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