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
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: Exception
229: When hr_api.check_integrity_violated Then
230: -- A check constraint has been violated
231: per_apr_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.parent_integrity_violated Then
234: -- Parent integrity has been violated
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.parent_integrity_violated Then
234: -- Parent integrity has been violated
235: per_apr_shd.constraint_error
236: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
237: When hr_api.unique_integrity_violated Then
238: -- Unique integrity has been violated
239: per_apr_shd.constraint_error
235: per_apr_shd.constraint_error
236: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
237: When hr_api.unique_integrity_violated Then
238: -- Unique integrity has been violated
239: per_apr_shd.constraint_error
240: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
241: When Others Then
242: Raise;
243: End insert_dml;
278: -- Internal Table Handler Use Only.
279:
280: -- {End Of Comments}
281: -- ---------------------------------------------------------------------------+
282: Procedure pre_insert(p_rec in out nocopy per_apr_shd.g_rec_type) is
283:
284: l_proc varchar2(72) := g_package||'pre_insert';
285: l_exists varchar2(1);
286:
360: -- Internal Table Handler Use Only.
361:
362: -- {End Of Comments}
363: -- ---------------------------------------------------------------------------+
364: Procedure post_insert(p_rec in per_apr_shd.g_rec_type) is
365:
366: l_proc varchar2(72) := g_package||'post_insert';
367:
368: Begin
459: -- |---------------------------------< ins >----------------------------------|
460: -- ---------------------------------------------------------------------------+
461: Procedure ins
462: (
463: p_rec in out nocopy per_apr_shd.g_rec_type,
464: p_effective_date in date ,
465: p_validate in boolean default false
466: ) is
467:
595: p_validate in boolean default false,
596: p_show_participant_comments in varchar2 default null -- 8651478 bug fix
597: ) is
598:
599: l_rec per_apr_shd.g_rec_type;
600: l_proc varchar2(72) := g_package||'ins';
601:
602: Begin
603: hr_utility.set_location('Entering:'||l_proc, 5);
605: -- Call conversion function to turn arguments into the
606: -- p_rec structure.
607:
608: l_rec :=
609: per_apr_shd.convert_args
610: (
611: null,
612: p_business_group_id,
613: null,