eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_EVT_BUS2

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

57: --
58:
59: if p_maximum_attendees is not null then
60: --
61: if (ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) and
62: l_booking_status in ('P','A','E') then
63: --
64: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
65: fnd_message.raise_error;

Line 661: ota_evt_bus2.lock_event(p_event_id);

657: if l_event_rec.maximum_attendees is NOT NULL THEN --Added for bug 12617891
658: OPEN csr_class_data;--Bug 5386501
659: FETCH csr_class_data into l_class_name;
660: begin
661: ota_evt_bus2.lock_event(p_event_id);
662: exception
663: when others then
664: fnd_message.set_name('OTA','OTA_443997_EVT_ROW_LCK_ERR');
665: fnd_message.set_token('CLASS_NAME', l_class_name);

Line 993: ota_evt_bus2.reset_event_status(p_event_id

989: --
990: -- Reset Event Status
991: --
992: if l_event_rec.maximum_attendees is NOT NULL THEN --Added for bug 12617891
993: ota_evt_bus2.reset_event_status(p_event_id
994: ,l_event_rec.object_version_number
995: ,l_event_rec.event_status
996: ,l_event_rec.maximum_attendees);
997: --

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

1283: l_number_of_places_changed boolean := ota_general.value_changed(
1284: ota_tdb_shd.g_old_rec.number_of_places,
1285: p_number_of_places);
1286:
1287: l_vacancies number := ota_evt_bus2.get_vacancies(p_event_id);
1288:
1289: l_old_number_of_places number := ota_tdb_shd.g_old_rec.number_of_places;
1290:
1291: l_old_event_id number := ota_tdb_shd.g_old_rec.event_id;

Line 1331: ota_evt_bus2.get_vacancies(p_event_id) <

1327:
1328: if p_event_id <> l_old_event_id and
1329: l_booking_status in ('A','P','E') and
1330: ( p_event_status = 'F' or
1331: ota_evt_bus2.get_vacancies(p_event_id) <
1332: p_number_of_places ) then
1333:
1334: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1335: fnd_message.raise_error;

Line 1353: (ota_evt_bus2.get_vacancies(p_event_id) <

1349: --
1350: -- Check for exceeding max attendees.
1351: --
1352: if (l_booking_status in ('A','P','E') and
1353: (ota_evt_bus2.get_vacancies(p_event_id) <
1354: (p_number_of_places - l_old_number_of_places)))
1355: or
1356: (l_booking_status in ('A','P','E') and
1357: l_old_booking_status not in ('A','P','E') and

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

1354: (p_number_of_places - l_old_number_of_places)))
1355: or
1356: (l_booking_status in ('A','P','E') and
1357: l_old_booking_status not in ('A','P','E') and
1358: ota_evt_bus2.get_vacancies(p_event_id) < p_number_of_places) then
1359: --
1360: fnd_message.set_name('OTA','OTA_13558_TDB_PLACES_INC');
1361: fnd_message.raise_error;
1362: --

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

1392: --
1393:
1394: if l_old_booking_status = 'W' and
1395: l_booking_status in ('P','A','E') and
1396: ota_evt_bus2.get_vacancies(p_event_id) >= p_number_of_places
1397: and p_event_status <> 'P' then
1398: null;
1399: else
1400: fnd_message.set_name('OTA','OTA_13521_TDB_CH_STATUS_FP');

Line 2175: -- ota_evt_bus2.lock_event(p_event_id);

2171: END IF;
2172:
2173: -- Lock the Event
2174: --
2175: -- ota_evt_bus2.lock_event(p_event_id);
2176:
2177: -- get booking_status type to fire ntf process
2178: OPEN get_status_info;
2179: FETCH get_status_info INTO l_enroll_type;

Line 2952: ota_evt_bus2.lock_event(l_new_event_id);

2948: null;
2949: else
2950:
2951: hr_utility.trace('Entered lock event');
2952: ota_evt_bus2.lock_event(l_new_event_id);
2953: --
2954: -- Reset Event Status
2955: --
2956: ota_evt_bus2.reset_event_status(l_new_event_id

Line 2956: ota_evt_bus2.reset_event_status(l_new_event_id

2952: ota_evt_bus2.lock_event(l_new_event_id);
2953: --
2954: -- Reset Event Status
2955: --
2956: ota_evt_bus2.reset_event_status(l_new_event_id
2957: ,l_event_rec.object_version_number
2958: ,l_event_rec.event_status
2959: ,l_event_rec.maximum_attendees);
2960: end if;

Line 2965: /*ota_evt_bus2.reset_event_status(p_event_id

2961:
2962: --
2963: -- Reset Event Status
2964: --
2965: /*ota_evt_bus2.reset_event_status(p_event_id
2966: ,l_event_rec.object_version_number
2967: ,l_event_rec.event_status
2968: ,l_event_rec.maximum_attendees);*/
2969:

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

2970: --
2971: -- *** In case of Event Change -- Reset Event Status for Old Event ***
2972: --
2973: IF l_new_event_id <> ota_tdb_shd.g_old_rec.event_id THEN
2974: ota_evt_bus2.lock_event(ota_tdb_shd.g_old_rec.event_id);
2975:
2976: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
2977: l_event_rec,
2978: l_event_exists);

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

2976: ota_evt_shd.get_event_details (ota_tdb_shd.g_old_rec.event_id,
2977: l_event_rec,
2978: l_event_exists);
2979:
2980: ota_evt_bus2.reset_event_status(ota_tdb_shd.g_old_rec.event_id
2981: ,l_event_rec.object_version_number
2982: ,l_event_rec.event_status
2983: ,l_event_rec.maximum_attendees);
2984:

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

3375: --
3376: -- Call the delegate booking update API.
3377: --
3378:
3379: l_places := ota_evt_bus2.get_vacancies(p_event_id);
3380:
3381: if p_number_of_places <= l_places or
3382: l_places is null then
3383: --