APPS.PER_PAC_SHD dependencies on PER_ALLOCATED_CHECKLISTS

Line 22: If (p_constraint_name = 'PER_ALLOCATED_CHECKLISTS_PK') Then

18: l_proc varchar2(72) := g_package||'constraint_error';
19: --
20: Begin
21: --
22: If (p_constraint_name = 'PER_ALLOCATED_CHECKLISTS_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;

Line 100: from per_allocated_checklists

96: ,information17
97: ,information18
98: ,information19
99: ,information20
100: from per_allocated_checklists
101: where allocated_checklist_id = p_allocated_checklist_id;
102: --
103: l_fct_ret boolean;
104: --

Line 215: from per_allocated_checklists

211: ,information17
212: ,information18
213: ,information19
214: ,information20
215: from per_allocated_checklists
216: where allocated_checklist_id = p_allocated_checklist_id
217: for update nowait;
218: --
219: l_proc varchar2(72) := g_package||'lck';

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

260: -- The object is locked therefore we need to supply a meaningful
261: -- error message.
262: --
263: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
264: fnd_message.set_token('TABLE_NAME', 'per_allocated_checklists');
265: fnd_message.raise_error;
266: End lck;
267: --
268: -- ----------------------------------------------------------------------------