DBA Data[Home] [Help]

APPS.PER_PAT_INS dependencies on PER_PAT_SHD

Line 77: (p_rec in out nocopy per_pat_shd.g_rec_type

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

Line 218: per_pat_shd.constraint_error

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

Line 223: per_pat_shd.constraint_error

219: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
220: When hr_api.parent_integrity_violated Then
221: -- Parent integrity has been violated
222: --
223: per_pat_shd.constraint_error
224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When hr_api.unique_integrity_violated Then
226: -- Unique integrity has been violated
227: --

Line 228: per_pat_shd.constraint_error

224: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
225: When hr_api.unique_integrity_violated Then
226: -- Unique integrity has been violated
227: --
228: per_pat_shd.constraint_error
229: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
230: When Others Then
231: --
232: Raise;

Line 273: (p_rec in out nocopy per_pat_shd.g_rec_type

269: --
270: -- {End Of Comments}
271: -- ----------------------------------------------------------------------------
272: Procedure pre_insert
273: (p_rec in out nocopy per_pat_shd.g_rec_type
274: ) is
275: --
276: Cursor C_Sel1 is select per_allocated_tasks_s.nextval from sys.dual;
277: --

Line 361: ,p_rec in per_pat_shd.g_rec_type

357: -- {End Of Comments}
358: -- ----------------------------------------------------------------------------
359: Procedure post_insert
360: (p_effective_date in date
361: ,p_rec in per_pat_shd.g_rec_type
362: ) is
363: --
364: l_proc varchar2(72) := g_package||'post_insert';
365: --

Line 508: ,p_rec in out nocopy per_pat_shd.g_rec_type

504: -- |---------------------------------< ins >----------------------------------|
505: -- ----------------------------------------------------------------------------
506: Procedure ins
507: (p_effective_date in date
508: ,p_rec in out nocopy per_pat_shd.g_rec_type
509: ) is
510: --
511: l_proc varchar2(72) := g_package||'ins';
512: --

Line 612: l_rec per_pat_shd.g_rec_type;

608: ,p_allocated_task_id out nocopy number
609: ,p_object_version_number out nocopy number
610: ) is
611: --
612: l_rec per_pat_shd.g_rec_type;
613: l_proc varchar2(72) := g_package||'ins';
614: --
615: Begin
616: hr_utility.set_location('Entering:'||l_proc, 5);

Line 622: per_pat_shd.convert_args

618: -- Call conversion function to turn arguments into the
619: -- p_rec structure.
620: --
621: l_rec :=
622: per_pat_shd.convert_args
623: (null
624: ,p_allocated_checklist_id
625: ,p_task_name
626: ,p_description