APPS.IGS_PS_VAL_ATL dependencies on IGS_EN_ATD_TYPE_LOAD

Line 30: -- closed indicator for an IGS_EN_ATD_TYPE_LOAD record

26: FROM IGS_CA_TYPE
27: WHERE cal_type = p_cal_type;
28: BEGIN
29: -- This module validates the clendar category and
30: -- closed indicator for an IGS_EN_ATD_TYPE_LOAD record
31: -- being inserted.
32: p_message_name := NULL;
33: OPEN c_ci_scc_ct;
34: FETCH c_ci_scc_ct into v_closed_ind,

Line 75: v_p_lower_enr_load_range IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;

71: p_message_name OUT NOCOPY VARCHAR2 )
72: RETURN boolean AS
73: BEGIN
74: DECLARE
75: v_p_lower_enr_load_range IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
76: v_p_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;
77: CURSOR c_lelr_uelr IS
78: SELECT lower_enr_load_range,
79: upper_enr_load_range

Line 76: v_p_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;

72: RETURN boolean AS
73: BEGIN
74: DECLARE
75: v_p_lower_enr_load_range IGS_EN_ATD_TYPE_LOAD.lower_enr_load_range%TYPE;
76: v_p_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;
77: CURSOR c_lelr_uelr IS
78: SELECT lower_enr_load_range,
79: upper_enr_load_range
80: FROM IGS_EN_ATD_TYPE_LOAD

Line 80: FROM IGS_EN_ATD_TYPE_LOAD

76: v_p_upper_enr_load_range IGS_EN_ATD_TYPE_LOAD.upper_enr_load_range%TYPE;
77: CURSOR c_lelr_uelr IS
78: SELECT lower_enr_load_range,
79: upper_enr_load_range
80: FROM IGS_EN_ATD_TYPE_LOAD
81: WHERE cal_type = p_cal_type AND
82: attendance_type <> p_attendance_type AND
83: ((p_lower_enr_load_range >= lower_enr_load_range AND
84: p_lower_enr_load_range <= upper_enr_load_range) OR

Line 92: -- overlaps between more than one IGS_EN_ATD_TYPE_LOAD record in

88: p_upper_enr_load_range > upper_enr_load_range));
89: BEGIN
90: -- This module validates the attendance type load range for
91: -- a lower range which exceeds an upper range and
92: -- overlaps between more than one IGS_EN_ATD_TYPE_LOAD record in
93: -- the same load calendar type.
94: p_message_name := NULL;
95: IF (p_lower_enr_load_range > p_upper_enr_load_range) THEN
96: p_message_name := 'IGS_PS_LOW_ENRLOAD_BELOW';