82: -- Internal Row Handler Use Only.
83: --
84: -- {End Of Comments}
85: -- ----------------------------------------------------------------------------
86: Procedure delete_dml(p_rec in ben_xdd_shd.g_rec_type) is
87: --
88: l_proc varchar2(72) := g_package||'delete_dml';
89: --
90: Begin
89: --
90: Begin
91: hr_utility.set_location('Entering:'||l_proc, 5);
92: --
93: ben_xdd_shd.g_api_dml := true; -- Set the api dml status
94: --
95: -- Delete the ben_ext_data_elmt_decd row.
96: --
97: delete from ben_ext_data_elmt_decd
96: --
97: delete from ben_ext_data_elmt_decd
98: where ext_data_elmt_decd_id = p_rec.ext_data_elmt_decd_id;
99: --
100: ben_xdd_shd.g_api_dml := false; -- Unset the api dml status
101: --
102: hr_utility.set_location(' Leaving:'||l_proc, 10);
103: --
104: Exception
103: --
104: Exception
105: When hr_api.child_integrity_violated then
106: -- Child integrity has been violated
107: ben_xdd_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xdd_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xdd_shd.g_api_dml := false; -- Unset the api dml status
104: Exception
105: When hr_api.child_integrity_violated then
106: -- Child integrity has been violated
107: ben_xdd_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xdd_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xdd_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
107: ben_xdd_shd.g_api_dml := false; -- Unset the api dml status
108: ben_xdd_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_xdd_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
113: End delete_dml;
114: --
115: -- ----------------------------------------------------------------------------
143: -- Internal Row Handler Use Only.
144: --
145: -- {End Of Comments}
146: -- ----------------------------------------------------------------------------
147: Procedure pre_delete(p_rec in ben_xdd_shd.g_rec_type) is
148: --
149: l_proc varchar2(72) := g_package||'pre_delete';
150: --
151: Begin
185: -- Internal table Handler Use Only.
186: --
187: -- {End Of Comments}
188: -- ----------------------------------------------------------------------------
189: Procedure post_delete(p_rec in ben_xdd_shd.g_rec_type) is
190: --
191: l_proc varchar2(72) := g_package||'post_delete';
192: --
193: Begin
205: --
206: ben_xdd_rkd.after_delete
207: (
208: p_ext_data_elmt_decd_id =>p_rec.ext_data_elmt_decd_id
209: ,p_val_o =>ben_xdd_shd.g_old_rec.val
210: ,p_dcd_val_o =>ben_xdd_shd.g_old_rec.dcd_val
211: ,p_chg_evt_source_o =>ben_xdd_shd.g_old_rec.chg_evt_source
212: ,p_ext_data_elmt_id_o =>ben_xdd_shd.g_old_rec.ext_data_elmt_id
213: ,p_business_group_id_o =>ben_xdd_shd.g_old_rec.business_group_id
206: ben_xdd_rkd.after_delete
207: (
208: p_ext_data_elmt_decd_id =>p_rec.ext_data_elmt_decd_id
209: ,p_val_o =>ben_xdd_shd.g_old_rec.val
210: ,p_dcd_val_o =>ben_xdd_shd.g_old_rec.dcd_val
211: ,p_chg_evt_source_o =>ben_xdd_shd.g_old_rec.chg_evt_source
212: ,p_ext_data_elmt_id_o =>ben_xdd_shd.g_old_rec.ext_data_elmt_id
213: ,p_business_group_id_o =>ben_xdd_shd.g_old_rec.business_group_id
214: ,p_legislation_code_o =>ben_xdd_shd.g_old_rec.legislation_code
207: (
208: p_ext_data_elmt_decd_id =>p_rec.ext_data_elmt_decd_id
209: ,p_val_o =>ben_xdd_shd.g_old_rec.val
210: ,p_dcd_val_o =>ben_xdd_shd.g_old_rec.dcd_val
211: ,p_chg_evt_source_o =>ben_xdd_shd.g_old_rec.chg_evt_source
212: ,p_ext_data_elmt_id_o =>ben_xdd_shd.g_old_rec.ext_data_elmt_id
213: ,p_business_group_id_o =>ben_xdd_shd.g_old_rec.business_group_id
214: ,p_legislation_code_o =>ben_xdd_shd.g_old_rec.legislation_code
215: ,p_object_version_number_o =>ben_xdd_shd.g_old_rec.object_version_number
208: p_ext_data_elmt_decd_id =>p_rec.ext_data_elmt_decd_id
209: ,p_val_o =>ben_xdd_shd.g_old_rec.val
210: ,p_dcd_val_o =>ben_xdd_shd.g_old_rec.dcd_val
211: ,p_chg_evt_source_o =>ben_xdd_shd.g_old_rec.chg_evt_source
212: ,p_ext_data_elmt_id_o =>ben_xdd_shd.g_old_rec.ext_data_elmt_id
213: ,p_business_group_id_o =>ben_xdd_shd.g_old_rec.business_group_id
214: ,p_legislation_code_o =>ben_xdd_shd.g_old_rec.legislation_code
215: ,p_object_version_number_o =>ben_xdd_shd.g_old_rec.object_version_number
216: );
209: ,p_val_o =>ben_xdd_shd.g_old_rec.val
210: ,p_dcd_val_o =>ben_xdd_shd.g_old_rec.dcd_val
211: ,p_chg_evt_source_o =>ben_xdd_shd.g_old_rec.chg_evt_source
212: ,p_ext_data_elmt_id_o =>ben_xdd_shd.g_old_rec.ext_data_elmt_id
213: ,p_business_group_id_o =>ben_xdd_shd.g_old_rec.business_group_id
214: ,p_legislation_code_o =>ben_xdd_shd.g_old_rec.legislation_code
215: ,p_object_version_number_o =>ben_xdd_shd.g_old_rec.object_version_number
216: );
217: --
210: ,p_dcd_val_o =>ben_xdd_shd.g_old_rec.dcd_val
211: ,p_chg_evt_source_o =>ben_xdd_shd.g_old_rec.chg_evt_source
212: ,p_ext_data_elmt_id_o =>ben_xdd_shd.g_old_rec.ext_data_elmt_id
213: ,p_business_group_id_o =>ben_xdd_shd.g_old_rec.business_group_id
214: ,p_legislation_code_o =>ben_xdd_shd.g_old_rec.legislation_code
215: ,p_object_version_number_o =>ben_xdd_shd.g_old_rec.object_version_number
216: );
217: --
218: exception
211: ,p_chg_evt_source_o =>ben_xdd_shd.g_old_rec.chg_evt_source
212: ,p_ext_data_elmt_id_o =>ben_xdd_shd.g_old_rec.ext_data_elmt_id
213: ,p_business_group_id_o =>ben_xdd_shd.g_old_rec.business_group_id
214: ,p_legislation_code_o =>ben_xdd_shd.g_old_rec.legislation_code
215: ,p_object_version_number_o =>ben_xdd_shd.g_old_rec.object_version_number
216: );
217: --
218: exception
219: --
235: -- |---------------------------------< del >----------------------------------|
236: -- ----------------------------------------------------------------------------
237: Procedure del
238: (
239: p_rec in ben_xdd_shd.g_rec_type
240: ) is
241: --
242: l_proc varchar2(72) := g_package||'del';
243: --
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: -- We must lock the row which we need to delete.
248: --
249: ben_xdd_shd.lck
250: (
251: p_rec.ext_data_elmt_decd_id,
252: p_rec.object_version_number
253: );
278: p_legislation_code in varchar2 default null,
279: p_object_version_number in number
280: ) is
281: --
282: l_rec ben_xdd_shd.g_rec_type;
283: l_proc varchar2(72) := g_package||'del';
284: --
285: Begin
286: hr_utility.set_location('Entering:'||l_proc, 5);