eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_BULK_ENROLL_UTIL dependencies on OTA_BOOKING_STATUS_TYPES

Line 30: ota_booking_status_types bst,

26: btt.name Status,
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

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 121: FROM ota_delegate_bookings tdb, ota_booking_status_types bst

117: , p_status_message OUT NOCOPY VARCHAR2)
118: IS
119: CURSOR get_enrolled_places IS
120: SELECT sum(nvl(tdb.number_of_places,1)) enrolled_places
121: FROM ota_delegate_bookings tdb, ota_booking_status_types bst
122: WHERE tdb.event_id = p_class_id
123: and tdb.internal_booking_flag = 'Y'
124: and tdb.booking_status_type_id = bst.booking_status_type_id
125: and bst.type IN ('P', 'A','E');

Line 129: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

125: and bst.type IN ('P', 'A','E');
126:
127: l_enrolled_places number;
128: l_max_enroll number;
129: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
130: l_max_internal number;
131: l_event_status ota_events.event_status%TYPE;
132: l_maximum_internal_allowed number;
133:

Line 339: , ota_booking_status_types bst

335:
336: CURSOR cse_get_class_enrollments IS
337: SELECT sum(nvl(tdb.number_of_places,0))
338: FROM ota_delegate_bookings tdb
339: , ota_booking_status_types bst
340: WHERE tdb.booking_status_type_id = bst.booking_status_type_id
341: AND tdb.event_id = p_object_id
342: --TBD: needs to be confirmed if Requested(R) and Waitlisted(W) should also be included here
343: AND bst.type NOT IN ('C');

Line 443: OTA_BOOKING_STATUS_TYPES bst

439:
440: CURSOR get_existing_internal IS
441: SELECT sum(nvl(dbt.number_of_places, 0))
442: FROM OTA_DELEGATE_BOOKINGS dbt,
443: OTA_BOOKING_STATUS_TYPES bst
444: WHERE dbt.event_id = TO_NUMBER(p_event_id)
445: AND dbt.internal_booking_flag = 'Y'
446: AND dbt.booking_status_type_id = bst.booking_status_type_id
447: AND bst.type in ('P','A','E');

Line 452: OTA_BOOKING_STATUS_TYPES bst

448:
449: CURSOR get_existing_bookings IS
450: SELECT sum(number_of_places)
451: FROM OTA_DELEGATE_BOOKINGS dbt,
452: OTA_BOOKING_STATUS_TYPES bst
453: WHERE dbt.event_id = TO_NUMBER(p_event_id)
454: AND dbt.booking_status_type_id = bst.booking_status_type_id
455: AND bst.type in ('P','A','E');
456:

Line 552: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;

548: l_price_basis OTA_EVENTS.price_basis%TYPE;
549:
550: l_person_details csr_get_assignment_details%ROWTYPE;
551: --
552: l_booking_status_row OTA_BOOKING_STATUS_TYPES%ROWTYPE;
553: l_booking_id OTA_DELEGATE_BOOKINGS.booking_id%type := null;
554: l_object_version_number BINARY_INTEGER;
555: l_tfl_ovn BINARY_INTEGER;
556: l_finance_line_id OTA_FINANCE_LINES.finance_line_id%type:= null;

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 1561: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;

1557: AND trunc(sysdate) between nvl(assg.effective_start_date,trunc(sysdate))
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;

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 1731: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;

1727: AND lme.learning_path_member_id=lpm.learning_path_member_id
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;

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 2199: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;

2195: FROM ota_finance_lines fln
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;

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;