APPS.OTA_TDB_BUS2 dependencies on OTA_TDB_BUS2

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 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;