eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.GHR_SF52_BK2

Source


1 package body GHR_SF52_BK2 as
2 /* $Header: ghparapi.pkb 120.8.12010000.2 2008/08/05 15:08:16 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:20:38 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_SF52_A
6 (P_PA_REQUEST_ID in NUMBER
7 ,P_NOA_FAMILY_CODE in VARCHAR2
8 ,P_ROUTING_GROUP_ID in NUMBER
9 ,P_PROPOSED_EFFECTIVE_ASAP_FLAG in VARCHAR2
10 ,P_ACADEMIC_DISCIPLINE in VARCHAR2
11 ,P_ADDITIONAL_INFO_PERSON_ID in NUMBER
12 ,P_ADDITIONAL_INFO_TEL_NUMBER in VARCHAR2
13 ,P_ALTERED_PA_REQUEST_ID in NUMBER
14 ,P_ANNUITANT_INDICATOR in VARCHAR2
15 ,P_ANNUITANT_INDICATOR_DESC in VARCHAR2
16 ,P_APPROPRIATION_CODE1 in VARCHAR2
17 ,P_APPROPRIATION_CODE2 in VARCHAR2
18 ,P_AUTHORIZED_BY_PERSON_ID in NUMBER
19 ,P_AUTHORIZED_BY_TITLE in VARCHAR2
20 ,P_AWARD_AMOUNT in NUMBER
21 ,P_AWARD_UOM in VARCHAR2
22 ,P_BARGAINING_UNIT_STATUS in VARCHAR2
23 ,P_CITIZENSHIP in VARCHAR2
24 ,P_CONCURRENCE_DATE in DATE
25 ,P_CUSTOM_PAY_CALC_FLAG in VARCHAR2
26 ,P_DUTY_STATION_CODE in VARCHAR2
27 ,P_DUTY_STATION_DESC in VARCHAR2
28 ,P_DUTY_STATION_ID in NUMBER
29 ,P_DUTY_STATION_LOCATION_ID in NUMBER
30 ,P_EDUCATION_LEVEL in VARCHAR2
31 ,P_EFFECTIVE_DATE in DATE
32 ,P_EMPLOYEE_ASSIGNMENT_ID in NUMBER
33 ,P_EMPLOYEE_DATE_OF_BIRTH in DATE
34 ,P_EMPLOYEE_FIRST_NAME in VARCHAR2
35 ,P_EMPLOYEE_LAST_NAME in VARCHAR2
36 ,P_EMPLOYEE_MIDDLE_NAMES in VARCHAR2
37 ,P_EMPLOYEE_NATIONAL_IDENTIFIER in VARCHAR2
38 ,P_FEGLI in VARCHAR2
39 ,P_FEGLI_DESC in VARCHAR2
40 ,P_FIRST_ACTION_LA_CODE1 in VARCHAR2
41 ,P_FIRST_ACTION_LA_CODE2 in VARCHAR2
42 ,P_FIRST_ACTION_LA_DESC1 in VARCHAR2
43 ,P_FIRST_ACTION_LA_DESC2 in VARCHAR2
44 ,P_FIRST_NOA_CANCEL_OR_CORRECT in VARCHAR2
45 ,P_FIRST_NOA_CODE in VARCHAR2
46 ,P_FIRST_NOA_DESC in VARCHAR2
47 ,P_FIRST_NOA_ID in NUMBER
48 ,P_FIRST_NOA_PA_REQUEST_ID in NUMBER
49 ,P_FLSA_CATEGORY in VARCHAR2
50 ,P_FORWARDING_ADDRESS_LINE1 in VARCHAR2
51 ,P_FORWARDING_ADDRESS_LINE2 in VARCHAR2
52 ,P_FORWARDING_ADDRESS_LINE3 in VARCHAR2
53 ,P_FORWARDING_COUNTRY in VARCHAR2
54 ,P_FORWARDING_COUNTRY_SHORT_NAM in VARCHAR2
55 ,P_FORWARDING_POSTAL_CODE in VARCHAR2
56 ,P_FORWARDING_REGION_2 in VARCHAR2
57 ,P_FORWARDING_TOWN_OR_CITY in VARCHAR2
58 ,P_FROM_ADJ_BASIC_PAY in NUMBER
59 ,P_FROM_BASIC_PAY in NUMBER
60 ,P_FROM_GRADE_OR_LEVEL in VARCHAR2
61 ,P_FROM_LOCALITY_ADJ in NUMBER
62 ,P_FROM_OCC_CODE in VARCHAR2
63 ,P_FROM_OTHER_PAY_AMOUNT in NUMBER
64 ,P_FROM_PAY_BASIS in VARCHAR2
65 ,P_FROM_PAY_PLAN in VARCHAR2
66 ,P_FROM_POSITION_ID in NUMBER
67 ,P_FROM_POSITION_ORG_LINE1 in VARCHAR2
68 ,P_FROM_POSITION_ORG_LINE2 in VARCHAR2
69 ,P_FROM_POSITION_ORG_LINE3 in VARCHAR2
70 ,P_FROM_POSITION_ORG_LINE4 in VARCHAR2
71 ,P_FROM_POSITION_ORG_LINE5 in VARCHAR2
72 ,P_FROM_POSITION_ORG_LINE6 in VARCHAR2
73 ,P_FROM_POSITION_NUMBER in VARCHAR2
74 ,P_FROM_POSITION_SEQ_NO in NUMBER
75 ,P_FROM_POSITION_TITLE in VARCHAR2
76 ,P_FROM_STEP_OR_RATE in VARCHAR2
77 ,P_FROM_TOTAL_SALARY in NUMBER
78 ,P_FUNCTIONAL_CLASS in VARCHAR2
79 ,P_NOTEPAD in VARCHAR2
80 ,P_PART_TIME_HOURS in NUMBER
81 ,P_PAY_RATE_DETERMINANT in VARCHAR2
82 ,P_PERSON_ID in NUMBER
83 ,P_POSITION_OCCUPIED in VARCHAR2
84 ,P_PROPOSED_EFFECTIVE_DATE in DATE
85 ,P_REQUESTED_BY_PERSON_ID in NUMBER
86 ,P_REQUESTED_BY_TITLE in VARCHAR2
87 ,P_REQUESTED_DATE in DATE
88 ,P_REQUESTING_OFFICE_REMARKS_DE in VARCHAR2
89 ,P_REQUESTING_OFFICE_REMARKS_FL in VARCHAR2
90 ,P_REQUEST_NUMBER in VARCHAR2
91 ,P_RESIGN_AND_RETIRE_REASON_DES in VARCHAR2
92 ,P_RETIREMENT_PLAN in VARCHAR2
93 ,P_RETIREMENT_PLAN_DESC in VARCHAR2
94 ,P_SECOND_ACTION_LA_CODE1 in VARCHAR2
95 ,P_SECOND_ACTION_LA_CODE2 in VARCHAR2
96 ,P_SECOND_ACTION_LA_DESC1 in VARCHAR2
97 ,P_SECOND_ACTION_LA_DESC2 in VARCHAR2
98 ,P_SECOND_NOA_CANCEL_OR_CORRECT in VARCHAR2
99 ,P_SECOND_NOA_CODE in VARCHAR2
100 ,P_SECOND_NOA_DESC in VARCHAR2
101 ,P_SECOND_NOA_ID in NUMBER
102 ,P_SECOND_NOA_PA_REQUEST_ID in NUMBER
103 ,P_SERVICE_COMP_DATE in DATE
104 ,P_SUPERVISORY_STATUS in VARCHAR2
105 ,P_TENURE in VARCHAR2
106 ,P_TO_ADJ_BASIC_PAY in NUMBER
107 ,P_TO_BASIC_PAY in NUMBER
108 ,P_TO_GRADE_ID in NUMBER
109 ,P_TO_GRADE_OR_LEVEL in VARCHAR2
110 ,P_TO_JOB_ID in NUMBER
111 ,P_TO_LOCALITY_ADJ in NUMBER
112 ,P_TO_OCC_CODE in VARCHAR2
113 ,P_TO_ORGANIZATION_ID in NUMBER
114 ,P_TO_OTHER_PAY_AMOUNT in NUMBER
115 ,P_TO_AU_OVERTIME in NUMBER
116 ,P_TO_AUO_PREMIUM_PAY_INDICATOR in VARCHAR2
117 ,P_TO_AVAILABILITY_PAY in NUMBER
118 ,P_TO_AP_PREMIUM_PAY_INDICATOR in VARCHAR2
119 ,P_TO_RETENTION_ALLOWANCE in NUMBER
120 ,P_TO_SUPERVISORY_DIFFERENTIAL in NUMBER
121 ,P_TO_STAFFING_DIFFERENTIAL in NUMBER
122 ,P_TO_PAY_BASIS in VARCHAR2
123 ,P_TO_PAY_PLAN in VARCHAR2
124 ,P_TO_POSITION_ID in NUMBER
125 ,P_TO_POSITION_ORG_LINE1 in VARCHAR2
126 ,P_TO_POSITION_ORG_LINE2 in VARCHAR2
127 ,P_TO_POSITION_ORG_LINE3 in VARCHAR2
128 ,P_TO_POSITION_ORG_LINE4 in VARCHAR2
129 ,P_TO_POSITION_ORG_LINE5 in VARCHAR2
130 ,P_TO_POSITION_ORG_LINE6 in VARCHAR2
131 ,P_TO_POSITION_NUMBER in VARCHAR2
132 ,P_TO_POSITION_SEQ_NO in NUMBER
133 ,P_TO_POSITION_TITLE in VARCHAR2
134 ,P_TO_STEP_OR_RATE in VARCHAR2
135 ,P_TO_TOTAL_SALARY in NUMBER
136 ,P_VETERANS_PREFERENCE in VARCHAR2
137 ,P_VETERANS_PREF_FOR_RIF in VARCHAR2
138 ,P_VETERANS_STATUS in VARCHAR2
139 ,P_WORK_SCHEDULE in VARCHAR2
140 ,P_WORK_SCHEDULE_DESC in VARCHAR2
141 ,P_YEAR_DEGREE_ATTAINED in NUMBER
142 ,P_FIRST_NOA_INFORMATION1 in VARCHAR2
143 ,P_FIRST_NOA_INFORMATION2 in VARCHAR2
144 ,P_FIRST_NOA_INFORMATION3 in VARCHAR2
145 ,P_FIRST_NOA_INFORMATION4 in VARCHAR2
146 ,P_FIRST_NOA_INFORMATION5 in VARCHAR2
147 ,P_SECOND_LAC1_INFORMATION1 in VARCHAR2
148 ,P_SECOND_LAC1_INFORMATION2 in VARCHAR2
149 ,P_SECOND_LAC1_INFORMATION3 in VARCHAR2
150 ,P_SECOND_LAC1_INFORMATION4 in VARCHAR2
151 ,P_SECOND_LAC1_INFORMATION5 in VARCHAR2
152 ,P_SECOND_LAC2_INFORMATION1 in VARCHAR2
153 ,P_SECOND_LAC2_INFORMATION2 in VARCHAR2
154 ,P_SECOND_LAC2_INFORMATION3 in VARCHAR2
155 ,P_SECOND_LAC2_INFORMATION4 in VARCHAR2
156 ,P_SECOND_LAC2_INFORMATION5 in VARCHAR2
157 ,P_SECOND_NOA_INFORMATION1 in VARCHAR2
158 ,P_SECOND_NOA_INFORMATION2 in VARCHAR2
159 ,P_SECOND_NOA_INFORMATION3 in VARCHAR2
160 ,P_SECOND_NOA_INFORMATION4 in VARCHAR2
161 ,P_SECOND_NOA_INFORMATION5 in VARCHAR2
162 ,P_FIRST_LAC1_INFORMATION1 in VARCHAR2
163 ,P_FIRST_LAC1_INFORMATION2 in VARCHAR2
164 ,P_FIRST_LAC1_INFORMATION3 in VARCHAR2
165 ,P_FIRST_LAC1_INFORMATION4 in VARCHAR2
166 ,P_FIRST_LAC1_INFORMATION5 in VARCHAR2
167 ,P_FIRST_LAC2_INFORMATION1 in VARCHAR2
168 ,P_FIRST_LAC2_INFORMATION2 in VARCHAR2
169 ,P_FIRST_LAC2_INFORMATION3 in VARCHAR2
170 ,P_FIRST_LAC2_INFORMATION4 in VARCHAR2
171 ,P_FIRST_LAC2_INFORMATION5 in VARCHAR2
172 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
173 ,P_ATTRIBUTE1 in VARCHAR2
174 ,P_ATTRIBUTE2 in VARCHAR2
175 ,P_ATTRIBUTE3 in VARCHAR2
176 ,P_ATTRIBUTE4 in VARCHAR2
177 ,P_ATTRIBUTE5 in VARCHAR2
178 ,P_ATTRIBUTE6 in VARCHAR2
179 ,P_ATTRIBUTE7 in VARCHAR2
180 ,P_ATTRIBUTE8 in VARCHAR2
181 ,P_ATTRIBUTE9 in VARCHAR2
182 ,P_ATTRIBUTE10 in VARCHAR2
183 ,P_ATTRIBUTE11 in VARCHAR2
184 ,P_ATTRIBUTE12 in VARCHAR2
185 ,P_ATTRIBUTE13 in VARCHAR2
186 ,P_ATTRIBUTE14 in VARCHAR2
187 ,P_ATTRIBUTE15 in VARCHAR2
188 ,P_ATTRIBUTE16 in VARCHAR2
189 ,P_ATTRIBUTE17 in VARCHAR2
190 ,P_ATTRIBUTE18 in VARCHAR2
191 ,P_ATTRIBUTE19 in VARCHAR2
192 ,P_ATTRIBUTE20 in VARCHAR2
193 ,P_PRINT_SF50_FLAG in VARCHAR2
194 ,P_PRINTER_NAME in VARCHAR2
195 ,P_U_ATTACHMENT_MODIFIED_FLAG in VARCHAR2
196 ,P_U_APPROVED_FLAG in VARCHAR2
197 ,P_U_USER_NAME_ACTED_ON in VARCHAR2
198 ,P_U_ACTION_TAKEN in VARCHAR2
199 ,P_U_APPROVAL_STATUS in VARCHAR2
200 ,P_I_USER_NAME_ROUTED_TO in VARCHAR2
201 ,P_I_GROUPBOX_ID in NUMBER
202 ,P_I_ROUTING_LIST_ID in NUMBER
203 ,P_I_ROUTING_SEQ_NUMBER in NUMBER
204 ,P_CAPPED_OTHER_PAY in NUMBER
205 ,P_I_PA_ROUTING_HISTORY_ID in NUMBER
206 ,P_I_PRH_OBJECT_VERSION_NUMBER in NUMBER
207 ,P_PAR_OBJECT_VERSION_NUMBER in NUMBER
208 ,P_TO_RETENTION_ALLOW_PERCENTAG in NUMBER
209 ,P_TO_SUPERVISORY_DIFF_PERCENTA in NUMBER
210 ,P_TO_STAFFING_DIFF_PERCENTAGE in NUMBER
211 ,P_AWARD_PERCENTAGE in NUMBER
212 ,P_RPA_TYPE in VARCHAR2
213 ,P_MASS_ACTION_ID in NUMBER
214 ,P_MASS_ACTION_ELIGIBLE_FLAG in VARCHAR2
215 ,P_MASS_ACTION_SELECT_FLAG in VARCHAR2
216 ,P_MASS_ACTION_COMMENTS in VARCHAR2
217 )is
218 begin
219 hr_utility.set_location('Entering: GHR_SF52_BK2.UPDATE_SF52_A', 10);
220 hr_utility.set_location(' Leaving: GHR_SF52_BK2.UPDATE_SF52_A', 20);
221 end UPDATE_SF52_A;
222 procedure UPDATE_SF52_B
223 (P_PA_REQUEST_ID in NUMBER
224 ,P_NOA_FAMILY_CODE in VARCHAR2
225 ,P_ROUTING_GROUP_ID in NUMBER
226 ,P_PROPOSED_EFFECTIVE_ASAP_FLAG in VARCHAR2
227 ,P_ACADEMIC_DISCIPLINE in VARCHAR2
228 ,P_ADDITIONAL_INFO_PERSON_ID in NUMBER
229 ,P_ADDITIONAL_INFO_TEL_NUMBER in VARCHAR2
230 ,P_ALTERED_PA_REQUEST_ID in NUMBER
231 ,P_ANNUITANT_INDICATOR in VARCHAR2
232 ,P_ANNUITANT_INDICATOR_DESC in VARCHAR2
233 ,P_APPROPRIATION_CODE1 in VARCHAR2
234 ,P_APPROPRIATION_CODE2 in VARCHAR2
235 ,P_AUTHORIZED_BY_PERSON_ID in NUMBER
236 ,P_AUTHORIZED_BY_TITLE in VARCHAR2
237 ,P_AWARD_AMOUNT in NUMBER
238 ,P_AWARD_UOM in VARCHAR2
239 ,P_BARGAINING_UNIT_STATUS in VARCHAR2
240 ,P_CITIZENSHIP in VARCHAR2
241 ,P_CONCURRENCE_DATE in DATE
242 ,P_CUSTOM_PAY_CALC_FLAG in VARCHAR2
243 ,P_DUTY_STATION_CODE in VARCHAR2
244 ,P_DUTY_STATION_DESC in VARCHAR2
245 ,P_DUTY_STATION_ID in NUMBER
246 ,P_DUTY_STATION_LOCATION_ID in NUMBER
247 ,P_EDUCATION_LEVEL in VARCHAR2
248 ,P_EFFECTIVE_DATE in DATE
249 ,P_EMPLOYEE_ASSIGNMENT_ID in NUMBER
250 ,P_EMPLOYEE_DATE_OF_BIRTH in DATE
251 ,P_EMPLOYEE_FIRST_NAME in VARCHAR2
252 ,P_EMPLOYEE_LAST_NAME in VARCHAR2
253 ,P_EMPLOYEE_MIDDLE_NAMES in VARCHAR2
254 ,P_EMPLOYEE_NATIONAL_IDENTIFIER in VARCHAR2
255 ,P_FEGLI in VARCHAR2
256 ,P_FEGLI_DESC in VARCHAR2
257 ,P_FIRST_ACTION_LA_CODE1 in VARCHAR2
258 ,P_FIRST_ACTION_LA_CODE2 in VARCHAR2
259 ,P_FIRST_ACTION_LA_DESC1 in VARCHAR2
260 ,P_FIRST_ACTION_LA_DESC2 in VARCHAR2
261 ,P_FIRST_NOA_CANCEL_OR_CORRECT in VARCHAR2
262 ,P_FIRST_NOA_CODE in VARCHAR2
263 ,P_FIRST_NOA_DESC in VARCHAR2
264 ,P_FIRST_NOA_ID in NUMBER
265 ,P_FIRST_NOA_PA_REQUEST_ID in NUMBER
266 ,P_FLSA_CATEGORY in VARCHAR2
267 ,P_FORWARDING_ADDRESS_LINE1 in VARCHAR2
268 ,P_FORWARDING_ADDRESS_LINE2 in VARCHAR2
269 ,P_FORWARDING_ADDRESS_LINE3 in VARCHAR2
270 ,P_FORWARDING_COUNTRY in VARCHAR2
271 ,P_FORWARDING_COUNTRY_SHORT_NAM in VARCHAR2
272 ,P_FORWARDING_POSTAL_CODE in VARCHAR2
273 ,P_FORWARDING_REGION_2 in VARCHAR2
274 ,P_FORWARDING_TOWN_OR_CITY in VARCHAR2
275 ,P_FROM_ADJ_BASIC_PAY in NUMBER
276 ,P_FROM_BASIC_PAY in NUMBER
277 ,P_FROM_GRADE_OR_LEVEL in VARCHAR2
278 ,P_FROM_LOCALITY_ADJ in NUMBER
279 ,P_FROM_OCC_CODE in VARCHAR2
280 ,P_FROM_OTHER_PAY_AMOUNT in NUMBER
281 ,P_FROM_PAY_BASIS in VARCHAR2
282 ,P_FROM_PAY_PLAN in VARCHAR2
283 ,P_FROM_POSITION_ID in NUMBER
284 ,P_FROM_POSITION_ORG_LINE1 in VARCHAR2
285 ,P_FROM_POSITION_ORG_LINE2 in VARCHAR2
286 ,P_FROM_POSITION_ORG_LINE3 in VARCHAR2
287 ,P_FROM_POSITION_ORG_LINE4 in VARCHAR2
288 ,P_FROM_POSITION_ORG_LINE5 in VARCHAR2
289 ,P_FROM_POSITION_ORG_LINE6 in VARCHAR2
290 ,P_FROM_POSITION_NUMBER in VARCHAR2
291 ,P_FROM_POSITION_SEQ_NO in NUMBER
292 ,P_FROM_POSITION_TITLE in VARCHAR2
293 ,P_FROM_STEP_OR_RATE in VARCHAR2
294 ,P_FROM_TOTAL_SALARY in NUMBER
295 ,P_FUNCTIONAL_CLASS in VARCHAR2
296 ,P_NOTEPAD in VARCHAR2
297 ,P_PART_TIME_HOURS in NUMBER
298 ,P_PAY_RATE_DETERMINANT in VARCHAR2
299 ,P_PERSON_ID in NUMBER
300 ,P_POSITION_OCCUPIED in VARCHAR2
301 ,P_PROPOSED_EFFECTIVE_DATE in DATE
302 ,P_REQUESTED_BY_PERSON_ID in NUMBER
303 ,P_REQUESTED_BY_TITLE in VARCHAR2
304 ,P_REQUESTED_DATE in DATE
305 ,P_REQUESTING_OFFICE_REMARKS_DE in VARCHAR2
306 ,P_REQUESTING_OFFICE_REMARKS_FL in VARCHAR2
307 ,P_REQUEST_NUMBER in VARCHAR2
308 ,P_RESIGN_AND_RETIRE_REASON_DES in VARCHAR2
309 ,P_RETIREMENT_PLAN in VARCHAR2
310 ,P_RETIREMENT_PLAN_DESC in VARCHAR2
311 ,P_SECOND_ACTION_LA_CODE1 in VARCHAR2
312 ,P_SECOND_ACTION_LA_CODE2 in VARCHAR2
313 ,P_SECOND_ACTION_LA_DESC1 in VARCHAR2
314 ,P_SECOND_ACTION_LA_DESC2 in VARCHAR2
315 ,P_SECOND_NOA_CANCEL_OR_CORRECT in VARCHAR2
316 ,P_SECOND_NOA_CODE in VARCHAR2
317 ,P_SECOND_NOA_DESC in VARCHAR2
318 ,P_SECOND_NOA_ID in NUMBER
319 ,P_SECOND_NOA_PA_REQUEST_ID in NUMBER
320 ,P_SERVICE_COMP_DATE in DATE
321 ,P_SUPERVISORY_STATUS in VARCHAR2
322 ,P_TENURE in VARCHAR2
323 ,P_TO_ADJ_BASIC_PAY in NUMBER
324 ,P_TO_BASIC_PAY in NUMBER
325 ,P_TO_GRADE_ID in NUMBER
326 ,P_TO_GRADE_OR_LEVEL in VARCHAR2
327 ,P_TO_JOB_ID in NUMBER
328 ,P_TO_LOCALITY_ADJ in NUMBER
329 ,P_TO_OCC_CODE in VARCHAR2
330 ,P_TO_ORGANIZATION_ID in NUMBER
331 ,P_TO_OTHER_PAY_AMOUNT in NUMBER
332 ,P_TO_AU_OVERTIME in NUMBER
333 ,P_TO_AUO_PREMIUM_PAY_INDICATOR in VARCHAR2
334 ,P_TO_AVAILABILITY_PAY in NUMBER
335 ,P_TO_AP_PREMIUM_PAY_INDICATOR in VARCHAR2
336 ,P_TO_RETENTION_ALLOWANCE in NUMBER
337 ,P_TO_SUPERVISORY_DIFFERENTIAL in NUMBER
338 ,P_TO_STAFFING_DIFFERENTIAL in NUMBER
339 ,P_TO_PAY_BASIS in VARCHAR2
340 ,P_TO_PAY_PLAN in VARCHAR2
341 ,P_TO_POSITION_ID in NUMBER
342 ,P_TO_POSITION_ORG_LINE1 in VARCHAR2
343 ,P_TO_POSITION_ORG_LINE2 in VARCHAR2
344 ,P_TO_POSITION_ORG_LINE3 in VARCHAR2
345 ,P_TO_POSITION_ORG_LINE4 in VARCHAR2
346 ,P_TO_POSITION_ORG_LINE5 in VARCHAR2
347 ,P_TO_POSITION_ORG_LINE6 in VARCHAR2
348 ,P_TO_POSITION_NUMBER in VARCHAR2
349 ,P_TO_POSITION_SEQ_NO in NUMBER
350 ,P_TO_POSITION_TITLE in VARCHAR2
351 ,P_TO_STEP_OR_RATE in VARCHAR2
352 ,P_TO_TOTAL_SALARY in NUMBER
353 ,P_VETERANS_PREFERENCE in VARCHAR2
354 ,P_VETERANS_PREF_FOR_RIF in VARCHAR2
355 ,P_VETERANS_STATUS in VARCHAR2
356 ,P_WORK_SCHEDULE in VARCHAR2
357 ,P_WORK_SCHEDULE_DESC in VARCHAR2
358 ,P_YEAR_DEGREE_ATTAINED in NUMBER
359 ,P_FIRST_NOA_INFORMATION1 in VARCHAR2
360 ,P_FIRST_NOA_INFORMATION2 in VARCHAR2
361 ,P_FIRST_NOA_INFORMATION3 in VARCHAR2
362 ,P_FIRST_NOA_INFORMATION4 in VARCHAR2
363 ,P_FIRST_NOA_INFORMATION5 in VARCHAR2
364 ,P_SECOND_LAC1_INFORMATION1 in VARCHAR2
365 ,P_SECOND_LAC1_INFORMATION2 in VARCHAR2
366 ,P_SECOND_LAC1_INFORMATION3 in VARCHAR2
367 ,P_SECOND_LAC1_INFORMATION4 in VARCHAR2
368 ,P_SECOND_LAC1_INFORMATION5 in VARCHAR2
369 ,P_SECOND_LAC2_INFORMATION1 in VARCHAR2
370 ,P_SECOND_LAC2_INFORMATION2 in VARCHAR2
371 ,P_SECOND_LAC2_INFORMATION3 in VARCHAR2
372 ,P_SECOND_LAC2_INFORMATION4 in VARCHAR2
373 ,P_SECOND_LAC2_INFORMATION5 in VARCHAR2
374 ,P_SECOND_NOA_INFORMATION1 in VARCHAR2
375 ,P_SECOND_NOA_INFORMATION2 in VARCHAR2
376 ,P_SECOND_NOA_INFORMATION3 in VARCHAR2
377 ,P_SECOND_NOA_INFORMATION4 in VARCHAR2
378 ,P_SECOND_NOA_INFORMATION5 in VARCHAR2
379 ,P_FIRST_LAC1_INFORMATION1 in VARCHAR2
380 ,P_FIRST_LAC1_INFORMATION2 in VARCHAR2
381 ,P_FIRST_LAC1_INFORMATION3 in VARCHAR2
382 ,P_FIRST_LAC1_INFORMATION4 in VARCHAR2
383 ,P_FIRST_LAC1_INFORMATION5 in VARCHAR2
384 ,P_FIRST_LAC2_INFORMATION1 in VARCHAR2
385 ,P_FIRST_LAC2_INFORMATION2 in VARCHAR2
386 ,P_FIRST_LAC2_INFORMATION3 in VARCHAR2
387 ,P_FIRST_LAC2_INFORMATION4 in VARCHAR2
388 ,P_FIRST_LAC2_INFORMATION5 in VARCHAR2
389 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
390 ,P_ATTRIBUTE1 in VARCHAR2
391 ,P_ATTRIBUTE2 in VARCHAR2
392 ,P_ATTRIBUTE3 in VARCHAR2
393 ,P_ATTRIBUTE4 in VARCHAR2
394 ,P_ATTRIBUTE5 in VARCHAR2
395 ,P_ATTRIBUTE6 in VARCHAR2
396 ,P_ATTRIBUTE7 in VARCHAR2
397 ,P_ATTRIBUTE8 in VARCHAR2
398 ,P_ATTRIBUTE9 in VARCHAR2
399 ,P_ATTRIBUTE10 in VARCHAR2
400 ,P_ATTRIBUTE11 in VARCHAR2
401 ,P_ATTRIBUTE12 in VARCHAR2
402 ,P_ATTRIBUTE13 in VARCHAR2
403 ,P_ATTRIBUTE14 in VARCHAR2
404 ,P_ATTRIBUTE15 in VARCHAR2
405 ,P_ATTRIBUTE16 in VARCHAR2
406 ,P_ATTRIBUTE17 in VARCHAR2
407 ,P_ATTRIBUTE18 in VARCHAR2
408 ,P_ATTRIBUTE19 in VARCHAR2
409 ,P_ATTRIBUTE20 in VARCHAR2
410 ,P_PRINT_SF50_FLAG in VARCHAR2
411 ,P_PRINTER_NAME in VARCHAR2
412 ,P_U_ATTACHMENT_MODIFIED_FLAG in VARCHAR2
413 ,P_U_APPROVED_FLAG in VARCHAR2
414 ,P_U_USER_NAME_ACTED_ON in VARCHAR2
415 ,P_U_ACTION_TAKEN in VARCHAR2
416 ,P_U_APPROVAL_STATUS in VARCHAR2
417 ,P_I_USER_NAME_ROUTED_TO in VARCHAR2
418 ,P_I_GROUPBOX_ID in NUMBER
419 ,P_I_ROUTING_LIST_ID in NUMBER
420 ,P_I_ROUTING_SEQ_NUMBER in NUMBER
421 ,P_CAPPED_OTHER_PAY in NUMBER
422 ,P_PAR_OBJECT_VERSION_NUMBER in NUMBER
423 ,P_TO_RETENTION_ALLOW_PERCENTAG in NUMBER
424 ,P_TO_SUPERVISORY_DIFF_PERCENTA in NUMBER
425 ,P_TO_STAFFING_DIFF_PERCENTAGE in NUMBER
426 ,P_AWARD_PERCENTAGE in NUMBER
427 ,P_RPA_TYPE in VARCHAR2
428 ,P_MASS_ACTION_ID in NUMBER
429 ,P_MASS_ACTION_ELIGIBLE_FLAG in VARCHAR2
430 ,P_MASS_ACTION_SELECT_FLAG in VARCHAR2
431 ,P_MASS_ACTION_COMMENTS in VARCHAR2
432 )is
433 begin
434 hr_utility.set_location('Entering: GHR_SF52_BK2.UPDATE_SF52_B', 10);
435 hr_utility.set_location(' Leaving: GHR_SF52_BK2.UPDATE_SF52_B', 20);
436 end UPDATE_SF52_B;
437 end GHR_SF52_BK2;