APPS.IGS_AD_GEN_008 dependencies on IGS_AD_OFRDFRMT_STAT

Line 37: --Get the s_adm_offer_dfrmnt_status for a specified IGS_AD_OFRDFRMT_STAT.

33: p_adm_offer_dfrmnt_status IN VARCHAR2 )
34: RETURN VARCHAR2 IS
35: gv_other_detail VARCHAR2(255);
36: BEGIN --admp_get_saods
37: --Get the s_adm_offer_dfrmnt_status for a specified IGS_AD_OFRDFRMT_STAT.
38: DECLARE
39: v_dfrmnt_status IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE;
40: CURSOR c_aods IS
41: SELECT s_adm_offer_dfrmnt_status

Line 39: v_dfrmnt_status IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE;

35: gv_other_detail VARCHAR2(255);
36: BEGIN --admp_get_saods
37: --Get the s_adm_offer_dfrmnt_status for a specified IGS_AD_OFRDFRMT_STAT.
38: DECLARE
39: v_dfrmnt_status IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE;
40: CURSOR c_aods IS
41: SELECT s_adm_offer_dfrmnt_status
42: FROM IGS_AD_OFRDFRMT_STAT
43: WHERE adm_offer_dfrmnt_status = p_adm_offer_dfrmnt_status;

Line 42: FROM IGS_AD_OFRDFRMT_STAT

38: DECLARE
39: v_dfrmnt_status IGS_AD_OFRDFRMT_STAT.s_adm_offer_dfrmnt_status%TYPE;
40: CURSOR c_aods IS
41: SELECT s_adm_offer_dfrmnt_status
42: FROM IGS_AD_OFRDFRMT_STAT
43: WHERE adm_offer_dfrmnt_status = p_adm_offer_dfrmnt_status;
44: BEGIN
45: --initialise v_dfrmnt_status
46: v_dfrmnt_status := NULL;