APPS.IGS_EN_ELGBL_PERSON dependencies on IGS_EN_METHOD_TYPE

Line 96: l_enr_method_type igs_en_method_type.enr_method_type%TYPE;

92: -- smaddali 19-sep-04 For bug#3930876, removed the condition if l_person_type is not NULL and replaced it with p_person_type
93: -- before deriving the system person type, since this is a local variable
94: -------------------------------------------------------------------------------------
95:
96: l_enr_method_type igs_en_method_type.enr_method_type%TYPE;
97:
98: --
99: -- cursor to check whether the CHKENCUMB is overridden or not
100: --

Line 338: l_enr_method_type igs_en_method_type.enr_method_type%TYPE;

334: --Change History:
335: --Who When What
336: -------------------------------------------------------------------------------------
337:
338: l_enr_method_type igs_en_method_type.enr_method_type%TYPE;
339:
340: CURSOR get_enr_method IS
341: SELECT enr_method_type FROM igs_en_method_type
342: WHERE self_service = 'Y'

Line 341: SELECT enr_method_type FROM igs_en_method_type

337:
338: l_enr_method_type igs_en_method_type.enr_method_type%TYPE;
339:
340: CURSOR get_enr_method IS
341: SELECT enr_method_type FROM igs_en_method_type
342: WHERE self_service = 'Y'
343: AND closed_ind = 'N';
344:
345: --

Line 600: l_enr_method_type igs_en_method_type.enr_method_type%TYPE;

596: -- calling the function igs_ss_enr_details.get_notification.
597: --
598: -------------------------------------------------------------------------------------
599:
600: l_enr_method_type igs_en_method_type.enr_method_type%TYPE;
601:
602: --
603: -- cursor to fetch validation steps for the person type not equal to STUDENT
604: --

Line 1411: l_enr_method_type igs_en_method_type.enr_method_type%TYPE;

1407: -- svanukur 31-may-03 Converted the person?unit step timeslot validation step which can be configured for DENY or WARN
1408: -- Added a new parameter p_notification_flag and modified p_message to IN OUT as per the Deny/Warn behaviour build # 2829272
1409: -------------------------------------------------------------------------------------------------
1410:
1411: l_enr_method_type igs_en_method_type.enr_method_type%TYPE;
1412: l_step igs_en_cat_prc_step.s_enrolment_step_type%TYPE;
1413: l_vald_timeslot BOOLEAN;
1414: --
1415: -- cursor to check whether the step is oevrridden or not

Line 1711: CURSOR get_enr_method IS SELECT enr_method_type FROM igs_en_method_type

1707: --Change History:
1708: --Who When What
1709: -------------------------------------------------------------------------------------
1710:
1711: CURSOR get_enr_method IS SELECT enr_method_type FROM igs_en_method_type
1712: WHERE self_service = 'Y'
1713: AND closed_ind = 'N';
1714: l_comm_type VARCHAR2(100);
1715: l_enrolment_cat VARCHAR2(100);

Line 1716: l_enr_method_type igs_en_method_type.enr_method_type%TYPE;

1712: WHERE self_service = 'Y'
1713: AND closed_ind = 'N';
1714: l_comm_type VARCHAR2(100);
1715: l_enrolment_cat VARCHAR2(100);
1716: l_enr_method_type igs_en_method_type.enr_method_type%TYPE;
1717: BEGIN
1718: p_status := 'S';
1719: p_message := NULL;
1720: --Get the enrollment category and enrollment commencement type.