APPS.PER_CTK_INS dependencies on PER_TASKS_IN_CHECKLIST

Line 87: -- Insert the row into: per_tasks_in_checklist

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: per_tasks_in_checklist
88: --
89: insert into per_tasks_in_checklist
90: (task_in_checklist_id
91: ,checklist_id

Line 89: insert into per_tasks_in_checklist

85: --
86: --
87: -- Insert the row into: per_tasks_in_checklist
88: --
89: insert into per_tasks_in_checklist
90: (task_in_checklist_id
91: ,checklist_id
92: ,checklist_task_name
93: ,eligibility_object_id

Line 270: Cursor C_Sel1 is select per_tasks_in_checklist_s.nextval from sys.dual;

266: (p_rec in out nocopy per_ctk_shd.g_rec_type
267: ,p_effective_date in date
268: ) is
269: --
270: Cursor C_Sel1 is select per_tasks_in_checklist_s.nextval from sys.dual;
271: --
272: cursor c_bg_id(p_checklist_id number) is
273: select business_group_id
274: from per_checklists

Line 279: from per_tasks_in_checklist

275: where checklist_id = p_checklist_id;
276: --
277: Cursor C_Sel2 is
278: Select null
279: from per_tasks_in_checklist
280: where task_in_checklist_id =
281: per_ctk_ins.g_task_in_checklist_id_i;
282: --
283: cursor c_elig_prfl_dates(cur_p_elig_prfl_id number) is

Line 303: l_tab_name varchar2(30) := 'PER_TASKS_IN_CHECKLIST';

299: l_elig_obj_elig_prfl_id number;
300: l_prf_ovn number;
301: l_obj_ovn number;
302: l_effective_date date;
303: l_tab_name varchar2(30) := 'PER_TASKS_IN_CHECKLIST';
304: l_col_name varchar2(30) := 'TASK_IN_CHECKLIST_ID';
305: l_tic_id number;
306: l_effective_start_date date;
307: l_effective_end_date date;

Line 324: fnd_message.set_token('TABLE_NAME','per_tasks_in_checklist');

320: --
321: -- The primary key values are already in use.
322: --
323: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
324: fnd_message.set_token('TABLE_NAME','per_tasks_in_checklist');
325: fnd_message.raise_error;
326: End If;
327: Close C_Sel2;
328: --

Line 378: ,p_table_name => l_tab_name --'PER_TASKS_IN_CHECKLIST'

374: ,p_elig_obj_id => l_elig_obj_id
375: ,p_effective_start_date => l_effective_start_date
376: ,p_effective_end_date => l_effective_end_date
377: ,p_business_group_id => l_bgid
378: ,p_table_name => l_tab_name --'PER_TASKS_IN_CHECKLIST'
379: ,p_column_name => l_col_name
380: ,p_column_value => l_tic_id
381: ,p_object_version_number => l_obj_ovn
382: ,p_effective_date => l_effective_date

Line 569: (p_module_name => 'PER_TASKS_IN_CHECKLIST'

565: --
566: when hr_api.cannot_find_prog_unit then
567: --
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'PER_TASKS_IN_CHECKLIST'
570: ,p_hook_type => 'AI');
571: --
572: end;
573: --