APPS.PER_RI_SETUP_TASK_API dependencies on PER_RI_SETUP_TASKS

Line 6: g_package VARCHAR2(33) := 'per_ri_setup_tasks_api.';

2: /* $Header: pestbapi.pkb 115.0 2003/07/03 06:24:02 kavenkat noship $ */
3: --
4: -- Package Variables
5: --
6: g_package VARCHAR2(33) := 'per_ri_setup_tasks_api.';
7: --
8: --------------------------------------------------------------------------------
9: g_dummy number(1); -- Dummy for cursor returns which are not needed
10: g_business_group_id number(15); -- For validating translation;

Line 37: l_object_version_number per_ri_setup_tasks.object_version_number%TYPE;

33: --
34: -- Declare cursors and local variables
35: --
36: l_proc Varchar2(72) := g_package||'create_setup_task';
37: l_object_version_number per_ri_setup_tasks.object_version_number%TYPE;
38: l_language_code per_ri_setup_tasks_tl.language%TYPE;
39: l_effective_date Date;
40: l_setup_task_creation_date Date;
41: l_setup_task_last_mod_date Date;

Line 38: l_language_code per_ri_setup_tasks_tl.language%TYPE;

34: -- Declare cursors and local variables
35: --
36: l_proc Varchar2(72) := g_package||'create_setup_task';
37: l_object_version_number per_ri_setup_tasks.object_version_number%TYPE;
38: l_language_code per_ri_setup_tasks_tl.language%TYPE;
39: l_effective_date Date;
40: l_setup_task_creation_date Date;
41: l_setup_task_last_mod_date Date;
42: l_setup_task_code per_ri_setup_tasks.setup_task_code%TYPE;

Line 42: l_setup_task_code per_ri_setup_tasks.setup_task_code%TYPE;

38: l_language_code per_ri_setup_tasks_tl.language%TYPE;
39: l_effective_date Date;
40: l_setup_task_creation_date Date;
41: l_setup_task_last_mod_date Date;
42: l_setup_task_code per_ri_setup_tasks.setup_task_code%TYPE;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 73: -- Insert non-translatable rows into PER_RI_SETUP_TASKS first

69: hr_utility.set_location(l_proc, 20);
70:
71: -- Process Logic
72: --
73: -- Insert non-translatable rows into PER_RI_SETUP_TASKS first
74: per_stb_ins.ins
75: (p_workbench_item_code => p_workbench_item_code
76: ,p_setup_task_code => l_setup_task_code
77: ,p_setup_task_sequence => p_setup_task_sequence

Line 87: -- Now insert translatable rows in PER_RI_SETUP_TASKS table

83: ,p_effective_date => l_effective_date
84: ,p_object_version_number => l_object_version_number
85: );
86: --
87: -- Now insert translatable rows in PER_RI_SETUP_TASKS table
88: per_stl_ins.ins_tl
89: (p_setup_task_code =>p_setup_task_code
90: ,p_setup_task_name =>p_setup_task_name
91: ,p_setup_task_description =>p_setup_task_description

Line 193: -- Insert non-translatable rows in PER_RI_SETUP_TASKS Table

189: -- Process Logic
190: --
191: l_object_version_number := p_object_version_number;
192: --
193: -- Insert non-translatable rows in PER_RI_SETUP_TASKS Table
194: --
195: per_stb_upd.upd
196: (p_setup_task_code => p_setup_task_code
197: ,p_workbench_item_code => p_workbench_item_code

Line 208: -- Now insert translatable rows in PER_RI_SETUP_TASKS_TL table

204: ,p_effective_date => l_effective_date
205: ,p_object_version_number => l_object_version_number
206: ) ;
207: --
208: -- Now insert translatable rows in PER_RI_SETUP_TASKS_TL table
209:
210: per_stl_upd.upd_tl
211: ( p_setup_task_code => p_setup_task_code
212: ,p_setup_task_name => p_setup_task_name