DBA Data[Home] [Help]

APPS.PER_PGH_INS dependencies on PER_PGH_SHD

Line 54: (p_rec in out nocopy per_pgh_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy per_pgh_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --

Line 221: per_pgh_shd.constraint_error

217: Exception
218: When hr_api.check_integrity_violated Then
219: -- A check constraint has been violated
220: --
221: per_pgh_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When hr_api.parent_integrity_violated Then
224: -- Parent integrity has been violated
225: --

Line 226: per_pgh_shd.constraint_error

222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When hr_api.parent_integrity_violated Then
224: -- Parent integrity has been violated
225: --
226: per_pgh_shd.constraint_error
227: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
228: When hr_api.unique_integrity_violated Then
229: -- Unique integrity has been violated
230: --

Line 231: per_pgh_shd.constraint_error

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

Line 276: (p_rec in out nocopy per_pgh_shd.g_rec_type

272: --
273: -- {End Of Comments}
274: -- ----------------------------------------------------------------------------
275: Procedure pre_insert
276: (p_rec in out nocopy per_pgh_shd.g_rec_type
277: ) is
278: --
279: l_proc varchar2(72) := g_package||'pre_insert';
280: --

Line 330: ,p_rec in per_pgh_shd.g_rec_type

326: -- {End Of Comments}
327: -- ----------------------------------------------------------------------------
328: Procedure post_insert
329: (p_effective_date in date
330: ,p_rec in per_pgh_shd.g_rec_type
331: ) is
332: --
333: l_proc varchar2(72) := g_package||'post_insert';
334: --

Line 503: ,p_rec in out nocopy per_pgh_shd.g_rec_type

499: -- |---------------------------------< ins >----------------------------------|
500: -- ----------------------------------------------------------------------------
501: Procedure ins
502: (p_effective_date in date
503: ,p_rec in out nocopy per_pgh_shd.g_rec_type
504: ) is
505: --
506: l_proc varchar2(72) := g_package||'ins';
507: --

Line 614: l_rec per_pgh_shd.g_rec_type;

610: ,p_hierarchy_id in out nocopy number
611: ,p_object_version_number in out nocopy number
612: ) is
613: --
614: l_rec per_pgh_shd.g_rec_type;
615: l_proc varchar2(72) := g_package||'ins';
616: --
617: Begin
618: hr_utility.set_location('Entering:'||l_proc, 5);

Line 624: per_pgh_shd.convert_args

620: -- Call conversion function to turn arguments into the
621: -- p_rec structure.
622: --
623: l_rec :=
624: per_pgh_shd.convert_args
625: (null
626: ,p_business_group_id
627: ,p_name
628: ,p_type