-- C:\Users\mmoscatello\Downloads\pra_pso_apex.pks
--
-- Generated for Oracle 10g on Thu Aug 22  14:52:59 2024 by Server Generator 6.5.96.5.6
 

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

FUNCTION VRATI_URL
 (LOK_ID_P IN MPSO_LOKACIJE.ID%TYPE
 )
 RETURN VARCHAR2;
PROCEDURE POSALJI_OBAVIJEST
 (ID_P IN NUMBER
 ,TEMA_P IN apex_t_varchar2
 ,PORUKA_P IN VARCHAR2
 ,BROJ_SOBE_P IN VARCHAR2 := null
 ,NAR_ID_P IN tpso_narudzbe.id%TYPE := null
 );
/* PUNI_COLL_GPRO */
PROCEDURE PUNI_COLL_GPRO
 (KASA_ID_P IN NUMBER
 ,NAC_ID_P IN NUMBER
 ,JEZIK_3A_P IN VARCHAR2
 );
FUNCTION R_PSO_ASO_KASE
 (KASA_ID_P IN NUMBER
 ,NAC_ID_P IN NUMBER
 ,JEZIK_3A_P IN VARCHAR2
 )
 RETURN SYS_REFCURSOR;
FUNCTION MIN_VRIJEME_ISPORUKE
 (LOK_ID_P IN NUMBER
 ,MIN_VRIJEME_ISPORUKE_P IN NUMBER
 ,VRIJEME_ISPORUKE_P IN VARCHAR2
 ,DATUM_VRIJEME_UNOSA_NARUDZBE_P IN DATE := SYSDATE
 )
 RETURN BOOLEAN;
FUNCTION RADNO_VRIJEME_LOKACIJE
 (LOK_ID_P IN NUMBER
 ,VRIJEME_P IN VARCHAR2 := NULL
 )
 RETURN BOOLEAN;
PROCEDURE AZURIRAJ_NARUDZBU
 (PRO_ID_P IN NUMBER
 ,KOLICINA_P IN NUMBER
 );
PROCEDURE PROVJERI_DATUM_PSO
 (LOK_ID_P IN MPSO_LOKACIJE.ID%TYPE
 );
END PRA_PSO_APEX;
/
SHOW ERROR