APPS.PER_PAT_SHD dependencies on PER_ALLOCATED_TASKS

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

18: l_proc varchar2(72) := g_package||'constraint_error';
19: --
20: Begin
21: --
22: If (p_constraint_name = 'PER_ALLOCATED_TASKS_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 108: from per_allocated_tasks

104: ,information17
105: ,information18
106: ,information19
107: ,information20
108: from per_allocated_tasks
109: where allocated_task_id = p_allocated_task_id;
110: --
111: l_fct_ret boolean;
112: --

Line 231: from per_allocated_tasks

227: ,information17
228: ,information18
229: ,information19
230: ,information20
231: from per_allocated_tasks
232: where allocated_task_id = p_allocated_task_id
233: for update nowait;
234: --
235: l_proc varchar2(72) := g_package||'lck';

Line 280: fnd_message.set_token('TABLE_NAME', 'per_allocated_tasks');

276: -- The object is locked therefore we need to supply a meaningful
277: -- error message.
278: --
279: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
280: fnd_message.set_token('TABLE_NAME', 'per_allocated_tasks');
281: fnd_message.raise_error;
282: End lck;
283: --
284: -- ----------------------------------------------------------------------------