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_TRAN_PROCESSOR_PKG dependencies on IGS_AD_APPL_ALL

Line 2011: p_alt_appl_id IN igs_ad_appl_all.alt_appl_id%TYPE,

2007:
2008: END trans_write;
2009:
2010: FUNCTION get_adm_offer_resp_stat (
2011: p_alt_appl_id IN igs_ad_appl_all.alt_appl_id%TYPE,
2012: p_choice_number IN igs_ad_appl_all.choice_number%TYPE,
2013: p_old_outcome_status IN igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
2014: p_new_outcome_status IN igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
2015: p_old_adm_offer_resp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,

Line 2012: p_choice_number IN igs_ad_appl_all.choice_number%TYPE,

2008: END trans_write;
2009:
2010: FUNCTION get_adm_offer_resp_stat (
2011: p_alt_appl_id IN igs_ad_appl_all.alt_appl_id%TYPE,
2012: p_choice_number IN igs_ad_appl_all.choice_number%TYPE,
2013: p_old_outcome_status IN igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
2014: p_new_outcome_status IN igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
2015: p_old_adm_offer_resp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
2016: p_message_name OUT NOCOPY VARCHAR2

Line 2032: CURSOR c_sys_cd (cp_alt_appl_id igs_ad_appl_all.alt_appl_id%TYPE ) IS

2028: *************************************************************/
2029:
2030: -- Cursor to find the system code associated with the UCAS application
2031:
2032: CURSOR c_sys_cd (cp_alt_appl_id igs_ad_appl_all.alt_appl_id%TYPE ) IS
2033: SELECT system_code
2034: FROM igs_uc_applicants
2035: WHERE TO_CHAR(app_no) = cp_alt_appl_id;
2036: