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_ST_GOVT_STDNT_EN_PKG

Source


1 package IGS_ST_GOVT_STDNT_EN_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSVI10S.pls 115.4 2002/11/29 04:33:22 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_SUBMISSION_YR in NUMBER,
7   X_SUBMISSION_NUMBER in NUMBER,
8   X_PERSON_ID in NUMBER,
9   X_COURSE_CD in VARCHAR2,
10   X_VERSION_NUMBER in NUMBER,
11   X_BIRTH_DT in DATE,
12   X_SEX in VARCHAR2,
13   X_ABORIG_TORRES_CD in VARCHAR2,
14   X_GOVT_ABORIG_TORRES_CD in NUMBER,
15   X_CITIZENSHIP_CD in VARCHAR2,
16   X_GOVT_CITIZENSHIP_CD in NUMBER,
17   X_PERM_RESIDENT_CD in VARCHAR2,
18   X_GOVT_PERM_RESIDENT_CD in NUMBER,
19   X_HOME_LOCATION in VARCHAR2,
20   X_GOVT_HOME_LOCATION in VARCHAR2,
21   X_TERM_LOCATION in VARCHAR2,
22   X_GOVT_TERM_LOCATION in VARCHAR2,
23   X_BIRTH_COUNTRY_CD in VARCHAR2,
24   X_GOVT_BIRTH_COUNTRY_CD in VARCHAR2,
25   X_YR_ARRIVAL in VARCHAR2,
26   X_HOME_LANGUAGE_CD in VARCHAR2,
27   X_GOVT_HOME_LANGUAGE_CD in NUMBER,
28   X_PRIOR_UG_INST in VARCHAR2,
29   X_GOVT_PRIOR_UG_INST in VARCHAR2,
30   X_PRIOR_OTHER_QUAL in VARCHAR2,
31   X_PRIOR_POST_GRAD in VARCHAR2,
32   X_PRIOR_DEGREE in VARCHAR2,
33   X_PRIOR_SUBDEG_NOTAFE in VARCHAR2,
34   X_PRIOR_SUBDEG_TAFE in VARCHAR2,
35   X_PRIOR_SECED_TAFE in VARCHAR2,
36   X_PRIOR_SECED_SCHOOL in VARCHAR2,
37   X_PRIOR_TAFE_AWARD in VARCHAR2,
38   X_PRIOR_STUDIES_EXEMPTION in NUMBER,
39   X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
40   X_GOVT_EXEMPT_INSTITU_CD in VARCHAR2,
41   X_ATTENDANCE_MODE in VARCHAR2,
42   X_GOVT_ATTENDANCE_MODE in VARCHAR2,
43   X_ATTENDANCE_TYPE in VARCHAR2,
44   X_GOVT_ATTENDANCE_TYPE in VARCHAR2,
45   X_COMMENCEMENT_DT in DATE,
46   X_MAJOR_COURSE in NUMBER,
47   X_TERTIARY_ENTRANCE_SCORE in NUMBER,
48   X_BASIS_FOR_ADMISSION_TYPE in VARCHAR2,
49   X_GOVT_BASIS_FOR_ADM_TYPE in VARCHAR2,
50   X_GOVT_DISABILITY in VARCHAR2,
51   X_MODE in VARCHAR2 default 'R'
52   );
53 procedure LOCK_ROW (
54   X_ROWID in VARCHAR2,
55   X_SUBMISSION_YR in NUMBER,
56   X_SUBMISSION_NUMBER in NUMBER,
57   X_PERSON_ID in NUMBER,
58   X_COURSE_CD in VARCHAR2,
59   X_VERSION_NUMBER in NUMBER,
60   X_BIRTH_DT in DATE,
61   X_SEX in VARCHAR2,
62   X_ABORIG_TORRES_CD in VARCHAR2,
63   X_GOVT_ABORIG_TORRES_CD in NUMBER,
64   X_CITIZENSHIP_CD in VARCHAR2,
65   X_GOVT_CITIZENSHIP_CD in NUMBER,
66   X_PERM_RESIDENT_CD in VARCHAR2,
67   X_GOVT_PERM_RESIDENT_CD in NUMBER,
68   X_HOME_LOCATION in VARCHAR2,
69   X_GOVT_HOME_LOCATION in VARCHAR2,
70   X_TERM_LOCATION in VARCHAR2,
71   X_GOVT_TERM_LOCATION in VARCHAR2,
72   X_BIRTH_COUNTRY_CD in VARCHAR2,
73   X_GOVT_BIRTH_COUNTRY_CD in VARCHAR2,
74   X_YR_ARRIVAL in VARCHAR2,
75   X_HOME_LANGUAGE_CD in VARCHAR2,
76   X_GOVT_HOME_LANGUAGE_CD in NUMBER,
77   X_PRIOR_UG_INST in VARCHAR2,
78   X_GOVT_PRIOR_UG_INST in VARCHAR2,
79   X_PRIOR_OTHER_QUAL in VARCHAR2,
80   X_PRIOR_POST_GRAD in VARCHAR2,
81   X_PRIOR_DEGREE in VARCHAR2,
82   X_PRIOR_SUBDEG_NOTAFE in VARCHAR2,
83   X_PRIOR_SUBDEG_TAFE in VARCHAR2,
84   X_PRIOR_SECED_TAFE in VARCHAR2,
85   X_PRIOR_SECED_SCHOOL in VARCHAR2,
86   X_PRIOR_TAFE_AWARD in VARCHAR2,
87   X_PRIOR_STUDIES_EXEMPTION in NUMBER,
88   X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
89   X_GOVT_EXEMPT_INSTITU_CD in VARCHAR2,
90   X_ATTENDANCE_MODE in VARCHAR2,
91   X_GOVT_ATTENDANCE_MODE in VARCHAR2,
92   X_ATTENDANCE_TYPE in VARCHAR2,
93   X_GOVT_ATTENDANCE_TYPE in VARCHAR2,
94   X_COMMENCEMENT_DT in DATE,
95   X_MAJOR_COURSE in NUMBER,
96   X_TERTIARY_ENTRANCE_SCORE in NUMBER,
97   X_BASIS_FOR_ADMISSION_TYPE in VARCHAR2,
98   X_GOVT_BASIS_FOR_ADM_TYPE in VARCHAR2,
99   X_GOVT_DISABILITY in VARCHAR2
100 );
101 procedure UPDATE_ROW (
102   X_ROWID in VARCHAR2,
103   X_SUBMISSION_YR in NUMBER,
104   X_SUBMISSION_NUMBER in NUMBER,
105   X_PERSON_ID in NUMBER,
106   X_COURSE_CD in VARCHAR2,
107   X_VERSION_NUMBER in NUMBER,
108   X_BIRTH_DT in DATE,
109   X_SEX in VARCHAR2,
110   X_ABORIG_TORRES_CD in VARCHAR2,
111   X_GOVT_ABORIG_TORRES_CD in NUMBER,
112   X_CITIZENSHIP_CD in VARCHAR2,
113   X_GOVT_CITIZENSHIP_CD in NUMBER,
114   X_PERM_RESIDENT_CD in VARCHAR2,
115   X_GOVT_PERM_RESIDENT_CD in NUMBER,
116   X_HOME_LOCATION in VARCHAR2,
117   X_GOVT_HOME_LOCATION in VARCHAR2,
118   X_TERM_LOCATION in VARCHAR2,
119   X_GOVT_TERM_LOCATION in VARCHAR2,
120   X_BIRTH_COUNTRY_CD in VARCHAR2,
121   X_GOVT_BIRTH_COUNTRY_CD in VARCHAR2,
122   X_YR_ARRIVAL in VARCHAR2,
123   X_HOME_LANGUAGE_CD in VARCHAR2,
124   X_GOVT_HOME_LANGUAGE_CD in NUMBER,
125   X_PRIOR_UG_INST in VARCHAR2,
126   X_GOVT_PRIOR_UG_INST in VARCHAR2,
127   X_PRIOR_OTHER_QUAL in VARCHAR2,
128   X_PRIOR_POST_GRAD in VARCHAR2,
129   X_PRIOR_DEGREE in VARCHAR2,
130   X_PRIOR_SUBDEG_NOTAFE in VARCHAR2,
131   X_PRIOR_SUBDEG_TAFE in VARCHAR2,
132   X_PRIOR_SECED_TAFE in VARCHAR2,
133   X_PRIOR_SECED_SCHOOL in VARCHAR2,
134   X_PRIOR_TAFE_AWARD in VARCHAR2,
135   X_PRIOR_STUDIES_EXEMPTION in NUMBER,
136   X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
137   X_GOVT_EXEMPT_INSTITU_CD in VARCHAR2,
138   X_ATTENDANCE_MODE in VARCHAR2,
139   X_GOVT_ATTENDANCE_MODE in VARCHAR2,
140   X_ATTENDANCE_TYPE in VARCHAR2,
141   X_GOVT_ATTENDANCE_TYPE in VARCHAR2,
142   X_COMMENCEMENT_DT in DATE,
143   X_MAJOR_COURSE in NUMBER,
144   X_TERTIARY_ENTRANCE_SCORE in NUMBER,
145   X_BASIS_FOR_ADMISSION_TYPE in VARCHAR2,
146   X_GOVT_BASIS_FOR_ADM_TYPE in VARCHAR2,
147   X_GOVT_DISABILITY in VARCHAR2,
148   X_MODE in VARCHAR2 default 'R'
149   );
150 procedure ADD_ROW (
151   X_ROWID in out NOCOPY VARCHAR2,
152   X_SUBMISSION_YR in NUMBER,
153   X_SUBMISSION_NUMBER in NUMBER,
154   X_PERSON_ID in NUMBER,
155   X_COURSE_CD in VARCHAR2,
156   X_VERSION_NUMBER in NUMBER,
157   X_BIRTH_DT in DATE,
158   X_SEX in VARCHAR2,
159   X_ABORIG_TORRES_CD in VARCHAR2,
160   X_GOVT_ABORIG_TORRES_CD in NUMBER,
161   X_CITIZENSHIP_CD in VARCHAR2,
162   X_GOVT_CITIZENSHIP_CD in NUMBER,
163   X_PERM_RESIDENT_CD in VARCHAR2,
164   X_GOVT_PERM_RESIDENT_CD in NUMBER,
165   X_HOME_LOCATION in VARCHAR2,
166   X_GOVT_HOME_LOCATION in VARCHAR2,
167   X_TERM_LOCATION in VARCHAR2,
168   X_GOVT_TERM_LOCATION in VARCHAR2,
169   X_BIRTH_COUNTRY_CD in VARCHAR2,
170   X_GOVT_BIRTH_COUNTRY_CD in VARCHAR2,
171   X_YR_ARRIVAL in VARCHAR2,
172   X_HOME_LANGUAGE_CD in VARCHAR2,
173   X_GOVT_HOME_LANGUAGE_CD in NUMBER,
174   X_PRIOR_UG_INST in VARCHAR2,
175   X_GOVT_PRIOR_UG_INST in VARCHAR2,
176   X_PRIOR_OTHER_QUAL in VARCHAR2,
177   X_PRIOR_POST_GRAD in VARCHAR2,
178   X_PRIOR_DEGREE in VARCHAR2,
179   X_PRIOR_SUBDEG_NOTAFE in VARCHAR2,
180   X_PRIOR_SUBDEG_TAFE in VARCHAR2,
181   X_PRIOR_SECED_TAFE in VARCHAR2,
182   X_PRIOR_SECED_SCHOOL in VARCHAR2,
183   X_PRIOR_TAFE_AWARD in VARCHAR2,
184   X_PRIOR_STUDIES_EXEMPTION in NUMBER,
185   X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
186   X_GOVT_EXEMPT_INSTITU_CD in VARCHAR2,
187   X_ATTENDANCE_MODE in VARCHAR2,
188   X_GOVT_ATTENDANCE_MODE in VARCHAR2,
189   X_ATTENDANCE_TYPE in VARCHAR2,
190   X_GOVT_ATTENDANCE_TYPE in VARCHAR2,
191   X_COMMENCEMENT_DT in DATE,
192   X_MAJOR_COURSE in NUMBER,
193   X_TERTIARY_ENTRANCE_SCORE in NUMBER,
194   X_BASIS_FOR_ADMISSION_TYPE in VARCHAR2,
195   X_GOVT_BASIS_FOR_ADM_TYPE in VARCHAR2,
196   X_GOVT_DISABILITY in VARCHAR2,
197   X_MODE in VARCHAR2 default 'R'
198   );
199 procedure DELETE_ROW (
200   X_ROWID in VARCHAR2
201 );
202 
203 function Get_PK_For_Validation (
204     x_submission_yr IN NUMBER,
205     x_submission_number IN NUMBER,
206     x_person_id IN NUMBER,
207     x_course_cd IN VARCHAR2
208 )return BOOLEAN;
209 
210 PROCEDURE get_fk_igs_st_gvt_spsht_ctl (
211     x_submission_yr IN NUMBER,
212     x_submission_number IN NUMBER
213     );
214 
215   PROCEDURE Before_DML (
216     p_action IN VARCHAR2,
217     x_rowid IN VARCHAR2 DEFAULT NULL,
218     x_submission_yr IN NUMBER DEFAULT NULL,
219     x_submission_number IN NUMBER DEFAULT NULL,
220     x_person_id IN NUMBER DEFAULT NULL,
221     x_course_cd IN VARCHAR2 DEFAULT NULL,
222     x_version_number IN NUMBER DEFAULT NULL,
223     x_birth_dt IN DATE DEFAULT NULL,
224     x_sex IN VARCHAR2 DEFAULT NULL,
225     x_aborig_torres_cd IN VARCHAR2 DEFAULT NULL,
226     x_govt_aborig_torres_cd IN NUMBER DEFAULT NULL,
227     x_citizenship_cd IN VARCHAR2 DEFAULT NULL,
228     x_govt_citizenship_cd IN NUMBER DEFAULT NULL,
229     x_perm_resident_cd IN VARCHAR2 DEFAULT NULL,
230     x_govt_perm_resident_cd IN NUMBER DEFAULT NULL,
231     x_home_location IN VARCHAR2 DEFAULT NULL,
232     x_govt_home_location IN VARCHAR2 DEFAULT NULL,
233     x_term_location IN VARCHAR2 DEFAULT NULL,
234     x_govt_term_location IN VARCHAR2 DEFAULT NULL,
235     x_birth_country_cd IN VARCHAR2 DEFAULT NULL,
236     x_govt_birth_country_cd IN VARCHAR2 DEFAULT NULL,
237     x_yr_arrival IN VARCHAR2 DEFAULT NULL,
238     x_home_language_cd IN VARCHAR2 DEFAULT NULL,
239     x_govt_home_language_cd IN NUMBER DEFAULT NULL,
240     x_prior_ug_inst IN VARCHAR2 DEFAULT NULL,
241     x_govt_prior_ug_inst IN VARCHAR2 DEFAULT NULL,
242     x_prior_other_qual IN VARCHAR2 DEFAULT NULL,
243     x_prior_post_grad IN VARCHAR2 DEFAULT NULL,
244     x_prior_degree IN VARCHAR2 DEFAULT NULL,
245     x_prior_subdeg_notafe IN VARCHAR2 DEFAULT NULL,
246     x_prior_subdeg_tafe IN VARCHAR2 DEFAULT NULL,
247     x_prior_seced_tafe IN VARCHAR2 DEFAULT NULL,
248     x_prior_seced_school IN VARCHAR2 DEFAULT NULL,
249     x_prior_tafe_award IN VARCHAR2 DEFAULT NULL,
250     x_prior_studies_exemption IN NUMBER DEFAULT NULL,
251     x_exemption_institution_cd IN VARCHAR2 DEFAULT NULL,
252     x_govt_exempt_institu_cd IN VARCHAR2 DEFAULT NULL,
253     x_attendance_mode IN VARCHAR2 DEFAULT NULL,
254     x_govt_attendance_mode IN VARCHAR2 DEFAULT NULL,
255     x_attendance_type IN VARCHAR2 DEFAULT NULL,
256     x_govt_attendance_type IN VARCHAR2 DEFAULT NULL,
257     x_commencement_dt IN DATE DEFAULT NULL,
258     x_major_course IN NUMBER DEFAULT NULL,
259     x_tertiary_entrance_score IN NUMBER DEFAULT NULL,
260     x_basis_for_admission_type IN VARCHAR2 DEFAULT NULL,
261     x_govt_basis_for_adm_type IN VARCHAR2 DEFAULT NULL,
262     x_govt_disability 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   );
269 
270 end IGS_ST_GOVT_STDNT_EN_PKG;