50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy per_cei_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_created_by per_cagr_entitlement_items.created_by%TYPE;
138: Exception
139: When hr_api.check_integrity_violated Then
140: -- A check constraint has been violated
141: --
142: per_cei_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: --
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.parent_integrity_violated Then
145: -- Parent integrity has been violated
146: --
147: per_cei_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: --
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: --
152: per_cei_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: --
156: Raise;
193: --
194: -- {End Of Comments}
195: -- ----------------------------------------------------------------------------
196: Procedure pre_insert
197: (p_rec in out nocopy per_cei_shd.g_rec_type
198: ) is
199: --
200: l_proc varchar2(72) := g_package||'pre_insert';
201: --
248: -- {End Of Comments}
249: -- ----------------------------------------------------------------------------
250: Procedure post_insert
251: (p_effective_date in date
252: ,p_rec in per_cei_shd.g_rec_type
253: ) is
254: --
255: l_proc varchar2(72) := g_package||'post_insert';
256: --
301: -- |---------------------------------< ins >----------------------------------|
302: -- ----------------------------------------------------------------------------
303: Procedure ins
304: (p_effective_date in date
305: ,p_rec in out nocopy per_cei_shd.g_rec_type
306: ) is
307: --
308: l_proc varchar2(72) := g_package||'ins';
309: --
362: ,p_object_version_number out nocopy number
363:
364: ) is
365: --
366: l_rec per_cei_shd.g_rec_type;
367: l_proc varchar2(72) := g_package||'ins';
368: --
369: Begin
370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: -- Call conversion function to turn arguments into the
373: -- p_rec structure.
374: --
375: l_rec := per_cei_shd.convert_args
376: (NULL
377: ,p_item_name
378: ,p_element_type_id
379: ,p_input_value_id