APPS.IGS_AD_VAL_ACAI_STATUS dependencies on IGS_AD_APPL_STAT

Line 3381: v_closed_ind igs_ad_appl_stat.closed_ind%TYPE;

3377: FUNCTION admp_val_ais_closed( --arvsrini igsm
3378: p_appl_inst_status IN VARCHAR2 ,
3379: p_message_name OUT NOCOPY VARCHAR2 )
3380: RETURN BOOLEAN AS
3381: v_closed_ind igs_ad_appl_stat.closed_ind%TYPE;
3382: CURSOR c_ais IS
3383: SELECT ais.closed_ind
3384: FROM igs_ad_appl_stat ais
3385: WHERE ais.adm_appl_status = p_appl_inst_status;

Line 3384: FROM igs_ad_appl_stat ais

3380: RETURN BOOLEAN AS
3381: v_closed_ind igs_ad_appl_stat.closed_ind%TYPE;
3382: CURSOR c_ais IS
3383: SELECT ais.closed_ind
3384: FROM igs_ad_appl_stat ais
3385: WHERE ais.adm_appl_status = p_appl_inst_status;
3386: BEGIN
3387: -- Validate if igs_ad_appl_stat.adm_appl_status is closed.
3388: OPEN c_ais;

Line 3387: -- Validate if igs_ad_appl_stat.adm_appl_status is closed.

3383: SELECT ais.closed_ind
3384: FROM igs_ad_appl_stat ais
3385: WHERE ais.adm_appl_status = p_appl_inst_status;
3386: BEGIN
3387: -- Validate if igs_ad_appl_stat.adm_appl_status is closed.
3388: OPEN c_ais;
3389: FETCH c_ais INTO v_closed_ind;
3390: IF (c_ais%FOUND) THEN
3391: IF (v_closed_ind = 'Y') THEN