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_UC_EXPORT_DECISION_REPLY dependencies on IGS_AD_OFFRESP_INT_S

Line 1632: p_sequence_number igs_ad_offresp_int.sequence_number%TYPE ) IS

1628: -- Cursor to check for the error or pending records in the Offer Response Import Process
1629: CURSOR cur_reply_import_error ( p_person_id igs_ad_offresp_int.person_id%TYPE,
1630: p_admission_appl_number igs_ad_offresp_int.admission_appl_number%TYPE,
1631: p_nominated_course_cd igs_ad_offresp_int.nominated_course_cd%TYPE,
1632: p_sequence_number igs_ad_offresp_int.sequence_number%TYPE ) IS
1633: SELECT 'X'
1634: FROM igs_ad_offresp_int
1635: WHERE person_id = p_person_id
1636: AND admission_appl_number = p_admission_appl_number

Line 1881: ( igs_ad_offresp_int_s.NEXTVAL,

1877: program_update_date,
1878: program_id,
1879: decline_ofr_reason)
1880: VALUES
1881: ( igs_ad_offresp_int_s.NEXTVAL,
1882: l_batch_id,
1883: cur_oss_appl_inst_rec.person_id,
1884: cur_oss_appl_inst_rec.admission_appl_number,
1885: cur_oss_appl_inst_rec.nominated_course_cd,