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.

APPS.IGS_ST_GEN_004 dependencies on IGS_ST_GOVT_STDNT_EN

Line 269: v_birth_dt IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE;

265: v_gse_course_cd IGS_EN_ST_SNAPSHOT.course_cd%TYPE DEFAULT NULL;
266: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE DEFAULT NULL;
267: v_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE DEFAULT NULL;
268: v_govt_reportable IGS_EN_ST_SNAPSHOT.govt_reportable_ind%TYPE;
269: v_birth_dt IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE;
270: v_sex IGS_ST_GOVT_STDNT_EN.sex%TYPE;
271: v_govt_disability IGS_ST_GOVT_STDNT_EN.govt_disability%TYPE;
272: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
273: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;

Line 270: v_sex IGS_ST_GOVT_STDNT_EN.sex%TYPE;

266: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE DEFAULT NULL;
267: v_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE DEFAULT NULL;
268: v_govt_reportable IGS_EN_ST_SNAPSHOT.govt_reportable_ind%TYPE;
269: v_birth_dt IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE;
270: v_sex IGS_ST_GOVT_STDNT_EN.sex%TYPE;
271: v_govt_disability IGS_ST_GOVT_STDNT_EN.govt_disability%TYPE;
272: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
273: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
274: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;

Line 271: v_govt_disability IGS_ST_GOVT_STDNT_EN.govt_disability%TYPE;

267: v_govt_semester IGS_ST_GVT_STDNTLOAD.govt_semester%TYPE DEFAULT NULL;
268: v_govt_reportable IGS_EN_ST_SNAPSHOT.govt_reportable_ind%TYPE;
269: v_birth_dt IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE;
270: v_sex IGS_ST_GOVT_STDNT_EN.sex%TYPE;
271: v_govt_disability IGS_ST_GOVT_STDNT_EN.govt_disability%TYPE;
272: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
273: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
274: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;
275: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;

Line 272: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;

268: v_govt_reportable IGS_EN_ST_SNAPSHOT.govt_reportable_ind%TYPE;
269: v_birth_dt IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE;
270: v_sex IGS_ST_GOVT_STDNT_EN.sex%TYPE;
271: v_govt_disability IGS_ST_GOVT_STDNT_EN.govt_disability%TYPE;
272: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
273: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
274: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;
275: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
276: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;

Line 273: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;

269: v_birth_dt IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE;
270: v_sex IGS_ST_GOVT_STDNT_EN.sex%TYPE;
271: v_govt_disability IGS_ST_GOVT_STDNT_EN.govt_disability%TYPE;
272: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
273: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
274: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;
275: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
276: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
277: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE;

Line 274: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;

270: v_sex IGS_ST_GOVT_STDNT_EN.sex%TYPE;
271: v_govt_disability IGS_ST_GOVT_STDNT_EN.govt_disability%TYPE;
272: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
273: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
274: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;
275: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
276: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
277: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE;
278: v_home_location_cd IGS_ST_GOVT_STDNT_EN.home_location%TYPE;

Line 275: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;

271: v_govt_disability IGS_ST_GOVT_STDNT_EN.govt_disability%TYPE;
272: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
273: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
274: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;
275: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
276: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
277: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE;
278: v_home_location_cd IGS_ST_GOVT_STDNT_EN.home_location%TYPE;
279: v_govt_home_location_cd IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;

Line 276: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;

272: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
273: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
274: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;
275: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
276: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
277: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE;
278: v_home_location_cd IGS_ST_GOVT_STDNT_EN.home_location%TYPE;
279: v_govt_home_location_cd IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;
280: v_term_location_cd IGS_ST_GOVT_STDNT_EN.term_location%TYPE;

Line 277: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE;

273: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
274: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;
275: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
276: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
277: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE;
278: v_home_location_cd IGS_ST_GOVT_STDNT_EN.home_location%TYPE;
279: v_govt_home_location_cd IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;
280: v_term_location_cd IGS_ST_GOVT_STDNT_EN.term_location%TYPE;
281: v_govt_term_location_cd IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;

Line 278: v_home_location_cd IGS_ST_GOVT_STDNT_EN.home_location%TYPE;

274: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;
275: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
276: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
277: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE;
278: v_home_location_cd IGS_ST_GOVT_STDNT_EN.home_location%TYPE;
279: v_govt_home_location_cd IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;
280: v_term_location_cd IGS_ST_GOVT_STDNT_EN.term_location%TYPE;
281: v_govt_term_location_cd IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;
282: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;

