-- C:\Radni\pra_pka_csv.pks
--
-- Generated for Oracle 10g on Fri Dec 06  09:42:04 2024 by Server Generator 6.5.96.5.6
 

PROMPT Creating Package 'PRA_PKA_CSV'
CREATE OR REPLACE PACKAGE PRA_PKA_CSV IS

/* IZRADI_CSV_DATOTEKU */
PROCEDURE IZRADI_CSV_DATOTEKU
 (METMODSTRD_ID_P TMET_MOD_VRIR.METMODSTRD_ID%TYPE
 ,METMOD_SIFRA_P SMET_MODULI.SIFRA%TYPE
 ,ODREDISTE_P TMET_MOD_SETR.ODREDISTE%TYPE
 ,NACIN_P TMET_MOD_SETR.NACIN%TYPE
 ,NAZIV_P IN TMET_MOD_SET.NAZIV%TYPE
 );
/* IZRADI_REC5510_CSV */
PROCEDURE IZRADI_REC5510_CSV
 (METMODSTRD_ID_P TMET_MOD_VRIR.METMODSTRD_ID%TYPE
 ,PKACLOB_ID_P OUT NUMBER
 );
/* IZRADI_REC5510_CSV2 */
PROCEDURE IZRADI_REC5510_CSV2
 (DAT_POC_P DATE
 ,DAT_ZAV_P DATE
 ,SO_ID_P M_SO.ID%TYPE
 ,VSJ_ID_P S_VSJ.ID%TYPE
 ,MS_ID_P M_MSEGMENTI.ID%TYPE
 ,VMS_ID_P M_MSEGMENTI.VMS_ID%TYPE
 ,GMS_ID_P M_MSEGMENTI.ZMPGMS_ID%TYPE
 ,STUPANJ_PRODAJE_P VARCHAR2
 ,PKACLOB_ID_P OUT NUMBER
 );
/* IZRADI_REC5520_CSV */
PROCEDURE IZRADI_REC5520_CSV
 (METMODSTRD_ID_P IN TMET_MOD_VRIR.METMODSTRD_ID%TYPE
 ,PKACLOB_ID_P OUT NUMBER
 );
/* IZRADI_REC5520_CSV2 */
PROCEDURE IZRADI_REC5520_CSV2
 (DAT_POC_P IN DATE
 ,DAT_ZAV_P IN DATE
 ,SO_ID_P IN M_SO.ID%TYPE
 ,STUPANJ_PRODAJE_P IN VARCHAR2
 ,PKACLOB_ID_P OUT NUMBER
 );
/* OBRISI_LPKA_CLOB */
PROCEDURE OBRISI_LPKA_CLOB
 (PKACLOB_ID_P LPKA_CLOB.ID%TYPE
 );
END PRA_PKA_CSV;
/
SHOW ERROR