DBA Data[Home] [Help]

APPS.IGS_PS_VAL_COO dependencies on IGS_EN_ATD_MODE

Line 16: v_closed_ind IGS_EN_ATD_MODE.closed_ind%TYPE;

12: FUNCTION crsp_val_coo_am(
13: p_attendance_mode IN VARCHAR2 ,
14: p_message_name OUT NOCOPY VARCHAR2 )
15: RETURN BOOLEAN AS
16: v_closed_ind IGS_EN_ATD_MODE.closed_ind%TYPE;
17: CURSOR c_attendance_mode(
18: cp_attendance_mode IGS_EN_ATD_MODE.attendance_mode%TYPE)IS
19: SELECT closed_ind
20: FROM IGS_EN_ATD_MODE

Line 18: cp_attendance_mode IGS_EN_ATD_MODE.attendance_mode%TYPE)IS

14: p_message_name OUT NOCOPY VARCHAR2 )
15: RETURN BOOLEAN AS
16: v_closed_ind IGS_EN_ATD_MODE.closed_ind%TYPE;
17: CURSOR c_attendance_mode(
18: cp_attendance_mode IGS_EN_ATD_MODE.attendance_mode%TYPE)IS
19: SELECT closed_ind
20: FROM IGS_EN_ATD_MODE
21: WHERE attendance_mode = cp_attendance_mode;
22: BEGIN

Line 20: FROM IGS_EN_ATD_MODE

16: v_closed_ind IGS_EN_ATD_MODE.closed_ind%TYPE;
17: CURSOR c_attendance_mode(
18: cp_attendance_mode IGS_EN_ATD_MODE.attendance_mode%TYPE)IS
19: SELECT closed_ind
20: FROM IGS_EN_ATD_MODE
21: WHERE attendance_mode = cp_attendance_mode;
22: BEGIN
23: p_message_name := NULL;
24: OPEN c_attendance_mode(