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_EVT_BUS2 dependencies on OTA_EVT_BUS2

Line 1: Package Body ota_evt_bus2 as

1: Package Body ota_evt_bus2 as
2: /* $Header: otevt02t.pkb 120.7.12020000.4 2013/02/11 04:52:08 jaysridh ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ota_evt_bus2.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_evt_bus2.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |--------------------------< Lock_Event >----------------------------------|
12: -- ----------------------------------------------------------------------------

Line 103: l_total_places number := ota_evt_bus2.get_total_places('ALL',p_event_id);

99: ,p_maximum_attendees in number
100: ,p_maximum_internal_attendees in number) is
101: --
102: --
103: l_total_places number := ota_evt_bus2.get_total_places('ALL',p_event_id);
104: l_total_internal_places number := ota_evt_bus2.get_total_places('INTERNAL',p_event_id);
105: --
106: l_proc varchar2(72) := g_package||'check_places';
107: --

Line 104: l_total_internal_places number := ota_evt_bus2.get_total_places('INTERNAL',p_event_id);

100: ,p_maximum_internal_attendees in number) is
101: --
102: --
103: l_total_places number := ota_evt_bus2.get_total_places('ALL',p_event_id);
104: l_total_internal_places number := ota_evt_bus2.get_total_places('INTERNAL',p_event_id);
105: --
106: l_proc varchar2(72) := g_package||'check_places';
107: --
108: begin

Line 323: l_total_places number := ota_evt_bus2.get_total_places('ALL',p_event_id);

319: --
320: p_rec ota_evt_shd.g_rec_type;
321: p_event_exists boolean;
322: l_vacancies number;
323: l_total_places number := ota_evt_bus2.get_total_places('ALL',p_event_id);
324: l_proc varchar2(72) := g_package||'get_vacancies';
325: --
326: --
327: begin

Line 365: l_total_attendees number := ota_evt_bus2.get_total_places('ALL',p_event_id);

361: l_rec ota_evt_shd.g_rec_type;
362: l_event_exists boolean;
363: l_old_booking_status varchar2(30);
364: l_new_booking_status varchar2(30);
365: l_total_attendees number := ota_evt_bus2.get_total_places('ALL',p_event_id);
366: l_total_waitlisted number :=
367: ota_tdb_bus.places_for_status(p_event_id => p_event_id
368: ,p_all_or_internal => 'ALL'
369: ,p_status_type => 'W');

Line 466: l_mandatory_association_exists boolean := ota_evt_bus2.mandatory_associations_exists(p_event_id);

462: ,p_maximum_attendees in number
463: ,p_maximum_internal_attendees in number) is
464: --
465: --
466: l_mandatory_association_exists boolean := ota_evt_bus2.mandatory_associations_exists(p_event_id);
467:
468: l_proc varchar2(72) := g_package||'check_mandatory_associations';
469: --
470: begin

Line 486: end ota_evt_bus2;

482: --
483: hr_utility.set_location('Leaving:'||l_proc, 10);
484: --
485: end Check_Mandatory_Associations;
486: end ota_evt_bus2;