DBA Data[Home] [Help]

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 1527: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt

1523: IS
1524:
1525: CURSOR csr_get_booking_status_id(l_booking_id NUMBER) IS
1526: SELECT btt.booking_status_type_id , btt.name booking_status
1527: FROM ota_delegate_bookings tdb, ota_booking_status_types_tl btt
1528: WHERE booking_id = l_booking_id
1529: and tdb.booking_status_type_id = btt.booking_status_type_id
1530: and btt.language = USERENV('LANG');
1531:

Line 1553: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;

1549: AND trunc(sysdate) between nvl(assg.effective_start_date,trunc(sysdate))
1550: and nvl(assg.effective_end_date,trunc(sysdate+1));
1551:
1552: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1553: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
1554: l_booking_status ota_booking_status_types_tl.name%TYPE;
1555:
1556: l_request_rec csr_get_request_info%ROWTYPE;
1557: l_req_member_rec csr_get_request_members%ROWTYPE;

Line 1554: l_booking_status ota_booking_status_types_tl.name%TYPE;

1550: and nvl(assg.effective_end_date,trunc(sysdate+1));
1551:
1552: l_error_message ota_bulk_enr_req_members.error_message%TYPE;
1553: l_booking_status_type_id ota_booking_status_types.booking_status_type_id%TYPE;
1554: l_booking_status ota_booking_status_types_tl.name%TYPE;
1555:
1556: l_request_rec csr_get_request_info%ROWTYPE;
1557: l_req_member_rec csr_get_request_members%ROWTYPE;
1558: l_booking_id ota_delegate_bookings.booking_id%TYPE;