Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Package | Package MAGAZYN | Next Package |
Object Name | Overload | Argument Name | Position | Datatype | Direction |
---|---|---|---|---|---|
AKCEPTDOWOD | PN$ID_DOWODU | 1 | NUMBER | IN | |
AKCEPTDOWOD | PD$DATA_AKCEPT | 2 | DATE | IN | |
AKCEPTDOWOD | PC$OPER | 3 | VARCHAR2 | IN | |
AKCEPTUJFAKTURE | PN$FAK | 1 | NUMBER | IN | |
AKTUALIZUJFAKTUREVAT | P_ID_FAK | 1 | NUMBER | IN | |
AKTUALIZUJFAKTUREVAT | PB$WAR_FAK | 2 | PL/SQL BOOLEAN | IN | |
AUTOMATYCZNIEPRZYDZIELDOSTAWY | PN$POZ_WZ | 1 | NUMBER | IN | |
AUTOMATYCZNIEPRZYDZIELDOSTAWY | PN$NOWA_ILOSC | 2 | NUMBER | IN | |
AUTOMATYCZNIEPRZYDZIELDOSTAWY | <return value for function> | NUMBER | OUT | ||
CENA_NETTO_ND | P_NRKAT | 1 | NUMBER | IN | |
CENA_NETTO_ND | P_DATA | 2 | DATE | IN | |
CENA_NETTO_ND | <return value for function> | NUMBER | OUT | ||
CENAOSTATNIEGOPRZYJECIA | PN$NR_KATAL | 1 | NUMBER | IN | |
CENAOSTATNIEGOPRZYJECIA | <return value for function> | NUMBER | OUT | ||
CENA_PO_KOR | P_ID_DOW | 1 | NUMBER | IN | |
CENA_PO_KOR | P_NR_KATAL | 2 | NUMBER | IN | |
CENA_PO_KOR | P_CENA | 3 | NUMBER | IN | |
CENA_PO_KOR | P_DATA_DO | 4 | DATE | IN | |
CENA_PO_KOR | P_CO | 5 | VARCHAR2 | IN | |
CENA_PO_KOR | <return value for function> | NUMBER | OUT | ||
CENA_PO_KOR2 | P_ID_POZ | 1 | NUMBER | IN | |
CENA_PO_KOR2 | P_CENA | 2 | NUMBER | IN | |
CENA_PO_KOR2 | P_DATA_DO | 3 | DATE | IN | |
CENA_PO_KOR2 | <return value for function> | NUMBER | OUT | ||
CZJESTOTWARTYDOWOD | PN$MAGAZYN | 1 | NUMBER | IN | |
CZJESTOTWARTYDOWOD | <return value for function> | NUMBER | OUT | ||
CZYFAKTURAWBUFORZE | PN$FAK | 1 | NUMBER | IN | |
CZYFAKTURAWBUFORZE | <return value for function> | CHAR | OUT | ||
DAJ_KOLEJNY_NUMER_MAG_ZAKUP | P_ROK | 1 | NUMBER | IN | |
DAJ_KOLEJNY_NUMER_MAG_ZAKUP | <return value for function> | NUMBER | OUT | ||
GENERUJDOWOD | PN$NRMAG | 1 | NUMBER | IN | |
GENERUJDOWOD | PN$NRMAGDOC | 2 | NUMBER | IN | |
GENERUJDOWOD | PC$DOWOD | 3 | VARCHAR2 | IN | |
GENERUJDOWOD | PD$DATA | 4 | DATE | IN | |
GENERUJDOWOD | PN$NRKONTR | 5 | NUMBER | IN | |
GENERUJDOWOD | <return value for function> | NUMBER | OUT | ||
GENERUJGLOWKEFAKTURY | PN$KONTR | 1 | NUMBER | IN | |
GENERUJGLOWKEFAKTURY | PD$TERMIN | 2 | DATE | IN | |
GENERUJGLOWKEFAKTURY | PC$REJESTR | 3 | VARCHAR2 | IN | |
GENERUJGLOWKEFAKTURY | PN$PLATNOSC | 4 | NUMBER | IN | |
GENERUJGLOWKEFAKTURY | OC$NUMER | 5 | VARCHAR2 | OUT | |
GENERUJGLOWKEFAKTURY | <return value for function> | NUMBER | OUT | ||
GENERUJ_NR_DOK | P_MASKA | 1 | VARCHAR2 | IN | |
GENERUJ_NR_DOK | P_NR_KONTR | 2 | BINARY_INTEGER | IN | |
GENERUJ_NR_DOK | P_NR_DOK | 3 | BINARY_INTEGER | IN | |
GENERUJ_NR_DOK | P_DATA_DOK | 4 | DATE | IN | |
GENERUJ_NR_DOK | P_NR_RATY | 5 | BINARY_INTEGER | IN | |
GENERUJ_NR_DOK | <return value for function> | VARCHAR2 | OUT | ||
GENERUJPOZYCJEINWE | PN$ID_INWE | 1 | NUMBER | IN | |
GENERUJPOZYCJEINWE | PD$DATA | 2 | DATE | IN | |
GENERUJPOZYCJEINWE | PN$NRKONTR | 3 | NUMBER | IN | |
GENERUJPOZYCJEINWE | PN$ID_DOW_P | 4 | NUMBER | OUT | |
GENERUJPOZYCJEINWE | PN$ID_DOW_R | 5 | NUMBER | OUT | |
GENERUJPOZYCJEINWE | <return value for function> | NUMBER | OUT | ||
GET_DEFAULT_NR_KATAL | P_NR_GR_TOW | 1 | NUMBER | IN | |
GET_DEFAULT_NR_KATAL | <return value for function> | NUMBER | OUT | ||
GET_G_P_DATA_V_MAG_AKTY_ZAPASY | <return value for function> | DATE | OUT | ||
GET_TYP_TOWARU | P_NR_KATAL | 1 | NUMBER | IN | |
GET_TYP_TOWARU | <return value for function> | CHAR | OUT | ||
ILOSC_PO_KOR | P_ID_DOW | 1 | NUMBER | IN | |
ILOSC_PO_KOR | P_ID_POZ | 2 | NUMBER | IN | |
ILOSC_PO_KOR | P_NR_KATAL | 3 | NUMBER | IN | |
ILOSC_PO_KOR | P_ILOSC | 4 | NUMBER | IN | |
ILOSC_PO_KOR | P_DATA_DO | 5 | DATE | IN | |
ILOSC_PO_KOR | <return value for function> | NUMBER | OUT | ||
ILOSCREZERWACJITOWARU | PN$NR_KATAL | 1 | NUMBER | IN | |
ILOSCREZERWACJITOWARU | PN$NRMAG | 2 | NUMBER | IN | |
ILOSCREZERWACJITOWARU | PD$NADZIEN | 3 | DATE | IN | |
ILOSCREZERWACJITOWARU | <return value for function> | NUMBER | OUT | ||
INWE_CALOSC | PN$MAGAZYN | 1 | NUMBER | IN | |
INWE_CALOSC | <return value for function> | NUMBER | OUT | ||
INWE_CZESC | PN$MAGAZYN | 1 | NUMBER | IN | |
INWE_CZESC | <return value for function> | NUMBER | OUT | ||
INWE_DOWOD | PN$IDDOWODU | 1 | NUMBER | IN | |
INWE_DOWOD | <return value for function> | NUMBER | OUT | ||
INWE_NRKATAL | PN$NRKATAL | 1 | NUMBER | IN | |
INWE_NRKATAL | PN$MAGAZYN | 2 | NUMBER | IN | |
INWE_NRKATAL | <return value for function> | NUMBER | OUT | ||
KOPIUJDOWOD | PN$IDDOWODU | 1 | NUMBER | IN | |
KOPIUJDOWOD | PC$DOWOD | 2 | VARCHAR2 | IN | |
KOPIUJDOWOD | <return value for function> | NUMBER | OUT | ||
LIMIT_CZYPRZEKROCZONO | PN$KONTR | 1 | NUMBER | IN | |
LIMIT_CZYPRZEKROCZONO | <return value for function> | PL/SQL BOOLEAN | OUT | ||
LIMIT_POBIERZSALDO | PN$KONTR | 1 | NUMBER | IN | |
LIMIT_POBIERZSALDO | <return value for function> | NUMBER | OUT | ||
MAGAZYN_USLUG_DOMYSLNY | <return value for function> | NUMBER | OUT | ||
NAZWA | PN$NR_KATAL | 1 | NUMBER | IN/OUT | |
NAZWA | PN$MAGAZYN | 2 | NUMBER | IN/OUT | |
NAZWA | PN$ID_POZ_WZ | 3 | NUMBER | IN/OUT | |
NAZWA | R$OUT | 4 | REF CURSOR | IN/OUT | |
NAZWA_GRP | P_KODG | 1 | NUMBER | IN | |
NAZWA_GRP | <return value for function> | VARCHAR2 | OUT | ||
NAZWA_KIT | NRU | 1 | NUMBER | IN | |
NAZWA_KIT | <return value for function> | VARCHAR2 | OUT | ||
POBIERZCENE | PN$KONTR | 1 | NUMBER | IN | |
POBIERZCENE | PN$KATAL | 2 | NUMBER | IN | |
POBIERZCENE | <return value for function> | NUMBER | OUT | ||
POBIERZNAGLOWEKFAKTURY | PN$KONTR | 1 | NUMBER | IN | |
POBIERZNAGLOWEKFAKTURY | OC$NUMER | 2 | VARCHAR2 | OUT | |
POBIERZNAGLOWEKFAKTURY | PC$REJESTR | 3 | VARCHAR2 | IN | |
POBIERZNAGLOWEKFAKTURY | PC$TYPFAK | 4 | CHAR | IN | |
POBIERZNAGLOWEKFAKTURY | P_DAWPL | 5 | DATE | IN | |
POBIERZNAGLOWEKFAKTURY | P_ID_FAK | 6 | NUMBER | IN | |
POBIERZNAGLOWEKFAKTURY | <return value for function> | VARCHAR2 | OUT | ||
POBIERZNAGLOWEKFAKTURYTRANS | PN$KONTR | 1 | NUMBER | IN | |
POBIERZNAGLOWEKFAKTURYTRANS | OC$NUMER | 2 | VARCHAR2 | OUT | |
POBIERZNAGLOWEKFAKTURYTRANS | PC$REJESTR | 3 | VARCHAR2 | IN | |
POBIERZNAGLOWEKFAKTURYTRANS | PC$TYPFAK | 4 | CHAR | IN | |
POBIERZNAGLOWEKFAKTURYTRANS | P_DAWPL | 5 | DATE | IN | |
POBIERZNAGLOWEKFAKTURYTRANS | P_W_TRANSAKCJI | 6 | PL/SQL BOOLEAN | IN | |
POBIERZNAGLOWEKFAKTURYTRANS | P_ID_FAK | 7 | NUMBER | IN | |
POBIERZNAGLOWEKFAKTURYTRANS | <return value for function> | VARCHAR2 | OUT | ||
POBIERZTERMIN | PN$KONTR | 1 | NUMBER | IN | |
POBIERZTERMIN | <return value for function> | DATE | OUT | ||
PODAJ_SKROT_JM | P_KOD_JM | 1 | NUMBER | IN | |
PODAJ_SKROT_JM | <return value for function> | VARCHAR2 | OUT | ||
SALDOOPAKOWANKONTR | PN$KONTR | 1 | NUMBER | IN | |
SALDOOPAKOWANKONTR | PN$NR_KATAL | 2 | NUMBER | IN | |
SALDOOPAKOWANKONTR | <return value for function> | NUMBER | OUT | ||
SET_G_P_DATA_V_MAG_AKTY_ZAPASY | P_VAL | 1 | DATE | IN | |
STAN_MAGAZYNU | P_NR_KATAL | 1 | NUMBER | IN | |
STAN_MAGAZYNU | P_ID_MAG | 2 | NUMBER | IN | |
STAN_MAGAZYNU | <return value for function> | NUMBER | OUT | ||
USUNFAKTURE | P_FAK | 1 | NUMBER | IN | |
USUNFAKTURE | P_OPIS | 2 | VARCHAR2 | IN | |
USUNFAKTURE | <return value for function> | NUMBER | OUT | ||
WARTOSC_NETTO_POZYCJI | P_ILOSC | 1 | NUMBER | IN | |
WARTOSC_NETTO_POZYCJI | P_CENA | 2 | NUMBER | IN | |
WARTOSC_NETTO_POZYCJI | P_RABAT | 3 | NUMBER | IN | |
WARTOSC_NETTO_POZYCJI | <return value for function> | NUMBER | OUT | ||
WARTOSC_TOWARU | PN$NRKATAL | 1 | NUMBER | IN | |
WARTOSC_TOWARU | PN$MAGAZYN | 2 | NUMBER | IN | |
WARTOSC_TOWARU | PN$STANILE | 3 | NUMBER | IN | |
WARTOSC_TOWARU | <return value for function> | NUMBER | OUT | ||
WARTOSC_VAT_POZYCJI | P_ILOSC | 1 | NUMBER | IN | |
WARTOSC_VAT_POZYCJI | P_CENA | 2 | NUMBER | IN | |
WARTOSC_VAT_POZYCJI | P_RABAT | 3 | NUMBER | IN | |
WARTOSC_VAT_POZYCJI | P_PR_VAT | 4 | NUMBER | IN | |
WARTOSC_VAT_POZYCJI | <return value for function> | NUMBER | OUT | ||
WARTZAKNET | IDWZ | 1 | NUMBER | IN | |
WARTZAKNET | PD$NA_DZIEN | 2 | DATE | IN | |
WARTZAKNET | <return value for function> | NUMBER | OUT | ||
WARTZAKNET_POZYCJA | IDWZ | 1 | NUMBER | IN | |
WARTZAKNET_POZYCJA | IDPOZ | 2 | NUMBER | IN | |
WARTZAKNET_POZYCJA | PD$NA_DZIEN | 3 | DATE | IN | |
WARTZAKNET_POZYCJA | <return value for function> | NUMBER | OUT | ||
WYDANO_ND | P_IDPOZ | 1 | NUMBER | IN | |
WYDANO_ND | P_DATA | 2 | DATE | IN | |
WYDANO_ND | <return value for function> | NUMBER | OUT | ||
WYSTAWFAKTUREZDOWODOW | PC$LISTADOWODOW | 1 | VARCHAR2 | IN | |
WYSTAWFAKTUREZDOWODOW | PN$KONTR | 2 | NUMBER | IN | |
WYSTAWFAKTUREZDOWODOW | PD$TERMIN | 3 | DATE | IN | |
WYSTAWFAKTUREZDOWODOW | PC$REJESTR | 4 | VARCHAR2 | IN | |
WYSTAWFAKTUREZDOWODOW | PN$PLATNOSC | 5 | NUMBER | IN | |
WYSTAWFAKTUREZDOWODOW | PN$SESJA | 6 | NUMBER | IN | |
WYSTAWFAKTUREZDOWODOW | PC$BUFOR | 7 | CHAR | IN | |
WYSTAWFAKTUREZDOWODOW | P_LISTAZALICZKOWYCH | 8 | VARCHAR2 | IN | |
WYSTAWFAKTUREZDOWODOW | <return value for function> | NUMBER | OUT | ||
ZBIORCZA_KOREKTA_WZ | P_NR_KONTR | 1 | NUMBER | IN | |
ZBIORCZA_KOREKTA_WZ | P_NR_KATAL | 2 | NUMBER | IN | |
ZBIORCZA_KOREKTA_WZ | P_ILOSC_ZWROTU | 3 | NUMBER | IN | |
ZESTAWIENIEDOK | PR$ZESTDOK | 1 | REF CURSOR | IN/OUT | |
ZESTAWIENIEDOK | PN$NRMAG | 2 | NUMBER | IN | |
ZESTAWIENIEDOK | PN$NRKATAL | 3 | NUMBER | IN | |
ZESTAWIENIEDOK | PD$DATAOD | 4 | DATE | IN | |
ZESTAWIENIEDOK | PD$DATADO | 5 | DATE | IN | |
ZESTAWIENIEDOK | PC$SZCZEGOLY | 6 | CHAR | IN |