APPS.BEN_ERC_SHD dependencies on BEN_ENRT_RT_CTFN

Line 41: ElsIf (p_constraint_name = 'BEN_enrt_rt_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_enrt_rt_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_enrt_rt_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_enrt_rt_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 116: from ben_enrt_rt_ctfn

112: program_application_id,
113: program_id,
114: program_update_date,
115: object_version_number
116: from ben_enrt_rt_ctfn
117: where enrt_rt_ctfn_id = p_enrt_rt_ctfn_id;
118: --
119: l_proc varchar2(72) := g_package||'api_updating';
120: l_fct_ret boolean;

Line 226: from ben_enrt_rt_ctfn

222: program_application_id,
223: program_id,
224: program_update_date,
225: object_version_number
226: from ben_enrt_rt_ctfn
227: where enrt_rt_ctfn_id = p_enrt_rt_ctfn_id
228: for update nowait;
229: --
230: l_proc varchar2(72) := g_package||'lck';

Line 269: fnd_message.set_token('TABLE_NAME', 'ben_enrt_rt_ctfn');

265: -- The object is locked therefore we need to supply a meaningful
266: -- error message.
267: --
268: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
269: fnd_message.set_token('TABLE_NAME', 'ben_enrt_rt_ctfn');
270: fnd_message.raise_error;
271: End lck;
272: --
273: -- ----------------------------------------------------------------------------