APPS.PSP_PEE_INS dependencies on PSP_PEE_SHD

Line 76: (p_rec in out nocopy psp_pee_shd.g_rec_type

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

Line 165: psp_pee_shd.constraint_error

161: Exception
162: When hr_api.check_integrity_violated Then
163: -- A check constraint has been violated
164: --
165: psp_pee_shd.constraint_error
166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.parent_integrity_violated Then
168: -- Parent integrity has been violated
169: --

Line 170: psp_pee_shd.constraint_error

166: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
167: When hr_api.parent_integrity_violated Then
168: -- Parent integrity has been violated
169: --
170: psp_pee_shd.constraint_error
171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.unique_integrity_violated Then
173: -- Unique integrity has been violated
174: --

Line 175: psp_pee_shd.constraint_error

171: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
172: When hr_api.unique_integrity_violated Then
173: -- Unique integrity has been violated
174: --
175: psp_pee_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When Others Then
178: --
179: Raise;

Line 220: (p_rec in out nocopy psp_pee_shd.g_rec_type

216: --
217: -- {End Of Comments}
218: -- ----------------------------------------------------------------------------
219: Procedure pre_insert
220: (p_rec in out nocopy psp_pee_shd.g_rec_type
221: ) is
222: --
223: Cursor C_Sel1 is select psp_external_effort_lines_s.nextval from sys.dual;
224: --

Line 307: (p_rec in psp_pee_shd.g_rec_type

303: --
304: -- {End Of Comments}
305: -- ----------------------------------------------------------------------------
306: Procedure post_insert
307: (p_rec in psp_pee_shd.g_rec_type
308: ) is
309: --
310: l_proc varchar2(72) := g_package||'post_insert';
311: --

Line 400: (p_rec in out nocopy psp_pee_shd.g_rec_type

396: -- ----------------------------------------------------------------------------
397: -- |---------------------------------< ins >----------------------------------|
398: -- ----------------------------------------------------------------------------
399: Procedure ins
400: (p_rec in out nocopy psp_pee_shd.g_rec_type
401: ) is
402: --
403: l_proc varchar2(72) := g_package||'ins';
404: --

Line 475: l_rec psp_pee_shd.g_rec_type;

471: ,p_external_effort_line_id out nocopy number
472: ,p_object_version_number out nocopy number
473: ) is
474: --
475: l_rec psp_pee_shd.g_rec_type;
476: l_proc varchar2(72) := g_package||'ins';
477: --
478: Begin
479: hr_utility.set_location('Entering:'||l_proc, 5);

Line 485: psp_pee_shd.convert_args

481: -- Call conversion function to turn arguments into the
482: -- p_rec structure.
483: --
484: l_rec :=
485: psp_pee_shd.convert_args
486: (null
487: ,p_batch_name
488: ,null
489: ,p_distribution_date