[Home] [Help]
PACKAGE BODY: APPS.HRDPP_CREATE_AU_SECONDARY_EMP_
Source
1 package body hrdpp_CREATE_AU_SECONDARY_EMP_ as
2 /*
3 * Generated by hr_pump_meta_mapper at: 2009/03/30 04:03:01
4 * Generated for API: HR_AU_ASSIGNMENT_API.CREATE_AU_SECONDARY_EMP_ASG
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_ASSIGNMENT_NUMBER in varchar2
84 ,P_CHANGE_REASON in varchar2 default null
85 ,P_COMMENTS in varchar2 default null
86 ,P_DATE_PROBATION_END in date default null
87 ,P_EMPLOYMENT_CATEGORY in varchar2 default null
88 ,P_FREQUENCY in varchar2 default null
89 ,P_INTERNAL_ADDRESS_LINE in varchar2 default null
90 ,P_MANAGER_FLAG in varchar2 default null
91 ,P_NORMAL_HOURS in number default null
92 ,P_PERF_REVIEW_PERIOD in number default null
93 ,P_PERF_REVIEW_PERIOD_FREQUENCY in varchar2 default null
94 ,P_PROBATION_PERIOD in number default null
95 ,P_PROBATION_UNIT in varchar2 default null
96 ,P_SAL_REVIEW_PERIOD in number default null
97 ,P_SAL_REVIEW_PERIOD_FREQUENCY in varchar2 default null
98 ,P_SOURCE_TYPE in varchar2 default null
99 ,P_TIME_NORMAL_FINISH in varchar2 default null
100 ,P_TIME_NORMAL_START in varchar2 default null
101 ,P_BARGAINING_UNIT_CODE in varchar2 default null
102 ,P_LABOUR_UNION_MEMBER_FLAG in varchar2 default null
103 ,P_HOURLY_SALARIED_CODE in varchar2 default null
104 ,P_ASS_ATTRIBUTE_CATEGORY in varchar2 default null
105 ,P_ASS_ATTRIBUTE1 in varchar2 default null
106 ,P_ASS_ATTRIBUTE2 in varchar2 default null
107 ,P_ASS_ATTRIBUTE3 in varchar2 default null
108 ,P_ASS_ATTRIBUTE4 in varchar2 default null
109 ,P_ASS_ATTRIBUTE5 in varchar2 default null
110 ,P_ASS_ATTRIBUTE6 in varchar2 default null
111 ,P_ASS_ATTRIBUTE7 in varchar2 default null
112 ,P_ASS_ATTRIBUTE8 in varchar2 default null
113 ,P_ASS_ATTRIBUTE9 in varchar2 default null
114 ,P_ASS_ATTRIBUTE10 in varchar2 default null
115 ,P_ASS_ATTRIBUTE11 in varchar2 default null
116 ,P_ASS_ATTRIBUTE12 in varchar2 default null
117 ,P_ASS_ATTRIBUTE13 in varchar2 default null
118 ,P_ASS_ATTRIBUTE14 in varchar2 default null
119 ,P_ASS_ATTRIBUTE15 in varchar2 default null
120 ,P_ASS_ATTRIBUTE16 in varchar2 default null
121 ,P_ASS_ATTRIBUTE17 in varchar2 default null
122 ,P_ASS_ATTRIBUTE18 in varchar2 default null
123 ,P_ASS_ATTRIBUTE19 in varchar2 default null
124 ,P_ASS_ATTRIBUTE20 in varchar2 default null
125 ,P_ASS_ATTRIBUTE21 in varchar2 default null
126 ,P_ASS_ATTRIBUTE22 in varchar2 default null
127 ,P_ASS_ATTRIBUTE23 in varchar2 default null
128 ,P_ASS_ATTRIBUTE24 in varchar2 default null
129 ,P_ASS_ATTRIBUTE25 in varchar2 default null
130 ,P_ASS_ATTRIBUTE26 in varchar2 default null
131 ,P_ASS_ATTRIBUTE27 in varchar2 default null
132 ,P_ASS_ATTRIBUTE28 in varchar2 default null
133 ,P_ASS_ATTRIBUTE29 in varchar2 default null
134 ,P_ASS_ATTRIBUTE30 in varchar2 default null
135 ,P_TITLE in varchar2 default null
136 ,P_LEV_LOD_FLG in varchar2 default null
137 ,P_GROUP_CERT_ISSUE_DATE in varchar2 default null
138 ,P_HRS_WORKED_PER_WEEK in varchar2 default null
139 ,P_PGP_SEGMENT1 in varchar2 default null
140 ,P_PGP_SEGMENT2 in varchar2 default null
141 ,P_PGP_SEGMENT3 in varchar2 default null
142 ,P_PGP_SEGMENT4 in varchar2 default null
143 ,P_PGP_SEGMENT5 in varchar2 default null
144 ,P_PGP_SEGMENT6 in varchar2 default null
145 ,P_PGP_SEGMENT7 in varchar2 default null
146 ,P_PGP_SEGMENT8 in varchar2 default null
147 ,P_PGP_SEGMENT9 in varchar2 default null
148 ,P_PGP_SEGMENT10 in varchar2 default null
149 ,P_PGP_SEGMENT11 in varchar2 default null
150 ,P_PGP_SEGMENT12 in varchar2 default null
151 ,P_PGP_SEGMENT13 in varchar2 default null
152 ,P_PGP_SEGMENT14 in varchar2 default null
153 ,P_PGP_SEGMENT15 in varchar2 default null
154 ,P_PGP_SEGMENT16 in varchar2 default null
155 ,P_PGP_SEGMENT17 in varchar2 default null
156 ,P_PGP_SEGMENT18 in varchar2 default null
157 ,P_PGP_SEGMENT19 in varchar2 default null
158 ,P_PGP_SEGMENT20 in varchar2 default null
159 ,P_PGP_SEGMENT21 in varchar2 default null
160 ,P_PGP_SEGMENT22 in varchar2 default null
161 ,P_PGP_SEGMENT23 in varchar2 default null
162 ,P_PGP_SEGMENT24 in varchar2 default null
163 ,P_PGP_SEGMENT25 in varchar2 default null
164 ,P_PGP_SEGMENT26 in varchar2 default null
165 ,P_PGP_SEGMENT27 in varchar2 default null
166 ,P_PGP_SEGMENT28 in varchar2 default null
167 ,P_PGP_SEGMENT29 in varchar2 default null
168 ,P_PGP_SEGMENT30 in varchar2 default null
169 ,P_PGP_CONCAT_SEGMENTS in varchar2 default null
170 ,P_CAGR_ID_FLEX_NUM in number default null
171 ,P_CAG_SEGMENT1 in varchar2 default null
172 ,P_CAG_SEGMENT2 in varchar2 default null
173 ,P_CAG_SEGMENT3 in varchar2 default null
174 ,P_CAG_SEGMENT4 in varchar2 default null
175 ,P_CAG_SEGMENT5 in varchar2 default null
176 ,P_CAG_SEGMENT6 in varchar2 default null
177 ,P_CAG_SEGMENT7 in varchar2 default null
178 ,P_CAG_SEGMENT8 in varchar2 default null
179 ,P_CAG_SEGMENT9 in varchar2 default null
180 ,P_CAG_SEGMENT10 in varchar2 default null
181 ,P_CAG_SEGMENT11 in varchar2 default null
182 ,P_CAG_SEGMENT12 in varchar2 default null
183 ,P_CAG_SEGMENT13 in varchar2 default null
184 ,P_CAG_SEGMENT14 in varchar2 default null
185 ,P_CAG_SEGMENT15 in varchar2 default null
186 ,P_CAG_SEGMENT16 in varchar2 default null
187 ,P_CAG_SEGMENT17 in varchar2 default null
188 ,P_CAG_SEGMENT18 in varchar2 default null
189 ,P_CAG_SEGMENT19 in varchar2 default null
190 ,P_CAG_SEGMENT20 in varchar2 default null
191 ,P_ASSIGNMENT_USER_KEY in varchar2
192 ,P_PERSON_USER_KEY in varchar2
193 ,P_ORGANIZATION_NAME in varchar2
194 ,P_LANGUAGE_CODE in varchar2
195 ,P_GRADE_NAME in varchar2 default null
196 ,P_POSITION_NAME in varchar2 default null
197 ,P_JOB_NAME in varchar2 default null
198 ,P_USER_STATUS in varchar2 default null
199 ,P_PAYROLL_NAME in varchar2 default null
200 ,P_LOCATION_CODE in varchar2 default null
201 ,P_SUPERVISOR_USER_KEY in varchar2 default null
202 ,P_SPECIAL_CEILIN_STEP_USER_KEY in varchar2 default null
203 ,P_PAY_BASIS_NAME in varchar2 default null
204 ,P_DEFAULT_CODE_COMB_USER_KEY in varchar2 default null
205 ,P_SET_OF_BOOKS_NAME in varchar2 default null
206 ,P_LEGAL_EMPLOYER_NAME in varchar2 default null
207 ,P_CONTRACT_USER_KEY in varchar2 default null
208 ,P_ESTABLISHMENT_NAME in varchar2 default null
209 ,P_LOCATION in varchar2 default null
210 ,P_CAGR_NAME in varchar2 default null) is
211 blid number := p_data_pump_batch_line_id;
212 begin
213 if blid is not null then
214 delete from hr_pump_batch_lines where batch_line_id = blid;
215 delete from hr_pump_batch_exceptions
216 where source_type = 'BATCH_LINE' and source_id = blid;
217 end if;
218 insert into hr_pump_batch_lines
219 (batch_id
220 ,batch_line_id
221 ,business_group_name
222 ,api_module_id
223 ,line_status
224 ,user_sequence
225 ,link_value
226 ,pval001
227 ,pval002
228 ,pval003
229 ,pval004
230 ,pval005
231 ,pval006
232 ,pval007
233 ,pval008
234 ,pval009
235 ,pval010
236 ,pval011
237 ,pval012
238 ,pval013
239 ,pval014
240 ,pval015
241 ,pval016
242 ,pval017
243 ,pval018
244 ,pval019
245 ,pval020
246 ,pval021
247 ,pval022
248 ,pval023
249 ,pval024
250 ,pval025
251 ,pval026
252 ,pval027
253 ,pval028
254 ,pval029
255 ,pval030
256 ,pval031
257 ,pval032
258 ,pval033
259 ,pval034
260 ,pval035
261 ,pval036
262 ,pval037
263 ,pval038
264 ,pval039
265 ,pval040
266 ,pval041
267 ,pval042
268 ,pval043
269 ,pval044
270 ,pval045
271 ,pval046
272 ,pval047
273 ,pval048
274 ,pval049
275 ,pval050
276 ,pval051
277 ,pval052
278 ,pval053
279 ,pval054
280 ,pval055
281 ,pval056
282 ,pval057
283 ,pval058
284 ,pval059
285 ,pval060
286 ,pval061
287 ,pval062
288 ,pval063
289 ,pval064
290 ,pval065
291 ,pval066
292 ,pval067
293 ,pval068
294 ,pval069
295 ,pval070
296 ,pval071
297 ,pval072
298 ,pval073
299 ,pval074
300 ,pval075
301 ,pval076
302 ,pval077
303 ,pval078
304 ,pval079
305 ,pval080
306 ,pval081
307 ,pval082
308 ,pval083
309 ,pval084
310 ,pval085
311 ,pval086
312 ,pval087
313 ,pval088
314 ,pval089
315 ,pval090
316 ,pval091
317 ,pval092
318 ,pval093
319 ,pval094
320 ,pval095
321 ,pval096
322 ,pval097
323 ,pval098
324 ,pval099
325 ,pval100
326 ,pval101
327 ,pval102
328 ,pval103
329 ,pval104
330 ,pval105
331 ,pval106
332 ,pval107
333 ,pval108
334 ,pval109
335 ,pval112
336 ,pval123
337 ,pval124
338 ,pval125
339 ,pval126
340 ,pval127
341 ,pval128
342 ,pval129
343 ,pval130
344 ,pval131
345 ,pval132
346 ,pval133
347 ,pval134
348 ,pval135
349 ,pval136
350 ,pval137
351 ,pval138
352 ,pval139
353 ,pval140
354 ,pval141)
355 values
356 (p_batch_id
357 ,nvl(blid,hr_pump_batch_lines_s.nextval)
358 ,p_data_pump_business_grp_name
359 ,2161
360 ,'U'
361 ,p_user_sequence
362 ,p_link_value
363 ,dc(P_EFFECTIVE_DATE)
364 ,P_ASSIGNMENT_NUMBER
365 ,P_CHANGE_REASON
366 ,P_COMMENTS
367 ,dc(P_DATE_PROBATION_END)
368 ,P_EMPLOYMENT_CATEGORY
369 ,P_FREQUENCY
370 ,P_INTERNAL_ADDRESS_LINE
371 ,P_MANAGER_FLAG
372 ,P_NORMAL_HOURS
373 ,P_PERF_REVIEW_PERIOD
374 ,P_PERF_REVIEW_PERIOD_FREQUENCY
375 ,P_PROBATION_PERIOD
376 ,P_PROBATION_UNIT
377 ,P_SAL_REVIEW_PERIOD
378 ,P_SAL_REVIEW_PERIOD_FREQUENCY
379 ,P_SOURCE_TYPE
380 ,P_TIME_NORMAL_FINISH
381 ,P_TIME_NORMAL_START
382 ,P_BARGAINING_UNIT_CODE
383 ,P_LABOUR_UNION_MEMBER_FLAG
384 ,P_HOURLY_SALARIED_CODE
385 ,P_ASS_ATTRIBUTE_CATEGORY
386 ,P_ASS_ATTRIBUTE1
387 ,P_ASS_ATTRIBUTE2
388 ,P_ASS_ATTRIBUTE3
389 ,P_ASS_ATTRIBUTE4
390 ,P_ASS_ATTRIBUTE5
391 ,P_ASS_ATTRIBUTE6
392 ,P_ASS_ATTRIBUTE7
393 ,P_ASS_ATTRIBUTE8
394 ,P_ASS_ATTRIBUTE9
395 ,P_ASS_ATTRIBUTE10
396 ,P_ASS_ATTRIBUTE11
397 ,P_ASS_ATTRIBUTE12
398 ,P_ASS_ATTRIBUTE13
399 ,P_ASS_ATTRIBUTE14
400 ,P_ASS_ATTRIBUTE15
401 ,P_ASS_ATTRIBUTE16
402 ,P_ASS_ATTRIBUTE17
403 ,P_ASS_ATTRIBUTE18
404 ,P_ASS_ATTRIBUTE19
405 ,P_ASS_ATTRIBUTE20
406 ,P_ASS_ATTRIBUTE21
410 ,P_ASS_ATTRIBUTE25
407 ,P_ASS_ATTRIBUTE22
408 ,P_ASS_ATTRIBUTE23
409 ,P_ASS_ATTRIBUTE24
411 ,P_ASS_ATTRIBUTE26
412 ,P_ASS_ATTRIBUTE27
413 ,P_ASS_ATTRIBUTE28
414 ,P_ASS_ATTRIBUTE29
415 ,P_ASS_ATTRIBUTE30
416 ,P_TITLE
417 ,P_LEV_LOD_FLG
418 ,P_GROUP_CERT_ISSUE_DATE
419 ,P_HRS_WORKED_PER_WEEK
420 ,P_PGP_SEGMENT1
421 ,P_PGP_SEGMENT2
422 ,P_PGP_SEGMENT3
423 ,P_PGP_SEGMENT4
424 ,P_PGP_SEGMENT5
425 ,P_PGP_SEGMENT6
426 ,P_PGP_SEGMENT7
427 ,P_PGP_SEGMENT8
428 ,P_PGP_SEGMENT9
429 ,P_PGP_SEGMENT10
430 ,P_PGP_SEGMENT11
431 ,P_PGP_SEGMENT12
432 ,P_PGP_SEGMENT13
433 ,P_PGP_SEGMENT14
434 ,P_PGP_SEGMENT15
435 ,P_PGP_SEGMENT16
436 ,P_PGP_SEGMENT17
437 ,P_PGP_SEGMENT18
438 ,P_PGP_SEGMENT19
439 ,P_PGP_SEGMENT20
440 ,P_PGP_SEGMENT21
441 ,P_PGP_SEGMENT22
442 ,P_PGP_SEGMENT23
443 ,P_PGP_SEGMENT24
444 ,P_PGP_SEGMENT25
445 ,P_PGP_SEGMENT26
446 ,P_PGP_SEGMENT27
447 ,P_PGP_SEGMENT28
448 ,P_PGP_SEGMENT29
449 ,P_PGP_SEGMENT30
450 ,P_PGP_CONCAT_SEGMENTS
451 ,P_CAGR_ID_FLEX_NUM
452 ,P_CAG_SEGMENT1
453 ,P_CAG_SEGMENT2
454 ,P_CAG_SEGMENT3
455 ,P_CAG_SEGMENT4
456 ,P_CAG_SEGMENT5
457 ,P_CAG_SEGMENT6
458 ,P_CAG_SEGMENT7
459 ,P_CAG_SEGMENT8
460 ,P_CAG_SEGMENT9
461 ,P_CAG_SEGMENT10
462 ,P_CAG_SEGMENT11
463 ,P_CAG_SEGMENT12
464 ,P_CAG_SEGMENT13
465 ,P_CAG_SEGMENT14
466 ,P_CAG_SEGMENT15
467 ,P_CAG_SEGMENT16
468 ,P_CAG_SEGMENT17
469 ,P_CAG_SEGMENT18
470 ,P_CAG_SEGMENT19
471 ,P_CAG_SEGMENT20
472 ,P_ASSIGNMENT_USER_KEY
473 ,P_PERSON_USER_KEY
474 ,P_ORGANIZATION_NAME
475 ,P_LANGUAGE_CODE
476 ,P_GRADE_NAME
477 ,P_POSITION_NAME
478 ,P_JOB_NAME
479 ,P_USER_STATUS
480 ,P_PAYROLL_NAME
481 ,P_LOCATION_CODE
482 ,P_SUPERVISOR_USER_KEY
483 ,P_SPECIAL_CEILIN_STEP_USER_KEY
484 ,P_PAY_BASIS_NAME
485 ,P_DEFAULT_CODE_COMB_USER_KEY
486 ,P_SET_OF_BOOKS_NAME
487 ,P_LEGAL_EMPLOYER_NAME
488 ,P_CONTRACT_USER_KEY
489 ,P_ESTABLISHMENT_NAME
490 ,P_LOCATION
491 ,P_CAGR_NAME);
492 end insert_batch_lines;
493 --
494 procedure call
495 (p_business_group_id in number,
496 p_batch_line_id in number) is
497 cursor cr is
498 select l.rowid myrowid,
499 decode(l.pval001,cn,dn,d(l.pval001)) p1,
500 decode(l.pval002,cn,vn,l.pval002) p2,
501 decode(l.pval003,cn,vn,vn,vn,
502 hr_pump_get.gl(l.pval003,'EMP_ASSIGN_REASON',d(l.pval001),l.pval125)) p3,
503 l.pval003 d3,
504 decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
505 l.pval004 d4,
506 decode(l.pval005,cn,dn,vn,dn,d(l.pval005)) p5,
507 l.pval005 d5,
508 decode(l.pval006,cn,vn,vn,vn,
509 hr_pump_get.gl(l.pval006,'EMP_CAT',d(l.pval001),l.pval125)) p6,
510 l.pval006 d6,
511 decode(l.pval007,cn,vn,vn,vn,
512 hr_pump_get.gl(l.pval007,'FREQUENCY',d(l.pval001),l.pval125)) p7,
513 l.pval007 d7,
514 decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
515 l.pval008 d8,
516 decode(l.pval009,cn,vn,vn,vn,
517 hr_pump_get.gl(l.pval009,'YES_NO',d(l.pval001),l.pval125)) p9,
518 l.pval009 d9,
519 decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
520 l.pval010 d10,
521 decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
522 l.pval011 d11,
523 decode(l.pval012,cn,vn,vn,vn,
524 hr_pump_get.gl(l.pval012,'FREQUENCY',d(l.pval001),l.pval125)) p12,
525 l.pval012 d12,
526 decode(l.pval013,cn,nn,vn,nn,n(l.pval013)) p13,
527 l.pval013 d13,
528 decode(l.pval014,cn,vn,vn,vn,
529 hr_pump_get.gl(l.pval014,'QUALIFYING_UNITS',d(l.pval001),l.pval125)) p14,
530 l.pval014 d14,
531 decode(l.pval015,cn,nn,vn,nn,n(l.pval015)) p15,
532 l.pval015 d15,
533 decode(l.pval016,cn,vn,vn,vn,
534 hr_pump_get.gl(l.pval016,'FREQUENCY',d(l.pval001),l.pval125)) p16,
535 l.pval016 d16,
536 decode(l.pval017,cn,vn,vn,vn,
537 hr_pump_get.gl(l.pval017,'REC_TYPE',d(l.pval001),l.pval125)) p17,
538 l.pval017 d17,
539 decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
540 l.pval018 d18,
541 decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
542 l.pval019 d19,
543 decode(l.pval020,cn,vn,vn,vn,
544 hr_pump_get.gl(l.pval020,'BARGAINING_UNIT_CODE',d(l.pval001),l.pval125)) p20,
545 l.pval020 d20,
546 decode(l.pval021,cn,vn,vn,'N',
547 hr_pump_get.gl(l.pval021,'YES_NO',d(l.pval001),l.pval125)) p21,
548 l.pval021 d21,
549 decode(l.pval022,cn,vn,vn,vn,
550 hr_pump_get.gl(l.pval022,'HOURLY_SALARIED_CODE',d(l.pval001),l.pval125)) p22,
551 l.pval022 d22,
552 decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
553 l.pval023 d23,
554 decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,
555 l.pval024 d24,
556 decode(l.pval025,cn,vn,vn,vn,l.pval025) p25,
557 l.pval025 d25,
558 decode(l.pval026,cn,vn,vn,vn,l.pval026) p26,
559 l.pval026 d26,
560 decode(l.pval027,cn,vn,vn,vn,l.pval027) p27,
561 l.pval027 d27,
562 decode(l.pval028,cn,vn,vn,vn,l.pval028) p28,
563 l.pval028 d28,
564 decode(l.pval029,cn,vn,vn,vn,l.pval029) p29,
565 l.pval029 d29,
566 decode(l.pval030,cn,vn,vn,vn,l.pval030) p30,
567 l.pval030 d30,
568 decode(l.pval031,cn,vn,vn,vn,l.pval031) p31,
569 l.pval031 d31,
570 decode(l.pval032,cn,vn,vn,vn,l.pval032) p32,
571 l.pval032 d32,
572 decode(l.pval033,cn,vn,vn,vn,l.pval033) p33,
573 l.pval033 d33,
574 decode(l.pval034,cn,vn,vn,vn,l.pval034) p34,
575 l.pval034 d34,
576 decode(l.pval035,cn,vn,vn,vn,l.pval035) p35,
577 l.pval035 d35,
578 decode(l.pval036,cn,vn,vn,vn,l.pval036) p36,
579 l.pval036 d36,
580 decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
581 l.pval037 d37,
582 decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
583 l.pval038 d38,
584 decode(l.pval039,cn,vn,vn,vn,l.pval039) p39,
585 l.pval039 d39,
589 l.pval041 d41,
586 decode(l.pval040,cn,vn,vn,vn,l.pval040) p40,
587 l.pval040 d40,
588 decode(l.pval041,cn,vn,vn,vn,l.pval041) p41,
590 decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
591 l.pval042 d42,
592 decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
593 l.pval043 d43,
594 decode(l.pval044,cn,vn,vn,vn,l.pval044) p44,
595 l.pval044 d44,
596 decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
597 l.pval045 d45,
598 decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
599 l.pval046 d46,
600 decode(l.pval047,cn,vn,vn,vn,l.pval047) p47,
601 l.pval047 d47,
602 decode(l.pval048,cn,vn,vn,vn,l.pval048) p48,
603 l.pval048 d48,
604 decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
605 l.pval049 d49,
606 decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
607 l.pval050 d50,
608 decode(l.pval051,cn,vn,vn,vn,l.pval051) p51,
609 l.pval051 d51,
610 decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,
611 l.pval052 d52,
612 decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
613 l.pval053 d53,
614 decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
615 l.pval054 d54,
616 decode(l.pval055,cn,vn,vn,vn,l.pval055) p55,
617 l.pval055 d55,
618 decode(l.pval056,cn,vn,vn,vn,l.pval056) p56,
619 l.pval056 d56,
620 decode(l.pval057,cn,vn,vn,vn,l.pval057) p57,
621 l.pval057 d57,
622 decode(l.pval058,cn,vn,vn,vn,l.pval058) p58,
623 l.pval058 d58,
624 decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,
625 l.pval059 d59,
626 decode(l.pval060,cn,vn,vn,vn,l.pval060) p60,
627 l.pval060 d60,
628 decode(l.pval061,cn,vn,vn,vn,l.pval061) p61,
629 l.pval061 d61,
630 decode(l.pval062,cn,vn,vn,vn,l.pval062) p62,
631 l.pval062 d62,
632 decode(l.pval063,cn,vn,vn,vn,l.pval063) p63,
633 l.pval063 d63,
634 decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
635 l.pval064 d64,
636 decode(l.pval065,cn,vn,vn,vn,l.pval065) p65,
637 l.pval065 d65,
638 decode(l.pval066,cn,vn,vn,vn,l.pval066) p66,
639 l.pval066 d66,
640 decode(l.pval067,cn,vn,vn,vn,l.pval067) p67,
641 l.pval067 d67,
642 decode(l.pval068,cn,vn,vn,vn,l.pval068) p68,
643 l.pval068 d68,
644 decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
645 l.pval069 d69,
646 decode(l.pval070,cn,vn,vn,vn,l.pval070) p70,
647 l.pval070 d70,
648 decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
649 l.pval071 d71,
650 decode(l.pval072,cn,vn,vn,vn,l.pval072) p72,
651 l.pval072 d72,
652 decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
653 l.pval073 d73,
654 decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
655 l.pval074 d74,
656 decode(l.pval075,cn,vn,vn,vn,l.pval075) p75,
657 l.pval075 d75,
658 decode(l.pval076,cn,vn,vn,vn,l.pval076) p76,
659 l.pval076 d76,
660 decode(l.pval077,cn,vn,vn,vn,l.pval077) p77,
661 l.pval077 d77,
662 decode(l.pval078,cn,vn,vn,vn,l.pval078) p78,
663 l.pval078 d78,
664 decode(l.pval079,cn,vn,vn,vn,l.pval079) p79,
665 l.pval079 d79,
666 decode(l.pval080,cn,vn,vn,vn,l.pval080) p80,
667 l.pval080 d80,
668 decode(l.pval081,cn,vn,vn,vn,l.pval081) p81,
669 l.pval081 d81,
670 decode(l.pval082,cn,vn,vn,vn,l.pval082) p82,
671 l.pval082 d82,
672 decode(l.pval083,cn,vn,vn,vn,l.pval083) p83,
673 l.pval083 d83,
674 decode(l.pval084,cn,vn,vn,vn,l.pval084) p84,
675 l.pval084 d84,
676 decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,
677 l.pval085 d85,
678 decode(l.pval086,cn,vn,vn,vn,l.pval086) p86,
679 l.pval086 d86,
680 decode(l.pval087,cn,vn,vn,vn,l.pval087) p87,
681 l.pval087 d87,
682 decode(l.pval088,cn,vn,vn,vn,l.pval088) p88,
683 l.pval088 d88,
684 decode(l.pval089,cn,nn,vn,nn,n(l.pval089)) p89,
685 l.pval089 d89,
686 decode(l.pval090,cn,vn,vn,vn,l.pval090) p90,
687 l.pval090 d90,
688 decode(l.pval091,cn,vn,vn,vn,l.pval091) p91,
689 l.pval091 d91,
690 decode(l.pval092,cn,vn,vn,vn,l.pval092) p92,
691 l.pval092 d92,
692 decode(l.pval093,cn,vn,vn,vn,l.pval093) p93,
693 l.pval093 d93,
694 decode(l.pval094,cn,vn,vn,vn,l.pval094) p94,
695 l.pval094 d94,
696 decode(l.pval095,cn,vn,vn,vn,l.pval095) p95,
697 l.pval095 d95,
698 decode(l.pval096,cn,vn,vn,vn,l.pval096) p96,
699 l.pval096 d96,
700 decode(l.pval097,cn,vn,vn,vn,l.pval097) p97,
701 l.pval097 d97,
702 decode(l.pval098,cn,vn,vn,vn,l.pval098) p98,
703 l.pval098 d98,
704 decode(l.pval099,cn,vn,vn,vn,l.pval099) p99,
705 l.pval099 d99,
706 decode(l.pval100,cn,vn,vn,vn,l.pval100) p100,
707 l.pval100 d100,
708 decode(l.pval101,cn,vn,vn,vn,l.pval101) p101,
709 l.pval101 d101,
710 decode(l.pval102,cn,vn,vn,vn,l.pval102) p102,
711 l.pval102 d102,
712 decode(l.pval103,cn,vn,vn,vn,l.pval103) p103,
713 l.pval103 d103,
714 decode(l.pval104,cn,vn,vn,vn,l.pval104) p104,
715 l.pval104 d104,
716 decode(l.pval105,cn,vn,vn,vn,l.pval105) p105,
717 l.pval105 d105,
718 decode(l.pval106,cn,vn,vn,vn,l.pval106) p106,
719 l.pval106 d106,
720 decode(l.pval107,cn,vn,vn,vn,l.pval107) p107,
721 l.pval107 d107,
722 decode(l.pval108,cn,vn,vn,vn,l.pval108) p108,
723 l.pval108 d108,
724 decode(l.pval109,cn,vn,vn,vn,l.pval109) p109,
725 l.pval109 d109,
726 l.pval110 p110,
727 l.pval111 p111,
728 l.pval112 p112,
729 l.pval113 p113,
730 l.pval114 p114,
731 l.pval115 p115,
732 decode(l.pval116,cn,dn,d(l.pval116)) p116,
733 decode(l.pval117,cn,dn,d(l.pval117)) p117,
734 l.pval118 p118,
735 l.pval119 p119,
736 l.pval120 p120,
737 l.pval121 p121,
738 l.pval122 p122,
739 decode(l.pval123,cn,vn,l.pval123) p123,
740 decode(l.pval124,cn,vn,l.pval124) p124,
741 decode(l.pval125,cn,vn,l.pval125) p125,
742 decode(l.pval126,cn,vn,vn,vn,l.pval126) p126,
743 l.pval126 d126,
744 decode(l.pval127,cn,vn,vn,vn,l.pval127) p127,
745 l.pval127 d127,
746 decode(l.pval128,cn,vn,vn,vn,l.pval128) p128,
747 l.pval128 d128,
751 l.pval130 d130,
748 decode(l.pval129,cn,vn,vn,vn,l.pval129) p129,
749 l.pval129 d129,
750 decode(l.pval130,cn,vn,vn,vn,l.pval130) p130,
752 decode(l.pval131,cn,vn,vn,vn,l.pval131) p131,
753 l.pval131 d131,
754 decode(l.pval132,cn,vn,vn,vn,l.pval132) p132,
755 l.pval132 d132,
756 decode(l.pval133,cn,vn,vn,vn,l.pval133) p133,
757 l.pval133 d133,
758 decode(l.pval134,cn,vn,vn,vn,l.pval134) p134,
759 l.pval134 d134,
760 decode(l.pval135,cn,vn,vn,vn,l.pval135) p135,
761 l.pval135 d135,
762 decode(l.pval136,cn,vn,vn,vn,l.pval136) p136,
763 l.pval136 d136,
764 decode(l.pval137,cn,vn,vn,vn,l.pval137) p137,
765 l.pval137 d137,
766 decode(l.pval138,cn,vn,vn,vn,l.pval138) p138,
767 l.pval138 d138,
768 decode(l.pval139,cn,vn,vn,vn,l.pval139) p139,
769 l.pval139 d139,
770 decode(l.pval140,cn,vn,vn,vn,l.pval140) p140,
771 l.pval140 d140,
772 decode(l.pval141,cn,vn,vn,vn,l.pval141) p141,
773 l.pval141 d141
774 from hr_pump_batch_lines l
775 where l.batch_line_id = p_batch_line_id;
776 --
777 c cr%rowtype;
778 l_validate boolean := false;
779 L_ASSIGNMENT_ID number;
780 L_OTHER_MANAGER_WARNING boolean;
781 L_PERSON_ID number;
782 L_ORGANIZATION_ID number;
783 L_GRADE_ID number;
784 L_POSITION_ID number;
785 L_JOB_ID number;
786 L_ASSIGNMENT_STATUS_TYPE_ID number;
787 L_PAYROLL_ID number;
788 L_LOCATION_ID number;
789 L_SUPERVISOR_ID number;
790 L_SPECIAL_CEILING_STEP_ID number;
791 L_PAY_BASIS_ID number;
792 L_DEFAULT_CODE_COMB_ID number;
793 L_SET_OF_BOOKS_ID number;
794 L_LEGAL_EMPLOYER_ID varchar2(2000);
795 L_CONTRACT_ID number;
796 L_ESTABLISHMENT_ID number;
797 L_COLLECTIVE_AGREEMENT_ID number;
798 --
799 begin
800 hr_data_pump.entry('call');
801 open cr;
802 fetch cr into c;
803 if cr%notfound then
804 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
805 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
806 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
807 hr_utility.set_message_token('VALUE',p_batch_line_id);
808 hr_utility.raise_error;
809 end if;
810 --
811 if c.p123 is null then
812 L_PERSON_ID:=nn;
813 else
814 L_PERSON_ID :=
815 hr_pump_get.get_person_id
816 (P_PERSON_USER_KEY => c.p123);
817 end if;
818 --
819 if c.p124 is null or
820 c.p1 is null or
821 c.p125 is null then
822 L_ORGANIZATION_ID:=nn;
823 else
824 L_ORGANIZATION_ID :=
825 hr_pump_get.get_organization_id
826 (P_ORGANIZATION_NAME => c.p124
827 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
828 ,P_EFFECTIVE_DATE => c.p1
829 ,P_LANGUAGE_CODE => c.p125);
830 end if;
831 --
832 if c.p126 is null or
833 c.p1 is null then
834 L_GRADE_ID:=nn;
835 else
836 L_GRADE_ID :=
837 hr_pump_get.get_grade_id
838 (P_GRADE_NAME => c.p126
839 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
840 ,P_EFFECTIVE_DATE => c.p1);
841 end if;
842 --
843 if c.p127 is null or
844 c.p1 is null then
845 L_POSITION_ID:=nn;
846 else
847 L_POSITION_ID :=
848 hr_pump_get.get_position_id
849 (P_POSITION_NAME => c.p127
850 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
851 ,P_EFFECTIVE_DATE => c.p1);
852 end if;
853 --
854 if c.p128 is null or
855 c.p1 is null then
856 L_JOB_ID:=nn;
857 else
858 L_JOB_ID :=
859 hr_pump_get.get_job_id
860 (P_JOB_NAME => c.p128
861 ,P_EFFECTIVE_DATE => c.p1
862 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
863 end if;
864 --
865 if c.p129 is null or
866 c.p125 is null then
867 L_ASSIGNMENT_STATUS_TYPE_ID:=nn;
868 else
869 L_ASSIGNMENT_STATUS_TYPE_ID :=
870 hr_pump_get.get_assignment_status_type_id
871 (P_USER_STATUS => c.p129
872 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
873 ,P_LANGUAGE_CODE => c.p125);
874 end if;
875 --
876 if c.p130 is null or
877 c.p1 is null then
878 L_PAYROLL_ID:=nn;
879 else
880 L_PAYROLL_ID :=
881 hr_pump_get.get_payroll_id
882 (P_PAYROLL_NAME => c.p130
883 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
884 ,P_EFFECTIVE_DATE => c.p1);
885 end if;
886 --
887 if c.p131 is null or
888 c.p125 is null then
889 L_LOCATION_ID:=nn;
890 else
891 L_LOCATION_ID :=
892 hr_pump_get.get_location_id
893 (P_LOCATION_CODE => c.p131
894 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
895 ,P_LANGUAGE_CODE => c.p125);
896 end if;
897 --
898 if c.p132 is null then
899 L_SUPERVISOR_ID:=nn;
900 else
901 L_SUPERVISOR_ID :=
902 hr_pump_get.get_supervisor_id
903 (P_SUPERVISOR_USER_KEY => c.p132);
904 end if;
905 --
906 if c.p133 is null then
907 L_SPECIAL_CEILING_STEP_ID:=nn;
908 else
909 L_SPECIAL_CEILING_STEP_ID :=
910 hr_pump_get.get_special_ceiling_step_id
911 (P_SPECIAL_CEILIN_STEP_USER_KEY => c.p133);
912 end if;
913 --
914 if c.p134 is null then
915 L_PAY_BASIS_ID:=nn;
916 else
917 L_PAY_BASIS_ID :=
918 hr_pump_get.get_pay_basis_id
919 (P_PAY_BASIS_NAME => c.p134
920 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
921 end if;
922 --
923 if c.p135 is null then
924 L_DEFAULT_CODE_COMB_ID:=nn;
925 else
926 L_DEFAULT_CODE_COMB_ID :=
927 hr_pump_get.get_default_code_comb_id
928 (P_DEFAULT_CODE_COMB_USER_KEY => c.p135);
929 end if;
930 --
931 if c.p136 is null then
932 L_SET_OF_BOOKS_ID:=nn;
933 else
934 L_SET_OF_BOOKS_ID :=
935 hr_pump_get.get_set_of_books_id
936 (P_SET_OF_BOOKS_NAME => c.p136);
937 end if;
938 --
939 if c.p137 is null then
940 L_LEGAL_EMPLOYER_ID:=vn;
941 else
945 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
942 L_LEGAL_EMPLOYER_ID :=
943 PER_AU_DATA_PUMP.get_legal_employer_id
944 (P_LEGAL_EMPLOYER_NAME => c.p137
946 end if;
947 --
948 if c.p138 is null then
949 L_CONTRACT_ID:=nn;
950 else
951 L_CONTRACT_ID :=
952 hr_pump_get.get_contract_id
953 (P_CONTRACT_USER_KEY => c.p138);
954 end if;
955 --
956 if c.p139 is null or
957 c.p140 is null then
958 L_ESTABLISHMENT_ID:=nn;
959 else
960 L_ESTABLISHMENT_ID :=
961 hr_pump_get.get_establishment_id
962 (P_ESTABLISHMENT_NAME => c.p139
963 ,P_LOCATION => c.p140);
964 end if;
965 --
966 if c.p141 is null or
967 c.p1 is null then
968 L_COLLECTIVE_AGREEMENT_ID:=nn;
969 else
970 L_COLLECTIVE_AGREEMENT_ID :=
971 hr_pump_get.get_collective_agreement_id
972 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
973 ,P_CAGR_NAME => c.p141
974 ,P_EFFECTIVE_DATE => c.p1);
975 end if;
976 --
977 hr_data_pump.api_trc_on;
978 HR_AU_ASSIGNMENT_API.CREATE_AU_SECONDARY_EMP_ASG
979 (p_validate => l_validate
980 ,P_EFFECTIVE_DATE => c.p1
981 ,P_PERSON_ID => L_PERSON_ID
982 ,P_ORGANIZATION_ID => L_ORGANIZATION_ID
983 ,P_GRADE_ID => L_GRADE_ID
984 ,P_POSITION_ID => L_POSITION_ID
985 ,P_JOB_ID => L_JOB_ID
986 ,P_ASSIGNMENT_STATUS_TYPE_ID => L_ASSIGNMENT_STATUS_TYPE_ID
987 ,P_PAYROLL_ID => L_PAYROLL_ID
988 ,P_LOCATION_ID => L_LOCATION_ID
989 ,P_SUPERVISOR_ID => L_SUPERVISOR_ID
990 ,P_SPECIAL_CEILING_STEP_ID => L_SPECIAL_CEILING_STEP_ID
991 ,P_PAY_BASIS_ID => L_PAY_BASIS_ID
992 ,P_ASSIGNMENT_NUMBER => c.p2
993 ,P_CHANGE_REASON => c.p3
994 ,P_COMMENTS => c.p4
995 ,P_DATE_PROBATION_END => c.p5
996 ,P_DEFAULT_CODE_COMB_ID => L_DEFAULT_CODE_COMB_ID
997 ,P_EMPLOYMENT_CATEGORY => c.p6
998 ,P_FREQUENCY => c.p7
999 ,P_INTERNAL_ADDRESS_LINE => c.p8
1000 ,P_MANAGER_FLAG => c.p9
1001 ,P_NORMAL_HOURS => c.p10
1002 ,P_PERF_REVIEW_PERIOD => c.p11
1003 ,P_PERF_REVIEW_PERIOD_FREQUENCY => c.p12
1004 ,P_PROBATION_PERIOD => c.p13
1005 ,P_PROBATION_UNIT => c.p14
1006 ,P_SAL_REVIEW_PERIOD => c.p15
1007 ,P_SAL_REVIEW_PERIOD_FREQUENCY => c.p16
1008 ,P_SET_OF_BOOKS_ID => L_SET_OF_BOOKS_ID
1009 ,P_SOURCE_TYPE => c.p17
1010 ,P_TIME_NORMAL_FINISH => c.p18
1011 ,P_TIME_NORMAL_START => c.p19
1012 ,P_BARGAINING_UNIT_CODE => c.p20
1013 ,P_LABOUR_UNION_MEMBER_FLAG => c.p21
1014 ,P_HOURLY_SALARIED_CODE => c.p22
1015 ,P_ASS_ATTRIBUTE_CATEGORY => c.p23
1016 ,P_ASS_ATTRIBUTE1 => c.p24
1017 ,P_ASS_ATTRIBUTE2 => c.p25
1018 ,P_ASS_ATTRIBUTE3 => c.p26
1019 ,P_ASS_ATTRIBUTE4 => c.p27
1020 ,P_ASS_ATTRIBUTE5 => c.p28
1021 ,P_ASS_ATTRIBUTE6 => c.p29
1022 ,P_ASS_ATTRIBUTE7 => c.p30
1023 ,P_ASS_ATTRIBUTE8 => c.p31
1024 ,P_ASS_ATTRIBUTE9 => c.p32
1025 ,P_ASS_ATTRIBUTE10 => c.p33
1026 ,P_ASS_ATTRIBUTE11 => c.p34
1027 ,P_ASS_ATTRIBUTE12 => c.p35
1028 ,P_ASS_ATTRIBUTE13 => c.p36
1029 ,P_ASS_ATTRIBUTE14 => c.p37
1030 ,P_ASS_ATTRIBUTE15 => c.p38
1031 ,P_ASS_ATTRIBUTE16 => c.p39
1032 ,P_ASS_ATTRIBUTE17 => c.p40
1033 ,P_ASS_ATTRIBUTE18 => c.p41
1034 ,P_ASS_ATTRIBUTE19 => c.p42
1035 ,P_ASS_ATTRIBUTE20 => c.p43
1036 ,P_ASS_ATTRIBUTE21 => c.p44
1037 ,P_ASS_ATTRIBUTE22 => c.p45
1038 ,P_ASS_ATTRIBUTE23 => c.p46
1039 ,P_ASS_ATTRIBUTE24 => c.p47
1040 ,P_ASS_ATTRIBUTE25 => c.p48
1041 ,P_ASS_ATTRIBUTE26 => c.p49
1042 ,P_ASS_ATTRIBUTE27 => c.p50
1043 ,P_ASS_ATTRIBUTE28 => c.p51
1044 ,P_ASS_ATTRIBUTE29 => c.p52
1045 ,P_ASS_ATTRIBUTE30 => c.p53
1046 ,P_TITLE => c.p54
1047 ,P_LEGAL_EMPLOYER_ID => L_LEGAL_EMPLOYER_ID
1048 ,P_LEV_LOD_FLG => c.p55
1049 ,P_GROUP_CERT_ISSUE_DATE => c.p56
1050 ,P_HRS_WORKED_PER_WEEK => c.p57
1051 ,P_PGP_SEGMENT1 => c.p58
1052 ,P_PGP_SEGMENT2 => c.p59
1053 ,P_PGP_SEGMENT3 => c.p60
1054 ,P_PGP_SEGMENT4 => c.p61
1055 ,P_PGP_SEGMENT5 => c.p62
1056 ,P_PGP_SEGMENT6 => c.p63
1057 ,P_PGP_SEGMENT7 => c.p64
1058 ,P_PGP_SEGMENT8 => c.p65
1059 ,P_PGP_SEGMENT9 => c.p66
1060 ,P_PGP_SEGMENT10 => c.p67
1061 ,P_PGP_SEGMENT11 => c.p68
1062 ,P_PGP_SEGMENT12 => c.p69
1063 ,P_PGP_SEGMENT13 => c.p70
1064 ,P_PGP_SEGMENT14 => c.p71
1065 ,P_PGP_SEGMENT15 => c.p72
1066 ,P_PGP_SEGMENT16 => c.p73
1067 ,P_PGP_SEGMENT17 => c.p74
1068 ,P_PGP_SEGMENT18 => c.p75
1069 ,P_PGP_SEGMENT19 => c.p76
1070 ,P_PGP_SEGMENT20 => c.p77
1071 ,P_PGP_SEGMENT21 => c.p78
1072 ,P_PGP_SEGMENT22 => c.p79
1073 ,P_PGP_SEGMENT23 => c.p80
1074 ,P_PGP_SEGMENT24 => c.p81
1075 ,P_PGP_SEGMENT25 => c.p82
1076 ,P_PGP_SEGMENT26 => c.p83
1077 ,P_PGP_SEGMENT27 => c.p84
1078 ,P_PGP_SEGMENT28 => c.p85
1079 ,P_PGP_SEGMENT29 => c.p86
1080 ,P_PGP_SEGMENT30 => c.p87
1081 ,P_PGP_CONCAT_SEGMENTS => c.p88
1082 ,P_CONTRACT_ID => L_CONTRACT_ID
1083 ,P_ESTABLISHMENT_ID => L_ESTABLISHMENT_ID
1084 ,P_COLLECTIVE_AGREEMENT_ID => L_COLLECTIVE_AGREEMENT_ID
1085 ,P_CAGR_ID_FLEX_NUM => c.p89
1086 ,P_CAG_SEGMENT1 => c.p90
1087 ,P_CAG_SEGMENT2 => c.p91
1088 ,P_CAG_SEGMENT3 => c.p92
1089 ,P_CAG_SEGMENT4 => c.p93
1090 ,P_CAG_SEGMENT5 => c.p94
1091 ,P_CAG_SEGMENT6 => c.p95
1092 ,P_CAG_SEGMENT7 => c.p96
1093 ,P_CAG_SEGMENT8 => c.p97
1094 ,P_CAG_SEGMENT9 => c.p98
1095 ,P_CAG_SEGMENT10 => c.p99
1096 ,P_CAG_SEGMENT11 => c.p100
1097 ,P_CAG_SEGMENT12 => c.p101
1098 ,P_CAG_SEGMENT13 => c.p102
1099 ,P_CAG_SEGMENT14 => c.p103
1100 ,P_CAG_SEGMENT15 => c.p104
1101 ,P_CAG_SEGMENT16 => c.p105
1102 ,P_CAG_SEGMENT17 => c.p106
1103 ,P_CAG_SEGMENT18 => c.p107
1104 ,P_CAG_SEGMENT19 => c.p108
1105 ,P_CAG_SEGMENT20 => c.p109
1106 ,P_CAGR_GRADE_DEF_ID => c.p110
1110 ,P_PEOPLE_GROUP_ID => c.p114
1107 ,P_CAGR_CONCATENATED_SEGMENTS => c.p111
1108 ,P_ASSIGNMENT_ID => L_ASSIGNMENT_ID
1109 ,P_SOFT_CODING_KEYFLEX_ID => c.p113
1111 ,P_OBJECT_VERSION_NUMBER => c.p115
1112 ,P_EFFECTIVE_START_DATE => c.p116
1113 ,P_EFFECTIVE_END_DATE => c.p117
1114 ,P_ASSIGNMENT_SEQUENCE => c.p118
1115 ,P_COMMENT_ID => c.p119
1116 ,P_CONCATENATED_SEGMENTS => c.p120
1117 ,P_GROUP_NAME => c.p121
1118 ,P_OTHER_MANAGER_WARNING => L_OTHER_MANAGER_WARNING);
1119 hr_data_pump.api_trc_off;
1120 --
1121 iuk(p_batch_line_id,c.p112,L_ASSIGNMENT_ID);
1122 --
1123 if L_OTHER_MANAGER_WARNING then
1124 c.p122 := 'TRUE';
1125 else
1126 c.p122 := 'FALSE';
1127 end if;
1128 --
1129 update hr_pump_batch_lines l set
1130 l.pval002 = decode(c.p2,null,cn,c.p2),
1131 l.pval110 = decode(c.p110,null,cn,c.p110),
1132 l.pval111 = decode(c.p111,null,cn,c.p111),
1133 l.pval112 = decode(c.p112,null,cn,c.p112),
1134 l.pval113 = decode(c.p113,null,cn,c.p113),
1135 l.pval114 = decode(c.p114,null,cn,c.p114),
1136 l.pval115 = decode(c.p115,null,cn,c.p115),
1137 l.pval116 = decode(c.p116,null,cn,dc(c.p116)),
1138 l.pval117 = decode(c.p117,null,cn,dc(c.p117)),
1139 l.pval118 = decode(c.p118,null,cn,c.p118),
1140 l.pval119 = decode(c.p119,null,cn,c.p119),
1141 l.pval120 = decode(c.p120,null,cn,c.p120),
1142 l.pval121 = decode(c.p121,null,cn,c.p121),
1143 l.pval122 = decode(c.p122,null,cn,c.p122)
1144 where l.rowid = c.myrowid;
1145 --
1146 close cr;
1147 --
1148 hr_data_pump.exit('call');
1149 exception
1150 when hr_multi_message.error_message_exist then
1151 if cr%isopen then
1152 close cr;
1153 end if;
1154 hr_pump_utils.set_multi_msg_error_flag(true);
1155 when others then
1156 if cr%isopen then
1157 close cr;
1158 end if;
1159 raise;
1160 end call;
1161 end hrdpp_CREATE_AU_SECONDARY_EMP_;