Line 279: v_govt_home_location_cd IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;

275: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
276: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
277: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE;
278: v_home_location_cd IGS_ST_GOVT_STDNT_EN.home_location%TYPE;
279: v_govt_home_location_cd IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;
280: v_term_location_cd IGS_ST_GOVT_STDNT_EN.term_location%TYPE;
281: v_govt_term_location_cd IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;
282: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
283: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;

Line 280: v_term_location_cd IGS_ST_GOVT_STDNT_EN.term_location%TYPE;

276: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;
277: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE;
278: v_home_location_cd IGS_ST_GOVT_STDNT_EN.home_location%TYPE;
279: v_govt_home_location_cd IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;
280: v_term_location_cd IGS_ST_GOVT_STDNT_EN.term_location%TYPE;
281: v_govt_term_location_cd IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;
282: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
283: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
284: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;

Line 281: v_govt_term_location_cd IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;

277: v_govt_perm_resident_cd IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE;
278: v_home_location_cd IGS_ST_GOVT_STDNT_EN.home_location%TYPE;
279: v_govt_home_location_cd IGS_ST_GOVT_STDNT_EN.govt_home_location%TYPE;
280: v_term_location_cd IGS_ST_GOVT_STDNT_EN.term_location%TYPE;
281: v_govt_term_location_cd IGS_ST_GOVT_STDNT_EN.govt_term_location%TYPE;
282: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
283: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
284: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
285: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;

Line 286: v_birth_country_cd IGS_ST_GOVT_STDNT_EN.birth_country_cd%TYPE;

282: v_home_location_postcode IGS_PE_STATISTICS.home_location_postcode%TYPE;
283: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
284: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
285: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
286: v_birth_country_cd IGS_ST_GOVT_STDNT_EN.birth_country_cd%TYPE;
287: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;
288: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;
289: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%TYPE;
290: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%TYPE;

Line 287: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;

283: v_home_location_country IGS_PE_STATISTICS.home_location_country%TYPE;
284: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
285: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
286: v_birth_country_cd IGS_ST_GOVT_STDNT_EN.birth_country_cd%TYPE;
287: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;
288: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;
289: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%TYPE;
290: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%TYPE;
291: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;

Line 288: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;

284: v_term_location_postcode IGS_PE_STATISTICS.term_location_postcode%TYPE;
285: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
286: v_birth_country_cd IGS_ST_GOVT_STDNT_EN.birth_country_cd%TYPE;
287: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;
288: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;
289: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%TYPE;
290: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%TYPE;
291: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
292: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;

Line 289: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%TYPE;

285: v_term_location_country IGS_PE_STATISTICS.term_location_country%TYPE;
286: v_birth_country_cd IGS_ST_GOVT_STDNT_EN.birth_country_cd%TYPE;
287: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;
288: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;
289: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%TYPE;
290: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%TYPE;
291: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
292: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
293: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;

Line 290: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%TYPE;

286: v_birth_country_cd IGS_ST_GOVT_STDNT_EN.birth_country_cd%TYPE;
287: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;
288: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;
289: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%TYPE;
290: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%TYPE;
291: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
292: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
293: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
294: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;

Line 291: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;

287: v_govt_birth_country_cd IGS_ST_GOVT_STDNT_EN.govt_birth_country_cd%TYPE;
288: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;
289: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%TYPE;
290: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%TYPE;
291: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
292: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
293: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
294: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
295: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;

Line 292: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;

288: v_yr_arrival IGS_ST_GOVT_STDNT_EN.yr_arrival%TYPE;
289: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%TYPE;
290: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%TYPE;
291: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
292: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
293: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
294: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
295: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
296: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;

Line 293: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;

289: v_home_language_cd IGS_ST_GOVT_STDNT_EN.home_language_cd%TYPE;
290: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%TYPE;
291: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
292: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
293: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
294: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
295: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
296: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
297: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;

Line 294: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;

290: v_govt_home_language_cd IGS_ST_GOVT_STDNT_EN.govt_home_language_cd%TYPE;
291: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
292: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
293: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
294: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
295: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
296: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
297: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
298: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;

Line 295: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;

