1 PACKAGE IGS_EN_GEN_001 as
2 /* $Header: IGSEN01S.pls 120.0 2005/06/02 03:40:57 appldev noship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --kkillams 24-04-2003 New parameter p_uoo_id is added to the Enrp_Del_Sua_Trnsfr,
7 -- Enrp_Del_Sua_Sut and Enrp_Del_Suao_Discon procedures
8 -- w.r.t. bug number 2829262
9 -------------------------------------------------------------------------------------------
10
11 Function Check_HRMS_Installed
12 RETURN VARCHAR2;
13 PRAGMA RESTRICT_REFERENCES(Check_HRMS_Installed, WNDS,WNPS);
14
15 PROCEDURE Enrp_Clc_Crrnt_Acad(
16 p_cal_type IN VARCHAR2 ,
17 p_effective_dt IN DATE ,
18 p_sequence_number OUT NOCOPY NUMBER );
19
20 PROCEDURE Enrp_Clc_Sca_Acad(
21 p_person_id IN NUMBER ,
22 p_course_cd IN VARCHAR2 ,
23 p_effective_dt IN DATE ,
24 p_cal_type OUT NOCOPY VARCHAR2 ,
25 p_sequence_number OUT NOCOPY NUMBER );
26
27 FUNCTION Enrp_Clc_Sca_Pass_Cp(
28 p_person_id IN NUMBER ,
29 p_course_cd IN VARCHAR2 ,
30 p_effective_dt IN DATE )
31 RETURN NUMBER;
32 PRAGMA RESTRICT_REFERENCES(Enrp_Clc_Sca_Pass_Cp, WNDS,WNPS);
33
34 PROCEDURE Enrp_Del_Suao_Discon(
35 p_person_id IN NUMBER ,
36 p_course_cd IN VARCHAR2 ,
37 p_unit_cd IN VARCHAR2 ,
38 p_cal_type IN VARCHAR2 ,
39 p_ci_sequence_number IN NUMBER ,
40 p_discontinued_dt IN DATE,
41 p_uoo_id IN NUMBER);
42
43 FUNCTION Enrp_Del_Sua_Sut(
44 p_person_id IN NUMBER ,
45 p_course_cd IN VARCHAR2 ,
46 p_unit_cd IN VARCHAR2 ,
47 p_cal_type IN VARCHAR2 ,
48 p_ci_sequence_number IN NUMBER ,
49 p_unit_attempt_status IN VARCHAR2 ,
50 p_message_name OUT NOCOPY VARCHAR2,
51 p_uoo_id IN NUMBER )
52 RETURN BOOLEAN;
53
54
55 FUNCTION Enrp_Del_Sua_Trnsfr(
56 p_person_id IN NUMBER ,
57 p_course_cd IN VARCHAR2 ,
58 p_unit_cd IN VARCHAR2 ,
59 p_cal_type IN VARCHAR2 ,
60 p_ci_sequence_number IN NUMBER ,
61 p_message_name OUT NOCOPY VARCHAR2,
62 p_uoo_id IN NUMBER)
63 RETURN BOOLEAN;
64
65
66 FUNCTION Enrp_Del_Susa_Hist(
67 p_person_id IN NUMBER ,
68 p_course_cd IN VARCHAR2 ,
69 p_unit_set_cd IN VARCHAR2 ,
70 p_sequence_number IN NUMBER ,
71 p_message_name out NOCOPY Varchar2 )
72 RETURN BOOLEAN;
73
74
75 FUNCTION Enrp_Del_Susa_Trnsfr(
76 p_person_id IN NUMBER ,
77 p_course_cd IN VARCHAR2 ,
78 p_unit_set_cd IN VARCHAR2 ,
79 p_us_version_number IN NUMBER ,
80 p_message_name out NOCOPY Varchar2 )
81 RETURN BOOLEAN;
82
83
84 END IGS_EN_GEN_001;
[Home] [Help]