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_PS_APPL_INST_ALL

Line 2013: p_old_outcome_status IN igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,

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
2017: ) RETURN VARCHAR2 IS

Line 2014: p_new_outcome_status IN igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,

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
2017: ) RETURN VARCHAR2 IS
2018:

Line 2015: p_old_adm_offer_resp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,

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
2017: ) RETURN VARCHAR2 IS
2018:
2019: /*************************************************************

Line 2042: cp_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE) IS

2038:
2039: --Cursor to get the decision code associated with the current outcome status and the new outcome status
2040:
2041: CURSOR c_decision_cd(cp_system_code igs_uc_app_choices.system_code%TYPE,
2042: cp_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE) IS
2043: SELECT decision_code
2044: FROM igs_uc_map_out_stat
2045: WHERE system_code = cp_system_code
2046: AND adm_outcome_status = cp_outcome_status

Line 2055: cp_adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE) IS

2051: -- Cursor to find out if the reply code of Firm Acceptance is mapped to the decision code returned from the cursor (c_decision_cd) with the old outcome status
2052:
2053: CURSOR c_curr_off_resp_status (cp_system_code igs_uc_app_choices.system_code%TYPE,
2054: cp_decision_code igs_uc_map_out_stat.decision_code%TYPE,
2055: cp_adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE) IS
2056: SELECT 'X'
2057: FROM igs_uc_map_off_resp
2058: WHERE decision_code= cp_decision_code
2059: AND system_code = cp_system_code