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