APPS.BEN_ECC_SHD dependencies on BEN_ELCTBL_CHC_CTFN

Line 41: ElsIf (p_constraint_name = 'BEN_ELCTBL_CHC_CTFN_FK2') Then

37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ELCTBL_CHC_CTFN_FK2') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;

Line 46: ElsIf (p_constraint_name = 'BEN_ELCTBL_CHC_CTFN_FK3') Then

42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_ELCTBL_CHC_CTFN_FK3') Then
47: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48: fnd_message.set_token('PROCEDURE', l_proc);
49: fnd_message.set_token('STEP','15');
50: fnd_message.raise_error;

Line 119: from ben_elctbl_chc_ctfn

115: program_application_id,
116: program_id,
117: program_update_date,
118: object_version_number
119: from ben_elctbl_chc_ctfn
120: where elctbl_chc_ctfn_id = p_elctbl_chc_ctfn_id;
121: --
122: l_proc varchar2(72) := g_package||'api_updating';
123: l_fct_ret boolean;

Line 232: from ben_elctbl_chc_ctfn

228: program_application_id,
229: program_id,
230: program_update_date,
231: object_version_number
232: from ben_elctbl_chc_ctfn
233: where elctbl_chc_ctfn_id = p_elctbl_chc_ctfn_id
234: for update nowait;
235: --
236: l_proc varchar2(72) := g_package||'lck';

Line 275: fnd_message.set_token('TABLE_NAME', 'ben_elctbl_chc_ctfn');

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