1 PACKAGE IGS_EN_GEN_007 AS
2 /* $Header: IGSEN07S.pls 120.0 2005/06/01 20:49:59 appldev noship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --kkillams 25-04-2003 New parameter p_uoo_id is added to Enrp_Get_Suah_Col, Enrp_Get_Sua_Incur
7 -- and Enrp_Get_Sua_Status functions w.r.t. bug number 2829262
8 -------------------------------------------------------------------------------------------
9
10 Function Enrp_Get_Student_Ind(
11 p_person_id IN NUMBER )
12 RETURN VARCHAR2;
13 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Student_Ind, WNDS);
14
15 FUNCTION Enrp_Get_Suah_Col(
16 p_column_name IN user_tab_columns.column_name%TYPE ,
17 p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
18 p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
19 p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
20 p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
21 p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
22 p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
23 p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.uoo_id%TYPE)
24 RETURN VARCHAR2;
25 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Suah_Col, WNDS);
26
27 FUNCTION Enrp_Get_Sua_Incur(
28 p_person_id IN NUMBER ,
29 p_course_cd IN VARCHAR2 ,
30 p_unit_cd IN VARCHAR2 ,
31 p_unit_version_number IN NUMBER ,
32 p_cal_type IN VARCHAR2 ,
33 p_ci_sequence_number IN NUMBER ,
34 p_unit_attempt_status IN VARCHAR2 ,
35 p_discontinued_dt IN DATE ,
36 p_administrative_unit_status IN VARCHAR2,
37 p_uoo_id IN NUMBER)
38 RETURN VARCHAR2;
39 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sua_Incur, WNDS, WNPS);
40
41 FUNCTION Enrp_Get_Sua_Status(
42 p_person_id IN NUMBER ,
43 p_course_cd IN VARCHAR2 ,
44 p_unit_cd IN VARCHAR2 ,
45 p_version_number IN NUMBER ,
46 p_cal_type IN VARCHAR2 ,
47 p_ci_sequence_number IN NUMBER ,
48 p_unit_attempt_status IN VARCHAR2 ,
49 p_enrolled_dt IN DATE ,
50 p_rule_waived_dt IN DATE ,
51 p_discontinued_dt IN DATE ,
52 p_waitlisted_dt IN DATE DEFAULT NULL, -- Added p_waitlist_dt parameter as per the Bug# 2335455.
53 p_uoo_id IN NUMBER)
54 RETURN VARCHAR2;
55 -- PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sua_Status, WNDS);
56
57 Function Enrp_Get_Susa_Status(
58 p_selection_dt IN DATE ,
59 p_student_confirmed_ind IN VARCHAR2 ,
60 p_end_dt IN DATE ,
61 p_rqrmnts_complete_ind IN VARCHAR2 )
62 RETURN VARCHAR2;
63 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Susa_Status, WNDS, WNPS);
64
65 END IGS_EN_GEN_007;