48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in hr_twn_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --
93: Exception
94: When hr_api.child_integrity_violated then
95: -- Child integrity has been violated
96: --
97: hr_twn_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --
101: Raise;
132: -- Internal Row Handler Use Only.
133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_delete(p_rec in hr_twn_shd.g_rec_type) is
137: --
138: l_proc varchar2(72) := g_package||'pre_delete';
139: --
140: Begin
174: -- Internal Row Handler Use Only.
175: --
176: -- {End Of Comments}
177: -- -----------------------------------------------------------------------------
178: Procedure post_delete(p_rec in hr_twn_shd.g_rec_type) is
179: --
180: l_proc varchar2(72) := g_package||'post_delete';
181: --
182: Begin
186: hr_twn_rkd.after_delete
187: (p_template_window_id
188: => p_rec.template_window_id
189: ,p_object_version_number_o
190: => hr_twn_shd.g_old_rec.object_version_number
191: ,p_form_template_id_o
192: => hr_twn_shd.g_old_rec.form_template_id
193: ,p_form_window_id_o
194: => hr_twn_shd.g_old_rec.form_window_id
188: => p_rec.template_window_id
189: ,p_object_version_number_o
190: => hr_twn_shd.g_old_rec.object_version_number
191: ,p_form_template_id_o
192: => hr_twn_shd.g_old_rec.form_template_id
193: ,p_form_window_id_o
194: => hr_twn_shd.g_old_rec.form_window_id
195: );
196: --
190: => hr_twn_shd.g_old_rec.object_version_number
191: ,p_form_template_id_o
192: => hr_twn_shd.g_old_rec.form_template_id
193: ,p_form_window_id_o
194: => hr_twn_shd.g_old_rec.form_window_id
195: );
196: --
197: exception
198: --
210: -- ----------------------------------------------------------------------------
211: -- |---------------------------------< del >----------------------------------|
212: -- ----------------------------------------------------------------------------
213: Procedure del
214: (p_rec in hr_twn_shd.g_rec_type
215: ) is
216: --
217: l_proc varchar2(72) := g_package||'del';
218: --
220: hr_utility.set_location('Entering:'||l_proc, 5);
221: --
222: -- We must lock the row which we need to delete.
223: --
224: hr_twn_shd.lck
225: (p_rec.template_window_id
226: ,p_rec.object_version_number
227: );
228: --
251: (p_template_window_id in number
252: ,p_object_version_number in number
253: ) is
254: --
255: l_rec hr_twn_shd.g_rec_type;
256: l_proc varchar2(72) := g_package||'del';
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);