57: --
58: -- Declare cursors and local variables
59: --
60: l_proc Varchar2(72) := g_package||'create_config_information';
61: l_object_version_number hr_locations_all.object_version_number%TYPE;
62: l_language_code per_ri_workbench_items_tl.language%TYPE;
63: l_effective_date Date;
64:
65: --
217: --
218: -- Declare cursors and local variables
219: --
220: l_proc VARCHAR2(72) := g_package||'update_workbench_item';
221: l_object_version_number hr_locations.object_version_number%TYPE;
222: l_language_code hr_locations_all_tl.language%TYPE;
223: l_workbench_item_creation_date Date;
224: l_effective_date DATE;
225:
218: -- Declare cursors and local variables
219: --
220: l_proc VARCHAR2(72) := g_package||'update_workbench_item';
221: l_object_version_number hr_locations.object_version_number%TYPE;
222: l_language_code hr_locations_all_tl.language%TYPE;
223: l_workbench_item_creation_date Date;
224: l_effective_date DATE;
225:
226: l_temp_ovn number := p_object_version_number;