APPS.IGS_CA_VAL_CAT dependencies on IGS_CA_ARTS_TC_CA_CD

Line 57: v_closed_ind IGS_CA_ARTS_TC_CA_CD.closed_ind%TYPE;

53: RETURN BOOLEAN AS
54: gv_other_detail VARCHAR2(255);
55: BEGIN
56: DECLARE
57: v_closed_ind IGS_CA_ARTS_TC_CA_CD.closed_ind%TYPE;
58: CURSOR c_atctc IS
59: SELECT atctc.closed_ind
60: FROM IGS_CA_ARTS_TC_CA_CD atctc
61: WHERE atctc.ARTS_TEACHING_CAL_TYPE_CD = p_arts_teaching_cal_type_cd;

Line 60: FROM IGS_CA_ARTS_TC_CA_CD atctc

56: DECLARE
57: v_closed_ind IGS_CA_ARTS_TC_CA_CD.closed_ind%TYPE;
58: CURSOR c_atctc IS
59: SELECT atctc.closed_ind
60: FROM IGS_CA_ARTS_TC_CA_CD atctc
61: WHERE atctc.ARTS_TEACHING_CAL_TYPE_CD = p_arts_teaching_cal_type_cd;
62: BEGIN
63: -- Validate if IGS_CA_ARTS_TC_CA_CD.ARTS_TEACHING_CAL_TYPE_CD is closed.
64: OPEN c_atctc;

Line 63: -- Validate if IGS_CA_ARTS_TC_CA_CD.ARTS_TEACHING_CAL_TYPE_CD is closed.

59: SELECT atctc.closed_ind
60: FROM IGS_CA_ARTS_TC_CA_CD atctc
61: WHERE atctc.ARTS_TEACHING_CAL_TYPE_CD = p_arts_teaching_cal_type_cd;
62: BEGIN
63: -- Validate if IGS_CA_ARTS_TC_CA_CD.ARTS_TEACHING_CAL_TYPE_CD is closed.
64: OPEN c_atctc;
65: FETCH c_atctc INTO v_closed_ind;
66: IF (c_atctc%FOUND) THEN
67: IF (v_closed_ind = 'Y') THEN