DBA Data[Home] [Help]

APPS.PER_PSH_INS dependencies on PER_PSH_SHD

Line 76: (p_rec in out nocopy per_psh_shd.g_rec_type

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

Line 171: per_psh_shd.constraint_error

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

Line 176: per_psh_shd.constraint_error

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

Line 181: per_psh_shd.constraint_error

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

Line 226: (p_rec in out nocopy per_psh_shd.g_rec_type

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

Line 313: (p_rec in per_psh_shd.g_rec_type

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

Line 412: (p_rec in out nocopy per_psh_shd.g_rec_type

408: -- ----------------------------------------------------------------------------
409: -- |---------------------------------< ins >----------------------------------|
410: -- ----------------------------------------------------------------------------
411: Procedure ins
412: (p_rec in out nocopy per_psh_shd.g_rec_type
413: ) is
414: --
415: l_proc varchar2(72) := g_package||'ins';
416: --

Line 490: l_rec per_psh_shd.g_rec_type;

486: ,p_sharing_instance_id out nocopy number
487: ,p_object_version_number out nocopy number
488: ) is
489: --
490: l_rec per_psh_shd.g_rec_type;
491: l_proc varchar2(72) := g_package||'ins';
492: --
493: Begin
494: hr_utility.set_location('Entering:'||l_proc, 5);

Line 500: per_psh_shd.convert_args

496: -- Call conversion function to turn arguments into the
497: -- p_rec structure.
498: --
499: l_rec :=
500: per_psh_shd.convert_args
501: (null
502: ,null
503: ,p_scorecard_id
504: ,p_person_id