-- C:\Radni\pra_rec_rm.pks
--
-- Generated for Oracle 10g on Fri Nov 29  08:41:39 2024 by Server Generator 6.5.96.5.6
 

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

/* pra_rec_rm */
FUNCTION SJ_KOR_NAZIV
 (SJ_ID_P IN T_GOSTI.SJ_ID%TYPE
 ,DATUM_P IN T_GOSTI.DAT_ODLASKA%TYPE
 )
 RETURN VARCHAR2;
PRAGMA RESTRICT_REFERENCES (SJ_KOR_NAZIV, WNDS, WNPS);
/* pra_rec_rm */
PROCEDURE IZRACUNAJ_TU18
 (SO_ID_P IN T_ZAKUP.SO_ID%TYPE
 ,DAT_POC_P IN T_ZAKUP.DAT_POC%TYPE
 ,DAT_ZAV_P IN T_ZAKUP.DAT_ZAV%TYPE
 );
/* pra_rec_rm */
FUNCTION USL_IMA_OBROKE
 (USL_ID_P IN S_USLUGE.ID%TYPE
 )
 RETURN NUMBER;
PRAGMA RESTRICT_REFERENCES (USL_IMA_OBROKE, WNDS, WNPS);
/* pra_rec_rm */
FUNCTION SAS_ZAV_ID
 (USL_ID_P IN S_USL_SAS.USL_ID%TYPE
 ,SAS_ID_P IN S_USL_SAS.SAS_ID%TYPE
 )
 RETURN s_sastojci.id%TYPE;
PRAGMA RESTRICT_REFERENCES (SAS_ZAV_ID, WNDS, WNPS);
/* pra_rec_rm */
PROCEDURE IZRACUNAJ_REC51207
 (SO_ID_P IN T_REZERVACIJE.SO_ID%TYPE
 ,DAT_POC_P IN T_REZ_USL.DAT_POC%TYPE
 ,DAT_ZAV_P IN T_REZ_USL.DAT_ZAV%TYPE
 );
/* pra_rec_rm */
FUNCTION BR_OSOBA_UGO
 (OZN_GRUPE_P IN NUMBER
 ,DATUM_P IN I_BOOKING.DATUM%TYPE
 ,SO_ID_P IN M_SO.ID%TYPE
 ,ID_GRUPE_P IN NUMBER
 ,OZN_RAZDOBLJA_P IN VARCHAR2
 ,ID_GRUPE_DODATNE_P IN M_MSEGMENTI.ID%TYPE
 )
 RETURN NUMBER;
PRAGMA RESTRICT_REFERENCES (BR_OSOBA_UGO, WNDS, WNPS);
/* pra_rec_rm */
FUNCTION KAPACITET
 (OZN_SP_P IN VARCHAR2
 ,OZN_JM_P IN VARCHAR2
 ,VUO_ID_P IN M_SO.VUO_ID%TYPE
 ,SO_ID_P IN M_SJ.SO_ID%TYPE
 ,VSJ_ID_P IN M_SJ.VSJ_ID%TYPE
 ,SSJ_ID_P IN S_VSJ.SSJ_ID%TYPE
 ,DAT_POC_P IN DATE
 ,DAT_ZAV_P IN DATE
 )
 RETURN NUMBER;
/* pra_rec_rm */
FUNCTION BROJ_REZ_SJ_BB
 (VSJ_ID_P IN T_REZ_VSJ.ID%TYPE
 )
 RETURN NUMBER;
PRAGMA RESTRICT_REFERENCES (BROJ_REZ_SJ_BB, WNDS, WNPS);
/* pra_rec_rm */
FUNCTION SJ_VIP
 (SJ_ID_P IN T_GOSTI.SJ_ID%TYPE
 ,DATUM_P IN T_GOSTI.DAT_ODLASKA%TYPE
 ,TIP_P IN VARCHAR2
 )
 RETURN VARCHAR2;
/* pra_rec_rm */
PROCEDURE PUNI_GLOB_REC5210_B
 (DAT_POC_P IN DATE
 ,DAT_ZAV_P IN DATE
 ,OJ_ID_P IN NUMBER
 ,SO_SIFRA1_P IN VARCHAR2
 ,SO_SIFRA2_P IN VARCHAR2
 );
