APPS.PQH_PSU_INS dependencies on PQH_PSU_SHD

Line 76: (p_rec in out nocopy pqh_psu_shd.g_rec_type

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

Line 195: pqh_psu_shd.constraint_error

191: Exception
192: When hr_api.check_integrity_violated Then
193: -- A check constraint has been violated
194: --
195: pqh_psu_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.parent_integrity_violated Then
198: -- Parent integrity has been violated
199: --

Line 200: pqh_psu_shd.constraint_error

196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.parent_integrity_violated Then
198: -- Parent integrity has been violated
199: --
200: pqh_psu_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: --

Line 205: pqh_psu_shd.constraint_error

201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When hr_api.unique_integrity_violated Then
203: -- Unique integrity has been violated
204: --
205: pqh_psu_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When Others Then
208: --
209: Raise;

Line 250: (p_rec in out nocopy pqh_psu_shd.g_rec_type

246: --
247: -- {End Of Comments}
248: -- ----------------------------------------------------------------------------
249: Procedure pre_insert
250: (p_rec in out nocopy pqh_psu_shd.g_rec_type
251: ) is
252: --
253: Cursor C_Sel1 is select pqh_fr_emp_stat_situations_s.nextval from sys.dual;
254: --

Line 338: ,p_rec in pqh_psu_shd.g_rec_type

334: -- {End Of Comments}
335: -- ----------------------------------------------------------------------------
336: Procedure post_insert
337: (p_effective_date in date
338: ,p_rec in pqh_psu_shd.g_rec_type
339: ) is
340: --
341: l_proc varchar2(72) := g_package||'post_insert';
342: --

Line 463: ,p_rec in out nocopy pqh_psu_shd.g_rec_type

459: -- |---------------------------------< ins >----------------------------------|
460: -- ----------------------------------------------------------------------------
461: Procedure ins
462: (p_effective_date in date
463: ,p_rec in out nocopy pqh_psu_shd.g_rec_type
464: ) is
465: --
466: l_proc varchar2(72) := g_package||'ins';
467: --

Line 556: l_rec pqh_psu_shd.g_rec_type;

552: ,p_emp_stat_situation_id out nocopy number
553: ,p_object_version_number out nocopy number
554: ) is
555: --
556: l_rec pqh_psu_shd.g_rec_type;
557: l_proc varchar2(72) := g_package||'ins';
558: --
559: Begin
560: hr_utility.set_location('Entering:'||l_proc, 5);

Line 566: pqh_psu_shd.convert_args

562: -- Call conversion function to turn arguments into the
563: -- p_rec structure.
564: --
565: l_rec :=
566: pqh_psu_shd.convert_args
567: (null
568: ,p_statutory_situation_id
569: ,p_person_id
570: ,p_provisional_start_date