72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy hr_ctx_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
163: Exception
164: When hr_api.check_integrity_violated Then
165: -- A check constraint has been violated
166: --
167: hr_ctx_shd.constraint_error
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When hr_api.parent_integrity_violated Then
170: -- Parent integrity has been violated
171: --
168: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169: When hr_api.parent_integrity_violated Then
170: -- Parent integrity has been violated
171: --
172: hr_ctx_shd.constraint_error
173: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
174: When hr_api.unique_integrity_violated Then
175: -- Unique integrity has been violated
176: --
173: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
174: When hr_api.unique_integrity_violated Then
175: -- Unique integrity has been violated
176: --
177: hr_ctx_shd.constraint_error
178: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
179: When Others Then
180: --
181: Raise;
218: --
219: -- {End Of Comments}
220: -- ----------------------------------------------------------------------------
221: Procedure pre_insert
222: (p_rec in out nocopy hr_ctx_shd.g_rec_type
223: ) is
224: --
225: Cursor C_Sel1 is select hr_ki_contexts_s.nextval from sys.dual;
226: --
305: --
306: -- {End Of Comments}
307: -- ----------------------------------------------------------------------------
308: Procedure post_insert
309: (p_rec in hr_ctx_shd.g_rec_type
310: ) is
311: --
312: l_proc varchar2(72) := g_package||'post_insert';
313: --
400: -- ----------------------------------------------------------------------------
401: -- |---------------------------------< ins >----------------------------------|
402: -- ----------------------------------------------------------------------------
403: Procedure ins
404: (p_rec in out nocopy hr_ctx_shd.g_rec_type
405: ) is
406: --
407: l_proc varchar2(72) := g_package||'ins';
408: --
476: ,p_context_id out nocopy number
477: ,p_object_version_number out nocopy number
478: ) is
479: --
480: l_rec hr_ctx_shd.g_rec_type;
481: l_proc varchar2(72) := g_package||'ins';
482: --
483: Begin
484: hr_utility.set_location('Entering:'||l_proc, 5);
486: -- Call conversion function to turn arguments into the
487: -- p_rec structure.
488: --
489: l_rec :=
490: hr_ctx_shd.convert_args
491: (null
492: ,p_view_name
493: ,p_param_1
494: ,p_param_2