48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in hr_tic_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --
87: Exception
88: When hr_api.child_integrity_violated then
89: -- Child integrity has been violated
90: --
91: hr_tic_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When Others Then
94: --
95: Raise;
126: -- Internal Row Handler Use Only.
127: --
128: -- {End Of Comments}
129: -- ----------------------------------------------------------------------------
130: Procedure pre_delete(p_rec in hr_tic_shd.g_rec_type) is
131: --
132: l_proc varchar2(72) := g_package||'pre_delete';
133: --
134: Begin
168: -- Internal Row Handler Use Only.
169: --
170: -- {End Of Comments}
171: -- -----------------------------------------------------------------------------
172: Procedure post_delete(p_rec in hr_tic_shd.g_rec_type) is
173: --
174: l_proc varchar2(72) := g_package||'post_delete';
175: --
176: Begin
180: hr_tic_rkd.after_delete
181: (p_template_item_context_id
182: => p_rec.template_item_context_id
183: ,p_object_version_number_o
184: => hr_tic_shd.g_old_rec.object_version_number
185: ,p_template_item_id_o
186: => hr_tic_shd.g_old_rec.template_item_id
187: ,p_context_type_o
188: => hr_tic_shd.g_old_rec.context_type
182: => p_rec.template_item_context_id
183: ,p_object_version_number_o
184: => hr_tic_shd.g_old_rec.object_version_number
185: ,p_template_item_id_o
186: => hr_tic_shd.g_old_rec.template_item_id
187: ,p_context_type_o
188: => hr_tic_shd.g_old_rec.context_type
189: ,p_item_context_id_o
190: => hr_tic_shd.g_old_rec.item_context_id
184: => hr_tic_shd.g_old_rec.object_version_number
185: ,p_template_item_id_o
186: => hr_tic_shd.g_old_rec.template_item_id
187: ,p_context_type_o
188: => hr_tic_shd.g_old_rec.context_type
189: ,p_item_context_id_o
190: => hr_tic_shd.g_old_rec.item_context_id
191: );
192: --
186: => hr_tic_shd.g_old_rec.template_item_id
187: ,p_context_type_o
188: => hr_tic_shd.g_old_rec.context_type
189: ,p_item_context_id_o
190: => hr_tic_shd.g_old_rec.item_context_id
191: );
192: --
193: exception
194: --
206: -- ----------------------------------------------------------------------------
207: -- |---------------------------------< del >----------------------------------|
208: -- ----------------------------------------------------------------------------
209: Procedure del
210: (p_rec in hr_tic_shd.g_rec_type
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'del';
214: --
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: -- We must lock the row which we need to delete.
219: --
220: hr_tic_shd.lck
221: (p_rec.template_item_context_id
222: ,p_rec.object_version_number
223: );
224: --
247: (p_template_item_context_id in number
248: ,p_object_version_number in number
249: ) is
250: --
251: l_rec hr_tic_shd.g_rec_type;
252: l_proc varchar2(72) := g_package||'del';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);