50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy pay_evg_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
91: Exception
92: When hr_api.check_integrity_violated Then
93: -- A check constraint has been violated
94: --
95: pay_evg_shd.constraint_error
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: --
96: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
97: When hr_api.parent_integrity_violated Then
98: -- Parent integrity has been violated
99: --
100: pay_evg_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: --
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When hr_api.unique_integrity_violated Then
103: -- Unique integrity has been violated
104: --
105: pay_evg_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When Others Then
108: --
109: Raise;
146: --
147: -- {End Of Comments}
148: -- ----------------------------------------------------------------------------
149: Procedure pre_insert
150: (p_rec in out nocopy pay_evg_shd.g_rec_type
151: ) is
152: --
153: l_proc varchar2(72) := g_package||'pre_insert';
154: --
200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure post_insert
203: (p_effective_date in date
204: ,p_rec in pay_evg_shd.g_rec_type
205: ) is
206: --
207: l_proc varchar2(72) := g_package||'post_insert';
208: --
247: -- |---------------------------------< ins >----------------------------------|
248: -- ----------------------------------------------------------------------------
249: Procedure ins
250: (p_effective_date in date
251: ,p_rec in out nocopy pay_evg_shd.g_rec_type
252: ) is
253: --
254: l_proc varchar2(72) := g_package||'ins';
255: --
295: ,p_object_version_number out nocopy number
296: ,p_time_definition_id in number default null
297: ) is
298: --
299: l_rec pay_evg_shd.g_rec_type;
300: l_proc varchar2(72) := g_package||'ins';
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
305: -- Call conversion function to turn arguments into the
306: -- p_rec structure.
307: --
308: l_rec :=
309: pay_evg_shd.convert_args
310: (null
311: ,p_event_group_name
312: ,p_event_group_type
313: ,p_proration_type