DBA Data[Home] [Help]

APPS.IGS_EN_VAL_SCAE dependencies on IGS_EN_ENROLMENT_CAT

Line 14: FROM IGS_EN_ENROLMENT_CAT

10: DECLARE
11: v_closed_ind VARCHAR2(1);
12: CURSOR c_enrolment_cat IS
13: SELECT closed_ind
14: FROM IGS_EN_ENROLMENT_CAT
15: WHERE enrolment_cat = p_enrolment_cat;
16: BEGIN
17: -- Validate if stdnt_crs_atmpt_enr.enrolment_cat is open
18: p_message_name := null;

Line 29: -- IGS_EN_ENROLMENT_CAT is closed

25: CLOSE c_enrolment_cat;
26: IF (v_closed_ind = 'N') THEN
27: RETURN TRUE;
28: END IF;
29: -- IGS_EN_ENROLMENT_CAT is closed
30: p_message_name := 'IGS_EN_ENR_CAT_CLOSED';
31: RETURN FALSE;
32: EXCEPTION
33: WHEN OTHERS THEN