APPS.PER_RI_WORKBENCH_ITEM_API dependencies on PER_RI_WORKBENCH_ITEMS

Line 36: l_language_code per_ri_workbench_items_tl.language%TYPE;

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: --

Line 39: l_workbench_item_code per_ri_workbench_items.workbench_item_code%TYPE;

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: --
41: Begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 69: -- Insert non-translatable rows into PER_RI_WORKBENCH_ITEMS first

65: hr_utility.set_location(l_proc, 20);
66:
67: -- Process Logic
68: --
69: -- Insert non-translatable rows into PER_RI_WORKBENCH_ITEMS first
70: per_wbi_ins.ins
71: ( p_workbench_item_code => l_workbench_item_code
72: ,p_menu_id => p_menu_id
73: ,p_workbench_item_sequence => p_workbench_item_sequence

Line 81: -- Now insert translatable rows in PER_RI_WORKBENCH_ITEMS_TL table

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

Line 184: -- Insert non-translatable rows in PER_RI_WORKBENCH_ITEMS Table

180: -- Process Logic
181: --
182: l_object_version_number := p_object_version_number;
183: --
184: -- Insert non-translatable rows in PER_RI_WORKBENCH_ITEMS Table
185: --
186: per_wbi_upd.upd
187: ( p_workbench_item_code => p_workbench_item_code
188: ,p_menu_id => p_menu_id

Line 196: -- Now insert translatable rows in PER_RI_WORKBENCH_ITEMS_TL table

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