APPS.IGS_AD_VAL_ACA dependencies on IGS_AD_BASIS_FOR_AD

Line 425: -- Validate if IGS_AD_BASIS_FOR_AD.basis_for_admission_type is closed.

421: IGS_GE_MSG_STACK.ADD;
422: App_Exception.Raise_Exception;
423: END admp_val_aco_closed;
424: --
425: -- Validate if IGS_AD_BASIS_FOR_AD.basis_for_admission_type is closed.
426: FUNCTION admp_val_bfa_closed(
427: p_basis_for_admission_type IN VARCHAR2 ,
428: p_message_name OUT NOCOPY VARCHAR2 )
429: RETURN BOOLEAN IS

Line 432: v_closed_ind IGS_AD_BASIS_FOR_AD.closed_ind%TYPE;

428: p_message_name OUT NOCOPY VARCHAR2 )
429: RETURN BOOLEAN IS
430: BEGIN
431: DECLARE
432: v_closed_ind IGS_AD_BASIS_FOR_AD.closed_ind%TYPE;
433: CURSOR c_bfa IS
434: SELECT bfa.closed_ind
435: FROM IGS_AD_BASIS_FOR_AD bfa
436: WHERE bfa.basis_for_admission_type = p_basis_for_admission_type;

Line 435: FROM IGS_AD_BASIS_FOR_AD bfa

431: DECLARE
432: v_closed_ind IGS_AD_BASIS_FOR_AD.closed_ind%TYPE;
433: CURSOR c_bfa IS
434: SELECT bfa.closed_ind
435: FROM IGS_AD_BASIS_FOR_AD bfa
436: WHERE bfa.basis_for_admission_type = p_basis_for_admission_type;
437: BEGIN
438: -- Validate if IGS_AD_BASIS_FOR_AD.basis_for_admission_type is closed.
439: OPEN c_bfa;

Line 438: -- Validate if IGS_AD_BASIS_FOR_AD.basis_for_admission_type is closed.

434: SELECT bfa.closed_ind
435: FROM IGS_AD_BASIS_FOR_AD bfa
436: WHERE bfa.basis_for_admission_type = p_basis_for_admission_type;
437: BEGIN
438: -- Validate if IGS_AD_BASIS_FOR_AD.basis_for_admission_type is closed.
439: OPEN c_bfa;
440: FETCH c_bfa INTO v_closed_ind;
441: IF (c_bfa%FOUND) THEN
442: IF (v_closed_ind = 'Y') THEN