APPS.IGS_AD_VAL_AORS dependencies on IGS_AD_OFR_RESP_STAT

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

45: p_s_adm_offer_resp_status IN VARCHAR2 ,
46: p_message_name OUT NOCOPY VARCHAR2 )
47: RETURN BOOLEAN AS
48: BEGIN -- ADMP_VAL_AORS_DFLT
49: -- Check if another IGS_AD_OFR_RESP_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_OFR_RESP_STAT.system_default_ind%TYPE;

Line 53: v_sys_def_ind IGS_AD_OFR_RESP_STAT.system_default_ind%TYPE;

49: -- Check if another IGS_AD_OFR_RESP_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_OFR_RESP_STAT.system_default_ind%TYPE;
54: CURSOR c_count IS
55: SELECT count(*),
56: system_default_ind
57: FROM IGS_AD_OFR_RESP_STAT aors

Line 57: FROM IGS_AD_OFR_RESP_STAT aors

53: v_sys_def_ind IGS_AD_OFR_RESP_STAT.system_default_ind%TYPE;
54: CURSOR c_count IS
55: SELECT count(*),
56: system_default_ind
57: FROM IGS_AD_OFR_RESP_STAT aors
58: WHERE aors.adm_offer_resp_status <> p_adm_offer_resp_status AND
59: aors.s_adm_offer_resp_status = p_s_adm_offer_resp_status AND
60: aors.system_default_ind = 'Y'
61: GROUP BY system_default_ind;