72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy ben_cso_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
211: Exception
212: When hr_api.check_integrity_violated Then
213: -- A check constraint has been violated
214: --
215: ben_cso_shd.constraint_error
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When hr_api.parent_integrity_violated Then
218: -- Parent integrity has been violated
219: --
216: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
217: When hr_api.parent_integrity_violated Then
218: -- Parent integrity has been violated
219: --
220: ben_cso_shd.constraint_error
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: --
221: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
222: When hr_api.unique_integrity_violated Then
223: -- Unique integrity has been violated
224: --
225: ben_cso_shd.constraint_error
226: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
227: When Others Then
228: --
229: Raise;
266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure pre_insert
270: (p_rec in out nocopy ben_cso_shd.g_rec_type
271: ) is
272: --
273: Cursor C_Sel1 is select ben_cwb_stock_optn_dtls_s.nextval from sys.dual;
274: --
354: -- {End Of Comments}
355: -- ----------------------------------------------------------------------------
356: Procedure post_insert
357: (p_effective_date in date
358: ,p_rec in ben_cso_shd.g_rec_type
359: ) is
360: --
361: l_proc varchar2(72) := g_package||'post_insert';
362: --
499: -- |---------------------------------< ins >----------------------------------|
500: -- ----------------------------------------------------------------------------
501: Procedure ins
502: (p_effective_date in date
503: ,p_rec in out nocopy ben_cso_shd.g_rec_type
504: ) is
505: --
506: l_proc varchar2(72) := g_package||'ins';
507: --
602: ,p_cwb_stock_optn_dtls_id out nocopy number
603: ,p_object_version_number out nocopy number
604: ) is
605: --
606: l_rec ben_cso_shd.g_rec_type;
607: l_proc varchar2(72) := g_package||'ins';
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);
612: -- Call conversion function to turn arguments into the
613: -- p_rec structure.
614: --
615: l_rec :=
616: ben_cso_shd.convert_args
617: (null
618: ,p_grant_id
619: ,p_grant_number
620: ,p_grant_name