eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.IGS_EN_STDNT_PS_ATT_PKG

Source


1 PACKAGE  IGS_EN_STDNT_PS_ATT_PKG AS
2 /* $Header: IGSEI24S.pls 120.0 2005/06/01 21:30:52 appldev noship $ */
3 
4 skip_before_after_dml BOOLEAN DEFAULT FALSE;
5 
6 PROCEDURE INSERT_ROW (
7   X_ROWID IN OUT NOCOPY VARCHAR2,
8   X_ORG_ID IN NUMBER,
9   X_PERSON_ID IN NUMBER,
10   X_COURSE_CD IN VARCHAR2,
11   X_ADVANCED_STANDING_IND IN VARCHAR2,
12   X_FEE_CAT IN VARCHAR2,
13   X_CORRESPONDENCE_CAT IN VARCHAR2,
14   X_SELF_HELP_GROUP_IND IN VARCHAR2,
15   X_LOGICAL_DELETE_DT IN DATE,
16   X_ADM_ADMISSION_APPL_NUMBER IN NUMBER,
17   X_ADM_NOMINATED_COURSE_CD IN VARCHAR2,
18   X_ADM_SEQUENCE_NUMBER IN NUMBER,
19   X_VERSION_NUMBER IN NUMBER,
20   X_CAL_TYPE IN VARCHAR2,
21   X_LOCATION_CD IN VARCHAR2,
22   X_ATTENDANCE_MODE IN VARCHAR2,
23   X_ATTENDANCE_TYPE IN VARCHAR2,
24   X_COO_ID IN NUMBER,
25   X_STUDENT_CONFIRMED_IND IN VARCHAR2,
26   X_COMMENCEMENT_DT IN DATE,
27   X_COURSE_ATTEMPT_STATUS IN VARCHAR2,
28   X_PROGRESSION_STATUS IN VARCHAR2,
29   X_DERIVED_ATT_TYPE IN VARCHAR2,
30   X_DERIVED_ATT_MODE IN VARCHAR2,
31   X_PROVISIONAL_IND IN VARCHAR2,
32   X_DISCONTINUED_DT IN DATE,
33   X_DISCONTINUATION_REASON_CD IN VARCHAR2,
34   X_LAPSED_DT IN DATE,
35   X_FUNDING_SOURCE IN VARCHAR2,
36   X_EXAM_LOCATION_CD IN VARCHAR2,
37   X_DERIVED_COMPLETION_YR IN NUMBER,
38   X_DERIVED_COMPLETION_PERD IN VARCHAR2,
39   X_NOMINATED_COMPLETION_YR IN NUMBER,
40   X_NOMINATED_COMPLETION_PERD IN VARCHAR2,
41   X_RULE_CHECK_IND IN VARCHAR2,
42   X_WAIVE_OPTION_CHECK_IND IN VARCHAR2,
43   X_LAST_RULE_CHECK_DT IN DATE,
44   X_PUBLISH_OUTCOMES_IND IN VARCHAR2,
45   X_COURSE_RQRMNT_COMPLETE_IND IN VARCHAR2,
46   X_COURSE_RQRMNTS_COMPLETE_DT IN DATE,
47   X_S_COMPLETED_SOURCE_TYPE IN VARCHAR2,
48   X_OVERRIDE_TIME_LIMITATION IN NUMBER,
49   X_MODE IN VARCHAR2 DEFAULT 'R',
50   X_LAST_DATE_OF_ATTENDANCE IN DATE DEFAULT NULL,
51   X_DROPPED_BY IN VARCHAR2 DEFAULT NULL,
52   X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL,
53   X_PRIMARY_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
54   X_PRIMARY_PROG_TYPE_SOURCE IN VARCHAR2 DEFAULT NULL,
55   X_CATALOG_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
56   X_CATALOG_SEQ_NUM IN NUMBER DEFAULT NULL,
57   X_KEY_PROGRAM  IN VARCHAR2 DEFAULT NULL,
58   X_MANUAL_OVR_CMPL_DT_IND IN VARCHAR2 DEFAULT 'N',
59   X_OVERRIDE_CMPL_DT IN DATE DEFAULT NULL,
60   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
61   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
62   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
63   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
64   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
65   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
66   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
67   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
68   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
69   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
70   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
71   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
72   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
73   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
74   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
75   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
76   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
77   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
78   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
79   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
80   x_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
81   X_FUTURE_DATED_TRANS_FLAG IN VARCHAR2 DEFAULT NULL
82   );
83 
84 PROCEDURE LOCK_ROW (
85   X_ROWID IN VARCHAR2,
86   X_PERSON_ID IN NUMBER,
87   X_COURSE_CD IN VARCHAR2,
88   X_ADVANCED_STANDING_IND IN VARCHAR2,
89   X_FEE_CAT IN VARCHAR2,
90   X_CORRESPONDENCE_CAT IN VARCHAR2,
91   X_SELF_HELP_GROUP_IND IN VARCHAR2,
92   X_LOGICAL_DELETE_DT IN DATE,
93   X_ADM_ADMISSION_APPL_NUMBER IN NUMBER,
94   X_ADM_NOMINATED_COURSE_CD IN VARCHAR2,
95   X_ADM_SEQUENCE_NUMBER IN NUMBER,
96   X_VERSION_NUMBER IN NUMBER,
97   X_CAL_TYPE IN VARCHAR2,
98   X_LOCATION_CD IN VARCHAR2,
99   X_ATTENDANCE_MODE IN VARCHAR2,
100   X_ATTENDANCE_TYPE IN VARCHAR2,
101   X_COO_ID IN NUMBER,
102   X_STUDENT_CONFIRMED_IND IN VARCHAR2,
103   X_COMMENCEMENT_DT IN DATE,
104   X_COURSE_ATTEMPT_STATUS IN VARCHAR2,
105   X_PROGRESSION_STATUS IN VARCHAR2,
106   X_DERIVED_ATT_TYPE IN VARCHAR2,
107   X_DERIVED_ATT_MODE IN VARCHAR2,
108   X_PROVISIONAL_IND IN VARCHAR2,
109   X_DISCONTINUED_DT IN DATE,
110   X_DISCONTINUATION_REASON_CD IN VARCHAR2,
111   X_LAPSED_DT IN DATE,
112   X_FUNDING_SOURCE IN VARCHAR2,
113   X_EXAM_LOCATION_CD IN VARCHAR2,
114   X_DERIVED_COMPLETION_YR IN NUMBER,
115   X_DERIVED_COMPLETION_PERD IN VARCHAR2,
116   X_NOMINATED_COMPLETION_YR IN NUMBER,
117   X_NOMINATED_COMPLETION_PERD IN VARCHAR2,
118   X_RULE_CHECK_IND IN VARCHAR2,
119   X_WAIVE_OPTION_CHECK_IND IN VARCHAR2,
120   X_LAST_RULE_CHECK_DT IN DATE,
121   X_PUBLISH_OUTCOMES_IND IN VARCHAR2,
122   X_COURSE_RQRMNT_COMPLETE_IND IN VARCHAR2,
123   X_COURSE_RQRMNTS_COMPLETE_DT IN DATE,
124   X_S_COMPLETED_SOURCE_TYPE IN VARCHAR2,
125   X_OVERRIDE_TIME_LIMITATION IN NUMBER,
126   X_LAST_DATE_OF_ATTENDANCE IN DATE DEFAULT NULL,
127   X_DROPPED_BY IN VARCHAR2 DEFAULT NULL,
128   X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL,
129   X_PRIMARY_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
130   X_PRIMARY_PROG_TYPE_SOURCE IN VARCHAR2 DEFAULT NULL,
131   X_CATALOG_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
132   X_CATALOG_SEQ_NUM IN NUMBER DEFAULT NULL,
133   X_KEY_PROGRAM  IN VARCHAR2 DEFAULT NULL,
134   X_MANUAL_OVR_CMPL_DT_IND IN VARCHAR2 DEFAULT 'N',
135   X_OVERRIDE_CMPL_DT IN DATE DEFAULT NULL,
136   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
137   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
138   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
139   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
140   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
141   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
142   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
143   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
144   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
145   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
146   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
147   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
148   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
149   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
150   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
151   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
152   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
153   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
154   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
155   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
156   x_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
157   X_FUTURE_DATED_TRANS_FLAG IN VARCHAR2 DEFAULT NULL
158 );
159 
160 PROCEDURE UPDATE_ROW (
161   X_ROWID IN VARCHAR2,
162   X_PERSON_ID IN NUMBER,
163   X_COURSE_CD IN VARCHAR2,
164   X_ADVANCED_STANDING_IND IN VARCHAR2,
165   X_FEE_CAT IN VARCHAR2,
166   X_CORRESPONDENCE_CAT IN VARCHAR2,
167   X_SELF_HELP_GROUP_IND IN VARCHAR2,
168   X_LOGICAL_DELETE_DT IN DATE,
169   X_ADM_ADMISSION_APPL_NUMBER IN NUMBER,
170   X_ADM_NOMINATED_COURSE_CD IN VARCHAR2,
171   X_ADM_SEQUENCE_NUMBER IN NUMBER,
172   X_VERSION_NUMBER IN NUMBER,
173   X_CAL_TYPE IN VARCHAR2,
174   X_LOCATION_CD IN VARCHAR2,
175   X_ATTENDANCE_MODE IN VARCHAR2,
176   X_ATTENDANCE_TYPE IN VARCHAR2,
177   X_COO_ID IN NUMBER,
178   X_STUDENT_CONFIRMED_IND IN VARCHAR2,
179   X_COMMENCEMENT_DT IN DATE,
180   X_COURSE_ATTEMPT_STATUS IN VARCHAR2,
181   X_PROGRESSION_STATUS IN VARCHAR2,
182   X_DERIVED_ATT_TYPE IN VARCHAR2,
183   X_DERIVED_ATT_MODE IN VARCHAR2,
184   X_PROVISIONAL_IND IN VARCHAR2,
185   X_DISCONTINUED_DT IN DATE,
186   X_DISCONTINUATION_REASON_CD IN VARCHAR2,
187   X_LAPSED_DT IN DATE,
188   X_FUNDING_SOURCE IN VARCHAR2,
189   X_EXAM_LOCATION_CD IN VARCHAR2,
190   X_DERIVED_COMPLETION_YR IN NUMBER,
191   X_DERIVED_COMPLETION_PERD IN VARCHAR2,
192   X_NOMINATED_COMPLETION_YR IN NUMBER,
193   X_NOMINATED_COMPLETION_PERD IN VARCHAR2,
194   X_RULE_CHECK_IND IN VARCHAR2,
195   X_WAIVE_OPTION_CHECK_IND IN VARCHAR2,
196   X_LAST_RULE_CHECK_DT IN DATE,
197   X_PUBLISH_OUTCOMES_IND IN VARCHAR2,
198   X_COURSE_RQRMNT_COMPLETE_IND IN VARCHAR2,
199   X_COURSE_RQRMNTS_COMPLETE_DT IN DATE,
200   X_S_COMPLETED_SOURCE_TYPE IN VARCHAR2,
201   X_OVERRIDE_TIME_LIMITATION IN NUMBER,
202   X_MODE IN VARCHAR2 DEFAULT 'R',
203   X_LAST_DATE_OF_ATTENDANCE IN DATE DEFAULT NULL,
204   X_DROPPED_BY IN VARCHAR2 DEFAULT NULL,
205   X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL,
206   X_PRIMARY_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
207   X_PRIMARY_PROG_TYPE_SOURCE IN VARCHAR2 DEFAULT NULL,
208   X_CATALOG_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
209   X_CATALOG_SEQ_NUM IN NUMBER DEFAULT NULL ,
210   X_KEY_PROGRAM  IN VARCHAR2 DEFAULT NULL,
211   X_MANUAL_OVR_CMPL_DT_IND IN VARCHAR2 DEFAULT 'N',
212   X_OVERRIDE_CMPL_DT IN DATE DEFAULT NULL,
213   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
214   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
215   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
216   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
217   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
218   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
219   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
220   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
221   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
222   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
223   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
224   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
225   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
226   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
227   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
228   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
229   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
230   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
231   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
232   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
233   x_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
234   X_FUTURE_DATED_TRANS_FLAG IN VARCHAR2 DEFAULT NULL
235   );
236 
237 PROCEDURE ADD_ROW (
238   X_ROWID IN OUT NOCOPY VARCHAR2,
239   X_ORG_ID IN NUMBER,
240   X_PERSON_ID IN NUMBER,
241   X_COURSE_CD IN VARCHAR2,
242   X_ADVANCED_STANDING_IND IN VARCHAR2,
243   X_FEE_CAT IN VARCHAR2,
244   X_CORRESPONDENCE_CAT IN VARCHAR2,
245   X_SELF_HELP_GROUP_IND IN VARCHAR2,
246   X_LOGICAL_DELETE_DT IN DATE,
247   X_ADM_ADMISSION_APPL_NUMBER IN NUMBER,
248   X_ADM_NOMINATED_COURSE_CD IN VARCHAR2,
249   X_ADM_SEQUENCE_NUMBER IN NUMBER,
250   X_VERSION_NUMBER IN NUMBER,
251   X_CAL_TYPE IN VARCHAR2,
252   X_LOCATION_CD IN VARCHAR2,
253   X_ATTENDANCE_MODE IN VARCHAR2,
254   X_ATTENDANCE_TYPE IN VARCHAR2,
255   X_COO_ID IN NUMBER,
256   X_STUDENT_CONFIRMED_IND IN VARCHAR2,
257   X_COMMENCEMENT_DT IN DATE,
258   X_COURSE_ATTEMPT_STATUS IN VARCHAR2,
259   X_PROGRESSION_STATUS IN VARCHAR2,
260   X_DERIVED_ATT_TYPE IN VARCHAR2,
261   X_DERIVED_ATT_MODE IN VARCHAR2,
262   X_PROVISIONAL_IND IN VARCHAR2,
263   X_DISCONTINUED_DT IN DATE,
264   X_DISCONTINUATION_REASON_CD IN VARCHAR2,
265   X_LAPSED_DT IN DATE,
266   X_FUNDING_SOURCE IN VARCHAR2,
267   X_EXAM_LOCATION_CD IN VARCHAR2,
268   X_DERIVED_COMPLETION_YR IN NUMBER,
269   X_DERIVED_COMPLETION_PERD IN VARCHAR2,
270   X_NOMINATED_COMPLETION_YR IN NUMBER,
271   X_NOMINATED_COMPLETION_PERD IN VARCHAR2,
272   X_RULE_CHECK_IND IN VARCHAR2,
273   X_WAIVE_OPTION_CHECK_IND IN VARCHAR2,
274   X_LAST_RULE_CHECK_DT IN DATE,
275   X_PUBLISH_OUTCOMES_IND IN VARCHAR2,
276   X_COURSE_RQRMNT_COMPLETE_IND IN VARCHAR2,
277   X_COURSE_RQRMNTS_COMPLETE_DT IN DATE,
278   X_S_COMPLETED_SOURCE_TYPE IN VARCHAR2,
279   X_OVERRIDE_TIME_LIMITATION IN NUMBER,
280   X_MODE IN VARCHAR2 DEFAULT 'R',
281   X_LAST_DATE_OF_ATTENDANCE IN DATE DEFAULT NULL,
282   X_DROPPED_BY IN VARCHAR2 DEFAULT NULL,
283   X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL,
284   X_PRIMARY_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
285   X_PRIMARY_PROG_TYPE_SOURCE IN VARCHAR2 DEFAULT NULL,
286   X_CATALOG_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
287   X_CATALOG_SEQ_NUM IN NUMBER DEFAULT NULL ,
288   X_KEY_PROGRAM  IN VARCHAR2 DEFAULT NULL,
289   X_MANUAL_OVR_CMPL_DT_IND IN VARCHAR2 DEFAULT 'N',
290   X_OVERRIDE_CMPL_DT IN DATE DEFAULT NULL,
291   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
292   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
293   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
294   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
295   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
296   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
297   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
298   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
299   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
300   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
301   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
302   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
303   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
304   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
305   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
306   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
307   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
308   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
309   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
310   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
311   x_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
312   X_FUTURE_DATED_TRANS_FLAG IN VARCHAR2 DEFAULT NULL
313   );
314 
315 PROCEDURE DELETE_ROW (
316   X_ROWID IN VARCHAR2,
317   x_mode IN VARCHAR2 DEFAULT 'R'
318   );
319 
320   FUNCTION Get_PK_For_Validation (
321     x_person_id IN NUMBER,
322     x_course_cd IN VARCHAR2
323     )
324     RETURN BOOLEAN ;
325 
326   PROCEDURE GET_FK_IGS_LOOKUPS_VIEW_Prog (
327     x_progression_status IN VARCHAR2
328     );
329 
330   PROCEDURE GET_FK_IGS_EN_ATD_MODE (
331     x_attendance_mode IN VARCHAR2
332     );
333 
334   PROCEDURE GET_FK_IGS_LOOKUPS_VIEW_CAS (
335     x_course_attempt_status IN VARCHAR2
336     );
337 
338   PROCEDURE GET_FK_IGS_AD_PS_APPL_INST (
339     x_person_id IN NUMBER,
340     x_admission_appl_number IN NUMBER,
341     x_nominated_course_cd IN VARCHAR2,
342     x_sequence_number IN NUMBER
343     );
344 
345   PROCEDURE GET_FK_IGS_EN_ATD_TYPE (
346     x_attendance_type IN VARCHAR2
347     );
348 
349   PROCEDURE GET_FK_IGS_CO_CAT (
350     x_correspondence_cat IN VARCHAR2
351     );
352 
353   PROCEDURE GET_FK_IGS_PS_OFR_OPT (
354     x_course_cd IN VARCHAR2,
355     x_version_number IN NUMBER,
356     x_cal_type IN VARCHAR2,
357     x_location_cd IN VARCHAR2,
358     x_attendance_mode IN VARCHAR2,
359     x_attendance_type IN VARCHAR2
360     );
361 
362   PROCEDURE GET_UFK_IGS_PS_OFR_OPT (
363     x_coo_id IN NUMBER
364     );
365 
366    PROCEDURE GET_FK_IGS_PS_COURSE (
367     x_course_cd IN VARCHAR2
368     );
369 
370   PROCEDURE GET_FK_IGS_PS_VER (
371     x_course_cd IN VARCHAR2,
372     x_version_number IN NUMBER
373     );
374 
375 
376   PROCEDURE GET_FK_IGS_FI_FEE_CAT (
377     x_fee_cat IN VARCHAR2
378     );
379 
380   PROCEDURE GET_FK_IGS_FI_FUND_SRC (
381     x_funding_source IN VARCHAR2
382     );
383 
384   PROCEDURE GET_FK_IGS_AD_LOCATION (
385     x_location_cd IN VARCHAR2
386     );
387 
388   PROCEDURE GET_FK_IGS_PE_PERSON (
389     x_person_id IN NUMBER
390     );
391 
392 -- added as part of Enroll process Build for class standing dld
393 -- amuthu 30-JUL-2001
394   PROCEDURE GET_FK_IGS_PR_CLASS_STD(
395     X_IGS_PR_CLASS_STD_ID IN NUMBER
396   );
397 
398 -- added as part of  Career Impact Build
399 -- amuthu 30-JUL-2001
400   PROCEDURE GET_FK_IGS_CA_INST (
401     X_CATALOG_CAL_TYPE IN VARCHAR2,
402     X_CATALOG_SEQ_NUM IN NUMBER
403     ) ;
404 
405 
406 PROCEDURE Check_constraints(
407 	column_name IN VARCHAR2 DEFAULT NULL,
408 	column_value IN VARCHAR2 DEFAULT NULL
409    );
410 PROCEDURE Before_DML (
411     p_action IN VARCHAR2,
412     x_rowid IN VARCHAR2 DEFAULT NULL,
413     X_ORG_ID IN NUMBER DEFAULT NULL,
414     x_person_id IN NUMBER DEFAULT NULL,
415     x_course_cd IN VARCHAR2 DEFAULT NULL,
416     x_version_number IN NUMBER DEFAULT NULL,
417     x_cal_type IN VARCHAR2 DEFAULT NULL,
421     x_coo_id IN NUMBER DEFAULT NULL,
418     x_location_cd IN VARCHAR2 DEFAULT NULL,
419     x_attendance_mode IN VARCHAR2 DEFAULT NULL,
420     x_attendance_type IN VARCHAR2 DEFAULT NULL,
422     x_student_confirmed_ind IN VARCHAR2 DEFAULT NULL,
423     x_commencement_dt IN DATE DEFAULT NULL,
424     x_course_attempt_status IN VARCHAR2 DEFAULT NULL,
425     x_progression_status IN VARCHAR2 DEFAULT NULL,
426     x_derived_att_type IN VARCHAR2 DEFAULT NULL,
427     x_derived_att_mode IN VARCHAR2 DEFAULT NULL,
428     x_provisional_ind IN VARCHAR2 DEFAULT NULL,
429     x_discontinued_dt IN DATE DEFAULT NULL,
430     x_discontinuation_reason_cd IN VARCHAR2 DEFAULT NULL,
431     x_lapsed_dt IN DATE DEFAULT NULL,
432     x_funding_source IN VARCHAR2 DEFAULT NULL,
433     x_exam_location_cd IN VARCHAR2 DEFAULT NULL,
434     x_derived_completion_yr IN NUMBER DEFAULT NULL,
435     x_derived_completion_perd IN VARCHAR2 DEFAULT NULL,
436     x_nominated_completion_yr IN NUMBER DEFAULT NULL,
437     x_nominated_completion_perd IN VARCHAR2 DEFAULT NULL,
438     x_rule_check_ind IN VARCHAR2 DEFAULT NULL,
439     x_waive_option_check_ind IN VARCHAR2 DEFAULT NULL,
440     x_last_rule_check_dt IN DATE DEFAULT NULL,
441     x_publish_outcomes_ind IN VARCHAR2 DEFAULT NULL,
442     x_course_rqrmnt_complete_ind IN VARCHAR2 DEFAULT NULL,
443     x_course_rqrmnts_complete_dt IN DATE DEFAULT NULL,
444     x_s_completed_source_type IN VARCHAR2 DEFAULT NULL,
445     x_override_time_limitation IN NUMBER DEFAULT NULL,
446     x_advanced_standing_ind IN VARCHAR2 DEFAULT NULL,
447     x_fee_cat IN VARCHAR2 DEFAULT NULL,
448     x_correspondence_cat IN VARCHAR2 DEFAULT NULL,
449     x_self_help_group_ind IN VARCHAR2 DEFAULT NULL,
450     x_logical_delete_dt IN DATE DEFAULT NULL,
451     x_adm_admission_appl_number IN NUMBER DEFAULT NULL,
452     x_adm_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
453     x_adm_sequence_number IN NUMBER DEFAULT NULL,
454     x_creation_date IN DATE DEFAULT NULL,
455     x_created_by IN NUMBER DEFAULT NULL,
456     x_last_update_date IN DATE DEFAULT NULL,
457     x_last_updated_by IN NUMBER DEFAULT NULL,
458     x_last_update_login IN NUMBER DEFAULT NULL,
459     X_LAST_DATE_OF_ATTENDANCE IN DATE DEFAULT NULL,
460     X_DROPPED_BY IN VARCHAR2 DEFAULT NULL,
461     X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL,
462     X_PRIMARY_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
463     X_PRIMARY_PROG_TYPE_SOURCE IN VARCHAR2 DEFAULT NULL,
464     X_CATALOG_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
465     X_CATALOG_SEQ_NUM IN NUMBER DEFAULT NULL,
466     X_KEY_PROGRAM  IN VARCHAR2 DEFAULT NULL,
467     X_MANUAL_OVR_CMPL_DT_IND IN VARCHAR2 DEFAULT 'N',
468     X_OVERRIDE_CMPL_DT IN DATE DEFAULT NULL,
469   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
470   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
471   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
472   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
473   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
474   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
475   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
476   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
477   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
478   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
479   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
480   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
481   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
482   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
483   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
484   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
485   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
486   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
487   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
488   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
489   x_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
490   X_FUTURE_DATED_TRANS_FLAG IN VARCHAR2 DEFAULT NULL
491   );
492 
493 END IGS_EN_STDNT_PS_ATT_PKG;