/* pra_rec_rm */
PROCEDURE PUNI_GLOB_REC5210_N
 (DAT_POC_P IN DATE
 ,DAT_ZAV_P IN DATE
 ,OJ_ID_P IN NUMBER
 ,SO_SIFRA1_P IN VARCHAR2
 ,SO_SIFRA2_P IN VARCHAR2
 );
/* pra_rec_rm */
PROCEDURE PUNI_GLOB_REC5210_DOK_B
 (DAT_POC_P IN DATE
 ,DAT_ZAV_P IN DATE
 ,OJ_ID_P IN NUMBER
 ,SO_SIFRA1_P IN VARCHAR2
 ,SO_SIFRA2_P IN VARCHAR2
 ,VAPLDOK_ID_P NUMBER
 );
/* pra_rec_rm */
PROCEDURE PUNI_GLOB_REC5210_DOK_N
 (DAT_POC_P IN DATE
 ,DAT_ZAV_P IN DATE
 ,OJ_ID_P IN NUMBER
 ,SO_SIFRA1_P IN VARCHAR2
 ,SO_SIFRA2_P IN VARCHAR2
 ,VAPLDOK_ID_P NUMBER
 );
/* PRA_REC_RM */
FUNCTION IZN_PRIJENOSA_TRO_NZ
 (DATUM_P IN T_TROSKOVI.DAT_POC%TYPE
 ,IZN_PRIHODA_P IN t_troskovi.izn_prihoda%TYPE
 ,IZN_ODBITKA_POC_P IN t_troskovi.izn_odbitka_poc%type
 ,OBR_ZDANA_POC_P IN T_TROSKOVI.OBR_ZDANA%TYPE
 ,DAT_POC_P IN T_TROSKOVI.DAT_POC%TYPE
 ,DAT_ZAV_P IN T_TROSKOVI.DAT_ZAV%TYPE
 ,IZN_PRIHODA_PRVIDAN_P IN t_troskovi.izn_prihoda_prvidan%type
 ,USL_ID1_P IN t_troskovi.usl_id1%type
 ,DAT_POC1_P IN T_TROSKOVI.DAT_POC%TYPE
 ,DAT_ZAV1_P IN T_TROSKOVI.DAT_ZAV%TYPE
 ,OZN_PRIJENOSA_P IN VARCHAR2
 ,OZN_NZ_UZ_P IN VARCHAR2
 )
 RETURN NUMBER;
/* PRA_REC_RM */
FUNCTION IZN_PRIJENOSA_PDV_USL1_NZ
 (DATUM_P IN T_TROSKOVI.DAT_POC%TYPE
 ,IZN_PDV_POC1_P IN t_troskovi.izn_pdv_poc1%TYPE
 ,IZN_ODBITKA_PDV_POC1_P IN t_troskovi.izn_odbitka_pdv_poc%type
 ,OBR_ZDANA_POC_P IN T_TROSKOVI.OBR_ZDANA%TYPE
 ,DAT_POC_P IN T_TROSKOVI.DAT_POC%TYPE
 ,DAT_ZAV_P IN T_TROSKOVI.DAT_ZAV%TYPE
 ,IZN_PDV_PRVIDAN1_P IN t_troskovi.izn_pdv_prvidan1%type
 ,USL_ID1_P IN t_troskovi.usl_id1%type
 ,DAT_POC1_P IN T_TROSKOVI.DAT_POC%TYPE
 ,DAT_ZAV1_P IN T_TROSKOVI.DAT_ZAV%TYPE
 ,OZN_NZ_UZ_P IN VARCHAR2
 )
 RETURN NUMBER;
