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 485: ota_tdb_bus.check_delegate_eligible (p_event_id,

481: IF p_override_learner_access <> 'Y' THEN
482: --
483: -- check that the delegate is eligible to be booked on to the event
484: --
485: ota_tdb_bus.check_delegate_eligible (p_event_id,
486: p_customer_id,
487: p_delegate_contact_id,
488: p_organization_id,
489: p_delegate_person_id,

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

489: p_delegate_person_id,
490: p_delegate_assignment_id);
491: -- Added for bug#4606760
492: ELSIF p_delegate_person_id IS NOT NULL THEN
493: ota_tdb_bus.check_secure_event(p_event_id, p_delegate_person_id);
494:
495: END IF;
496:
497: --

Line 751: ota_tdb_bus.ota_letter_lines

747: --
748: p_booking_id := l_booking_id;
749: p_object_version_number := l_object_version_number;
750:
751: ota_tdb_bus.ota_letter_lines
752: (p_booking_id => p_booking_id,
753: p_booking_status_type_id => p_booking_status_type_id,
754: p_event_id => p_event_id,
755: p_delegate_person_id => p_delegate_person_id);

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

1110: --
1111: -- Set up local variables
1112: --
1113:
1114: l_old_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
1115: ota_tdb_shd.g_old_rec.booking_status_type_id);
1116:
1117: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
1118: p_booking_status_type_id);

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

1113:
1114: l_old_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
1115: ota_tdb_shd.g_old_rec.booking_status_type_id);
1116:
1117: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
1118: p_booking_status_type_id);
1119:
1120: l_booking_status_changed boolean := ota_general.value_changed(
1121: ota_tdb_shd.g_old_rec.booking_status_type_id,

Line 1922: ota_tdb_bus.check_delegate_eligible(

1918: l_delegate_asg_changed then
1919: --
1920: -- check that the delegate is eligible to be booked on to the event
1921: --
1922: ota_tdb_bus.check_delegate_eligible(
1923: p_event_id => l_new_event_id
1924: ,p_customer_id => l_new_customer_id
1925: ,p_delegate_contact_id => l_new_delegate_contact_id
1926: ,p_organization_id => l_new_organization_id

Line 2244: l_old_booking_status := ota_tdb_bus.booking_status_type(

2240: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,
2241: p_booking_status_type_id);
2242:
2243: -- Getting the old booking status to manipulate the fourm notification records
2244: l_old_booking_status := ota_tdb_bus.booking_status_type(
2245: ota_tdb_shd.g_old_rec.booking_status_type_id);
2246:
2247: OPEN is_contact;
2248: FETCH is_contact INTO l_contact_id,l_delegate_contact_id;

Line 2394: ota_tdb_bus.maintain_status_history

2390:
2391: -- Bug 2982183
2392: --Bug 5452795
2393: if l_status_type_id_changed then
2394: ota_tdb_bus.maintain_status_history
2395: (p_booking_status_type_id,
2396: l_date_status_changed, --p_date_status_changed,Bug6801749
2397: p_administrator,
2398: l_status_change_comments, --p_status_change_comments,Bug 2359495

Line 2406: ota_tdb_bus.ota_letter_lines

2402: ota_tdb_shd.g_created_by,
2403: p_date_booking_placed);
2404: end if;
2405: --
2406: ota_tdb_bus.ota_letter_lines
2407: (p_booking_id => p_booking_id,
2408: p_booking_status_type_id => p_booking_status_type_id,
2409: p_event_id => p_event_id,
2410: p_delegate_person_id => l_person_id);