APPS.PER_REQ_INS dependencies on PER_REQ_SHD

Line 76: (p_rec in out nocopy per_req_shd.g_rec_type

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

Line 169: per_req_shd.constraint_error

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

Line 174: per_req_shd.constraint_error

170: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
171: When hr_api.parent_integrity_violated Then
172: -- Parent integrity has been violated
173: --
174: per_req_shd.constraint_error
175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: --

Line 179: per_req_shd.constraint_error

175: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
176: When hr_api.unique_integrity_violated Then
177: -- Unique integrity has been violated
178: --
179: per_req_shd.constraint_error
180: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
181: When Others Then
182: --
183: Raise;

Line 224: (p_rec in out nocopy per_req_shd.g_rec_type

220: --
221: -- {End Of Comments}
222: -- ----------------------------------------------------------------------------
223: Procedure pre_insert
224: (p_rec in out nocopy per_req_shd.g_rec_type
225: ) is
226: --
227: Cursor C_Sel1 is select per_requisitions_s.nextval from sys.dual;
228: --

Line 311: (p_rec in per_req_shd.g_rec_type

307: --
308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure post_insert
311: (p_rec in per_req_shd.g_rec_type
312: ) is
313: --
314: l_proc varchar2(72) := g_package||'post_insert';
315: --

Line 408: (p_rec in out nocopy per_req_shd.g_rec_type

404: -- ----------------------------------------------------------------------------
405: -- |---------------------------------< ins >----------------------------------|
406: -- ----------------------------------------------------------------------------
407: Procedure ins
408: (p_rec in out nocopy per_req_shd.g_rec_type
409: ) is
410: --
411: l_proc varchar2(72) := g_package||'ins';
412: --

Line 479: l_rec per_req_shd.g_rec_type;

475: ,p_requisition_id out nocopy number
476: ,p_object_version_number out nocopy number
477: ) is
478: --
479: l_rec per_req_shd.g_rec_type;
480: l_proc varchar2(72) := g_package||'ins';
481: --
482: Begin
483: hr_utility.set_location('Entering:'||l_proc, 5);

Line 489: per_req_shd.convert_args

485: -- Call conversion function to turn arguments into the
486: -- p_rec structure.
487: --
488: l_rec :=
489: per_req_shd.convert_args
490: (null
491: ,p_business_group_id
492: ,p_person_id
493: ,p_date_from