45: -- Internal Row Handler Use Only.
46: --
47: -- {End Of Comments}
48: -- ----------------------------------------------------------------------------
49: Procedure insert_dml(p_rec in out nocopy pqh_cec_shd.g_rec_type) is
50: --
51: l_proc varchar2(72) := g_package||'insert_dml';
52: --
53: Begin
78: hr_utility.set_location(' Leaving:'||l_proc, 10);
79: Exception
80: When hr_api.check_integrity_violated Then
81: -- A check constraint has been violated
82: pqh_cec_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When hr_api.parent_integrity_violated Then
85: -- Parent integrity has been violated
86: pqh_cec_shd.constraint_error
82: pqh_cec_shd.constraint_error
83: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
84: When hr_api.parent_integrity_violated Then
85: -- Parent integrity has been violated
86: pqh_cec_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.unique_integrity_violated Then
89: -- Unique integrity has been violated
90: pqh_cec_shd.constraint_error
86: pqh_cec_shd.constraint_error
87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.unique_integrity_violated Then
89: -- Unique integrity has been violated
90: pqh_cec_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When Others Then
93: Raise;
94: End insert_dml;
129: -- Internal Row Handler Use Only.
130: --
131: -- {End Of Comments}
132: -- ----------------------------------------------------------------------------
133: Procedure pre_insert(p_rec in out nocopy pqh_cec_shd.g_rec_type) is
134: --
135: l_proc varchar2(72) := g_package||'pre_insert';
136: --
137: -- Cursor C_Sel1 is select pqh_copy_entity_contexts_s.nextval from sys.dual;
182: -- Internal Row Handler Use Only.
183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure post_insert(p_rec in pqh_cec_shd.g_rec_type) is
187: --
188: l_proc varchar2(72) := g_package||'post_insert';
189: --
190: Begin
225: -- |---------------------------------< ins >----------------------------------|
226: -- ----------------------------------------------------------------------------
227: Procedure ins
228: (
229: p_rec in out nocopy pqh_cec_shd.g_rec_type
230: ) is
231: --
232: l_proc varchar2(72) := g_package||'ins';
233: --
263: p_transaction_short_name in varchar2 default null,
264: p_object_version_number out nocopy number
265: ) is
266: --
267: l_rec pqh_cec_shd.g_rec_type;
268: l_proc varchar2(72) := g_package||'ins';
269: --
270: Begin
271: hr_utility.set_location('Entering:'||l_proc, 5);
273: -- Call conversion function to turn arguments into the
274: -- p_rec structure.
275: --
276: l_rec :=
277: pqh_cec_shd.convert_args
278: (
279: p_context,
280: p_application_short_name,
281: p_legislation_code,