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_VAL_AODS dependencies on IGS_AD_OFRDFRMT_STAT

Line 49: -- Check if another IGS_AD_OFRDFRMT_STAT record exists with the system

45: p_s_adm_offer_dfrmnt_status IN VARCHAR2 ,
46: p_message_name OUT NOCOPY VARCHAR2 )
47: RETURN BOOLEAN AS
48: BEGIN -- ADMP_VAL_AODS_DFLT
49: -- Check if another IGS_AD_OFRDFRMT_STAT record exists with the system
50: -- default indicator set to 'Y'
51: DECLARE
52: v_count_rec NUMBER;
53: v_sys_def_ind IGS_AD_OFRDFRMT_STAT.system_default_ind%TYPE;

Line 53: v_sys_def_ind IGS_AD_OFRDFRMT_STAT.system_default_ind%TYPE;

49: -- Check if another IGS_AD_OFRDFRMT_STAT record exists with the system
50: -- default indicator set to 'Y'
51: DECLARE
52: v_count_rec NUMBER;
53: v_sys_def_ind IGS_AD_OFRDFRMT_STAT.system_default_ind%TYPE;
54: cst_yes CONSTANT CHAR := 'Y';
55: CURSOR c_count(cp_adm_offer_dfrmnt_status
56: IGS_AD_OFRDFRMT_STAT.adm_offer_dfrmnt_status%TYPE,
57: cp_s_adm_offer_dfrmnt_status

Line 56: IGS_AD_OFRDFRMT_STAT.adm_offer_dfrmnt_status%TYPE,

52: v_count_rec NUMBER;
53: v_sys_def_ind IGS_AD_OFRDFRMT_STAT.system_default_ind%TYPE;
54: cst_yes CONSTANT CHAR := 'Y';
55: CURSOR c_count(cp_adm_offer_dfrmnt_status
56: IGS_AD_OFRDFRMT_STAT.adm_offer_dfrmnt_status%TYPE,
57: cp_s_adm_offer_dfrmnt_status
58: IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE)IS
59: SELECT count(*),
60: system_default_ind

Line 58: IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE)IS

54: cst_yes CONSTANT CHAR := 'Y';
55: CURSOR c_count(cp_adm_offer_dfrmnt_status
56: IGS_AD_OFRDFRMT_STAT.adm_offer_dfrmnt_status%TYPE,
57: cp_s_adm_offer_dfrmnt_status
58: IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE)IS
59: SELECT count(*),
60: system_default_ind
61: FROM IGS_AD_OFRDFRMT_STAT aods
62: WHERE aods.adm_offer_dfrmnt_status <> cp_adm_offer_dfrmnt_status AND

Line 61: FROM IGS_AD_OFRDFRMT_STAT aods

57: cp_s_adm_offer_dfrmnt_status
58: IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE)IS
59: SELECT count(*),
60: system_default_ind
61: FROM IGS_AD_OFRDFRMT_STAT aods
62: WHERE aods.adm_offer_dfrmnt_status <> cp_adm_offer_dfrmnt_status AND
63: aods.s_adm_offer_dfrmnt_status = cp_s_adm_offer_dfrmnt_status AND
64: aods.system_default_ind = cst_yes
65: GROUP BY system_default_ind;