1 PACKAGE IGS_EN_GEN_006 AS
2 /* $Header: IGSEN06S.pls 120.1 2006/02/19 22:37:30 ctyagi noship $ */
3
4 Function Enrp_Get_Sca_Acad(
5 p_person_id IN NUMBER ,
6 p_course_cd IN VARCHAR2 ,
7 p_cal_type IN VARCHAR2 ,
8 p_ci_sequence_number OUT NOCOPY NUMBER ,
9 p_enrolment_cat OUT NOCOPY VARCHAR2 ,
10 p_message_name out NOCOPY Varchar2 )
11 RETURN BOOLEAN;
12 -- PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Acad, WNDS);
13
14 Function Enrp_Get_Sca_Am(
15 p_person_id IN NUMBER ,
16 p_course_cd IN VARCHAR2 ,
17 p_load_cal_type IN VARCHAR2 ,
18 p_load_sequence_number IN NUMBER )
19 RETURN VARCHAR2;
20 -- PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Am, WNDS);
21
22 Function Enrp_Get_Sca_Att(
23 p_person_id IN NUMBER ,
24 p_course_cd IN VARCHAR2 ,
25 p_effective_dt IN DATE )
26 RETURN VARCHAR2;
27 -- PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Att, WNDS);
28
29 Function Enrp_Get_Sca_Comm(
30 p_person_id IN NUMBER ,
31 p_course_cd IN VARCHAR2 ,
32 p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
33 p_effective_date IN DATE )
34 RETURN boolean;
35 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Comm, WNDS, WNPS);
36
37 Function Enrp_Get_Sca_Elgbl(
38 p_person_id IN NUMBER ,
39 p_course_cd IN VARCHAR2 ,
40 p_student_comm_type IN VARCHAR2 ,
41 p_acad_cal_type IN VARCHAR2 ,
42 p_acad_ci_sequence_number IN NUMBER ,
43 p_dflt_confirmed_course_ind IN VARCHAR2 DEFAULT 'N',
44 p_message_name out NOCOPY Varchar2 )
45 RETURN boolean;
46 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Elgbl, WNDS, WNPS);
47
48
49 Function Enrp_Get_Sca_Latt(
50 p_person_id IN NUMBER ,
51 p_course_cd IN VARCHAR2 ,
52 p_load_cal_type IN VARCHAR2 ,
53 p_load_sequence_number IN NUMBER )
54 RETURN VARCHAR2;
55 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Latt, WNDS, WNPS);
56
57
58 Function Enrp_Get_Sca_Perd(
59 p_person_id IN NUMBER ,
60 p_course_cd IN VARCHAR2 )
61 RETURN VARCHAR2;
62 -- PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Perd, WNDS);
63
64 Function Enrp_Get_Sca_Status(
65 p_person_id IN NUMBER ,
66 p_course_cd IN VARCHAR2 ,
67 p_course_attempt_status IN VARCHAR2 ,
68 p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
69 p_discontinued_dt IN DATE ,
70 p_lapsed_dt IN DATE ,
71 p_course_rqrmnt_complete_ind IN VARCHAR2 DEFAULT 'N',
72 p_logical_delete_dt IN DATE )
73 RETURN VARCHAR2;
74 -- PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Status, WNDS);
75
76 Function Enrp_Get_Sca_Trnsfr(
77 p_person_id IN NUMBER ,
78 p_course_cd IN VARCHAR2 ,
79 p_message_name out NOCOPY Varchar2 )
80 RETURN BOOLEAN;
81 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Trnsfr, WNDS, WNPS);
82
83 END IGS_EN_GEN_006;