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_AD_GEN_002 dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 3842: CURSOR c_get_applicant(cp_person_id igs_pe_typ_instances_all.person_id%TYPE,

3838: cur_ad_ps_appl_rec cur_ad_ps_appl%ROWTYPE ;
3839:
3840:
3841:
3842: CURSOR c_get_applicant(cp_person_id igs_pe_typ_instances_all.person_id%TYPE,
3843: cp_admission_appl_number igs_pe_typ_instances_all.admission_appl_number%TYPE,
3844: cp_nominated_course_cd igs_pe_typ_instances_all.nominated_course_cd%TYPE) IS
3845: SELECT pti.rowid,pti.*
3846: FROM igs_pe_typ_instances_all pti

Line 3843: cp_admission_appl_number igs_pe_typ_instances_all.admission_appl_number%TYPE,

3839:
3840:
3841:
3842: CURSOR c_get_applicant(cp_person_id igs_pe_typ_instances_all.person_id%TYPE,
3843: cp_admission_appl_number igs_pe_typ_instances_all.admission_appl_number%TYPE,
3844: cp_nominated_course_cd igs_pe_typ_instances_all.nominated_course_cd%TYPE) IS
3845: SELECT pti.rowid,pti.*
3846: FROM igs_pe_typ_instances_all pti
3847: WHERE pti.person_type_code IN (SELECT pt.person_type_code FROM Igs_pe_person_types pt WHERE pt.system_type = 'APPLICANT')

Line 3844: cp_nominated_course_cd igs_pe_typ_instances_all.nominated_course_cd%TYPE) IS

3840:
3841:
3842: CURSOR c_get_applicant(cp_person_id igs_pe_typ_instances_all.person_id%TYPE,
3843: cp_admission_appl_number igs_pe_typ_instances_all.admission_appl_number%TYPE,
3844: cp_nominated_course_cd igs_pe_typ_instances_all.nominated_course_cd%TYPE) IS
3845: SELECT pti.rowid,pti.*
3846: FROM igs_pe_typ_instances_all pti
3847: WHERE pti.person_type_code IN (SELECT pt.person_type_code FROM Igs_pe_person_types pt WHERE pt.system_type = 'APPLICANT')
3848: AND pti.person_id = cp_person_id

Line 3846: FROM igs_pe_typ_instances_all pti

3842: CURSOR c_get_applicant(cp_person_id igs_pe_typ_instances_all.person_id%TYPE,
3843: cp_admission_appl_number igs_pe_typ_instances_all.admission_appl_number%TYPE,
3844: cp_nominated_course_cd igs_pe_typ_instances_all.nominated_course_cd%TYPE) IS
3845: SELECT pti.rowid,pti.*
3846: FROM igs_pe_typ_instances_all pti
3847: WHERE pti.person_type_code IN (SELECT pt.person_type_code FROM Igs_pe_person_types pt WHERE pt.system_type = 'APPLICANT')
3848: AND pti.person_id = cp_person_id
3849: AND pti.admission_appl_number = cp_admission_appl_number
3850: AND pti.nominated_course_cd = cp_nominated_course_cd