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;
40: --
77: ,p_effective_date => l_effective_date
78: ,p_object_version_number => l_object_version_number
79: );
80: --
81: -- Now insert translatable rows in PER_RI_WORKBENCH_ITEMS_TL table
82: per_wbt_ins.ins_tl
83: ( p_workbench_item_code => p_workbench_item_code
84: ,p_workbench_item_name => p_workbench_item_name
85: ,p_workbench_item_description => p_workbench_item_description
192: ,p_workbench_item_type => p_workbench_item_type
193: ,p_effective_date => l_effective_date
194: ,p_object_version_number => l_object_version_number);
195: --
196: -- Now insert translatable rows in PER_RI_WORKBENCH_ITEMS_TL table
197:
198: per_wbt_upd.upd_tl
199: ( p_workbench_item_code => p_workbench_item_code
200: ,p_workbench_item_name => p_workbench_item_name