APPS.OTA_TDB_API_UPD2 dependencies on OTA_TDB_BUS

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

22: --
23: -- Set up local variables
24: --
25:
26: l_old_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
27: ota_tdb_shd.g_old_rec.booking_status_type_id);
28:
29: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
30: p_booking_status_type_id);

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

25:
26: l_old_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
27: ota_tdb_shd.g_old_rec.booking_status_type_id);
28:
29: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
30: p_booking_status_type_id);
31:
32: l_booking_status_changed boolean := ota_general.value_changed(
33: ota_tdb_shd.g_old_rec.booking_status_type_id,

Line 702: ota_tdb_bus.check_delegate_eligible(

698: l_delegate_asg_changed then
699: --
700: -- check that the delegate is eligible to be booked on to the event
701: --
702: ota_tdb_bus.check_delegate_eligible(
703: p_event_id => l_new_event_id
704: ,p_customer_id => l_new_customer_id
705: ,p_delegate_contact_id => l_new_delegate_contact_id
706: ,p_organization_id => l_new_organization_id

Line 884: l_old_booking_status := ota_tdb_bus.booking_status_type(

880: ota_general.value_changed (ota_tdb_shd.g_old_rec.booking_status_type_id,
881: p_booking_status_type_id);
882:
883: --Getting the old booking status to manipulate the fourm notification records
884: l_old_booking_status := ota_tdb_bus.booking_status_type(
885: ota_tdb_shd.g_old_rec.booking_status_type_id);
886:
887: OPEN is_contact;
888: FETCH is_contact INTO l_contact_id,l_delegate_contact_id;

Line 1015: ota_tdb_bus.maintain_status_history

1011: end if;
1012:
1013: -- Bug 2982183
1014: --
1015: ota_tdb_bus.maintain_status_history
1016: (p_booking_status_type_id,
1017: p_date_status_changed,
1018: p_administrator,
1019: l_status_change_comments, --p_status_change_comments,Bug 2359495

Line 1026: ota_tdb_bus.ota_letter_lines

1022: ota_tdb_shd.g_old_rec.booking_status_type_id,
1023: ota_tdb_shd.g_created_by,
1024: p_date_booking_placed);
1025: --
1026: ota_tdb_bus.ota_letter_lines
1027: (p_booking_id => p_booking_id,
1028: p_booking_status_type_id => p_booking_status_type_id,
1029: p_event_id => p_event_id,
1030: p_delegate_person_id => l_person_id);