DBA Data[Home] [Help]

APPS.PER_SOL_INS dependencies on PER_SOL_SHD

Line 76: (p_rec in out nocopy per_sol_shd.g_rec_type

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

Line 135: per_sol_shd.constraint_error

131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
134: --
135: per_sol_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: --

Line 140: per_sol_shd.constraint_error

136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When hr_api.parent_integrity_violated Then
138: -- Parent integrity has been violated
139: --
140: per_sol_shd.constraint_error
141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: --

Line 145: per_sol_shd.constraint_error

141: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
142: When hr_api.unique_integrity_violated Then
143: -- Unique integrity has been violated
144: --
145: per_sol_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When Others Then
148: --
149: Raise;

Line 190: (p_rec in out nocopy per_sol_shd.g_rec_type

186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure pre_insert
190: (p_rec in out nocopy per_sol_shd.g_rec_type
191: ) is
192: --
193: Cursor C_Sel1 is select per_solutions_s.nextval from sys.dual;
194: --

Line 278: ,p_rec in per_sol_shd.g_rec_type

274: -- {End Of Comments}
275: -- ----------------------------------------------------------------------------
276: Procedure post_insert
277: (p_effective_date in date
278: ,p_rec in per_sol_shd.g_rec_type
279: ) is
280: --
281: l_proc varchar2(72) := g_package||'post_insert';
282: --

Line 327: ,p_rec in out nocopy per_sol_shd.g_rec_type

323: -- |---------------------------------< ins >----------------------------------|
324: -- ----------------------------------------------------------------------------
325: Procedure ins
326: (p_effective_date in date
327: ,p_rec in out nocopy per_sol_shd.g_rec_type
328: ) is
329: --
330: l_proc varchar2(72) := g_package||'ins';
331: --

Line 382: l_rec per_sol_shd.g_rec_type;

378: ,p_solution_id out nocopy number
379: ,p_object_version_number out nocopy number
380: ) is
381: --
382: l_rec per_sol_shd.g_rec_type;
383: l_proc varchar2(72) := g_package||'ins';
384: --
385: Begin
386: hr_utility.set_location('Entering:'||l_proc, 5);

Line 392: per_sol_shd.convert_args

388: -- Call conversion function to turn arguments into the
389: -- p_rec structure.
390: --
391: l_rec :=
392: per_sol_shd.convert_args
393: (p_solution_name
394: ,null
395: ,p_description
396: ,p_link_to_full_description