DBA Data[Home] [Help]

APPS.PER_CKL_SHD dependencies on PER_CHECKLISTS

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PER_CHECKLISTS_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 98: from per_checklists

94: ,information17
95: ,information18
96: ,information19
97: ,information20
98: from per_checklists
99: where checklist_id = p_checklist_id;
100: --
101: l_fct_ret boolean;
102: --

Line 212: from per_checklists

208: ,information17
209: ,information18
210: ,information19
211: ,information20
212: from per_checklists
213: where checklist_id = p_checklist_id
214: for update nowait;
215: --
216: l_proc varchar2(72) := g_package||'lck';

Line 261: fnd_message.set_token('TABLE_NAME', 'per_checklists');

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