APPS.IGS_AD_VAL_APCOO dependencies on IGS_EN_ATD_MODE

Line 616: -- Validate if IGS_EN_ATD_MODE.attendance_mod is closed.

612: p_message_name OUT NOCOPY VARCHAR2 )
613: RETURN BOOLEAN IS
614: gv_other_detail VARCHAR2(255);
615: BEGIN -- crsp_val_am_closed
616: -- Validate if IGS_EN_ATD_MODE.attendance_mod is closed.
617: DECLARE
618: v_closed_ind IGS_EN_ATD_MODE.closed_ind%TYPE;
619: v_ret_val BOOLEAN DEFAULT TRUE;
620: CURSOR c_am IS

Line 618: v_closed_ind IGS_EN_ATD_MODE.closed_ind%TYPE;

614: gv_other_detail VARCHAR2(255);
615: BEGIN -- crsp_val_am_closed
616: -- Validate if IGS_EN_ATD_MODE.attendance_mod is closed.
617: DECLARE
618: v_closed_ind IGS_EN_ATD_MODE.closed_ind%TYPE;
619: v_ret_val BOOLEAN DEFAULT TRUE;
620: CURSOR c_am IS
621: SELECT closed_ind
622: FROM IGS_EN_ATD_MODE

Line 622: FROM IGS_EN_ATD_MODE

618: v_closed_ind IGS_EN_ATD_MODE.closed_ind%TYPE;
619: v_ret_val BOOLEAN DEFAULT TRUE;
620: CURSOR c_am IS
621: SELECT closed_ind
622: FROM IGS_EN_ATD_MODE
623: WHERE attendance_mode = p_attendance_mode;
624: BEGIN
625: p_message_name := Null;
626: OPEN c_am;