DBA Data[Home] [Help]

APPS.PER_CKL_INS dependencies on PER_CKL_SHD

Line 76: (p_rec in out nocopy per_ckl_shd.g_rec_type

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

Line 199: per_ckl_shd.constraint_error

195: Exception
196: When hr_api.check_integrity_violated Then
197: -- A check constraint has been violated
198: --
199: per_ckl_shd.constraint_error
200: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
201: When hr_api.parent_integrity_violated Then
202: -- Parent integrity has been violated
203: --

Line 204: per_ckl_shd.constraint_error

200: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
201: When hr_api.parent_integrity_violated Then
202: -- Parent integrity has been violated
203: --
204: per_ckl_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: --

Line 209: per_ckl_shd.constraint_error

205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: --
209: per_ckl_shd.constraint_error
210: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
211: When Others Then
212: --
213: Raise;

Line 254: (p_rec in out nocopy per_ckl_shd.g_rec_type

250: --
251: -- {End Of Comments}
252: -- ----------------------------------------------------------------------------
253: Procedure pre_insert
254: (p_rec in out nocopy per_ckl_shd.g_rec_type
255: ) is
256: --
257: Cursor C_Sel1 is select per_checklists_s.nextval from sys.dual;
258: --

Line 342: ,p_rec in per_ckl_shd.g_rec_type

338: -- {End Of Comments}
339: -- ----------------------------------------------------------------------------
340: Procedure post_insert
341: (p_effective_date in date
342: ,p_rec in per_ckl_shd.g_rec_type
343: ) is
344: --
345: l_proc varchar2(72) := g_package||'post_insert';
346: --

Line 471: ,p_rec in out nocopy per_ckl_shd.g_rec_type

467: -- |---------------------------------< ins >----------------------------------|
468: -- ----------------------------------------------------------------------------
469: Procedure ins
470: (p_effective_date in date
471: ,p_rec in out nocopy per_ckl_shd.g_rec_type
472: ) is
473: --
474: l_proc varchar2(72) := g_package||'ins';
475: --

Line 566: l_rec per_ckl_shd.g_rec_type;

562: ,p_checklist_id out nocopy number
563: ,p_object_version_number out nocopy number
564: ) is
565: --
566: l_rec per_ckl_shd.g_rec_type;
567: l_proc varchar2(72) := g_package||'ins';
568: --
569: Begin
570: hr_utility.set_location('Entering:'||l_proc, 5);

Line 576: per_ckl_shd.convert_args

572: -- Call conversion function to turn arguments into the
573: -- p_rec structure.
574: --
575: l_rec :=
576: per_ckl_shd.convert_args
577: (null
578: ,p_name
579: ,p_description
580: ,p_checklist_category