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 231: per_apr_shd.constraint_error

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

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.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

Line 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;

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

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:

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

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

Line 463: p_rec in out nocopy per_apr_shd.g_rec_type,

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:

Line 599: l_rec per_apr_shd.g_rec_type;

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);

Line 609: per_apr_shd.convert_args

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,