APPS.OTA_EVT_API_UPD2 dependencies on OTA_EVT_SHD

Line 35: l_event_rec ota_evt_shd.g_rec_type;

31: l_att_enr_exists VARCHAR2(1);
32: -- Bug 3493695
33: l_booking_status varchar2(30) := ota_tdb_bus.booking_status_type(
34: p_booking_status_type_id);
35: l_event_rec ota_evt_shd.g_rec_type;
36: l_event_exists boolean;
37: l_total_places number;
38:
39: --

Line 48: ota_evt_shd.get_event_details (p_event_id,

44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: -- Get Event Record
47: --
48: ota_evt_shd.get_event_details (p_event_id,
49: l_event_rec,
50: l_event_exists);
51: --
52: -- Check event status change for No change.

Line 179: if ota_evt_shd.g_old_rec.maximum_internal_attendees is null then

175: end if;
176: close c_check_waitlist_candidates;
177: /* Start Bug 1712445 */
178: if p_maximum_attendees <= l_total_places + l_no_of_waitlist_candidate then
179: if ota_evt_shd.g_old_rec.maximum_internal_attendees is null then
180: p_event_status := 'F';
181: else
182: p_event_status := 'N';
183:

Line 375: l_event_rec ota_evt_shd.g_rec_type;

371: p_booking_status_type_id in number default null,
372: p_date_status_changed in date default null,
373: p_maximum_attendees in number default null) is
374: --
375: l_event_rec ota_evt_shd.g_rec_type;
376: l_event_rec_ovn ota_evt_shd.g_rec_type;
377: l_event_exists boolean;
378: l_event_exists_ovn boolean;
379: l_event_status varchar2(30);

Line 376: l_event_rec_ovn ota_evt_shd.g_rec_type;

372: p_date_status_changed in date default null,
373: p_maximum_attendees in number default null) is
374: --
375: l_event_rec ota_evt_shd.g_rec_type;
376: l_event_rec_ovn ota_evt_shd.g_rec_type;
377: l_event_exists boolean;
378: l_event_exists_ovn boolean;
379: l_event_status varchar2(30);
380: --

Line 398: ota_evt_shd.lck(p_event_id, p_object_version_number);

394: --
395: -- Validation in addition to Table Handlers.
396: -- Lock Event
397: --
398: ota_evt_shd.lck(p_event_id, p_object_version_number);
399: --
400: -- Get Event record.
401: --
402: ota_evt_shd.get_event_details (p_event_id,

Line 402: ota_evt_shd.get_event_details (p_event_id,

398: ota_evt_shd.lck(p_event_id, p_object_version_number);
399: --
400: -- Get Event record.
401: --
402: ota_evt_shd.get_event_details (p_event_id,
403: l_event_rec,
404: l_event_exists);
405: --
406: if p_event = 'STATUS' then

Line 456: ota_evt_shd.get_event_details(p_event_id,

452: -- Bug 463742.
453: -- Requery event record, as object version number
454: -- may have changed.
455:
456: ota_evt_shd.get_event_details(p_event_id,
457: l_event_rec_ovn,
458: l_event_exists_ovn);
459:
460: -- Force Event update