APPS.IGS_EN_VAL_ECPD dependencies on IGS_EN_CAT_PRC_DTL

Line 15: v_enrolment_cat IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE;

11:
12: BEGIN
13: DECLARE
14: v_search_comm VARCHAR2(30);
15: v_enrolment_cat IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE;
16: CURSOR c_ecpd1 IS
17: SELECT ecpd.enrolment_cat
18: FROM IGS_EN_CAT_PRC_DTL ecpd
19: WHERE ecpd.enrolment_cat = p_enrolment_cat AND

Line 18: FROM IGS_EN_CAT_PRC_DTL ecpd

14: v_search_comm VARCHAR2(30);
15: v_enrolment_cat IGS_EN_CAT_PRC_DTL.enrolment_cat%TYPE;
16: CURSOR c_ecpd1 IS
17: SELECT ecpd.enrolment_cat
18: FROM IGS_EN_CAT_PRC_DTL ecpd
19: WHERE ecpd.enrolment_cat = p_enrolment_cat AND
20: ecpd.enr_method_type = p_enr_method_type AND
21: ecpd.s_student_comm_type = 'ALL';
22: CURSOR c_ecpd2 IS

Line 24: FROM IGS_EN_CAT_PRC_DTL ecpd

20: ecpd.enr_method_type = p_enr_method_type AND
21: ecpd.s_student_comm_type = 'ALL';
22: CURSOR c_ecpd2 IS
23: SELECT ecpd.enrolment_cat
24: FROM IGS_EN_CAT_PRC_DTL ecpd
25: WHERE ecpd.enrolment_cat = p_enrolment_cat AND
26: ecpd.enr_method_type = p_enr_method_type AND
27: ecpd.s_student_comm_type in ('NEW','RETURN');
28: BEGIN

Line 29: -- Validate the commencement type for the IGS_EN_CAT_PRC_DTL;

25: WHERE ecpd.enrolment_cat = p_enrolment_cat AND
26: ecpd.enr_method_type = p_enr_method_type AND
27: ecpd.s_student_comm_type in ('NEW','RETURN');
28: BEGIN
29: -- Validate the commencement type for the IGS_EN_CAT_PRC_DTL;
30: -- All can not be used when there is a specific (being NEW or RETURN)
31: -- record for the same enrolment_cat/enr_method_type combination.
32: -- Set the default message number
33: p_message_name := null;

Line 75: cp_enr_method_type IGS_EN_CAT_PRC_DTL.enr_method_type%TYPE) IS

71: BEGIN
72: DECLARE
73: v_closed_ind IGS_EN_METHOD_TYPE.closed_ind%TYPE;
74: CURSOR c_enr_method_type(
75: cp_enr_method_type IGS_EN_CAT_PRC_DTL.enr_method_type%TYPE) IS
76: SELECT closed_ind
77: FROM IGS_EN_METHOD_TYPE
78: WHERE enr_method_type = cp_enr_method_type;
79: v_other_detail VARCHAR2(255);