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_UPDATE_POSITION

Source


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