291: v_prior_ug_inst IGS_ST_GOVT_STDNT_EN.prior_ug_inst%TYPE;
292: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
293: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
294: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
295: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
296: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
297: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
298: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
299: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;

Line 296: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;

292: v_govt_prior_ug_inst IGS_ST_GOVT_STDNT_EN.govt_prior_ug_inst%TYPE;
293: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
294: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
295: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
296: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
297: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
298: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
299: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;
300: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;

Line 297: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;

293: v_prior_other_qual IGS_ST_GOVT_STDNT_EN.prior_other_qual%TYPE;
294: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
295: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
296: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
297: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
298: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
299: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;
300: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;
301: v_prior_studies_exemption IGS_ST_GOVT_STDNT_EN.prior_studies_exemption%TYPE;

Line 298: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;

294: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
295: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
296: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
297: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
298: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
299: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;
300: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;
301: v_prior_studies_exemption IGS_ST_GOVT_STDNT_EN.prior_studies_exemption%TYPE;
302: v_exempt_institution_cd

Line 299: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;

295: v_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
296: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
297: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
298: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
299: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;
300: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;
301: v_prior_studies_exemption IGS_ST_GOVT_STDNT_EN.prior_studies_exemption%TYPE;
302: v_exempt_institution_cd
303: IGS_ST_GOVT_STDNT_EN.exemption_institution_cd%TYPE;

Line 300: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;

296: v_prior_subdeg_notafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_notafe%TYPE;
297: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
298: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
299: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;
300: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;
301: v_prior_studies_exemption IGS_ST_GOVT_STDNT_EN.prior_studies_exemption%TYPE;
302: v_exempt_institution_cd
303: IGS_ST_GOVT_STDNT_EN.exemption_institution_cd%TYPE;
304: v_govt_exempt_institution_cd

Line 301: v_prior_studies_exemption IGS_ST_GOVT_STDNT_EN.prior_studies_exemption%TYPE;

297: v_prior_subdeg_tafe IGS_ST_GOVT_STDNT_EN.prior_subdeg_tafe%TYPE;
298: v_prior_seced_tafe IGS_ST_GOVT_STDNT_EN.prior_seced_tafe%TYPE;
299: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;
300: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;
301: v_prior_studies_exemption IGS_ST_GOVT_STDNT_EN.prior_studies_exemption%TYPE;
302: v_exempt_institution_cd
303: IGS_ST_GOVT_STDNT_EN.exemption_institution_cd%TYPE;
304: v_govt_exempt_institution_cd
305: IGS_ST_GOVT_STDNT_EN.govt_exemption_institution_cd%TYPE;

Line 303: IGS_ST_GOVT_STDNT_EN.exemption_institution_cd%TYPE;

299: v_prior_seced_school IGS_ST_GOVT_STDNT_EN.prior_seced_school%TYPE;
300: v_prior_tafe_award IGS_ST_GOVT_STDNT_EN.prior_tafe_award%TYPE;
301: v_prior_studies_exemption IGS_ST_GOVT_STDNT_EN.prior_studies_exemption%TYPE;
302: v_exempt_institution_cd
303: IGS_ST_GOVT_STDNT_EN.exemption_institution_cd%TYPE;
304: v_govt_exempt_institution_cd
305: IGS_ST_GOVT_STDNT_EN.govt_exemption_institution_cd%TYPE;
306: v_tertiary_entrance_score IGS_ST_GOVT_STDNT_EN.tertiary_entrance_score%TYPE;
307: v_basis_for_admission_type

Line 305: IGS_ST_GOVT_STDNT_EN.govt_exemption_institution_cd%TYPE;

301: v_prior_studies_exemption IGS_ST_GOVT_STDNT_EN.prior_studies_exemption%TYPE;
302: v_exempt_institution_cd
303: IGS_ST_GOVT_STDNT_EN.exemption_institution_cd%TYPE;
304: v_govt_exempt_institution_cd
305: IGS_ST_GOVT_STDNT_EN.govt_exemption_institution_cd%TYPE;
306: v_tertiary_entrance_score IGS_ST_GOVT_STDNT_EN.tertiary_entrance_score%TYPE;
307: v_basis_for_admission_type
308: IGS_ST_GOVT_STDNT_EN.basis_for_admission_type%TYPE;
309: v_govt_basis_for_adm_type

Line 306: v_tertiary_entrance_score IGS_ST_GOVT_STDNT_EN.tertiary_entrance_score%TYPE;

