APPS.PSP_ERA_INS dependencies on PSP_ERA_SHD

Line 76: (p_rec in out nocopy psp_era_shd.g_rec_type

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

Line 205: psp_era_shd.constraint_error

201: Exception
202: When hr_api.check_integrity_violated Then
203: -- A check constraint has been violated
204: --
205: psp_era_shd.constraint_error
206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.parent_integrity_violated Then
208: -- Parent integrity has been violated
209: --

Line 210: psp_era_shd.constraint_error

206: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
207: When hr_api.parent_integrity_violated Then
208: -- Parent integrity has been violated
209: --
210: psp_era_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212: When hr_api.unique_integrity_violated Then
213: -- Unique integrity has been violated
214: --

Line 215: psp_era_shd.constraint_error

211: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212: When hr_api.unique_integrity_violated Then
213: -- Unique integrity has been violated
214: --
215: psp_era_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When Others Then
218: --
219: Raise;

Line 260: (p_rec in out nocopy psp_era_shd.g_rec_type

256: --
257: -- {End Of Comments}
258: -- ----------------------------------------------------------------------------
259: Procedure pre_insert
260: (p_rec in out nocopy psp_era_shd.g_rec_type
261: ) is
262: --
263: Cursor C_Sel1 is select psp_eff_report_approvals_s.nextval from sys.dual;
264: --

Line 347: (p_rec in psp_era_shd.g_rec_type

343: --
344: -- {End Of Comments}
345: -- ----------------------------------------------------------------------------
346: Procedure post_insert
347: (p_rec in psp_era_shd.g_rec_type
348: ) is
349: --
350: l_proc varchar2(72) := g_package||'post_insert';
351: --

Line 480: (p_rec in out nocopy psp_era_shd.g_rec_type

476: -- ----------------------------------------------------------------------------
477: -- |---------------------------------< ins >----------------------------------|
478: -- ----------------------------------------------------------------------------
479: Procedure ins
480: (p_rec in out nocopy psp_era_shd.g_rec_type
481: ) is
482: --
483: l_proc varchar2(72) := g_package||'ins';
484: --

Line 575: l_rec psp_era_shd.g_rec_type;

571: ,p_effort_report_approval_id out nocopy number
572: ,p_object_version_number out nocopy number
573: ) is
574: --
575: l_rec psp_era_shd.g_rec_type;
576: l_proc varchar2(72) := g_package||'ins';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);

Line 585: psp_era_shd.convert_args

581: -- Call conversion function to turn arguments into the
582: -- p_rec structure.
583: --
584: l_rec :=
585: psp_era_shd.convert_args
586: (null
587: ,p_effort_report_detail_id
588: ,p_wf_role_name
589: ,p_wf_orig_system_id