eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.HRDPP_CREATE_POSITION

Source


1 package body hrdpp_CREATE_POSITION as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2009/03/30 04:03:10
4  * Generated for API: HR_POSITION_API.CREATE_POSITION
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_POSITION_DEFINITION_ID in number
83 ,P_NAME in varchar2
84 ,P_EFFECTIVE_DATE in date
85 ,P_DATE_EFFECTIVE in date
86 ,P_LANGUAGE_CODE in varchar2
87 ,P_POSITION_TRANSACTION_ID in number default null
88 ,P_AMENDMENT_DATE in date default null
89 ,P_AMENDMENT_RECOMMENDATION in varchar2 default null
90 ,P_AMENDMENT_REF_NUMBER in varchar2 default null
91 ,P_BARGAINING_UNIT_CD in varchar2 default null
92 ,P_COMMENTS in long default null
93 ,P_CURRENT_JOB_PROP_END_DATE in date default null
94 ,P_CURRENT_ORG_PROP_END_DATE in date default null
95 ,P_AVAIL_STATUS_PROP_END_DATE in date default null
96 ,P_DATE_END in date default null
97 ,P_EARLIEST_HIRE_DATE in date default null
98 ,P_FILL_BY_DATE in date default null
99 ,P_FREQUENCY in varchar2 default null
100 ,P_FTE in number default null
101 ,P_MAX_PERSONS in number default null
102 ,P_OVERLAP_PERIOD in number default null
103 ,P_OVERLAP_UNIT_CD in varchar2 default null
104 ,P_PAY_TERM_END_DAY_CD in varchar2 default null
105 ,P_PAY_TERM_END_MONTH_CD in varchar2 default null
106 ,P_PERMANENT_TEMPORARY_FLAG in varchar2 default null
107 ,P_PERMIT_RECRUITMENT_FLAG in varchar2 default null
108 ,P_POSITION_TYPE in varchar2 default null
109 ,P_POSTING_DESCRIPTION in varchar2 default null
110 ,P_PROBATION_PERIOD in number default null
111 ,P_PROBATION_PERIOD_UNIT_CD in varchar2 default null
112 ,P_REPLACEMENT_REQUIRED_FLAG in varchar2 default null
113 ,P_REVIEW_FLAG in varchar2 default null
114 ,P_SEASONAL_FLAG in varchar2 default null
115 ,P_SECURITY_REQUIREMENTS in varchar2 default null
116 ,P_STATUS in varchar2 default null
117 ,P_TERM_START_DAY_CD in varchar2 default null
118 ,P_TERM_START_MONTH_CD in varchar2 default null
119 ,P_TIME_NORMAL_FINISH in varchar2 default null
120 ,P_TIME_NORMAL_START in varchar2 default null
121 ,P_UPDATE_SOURCE_CD in varchar2 default null
122 ,P_WORKING_HOURS in number default null
123 ,P_WORKS_COUNCIL_APPROVAL_FLAG in varchar2 default null
124 ,P_WORK_PERIOD_TYPE_CD in varchar2 default null
125 ,P_WORK_TERM_END_DAY_CD in varchar2 default null
126 ,P_WORK_TERM_END_MONTH_CD in varchar2 default null
127 ,P_PROPOSED_FTE_FOR_LAYOFF in number default null
128 ,P_PROPOSED_DATE_FOR_LAYOFF in date default null
129 ,P_INFORMATION1 in varchar2 default null
130 ,P_INFORMATION2 in varchar2 default null
131 ,P_INFORMATION3 in varchar2 default null
132 ,P_INFORMATION4 in varchar2 default null
133 ,P_INFORMATION5 in varchar2 default null
134 ,P_INFORMATION6 in varchar2 default null
135 ,P_INFORMATION7 in varchar2 default null
136 ,P_INFORMATION8 in varchar2 default null
137 ,P_INFORMATION9 in varchar2 default null
138 ,P_INFORMATION10 in varchar2 default null
139 ,P_INFORMATION11 in varchar2 default null
140 ,P_INFORMATION12 in varchar2 default null
141 ,P_INFORMATION13 in varchar2 default null
142 ,P_INFORMATION14 in varchar2 default null
143 ,P_INFORMATION15 in varchar2 default null
144 ,P_INFORMATION16 in varchar2 default null
145 ,P_INFORMATION17 in varchar2 default null
146 ,P_INFORMATION18 in varchar2 default null
147 ,P_INFORMATION19 in varchar2 default null
148 ,P_INFORMATION20 in varchar2 default null
149 ,P_INFORMATION21 in varchar2 default null
150 ,P_INFORMATION22 in varchar2 default null
151 ,P_INFORMATION23 in varchar2 default null
152 ,P_INFORMATION24 in varchar2 default null
153 ,P_INFORMATION25 in varchar2 default null
154 ,P_INFORMATION26 in varchar2 default null
155 ,P_INFORMATION27 in varchar2 default null
156 ,P_INFORMATION28 in varchar2 default null
157 ,P_INFORMATION29 in varchar2 default null
158 ,P_INFORMATION30 in varchar2 default null
159 ,P_INFORMATION_CATEGORY in varchar2 default null
160 ,P_ATTRIBUTE1 in varchar2 default null
161 ,P_ATTRIBUTE2 in varchar2 default null
162 ,P_ATTRIBUTE3 in varchar2 default null
163 ,P_ATTRIBUTE4 in varchar2 default null
164 ,P_ATTRIBUTE5 in varchar2 default null
165 ,P_ATTRIBUTE6 in varchar2 default null
166 ,P_ATTRIBUTE7 in varchar2 default null
167 ,P_ATTRIBUTE8 in varchar2 default null
168 ,P_ATTRIBUTE9 in varchar2 default null
169 ,P_ATTRIBUTE10 in varchar2 default null
170 ,P_ATTRIBUTE11 in varchar2 default null
171 ,P_ATTRIBUTE12 in varchar2 default null
172 ,P_ATTRIBUTE13 in varchar2 default null
173 ,P_ATTRIBUTE14 in varchar2 default null
174 ,P_ATTRIBUTE15 in varchar2 default null
175 ,P_ATTRIBUTE16 in varchar2 default null
176 ,P_ATTRIBUTE17 in varchar2 default null
177 ,P_ATTRIBUTE18 in varchar2 default null
178 ,P_ATTRIBUTE19 in varchar2 default null
179 ,P_ATTRIBUTE20 in varchar2 default null
180 ,P_ATTRIBUTE21 in varchar2 default null
181 ,P_ATTRIBUTE22 in varchar2 default null
182 ,P_ATTRIBUTE23 in varchar2 default null
183 ,P_ATTRIBUTE24 in varchar2 default null
184 ,P_ATTRIBUTE25 in varchar2 default null
185 ,P_ATTRIBUTE26 in varchar2 default null
186 ,P_ATTRIBUTE27 in varchar2 default null
187 ,P_ATTRIBUTE28 in varchar2 default null
188 ,P_ATTRIBUTE29 in varchar2 default null
189 ,P_ATTRIBUTE30 in varchar2 default null
190 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
191 ,P_SEGMENT1 in varchar2 default null
192 ,P_SEGMENT2 in varchar2 default null
193 ,P_SEGMENT3 in varchar2 default null
194 ,P_SEGMENT4 in varchar2 default null
195 ,P_SEGMENT5 in varchar2 default null
196 ,P_SEGMENT6 in varchar2 default null
197 ,P_SEGMENT7 in varchar2 default null
198 ,P_SEGMENT8 in varchar2 default null
199 ,P_SEGMENT9 in varchar2 default null
200 ,P_SEGMENT10 in varchar2 default null
201 ,P_SEGMENT11 in varchar2 default null
202 ,P_SEGMENT12 in varchar2 default null
203 ,P_SEGMENT13 in varchar2 default null
204 ,P_SEGMENT14 in varchar2 default null
205 ,P_SEGMENT15 in varchar2 default null
206 ,P_SEGMENT16 in varchar2 default null
207 ,P_SEGMENT17 in varchar2 default null
208 ,P_SEGMENT18 in varchar2 default null
209 ,P_SEGMENT19 in varchar2 default null
210 ,P_SEGMENT20 in varchar2 default null
211 ,P_SEGMENT21 in varchar2 default null
212 ,P_SEGMENT22 in varchar2 default null
213 ,P_SEGMENT23 in varchar2 default null
214 ,P_SEGMENT24 in varchar2 default null
215 ,P_SEGMENT25 in varchar2 default null
216 ,P_SEGMENT26 in varchar2 default null
217 ,P_SEGMENT27 in varchar2 default null
218 ,P_SEGMENT28 in varchar2 default null
219 ,P_SEGMENT29 in varchar2 default null
220 ,P_SEGMENT30 in varchar2 default null
221 ,P_CONCAT_SEGMENTS in varchar2 default null
222 ,P_REQUEST_ID in number default null
223 ,P_PROGRAM_APPLICATION_ID in number default null
224 ,P_PROGRAM_ID in number default null
225 ,P_PROGRAM_UPDATE_DATE in date default null
226 ,P_SECURITY_PROFILE_ID in number default null
227 ,I_SECURITY_PROFILE_ID in varchar2 default 'N'
228 ,P_JOB_NAME in varchar2
229 ,P_ORGANIZATION_NAME in varchar2
230 ,P_SHARED_TYPE_NAME in varchar2 default null
231 ,P_SYSTEM_TYPE_CD in varchar2 default null
232 ,P_ENTRY_STEP_USER_KEY in varchar2 default null
233 ,P_ENTRY_GRADE_RULE_USER_KEY in varchar2 default null
234 ,P_LOCATION_CODE in varchar2 default null
235 ,P_PAY_FREQ_PAYROLL_NAME in varchar2 default null
236 ,P_PRIOR_POSITION_NAME in varchar2 default null
237 ,P_RELIEF_POSITION_NAME in varchar2 default null
238 ,P_ENTRY_GRADE_NAME in varchar2 default null
239 ,P_SUCCESSOR_POSITION_NAME in varchar2 default null
240 ,P_SUPERVISOR_POSITION_NAME in varchar2 default null
241 ,P_PAY_BASIS_NAME in varchar2 default null
242 ,P_SUPERVISOR_USER_KEY in varchar2 default null) is
243 blid number := p_data_pump_batch_line_id;
244 begin
245 if blid is not null then
246 delete from hr_pump_batch_lines where batch_line_id = blid;
247 delete from hr_pump_batch_exceptions
248 where source_type = 'BATCH_LINE' and source_id = blid;
249 end if;
250 insert into hr_pump_batch_lines
251 (batch_id
252 ,batch_line_id
253 ,business_group_name
254 ,api_module_id
255 ,line_status
256 ,user_sequence
257 ,link_value
258 ,pval004
259 ,pval005
260 ,pval007
261 ,pval008
262 ,pval009
263 ,pval010
264 ,pval011
265 ,pval012
266 ,pval013
267 ,pval014
268 ,plongval
269 ,pval016
270 ,pval017
271 ,pval018
272 ,pval019
273 ,pval020
274 ,pval021
275 ,pval022
276 ,pval023
277 ,pval024
278 ,pval025
279 ,pval026
280 ,pval027
281 ,pval028
282 ,pval029
283 ,pval030
284 ,pval031
285 ,pval032
286 ,pval033
287 ,pval034
288 ,pval035
289 ,pval036
290 ,pval037
291 ,pval038
292 ,pval039
293 ,pval040
294 ,pval041
295 ,pval042
296 ,pval043
297 ,pval044
298 ,pval045
299 ,pval046
300 ,pval047
301 ,pval048
302 ,pval049
303 ,pval050
304 ,pval051
305 ,pval052
306 ,pval053
307 ,pval054
308 ,pval055
309 ,pval056
310 ,pval057
311 ,pval058
312 ,pval059
313 ,pval060
314 ,pval061
315 ,pval062
316 ,pval063
317 ,pval064
318 ,pval065
319 ,pval066
320 ,pval067
321 ,pval068
322 ,pval069
323 ,pval070
324 ,pval071
325 ,pval072
326 ,pval073
327 ,pval074
328 ,pval075
329 ,pval076
330 ,pval077
331 ,pval078
332 ,pval079
333 ,pval080
334 ,pval081
335 ,pval082
336 ,pval083
337 ,pval084
338 ,pval085
339 ,pval086
340 ,pval087
341 ,pval088
342 ,pval089
343 ,pval090
344 ,pval091
345 ,pval092
346 ,pval093
347 ,pval094
348 ,pval095
349 ,pval096
350 ,pval097
351 ,pval098
352 ,pval099
353 ,pval100
354 ,pval101
355 ,pval102
356 ,pval103
357 ,pval104
358 ,pval105
359 ,pval106
360 ,pval107
361 ,pval108
362 ,pval109
363 ,pval110
364 ,pval111
365 ,pval112
366 ,pval113
367 ,pval114
368 ,pval115
369 ,pval116
370 ,pval117
371 ,pval118
372 ,pval119
373 ,pval120
374 ,pval121
375 ,pval122
376 ,pval123
377 ,pval124
378 ,pval125
379 ,pval126
380 ,pval127
381 ,pval128
382 ,pval129
383 ,pval130
384 ,pval131
385 ,pval132
386 ,pval133
387 ,pval134
388 ,pval135
389 ,pval136
390 ,pval137
391 ,pval138
392 ,pval139
393 ,pval140
394 ,pval141
395 ,pval142
396 ,pval143
397 ,pval144
398 ,pval145
399 ,pval146
400 ,pval147
401 ,pval148
402 ,pval149
403 ,pval150
404 ,pval151
405 ,pval152
406 ,pval153
407 ,pval154
408 ,pval155
409 ,pval156
410 ,pval157
411 ,pval158
412 ,pval159
413 ,pval160
414 ,pval161
415 ,pval162
416 ,pval163
417 ,pval164)
418 values
419 (p_batch_id
420 ,nvl(blid,hr_pump_batch_lines_s.nextval)
421 ,p_data_pump_business_grp_name
422 ,1215
423 ,'U'
424 ,p_user_sequence
425 ,p_link_value
426 ,P_POSITION_DEFINITION_ID
427 ,P_NAME
428 ,dc(P_EFFECTIVE_DATE)
429 ,dc(P_DATE_EFFECTIVE)
430 ,P_LANGUAGE_CODE
431 ,P_POSITION_TRANSACTION_ID
432 ,dc(P_AMENDMENT_DATE)
433 ,P_AMENDMENT_RECOMMENDATION
434 ,P_AMENDMENT_REF_NUMBER
435 ,P_BARGAINING_UNIT_CD
436 ,P_COMMENTS
437 ,dc(P_CURRENT_JOB_PROP_END_DATE)
438 ,dc(P_CURRENT_ORG_PROP_END_DATE)
439 ,dc(P_AVAIL_STATUS_PROP_END_DATE)
440 ,dc(P_DATE_END)
441 ,dc(P_EARLIEST_HIRE_DATE)
442 ,dc(P_FILL_BY_DATE)
443 ,P_FREQUENCY
444 ,P_FTE
445 ,P_MAX_PERSONS
446 ,P_OVERLAP_PERIOD
447 ,P_OVERLAP_UNIT_CD
448 ,P_PAY_TERM_END_DAY_CD
449 ,P_PAY_TERM_END_MONTH_CD
450 ,P_PERMANENT_TEMPORARY_FLAG
451 ,P_PERMIT_RECRUITMENT_FLAG
452 ,P_POSITION_TYPE
453 ,P_POSTING_DESCRIPTION
454 ,P_PROBATION_PERIOD
455 ,P_PROBATION_PERIOD_UNIT_CD
456 ,P_REPLACEMENT_REQUIRED_FLAG
457 ,P_REVIEW_FLAG
458 ,P_SEASONAL_FLAG
459 ,P_SECURITY_REQUIREMENTS
460 ,P_STATUS
461 ,P_TERM_START_DAY_CD
462 ,P_TERM_START_MONTH_CD
463 ,P_TIME_NORMAL_FINISH
464 ,P_TIME_NORMAL_START
465 ,P_UPDATE_SOURCE_CD
466 ,P_WORKING_HOURS
467 ,P_WORKS_COUNCIL_APPROVAL_FLAG
468 ,P_WORK_PERIOD_TYPE_CD
469 ,P_WORK_TERM_END_DAY_CD
470 ,P_WORK_TERM_END_MONTH_CD
471 ,P_PROPOSED_FTE_FOR_LAYOFF
472 ,dc(P_PROPOSED_DATE_FOR_LAYOFF)
473 ,P_INFORMATION1
474 ,P_INFORMATION2
475 ,P_INFORMATION3
476 ,P_INFORMATION4
477 ,P_INFORMATION5
478 ,P_INFORMATION6
479 ,P_INFORMATION7
480 ,P_INFORMATION8
481 ,P_INFORMATION9
482 ,P_INFORMATION10
483 ,P_INFORMATION11
484 ,P_INFORMATION12
485 ,P_INFORMATION13
486 ,P_INFORMATION14
487 ,P_INFORMATION15
488 ,P_INFORMATION16
489 ,P_INFORMATION17
490 ,P_INFORMATION18
491 ,P_INFORMATION19
492 ,P_INFORMATION20
493 ,P_INFORMATION21
494 ,P_INFORMATION22
495 ,P_INFORMATION23
496 ,P_INFORMATION24
497 ,P_INFORMATION25
498 ,P_INFORMATION26
499 ,P_INFORMATION27
500 ,P_INFORMATION28
501 ,P_INFORMATION29
502 ,P_INFORMATION30
503 ,P_INFORMATION_CATEGORY
504 ,P_ATTRIBUTE1
505 ,P_ATTRIBUTE2
506 ,P_ATTRIBUTE3
507 ,P_ATTRIBUTE4
508 ,P_ATTRIBUTE5
509 ,P_ATTRIBUTE6
510 ,P_ATTRIBUTE7
511 ,P_ATTRIBUTE8
512 ,P_ATTRIBUTE9
513 ,P_ATTRIBUTE10
514 ,P_ATTRIBUTE11
515 ,P_ATTRIBUTE12
516 ,P_ATTRIBUTE13
517 ,P_ATTRIBUTE14
518 ,P_ATTRIBUTE15
519 ,P_ATTRIBUTE16
520 ,P_ATTRIBUTE17
521 ,P_ATTRIBUTE18
522 ,P_ATTRIBUTE19
523 ,P_ATTRIBUTE20
524 ,P_ATTRIBUTE21
525 ,P_ATTRIBUTE22
526 ,P_ATTRIBUTE23
527 ,P_ATTRIBUTE24
528 ,P_ATTRIBUTE25
529 ,P_ATTRIBUTE26
530 ,P_ATTRIBUTE27
531 ,P_ATTRIBUTE28
532 ,P_ATTRIBUTE29
533 ,P_ATTRIBUTE30
534 ,P_ATTRIBUTE_CATEGORY
535 ,P_SEGMENT1
536 ,P_SEGMENT2
537 ,P_SEGMENT3
538 ,P_SEGMENT4
539 ,P_SEGMENT5
540 ,P_SEGMENT6
541 ,P_SEGMENT7
542 ,P_SEGMENT8
543 ,P_SEGMENT9
544 ,P_SEGMENT10
545 ,P_SEGMENT11
546 ,P_SEGMENT12
547 ,P_SEGMENT13
548 ,P_SEGMENT14
549 ,P_SEGMENT15
550 ,P_SEGMENT16
551 ,P_SEGMENT17
552 ,P_SEGMENT18
553 ,P_SEGMENT19
554 ,P_SEGMENT20
555 ,P_SEGMENT21
556 ,P_SEGMENT22
557 ,P_SEGMENT23
558 ,P_SEGMENT24
559 ,P_SEGMENT25
560 ,P_SEGMENT26
561 ,P_SEGMENT27
565 ,P_CONCAT_SEGMENTS
562 ,P_SEGMENT28
563 ,P_SEGMENT29
564 ,P_SEGMENT30
566 ,P_REQUEST_ID
567 ,P_PROGRAM_APPLICATION_ID
568 ,P_PROGRAM_ID
569 ,dc(P_PROGRAM_UPDATE_DATE)
570 ,nd(P_SECURITY_PROFILE_ID,I_SECURITY_PROFILE_ID)
571 ,P_JOB_NAME
572 ,P_ORGANIZATION_NAME
573 ,P_SHARED_TYPE_NAME
574 ,P_SYSTEM_TYPE_CD
575 ,P_ENTRY_STEP_USER_KEY
576 ,P_ENTRY_GRADE_RULE_USER_KEY
577 ,P_LOCATION_CODE
578 ,P_PAY_FREQ_PAYROLL_NAME
579 ,P_PRIOR_POSITION_NAME
580 ,P_RELIEF_POSITION_NAME
581 ,P_ENTRY_GRADE_NAME
582 ,P_SUCCESSOR_POSITION_NAME
583 ,P_SUPERVISOR_POSITION_NAME
584 ,P_PAY_BASIS_NAME
585 ,P_SUPERVISOR_USER_KEY);
586 end insert_batch_lines;
587 --
588 procedure call
589 (p_business_group_id in number,
590 p_batch_line_id     in number) is
591 cursor cr is
592 select l.rowid myrowid,
593 l.pval001 p1,
594 decode(l.pval002,cn,dn,d(l.pval002)) p2,
595 decode(l.pval003,cn,dn,d(l.pval003)) p3,
596 decode(l.pval004,cn,nn,n(l.pval004)) p4,
597 decode(l.pval005,cn,vn,l.pval005) p5,
598 l.pval006 p6,
599 decode(l.pval007,cn,dn,d(l.pval007)) p7,
600 decode(l.pval008,cn,dn,d(l.pval008)) p8,
601 decode(l.pval009,cn,vn,l.pval009) p9,
602 decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
603 l.pval010 d10,
604 decode(l.pval011,cn,dn,vn,dn,d(l.pval011)) p11,
605 l.pval011 d11,
606 decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
607 l.pval012 d12,
608 decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,
609 l.pval013 d13,
610 decode(l.pval014,cn,vn,vn,vn,
611  hr_pump_get.gl(l.pval014,'BARGAINING_UNIT_CODE',d(l.pval007),l.pval009)) p14,
612 l.pval014 d14,
613 l.plongval plongval,
614 decode(l.pval016,cn,dn,vn,dn,d(l.pval016)) p16,
615 l.pval016 d16,
616 decode(l.pval017,cn,dn,vn,dn,d(l.pval017)) p17,
617 l.pval017 d17,
618 decode(l.pval018,cn,dn,vn,dn,d(l.pval018)) p18,
619 l.pval018 d18,
620 decode(l.pval019,cn,dn,vn,dn,d(l.pval019)) p19,
621 l.pval019 d19,
622 decode(l.pval020,cn,dn,vn,dn,d(l.pval020)) p20,
623 l.pval020 d20,
624 decode(l.pval021,cn,dn,vn,dn,d(l.pval021)) p21,
625 l.pval021 d21,
626 decode(l.pval022,cn,vn,vn,vn,
627  hr_pump_get.gl(l.pval022,'FREQUENCY',d(l.pval007),l.pval009)) p22,
628 l.pval022 d22,
629 decode(l.pval023,cn,nn,vn,nn,n(l.pval023)) p23,
630 l.pval023 d23,
631 decode(l.pval024,cn,nn,vn,nn,n(l.pval024)) p24,
632 l.pval024 d24,
633 decode(l.pval025,cn,nn,vn,nn,n(l.pval025)) p25,
634 l.pval025 d25,
635 decode(l.pval026,cn,vn,vn,vn,
636  hr_pump_get.gl(l.pval026,'FREQUENCY',d(l.pval007),l.pval009)) p26,
637 l.pval026 d26,
638 decode(l.pval027,cn,vn,vn,vn,
639  hr_pump_get.gl(l.pval027,'DAY_CODE',d(l.pval007),l.pval009)) p27,
640 l.pval027 d27,
641 decode(l.pval028,cn,vn,vn,vn,
642  hr_pump_get.gl(l.pval028,'MONTH_CODE',d(l.pval007),l.pval009)) p28,
643 l.pval028 d28,
644 decode(l.pval029,cn,vn,vn,vn,
645  hr_pump_get.gl(l.pval029,'YES_NO',d(l.pval007),l.pval009)) p29,
646 l.pval029 d29,
647 decode(l.pval030,cn,vn,vn,vn,
648  hr_pump_get.gl(l.pval030,'YES_NO',d(l.pval007),l.pval009)) p30,
649 l.pval030 d30,
650 decode(l.pval031,cn,vn,vn,'NONE',
651  hr_pump_get.gl(l.pval031,'POSITION_TYPE',d(l.pval007),l.pval009)) p31,
652 l.pval031 d31,
653 decode(l.pval032,cn,vn,vn,vn,l.pval032) p32,
654 l.pval032 d32,
655 decode(l.pval033,cn,nn,vn,nn,n(l.pval033)) p33,
656 l.pval033 d33,
657 decode(l.pval034,cn,vn,vn,vn,
658  hr_pump_get.gl(l.pval034,'QUALIFYING_UNITS',d(l.pval007),l.pval009)) p34,
659 l.pval034 d34,
660 decode(l.pval035,cn,vn,vn,vn,
661  hr_pump_get.gl(l.pval035,'YES_NO',d(l.pval007),l.pval009)) p35,
662 l.pval035 d35,
663 decode(l.pval036,cn,vn,vn,vn,
664  hr_pump_get.gl(l.pval036,'YES_NO',d(l.pval007),l.pval009)) p36,
665 l.pval036 d36,
666 decode(l.pval037,cn,vn,vn,vn,
667  hr_pump_get.gl(l.pval037,'YES_NO',d(l.pval007),l.pval009)) p37,
668 l.pval037 d37,
669 decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
670 l.pval038 d38,
671 decode(l.pval039,cn,vn,vn,vn,
672  hr_pump_get.gl(l.pval039,'POSITION_STATUS',d(l.pval007),l.pval009)) p39,
673 l.pval039 d39,
674 decode(l.pval040,cn,vn,vn,vn,
675  hr_pump_get.gl(l.pval040,'DAY_CODE',d(l.pval007),l.pval009)) p40,
676 l.pval040 d40,
677 decode(l.pval041,cn,vn,vn,vn,
678  hr_pump_get.gl(l.pval041,'MONTH_CODE',d(l.pval007),l.pval009)) p41,
679 l.pval041 d41,
680 decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
681 l.pval042 d42,
682 decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
683 l.pval043 d43,
684 decode(l.pval044,cn,vn,vn,vn,l.pval044) p44,
685 l.pval044 d44,
686 decode(l.pval045,cn,nn,vn,nn,n(l.pval045)) p45,
687 l.pval045 d45,
688 decode(l.pval046,cn,vn,vn,vn,
689  hr_pump_get.gl(l.pval046,'YES_NO',d(l.pval007),l.pval009)) p46,
690 l.pval046 d46,
691 decode(l.pval047,cn,vn,vn,vn,
692  hr_pump_get.gl(l.pval047,'YES_NO',d(l.pval007),l.pval009)) p47,
693 l.pval047 d47,
694 decode(l.pval048,cn,vn,vn,vn,
695  hr_pump_get.gl(l.pval048,'DAY_CODE',d(l.pval007),l.pval009)) p48,
696 l.pval048 d48,
697 decode(l.pval049,cn,vn,vn,vn,
698  hr_pump_get.gl(l.pval049,'MONTH_CODE',d(l.pval007),l.pval009)) p49,
699 l.pval049 d49,
700 decode(l.pval050,cn,nn,vn,nn,n(l.pval050)) p50,
701 l.pval050 d50,
702 decode(l.pval051,cn,dn,vn,dn,d(l.pval051)) p51,
703 l.pval051 d51,
704 decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,
705 l.pval052 d52,
706 decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
707 l.pval053 d53,
708 decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
709 l.pval054 d54,
710 decode(l.pval055,cn,vn,vn,vn,l.pval055) p55,
711 l.pval055 d55,
712 decode(l.pval056,cn,vn,vn,vn,l.pval056) p56,
713 l.pval056 d56,
714 decode(l.pval057,cn,vn,vn,vn,l.pval057) p57,
715 l.pval057 d57,
716 decode(l.pval058,cn,vn,vn,vn,l.pval058) p58,
720 decode(l.pval060,cn,vn,vn,vn,l.pval060) p60,
717 l.pval058 d58,
718 decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,
719 l.pval059 d59,
721 l.pval060 d60,
722 decode(l.pval061,cn,vn,vn,vn,l.pval061) p61,
723 l.pval061 d61,
724 decode(l.pval062,cn,vn,vn,vn,l.pval062) p62,
725 l.pval062 d62,
726 decode(l.pval063,cn,vn,vn,vn,l.pval063) p63,
727 l.pval063 d63,
728 decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
729 l.pval064 d64,
730 decode(l.pval065,cn,vn,vn,vn,l.pval065) p65,
731 l.pval065 d65,
732 decode(l.pval066,cn,vn,vn,vn,l.pval066) p66,
733 l.pval066 d66,
734 decode(l.pval067,cn,vn,vn,vn,l.pval067) p67,
735 l.pval067 d67,
736 decode(l.pval068,cn,vn,vn,vn,l.pval068) p68,
737 l.pval068 d68,
738 decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
739 l.pval069 d69,
740 decode(l.pval070,cn,vn,vn,vn,l.pval070) p70,
741 l.pval070 d70,
742 decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
743 l.pval071 d71,
744 decode(l.pval072,cn,vn,vn,vn,l.pval072) p72,
745 l.pval072 d72,
746 decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
747 l.pval073 d73,
748 decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
749 l.pval074 d74,
750 decode(l.pval075,cn,vn,vn,vn,l.pval075) p75,
751 l.pval075 d75,
752 decode(l.pval076,cn,vn,vn,vn,l.pval076) p76,
753 l.pval076 d76,
754 decode(l.pval077,cn,vn,vn,vn,l.pval077) p77,
755 l.pval077 d77,
756 decode(l.pval078,cn,vn,vn,vn,l.pval078) p78,
757 l.pval078 d78,
758 decode(l.pval079,cn,vn,vn,vn,l.pval079) p79,
759 l.pval079 d79,
760 decode(l.pval080,cn,vn,vn,vn,l.pval080) p80,
761 l.pval080 d80,
762 decode(l.pval081,cn,vn,vn,vn,l.pval081) p81,
763 l.pval081 d81,
764 decode(l.pval082,cn,vn,vn,vn,l.pval082) p82,
765 l.pval082 d82,
766 decode(l.pval083,cn,vn,vn,vn,l.pval083) p83,
767 l.pval083 d83,
768 decode(l.pval084,cn,vn,vn,vn,l.pval084) p84,
769 l.pval084 d84,
770 decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,
771 l.pval085 d85,
772 decode(l.pval086,cn,vn,vn,vn,l.pval086) p86,
773 l.pval086 d86,
774 decode(l.pval087,cn,vn,vn,vn,l.pval087) p87,
775 l.pval087 d87,
776 decode(l.pval088,cn,vn,vn,vn,l.pval088) p88,
777 l.pval088 d88,
778 decode(l.pval089,cn,vn,vn,vn,l.pval089) p89,
779 l.pval089 d89,
780 decode(l.pval090,cn,vn,vn,vn,l.pval090) p90,
781 l.pval090 d90,
782 decode(l.pval091,cn,vn,vn,vn,l.pval091) p91,
783 l.pval091 d91,
784 decode(l.pval092,cn,vn,vn,vn,l.pval092) p92,
785 l.pval092 d92,
786 decode(l.pval093,cn,vn,vn,vn,l.pval093) p93,
787 l.pval093 d93,
788 decode(l.pval094,cn,vn,vn,vn,l.pval094) p94,
789 l.pval094 d94,
790 decode(l.pval095,cn,vn,vn,vn,l.pval095) p95,
791 l.pval095 d95,
792 decode(l.pval096,cn,vn,vn,vn,l.pval096) p96,
793 l.pval096 d96,
794 decode(l.pval097,cn,vn,vn,vn,l.pval097) p97,
795 l.pval097 d97,
796 decode(l.pval098,cn,vn,vn,vn,l.pval098) p98,
797 l.pval098 d98,
798 decode(l.pval099,cn,vn,vn,vn,l.pval099) p99,
799 l.pval099 d99,
800 decode(l.pval100,cn,vn,vn,vn,l.pval100) p100,
801 l.pval100 d100,
802 decode(l.pval101,cn,vn,vn,vn,l.pval101) p101,
803 l.pval101 d101,
804 decode(l.pval102,cn,vn,vn,vn,l.pval102) p102,
805 l.pval102 d102,
806 decode(l.pval103,cn,vn,vn,vn,l.pval103) p103,
807 l.pval103 d103,
808 decode(l.pval104,cn,vn,vn,vn,l.pval104) p104,
809 l.pval104 d104,
810 decode(l.pval105,cn,vn,vn,vn,l.pval105) p105,
811 l.pval105 d105,
812 decode(l.pval106,cn,vn,vn,vn,l.pval106) p106,
813 l.pval106 d106,
814 decode(l.pval107,cn,vn,vn,vn,l.pval107) p107,
815 l.pval107 d107,
816 decode(l.pval108,cn,vn,vn,vn,l.pval108) p108,
817 l.pval108 d108,
818 decode(l.pval109,cn,vn,vn,vn,l.pval109) p109,
819 l.pval109 d109,
820 decode(l.pval110,cn,vn,vn,vn,l.pval110) p110,
821 l.pval110 d110,
822 decode(l.pval111,cn,vn,vn,vn,l.pval111) p111,
823 l.pval111 d111,
824 decode(l.pval112,cn,vn,vn,vn,l.pval112) p112,
825 l.pval112 d112,
826 decode(l.pval113,cn,vn,vn,vn,l.pval113) p113,
827 l.pval113 d113,
828 decode(l.pval114,cn,vn,vn,vn,l.pval114) p114,
829 l.pval114 d114,
830 decode(l.pval115,cn,vn,vn,vn,l.pval115) p115,
831 l.pval115 d115,
832 decode(l.pval116,cn,vn,vn,vn,l.pval116) p116,
833 l.pval116 d116,
834 decode(l.pval117,cn,vn,vn,vn,l.pval117) p117,
835 l.pval117 d117,
836 decode(l.pval118,cn,vn,vn,vn,l.pval118) p118,
837 l.pval118 d118,
838 decode(l.pval119,cn,vn,vn,vn,l.pval119) p119,
839 l.pval119 d119,
840 decode(l.pval120,cn,vn,vn,vn,l.pval120) p120,
841 l.pval120 d120,
842 decode(l.pval121,cn,vn,vn,vn,l.pval121) p121,
843 l.pval121 d121,
844 decode(l.pval122,cn,vn,vn,vn,l.pval122) p122,
845 l.pval122 d122,
846 decode(l.pval123,cn,vn,vn,vn,l.pval123) p123,
847 l.pval123 d123,
848 decode(l.pval124,cn,vn,vn,vn,l.pval124) p124,
849 l.pval124 d124,
850 decode(l.pval125,cn,vn,vn,vn,l.pval125) p125,
851 l.pval125 d125,
852 decode(l.pval126,cn,vn,vn,vn,l.pval126) p126,
853 l.pval126 d126,
854 decode(l.pval127,cn,vn,vn,vn,l.pval127) p127,
855 l.pval127 d127,
856 decode(l.pval128,cn,vn,vn,vn,l.pval128) p128,
857 l.pval128 d128,
858 decode(l.pval129,cn,vn,vn,vn,l.pval129) p129,
859 l.pval129 d129,
860 decode(l.pval130,cn,vn,vn,vn,l.pval130) p130,
861 l.pval130 d130,
862 decode(l.pval131,cn,vn,vn,vn,l.pval131) p131,
863 l.pval131 d131,
864 decode(l.pval132,cn,vn,vn,vn,l.pval132) p132,
865 l.pval132 d132,
866 decode(l.pval133,cn,vn,vn,vn,l.pval133) p133,
867 l.pval133 d133,
868 decode(l.pval134,cn,vn,vn,vn,l.pval134) p134,
869 l.pval134 d134,
870 decode(l.pval135,cn,vn,vn,vn,l.pval135) p135,
871 l.pval135 d135,
872 decode(l.pval136,cn,vn,vn,vn,l.pval136) p136,
876 decode(l.pval138,cn,vn,vn,vn,l.pval138) p138,
873 l.pval136 d136,
874 decode(l.pval137,cn,vn,vn,vn,l.pval137) p137,
875 l.pval137 d137,
877 l.pval138 d138,
878 decode(l.pval139,cn,vn,vn,vn,l.pval139) p139,
879 l.pval139 d139,
880 decode(l.pval140,cn,vn,vn,vn,l.pval140) p140,
881 l.pval140 d140,
882 decode(l.pval141,cn,vn,vn,vn,l.pval141) p141,
883 l.pval141 d141,
884 decode(l.pval142,cn,vn,vn,vn,l.pval142) p142,
885 l.pval142 d142,
886 decode(l.pval143,cn,vn,vn,vn,l.pval143) p143,
887 l.pval143 d143,
888 decode(l.pval144,cn,vn,vn,vn,l.pval144) p144,
889 l.pval144 d144,
890 decode(l.pval145,cn,nn,vn,nn,n(l.pval145)) p145,
891 l.pval145 d145,
892 decode(l.pval146,cn,nn,vn,nn,n(l.pval146)) p146,
893 l.pval146 d146,
894 decode(l.pval147,cn,nn,vn,nn,n(l.pval147)) p147,
895 l.pval147 d147,
896 decode(l.pval148,cn,dn,vn,dn,d(l.pval148)) p148,
897 l.pval148 d148,
898 decode(l.pval149,cn,nn,vn,HR_SECURITY.GET_SECURITY_PROFILE,n(l.pval149)) p149,
899 l.pval149 d149,
900 decode(l.pval150,cn,vn,l.pval150) p150,
901 decode(l.pval151,cn,vn,l.pval151) p151,
902 decode(l.pval152,cn,vn,vn,vn,l.pval152) p152,
903 l.pval152 d152,
904 decode(l.pval153,cn,vn,vn,vn,l.pval153) p153,
905 l.pval153 d153,
906 decode(l.pval154,cn,vn,vn,vn,l.pval154) p154,
907 l.pval154 d154,
908 decode(l.pval155,cn,vn,vn,vn,l.pval155) p155,
909 l.pval155 d155,
910 decode(l.pval156,cn,vn,vn,vn,l.pval156) p156,
911 l.pval156 d156,
912 decode(l.pval157,cn,vn,vn,vn,l.pval157) p157,
913 l.pval157 d157,
914 decode(l.pval158,cn,vn,vn,vn,l.pval158) p158,
915 l.pval158 d158,
916 decode(l.pval159,cn,vn,vn,vn,l.pval159) p159,
917 l.pval159 d159,
918 decode(l.pval160,cn,vn,vn,vn,l.pval160) p160,
919 l.pval160 d160,
920 decode(l.pval161,cn,vn,vn,vn,l.pval161) p161,
921 l.pval161 d161,
922 decode(l.pval162,cn,vn,vn,vn,l.pval162) p162,
923 l.pval162 d162,
924 decode(l.pval163,cn,vn,vn,vn,l.pval163) p163,
925 l.pval163 d163,
926 decode(l.pval164,cn,vn,vn,vn,l.pval164) p164,
927 l.pval164 d164
928 from hr_pump_batch_lines l
929 where l.batch_line_id = p_batch_line_id;
930 --
931 c cr%rowtype;
932 l_validate boolean := false;
933 L_COMMENTS varchar2(32767);
934 L_JOB_ID number;
935 L_ORGANIZATION_ID number;
936 L_AVAILABILITY_STATUS_ID number;
937 L_ENTRY_STEP_ID number;
938 L_ENTRY_GRADE_RULE_ID number;
939 L_LOCATION_ID number;
940 L_PAY_FREQ_PAYROLL_ID number;
941 L_PRIOR_POSITION_ID number;
942 L_RELIEF_POSITION_ID number;
943 L_ENTRY_GRADE_ID number;
944 L_SUCCESSOR_POSITION_ID number;
945 L_SUPERVISOR_POSITION_ID number;
946 L_PAY_BASIS_ID number;
947 L_SUPERVISOR_ID number;
948 --
949 begin
950 hr_data_pump.entry('call');
951 open cr;
952 fetch cr into c;
953 if cr%notfound then
954 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
955 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
956 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
957 hr_utility.set_message_token('VALUE',p_batch_line_id);
958 hr_utility.raise_error;
959 end if;
960 --
961 L_COMMENTS := c.plongval;
962 if L_COMMENTS = cn then
963 L_COMMENTS := null;
964 end if;
965 --
966 if c.p150 is null or
967 c.p7 is null then
968 L_JOB_ID:=nn;
969 else
970 L_JOB_ID := 
971 hr_pump_get.get_job_id
972 (P_JOB_NAME => c.p150
973 ,P_EFFECTIVE_DATE => c.p7
974 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
975 end if;
976 --
977 if c.p151 is null or
978 c.p7 is null or
979 c.p9 is null then
980 L_ORGANIZATION_ID:=nn;
981 else
982 L_ORGANIZATION_ID := 
983 hr_pump_get.get_organization_id
984 (P_ORGANIZATION_NAME => c.p151
985 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
986 ,P_EFFECTIVE_DATE => c.p7
987 ,P_LANGUAGE_CODE => c.p9);
988 end if;
989 --
990 if c.p152 is null or
991 c.p153 is null or
992 c.p9 is null then
993 L_AVAILABILITY_STATUS_ID:=nn;
994 else
995 L_AVAILABILITY_STATUS_ID := 
996 hr_pump_get.get_availability_status_id
997 (P_SHARED_TYPE_NAME => c.p152
998 ,P_SYSTEM_TYPE_CD => c.p153
999 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1000 ,P_LANGUAGE_CODE => c.p9);
1001 end if;
1002 --
1003 if c.p154 is null then
1004 L_ENTRY_STEP_ID:=nn;
1005 else
1006 L_ENTRY_STEP_ID := 
1007 hr_pump_get.get_entry_step_id
1008 (P_ENTRY_STEP_USER_KEY => c.p154);
1009 end if;
1010 --
1011 if c.p155 is null then
1012 L_ENTRY_GRADE_RULE_ID:=nn;
1013 else
1014 L_ENTRY_GRADE_RULE_ID := 
1015 hr_pump_get.get_entry_grade_rule_id
1016 (P_ENTRY_GRADE_RULE_USER_KEY => c.p155);
1017 end if;
1018 --
1019 if c.p156 is null or
1020 c.p9 is null then
1021 L_LOCATION_ID:=nn;
1022 else
1023 L_LOCATION_ID := 
1024 hr_pump_get.get_location_id
1025 (P_LOCATION_CODE => c.p156
1026 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1027 ,P_LANGUAGE_CODE => c.p9);
1028 end if;
1029 --
1030 if c.p157 is null or
1031 c.p7 is null then
1032 L_PAY_FREQ_PAYROLL_ID:=nn;
1033 else
1034 L_PAY_FREQ_PAYROLL_ID := 
1035 hr_pump_get.get_pay_freq_payroll_id
1036 (P_PAY_FREQ_PAYROLL_NAME => c.p157
1037 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1038 ,P_EFFECTIVE_DATE => c.p7);
1039 end if;
1040 --
1041 if c.p158 is null or
1042 c.p7 is null then
1043 L_PRIOR_POSITION_ID:=nn;
1044 else
1048 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1045 L_PRIOR_POSITION_ID := 
1046 hr_pump_get.get_prior_position_id
1047 (P_PRIOR_POSITION_NAME => c.p158
1049 ,P_EFFECTIVE_DATE => c.p7);
1050 end if;
1051 --
1052 if c.p159 is null or
1053 c.p7 is null then
1054 L_RELIEF_POSITION_ID:=nn;
1055 else
1056 L_RELIEF_POSITION_ID := 
1057 hr_pump_get.get_relief_position_id
1058 (P_RELIEF_POSITION_NAME => c.p159
1059 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1060 ,P_EFFECTIVE_DATE => c.p7);
1061 end if;
1062 --
1063 if c.p160 is null or
1064 c.p7 is null then
1065 L_ENTRY_GRADE_ID:=nn;
1066 else
1067 L_ENTRY_GRADE_ID := 
1068 hr_pump_get.get_entry_grade_id
1069 (P_ENTRY_GRADE_NAME => c.p160
1070 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1071 ,P_EFFECTIVE_DATE => c.p7);
1072 end if;
1073 --
1074 if c.p161 is null or
1075 c.p7 is null then
1076 L_SUCCESSOR_POSITION_ID:=nn;
1077 else
1078 L_SUCCESSOR_POSITION_ID := 
1079 hr_pump_get.get_successor_position_id
1080 (P_SUCCESSOR_POSITION_NAME => c.p161
1081 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1082 ,P_EFFECTIVE_DATE => c.p7);
1083 end if;
1084 --
1085 if c.p162 is null or
1086 c.p7 is null then
1087 L_SUPERVISOR_POSITION_ID:=nn;
1088 else
1089 L_SUPERVISOR_POSITION_ID := 
1090 hr_pump_get.get_supervisor_position_id
1091 (P_SUPERVISOR_POSITION_NAME => c.p162
1092 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
1093 ,P_EFFECTIVE_DATE => c.p7);
1094 end if;
1095 --
1096 if c.p163 is null then
1097 L_PAY_BASIS_ID:=nn;
1098 else
1099 L_PAY_BASIS_ID := 
1100 hr_pump_get.get_pay_basis_id
1101 (P_PAY_BASIS_NAME => c.p163
1102 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
1103 end if;
1104 --
1105 if c.p164 is null then
1106 L_SUPERVISOR_ID:=nn;
1107 else
1108 L_SUPERVISOR_ID := 
1109 hr_pump_get.get_supervisor_id
1110 (P_SUPERVISOR_USER_KEY => c.p164);
1111 end if;
1112 --
1113 hr_data_pump.api_trc_on;
1114 HR_POSITION_API.CREATE_POSITION
1115 (P_POSITION_ID => c.p1
1116 ,P_EFFECTIVE_START_DATE => c.p2
1117 ,P_EFFECTIVE_END_DATE => c.p3
1118 ,P_POSITION_DEFINITION_ID => c.p4
1119 ,P_NAME => c.p5
1120 ,P_OBJECT_VERSION_NUMBER => c.p6
1121 ,P_JOB_ID => L_JOB_ID
1122 ,P_ORGANIZATION_ID => L_ORGANIZATION_ID
1123 ,P_EFFECTIVE_DATE => c.p7
1124 ,P_DATE_EFFECTIVE => c.p8
1125 ,P_LANGUAGE_CODE => c.p9
1126 ,p_validate => l_validate
1127 ,P_AVAILABILITY_STATUS_ID => L_AVAILABILITY_STATUS_ID
1128 ,p_business_group_id => p_business_group_id
1129 ,P_ENTRY_STEP_ID => L_ENTRY_STEP_ID
1130 ,P_ENTRY_GRADE_RULE_ID => L_ENTRY_GRADE_RULE_ID
1131 ,P_LOCATION_ID => L_LOCATION_ID
1132 ,P_PAY_FREQ_PAYROLL_ID => L_PAY_FREQ_PAYROLL_ID
1133 ,P_POSITION_TRANSACTION_ID => c.p10
1134 ,P_PRIOR_POSITION_ID => L_PRIOR_POSITION_ID
1135 ,P_RELIEF_POSITION_ID => L_RELIEF_POSITION_ID
1136 ,P_ENTRY_GRADE_ID => L_ENTRY_GRADE_ID
1137 ,P_SUCCESSOR_POSITION_ID => L_SUCCESSOR_POSITION_ID
1138 ,P_SUPERVISOR_POSITION_ID => L_SUPERVISOR_POSITION_ID
1139 ,P_AMENDMENT_DATE => c.p11
1140 ,P_AMENDMENT_RECOMMENDATION => c.p12
1141 ,P_AMENDMENT_REF_NUMBER => c.p13
1142 ,P_BARGAINING_UNIT_CD => c.p14
1143 ,P_COMMENTS => L_COMMENTS
1144 ,P_CURRENT_JOB_PROP_END_DATE => c.p16
1145 ,P_CURRENT_ORG_PROP_END_DATE => c.p17
1146 ,P_AVAIL_STATUS_PROP_END_DATE => c.p18
1147 ,P_DATE_END => c.p19
1148 ,P_EARLIEST_HIRE_DATE => c.p20
1149 ,P_FILL_BY_DATE => c.p21
1150 ,P_FREQUENCY => c.p22
1151 ,P_FTE => c.p23
1152 ,P_MAX_PERSONS => c.p24
1153 ,P_OVERLAP_PERIOD => c.p25
1154 ,P_OVERLAP_UNIT_CD => c.p26
1155 ,P_PAY_TERM_END_DAY_CD => c.p27
1156 ,P_PAY_TERM_END_MONTH_CD => c.p28
1157 ,P_PERMANENT_TEMPORARY_FLAG => c.p29
1158 ,P_PERMIT_RECRUITMENT_FLAG => c.p30
1159 ,P_POSITION_TYPE => c.p31
1160 ,P_POSTING_DESCRIPTION => c.p32
1161 ,P_PROBATION_PERIOD => c.p33
1162 ,P_PROBATION_PERIOD_UNIT_CD => c.p34
1163 ,P_REPLACEMENT_REQUIRED_FLAG => c.p35
1164 ,P_REVIEW_FLAG => c.p36
1165 ,P_SEASONAL_FLAG => c.p37
1166 ,P_SECURITY_REQUIREMENTS => c.p38
1167 ,P_STATUS => c.p39
1168 ,P_TERM_START_DAY_CD => c.p40
1169 ,P_TERM_START_MONTH_CD => c.p41
1170 ,P_TIME_NORMAL_FINISH => c.p42
1171 ,P_TIME_NORMAL_START => c.p43
1172 ,P_UPDATE_SOURCE_CD => c.p44
1173 ,P_WORKING_HOURS => c.p45
1174 ,P_WORKS_COUNCIL_APPROVAL_FLAG => c.p46
1175 ,P_WORK_PERIOD_TYPE_CD => c.p47
1176 ,P_WORK_TERM_END_DAY_CD => c.p48
1177 ,P_WORK_TERM_END_MONTH_CD => c.p49
1178 ,P_PROPOSED_FTE_FOR_LAYOFF => c.p50
1179 ,P_PROPOSED_DATE_FOR_LAYOFF => c.p51
1180 ,P_PAY_BASIS_ID => L_PAY_BASIS_ID
1181 ,P_SUPERVISOR_ID => L_SUPERVISOR_ID
1182 ,P_INFORMATION1 => c.p52
1183 ,P_INFORMATION2 => c.p53
1184 ,P_INFORMATION3 => c.p54
1185 ,P_INFORMATION4 => c.p55
1186 ,P_INFORMATION5 => c.p56
1187 ,P_INFORMATION6 => c.p57
1188 ,P_INFORMATION7 => c.p58
1189 ,P_INFORMATION8 => c.p59
1190 ,P_INFORMATION9 => c.p60
1191 ,P_INFORMATION10 => c.p61
1192 ,P_INFORMATION11 => c.p62
1193 ,P_INFORMATION12 => c.p63
1194 ,P_INFORMATION13 => c.p64
1195 ,P_INFORMATION14 => c.p65
1196 ,P_INFORMATION15 => c.p66
1197 ,P_INFORMATION16 => c.p67
1198 ,P_INFORMATION17 => c.p68
1199 ,P_INFORMATION18 => c.p69
1200 ,P_INFORMATION19 => c.p70
1201 ,P_INFORMATION20 => c.p71
1202 ,P_INFORMATION21 => c.p72
1203 ,P_INFORMATION22 => c.p73
1204 ,P_INFORMATION23 => c.p74
1205 ,P_INFORMATION24 => c.p75
1206 ,P_INFORMATION25 => c.p76
1207 ,P_INFORMATION26 => c.p77
1208 ,P_INFORMATION27 => c.p78
1209 ,P_INFORMATION28 => c.p79
1210 ,P_INFORMATION29 => c.p80
1211 ,P_INFORMATION30 => c.p81
1212 ,P_INFORMATION_CATEGORY => c.p82
1213 ,P_ATTRIBUTE1 => c.p83
1214 ,P_ATTRIBUTE2 => c.p84
1215 ,P_ATTRIBUTE3 => c.p85
1216 ,P_ATTRIBUTE4 => c.p86
1217 ,P_ATTRIBUTE5 => c.p87
1221 ,P_ATTRIBUTE9 => c.p91
1218 ,P_ATTRIBUTE6 => c.p88
1219 ,P_ATTRIBUTE7 => c.p89
1220 ,P_ATTRIBUTE8 => c.p90
1222 ,P_ATTRIBUTE10 => c.p92
1223 ,P_ATTRIBUTE11 => c.p93
1224 ,P_ATTRIBUTE12 => c.p94
1225 ,P_ATTRIBUTE13 => c.p95
1226 ,P_ATTRIBUTE14 => c.p96
1227 ,P_ATTRIBUTE15 => c.p97
1228 ,P_ATTRIBUTE16 => c.p98
1229 ,P_ATTRIBUTE17 => c.p99
1230 ,P_ATTRIBUTE18 => c.p100
1231 ,P_ATTRIBUTE19 => c.p101
1232 ,P_ATTRIBUTE20 => c.p102
1233 ,P_ATTRIBUTE21 => c.p103
1234 ,P_ATTRIBUTE22 => c.p104
1235 ,P_ATTRIBUTE23 => c.p105
1236 ,P_ATTRIBUTE24 => c.p106
1237 ,P_ATTRIBUTE25 => c.p107
1238 ,P_ATTRIBUTE26 => c.p108
1239 ,P_ATTRIBUTE27 => c.p109
1240 ,P_ATTRIBUTE28 => c.p110
1241 ,P_ATTRIBUTE29 => c.p111
1242 ,P_ATTRIBUTE30 => c.p112
1243 ,P_ATTRIBUTE_CATEGORY => c.p113
1244 ,P_SEGMENT1 => c.p114
1245 ,P_SEGMENT2 => c.p115
1246 ,P_SEGMENT3 => c.p116
1247 ,P_SEGMENT4 => c.p117
1248 ,P_SEGMENT5 => c.p118
1249 ,P_SEGMENT6 => c.p119
1250 ,P_SEGMENT7 => c.p120
1251 ,P_SEGMENT8 => c.p121
1252 ,P_SEGMENT9 => c.p122
1253 ,P_SEGMENT10 => c.p123
1254 ,P_SEGMENT11 => c.p124
1255 ,P_SEGMENT12 => c.p125
1256 ,P_SEGMENT13 => c.p126
1257 ,P_SEGMENT14 => c.p127
1258 ,P_SEGMENT15 => c.p128
1259 ,P_SEGMENT16 => c.p129
1260 ,P_SEGMENT17 => c.p130
1261 ,P_SEGMENT18 => c.p131
1262 ,P_SEGMENT19 => c.p132
1263 ,P_SEGMENT20 => c.p133
1264 ,P_SEGMENT21 => c.p134
1265 ,P_SEGMENT22 => c.p135
1266 ,P_SEGMENT23 => c.p136
1267 ,P_SEGMENT24 => c.p137
1268 ,P_SEGMENT25 => c.p138
1269 ,P_SEGMENT26 => c.p139
1270 ,P_SEGMENT27 => c.p140
1271 ,P_SEGMENT28 => c.p141
1272 ,P_SEGMENT29 => c.p142
1273 ,P_SEGMENT30 => c.p143
1274 ,P_CONCAT_SEGMENTS => c.p144
1275 ,P_REQUEST_ID => c.p145
1276 ,P_PROGRAM_APPLICATION_ID => c.p146
1277 ,P_PROGRAM_ID => c.p147
1278 ,P_PROGRAM_UPDATE_DATE => c.p148
1279 ,P_SECURITY_PROFILE_ID => c.p149);
1280 hr_data_pump.api_trc_off;
1281 
1282 --
1283 update hr_pump_batch_lines l set
1284 l.pval001 = decode(c.p1,null,cn,c.p1),
1285 l.pval002 = decode(c.p2,null,cn,dc(c.p2)),
1286 l.pval003 = decode(c.p3,null,cn,dc(c.p3)),
1287 l.pval004 = decode(c.p4,null,cn,c.p4),
1288 l.pval005 = decode(c.p5,null,cn,c.p5),
1289 l.pval006 = decode(c.p6,null,cn,c.p6)
1290 where l.rowid = c.myrowid;
1291 --
1292 close cr;
1293 --
1294 hr_data_pump.exit('call');
1295 exception
1296  when hr_multi_message.error_message_exist then
1297    if cr%isopen then
1298     close cr;
1299    end if;
1300    hr_pump_utils.set_multi_msg_error_flag(true);
1301  when others then
1302  if cr%isopen then
1303   close cr;
1304  end if;
1305  raise;
1306 end call;
1307 end hrdpp_CREATE_POSITION;