APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on OTA_DELEGATE_BOOKINGS

Line 322: FROM ota_delegate_bookings

318: RETURN varchar2 IS
319:
320: CURSOR check_enr_exists IS
321: SELECT booking_id
322: FROM ota_delegate_bookings
323: WHERE delegate_person_id = p_learner_id
324: AND event_id = p_event_id;
325: CURSOR get_learner_class_enr_status IS
326: SELECT bst.type status_code,

Line 330: FROM ota_delegate_bookings tdb,

326: SELECT bst.type status_code,
327: bst.booking_status_type_id status_id,
328: decode(bst.type, 'C', 0,'R',1, 'W',2, 'P',3,'E',4, 'A',5) status_number,
329: nvl(tdb.is_mandatory_enrollment,'N') mandatory_enrollment_flag
330: FROM ota_delegate_bookings tdb,
331: ota_booking_status_types bst
332: WHERE tdb.delegate_person_id = p_learner_id
333: AND tdb.event_id = p_event_id
334: AND tdb.booking_status_type_id = bst.booking_status_type_id

Line 343: l_booking_id ota_delegate_bookings.booking_id%type;

339: l_status_id NUMBER := NULL;
340: l_status_number NUMBER;
341: l_mandatory_enrollment_flag varchar2(1) := NULL;
342: l_proc varchar2(72) := g_package||'learner_can_enroll_in_class';
343: l_booking_id ota_delegate_bookings.booking_id%type;
344: BEGIN
345:
346: hr_utility.set_location(' Entering:'||l_proc, 5);
347:

Line 355: --Since ota_delegate_bookings can have more than one row('n' cancelled rows and one enrolled row), we

351: CLOSE check_enr_exists;
352: RETURN 'Y';
353:
354: ELSE
355: --Since ota_delegate_bookings can have more than one row('n' cancelled rows and one enrolled row), we
356: --need to execute below cursor
357: CLOSE check_enr_exists;
358: OPEN get_learner_class_enr_status;
359: FETCH get_learner_class_enr_status INTO l_status_code, l_status_id, l_status_number, l_mandatory_enrollment_flag ;

Line 1764: l_booking_id ota_delegate_bookings.booking_id%type;

1760: l_booking_status ota_booking_status_types_tl.name%type;
1761:
1762: l_request_rec get_all_mandatory_enr_requests%rowtype;
1763: l_req_member_rec csr_get_request_members%rowtype;
1764: l_booking_id ota_delegate_bookings.booking_id%type;
1765:
1766:
1767: l_cost_center_info csr_get_cost_center_info%rowtype;
1768:

Line 1924: l_booking_id ota_delegate_bookings.booking_id%type;

1920: l_booking_status ota_booking_status_types_tl.name%type;
1921:
1922: l_request_rec get_all_mandatory_enr_requests%rowtype;
1923: l_req_member_rec csr_get_request_members%rowtype;
1924: l_booking_id ota_delegate_bookings.booking_id%type;
1925:
1926:
1927: l_cost_center_info csr_get_cost_center_info%rowtype;
1928: