APPS.IGS_AD_GEN_008 dependencies on IGS_AD_OFR_RESP_STAT

Line 65: --Get the s_adm_offer_resp_status for a specified IGS_AD_OFR_RESP_STAT.

61: p_adm_offer_resp_status IN VARCHAR2 )
62: RETURN VARCHAR2 IS
63: gv_other_detail VARCHAR2(255);
64: BEGIN --admp_get_saors
65: --Get the s_adm_offer_resp_status for a specified IGS_AD_OFR_RESP_STAT.
66: DECLARE
67: v_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
68: CURSOR c_aors IS
69: SELECT s_adm_offer_resp_status

Line 67: v_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;

63: gv_other_detail VARCHAR2(255);
64: BEGIN --admp_get_saors
65: --Get the s_adm_offer_resp_status for a specified IGS_AD_OFR_RESP_STAT.
66: DECLARE
67: v_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
68: CURSOR c_aors IS
69: SELECT s_adm_offer_resp_status
70: FROM IGS_AD_OFR_RESP_STAT
71: WHERE adm_offer_resp_status = p_adm_offer_resp_status;

Line 70: FROM IGS_AD_OFR_RESP_STAT

66: DECLARE
67: v_resp_status IGS_AD_OFR_RESP_STAT.s_adm_offer_resp_status%TYPE;
68: CURSOR c_aors IS
69: SELECT s_adm_offer_resp_status
70: FROM IGS_AD_OFR_RESP_STAT
71: WHERE adm_offer_resp_status = p_adm_offer_resp_status;
72: BEGIN
73: --initialise v_resp_status
74: v_resp_status := NULL;