50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out pay_ppe_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: --
97: pay_ppe_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: --
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: --
102: pay_ppe_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: --
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: --
107: pay_ppe_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: --
111: Raise;
148: --
149: -- {End Of Comments}
150: -- ----------------------------------------------------------------------------
151: Procedure pre_insert
152: (p_rec in out pay_ppe_shd.g_rec_type
153: ) is
154: --
155: l_proc varchar2(72) := g_package||'pre_insert';
156: --
201: --
202: -- {End Of Comments}
203: -- ----------------------------------------------------------------------------
204: Procedure post_insert
205: (p_rec in pay_ppe_shd.g_rec_type
206: ) is
207: --
208: l_proc varchar2(72) := g_package||'post_insert';
209: --
215: -- ----------------------------------------------------------------------------
216: -- |---------------------------------< ins >----------------------------------|
217: -- ----------------------------------------------------------------------------
218: Procedure ins
219: (p_rec in out pay_ppe_shd.g_rec_type
220: ) is
221: --
222: l_proc varchar2(72) := g_package||'ins';
223: --
259: ,p_process_event_id out number
260: ,p_object_version_number out number
261: ) is
262: --
263: l_rec pay_ppe_shd.g_rec_type;
264: l_proc varchar2(72) := g_package||'ins';
265: --
266: Begin
267: hr_utility.set_location('Entering:'||l_proc, 5);
269: -- Call conversion function to turn arguments into the
270: -- p_rec structure.
271: --
272: l_rec :=
273: pay_ppe_shd.convert_args
274: (null
275: ,p_assignment_id
276: ,p_effective_date
277: ,p_change_type