DBA Data[Home] [Help]

APPS.PER_CTK_SHD dependencies on PER_TASKS_IN_CHECKLIST

Line 21: If (p_constraint_name = 'PER_TASKS_IN_CHECKLIST_PK') Then

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

Line 104: from per_tasks_in_checklist

100: ,information17
101: ,information18
102: ,information19
103: ,information20
104: from per_tasks_in_checklist
105: where task_in_checklist_id = p_task_in_checklist_id;
106: --
107: l_fct_ret boolean;
108: --

Line 224: from per_tasks_in_checklist

220: ,information17
221: ,information18
222: ,information19
223: ,information20
224: from per_tasks_in_checklist
225: where task_in_checklist_id = p_task_in_checklist_id
226: for update nowait;
227: --
228: l_proc varchar2(72) := g_package||'lck';

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

269: -- The object is locked therefore we need to supply a meaningful
270: -- error message.
271: --
272: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
273: fnd_message.set_token('TABLE_NAME', 'per_tasks_in_checklist');
274: fnd_message.raise_error;
275: End lck;
276: --
277: -- ----------------------------------------------------------------------------