APPS.PQH_REI_INS dependencies on PQH_REI_SHD

Line 76: (p_rec in out nocopy pqh_rei_shd.g_rec_type

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

Line 241: pqh_rei_shd.constraint_error

237: Exception
238: When hr_api.check_integrity_violated Then
239: -- A check constraint has been violated
240: --
241: pqh_rei_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.parent_integrity_violated Then
244: -- Parent integrity has been violated
245: --

Line 246: pqh_rei_shd.constraint_error

242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When hr_api.parent_integrity_violated Then
244: -- Parent integrity has been violated
245: --
246: pqh_rei_shd.constraint_error
247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --

Line 251: pqh_rei_shd.constraint_error

247: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
248: When hr_api.unique_integrity_violated Then
249: -- Unique integrity has been violated
250: --
251: pqh_rei_shd.constraint_error
252: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
253: When Others Then
254: --
255: Raise;

Line 297: (p_rec in out nocopy pqh_rei_shd.g_rec_type

293: --
294: -- {End Of Comments}
295: -- ----------------------------------------------------------------------------
296: Procedure pre_insert
297: (p_rec in out nocopy pqh_rei_shd.g_rec_type
298: ) is
299: --
300: Cursor C_Sel1 is select pqh_role_extra_info_s.nextval from sys.dual;
301: --

Line 384: (p_rec in pqh_rei_shd.g_rec_type

380: --
381: -- {End Of Comments}
382: -- ----------------------------------------------------------------------------
383: Procedure post_insert
384: (p_rec in pqh_rei_shd.g_rec_type
385: ) is
386: --
387: l_proc varchar2(72) := g_package||'post_insert';
388: --

Line 484: (p_rec in out nocopy pqh_rei_shd.g_rec_type

480: -- |---------------------------------< ins >----------------------------------|
481: -- ----------------------------------------------------------------------------
482:
483: Procedure ins
484: (p_rec in out nocopy pqh_rei_shd.g_rec_type
485: ,p_validate in boolean
486: ) is
487: --
488: l_proc varchar2(72) := g_package||'ins';

Line 622: l_rec pqh_rei_shd.g_rec_type;

618: ,p_object_version_number out nocopy number
619: ,p_validate in boolean
620: ) is
621: --
622: l_rec pqh_rei_shd.g_rec_type;
623: l_proc varchar2(72) := g_package||'ins';
624: --
625: Begin
626: hr_utility.set_location('Entering:'||l_proc, 5);

Line 632: pqh_rei_shd.convert_args

628: -- Call conversion function to turn arguments into the
629: -- p_rec structure.
630: --
631: l_rec :=
632: pqh_rei_shd.convert_args
633: (null
634: ,p_role_id
635: ,p_information_type
636: ,p_request_id