Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Package | Package RAPORTY | Next Package |
Object Name | Overload | Argument Name | Position | Datatype | Direction |
---|---|---|---|---|---|
ADRES_KONTRAH | NR_KON | 1 | NUMBER | IN | |
ADRES_KONTRAH | <return value for function> | VARCHAR2 | OUT | ||
ADRES_POSESJI | P_ID_POSESJI | 1 | VARCHAR2 | IN | |
ADRES_POSESJI | <return value for function> | VARCHAR2 | OUT | ||
ADRESY_POSESJI_FAKTURY | P_ID_FAK | 1 | NUMBER | IN | |
ADRESY_POSESJI_FAKTURY | <return value for function> | VARCHAR2 | OUT | ||
DAJ_ID_TABELI_UNIWERSALNEJ | P_KOD_TABELI | 1 | VARCHAR2 | IN | |
DAJ_ID_TABELI_UNIWERSALNEJ | P_USER | 2 | VARCHAR2 | IN | |
DAJ_ID_TABELI_UNIWERSALNEJ | P_CZAS | 3 | DATE | IN | |
DAJ_ID_TABELI_UNIWERSALNEJ | <return value for function> | NUMBER | OUT | ||
DEHASZUJ_CIAG | P_WHERE | 1 | VARCHAR2 | IN | |
DEHASZUJ_CIAG | <return value for function> | VARCHAR2 | OUT | ||
DUPLIKAT_WEZWANIA | PP_IDSESJI | 1 | NUMBER | IN | |
DUPLIKAT_WEZWANIA | PP_ILEDNI | 2 | NUMBER | IN | |
DUPLIKAT_WEZWANIA | PP_PROFORMY | 3 | VARCHAR2 | IN | |
DUPLIKAT_WEZWANIA | PP_TERMIN | 4 | DATE | IN | |
DUPLIKAT_WEZWANIA | P_TYP_DOK | 5 | VARCHAR2 | IN | |
DUPLIKAT_WEZWANIA | P_MIASTO_WEZWANIA | 6 | VARCHAR2 | IN | |
DUPLIKAT_WEZWANIA | P_ID_WYDRUKU | 7 | NUMBER | IN | |
FORMATUJ_NR_KONTA | P_NR_RACH | 1 | VARCHAR2 | IN | |
FORMATUJ_NR_KONTA | P_FORMAT | 2 | VARCHAR2 | IN | |
FORMATUJ_NR_KONTA | <return value for function> | VARCHAR2 | OUT | ||
GENERUJ_RAPORT_EXCEL | P_ID_RAPORTU | 1 | NUMBER | IN | |
GENERUJ_RAPORT_EXCEL | <return value for function> | BLOB | OUT | ||
GENERUJ_RAPORT_PDF | P_ID_RAPORTU | 1 | NUMBER | IN | |
GENERUJ_RAPORT_PDF | <return value for function> | BLOB | OUT | ||
GENERUJ_RAPORT_USLUGI_PRZYPIS | P_NR_KONTR | 1 | NUMBER | IN | |
GENERUJ_RAPORT_USLUGI_PRZYPIS | P_DATA_OD | 2 | DATE | IN | |
GENERUJ_RAPORT_USLUGI_PRZYPIS | P_DATA_DO | 3 | DATE | IN | |
GEN_RAP_ROZN_DEKL_LODZ | P_ID_STANU_A | 1 | NUMBER | IN | |
GEN_RAP_ROZN_DEKL_LODZ | P_ID_STANU_B | 2 | NUMBER | IN | |
GEN_RAP_STAN_DEKL_LODZ | P_ID_STANU | 1 | NUMBER | IN | |
HASZUJ_CIAG | P_WHERE | 1 | VARCHAR2 | IN | |
HASZUJ_CIAG | <return value for function> | VARCHAR2 | OUT | ||
ID_POSESJI_FAKTURY | P_ID_FAK | 1 | NUMBER | IN | |
ID_POSESJI_FAKTURY | <return value for function> | VARCHAR2 | OUT | ||
ILOSC_PJM | P_NR_KATAL | 1 | NUMBER | IN | |
ILOSC_PJM | P_ILOSC | 2 | NUMBER | IN | |
ILOSC_PJM | <return value for function> | NUMBER | OUT | ||
KOD_KRESKOWY | P_NUMER | 1 | NUMBER | IN | |
KOD_KRESKOWY | <return value for function> | NUMBER | OUT | ||
KONTAKTG | P_NR_KONTR | 1 | NUMBER | IN | |
KONTAKTG | <return value for function> | VARCHAR2 | OUT | ||
KWOTAS | P_ID_FAK | 1 | NUMBER | IN | |
KWOTAS | P_ST_VAT | 2 | NUMBER | IN | |
KWOTAS | P_RODZAJ | 3 | VARCHAR2 | IN | |
KWOTAS | P_ROD_KON | 4 | VARCHAR2 | IN | |
KWOTAS | P_RODZ_ZAKSPR | 5 | VARCHAR2 | IN | |
KWOTAS | P_KOD_ST_VAT | 6 | VARCHAR2 | IN | |
KWOTAS | P_CZY_WART_WAL | 7 | VARCHAR2 | IN | |
KWOTAS | <return value for function> | NUMBER | OUT | ||
KWOTAZ | P_ID_FAK | 1 | NUMBER | IN | |
KWOTAZ | P_ST_VAT | 2 | NUMBER | IN | |
KWOTAZ | P_RODZAJ | 3 | VARCHAR2 | IN | |
KWOTAZ | P_TYP_VAT | 4 | VARCHAR2 | IN | |
KWOTAZ | <return value for function> | NUMBER | OUT | ||
MIASTO | P_ID_MSC | 1 | NUMBER | IN | |
MIASTO | <return value for function> | VARCHAR2 | OUT | ||
NAZWA_DZIELNICY | P_ID_DZ | 1 | NUMBER | IN | |
NAZWA_DZIELNICY | <return value for function> | VARCHAR2 | OUT | ||
NAZWA_GRP | P_GRP_TOW | 1 | NUMBER | IN | |
NAZWA_GRP | <return value for function> | VARCHAR2 | OUT | ||
NAZWA_KIT | P_NR_KATAL | 1 | NUMBER | IN | |
NAZWA_KIT | <return value for function> | VARCHAR2 | OUT | ||
NAZWAKKDO | P_NR_KONTR | 1 | NUMBER | IN | |
NAZWAKKDO | <return value for function> | VARCHAR2 | OUT | ||
NAZWA_KONTRAH | NR_KON | 1 | NUMBER | IN | |
NAZWA_KONTRAH | <return value for function> | VARCHAR2 | OUT | ||
NAZWA_MAG | NR_MAG | 1 | NUMBER | IN | |
NAZWA_MAG | <return value for function> | VARCHAR2 | OUT | ||
NAZWA_TOWARU | P_ID_POZ | 1 | NUMBER | IN | |
NAZWA_TOWARU | <return value for function> | VARCHAR2 | OUT | ||
NUMER_POSTANOWIENIA | P_NR_KONTR | 1 | NUMBER | IN | |
NUMER_POSTANOWIENIA | <return value for function> | VARCHAR2 | OUT | ||
OBROTY_SP | P_OD | 1 | DATE | IN | |
OBROTY_SP | P_DO | 2 | DATE | IN | |
OBROTY_SP | P_SORT | 3 | CHAR | IN | |
OBROTY_SP | P_REJESTR | 4 | CHAR | IN | |
OBROTY_SP | <return value for function> | REF CURSOR | OUT | ||
OBROTY_SP_SUM | P_OD | 1 | DATE | IN | |
OBROTY_SP_SUM | P_DO | 2 | DATE | IN | |
OBROTY_SP_SUM | P_SORT | 3 | CHAR | IN | |
OBROTY_SP_SUM | P_REJESTR | 4 | CHAR | IN | |
OBROTY_SP_SUM | <return value for function> | REF CURSOR | OUT | ||
OKRES_FAKTURY | P_ID_FAK | 1 | NUMBER | IN | |
OKRES_FAKTURY | P_JAKA_DATA | 2 | VARCHAR2 | IN | |
OKRES_FAKTURY | <return value for function> | VARCHAR2 | OUT | ||
OPIS_TYPKONTR | P_TYP_KONTR | 1 | VARCHAR2 | IN | |
OPIS_TYPKONTR | <return value for function> | VARCHAR2 | OUT | ||
PARAMFORM | P_NAZWA_RAPORTU | 1 | VARCHAR2 | IN | |
PARAMFORM | <return value for function> | VARCHAR2 | OUT | ||
PODAJ_SKROT_JM | P_JM | 1 | NUMBER | IN | |
PODAJ_SKROT_JM | <return value for function> | VARCHAR2 | OUT | ||
PODZIAL_PRZEDS_LUDNOSC | P_TYP_KONTR | 1 | VARCHAR2 | IN | |
PODZIAL_PRZEDS_LUDNOSC | <return value for function> | VARCHAR2 | OUT | ||
POZYCJE_ZOZSO | P_NR_KONTR | 1 | NUMBER | IN | |
POZYCJE_ZOZSO | P_ID_POSESJI | 2 | VARCHAR2 | IN | |
POZYCJE_ZOZSO | P_TYP_SEKCJI | 3 | VARCHAR2 | IN | |
POZYCJE_ZOZSO | P_MIESIAC_PISMA | 4 | DATE | IN | |
POZYCJE_ZOZSO | P_USL_PISMA_ID | 5 | NUMBER | IN | |
POZYCJE_ZOZSO | P_USL_TMP_DRUKI_SL_TABELE_ID | 6 | NUMBER | IN | |
POZYCJE_ZOZSO | <return value for function> | NUMBER | OUT | ||
RACHUNEK_SP | P_NR_KONTR | 1 | NUMBER | IN | |
RACHUNEK_SP | P_KRAJ | 2 | CHAR | IN | |
RACHUNEK_SP | P_FORMAT_ZWROTU | 3 | CHAR | IN | |
RACHUNEK_SP | P_NA_DZIEN | 4 | DATE | IN | |
RACHUNEK_SP | <return value for function> | VARCHAR2 | OUT | ||
RACHUNEK_SP_PRZYSZLY | P_NR_KONTR | 1 | NUMBER | IN | |
RACHUNEK_SP_PRZYSZLY | P_FORMAT_ZWROTU | 2 | CHAR | IN | |
RACHUNEK_SP_PRZYSZLY | P_NA_DZIEN | 3 | DATE | IN | |
RACHUNEK_SP_PRZYSZLY | P_NR_RACHUNKU_PRZYSZLY | 4 | CHAR | IN | |
RACHUNEK_SP_PRZYSZLY | <return value for function> | VARCHAR2 | OUT | ||
RACHUNEK_SP_PRZYSZLY_REC | P_NR_KONTR | 1 | NUMBER | IN | |
RACHUNEK_SP_PRZYSZLY_REC | P_FORMAT_ZWROTU | 2 | CHAR | IN | |
RACHUNEK_SP_PRZYSZLY_REC | P_NA_DZIEN | 3 | DATE | IN | |
RACHUNEK_SP_PRZYSZLY_REC | P_NR_RACHUNKU_PRZYSZLY | 4 | CHAR | IN | |
RACHUNEK_SP_PRZYSZLY_REC | <return value for function> | OBJECT | OUT | ||
RACHUNEK_SP_REC | P_NR_KONTR | 1 | NUMBER | IN | |
RACHUNEK_SP_REC | P_KRAJ | 2 | CHAR | IN | |
RACHUNEK_SP_REC | P_FORMAT_ZWROTU | 3 | CHAR | IN | |
RACHUNEK_SP_REC | P_NA_DZIEN | 4 | DATE | IN | |
RACHUNEK_SP_REC | <return value for function> | OBJECT | OUT | ||
SLOWNIE | P_LICZBA | 1 | NUMBER | IN | |
SLOWNIE | P_WALUTA | 2 | VARCHAR2 | IN | |
SLOWNIE | <return value for function> | VARCHAR2 | OUT | ||
SLOWNIE_ZL | P_LICZBA | 1 | NUMBER | IN | |
SLOWNIE_ZL | <return value for function> | VARCHAR2 | OUT | ||
SPELL | P_SETKI | 1 | NUMBER | IN | |
SPELL | P_DZIESIATKI | 2 | NUMBER | IN | |
SPELL | P_JEDNOSTKI | 3 | NUMBER | IN | |
SPELL | <return value for function> | VARCHAR2 | OUT | ||
SUMA_KONTROLNA_IBAN | P_NUMER | 1 | VARCHAR2 | IN | |
SUMA_KONTROLNA_IBAN | <return value for function> | VARCHAR2 | OUT | ||
TEKST | P_TYP | 1 | VARCHAR2 | IN | |
TEKST | <return value for function> | VARCHAR2 | OUT | ||
TYP_KLIENTA | TYP_KLIENTA | 1 | VARCHAR2 | IN | |
TYP_KLIENTA | <return value for function> | VARCHAR2 | OUT | ||
TYP_KONTR | KOD_KLIENTA | 1 | NUMBER | IN | |
TYP_KONTR | <return value for function> | VARCHAR2 | OUT | ||
ULICA | P_ID_UL | 1 | NUMBER | IN | |
ULICA | <return value for function> | VARCHAR2 | OUT | ||
USUN_RAPORT_EXCEL | P_NAZWA | 1 | VARCHAR2 | IN | |
USUN_UKRYTEWEZWANIA | P_ID_WYDRUKU | 1 | NUMBER | IN | |
USUN_UKRYTEWEZWANIA | P_NR_KONTR | 2 | NUMBER | IN | |
UWAGI_DO_FAKTURY | P_ID_FAK | 1 | NUMBER | IN | |
UWAGI_DO_FAKTURY | <return value for function> | VARCHAR2 | OUT | ||
UWAGI_DO_PROFORMY | P_ID_PROFORMY | 1 | NUMBER | IN | |
UWAGI_DO_PROFORMY | <return value for function> | VARCHAR2 | OUT | ||
UWAGIKDO | P_NR_KONTR | 1 | NUMBER | IN | |
UWAGIKDO | <return value for function> | VARCHAR2 | OUT | ||
WALUTA_ODMIANA | P_WALUTA | 1 | VARCHAR2 | IN | |
WALUTA_ODMIANA | P_CALOSCI | 2 | VARCHAR2 | IN | |
WALUTA_ODMIANA | P_ODM | 3 | NUMBER | IN | |
WALUTA_ODMIANA | <return value for function> | VARCHAR2 | OUT | ||
WAR_GODZ_PRZEP | 1 | WYK_DATA | 1 | DATE | IN |
WAR_GODZ_PRZEP | 1 | WYK_ID_PRACY | 2 | NUMBER | IN |
WAR_GODZ_PRZEP | 1 | WYK_RODZ_CZASU | 3 | NUMBER | IN |
WAR_GODZ_PRZEP | 1 | <return value for function> | NUMBER | OUT | |
WAR_GODZ_PRZEP | 2 | DATA_OD | 1 | DATE | IN |
WAR_GODZ_PRZEP | 2 | DATA_DO | 2 | DATE | IN |
WAR_GODZ_PRZEP | 2 | WYK_ID_PRACY | 3 | NUMBER | IN |
WAR_GODZ_PRZEP | 2 | WYK_RODZ_CZASU | 4 | NUMBER | IN |
WAR_GODZ_PRZEP | 2 | <return value for function> | NUMBER | OUT | |
WAR_GODZ_PRZEP | 3 | DATA_PRACY | 1 | DATE | IN |
WAR_GODZ_PRZEP | 3 | WYK_ID_PRACY | 2 | NUMBER | IN |
WAR_GODZ_PRZEP | 3 | <return value for function> | NUMBER | OUT | |
WAR_GODZ_PRZEP_PWU | WYK_DATA | 1 | DATE | IN | |
WAR_GODZ_PRZEP_PWU | WYK_ID_PRACY | 2 | NUMBER | IN | |
WAR_GODZ_PRZEP_PWU | ID_RODZAJ_PRACY | 3 | NUMBER | IN | |
WAR_GODZ_PRZEP_PWU | P_ID_PWU | 4 | NUMBER | IN | |
WAR_GODZ_PRZEP_PWU | <return value for function> | NUMBER | OUT | ||
WSTAW_NIELAMLIWE_SPACJE | P_TEKST | 1 | VARCHAR2 | IN | |
WSTAW_NIELAMLIWE_SPACJE | P_DLUGOSC_WYRAZU | 2 | BINARY_INTEGER | IN | |
WSTAW_NIELAMLIWE_SPACJE | <return value for function> | VARCHAR2 | OUT | ||
WYDRUK_STOPKA | P_DATA | 1 | DATE | IN | |
WYDRUK_STOPKA | <return value for function> | VARCHAR2 | OUT | ||
ZAPLATY | P_ID_FAK | 1 | NUMBER | IN | |
ZAPLATY | <return value for function> | VARCHAR2 | OUT | ||
ZWLOKA_UW | <return value for function> | NUMBER | OUT | ||
ZWROC_DRZEWO_Z_GRUPAMI_RAP | P_ID_RODZICA | 1 | NUMBER | IN | |
ZWROC_DRZEWO_Z_GRUPAMI_RAP | P_ID_GRUPY | 2 | NUMBER | IN | |
ZWROC_DRZEWO_Z_GRUPAMI_RAP | <return value for function> | TABLE | OUT |