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.PER_ABB_INS dependencies on PER_ABB_SHD

Line 76: (p_rec in out nocopy per_abb_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy per_abb_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 85: per_abb_shd.g_api_dml := true; -- Set the api dml status

81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: per_abb_shd.g_api_dml := true; -- Set the api dml status
86: --
87: -- Insert the row into: per_absence_attendance_types
88: --
89: insert into per_absence_attendance_types

Line 216: per_abb_shd.g_api_dml := false; -- Unset the api dml status

212: ,p_rec.advance_pay
213: ,p_rec.absence_overlap_flag
214: );
215: --
216: per_abb_shd.g_api_dml := false; -- Unset the api dml status
217: --
218: hr_utility.set_location(' Leaving:'||l_proc, 10);
219: Exception
220: When hr_api.check_integrity_violated Then

Line 222: per_abb_shd.g_api_dml := false; -- Unset the api dml status

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

Line 223: per_abb_shd.constraint_error

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

Line 227: per_abb_shd.g_api_dml := false; -- Unset the api dml status

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

Line 228: per_abb_shd.constraint_error

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

Line 232: per_abb_shd.g_api_dml := false; -- Unset the api dml status

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

Line 233: per_abb_shd.constraint_error

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

Line 236: per_abb_shd.g_api_dml := false; -- Unset the api dml status

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

Line 278: (p_rec in out nocopy per_abb_shd.g_rec_type

274: --
275: -- {End Of Comments}
276: -- ----------------------------------------------------------------------------
277: Procedure pre_insert
278: (p_rec in out nocopy per_abb_shd.g_rec_type
279: ) is
280: --
281: Cursor C_Sel1 is select per_absence_attendance_types_s.nextval from sys.dual;
282: --

Line 365: (p_rec in per_abb_shd.g_rec_type

361: --
362: -- {End Of Comments}
363: -- ----------------------------------------------------------------------------
364: Procedure post_insert
365: (p_rec in per_abb_shd.g_rec_type
366: ) is
367: --
368: l_proc varchar2(72) := g_package||'post_insert';
369: --

Line 517: (p_rec in out nocopy per_abb_shd.g_rec_type

513: -- ----------------------------------------------------------------------------
514: -- |---------------------------------< ins >----------------------------------|
515: -- ----------------------------------------------------------------------------
516: Procedure ins
517: (p_rec in out nocopy per_abb_shd.g_rec_type
518: ) is
519: --
520: l_proc varchar2(72) := g_package||'ins';
521: --

Line 621: l_rec per_abb_shd.g_rec_type;

617: ,p_absence_attendance_type_id out nocopy number
618: ,p_object_version_number out nocopy number
619: ) is
620: --
621: l_rec per_abb_shd.g_rec_type;
622: l_proc varchar2(72) := g_package||'ins';
623: --
624: Begin
625: hr_utility.set_location('Entering:'||l_proc, 5);

Line 631: per_abb_shd.convert_args

627: -- Call conversion function to turn arguments into the
628: -- p_rec structure.
629: --
630: l_rec :=
631: per_abb_shd.convert_args
632: (null
633: ,p_business_group_id
634: ,p_input_value_id
635: ,p_date_effective