[Home] [Help]
PACKAGE BODY: APPS.GHR_PAR_DEL
Source
1 Package Body ghr_par_del as
2 /* $Header: ghparrhi.pkb 120.5.12010000.3 2008/10/22 07:10:55 utokachi ship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ghr_par_del.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< delete_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the actual dml delete logic. The functions of
17 -- this procedure are as follows:
18 -- 1) To delete the specified row from the schema using the primary key in
19 -- the predicates.
20 -- 2) To trap any constraint violations that may have occurred.
21 -- 3) To raise any other errors.
22 --
23 -- Prerequisites:
24 -- This is an internal private procedure which must be called from the del
25 -- procedure.
26 --
27 -- In Parameters:
28 -- A Pl/Sql record structre.
29 --
30 -- Post Success:
31 -- The specified row will be delete from the schema.
32 --
33 -- Post Failure:
34 -- If a child integrity constraint violation is raised the
35 -- constraint_error procedure will be called.
36 --
37 -- Developer Implementation Notes:
38 -- None.
39 --
40 -- Access Status:
41 -- Internal Row Handler Use Only.
42 --
43 -- {End Of Comments}
44 -- ----------------------------------------------------------------------------
45 Procedure delete_dml(p_rec in ghr_par_shd.g_rec_type) is
46 --
47 l_proc varchar2(72) := g_package||'delete_dml';
48 --
49 Begin
50 hr_utility.set_location('Entering:'||l_proc, 5);
51 --
52 --
53 -- Delete the ghr_pa_requests row.
54 --
55 delete from ghr_pa_requests
56 where pa_request_id = p_rec.pa_request_id;
57 --
58 --
59 hr_utility.set_location(' Leaving:'||l_proc, 10);
60 --
61 Exception
62 When hr_api.child_integrity_violated then
63 -- Child integrity has been violated
64 ghr_par_shd.constraint_error
65 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
66 When Others Then
67 Raise;
68 End delete_dml;
69 --
70 -- ----------------------------------------------------------------------------
71 -- |------------------------------< pre_delete >------------------------------|
72 -- ----------------------------------------------------------------------------
73 -- {Start Of Comments}
74 --
75 -- Description:
76 -- This private procedure contains any processing which is required before
77 -- the delete dml.
78 --
79 -- Prerequisites:
80 -- This is an internal procedure which is called from the del procedure.
81 --
82 -- In Parameters:
83 -- A Pl/Sql record structre.
84 --
85 -- Post Success:
86 -- Processing continues.
87 --
88 -- Post Failure:
89 -- If an error has occurred, an error message and exception will be raised
90 -- but not handled.
91 --
92 -- Developer Implementation Notes:
93 -- Any pre-processing required before the delete dml is issued should be
94 -- coded within this procedure. It is important to note that any 3rd party
95 -- maintenance should be reviewed before placing in this procedure.
96 --
97 -- Access Status:
98 -- Internal Row Handler Use Only.
99 --
100 -- {End Of Comments}
101 -- ----------------------------------------------------------------------------
102 Procedure pre_delete(p_rec in ghr_par_shd.g_rec_type) is
103 --
104 l_proc varchar2(72) := g_package||'pre_delete';
105 --
106 Begin
107 hr_utility.set_location('Entering:'||l_proc, 5);
108 --
109 hr_utility.set_location(' Leaving:'||l_proc, 10);
110 End pre_delete;
111 --
112 -- ----------------------------------------------------------------------------
113 -- |-----------------------------< post_delete >------------------------------|
114 -- ----------------------------------------------------------------------------
115 -- {Start Of Comments}
116 --
117 -- Description:
118 -- This private procedure contains any processing which is required after the
119 -- delete dml.
120 --
121 -- Prerequisites:
122 -- This is an internal procedure which is called from the del procedure.
123 --
124 -- In Parameters:
125 -- A Pl/Sql record structre.
126 --
127 -- Post Success:
128 -- Processing continues.
129 --
130 -- Post Failure:
131 -- If an error has occurred, an error message and exception will be raised
132 -- but not handled.
133 --
134 -- Developer Implementation Notes:
135 -- Any post-processing required after the delete dml is issued should be
136 -- coded within this procedure. It is important to note that any 3rd party
137 -- maintenance should be reviewed before placing in this procedure.
138 --
139 -- Access Status:
140 -- Internal table Handler Use Only.
141 --
142 -- {End Of Comments}
143 -- ----------------------------------------------------------------------------
144 Procedure post_delete(p_rec in ghr_par_shd.g_rec_type) is
145 --
146 l_proc varchar2(72) := g_package||'post_delete';
147 --
148 Begin
149 hr_utility.set_location('Entering:'||l_proc, 5);
150 --
151 -- This is a hook point and the user hook for post_delete is called here.
152 --
153 begin
154 ghr_par_rkd.after_delete (
155 p_pa_request_id => ghr_par_shd.g_old_rec.pa_request_id ,
156 p_pa_notification_id_o => ghr_par_shd.g_old_rec.pa_notification_id ,
157 p_noa_family_code_o => ghr_par_shd.g_old_rec.noa_family_code ,
158 p_routing_group_id_o => ghr_par_shd.g_old_rec.routing_group_id ,
159 p_proposed_effective_asap_fl_o => ghr_par_shd.g_old_rec.proposed_effective_asap_flag ,
160 p_academic_discipline_o => ghr_par_shd.g_old_rec.academic_discipline ,
161 p_additional_info_person_id_o => ghr_par_shd.g_old_rec.additional_info_person_id ,
162 p_additional_info_tel_number_o => ghr_par_shd.g_old_rec.additional_info_tel_number ,
163 p_agency_code_o => ghr_par_shd.g_old_rec.agency_code ,
164 p_altered_pa_request_id_o => ghr_par_shd.g_old_rec.altered_pa_request_id ,
165 p_annuitant_indicator_o => ghr_par_shd.g_old_rec.annuitant_indicator ,
166 p_annuitant_indicator_desc_o => ghr_par_shd.g_old_rec.annuitant_indicator_desc ,
167 p_appropriation_code1_o => ghr_par_shd.g_old_rec.appropriation_code1 ,
168 p_appropriation_code2_o => ghr_par_shd.g_old_rec.appropriation_code2 ,
169 p_approval_date_o => ghr_par_shd.g_old_rec.approval_date ,
170 p_approving_official_full_na_o => ghr_par_shd.g_old_rec.approving_official_full_name ,
171 p_approving_official_work_ti_o => ghr_par_shd.g_old_rec.approving_official_work_title ,
172 p_sf50_approval_date_o => ghr_par_shd.g_old_rec.sf50_approval_date ,
173 p_sf50_approving_ofcl_full_n_o => ghr_par_shd.g_old_rec.sf50_approving_ofcl_full_name ,
174 p_sf50_approving_ofcl_work_t_o => ghr_par_shd.g_old_rec.sf50_approving_ofcl_work_title ,
175 p_authorized_by_person_id_o => ghr_par_shd.g_old_rec.authorized_by_person_id ,
176 p_authorized_by_title_o => ghr_par_shd.g_old_rec.authorized_by_title ,
177 p_award_amount_o => ghr_par_shd.g_old_rec.award_amount ,
178 p_award_uom_o => ghr_par_shd.g_old_rec.award_uom ,
179 p_bargaining_unit_status_o => ghr_par_shd.g_old_rec.bargaining_unit_status ,
180 p_citizenship_o => ghr_par_shd.g_old_rec.citizenship ,
181 p_concurrence_date_o => ghr_par_shd.g_old_rec.concurrence_date ,
182 p_custom_pay_calc_flag_o => ghr_par_shd.g_old_rec.custom_pay_calc_flag ,
183 p_duty_station_code_o => ghr_par_shd.g_old_rec.duty_station_code ,
184 p_duty_station_desc_o => ghr_par_shd.g_old_rec.duty_station_desc ,
185 p_duty_station_id_o => ghr_par_shd.g_old_rec.duty_station_id ,
186 p_duty_station_location_id_o => ghr_par_shd.g_old_rec.duty_station_location_id ,
187 p_education_level_o => ghr_par_shd.g_old_rec.education_level ,
188 p_effective_date_o => ghr_par_shd.g_old_rec.effective_date ,
189 p_employee_assignment_id_o => ghr_par_shd.g_old_rec.employee_assignment_id ,
190 p_employee_date_of_birth_o => ghr_par_shd.g_old_rec.employee_date_of_birth ,
191 p_employee_dept_or_agency_o => ghr_par_shd.g_old_rec.employee_dept_or_agency ,
192 p_employee_first_name_o => ghr_par_shd.g_old_rec.employee_first_name ,
193 p_employee_last_name_o => ghr_par_shd.g_old_rec.employee_last_name ,
194 p_employee_middle_names_o => ghr_par_shd.g_old_rec.employee_middle_names ,
195 p_employee_national_identifi_o => ghr_par_shd.g_old_rec.employee_national_identifier ,
196 p_fegli_o => ghr_par_shd.g_old_rec.fegli ,
197 p_fegli_desc_o => ghr_par_shd.g_old_rec.fegli_desc ,
198 p_first_action_la_code1_o => ghr_par_shd.g_old_rec.first_action_la_code1 ,
199 p_first_action_la_code2_o => ghr_par_shd.g_old_rec.first_action_la_code2 ,
200 p_first_action_la_desc1_o => ghr_par_shd.g_old_rec.first_action_la_desc1 ,
201 p_first_action_la_desc2_o => ghr_par_shd.g_old_rec.first_action_la_desc2 ,
202 p_first_noa_cancel_or_correc_o => ghr_par_shd.g_old_rec.first_noa_cancel_or_correct ,
203 p_first_noa_code_o => ghr_par_shd.g_old_rec.first_noa_code ,
204 p_first_noa_desc_o => ghr_par_shd.g_old_rec.first_noa_desc ,
205 p_first_noa_id_o => ghr_par_shd.g_old_rec.first_noa_id ,
206 p_first_noa_pa_request_id_o => ghr_par_shd.g_old_rec.first_noa_pa_request_id ,
207 p_flsa_category_o => ghr_par_shd.g_old_rec.flsa_category ,
208 p_forwarding_address_line1_o => ghr_par_shd.g_old_rec.forwarding_address_line1 ,
209 p_forwarding_address_line2_o => ghr_par_shd.g_old_rec.forwarding_address_line2 ,
210 p_forwarding_address_line3_o => ghr_par_shd.g_old_rec.forwarding_address_line3 ,
211 p_forwarding_country_o => ghr_par_shd.g_old_rec.forwarding_country ,
212 p_forwarding_country_short_n_o => ghr_par_shd.g_old_rec.forwarding_country_short_name ,
213 p_forwarding_postal_code_o => ghr_par_shd.g_old_rec.forwarding_postal_code ,
214 p_forwarding_region_2_o => ghr_par_shd.g_old_rec.forwarding_region_2 ,
215 p_forwarding_town_or_city_o => ghr_par_shd.g_old_rec.forwarding_town_or_city ,
216 p_from_adj_basic_pay_o => ghr_par_shd.g_old_rec.from_adj_basic_pay ,
217 p_from_agency_code_o => ghr_par_shd.g_old_rec.from_agency_code ,
218 p_from_agency_desc_o => ghr_par_shd.g_old_rec.from_agency_desc ,
219 p_from_basic_pay_o => ghr_par_shd.g_old_rec.from_basic_pay ,
220 p_from_grade_or_level_o => ghr_par_shd.g_old_rec.from_grade_or_level ,
221 p_from_locality_adj_o => ghr_par_shd.g_old_rec.from_locality_adj ,
222 p_from_occ_code_o => ghr_par_shd.g_old_rec.from_occ_code ,
223 p_from_office_symbol_o => ghr_par_shd.g_old_rec.from_office_symbol ,
224 p_from_other_pay_amount_o => ghr_par_shd.g_old_rec.from_other_pay_amount ,
225 p_from_pay_basis_o => ghr_par_shd.g_old_rec.from_pay_basis ,
226 p_from_pay_plan_o => ghr_par_shd.g_old_rec.from_pay_plan ,
227 -- FWFA Changes Bug#4444609
228 -- p_input_pay_rate_determinant_o => ghr_par_shd.g_old_rec.input_pay_rate_determinant ,
229 -- p_from_pay_table_identifier_o => ghr_par_shd.g_old_rec.from_pay_table_identifier ,
230 -- FWFA Changes
231 p_from_position_id_o => ghr_par_shd.g_old_rec.from_position_id ,
232 p_from_position_org_line1_o => ghr_par_shd.g_old_rec.from_position_org_line1 ,
233 p_from_position_org_line2_o => ghr_par_shd.g_old_rec.from_position_org_line2 ,
234 p_from_position_org_line3_o => ghr_par_shd.g_old_rec.from_position_org_line3 ,
235 p_from_position_org_line4_o => ghr_par_shd.g_old_rec.from_position_org_line4 ,
236 p_from_position_org_line5_o => ghr_par_shd.g_old_rec.from_position_org_line5 ,
237 p_from_position_org_line6_o => ghr_par_shd.g_old_rec.from_position_org_line6 ,
238 p_from_position_number_o => ghr_par_shd.g_old_rec.from_position_number ,
239 p_from_position_seq_no_o => ghr_par_shd.g_old_rec.from_position_seq_no ,
240 p_from_position_title_o => ghr_par_shd.g_old_rec.from_position_title ,
241 p_from_step_or_rate_o => ghr_par_shd.g_old_rec.from_step_or_rate ,
242 p_from_total_salary_o => ghr_par_shd.g_old_rec.from_total_salary ,
243 p_functional_class_o => ghr_par_shd.g_old_rec.functional_class ,
244 p_notepad_o => ghr_par_shd.g_old_rec.notepad ,
245 p_part_time_hours_o => ghr_par_shd.g_old_rec.part_time_hours ,
246 p_pay_rate_determinant_o => ghr_par_shd.g_old_rec.pay_rate_determinant ,
247 p_personnel_office_id_o => ghr_par_shd.g_old_rec.personnel_office_id ,
248 p_person_id_o => ghr_par_shd.g_old_rec.person_id ,
249 p_position_occupied_o => ghr_par_shd.g_old_rec.position_occupied ,
250 p_proposed_effective_date_o => ghr_par_shd.g_old_rec.proposed_effective_date ,
251 p_requested_by_person_id_o => ghr_par_shd.g_old_rec.requested_by_person_id ,
252 p_requested_by_title_o => ghr_par_shd.g_old_rec.requested_by_title ,
253 p_requested_date_o => ghr_par_shd.g_old_rec.requested_date ,
254 p_requesting_office_remark_d_o => ghr_par_shd.g_old_rec.requesting_office_remarks_desc ,
255 p_requesting_office_remark_f_o => ghr_par_shd.g_old_rec.requesting_office_remarks_flag ,
256 p_request_number_o => ghr_par_shd.g_old_rec.request_number ,
257 p_resign_and_retire_reason_d_o => ghr_par_shd.g_old_rec.resign_and_retire_reason_desc ,
258 p_retirement_plan_o => ghr_par_shd.g_old_rec.retirement_plan ,
259 p_retirement_plan_desc_o => ghr_par_shd.g_old_rec.retirement_plan_desc ,
260 p_second_action_la_code1_o => ghr_par_shd.g_old_rec.second_action_la_code1 ,
261 p_second_action_la_code2_o => ghr_par_shd.g_old_rec.second_action_la_code2 ,
262 p_second_action_la_desc1_o => ghr_par_shd.g_old_rec.second_action_la_desc1 ,
263 p_second_action_la_desc2_o => ghr_par_shd.g_old_rec.second_action_la_desc2 ,
264 p_second_noa_cancel_or_corre_o => ghr_par_shd.g_old_rec.second_noa_cancel_or_correct ,
265 p_second_noa_code_o => ghr_par_shd.g_old_rec.second_noa_code ,
266 p_second_noa_desc_o => ghr_par_shd.g_old_rec.second_noa_desc ,
267 p_second_noa_id_o => ghr_par_shd.g_old_rec.second_noa_id ,
268 p_second_noa_pa_request_id_o => ghr_par_shd.g_old_rec.second_noa_pa_request_id ,
269 p_service_comp_date_o => ghr_par_shd.g_old_rec.service_comp_date ,
270 p_status_o => ghr_par_shd.g_old_rec.status ,
271 p_supervisory_status_o => ghr_par_shd.g_old_rec.supervisory_status ,
272 p_tenure_o => ghr_par_shd.g_old_rec.tenure ,
273 p_to_adj_basic_pay_o => ghr_par_shd.g_old_rec.to_adj_basic_pay ,
274 p_to_basic_pay_o => ghr_par_shd.g_old_rec.to_basic_pay ,
275 p_to_grade_id_o => ghr_par_shd.g_old_rec.to_grade_id ,
276 p_to_grade_or_level_o => ghr_par_shd.g_old_rec.to_grade_or_level ,
277 p_to_job_id_o => ghr_par_shd.g_old_rec.to_job_id ,
278 p_to_locality_adj_o => ghr_par_shd.g_old_rec.to_locality_adj ,
279 p_to_occ_code_o => ghr_par_shd.g_old_rec.to_occ_code ,
280 p_to_office_symbol_o => ghr_par_shd.g_old_rec.to_office_symbol ,
281 p_to_organization_id_o => ghr_par_shd.g_old_rec.to_organization_id ,
282 p_to_other_pay_amount_o => ghr_par_shd.g_old_rec.to_other_pay_amount ,
283 p_to_au_overtime_o => ghr_par_shd.g_old_rec.to_au_overtime ,
284 p_to_auo_premium_pay_indicat_o => ghr_par_shd.g_old_rec.to_auo_premium_pay_indicator ,
285 p_to_availability_pay_o => ghr_par_shd.g_old_rec.to_availability_pay ,
286 p_to_ap_premium_pay_indicato_o => ghr_par_shd.g_old_rec.to_ap_premium_pay_indicator ,
287 p_to_retention_allowance_o => ghr_par_shd.g_old_rec.to_retention_allowance ,
288 p_to_supervisory_differentia_o => ghr_par_shd.g_old_rec.to_supervisory_differential ,
289 p_to_staffing_differential_o => ghr_par_shd.g_old_rec.to_staffing_differential ,
290 p_to_pay_basis_o => ghr_par_shd.g_old_rec.to_pay_basis ,
291 p_to_pay_plan_o => ghr_par_shd.g_old_rec.to_pay_plan ,
292 -- FWFA Changes Bug#4444609
293 -- p_to_pay_table_identifier_o => ghr_par_shd.g_old_rec.to_pay_table_identifier ,
294 -- FWFA Changes
295 p_to_position_id_o => ghr_par_shd.g_old_rec.to_position_id ,
296 p_to_position_org_line1_o => ghr_par_shd.g_old_rec.to_position_org_line1 ,
297 p_to_position_org_line2_o => ghr_par_shd.g_old_rec.to_position_org_line2 ,
298 p_to_position_org_line3_o => ghr_par_shd.g_old_rec.to_position_org_line3 ,
299 p_to_position_org_line4_o => ghr_par_shd.g_old_rec.to_position_org_line4 ,
300 p_to_position_org_line5_o => ghr_par_shd.g_old_rec.to_position_org_line5 ,
301 p_to_position_org_line6_o => ghr_par_shd.g_old_rec.to_position_org_line6 ,
302 p_to_position_number_o => ghr_par_shd.g_old_rec.to_position_number ,
303 p_to_position_seq_no_o => ghr_par_shd.g_old_rec.to_position_seq_no ,
304 p_to_position_title_o => ghr_par_shd.g_old_rec.to_position_title ,
305 p_to_step_or_rate_o => ghr_par_shd.g_old_rec.to_step_or_rate ,
306 p_to_total_salary_o => ghr_par_shd.g_old_rec.to_total_salary ,
307 p_veterans_preference_o => ghr_par_shd.g_old_rec.veterans_preference ,
308 p_veterans_pref_for_rif_o => ghr_par_shd.g_old_rec.veterans_pref_for_rif ,
309 p_veterans_status_o => ghr_par_shd.g_old_rec.veterans_status ,
310 p_work_schedule_o => ghr_par_shd.g_old_rec.work_schedule ,
311 p_work_schedule_desc_o => ghr_par_shd.g_old_rec.work_schedule_desc ,
312 p_year_degree_attained_o => ghr_par_shd.g_old_rec.year_degree_attained ,
313 p_first_noa_information1_o => ghr_par_shd.g_old_rec.first_noa_information1 ,
314 p_first_noa_information2_o => ghr_par_shd.g_old_rec.first_noa_information2 ,
315 p_first_noa_information3_o => ghr_par_shd.g_old_rec.first_noa_information3 ,
316 p_first_noa_information4_o => ghr_par_shd.g_old_rec.first_noa_information4 ,
317 p_first_noa_information5_o => ghr_par_shd.g_old_rec.first_noa_information5 ,
318 p_second_lac1_information1_o => ghr_par_shd.g_old_rec.second_lac1_information1 ,
319 p_second_lac1_information2_o => ghr_par_shd.g_old_rec.second_lac1_information2 ,
320 p_second_lac1_information3_o => ghr_par_shd.g_old_rec.second_lac1_information3 ,
321 p_second_lac1_information4_o => ghr_par_shd.g_old_rec.second_lac1_information4 ,
322 p_second_lac1_information5_o => ghr_par_shd.g_old_rec.second_lac1_information5 ,
323 p_second_lac2_information1_o => ghr_par_shd.g_old_rec.second_lac2_information1 ,
324 p_second_lac2_information2_o => ghr_par_shd.g_old_rec.second_lac2_information2 ,
325 p_second_lac2_information3_o => ghr_par_shd.g_old_rec.second_lac2_information3 ,
326 p_second_lac2_information4_o => ghr_par_shd.g_old_rec.second_lac2_information4 ,
327 p_second_lac2_information5_o => ghr_par_shd.g_old_rec.second_lac2_information5 ,
328 p_second_noa_information1_o => ghr_par_shd.g_old_rec.second_noa_information1 ,
329 p_second_noa_information2_o => ghr_par_shd.g_old_rec.second_noa_information2 ,
330 p_second_noa_information3_o => ghr_par_shd.g_old_rec.second_noa_information3 ,
331 p_second_noa_information4_o => ghr_par_shd.g_old_rec.second_noa_information4 ,
332 p_second_noa_information5_o => ghr_par_shd.g_old_rec.second_noa_information5 ,
333 p_first_lac1_information1_o => ghr_par_shd.g_old_rec.first_lac1_information1 ,
334 p_first_lac1_information2_o => ghr_par_shd.g_old_rec.first_lac1_information2 ,
335 p_first_lac1_information3_o => ghr_par_shd.g_old_rec.first_lac1_information3 ,
336 p_first_lac1_information4_o => ghr_par_shd.g_old_rec.first_lac1_information4 ,
337 p_first_lac1_information5_o => ghr_par_shd.g_old_rec.first_lac1_information5 ,
338 p_first_lac2_information1_o => ghr_par_shd.g_old_rec.first_lac2_information1 ,
339 p_first_lac2_information2_o => ghr_par_shd.g_old_rec.first_lac2_information2 ,
340 p_first_lac2_information3_o => ghr_par_shd.g_old_rec.first_lac2_information3 ,
341 p_first_lac2_information4_o => ghr_par_shd.g_old_rec.first_lac2_information4 ,
342 p_first_lac2_information5_o => ghr_par_shd.g_old_rec.first_lac2_information5 ,
343 p_attribute_category_o => ghr_par_shd.g_old_rec.attribute_category ,
344 p_attribute1_o => ghr_par_shd.g_old_rec.attribute1 ,
345 p_attribute2_o => ghr_par_shd.g_old_rec.attribute2 ,
346 p_attribute3_o => ghr_par_shd.g_old_rec.attribute3 ,
347 p_attribute4_o => ghr_par_shd.g_old_rec.attribute4 ,
348 p_attribute5_o => ghr_par_shd.g_old_rec.attribute5 ,
349 p_attribute6_o => ghr_par_shd.g_old_rec.attribute6 ,
350 p_attribute7_o => ghr_par_shd.g_old_rec.attribute7 ,
351 p_attribute8_o => ghr_par_shd.g_old_rec.attribute8 ,
352 p_attribute9_o => ghr_par_shd.g_old_rec.attribute9 ,
353 p_attribute10_o => ghr_par_shd.g_old_rec.attribute10 ,
354 p_attribute11_o => ghr_par_shd.g_old_rec.attribute11 ,
355 p_attribute12_o => ghr_par_shd.g_old_rec.attribute12 ,
356 p_attribute13_o => ghr_par_shd.g_old_rec.attribute13 ,
357 p_attribute14_o => ghr_par_shd.g_old_rec.attribute14 ,
358 p_attribute15_o => ghr_par_shd.g_old_rec.attribute15 ,
359 p_attribute16_o => ghr_par_shd.g_old_rec.attribute16 ,
360 p_attribute17_o => ghr_par_shd.g_old_rec.attribute17 ,
361 p_attribute18_o => ghr_par_shd.g_old_rec.attribute18 ,
362 p_attribute19_o => ghr_par_shd.g_old_rec.attribute19 ,
363 p_attribute20_o => ghr_par_shd.g_old_rec.attribute20 ,
364 p_first_noa_canc_pa_request_o => ghr_par_shd.g_old_rec.first_noa_canc_pa_request_id ,
365 p_second_noa_canc_pa_request_o => ghr_par_shd.g_old_rec.second_noa_canc_pa_request_id ,
366 p_to_retention_allow_percent_o => ghr_par_shd.g_old_rec.to_retention_allow_percentage ,
367 p_to_supervisory_diff_percen_o => ghr_par_shd.g_old_rec.to_supervisory_diff_percentage,
368 p_to_staffing_diff_percentag_o => ghr_par_shd.g_old_rec.to_staffing_diff_percentage ,
369 p_award_percentage_o => ghr_par_shd.g_old_rec.award_percentage ,
370 p_rpa_type_o => ghr_par_shd.g_old_rec.rpa_type,
371 p_mass_action_id_o => ghr_par_shd.g_old_rec.mass_action_id,
372 p_mass_action_eligible_flag_o => ghr_par_shd.g_old_rec.mass_action_eligible_flag,
373 p_mass_action_select_flag_o => ghr_par_shd.g_old_rec.mass_action_select_flag,
374 p_mass_action_comments_o => ghr_par_shd.g_old_rec.mass_action_comments
375 );
376 exception
377 when hr_api.cannot_find_prog_unit then
378 hr_api.cannot_find_prog_unit_error
379 ( p_module_name => 'GHR_PA_REQUESTS'
380 ,p_hook_type => 'AD'
381 );
382 end;
383 -- End of API User Hook for post_delete.
384 --
385 hr_utility.set_location(' Leaving:'||l_proc, 10);
386 End post_delete;
387 --
388 -- ----------------------------------------------------------------------------
389 -- |---------------------------------< del >----------------------------------|
390 -- ----------------------------------------------------------------------------
391 Procedure del
392 (
393 p_rec in ghr_par_shd.g_rec_type
394 ) is
395 --
396 l_proc varchar2(72) := g_package||'del';
397 --
398 Begin
399 hr_utility.set_location('Entering:'||l_proc, 5);
400 --
401 -- We must lock the row which we need to delete.
402 --
403 ghr_par_shd.lck
404 (
405 p_rec.pa_request_id,
406 p_rec.routing_group_id,
407 p_rec.object_version_number
408 );
409 --
410 -- Call the supporting delete validate operation
411 --
412 ghr_par_bus.delete_validate(p_rec);
413 --
414 -- Call the supporting pre-delete operation
415 --
416 pre_delete(p_rec);
417 --
418 -- Delete the row.
419 --
420 delete_dml(p_rec);
421 --
422 -- Call the supporting post-delete operation
423 --
424 post_delete(p_rec);
425 End del;
426 --
427 -- ----------------------------------------------------------------------------
428 -- |---------------------------------< del >----------------------------------|
429 -- ----------------------------------------------------------------------------
430 Procedure del
431 (
432 p_pa_request_id in number,
433 p_object_version_number in number
434 ) is
435 --
436 l_rec ghr_par_shd.g_rec_type;
437 l_proc varchar2(72) := g_package||'del';
438 --
439 Begin
440 hr_utility.set_location('Entering:'||l_proc, 5);
441 --
442 -- As the delete procedure accepts a plsql record structure we do need to
443 -- convert the arguments into the record structure.
444 -- We don't need to call the supplied conversion argument routine as we
445 -- only need a few attributes.
446 --
447 l_rec.pa_request_id:= p_pa_request_id;
448 l_rec.object_version_number := p_object_version_number;
449 --
450 -- Having converted the arguments into the par_rec
451 -- plsql record structure we must call the corresponding entity
452 -- business process
453 --
454 del(l_rec);
455 --
456 hr_utility.set_location(' Leaving:'||l_proc, 10);
457 End del;
458 --
459 end ghr_par_del;