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 704: ota_tdb_bus.check_delegate_eligible(

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

Line 886: l_old_booking_status := ota_tdb_bus.booking_status_type(

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

Line 1017: ota_tdb_bus.maintain_status_history

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

Line 1028: ota_tdb_bus.ota_letter_lines

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