eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CPG_INS dependencies on BEN_CPG_SHD

Line 87: (p_rec in out nocopy ben_cpg_shd.g_rec_type

83: --
84: -- {End Of Comments}
85: -- ----------------------------------------------------------------------------
86: Procedure insert_dml
87: (p_rec in out nocopy ben_cpg_shd.g_rec_type
88: ) is
89: --
90: l_proc varchar2(72) := g_package||'insert_dml';
91: --

Line 98: ben_cpg_shd.g_api_dml := true; -- Set the api dml status

94: hr_utility.set_location('Entering:'||l_proc, 5);
95: end if;
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

Line 179: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status

175: ,p_rec.rsrv_val_last_upd_by
176: ,p_rec.object_version_number
177: );
178: --
179: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
180: --
181: if g_debug then
182: hr_utility.set_location(' Leaving:'||l_proc, 10);
183: end if;

Line 187: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status

183: end if;
184: Exception
185: When hr_api.check_integrity_violated Then
186: -- A check constraint has been violated
187: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
188: ben_cpg_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.parent_integrity_violated Then
191: -- Parent integrity has been violated

Line 188: ben_cpg_shd.constraint_error

184: Exception
185: When hr_api.check_integrity_violated Then
186: -- A check constraint has been violated
187: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
188: ben_cpg_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.parent_integrity_violated Then
191: -- Parent integrity has been violated
192: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status

Line 192: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status

188: ben_cpg_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.parent_integrity_violated Then
191: -- Parent integrity has been violated
192: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
193: ben_cpg_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.unique_integrity_violated Then
196: -- Unique integrity has been violated

Line 193: ben_cpg_shd.constraint_error

189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.parent_integrity_violated Then
191: -- Parent integrity has been violated
192: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
193: ben_cpg_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.unique_integrity_violated Then
196: -- Unique integrity has been violated
197: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status

Line 197: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status

193: ben_cpg_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.unique_integrity_violated Then
196: -- Unique integrity has been violated
197: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
198: ben_cpg_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When Others Then
201: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status

Line 198: ben_cpg_shd.constraint_error

194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When hr_api.unique_integrity_violated Then
196: -- Unique integrity has been violated
197: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
198: ben_cpg_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When Others Then
201: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
202: Raise;

Line 201: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status

197: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
198: ben_cpg_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When Others Then
201: ben_cpg_shd.g_api_dml := false; -- Unset the api dml status
202: Raise;
203: End insert_dml;
204: --
205: -- ----------------------------------------------------------------------------

Line 243: (p_rec in out nocopy ben_cpg_shd.g_rec_type

239: --
240: -- {End Of Comments}
241: -- ----------------------------------------------------------------------------
242: Procedure pre_insert
243: (p_rec in out nocopy ben_cpg_shd.g_rec_type
244: ) is
245: --
246: Cursor C_Sel2 is
247: Select null

Line 346: (p_rec in ben_cpg_shd.g_rec_type

342: --
343: -- {End Of Comments}
344: -- ----------------------------------------------------------------------------
345: Procedure post_insert
346: (p_rec in ben_cpg_shd.g_rec_type
347: ) is
348: --
349: l_proc varchar2(72) := g_package||'post_insert';
350: --

Line 451: (p_rec in out nocopy ben_cpg_shd.g_rec_type

447: -- ----------------------------------------------------------------------------
448: -- |---------------------------------< ins >----------------------------------|
449: -- ----------------------------------------------------------------------------
450: Procedure ins
451: (p_rec in out nocopy ben_cpg_shd.g_rec_type
452: ) is
453: --
454: l_proc varchar2(72) := g_package||'ins';
455: --

Line 538: l_rec ben_cpg_shd.g_rec_type;

534: ,p_rsrv_val_last_upd_by in number default null
535: ,p_object_version_number out nocopy number
536: ) is
537: --
538: l_rec ben_cpg_shd.g_rec_type;
539: l_proc varchar2(72) := g_package||'ins';
540: --
541: Begin
542: if g_debug then

Line 550: ben_cpg_shd.convert_args

546: -- Call conversion function to turn arguments into the
547: -- p_rec structure.
548: --
549: l_rec :=
550: ben_cpg_shd.convert_args
551: (p_group_per_in_ler_id
552: ,p_group_pl_id
553: ,p_group_oipl_id
554: ,p_lf_evt_ocrd_dt