DBA Data[Home] [Help]

APPS.PER_CNI_INS dependencies on PER_CNI_SHD

Line 76: (p_rec in out nocopy per_cni_shd.g_rec_type

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

Line 172: per_cni_shd.constraint_error

168: Exception
169: When hr_api.check_integrity_violated Then
170: -- A check constraint has been violated
171: --
172: per_cni_shd.constraint_error
173: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
174: When hr_api.parent_integrity_violated Then
175: -- Parent integrity has been violated
176: --

Line 177: per_cni_shd.constraint_error

173: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
174: When hr_api.parent_integrity_violated Then
175: -- Parent integrity has been violated
176: --
177: per_cni_shd.constraint_error
178: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
179: When hr_api.unique_integrity_violated Then
180: -- Unique integrity has been violated
181: --

Line 182: per_cni_shd.constraint_error

178: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
179: When hr_api.unique_integrity_violated Then
180: -- Unique integrity has been violated
181: --
182: per_cni_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When Others Then
185: --
186: Raise;

Line 227: (p_rec in out nocopy per_cni_shd.g_rec_type

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure pre_insert
227: (p_rec in out nocopy per_cni_shd.g_rec_type
228: ) is
229: --
230: Cursor C_Sel1 is select per_ri_config_information_s.nextval from sys.dual;
231: --

Line 315: ,p_rec in per_cni_shd.g_rec_type

311: -- {End Of Comments}
312: -- ----------------------------------------------------------------------------
313: Procedure post_insert
314: (p_effective_date in date
315: ,p_rec in per_cni_shd.g_rec_type
316: ) is
317: --
318: l_proc varchar2(72) := g_package||'post_insert';
319: --

Line 414: ,p_rec in out nocopy per_cni_shd.g_rec_type

410: -- |---------------------------------< ins >----------------------------------|
411: -- ----------------------------------------------------------------------------
412: Procedure ins
413: (p_effective_date in date
414: ,p_rec in out nocopy per_cni_shd.g_rec_type
415: ) is
416: --
417: l_proc varchar2(72) := g_package||'ins';
418: --

Line 495: l_rec per_cni_shd.g_rec_type;

491: ,p_config_information_id out nocopy number
492: ,p_object_version_number out nocopy number
493: ) is
494: --
495: l_rec per_cni_shd.g_rec_type;
496: l_proc varchar2(72) := g_package||'ins';
497: --
498: Begin
499: hr_utility.set_location('Entering:'||l_proc, 5);

Line 505: per_cni_shd.convert_args

501: -- Call conversion function to turn arguments into the
502: -- p_rec structure.
503: --
504: l_rec :=
505: per_cni_shd.convert_args
506: (p_configuration_code
507: ,p_config_information_category
508: ,p_config_information1
509: ,p_config_information2