APPS.PER_PAC_INS dependencies on PER_ALLOCATED_CHECKLISTS

Line 88: -- Insert the row into: per_allocated_checklists

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

Line 90: insert into per_allocated_checklists

86: --
87: --
88: -- Insert the row into: per_allocated_checklists
89: --
90: insert into per_allocated_checklists
91: (allocated_checklist_id
92: ,checklist_id
93: ,person_id
94: ,assignment_id

Line 260: Cursor C_Sel1 is select per_allocated_checklists_s.nextval from sys.dual;

256: Procedure pre_insert
257: (p_rec in out nocopy per_pac_shd.g_rec_type
258: ) is
259: --
260: Cursor C_Sel1 is select per_allocated_checklists_s.nextval from sys.dual;
261: --
262: Cursor C_Sel2 is
263: Select null
264: from per_allocated_checklists

Line 264: from per_allocated_checklists

260: Cursor C_Sel1 is select per_allocated_checklists_s.nextval from sys.dual;
261: --
262: Cursor C_Sel2 is
263: Select null
264: from per_allocated_checklists
265: where allocated_checklist_id =
266: per_pac_ins.g_allocated_checklist_id_i;
267: --
268: l_proc varchar2(72) := g_package||'pre_insert';

Line 286: fnd_message.set_token('TABLE_NAME','per_allocated_checklists');

282: --
283: -- The primary key values are already in use.
284: --
285: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
286: fnd_message.set_token('TABLE_NAME','per_allocated_checklists');
287: fnd_message.raise_error;
288: End If;
289: Close C_Sel2;
290: --

Line 463: (p_module_name => 'PER_ALLOCATED_CHECKLISTS'

459: --
460: when hr_api.cannot_find_prog_unit then
461: --
462: hr_api.cannot_find_prog_unit_error
463: (p_module_name => 'PER_ALLOCATED_CHECKLISTS'
464: ,p_hook_type => 'AI');
465: --
466: end;
467: --