APPS.PQH_CEI_INS dependencies on PQH_CEI_SHD

Line 76: (p_rec in out nocopy pqh_cei_shd.g_rec_type

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

Line 233: pqh_cei_shd.constraint_error

229: Exception
230: When hr_api.check_integrity_violated Then
231: -- A check constraint has been violated
232: --
233: pqh_cei_shd.constraint_error
234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When hr_api.parent_integrity_violated Then
236: -- Parent integrity has been violated
237: --

Line 238: pqh_cei_shd.constraint_error

234: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
235: When hr_api.parent_integrity_violated Then
236: -- Parent integrity has been violated
237: --
238: pqh_cei_shd.constraint_error
239: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
240: When hr_api.unique_integrity_violated Then
241: -- Unique integrity has been violated
242: --

Line 243: pqh_cei_shd.constraint_error

239: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
240: When hr_api.unique_integrity_violated Then
241: -- Unique integrity has been violated
242: --
243: pqh_cei_shd.constraint_error
244: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
245: When Others Then
246: --
247: Raise;

Line 288: (p_rec in out nocopy pqh_cei_shd.g_rec_type

284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure pre_insert
288: (p_rec in out nocopy pqh_cei_shd.g_rec_type
289: ) is
290: --
291: Cursor C_Sel1 is select pqh_corps_extra_info_s.nextval from sys.dual;
292: --

Line 376: ,p_rec in pqh_cei_shd.g_rec_type

372: -- {End Of Comments}
373: -- ----------------------------------------------------------------------------
374: Procedure post_insert
375: (p_effective_date in date
376: ,p_rec in pqh_cei_shd.g_rec_type
377: ) is
378: --
379: l_proc varchar2(72) := g_package||'post_insert';
380: --

Line 539: ,p_rec in out nocopy pqh_cei_shd.g_rec_type

535: -- |---------------------------------< ins >----------------------------------|
536: -- ----------------------------------------------------------------------------
537: Procedure ins
538: (p_effective_date in date
539: ,p_rec in out nocopy pqh_cei_shd.g_rec_type
540: ) is
541: --
542: l_proc varchar2(72) := g_package||'ins';
543: --

Line 651: l_rec pqh_cei_shd.g_rec_type;

647: ,p_corps_extra_info_id out nocopy number
648: ,p_object_version_number out nocopy number
649: ) is
650: --
651: l_rec pqh_cei_shd.g_rec_type;
652: l_proc varchar2(72) := g_package||'ins';
653: --
654: Begin
655: hr_utility.set_location('Entering:'||l_proc, 5);

Line 661: pqh_cei_shd.convert_args

657: -- Call conversion function to turn arguments into the
658: -- p_rec structure.
659: --
660: l_rec :=
661: pqh_cei_shd.convert_args
662: (null
663: ,p_corps_definition_id
664: ,p_information_type
665: ,p_information1