APPS.BEN_BNR_INS dependencies on BEN_RPTG_GRP

Line 67: -- Insert the row into: ben_rptg_grp

63: p_rec.object_version_number := 1; -- Initialise the object version
64: --
65: ben_bnr_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Insert the row into: ben_rptg_grp
68: --
69: insert into ben_rptg_grp
70: ( rptg_grp_id,
71: name,

Line 69: insert into ben_rptg_grp

65: ben_bnr_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Insert the row into: ben_rptg_grp
68: --
69: insert into ben_rptg_grp
70: ( rptg_grp_id,
71: name,
72: business_group_id,
73: rptg_prps_cd,

Line 155: insert into ben_rptg_grp_tl (

151: p_rec.ordr_num --iRec
152: );
153: --
154: -- insert into translation table
155: insert into ben_rptg_grp_tl (
156: rptg_grp_id,
157: function_code,
158: name,
159: language,

Line 182: from ben_rptg_grp_tl t

178: from fnd_languages l
179: where l.installed_flag in ('I', 'B')
180: and not exists
181: (select null
182: from ben_rptg_grp_tl t
183: where t.rptg_grp_id = p_rec.rptg_grp_id
184: and t.language = l.language_code);
185: --
186: ben_bnr_shd.g_api_dml := false; -- Unset the api dml status

Line 251: Cursor C_Sel1 is select ben_rptg_grp_s.nextval from sys.dual;

247: Procedure pre_insert(p_rec in out nocopy ben_bnr_shd.g_rec_type) is
248: --
249: l_proc varchar2(72) := g_package||'pre_insert';
250: --
251: Cursor C_Sel1 is select ben_rptg_grp_s.nextval from sys.dual;
252: --
253: cursor c_legislation is
254: select legislation_code
255: from per_business_groups

Line 370: (p_module_name => 'ben_rptg_grp'

366: --
367: when hr_api.cannot_find_prog_unit then
368: --
369: hr_api.cannot_find_prog_unit_error
370: (p_module_name => 'ben_rptg_grp'
371: ,p_hook_type => 'AI');
372: --
373: end;
374: --