DBA Data[Home] [Help]

APPS.PER_APR_INS dependencies on PER_APR_SHD

Line 70: Procedure insert_dml(p_rec in out nocopy per_apr_shd.g_rec_type) is

66: -- Internal Table Handler Use Only.
67:
68: -- {End Of Comments}
69: -- ---------------------------------------------------------------------------+
70: Procedure insert_dml(p_rec in out nocopy per_apr_shd.g_rec_type) is
71:
72: l_proc varchar2(72) := g_package||'insert_dml';
73:
74: Begin

Line 227: per_apr_shd.constraint_error

223: hr_utility.set_location(' Leaving:'||l_proc, 10);
224: Exception
225: When hr_api.check_integrity_violated Then
226: -- A check constraint has been violated
227: per_apr_shd.constraint_error
228: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
229: When hr_api.parent_integrity_violated Then
230: -- Parent integrity has been violated
231: per_apr_shd.constraint_error

Line 231: per_apr_shd.constraint_error

227: per_apr_shd.constraint_error
228: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
229: When hr_api.parent_integrity_violated Then
230: -- Parent integrity has been violated
231: per_apr_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: per_apr_shd.constraint_error

Line 235: per_apr_shd.constraint_error

231: per_apr_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: per_apr_shd.constraint_error
236: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
237: When Others Then
238: Raise;
239: End insert_dml;

Line 278: Procedure pre_insert(p_rec in out nocopy per_apr_shd.g_rec_type) is

274: -- Internal Table Handler Use Only.
275:
276: -- {End Of Comments}
277: -- ---------------------------------------------------------------------------+
278: Procedure pre_insert(p_rec in out nocopy per_apr_shd.g_rec_type) is
279:
280: l_proc varchar2(72) := g_package||'pre_insert';
281: l_exists varchar2(1);
282:

Line 360: Procedure post_insert(p_rec in per_apr_shd.g_rec_type) is

356: -- Internal Table Handler Use Only.
357:
358: -- {End Of Comments}
359: -- ---------------------------------------------------------------------------+
360: Procedure post_insert(p_rec in per_apr_shd.g_rec_type) is
361:
362: l_proc varchar2(72) := g_package||'post_insert';
363:
364: Begin

Line 457: p_rec in out nocopy per_apr_shd.g_rec_type,

453: -- |---------------------------------< ins >----------------------------------|
454: -- ---------------------------------------------------------------------------+
455: Procedure ins
456: (
457: p_rec in out nocopy per_apr_shd.g_rec_type,
458: p_effective_date in date ,
459: p_validate in boolean default false
460: ) is
461:

Line 591: l_rec per_apr_shd.g_rec_type;

587: p_offline_status in varchar2 default null,
588: p_validate in boolean default false
589: ) is
590:
591: l_rec per_apr_shd.g_rec_type;
592: l_proc varchar2(72) := g_package||'ins';
593:
594: Begin
595: hr_utility.set_location('Entering:'||l_proc, 5);

Line 601: per_apr_shd.convert_args

597: -- Call conversion function to turn arguments into the
598: -- p_rec structure.
599:
600: l_rec :=
601: per_apr_shd.convert_args
602: (
603: null,
604: p_business_group_id,
605: null,