DBA Data[Home] [Help]

APPS.BEN_CPD_INS dependencies on BEN_CWB_PL_DSGN

Line 93: -- Insert the row into: ben_cwb_pl_dsgn

89: p_rec.object_version_number := 1; -- Initialise the object version
90: --
91: ben_cpd_shd.g_api_dml := true; -- Set the api dml status
92: --
93: -- Insert the row into: ben_cwb_pl_dsgn
94: --
95: insert into ben_cwb_pl_dsgn
96: (pl_id
97: ,lf_evt_ocrd_dt

Line 95: insert into ben_cwb_pl_dsgn

91: ben_cpd_shd.g_api_dml := true; -- Set the api dml status
92: --
93: -- Insert the row into: ben_cwb_pl_dsgn
94: --
95: insert into ben_cwb_pl_dsgn
96: (pl_id
97: ,lf_evt_ocrd_dt
98: ,oipl_id
99: ,effective_date

Line 347: from ben_cwb_pl_dsgn

343: ) is
344: --
345: Cursor C_Sel1 is
346: Select null
347: from ben_cwb_pl_dsgn
348: where pl_id =
349: ben_cpd_ins.g_pl_id_i
350: or lf_evt_ocrd_dt =
351: ben_cpd_ins.g_lf_evt_ocrd_dt_i

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

371: --
372: -- The primary key values are already in use.
373: --
374: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
375: fnd_message.set_token('TABLE_NAME','ben_cwb_pl_dsgn');
376: fnd_message.raise_error;
377: End If;
378: Close C_Sel1;
379: --

Line 638: (p_module_name => 'BEN_CWB_PL_DSGN'

634: --
635: when hr_api.cannot_find_prog_unit then
636: --
637: hr_api.cannot_find_prog_unit_error
638: (p_module_name => 'BEN_CWB_PL_DSGN'
639: ,p_hook_type => 'AI');
640: --
641: end;
642: --