APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_EVT_BUS2

Line 54: if (ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) and

50: --
51:
52: if p_maximum_attendees is not null then
53: --
54: if (ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) and
55: l_booking_status in ('P','A','E') then
56: --
57: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
58: fnd_message.raise_error;

Line 503: ota_evt_bus2.lock_event(p_event_id);

499: --
500: OPEN csr_class_data;--Bug 5386501
501: FETCH csr_class_data into l_class_name;
502: begin
503: ota_evt_bus2.lock_event(p_event_id);
504: exception
505: when others then
506: fnd_message.set_name('OTA','OTA_443997_EVT_ROW_LCK_ERR');
507: fnd_message.set_token('CLASS_NAME', l_class_name);

Line 835: ota_evt_bus2.reset_event_status(p_event_id

831:
832: --
833: -- Reset Event Status
834: --
835: ota_evt_bus2.reset_event_status(p_event_id
836: ,l_event_rec.object_version_number
837: ,l_event_rec.event_status
838: ,l_event_rec.maximum_attendees);
839: --

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

1124: l_number_of_places_changed boolean := ota_general.value_changed(
1125: ota_tdb_shd.g_old_rec.number_of_places,
1126: p_number_of_places);
1127:
1128: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);
1129:
1130: l_old_number_of_places number := ota_tdb_shd.g_old_rec.number_of_places;
1131:
1132: l_old_event_id number := ota_tdb_shd.g_old_rec.event_id;

Line 1165: ota_evt_bus2.get_vacancies(p_event_id) <

1161:
1162: if p_event_id <> l_old_event_id and
1163: l_booking_status in ('A','P','E') and
1164: ( p_event_status = 'F' or
1165: ota_evt_bus2.get_vacancies(p_event_id) <
1166: p_number_of_places ) then
1167:
1168: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1169: fnd_message.raise_error;

Line 1187: (ota_evt_bus2.get_vacancies(p_event_id) <

1183: --
1184: -- Check for exceeding max attendees.
1185: --
1186: if (l_booking_status in ('A','P','E') and
1187: (ota_evt_bus2.get_vacancies(p_event_id) <
1188: (p_number_of_places - l_old_number_of_places)))
1189: or
1190: (l_booking_status in ('A','P','E') and
1191: l_old_booking_status not in ('A','P','E') and

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

1188: (p_number_of_places - l_old_number_of_places)))
1189: or
1190: (l_booking_status in ('A','P','E') and
1191: l_old_booking_status not in ('A','P','E') and
1192: ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) then
1193: --
1194: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1195: fnd_message.raise_error;
1196: --

Line 1227: ota_evt_bus2.get_vacancies(p_event_id) >= p_number_of_places

1223: --
1224:
1225: if l_old_booking_status = 'W' and
1226: l_booking_status in ('P','A','E') and
1227: ota_evt_bus2.get_vacancies(p_event_id) >= p_number_of_places
1228: and p_event_status <> 'P' then
1229: null;
1230: else
1231: fnd_message.set_name('OTA','OTA_13521_TDB_CH_STATUS_FP');

Line 1974: ota_evt_bus2.lock_event(p_event_id);

1970: END IF;
1971:
1972: -- Lock the Event
1973: --
1974: ota_evt_bus2.lock_event(p_event_id);
1975:
1976: -- get booking_status type to fire ntf process
1977: OPEN get_status_info;
1978: FETCH get_status_info INTO l_enroll_type;

Line 2734: ota_evt_bus2.reset_event_status(p_event_id

2730:
2731: --
2732: -- Reset Event Status
2733: --
2734: ota_evt_bus2.reset_event_status(p_event_id
2735: ,l_event_rec.object_version_number
2736: ,l_event_rec.event_status
2737: ,l_event_rec.maximum_attendees);
2738: --

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

2738: --
2739: -- *** In case of Event Change -- Reset Event Status for Old Event ***
2740: --
2741: IF p_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
2742: ota_evt_bus2.lock_event(ota_tdb_shd.g_old_rec.event_id);
2743:
2744: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
2745: l_event_rec,
2746: l_event_exists);

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

2744: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
2745: l_event_rec,
2746: l_event_exists);
2747:
2748: ota_evt_bus2.reset_event_status(ota_tdb_shd.g_old_rec.event_id
2749: ,l_event_rec.object_version_number
2750: ,l_event_rec.event_status
2751: ,l_event_rec.maximum_attendees);
2752:

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

3129: --
3130: -- Call the delegate booking update API.
3131: --
3132:
3133: l_places := ota_evt_bus2.get_vacancies(p_event_id);
3134:
3135: if p_number_of_places <= l_places or
3136: l_places is null then
3137: --