APPS.OTA_TDB_BUS2 dependencies on OTA_TDB_BUS

Line 1: Package Body ota_tdb_bus2 as

1: Package Body ota_tdb_bus2 as
2: /* $Header: ottdb01t.pkb 120.30 2011/02/07 11:01:05 shwnayak ship $ */
3: g_package varchar2(33) := ' ota_tdb_bus2.'; -- Global package name
4: --
5: --***************************** STARTS HERE **********************************

Line 3: g_package varchar2(33) := ' ota_tdb_bus2.'; -- Global package name

1: Package Body ota_tdb_bus2 as
2: /* $Header: ottdb01t.pkb 120.30 2011/02/07 11:01:05 shwnayak ship $ */
3: g_package varchar2(33) := ' ota_tdb_bus2.'; -- Global package name
4: --
5: --***************************** STARTS HERE **********************************
6: --
7: g_event_rec ota_evt_shd.g_rec_type;

Line 49: l_proc varchar2(72) := 'OTA_TDB_BUS2 '||'check_person_address';

45: from per_addresses
46: where person_id = p_person_id
47: and address_id = p_address_id;
48: --
49: l_proc varchar2(72) := 'OTA_TDB_BUS2 '||'check_person_address';
50: l_dummy varchar2(1);
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);

Line 196: l_booking_status := ota_tdb_bus.booking_status_type(p_booking_status_type_id);

192: --
193:
194: if l_result then
195: --
196: l_booking_status := ota_tdb_bus.booking_status_type(p_booking_status_type_id);
197:
198: if l_booking_status in (g_attended_booking, g_placed_booking) and
199: l_dummy in (g_attended_booking, g_placed_booking) then
200: --

Line 302: if not ota_tdb_bus.check_person (p_person_id,

298: --
299: if p_person_id is not null then
300: --
301: hr_utility.trace(p_person_type||' Person ID -> '||to_char(p_person_id));
302: if not ota_tdb_bus.check_person (p_person_id,
303: p_date_booking_placed,
304: p_person_type,
305: p_person_address_type) then
306: --

Line 1041: end ota_tdb_bus2;

1037: hr_utility.set_location('Leaving:'|| l_proc, 10);
1038: --
1039: end Check_location;
1040: --
1041: end ota_tdb_bus2;