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 740: ota_evt_bus2.lock_event(p_event_id);

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

Line 1252: ota_evt_bus2.reset_event_status(p_event_id

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

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

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

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

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

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

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