302: v_exempt_institution_cd
303: IGS_ST_GOVT_STDNT_EN.exemption_institution_cd%TYPE;
304: v_govt_exempt_institution_cd
305: IGS_ST_GOVT_STDNT_EN.govt_exemption_institution_cd%TYPE;
306: v_tertiary_entrance_score IGS_ST_GOVT_STDNT_EN.tertiary_entrance_score%TYPE;
307: v_basis_for_admission_type
308: IGS_ST_GOVT_STDNT_EN.basis_for_admission_type%TYPE;
309: v_govt_basis_for_adm_type
310: IGS_ST_GOVT_STDNT_EN.govt_basis_for_admission_type% TYPE;

Line 308: IGS_ST_GOVT_STDNT_EN.basis_for_admission_type%TYPE;

304: v_govt_exempt_institution_cd
305: IGS_ST_GOVT_STDNT_EN.govt_exemption_institution_cd%TYPE;
306: v_tertiary_entrance_score IGS_ST_GOVT_STDNT_EN.tertiary_entrance_score%TYPE;
307: v_basis_for_admission_type
308: IGS_ST_GOVT_STDNT_EN.basis_for_admission_type%TYPE;
309: v_govt_basis_for_adm_type
310: IGS_ST_GOVT_STDNT_EN.govt_basis_for_admission_type% TYPE;
311: v_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;
312: v_hecs_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE;

Line 310: IGS_ST_GOVT_STDNT_EN.govt_basis_for_admission_type% TYPE;

306: v_tertiary_entrance_score IGS_ST_GOVT_STDNT_EN.tertiary_entrance_score%TYPE;
307: v_basis_for_admission_type
308: IGS_ST_GOVT_STDNT_EN.basis_for_admission_type%TYPE;
309: v_govt_basis_for_adm_type
310: IGS_ST_GOVT_STDNT_EN.govt_basis_for_admission_type% TYPE;
311: v_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;
312: v_hecs_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE;
313: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
314: v_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE;

Line 334: v_major_course IGS_ST_GOVT_STDNT_EN.major_course%TYPE;

330: v_s_unit_mode IGS_AS_UNIT_MODE.s_unit_mode%TYPE;
331: v_govt_attendance_mode IGS_EN_ATD_MODE.govt_attendance_mode%TYPE;
332: v_attendance_mode IGS_EN_ATD_MODE.attendance_mode%TYPE;
333: v_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE;
334: v_major_course IGS_ST_GOVT_STDNT_EN.major_course%TYPE;
335: v_on BOOLEAN DEFAULT FALSE;
336: v_off BOOLEAN DEFAULT FALSE;
337: v_composite BOOLEAN DEFAULT FALSE;
338: v_unit_total_eftsu IGS_ST_GVT_STDNTLOAD.eftsu%TYPE;

Line 508: FROM IGS_ST_GOVT_STDNT_EN gse

