APPS.IGS_AD_VAL_ACAIU dependencies on IGS_AD_UNIT_OU_STAT

Line 422: v_s_adm_outcome_status_auos IGS_AD_UNIT_OU_STAT.s_adm_outcome_status%TYPE;

418: cst_withdrawn CONSTANT VARCHAR2(9) :='WITHDRAWN';
419: cst_voided CONSTANT VARCHAR2(6) :='VOIDED';
420: v_message_name VARCHAR2(30);
421: v_s_adm_outcome_status_aos IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
422: v_s_adm_outcome_status_auos IGS_AD_UNIT_OU_STAT.s_adm_outcome_status%TYPE;
423: CURSOR c_aos IS
424: SELECT aos.s_adm_outcome_status
425: FROM IGS_AD_PS_APPL_INST acai,
426: IGS_AD_OU_STAT aos

Line 724: --Validate if IGS_AD_UNIT_OU_STAT.adm_unit_outcome_status is closed

720: p_adm_unit_outcome_status IN VARCHAR2 ,
721: p_message_name OUT NOCOPY VARCHAR2 )
722: RETURN BOOLEAN AS
723: BEGIN --admp_val_auos_closed
724: --Validate if IGS_AD_UNIT_OU_STAT.adm_unit_outcome_status is closed
725: DECLARE
726: v_auos_exists VARCHAR2(1);
727: CURSOR c_auos IS
728: SELECT 'x'

Line 729: FROM IGS_AD_UNIT_OU_STAT auos

725: DECLARE
726: v_auos_exists VARCHAR2(1);
727: CURSOR c_auos IS
728: SELECT 'x'
729: FROM IGS_AD_UNIT_OU_STAT auos
730: WHERE adm_unit_outcome_status = p_adm_unit_outcome_status AND
731: closed_ind = 'Y';
732: BEGIN
733: --set the default message number