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_007 dependencies on IGS_AD_CNDNL_OFRSTAT

Line 645: v_adm_offer_status IGS_AD_CNDNL_OFRSTAT.s_adm_cndtnl_offer_status%TYPE;

641: RETURN VARCHAR2 IS
642: BEGIN --admp_get_sacos
643: --Get the s_adm_cndtnl_offer_status for a specified adm_cndtnl_offer_status
644: DECLARE
645: v_adm_offer_status IGS_AD_CNDNL_OFRSTAT.s_adm_cndtnl_offer_status%TYPE;
646: CURSOR c_acos IS
647: SELECT s_adm_cndtnl_offer_status
648: FROM IGS_AD_CNDNL_OFRSTAT
649: WHERE adm_cndtnl_offer_status = p_adm_cndtnl_offer_status;

Line 648: FROM IGS_AD_CNDNL_OFRSTAT

644: DECLARE
645: v_adm_offer_status IGS_AD_CNDNL_OFRSTAT.s_adm_cndtnl_offer_status%TYPE;
646: CURSOR c_acos IS
647: SELECT s_adm_cndtnl_offer_status
648: FROM IGS_AD_CNDNL_OFRSTAT
649: WHERE adm_cndtnl_offer_status = p_adm_cndtnl_offer_status;
650: BEGIN
651: --initialise v_adm_offer_status
652: v_adm_offer_status := NULL;