APPS.IGS_EN_VAL_DLA dependencies on IGS_CA_TYPE

Line 110: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;

106: RETURN BOOLEAN AS
107:
108: BEGIN
109: DECLARE
110: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
111: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
112: CURSOR c_ct IS
113: SELECT closed_ind,
114: s_cal_cat

Line 111: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

107:
108: BEGIN
109: DECLARE
110: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
111: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
112: CURSOR c_ct IS
113: SELECT closed_ind,
114: s_cal_cat
115: FROM IGS_CA_TYPE

Line 115: FROM IGS_CA_TYPE

111: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
112: CURSOR c_ct IS
113: SELECT closed_ind,
114: s_cal_cat
115: FROM IGS_CA_TYPE
116: WHERE cal_type = p_cal_type;
117: BEGIN
118: -- This function checks that the cal_type calendar category
119: -- is 'LOAD' and validates the closed indicator for an

Line 162: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;

158: RETURN BOOLEAN AS
159:
160: BEGIN
161: DECLARE
162: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
163: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
164: CURSOR c_ct IS
165: SELECT closed_ind,
166: s_cal_cat

Line 163: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

159:
160: BEGIN
161: DECLARE
162: v_closed_ind IGS_CA_TYPE.closed_ind%TYPE;
163: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
164: CURSOR c_ct IS
165: SELECT closed_ind,
166: s_cal_cat
167: FROM IGS_CA_TYPE

Line 167: FROM IGS_CA_TYPE

163: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
164: CURSOR c_ct IS
165: SELECT closed_ind,
166: s_cal_cat
167: FROM IGS_CA_TYPE
168: WHERE cal_type = p_cal_type;
169: BEGIN
170: -- This function checks that the cal_type calendar category
171: -- is 'TEACHING' and validates the closed indicator for an