/* PRA_REC_RM */
FUNCTION IZN_PRIJENOSA_PDV_USL_NZ
 (DATUM_P IN T_TROSKOVI.DAT_POC%TYPE
 ,IZN_PDV_POC_P IN t_troskovi.izn_pdv_poc%TYPE
 ,IZN_ODBITKA_PDV_POC_P IN t_troskovi.izn_odbitka_pdv_poc%type
 ,OBR_ZDANA_POC_P IN T_TROSKOVI.OBR_ZDANA%TYPE
 ,DAT_POC_P IN T_TROSKOVI.DAT_POC%TYPE
 ,DAT_ZAV_P IN T_TROSKOVI.DAT_ZAV%TYPE
 ,IZN_PDV_PRVIDAN_P IN t_troskovi.izn_pdv_prvidan%type
 ,OZN_NZ_UZ_P IN VARCHAR2
 )
 RETURN NUMBER;
/* PRA_REC_RM */
FUNCTION IZN_DUGA_GOSTP
 (GOSTP_ID_P IN T_TROSKOVI.GOSTP_ID%TYPE
 ,GOST_ID_P IN T_TROSKOVI.GOST_ID%TYPE
 )
 RETURN NUMBER;
FUNCTION VSJ_RECARA_PON2
 (RECPON2_ID_P IN TREC_PON2_USL.RECPON2_ID%TYPE
 ,RECARA_ID_P IN TREC_PON2_USL.RECARA_ID%TYPE
 ,BR_UPUTNICE_P IN TREC_PON2_USL.BR_UPUTNICE%TYPE
 ,ISPIS_P IN NUMBER
 )
 RETURN NUMBER;
/* pra_rec_rm */
PROCEDURE IZRACUNAJ_BROJ_SASTOJAKA_1
 (SO_ID_P IN M_SO.ID%TYPE
 ,DATUM_P IN I_ZURNALI.DATUM%TYPE
 );
/* pra_rec_rm */
FUNCTION ZADNJI_BORAVAK_NAPOMENA
 (ID_P IN IREC_AGOST_BORAVCI.RECAGOST_ID%TYPE
 ,CENTAR_P IN NUMBER
 )
 RETURN NUMBER;
/* pra_rec_rm */
PROCEDURE REGISTRIRAJ_ISPIS_RAC
 (RAC_ID_P IN lpka_rac_ispisi.rac_id%TYPE
 ,RBR_P IN lpka_rac_ispisi.rbr%TYPE
 ,BR_KOPIJA_P IN lpka_rac_ispisi.br_kopija%TYPE
 ,BR_POREZNI_KUPCA_P IN lpka_rac_ispisi.br_porezni_kupca%TYPE
 ,OPIS_P IN lpka_rac_ispisi.opis%TYPE
 );
/* PLANIRANI_KAPACITETI za report REC5069 */
FUNCTION PLANIRANI_KAPACITETI
 (SO_P IN VARCHAR2
 ,RECSPOK_SIFRA_P IN VARCHAR2
 ,SVEUKUPNO_P IN NUMBER
 ,ID_P IN NUMBER
 ,DATUM_P IN VARCHAR2
 ,MJESEC_P IN VARCHAR2
 )
 RETURN NUMBER;
/* pra_rec_rm */
FUNCTION MS_NAZIV
 (RECORD_NUMBER_P IN NUMBER
 ,DATUM_P DATE
 )
 RETURN m_msegmenti.naziv%TYPE;
PRAGMA RESTRICT_REFERENCES (MS_NAZIV, WNDS, WNPS, RNPS);
/* pra_rec_rm */
FUNCTION MS_SIFRA
 (RECORD_NUMBER_P NUMBER
 ,DATUM_P DATE
 )
 RETURN m_msegmenti.sifra%TYPE;
PRAGMA RESTRICT_REFERENCES (MS_SIFRA, WNDS, WNPS, RNPS);
PROCEDURE PUNI_RECPON2_ODBICI_U
 (RECPON2_ID_P IN trec_ponude2.id%TYPE
 ,DOMJEZ_SIFRA_P IN s_jezici.sifra_3a%TYPE
 ,JEZ_SIFRA_P IN s_jezici.sifra_3a%TYPE
 );
/* PUNI_RECGLO_REC5512 */
PROCEDURE PUNI_RECGLO_REC5512
 (DAT_POC_P IN DATE
 ,DAT_ZAV_P DATE
 ,SO_ID_P M_SO.ID%TYPE
 ,STUPANJ_PRODAJE_P VARCHAR2
 );
END PRA_REC_RM;
/
SHOW ERROR