1 package IGS_EN_SU_ATTEMPT_H_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSEI37S.pls 115.9 2003/10/15 04:10:25 ptandon ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_PERSON_ID in NUMBER,
6 X_COURSE_CD in VARCHAR2,
7 X_UNIT_CD in VARCHAR2,
8 X_CAL_TYPE in VARCHAR2,
9 X_CI_SEQUENCE_NUMBER in NUMBER,
10 X_HIST_START_DT in DATE,
11 X_ELO_DESCRIPTION in VARCHAR2,
12 X_SUP_UNIT_CD in VARCHAR2,
13 X_SUP_VERSION_NUMBER in NUMBER,
14 X_ALTERNATIVE_TITLE in VARCHAR2,
15 X_OVERRIDE_ENROLLED_CP in NUMBER,
16 X_OVERRIDE_EFTSU in NUMBER,
17 X_OVERRIDE_ACHIEVABLE_CP in NUMBER,
18 X_OVERRIDE_OUTCOME_DUE_DT in DATE,
19 X_OVERRIDE_CREDIT_REASON in VARCHAR2,
20 X_VERSION_NUMBER in NUMBER,
21 X_HIST_END_DT in DATE,
22 X_HIST_WHO in NUMBER,
23 X_LOCATION_CD in VARCHAR2,
24 X_UNIT_CLASS in VARCHAR2,
25 X_ENROLLED_DT in DATE,
26 X_UNIT_ATTEMPT_STATUS in VARCHAR2,
27 X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
28 X_AUS_DESCRIPTION in VARCHAR2,
29 X_DISCONTINUED_DT in DATE,
30 X_RULE_WAIVED_DT in DATE,
31 X_RULE_WAIVED_PERSON_ID in NUMBER,
32 X_NO_ASSESSMENT_IND in VARCHAR2,
33 X_EXAM_LOCATION_CD in VARCHAR2,
34 X_DCNT_REASON_CD in VARCHAR2,
35 X_MODE in VARCHAR2 default 'R' ,
36 x_org_id IN NUMBER,
37 X_GRADING_SCHEMA_CODE in VARCHAR2 DEFAULT NULL,
38 X_ENR_METHOD_TYPE in VARCHAR2 DEFAULT NULL,
39 X_ADMINISTRATIVE_PRIORITY IN NUMBER DEFAULT NULL,
40 X_WAITLIST_DT IN DATE DEFAULT NULL,
41 X_REQUEST_ID IN NUMBER DEFAULT NULL,
42 X_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL,
43 X_PROGRAM_ID IN NUMBER DEFAULT NULL,
44 X_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL,
45 X_CART IN VARCHAR2 DEFAULT NULL,
46 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
47 X_RSV_SEAT_EXT_ID IN NUMBER DEFAULT NULL,
48 X_GS_VERSION_NUMBER IN NUMBER DEFAULT NULL,
49 X_FAILED_UNIT_RULE IN VARCHAR2 DEFAULT NULL,
50 X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
51 X_UOO_ID IN NUMBER,
52 X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
53 );
54 procedure LOCK_ROW (
55 X_ROWID in VARCHAR2,
56 X_PERSON_ID in NUMBER,
57 X_COURSE_CD in VARCHAR2,
58 X_UNIT_CD in VARCHAR2,
59 X_CAL_TYPE in VARCHAR2,
60 X_CI_SEQUENCE_NUMBER in NUMBER,
61 X_HIST_START_DT in DATE,
62 X_ELO_DESCRIPTION in VARCHAR2,
63 X_SUP_UNIT_CD in VARCHAR2,
64 X_SUP_VERSION_NUMBER in NUMBER,
65 X_ALTERNATIVE_TITLE in VARCHAR2,
66 X_OVERRIDE_ENROLLED_CP in NUMBER,
67 X_OVERRIDE_EFTSU in NUMBER,
68 X_OVERRIDE_ACHIEVABLE_CP in NUMBER,
69 X_OVERRIDE_OUTCOME_DUE_DT in DATE,
70 X_OVERRIDE_CREDIT_REASON in VARCHAR2,
71 X_VERSION_NUMBER in NUMBER,
72 X_HIST_END_DT in DATE,
73 X_HIST_WHO in NUMBER,
74 X_LOCATION_CD in VARCHAR2,
75 X_UNIT_CLASS in VARCHAR2,
76 X_ENROLLED_DT in DATE,
77 X_UNIT_ATTEMPT_STATUS in VARCHAR2,
78 X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
79 X_AUS_DESCRIPTION in VARCHAR2,
80 X_DISCONTINUED_DT in DATE,
81 X_RULE_WAIVED_DT in DATE,
82 X_RULE_WAIVED_PERSON_ID in NUMBER,
83 X_NO_ASSESSMENT_IND in VARCHAR2,
84 X_EXAM_LOCATION_CD in VARCHAR2,
85 X_DCNT_REASON_CD in VARCHAR2,
86 X_GRADING_SCHEMA_CODE in VARCHAR2 DEFAULT NULL,
87 X_ENR_METHOD_TYPE in VARCHAR2 DEFAULT NULL,
88 X_ADMINISTRATIVE_PRIORITY IN NUMBER DEFAULT NULL,
89 X_WAITLIST_DT IN DATE DEFAULT NULL,
90 X_REQUEST_ID IN NUMBER DEFAULT NULL,
91 X_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL,
92 X_PROGRAM_ID IN NUMBER DEFAULT NULL,
93 X_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL,
94 X_CART IN VARCHAR2 DEFAULT NULL,
95 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
96 X_RSV_SEAT_EXT_ID IN NUMBER DEFAULT NULL,
97 X_GS_VERSION_NUMBER IN NUMBER DEFAULT NULL,
98 X_FAILED_UNIT_RULE IN VARCHAR2 DEFAULT NULL,
99 X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
100 X_UOO_ID IN NUMBER,
101 X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
102 );
103 procedure UPDATE_ROW (
104 X_ROWID in VARCHAR2,
105 X_PERSON_ID in NUMBER,
106 X_COURSE_CD in VARCHAR2,
107 X_UNIT_CD in VARCHAR2,
108 X_CAL_TYPE in VARCHAR2,
109 X_CI_SEQUENCE_NUMBER in NUMBER,
110 X_HIST_START_DT in DATE,
111 X_ELO_DESCRIPTION in VARCHAR2,
112 X_SUP_UNIT_CD in VARCHAR2,
113 X_SUP_VERSION_NUMBER in NUMBER,
114 X_ALTERNATIVE_TITLE in VARCHAR2,
115 X_OVERRIDE_ENROLLED_CP in NUMBER,
116 X_OVERRIDE_EFTSU in NUMBER,
117 X_OVERRIDE_ACHIEVABLE_CP in NUMBER,
118 X_OVERRIDE_OUTCOME_DUE_DT in DATE,
119 X_OVERRIDE_CREDIT_REASON in VARCHAR2,
120 X_VERSION_NUMBER in NUMBER,
121 X_HIST_END_DT in DATE,
122 X_HIST_WHO in NUMBER,
123 X_LOCATION_CD in VARCHAR2,
124 X_UNIT_CLASS in VARCHAR2,
125 X_ENROLLED_DT in DATE,
126 X_UNIT_ATTEMPT_STATUS in VARCHAR2,
127 X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
128 X_AUS_DESCRIPTION in VARCHAR2,
129 X_DISCONTINUED_DT in DATE,
130 X_RULE_WAIVED_DT in DATE,
131 X_RULE_WAIVED_PERSON_ID in NUMBER,
132 X_NO_ASSESSMENT_IND in VARCHAR2,
133 X_EXAM_LOCATION_CD in VARCHAR2,
134 X_DCNT_REASON_CD in VARCHAR2,
135 X_MODE in VARCHAR2 default 'R',
136 X_GRADING_SCHEMA_CODE in VARCHAR2 DEFAULT NULL,
137 X_ENR_METHOD_TYPE in VARCHAR2 DEFAULT NULL,
138 X_ADMINISTRATIVE_PRIORITY IN NUMBER DEFAULT NULL,
139 X_WAITLIST_DT IN DATE DEFAULT NULL,
140 X_REQUEST_ID IN NUMBER DEFAULT NULL,
141 X_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL,
142 X_PROGRAM_ID IN NUMBER DEFAULT NULL,
143 X_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL,
144 X_CART IN VARCHAR2 DEFAULT NULL,
145 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
146 X_RSV_SEAT_EXT_ID IN NUMBER DEFAULT NULL,
147 X_GS_VERSION_NUMBER IN NUMBER DEFAULT NULL,
148 X_FAILED_UNIT_RULE IN VARCHAR2 DEFAULT NULL,
149 X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
150 X_UOO_ID IN NUMBER,
151 X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
152 );
153 procedure ADD_ROW (
154 X_ROWID in out NOCOPY VARCHAR2,
155 X_PERSON_ID in NUMBER,
156 X_COURSE_CD in VARCHAR2,
157 X_UNIT_CD in VARCHAR2,
158 X_CAL_TYPE in VARCHAR2,
159 X_CI_SEQUENCE_NUMBER in NUMBER,
160 X_HIST_START_DT in DATE,
161 X_ELO_DESCRIPTION in VARCHAR2,
162 X_SUP_UNIT_CD in VARCHAR2,
163 X_SUP_VERSION_NUMBER in NUMBER,
164 X_ALTERNATIVE_TITLE in VARCHAR2,
165 X_OVERRIDE_ENROLLED_CP in NUMBER,
166 X_OVERRIDE_EFTSU in NUMBER,
167 X_OVERRIDE_ACHIEVABLE_CP in NUMBER,
168 X_OVERRIDE_OUTCOME_DUE_DT in DATE,
169 X_OVERRIDE_CREDIT_REASON in VARCHAR2,
170 X_VERSION_NUMBER in NUMBER,
171 X_HIST_END_DT in DATE,
172 X_HIST_WHO in NUMBER,
173 X_LOCATION_CD in VARCHAR2,
174 X_UNIT_CLASS in VARCHAR2,
175 X_ENROLLED_DT in DATE,
176 X_UNIT_ATTEMPT_STATUS in VARCHAR2,
177 X_ADMINISTRATIVE_UNIT_STATUS in VARCHAR2,
178 X_AUS_DESCRIPTION in VARCHAR2,
179 X_DISCONTINUED_DT in DATE,
180 X_RULE_WAIVED_DT in DATE,
181 X_RULE_WAIVED_PERSON_ID in NUMBER,
182 X_NO_ASSESSMENT_IND in VARCHAR2,
183 X_EXAM_LOCATION_CD in VARCHAR2,
184 X_DCNT_REASON_CD in VARCHAR2,
185 X_MODE in VARCHAR2 default 'R',
186 x_org_id IN NUMBER,
187 X_GRADING_SCHEMA_CODE in VARCHAR2 DEFAULT NULL,
188 X_ENR_METHOD_TYPE in VARCHAR2 DEFAULT NULL,
189 X_ADMINISTRATIVE_PRIORITY IN NUMBER DEFAULT NULL,
190 X_WAITLIST_DT IN DATE DEFAULT NULL,
191 X_REQUEST_ID IN NUMBER DEFAULT NULL,
192 X_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL,
193 X_PROGRAM_ID IN NUMBER DEFAULT NULL,
194 X_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL,
195 X_CART IN VARCHAR2 DEFAULT NULL,
196 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
197 X_RSV_SEAT_EXT_ID IN NUMBER DEFAULT NULL,
198 X_GS_VERSION_NUMBER IN NUMBER DEFAULT NULL,
199 X_FAILED_UNIT_RULE IN VARCHAR2 DEFAULT NULL,
200 X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
201 X_UOO_ID IN NUMBER,
202 X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
203 );
204 procedure DELETE_ROW (
205 X_ROWID in VARCHAR2
206 );
207 FUNCTION Get_PK_For_Validation (
208 x_person_id IN NUMBER,
209 x_course_cd IN VARCHAR2,
210 x_hist_start_dt IN DATE,
211 x_uoo_id IN NUMBER
212 ) RETURN BOOLEAN;
213
214 PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
215 x_person_id IN NUMBER,
216 x_course_cd IN VARCHAR2
217 );
218
219 PROCEDURE GET_FK_IGS_EN_SU_ATTEMPT (
220 x_person_id IN NUMBER,
221 x_course_cd IN VARCHAR2,
222 x_uoo_id IN NUMBER
223 );
224
225 PROCEDURE Check_Constraints (
226 Column_Name IN VARCHAR2 DEFAULT NULL,
227 Column_Value IN VARCHAR2 DEFAULT NULL
228 );
229
230 PROCEDURE Before_DML (
231 p_action IN VARCHAR2,
232 x_rowid IN VARCHAR2 DEFAULT NULL,
233 x_person_id IN NUMBER DEFAULT NULL,
234 x_course_cd IN VARCHAR2 DEFAULT NULL,
235 x_unit_cd IN VARCHAR2 DEFAULT NULL,
236 x_version_number IN NUMBER DEFAULT NULL,
237 x_cal_type IN VARCHAR2 DEFAULT NULL,
238 x_ci_sequence_number IN NUMBER DEFAULT NULL,
239 x_hist_start_dt IN DATE DEFAULT NULL,
240 x_hist_end_dt IN DATE DEFAULT NULL,
241 x_hist_who IN NUMBER DEFAULT NULL,
242 x_location_cd IN VARCHAR2 DEFAULT NULL,
243 x_unit_class IN VARCHAR2 DEFAULT NULL,
244 x_enrolled_dt IN DATE DEFAULT NULL,
245 x_unit_attempt_status IN VARCHAR2 DEFAULT NULL,
246 x_administrative_unit_status IN VARCHAR2 DEFAULT NULL,
247 x_aus_description IN VARCHAR2 DEFAULT NULL,
248 x_discontinued_dt IN DATE DEFAULT NULL,
249 x_rule_waived_dt IN DATE DEFAULT NULL,
250 x_rule_waived_person_id IN NUMBER DEFAULT NULL,
251 x_no_assessment_ind IN VARCHAR2 DEFAULT NULL,
252 x_exam_location_cd IN VARCHAR2 DEFAULT NULL,
253 x_elo_description IN VARCHAR2 DEFAULT NULL,
254 x_sup_unit_cd IN VARCHAR2 DEFAULT NULL,
255 x_sup_version_number IN NUMBER DEFAULT NULL,
256 x_alternative_title IN VARCHAR2 DEFAULT NULL,
257 x_override_enrolled_cp IN NUMBER DEFAULT NULL,
258 x_override_eftsu IN NUMBER DEFAULT NULL,
259 x_override_achievable_cp IN NUMBER DEFAULT NULL,
260 x_override_outcome_due_dt IN DATE DEFAULT NULL,
261 x_override_credit_reason IN VARCHAR2 DEFAULT NULL,
262 x_dcnt_reason_Cd IN VARCHAR2 DEFAULT NULL,
263 x_creation_date IN DATE DEFAULT NULL,
264 x_created_by IN NUMBER DEFAULT NULL,
265 x_last_update_date IN DATE DEFAULT NULL,
266 x_last_updated_by IN NUMBER DEFAULT NULL,
267 x_last_update_login IN NUMBER DEFAULT NULL,
268 x_org_id IN NUMBER DEFAULT NULL,
269 X_GRADING_SCHEMA_CODE in VARCHAR2 DEFAULT NULL,
270 X_ENR_METHOD_TYPE in VARCHAR2 DEFAULT NULL,
271 X_ADMINISTRATIVE_PRIORITY IN NUMBER DEFAULT NULL,
272 X_WAITLIST_DT IN DATE DEFAULT NULL,
273 X_REQUEST_ID IN NUMBER DEFAULT NULL,
274 X_PROGRAM_APPLICATION_ID IN NUMBER DEFAULT NULL,
275 X_PROGRAM_ID IN NUMBER DEFAULT NULL,
276 X_PROGRAM_UPDATE_DATE IN DATE DEFAULT NULL,
277 X_CART IN VARCHAR2 DEFAULT NULL,
278 X_ORG_UNIT_CD IN VARCHAR2 DEFAULT NULL,
279 X_RSV_SEAT_EXT_ID IN NUMBER DEFAULT NULL,
280 X_GS_VERSION_NUMBER IN NUMBER DEFAULT NULL,
281 X_FAILED_UNIT_RULE IN VARCHAR2 DEFAULT NULL,
282 X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL,
283 X_UOO_ID IN NUMBER DEFAULT NULL,
284 X_CORE_INDICATOR_CODE IN VARCHAR2 DEFAULT NULL
285 ) ;
286
287 end IGS_EN_SU_ATTEMPT_H_PKG;