DBA Data[Home] [Help]

APPS.PER_RI_SETUP_SUB_TASK_API dependencies on PER_RI_SETUP_SUB_TASKS_TL

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