[Home] [Help]
PACKAGE BODY: APPS.HRDPP_UPDATE_PERSON
Source
1 package body hrdpp_UPDATE_PERSON as
2 /*
3 * Generated by hr_pump_meta_mapper at: 2009/03/30 04:03:09
4 * Generated for API: HR_PERSON_API.UPDATE_PERSON
5 */
6 --
7 dh constant date := hr_api.g_date;
8 nh constant number := hr_api.g_number;
9 vh constant varchar2(64) := hr_api.g_varchar2;
10 c_sot constant date := to_date('01010001','DDMMYYYY');
11 cn constant varchar2(32) := '<NULL>';
12 dn constant date := null;
13 nn constant number := null;
14 vn constant varchar2(1) := null;
15 --
16 function dc(p in date) return varchar2 is
17 begin
18 if p<c_sot then
19 if p<>trunc(p) then
20 return to_char(p,'SYYYY/MM/DD HH24:MI:SS');
21 end if;
22 return to_char(p,'SYYYY/MM/DD');
23 elsif p<>trunc(p) then
24 return to_char(p,'YYYY/MM/DD HH24:MI:SS');
25 end if;
26 return to_char(p,'YYYY/MM/DD');
27 end dc;
28 function d(p in varchar2) return date is
29 begin
30 if length(p)=10 then
31 return to_date(p,'YYYY/MM/DD');
32 elsif length(p)=19 then
33 return to_date(p,'YYYY/MM/DD HH24:MI:SS');
34 elsif length(p)=11 then
35 return to_date(p,'SYYYY/MM/DD');
36 elsif length(p)=20 then
37 return to_date(p,'SYYYY/MM/DD HH24:MI:SS');
38 end if;
39 -- Try default format as last resort.
40 return to_date(p,'YYYY/MM/DD');
41 end d;
42 function n(p in varchar2) return number is
43 begin
44 return to_number(p);
45 end n;
46 function dd(p in date,i in varchar2)
47 return varchar2 is
48 begin
49 if upper(i) = 'N' then return dc(p);
50 else return cn; end if;
51 end dd;
52 function nd(p in number,i in varchar2)
53 return varchar2 is
54 begin
55 if upper(i) = 'N' then return to_char(p);
56 else return cn; end if;
57 end nd;
58 --
59 procedure iuk
60 (p_batch_line_id in number,
61 p_user_key_value in varchar2,
62 p_unique_key_id in number)
63 is
64 begin
65 hr_data_pump.entry('ins_user_key');
66 insert into hr_pump_batch_line_user_keys
67 (user_key_id, batch_line_id,user_key_value,unique_key_id)
68 values
69 (hr_pump_batch_line_user_keys_s.nextval,
70 p_batch_line_id,
71 p_user_key_value,
72 p_unique_key_id);
73 hr_data_pump.exit('ins_user_key');
74 end iuk;
75 --
76 procedure insert_batch_lines
77 (p_batch_id in number
78 ,p_data_pump_batch_line_id in number default null
79 ,p_data_pump_business_grp_name in varchar2 default null
80 ,p_user_sequence in number default null
81 ,p_link_value in number default null
82 ,P_EFFECTIVE_DATE in date
83 ,P_DATETRACK_UPDATE_MODE in varchar2
84 ,P_LAST_NAME in varchar2 default null
85 ,P_APPLICANT_NUMBER in varchar2 default null
86 ,P_COMMENTS in varchar2 default null
87 ,P_DATE_EMPLOYEE_DATA_VERIFIED in date default null
88 ,I_DATE_EMPLOYEE_DATA_VERIFIED in varchar2 default 'N'
89 ,P_DATE_OF_BIRTH in date default null
90 ,I_DATE_OF_BIRTH in varchar2 default 'N'
91 ,P_EMAIL_ADDRESS in varchar2 default null
92 ,P_EMPLOYEE_NUMBER in varchar2
93 ,P_EXPENSE_CHECK_SEND_TO_ADDRES in varchar2 default null
94 ,P_FIRST_NAME in varchar2 default null
95 ,P_KNOWN_AS in varchar2 default null
96 ,P_MARITAL_STATUS in varchar2 default null
97 ,P_MIDDLE_NAMES in varchar2 default null
98 ,P_NATIONALITY in varchar2 default null
99 ,P_NATIONAL_IDENTIFIER in varchar2 default null
100 ,P_PREVIOUS_LAST_NAME in varchar2 default null
101 ,P_REGISTERED_DISABLED_FLAG in varchar2 default null
102 ,P_SEX in varchar2 default null
103 ,P_TITLE in varchar2 default null
104 ,P_WORK_TELEPHONE in varchar2 default null
105 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
106 ,P_ATTRIBUTE1 in varchar2 default null
107 ,P_ATTRIBUTE2 in varchar2 default null
108 ,P_ATTRIBUTE3 in varchar2 default null
109 ,P_ATTRIBUTE4 in varchar2 default null
110 ,P_ATTRIBUTE5 in varchar2 default null
111 ,P_ATTRIBUTE6 in varchar2 default null
112 ,P_ATTRIBUTE7 in varchar2 default null
113 ,P_ATTRIBUTE8 in varchar2 default null
114 ,P_ATTRIBUTE9 in varchar2 default null
115 ,P_ATTRIBUTE10 in varchar2 default null
116 ,P_ATTRIBUTE11 in varchar2 default null
117 ,P_ATTRIBUTE12 in varchar2 default null
118 ,P_ATTRIBUTE13 in varchar2 default null
119 ,P_ATTRIBUTE14 in varchar2 default null
120 ,P_ATTRIBUTE15 in varchar2 default null
121 ,P_ATTRIBUTE16 in varchar2 default null
122 ,P_ATTRIBUTE17 in varchar2 default null
123 ,P_ATTRIBUTE18 in varchar2 default null
124 ,P_ATTRIBUTE19 in varchar2 default null
125 ,P_ATTRIBUTE20 in varchar2 default null
126 ,P_ATTRIBUTE21 in varchar2 default null
127 ,P_ATTRIBUTE22 in varchar2 default null
128 ,P_ATTRIBUTE23 in varchar2 default null
129 ,P_ATTRIBUTE24 in varchar2 default null
130 ,P_ATTRIBUTE25 in varchar2 default null
131 ,P_ATTRIBUTE26 in varchar2 default null
132 ,P_ATTRIBUTE27 in varchar2 default null
133 ,P_ATTRIBUTE28 in varchar2 default null
134 ,P_ATTRIBUTE29 in varchar2 default null
135 ,P_ATTRIBUTE30 in varchar2 default null
136 ,P_PER_INFORMATION_CATEGORY in varchar2 default null
137 ,P_PER_INFORMATION1 in varchar2 default null
138 ,P_PER_INFORMATION2 in varchar2 default null
139 ,P_PER_INFORMATION3 in varchar2 default null
140 ,P_PER_INFORMATION4 in varchar2 default null
141 ,P_PER_INFORMATION5 in varchar2 default null
142 ,P_PER_INFORMATION6 in varchar2 default null
143 ,P_PER_INFORMATION7 in varchar2 default null
144 ,P_PER_INFORMATION8 in varchar2 default null
145 ,P_PER_INFORMATION9 in varchar2 default null
146 ,P_PER_INFORMATION10 in varchar2 default null
147 ,P_PER_INFORMATION11 in varchar2 default null
148 ,P_PER_INFORMATION12 in varchar2 default null
149 ,P_PER_INFORMATION13 in varchar2 default null
150 ,P_PER_INFORMATION14 in varchar2 default null
151 ,P_PER_INFORMATION15 in varchar2 default null
152 ,P_PER_INFORMATION16 in varchar2 default null
153 ,P_PER_INFORMATION17 in varchar2 default null
154 ,P_PER_INFORMATION18 in varchar2 default null
155 ,P_PER_INFORMATION19 in varchar2 default null
156 ,P_PER_INFORMATION20 in varchar2 default null
157 ,P_PER_INFORMATION21 in varchar2 default null
158 ,P_PER_INFORMATION22 in varchar2 default null
159 ,P_PER_INFORMATION23 in varchar2 default null
160 ,P_PER_INFORMATION24 in varchar2 default null
161 ,P_PER_INFORMATION25 in varchar2 default null
162 ,P_PER_INFORMATION26 in varchar2 default null
163 ,P_PER_INFORMATION27 in varchar2 default null
164 ,P_PER_INFORMATION28 in varchar2 default null
165 ,P_PER_INFORMATION29 in varchar2 default null
166 ,P_PER_INFORMATION30 in varchar2 default null
167 ,P_DATE_OF_DEATH in date default null
168 ,I_DATE_OF_DEATH in varchar2 default 'N'
169 ,P_BACKGROUND_CHECK_STATUS in varchar2 default null
170 ,P_BACKGROUND_DATE_CHECK in date default null
171 ,I_BACKGROUND_DATE_CHECK in varchar2 default 'N'
172 ,P_BLOOD_TYPE in varchar2 default null
173 ,P_FAST_PATH_EMPLOYEE in varchar2 default null
174 ,P_FTE_CAPACITY in number default null
175 ,I_FTE_CAPACITY in varchar2 default 'N'
176 ,P_HOLD_APPLICANT_DATE_UNTIL in date default null
177 ,I_HOLD_APPLICANT_DATE_UNTIL in varchar2 default 'N'
178 ,P_HONORS in varchar2 default null
179 ,P_INTERNAL_LOCATION in varchar2 default null
180 ,P_LAST_MEDICAL_TEST_BY in varchar2 default null
181 ,P_LAST_MEDICAL_TEST_DATE in date default null
182 ,I_LAST_MEDICAL_TEST_DATE in varchar2 default 'N'
183 ,P_MAILSTOP in varchar2 default null
184 ,P_OFFICE_NUMBER in varchar2 default null
185 ,P_ON_MILITARY_SERVICE in varchar2 default null
186 ,P_PRE_NAME_ADJUNCT in varchar2 default null
187 ,P_PROJECTED_START_DATE in date default null
188 ,I_PROJECTED_START_DATE in varchar2 default 'N'
189 ,P_REHIRE_AUTHORIZOR in varchar2 default null
190 ,P_REHIRE_RECOMMENDATION in varchar2 default null
191 ,P_RESUME_EXISTS in varchar2 default null
192 ,P_RESUME_LAST_UPDATED in date default null
193 ,I_RESUME_LAST_UPDATED in varchar2 default 'N'
194 ,P_SECOND_PASSPORT_EXISTS in varchar2 default null
195 ,P_STUDENT_STATUS in varchar2 default null
196 ,P_WORK_SCHEDULE in varchar2 default null
197 ,P_REHIRE_REASON in varchar2 default null
198 ,P_SUFFIX in varchar2 default null
199 ,P_RECEIPT_OF_DEATH_CERT_DATE in date default null
200 ,I_RECEIPT_OF_DEATH_CERT_DATE in varchar2 default 'N'
201 ,P_COORD_BEN_MED_PLN_NO in varchar2 default null
202 ,P_COORD_BEN_NO_CVG_FLAG in varchar2 default null
203 ,P_COORD_BEN_MED_EXT_ER in varchar2 default null
204 ,P_COORD_BEN_MED_PL_NAME in varchar2 default null
205 ,P_COORD_BEN_MED_INSR_CRR_NAME in varchar2 default null
206 ,P_COORD_BEN_MED_INSR_CRR_IDENT in varchar2 default null
207 ,P_COORD_BEN_MED_CVG_STRT_DT in date default null
208 ,I_COORD_BEN_MED_CVG_STRT_DT in varchar2 default 'N'
209 ,P_COORD_BEN_MED_CVG_END_DT in date default null
210 ,I_COORD_BEN_MED_CVG_END_DT in varchar2 default 'N'
211 ,P_USES_TOBACCO_FLAG in varchar2 default null
212 ,P_DPDNT_ADOPTION_DATE in date default null
213 ,I_DPDNT_ADOPTION_DATE in varchar2 default 'N'
214 ,P_DPDNT_VLNTRY_SVCE_FLAG in varchar2 default null
215 ,P_ORIGINAL_DATE_OF_HIRE in date default null
216 ,I_ORIGINAL_DATE_OF_HIRE in varchar2 default 'N'
217 ,P_ADJUSTED_SVC_DATE in date default null
218 ,I_ADJUSTED_SVC_DATE in varchar2 default 'N'
219 ,P_TOWN_OF_BIRTH in varchar2 default null
220 ,P_REGION_OF_BIRTH in varchar2 default null
221 ,P_COUNTRY_OF_BIRTH in varchar2 default null
222 ,P_GLOBAL_PERSON_ID in varchar2 default null
223 ,P_PARTY_ID in number default null
224 ,I_PARTY_ID in varchar2 default 'N'
225 ,P_NPW_NUMBER in varchar2 default null
226 ,P_PERSON_USER_KEY in varchar2
227 ,P_USER_PERSON_TYPE in varchar2 default null
228 ,P_LANGUAGE_CODE in varchar2 default null
229 ,P_VENDOR_NAME in varchar2 default null
230 ,P_CORRESPONDENCE_LANGUAGE in varchar2 default null
231 ,P_BENEFIT_GROUP in varchar2 default null) is
232 blid number := p_data_pump_batch_line_id;
233 begin
234 if blid is not null then
235 delete from hr_pump_batch_lines where batch_line_id = blid;
236 delete from hr_pump_batch_exceptions
237 where source_type = 'BATCH_LINE' and source_id = blid;
238 end if;
239 insert into hr_pump_batch_lines
240 (batch_id
241 ,batch_line_id
242 ,business_group_name
243 ,api_module_id
244 ,line_status
245 ,user_sequence
246 ,link_value
247 ,pval001
248 ,pval002
249 ,pval003
250 ,pval004
251 ,pval005
252 ,pval006
253 ,pval007
254 ,pval008
255 ,pval009
256 ,pval010
257 ,pval011
258 ,pval012
259 ,pval013
260 ,pval014
261 ,pval015
262 ,pval016
263 ,pval017
264 ,pval018
265 ,pval019
266 ,pval020
267 ,pval021
268 ,pval022
269 ,pval023
270 ,pval024
271 ,pval025
272 ,pval026
273 ,pval027
274 ,pval028
275 ,pval029
276 ,pval030
277 ,pval031
278 ,pval032
279 ,pval033
280 ,pval034
281 ,pval035
282 ,pval036
283 ,pval037
284 ,pval038
285 ,pval039
286 ,pval040
287 ,pval041
288 ,pval042
289 ,pval043
290 ,pval044
291 ,pval045
292 ,pval046
293 ,pval047
294 ,pval048
295 ,pval049
296 ,pval050
297 ,pval051
298 ,pval052
299 ,pval053
300 ,pval054
301 ,pval055
302 ,pval056
303 ,pval057
304 ,pval058
305 ,pval059
306 ,pval060
307 ,pval061
308 ,pval062
309 ,pval063
310 ,pval064
311 ,pval065
312 ,pval066
313 ,pval067
314 ,pval068
315 ,pval069
316 ,pval070
317 ,pval071
318 ,pval072
319 ,pval073
320 ,pval074
321 ,pval075
322 ,pval076
323 ,pval077
324 ,pval078
325 ,pval079
326 ,pval080
327 ,pval081
328 ,pval082
329 ,pval083
330 ,pval084
331 ,pval085
332 ,pval086
333 ,pval087
334 ,pval088
335 ,pval089
336 ,pval090
337 ,pval091
338 ,pval092
339 ,pval093
340 ,pval094
341 ,pval095
342 ,pval096
343 ,pval097
344 ,pval098
345 ,pval099
346 ,pval100
347 ,pval101
348 ,pval102
349 ,pval103
350 ,pval104
351 ,pval105
352 ,pval106
353 ,pval107
354 ,pval108
355 ,pval109
356 ,pval110
357 ,pval111
358 ,pval112
359 ,pval113
360 ,pval114
361 ,pval115
362 ,pval116
363 ,pval117
364 ,pval118
365 ,pval119
366 ,pval120
367 ,pval121
368 ,pval122
369 ,pval123
370 ,pval124
371 ,pval125
372 ,pval126
373 ,pval127
374 ,pval128
375 ,pval136
376 ,pval137
377 ,pval138
378 ,pval139
379 ,pval140
380 ,pval141)
381 values
382 (p_batch_id
383 ,nvl(blid,hr_pump_batch_lines_s.nextval)
384 ,p_data_pump_business_grp_name
385 ,1212
386 ,'U'
387 ,p_user_sequence
388 ,p_link_value
389 ,dc(P_EFFECTIVE_DATE)
390 ,P_DATETRACK_UPDATE_MODE
391 ,P_LAST_NAME
392 ,P_APPLICANT_NUMBER
393 ,P_COMMENTS
394 ,dd(P_DATE_EMPLOYEE_DATA_VERIFIED,I_DATE_EMPLOYEE_DATA_VERIFIED)
395 ,dd(P_DATE_OF_BIRTH,I_DATE_OF_BIRTH)
396 ,P_EMAIL_ADDRESS
397 ,P_EMPLOYEE_NUMBER
398 ,P_EXPENSE_CHECK_SEND_TO_ADDRES
399 ,P_FIRST_NAME
400 ,P_KNOWN_AS
401 ,P_MARITAL_STATUS
402 ,P_MIDDLE_NAMES
403 ,P_NATIONALITY
404 ,P_NATIONAL_IDENTIFIER
405 ,P_PREVIOUS_LAST_NAME
406 ,P_REGISTERED_DISABLED_FLAG
407 ,P_SEX
408 ,P_TITLE
409 ,P_WORK_TELEPHONE
410 ,P_ATTRIBUTE_CATEGORY
411 ,P_ATTRIBUTE1
412 ,P_ATTRIBUTE2
413 ,P_ATTRIBUTE3
414 ,P_ATTRIBUTE4
415 ,P_ATTRIBUTE5
416 ,P_ATTRIBUTE6
417 ,P_ATTRIBUTE7
418 ,P_ATTRIBUTE8
419 ,P_ATTRIBUTE9
420 ,P_ATTRIBUTE10
421 ,P_ATTRIBUTE11
422 ,P_ATTRIBUTE12
423 ,P_ATTRIBUTE13
424 ,P_ATTRIBUTE14
425 ,P_ATTRIBUTE15
426 ,P_ATTRIBUTE16
427 ,P_ATTRIBUTE17
428 ,P_ATTRIBUTE18
429 ,P_ATTRIBUTE19
430 ,P_ATTRIBUTE20
431 ,P_ATTRIBUTE21
432 ,P_ATTRIBUTE22
433 ,P_ATTRIBUTE23
434 ,P_ATTRIBUTE24
435 ,P_ATTRIBUTE25
436 ,P_ATTRIBUTE26
437 ,P_ATTRIBUTE27
438 ,P_ATTRIBUTE28
439 ,P_ATTRIBUTE29
440 ,P_ATTRIBUTE30
441 ,P_PER_INFORMATION_CATEGORY
442 ,P_PER_INFORMATION1
443 ,P_PER_INFORMATION2
444 ,P_PER_INFORMATION3
445 ,P_PER_INFORMATION4
446 ,P_PER_INFORMATION5
447 ,P_PER_INFORMATION6
448 ,P_PER_INFORMATION7
449 ,P_PER_INFORMATION8
450 ,P_PER_INFORMATION9
451 ,P_PER_INFORMATION10
452 ,P_PER_INFORMATION11
453 ,P_PER_INFORMATION12
454 ,P_PER_INFORMATION13
455 ,P_PER_INFORMATION14
456 ,P_PER_INFORMATION15
457 ,P_PER_INFORMATION16
458 ,P_PER_INFORMATION17
459 ,P_PER_INFORMATION18
460 ,P_PER_INFORMATION19
461 ,P_PER_INFORMATION20
462 ,P_PER_INFORMATION21
463 ,P_PER_INFORMATION22
464 ,P_PER_INFORMATION23
465 ,P_PER_INFORMATION24
466 ,P_PER_INFORMATION25
467 ,P_PER_INFORMATION26
468 ,P_PER_INFORMATION27
469 ,P_PER_INFORMATION28
470 ,P_PER_INFORMATION29
471 ,P_PER_INFORMATION30
472 ,dd(P_DATE_OF_DEATH,I_DATE_OF_DEATH)
473 ,P_BACKGROUND_CHECK_STATUS
474 ,dd(P_BACKGROUND_DATE_CHECK,I_BACKGROUND_DATE_CHECK)
475 ,P_BLOOD_TYPE
476 ,P_FAST_PATH_EMPLOYEE
477 ,nd(P_FTE_CAPACITY,I_FTE_CAPACITY)
478 ,dd(P_HOLD_APPLICANT_DATE_UNTIL,I_HOLD_APPLICANT_DATE_UNTIL)
479 ,P_HONORS
480 ,P_INTERNAL_LOCATION
481 ,P_LAST_MEDICAL_TEST_BY
482 ,dd(P_LAST_MEDICAL_TEST_DATE,I_LAST_MEDICAL_TEST_DATE)
483 ,P_MAILSTOP
484 ,P_OFFICE_NUMBER
485 ,P_ON_MILITARY_SERVICE
486 ,P_PRE_NAME_ADJUNCT
487 ,dd(P_PROJECTED_START_DATE,I_PROJECTED_START_DATE)
488 ,P_REHIRE_AUTHORIZOR
489 ,P_REHIRE_RECOMMENDATION
490 ,P_RESUME_EXISTS
491 ,dd(P_RESUME_LAST_UPDATED,I_RESUME_LAST_UPDATED)
492 ,P_SECOND_PASSPORT_EXISTS
493 ,P_STUDENT_STATUS
494 ,P_WORK_SCHEDULE
495 ,P_REHIRE_REASON
496 ,P_SUFFIX
497 ,dd(P_RECEIPT_OF_DEATH_CERT_DATE,I_RECEIPT_OF_DEATH_CERT_DATE)
498 ,P_COORD_BEN_MED_PLN_NO
499 ,P_COORD_BEN_NO_CVG_FLAG
500 ,P_COORD_BEN_MED_EXT_ER
501 ,P_COORD_BEN_MED_PL_NAME
502 ,P_COORD_BEN_MED_INSR_CRR_NAME
503 ,P_COORD_BEN_MED_INSR_CRR_IDENT
504 ,dd(P_COORD_BEN_MED_CVG_STRT_DT,I_COORD_BEN_MED_CVG_STRT_DT)
505 ,dd(P_COORD_BEN_MED_CVG_END_DT,I_COORD_BEN_MED_CVG_END_DT)
506 ,P_USES_TOBACCO_FLAG
507 ,dd(P_DPDNT_ADOPTION_DATE,I_DPDNT_ADOPTION_DATE)
508 ,P_DPDNT_VLNTRY_SVCE_FLAG
509 ,dd(P_ORIGINAL_DATE_OF_HIRE,I_ORIGINAL_DATE_OF_HIRE)
510 ,dd(P_ADJUSTED_SVC_DATE,I_ADJUSTED_SVC_DATE)
511 ,P_TOWN_OF_BIRTH
512 ,P_REGION_OF_BIRTH
513 ,P_COUNTRY_OF_BIRTH
514 ,P_GLOBAL_PERSON_ID
515 ,nd(P_PARTY_ID,I_PARTY_ID)
516 ,P_NPW_NUMBER
517 ,P_PERSON_USER_KEY
518 ,P_USER_PERSON_TYPE
519 ,P_LANGUAGE_CODE
520 ,P_VENDOR_NAME
521 ,P_CORRESPONDENCE_LANGUAGE
522 ,P_BENEFIT_GROUP);
523 end insert_batch_lines;
524 --
525 procedure call
526 (p_business_group_id in number,
527 p_batch_line_id in number) is
528 cursor cr is
529 select l.rowid myrowid,
530 decode(l.pval001,cn,dn,d(l.pval001)) p1,
531 decode(l.pval002,cn,vn,l.pval002) p2,
532 decode(l.pval003,cn,vn,vn,vh,l.pval003) p3,
533 l.pval003 d3,
537 l.pval005 d5,
534 decode(l.pval004,cn,vn,vn,vh,l.pval004) p4,
535 l.pval004 d4,
536 decode(l.pval005,cn,vn,vn,vh,l.pval005) p5,
538 decode(l.pval006,cn,dn,vn,dh,d(l.pval006)) p6,
539 l.pval006 d6,
540 decode(l.pval007,cn,dn,vn,dh,d(l.pval007)) p7,
541 l.pval007 d7,
542 decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,
543 l.pval008 d8,
544 decode(l.pval009,cn,vn,l.pval009) p9,
545 decode(l.pval010,cn,vn,vn,vh,
546 hr_pump_get.gl(l.pval010,'HOME_OFFICE',d(l.pval001),l.pval138)) p10,
547 l.pval010 d10,
548 decode(l.pval011,cn,vn,vn,vh,l.pval011) p11,
549 l.pval011 d11,
550 decode(l.pval012,cn,vn,vn,vh,l.pval012) p12,
551 l.pval012 d12,
552 decode(l.pval013,cn,vn,vn,vh,
553 hr_pump_get.gl(l.pval013,'MAR_STATUS',d(l.pval001),l.pval138)) p13,
554 l.pval013 d13,
555 decode(l.pval014,cn,vn,vn,vh,l.pval014) p14,
556 l.pval014 d14,
557 decode(l.pval015,cn,vn,vn,vh,
558 hr_pump_get.gl(l.pval015,'NATIONALITY',d(l.pval001),l.pval138)) p15,
559 l.pval015 d15,
560 decode(l.pval016,cn,vn,vn,vh,l.pval016) p16,
561 l.pval016 d16,
562 decode(l.pval017,cn,vn,vn,vh,l.pval017) p17,
563 l.pval017 d17,
564 decode(l.pval018,cn,vn,vn,vh,
565 hr_pump_get.gl(l.pval018,'REGISTERED_DISABLED',d(l.pval001),l.pval138)) p18,
566 l.pval018 d18,
567 decode(l.pval019,cn,vn,vn,vh,
568 hr_pump_get.gl(l.pval019,'SEX',d(l.pval001),l.pval138)) p19,
569 l.pval019 d19,
570 decode(l.pval020,cn,vn,vn,vh,
571 hr_pump_get.gl(l.pval020,'TITLE',d(l.pval001),l.pval138)) p20,
572 l.pval020 d20,
573 decode(l.pval021,cn,vn,vn,vh,l.pval021) p21,
574 l.pval021 d21,
575 decode(l.pval022,cn,vn,vn,vh,l.pval022) p22,
576 l.pval022 d22,
577 decode(l.pval023,cn,vn,vn,vh,l.pval023) p23,
578 l.pval023 d23,
579 decode(l.pval024,cn,vn,vn,vh,l.pval024) p24,
580 l.pval024 d24,
581 decode(l.pval025,cn,vn,vn,vh,l.pval025) p25,
582 l.pval025 d25,
583 decode(l.pval026,cn,vn,vn,vh,l.pval026) p26,
584 l.pval026 d26,
585 decode(l.pval027,cn,vn,vn,vh,l.pval027) p27,
586 l.pval027 d27,
587 decode(l.pval028,cn,vn,vn,vh,l.pval028) p28,
588 l.pval028 d28,
589 decode(l.pval029,cn,vn,vn,vh,l.pval029) p29,
590 l.pval029 d29,
591 decode(l.pval030,cn,vn,vn,vh,l.pval030) p30,
592 l.pval030 d30,
593 decode(l.pval031,cn,vn,vn,vh,l.pval031) p31,
594 l.pval031 d31,
595 decode(l.pval032,cn,vn,vn,vh,l.pval032) p32,
596 l.pval032 d32,
597 decode(l.pval033,cn,vn,vn,vh,l.pval033) p33,
598 l.pval033 d33,
599 decode(l.pval034,cn,vn,vn,vh,l.pval034) p34,
600 l.pval034 d34,
601 decode(l.pval035,cn,vn,vn,vh,l.pval035) p35,
602 l.pval035 d35,
603 decode(l.pval036,cn,vn,vn,vh,l.pval036) p36,
604 l.pval036 d36,
605 decode(l.pval037,cn,vn,vn,vh,l.pval037) p37,
606 l.pval037 d37,
607 decode(l.pval038,cn,vn,vn,vh,l.pval038) p38,
608 l.pval038 d38,
609 decode(l.pval039,cn,vn,vn,vh,l.pval039) p39,
610 l.pval039 d39,
611 decode(l.pval040,cn,vn,vn,vh,l.pval040) p40,
612 l.pval040 d40,
613 decode(l.pval041,cn,vn,vn,vh,l.pval041) p41,
614 l.pval041 d41,
615 decode(l.pval042,cn,vn,vn,vh,l.pval042) p42,
616 l.pval042 d42,
617 decode(l.pval043,cn,vn,vn,vh,l.pval043) p43,
618 l.pval043 d43,
619 decode(l.pval044,cn,vn,vn,vh,l.pval044) p44,
620 l.pval044 d44,
621 decode(l.pval045,cn,vn,vn,vh,l.pval045) p45,
622 l.pval045 d45,
623 decode(l.pval046,cn,vn,vn,vh,l.pval046) p46,
624 l.pval046 d46,
625 decode(l.pval047,cn,vn,vn,vh,l.pval047) p47,
626 l.pval047 d47,
627 decode(l.pval048,cn,vn,vn,vh,l.pval048) p48,
628 l.pval048 d48,
629 decode(l.pval049,cn,vn,vn,vh,l.pval049) p49,
630 l.pval049 d49,
631 decode(l.pval050,cn,vn,vn,vh,l.pval050) p50,
632 l.pval050 d50,
633 decode(l.pval051,cn,vn,vn,vh,l.pval051) p51,
634 l.pval051 d51,
635 decode(l.pval052,cn,vn,vn,vh,l.pval052) p52,
636 l.pval052 d52,
637 decode(l.pval053,cn,vn,vn,vh,l.pval053) p53,
638 l.pval053 d53,
639 decode(l.pval054,cn,vn,vn,vh,l.pval054) p54,
640 l.pval054 d54,
641 decode(l.pval055,cn,vn,vn,vh,l.pval055) p55,
642 l.pval055 d55,
643 decode(l.pval056,cn,vn,vn,vh,l.pval056) p56,
644 l.pval056 d56,
645 decode(l.pval057,cn,vn,vn,vh,l.pval057) p57,
646 l.pval057 d57,
647 decode(l.pval058,cn,vn,vn,vh,l.pval058) p58,
648 l.pval058 d58,
649 decode(l.pval059,cn,vn,vn,vh,l.pval059) p59,
650 l.pval059 d59,
651 decode(l.pval060,cn,vn,vn,vh,l.pval060) p60,
652 l.pval060 d60,
653 decode(l.pval061,cn,vn,vn,vh,l.pval061) p61,
654 l.pval061 d61,
655 decode(l.pval062,cn,vn,vn,vh,l.pval062) p62,
656 l.pval062 d62,
657 decode(l.pval063,cn,vn,vn,vh,l.pval063) p63,
658 l.pval063 d63,
659 decode(l.pval064,cn,vn,vn,vh,l.pval064) p64,
660 l.pval064 d64,
661 decode(l.pval065,cn,vn,vn,vh,l.pval065) p65,
662 l.pval065 d65,
663 decode(l.pval066,cn,vn,vn,vh,l.pval066) p66,
664 l.pval066 d66,
665 decode(l.pval067,cn,vn,vn,vh,l.pval067) p67,
666 l.pval067 d67,
667 decode(l.pval068,cn,vn,vn,vh,l.pval068) p68,
668 l.pval068 d68,
669 decode(l.pval069,cn,vn,vn,vh,l.pval069) p69,
670 l.pval069 d69,
671 decode(l.pval070,cn,vn,vn,vh,l.pval070) p70,
672 l.pval070 d70,
673 decode(l.pval071,cn,vn,vn,vh,l.pval071) p71,
674 l.pval071 d71,
675 decode(l.pval072,cn,vn,vn,vh,l.pval072) p72,
676 l.pval072 d72,
677 decode(l.pval073,cn,vn,vn,vh,l.pval073) p73,
678 l.pval073 d73,
679 decode(l.pval074,cn,vn,vn,vh,l.pval074) p74,
680 l.pval074 d74,
681 decode(l.pval075,cn,vn,vn,vh,l.pval075) p75,
682 l.pval075 d75,
683 decode(l.pval076,cn,vn,vn,vh,l.pval076) p76,
684 l.pval076 d76,
685 decode(l.pval077,cn,vn,vn,vh,l.pval077) p77,
686 l.pval077 d77,
687 decode(l.pval078,cn,vn,vn,vh,l.pval078) p78,
688 l.pval078 d78,
689 decode(l.pval079,cn,vn,vn,vh,l.pval079) p79,
690 l.pval079 d79,
694 l.pval081 d81,
691 decode(l.pval080,cn,vn,vn,vh,l.pval080) p80,
692 l.pval080 d80,
693 decode(l.pval081,cn,vn,vn,vh,l.pval081) p81,
695 decode(l.pval082,cn,vn,vn,vh,l.pval082) p82,
696 l.pval082 d82,
697 decode(l.pval083,cn,vn,vn,vh,l.pval083) p83,
698 l.pval083 d83,
699 decode(l.pval084,cn,dn,vn,dh,d(l.pval084)) p84,
700 l.pval084 d84,
701 decode(l.pval085,cn,vn,vn,vh,
702 hr_pump_get.gl(l.pval085,'YES_NO',d(l.pval001),l.pval138)) p85,
703 l.pval085 d85,
704 decode(l.pval086,cn,dn,vn,dh,d(l.pval086)) p86,
705 l.pval086 d86,
706 decode(l.pval087,cn,vn,vn,vh,
707 hr_pump_get.gl(l.pval087,'BLOOD_TYPE',d(l.pval001),l.pval138)) p87,
708 l.pval087 d87,
709 decode(l.pval088,cn,vn,vn,vh,l.pval088) p88,
710 l.pval088 d88,
711 decode(l.pval089,cn,nn,vn,nh,n(l.pval089)) p89,
712 l.pval089 d89,
713 decode(l.pval090,cn,dn,vn,dh,d(l.pval090)) p90,
714 l.pval090 d90,
715 decode(l.pval091,cn,vn,vn,vh,l.pval091) p91,
716 l.pval091 d91,
717 decode(l.pval092,cn,vn,vn,vh,l.pval092) p92,
718 l.pval092 d92,
719 decode(l.pval093,cn,vn,vn,vh,l.pval093) p93,
720 l.pval093 d93,
721 decode(l.pval094,cn,dn,vn,dh,d(l.pval094)) p94,
722 l.pval094 d94,
723 decode(l.pval095,cn,vn,vn,vh,l.pval095) p95,
724 l.pval095 d95,
725 decode(l.pval096,cn,vn,vn,vh,l.pval096) p96,
726 l.pval096 d96,
727 decode(l.pval097,cn,vn,vn,vh,
728 hr_pump_get.gl(l.pval097,'YES_NO',d(l.pval001),l.pval138)) p97,
729 l.pval097 d97,
730 decode(l.pval098,cn,vn,vn,vh,l.pval098) p98,
731 l.pval098 d98,
732 decode(l.pval099,cn,dn,vn,dh,d(l.pval099)) p99,
733 l.pval099 d99,
734 decode(l.pval100,cn,vn,vn,vh,l.pval100) p100,
735 l.pval100 d100,
736 decode(l.pval101,cn,vn,vn,vh,
737 hr_pump_get.gl(l.pval101,'YES_NO',d(l.pval001),l.pval138)) p101,
738 l.pval101 d101,
739 decode(l.pval102,cn,vn,vn,vh,
740 hr_pump_get.gl(l.pval102,'YES_NO',d(l.pval001),l.pval138)) p102,
741 l.pval102 d102,
742 decode(l.pval103,cn,dn,vn,dh,d(l.pval103)) p103,
743 l.pval103 d103,
744 decode(l.pval104,cn,vn,vn,vh,
745 hr_pump_get.gl(l.pval104,'YES_NO',d(l.pval001),l.pval138)) p104,
746 l.pval104 d104,
747 decode(l.pval105,cn,vn,vn,vh,
748 hr_pump_get.gl(l.pval105,'STUDENT_STATUS',d(l.pval001),l.pval138)) p105,
749 l.pval105 d105,
750 decode(l.pval106,cn,vn,vn,vh,
751 hr_pump_get.gl(l.pval106,'WORK_SCHEDULE',d(l.pval001),l.pval138)) p106,
752 l.pval106 d106,
753 decode(l.pval107,cn,vn,vn,vh,l.pval107) p107,
754 l.pval107 d107,
755 decode(l.pval108,cn,vn,vn,vh,l.pval108) p108,
756 l.pval108 d108,
757 decode(l.pval109,cn,dn,vn,dh,d(l.pval109)) p109,
758 l.pval109 d109,
759 decode(l.pval110,cn,vn,vn,vh,l.pval110) p110,
760 l.pval110 d110,
761 decode(l.pval111,cn,vn,vn,vh,l.pval111) p111,
762 l.pval111 d111,
763 decode(l.pval112,cn,vn,vn,vh,l.pval112) p112,
764 l.pval112 d112,
765 decode(l.pval113,cn,vn,vn,vh,l.pval113) p113,
766 l.pval113 d113,
767 decode(l.pval114,cn,vn,vn,vh,l.pval114) p114,
768 l.pval114 d114,
769 decode(l.pval115,cn,vn,vn,vh,l.pval115) p115,
770 l.pval115 d115,
771 decode(l.pval116,cn,dn,vn,dh,d(l.pval116)) p116,
772 l.pval116 d116,
776 l.pval118 d118,
773 decode(l.pval117,cn,dn,vn,dh,d(l.pval117)) p117,
774 l.pval117 d117,
775 decode(l.pval118,cn,vn,vn,vh,l.pval118) p118,
777 decode(l.pval119,cn,dn,vn,dh,d(l.pval119)) p119,
778 l.pval119 d119,
779 decode(l.pval120,cn,vn,vn,vh,l.pval120) p120,
780 l.pval120 d120,
781 decode(l.pval121,cn,dn,vn,dh,d(l.pval121)) p121,
782 l.pval121 d121,
783 decode(l.pval122,cn,dn,vn,dh,d(l.pval122)) p122,
784 l.pval122 d122,
785 decode(l.pval123,cn,vn,vn,vh,l.pval123) p123,
786 l.pval123 d123,
787 decode(l.pval124,cn,vn,vn,vh,l.pval124) p124,
788 l.pval124 d124,
789 decode(l.pval125,cn,vn,vn,vh,l.pval125) p125,
790 l.pval125 d125,
791 decode(l.pval126,cn,vn,vn,vh,l.pval126) p126,
792 l.pval126 d126,
793 decode(l.pval127,cn,nn,vn,nh,n(l.pval127)) p127,
794 l.pval127 d127,
795 decode(l.pval128,cn,vn,vn,vh,l.pval128) p128,
796 l.pval128 d128,
797 decode(l.pval129,cn,dn,d(l.pval129)) p129,
798 decode(l.pval130,cn,dn,d(l.pval130)) p130,
799 l.pval131 p131,
800 l.pval132 p132,
801 l.pval133 p133,
802 l.pval134 p134,
803 l.pval135 p135,
804 decode(l.pval136,cn,vn,l.pval136) p136,
805 decode(l.pval137,cn,vn,vn,vh,l.pval137) p137,
806 l.pval137 d137,
807 decode(l.pval138,cn,vn,vn,vh,l.pval138) p138,
808 l.pval138 d138,
809 decode(l.pval139,cn,vn,vn,vh,l.pval139) p139,
810 l.pval139 d139,
811 decode(l.pval140,cn,vn,vn,vh,l.pval140) p140,
812 l.pval140 d140,
813 decode(l.pval141,cn,vn,vn,vh,l.pval141) p141,
814 l.pval141 d141
815 from hr_pump_batch_lines l
816 where l.batch_line_id = p_batch_line_id;
817 --
818 c cr%rowtype;
819 l_validate boolean := false;
820 L_NAME_COMBINATION_WARNING boolean;
821 L_ASSIGN_PAYROLL_WARNING boolean;
822 L_ORIG_HIRE_WARNING boolean;
823 L_PERSON_ID number;
824 L_OBJECT_VERSION_NUMBER number;
825 L_PERSON_TYPE_ID number;
826 L_VENDOR_ID number;
827 L_CORRESPONDENCE_LANGUAGE varchar2(2000);
828 L_BENEFIT_GROUP_ID number;
829 --
830 begin
831 hr_data_pump.entry('call');
832 open cr;
833 fetch cr into c;
834 if cr%notfound then
835 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
836 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
837 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
838 hr_utility.set_message_token('VALUE',p_batch_line_id);
839 hr_utility.raise_error;
840 end if;
841 --
842 if c.p136 is null then
843 L_PERSON_ID:=nn;
844 else
845 L_PERSON_ID :=
846 hr_pump_get.get_person_id
847 (P_PERSON_USER_KEY => c.p136);
848 end if;
849 --
850 if c.p136 is null or
851 c.p1 is null then
852 L_OBJECT_VERSION_NUMBER:=nn;
853 else
854 L_OBJECT_VERSION_NUMBER :=
855 hr_pump_get.GET_PER_OVN
856 (P_PERSON_USER_KEY => c.p136
857 ,P_EFFECTIVE_DATE => c.p1);
858 end if;
859 --
860 if c.d137=cn or
861 c.d138=cn then
862 L_PERSON_TYPE_ID:=nn;
863 elsif c.d137 is null or
864 c.d138 is null then
865 L_PERSON_TYPE_ID:=nh;
866 else
867 L_PERSON_TYPE_ID :=
868 hr_pump_get.get_person_type_id
869 (P_USER_PERSON_TYPE => c.p137
870 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
871 ,P_LANGUAGE_CODE => c.p138);
872 end if;
873 --
874 if c.d139=cn then
875 L_VENDOR_ID:=nn;
876 elsif c.d139 is null then
877 L_VENDOR_ID:=nh;
878 else
879 L_VENDOR_ID :=
880 hr_pump_get.get_vendor_id
881 (P_VENDOR_NAME => c.p139);
882 end if;
883 --
884 if c.d140=cn then
885 L_CORRESPONDENCE_LANGUAGE:=vn;
886 elsif c.d140 is null then
887 L_CORRESPONDENCE_LANGUAGE:=vh;
888 else
889 L_CORRESPONDENCE_LANGUAGE :=
890 hr_pump_get.GET_CORRESPONDENCE_LANGUAGE
891 (P_CORRESPONDENCE_LANGUAGE => c.p140);
892 end if;
893 --
894 if c.d141=cn then
895 L_BENEFIT_GROUP_ID:=nn;
896 elsif c.d141 is null then
897 L_BENEFIT_GROUP_ID:=nh;
898 else
899 L_BENEFIT_GROUP_ID :=
900 hr_pump_get.get_benefit_group_id
901 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
902 ,P_BENEFIT_GROUP => c.p141);
903 end if;
904 --
905 hr_data_pump.api_trc_on;
906 HR_PERSON_API.UPDATE_PERSON
907 (p_validate => l_validate
908 ,P_EFFECTIVE_DATE => c.p1
909 ,P_DATETRACK_UPDATE_MODE => c.p2
910 ,P_PERSON_ID => L_PERSON_ID
911 ,P_OBJECT_VERSION_NUMBER => L_OBJECT_VERSION_NUMBER
912 ,P_PERSON_TYPE_ID => L_PERSON_TYPE_ID
913 ,P_LAST_NAME => c.p3
914 ,P_APPLICANT_NUMBER => c.p4
915 ,P_COMMENTS => c.p5
916 ,P_DATE_EMPLOYEE_DATA_VERIFIED => c.p6
917 ,P_DATE_OF_BIRTH => c.p7
918 ,P_EMAIL_ADDRESS => c.p8
919 ,P_EMPLOYEE_NUMBER => c.p9
920 ,P_EXPENSE_CHECK_SEND_TO_ADDRES => c.p10
921 ,P_FIRST_NAME => c.p11
922 ,P_KNOWN_AS => c.p12
923 ,P_MARITAL_STATUS => c.p13
924 ,P_MIDDLE_NAMES => c.p14
925 ,P_NATIONALITY => c.p15
926 ,P_NATIONAL_IDENTIFIER => c.p16
927 ,P_PREVIOUS_LAST_NAME => c.p17
928 ,P_REGISTERED_DISABLED_FLAG => c.p18
929 ,P_SEX => c.p19
930 ,P_TITLE => c.p20
931 ,P_VENDOR_ID => L_VENDOR_ID
932 ,P_WORK_TELEPHONE => c.p21
933 ,P_ATTRIBUTE_CATEGORY => c.p22
934 ,P_ATTRIBUTE1 => c.p23
935 ,P_ATTRIBUTE2 => c.p24
936 ,P_ATTRIBUTE3 => c.p25
937 ,P_ATTRIBUTE4 => c.p26
938 ,P_ATTRIBUTE5 => c.p27
939 ,P_ATTRIBUTE6 => c.p28
940 ,P_ATTRIBUTE7 => c.p29
941 ,P_ATTRIBUTE8 => c.p30
942 ,P_ATTRIBUTE9 => c.p31
943 ,P_ATTRIBUTE10 => c.p32
944 ,P_ATTRIBUTE11 => c.p33
945 ,P_ATTRIBUTE12 => c.p34
946 ,P_ATTRIBUTE13 => c.p35
947 ,P_ATTRIBUTE14 => c.p36
948 ,P_ATTRIBUTE15 => c.p37
949 ,P_ATTRIBUTE16 => c.p38
950 ,P_ATTRIBUTE17 => c.p39
951 ,P_ATTRIBUTE18 => c.p40
952 ,P_ATTRIBUTE19 => c.p41
953 ,P_ATTRIBUTE20 => c.p42
954 ,P_ATTRIBUTE21 => c.p43
958 ,P_ATTRIBUTE25 => c.p47
955 ,P_ATTRIBUTE22 => c.p44
956 ,P_ATTRIBUTE23 => c.p45
957 ,P_ATTRIBUTE24 => c.p46
959 ,P_ATTRIBUTE26 => c.p48
960 ,P_ATTRIBUTE27 => c.p49
961 ,P_ATTRIBUTE28 => c.p50
962 ,P_ATTRIBUTE29 => c.p51
963 ,P_ATTRIBUTE30 => c.p52
964 ,P_PER_INFORMATION_CATEGORY => c.p53
965 ,P_PER_INFORMATION1 => c.p54
966 ,P_PER_INFORMATION2 => c.p55
967 ,P_PER_INFORMATION3 => c.p56
968 ,P_PER_INFORMATION4 => c.p57
969 ,P_PER_INFORMATION5 => c.p58
970 ,P_PER_INFORMATION6 => c.p59
971 ,P_PER_INFORMATION7 => c.p60
972 ,P_PER_INFORMATION8 => c.p61
973 ,P_PER_INFORMATION9 => c.p62
974 ,P_PER_INFORMATION10 => c.p63
975 ,P_PER_INFORMATION11 => c.p64
976 ,P_PER_INFORMATION12 => c.p65
977 ,P_PER_INFORMATION13 => c.p66
978 ,P_PER_INFORMATION14 => c.p67
979 ,P_PER_INFORMATION15 => c.p68
980 ,P_PER_INFORMATION16 => c.p69
981 ,P_PER_INFORMATION17 => c.p70
982 ,P_PER_INFORMATION18 => c.p71
983 ,P_PER_INFORMATION19 => c.p72
984 ,P_PER_INFORMATION20 => c.p73
985 ,P_PER_INFORMATION21 => c.p74
986 ,P_PER_INFORMATION22 => c.p75
987 ,P_PER_INFORMATION23 => c.p76
988 ,P_PER_INFORMATION24 => c.p77
989 ,P_PER_INFORMATION25 => c.p78
990 ,P_PER_INFORMATION26 => c.p79
991 ,P_PER_INFORMATION27 => c.p80
992 ,P_PER_INFORMATION28 => c.p81
993 ,P_PER_INFORMATION29 => c.p82
994 ,P_PER_INFORMATION30 => c.p83
995 ,P_DATE_OF_DEATH => c.p84
996 ,P_BACKGROUND_CHECK_STATUS => c.p85
997 ,P_BACKGROUND_DATE_CHECK => c.p86
998 ,P_BLOOD_TYPE => c.p87
999 ,P_CORRESPONDENCE_LANGUAGE => L_CORRESPONDENCE_LANGUAGE
1000 ,P_FAST_PATH_EMPLOYEE => c.p88
1001 ,P_FTE_CAPACITY => c.p89
1002 ,P_HOLD_APPLICANT_DATE_UNTIL => c.p90
1003 ,P_HONORS => c.p91
1004 ,P_INTERNAL_LOCATION => c.p92
1005 ,P_LAST_MEDICAL_TEST_BY => c.p93
1006 ,P_LAST_MEDICAL_TEST_DATE => c.p94
1007 ,P_MAILSTOP => c.p95
1008 ,P_OFFICE_NUMBER => c.p96
1009 ,P_ON_MILITARY_SERVICE => c.p97
1010 ,P_PRE_NAME_ADJUNCT => c.p98
1011 ,P_PROJECTED_START_DATE => c.p99
1012 ,P_REHIRE_AUTHORIZOR => c.p100
1013 ,P_REHIRE_RECOMMENDATION => c.p101
1014 ,P_RESUME_EXISTS => c.p102
1015 ,P_RESUME_LAST_UPDATED => c.p103
1016 ,P_SECOND_PASSPORT_EXISTS => c.p104
1017 ,P_STUDENT_STATUS => c.p105
1018 ,P_WORK_SCHEDULE => c.p106
1019 ,P_REHIRE_REASON => c.p107
1020 ,P_SUFFIX => c.p108
1021 ,P_BENEFIT_GROUP_ID => L_BENEFIT_GROUP_ID
1022 ,P_RECEIPT_OF_DEATH_CERT_DATE => c.p109
1023 ,P_COORD_BEN_MED_PLN_NO => c.p110
1024 ,P_COORD_BEN_NO_CVG_FLAG => c.p111
1025 ,P_COORD_BEN_MED_EXT_ER => c.p112
1026 ,P_COORD_BEN_MED_PL_NAME => c.p113
1027 ,P_COORD_BEN_MED_INSR_CRR_NAME => c.p114
1028 ,P_COORD_BEN_MED_INSR_CRR_IDENT => c.p115
1029 ,P_COORD_BEN_MED_CVG_STRT_DT => c.p116
1030 ,P_COORD_BEN_MED_CVG_END_DT => c.p117
1031 ,P_USES_TOBACCO_FLAG => c.p118
1032 ,P_DPDNT_ADOPTION_DATE => c.p119
1033 ,P_DPDNT_VLNTRY_SVCE_FLAG => c.p120
1034 ,P_ORIGINAL_DATE_OF_HIRE => c.p121
1035 ,P_ADJUSTED_SVC_DATE => c.p122
1036 ,P_TOWN_OF_BIRTH => c.p123
1037 ,P_REGION_OF_BIRTH => c.p124
1038 ,P_COUNTRY_OF_BIRTH => c.p125
1039 ,P_GLOBAL_PERSON_ID => c.p126
1040 ,P_PARTY_ID => c.p127
1041 ,P_NPW_NUMBER => c.p128
1042 ,P_EFFECTIVE_START_DATE => c.p129
1043 ,P_EFFECTIVE_END_DATE => c.p130
1044 ,P_FULL_NAME => c.p131
1045 ,P_COMMENT_ID => c.p132
1046 ,P_NAME_COMBINATION_WARNING => L_NAME_COMBINATION_WARNING
1047 ,P_ASSIGN_PAYROLL_WARNING => L_ASSIGN_PAYROLL_WARNING
1048 ,P_ORIG_HIRE_WARNING => L_ORIG_HIRE_WARNING);
1049 hr_data_pump.api_trc_off;
1050 --
1051 if L_NAME_COMBINATION_WARNING then
1052 c.p133 := 'TRUE';
1053 else
1054 c.p133 := 'FALSE';
1055 end if;
1056 --
1057 if L_ASSIGN_PAYROLL_WARNING then
1058 c.p134 := 'TRUE';
1059 else
1060 c.p134 := 'FALSE';
1061 end if;
1062 --
1063 if L_ORIG_HIRE_WARNING then
1064 c.p135 := 'TRUE';
1065 else
1066 c.p135 := 'FALSE';
1067 end if;
1068 --
1069 update hr_pump_batch_lines l set
1070 l.pval009 = decode(c.p9,null,cn,c.p9),
1071 l.pval129 = decode(c.p129,null,cn,dc(c.p129)),
1072 l.pval130 = decode(c.p130,null,cn,dc(c.p130)),
1073 l.pval131 = decode(c.p131,null,cn,c.p131),
1074 l.pval132 = decode(c.p132,null,cn,c.p132),
1075 l.pval133 = decode(c.p133,null,cn,c.p133),
1076 l.pval134 = decode(c.p134,null,cn,c.p134),
1077 l.pval135 = decode(c.p135,null,cn,c.p135)
1078 where l.rowid = c.myrowid;
1079 --
1080 close cr;
1081 --
1082 hr_data_pump.exit('call');
1083 exception
1084 when hr_multi_message.error_message_exist then
1085 if cr%isopen then
1086 close cr;
1087 end if;
1088 hr_pump_utils.set_multi_msg_error_flag(true);
1089 when others then
1090 if cr%isopen then
1091 close cr;
1092 end if;
1093 raise;
1094 end call;
1095 end hrdpp_UPDATE_PERSON;