DBA Data[Home] [Help]

APPS.PER_CTK_INS dependencies on PER_CTK_SHD

Line 76: (p_rec in out nocopy per_ctk_shd.g_rec_type

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

Line 211: per_ctk_shd.constraint_error

207: Exception
208: When hr_api.check_integrity_violated Then
209: -- A check constraint has been violated
210: --
211: per_ctk_shd.constraint_error
212: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
213: When hr_api.parent_integrity_violated Then
214: -- Parent integrity has been violated
215: --

Line 216: per_ctk_shd.constraint_error

212: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
213: When hr_api.parent_integrity_violated Then
214: -- Parent integrity has been violated
215: --
216: per_ctk_shd.constraint_error
217: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
218: When hr_api.unique_integrity_violated Then
219: -- Unique integrity has been violated
220: --

Line 221: per_ctk_shd.constraint_error

217: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
218: When hr_api.unique_integrity_violated Then
219: -- Unique integrity has been violated
220: --
221: per_ctk_shd.constraint_error
222: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
223: When Others Then
224: --
225: Raise;

Line 266: (p_rec in out nocopy per_ctk_shd.g_rec_type

262: --
263: -- {End Of Comments}
264: -- ----------------------------------------------------------------------------
265: Procedure pre_insert
266: (p_rec in out nocopy per_ctk_shd.g_rec_type
267: ,p_effective_date in date
268: ) is
269: --
270: Cursor C_Sel1 is select per_tasks_in_checklist_s.nextval from sys.dual;

Line 441: ,p_rec in per_ctk_shd.g_rec_type

437: -- {End Of Comments}
438: -- ----------------------------------------------------------------------------
439: Procedure post_insert
440: (p_effective_date in date
441: ,p_rec in per_ctk_shd.g_rec_type
442: ) is
443: --
444: l_proc varchar2(72) := g_package||'post_insert';
445: --

Line 582: ,p_rec in out nocopy per_ctk_shd.g_rec_type

578: -- |---------------------------------< ins >----------------------------------|
579: -- ----------------------------------------------------------------------------
580: Procedure ins
581: (p_effective_date in date
582: ,p_rec in out nocopy per_ctk_shd.g_rec_type
583: ) is
584: --
585: l_proc varchar2(72) := g_package||'ins';
586: --

Line 684: l_rec per_ctk_shd.g_rec_type;

680: ,p_task_in_checklist_id out nocopy number
681: ,p_object_version_number out nocopy number
682: ) is
683: --
684: l_rec per_ctk_shd.g_rec_type;
685: l_proc varchar2(72) := g_package||'ins';
686: --
687: Begin
688: hr_utility.set_location('Entering:'||l_proc, 5);

Line 694: per_ctk_shd.convert_args

690: -- Call conversion function to turn arguments into the
691: -- p_rec structure.
692: --
693: l_rec :=
694: per_ctk_shd.convert_args
695: (null
696: ,p_checklist_id
697: ,p_checklist_task_name
698: ,p_eligibility_object_id