DBA Data[Home] [Help]

APPS.HR_DEI_INS dependencies on HR_DEI_SHD

Line 70: (p_rec in out nocopy hr_dei_shd.g_rec_type

66: --
67: -- {End Of Comments}
68: -- ----------------------------------------------------------------------------
69: Procedure insert_dml
70: (p_rec in out nocopy hr_dei_shd.g_rec_type
71: ) is
72: --
73: l_proc varchar2(72) := g_package||'insert_dml';
74: --

Line 259: hr_dei_shd.constraint_error

255: Exception
256: When hr_api.check_integrity_violated Then
257: -- A check constraint has been violated
258: --
259: hr_dei_shd.constraint_error
260: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
261: When hr_api.parent_integrity_violated Then
262: -- Parent integrity has been violated
263: --

Line 264: hr_dei_shd.constraint_error

260: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
261: When hr_api.parent_integrity_violated Then
262: -- Parent integrity has been violated
263: --
264: hr_dei_shd.constraint_error
265: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
266: When hr_api.unique_integrity_violated Then
267: -- Unique integrity has been violated
268: --

Line 269: hr_dei_shd.constraint_error

265: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
266: When hr_api.unique_integrity_violated Then
267: -- Unique integrity has been violated
268: --
269: hr_dei_shd.constraint_error
270: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
271: When Others Then
272: --
273: Raise;

Line 314: (p_rec in out nocopy hr_dei_shd.g_rec_type

310: --
311: -- {End Of Comments}
312: -- ----------------------------------------------------------------------------
313: Procedure pre_insert
314: (p_rec in out nocopy hr_dei_shd.g_rec_type
315: ) is
316: --
317: Cursor C_Sel1 is select hr_document_extra_info_s.nextval from sys.dual;
318: --

Line 401: (p_rec in hr_dei_shd.g_rec_type

397: --
398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: Procedure post_insert
401: (p_rec in hr_dei_shd.g_rec_type
402: ) is
403: --
404: l_proc varchar2(72) := g_package||'post_insert';
405: --

Line 594: (p_rec in out nocopy hr_dei_shd.g_rec_type

590: -- ----------------------------------------------------------------------------
591: -- |---------------------------------< ins >----------------------------------|
592: -- ----------------------------------------------------------------------------
593: Procedure ins
594: (p_rec in out nocopy hr_dei_shd.g_rec_type
595: ) is
596: --
597: l_proc varchar2(72) := g_package||'ins';
598: --

Line 719: l_rec hr_dei_shd.g_rec_type;

715: ,p_document_extra_info_id out nocopy number
716: ,p_object_version_number out nocopy number
717: ) is
718: --
719: l_rec hr_dei_shd.g_rec_type;
720: l_proc varchar2(72) := g_package||'ins';
721: --
722: Begin
723: hr_utility.set_location('Entering:'||l_proc, 5);

Line 729: hr_dei_shd.convert_args

725: -- Call conversion function to turn arguments into the
726: -- p_rec structure.
727: --
728: l_rec :=
729: hr_dei_shd.convert_args
730: (null
731: ,p_person_id
732: ,p_document_type_id
733: ,p_document_number