APPS.OTA_TDB_API_UPD2 dependencies on OTA_EVT_BUS2

Line 40: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);

36: l_number_of_places_changed boolean := ota_general.value_changed(
37: ota_tdb_shd.g_old_rec.number_of_places,
38: p_number_of_places);
39:
40: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);
41:
42: l_old_number_of_places number := ota_tdb_shd.g_old_rec.number_of_places;
43:
44: l_old_event_id number := ota_tdb_shd.g_old_rec.event_id;

Line 62: ota_evt_bus2.get_vacancies(p_event_id) <

58:
59: if p_event_id <> l_old_event_id and
60: l_booking_status in ('A','P','E') and
61: ( p_event_status = 'F' or
62: ota_evt_bus2.get_vacancies(p_event_id) <
63: p_number_of_places ) then
64:
65: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
66: fnd_message.raise_error;

Line 73: (ota_evt_bus2.get_vacancies(p_event_id) <

69: --
70: -- Check for exceeding max attendees.
71: --
72: if (l_booking_status in ('A','P','E') and
73: (ota_evt_bus2.get_vacancies(p_event_id) <
74: (p_number_of_places - l_old_number_of_places)))
75: or
76: (l_booking_status in ('A','P','E') and
77: l_old_booking_status not in ('A','P','E') and

Line 78: ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) then

74: (p_number_of_places - l_old_number_of_places)))
75: or
76: (l_booking_status in ('A','P','E') and
77: l_old_booking_status not in ('A','P','E') and
78: ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) then
79: --
80: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
81: fnd_message.raise_error;
82: --

Line 101: ota_evt_bus2.get_vacancies(p_event_id) >= p_number_of_places then

97: --
98:
99: if l_old_booking_status = 'W' and
100: l_booking_status in ('P','A','E') and
101: ota_evt_bus2.get_vacancies(p_event_id) >= p_number_of_places then
102: null;
103: else
104: fnd_message.set_name('OTA','OTA_13521_TDB_CH_STATUS_FP');
105: fnd_message.raise_error;

Line 742: ota_evt_bus2.lock_event(p_event_id);

738: END IF;
739:
740: -- Lock the Event
741: --
742: ota_evt_bus2.lock_event(p_event_id);
743:
744: -- get booking_status type to fire ntf process
745: open get_status_info;
746: fetch get_status_info into l_enroll_type;

Line 1254: ota_evt_bus2.reset_event_status(p_event_id

1250:
1251: --
1252: -- Reset Event Status
1253: --
1254: ota_evt_bus2.reset_event_status(p_event_id
1255: ,l_event_rec.object_version_number
1256: ,l_event_rec.event_status
1257: ,l_event_rec.maximum_attendees);
1258: --

Line 1262: ota_evt_bus2.lock_event(ota_tdb_shd.g_old_rec.event_id);

1258: --
1259: -- *** In case of Event Change -- Reset Event Status for Old Event ***
1260: --
1261: if p_event_id <> ota_tdb_shd.g_old_rec.event_id then
1262: ota_evt_bus2.lock_event(ota_tdb_shd.g_old_rec.event_id);
1263:
1264: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
1265: l_event_rec,
1266: l_event_exists);

Line 1268: ota_evt_bus2.reset_event_status(ota_tdb_shd.g_old_rec.event_id

1264: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
1265: l_event_rec,
1266: l_event_exists);
1267:
1268: ota_evt_bus2.reset_event_status(ota_tdb_shd.g_old_rec.event_id
1269: ,l_event_rec.object_version_number
1270: ,l_event_rec.event_status
1271: ,l_event_rec.maximum_attendees);
1272:

Line 1349: l_places := ota_evt_bus2.get_vacancies(p_event_id);

1345: --
1346: -- Call the delegate booking update API.
1347: --
1348:
1349: l_places := ota_evt_bus2.get_vacancies(p_event_id);
1350:
1351: if p_number_of_places <= l_places or
1352: l_places is null then
1353: --