APPS.GHR_CMP_SHD dependencies on GHR_COMPLAINTS2

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

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

204: ,attribute27
205: ,attribute28
206: ,attribute29
207: ,attribute30
208: from ghr_complaints2
209: where complaint_id = p_complaint_id;
210: --
211: l_fct_ret boolean;
212: --

Line 432: from ghr_complaints2

428: ,attribute27
429: ,attribute28
430: ,attribute29
431: ,attribute30
432: from ghr_complaints2
433: where complaint_id = p_complaint_id
434: for update nowait;
435: --
436: l_proc varchar2(72) := g_package||'lck';

Line 481: fnd_message.set_token('TABLE_NAME', 'ghr_complaints2');

477: -- The object is locked therefore we need to supply a meaningful
478: -- error message.
479: --
480: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
481: fnd_message.set_token('TABLE_NAME', 'ghr_complaints2');
482: fnd_message.raise_error;
483: End lck;
484: --
485: -- ----------------------------------------------------------------------------