1 PACKAGE igs_en_gen_008 AUTHID CURRENT_USER AS
2 /* $Header: IGSEN08S.pls 115.12 2003/06/17 14:02:26 kkillams ship $ */
3
4 /******************************************************************
5 Created By :
6 Date Created By :
7 Purpose :
8 Known limitations,
9 enhancements,
10 remarks :
11 Change History
12 Who When What
13 vchappid 04-Jul-01 functions enrp_get_person_type, enrp_val_chg_grd_sch are added
14 functions enrp_get_ua_del_alwd, enrp_get_var_window, enrp_get_uddc_aus
15 are modified by adding p_uoo_id parameter with default NULL
16 kkillams 26-12-2001 new parameters are added to procedure ENRP_INS_BTCH_PRENRL
17 w.r.t. YOP-EN build bug id:2156956
18 Nishikant 07OCT2002 UK Enhancement build. Bug#2580731. Five new parameters p_start_day, p_start_month,
19 p_end_day, p_end_month, p_selection_date added in the procedure enrp_ins_btch_prenrl.
20 The function get_commence_date_range defined for being used in a cursor c_sca of the
21 procedure enrp_ins_btch_prenrl.
22 Nishikant 16DEC2002 ENCR030(UK Enh) - Bug#2708430. One more parameter p_completion_date added in the procedure
23 enrp_ins_btch_prenrl.
24 kkillams 25-04-2003 New parameter p_uoo_id is added to the function enrp_get_ua_rty w.r.t bug number 2829262
25 amuthu 04-JUN-2003 added new parameter p_progress_status to enrp_ins_btch_prenrl as part of bug 2829265
26 kkillams 16-06-2003 Three new parameters are added to the enrp_ins_btch_prenrl procedure as part of bug 2829270
27 ******************************************************************/
28
29 FUNCTION enrp_get_ua_del_alwd(
30 p_cal_type IN VARCHAR2 ,
31 p_ci_sequence_number IN NUMBER ,
32 p_effective_dt IN DATE,
33 p_uoo_id IN NUMBER DEFAULT NULL)
34 RETURN VARCHAR2;
35 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Ua_Del_Alwd, WNDS);
36
37
38 FUNCTION enrp_get_ua_rty(
39 p_person_id IN NUMBER ,
40 p_course_cd IN VARCHAR2 ,
41 p_unit_cd IN VARCHAR2 ,
42 p_cal_type IN VARCHAR2 ,
43 p_ci_sequence_number IN NUMBER,
44 p_uoo_id IN NUMBER)
45 RETURN VARCHAR2;
46 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Ua_Rty, WNDS);
47
48 FUNCTION enrp_get_uddc_aus(
49 p_discontinued_dt IN DATE ,
50 p_cal_type IN VARCHAR2 ,
51 p_ci_sequence_number IN NUMBER ,
52 p_admin_unit_status_str OUT NOCOPY VARCHAR2 ,
53 p_alias_val OUT NOCOPY DATE,
54 p_uoo_id IN NUMBER DEFAULT NULL )
55 RETURN VARCHAR2;
56 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Uddc_Aus, WNDS, WNPS);
57
58 FUNCTION enrp_get_ug_pg_crs(
59 p_course_cd IN VARCHAR2 ,
60 p_version_number NUMBER )
61 RETURN VARCHAR2;
62 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Ug_Pg_Crs, WNDS);
63
64 FUNCTION enrp_get_us_title(
65 p_unit_set_cd IN VARCHAR2 ,
66 p_us_version_number IN NUMBER ,
67 p_course_cd IN VARCHAR2 ,
68 p_version_number IN NUMBER ,
69 p_cal_type IN VARCHAR2 ,
70 p_sequence_number IN NUMBER ,
71 p_person_id IN NUMBER )
72 RETURN varchar2;
73 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Us_Title, WNDS,WNPS);
74
75 FUNCTION enrp_get_var_window(
76 p_cal_type IN VARCHAR2 ,
77 p_ci_sequence_number IN NUMBER ,
78 p_effective_dt IN DATE,
79 p_uoo_id IN NUMBER DEFAULT NULL)
80 RETURN BOOLEAN;
81 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Var_Window, WNDS);
82
83 FUNCTION enrp_get_within_ci(
84 p_sup_cal_type IN VARCHAR2 ,
85 p_sup_sequence_number IN NUMBER ,
86 p_sub_cal_type IN VARCHAR2 ,
87 p_sub_sequence_number IN NUMBER ,
88 p_direct_match_ind IN boolean )
89 RETURN boolean;
90 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Within_Ci, WNDS, WNPS);
91
92 PROCEDURE enrp_ins_btch_prenrl(
93 p_course_cd IN VARCHAR2 ,
94 p_acad_cal_type IN VARCHAR2 ,
95 p_acad_sequence_number IN NUMBER ,
96 p_course_type IN VARCHAR2 ,
97 p_responsible_org_unit_cd IN VARCHAR2 ,
98 p_location_cd IN VARCHAR2 ,
99 p_attendance_type IN VARCHAR2 ,
100 p_attendance_mode IN VARCHAR2 ,
101 p_student_comm_type IN VARCHAR2 ,
102 p_person_group_id IN NUMBER ,
103 p_dflt_enrolment_cat IN VARCHAR2 ,
104 p_units_indicator IN VARCHAR2 ,
105 p_override_enr_form_due_dt IN DATE ,
106 p_override_enr_pckg_prod_dt IN DATE ,
107 p_enr_cal_type IN VARCHAR2 ,
108 p_enr_sequence_number IN NUMBER ,
109 p_last_enrolment_cat IN VARCHAR2 ,
110 p_admission_cat IN VARCHAR2 ,
111 p_adm_cal_type IN VARCHAR2 ,
112 p_adm_sequence_number IN NUMBER ,
113 p_dflt_confirmed_ind IN VARCHAR2 ,
114 p_unit1_unit_cd IN VARCHAR2 ,
115 p_unit1_cal_type IN VARCHAR2 ,
116 p_unit1_location_cd IN VARCHAR2 ,
117 p_unit1_unit_class IN VARCHAR2 ,
118 p_unit2_unit_cd IN VARCHAR2 ,
119 p_unit2_cal_type IN VARCHAR ,
120 p_unit2_location_cd IN VARCHAR2 ,
121 p_unit2_unit_class IN VARCHAR2 ,
122 p_unit3_unit_cd IN VARCHAR2 ,
123 p_unit3_cal_type IN VARCHAR2 ,
124 p_unit3_location_cd IN VARCHAR2 ,
125 p_unit3_unit_class IN VARCHAR2 ,
126 p_unit4_unit_cd IN VARCHAR2 ,
127 p_unit4_cal_type IN VARCHAR2 ,
128 p_unit4_location_cd IN VARCHAR2 ,
129 p_unit4_unit_class IN VARCHAR2 ,
130 p_unit5_unit_cd IN VARCHAR2 ,
131 p_unit5_cal_type IN VARCHAR2 ,
132 p_unit5_location_cd IN VARCHAR2 ,
133 p_unit5_unit_class IN VARCHAR2 ,
134 p_unit6_unit_cd IN VARCHAR2 ,
135 p_unit6_cal_type IN VARCHAR2 ,
136 p_unit6_location_cd IN VARCHAR2 ,
137 p_unit6_unit_class IN VARCHAR2 ,
138 p_unit7_unit_cd IN VARCHAR2 ,
139 p_unit7_cal_type IN VARCHAR2 ,
140 p_unit7_location_cd IN VARCHAR2 ,
141 p_unit7_unit_class IN VARCHAR2 ,
142 p_unit8_unit_cd IN VARCHAR2 ,
143 p_unit8_cal_type IN VARCHAR2 ,
144 p_unit8_location_cd IN VARCHAR2 ,
145 p_unit8_unit_class IN VARCHAR2 ,
146 p_unit9_unit_cd IN VARCHAR2 , --cloumns are added w.r.t. YOP-EN build by kkillams from p_unit9_unit_cd to p_unit_set_cd2
147 p_unit9_cal_type IN VARCHAR2 ,
148 p_unit9_location_cd IN VARCHAR2 ,
149 p_unit9_unit_class IN VARCHAR2 ,
150 p_unit10_unit_cd IN VARCHAR2 ,
151 p_unit10_cal_type IN VARCHAR2 ,
152 p_unit10_location_cd IN VARCHAR2 ,
153 p_unit10_unit_class IN VARCHAR2 ,
154 p_unit11_unit_cd IN VARCHAR2 ,
155 p_unit11_cal_type IN VARCHAR2 ,
156 p_unit11_location_cd IN VARCHAR2 ,
157 p_unit11_unit_class IN VARCHAR2 ,
158 p_unit12_unit_cd IN VARCHAR2 ,
159 p_unit12_cal_type IN VARCHAR2 ,
160 p_unit12_location_cd IN VARCHAR2 ,
161 p_unit12_unit_class IN VARCHAR2 ,
162 p_unit_set_cd1 IN VARCHAR2 ,
163 p_unit_set_cd2 IN VARCHAR2 ,
164 -- The Below five parameters are added as part of the Enh bug#2580731
165 p_start_day IN NUMBER,
166 p_start_month IN NUMBER,
167 p_end_day IN NUMBER,
168 p_end_month IN NUMBER,
169 p_selection_date IN DATE,
170 --Below parameter added as part of ENCR030(UK Enh) - Bug#2708430
171 p_completion_date IN DATE DEFAULT NULL,
172 p_log_creation_dt OUT NOCOPY DATE,
173 p_progress_stat IN VARCHAR2 DEFAULT NULL,
174 p_dflt_enr_method IN VARCHAR2 DEFAULT NULL,
175 p_load_cal_type IN VARCHAR2 DEFAULT NULL,
176 p_load_ci_seq_num IN NUMBER DEFAULT NULL);
177
178 FUNCTION enrp_get_person_type(p_course_cd IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
179 PRAGMA RESTRICT_REFERENCES(enrp_get_person_type, WNDS,WNPS);
180
181
182 FUNCTION enrp_val_chg_grd_sch ( p_uoo_id IN NUMBER,
183 p_cal_type IN VARCHAR2,
184 p_ci_sequence_number IN NUMBER,
185 p_message_name OUT NOCOPY VARCHAR2
186 ) RETURN BOOLEAN;
187
188
189 FUNCTION enrp_val_chg_grd_sch_wrapper ( p_uoo_id IN NUMBER,
190 p_cal_type IN VARCHAR2,
191 p_ci_sequence_number IN NUMBER
192 ) RETURN CHAR;
193 FUNCTION enrp_val_chg_cp ( p_person_id IN NUMBER,
194 p_uoo_id IN NUMBER,
195 p_cal_type IN VARCHAR2,
196 p_ci_sequence_number IN NUMBER
197 ) RETURN CHAR;
198
199 FUNCTION enrp_get_dflt_sdrt(
200 p_s_discont_reason_type IN VARCHAR2 )
201 RETURN VARCHAR2;
202
203 FUNCTION get_commence_date_range(
204 p_start_day IN NUMBER,
205 p_start_month IN NUMBER,
206 p_end_day IN NUMBER,
207 p_end_month IN NUMBER,
208 p_commencement_dt IN DATE)
209 RETURN VARCHAR2;
210
211 END igs_en_gen_008;