41: -- Internal Row Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in hr_lot_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin
59: --
60: Exception
61: When hr_api.child_integrity_violated then
62: -- Child integrity has been violated
63: hr_lot_shd.constraint_error
64: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
65: When Others Then
66: Raise;
67: End delete_dml;
97: -- Internal Row Handler Use Only.
98: --
99: -- {End Of Comments}
100: -- ----------------------------------------------------------------------------
101: Procedure pre_delete(p_rec in hr_lot_shd.g_rec_type) is
102: --
103: l_proc varchar2(72) := g_package||'pre_delete';
104: --
105: Begin
139: -- Internal table Handler Use Only.
140: --
141: -- {End Of Comments}
142: -- ----------------------------------------------------------------------------
143: Procedure post_delete(p_rec in hr_lot_shd.g_rec_type) is
144: --
145: l_proc varchar2(72) := g_package||'post_delete';
146: --
147: Begin
155: hr_lot_rkd.after_delete
156: (
157: p_location_id =>p_rec.location_id
158: ,p_language =>p_rec.language
159: ,p_source_lang_o =>hr_lot_shd.g_old_rec.source_lang
160: ,p_location_code_o =>hr_lot_shd.g_old_rec.location_code
161: ,p_description_o =>hr_lot_shd.g_old_rec.description
162: );
163: --
156: (
157: p_location_id =>p_rec.location_id
158: ,p_language =>p_rec.language
159: ,p_source_lang_o =>hr_lot_shd.g_old_rec.source_lang
160: ,p_location_code_o =>hr_lot_shd.g_old_rec.location_code
161: ,p_description_o =>hr_lot_shd.g_old_rec.description
162: );
163: --
164: exception
157: p_location_id =>p_rec.location_id
158: ,p_language =>p_rec.language
159: ,p_source_lang_o =>hr_lot_shd.g_old_rec.source_lang
160: ,p_location_code_o =>hr_lot_shd.g_old_rec.location_code
161: ,p_description_o =>hr_lot_shd.g_old_rec.description
162: );
163: --
164: exception
165: --
181: -- |---------------------------------< del >----------------------------------|
182: -- ----------------------------------------------------------------------------
183: Procedure del
184: (
185: p_rec in hr_lot_shd.g_rec_type
186: ) is
187: --
188: l_proc varchar2(72) := g_package||'del';
189: --
191: hr_utility.set_location('Entering:'||l_proc, 5);
192: --
193: -- We must lock the row which we need to delete.
194: --
195: hr_lot_shd.lck
196: (
197: p_rec.location_id,
198: p_rec.language
199: );
223: p_location_id in number,
224: p_language in varchar2
225: ) is
226: --
227: l_rec hr_lot_shd.g_rec_type;
228: l_proc varchar2(72) := g_package||'del';
229: --
230: Begin
231: hr_utility.set_location('Entering:'||l_proc, 5);