APPS.BEN_CPG_INS dependencies on BEN_CWB_PERSON_GROUPS

Line 100: -- Insert the row into: ben_cwb_person_groups

96: p_rec.object_version_number := 1; -- Initialise the object version
97: --
98: ben_cpg_shd.g_api_dml := true; -- Set the api dml status
99: --
100: -- Insert the row into: ben_cwb_person_groups
101: --
102: insert into ben_cwb_person_groups
103: (group_per_in_ler_id
104: ,group_pl_id

Line 102: insert into ben_cwb_person_groups

98: ben_cpg_shd.g_api_dml := true; -- Set the api dml status
99: --
100: -- Insert the row into: ben_cwb_person_groups
101: --
102: insert into ben_cwb_person_groups
103: (group_per_in_ler_id
104: ,group_pl_id
105: ,group_oipl_id
106: ,lf_evt_ocrd_dt

Line 248: from ben_cwb_person_groups

244: ) is
245: --
246: Cursor C_Sel2 is
247: Select null
248: from ben_cwb_person_groups
249: where group_per_in_ler_id =
250: ben_cpg_ins.g_group_per_in_ler_id_i
251: or group_pl_id =
252: ben_cpg_ins.g_group_pl_id_i

Line 278: fnd_message.set_token('TABLE_NAME','ben_cwb_person_groups');

274: --
275: -- The primary key values are already in use.
276: --
277: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
278: fnd_message.set_token('TABLE_NAME','ben_cwb_person_groups');
279: fnd_message.raise_error;
280: End If;
281: Close C_Sel2;
282: --

Line 437: (p_module_name => 'BEN_CWB_PERSON_GROUPS'

433: --
434: when hr_api.cannot_find_prog_unit then
435: --
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'BEN_CWB_PERSON_GROUPS'
438: ,p_hook_type => 'AI');
439: --
440: end;
441: --