504: CURSOR c_gse_att_mode IS
505: SELECT DISTINCT
506: gse.person_id,
507: gse.course_cd
508: FROM IGS_ST_GOVT_STDNT_EN gse
509: WHERE gse.submission_yr = p_submission_yr AND
510: gse.submission_number = p_submission_number;
511: CURSOR c_gslo (
512: cp_person_id IGS_ST_GVT_STDNTLOAD.person_id%TYPE,

Line 531: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE,

527: gslo.person_id = cp_person_id AND
528: gslo.course_cd = cp_course_cd AND
529: gslo.eftsu <> 0;
530: CURSOR c_sua_ucl_um (
531: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE,
532: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE,
533: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
534: cp_cal_type IGS_CA_TYPE.cal_type%TYPE,
535: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,

Line 532: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE,

528: gslo.course_cd = cp_course_cd AND
529: gslo.eftsu <> 0;
530: CURSOR c_sua_ucl_um (
531: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE,
532: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE,
533: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,
534: cp_cal_type IGS_CA_TYPE.cal_type%TYPE,
535: cp_ci_seq_num IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
536: cp_location_cd IGS_EN_SU_ATTEMPT.location_cd%TYPE,

Line 563: FROM IGS_ST_GOVT_STDNT_EN gse

559: CURSOR c_gse (
560: cp_lower_enr_load_range IGS_EN_ATD_TYPE.lower_enr_load_range%TYPE) IS
561: SELECT DISTINCT
562: gse.person_id
563: FROM IGS_ST_GOVT_STDNT_EN gse
564: WHERE gse.submission_yr = p_submission_yr AND
565: gse.submission_number = p_submission_number AND
566: cp_lower_enr_load_range <=
567: (SELECT SUM(gsl.eftsu)

Line 577: FROM IGS_ST_GOVT_STDNT_EN gse

573: -- with more than one IGS_PS_COURSE
574: CURSOR c_gse2 IS
575: SELECT gse.person_id,
576: gse.course_cd
577: FROM IGS_ST_GOVT_STDNT_EN gse
578: WHERE gse.submission_yr = p_submission_yr AND
579: gse.submission_number = p_submission_number
580: ORDER BY
581: gse.person_id;

Line 584: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE) IS

580: ORDER BY
581: gse.person_id;
582: -- Called when a student is found more than once in gse
583: CURSOR c_gse_sca (
584: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE) IS
585: SELECT gse.person_id,
586: gse.course_cd,
587: SUM(gslo.eftsu)
588: FROM IGS_ST_GOVT_STDNT_EN gse,

Line 588: FROM IGS_ST_GOVT_STDNT_EN gse,

584: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE) IS
585: SELECT gse.person_id,
586: gse.course_cd,
587: SUM(gslo.eftsu)
588: FROM IGS_ST_GOVT_STDNT_EN gse,
589: IGS_ST_GVT_STDNTLOAD gslo,
590: IGS_EN_STDNT_PS_ATT sca
591: WHERE gse.submission_yr = p_submission_yr AND
592: gse.submission_number = p_submission_number AND

Line 595: FROM IGS_ST_GOVT_STDNT_EN gse2

591: WHERE gse.submission_yr = p_submission_yr AND
592: gse.submission_number = p_submission_number AND
593: gse.person_id = cp_person_id AND
594: 1 < (SELECT COUNT(DISTINCT gse2.course_cd)
595: FROM IGS_ST_GOVT_STDNT_EN gse2
596: WHERE gse2.submission_yr = p_submission_yr AND
597: gse2.submission_number = p_submission_number AND
598: gse2.person_id = cp_person_id) AND
599: sca.person_id = gse.person_id AND

Line 667: FROM IGS_ST_GOVT_STDNT_EN gse

663: gslo.course_cd,
664: gslo.govt_semester;
665: CURSOR c_gse_upd IS
666: SELECT rowid,gse.*
667: FROM IGS_ST_GOVT_STDNT_EN gse
668: WHERE submission_yr = p_submission_yr AND
669: submission_number = p_submission_number
670: FOR UPDATE OF gse.last_updated_by NOWAIT;
671: CURSOR c_gse_upd2 (

Line 672: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE) IS

668: WHERE submission_yr = p_submission_yr AND
669: submission_number = p_submission_number
670: FOR UPDATE OF gse.last_updated_by NOWAIT;
671: CURSOR c_gse_upd2 (
672: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE) IS
673: SELECT rowid, gse.*
674: FROM IGS_ST_GOVT_STDNT_EN gse
675: WHERE submission_yr = p_submission_yr AND
676: submission_number = p_submission_number AND

Line 674: FROM IGS_ST_GOVT_STDNT_EN gse

670: FOR UPDATE OF gse.last_updated_by NOWAIT;
671: CURSOR c_gse_upd2 (
672: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE) IS
673: SELECT rowid, gse.*
674: FROM IGS_ST_GOVT_STDNT_EN gse
675: WHERE submission_yr = p_submission_yr AND
676: submission_number = p_submission_number AND
677: person_id = cp_person_id
678: FOR UPDATE OF gse.last_updated_by NOWAIT;

Line 680: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE,

676: submission_number = p_submission_number AND
677: person_id = cp_person_id
678: FOR UPDATE OF gse.last_updated_by NOWAIT;
679: CURSOR c_gse_upd3 (
680: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE,
681: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE) IS
682: SELECT rowid, gse.*
683: FROM IGS_ST_GOVT_STDNT_EN gse
684: WHERE gse.submission_yr = p_submission_yr AND

Line 681: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE) IS

677: person_id = cp_person_id
678: FOR UPDATE OF gse.last_updated_by NOWAIT;
679: CURSOR c_gse_upd3 (
680: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE,
681: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE) IS
682: SELECT rowid, gse.*
683: FROM IGS_ST_GOVT_STDNT_EN gse
684: WHERE gse.submission_yr = p_submission_yr AND
685: gse.submission_number = p_submission_number AND

Line 683: FROM IGS_ST_GOVT_STDNT_EN gse

679: CURSOR c_gse_upd3 (
680: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE,
681: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE) IS
682: SELECT rowid, gse.*
683: FROM IGS_ST_GOVT_STDNT_EN gse
684: WHERE gse.submission_yr = p_submission_yr AND
685: gse.submission_number = p_submission_number AND
686: gse.person_id = cp_person_id AND
687: gse.course_cd = cp_course_cd

Line 714: FROM IGS_ST_GOVT_STDNT_EN gse

710: gse.person_id,
711: gse.course_cd,
712: gse.version_number,
713: gse.commencement_dt
714: FROM IGS_ST_GOVT_STDNT_EN gse
715: WHERE gse.submission_yr = p_submission_yr AND
716: gse.submission_number = p_submission_number;
717: CURSOR c_gse_upd_commencement (
718: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,

Line 721: FROM IGS_ST_GOVT_STDNT_EN gse

717: CURSOR c_gse_upd_commencement (
718: cp_person_id IGS_ST_GVT_STDNT_LBL.person_id%TYPE,
719: cp_course_cd IGS_ST_GVT_STDNT_LBL.course_cd%TYPE) IS
720: SELECT rowid,gse.*
721: FROM IGS_ST_GOVT_STDNT_EN gse
722: WHERE gse.submission_yr = p_submission_yr AND
723: gse.submission_number = p_submission_number AND
724: gse.person_id = cp_person_id AND
725: gse.course_cd = cp_course_cd

Line 850: p_birth_dt IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE,

846: p_effective_dt DATE,
847: p_logged_ind IN OUT NOCOPY BOOLEAN,
848: p_s_log_type VARCHAR2,
849: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE,
850: p_birth_dt IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE,
851: p_sex IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.sex%TYPE,
852: p_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE,
853: p_govt_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE,
854: p_perm_resident_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE,

Line 851: p_sex IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.sex%TYPE,

847: p_logged_ind IN OUT NOCOPY BOOLEAN,
848: p_s_log_type VARCHAR2,
849: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE,
850: p_birth_dt IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE,
851: p_sex IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.sex%TYPE,
852: p_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE,
853: p_govt_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE,
854: p_perm_resident_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE,
855: p_govt_perm_resident_cd IN OUT NOCOPY

Line 852: p_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE,

848: p_s_log_type VARCHAR2,
849: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE,
850: p_birth_dt IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE,
851: p_sex IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.sex%TYPE,
852: p_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE,
853: p_govt_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE,
854: p_perm_resident_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE,
855: p_govt_perm_resident_cd IN OUT NOCOPY
856: IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE)

Line 853: p_govt_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE,

849: p_creation_dt IGS_GE_S_LOG.creation_dt%TYPE,
850: p_birth_dt IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE,
851: p_sex IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.sex%TYPE,
852: p_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE,
853: p_govt_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE,
854: p_perm_resident_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE,
855: p_govt_perm_resident_cd IN OUT NOCOPY
856: IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE)
857: AS

