[Home] [Help]
PACKAGE: APPS.GHR_SF52_API
Source
1 Package ghr_sf52_api AUTHID CURRENT_USER as
2 /* $Header: ghparapi.pkh 120.13 2010/04/16 10:40:47 utokachi ship $ */
3 /*#
4 * This package contains the procedures for creating, updating, and deleting a
5 * Request for Personnel Action (RPA).
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Request for Personnel Action
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-------------------------------< create_sf52 >----------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates Request for Personnel Actions (RPA).
18 *
19 * This API creates a pa_request record and two pa_routing_history records, one
23 * name of each routing destination). The API also stores the mandatory remarks
20 * that populates the details regarding the action taken (the user name of the
21 * person who acted on the RPA, that person's roles and actions taken) and a
22 * second that stores the routing information (the user name or the groupbox
24 * required for the specific first_nature_of_action in the pa_remarks table.
25 *
26 * <p><b>Licensing</b><br>
27 * This API is licensed for use with Human Resources.
28 *
29 * <p><b>Prerequisites</b><br>
30 * The Nature of Action and Family records must exist as of the effective date.
31 * A Routing Group must be assigned to the user.
32 *
33 * <p><b>Post Success</b><br>
34 * The API creates the Request for Personnel Action, Personnel Action Remark,
35 * and the Personnel Action Routing History records.
36 *
37 * <p><b>Post Failure</b><br>
38 * The API does not create the Request for Personnel Action, Personnel Action
39 * Remark or the Personnel Action Routing History records and an error is
40 * raised.
41 * @param p_validate If true, then validation alone will be performed and the
42 * database will remain unchanged. If false and all validation checks pass,
43 * then the database will be modified.
44 * @param p_noa_family_code Nature Of Action Family Code
45 * @param p_pa_request_id If p_validate is false, this parameter uniquely
46 * identifies the Request for Personnel Action record Created. If p_validate is
47 * true, sets null.
48 * @param p_routing_group_id {@rep:casecolumn GHR_PA_REQUESTS.ROUTING_GROUP_ID}
49 * @param p_proposed_effective_asap_flag Flag to indicate ASAP for proposed
50 * effective date. Valid Values are Y - Yes, N - No.
51 * @param p_academic_discipline Academic Discipline. Valid values are defined
52 * by 'GHR_US_ACADEMIC_DISCIPLINE' lookup type.
53 * @param p_additional_info_person_id Uniquely identifies the person chosen as
54 * the Additional Information Person.
55 * @param p_additional_info_tel_number {@rep:casecolumn
56 * GHR_PA_REQUESTS.ADDITIONAL_INFO_TEL_NUMBER}
57 * @param p_altered_pa_request_id {@rep:casecolumn
58 * GHR_PA_REQUESTS.ALTERED_PA_REQUEST_ID}
59 * @param p_annuitant_indicator Annuitant Indicator. Valid values are defined
60 * by 'GHR_US_ANNUITANT_INDICATOR' lookup type.
61 * @param p_annuitant_indicator_desc Annuitant Indicator Description. Valid
62 * values are defined by 'GHR_US_ANNUITANT_INDICATOR' lookup meaning.
63 * @param p_appropriation_code1 Appropriation Code1. Valid values are defined
64 * by 'GHR_US_APPROPRIATION_CODE1' lookup type.
65 * @param p_appropriation_code2 Appropriation Code2. Valid values are defined
66 * by 'GHR_US_APPROPRIATION_CODE2' lookup type.
67 * @param p_approval_date {@rep:casecolumn GHR_PA_REQUESTS.APPROVAL_DATE}
68 * @param p_approving_official_full_name {@rep:casecolumn
69 * GHR_PA_REQUESTS.APPROVING_OFFICIAL_FULL_NAME}
70 * @param p_approving_official_work_titl {@rep:casecolumn
71 * GHR_PA_REQUESTS.APPROVING_OFFICIAL_WORK_TITLE}
72 * @param p_authorized_by_person_id Uniquely identifies the Person Authorizing
73 * the Request for Personnel Action.
74 * @param p_authorized_by_title {@rep:casecolumn
75 * GHR_PA_REQUESTS.AUTHORIZED_BY_TITLE}
76 * @param p_award_amount {@rep:casecolumn GHR_PA_REQUESTS.AWARD_AMOUNT}
77 * @param p_award_uom {@rep:casecolumn GHR_PA_REQUESTS.AWARD_UOM}
78 * @param p_bargaining_unit_status Bargaining Unit Status. Valid values are
79 * defined by 'GHR_US_BARG_UNIT_STATUS' lookup type.
80 * @param p_citizenship Citizenship. Valid values are defined by
81 * 'GHR_US_CITIZENSHIP' lookup type.
82 * @param p_concurrence_date {@rep:casecolumn GHR_PA_REQUESTS.CONCURRENCE_DATE}
83 * @param p_custom_pay_calc_flag {@rep:casecolumn
84 * GHR_PA_REQUESTS.CUSTOM_PAY_CALC_FLAG}
85 * @param p_duty_station_code {@rep:casecolumn
86 * GHR_PA_REQUESTS.DUTY_STATION_CODE}
87 * @param p_duty_station_desc {@rep:casecolumn
88 * GHR_PA_REQUESTS.DUTY_STATION_DESC}
89 * @param p_duty_station_id {@rep:casecolumn GHR_PA_REQUESTS.DUTY_STATION_ID}
90 * @param p_duty_station_location_id {@rep:casecolumn
91 * GHR_PA_REQUESTS.DUTY_STATION_LOCATION_ID}
92 * @param p_education_level Education Level. Valid values are defined by
93 * 'GHR_US_EDUCATION_LEVEL' lookup type.
94 * @param p_effective_date Reference date for validating lookup values are
95 * applicable during the start to end active date range. This date does not
96 * determine when the changes take effect.
97 * @param p_employee_assignment_id {@rep:casecolumn
98 * GHR_PA_REQUESTS.EMPLOYEE_ASSIGNMENT_ID}
99 * @param p_employee_date_of_birth {@rep:casecolumn
100 * GHR_PA_REQUESTS.EMPLOYEE_DATE_OF_BIRTH}
101 * @param p_employee_first_name {@rep:casecolumn
102 * GHR_PA_REQUESTS.EMPLOYEE_FIRST_NAME}
103 * @param p_employee_last_name {@rep:casecolumn
104 * GHR_PA_REQUESTS.EMPLOYEE_LAST_NAME}
105 * @param p_employee_middle_names {@rep:casecolumn
106 * GHR_PA_REQUESTS.EMPLOYEE_MIDDLE_NAMES}
107 * @param p_employee_national_identifier {@rep:casecolumn
108 * GHR_PA_REQUESTS.EMPLOYEE_NATIONAL_IDENTIFIER}
109 * @param p_fegli FEGLI. Valid values are defined by 'GHR_US_FEGLI' lookup
110 * type.
111 * @param p_fegli_desc FEGLI Description. Valid values are defined by
112 * 'GHR_US_FEGLI' lookup meaning.
113 * @param p_first_action_la_code1 Legal Authority Code. Valid values are
114 * defined by 'GHR_US_LEGAL_AUTHORITY' lookup type.
115 * @param p_first_action_la_code2 Legal Authority Code. Valid values are
116 * defined by 'GHR_US_LEGAL_AUTHORITY' lookup type.
117 * @param p_first_action_la_desc1 Legal Authority Code description.
118 * @param p_first_action_la_desc2 Legal Authority Code description.
119 * @param p_first_noa_cancel_or_correct {@rep:casecolumn
120 * GHR_PA_REQUESTS.FIRST_NOA_CANCEL_OR_CORRECT}
121 * @param p_first_noa_code {@rep:casecolumn GHR_PA_REQUESTS.FIRST_NOA_CODE}
122 * @param p_first_noa_desc {@rep:casecolumn GHR_PA_REQUESTS.FIRST_NOA_DESC}
123 * @param p_first_noa_id {@rep:casecolumn GHR_PA_REQUESTS.FIRST_NOA_ID}
127 * @param p_forwarding_address_line1 {@rep:casecolumn
124 * @param p_first_noa_pa_request_id {@rep:casecolumn
125 * GHR_PA_REQUESTS.FIRST_NOA_PA_REQUEST_ID}
126 * @param p_flsa_category {@rep:casecolumn GHR_PA_REQUESTS.FLSA_CATEGORY}
128 * GHR_PA_REQUESTS.FORWARDING_ADDRESS_LINE1}
129 * @param p_forwarding_address_line2 {@rep:casecolumn
130 * GHR_PA_REQUESTS.FORWARDING_ADDRESS_LINE2}
131 * @param p_forwarding_address_line3 {@rep:casecolumn
132 * GHR_PA_REQUESTS.FORWARDING_ADDRESS_LINE3}
133 * @param p_forwarding_country {@rep:casecolumn
134 * GHR_PA_REQUESTS.FORWARDING_COUNTRY}
135 * @param p_forwarding_country_short_nam {@rep:casecolumn
136 * GHR_PA_REQUESTS.FORWARDING_COUNTRY_SHORT_NAME}
137 * @param p_forwarding_postal_code {@rep:casecolumn
138 * GHR_PA_REQUESTS.FORWARDING_POSTAL_CODE}
139 * @param p_forwarding_region_2 {@rep:casecolumn
140 * GHR_PA_REQUESTS.FORWARDING_REGION_2}
141 * @param p_forwarding_town_or_city {@rep:casecolumn
142 * GHR_PA_REQUESTS.FORWARDING_TOWN_OR_CITY}
143 * @param p_from_adj_basic_pay {@rep:casecolumn
144 * GHR_PA_REQUESTS.FROM_ADJ_BASIC_PAY}
145 * @param p_from_basic_pay {@rep:casecolumn GHR_PA_REQUESTS.FROM_BASIC_PAY}
146 * @param p_from_grade_or_level {@rep:casecolumn
147 * GHR_PA_REQUESTS.FROM_GRADE_OR_LEVEL}
148 * @param p_from_locality_adj {@rep:casecolumn
149 * GHR_PA_REQUESTS.FROM_LOCALITY_ADJ}
150 * @param p_from_occ_code {@rep:casecolumn GHR_PA_REQUESTS.FROM_OCC_CODE}
151 * @param p_from_other_pay_amount {@rep:casecolumn
152 * GHR_PA_REQUESTS.FROM_OTHER_PAY_AMOUNT}
153 * @param p_from_pay_basis From Pay basis. Valid values are defined by
154 * 'GHR_US_PAY_BASIS' lookup type.
155 * @param p_from_pay_plan {@rep:casecolumn GHR_PA_REQUESTS.FROM_PAY_PLAN}
156 * @param p_from_position_id {@rep:casecolumn GHR_PA_REQUESTS.FROM_POSITION_ID}
157 * @param p_from_position_org_line1 {@rep:casecolumn
158 * GHR_PA_REQUESTS.FROM_POSITION_ORG_LINE1}
159 * @param p_from_position_org_line2 {@rep:casecolumn
160 * GHR_PA_REQUESTS.FROM_POSITION_ORG_LINE2}
161 * @param p_from_position_org_line3 {@rep:casecolumn
162 * GHR_PA_REQUESTS.FROM_POSITION_ORG_LINE3}
163 * @param p_from_position_org_line4 {@rep:casecolumn
164 * GHR_PA_REQUESTS.FROM_POSITION_ORG_LINE4}
165 * @param p_from_position_org_line5 {@rep:casecolumn
166 * GHR_PA_REQUESTS.FROM_POSITION_ORG_LINE5}
167 * @param p_from_position_org_line6 {@rep:casecolumn
168 * GHR_PA_REQUESTS.FROM_POSITION_ORG_LINE6}
169 * @param p_from_position_number {@rep:casecolumn
170 * GHR_PA_REQUESTS.FROM_POSITION_NUMBER}
171 * @param p_from_position_seq_no {@rep:casecolumn
172 * GHR_PA_REQUESTS.FROM_POSITION_SEQ_NO}
173 * @param p_from_position_title {@rep:casecolumn
174 * GHR_PA_REQUESTS.FROM_POSITION_TITLE}
175 * @param p_from_step_or_rate {@rep:casecolumn
176 * GHR_PA_REQUESTS.FROM_STEP_OR_RATE}
177 * @param p_from_total_salary {@rep:casecolumn
178 * GHR_PA_REQUESTS.FROM_TOTAL_SALARY}
179 * @param p_functional_class Functional Class. Valid values are defined by
180 * 'GHR_US_FUNCTIONAL_CLASS' lookup type.
181 * @param p_notepad {@rep:casecolumn GHR_PA_REQUESTS.NOTEPAD}
182 * @param p_part_time_hours {@rep:casecolumn GHR_PA_REQUESTS.PART_TIME_HOURS}
183 * @param p_pay_rate_determinant Pay Rate Determinant. Valid values are defined
184 * by 'GHR_US_PAY_RATE_DETERMINANT' lookup type.
185 * @param p_person_id Identifies the person for whom you create the personnel
186 * action record.
187 * @param p_position_occupied {@rep:casecolumn
188 * GHR_PA_REQUESTS.POSITION_OCCUPIED}
189 * @param p_proposed_effective_date {@rep:casecolumn
190 * GHR_PA_REQUESTS.PROPOSED_EFFECTIVE_DATE}
191 * @param p_requested_by_person_id {@rep:casecolumn
192 * GHR_PA_REQUESTS.REQUESTED_BY_PERSON_ID}
193 * @param p_requested_by_title {@rep:casecolumn
194 * GHR_PA_REQUESTS.REQUESTED_BY_TITLE}
195 * @param p_requested_date {@rep:casecolumn GHR_PA_REQUESTS.REQUESTED_DATE}
196 * @param p_requesting_office_remarks_de Requesting Office remarks description
197 * @param p_requesting_office_remarks_fl Flag to indicate if there are remarks
198 * from the Requesting Office. Valid values are Y - Yes, N - No.
199 * @param p_request_number {@rep:casecolumn GHR_PA_REQUESTS.REQUEST_NUMBER}
200 * @param p_resign_and_retire_reason_des {@rep:casecolumn
201 * GHR_PA_REQUESTS.RESIGN_AND_RETIRE_REASON_DESC}
202 * @param p_retirement_plan Retirement Plan. Valid values are defined by
203 * 'GHR_US_RETIREMENT_PLAN' lookup type.
204 * @param p_retirement_plan_desc Retirement Plan Description. Valid values are
205 * defined by 'GHR_US_RETIREMENT_PLAN' lookup meaning.
206 * @param p_second_action_la_code1 Legal Authority Code. Valid values are
207 * defined by 'GHR_US_LEGAL_AUTHORITY' lookup type.
208 * @param p_second_action_la_code2 Legal Authority Code. Valid values are
209 * defined by 'GHR_US_LEGAL_AUTHORITY' lookup type.
210 * @param p_second_action_la_desc1 Legal Authority Code description.
211 * @param p_second_action_la_desc2 Legal Authority Code description.
212 * @param p_second_noa_cancel_or_correct {@rep:casecolumn
213 * GHR_PA_REQUESTS.SECOND_NOA_CANCEL_OR_CORRECT}
214 * @param p_second_noa_code {@rep:casecolumn GHR_PA_REQUESTS.SECOND_NOA_CODE}
215 * @param p_second_noa_desc {@rep:casecolumn GHR_PA_REQUESTS.SECOND_NOA_DESC}
216 * @param p_second_noa_id {@rep:casecolumn GHR_PA_REQUESTS.SECOND_NOA_ID}
217 * @param p_second_noa_pa_request_id {@rep:casecolumn
218 * GHR_PA_REQUESTS.SECOND_NOA_PA_REQUEST_ID}
219 * @param p_service_comp_date {@rep:casecolumn
220 * GHR_PA_REQUESTS.SERVICE_COMP_DATE}
221 * @param p_supervisory_status Supervisory Status. Valid values are defined by
222 * 'GHR_US_SUPERVISORY_STATUS' lookup type.
223 * @param p_tenure Tenure. Valid values are defined by 'GHR_US_TENURE' lookup
224 * type.
225 * @param p_to_adj_basic_pay {@rep:casecolumn GHR_PA_REQUESTS.TO_ADJ_BASIC_PAY}
226 * @param p_to_basic_pay {@rep:casecolumn GHR_PA_REQUESTS.TO_BASIC_PAY}
227 * @param p_to_grade_id {@rep:casecolumn GHR_PA_REQUESTS.TO_GRADE_ID}
228 * @param p_to_grade_or_level {@rep:casecolumn
229 * GHR_PA_REQUESTS.TO_GRADE_OR_LEVEL}
230 * @param p_to_job_id {@rep:casecolumn GHR_PA_REQUESTS.TO_JOB_ID}
231 * @param p_to_locality_adj {@rep:casecolumn GHR_PA_REQUESTS.TO_LOCALITY_ADJ}
232 * @param p_to_occ_code {@rep:casecolumn GHR_PA_REQUESTS.TO_OCC_CODE}
233 * @param p_to_organization_id {@rep:casecolumn
234 * GHR_PA_REQUESTS.TO_ORGANIZATION_ID}
235 * @param p_to_other_pay_amount {@rep:casecolumn
236 * GHR_PA_REQUESTS.TO_OTHER_PAY_AMOUNT}
237 * @param p_to_au_overtime {@rep:casecolumn GHR_PA_REQUESTS.TO_AU_OVERTIME}
238 * @param p_to_auo_premium_pay_indicator To authorized uncontrollable overtime
239 * premium pay indicator. Valid values are defined by 'GHR_US_PREM_PAY_IND'
240 * lookup type.
241 * @param p_to_availability_pay {@rep:casecolumn
242 * GHR_PA_REQUESTS.TO_AVAILABILITY_PAY}
243 * @param p_to_ap_premium_pay_indicator {@rep:casecolumn
244 * GHR_PA_REQUESTS.TO_AP_PREMIUM_PAY_INDICATOR}
245 * @param p_to_retention_allowance {@rep:casecolumn
246 * GHR_PA_REQUESTS.TO_RETENTION_ALLOWANCE}
247 * @param p_to_supervisory_differential {@rep:casecolumn
248 * GHR_PA_REQUESTS.TO_SUPERVISORY_DIFFERENTIAL}
249 * @param p_to_staffing_differential {@rep:casecolumn
250 * GHR_PA_REQUESTS.TO_STAFFING_DIFFERENTIAL}
254 * @param p_to_position_id {@rep:casecolumn GHR_PA_REQUESTS.TO_POSITION_ID}
251 * @param p_to_pay_basis To Pay basis. Valid values are defined by
252 * 'GHR_US_PAY_BASIS' lookup type.
253 * @param p_to_pay_plan {@rep:casecolumn GHR_PA_REQUESTS.TO_PAY_PLAN}
255 * @param p_to_position_org_line1 {@rep:casecolumn
256 * GHR_PA_REQUESTS.TO_POSITION_ORG_LINE1}
257 * @param p_to_position_org_line2 {@rep:casecolumn
258 * GHR_PA_REQUESTS.TO_POSITION_ORG_LINE2}
259 * @param p_to_position_org_line3 {@rep:casecolumn
260 * GHR_PA_REQUESTS.TO_POSITION_ORG_LINE3}
261 * @param p_to_position_org_line4 {@rep:casecolumn
262 * GHR_PA_REQUESTS.TO_POSITION_ORG_LINE4}
263 * @param p_to_position_org_line5 {@rep:casecolumn
264 * GHR_PA_REQUESTS.TO_POSITION_ORG_LINE5}
265 * @param p_to_position_org_line6 {@rep:casecolumn
266 * GHR_PA_REQUESTS.TO_POSITION_ORG_LINE6}
267 * @param p_to_position_number {@rep:casecolumn
268 * GHR_PA_REQUESTS.TO_POSITION_NUMBER}
269 * @param p_to_position_seq_no {@rep:casecolumn
270 * GHR_PA_REQUESTS.TO_POSITION_SEQ_NO}
271 * @param p_to_position_title {@rep:casecolumn
272 * GHR_PA_REQUESTS.TO_POSITION_TITLE}
273 * @param p_to_step_or_rate {@rep:casecolumn GHR_PA_REQUESTS.TO_STEP_OR_RATE}
274 * @param p_to_total_salary {@rep:casecolumn GHR_PA_REQUESTS.TO_TOTAL_SALARY}
275 * @param p_veterans_preference Veterans Preference. Valid values are defined
276 * by 'GHR_US_VETERANS_PREF' lookup type.
277 * @param p_veterans_pref_for_rif Veterans Preference for Reduction in Force.
278 * Valid values are defined by 'GHR_US_VETERANS_PREF_FOR_RIF' lookup type.
279 * @param p_veterans_status Veterans Status. Valid values are defined by
280 * 'GHR_US_VET_STATUS' lookup type
281 * @param p_work_schedule Work Schedule. Valid values are defined by
282 * 'GHR_US_WORK_SCHEDULE' lookup type.
283 * @param p_work_schedule_desc Work Schedule Description. Valid values are
284 * defined by 'GHR_US_WORK_SCHEDULE' lookup meaning
285 * @param p_year_degree_attained {@rep:casecolumn
286 * GHR_PA_REQUESTS.YEAR_DEGREE_ATTAINED}
287 * @param p_first_noa_information1 First Nature of Action description Insertion
288 * Value1
289 * @param p_first_noa_information2 First Nature of Action description Insertion
290 * Value2
291 * @param p_first_noa_information3 First Nature of Action description Insertion
292 * Value3
293 * @param p_first_noa_information4 First Nature of Action description Insertion
294 * Value4
295 * @param p_first_noa_information5 First Nature of Action description Insertion
296 * Value5
297 * @param p_second_lac1_information1 Second Legal Authority Code1 Description
298 * Insertion Value1
299 * @param p_second_lac1_information2 Second Legal Authority Code1 Description
300 * Insertion Value2
301 * @param p_second_lac1_information3 Second Legal Authority Code1 Description
302 * Insertion Value3
303 * @param p_second_lac1_information4 Second Legal Authority Code1 Description
304 * Insertion Value4
305 * @param p_second_lac1_information5 Second Legal Authority Code1 Description
306 * Insertion Value5
307 * @param p_second_lac2_information1 Second Legal Authority Code2 Description
308 * Insertion Value1
309 * @param p_second_lac2_information2 Second Legal Authority Code2 Description
310 * Insertion Value2
311 * @param p_second_lac2_information3 Second Legal Authority Code2 Description
312 * Insertion Value3
313 * @param p_second_lac2_information4 Second Legal Authority Code2 Description
314 * Insertion Value4
315 * @param p_second_lac2_information5 Second Legal Authority Code2 Description
316 * Insertion Value5
317 * @param p_second_noa_information1 Second Nature of Action description
318 * Insertion Value1
319 * @param p_second_noa_information2 Second Nature of Action description
320 * Insertion Value2
321 * @param p_second_noa_information3 Second Nature of Action description
322 * Insertion Value3
323 * @param p_second_noa_information4 Second Nature of Action description
324 * Insertion Value4
325 * @param p_second_noa_information5 Second Nature of Action description
326 * Insertion Value5
327 * @param p_first_lac1_information1 First Legal Authority Code1 Description
328 * Insertion Value1.
329 * @param p_first_lac1_information2 First Legal Authority Code1 Description
330 * Insertion Value2.
331 * @param p_first_lac1_information3 First Legal Authority Code1 Description
332 * Insertion Value3.
333 * @param p_first_lac1_information4 First Legal Authority Code1 Description
334 * Insertion Value4.
335 * @param p_first_lac1_information5 First Legal Authority Code1 Description
336 * Insertion Value5.
337 * @param p_first_lac2_information1 First Legal Authority Code2 Description
338 * Insertion Value1.
339 * @param p_first_lac2_information2 First Legal Authority Code2 Description
340 * Insertion Value2.
341 * @param p_first_lac2_information3 First Legal Authority Code2 Description
342 * Insertion Value3.
343 * @param p_first_lac2_information4 First Legal Authority Code2 Description
344 * Insertion Value4.
345 * @param p_first_lac2_information5 First Legal Authority Code2 Description
346 * Insertion Value5.
347 * @param p_attribute_category This context value determines which flexfield
348 * structure to use with the descriptive flexfield segments.
349 * @param p_attribute1 Descriptive flexfield segment.
350 * @param p_attribute2 Descriptive flexfield segment.
351 * @param p_attribute3 Descriptive flexfield segment.
352 * @param p_attribute4 Descriptive flexfield segment.
353 * @param p_attribute5 Descriptive flexfield segment.
354 * @param p_attribute6 Descriptive flexfield segment.
355 * @param p_attribute7 Descriptive flexfield segment.
356 * @param p_attribute8 Descriptive flexfield segment.
357 * @param p_attribute9 Descriptive flexfield segment.
358 * @param p_attribute10 Descriptive flexfield segment.
359 * @param p_attribute11 Descriptive flexfield segment.
360 * @param p_attribute12 Descriptive flexfield segment.
364 * @param p_attribute16 Descriptive flexfield segment.
361 * @param p_attribute13 Descriptive flexfield segment.
362 * @param p_attribute14 Descriptive flexfield segment.
363 * @param p_attribute15 Descriptive flexfield segment.
365 * @param p_attribute17 Descriptive flexfield segment.
366 * @param p_attribute18 Descriptive flexfield segment.
367 * @param p_attribute19 Descriptive flexfield segment.
368 * @param p_attribute20 Descriptive flexfield segment.
369 * @param p_print_sf50_flag Print Flag Yes or No.
370 * @param p_printer_name Printer Name
371 * @param p_1_attachment_modified_flag {@rep:casecolumn
372 * GHR_PA_ROUTING_HISTORY.ATTACHMENT_MODIFIED_FLAG}
373 * @param p_1_approved_flag {@rep:casecolumn
374 * GHR_PA_ROUTING_HISTORY.APPROVED_FLAG}
375 * @param p_1_user_name_acted_on The user name of the person who acted on the
376 * Request for Personnel Action (RPA)
377 * @param p_1_action_taken Action taken by the user
378 * @param p_1_approval_status {@rep:casecolumn GHR_PA_REQUESTS.STATUS}
379 * @param p_2_user_name_routed_to The user name of the person to whom the RPA
380 * is routed.
381 * @param p_2_groupbox_id Groupbox to which the Request for Personnel Action
382 * (RPA) is routed. Note: You can designate a groupbox or a user name as a
383 * routing destination.
384 * @param p_2_routing_list_id Routing List to which you are routing the Request
385 * for Personnel Action (RPA)
386 * @param p_2_routing_seq_number Sequence number within the Routing List
387 * @param p_capped_other_pay Other Pay amount after being reduced (capped) due
388 * to hitting the Pay Cap.
389 * @param p_to_retention_allow_percentag {@rep:casecolumn
390 * GHR_PA_REQUESTS.TO_RETENTION_ALLOW_PERCENTAGE}
391 * @param p_to_supervisory_diff_percenta {@rep:casecolumn
392 * GHR_PA_REQUESTS.TO_SUPERVISORY_DIFF_PERCENTAGE}
393 * @param p_to_staffing_diff_percentage {@rep:casecolumn
394 * GHR_PA_REQUESTS.TO_STAFFING_DIFF_PERCENTAGE}
395 * @param p_award_percentage {@rep:casecolumn GHR_PA_REQUESTS.AWARD_PERCENTAGE}
396 * @param p_rpa_type {@rep:casecolumn GHR_PA_REQUESTS.RPA_TYPE}
397 * @param p_mass_action_id {@rep:casecolumn GHR_PA_REQUESTS.MASS_ACTION_ID}
398 * @param p_mass_action_eligible_flag {@rep:casecolumn
399 * GHR_PA_REQUESTS.MASS_ACTION_ELIGIBLE_FLAG}
400 * @param p_mass_action_select_flag {@rep:casecolumn
401 * GHR_PA_REQUESTS.MASS_ACTION_SELECT_FLAG}
402 * @param p_mass_action_comments {@rep:casecolumn
403 * GHR_PA_REQUESTS.MASS_ACTION_COMMENTS}
404 * @param p_payment_option Payment option for the Incentive Family
405 * @param p_award_salary Award Salary used for award calculation
406 * @param p_par_object_version_number If p_validate is false, then sets the
407 * version number of the created pa_request_id. If p_validate is true, then the
408 * value is null.
409 * @param p_1_pa_routing_history_id pa_routing_history_id for the record
410 * containing action details
411 * @param p_1_prh_object_version_number If p_validate is false, then sets the
412 * version number of the created first routing history id. If p_validate is
413 * true, then the value is null.
414 * @param p_2_pa_routing_history_id pa_routing_history_id for the record
415 * containing routing details
416 * @param p_2_prh_object_version_number If p_validate is false, then sets the
417 * version number of the created second routing history id. If p_validate is
418 * true, then the value is null.
419 * @param p_input_pay_rate_determinant Pay Rate Determinant passed to the pay calculation procedure
420 * @param p_from_pay_table_identifier Pay Table ID on the RPA effective date
421 * @param p_to_pay_table_identifier Pay Table ID after pay calculation has completed
422 * @param p_print_back_page If Print Back Page is set to Yes then NPA back page will be printed
423 * @rep:displayname Create Request for Personnel Action
424 * @rep:category BUSINESS_ENTITY GHR_REQ_FOR_PERSONNEL_ACTION
425 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
426 * @rep:scope public
427 * @rep:lifecycle active
428 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
429 */
430 --
431 -- {End Of Comments}
432 --
433 procedure create_sf52
434 (p_validate in boolean default false,
435 p_noa_family_code in varchar2,
436 p_pa_request_id in out nocopy number,
437 p_routing_group_id in number default null,
438 p_proposed_effective_asap_flag in varchar2 default 'N',
439 p_academic_discipline in varchar2 default null,
440 p_additional_info_person_id in number default null,
441 p_additional_info_tel_number in varchar2 default null,
442 p_altered_pa_request_id in number default null,
443 p_annuitant_indicator in varchar2 default null,
444 p_annuitant_indicator_desc in varchar2 default null,
445 p_appropriation_code1 in varchar2 default null,
446 p_appropriation_code2 in varchar2 default null,
447 p_approval_date in date default null,
448 p_approving_official_full_name in varchar2 default null,
449 p_approving_official_work_titl in varchar2 default null,
450 -- p_sf50_approval_date in date default null,
451 -- p_sf50_approving_ofcl_full_nam in varchar2 default null,
452 -- p_sf50_approving_ofcl_work_tit in varchar2 default null,
453 p_authorized_by_person_id in number default null,
454 p_authorized_by_title in varchar2 default null,
455 p_award_amount in number default null,
456 p_award_uom in varchar2 default null,
457 p_bargaining_unit_status in varchar2 default null,
458 p_citizenship in varchar2 default null,
459 p_concurrence_date in date default null,
460 p_custom_pay_calc_flag in varchar2 default null,
461 p_duty_station_code in varchar2 default null,
462 p_duty_station_desc in varchar2 default null,
463 p_duty_station_id in number default null,
464 p_duty_station_location_id in number default null,
465 p_education_level in varchar2 default null,
466 p_effective_date in date default null,
467 p_employee_assignment_id in number default null,
468 p_employee_date_of_birth in date default null,
469 p_employee_first_name in varchar2 default null,
470 p_employee_last_name in varchar2 default null,
471 p_employee_middle_names in varchar2 default null,
472 p_employee_national_identifier in varchar2 default null,
473 p_fegli in varchar2 default null,
474 p_fegli_desc in varchar2 default null,
475 p_first_action_la_code1 in varchar2 default null,
476 p_first_action_la_code2 in varchar2 default null,
477 p_first_action_la_desc1 in varchar2 default null,
478 p_first_action_la_desc2 in varchar2 default null,
479 p_first_noa_cancel_or_correct in varchar2 default null,
480 p_first_noa_code in varchar2 default null,
481 p_first_noa_desc in varchar2 default null,
482 p_first_noa_id in number default null,
483 p_first_noa_pa_request_id in number default null,
484 p_flsa_category in varchar2 default null,
485 p_forwarding_address_line1 in varchar2 default null,
486 p_forwarding_address_line2 in varchar2 default null,
487 p_forwarding_address_line3 in varchar2 default null,
488 p_forwarding_country in varchar2 default null,
489 p_forwarding_country_short_nam in varchar2 default null,
490 p_forwarding_postal_code in varchar2 default null,
491 p_forwarding_region_2 in varchar2 default null,
492 p_forwarding_town_or_city in varchar2 default null,
493 p_from_adj_basic_pay in number default null,
494 p_from_basic_pay in number default null,
495 p_from_grade_or_level in varchar2 default null,
496 p_from_locality_adj in number default null,
497 p_from_occ_code in varchar2 default null,
498 p_from_other_pay_amount in number default null,
499 p_from_pay_basis in varchar2 default null,
500 p_from_pay_plan in varchar2 default null,
501 -- FWFA Changes Bug#4444609
502 p_input_pay_rate_determinant in varchar2 default null,
503 p_from_pay_table_identifier in number default null,
504 -- FWFA Changes
505 p_from_position_id in number default null,
506 p_from_position_org_line1 in varchar2 default null,
507 p_from_position_org_line2 in varchar2 default null,
508 p_from_position_org_line3 in varchar2 default null,
509 p_from_position_org_line4 in varchar2 default null,
510 p_from_position_org_line5 in varchar2 default null,
511 p_from_position_org_line6 in varchar2 default null,
512 p_from_position_number in varchar2 default null,
513 p_from_position_seq_no in number default null,
514 p_from_position_title in varchar2 default null,
515 p_from_step_or_rate in varchar2 default null,
516 p_from_total_salary in number default null,
517 p_functional_class in varchar2 default null,
518 p_notepad in varchar2 default null,
519 p_part_time_hours in number default null,
520 p_pay_rate_determinant in varchar2 default null,
521 p_person_id in number default null,
522 p_position_occupied in varchar2 default null,
523 p_proposed_effective_date in date default null,
524 p_requested_by_person_id in number default null,
525 p_requested_by_title in varchar2 default null,
526 p_requested_date in date default null,
527 p_requesting_office_remarks_de in varchar2 default null,
528 p_requesting_office_remarks_fl in varchar2 default null,
529 p_request_number in varchar2 default null,
530 p_resign_and_retire_reason_des in varchar2 default null,
531 p_retirement_plan in varchar2 default null,
532 p_retirement_plan_desc in varchar2 default null,
533 p_second_action_la_code1 in varchar2 default null,
534 p_second_action_la_code2 in varchar2 default null,
535 p_second_action_la_desc1 in varchar2 default null,
536 p_second_action_la_desc2 in varchar2 default null,
537 p_second_noa_cancel_or_correct in varchar2 default null,
538 p_second_noa_code in varchar2 default null,
539 p_second_noa_desc in varchar2 default null,
540 p_second_noa_id in number default null,
541 p_second_noa_pa_request_id in number default null,
542 p_service_comp_date in date default null,
543 p_supervisory_status in varchar2 default null,
544 p_tenure in varchar2 default null,
545 p_to_adj_basic_pay in number default null,
546 p_to_basic_pay in number default null,
547 p_to_grade_id in number default null,
548 p_to_grade_or_level in varchar2 default null,
549 p_to_job_id in number default null,
550 p_to_locality_adj in number default null,
551 p_to_occ_code in varchar2 default null,
552 p_to_organization_id in number default null,
553 p_to_other_pay_amount in number default null,
554 p_to_au_overtime in number default null,
555 p_to_auo_premium_pay_indicator in varchar2 default null,
556 p_to_availability_pay in number default null,
557 p_to_ap_premium_pay_indicator in varchar2 default null,
558 p_to_retention_allowance in number default null,
559 p_to_supervisory_differential in number default null,
560 p_to_staffing_differential in number default null,
561 p_to_pay_basis in varchar2 default null,
562 p_to_pay_plan in varchar2 default null,
563 -- FWFA Changes Bug#4444609
564 p_to_pay_table_identifier in number default null,
565 -- FWFA Changes
566 p_to_position_id in number default null,
567 p_to_position_org_line1 in varchar2 default null,
568 p_to_position_org_line2 in varchar2 default null,
569 p_to_position_org_line3 in varchar2 default null,
570 p_to_position_org_line4 in varchar2 default null,
571 p_to_position_org_line5 in varchar2 default null,
572 p_to_position_org_line6 in varchar2 default null,
573 p_to_position_number in varchar2 default null,
574 p_to_position_seq_no in number default null,
575 p_to_position_title in varchar2 default null,
576 p_to_step_or_rate in varchar2 default null,
580 p_veterans_status in varchar2 default null,
577 p_to_total_salary in number default null,
578 p_veterans_preference in varchar2 default null,
579 p_veterans_pref_for_rif in varchar2 default null,
581 p_work_schedule in varchar2 default null,
582 p_work_schedule_desc in varchar2 default null,
583 p_year_degree_attained in number default null,
584 p_first_noa_information1 in varchar2 default null,
585 p_first_noa_information2 in varchar2 default null,
586 p_first_noa_information3 in varchar2 default null,
587 p_first_noa_information4 in varchar2 default null,
588 p_first_noa_information5 in varchar2 default null,
589 p_second_lac1_information1 in varchar2 default null,
590 p_second_lac1_information2 in varchar2 default null,
591 p_second_lac1_information3 in varchar2 default null,
592 p_second_lac1_information4 in varchar2 default null,
593 p_second_lac1_information5 in varchar2 default null,
594 p_second_lac2_information1 in varchar2 default null,
595 p_second_lac2_information2 in varchar2 default null,
596 p_second_lac2_information3 in varchar2 default null,
597 p_second_lac2_information4 in varchar2 default null,
598 p_second_lac2_information5 in varchar2 default null,
599 p_second_noa_information1 in varchar2 default null,
600 p_second_noa_information2 in varchar2 default null,
601 p_second_noa_information3 in varchar2 default null,
602 p_second_noa_information4 in varchar2 default null,
603 p_second_noa_information5 in varchar2 default null,
604 p_first_lac1_information1 in varchar2 default null,
605 p_first_lac1_information2 in varchar2 default null,
606 p_first_lac1_information3 in varchar2 default null,
607 p_first_lac1_information4 in varchar2 default null,
608 p_first_lac1_information5 in varchar2 default null,
609 p_first_lac2_information1 in varchar2 default null,
610 p_first_lac2_information2 in varchar2 default null,
611 p_first_lac2_information3 in varchar2 default null,
612 p_first_lac2_information4 in varchar2 default null,
613 p_first_lac2_information5 in varchar2 default null,
614 p_attribute_category in varchar2 default null,
615 p_attribute1 in varchar2 default null,
616 p_attribute2 in varchar2 default null,
617 p_attribute3 in varchar2 default null,
618 p_attribute4 in varchar2 default null,
619 p_attribute5 in varchar2 default null,
620 p_attribute6 in varchar2 default null,
621 p_attribute7 in varchar2 default null,
622 p_attribute8 in varchar2 default null,
623 p_attribute9 in varchar2 default null,
624 p_attribute10 in varchar2 default null,
625 p_attribute11 in varchar2 default null,
626 p_attribute12 in varchar2 default null,
627 p_attribute13 in varchar2 default null,
628 p_attribute14 in varchar2 default null,
629 p_attribute15 in varchar2 default null,
630 p_attribute16 in varchar2 default null,
631 p_attribute17 in varchar2 default null,
632 p_attribute18 in varchar2 default null,
633 p_attribute19 in varchar2 default null,
634 p_attribute20 in varchar2 default null,
635 p_print_sf50_flag in varchar2 default 'N',
636 p_printer_name in varchar2 default null,
637 p_print_back_page in varchar2 default 'Y',
638 p_1_attachment_modified_flag in varchar2 default 'N',
639 p_1_approved_flag in varchar2 default null,
640 p_1_user_name_acted_on in varchar2 default null,
641 p_1_action_taken in varchar2 default null,
642 p_1_approval_status in varchar2 default null,
643 p_2_user_name_routed_to in varchar2 default null,
644 p_2_groupbox_id in number default null,
645 p_2_routing_list_id in number default null,
646 p_2_routing_seq_number in number default null,
647 p_capped_other_pay in number default null,
648 p_to_retention_allow_percentag in number default null,
649 p_to_supervisory_diff_percenta in number default null,
650 p_to_staffing_diff_percentage in number default null,
651 p_award_percentage in number default null,
652 p_rpa_type in varchar2 default null,
653 p_mass_action_id in number default null,
654 p_mass_action_eligible_flag in varchar2 default null,
655 p_mass_action_select_flag in varchar2 default null,
656 p_mass_action_comments in varchar2 default null,
657 -- Bug#4486823 RRR Changes
658 p_payment_option in varchar2 default null,
659 p_award_salary in number default null,
660 -- Bug#4486823 RRR Changes
661 p_par_object_version_number out nocopy number,
662 p_1_pa_routing_history_id out nocopy number,
663 p_1_prh_object_version_number out nocopy number,
664 p_2_pa_routing_history_id out nocopy number,
665 p_2_prh_object_version_number out nocopy number
666 );
667 --
668 -- ----------------------------------------------------------------------------
669 -- |-------------------------------< update_sf52 >----------------------------|
670 -- ----------------------------------------------------------------------------
671 --
672 -- {Start Of Comments}
673 /*#
674 * This API updates the Request for Personnel Action (RPA).
675 *
676 * This API updates the pa_request record and the latest pa_routing_history
677 * record with details about the action taken, including the user name of the
678 * person who acted on the Request for Personnel Action (RPA), the person's
679 * roles and the action taken. The API creates a new record to store the
680 * routing information for the Request for Personnel Action (RPA), including
681 * the user name or the groupbox for each time the Request for Personnel Action
682 * (RPA) is routed. If the first_nature_of_action_id changes, the API deletes
683 * the mandatory remarks for the former first_nature_of_action_id from the
684 * pa_remarks table, and then populates the pa_remarks table with the set of
685 * mandatory remarks for the new first_nature_of_action_id.
686 *
687 * <p><b>Licensing</b><br>
688 * This API is licensed for use with Human Resources.
689 *
690 * <p><b>Prerequisites</b><br>
691 * A parent Request for Personnel Action record must exist in ghr_pa_requests.
692 *
693 * <p><b>Post Success</b><br>
694 * The API updates the Request for Personnel Action, and inserts/updates the
695 * Personnel Action Remark and the Personnel Action Routing History records as
696 * required.
697 *
698 * <p><b>Post Failure</b><br>
699 * The API does not update the Request for Personnel Action, Personnel Action
700 * Remark, or the Personnel Action Routing History records and an error is
701 * raised.
702 * @param p_validate If true, then validation alone will be performed and the
703 * database will remain unchanged. If false and all validation checks pass,
704 * then the database will be modified.
705 * @param p_pa_request_id Uniquely identifies the Request for Personnel Action.
706 * @param p_noa_family_code {@rep:casecolumn GHR_PA_REQUESTS.NOA_FAMILY_CODE}
707 * @param p_routing_group_id {@rep:casecolumn GHR_PA_REQUESTS.ROUTING_GROUP_ID}
708 * @param p_par_object_version_number Pass in the current version number of the
709 * pa_request_id that you are updating. When the API completes, if p_validate
710 * is false, sets the new version number of the updated pa_request_id. If
711 * p_validate is true, sets the same value passed in.
712 * @param p_proposed_effective_asap_flag Flag to indicate ASAP for proposed
713 * effective date. Valid Values are Y - Yes, N - No.
714 * @param p_academic_discipline Academic Discipline. Valid values are defined
715 * by 'GHR_US_ACADEMIC_DISCIPLINE' lookup type.
716 * @param p_additional_info_person_id Uniquely identifies the Person chosen as
717 * the Additional Information Person.
718 * @param p_additional_info_tel_number {@rep:casecolumn
719 * GHR_PA_REQUESTS.ADDITIONAL_INFO_TEL_NUMBER}
720 * @param p_altered_pa_request_id {@rep:casecolumn
721 * GHR_PA_REQUESTS.ALTERED_PA_REQUEST_ID}
722 * @param p_annuitant_indicator Annuitant Indicator. Valid values are defined
723 * by 'GHR_US_ANNUITANT_INDICATOR' lookup type.
724 * @param p_annuitant_indicator_desc Annuitant Indicator Description. Valid
725 * values are defined by 'GHR_US_ANNUITANT_INDICATOR' lookup meaning.
726 * @param p_appropriation_code1 Appropriation Code1. Valid values are defined
727 * by 'GHR_US_APPROPRIATION_CODE1' lookup type.
728 * @param p_appropriation_code2 Appropriation Code2. Valid values are defined
729 * by 'GHR_US_APPROPRIATION_CODE2' lookup type.
730 * @param p_approval_date {@rep:casecolumn GHR_PA_REQUESTS.APPROVAL_DATE}
731 * @param p_approving_official_full_name {@rep:casecolumn
732 * GHR_PA_REQUESTS.APPROVING_OFFICIAL_FULL_NAME}
733 * @param p_approving_official_work_titl {@rep:casecolumn
734 * GHR_PA_REQUESTS.APPROVING_OFFICIAL_WORK_TITLE}
735 * @param p_authorized_by_person_id Uniquely identifies the person authorizing
736 * the Request for Personnel Action.
737 * @param p_authorized_by_title {@rep:casecolumn
738 * GHR_PA_REQUESTS.AUTHORIZED_BY_TITLE}
739 * @param p_award_amount {@rep:casecolumn GHR_PA_REQUESTS.AWARD_AMOUNT}
740 * @param p_award_uom {@rep:casecolumn GHR_PA_REQUESTS.AWARD_UOM}
741 * @param p_bargaining_unit_status Bargaining Unit Status. Valid values are
742 * defined by 'GHR_US_BARG_UNIT_STATUS' lookup type.
743 * @param p_citizenship Citizenship. Valid values are defined by
744 * 'GHR_US_CITIZENSHIP' lookup type.
745 * @param p_concurrence_date {@rep:casecolumn GHR_PA_REQUESTS.CONCURRENCE_DATE}
746 * @param p_custom_pay_calc_flag {@rep:casecolumn
747 * GHR_PA_REQUESTS.CUSTOM_PAY_CALC_FLAG}
748 * @param p_duty_station_code {@rep:casecolumn
749 * GHR_PA_REQUESTS.DUTY_STATION_CODE}
750 * @param p_duty_station_desc {@rep:casecolumn
754 * GHR_PA_REQUESTS.DUTY_STATION_LOCATION_ID}
751 * GHR_PA_REQUESTS.DUTY_STATION_DESC}
752 * @param p_duty_station_id {@rep:casecolumn GHR_PA_REQUESTS.DUTY_STATION_ID}
753 * @param p_duty_station_location_id {@rep:casecolumn
755 * @param p_education_level Education Level. Valid values are defined by
756 * 'GHR_US_EDUCATION_LEVEL' lookup type.
757 * @param p_effective_date Reference date for validating lookup values are
758 * applicable during the start to end active date range. This date does not
759 * determine when the changes take effect.
760 * @param p_employee_assignment_id {@rep:casecolumn
761 * GHR_PA_REQUESTS.EMPLOYEE_ASSIGNMENT_ID}
762 * @param p_employee_date_of_birth {@rep:casecolumn
763 * GHR_PA_REQUESTS.EMPLOYEE_DATE_OF_BIRTH}
764 * @param p_employee_first_name {@rep:casecolumn
765 * GHR_PA_REQUESTS.EMPLOYEE_FIRST_NAME}
766 * @param p_employee_last_name {@rep:casecolumn
767 * GHR_PA_REQUESTS.EMPLOYEE_LAST_NAME}
768 * @param p_employee_middle_names {@rep:casecolumn
769 * GHR_PA_REQUESTS.EMPLOYEE_MIDDLE_NAMES}
770 * @param p_employee_national_identifier {@rep:casecolumn
771 * GHR_PA_REQUESTS.EMPLOYEE_NATIONAL_IDENTIFIER}
772 * @param p_fegli FEGLI. Valid values are defined by 'GHR_US_FEGLI' lookup
773 * type.
774 * @param p_fegli_desc FEGLI Description. Valid values are defined by
775 * 'GHR_US_FEGLI' lookup meaning.
776 * @param p_first_action_la_code1 Legal Authority Code. Valid values are
777 * defined by 'GHR_US_LEGAL_AUTHORITY' lookup type.
778 * @param p_first_action_la_code2 Legal Authority Code. Valid values are
779 * defined by 'GHR_US_LEGAL_AUTHORITY' lookup type.
780 * @param p_first_action_la_desc1 Legal Authority Code description.
781 * @param p_first_action_la_desc2 Legal Authority Code description.
782 * @param p_first_noa_cancel_or_correct {@rep:casecolumn
783 * GHR_PA_REQUESTS.FIRST_NOA_CANCEL_OR_CORRECT}
784 * @param p_first_noa_code {@rep:casecolumn GHR_PA_REQUESTS.FIRST_NOA_CODE}
785 * @param p_first_noa_desc {@rep:casecolumn GHR_PA_REQUESTS.FIRST_NOA_DESC}
786 * @param p_first_noa_id {@rep:casecolumn GHR_PA_REQUESTS.FIRST_NOA_ID}
787 * @param p_first_noa_pa_request_id {@rep:casecolumn
788 * GHR_PA_REQUESTS.FIRST_NOA_PA_REQUEST_ID}
789 * @param p_flsa_category FLSA Category. Valid values are defined by
790 * 'GHR_US_FLSA_CATEGORY' lookup type.
791 * @param p_forwarding_address_line1 {@rep:casecolumn
792 * GHR_PA_REQUESTS.FORWARDING_ADDRESS_LINE1}
793 * @param p_forwarding_address_line2 {@rep:casecolumn
794 * GHR_PA_REQUESTS.FORWARDING_ADDRESS_LINE2}
795 * @param p_forwarding_address_line3 {@rep:casecolumn
796 * GHR_PA_REQUESTS.FORWARDING_ADDRESS_LINE3}
797 * @param p_forwarding_country {@rep:casecolumn
798 * GHR_PA_REQUESTS.FORWARDING_COUNTRY}
799 * @param p_forwarding_country_short_nam {@rep:casecolumn
800 * GHR_PA_REQUESTS.FORWARDING_COUNTRY_SHORT_NAME}
801 * @param p_forwarding_postal_code {@rep:casecolumn
802 * GHR_PA_REQUESTS.FORWARDING_POSTAL_CODE}
803 * @param p_forwarding_region_2 {@rep:casecolumn
804 * GHR_PA_REQUESTS.FORWARDING_REGION_2}
805 * @param p_forwarding_town_or_city {@rep:casecolumn
806 * GHR_PA_REQUESTS.FORWARDING_TOWN_OR_CITY}
807 * @param p_from_adj_basic_pay {@rep:casecolumn
808 * GHR_PA_REQUESTS.FROM_ADJ_BASIC_PAY}
809 * @param p_from_basic_pay {@rep:casecolumn GHR_PA_REQUESTS.FROM_BASIC_PAY}
810 * @param p_from_grade_or_level {@rep:casecolumn
811 * GHR_PA_REQUESTS.FROM_GRADE_OR_LEVEL}
812 * @param p_from_locality_adj {@rep:casecolumn
813 * GHR_PA_REQUESTS.FROM_LOCALITY_ADJ}
814 * @param p_from_occ_code {@rep:casecolumn GHR_PA_REQUESTS.FROM_OCC_CODE}
815 * @param p_from_other_pay_amount {@rep:casecolumn
816 * GHR_PA_REQUESTS.FROM_OTHER_PAY_AMOUNT}
817 * @param p_from_pay_basis From Pay basis. Valid values are defined by
818 * 'GHR_US_PAY_BASIS' lookup type.
819 * @param p_from_pay_plan {@rep:casecolumn GHR_PA_REQUESTS.FROM_PAY_PLAN}
820 * @param p_from_position_id {@rep:casecolumn GHR_PA_REQUESTS.FROM_POSITION_ID}
821 * @param p_from_position_org_line1 {@rep:casecolumn
822 * GHR_PA_REQUESTS.FROM_POSITION_ORG_LINE1}
823 * @param p_from_position_org_line2 {@rep:casecolumn
824 * GHR_PA_REQUESTS.FROM_POSITION_ORG_LINE2}
825 * @param p_from_position_org_line3 {@rep:casecolumn
826 * GHR_PA_REQUESTS.FROM_POSITION_ORG_LINE3}
827 * @param p_from_position_org_line4 {@rep:casecolumn
828 * GHR_PA_REQUESTS.FROM_POSITION_ORG_LINE4}
829 * @param p_from_position_org_line5 {@rep:casecolumn
830 * GHR_PA_REQUESTS.FROM_POSITION_ORG_LINE5}
831 * @param p_from_position_org_line6 {@rep:casecolumn
832 * GHR_PA_REQUESTS.FROM_POSITION_ORG_LINE6}
833 * @param p_from_position_number {@rep:casecolumn
834 * GHR_PA_REQUESTS.FROM_POSITION_NUMBER}
835 * @param p_from_position_seq_no {@rep:casecolumn
836 * GHR_PA_REQUESTS.FROM_POSITION_SEQ_NO}
837 * @param p_from_position_title {@rep:casecolumn
838 * GHR_PA_REQUESTS.FROM_POSITION_TITLE}
839 * @param p_from_step_or_rate {@rep:casecolumn
840 * GHR_PA_REQUESTS.FROM_STEP_OR_RATE}
841 * @param p_from_total_salary {@rep:casecolumn
842 * GHR_PA_REQUESTS.FROM_TOTAL_SALARY}
843 * @param p_functional_class Functional Class. Valid values are defined by
844 * 'GHR_US_FUNCTIONAL_CLASS' lookup type.
845 * @param p_notepad {@rep:casecolumn GHR_PA_REQUESTS.NOTEPAD}
846 * @param p_part_time_hours {@rep:casecolumn GHR_PA_REQUESTS.PART_TIME_HOURS}
847 * @param p_pay_rate_determinant Pay Rate Determinant. Valid values are defined
848 * by 'GHR_US_PAY_RATE_DETERMINANT' lookup type.
849 * @param p_person_id Uniquely identifies the Person for whom you update the
850 * Request for Personnel Action record.
851 * @param p_position_occupied {@rep:casecolumn
852 * GHR_PA_REQUESTS.POSITION_OCCUPIED}
853 * @param p_proposed_effective_date {@rep:casecolumn
854 * GHR_PA_REQUESTS.PROPOSED_EFFECTIVE_DATE}
855 * @param p_requested_by_person_id {@rep:casecolumn
856 * GHR_PA_REQUESTS.REQUESTED_BY_PERSON_ID}
857 * @param p_requested_by_title {@rep:casecolumn
858 * GHR_PA_REQUESTS.REQUESTED_BY_TITLE}
859 * @param p_requested_date {@rep:casecolumn GHR_PA_REQUESTS.REQUESTED_DATE}
860 * @param p_requesting_office_remarks_de Requesting Office remarks description
861 * @param p_requesting_office_remarks_fl Flag to indicate if there are remarks
862 * from the Requesting Office. Valid values are Y - Yes, N - No.
863 * @param p_request_number {@rep:casecolumn GHR_PA_REQUESTS.REQUEST_NUMBER}
864 * @param p_resign_and_retire_reason_des {@rep:casecolumn
865 * GHR_PA_REQUESTS.RESIGN_AND_RETIRE_REASON_DESC}
866 * @param p_retirement_plan Retirement Plan. Valid values are defined by
867 * 'GHR_US_RETIREMENT_PLAN' lookup type.
868 * @param p_retirement_plan_desc Retirement Plan Description. Valid values are
869 * defined by 'GHR_US_RETIREMENT_PLAN' lookup meaning.
870 * @param p_second_action_la_code1 Legal Authority lookup code. Valid values
871 * are defined by 'GHR_US_LEGAL_AUTHORITY' lookup type.
872 * @param p_second_action_la_code2 Legal Authority lookup code. Valid values
873 * are defined by 'GHR_US_LEGAL_AUTHORITY' lookup type.
874 * @param p_second_action_la_desc1 Legal Authority Code description.
875 * @param p_second_action_la_desc2 Legal Authority Code description.
876 * @param p_second_noa_cancel_or_correct {@rep:casecolumn
877 * GHR_PA_REQUESTS.SECOND_NOA_CANCEL_OR_CORRECT}
878 * @param p_second_noa_code {@rep:casecolumn GHR_PA_REQUESTS.SECOND_NOA_CODE}
879 * @param p_second_noa_desc {@rep:casecolumn GHR_PA_REQUESTS.SECOND_NOA_DESC}
880 * @param p_second_noa_id {@rep:casecolumn GHR_PA_REQUESTS.SECOND_NOA_ID}
881 * @param p_second_noa_pa_request_id {@rep:casecolumn
882 * GHR_PA_REQUESTS.SECOND_NOA_PA_REQUEST_ID}
883 * @param p_service_comp_date {@rep:casecolumn
884 * GHR_PA_REQUESTS.SERVICE_COMP_DATE}
885 * @param p_supervisory_status Supervisory Status. Valid values are defined by
886 * 'GHR_US_SUPERVISORY_STATUS' lookup type.
887 * @param p_tenure Tenure. Valid values are defined by 'GHR_US_TENURE' lookup
888 * type.
889 * @param p_to_adj_basic_pay {@rep:casecolumn GHR_PA_REQUESTS.TO_ADJ_BASIC_PAY}
890 * @param p_to_basic_pay {@rep:casecolumn GHR_PA_REQUESTS.TO_BASIC_PAY}
891 * @param p_to_grade_id {@rep:casecolumn GHR_PA_REQUESTS.TO_GRADE_ID}
892 * @param p_to_grade_or_level {@rep:casecolumn
893 * GHR_PA_REQUESTS.TO_GRADE_OR_LEVEL}
894 * @param p_to_job_id {@rep:casecolumn GHR_PA_REQUESTS.TO_JOB_ID}
895 * @param p_to_locality_adj {@rep:casecolumn GHR_PA_REQUESTS.TO_LOCALITY_ADJ}
896 * @param p_to_occ_code {@rep:casecolumn GHR_PA_REQUESTS.TO_OCC_CODE}
897 * @param p_to_organization_id {@rep:casecolumn
898 * GHR_PA_REQUESTS.TO_ORGANIZATION_ID}
899 * @param p_to_other_pay_amount {@rep:casecolumn
900 * GHR_PA_REQUESTS.TO_OTHER_PAY_AMOUNT}
901 * @param p_to_au_overtime {@rep:casecolumn GHR_PA_REQUESTS.TO_AU_OVERTIME}
902 * @param p_to_auo_premium_pay_indicator To authorized uncontrollable overtime
903 * premium pay indicator. Valid values are defined by 'GHR_US_PREM_PAY_IND'
904 * lookup type.
905 * @param p_to_availability_pay {@rep:casecolumn
906 * GHR_PA_REQUESTS.TO_AVAILABILITY_PAY}
907 * @param p_to_ap_premium_pay_indicator {@rep:casecolumn
908 * GHR_PA_REQUESTS.TO_AP_PREMIUM_PAY_INDICATOR}
909 * @param p_to_retention_allowance {@rep:casecolumn
910 * GHR_PA_REQUESTS.TO_RETENTION_ALLOWANCE}
911 * @param p_to_supervisory_differential {@rep:casecolumn
912 * GHR_PA_REQUESTS.TO_SUPERVISORY_DIFFERENTIAL}
913 * @param p_to_staffing_differential {@rep:casecolumn
914 * GHR_PA_REQUESTS.TO_STAFFING_DIFFERENTIAL}
915 * @param p_to_pay_basis To Pay basis. Valid values are defined by
916 * 'GHR_US_PAY_BASIS' lookup type.
917 * @param p_to_pay_plan {@rep:casecolumn GHR_PA_REQUESTS.TO_PAY_PLAN}
918 * @param p_to_position_id {@rep:casecolumn GHR_PA_REQUESTS.TO_POSITION_ID}
919 * @param p_to_position_org_line1 {@rep:casecolumn
920 * GHR_PA_REQUESTS.TO_POSITION_ORG_LINE1}
921 * @param p_to_position_org_line2 {@rep:casecolumn
922 * GHR_PA_REQUESTS.TO_POSITION_ORG_LINE2}
923 * @param p_to_position_org_line3 {@rep:casecolumn
924 * GHR_PA_REQUESTS.TO_POSITION_ORG_LINE3}
925 * @param p_to_position_org_line4 {@rep:casecolumn
926 * GHR_PA_REQUESTS.TO_POSITION_ORG_LINE4}
927 * @param p_to_position_org_line5 {@rep:casecolumn
928 * GHR_PA_REQUESTS.TO_POSITION_ORG_LINE5}
929 * @param p_to_position_org_line6 {@rep:casecolumn
930 * GHR_PA_REQUESTS.TO_POSITION_ORG_LINE6}
931 * @param p_to_position_number {@rep:casecolumn
932 * GHR_PA_REQUESTS.TO_POSITION_NUMBER}
933 * @param p_to_position_seq_no {@rep:casecolumn
934 * GHR_PA_REQUESTS.TO_POSITION_SEQ_NO}
935 * @param p_to_position_title {@rep:casecolumn
936 * GHR_PA_REQUESTS.TO_POSITION_TITLE}
937 * @param p_to_step_or_rate {@rep:casecolumn GHR_PA_REQUESTS.TO_STEP_OR_RATE}
938 * @param p_to_total_salary {@rep:casecolumn GHR_PA_REQUESTS.TO_TOTAL_SALARY}
939 * @param p_veterans_preference Veterans Preference. Valid values are defined
940 * by 'GHR_US_VETERANS_PREF' lookup type.
941 * @param p_veterans_pref_for_rif Veterans Preference for Reduction in Force.
942 * Valid values are defined by 'GHR_US_VETERANS_PREF_FOR_RIF' lookup type.
943 * @param p_veterans_status Veterans Status. Valid values are defined by
944 * 'GHR_US_VET_STATUS' lookup type
945 * @param p_work_schedule Work Schedule. Valid values are defined by
946 * 'GHR_US_WORK_SCHEDULE' lookup type.
947 * @param p_work_schedule_desc Work Schedule Description. Valid values are
948 * defined by 'GHR_US_WORK_SCHEDULE' lookup meaning
949 * @param p_year_degree_attained {@rep:casecolumn
950 * GHR_PA_REQUESTS.YEAR_DEGREE_ATTAINED}
951 * @param p_first_noa_information1 First Nature of Action description Insertion
952 * Value1
953 * @param p_first_noa_information2 First Nature of Action description Insertion
954 * Value2
955 * @param p_first_noa_information3 First Nature of Action description Insertion
956 * Value3
957 * @param p_first_noa_information4 First Nature of Action description Insertion
958 * Value4
959 * @param p_first_noa_information5 First Nature of Action description Insertion
960 * Value5
961 * @param p_second_lac1_information1 Second Legal Authority Code1 Description
962 * Insertion Value1
963 * @param p_second_lac1_information2 Second Legal Authority Code1 Description
964 * Insertion Value2
965 * @param p_second_lac1_information3 Second Legal Authority Code1 Description
966 * Insertion Value3
967 * @param p_second_lac1_information4 Second Legal Authority Code1 Description
968 * Insertion Value4
969 * @param p_second_lac1_information5 Second Legal Authority Code1 Description
970 * Insertion Value5
971 * @param p_second_lac2_information1 Second Legal Authority Code2 Description
972 * Insertion Value1
973 * @param p_second_lac2_information2 Second Legal Authority Code2 Description
974 * Insertion Value2
975 * @param p_second_lac2_information3 Second Legal Authority Code2 Description
976 * Insertion Value3
977 * @param p_second_lac2_information4 Second Legal Authority Code2 Description
978 * Insertion Value4
979 * @param p_second_lac2_information5 Second Legal Authority Code2 Description
980 * Insertion Value5
981 * @param p_second_noa_information1 Second Nature of Action description
982 * Insertion Value1
983 * @param p_second_noa_information2 Second Nature of Action description
984 * Insertion Value2
985 * @param p_second_noa_information3 Second Nature of Action description
986 * Insertion Value3
987 * @param p_second_noa_information4 Second Nature of Action description
988 * Insertion Value4
989 * @param p_second_noa_information5 Second Nature of Action description
990 * Insertion Value5
991 * @param p_first_lac1_information1 First Legal Authority Code1 Description
992 * Insertion Value1.
993 * @param p_first_lac1_information2 First Legal Authority Code1 Description
994 * Insertion Value2.
995 * @param p_first_lac1_information3 First Legal Authority Code1 Description
996 * Insertion Value3.
997 * @param p_first_lac1_information4 First Legal Authority Code1 Description
998 * Insertion Value4.
999 * @param p_first_lac1_information5 First Legal Authority Code1 Description
1000 * Insertion Value5.
1001 * @param p_first_lac2_information1 First Legal Authority Code2 Description
1002 * Insertion Value1.
1003 * @param p_first_lac2_information2 First Legal Authority Code2 Description
1004 * Insertion Value2.
1005 * @param p_first_lac2_information3 First Legal Authority Code2 Description
1006 * Insertion Value3.
1007 * @param p_first_lac2_information4 First Legal Authority Code2 Description
1008 * Insertion Value4.
1009 * @param p_first_lac2_information5 First Legal Authority Code2 Description
1010 * Insertion Value5.
1011 * @param p_attribute_category This context value determines which flexfield
1012 * structure to use with the descriptive flexfield segments.
1013 * @param p_attribute1 Descriptive flexfield segment.
1014 * @param p_attribute2 Descriptive flexfield segment.
1015 * @param p_attribute3 Descriptive flexfield segment.
1016 * @param p_attribute4 Descriptive flexfield segment.
1017 * @param p_attribute5 Descriptive flexfield segment.
1018 * @param p_attribute6 Descriptive flexfield segment.
1019 * @param p_attribute7 Descriptive flexfield segment.
1020 * @param p_attribute8 Descriptive flexfield segment.
1021 * @param p_attribute9 Descriptive flexfield segment.
1022 * @param p_attribute10 Descriptive flexfield segment.
1023 * @param p_attribute11 Descriptive flexfield segment.
1024 * @param p_attribute12 Descriptive flexfield segment.
1025 * @param p_attribute13 Descriptive flexfield segment.
1026 * @param p_attribute14 Descriptive flexfield segment.
1027 * @param p_attribute15 Descriptive flexfield segment.
1028 * @param p_attribute16 Descriptive flexfield segment.
1029 * @param p_attribute17 Descriptive flexfield segment.
1030 * @param p_attribute18 Descriptive flexfield segment.
1031 * @param p_attribute19 Descriptive flexfield segment.
1032 * @param p_attribute20 Descriptive flexfield segment.
1033 * @param p_print_sf50_flag Print Flag Yes or No.
1034 * @param p_printer_name Printer Name
1035 * @param p_u_attachment_modified_flag {@rep:casecolumn
1036 * GHR_PA_ROUTING_HISTORY.ATTACHMENT_MODIFIED_FLAG}
1037 * @param p_u_approved_flag {@rep:casecolumn
1038 * GHR_PA_ROUTING_HISTORY.APPROVED_FLAG}
1039 * @param p_u_user_name_acted_on User name of the person who acted on the
1040 * Request for Personnel Action (RPA)
1041 * @param p_u_action_taken Action taken by the user
1042 * @param p_u_approval_status {@rep:casecolumn GHR_PA_REQUESTS.STATUS}
1043 * @param p_i_user_name_routed_to The user name of the person to whom the RPA
1044 * is routed.
1045 * @param p_i_groupbox_id Groupbox to which the Request for Personnel Action
1046 * (RPA) is routed. Note: You can designate a groupbox or a user name as a
1047 * routing destination.
1048 * @param p_i_routing_list_id Routing List to which you are routing the Request
1049 * for Personnel Action (RPA)
1050 * @param p_i_routing_seq_number Sequence number within the Routing list
1051 * @param p_capped_other_pay Other Pay amount after being reduced (capped) due
1052 * to hitting the Pay Cap.
1053 * @param p_to_retention_allow_percentag {@rep:casecolumn
1054 * GHR_PA_REQUESTS.TO_RETENTION_ALLOW_PERCENTAGE}
1055 * @param p_to_supervisory_diff_percenta {@rep:casecolumn
1056 * GHR_PA_REQUESTS.TO_SUPERVISORY_DIFF_PERCENTAGE}
1057 * @param p_to_staffing_diff_percentage {@rep:casecolumn
1058 * GHR_PA_REQUESTS.TO_STAFFING_DIFF_PERCENTAGE}
1059 * @param p_award_percentage {@rep:casecolumn GHR_PA_REQUESTS.AWARD_PERCENTAGE}
1060 * @param p_rpa_type {@rep:casecolumn GHR_PA_REQUESTS.RPA_TYPE}
1061 * @param p_mass_action_id {@rep:casecolumn GHR_PA_REQUESTS.MASS_ACTION_ID}
1062 * @param p_mass_action_eligible_flag {@rep:casecolumn
1063 * GHR_PA_REQUESTS.MASS_ACTION_ELIGIBLE_FLAG}
1064 * @param p_mass_action_select_flag {@rep:casecolumn
1065 * GHR_PA_REQUESTS.MASS_ACTION_SELECT_FLAG}
1066 * @param p_mass_action_comments {@rep:casecolumn
1067 * GHR_PA_REQUESTS.MASS_ACTION_COMMENTS}
1068 * @param p_payment_option Payment option for the Incentive Family
1069 * @param p_award_salary Award Salary used for award calculation
1070 * @param p_u_prh_object_version_number If p_validate is false, then set to the
1071 * version number of the updated routing history that contains the action
1072 * details. If p_validate is true, then the value of the version number is
1073 * retained from the routing record containing the original routing details.
1074 * @param p_i_pa_routing_history_id If p_validate is false, then set to the
1075 * updated routing history that contains the action details. If p_validate is
1076 * true , it is set to null.
1077 * @param p_i_prh_object_version_number If p_validate is false, then set to the
1078 * version_number of the routing history record that contains the routing
1079 * details. If p_validate is true, it is set to null.
1080 * @param p_input_pay_rate_determinant Pay Rate Determinant passed to the pay calculation procedure
1081 * @param p_from_pay_table_identifier Pay Table ID on the RPA effective date
1082 * @param p_to_pay_table_identifier Pay Table ID after pay calculation has completed
1083 * @param p_print_back_page If Print Back Page is set to Yes then NPA back page will be printed
1084 * @rep:displayname Update Request for Personnel Action
1085 * @rep:category BUSINESS_ENTITY GHR_REQ_FOR_PERSONNEL_ACTION
1086 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1087 * @rep:scope public
1088 * @rep:lifecycle active
1089 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1090 */
1091 --
1092 -- {End Of Comments}
1093 --
1094 procedure update_sf52
1095 (p_validate in boolean default false,
1096 p_pa_request_id in number,
1097 -- p_pa_notification_id in number default hr_api.g_number,
1098 p_noa_family_code in varchar2 default hr_api.g_varchar2,
1099 p_routing_group_id in number default hr_api.g_number,
1100 p_par_object_version_number in out nocopy number,
1101 p_proposed_effective_asap_flag in varchar2 default hr_api.g_varchar2,
1102 p_academic_discipline in varchar2 default hr_api.g_varchar2,
1103 p_additional_info_person_id in number default hr_api.g_number,
1104 p_additional_info_tel_number in varchar2 default hr_api.g_varchar2,
1105 --p_agency_code in varchar2 default hr_api.g_varchar2,
1106 p_altered_pa_request_id in number default hr_api.g_number,
1107 p_annuitant_indicator in varchar2 default hr_api.g_varchar2,
1108 p_annuitant_indicator_desc in varchar2 default hr_api.g_varchar2,
1109 p_appropriation_code1 in varchar2 default hr_api.g_varchar2,
1110 p_appropriation_code2 in varchar2 default hr_api.g_varchar2,
1111 p_approval_date in date default hr_api.g_date,
1112 p_approving_official_full_name in varchar2 default hr_api.g_varchar2,
1113 p_approving_official_work_titl in varchar2 default hr_api.g_varchar2,
1114 -- p_sf50_approval_date in date default hr_api.g_date,
1115 -- p_sf50_approving_ofcl_full_nam in varchar2 default hr_api.g_varchar2,
1116 -- p_sf50_approving_ofcl_work_tit in varchar2 default hr_api.g_varchar2,
1117 p_authorized_by_person_id in number default hr_api.g_number,
1118 p_authorized_by_title in varchar2 default hr_api.g_varchar2,
1119 p_award_amount in number default hr_api.g_number,
1120 p_award_uom in varchar2 default hr_api.g_varchar2,
1121 p_bargaining_unit_status in varchar2 default hr_api.g_varchar2,
1122 p_citizenship in varchar2 default hr_api.g_varchar2,
1123 p_concurrence_date in date default hr_api.g_date,
1124 p_custom_pay_calc_flag in varchar2 default hr_api.g_varchar2,
1125 p_duty_station_code in varchar2 default hr_api.g_varchar2,
1126 p_duty_station_desc in varchar2 default hr_api.g_varchar2,
1127 p_duty_station_id in number default hr_api.g_number,
1128 p_duty_station_location_id in number default hr_api.g_number,
1129 p_education_level in varchar2 default hr_api.g_varchar2,
1130 p_effective_date in date default hr_api.g_date,
1131 p_employee_assignment_id in number default hr_api.g_number,
1132 p_employee_date_of_birth in date default hr_api.g_date,
1133 --p_employee_dept_or_agency in varchar2 default hr_api.g_varchar2,
1134 p_employee_first_name in varchar2 default hr_api.g_varchar2,
1135 p_employee_last_name in varchar2 default hr_api.g_varchar2,
1136 p_employee_middle_names in varchar2 default hr_api.g_varchar2,
1137 p_employee_national_identifier in varchar2 default hr_api.g_varchar2,
1138 p_fegli in varchar2 default hr_api.g_varchar2,
1139 p_fegli_desc in varchar2 default hr_api.g_varchar2,
1140 p_first_action_la_code1 in varchar2 default hr_api.g_varchar2,
1141 p_first_action_la_code2 in varchar2 default hr_api.g_varchar2,
1142 p_first_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1143 p_first_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1144 p_first_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1145 p_first_noa_code in varchar2 default hr_api.g_varchar2,
1146 p_first_noa_desc in varchar2 default hr_api.g_varchar2,
1147 p_first_noa_id in number default hr_api.g_number,
1148 p_first_noa_pa_request_id in number default hr_api.g_number,
1149 p_flsa_category in varchar2 default hr_api.g_varchar2,
1150 p_forwarding_address_line1 in varchar2 default hr_api.g_varchar2,
1151 p_forwarding_address_line2 in varchar2 default hr_api.g_varchar2,
1152 p_forwarding_address_line3 in varchar2 default hr_api.g_varchar2,
1153 p_forwarding_country in varchar2 default hr_api.g_varchar2,
1154 p_forwarding_country_short_nam in varchar2 default hr_api.g_varchar2,
1155 p_forwarding_postal_code in varchar2 default hr_api.g_varchar2,
1156 p_forwarding_region_2 in varchar2 default hr_api.g_varchar2,
1157 p_forwarding_town_or_city in varchar2 default hr_api.g_varchar2,
1158 p_from_adj_basic_pay in number default hr_api.g_number,
1159 -- p_from_agency_code in varchar2 default hr_api.g_varchar2,
1160 -- p_from_agency_desc in varchar2 default hr_api.g_varchar2,
1161 p_from_basic_pay in number default hr_api.g_number,
1162 p_from_grade_or_level in varchar2 default hr_api.g_varchar2,
1163 p_from_locality_adj in number default hr_api.g_number,
1164 p_from_occ_code in varchar2 default hr_api.g_varchar2,
1165 -- p_from_office_symbol in varchar2 default hr_api.g_varchar2,
1166 p_from_other_pay_amount in number default hr_api.g_number,
1167 p_from_pay_basis in varchar2 default hr_api.g_varchar2,
1168 p_from_pay_plan in varchar2 default hr_api.g_varchar2,
1169 -- FWFA Changes Bug#4444609
1170 p_input_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1171 p_from_pay_table_identifier in number default hr_api.g_number,
1172 -- FWFA Changes
1173 p_from_position_id in number default hr_api.g_number,
1174 p_from_position_org_line1 in varchar2 default hr_api.g_varchar2,
1178 p_from_position_org_line5 in varchar2 default hr_api.g_varchar2,
1175 p_from_position_org_line2 in varchar2 default hr_api.g_varchar2,
1176 p_from_position_org_line3 in varchar2 default hr_api.g_varchar2,
1177 p_from_position_org_line4 in varchar2 default hr_api.g_varchar2,
1179 p_from_position_org_line6 in varchar2 default hr_api.g_varchar2,
1180 p_from_position_number in varchar2 default hr_api.g_varchar2,
1181 p_from_position_seq_no in number default hr_api.g_number,
1182 p_from_position_title in varchar2 default hr_api.g_varchar2,
1183 p_from_step_or_rate in varchar2 default hr_api.g_varchar2,
1184 p_from_total_salary in number default hr_api.g_number,
1185 p_functional_class in varchar2 default hr_api.g_varchar2,
1186 p_notepad in varchar2 default hr_api.g_varchar2,
1187 p_part_time_hours in number default hr_api.g_number,
1188 p_pay_rate_determinant in varchar2 default hr_api.g_varchar2,
1189 p_person_id in number default hr_api.g_number,
1190 p_position_occupied in varchar2 default hr_api.g_varchar2,
1191 p_proposed_effective_date in date default hr_api.g_date,
1192 p_requested_by_person_id in number default hr_api.g_number,
1193 p_requested_by_title in varchar2 default hr_api.g_varchar2,
1194 p_requested_date in date default hr_api.g_date,
1195 p_requesting_office_remarks_de in varchar2 default hr_api.g_varchar2,
1196 p_requesting_office_remarks_fl in varchar2 default hr_api.g_varchar2,
1197 p_request_number in varchar2 default hr_api.g_varchar2,
1198 p_resign_and_retire_reason_des in varchar2 default hr_api.g_varchar2,
1199 p_retirement_plan in varchar2 default hr_api.g_varchar2,
1200 p_retirement_plan_desc in varchar2 default hr_api.g_varchar2,
1201 p_second_action_la_code1 in varchar2 default hr_api.g_varchar2,
1202 p_second_action_la_code2 in varchar2 default hr_api.g_varchar2,
1203 p_second_action_la_desc1 in varchar2 default hr_api.g_varchar2,
1204 p_second_action_la_desc2 in varchar2 default hr_api.g_varchar2,
1205 p_second_noa_cancel_or_correct in varchar2 default hr_api.g_varchar2,
1206 p_second_noa_code in varchar2 default hr_api.g_varchar2,
1207 p_second_noa_desc in varchar2 default hr_api.g_varchar2,
1208 p_second_noa_id in number default hr_api.g_number,
1209 p_second_noa_pa_request_id in number default hr_api.g_number,
1210 p_service_comp_date in date default hr_api.g_date,
1211 p_supervisory_status in varchar2 default hr_api.g_varchar2,
1212 p_tenure in varchar2 default hr_api.g_varchar2,
1213 p_to_adj_basic_pay in number default hr_api.g_number,
1214 p_to_basic_pay in number default hr_api.g_number,
1215 p_to_grade_id in number default hr_api.g_number,
1216 p_to_grade_or_level in varchar2 default hr_api.g_varchar2,
1217 p_to_job_id in number default hr_api.g_number,
1218 p_to_locality_adj in number default hr_api.g_number,
1219 p_to_occ_code in varchar2 default hr_api.g_varchar2,
1220 -- p_to_office_symbol in varchar2 default hr_api.g_varchar2,
1221 p_to_organization_id in number default hr_api.g_number,
1222 p_to_other_pay_amount in number default hr_api.g_number,
1223 p_to_au_overtime in number default hr_api.g_number,
1224 p_to_auo_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1225 p_to_availability_pay in number default hr_api.g_number,
1226 p_to_ap_premium_pay_indicator in varchar2 default hr_api.g_varchar2,
1227 p_to_retention_allowance in number default hr_api.g_number,
1228 p_to_supervisory_differential in number default hr_api.g_number,
1229 p_to_staffing_differential in number default hr_api.g_number,
1230 p_to_pay_basis in varchar2 default hr_api.g_varchar2,
1231 p_to_pay_plan in varchar2 default hr_api.g_varchar2,
1232 -- FWFA Changes Bug#4444609
1233 p_to_pay_table_identifier in number default hr_api.g_number,
1234 -- FWFA Changes
1235 p_to_position_id in number default hr_api.g_number,
1236 p_to_position_org_line1 in varchar2 default hr_api.g_varchar2,
1237 p_to_position_org_line2 in varchar2 default hr_api.g_varchar2,
1238 p_to_position_org_line3 in varchar2 default hr_api.g_varchar2,
1239 p_to_position_org_line4 in varchar2 default hr_api.g_varchar2,
1240 p_to_position_org_line5 in varchar2 default hr_api.g_varchar2,
1241 p_to_position_org_line6 in varchar2 default hr_api.g_varchar2,
1242 p_to_position_number in varchar2 default hr_api.g_varchar2,
1243 p_to_position_seq_no in number default hr_api.g_number,
1244 p_to_position_title in varchar2 default hr_api.g_varchar2,
1245 p_to_step_or_rate in varchar2 default hr_api.g_varchar2,
1246 p_to_total_salary in number default hr_api.g_number,
1247 p_veterans_preference in varchar2 default hr_api.g_varchar2,
1248 p_veterans_pref_for_rif in varchar2 default hr_api.g_varchar2,
1249 p_veterans_status in varchar2 default hr_api.g_varchar2,
1250 p_work_schedule in varchar2 default hr_api.g_varchar2,
1251 p_work_schedule_desc in varchar2 default hr_api.g_varchar2,
1252 p_year_degree_attained in number default hr_api.g_number,
1253 p_first_noa_information1 in varchar2 default hr_api.g_varchar2,
1254 p_first_noa_information2 in varchar2 default hr_api.g_varchar2,
1255 p_first_noa_information3 in varchar2 default hr_api.g_varchar2,
1256 p_first_noa_information4 in varchar2 default hr_api.g_varchar2,
1257 p_first_noa_information5 in varchar2 default hr_api.g_varchar2,
1258 p_second_lac1_information1 in varchar2 default hr_api.g_varchar2,
1259 p_second_lac1_information2 in varchar2 default hr_api.g_varchar2,
1260 p_second_lac1_information3 in varchar2 default hr_api.g_varchar2,
1261 p_second_lac1_information4 in varchar2 default hr_api.g_varchar2,
1262 p_second_lac1_information5 in varchar2 default hr_api.g_varchar2,
1263 p_second_lac2_information1 in varchar2 default hr_api.g_varchar2,
1264 p_second_lac2_information2 in varchar2 default hr_api.g_varchar2,
1265 p_second_lac2_information3 in varchar2 default hr_api.g_varchar2,
1266 p_second_lac2_information4 in varchar2 default hr_api.g_varchar2,
1267 p_second_lac2_information5 in varchar2 default hr_api.g_varchar2,
1268 p_second_noa_information1 in varchar2 default hr_api.g_varchar2,
1269 p_second_noa_information2 in varchar2 default hr_api.g_varchar2,
1270 p_second_noa_information3 in varchar2 default hr_api.g_varchar2,
1271 p_second_noa_information4 in varchar2 default hr_api.g_varchar2,
1272 p_second_noa_information5 in varchar2 default hr_api.g_varchar2,
1273 p_first_lac1_information1 in varchar2 default hr_api.g_varchar2,
1274 p_first_lac1_information2 in varchar2 default hr_api.g_varchar2,
1275 p_first_lac1_information3 in varchar2 default hr_api.g_varchar2,
1276 p_first_lac1_information4 in varchar2 default hr_api.g_varchar2,
1277 p_first_lac1_information5 in varchar2 default hr_api.g_varchar2,
1278 p_first_lac2_information1 in varchar2 default hr_api.g_varchar2,
1279 p_first_lac2_information2 in varchar2 default hr_api.g_varchar2,
1280 p_first_lac2_information3 in varchar2 default hr_api.g_varchar2,
1281 p_first_lac2_information4 in varchar2 default hr_api.g_varchar2,
1282 p_first_lac2_information5 in varchar2 default hr_api.g_varchar2,
1283 p_attribute_category in varchar2 default hr_api.g_varchar2,
1284 p_attribute1 in varchar2 default hr_api.g_varchar2,
1285 p_attribute2 in varchar2 default hr_api.g_varchar2,
1286 p_attribute3 in varchar2 default hr_api.g_varchar2,
1287 p_attribute4 in varchar2 default hr_api.g_varchar2,
1288 p_attribute5 in varchar2 default hr_api.g_varchar2,
1289 p_attribute6 in varchar2 default hr_api.g_varchar2,
1290 p_attribute7 in varchar2 default hr_api.g_varchar2,
1291 p_attribute8 in varchar2 default hr_api.g_varchar2,
1292 p_attribute9 in varchar2 default hr_api.g_varchar2,
1293 p_attribute10 in varchar2 default hr_api.g_varchar2,
1294 p_attribute11 in varchar2 default hr_api.g_varchar2,
1295 p_attribute12 in varchar2 default hr_api.g_varchar2,
1296 p_attribute13 in varchar2 default hr_api.g_varchar2,
1297 p_attribute14 in varchar2 default hr_api.g_varchar2,
1298 p_attribute15 in varchar2 default hr_api.g_varchar2,
1299 p_attribute16 in varchar2 default hr_api.g_varchar2,
1300 p_attribute17 in varchar2 default hr_api.g_varchar2,
1301 p_attribute18 in varchar2 default hr_api.g_varchar2,
1302 p_attribute19 in varchar2 default hr_api.g_varchar2,
1303 p_attribute20 in varchar2 default hr_api.g_varchar2,
1304 p_print_sf50_flag in varchar2 default 'N',
1305 p_printer_name in varchar2 default null,
1306 p_print_back_page in varchar2 default 'Y',
1307 p_u_attachment_modified_flag in varchar2 default hr_api.g_varchar2,
1308 p_u_approved_flag in varchar2 default hr_api.g_varchar2,
1309 p_u_user_name_acted_on in varchar2 default hr_api.g_varchar2,
1310 p_u_action_taken in varchar2 default null,
1311 p_u_approval_status in varchar2 default hr_api.g_varchar2, -- check this
1312 p_i_user_name_routed_to in varchar2 default null,
1313 p_i_groupbox_id in number default null,
1314 p_i_routing_list_id in number default null,
1315 p_i_routing_seq_number in number default null,
1316 p_capped_other_pay in number default null,
1317 p_to_retention_allow_percentag in number default hr_api.g_number,
1318 p_to_supervisory_diff_percenta in number default hr_api.g_number,
1319 p_to_staffing_diff_percentage in number default hr_api.g_number,
1320 p_award_percentage in number default hr_api.g_number,
1321 p_rpa_type in varchar2 default hr_api.g_varchar2,
1322 p_mass_action_id in number default hr_api.g_number,
1323 p_mass_action_eligible_flag in varchar2 default hr_api.g_varchar2,
1324 p_mass_action_select_flag in varchar2 default hr_api.g_varchar2,
1325 p_mass_action_comments in varchar2 default hr_api.g_varchar2,
1326 -- Bug#4486823 RRR Changes
1327 p_payment_option in varchar2 default null,
1328 p_award_salary in number default hr_api.g_number,
1329 -- Bug#4486823 RRR Changes
1330 p_u_prh_object_version_number out nocopy number,
1331 p_i_pa_routing_history_id out nocopy number,
1332 p_i_prh_object_version_number out nocopy number
1333 );
1334 --
1335 -- ----------------------------------------------------------------------------
1336 -- |---------------------------------< end_sf52 >-----------------------------|
1337 -- ----------------------------------------------------------------------------
1338 --
1339 -- {Start Of Comments}
1340 /*#
1341 * This API ends the routing of the Request for Personnel Action (RPA).
1342 *
1343 * This API updates the pa_request record and the latest pa_routing_history
1344 * record to store the details regarding the action taken, including the user
1345 * name of the person who acted on the Request for Personnel Action (RPA), that
1346 * person's roles and the action taken. This API is valid only for
1347 * 'UPDATE_HR_COMPLETE' and 'CANCELED' actions.
1348 *
1349 * <p><b>Licensing</b><br>
1350 * This API is licensed for use with Human Resources.
1351 *
1352 * <p><b>Prerequisites</b><br>
1353 * The Request for Personnel Action record specified must exist.
1354 *
1355 * <p><b>Post Success</b><br>
1356 * This API ends the routing record of the Request for Personnel Action (RPA).
1357 *
1358 * <p><b>Post Failure</b><br>
1359 * The API does not end the routing of the Request for Personnel Action (RPA).
1360 * It does not update the GHR_pa_requests and GHR_pa_routing_history records
1361 * and an error is raised.
1362 * @param p_validate If true, then validation alone will be performed and the
1363 * database will remain unchanged. If false and all validation checks pass,
1364 * then the database will be modified.
1365 * @param p_pa_request_id Uniquely identifies the Request for Personnel Action
1366 * record.
1367 * @param p_user_name {@rep:casecolumn GHR_PA_ROUTING_HISTORY.USER_NAME}
1368 * @param p_action_taken Action taken that ended routing of the RPA. Possible
1369 * values are 'UPDATE_HR_COMPLETE' and 'CANCELED'.
1370 * @param p_altered_pa_request_id {@rep:casecolumn
1371 * GHR_PA_REQUESTS.ALTERED_PA_REQUEST_ID}
1372 * @param p_first_noa_code {@rep:casecolumn GHR_PA_REQUESTS.FIRST_NOA_CODE}
1373 * @param p_second_noa_code {@rep:casecolumn GHR_PA_REQUESTS.SECOND_NOA_CODE}
1374 * @param p_par_object_version_number Pass in the current version number of the
1375 * pa_request_id that you are updating. When the API completes, if p_validate
1376 * is false, sets the new version number of the updated pa_request_id. If
1377 * p_validate is true, sets the same value passed in.
1378 * @rep:displayname End Request for Personnel Action
1379 * @rep:category BUSINESS_ENTITY GHR_REQ_FOR_PERSONNEL_ACTION
1380 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1381 * @rep:scope public
1382 * @rep:lifecycle active
1383 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1384 */
1385 --
1386 -- {End Of Comments}
1387 --
1388 procedure end_sf52
1389 (p_validate in boolean default false,
1390 p_pa_request_id in number,
1391 p_user_name in varchar2 default hr_api.g_varchar2,
1392 p_action_taken in varchar2,
1393 p_altered_pa_request_id in number default null,
1394 p_first_noa_code in varchar2 default null,
1395 p_second_noa_code in varchar2 default null,
1396 p_par_object_version_number in out nocopy number
1397 );
1398
1399 --
1400
1401 Procedure Cancel_Cancor
1402 (p_altered_pa_request_id in number,
1403 p_noa_code_correct in varchar2,
1404 p_result out nocopy boolean
1405 );
1406
1407 --Bug#3757201 Added p_back_page parameter
1408 Procedure submit_request_to_print_50
1409 (p_printer_name in varchar2,
1410 p_pa_request_id in ghr_pa_requests.pa_request_id%type,
1411 p_effective_date in date,
1412 p_user_name in varchar2,
1413 p_back_page in varchar2
1414 );
1415
1416
1417 --
1418 -- ----------------------------------------------------------------------------
1419 -- |--------------------------< get_par_status >--------------------------|
1420 -- ----------------------------------------------------------------------------
1421 --
1422 -- {Start Of Comments}
1423 --
1424 -- Description:
1425 -- This procedure determines the current RPA status
1426 --
1427 -- Prerequisites:
1428 --
1429 -- Post Success:
1430 --
1431 -- Returns the most current status of the RPA
1432
1433 --
1434 -- Access Status:
1435 -- Public.
1436 --
1437 -- {End Of Comments}
1438 --
1439 --
1440 --
1441
1442 Procedure get_par_status
1443 (p_effective_date in date,
1444 p_approval_date in date,
1445 p_requested_by_person_id in number,
1446 p_authorized_by_person_id in number,
1447 p_action_taken in varchar2,
1448 --8279908
1449 p_pa_request_id in number,
1450 p_status out nocopy varchar2
1451 );
1452
1453
1454 --
1455 -- ----------------------------------------------------------------------------
1456 -- |--------------------------< check_for_open_events>--------------------------|
1457 -- ----------------------------------------------------------------------------
1458 --
1459 -- {Start Of Comments}
1460 --
1461 -- Description:
1462 -- This procedure checks for any open events pertaining to the RPA, before
1463 -- Routing it to another individual / Groupbox or when submitted to Update HR
1464 --
1465 -- Prerequisites:
1466 --
1467 -- Post Success:
1468 --
1469 -- The RPA will be either routed or successfully submitted for Update to HR
1470 --
1471 -- Post Failure:
1472 -- The RPA will not be routed and not submitted to Update HR.
1473 --
1474 -- Access Status:
1475 -- Public.
1476 --
1477 -- {End Of Comments}
1478 --
1479 --
1480 --
1481 Procedure check_for_open_events
1482 (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
1483 p_action_taken in varchar2,
1484 p_user_name_acted_on in varchar2,
1485 p_user_name_routed_to in varchar2,
1486 p_groupbox_routed_to in number,
1487 p_message out nocopy boolean
1488 );
1489 --
1490
1491
1492
1493 --Begin Bug# 8653508
1494 -- ----------------------------------------------------------------------------
1495 -- |--------------------------< update_detail_remarks>--------------------------|
1496 -- ----------------------------------------------------------------------------
1497 --
1498 -- {Start Of Comments}
1499 --
1500 -- Description:
1501 -- This procedure inserts remarks in ghr_pa_remarks table pertaining to the
1502 -- RPA Family GHR_DETAIL Routing it to another individual / Groupbox or when
1503 -- submitted to Update HR
1504 --
1505 -- Prerequisites:
1506 --
1507 -- Post Success:
1508 --
1509 -- The RPA will be either routed or successfully submitted for Update to HR
1510 --
1511 -- Post Failure:
1512 -- The RPA will not be routed and not submitted to Update HR.
1513 --
1514 -- Access Status:
1515 -- Public.
1516 --
1517 -- {End Of Comments}
1518 --
1519 --
1520 --
1521 Procedure update_detail_remarks
1522 (p_effective_date in date,
1523 p_pa_request_id in number
1524 );
1525 --End Bug# 8653508
1526
1527 end ghr_sf52_api ;