APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_BOOKING_STATUS_TYPES_TL

Line 31: ota_booking_status_types_tl btt

27: bst.booking_status_type_id status_id,
28: decode(bst.type, 'C', 0,'R',1, 'W',2, 'P',3, 'E',4, 'A',5) status_number
29: FROM ota_delegate_bookings tdb,
30: ota_booking_status_types bst,
31: ota_booking_status_types_tl btt
32: WHERE tdb.delegate_person_id = p_learner_id
33: AND tdb.event_id = p_object_id
34: AND tdb.booking_status_type_id = bst.booking_status_type_id
35: AND bst.booking_status_type_id = btt.booking_status_type_id

Line 86: FROM ota_booking_status_types_tl btt

82: ,p_enrollment_status IN VARCHAR2) RETURN VARCHAR2
83: IS
84: CURSOR get_class_enrollment_status IS
85: SELECT btt.name
86: FROM ota_booking_status_types_tl btt
87: WHERE btt.language = USERENV('LANG')
88: AND btt.booking_status_type_id = p_enrollment_status;
89:
90: CURSOR get_subscription_status IS

Line 1533: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt

1529: IS
1530:
1531: CURSOR csr_get_booking_status_id(l_booking_id NUMBER) IS
1532: SELECT btt.booking_status_type_id , btt.name booking_status
1533: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt
1534: WHERE booking_id = l_booking_id
1535: and tdb.booking_status_type_id = btt.booking_status_type_id
1536: and btt.language = USERENV('LANG');
1537:

Line 1562: l_booking_status ota_booking_status_types_tl.name%TYPE;

1558: and nvl(assg.effective_end_date,trunc(sysdate+1));
1559:
1560: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1561: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
1562: l_booking_status ota_booking_status_types_tl.name%TYPE;
1563:
1564: l_request_rec csr_get_request_info%ROWTYPE;
1565: l_req_member_rec csr_get_request_members%ROWTYPE;
1566: l_booking_id ota_delegate_bookings.booking_id%TYPE;

Line 1663: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt

1659: IS
1660:
1661: CURSOR csr_get_booking_status_id(l_booking_id NUMBER) IS
1662: SELECT btt.booking_status_type_id , btt.name booking_status
1663: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt
1664: WHERE booking_id = l_booking_id
1665: and tdb.booking_status_type_id = btt.booking_status_type_id
1666: and btt.language = USERENV('LANG');
1667:

Line 1732: l_booking_status ota_booking_status_types_tl.name%TYPE;

1728: AND lpe.learning_path_id= lpm.learning_path_id;
1729:
1730: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1731: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
1732: l_booking_status ota_booking_status_types_tl.name%TYPE;
1733:
1734: l_request_rec csr_get_request_info%ROWTYPE;
1735: l_req_member_rec csr_get_request_members%ROWTYPE;
1736: l_booking_id ota_delegate_bookings.booking_id%TYPE;

Line 2180: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt

2176:
2177:
2178: CURSOR csr_get_booking_status_id(l_booking_id NUMBER) IS
2179: SELECT btt.booking_status_type_id , btt.name booking_status
2180: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt
2181: WHERE booking_id = l_booking_id
2182: and tdb.booking_status_type_id = btt.booking_status_type_id
2183: and btt.language = USERENV('LANG');
2184:

Line 2200: l_booking_status ota_booking_status_types_tl.name%TYPE;

2196: WHERE fln.booking_id = p_booking_id;
2197:
2198: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
2199: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
2200: l_booking_status ota_booking_status_types_tl.name%TYPE;
2201: l_object_version_number ota_delegate_bookings.object_version_number%TYPE;
2202: l_request_rec csr_get_request_info%ROWTYPE;
2203: l_req_member_rec csr_get_request_members%ROWTYPE;
2204: l_booking_id ota_delegate_bookings.booking_id%TYPE;