DBA Data[Home] [Help]

APPS.HR_LOCATION_EXTRA_INFO_API dependencies on HR_LOCATION_EXTRA_INFO

Line 1: Package Body hr_location_extra_info_api as

1: Package Body hr_location_extra_info_api as
2: /* $Header: hrleiapi.pkb 115.4 2003/09/12 03:02:27 smparame ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' hr_location_extra_info_api.';

2: /* $Header: hrleiapi.pkb 115.4 2003/09/12 03:02:27 smparame ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_location_extra_info_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |----------------------< create_location_extra_info >----------------------|
10: -- ----------------------------------------------------------------------------

Line 75: l_object_version_number hr_location_extra_info.object_version_number%type;

71: --
72: -- Declare cursors and local variables
73: --
74: l_proc varchar2(72) := g_package||'create_location_extra_info';
75: l_object_version_number hr_location_extra_info.object_version_number%type;
76: l_location_extra_info_id hr_location_extra_info.location_extra_info_id%type;
77: -- Bug fix 3132479 . Local variable to store information category.
78: l_lei_information_category hr_location_extra_info.lei_information_category%type;
79: --

Line 76: l_location_extra_info_id hr_location_extra_info.location_extra_info_id%type;

72: -- Declare cursors and local variables
73: --
74: l_proc varchar2(72) := g_package||'create_location_extra_info';
75: l_object_version_number hr_location_extra_info.object_version_number%type;
76: l_location_extra_info_id hr_location_extra_info.location_extra_info_id%type;
77: -- Bug fix 3132479 . Local variable to store information category.
78: l_lei_information_category hr_location_extra_info.lei_information_category%type;
79: --
80: begin

Line 78: l_lei_information_category hr_location_extra_info.lei_information_category%type;

74: l_proc varchar2(72) := g_package||'create_location_extra_info';
75: l_object_version_number hr_location_extra_info.object_version_number%type;
76: l_location_extra_info_id hr_location_extra_info.location_extra_info_id%type;
77: -- Bug fix 3132479 . Local variable to store information category.
78: l_lei_information_category hr_location_extra_info.lei_information_category%type;
79: --
80: begin
81: hr_utility.set_location('Entering:'|| l_proc, 5);
82: --

Line 101: hr_location_extra_info_bk1.create_location_extra_info_b

97: --
98: -- Call Before Process User Hook
99: --
100: begin
101: hr_location_extra_info_bk1.create_location_extra_info_b
102: (p_information_type => p_information_type,
103: p_location_id => p_location_id,
104: p_lei_attribute_category => p_lei_attribute_category,
105: p_lei_attribute1 => p_lei_attribute1,

Line 240: hr_location_extra_info_bk1.create_location_extra_info_a

236: --
237: -- Call After Process User Hook
238: --
239: begin
240: hr_location_extra_info_bk1.create_location_extra_info_a
241: (p_location_extra_info_id => l_location_extra_info_id,
242: p_information_type => p_information_type,
243: p_location_id => p_location_id,
244: p_lei_attribute_category => p_lei_attribute_category,

Line 414: l_object_version_number hr_location_extra_info.object_version_number%TYPE;

410: --
411: -- Declare cursors and local variables
412: --
413: l_proc varchar2(72) := g_package||'update_location_extra_info';
414: l_object_version_number hr_location_extra_info.object_version_number%TYPE;
415: l_temp_ovn hr_location_extra_info.object_version_number%TYPE;
416: --
417: begin
418: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 415: l_temp_ovn hr_location_extra_info.object_version_number%TYPE;

411: -- Declare cursors and local variables
412: --
413: l_proc varchar2(72) := g_package||'update_location_extra_info';
414: l_object_version_number hr_location_extra_info.object_version_number%TYPE;
415: l_temp_ovn hr_location_extra_info.object_version_number%TYPE;
416: --
417: begin
418: hr_utility.set_location('Entering:'|| l_proc, 5);
419: --

Line 429: hr_location_extra_info_bk2.update_location_extra_info_b

425: --
426: -- Call Before Process User Hook
427: --
428: begin
429: hr_location_extra_info_bk2.update_location_extra_info_b
430: (p_location_extra_info_id => p_location_extra_info_id,
431: p_lei_attribute_category => p_lei_attribute_category,
432: p_lei_attribute1 => p_lei_attribute1,
433: p_lei_attribute2 => p_lei_attribute2,

Line 570: hr_location_extra_info_bk2.update_location_extra_info_a

566: --
567: -- Call After Process User Hook
568: --
569: begin
570: hr_location_extra_info_bk2.update_location_extra_info_a
571: (p_location_extra_info_id => p_location_extra_info_id,
572: p_lei_attribute_category => p_lei_attribute_category,
573: p_lei_attribute1 => p_lei_attribute1,
574: p_lei_attribute2 => p_lei_attribute2,

Line 698: hr_location_extra_info_bk3.delete_location_extra_info_b

694: --
695: -- Call Before Process User Hook
696: --
697: begin
698: hr_location_extra_info_bk3.delete_location_extra_info_b
699: (p_location_extra_info_id => p_location_extra_info_id,
700: p_object_version_number => p_object_version_number
701: );
702: exception

Line 727: hr_location_extra_info_bk3.delete_location_extra_info_a

723: --
724: -- Call After Process User Hook
725: --
726: begin
727: hr_location_extra_info_bk3.delete_location_extra_info_a
728: (p_location_extra_info_id => p_location_extra_info_id,
729: p_object_version_number => p_object_version_number
730: );
731: exception

Line 768: end hr_location_extra_info_api;

764: raise;
765: --
766: end delete_location_extra_info;
767: --
768: end hr_location_extra_info_api;