APPS.IGS_AD_GEN_008 dependencies on IGS_AD_UNIT_OU_STAT

Line 113: --Get the s_adm_unit_outcome_status for a specified IGS_AD_UNIT_OU_STAT

109: p_adm_unit_outcome_status IN VARCHAR2 )
110: RETURN VARCHAR2 IS
111: gv_other_detail VARCHAR2(255);
112: BEGIN --admp_get_sauos
113: --Get the s_adm_unit_outcome_status for a specified IGS_AD_UNIT_OU_STAT
114: DECLARE
115: v_adm_unit_outcome_status IGS_AD_UNIT_OU_STAT.s_adm_outcome_status%TYPE;
116: CURSOR c_auos IS
117: SELECT auos.s_adm_outcome_status

Line 115: v_adm_unit_outcome_status IGS_AD_UNIT_OU_STAT.s_adm_outcome_status%TYPE;

111: gv_other_detail VARCHAR2(255);
112: BEGIN --admp_get_sauos
113: --Get the s_adm_unit_outcome_status for a specified IGS_AD_UNIT_OU_STAT
114: DECLARE
115: v_adm_unit_outcome_status IGS_AD_UNIT_OU_STAT.s_adm_outcome_status%TYPE;
116: CURSOR c_auos IS
117: SELECT auos.s_adm_outcome_status
118: FROM IGS_AD_UNIT_OU_STAT auos
119: WHERE auos.adm_unit_outcome_status = p_adm_unit_outcome_status;

Line 118: FROM IGS_AD_UNIT_OU_STAT auos

114: DECLARE
115: v_adm_unit_outcome_status IGS_AD_UNIT_OU_STAT.s_adm_outcome_status%TYPE;
116: CURSOR c_auos IS
117: SELECT auos.s_adm_outcome_status
118: FROM IGS_AD_UNIT_OU_STAT auos
119: WHERE auos.adm_unit_outcome_status = p_adm_unit_outcome_status;
120: BEGIN
121: --initialise v_adm_unit_outcome_status
122: v_adm_unit_outcome_status := NULL;