DBA Data[Home] [Help]

APPS.BEN_XDF_INS dependencies on BEN_XDF_SHD

Line 107: Procedure insert_dml(p_rec in out nocopy ben_xdf_shd.g_rec_type) is

103: -- Internal Row Handler Use Only.
104: --
105: -- {End Of Comments}
106: -- ----------------------------------------------------------------------------
107: Procedure insert_dml(p_rec in out nocopy ben_xdf_shd.g_rec_type) is
108: --
109: l_proc varchar2(72) := g_package||'insert_dml';
110: --
111: Begin

Line 115: ben_xdf_shd.g_api_dml := true; -- Set the api dml status

111: Begin
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: p_rec.object_version_number := 1; -- Initialise the object version
114: --
115: ben_xdf_shd.g_api_dml := true; -- Set the api dml status
116: --
117: -- Insert the row into: ben_ext_dfn
118: --
119: insert into ben_ext_dfn

Line 248: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status

244: p_rec.use_eff_dt_for_chgs_flag,
245: p_rec.ext_post_prcs_rl
246: );
247: --
248: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status
249: --
250: hr_utility.set_location(' Leaving:'||l_proc, 10);
251: Exception
252: When hr_api.check_integrity_violated Then

Line 254: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status

250: hr_utility.set_location(' Leaving:'||l_proc, 10);
251: Exception
252: When hr_api.check_integrity_violated Then
253: -- A check constraint has been violated
254: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status
255: ben_xdf_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.parent_integrity_violated Then
258: -- Parent integrity has been violated

Line 255: ben_xdf_shd.constraint_error

251: Exception
252: When hr_api.check_integrity_violated Then
253: -- A check constraint has been violated
254: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status
255: ben_xdf_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.parent_integrity_violated Then
258: -- Parent integrity has been violated
259: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status

Line 259: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status

255: ben_xdf_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.parent_integrity_violated Then
258: -- Parent integrity has been violated
259: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status
260: ben_xdf_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When hr_api.unique_integrity_violated Then
263: -- Unique integrity has been violated

Line 260: ben_xdf_shd.constraint_error

256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.parent_integrity_violated Then
258: -- Parent integrity has been violated
259: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status
260: ben_xdf_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When hr_api.unique_integrity_violated Then
263: -- Unique integrity has been violated
264: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status

Line 264: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status

260: ben_xdf_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When hr_api.unique_integrity_violated Then
263: -- Unique integrity has been violated
264: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status
265: ben_xdf_shd.constraint_error
266: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
267: When Others Then
268: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status

Line 265: ben_xdf_shd.constraint_error

261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When hr_api.unique_integrity_violated Then
263: -- Unique integrity has been violated
264: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status
265: ben_xdf_shd.constraint_error
266: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
267: When Others Then
268: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status
269: Raise;

Line 268: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status

264: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status
265: ben_xdf_shd.constraint_error
266: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
267: When Others Then
268: ben_xdf_shd.g_api_dml := false; -- Unset the api dml status
269: Raise;
270: End insert_dml;
271: --
272: -- ----------------------------------------------------------------------------

Line 309: Procedure pre_insert(p_rec in out nocopy ben_xdf_shd.g_rec_type) is

305: -- Internal Row Handler Use Only.
306: --
307: -- {End Of Comments}
308: -- ----------------------------------------------------------------------------
309: Procedure pre_insert(p_rec in out nocopy ben_xdf_shd.g_rec_type) is
310: --
311: l_proc varchar2(72) := g_package||'pre_insert';
312: --
313: Cursor C_Sel1 is select ben_ext_dfn_s.nextval from sys.dual;

Line 361: p_effective_date in date,p_rec in ben_xdf_shd.g_rec_type) is

357: --
358: -- {End Of Comments}
359: -- ----------------------------------------------------------------------------
360: Procedure post_insert(
361: p_effective_date in date,p_rec in ben_xdf_shd.g_rec_type) is
362: --
363: l_proc varchar2(72) := g_package||'post_insert';
364: --
365: Begin

Line 462: p_rec in out nocopy ben_xdf_shd.g_rec_type

458: -- ----------------------------------------------------------------------------
459: Procedure ins
460: (
461: p_effective_date in date,
462: p_rec in out nocopy ben_xdf_shd.g_rec_type
463: ) is
464: --
465: l_proc varchar2(72) := g_package||'ins';
466: --

Line 564: l_rec ben_xdf_shd.g_rec_type;

560: p_use_eff_dt_for_chgs_flag in varchar2 default null,
561: p_ext_post_prcs_rl in number default null
562: ) is
563: --
564: l_rec ben_xdf_shd.g_rec_type;
565: l_proc varchar2(72) := g_package||'ins';
566: --
567: Begin
568: hr_utility.set_location('Entering:'||l_proc, 5);

Line 574: ben_xdf_shd.convert_args

570: -- Call conversion function to turn arguments into the
571: -- p_rec structure.
572: --
573: l_rec :=
574: ben_xdf_shd.convert_args
575: (
576: null,
577: p_name,
578: p_xml_tag_name,