[Home] [Help]
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml
46: (p_rec in hr_dty_shd.g_rec_type
47: ) is
48: --
49: l_proc varchar2(72) := g_package||'delete_dml';
50: --
65: Exception
66: When hr_api.child_integrity_violated then
67: -- Child integrity has been violated
68: --
69: hr_dty_shd.constraint_error
70: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
71: When Others Then
72: --
73: Raise;
104: -- Internal Row Handler Use Only.
105: --
106: -- {End Of Comments}
107: -- ----------------------------------------------------------------------------
108: Procedure pre_delete(p_rec in hr_dty_shd.g_rec_type) is
109: --
110: l_proc varchar2(72) := g_package||'pre_delete';
111: --
112: Begin
146: -- Internal Row Handler Use Only.
147: --
148: -- {End Of Comments}
149: -- -----------------------------------------------------------------------------
150: Procedure post_delete(p_rec in hr_dty_shd.g_rec_type) is
151: --
152: l_proc varchar2(72) := g_package||'post_delete';
153: --
154: Begin
158: hr_dty_rkd.after_delete
159: (p_document_type_id
160: => p_rec.document_type_id
161: ,p_category_code_o
162: => hr_dty_shd.g_old_rec.category_code
163: ,p_sub_category_code_o
164: => hr_dty_shd.g_old_rec.sub_category_code
165: ,p_active_inactive_flag_o
166: => hr_dty_shd.g_old_rec.active_inactive_flag
160: => p_rec.document_type_id
161: ,p_category_code_o
162: => hr_dty_shd.g_old_rec.category_code
163: ,p_sub_category_code_o
164: => hr_dty_shd.g_old_rec.sub_category_code
165: ,p_active_inactive_flag_o
166: => hr_dty_shd.g_old_rec.active_inactive_flag
167: ,p_multiple_occurences_flag_o
168: => hr_dty_shd.g_old_rec.multiple_occurences_flag
162: => hr_dty_shd.g_old_rec.category_code
163: ,p_sub_category_code_o
164: => hr_dty_shd.g_old_rec.sub_category_code
165: ,p_active_inactive_flag_o
166: => hr_dty_shd.g_old_rec.active_inactive_flag
167: ,p_multiple_occurences_flag_o
168: => hr_dty_shd.g_old_rec.multiple_occurences_flag
169: ,p_legislation_code_o
170: => hr_dty_shd.g_old_rec.legislation_code
164: => hr_dty_shd.g_old_rec.sub_category_code
165: ,p_active_inactive_flag_o
166: => hr_dty_shd.g_old_rec.active_inactive_flag
167: ,p_multiple_occurences_flag_o
168: => hr_dty_shd.g_old_rec.multiple_occurences_flag
169: ,p_legislation_code_o
170: => hr_dty_shd.g_old_rec.legislation_code
171: ,p_authorization_required_o
172: => hr_dty_shd.g_old_rec.authorization_required
166: => hr_dty_shd.g_old_rec.active_inactive_flag
167: ,p_multiple_occurences_flag_o
168: => hr_dty_shd.g_old_rec.multiple_occurences_flag
169: ,p_legislation_code_o
170: => hr_dty_shd.g_old_rec.legislation_code
171: ,p_authorization_required_o
172: => hr_dty_shd.g_old_rec.authorization_required
173: ,p_warning_period_o
174: => hr_dty_shd.g_old_rec.warning_period
168: => hr_dty_shd.g_old_rec.multiple_occurences_flag
169: ,p_legislation_code_o
170: => hr_dty_shd.g_old_rec.legislation_code
171: ,p_authorization_required_o
172: => hr_dty_shd.g_old_rec.authorization_required
173: ,p_warning_period_o
174: => hr_dty_shd.g_old_rec.warning_period
175: ,p_request_id_o
176: => hr_dty_shd.g_old_rec.request_id
170: => hr_dty_shd.g_old_rec.legislation_code
171: ,p_authorization_required_o
172: => hr_dty_shd.g_old_rec.authorization_required
173: ,p_warning_period_o
174: => hr_dty_shd.g_old_rec.warning_period
175: ,p_request_id_o
176: => hr_dty_shd.g_old_rec.request_id
177: ,p_program_application_id_o
178: => hr_dty_shd.g_old_rec.program_application_id
172: => hr_dty_shd.g_old_rec.authorization_required
173: ,p_warning_period_o
174: => hr_dty_shd.g_old_rec.warning_period
175: ,p_request_id_o
176: => hr_dty_shd.g_old_rec.request_id
177: ,p_program_application_id_o
178: => hr_dty_shd.g_old_rec.program_application_id
179: ,p_program_id_o
180: => hr_dty_shd.g_old_rec.program_id
174: => hr_dty_shd.g_old_rec.warning_period
175: ,p_request_id_o
176: => hr_dty_shd.g_old_rec.request_id
177: ,p_program_application_id_o
178: => hr_dty_shd.g_old_rec.program_application_id
179: ,p_program_id_o
180: => hr_dty_shd.g_old_rec.program_id
181: ,p_program_update_date_o
182: => hr_dty_shd.g_old_rec.program_update_date
176: => hr_dty_shd.g_old_rec.request_id
177: ,p_program_application_id_o
178: => hr_dty_shd.g_old_rec.program_application_id
179: ,p_program_id_o
180: => hr_dty_shd.g_old_rec.program_id
181: ,p_program_update_date_o
182: => hr_dty_shd.g_old_rec.program_update_date
183: ,p_object_version_number_o
184: => hr_dty_shd.g_old_rec.object_version_number
178: => hr_dty_shd.g_old_rec.program_application_id
179: ,p_program_id_o
180: => hr_dty_shd.g_old_rec.program_id
181: ,p_program_update_date_o
182: => hr_dty_shd.g_old_rec.program_update_date
183: ,p_object_version_number_o
184: => hr_dty_shd.g_old_rec.object_version_number
185: );
186: --
180: => hr_dty_shd.g_old_rec.program_id
181: ,p_program_update_date_o
182: => hr_dty_shd.g_old_rec.program_update_date
183: ,p_object_version_number_o
184: => hr_dty_shd.g_old_rec.object_version_number
185: );
186: --
187: exception
188: --
200: -- ----------------------------------------------------------------------------
201: -- |---------------------------------< del >----------------------------------|
202: -- ----------------------------------------------------------------------------
203: Procedure del
204: (p_rec in hr_dty_shd.g_rec_type
205: ) is
206: --
207: l_proc varchar2(72) := g_package||'del';
208: --
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: -- We must lock the row which we need to delete.
213: --
214: hr_dty_shd.lck
215: (p_rec.document_type_id
216: ,p_rec.object_version_number
217: );
218: --
247: (p_document_type_id in number
248: ,p_object_version_number in number
249: ) is
250: --
251: l_rec hr_dty_shd.g_rec_type;
252: l_proc varchar2(72) := g_package||'del';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);