DBA Data[Home] [Help]

APPS.BEN_XRC_INS dependencies on BEN_XRC_SHD

Line 108: Procedure insert_dml(p_rec in out nocopy ben_xrc_shd.g_rec_type) is

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

Line 116: ben_xrc_shd.g_api_dml := true; -- Set the api dml status

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

Line 213: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status

209: p_rec.created_by,
210: p_rec.object_version_number
211: );
212: --
213: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 10);
216: Exception
217: When hr_api.check_integrity_violated Then

Line 219: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status

215: hr_utility.set_location(' Leaving:'||l_proc, 10);
216: Exception
217: When hr_api.check_integrity_violated Then
218: -- A check constraint has been violated
219: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
220: ben_xrc_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.parent_integrity_violated Then
223: -- Parent integrity has been violated

Line 220: ben_xrc_shd.constraint_error

216: Exception
217: When hr_api.check_integrity_violated Then
218: -- A check constraint has been violated
219: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
220: ben_xrc_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.parent_integrity_violated Then
223: -- Parent integrity has been violated
224: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status

Line 224: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status

220: ben_xrc_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.parent_integrity_violated Then
223: -- Parent integrity has been violated
224: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
225: ben_xrc_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: -- Unique integrity has been violated

Line 225: ben_xrc_shd.constraint_error

221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.parent_integrity_violated Then
223: -- Parent integrity has been violated
224: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
225: ben_xrc_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: -- Unique integrity has been violated
229: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status

Line 229: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status

225: ben_xrc_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: -- Unique integrity has been violated
229: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
230: ben_xrc_shd.constraint_error
231: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
232: When Others Then
233: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status

Line 230: ben_xrc_shd.constraint_error

226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When hr_api.unique_integrity_violated Then
228: -- Unique integrity has been violated
229: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
230: ben_xrc_shd.constraint_error
231: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
232: When Others Then
233: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
234: Raise;

Line 233: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status

229: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
230: ben_xrc_shd.constraint_error
231: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
232: When Others Then
233: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
234: Raise;
235: End insert_dml;
236: --
237: -- ----------------------------------------------------------------------------

Line 274: Procedure pre_insert(p_rec in out nocopy ben_xrc_shd.g_rec_type) is

270: -- Internal Row Handler Use Only.
271: --
272: -- {End Of Comments}
273: -- ----------------------------------------------------------------------------
274: Procedure pre_insert(p_rec in out nocopy ben_xrc_shd.g_rec_type) is
275: --
276: l_proc varchar2(72) := g_package||'pre_insert';
277: --
278: Cursor C_Sel1 is select ben_ext_rcd_s.nextval from sys.dual;

Line 326: p_effective_date in date,p_rec in ben_xrc_shd.g_rec_type) is

322: --
323: -- {End Of Comments}
324: -- ----------------------------------------------------------------------------
325: Procedure post_insert(
326: p_effective_date in date,p_rec in ben_xrc_shd.g_rec_type) is
327: --
328: l_proc varchar2(72) := g_package||'post_insert';
329: --
330: Begin

Line 409: p_rec in out nocopy ben_xrc_shd.g_rec_type

405: -- ----------------------------------------------------------------------------
406: Procedure ins
407: (
408: p_effective_date in date,
409: p_rec in out nocopy ben_xrc_shd.g_rec_type
410: ) is
411: --
412: l_proc varchar2(72) := g_package||'ins';
413: --

Line 492: l_rec ben_xrc_shd.g_rec_type;

488: p_created_by in number default null,
489: p_object_version_number out nocopy number
490: ) is
491: --
492: l_rec ben_xrc_shd.g_rec_type;
493: l_proc varchar2(72) := g_package||'ins';
494: --
495: Begin
496: hr_utility.set_location('Entering:'||l_proc, 5);

Line 502: ben_xrc_shd.convert_args

498: -- Call conversion function to turn arguments into the
499: -- p_rec structure.
500: --
501: l_rec :=
502: ben_xrc_shd.convert_args
503: (
504: null,
505: p_name,
506: p_xml_tag_name,