DBA Data[Home] [Help]

APPS.BEN_CPI_SHD dependencies on BEN_CWB_PERSON_INFO

Line 33: If (p_constraint_name = 'BEN_CWB_PERSON_INFO_PK') Then

29: l_proc varchar2(72) := g_package||'constraint_error';
30: --
31: Begin
32: --
33: If (p_constraint_name = 'BEN_CWB_PERSON_INFO_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;

Line 213: from ben_cwb_person_info

209: ,cpi_attribute28
210: ,cpi_attribute29
211: ,cpi_attribute30
212: ,feedback_date
213: from ben_cwb_person_info
214: where group_per_in_ler_id = p_group_per_in_ler_id;
215: --
216: l_fct_ret boolean;
217: --

Line 430: from ben_cwb_person_info

426: ,cpi_attribute28
427: ,cpi_attribute29
428: ,cpi_attribute30
429: ,feedback_date
430: from ben_cwb_person_info
431: where group_per_in_ler_id = p_group_per_in_ler_id
432: for update nowait;
433: --
434: l_proc varchar2(72) := g_package||'lck';

Line 485: fnd_message.set_token('TABLE_NAME', 'ben_cwb_person_info');

481: -- The object is locked therefore we need to supply a meaningful
482: -- error message.
483: --
484: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
485: fnd_message.set_token('TABLE_NAME', 'ben_cwb_person_info');
486: fnd_message.raise_error;
487: End lck;
488: --
489: -- ----------------------------------------------------------------------------