Line 854: p_perm_resident_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE,

850: p_birth_dt IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.birth_dt%TYPE,
851: p_sex IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.sex%TYPE,
852: p_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE,
853: p_govt_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE,
854: p_perm_resident_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE,
855: p_govt_perm_resident_cd IN OUT NOCOPY
856: IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE)
857: AS
858: gv_other_detail VARCHAR2(255);

Line 856: IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE)

852: p_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE,
853: p_govt_citizenship_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE,
854: p_perm_resident_cd IN OUT NOCOPY IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE,
855: p_govt_perm_resident_cd IN OUT NOCOPY
856: IGS_ST_GOVT_STDNT_EN.govt_perm_resident_cd%TYPE)
857: AS
858: gv_other_detail VARCHAR2(255);
859: GE_SCA_NOTFOUND EXCEPTION;
860: BEGIN

Line 1318: IGS_ST_GOVT_STDNT_EN_PKG.DELETE_ROW(

1314: END;
1315: BEGIN
1316: FOR v_gse_upd_rec IN c_gse_upd LOOP
1317:
1318: IGS_ST_GOVT_STDNT_EN_PKG.DELETE_ROW(
1319: X_ROWID => v_gse_upd_rec.rowid);
1320: END LOOP;
1321: EXCEPTION
1322: WHEN e_resource_busy THEN

Line 1727: IGS_ST_GOVT_STDNT_EN_PKG.INSERT_ROW(

1723: BEGIN
1724:
1725: -- to insert row using insertrow of the respective TBH package
1726:
1727: IGS_ST_GOVT_STDNT_EN_PKG.INSERT_ROW(
1728: X_ROWID => v_rowid,
1729: X_SUBMISSION_YR => p_submission_yr,
1730: X_SUBMISSION_NUMBER => p_submission_number,
1731: X_PERSON_ID => v_enr_snpsht_rec.person_id,

Line 2170: -- update IGS_ST_GOVT_STDNT_EN table

2166: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
2167: IGS_GE_MSG_STACK.ADD;
2168: App_Exception.Raise_Exception;
2169: END IF;
2170: -- update IGS_ST_GOVT_STDNT_EN table
2171: BEGIN
2172: FOR v_gse_upd3_rec IN c_gse_upd3(
2173: v_gse_att_mode.person_id,
2174: v_gse_att_mode.course_cd) LOOP

Line 2178: IGS_ST_GOVT_STDNT_EN_PKG.UPDATE_ROW(

2174: v_gse_att_mode.course_cd) LOOP
2175:
2176: v_gse_upd3_rec.attendance_mode := v_attendance_mode;
2177: v_gse_upd3_rec.govt_attendance_mode := v_govt_attendance_mode;
2178: IGS_ST_GOVT_STDNT_EN_PKG.UPDATE_ROW(
2179: X_ROWID => v_gse_upd3_rec.rowid,
2180: X_SUBMISSION_YR => v_gse_upd3_rec.submission_yr,
2181: X_SUBMISSION_NUMBER => v_gse_upd3_rec.submission_number,
2182: X_PERSON_ID => v_gse_upd3_rec.person_id,

Line 2260: -- select records from IGS_ST_GOVT_STDNT_EN which

2256: IGS_GE_MSG_STACK.ADD;
2257: App_Exception.Raise_Exception;
2258: END IF;
2259: CLOSE c_att;
2260: -- select records from IGS_ST_GOVT_STDNT_EN which
2261: -- the SUM(eftsu) is greater than the lower_enr_load_range
2262: FOR v_gse IN c_gse(v_lower_enr_load_range) LOOP
2263: -- update the IGS_ST_GOVT_STDNT_EN record
2264: BEGIN

Line 2263: -- update the IGS_ST_GOVT_STDNT_EN record

2259: CLOSE c_att;
2260: -- select records from IGS_ST_GOVT_STDNT_EN which
2261: -- the SUM(eftsu) is greater than the lower_enr_load_range
2262: FOR v_gse IN c_gse(v_lower_enr_load_range) LOOP
2263: -- update the IGS_ST_GOVT_STDNT_EN record
2264: BEGIN
2265: FOR v_gse_upd2_rec IN c_gse_upd2(v_gse.person_id) LOOP
2266:
2267: v_gse_upd2_rec.attendance_type := v_attendance_type;

Line 2269: IGS_ST_GOVT_STDNT_EN_PKG.UPDATE_ROW(

2265: FOR v_gse_upd2_rec IN c_gse_upd2(v_gse.person_id) LOOP
2266:
2267: v_gse_upd2_rec.attendance_type := v_attendance_type;
2268: v_gse_upd2_rec.govt_attendance_type := v_govt_attendance_type;
2269: IGS_ST_GOVT_STDNT_EN_PKG.UPDATE_ROW(
2270: X_ROWID => v_gse_upd2_rec.rowid,
2271: X_SUBMISSION_YR => v_gse_upd2_rec.submission_yr,
2272: X_SUBMISSION_NUMBER => v_gse_upd2_rec.submission_number,
2273: X_PERSON_ID => v_gse_upd2_rec.person_id,

Line 2366: -- update the IGS_ST_GOVT_STDNT_EN record

2362: ELSE
2363: v_major_course := 3; -- minor IGS_PS_COURSE
2364: END IF;
2365: v_flag := FALSE;
2366: -- update the IGS_ST_GOVT_STDNT_EN record
2367: BEGIN
2368: FOR v_gse_upd3_rec IN c_gse_upd3(
2369: v_person_id,
2370: v_gse_sca.course_cd) LOOP

Line 2374: IGS_ST_GOVT_STDNT_EN_PKG.UPDATE_ROW(

2370: v_gse_sca.course_cd) LOOP
2371:
2372: v_gse_upd3_rec.major_course := v_major_course;
2373:
2374: IGS_ST_GOVT_STDNT_EN_PKG.UPDATE_ROW(
2375: X_ROWID => v_gse_upd3_rec.rowid,
2376: X_SUBMISSION_YR => v_gse_upd3_rec.submission_yr,
2377: X_SUBMISSION_NUMBER => v_gse_upd3_rec.submission_number,
2378: X_PERSON_ID => v_gse_upd3_rec.person_id,

Line 2525: IGS_ST_GOVT_STDNT_EN_PKG.UPDATE_ROW(

2521: BEGIN
2522:
2523: v_gse_upd_comm_rec.commencement_dt := v_derived_commencement_dt;
2524:
2525: IGS_ST_GOVT_STDNT_EN_PKG.UPDATE_ROW(
2526: X_ROWID => v_gse_upd_comm_rec.rowid,
2527: X_SUBMISSION_YR => v_gse_upd_comm_rec.submission_yr,
2528: X_SUBMISSION_NUMBER => v_gse_upd_comm_rec.submission_number,
2529: X_PERSON_ID => v_gse_upd_comm_rec.person_id,

Line 3084: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE,

3080: sua.course_cd = cp_course_cd AND
3081: sua.uoo_id = cp_uoo_id
3082: ORDER BY sua.last_update_date DESC;
3083: CURSOR c_gse (
3084: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE,
3085: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE) IS
3086: SELECT gse.person_id,
3087: gse.course_cd,
3088: gse.version_number,

Line 3085: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE) IS

3081: sua.uoo_id = cp_uoo_id
3082: ORDER BY sua.last_update_date DESC;
3083: CURSOR c_gse (
3084: cp_person_id IGS_ST_GOVT_STDNT_EN.person_id%TYPE,
3085: cp_course_cd IGS_ST_GOVT_STDNT_EN.course_cd%TYPE) IS
3086: SELECT gse.person_id,
3087: gse.course_cd,
3088: gse.version_number,
3089: gse.citizenship_cd,

Line 3093: FROM IGS_ST_GOVT_STDNT_EN gse

3089: gse.citizenship_cd,
3090: gse.perm_resident_cd,
3091: gse.prior_degree,
3092: gse.prior_post_grad
3093: FROM IGS_ST_GOVT_STDNT_EN gse
3094: WHERE gse.submission_yr = p_submission_yr AND
3095: gse.submission_number = 1 AND -- Government Enrolment only sub 1
3096: gse.person_id = cp_person_id AND
3097: gse.course_cd = cp_course_cd;

Line 3199: v_old_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;

3195: v_new_units_rows NUMBER;
3196: v_record_found BOOLEAN DEFAULT FALSE;
3197: v_old_citizenship_cd IGS_ST_GVT_STDNT_LBL.citizenship_cd%TYPE;
3198: v_old_perm_resident_cd IGS_ST_GVT_STDNT_LBL.perm_resident_cd%TYPE;
3199: v_old_prior_degree IGS_ST_GOVT_STDNT_EN.prior_degree%TYPE;
3200: v_effective_dt DATE;
3201: v_char_date VARCHAR2(10);
3202: v_crv_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE;
3203: v_govt_reportable_ind VARCHAR2(1);

Line 3212: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;

3208: v_new_cntr NUMBER;
3209: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;
3210: v_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE;
3211: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
3212: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
3213: v_old_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
3214: v_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
3215: -- declaration for rowid and the sequence number variable
3216: v_rowid VARCHAR2(25);

Line 3213: v_old_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;

3209: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;
3210: v_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE;
3211: v_prior_degree IGS_PE_STATISTICS.prior_degree%TYPE;
3212: v_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
3213: v_old_prior_post_grad IGS_ST_GOVT_STDNT_EN.prior_post_grad%TYPE;
3214: v_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
3215: -- declaration for rowid and the sequence number variable
3216: v_rowid VARCHAR2(25);
3217: v_seqnum IGS_ST_GVT_SPSHT_CHG.sequence_number%type;