[Home] [Help]
PACKAGE: APPS.BEN_CWB_PERSON_INFO_API
Source
4 * This package contains Compensation Workbench Person APIs.
1 Package BEN_CWB_PERSON_INFO_API AUTHID CURRENT_USER as
2 /* $Header: becpiapi.pkh 120.2 2005/10/17 04:59:32 steotia noship $ */
3 /*#
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Compensation Workbench Person Information
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------------< create_person_info >------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a snapshot of a person for compensation workbench
17 * processing.
18 *
19 * The API Creates denormalized person information that is a snapshot in time
20 * (as of the freeze date) from the HR Person Table.
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with Human Resources.
24 *
25 * <p><b>Prerequisites</b><br>
26 * The person should have a life event reason ID from BEN_PER_IN_LER table, a
27 * person ID from PER_ALL_PEOPLE_F and an assignment ID from the
28 * PER_ALL_ASSIGNMENTS_F table.
29 *
30 * <p><b>Post Success</b><br>
31 * A snapshot of a person for compensation workbench processing will be
32 * inserted into the database.
33 *
34 * <p><b>Post Failure</b><br>
35 * The person information will not be inserted in the database.
36 *
37 * @param p_validate If true, then validation alone will be performed and the
38 * database will remain unchanged. If false and all validation checks pass,
39 * then the database will be modified.
40 * @param p_group_per_in_ler_id This parameter identifies the Group Life Event
41 * Reason ID of Compensation Workbench Person. Foreign key to BEN_PER_IN_LER.
42 * @param p_assignment_id Identifies the assignment of the Compensation
43 * Workbench Person
44 * @param p_person_id Identifies the person for whom you create the
45 * Compensation Workbench Person record.
46 * @param p_supervisor_id This parameter identifies the person ID of the
47 * manager.
48 * @param p_effective_date Determines when the DateTrack operation comes into
49 * force.
50 * @param p_full_name {@rep:casecolumn BEN_CWB_PERSON_INFO.FULL_NAME}
51 * @param p_brief_name {@rep:casecolumn BEN_CWB_PERSON_INFO.BRIEF_NAME}
52 * @param p_custom_name {@rep:casecolumn BEN_CWB_PERSON_INFO.CUSTOM_NAME}
53 * @param p_supervisor_full_name {@rep:casecolumn
54 * BEN_CWB_PERSON_INFO.SUPERVISOR_FULL_NAME}
55 * @param p_supervisor_brief_name {@rep:casecolumn
56 * BEN_CWB_PERSON_INFO.SUPERVISOR_BRIEF_NAME}
57 * @param p_supervisor_custom_name {@rep:casecolumn
58 * BEN_CWB_PERSON_INFO.SUPERVISOR_CUSTOM_NAME}
59 * @param p_legislation_code This parameter specifies the legislation to which
60 * the information type applies.
61 * @param p_years_employed This parameter specifies the number of years
62 * employed.
63 * @param p_years_in_job This parameter specifies the number of years employed
64 * in the person's assigned Job.
65 * @param p_years_in_position This parameter specifies the number of years
66 * employed in the person's assigned Position.
67 * @param p_years_in_grade This parameter specifies the number of years
68 * employed in the person's assigned Grade.
69 * @param p_employee_number This parameter specifies the employee number
70 * assigned to the Compensation Workbench Person.
71 * @param p_start_date {@rep:casecolumn PER_ALL_PEOPLE_F.START_DATE}
72 * @param p_original_start_date {@rep:casecolumn
73 * PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE}
74 * @param p_adjusted_svc_date {@rep:casecolumn
75 * PER_PERIODS_OF_SERVICE.ADJUSTED_SVC_DATE}
76 * @param p_base_salary {@rep:casecolumn PER_PAY_PROPOSALS.PROPOSED_SALARY_N}
77 * @param p_base_salary_change_date {@rep:casecolumn
78 * PER_PAY_PROPOSALS.CHANGE_DATE}
79 * @param p_payroll_name {@rep:casecolumn PAY_ALL_PAYROLLS_F.PAYROLL_NAME}
80 * @param p_performance_rating {@rep:casecolumn
81 * PER_PERFORMANCE_REVIEWS.PERFORMANCE_RATING}
82 * @param p_performance_rating_type {@rep:casecolumn
83 * BEN_CWB_PERSON_INFO.PERFORMANCE_RATING_TYPE}
84 * @param p_performance_rating_date {@rep:casecolumn
85 * PER_PERFORMANCE_REVIEWS.REVIEW_DATE}
86 * @param p_business_group_id {@rep:casecolumn
87 * PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID}
88 * @param p_organization_id {@rep:casecolumn
89 * PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID}
90 * @param p_job_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.JOB_ID}
91 * @param p_grade_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.GRADE_ID}
92 * @param p_position_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.POSITION_ID}
93 * @param p_people_group_id {@rep:casecolumn
94 * PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID}
95 * @param p_soft_coding_keyflex_id {@rep:casecolumn
96 * PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID}
97 * @param p_location_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.LOCATION_ID}
98 * @param p_pay_rate_id {@rep:casecolumn PER_PAY_BASES.RATE_ID}
99 * @param p_assignment_status_type_id {@rep:casecolumn
100 * PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID}
101 * @param p_frequency {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.FREQUENCY}
105 * PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR}
102 * @param p_grade_annulization_factor {@rep:casecolumn
103 * PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR}
104 * @param p_pay_annulization_factor {@rep:casecolumn
106 * @param p_grd_min_val {@rep:casecolumn BEN_CWB_PERSON_INFO.GRD_MIN_VAL}
107 * @param p_grd_max_val {@rep:casecolumn BEN_CWB_PERSON_INFO.GRD_MAX_VAL}
108 * @param p_grd_mid_point {@rep:casecolumn BEN_CWB_PERSON_INFO.GRD_MID_POINT}
109 * @param p_grd_quartile {@rep:casecolumn BEN_CWB_PERSON_INFO.GRD_QUARTILE}
110 * @param p_grd_comparatio {@rep:casecolumn BEN_CWB_PERSON_INFO.GRD_COMPARATIO}
111 * @param p_emp_category {@rep:casecolumn
112 * PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY}
113 * @param p_change_reason {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.CHANGE_REASON}
114 * @param p_normal_hours {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS}
115 * @param p_email_address {@rep:casecolumn PER_ALL_PEOPLE_F.EMAIL_ADDRESS}
116 * @param p_base_salary_frequency {@rep:casecolumn PER_PAY_BASES.PAY_BASIS}
117 * @param p_new_assgn_ovn This parameter specifies the object version number
118 * for assignment changes.
119 * @param p_new_perf_event_id This parameter specifies the performance event
120 * ID.
121 * @param p_new_perf_review_id This parameter specifies the performance review
122 * ID.
123 * @param p_post_process_stat_cd {@rep:casecolumn
124 * BEN_CWB_PERSON_INFO.POST_PROCESS_STAT_CD}
125 * @param p_feedback_rating This parameter specifies the feedback rating. Valid
126 * values are Lookup Code from 'BEN_CWB_SUBMIT_FEEDBACK' lookups.
127 * @param p_feedback_comments This parameter specifies the feedback Comments.
128 * @param p_custom_segment1 Placeholder for custom defined alphanumeric values.
132 * @param p_custom_segment5 Placeholder for custom defined alphanumeric values.
129 * @param p_custom_segment2 Placeholder for custom defined alphanumeric values.
130 * @param p_custom_segment3 Placeholder for custom defined alphanumeric values.
131 * @param p_custom_segment4 Placeholder for custom defined alphanumeric values.
133 * @param p_custom_segment6 Placeholder for custom defined alphanumeric values.
134 * @param p_custom_segment7 Placeholder for custom defined alphanumeric values.
135 * @param p_custom_segment8 Placeholder for custom defined alphanumeric values.
136 * @param p_custom_segment9 Placeholder for custom defined alphanumeric values.
137 * @param p_custom_segment10 Placeholder for custom defined alphanumeric values.
138 * @param p_custom_segment11 Placeholder for custom defined numeric values.
139 * @param p_custom_segment12 Placeholder for custom defined numeric values.
140 * @param p_custom_segment13 Placeholder for custom defined numeric values.
141 * @param p_custom_segment14 Placeholder for custom defined numeric values.
142 * @param p_custom_segment15 Placeholder for custom defined numeric values.
143 * @param p_ass_attribute_category This parameter specifies the assigment
144 * attribute category.
145 * @param p_ass_attribute1 Developer descriptive flexfield segment for
146 * Assignment.
147 * @param p_ass_attribute2 Developer descriptive flexfield segment for
148 * Assignment.
149 * @param p_ass_attribute3 Developer descriptive flexfield segment for
150 * Assignment.
151 * @param p_ass_attribute4 Developer descriptive flexfield segment for
152 * Assignment.
153 * @param p_ass_attribute5 Developer descriptive flexfield segment for
154 * Assignment.
155 * @param p_ass_attribute6 Developer descriptive flexfield segment for
156 * Assignment.
157 * @param p_ass_attribute7 Developer descriptive flexfield segment for
158 * Assignment.
159 * @param p_ass_attribute8 Developer descriptive flexfield segment for
160 * Assignment.
161 * @param p_ass_attribute9 Developer descriptive flexfield segment for
162 * Assignment.
163 * @param p_ass_attribute10 Developer descriptive flexfield segment for
164 * Assignment.
165 * @param p_ass_attribute11 Developer descriptive flexfield segment for
166 * Assignment.
167 * @param p_ass_attribute12 Developer descriptive flexfield segment for
168 * Assignment.
169 * @param p_ass_attribute13 Developer descriptive flexfield segment for
170 * Assignment.
171 * @param p_ass_attribute14 Developer descriptive flexfield segment for
172 * Assignment.
173 * @param p_ass_attribute15 Developer descriptive flexfield segment for
174 * Assignment.
175 * @param p_ass_attribute16 Developer descriptive flexfield segment for
176 * Assignment.
177 * @param p_ass_attribute17 Developer descriptive flexfield segment for
178 * Assignment.
179 * @param p_ass_attribute18 Developer descriptive flexfield segment for
180 * Assignment.
181 * @param p_ass_attribute19 Developer descriptive flexfield segment for
182 * Assignment.
183 * @param p_ass_attribute20 Developer descriptive flexfield segment for
184 * Assignment.
188 * Assignment.
185 * @param p_ass_attribute21 Developer descriptive flexfield segment for
186 * Assignment.
187 * @param p_ass_attribute22 Developer descriptive flexfield segment for
189 * @param p_ass_attribute23 Developer descriptive flexfield segment for
190 * Assignment.
191 * @param p_ass_attribute24 Developer descriptive flexfield segment for
192 * Assignment.
193 * @param p_ass_attribute25 Developer descriptive flexfield segment for
194 * Assignment.
195 * @param p_ass_attribute26 Developer descriptive flexfield segment for
196 * Assignment.
197 * @param p_ass_attribute27 Developer descriptive flexfield segment for
198 * Assignment.
199 * @param p_ass_attribute28 Developer descriptive flexfield segment for
200 * Assignment.
201 * @param p_ass_attribute29 Developer descriptive flexfield segment for
202 * Assignment.
203 * @param p_ass_attribute30 Developer descriptive flexfield segment for
204 * Assignment.
205 * @param p_ws_comments {@rep:casecolumn BEN_CWB_PERSON_INFO.WS_COMMENTS}
206 * @param p_people_group_name {@rep:casecolumn PAY_PEOPLE_GROUPS.GROUP_NAME}
207 * @param p_people_group_segment1 Developer descriptive flexfield segment for
208 * People Group.
209 * @param p_people_group_segment2 Developer descriptive flexfield segment for
210 * People Group.
211 * @param p_people_group_segment3 Developer descriptive flexfield segment for
212 * People Group.
213 * @param p_people_group_segment4 Developer descriptive flexfield segment for
214 * People Group.
215 * @param p_people_group_segment5 Developer descriptive flexfield segment for
216 * People Group.
217 * @param p_people_group_segment6 Developer descriptive flexfield segment for
218 * People Group.
219 * @param p_people_group_segment7 Developer descriptive flexfield segment for
220 * People Group.
221 * @param p_people_group_segment8 Developer descriptive flexfield segment for
222 * People Group.
223 * @param p_people_group_segment9 Developer descriptive flexfield segment for
224 * People Group.
225 * @param p_people_group_segment10 Developer descriptive flexfield segment for
226 * People Group.
227 * @param p_people_group_segment11 Developer descriptive flexfield segment for
228 * People Group.
229 * @param p_cpi_attribute_category {@rep:casecolumn
230 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE_CATEGORY}
231 * @param p_cpi_attribute1 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE1}
232 * @param p_cpi_attribute2 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE2}
233 * @param p_cpi_attribute3 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE3}
234 * @param p_cpi_attribute4 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE4}
235 * @param p_cpi_attribute5 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE5}
236 * @param p_cpi_attribute6 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE6}
237 * @param p_cpi_attribute7 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE7}
238 * @param p_cpi_attribute8 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE8}
239 * @param p_cpi_attribute9 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE9}
240 * @param p_cpi_attribute10 {@rep:casecolumn
241 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE10}
242 * @param p_cpi_attribute11 {@rep:casecolumn
243 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE11}
244 * @param p_cpi_attribute12 {@rep:casecolumn
245 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE12}
246 * @param p_cpi_attribute13 {@rep:casecolumn
247 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE13}
248 * @param p_cpi_attribute14 {@rep:casecolumn
249 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE14}
250 * @param p_cpi_attribute15 {@rep:casecolumn
251 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE15}
252 * @param p_cpi_attribute16 {@rep:casecolumn
253 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE16}
254 * @param p_cpi_attribute17 {@rep:casecolumn
255 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE17}
256 * @param p_cpi_attribute18 {@rep:casecolumn
257 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE18}
258 * @param p_cpi_attribute19 {@rep:casecolumn
259 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE19}
260 * @param p_cpi_attribute20 {@rep:casecolumn
261 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE20}
262 * @param p_cpi_attribute21 {@rep:casecolumn
263 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE21}
264 * @param p_cpi_attribute22 {@rep:casecolumn
265 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE22}
266 * @param p_cpi_attribute23 {@rep:casecolumn
267 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE23}
268 * @param p_cpi_attribute24 {@rep:casecolumn
269 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE24}
270 * @param p_cpi_attribute25 {@rep:casecolumn
271 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE25}
272 * @param p_cpi_attribute26 {@rep:casecolumn
273 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE26}
274 * @param p_cpi_attribute27 {@rep:casecolumn
275 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE27}
276 * @param p_cpi_attribute28 {@rep:casecolumn
280 * @param p_cpi_attribute30 {@rep:casecolumn
277 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE28}
278 * @param p_cpi_attribute29 {@rep:casecolumn
279 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE29}
281 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE30}
282 * @param p_feedback_date This parameter specifies the feedback date.
283 * @param p_object_version_number If p_validate is false, then set to the
284 * version number of the created Group Person Life Event Reason. If p_validate
285 * is true, then the value will be null.
286 * @param p_custom_segment16 Placeholder for custom defined numeric values.
287 * @param p_custom_segment17 Placeholder for custom defined numeric values.
288 * @param p_custom_segment18 Placeholder for custom defined numeric values.
289 * @param p_custom_segment19 Placeholder for custom defined numeric values.
290 * @param p_custom_segment20 Placeholder for custom defined numeric values.
291 * @rep:displayname Create Person Information
292 * @rep:category BUSINESS_ENTITY BEN_CWB_PERSON
293 * @rep:lifecycle active
294 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
295 * @rep:scope public
296 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
297 */
298 --
299 -- {End Of Comments}
300 --
301 procedure create_person_info
302 (p_validate in boolean default false
303 ,p_group_per_in_ler_id in number
304 ,p_assignment_id in number
305 ,p_person_id in number
306 ,p_supervisor_id in number default null
307 ,p_effective_date in date default null
308 ,p_full_name in varchar2 default null
309 ,p_brief_name in varchar2 default null
310 ,p_custom_name in varchar2 default null
311 ,p_supervisor_full_name in varchar2 default null
312 ,p_supervisor_brief_name in varchar2 default null
313 ,p_supervisor_custom_name in varchar2 default null
314 ,p_legislation_code in varchar2 default null
315 ,p_years_employed in number default null
316 ,p_years_in_job in number default null
317 ,p_years_in_position in number default null
318 ,p_years_in_grade in number default null
319 ,p_employee_number in varchar2 default null
320 ,p_start_date in date default null
321 ,p_original_start_date in date default null
322 ,p_adjusted_svc_date in date default null
323 ,p_base_salary in number default null
324 ,p_base_salary_change_date in date default null
325 ,p_payroll_name in varchar2 default null
326 ,p_performance_rating in varchar2 default null
327 ,p_performance_rating_type in varchar2 default null
328 ,p_performance_rating_date in date default null
329 ,p_business_group_id in number default null
330 ,p_organization_id in number default null
331 ,p_job_id in number default null
332 ,p_grade_id in number default null
333 ,p_position_id in number default null
334 ,p_people_group_id in number default null
335 ,p_soft_coding_keyflex_id in number default null
336 ,p_location_id in number default null
337 ,p_pay_rate_id in number default null
338 ,p_assignment_status_type_id in number default null
339 ,p_frequency in varchar2 default null
340 ,p_grade_annulization_factor in number default null
341 ,p_pay_annulization_factor in number default null
342 ,p_grd_min_val in number default null
343 ,p_grd_max_val in number default null
344 ,p_grd_mid_point in number default null
345 ,p_grd_quartile in varchar2 default null
346 ,p_grd_comparatio in number default null
347 ,p_emp_category in varchar2 default null
348 ,p_change_reason in varchar2 default null
349 ,p_normal_hours in number default null
350 ,p_email_address in varchar2 default null
351 ,p_base_salary_frequency in varchar2 default null
352 ,p_new_assgn_ovn in number default null
353 ,p_new_perf_event_id in number default null
354 ,p_new_perf_review_id in number default null
355 ,p_post_process_stat_cd in varchar2 default null
356 ,p_feedback_rating in varchar2 default null
357 ,p_feedback_comments in varchar2 default null
358 ,p_custom_segment1 in varchar2 default null
359 ,p_custom_segment2 in varchar2 default null
360 ,p_custom_segment3 in varchar2 default null
361 ,p_custom_segment4 in varchar2 default null
362 ,p_custom_segment5 in varchar2 default null
363 ,p_custom_segment6 in varchar2 default null
364 ,p_custom_segment7 in varchar2 default null
365 ,p_custom_segment8 in varchar2 default null
366 ,p_custom_segment9 in varchar2 default null
367 ,p_custom_segment10 in varchar2 default null
368 ,p_custom_segment11 in number default null
369 ,p_custom_segment12 in number default null
370 ,p_custom_segment13 in number default null
371 ,p_custom_segment14 in number default null
372 ,p_custom_segment15 in number default null
376 ,p_custom_segment19 in number default null
373 ,p_custom_segment16 in number default null
374 ,p_custom_segment17 in number default null
375 ,p_custom_segment18 in number default null
377 ,p_custom_segment20 in number default null
378 ,p_ass_attribute_category in varchar2 default null
379 ,p_ass_attribute1 in varchar2 default null
380 ,p_ass_attribute2 in varchar2 default null
381 ,p_ass_attribute3 in varchar2 default null
382 ,p_ass_attribute4 in varchar2 default null
383 ,p_ass_attribute5 in varchar2 default null
384 ,p_ass_attribute6 in varchar2 default null
385 ,p_ass_attribute7 in varchar2 default null
386 ,p_ass_attribute8 in varchar2 default null
387 ,p_ass_attribute9 in varchar2 default null
388 ,p_ass_attribute10 in varchar2 default null
389 ,p_ass_attribute11 in varchar2 default null
390 ,p_ass_attribute12 in varchar2 default null
391 ,p_ass_attribute13 in varchar2 default null
392 ,p_ass_attribute14 in varchar2 default null
393 ,p_ass_attribute15 in varchar2 default null
394 ,p_ass_attribute16 in varchar2 default null
395 ,p_ass_attribute17 in varchar2 default null
396 ,p_ass_attribute18 in varchar2 default null
397 ,p_ass_attribute19 in varchar2 default null
398 ,p_ass_attribute20 in varchar2 default null
399 ,p_ass_attribute21 in varchar2 default null
400 ,p_ass_attribute22 in varchar2 default null
401 ,p_ass_attribute23 in varchar2 default null
402 ,p_ass_attribute24 in varchar2 default null
403 ,p_ass_attribute25 in varchar2 default null
404 ,p_ass_attribute26 in varchar2 default null
405 ,p_ass_attribute27 in varchar2 default null
406 ,p_ass_attribute28 in varchar2 default null
407 ,p_ass_attribute29 in varchar2 default null
408 ,p_ass_attribute30 in varchar2 default null
409 ,p_ws_comments in varchar2 default null
410 ,p_people_group_name in varchar2 default null
411 ,p_people_group_segment1 in varchar2 default null
412 ,p_people_group_segment2 in varchar2 default null
413 ,p_people_group_segment3 in varchar2 default null
414 ,p_people_group_segment4 in varchar2 default null
415 ,p_people_group_segment5 in varchar2 default null
416 ,p_people_group_segment6 in varchar2 default null
417 ,p_people_group_segment7 in varchar2 default null
418 ,p_people_group_segment8 in varchar2 default null
419 ,p_people_group_segment9 in varchar2 default null
420 ,p_people_group_segment10 in varchar2 default null
421 ,p_people_group_segment11 in varchar2 default null
422 ,p_cpi_attribute_category in varchar2 default null
423 ,p_cpi_attribute1 in varchar2 default null
424 ,p_cpi_attribute2 in varchar2 default null
425 ,p_cpi_attribute3 in varchar2 default null
426 ,p_cpi_attribute4 in varchar2 default null
427 ,p_cpi_attribute5 in varchar2 default null
428 ,p_cpi_attribute6 in varchar2 default null
429 ,p_cpi_attribute7 in varchar2 default null
430 ,p_cpi_attribute8 in varchar2 default null
431 ,p_cpi_attribute9 in varchar2 default null
432 ,p_cpi_attribute10 in varchar2 default null
433 ,p_cpi_attribute11 in varchar2 default null
434 ,p_cpi_attribute12 in varchar2 default null
435 ,p_cpi_attribute13 in varchar2 default null
436 ,p_cpi_attribute14 in varchar2 default null
437 ,p_cpi_attribute15 in varchar2 default null
438 ,p_cpi_attribute16 in varchar2 default null
439 ,p_cpi_attribute17 in varchar2 default null
440 ,p_cpi_attribute18 in varchar2 default null
441 ,p_cpi_attribute19 in varchar2 default null
442 ,p_cpi_attribute20 in varchar2 default null
443 ,p_cpi_attribute21 in varchar2 default null
444 ,p_cpi_attribute22 in varchar2 default null
445 ,p_cpi_attribute23 in varchar2 default null
446 ,p_cpi_attribute24 in varchar2 default null
447 ,p_cpi_attribute25 in varchar2 default null
448 ,p_cpi_attribute26 in varchar2 default null
449 ,p_cpi_attribute27 in varchar2 default null
450 ,p_cpi_attribute28 in varchar2 default null
451 ,p_cpi_attribute29 in varchar2 default null
452 ,p_cpi_attribute30 in varchar2 default null
453 ,p_feedback_date in date default null
454 ,p_object_version_number out nocopy number
455 );
456 --
457 -- ----------------------------------------------------------------------------
458 -- |----------------------------< update_person_info >------------------------|
459 -- ----------------------------------------------------------------------------
460 --
461 -- {Start Of Comments}
462 /*#
463 * This API updates a snapshot of a person for compensation workbench
464 * processing.
465 *
466 * Updates denormalized person information that is a snapshot in time (as of
467 * the freeze date) from the HR Person Table
468 *
469 * <p><b>Licensing</b><br>
470 * This API is licensed for use with Human Resources.
471 *
472 * <p><b>Prerequisites</b><br>
476 * The person information will be updated in the database.
473 * A Compensation Workbench Person record to update must exist in the database.
474 *
475 * <p><b>Post Success</b><br>
477 *
478 * <p><b>Post Failure</b><br>
479 * The person information will not be updated.
480 *
481 * @param p_validate If true, then validation alone will be performed and the
482 * database will remain unchanged. If false and all validation checks pass,
483 * then the database will be modified.
484 * @param p_group_per_in_ler_id This parameter identifies the Group Life Event
485 * Reason ID of Compensation Workbench Person. Foreign key to BEN_PER_IN_LER.
486 * @param p_assignment_id Identifies the assignment of the Compensation
487 * Workbench Person
488 * @param p_person_id Identifies the person for whom you create the
489 * Compensation Workbench Person record.
490 * @param p_supervisor_id This parameter identifies the person ID of the
491 * manager.
492 * @param p_effective_date Determines when the DateTrack operation comes into
493 * force.
494 * @param p_full_name {@rep:casecolumn BEN_CWB_PERSON_INFO.FULL_NAME}
495 * @param p_brief_name {@rep:casecolumn BEN_CWB_PERSON_INFO.BRIEF_NAME}
496 * @param p_custom_name {@rep:casecolumn BEN_CWB_PERSON_INFO.CUSTOM_NAME}
497 * @param p_supervisor_full_name {@rep:casecolumn
498 * BEN_CWB_PERSON_INFO.SUPERVISOR_FULL_NAME}
499 * @param p_supervisor_brief_name {@rep:casecolumn
500 * BEN_CWB_PERSON_INFO.SUPERVISOR_BRIEF_NAME}
501 * @param p_supervisor_custom_name {@rep:casecolumn
502 * BEN_CWB_PERSON_INFO.SUPERVISOR_CUSTOM_NAME}
503 * @param p_legislation_code This parameter specifies the legislation to which
504 * the information type applies.
505 * @param p_years_employed This parameter specifies the number of years
506 * employed.
507 * @param p_years_in_job This parameter specifies the number of years employed
508 * in the person's assigned Job.
509 * @param p_years_in_position This parameter specifies the number of years
510 * employed in the person's assigned position.
511 * @param p_years_in_grade This parameter specifies the number of years
512 * employed in the person's assigned grade.
513 * @param p_employee_number This parameter specifies the employee Number
514 * assigned to the Compensation Workbench Person.
515 * @param p_start_date {@rep:casecolumn PER_ALL_PEOPLE_F.START_DATE}
516 * @param p_original_start_date {@rep:casecolumn
517 * PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE}
518 * @param p_adjusted_svc_date {@rep:casecolumn
519 * PER_PERIODS_OF_SERVICE.ADJUSTED_SVC_DATE}
520 * @param p_base_salary {@rep:casecolumn PER_PAY_PROPOSALS.PROPOSED_SALARY_N}
521 * @param p_base_salary_change_date {@rep:casecolumn
522 * PER_PAY_PROPOSALS.CHANGE_DATE}
523 * @param p_payroll_name {@rep:casecolumn PAY_ALL_PAYROLLS_F.PAYROLL_NAME}
524 * @param p_performance_rating {@rep:casecolumn
525 * PER_PERFORMANCE_REVIEWS.PERFORMANCE_RATING}
526 * @param p_performance_rating_type {@rep:casecolumn
527 * BEN_CWB_PERSON_INFO.PERFORMANCE_RATING_TYPE}
528 * @param p_performance_rating_date {@rep:casecolumn
529 * PER_PERFORMANCE_REVIEWS.REVIEW_DATE}
530 * @param p_business_group_id {@rep:casecolumn
531 * PER_ALL_ASSIGNMENTS_F.BUSINESS_GROUP_ID}
532 * @param p_organization_id {@rep:casecolumn
533 * PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID}
534 * @param p_job_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.JOB_ID}
535 * @param p_grade_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.GRADE_ID}
536 * @param p_position_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.POSITION_ID}
537 * @param p_people_group_id {@rep:casecolumn
538 * PER_ALL_ASSIGNMENTS_F.PEOPLE_GROUP_ID}
539 * @param p_soft_coding_keyflex_id {@rep:casecolumn
540 * PER_ALL_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID}
541 * @param p_location_id {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.LOCATION_ID}
542 * @param p_pay_rate_id {@rep:casecolumn PER_PAY_BASES.RATE_ID}
543 * @param p_assignment_status_type_id {@rep:casecolumn
544 * PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID}
545 * @param p_frequency {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.FREQUENCY}
546 * @param p_grade_annulization_factor {@rep:casecolumn
547 * PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR}
548 * @param p_pay_annulization_factor {@rep:casecolumn
549 * PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR}
550 * @param p_grd_min_val {@rep:casecolumn BEN_CWB_PERSON_INFO.GRD_MIN_VAL}
551 * @param p_grd_max_val {@rep:casecolumn BEN_CWB_PERSON_INFO.GRD_MAX_VAL}
552 * @param p_grd_mid_point {@rep:casecolumn BEN_CWB_PERSON_INFO.GRD_MID_POINT}
553 * @param p_grd_quartile {@rep:casecolumn BEN_CWB_PERSON_INFO.GRD_QUARTILE}
554 * @param p_grd_comparatio {@rep:casecolumn BEN_CWB_PERSON_INFO.GRD_COMPARATIO}
555 * @param p_emp_category {@rep:casecolumn
556 * PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY}
557 * @param p_change_reason {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.CHANGE_REASON}
558 * @param p_normal_hours {@rep:casecolumn PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS}
559 * @param p_email_address {@rep:casecolumn PER_ALL_PEOPLE_F.EMAIL_ADDRESS}
560 * @param p_base_salary_frequency {@rep:casecolumn PER_PAY_BASES.PAY_BASIS}
561 * @param p_new_assgn_ovn This parameter specifies the object version number
562 * for assignment changes.
563 * @param p_new_perf_event_id This parameter specifies the performance event
564 * ID.
565 * @param p_new_perf_review_id This parameter specifies the performance review
566 * ID.
567 * @param p_post_process_stat_cd {@rep:casecolumn
568 * BEN_CWB_PERSON_INFO.POST_PROCESS_STAT_CD}
569 * @param p_feedback_rating This parameter specifies the feedback rating. Valid
570 * values are Lookup Code from 'BEN_CWB_SUBMIT_FEEDBACK' lookups.
571 * @param p_feedback_comments This parameter specifies the feedback comments.
572 * @param p_custom_segment1 Placeholder for custom defined alphanumeric values.
573 * @param p_custom_segment2 Placeholder for custom defined alphanumeric values.
574 * @param p_custom_segment3 Placeholder for custom defined alphanumeric values.
578 * @param p_custom_segment7 Placeholder for custom defined alphanumeric values.
575 * @param p_custom_segment4 Placeholder for custom defined alphanumeric values.
576 * @param p_custom_segment5 Placeholder for custom defined alphanumeric values.
577 * @param p_custom_segment6 Placeholder for custom defined alphanumeric values.
579 * @param p_custom_segment8 Placeholder for custom defined alphanumeric values.
580 * @param p_custom_segment9 Placeholder for custom defined alphanumeric values.
581 * @param p_custom_segment10 Placeholder for custom defined alphanumeric values.
582 * @param p_custom_segment11 Placeholder for custom defined numeric values.
583 * @param p_custom_segment12 Placeholder for custom defined numeric values.
584 * @param p_custom_segment13 Placeholder for custom defined numeric values.
585 * @param p_custom_segment14 Placeholder for custom defined numeric values.
586 * @param p_custom_segment15 Placeholder for custom defined numeric values.
587 * @param p_ass_attribute_category This parameter specifies the assigment
588 * attribute category.
589 * @param p_ass_attribute1 Developer descriptive flexfield segment for
590 * Assignment.
591 * @param p_ass_attribute2 Developer descriptive flexfield segment for
592 * Assignment.
593 * @param p_ass_attribute3 Developer descriptive flexfield segment for
594 * Assignment.
595 * @param p_ass_attribute4 Developer descriptive flexfield segment for
596 * Assignment.
597 * @param p_ass_attribute5 Developer descriptive flexfield segment for
598 * Assignment.
599 * @param p_ass_attribute6 Developer descriptive flexfield segment for
600 * Assignment.
601 * @param p_ass_attribute7 Developer descriptive flexfield segment for
602 * Assignment.
603 * @param p_ass_attribute8 Developer descriptive flexfield segment for
604 * Assignment.
605 * @param p_ass_attribute9 Developer descriptive flexfield segment for
606 * Assignment.
607 * @param p_ass_attribute10 Developer descriptive flexfield segment for
608 * Assignment.
609 * @param p_ass_attribute11 Developer descriptive flexfield segment for
610 * Assignment.
611 * @param p_ass_attribute12 Developer descriptive flexfield segment for
612 * Assignment.
613 * @param p_ass_attribute13 Developer descriptive flexfield segment for
614 * Assignment.
615 * @param p_ass_attribute14 Developer descriptive flexfield segment for
616 * Assignment.
617 * @param p_ass_attribute15 Developer descriptive flexfield segment for
618 * Assignment.
619 * @param p_ass_attribute16 Developer descriptive flexfield segment for
620 * Assignment.
621 * @param p_ass_attribute17 Developer descriptive flexfield segment for
622 * Assignment.
623 * @param p_ass_attribute18 Developer descriptive flexfield segment for
624 * Assignment.
625 * @param p_ass_attribute19 Developer descriptive flexfield segment for
626 * Assignment.
627 * @param p_ass_attribute20 Developer descriptive flexfield segment for
628 * Assignment.
629 * @param p_ass_attribute21 Developer descriptive flexfield segment for
630 * Assignment.
631 * @param p_ass_attribute22 Developer descriptive flexfield segment for
632 * Assignment.
633 * @param p_ass_attribute23 Developer descriptive flexfield segment for
634 * Assignment.
635 * @param p_ass_attribute24 Developer descriptive flexfield segment for
636 * Assignment.
637 * @param p_ass_attribute25 Developer descriptive flexfield segment for
638 * Assignment.
639 * @param p_ass_attribute26 Developer descriptive flexfield segment for
640 * Assignment.
641 * @param p_ass_attribute27 Developer descriptive flexfield segment for
642 * Assignment.
643 * @param p_ass_attribute28 Developer descriptive flexfield segment for
644 * Assignment.
645 * @param p_ass_attribute29 Developer descriptive flexfield segment for
646 * Assignment.
647 * @param p_ass_attribute30 Developer descriptive flexfield segment for
648 * Assignment.
649 * @param p_ws_comments {@rep:casecolumn BEN_CWB_PERSON_INFO.WS_COMMENTS}
650 * @param p_people_group_name {@rep:casecolumn PAY_PEOPLE_GROUPS.GROUP_NAME}
651 * @param p_people_group_segment1 Developer descriptive flexfield segment for
652 * People Group.
653 * @param p_people_group_segment2 Developer descriptive flexfield segment for
654 * People Group.
655 * @param p_people_group_segment3 Developer descriptive flexfield segment for
656 * People Group.
657 * @param p_people_group_segment4 Developer descriptive flexfield segment for
658 * People Group.
659 * @param p_people_group_segment5 Developer descriptive flexfield segment for
660 * People Group.
661 * @param p_people_group_segment6 Developer descriptive flexfield segment for
662 * People Group.
663 * @param p_people_group_segment7 Developer descriptive flexfield segment for
664 * People Group.
665 * @param p_people_group_segment8 Developer descriptive flexfield segment for
666 * People Group.
667 * @param p_people_group_segment9 Developer descriptive flexfield segment for
668 * People Group.
669 * @param p_people_group_segment10 Developer descriptive flexfield segment for
670 * People Group.
671 * @param p_people_group_segment11 Developer descriptive flexfield segment for
672 * People Group.
673 * @param p_cpi_attribute_category {@rep:casecolumn
674 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE_CATEGORY}
675 * @param p_cpi_attribute1 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE1}
676 * @param p_cpi_attribute2 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE2}
677 * @param p_cpi_attribute3 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE3}
678 * @param p_cpi_attribute4 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE4}
679 * @param p_cpi_attribute5 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE5}
680 * @param p_cpi_attribute6 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE6}
681 * @param p_cpi_attribute7 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE7}
685 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE10}
682 * @param p_cpi_attribute8 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE8}
683 * @param p_cpi_attribute9 {@rep:casecolumn BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE9}
684 * @param p_cpi_attribute10 {@rep:casecolumn
686 * @param p_cpi_attribute11 {@rep:casecolumn
687 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE11}
688 * @param p_cpi_attribute12 {@rep:casecolumn
689 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE12}
690 * @param p_cpi_attribute13 {@rep:casecolumn
691 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE13}
692 * @param p_cpi_attribute14 {@rep:casecolumn
693 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE14}
694 * @param p_cpi_attribute15 {@rep:casecolumn
695 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE15}
696 * @param p_cpi_attribute16 {@rep:casecolumn
697 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE16}
698 * @param p_cpi_attribute17 {@rep:casecolumn
699 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE17}
700 * @param p_cpi_attribute18 {@rep:casecolumn
701 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE18}
702 * @param p_cpi_attribute19 {@rep:casecolumn
703 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE19}
704 * @param p_cpi_attribute20 {@rep:casecolumn
705 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE20}
706 * @param p_cpi_attribute21 {@rep:casecolumn
707 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE21}
708 * @param p_cpi_attribute22 {@rep:casecolumn
709 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE22}
710 * @param p_cpi_attribute23 {@rep:casecolumn
711 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE23}
712 * @param p_cpi_attribute24 {@rep:casecolumn
713 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE24}
714 * @param p_cpi_attribute25 {@rep:casecolumn
715 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE25}
716 * @param p_cpi_attribute26 {@rep:casecolumn
717 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE26}
718 * @param p_cpi_attribute27 {@rep:casecolumn
719 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE27}
720 * @param p_cpi_attribute28 {@rep:casecolumn
721 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE28}
722 * @param p_cpi_attribute29 {@rep:casecolumn
723 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE29}
724 * @param p_cpi_attribute30 {@rep:casecolumn
725 * BEN_CWB_PERSON_INFO.CPI_ATTRIBUTE30}
726 * @param p_feedback_date This parameter specifies the feedback date.
727 * @param p_object_version_number Pass in the current version number of the
728 * Group Person Life Event Reason to be updated. When the API completes if
729 * p_validate is false, will be set to the new version number of the updated
730 * Group Person Life Event Reason. If p_validate is true will be set to the
731 * same value which was passed in.
732 * @param p_custom_segment16 Placeholder for custom defined numeric values.
733 * @param p_custom_segment17 Placeholder for custom defined numeric values.
734 * @param p_custom_segment18 Placeholder for custom defined numeric values.
735 * @param p_custom_segment19 Placeholder for custom defined numeric values.
736 * @param p_custom_segment20 Placeholder for custom defined numeric values.
737 * @rep:displayname Update Person Information
738 * @rep:category BUSINESS_ENTITY BEN_CWB_PERSON
739 * @rep:lifecycle active
740 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
741 * @rep:scope public
742 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
743 */
744 --
745 -- {End Of Comments}
746 --
747 procedure update_person_info
748 (p_validate in boolean default false
749 ,p_group_per_in_ler_id in number
750 ,p_assignment_id in number default hr_api.g_number
751 ,p_person_id in number default hr_api.g_number
752 ,p_supervisor_id in number default hr_api.g_number
753 ,p_effective_date in date default hr_api.g_date
754 ,p_full_name in varchar2 default hr_api.g_varchar2
755 ,p_brief_name in varchar2 default hr_api.g_varchar2
756 ,p_custom_name in varchar2 default hr_api.g_varchar2
757 ,p_supervisor_full_name in varchar2 default hr_api.g_varchar2
758 ,p_supervisor_brief_name in varchar2 default hr_api.g_varchar2
759 ,p_supervisor_custom_name in varchar2 default hr_api.g_varchar2
760 ,p_legislation_code in varchar2 default hr_api.g_varchar2
761 ,p_years_employed in number default hr_api.g_number
762 ,p_years_in_job in number default hr_api.g_number
763 ,p_years_in_position in number default hr_api.g_number
764 ,p_years_in_grade in number default hr_api.g_number
765 ,p_employee_number in varchar2 default hr_api.g_varchar2
766 ,p_start_date in date default hr_api.g_date
767 ,p_original_start_date in date default hr_api.g_date
768 ,p_adjusted_svc_date in date default hr_api.g_date
769 ,p_base_salary in number default hr_api.g_number
770 ,p_base_salary_change_date in date default hr_api.g_date
771 ,p_payroll_name in varchar2 default hr_api.g_varchar2
772 ,p_performance_rating in varchar2 default hr_api.g_varchar2
773 ,p_performance_rating_type in varchar2 default hr_api.g_varchar2
774 ,p_performance_rating_date in date default hr_api.g_date
775 ,p_business_group_id in number default hr_api.g_number
776 ,p_organization_id in number default hr_api.g_number
777 ,p_job_id in number default hr_api.g_number
778 ,p_grade_id in number default hr_api.g_number
779 ,p_position_id in number default hr_api.g_number
780 ,p_people_group_id in number default hr_api.g_number
781 ,p_soft_coding_keyflex_id in number default hr_api.g_number
782 ,p_location_id in number default hr_api.g_number
786 ,p_grade_annulization_factor in number default hr_api.g_number
783 ,p_pay_rate_id in number default hr_api.g_number
784 ,p_assignment_status_type_id in number default hr_api.g_number
785 ,p_frequency in varchar2 default hr_api.g_varchar2
787 ,p_pay_annulization_factor in number default hr_api.g_number
788 ,p_grd_min_val in number default hr_api.g_number
789 ,p_grd_max_val in number default hr_api.g_number
790 ,p_grd_mid_point in number default hr_api.g_number
791 ,p_grd_quartile in varchar2 default hr_api.g_varchar2
792 ,p_grd_comparatio in number default hr_api.g_number
793 ,p_emp_category in varchar2 default hr_api.g_varchar2
794 ,p_change_reason in varchar2 default hr_api.g_varchar2
795 ,p_normal_hours in number default hr_api.g_number
796 ,p_email_address in varchar2 default hr_api.g_varchar2
797 ,p_base_salary_frequency in varchar2 default hr_api.g_varchar2
798 ,p_new_assgn_ovn in number default hr_api.g_number
799 ,p_new_perf_event_id in number default hr_api.g_number
800 ,p_new_perf_review_id in number default hr_api.g_number
801 ,p_post_process_stat_cd in varchar2 default hr_api.g_varchar2
802 ,p_feedback_rating in varchar2 default hr_api.g_varchar2
803 ,p_feedback_comments in varchar2 default hr_api.g_varchar2
804 ,p_custom_segment1 in varchar2 default hr_api.g_varchar2
805 ,p_custom_segment2 in varchar2 default hr_api.g_varchar2
806 ,p_custom_segment3 in varchar2 default hr_api.g_varchar2
807 ,p_custom_segment4 in varchar2 default hr_api.g_varchar2
808 ,p_custom_segment5 in varchar2 default hr_api.g_varchar2
809 ,p_custom_segment6 in varchar2 default hr_api.g_varchar2
810 ,p_custom_segment7 in varchar2 default hr_api.g_varchar2
811 ,p_custom_segment8 in varchar2 default hr_api.g_varchar2
812 ,p_custom_segment9 in varchar2 default hr_api.g_varchar2
813 ,p_custom_segment10 in varchar2 default hr_api.g_varchar2
814 ,p_custom_segment11 in number default hr_api.g_number
815 ,p_custom_segment12 in number default hr_api.g_number
816 ,p_custom_segment13 in number default hr_api.g_number
817 ,p_custom_segment14 in number default hr_api.g_number
818 ,p_custom_segment15 in number default hr_api.g_number
819 ,p_custom_segment16 in number default hr_api.g_number
820 ,p_custom_segment17 in number default hr_api.g_number
821 ,p_custom_segment18 in number default hr_api.g_number
822 ,p_custom_segment19 in number default hr_api.g_number
823 ,p_custom_segment20 in number default hr_api.g_number
824 ,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
825 ,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
826 ,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
827 ,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
828 ,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
829 ,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
830 ,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
831 ,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
832 ,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
833 ,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
834 ,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
835 ,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
836 ,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
837 ,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
838 ,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
839 ,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
840 ,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
841 ,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
842 ,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
843 ,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
844 ,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
845 ,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
846 ,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
847 ,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
848 ,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
849 ,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
850 ,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
851 ,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
852 ,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
853 ,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
854 ,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
855 ,p_ws_comments in varchar2 default hr_api.g_varchar2
856 ,p_people_group_name in varchar2 default hr_api.g_varchar2
857 ,p_people_group_segment1 in varchar2 default hr_api.g_varchar2
858 ,p_people_group_segment2 in varchar2 default hr_api.g_varchar2
859 ,p_people_group_segment3 in varchar2 default hr_api.g_varchar2
860 ,p_people_group_segment4 in varchar2 default hr_api.g_varchar2
861 ,p_people_group_segment5 in varchar2 default hr_api.g_varchar2
862 ,p_people_group_segment6 in varchar2 default hr_api.g_varchar2
863 ,p_people_group_segment7 in varchar2 default hr_api.g_varchar2
864 ,p_people_group_segment8 in varchar2 default hr_api.g_varchar2
865 ,p_people_group_segment9 in varchar2 default hr_api.g_varchar2
866 ,p_people_group_segment10 in varchar2 default hr_api.g_varchar2
867 ,p_people_group_segment11 in varchar2 default hr_api.g_varchar2
868 ,p_cpi_attribute_category in varchar2 default hr_api.g_varchar2
869 ,p_cpi_attribute1 in varchar2 default hr_api.g_varchar2
870 ,p_cpi_attribute2 in varchar2 default hr_api.g_varchar2
871 ,p_cpi_attribute3 in varchar2 default hr_api.g_varchar2
872 ,p_cpi_attribute4 in varchar2 default hr_api.g_varchar2
873 ,p_cpi_attribute5 in varchar2 default hr_api.g_varchar2
874 ,p_cpi_attribute6 in varchar2 default hr_api.g_varchar2
875 ,p_cpi_attribute7 in varchar2 default hr_api.g_varchar2
876 ,p_cpi_attribute8 in varchar2 default hr_api.g_varchar2
877 ,p_cpi_attribute9 in varchar2 default hr_api.g_varchar2
878 ,p_cpi_attribute10 in varchar2 default hr_api.g_varchar2
879 ,p_cpi_attribute11 in varchar2 default hr_api.g_varchar2
880 ,p_cpi_attribute12 in varchar2 default hr_api.g_varchar2
881 ,p_cpi_attribute13 in varchar2 default hr_api.g_varchar2
882 ,p_cpi_attribute14 in varchar2 default hr_api.g_varchar2
883 ,p_cpi_attribute15 in varchar2 default hr_api.g_varchar2
884 ,p_cpi_attribute16 in varchar2 default hr_api.g_varchar2
885 ,p_cpi_attribute17 in varchar2 default hr_api.g_varchar2
886 ,p_cpi_attribute18 in varchar2 default hr_api.g_varchar2
887 ,p_cpi_attribute19 in varchar2 default hr_api.g_varchar2
888 ,p_cpi_attribute20 in varchar2 default hr_api.g_varchar2
889 ,p_cpi_attribute21 in varchar2 default hr_api.g_varchar2
890 ,p_cpi_attribute22 in varchar2 default hr_api.g_varchar2
891 ,p_cpi_attribute23 in varchar2 default hr_api.g_varchar2
892 ,p_cpi_attribute24 in varchar2 default hr_api.g_varchar2
893 ,p_cpi_attribute25 in varchar2 default hr_api.g_varchar2
894 ,p_cpi_attribute26 in varchar2 default hr_api.g_varchar2
895 ,p_cpi_attribute27 in varchar2 default hr_api.g_varchar2
896 ,p_cpi_attribute28 in varchar2 default hr_api.g_varchar2
897 ,p_cpi_attribute29 in varchar2 default hr_api.g_varchar2
898 ,p_cpi_attribute30 in varchar2 default hr_api.g_varchar2
899 ,p_feedback_date in date default hr_api.g_date
900 ,p_object_version_number in out nocopy number
901 );
902 --
903 -- ----------------------------------------------------------------------------
904 -- |----------------------------< delete_person_info >------------------------|
905 -- ----------------------------------------------------------------------------
906 --
907 -- {Start Of Comments}
908 /*#
909 * This API deletes Compensation Workbench information for a person.
910 *
911 *
912 * <p><b>Licensing</b><br>
913 * This API is licensed for use with Human Resources.
914 *
915 * <p><b>Prerequisites</b><br>
916 * A Compensation Workbench Person record to delete must exist in the database.
917 *
918 * <p><b>Post Success</b><br>
919 * The person information will be deleted from the database.
920 *
921 * <p><b>Post Failure</b><br>
922 * The person information will not be deleted.
923 *
924 * @param p_validate If true, then validation alone will be performed and the
925 * database will remain unchanged. If false and all validation checks pass,
926 * then the database will be modified.
927 * @param p_group_per_in_ler_id This parameter identifies the Group Life Event
928 * Reason ID of Compensation Workbench Person. Foreign key to BEN_PER_IN_LER.
929 * @param p_object_version_number Current version number of the Group Person
930 * Life Event Reason to be deleted.
931 * @rep:displayname Delete Person Information
932 * @rep:category BUSINESS_ENTITY BEN_CWB_PERSON
933 * @rep:lifecycle active
934 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
935 * @rep:scope public
936 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
937 */
938 --
939 -- {End Of Comments}
940 --
941 procedure delete_person_info
942 (p_validate in boolean default false
943 ,p_group_per_in_ler_id in number
944 ,p_object_version_number in number
945 );
946
947 end BEN_CWB_PERSON_INFO_API;