APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_TDB_BUS

Line 24: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(

20: ,p_event_status in varchar2
21: ,p_maximum_attendees in number
22: ,p_number_of_places in number) is
23: --
24: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
25: p_booking_status_type_id);
26:
27: Cursor c_eval_info is
28: select decode(nvl(evt_eval.eval_mandatory_flag,'N'), 'Y', 'Y',

Line 634: ota_tdb_bus.check_delegate_eligible (p_event_id,

630: IF p_override_learner_access <> 'Y' THEN
631: --
632: -- check that the delegate is eligible to be booked on to the event
633: --
634: ota_tdb_bus.check_delegate_eligible (p_event_id,
635: p_customer_id,
636: p_delegate_contact_id,
637: p_organization_id,
638: p_delegate_person_id,

Line 642: ota_tdb_bus.check_secure_event(p_event_id, p_delegate_person_id);

638: p_delegate_person_id,
639: p_delegate_assignment_id);
640: -- Added for bug#4606760
641: ELSIF p_delegate_person_id IS NOT NULL THEN
642: ota_tdb_bus.check_secure_event(p_event_id, p_delegate_person_id);
643:
644: END IF;
645:
646:

Line 907: ota_tdb_bus.ota_letter_lines

903: --
904: p_booking_id := l_booking_id;
905: p_object_version_number := l_object_version_number;
906:
907: ota_tdb_bus.ota_letter_lines
908: (p_booking_id => p_booking_id,
909: p_booking_status_type_id => p_booking_status_type_id,
910: p_event_id => p_event_id,
911: p_delegate_person_id => p_delegate_person_id);

Line 1273: l_old_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(

1269: --
1270: -- Set up local variables
1271: --
1272:
1273: l_old_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
1274: ota_tdb_shd.g_old_rec.booking_status_type_id);
1275:
1276: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
1277: p_booking_status_type_id);

Line 1276: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(

1272:
1273: l_old_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
1274: ota_tdb_shd.g_old_rec.booking_status_type_id);
1275:
1276: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
1277: p_booking_status_type_id);
1278:
1279: l_booking_status_changed boolean := ota_general.value_changed(
1280: ota_tdb_shd.g_old_rec.booking_status_type_id,

Line 2113: ota_tdb_bus.check_delegate_eligible(

2109: l_delegate_asg_changed then
2110: --
2111: -- check that the delegate is eligible to be booked on to the event
2112: --
2113: ota_tdb_bus.check_delegate_eligible(
2114: p_event_id => l_new_event_id
2115: ,p_customer_id => l_new_customer_id
2116: ,p_delegate_contact_id => l_new_delegate_contact_id
2117: ,p_organization_id => l_new_organization_id

Line 2455: l_old_booking_status := ota_tdb_bus.booking_status_type(

2451: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,
2452: l_new_booking_status_type_id);
2453:
2454: -- Getting the old booking status to manipulate the fourm notification records
2455: l_old_booking_status := ota_tdb_bus.booking_status_type(
2456: ota_tdb_shd.g_old_rec.booking_status_type_id);
2457:
2458: OPEN is_contact;
2459: FETCH is_contact INTO l_contact_id,l_delegate_contact_id;

Line 2605: ota_tdb_bus.maintain_status_history

2601:
2602: -- Bug 2982183
2603: --Bug 5452795
2604: if l_status_type_id_changed then
2605: ota_tdb_bus.maintain_status_history
2606: (l_new_booking_status_type_id,
2607: l_date_status_changed, --p_date_status_changed,Bug6801749
2608: p_administrator,
2609: l_status_change_comments, --p_status_change_comments,Bug 2359495

Line 2617: ota_tdb_bus.ota_letter_lines

2613: ota_tdb_shd.g_created_by,
2614: p_date_booking_placed);
2615: end if;
2616: --
2617: ota_tdb_bus.ota_letter_lines
2618: (p_booking_id => p_booking_id,
2619: p_booking_status_type_id => l_new_booking_status_type_id,
2620: p_event_id => l_new_event_id,
2621: p_delegate_person_id => l_person_id);