120: --
121: -- {End Of Comments}
122: -- ----------------------------------------------------------------------------
123: Procedure insert_dml
124: (p_rec in out nocopy pqh_rmn_shd.g_rec_type
125: ) is
126: --
127: l_proc varchar2(72) := g_package||'insert_dml';
128: --
167: Exception
168: When hr_api.check_integrity_violated Then
169: -- A check constraint has been violated
170: --
171: pqh_rmn_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: --
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: pqh_rmn_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: --
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: pqh_rmn_shd.constraint_error
182: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
183: When Others Then
184: --
185: Raise;
222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure pre_insert
226: (p_rec in out nocopy pqh_rmn_shd.g_rec_type
227: ) is
228: --
229: Cursor C_Sel1 is select pqh_rate_matrix_nodes_s.nextval from sys.dual;
230: --
309: --
310: -- {End Of Comments}
311: -- ----------------------------------------------------------------------------
312: Procedure post_insert
313: (p_rec in pqh_rmn_shd.g_rec_type
314: ) is
315: --
316: l_proc varchar2(72) := g_package||'post_insert';
317: --
366: -- ----------------------------------------------------------------------------
367: -- |---------------------------------< ins >----------------------------------|
368: -- ----------------------------------------------------------------------------
369: Procedure ins
370: (p_rec in out nocopy pqh_rmn_shd.g_rec_type
371: ) is
372: --
373: l_proc varchar2(72) := g_package||'ins';
374: --
420: ,p_rate_matrix_node_id out nocopy number
421: ,p_object_version_number out nocopy number
422: ) is
423: --
424: l_rec pqh_rmn_shd.g_rec_type;
425: l_proc varchar2(72) := g_package||'ins';
426: --
427: Begin
428: hr_utility.set_location('Entering:'||l_proc, 5);
430: -- Call conversion function to turn arguments into the
431: -- p_rec structure.
432: --
433: l_rec :=
434: pqh_rmn_shd.convert_args
435: (null
436: ,p_short_code
437: ,p_pl_id
438: ,p_level_number