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_AS_SC_ATTEMPT_H_PKG

Source


1 package IGS_AS_SC_ATTEMPT_H_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSDI19S.pls 115.9 2003/12/04 13:05:25 rvangala ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_ORG_ID in NUMBER,
7   X_PERSON_ID in NUMBER,
8   X_COURSE_CD in VARCHAR2,
9   X_HIST_START_DT in DATE,
10   X_HIST_END_DT in DATE,
11   X_HIST_WHO in NUMBER,
12   X_VERSION_NUMBER in NUMBER,
13   X_CAL_TYPE in VARCHAR2,
14   X_LOCATION_CD in VARCHAR2,
15   X_ATTENDANCE_MODE in VARCHAR2,
16   X_ATTENDANCE_TYPE in VARCHAR2,
17   X_STUDENT_CONFIRMED_IND in VARCHAR2,
18   X_COMMENCEMENT_DT in DATE,
19   X_COURSE_ATTEMPT_STATUS in VARCHAR2,
20   X_PROGRESSION_STATUS in VARCHAR2,
21   X_DERIVED_ATT_TYPE in VARCHAR2,
22   X_DERIVED_ATT_MODE in VARCHAR2,
23   X_PROVISIONAL_IND in VARCHAR2,
24   X_DISCONTINUED_DT in DATE,
25   X_DISCONTINUATION_REASON_CD in VARCHAR2,
26   X_LAPSED_DT in DATE,
27   X_FUNDING_SOURCE in VARCHAR2,
28   X_FS_DESCRIPTION in VARCHAR2,
29   X_EXAM_LOCATION_CD in VARCHAR2,
30   X_ELO_DESCRIPTION in VARCHAR2,
31   X_DERIVED_COMPLETION_YR in NUMBER,
32   X_DERIVED_COMPLETION_PERD in VARCHAR2,
33   X_NOMINATED_COMPLETION_YR in NUMBER,
34   X_NOMINATED_COMPLETION_PERD in VARCHAR2,
35   X_RULE_CHECK_IND in VARCHAR2,
36   X_WAIVE_OPTION_CHECK_IND in VARCHAR2,
37   X_LAST_RULE_CHECK_DT in DATE,
38   X_PUBLISH_OUTCOMES_IND in VARCHAR2,
39   X_COURSE_RQRMNT_COMPLETE_IND in VARCHAR2,
40   X_COURSE_RQRMNTS_COMPLETE_DT in DATE,
41   X_S_COMPLETED_SOURCE_TYPE in VARCHAR2,
42   X_OVERRIDE_TIME_LIMITATION in NUMBER,
43   X_ADVANCED_STANDING_IND in VARCHAR2,
44   X_FEE_CAT in VARCHAR2,
45   X_FC_DESCRIPTION in VARCHAR2,
46   X_CORRESPONDENCE_CAT in VARCHAR2,
47   X_CC_DESCRIPTION in VARCHAR2,
48   X_SELF_HELP_GROUP_IND in VARCHAR2,
49   X_ADM_ADMISSION_APPL_NUMBER in NUMBER,
50   X_ADM_NOMINATED_COURSE_CD in VARCHAR2,
51   X_ADM_SEQUENCE_NUMBER in NUMBER,
52   X_MODE in VARCHAR2 default 'R',
53   X_LAST_DATE_OF_ATTENDANCE in DATE DEFAULT NULL,
54   X_DROPPED_BY in VARCHAR2 DEFAULT NULL,
55   X_PRIMARY_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
56   X_PRIMARY_PROG_TYPE_SOURCE IN VARCHAR2 DEFAULT NULL,
57   X_CATALOG_CAL_TYPE  IN VARCHAR2 DEFAULT NULL,
58   X_CATALOG_SEQ_NUM IN NUMBER DEFAULT NULL,
59   X_KEY_PROGRAM  IN VARCHAR2  DEFAULT 'N',
60   X_OVERRIDE_CMPL_DT  IN DATE DEFAULT NULL,
61   X_MANUAL_OVR_CMPL_DT_IND  IN VARCHAR2 DEFAULT 'N',
62   X_COO_ID IN NUMBER DEFAULT NULL,
63   X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
64   );
65 procedure LOCK_ROW (
66   X_ROWID in VARCHAR2,
67   X_PERSON_ID in NUMBER,
68   X_COURSE_CD in VARCHAR2,
69   X_HIST_START_DT in DATE,
70   X_HIST_END_DT in DATE,
71   X_HIST_WHO in NUMBER,
72   X_VERSION_NUMBER in NUMBER,
73   X_CAL_TYPE in VARCHAR2,
74   X_LOCATION_CD in VARCHAR2,
75   X_ATTENDANCE_MODE in VARCHAR2,
76   X_ATTENDANCE_TYPE in VARCHAR2,
77   X_STUDENT_CONFIRMED_IND in VARCHAR2,
78   X_COMMENCEMENT_DT in DATE,
79   X_COURSE_ATTEMPT_STATUS in VARCHAR2,
80   X_PROGRESSION_STATUS in VARCHAR2,
81   X_DERIVED_ATT_TYPE in VARCHAR2,
82   X_DERIVED_ATT_MODE in VARCHAR2,
83   X_PROVISIONAL_IND in VARCHAR2,
84   X_DISCONTINUED_DT in DATE,
85   X_DISCONTINUATION_REASON_CD in VARCHAR2,
86   X_LAPSED_DT in DATE,
87   X_FUNDING_SOURCE in VARCHAR2,
88   X_FS_DESCRIPTION in VARCHAR2,
89   X_EXAM_LOCATION_CD in VARCHAR2,
90   X_ELO_DESCRIPTION in VARCHAR2,
91   X_DERIVED_COMPLETION_YR in NUMBER,
92   X_DERIVED_COMPLETION_PERD in VARCHAR2,
93   X_NOMINATED_COMPLETION_YR in NUMBER,
94   X_NOMINATED_COMPLETION_PERD in VARCHAR2,
95   X_RULE_CHECK_IND in VARCHAR2,
96   X_WAIVE_OPTION_CHECK_IND in VARCHAR2,
97   X_LAST_RULE_CHECK_DT in DATE,
98   X_PUBLISH_OUTCOMES_IND in VARCHAR2,
99   X_COURSE_RQRMNT_COMPLETE_IND in VARCHAR2,
100   X_COURSE_RQRMNTS_COMPLETE_DT in DATE,
101   X_S_COMPLETED_SOURCE_TYPE in VARCHAR2,
102   X_OVERRIDE_TIME_LIMITATION in NUMBER,
103   X_ADVANCED_STANDING_IND in VARCHAR2,
104   X_FEE_CAT in VARCHAR2,
105   X_FC_DESCRIPTION in VARCHAR2,
106   X_CORRESPONDENCE_CAT in VARCHAR2,
107   X_CC_DESCRIPTION in VARCHAR2,
108   X_SELF_HELP_GROUP_IND in VARCHAR2,
109   X_ADM_ADMISSION_APPL_NUMBER in NUMBER,
110   X_ADM_NOMINATED_COURSE_CD in VARCHAR2,
111   X_ADM_SEQUENCE_NUMBER in NUMBER,
112   X_LAST_DATE_OF_ATTENDANCE in DATE DEFAULT NULL,
113   X_DROPPED_BY in VARCHAR2 DEFAULT NULL,
114   X_PRIMARY_PROGRAM_TYPE  IN VARCHAR2 DEFAULT NULL,
115   X_PRIMARY_PROG_TYPE_SOURCE  IN VARCHAR2 DEFAULT NULL,
116   X_CATALOG_CAL_TYPE  IN VARCHAR2 DEFAULT  NULL,
117   X_CATALOG_SEQ_NUM  IN NUMBER DEFAULT NULL,
118   X_KEY_PROGRAM  IN VARCHAR2 DEFAULT 'N' ,
119   X_OVERRIDE_CMPL_DT  IN DATE DEFAULT NULL,
120   X_MANUAL_OVR_CMPL_DT_IND  IN VARCHAR2 DEFAULT 'N',
121   X_COO_ID IN NUMBER DEFAULT NULL,
122   X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
123 );
124 procedure UPDATE_ROW (
125   X_ROWID in VARCHAR2,
126   X_PERSON_ID in NUMBER,
127   X_COURSE_CD in VARCHAR2,
128   X_HIST_START_DT in DATE,
129   X_HIST_END_DT in DATE,
130   X_HIST_WHO in NUMBER,
131   X_VERSION_NUMBER in NUMBER,
132   X_CAL_TYPE in VARCHAR2,
133   X_LOCATION_CD in VARCHAR2,
134   X_ATTENDANCE_MODE in VARCHAR2,
135   X_ATTENDANCE_TYPE in VARCHAR2,
136   X_STUDENT_CONFIRMED_IND in VARCHAR2,
137   X_COMMENCEMENT_DT in DATE,
138   X_COURSE_ATTEMPT_STATUS in VARCHAR2,
139   X_PROGRESSION_STATUS in VARCHAR2,
140   X_DERIVED_ATT_TYPE in VARCHAR2,
141   X_DERIVED_ATT_MODE in VARCHAR2,
142   X_PROVISIONAL_IND in VARCHAR2,
143   X_DISCONTINUED_DT in DATE,
144   X_DISCONTINUATION_REASON_CD in VARCHAR2,
145   X_LAPSED_DT in DATE,
146   X_FUNDING_SOURCE in VARCHAR2,
147   X_FS_DESCRIPTION in VARCHAR2,
148   X_EXAM_LOCATION_CD in VARCHAR2,
149   X_ELO_DESCRIPTION in VARCHAR2,
150   X_DERIVED_COMPLETION_YR in NUMBER,
151   X_DERIVED_COMPLETION_PERD in VARCHAR2,
152   X_NOMINATED_COMPLETION_YR in NUMBER,
153   X_NOMINATED_COMPLETION_PERD in VARCHAR2,
154   X_RULE_CHECK_IND in VARCHAR2,
155   X_WAIVE_OPTION_CHECK_IND in VARCHAR2,
156   X_LAST_RULE_CHECK_DT in DATE,
157   X_PUBLISH_OUTCOMES_IND in VARCHAR2,
158   X_COURSE_RQRMNT_COMPLETE_IND in VARCHAR2,
159   X_COURSE_RQRMNTS_COMPLETE_DT in DATE,
160   X_S_COMPLETED_SOURCE_TYPE in VARCHAR2,
161   X_OVERRIDE_TIME_LIMITATION in NUMBER,
162   X_ADVANCED_STANDING_IND in VARCHAR2,
163   X_FEE_CAT in VARCHAR2,
164   X_FC_DESCRIPTION in VARCHAR2,
165   X_CORRESPONDENCE_CAT in VARCHAR2,
166   X_CC_DESCRIPTION in VARCHAR2,
167   X_SELF_HELP_GROUP_IND in VARCHAR2,
168   X_ADM_ADMISSION_APPL_NUMBER in NUMBER,
169   X_ADM_NOMINATED_COURSE_CD in VARCHAR2,
170   X_ADM_SEQUENCE_NUMBER in NUMBER,
171   X_MODE in VARCHAR2 default 'R',
172   X_LAST_DATE_OF_ATTENDANCE in DATE DEFAULT NULL,
173   X_DROPPED_BY in VARCHAR2 DEFAULT NULL,
174   X_PRIMARY_PROGRAM_TYPE  IN VARCHAR2 DEFAULT NULL,
175   X_PRIMARY_PROG_TYPE_SOURCE  IN VARCHAR2 DEFAULT NULL,
176   X_CATALOG_CAL_TYPE  IN VARCHAR2 DEFAULT NULL,
177   X_CATALOG_SEQ_NUM  IN NUMBER DEFAULT NULL,
178   X_KEY_PROGRAM   IN VARCHAR2 DEFAULT 'N',
179   X_OVERRIDE_CMPL_DT  IN DATE DEFAULT NULL,
180   X_MANUAL_OVR_CMPL_DT_IND  IN VARCHAR2 DEFAULT 'N',
181   X_COO_ID IN NUMBER DEFAULT NULL,
182   X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
183   );
184 procedure ADD_ROW (
185   X_ROWID in out NOCOPY VARCHAR2,
186   X_ORG_ID in NUMBER,
187   X_PERSON_ID in NUMBER,
188   X_COURSE_CD in VARCHAR2,
189   X_HIST_START_DT in DATE,
190   X_HIST_END_DT in DATE,
191   X_HIST_WHO in NUMBER,
192   X_VERSION_NUMBER in NUMBER,
193   X_CAL_TYPE in VARCHAR2,
194   X_LOCATION_CD in VARCHAR2,
195   X_ATTENDANCE_MODE in VARCHAR2,
196   X_ATTENDANCE_TYPE in VARCHAR2,
197   X_STUDENT_CONFIRMED_IND in VARCHAR2,
198   X_COMMENCEMENT_DT in DATE,
199   X_COURSE_ATTEMPT_STATUS in VARCHAR2,
200   X_PROGRESSION_STATUS in VARCHAR2,
201   X_DERIVED_ATT_TYPE in VARCHAR2,
202   X_DERIVED_ATT_MODE in VARCHAR2,
203   X_PROVISIONAL_IND in VARCHAR2,
204   X_DISCONTINUED_DT in DATE,
205   X_DISCONTINUATION_REASON_CD in VARCHAR2,
206   X_LAPSED_DT in DATE,
207   X_FUNDING_SOURCE in VARCHAR2,
208   X_FS_DESCRIPTION in VARCHAR2,
209   X_EXAM_LOCATION_CD in VARCHAR2,
210   X_ELO_DESCRIPTION in VARCHAR2,
211   X_DERIVED_COMPLETION_YR in NUMBER,
212   X_DERIVED_COMPLETION_PERD in VARCHAR2,
213   X_NOMINATED_COMPLETION_YR in NUMBER,
214   X_NOMINATED_COMPLETION_PERD in VARCHAR2,
215   X_RULE_CHECK_IND in VARCHAR2,
216   X_WAIVE_OPTION_CHECK_IND in VARCHAR2,
217   X_LAST_RULE_CHECK_DT in DATE,
218   X_PUBLISH_OUTCOMES_IND in VARCHAR2,
219   X_COURSE_RQRMNT_COMPLETE_IND in VARCHAR2,
220   X_COURSE_RQRMNTS_COMPLETE_DT in DATE,
221   X_S_COMPLETED_SOURCE_TYPE in VARCHAR2,
222   X_OVERRIDE_TIME_LIMITATION in NUMBER,
223   X_ADVANCED_STANDING_IND in VARCHAR2,
224   X_FEE_CAT in VARCHAR2,
225   X_FC_DESCRIPTION in VARCHAR2,
226   X_CORRESPONDENCE_CAT in VARCHAR2,
227   X_CC_DESCRIPTION in VARCHAR2,
228   X_SELF_HELP_GROUP_IND in VARCHAR2,
229   X_ADM_ADMISSION_APPL_NUMBER in NUMBER,
230   X_ADM_NOMINATED_COURSE_CD in VARCHAR2,
231   X_ADM_SEQUENCE_NUMBER in NUMBER,
232   X_MODE in VARCHAR2 default 'R',
233   X_LAST_DATE_OF_ATTENDANCE in DATE DEFAULT NULL,
234   X_DROPPED_BY in VARCHAR2 DEFAULT NULL,
235   X_PRIMARY_PROGRAM_TYPE  IN VARCHAR2 DEFAULT NULL,
236   X_PRIMARY_PROG_TYPE_SOURCE  IN VARCHAR2 DEFAULT NULL,
237   X_CATALOG_CAL_TYPE  IN VARCHAR2 DEFAULT NULL,
238   X_CATALOG_SEQ_NUM IN NUMBER DEFAULT NULL,
239   X_KEY_PROGRAM  IN VARCHAR2 DEFAULT 'N' ,
240   X_OVERRIDE_CMPL_DT  IN DATE DEFAULT NULL,
241   X_MANUAL_OVR_CMPL_DT_IND  IN VARCHAR2 DEFAULT 'N',
242   X_COO_ID IN NUMBER DEFAULT NULL,
243   X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
244   );
245 procedure DELETE_ROW (
246   X_ROWID in VARCHAR2
247   );
248 
249 FUNCTION Get_PK_For_Validation (
250     x_person_id IN NUMBER,
251     x_course_cd IN VARCHAR2,
252     x_hist_start_dt IN DATE
253     ) RETURN BOOLEAN;
254 
255  PROCEDURE Check_Constraints (
256  	Column_Name	IN	VARCHAR2	DEFAULT NULL,
257  	Column_Value 	IN	VARCHAR2	DEFAULT NULL
258  );
259 
260 PROCEDURE Before_DML (
261     p_action IN VARCHAR2,
262     x_rowid IN VARCHAR2 DEFAULT NULL,
263     x_org_id in NUMBER DEFAULT NULL,
264     x_progression_status IN VARCHAR2 DEFAULT NULL,
265     x_derived_att_type IN VARCHAR2 DEFAULT NULL,
266     x_derived_att_mode IN VARCHAR2 DEFAULT NULL,
267     x_provisional_ind IN VARCHAR2 DEFAULT NULL,
268     x_discontinued_dt IN DATE DEFAULT NULL,
269     x_discontinuation_reason_cd IN VARCHAR2 DEFAULT NULL,
270     x_lapsed_dt IN DATE DEFAULT NULL,
271     x_funding_source IN VARCHAR2 DEFAULT NULL,
272     x_fs_description IN VARCHAR2 DEFAULT NULL,
273     x_exam_location_cd IN VARCHAR2 DEFAULT NULL,
274     x_elo_description IN VARCHAR2 DEFAULT NULL,
275     x_derived_completion_yr IN NUMBER DEFAULT NULL,
276     x_derived_completion_perd IN VARCHAR2 DEFAULT NULL,
277     x_nominated_completion_yr IN NUMBER DEFAULT NULL,
278     x_nominated_completion_perd IN VARCHAR2 DEFAULT NULL,
279     x_rule_check_ind IN VARCHAR2 DEFAULT NULL,
280     x_waive_option_check_ind IN VARCHAR2 DEFAULT NULL,
281     x_last_rule_check_dt IN DATE DEFAULT NULL,
282     x_publish_outcomes_ind IN VARCHAR2 DEFAULT NULL,
283     x_course_rqrmnt_complete_ind IN VARCHAR2 DEFAULT NULL,
284     x_course_rqrmnts_complete_dt IN DATE DEFAULT NULL,
285     x_s_completed_source_type IN VARCHAR2 DEFAULT NULL,
286     x_override_time_limitation IN NUMBER DEFAULT NULL,
287     x_advanced_standing_ind IN VARCHAR2 DEFAULT NULL,
288     x_fee_cat IN VARCHAR2 DEFAULT NULL,
289     x_fc_description IN VARCHAR2 DEFAULT NULL,
290     x_correspondence_cat IN VARCHAR2 DEFAULT NULL,
291     x_cc_description IN VARCHAR2 DEFAULT NULL,
292     x_self_help_group_ind IN VARCHAR2 DEFAULT NULL,
293     x_adm_admission_appl_number IN NUMBER DEFAULT NULL,
294     x_adm_nominated_course_cd IN VARCHAR2 DEFAULT NULL,
295     x_adm_sequence_number IN NUMBER DEFAULT NULL,
296     x_person_id IN NUMBER DEFAULT NULL,
297     x_course_cd IN VARCHAR2 DEFAULT NULL,
298     x_hist_start_dt IN DATE DEFAULT NULL,
299     x_hist_end_dt IN DATE DEFAULT NULL,
300     x_hist_who IN NUMBER DEFAULT NULL,
301     x_version_number IN NUMBER DEFAULT NULL,
302     x_cal_type IN VARCHAR2 DEFAULT NULL,
303     x_location_cd IN VARCHAR2 DEFAULT NULL,
304     x_attendance_mode IN VARCHAR2 DEFAULT NULL,
305     x_attendance_type IN VARCHAR2 DEFAULT NULL,
306     x_student_confirmed_ind IN VARCHAR2 DEFAULT NULL,
307     x_commencement_dt IN DATE DEFAULT NULL,
308     x_course_attempt_status IN VARCHAR2 DEFAULT NULL,
309     x_creation_date IN DATE DEFAULT NULL,
310     x_created_by IN NUMBER DEFAULT NULL,
311     x_last_update_date IN DATE DEFAULT NULL,
312     x_last_updated_by IN NUMBER DEFAULT NULL,
313     x_last_update_login IN NUMBER DEFAULT NULL,
314     X_LAST_DATE_OF_ATTENDANCE in DATE DEFAULT NULL,
315     X_DROPPED_BY in VARCHAR2 DEFAULT NULL,
316     X_PRIMARY_PROGRAM_TYPE  IN VARCHAR2 DEFAULT NULL,
317     X_PRIMARY_PROG_TYPE_SOURCE  IN VARCHAR2 DEFAULT NULL,
318     X_CATALOG_CAL_TYPE  IN VARCHAR2 DEFAULT NULL,
319     X_CATALOG_SEQ_NUM  IN NUMBER DEFAULT NULL,
320     X_KEY_PROGRAM  IN VARCHAR2 DEFAULT 'N' ,
321     X_OVERRIDE_CMPL_DT  IN DATE DEFAULT NULL,
322     X_MANUAL_OVR_CMPL_DT_IND  IN VARCHAR2 DEFAULT 'N',
323     X_COO_ID IN NUMBER DEFAULT NULL,
324     X_IGS_PR_CLASS_STD_ID IN NUMBER DEFAULT NULL
325   );
326 
327 
328 end IGS_AS_SC_ATTEMPT_H_PKG;