72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy pqh_cgn_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: pqh_cgn_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: --
138: pqh_cgn_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: --
143: pqh_cgn_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: --
147: Raise;
184: --
185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure pre_insert
188: (p_rec in out nocopy pqh_cgn_shd.g_rec_type
189: ) is
190: --
191: Cursor C_Sel1 is select pqh_de_case_groups_s.nextval from sys.dual;
192: --
272: -- {End Of Comments}
273: -- ----------------------------------------------------------------------------
274: Procedure post_insert
275: (p_effective_date in date
276: ,p_rec in pqh_cgn_shd.g_rec_type
277: ) is
278: --
279: l_proc varchar2(72) := g_package||'post_insert';
280: --
335: -- |---------------------------------< ins >----------------------------------|
336: -- ----------------------------------------------------------------------------
337: Procedure ins
338: (p_effective_date in date
339: ,p_rec in out nocopy pqh_cgn_shd.g_rec_type
340: ) is
341: --
342: l_proc varchar2(72) := g_package||'ins';
343: --
397: ,p_case_group_id out nocopy number
398: ,p_object_version_number out nocopy number
399: ) is
400: --
401: l_rec pqh_cgn_shd.g_rec_type;
402: l_proc varchar2(72) := g_package||'ins';
403: --
404: Begin
405: hr_utility.set_location('Entering:'||l_proc, 5);
407: -- Call conversion function to turn arguments into the
408: -- p_rec structure.
409: --
410: l_rec :=
411: pqh_cgn_shd.convert_args
412: (null
413: ,p_case_group_number
414: ,p_description
415: ,p_advanced_pay_grade