APPS.BEN_CPD_SHD dependencies on BEN_CWB_PL_DSGN

Line 32: If (p_constraint_name = 'BEN_CWB_PL_DSGN_PK') Then

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

Line 160: from ben_cwb_pl_dsgn

156: ,email_cc_manager
157: ,email_subject
158: ,email_content
159: ,email_sample_address
160: from ben_cwb_pl_dsgn
161: where pl_id = p_pl_id
162: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
163: and oipl_id = p_oipl_id;
164: --

Line 333: from ben_cwb_pl_dsgn

329: ,email_cc_manager
330: ,email_subject
331: ,email_content
332: ,email_sample_address
333: from ben_cwb_pl_dsgn
334: where pl_id = p_pl_id
335: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
336: and oipl_id = p_oipl_id
337: for update nowait;

Line 398: fnd_message.set_token('TABLE_NAME', 'ben_cwb_pl_dsgn');

394: -- The object is locked therefore we need to supply a meaningful
395: -- error message.
396: --
397: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
398: fnd_message.set_token('TABLE_NAME', 'ben_cwb_pl_dsgn');
399: fnd_message.raise_error;
400: End lck;
401: --
402: -- ----------------------------------------------------------------------------