DBA Data[Home] [Help]

APPS.PER_RI_SETUP_SUB_TASK_API dependencies on PER_RI_SETUP_SUB_TASKS

Line 39: l_object_version_number per_ri_setup_sub_tasks.object_version_number%TYPE;

35: --
36: -- Declare cursors and local variables
37: --
38: l_proc Varchar2(72) := g_package||'create_setup_sub_task';
39: l_object_version_number per_ri_setup_sub_tasks.object_version_number%TYPE;
40: l_language_code per_ri_setup_sub_tasks_tl.language%TYPE;
41: l_effective_date Date;
42: l_setup_sub_task_creation_date Date;
43: l_setup_sub_task_last_mod_date Date;

Line 40: l_language_code per_ri_setup_sub_tasks_tl.language%TYPE;

36: -- Declare cursors and local variables
37: --
38: l_proc Varchar2(72) := g_package||'create_setup_sub_task';
39: l_object_version_number per_ri_setup_sub_tasks.object_version_number%TYPE;
40: l_language_code per_ri_setup_sub_tasks_tl.language%TYPE;
41: l_effective_date Date;
42: l_setup_sub_task_creation_date Date;
43: l_setup_sub_task_last_mod_date Date;
44: l_setup_sub_task_code per_ri_setup_sub_tasks.setup_sub_task_code%TYPE;

Line 44: l_setup_sub_task_code per_ri_setup_sub_tasks.setup_sub_task_code%TYPE;

40: l_language_code per_ri_setup_sub_tasks_tl.language%TYPE;
41: l_effective_date Date;
42: l_setup_sub_task_creation_date Date;
43: l_setup_sub_task_last_mod_date Date;
44: l_setup_sub_task_code per_ri_setup_sub_tasks.setup_sub_task_code%TYPE;
45: --
46: Begin
47: --
48: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 75: -- Insert non-translatable rows into PER_RI_SETUP_SUB_TASKS first

71: hr_utility.set_location(l_proc, 20);
72:
73: -- Process Logic
74: --
75: -- Insert non-translatable rows into PER_RI_SETUP_SUB_TASKS first
76:
77: per_ssb_ins.ins
78: (p_setup_task_code => p_setup_task_code
79: ,p_setup_sub_task_sequence => p_setup_sub_task_sequence

Line 93: -- Now insert translatable rows in PER_RI_SETUP_SUB_TASKS_TL table

89: ,p_object_version_number => l_object_version_number
90: );
91:
92: --
93: -- Now insert translatable rows in PER_RI_SETUP_SUB_TASKS_TL table
94: per_sst_ins.ins_tl
95: ( p_setup_sub_task_code => p_setup_sub_task_code
96: ,p_setup_sub_task_name => p_setup_sub_task_name
97: ,p_setup_sub_task_description => p_setup_sub_task_description

Line 166: l_object_version_number per_ri_setup_sub_tasks.object_version_number%TYPE;

162: --
163: -- Declare cursors and local variables
164: --
165: l_proc VARCHAR2(72) := g_package||'update_setup_sub_task';
166: l_object_version_number per_ri_setup_sub_tasks.object_version_number%TYPE;
167: l_language_code per_ri_setup_sub_tasks_tl.language%TYPE;
168: l_setup_sub_task_creation_date Date;
169: l_setup_sub_task_last_mod_date Date;
170: l_effective_date Date;

Line 167: l_language_code per_ri_setup_sub_tasks_tl.language%TYPE;

163: -- Declare cursors and local variables
164: --
165: l_proc VARCHAR2(72) := g_package||'update_setup_sub_task';
166: l_object_version_number per_ri_setup_sub_tasks.object_version_number%TYPE;
167: l_language_code per_ri_setup_sub_tasks_tl.language%TYPE;
168: l_setup_sub_task_creation_date Date;
169: l_setup_sub_task_last_mod_date Date;
170: l_effective_date Date;
171:

Line 202: -- Update non-translatable rows in PER_RI_SETUP_SUB_TASKS Table

198: -- Process Logic
199: --
200: l_object_version_number := p_object_version_number;
201: --
202: -- Update non-translatable rows in PER_RI_SETUP_SUB_TASKS Table
203: --
204: per_ssb_upd.upd
205: (p_setup_task_code => p_setup_task_code
206: ,p_setup_sub_task_sequence => p_setup_sub_task_sequence

Line 220: -- Now update translatable rows in PER_RI_SETUP_SUB_TASKS_TL table

216: ,p_object_version_number => l_object_version_number
217: );
218:
219: --
220: -- Now update translatable rows in PER_RI_SETUP_SUB_TASKS_TL table
221: per_sst_upd.upd_tl
222: ( p_setup_sub_task_code => p_setup_sub_task_code
223: ,p_setup_sub_task_name => p_setup_sub_task_name
224: ,p_setup_sub_task_description => p_setup_sub_task_description