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_GR_GRADUAND_PKG

Source


1 package IGS_GR_GRADUAND_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSGI12S.pls 115.8 2003/10/01 06:59:33 ijeddy ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_PERSON_ID in NUMBER,
6   X_CREATE_DT in out NOCOPY DATE,
7   X_GRD_CAL_TYPE in VARCHAR2,
8   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
9   X_COURSE_CD in VARCHAR2,
10   X_AWARD_COURSE_CD in VARCHAR2,
11   X_AWARD_CRS_VERSION_NUMBER in NUMBER,
12   X_AWARD_CD in VARCHAR2,
13   X_HONOURS_LEVEL in VARCHAR2 DEFAULT NULL,
14   X_CONFERRAL_DT in DATE    DEFAULT NULL,
15   X_GRADUAND_STATUS in VARCHAR2,
16   X_GRADUAND_APPR_STATUS in VARCHAR2,
17   X_S_GRADUAND_TYPE in VARCHAR2,
18   X_GRADUATION_NAME in VARCHAR2,
19   X_PROXY_AWARD_IND in VARCHAR2,
20   X_PROXY_AWARD_PERSON_ID in NUMBER,
21   X_PREVIOUS_QUALIFICATIONS in VARCHAR2,
22   X_CONVOCATION_MEMBERSHIP_IND in VARCHAR2,
23   X_SUR_FOR_COURSE_CD in VARCHAR2,
24   X_SUR_FOR_CRS_VERSION_NUMBER in NUMBER,
25   X_SUR_FOR_AWARD_CD in VARCHAR2,
26   X_COMMENTS in VARCHAR2,
27   X_MODE in VARCHAR2 default 'R' ,
28   X_ORG_ID  in NUMBER,
29   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
30   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
31   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
32   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
33   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
34   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
35   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
36   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
37   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
38   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
39   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
40   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
41   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
42   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
43   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
44   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
45   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
46   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
47   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
48   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
49   X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL
50   );
51 procedure LOCK_ROW (
52   X_ROWID in VARCHAR2,
53   X_PERSON_ID in NUMBER,
54   X_CREATE_DT in DATE,
55   X_GRD_CAL_TYPE in VARCHAR2,
56   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
57   X_COURSE_CD in VARCHAR2,
58   X_AWARD_COURSE_CD in VARCHAR2,
59   X_AWARD_CRS_VERSION_NUMBER in NUMBER,
60   X_AWARD_CD in VARCHAR2,
61   X_HONOURS_LEVEL in VARCHAR2 DEFAULT NULL,
62   X_CONFERRAL_DT in DATE DEFAULT NULL,
63   X_GRADUAND_STATUS in VARCHAR2,
64   X_GRADUAND_APPR_STATUS in VARCHAR2,
65   X_S_GRADUAND_TYPE in VARCHAR2,
66   X_GRADUATION_NAME in VARCHAR2,
67   X_PROXY_AWARD_IND in VARCHAR2,
68   X_PROXY_AWARD_PERSON_ID in NUMBER,
69   X_PREVIOUS_QUALIFICATIONS in VARCHAR2,
70   X_CONVOCATION_MEMBERSHIP_IND in VARCHAR2,
71   X_SUR_FOR_COURSE_CD in VARCHAR2,
72   X_SUR_FOR_CRS_VERSION_NUMBER in NUMBER,
73   X_SUR_FOR_AWARD_CD in VARCHAR2,
74   X_COMMENTS in VARCHAR2,
75   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
76   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
77   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
78   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
79   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
80   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
81   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
82   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
83   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
84   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
85   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
86   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
87   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
88   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
89   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
90   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
91   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
92   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
93   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
94   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
95   X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL
96 );
97 procedure UPDATE_ROW (
98   X_ROWID in VARCHAR2,
99   X_PERSON_ID in NUMBER,
100   X_CREATE_DT in DATE,
101   X_GRD_CAL_TYPE in VARCHAR2,
102   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
103   X_COURSE_CD in VARCHAR2,
104   X_AWARD_COURSE_CD in VARCHAR2,
105   X_AWARD_CRS_VERSION_NUMBER in NUMBER,
106   X_AWARD_CD in VARCHAR2,
107   X_HONOURS_LEVEL in VARCHAR2 DEFAULT NULL,
108   X_CONFERRAL_DT in DATE DEFAULT NULL,
109   X_GRADUAND_STATUS in VARCHAR2,
110   X_GRADUAND_APPR_STATUS in VARCHAR2,
111   X_S_GRADUAND_TYPE in VARCHAR2,
112   X_GRADUATION_NAME in VARCHAR2,
113   X_PROXY_AWARD_IND in VARCHAR2,
114   X_PROXY_AWARD_PERSON_ID in NUMBER,
115   X_PREVIOUS_QUALIFICATIONS in VARCHAR2,
116   X_CONVOCATION_MEMBERSHIP_IND in VARCHAR2,
117   X_SUR_FOR_COURSE_CD in VARCHAR2,
118   X_SUR_FOR_CRS_VERSION_NUMBER in NUMBER,
119   X_SUR_FOR_AWARD_CD in VARCHAR2,
120   X_COMMENTS in VARCHAR2,
121   X_MODE in VARCHAR2 default 'R',
122   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
123   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
124   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
125   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
126   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
127   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
128   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
129   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
130   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
131   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
132   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
133   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
134   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
135   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
136   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
137   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
138   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
139   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
140   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
141   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
142   X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL
143   );
144 procedure ADD_ROW (
145   X_ROWID in out NOCOPY VARCHAR2,
146   X_PERSON_ID in NUMBER,
147   X_CREATE_DT in out NOCOPY DATE,
148   X_GRD_CAL_TYPE in VARCHAR2,
149   X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
150   X_COURSE_CD in VARCHAR2,
151   X_AWARD_COURSE_CD in VARCHAR2,
152   X_AWARD_CRS_VERSION_NUMBER in NUMBER,
153   X_AWARD_CD in VARCHAR2,
154   X_HONOURS_LEVEL in VARCHAR2 DEFAULT NULL,
155   X_CONFERRAL_DT in DATE DEFAULT NULL,
156   X_GRADUAND_STATUS in VARCHAR2,
157   X_GRADUAND_APPR_STATUS in VARCHAR2,
158   X_S_GRADUAND_TYPE in VARCHAR2,
159   X_GRADUATION_NAME in VARCHAR2,
160   X_PROXY_AWARD_IND in VARCHAR2,
161   X_PROXY_AWARD_PERSON_ID in NUMBER,
162   X_PREVIOUS_QUALIFICATIONS in VARCHAR2,
163   X_CONVOCATION_MEMBERSHIP_IND in VARCHAR2,
164   X_SUR_FOR_COURSE_CD in VARCHAR2,
165   X_SUR_FOR_CRS_VERSION_NUMBER in NUMBER,
166   X_SUR_FOR_AWARD_CD in VARCHAR2,
167   X_COMMENTS in VARCHAR2,
168   X_MODE in VARCHAR2 default 'R',
169   X_ORG_ID  in NUMBER,
170   X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
171   X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
172   X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
173   X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
174   X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
175   X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
176   X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
177   X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
178   X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
179   X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
180   X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
181   X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
182   X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
183   X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
184   X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
185   X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
186   X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
187   X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
188   X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
189   X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
190   X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL
191   );
192 procedure DELETE_ROW (
193   X_ROWID in VARCHAR2
194 );
195 
196   FUNCTION Get_PK_For_Validation (
197     x_person_id IN NUMBER,
198     x_create_dt IN DATE
199     ) RETURN BOOLEAN;
200 
201   FUNCTION Get_UK_For_Validation (
202     x_person_id IN NUMBER,
203     x_create_dt IN DATE,
204     x_award_course_cd IN VARCHAR2,
205     x_award_crs_version_number IN NUMBER,
206     x_award_cd IN VARCHAR2
207     ) RETURN BOOLEAN;
208 
209   PROCEDURE GET_FK_IGS_GR_CRMN_ROUND (
210     x_grd_cal_type IN VARCHAR2,
211     x_grd_ci_sequence_number IN NUMBER
212     );
213 
214   PROCEDURE GET_FK_IGS_GR_APRV_STAT (
215     x_graduand_appr_status IN VARCHAR2
216     );
217 
218   PROCEDURE GET_FK_IGS_GR_STAT (
219     x_graduand_status IN VARCHAR2
220     );
221 
222   PROCEDURE GET_FK_IGS_GR_HONOURS_LEVEL (
223     x_honours_level IN VARCHAR2
224     );
225 
226   PROCEDURE GET_FK_IGS_EN_SPA_AWD (
227           x_person_id IN NUMBER,
228           x_course_cd IN VARCHAR2,
229           x_award_cd  IN VARCHAR2
230     );
231 
232   PROCEDURE GET_FK_IGS_PE_PERSON (
233     x_person_id IN NUMBER
234     );
235 
236   PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
237     x_person_id IN NUMBER,
238     x_course_cd IN VARCHAR2
239     );
240 
241 
242 PROCEDURE Check_Constraints(
243 	Column_Name IN VARCHAR2 DEFAULT NULL,
244 	Column_Value IN VARCHAR2 DEFAULT NULL
245 	);
246 
247   PROCEDURE Before_DML (
248     p_action IN VARCHAR2,
249     x_rowid IN VARCHAR2 DEFAULT NULL,
250     x_person_id IN NUMBER DEFAULT NULL,
251     x_create_dt IN DATE DEFAULT NULL,
252     x_grd_cal_type IN VARCHAR2 DEFAULT NULL,
253     x_grd_ci_sequence_number IN NUMBER DEFAULT NULL,
254     x_course_cd IN VARCHAR2 DEFAULT NULL,
255     x_award_course_cd IN VARCHAR2 DEFAULT NULL,
256     x_award_crs_version_number IN NUMBER DEFAULT NULL,
257     x_award_cd IN VARCHAR2 DEFAULT NULL,
258     x_honours_level IN VARCHAR2 DEFAULT NULL,
259     x_conferral_dt IN DATE DEFAULT NULL,
260     x_graduand_status IN VARCHAR2 DEFAULT NULL,
261     x_graduand_appr_status IN VARCHAR2 DEFAULT NULL,
262     x_s_graduand_type IN VARCHAR2 DEFAULT NULL,
263     x_graduation_name IN VARCHAR2 DEFAULT NULL,
264     x_proxy_award_ind IN VARCHAR2 DEFAULT NULL,
265     x_proxy_award_person_id IN NUMBER DEFAULT NULL,
266     x_previous_qualifications IN VARCHAR2 DEFAULT NULL,
267     x_convocation_membership_ind IN VARCHAR2 DEFAULT NULL,
268     x_sur_for_course_cd IN VARCHAR2 DEFAULT NULL,
269     x_sur_for_crs_version_number IN NUMBER DEFAULT NULL,
270     x_sur_for_award_cd IN VARCHAR2 DEFAULT NULL,
271     x_comments IN VARCHAR2 DEFAULT NULL,
272     x_creation_date IN DATE DEFAULT NULL,
273     x_created_by IN NUMBER DEFAULT NULL,
274     x_last_update_date IN DATE DEFAULT NULL,
275     x_last_updated_by IN NUMBER DEFAULT NULL,
276     x_last_update_login IN NUMBER DEFAULT NULL,
277     X_ORG_ID  in NUMBER DEFAULT NULL,
278     X_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
279     X_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
280     X_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
281     X_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
282     X_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
283     X_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
284     X_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
285     X_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
286     X_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
287     X_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
288     X_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
289     X_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
290     X_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
291     X_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
292     X_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
293     X_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
294     X_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
295     X_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
296     X_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
297     X_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
298     X_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL
299   );
300 
301 end IGS_GR_GRADUAND_PKG;