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_SU_SETATMPT_PKG

Source


1 PACKAGE  IGS_AS_SU_SETATMPT_PKG AS
2 /* $Header: IGSDI29S.pls 120.1 2006/05/29 07:52:36 sarakshi noship $ */
3 
4 PROCEDURE INSERT_ROW (
5   X_ROWID IN OUT NOCOPY VARCHAR2,
6   X_PERSON_ID IN NUMBER,
7   X_COURSE_CD IN VARCHAR2,
8   X_UNIT_SET_CD IN VARCHAR2,
9   X_SEQUENCE_NUMBER IN NUMBER,
10   X_US_VERSION_NUMBER IN NUMBER,
11   X_SELECTION_DT IN DATE,
12   X_STUDENT_CONFIRMED_IND IN VARCHAR2,
13   X_END_DT IN DATE,
14   X_PARENT_UNIT_SET_CD IN VARCHAR2,
15   X_PARENT_SEQUENCE_NUMBER IN NUMBER,
16   X_PRIMARY_SET_IND IN VARCHAR2,
17   X_VOLUNTARY_END_IND IN VARCHAR2,
18   X_AUTHORISED_PERSON_ID IN NUMBER,
19   X_AUTHORISED_ON IN DATE,
20   X_OVERRIDE_TITLE IN VARCHAR2,
21   X_RQRMNTS_COMPLETE_IND IN VARCHAR2,
22   X_RQRMNTS_COMPLETE_DT IN DATE,
23   X_S_COMPLETED_SOURCE_TYPE IN VARCHAR2,
24   X_CATALOG_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
25   X_CATALOG_SEQ_NUM IN NUMBER DEFAULT NULL,
26   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
27   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
28   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
29   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
30   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
31   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
32   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
33   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
34   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
35   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
36   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
37   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
38   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
39   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
40   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
41   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
42   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
43   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
44   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
45   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
46   X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
47   X_MODE IN VARCHAR2 DEFAULT 'R'
48   );
49 PROCEDURE LOCK_ROW (
50   X_ROWID IN VARCHAR2,
51   X_PERSON_ID IN NUMBER,
52   X_COURSE_CD IN VARCHAR2,
53   X_UNIT_SET_CD IN VARCHAR2,
54   X_SEQUENCE_NUMBER IN NUMBER,
55   X_US_VERSION_NUMBER IN NUMBER,
56   X_SELECTION_DT IN DATE,
57   X_STUDENT_CONFIRMED_IND IN VARCHAR2,
58   X_END_DT IN DATE,
59   X_PARENT_UNIT_SET_CD IN VARCHAR2,
60   X_PARENT_SEQUENCE_NUMBER IN NUMBER,
61   X_PRIMARY_SET_IND IN VARCHAR2,
62   X_VOLUNTARY_END_IND IN VARCHAR2,
63   X_AUTHORISED_PERSON_ID IN NUMBER,
64   X_AUTHORISED_ON IN DATE,
65   X_OVERRIDE_TITLE IN VARCHAR2,
66   X_RQRMNTS_COMPLETE_IND IN VARCHAR2,
67   X_RQRMNTS_COMPLETE_DT IN DATE,
68   X_S_COMPLETED_SOURCE_TYPE IN VARCHAR2,
69   X_CATALOG_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
70   X_CATALOG_SEQ_NUM IN NUMBER DEFAULT NULL,
71   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
72   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
73   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
74   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
75   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
76   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
77   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
78   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
79   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
80   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
81   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
82   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
83   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
84   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
85   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
86   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
87   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
88   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
89   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
90   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
91   X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL
92 );
93 PROCEDURE UPDATE_ROW (
94   X_ROWID IN VARCHAR2,
95   X_PERSON_ID IN NUMBER,
96   X_COURSE_CD IN VARCHAR2,
97   X_UNIT_SET_CD IN VARCHAR2,
98   X_SEQUENCE_NUMBER IN NUMBER,
99   X_US_VERSION_NUMBER IN NUMBER,
100   X_SELECTION_DT IN DATE,
101   X_STUDENT_CONFIRMED_IND IN VARCHAR2,
102   X_END_DT IN DATE,
103   X_PARENT_UNIT_SET_CD IN VARCHAR2,
104   X_PARENT_SEQUENCE_NUMBER IN NUMBER,
105   X_PRIMARY_SET_IND IN VARCHAR2,
106   X_VOLUNTARY_END_IND IN VARCHAR2,
107   X_AUTHORISED_PERSON_ID IN NUMBER,
108   X_AUTHORISED_ON IN DATE,
109   X_OVERRIDE_TITLE IN VARCHAR2,
110   X_RQRMNTS_COMPLETE_IND IN VARCHAR2,
111   X_RQRMNTS_COMPLETE_DT IN DATE,
112   X_S_COMPLETED_SOURCE_TYPE IN VARCHAR2,
113   X_CATALOG_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
114   X_CATALOG_SEQ_NUM IN NUMBER DEFAULT NULL,
115   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
116   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
117   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
118   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
119   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
120   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
121   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
122   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
123   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
124   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
125   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
126   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
127   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
128   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
129   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
130   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
131   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
132   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
133   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
134   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
135   X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
136   X_MODE IN VARCHAR2 DEFAULT 'R'
137   );
138 PROCEDURE ADD_ROW (
139   X_ROWID IN OUT NOCOPY VARCHAR2,
140   X_PERSON_ID IN NUMBER,
141   X_COURSE_CD IN VARCHAR2,
142   X_UNIT_SET_CD IN VARCHAR2,
143   X_SEQUENCE_NUMBER IN NUMBER,
144   X_US_VERSION_NUMBER IN NUMBER,
145   X_SELECTION_DT IN DATE,
146   X_STUDENT_CONFIRMED_IND IN VARCHAR2,
147   X_END_DT IN DATE,
148   X_PARENT_UNIT_SET_CD IN VARCHAR2,
149   X_PARENT_SEQUENCE_NUMBER IN NUMBER,
150   X_PRIMARY_SET_IND IN VARCHAR2,
151   X_VOLUNTARY_END_IND IN VARCHAR2,
152   X_AUTHORISED_PERSON_ID IN NUMBER,
153   X_AUTHORISED_ON IN DATE,
154   X_OVERRIDE_TITLE IN VARCHAR2,
155   X_RQRMNTS_COMPLETE_IND IN VARCHAR2,
156   X_RQRMNTS_COMPLETE_DT IN DATE,
157   X_S_COMPLETED_SOURCE_TYPE IN VARCHAR2,
158   X_CATALOG_CAL_TYPE IN VARCHAR2 DEFAULT NULL,
159   X_CATALOG_SEQ_NUM IN NUMBER DEFAULT NULL,
160   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
161   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
162   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
163   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
164   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
165   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
166   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
167   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
168   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
169   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
170   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
171   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
172   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
173   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
174   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
175   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
176   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
177   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
178   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
179   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
180   X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
181   X_MODE IN VARCHAR2 DEFAULT 'R'
182   );
183 PROCEDURE DELETE_ROW (
184   X_ROWID IN VARCHAR2,
185   x_mode IN VARCHAR2 DEFAULT 'R'
186   );
187 
188 FUNCTION Get_PK_For_Validation (
189     x_person_id IN NUMBER,
190     x_course_cd IN VARCHAR2,
191     x_unit_set_cd IN VARCHAR2,
192     x_sequence_number IN NUMBER
193     ) RETURN BOOLEAN;
194 
195   PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
196     x_person_id IN NUMBER,
197     x_course_cd IN VARCHAR2
198     );
199 
200   PROCEDURE GET_FK_IGS_AS_SU_SETATMPT (
201     x_person_id IN NUMBER,
202     x_course_cd IN VARCHAR2,
203     x_unit_set_cd IN VARCHAR2,
204     x_sequence_number IN NUMBER
205     );
206 
207   PROCEDURE GET_FK_IGS_EN_UNIT_SET (
208     x_unit_set_cd IN VARCHAR2,
209     x_version_number IN NUMBER
210     );
211 
212 -- added as part of  Career Impact Build
213 -- amuthu 08-OCT-2001
214   PROCEDURE GET_FK_IGS_CA_INST (
215     X_CATALOG_CAL_TYPE IN VARCHAR2,
216     X_CATALOG_SEQ_NUM IN NUMBER
217     ) ;
218 
219   PROCEDURE GET_FK_IGS_PS_OFR_UNIT_SET (
220     x_course_cd IN VARCHAR2,
221     x_version_number IN NUMBER,
222     x_cal_type IN VARCHAR2,
223     x_unit_set_cd IN VARCHAR2,
224     x_us_version_number IN NUMBER
225     ) ;
226 
227  PROCEDURE Check_Constraints (
228  Column_Name	IN	VARCHAR2	DEFAULT NULL,
229  Column_Value 	IN	VARCHAR2	DEFAULT NULL
230  );
231 
232   PROCEDURE Before_DML (
233     p_action IN VARCHAR2,
234     x_rowid IN VARCHAR2 DEFAULT NULL,
235     x_person_id IN NUMBER DEFAULT NULL,
236     x_course_cd IN VARCHAR2 DEFAULT NULL,
237     x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
238     x_us_version_number IN NUMBER DEFAULT NULL,
239     x_sequence_number IN NUMBER DEFAULT NULL,
240     x_selection_dt IN DATE DEFAULT NULL,
241     x_student_confirmed_ind IN VARCHAR2 DEFAULT NULL,
242     x_end_dt IN DATE DEFAULT NULL,
243     x_parent_unit_set_cd IN VARCHAR2 DEFAULT NULL,
244     x_parent_sequence_number IN NUMBER DEFAULT NULL,
245     x_primary_set_ind IN VARCHAR2 DEFAULT NULL,
246     x_voluntary_end_ind IN VARCHAR2 DEFAULT NULL,
247     x_authorised_person_id IN NUMBER DEFAULT NULL,
248     x_authorised_on IN DATE DEFAULT NULL,
249     x_override_title IN VARCHAR2 DEFAULT NULL,
250     x_rqrmnts_complete_ind IN VARCHAR2 DEFAULT NULL,
251     x_rqrmnts_complete_dt IN DATE DEFAULT NULL,
252     x_s_completed_source_type IN VARCHAR2 DEFAULT NULL,
253     x_creation_date IN DATE DEFAULT NULL,
254     x_created_by IN NUMBER DEFAULT NULL,
255     x_last_update_date IN DATE DEFAULT NULL,
256     x_last_updated_by IN NUMBER DEFAULT NULL,
257     x_last_update_login IN NUMBER DEFAULT NULL,
258     x_catalog_cal_type IN VARCHAR2 DEFAULT NULL,
259     x_catalog_seq_num IN NUMBER DEFAULT NULL,
260    X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
261    X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
262    X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
263    X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
264    X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
265    X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
266    X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
267    X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
268    X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
269    X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
270    X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
271    X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
272    X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
273    X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
274    X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
275    X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
276    X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
277    X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
278    X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
279    X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
280    X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL
281   ) ;
282 
283 
284 END IGS_AS_SU_SETATMPT_PKG;