DBA Data[Home] [Help]

APPS.PER_RI_WORKBENCH_ITEM_API dependencies on HR_LOCATIONS

Line 35: l_object_version_number hr_locations_all.object_version_number%TYPE;

31: --
32: -- Declare cursors and local variables
33: --
34: l_proc Varchar2(72) := g_package||'create_workbench_item';
35: l_object_version_number hr_locations_all.object_version_number%TYPE;
36: l_language_code per_ri_workbench_items_tl.language%TYPE;
37: l_effective_date Date;
38: l_workbench_item_creation_date Date;
39: l_workbench_item_code per_ri_workbench_items.workbench_item_code%TYPE;

Line 150: l_object_version_number hr_locations.object_version_number%TYPE;

146: --
147: -- Declare cursors and local variables
148: --
149: l_proc VARCHAR2(72) := g_package||'update_workbench_item';
150: l_object_version_number hr_locations.object_version_number%TYPE;
151: l_language_code hr_locations_all_tl.language%TYPE;
152: l_workbench_item_creation_date Date;
153: l_effective_date DATE;
154:

Line 151: l_language_code hr_locations_all_tl.language%TYPE;

147: -- Declare cursors and local variables
148: --
149: l_proc VARCHAR2(72) := g_package||'update_workbench_item';
150: l_object_version_number hr_locations.object_version_number%TYPE;
151: l_language_code hr_locations_all_tl.language%TYPE;
152: l_workbench_item_creation_date Date;
153: l_effective_date DATE;
154:
155: l_temp_ovn number := p_object_version_number;