50: --
51: -- Declare cursors and local variables
52: --
53: l_proc Varchar2(72) := g_package||'create_config_information';
54: l_object_version_number hr_locations_all.object_version_number%TYPE;
55: l_language_code per_ri_workbench_items_tl.language%TYPE;
56: l_effective_date Date;
57:
58: --
194: --
195: -- Declare cursors and local variables
196: --
197: l_proc VARCHAR2(72) := g_package||'update_location';
198: l_object_version_number hr_locations.object_version_number%TYPE;
199: l_language_code hr_locations_all_tl.language%TYPE;
200: l_workbench_item_creation_date Date;
201: l_effective_date DATE;
202:
195: -- Declare cursors and local variables
196: --
197: l_proc VARCHAR2(72) := g_package||'update_location';
198: l_object_version_number hr_locations.object_version_number%TYPE;
199: l_language_code hr_locations_all_tl.language%TYPE;
200: l_workbench_item_creation_date Date;
201: l_effective_date DATE;
202:
203: l_temp_ovn number := p_object_version_number;