1 PACKAGE IGS_EN_GEN_011 AS
2 /* $Header: IGSEN11S.pls 120.0 2005/06/01 17:35:41 appldev noship $ */
3
4 ------------------------------------------------------------------
5 --Created by : knaraset, Oracle IDC
6 --Date created:
7 --
8 --Purpose:
9 --
10 --Known limitations/enhancements and/or remarks:
11 --
12 --Change History:
13 --Who When What
14 --pradhakr 12/07/2001 Added one parameter p_dcnt_reason_cd in
15 -- the procedure Enrp_prc_sua_enr_ds as part
16 -- of Enrollment build (Bug # 1832130 )
17 --kkillams 03-10-2002 1)Three New p_unit_loc_cd, p_unit_class,p_reason
18 -- parameters are added to Enrp_Prc_Sua_Blk_E_D procedure.
19 -- 2)Three New p_enforce_val,p_enroll_method,p_reason parameters
20 -- are added to Enrp_Prc_Sua_Blk_Trn procedure.
21 -- w.r.t. build Drop Trasfer workflow notification(Bug no: 2599925)
22 -- kkillams 14-06-2003 Added three new parameters p_enr_method,p_load_cal_type
23 -- and p_load_cal_seq to the Enrp_Prc_Sua_Blk_E_D procedure w.r.t bug 2829270.
24 -- vkarthik 1. Added a function match_term_sca_params as a part of bug 2829263
25 -- 2. Added two parameters p_term_cal_type and p_term_sequence_number
26 -- in procedure enrp_prc_sca_blk_trn
27 -- stutta 03-Nov_2004 Added parameter p_course_attempt_status6 to proc Enrp_Prc_Sca_Blk_Trn.
28 -------------------------------------------------------------------
29
30 Procedure Enrp_Prc_Sca_Blk_Trn(
31 p_acad_cal_type IN VARCHAR2 ,
32 p_acad_ci_sequence_number IN NUMBER ,
33 p_course_cd IN VARCHAR2 ,
34 p_version_number IN NUMBER ,
35 p_location_cd IN VARCHAR2 ,
36 p_attendance_type IN VARCHAR2 ,
37 p_attendance_mode IN VARCHAR2 ,
38 p_group_id IN NUMBER ,
39 p_course_attempt_status1 IN VARCHAR2 ,
40 p_course_attempt_status2 IN VARCHAR2 ,
41 p_course_attempt_status3 IN VARCHAR2 ,
42 p_course_attempt_status4 IN VARCHAR2 ,
43 p_course_attempt_status5 IN VARCHAR2 ,
44 p_course_attempt_status6 IN VARCHAR2 DEFAULT NULL,
45 p_to_acad_cal_type IN VARCHAR2 ,
46 p_to_crs_version_number IN NUMBER ,
47 p_to_location_cd IN VARCHAR2 ,
48 p_to_attendance_type IN VARCHAR2 ,
49 p_to_attendance_mode IN VARCHAR2 ,
50 p_term_cal_type IN VARCHAR2,
51 p_term_sequence_number IN NUMBER,
52 p_creation_dt IN OUT NOCOPY DATE );
53
54 Procedure Enrp_Prc_Sua_Blk_E_D(
55 p_teach_cal_type IN VARCHAR2 ,
56 p_teach_ci_sequence_number IN NUMBER ,
57 p_course_cd IN VARCHAR2 ,
58 p_location_cd IN VARCHAR2 ,
59 p_attendance_type IN VARCHAR2 ,
60 p_attendance_mode IN VARCHAR2 ,
61 p_unit_cd IN VARCHAR2 ,
62 p_uv_version_number IN NUMBER ,
63 p_group_id IN NUMBER ,
64 p_person_id IN NUMBER ,
65 p_action1 IN VARCHAR2 ,
66 p_unit_cd1 IN VARCHAR2 ,
67 p_uv_version_number1 IN NUMBER ,
68 p_location_cd1 IN VARCHAR2 ,
69 p_unit_class1 IN VARCHAR2 ,
70 p_action2 IN VARCHAR2 ,
71 p_unit_cd2 IN VARCHAR2 ,
72 p_uv_version_number2 IN NUMBER ,
73 p_location_cd2 IN VARCHAR2 ,
74 p_unit_class2 IN VARCHAR2 ,
75 p_action3 IN VARCHAR2 ,
76 p_unit_cd3 IN VARCHAR2 ,
77 p_uv_version_number3 IN NUMBER ,
78 p_location_cd3 IN VARCHAR2 ,
79 p_unit_class3 IN VARCHAR2 ,
80 p_action4 IN VARCHAR2 ,
81 p_unit_cd4 IN VARCHAR2 ,
82 p_uv_version_number4 IN NUMBER ,
83 p_location_cd4 IN VARCHAR2 ,
84 p_unit_class4 IN VARCHAR2 ,
85 p_action5 IN VARCHAR2 ,
86 p_unit_cd5 IN VARCHAR2 ,
87 p_uv_version_number5 IN NUMBER ,
88 p_location_cd5 IN VARCHAR2 ,
89 p_unit_class5 IN VARCHAR2 ,
90 p_action6 IN VARCHAR2 ,
91 p_unit_cd6 IN VARCHAR2 ,
92 p_uv_version_number6 IN NUMBER ,
93 p_location_cd6 IN VARCHAR2 ,
94 p_unit_class6 IN VARCHAR2 ,
95 p_action7 IN VARCHAR2 ,
96 p_unit_cd7 IN VARCHAR2 ,
97 p_uv_version_number7 IN NUMBER ,
98 p_location_cd7 IN VARCHAR2 ,
99 p_unit_class7 IN VARCHAR2 ,
100 p_action8 IN VARCHAR2 ,
101 p_unit_cd8 IN VARCHAR2 ,
102 p_uv_version_number8 IN NUMBER ,
103 p_location_cd8 IN VARCHAR2 ,
104 p_unit_class8 IN VARCHAR2 ,
105 p_confirmed_ind IN VARCHAR2 DEFAULT 'N',
106 p_enrolled_dt IN DATE ,
107 p_no_assessment_ind IN VARCHAR2 DEFAULT 'N',
108 p_exam_location_cd IN VARCHAR2 ,
109 p_alternative_title IN VARCHAR2 ,
110 p_override_enrolled_cp IN NUMBER ,
111 p_override_achievable_cp IN NUMBER DEFAULT 6,
112 p_override_eftsu IN NUMBER DEFAULT 7,
113 p_override_credit_reason IN VARCHAR2 ,
114 p_administrative_unit_status IN VARCHAR2 ,
115 p_discontinued_dt IN DATE ,
116 p_creation_dt IN OUT NOCOPY DATE,
117 p_dcnt_reason_cd IN VARCHAR2 DEFAULT NULL,
118 p_unit_loc_cd IN VARCHAR2 DEFAULT NULL,
119 p_unit_class IN VARCHAR2 DEFAULT NULL,
120 p_reason IN VARCHAR2 DEFAULT NULL,
121 p_enr_method IN VARCHAR2,
122 p_load_cal_type IN VARCHAR2,
123 p_load_cal_seq IN NUMBER);
124
125 Procedure Enrp_Prc_Sua_Blk_Trn(
126 p_teach_cal_type IN VARCHAR2 ,
127 p_teach_ci_sequence_number IN NUMBER ,
128 p_course_cd IN VARCHAR2 ,
129 p_location_cd IN VARCHAR2 ,
130 p_attendance_type IN VARCHAR2 ,
131 p_attendance_mode IN VARCHAR2 ,
132 p_group_id IN NUMBER ,
133 p_from_unit_cd IN VARCHAR2 ,
134 p_from_uv_version_number IN NUMBER ,
135 p_from_location_cd IN VARCHAR2 ,
136 p_from_unit_class IN VARCHAR2 ,
137 p_unit_attempt_status1 IN VARCHAR2 ,
138 p_unit_attempt_status2 IN VARCHAR2 ,
139 p_unit_attempt_status3 IN VARCHAR2 ,
140 p_to_uv_version_number IN NUMBER ,
141 p_to_location_cd IN VARCHAR2 ,
142 p_to_unit_class IN VARCHAR2 ,
143 p_creation_dt IN OUT NOCOPY DATE,
144 p_enforce_val IN VARCHAR2 DEFAULT NULL,
145 p_enroll_method IN VARCHAR2 DEFAULT NULL,
146 p_reason IN VARCHAR2 DEFAULT NULL);
147
148 Procedure Enrp_Set_Pee_Expry(
149 p_person_id IN NUMBER ,
150 p_encumbrance_type IN VARCHAR2 ,
151 p_pen_start_dt IN DATE ,
152 p_effect_type IN VARCHAR2 ,
153 p_pee_start_dt IN DATE ,
154 p_sequence_number IN NUMBER ,
155 p_expiry_dt IN DATE ,
156 p_message_name OUT NOCOPY VARCHAR2 );
157
158 Procedure Enrp_Set_Pen_Expry(
159 p_person_id IN NUMBER ,
160 p_encumbrance_type IN VARCHAR2 ,
161 p_pen_start_dt IN DATE ,
162 p_sequence_number IN NUMBER ,
163 p_expiry_dt IN DATE ,
164 p_message_name OUT NOCOPY VARCHAR2 );
165
166 Function Enrp_Upd_Acai_Accept(
167 p_person_id IN NUMBER ,
168 p_course_cd IN VARCHAR2 ,
169 p_adm_admission_appl_number IN NUMBER ,
170 p_adm_nominated_course_cd IN VARCHAR2 ,
171 p_adm_sequence_number IN NUMBER ,
172 p_message_name OUT NOCOPY VARCHAR2 )
173 RETURN boolean;
174
175 Procedure Enrp_Upd_Enr_Pp(
176 p_username IN VARCHAR2 ,
177 p_cal_type IN VARCHAR2 ,
178 p_sequence_number IN NUMBER ,
179 p_enrolment_cat IN VARCHAR2 ,
180 p_enr_method_type IN VARCHAR2 );
181
182 FUNCTION match_term_sca_params (
183 p_sca_person_id IN NUMBER,
184 p_sca_course_cd IN VARCHAR2,
185 p_sca_version_number IN NUMBER,
186 p_sca_attendance_type IN VARCHAR2,
187 p_sca_attendance_mode IN VARCHAR2,
188 p_sca_location_cd IN VARCHAR2,
189 p_para_course_cd IN VARCHAR2,
190 p_para_version_number IN NUMBER,
191 p_para_attendance_type IN VARCHAR2,
192 p_para_attendance_mode IN VARCHAR2,
193 p_para_location_cd IN VARCHAR2,
194 p_term_cal_type IN VARCHAR2,
195 p_term_sequence_number IN NUMBER) RETURN VARCHAR2;
196 END IGS_EN_GEN_011;