APPS.BEN_CWG_INS dependencies on BEN_CWB_WKSHT_GRP

Line 87: -- Insert the row into: ben_cwb_wksht_grp

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: ben_cwb_wksht_grp
88: --
89: insert into ben_cwb_wksht_grp
90: (cwb_wksht_grp_id
91: ,business_group_id

Line 89: insert into ben_cwb_wksht_grp

85: --
86: --
87: -- Insert the row into: ben_cwb_wksht_grp
88: --
89: insert into ben_cwb_wksht_grp
90: (cwb_wksht_grp_id
91: ,business_group_id
92: ,pl_id
93: ,ordr_num

Line 239: Cursor C_Sel1 is select ben_cwb_wksht_grp_s.nextval from sys.dual;

235: Procedure pre_insert
236: (p_rec in out nocopy ben_cwg_shd.g_rec_type
237: ) is
238: --
239: Cursor C_Sel1 is select ben_cwb_wksht_grp_s.nextval from sys.dual;
240: --
241: Cursor C_Sel2 is
242: Select null
243: from ben_cwb_wksht_grp

Line 243: from ben_cwb_wksht_grp

239: Cursor C_Sel1 is select ben_cwb_wksht_grp_s.nextval from sys.dual;
240: --
241: Cursor C_Sel2 is
242: Select null
243: from ben_cwb_wksht_grp
244: where cwb_wksht_grp_id =
245: ben_cwg_ins.g_cwb_wksht_grp_id_i;
246: --
247: l_proc varchar2(72) := g_package||'pre_insert';

Line 265: fnd_message.set_token('TABLE_NAME','ben_cwb_wksht_grp');

261: --
262: -- The primary key values are already in use.
263: --
264: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
265: fnd_message.set_token('TABLE_NAME','ben_cwb_wksht_grp');
266: fnd_message.raise_error;
267: End If;
268: Close C_Sel2;
269: --

Line 420: (p_module_name => 'BEN_CWB_WKSHT_GRP'

416: --
417: when hr_api.cannot_find_prog_unit then
418: --
419: hr_api.cannot_find_prog_unit_error
420: (p_module_name => 'BEN_CWB_WKSHT_GRP'
421: ,p_hook_type => 'AI');
422: --
423: end;
424: --