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_JOB

Source


1 package body hrdpp_CREATE_JOB as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2009/03/30 04:03:02
4  * Generated for API: HR_JOB_API.CREATE_JOB
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_DATE_FROM in date
83 ,P_COMMENTS in varchar2 default null
84 ,P_DATE_TO in date default null
85 ,P_APPROVAL_AUTHORITY in number default null
86 ,P_BENCHMARK_JOB_FLAG in varchar2 default null
87 ,P_EMP_RIGHTS_FLAG in varchar2 default null
88 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
89 ,P_ATTRIBUTE1 in varchar2 default null
90 ,P_ATTRIBUTE2 in varchar2 default null
91 ,P_ATTRIBUTE3 in varchar2 default null
92 ,P_ATTRIBUTE4 in varchar2 default null
93 ,P_ATTRIBUTE5 in varchar2 default null
94 ,P_ATTRIBUTE6 in varchar2 default null
95 ,P_ATTRIBUTE7 in varchar2 default null
96 ,P_ATTRIBUTE8 in varchar2 default null
97 ,P_ATTRIBUTE9 in varchar2 default null
98 ,P_ATTRIBUTE10 in varchar2 default null
99 ,P_ATTRIBUTE11 in varchar2 default null
100 ,P_ATTRIBUTE12 in varchar2 default null
101 ,P_ATTRIBUTE13 in varchar2 default null
102 ,P_ATTRIBUTE14 in varchar2 default null
103 ,P_ATTRIBUTE15 in varchar2 default null
104 ,P_ATTRIBUTE16 in varchar2 default null
105 ,P_ATTRIBUTE17 in varchar2 default null
106 ,P_ATTRIBUTE18 in varchar2 default null
107 ,P_ATTRIBUTE19 in varchar2 default null
108 ,P_ATTRIBUTE20 in varchar2 default null
109 ,P_JOB_INFORMATION_CATEGORY in varchar2 default null
110 ,P_JOB_INFORMATION1 in varchar2 default null
111 ,P_JOB_INFORMATION2 in varchar2 default null
112 ,P_JOB_INFORMATION3 in varchar2 default null
113 ,P_JOB_INFORMATION4 in varchar2 default null
114 ,P_JOB_INFORMATION5 in varchar2 default null
115 ,P_JOB_INFORMATION6 in varchar2 default null
116 ,P_JOB_INFORMATION7 in varchar2 default null
117 ,P_JOB_INFORMATION8 in varchar2 default null
118 ,P_JOB_INFORMATION9 in varchar2 default null
119 ,P_JOB_INFORMATION10 in varchar2 default null
120 ,P_JOB_INFORMATION11 in varchar2 default null
121 ,P_JOB_INFORMATION12 in varchar2 default null
122 ,P_JOB_INFORMATION13 in varchar2 default null
123 ,P_JOB_INFORMATION14 in varchar2 default null
124 ,P_JOB_INFORMATION15 in varchar2 default null
125 ,P_JOB_INFORMATION16 in varchar2 default null
126 ,P_JOB_INFORMATION17 in varchar2 default null
127 ,P_JOB_INFORMATION18 in varchar2 default null
128 ,P_JOB_INFORMATION19 in varchar2 default null
129 ,P_JOB_INFORMATION20 in varchar2 default null
130 ,P_SEGMENT1 in varchar2 default null
131 ,P_SEGMENT2 in varchar2 default null
132 ,P_SEGMENT3 in varchar2 default null
133 ,P_SEGMENT4 in varchar2 default null
134 ,P_SEGMENT5 in varchar2 default null
135 ,P_SEGMENT6 in varchar2 default null
136 ,P_SEGMENT7 in varchar2 default null
137 ,P_SEGMENT8 in varchar2 default null
138 ,P_SEGMENT9 in varchar2 default null
139 ,P_SEGMENT10 in varchar2 default null
140 ,P_SEGMENT11 in varchar2 default null
141 ,P_SEGMENT12 in varchar2 default null
142 ,P_SEGMENT13 in varchar2 default null
143 ,P_SEGMENT14 in varchar2 default null
144 ,P_SEGMENT15 in varchar2 default null
145 ,P_SEGMENT16 in varchar2 default null
146 ,P_SEGMENT17 in varchar2 default null
147 ,P_SEGMENT18 in varchar2 default null
148 ,P_SEGMENT19 in varchar2 default null
149 ,P_SEGMENT20 in varchar2 default null
150 ,P_SEGMENT21 in varchar2 default null
151 ,P_SEGMENT22 in varchar2 default null
152 ,P_SEGMENT23 in varchar2 default null
153 ,P_SEGMENT24 in varchar2 default null
154 ,P_SEGMENT25 in varchar2 default null
155 ,P_SEGMENT26 in varchar2 default null
156 ,P_SEGMENT27 in varchar2 default null
157 ,P_SEGMENT28 in varchar2 default null
158 ,P_SEGMENT29 in varchar2 default null
159 ,P_SEGMENT30 in varchar2 default null
160 ,P_CONCAT_SEGMENTS in varchar2 default null
161 ,P_LANGUAGE_CODE in varchar2 default null
162 ,P_JOB_DEFINITION_ID in number
163 ,P_BENCHMARK_JOB_USER_KEY in varchar2 default null
164 ,P_JOB_GROUP_USER_KEY in varchar2) is
165 blid number := p_data_pump_batch_line_id;
166 begin
167 if blid is not null then
168 delete from hr_pump_batch_lines where batch_line_id = blid;
169 delete from hr_pump_batch_exceptions
170 where source_type = 'BATCH_LINE' and source_id = blid;
171 end if;
172 insert into hr_pump_batch_lines
173 (batch_id
174 ,batch_line_id
175 ,business_group_name
176 ,api_module_id
177 ,line_status
178 ,user_sequence
179 ,link_value
180 ,pval001
181 ,pval002
182 ,pval003
183 ,pval004
184 ,pval005
185 ,pval006
186 ,pval007
187 ,pval008
188 ,pval009
189 ,pval010
190 ,pval011
191 ,pval012
192 ,pval013
193 ,pval014
194 ,pval015
195 ,pval016
196 ,pval017
197 ,pval018
198 ,pval019
199 ,pval020
200 ,pval021
201 ,pval022
202 ,pval023
203 ,pval024
204 ,pval025
205 ,pval026
206 ,pval027
207 ,pval028
208 ,pval029
209 ,pval030
210 ,pval031
211 ,pval032
212 ,pval033
213 ,pval034
214 ,pval035
215 ,pval036
216 ,pval037
217 ,pval038
218 ,pval039
219 ,pval040
220 ,pval041
221 ,pval042
222 ,pval043
223 ,pval044
224 ,pval045
225 ,pval046
226 ,pval047
227 ,pval048
228 ,pval049
229 ,pval050
230 ,pval051
231 ,pval052
232 ,pval053
233 ,pval054
234 ,pval055
235 ,pval056
236 ,pval057
237 ,pval058
238 ,pval059
239 ,pval060
240 ,pval061
241 ,pval062
242 ,pval063
243 ,pval064
244 ,pval065
245 ,pval066
246 ,pval067
247 ,pval068
248 ,pval069
249 ,pval070
250 ,pval071
251 ,pval072
252 ,pval073
253 ,pval074
254 ,pval075
255 ,pval076
256 ,pval077
257 ,pval078
258 ,pval079
259 ,pval080
260 ,pval083
261 ,pval085
262 ,pval086)
263 values
264 (p_batch_id
265 ,nvl(blid,hr_pump_batch_lines_s.nextval)
266 ,p_data_pump_business_grp_name
267 ,1336
268 ,'U'
269 ,p_user_sequence
270 ,p_link_value
271 ,dc(P_DATE_FROM)
272 ,P_COMMENTS
273 ,dc(P_DATE_TO)
274 ,P_APPROVAL_AUTHORITY
275 ,P_BENCHMARK_JOB_FLAG
276 ,P_EMP_RIGHTS_FLAG
277 ,P_ATTRIBUTE_CATEGORY
278 ,P_ATTRIBUTE1
279 ,P_ATTRIBUTE2
280 ,P_ATTRIBUTE3
281 ,P_ATTRIBUTE4
282 ,P_ATTRIBUTE5
283 ,P_ATTRIBUTE6
284 ,P_ATTRIBUTE7
285 ,P_ATTRIBUTE8
286 ,P_ATTRIBUTE9
287 ,P_ATTRIBUTE10
288 ,P_ATTRIBUTE11
289 ,P_ATTRIBUTE12
290 ,P_ATTRIBUTE13
291 ,P_ATTRIBUTE14
292 ,P_ATTRIBUTE15
293 ,P_ATTRIBUTE16
294 ,P_ATTRIBUTE17
295 ,P_ATTRIBUTE18
296 ,P_ATTRIBUTE19
297 ,P_ATTRIBUTE20
298 ,P_JOB_INFORMATION_CATEGORY
299 ,P_JOB_INFORMATION1
300 ,P_JOB_INFORMATION2
301 ,P_JOB_INFORMATION3
302 ,P_JOB_INFORMATION4
303 ,P_JOB_INFORMATION5
304 ,P_JOB_INFORMATION6
305 ,P_JOB_INFORMATION7
306 ,P_JOB_INFORMATION8
307 ,P_JOB_INFORMATION9
308 ,P_JOB_INFORMATION10
309 ,P_JOB_INFORMATION11
310 ,P_JOB_INFORMATION12
311 ,P_JOB_INFORMATION13
312 ,P_JOB_INFORMATION14
313 ,P_JOB_INFORMATION15
314 ,P_JOB_INFORMATION16
315 ,P_JOB_INFORMATION17
316 ,P_JOB_INFORMATION18
317 ,P_JOB_INFORMATION19
318 ,P_JOB_INFORMATION20
319 ,P_SEGMENT1
320 ,P_SEGMENT2
321 ,P_SEGMENT3
322 ,P_SEGMENT4
323 ,P_SEGMENT5
324 ,P_SEGMENT6
325 ,P_SEGMENT7
326 ,P_SEGMENT8
327 ,P_SEGMENT9
328 ,P_SEGMENT10
329 ,P_SEGMENT11
330 ,P_SEGMENT12
331 ,P_SEGMENT13
332 ,P_SEGMENT14
333 ,P_SEGMENT15
334 ,P_SEGMENT16
335 ,P_SEGMENT17
336 ,P_SEGMENT18
337 ,P_SEGMENT19
338 ,P_SEGMENT20
339 ,P_SEGMENT21
340 ,P_SEGMENT22
341 ,P_SEGMENT23
342 ,P_SEGMENT24
343 ,P_SEGMENT25
344 ,P_SEGMENT26
345 ,P_SEGMENT27
346 ,P_SEGMENT28
347 ,P_SEGMENT29
348 ,P_SEGMENT30
349 ,P_CONCAT_SEGMENTS
350 ,P_LANGUAGE_CODE
351 ,P_JOB_DEFINITION_ID
352 ,P_BENCHMARK_JOB_USER_KEY
353 ,P_JOB_GROUP_USER_KEY);
354 end insert_batch_lines;
355 --
356 procedure call
357 (p_business_group_id in number,
358 p_batch_line_id     in number) is
359 cursor cr is
360 select l.rowid myrowid,
361 decode(l.pval001,cn,dn,d(l.pval001)) p1,
362 decode(l.pval002,cn,vn,vn,vn,l.pval002) p2,
363 l.pval002 d2,
364 decode(l.pval003,cn,dn,vn,dn,d(l.pval003)) p3,
365 l.pval003 d3,
366 decode(l.pval004,cn,nn,vn,nn,n(l.pval004)) p4,
367 l.pval004 d4,
368 decode(l.pval005,cn,vn,vn,vn,l.pval005) p5,
369 l.pval005 d5,
370 decode(l.pval006,cn,vn,vn,vn,l.pval006) p6,
371 l.pval006 d6,
372 decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
373 l.pval007 d7,
374 decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
375 l.pval008 d8,
376 decode(l.pval009,cn,vn,vn,vn,l.pval009) p9,
377 l.pval009 d9,
378 decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,
379 l.pval010 d10,
380 decode(l.pval011,cn,vn,vn,vn,l.pval011) p11,
381 l.pval011 d11,
382 decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
383 l.pval012 d12,
384 decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,
385 l.pval013 d13,
386 decode(l.pval014,cn,vn,vn,vn,l.pval014) p14,
387 l.pval014 d14,
388 decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,
389 l.pval015 d15,
390 decode(l.pval016,cn,vn,vn,vn,l.pval016) p16,
391 l.pval016 d16,
392 decode(l.pval017,cn,vn,vn,vn,l.pval017) p17,
393 l.pval017 d17,
394 decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
395 l.pval018 d18,
396 decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
397 l.pval019 d19,
398 decode(l.pval020,cn,vn,vn,vn,l.pval020) p20,
399 l.pval020 d20,
400 decode(l.pval021,cn,vn,vn,vn,l.pval021) p21,
401 l.pval021 d21,
402 decode(l.pval022,cn,vn,vn,vn,l.pval022) p22,
403 l.pval022 d22,
404 decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
405 l.pval023 d23,
406 decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,
407 l.pval024 d24,
408 decode(l.pval025,cn,vn,vn,vn,l.pval025) p25,
409 l.pval025 d25,
410 decode(l.pval026,cn,vn,vn,vn,l.pval026) p26,
411 l.pval026 d26,
412 decode(l.pval027,cn,vn,vn,vn,l.pval027) p27,
413 l.pval027 d27,
414 decode(l.pval028,cn,vn,vn,vn,l.pval028) p28,
415 l.pval028 d28,
416 decode(l.pval029,cn,vn,vn,vn,l.pval029) p29,
417 l.pval029 d29,
418 decode(l.pval030,cn,vn,vn,vn,l.pval030) p30,
419 l.pval030 d30,
420 decode(l.pval031,cn,vn,vn,vn,l.pval031) p31,
421 l.pval031 d31,
422 decode(l.pval032,cn,vn,vn,vn,l.pval032) p32,
423 l.pval032 d32,
424 decode(l.pval033,cn,vn,vn,vn,l.pval033) p33,
425 l.pval033 d33,
426 decode(l.pval034,cn,vn,vn,vn,l.pval034) p34,
427 l.pval034 d34,
428 decode(l.pval035,cn,vn,vn,vn,l.pval035) p35,
429 l.pval035 d35,
430 decode(l.pval036,cn,vn,vn,vn,l.pval036) p36,
431 l.pval036 d36,
432 decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
433 l.pval037 d37,
434 decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
435 l.pval038 d38,
436 decode(l.pval039,cn,vn,vn,vn,l.pval039) p39,
437 l.pval039 d39,
438 decode(l.pval040,cn,vn,vn,vn,l.pval040) p40,
439 l.pval040 d40,
440 decode(l.pval041,cn,vn,vn,vn,l.pval041) p41,
441 l.pval041 d41,
442 decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
443 l.pval042 d42,
444 decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
445 l.pval043 d43,
446 decode(l.pval044,cn,vn,vn,vn,l.pval044) p44,
447 l.pval044 d44,
448 decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
449 l.pval045 d45,
450 decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
451 l.pval046 d46,
452 decode(l.pval047,cn,vn,vn,vn,l.pval047) p47,
453 l.pval047 d47,
454 decode(l.pval048,cn,vn,vn,vn,l.pval048) p48,
455 l.pval048 d48,
456 decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
457 l.pval049 d49,
458 decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
459 l.pval050 d50,
460 decode(l.pval051,cn,vn,vn,vn,l.pval051) p51,
461 l.pval051 d51,
462 decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,
463 l.pval052 d52,
464 decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
465 l.pval053 d53,
466 decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
467 l.pval054 d54,
468 decode(l.pval055,cn,vn,vn,vn,l.pval055) p55,
469 l.pval055 d55,
470 decode(l.pval056,cn,vn,vn,vn,l.pval056) p56,
471 l.pval056 d56,
472 decode(l.pval057,cn,vn,vn,vn,l.pval057) p57,
473 l.pval057 d57,
474 decode(l.pval058,cn,vn,vn,vn,l.pval058) p58,
475 l.pval058 d58,
476 decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,
477 l.pval059 d59,
478 decode(l.pval060,cn,vn,vn,vn,l.pval060) p60,
482 decode(l.pval062,cn,vn,vn,vn,l.pval062) p62,
479 l.pval060 d60,
480 decode(l.pval061,cn,vn,vn,vn,l.pval061) p61,
481 l.pval061 d61,
483 l.pval062 d62,
484 decode(l.pval063,cn,vn,vn,vn,l.pval063) p63,
485 l.pval063 d63,
486 decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
487 l.pval064 d64,
488 decode(l.pval065,cn,vn,vn,vn,l.pval065) p65,
489 l.pval065 d65,
490 decode(l.pval066,cn,vn,vn,vn,l.pval066) p66,
491 l.pval066 d66,
492 decode(l.pval067,cn,vn,vn,vn,l.pval067) p67,
493 l.pval067 d67,
494 decode(l.pval068,cn,vn,vn,vn,l.pval068) p68,
495 l.pval068 d68,
496 decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
497 l.pval069 d69,
498 decode(l.pval070,cn,vn,vn,vn,l.pval070) p70,
499 l.pval070 d70,
500 decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
501 l.pval071 d71,
502 decode(l.pval072,cn,vn,vn,vn,l.pval072) p72,
503 l.pval072 d72,
504 decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
505 l.pval073 d73,
506 decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
507 l.pval074 d74,
508 decode(l.pval075,cn,vn,vn,vn,l.pval075) p75,
509 l.pval075 d75,
510 decode(l.pval076,cn,vn,vn,vn,l.pval076) p76,
511 l.pval076 d76,
512 decode(l.pval077,cn,vn,vn,vn,l.pval077) p77,
513 l.pval077 d77,
514 decode(l.pval078,cn,vn,vn,vn,l.pval078) p78,
515 l.pval078 d78,
516 decode(l.pval079,cn,vn,vn,vn,l.pval079) p79,
517 l.pval079 d79,
518 decode(l.pval080,cn,vn,vn,vn,l.pval080) p80,
519 l.pval080 d80,
520 l.pval081 p81,
521 l.pval082 p82,
522 decode(l.pval083,cn,nn,n(l.pval083)) p83,
523 l.pval084 p84,
524 decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,
525 l.pval085 d85,
526 decode(l.pval086,cn,vn,l.pval086) p86
527 from hr_pump_batch_lines l
528 where l.batch_line_id = p_batch_line_id;
529 --
530 c cr%rowtype;
531 l_validate boolean := false;
532 L_BENCHMARK_JOB_ID number;
533 L_JOB_GROUP_ID number;
534 --
535 begin
536 hr_data_pump.entry('call');
537 open cr;
538 fetch cr into c;
539 if cr%notfound then
540 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
541 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
542 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
543 hr_utility.set_message_token('VALUE',p_batch_line_id);
544 hr_utility.raise_error;
545 end if;
546 --
547 if c.p85 is null then
548 L_BENCHMARK_JOB_ID:=nn;
549 else
550 L_BENCHMARK_JOB_ID := 
551 hr_pump_get.GET_BENCHMARK_JOB_ID
552 (P_BENCHMARK_JOB_USER_KEY => c.p85);
553 end if;
554 --
555 if c.p86 is null then
556 L_JOB_GROUP_ID:=nn;
557 else
558 L_JOB_GROUP_ID := 
559 hr_pump_get.GET_JOB_GROUP_ID
560 (P_JOB_GROUP_USER_KEY => c.p86);
561 end if;
562 --
563 hr_data_pump.api_trc_on;
564 HR_JOB_API.CREATE_JOB
565 (p_validate => l_validate
566 ,p_business_group_id => p_business_group_id
567 ,P_DATE_FROM => c.p1
568 ,P_COMMENTS => c.p2
569 ,P_DATE_TO => c.p3
570 ,P_APPROVAL_AUTHORITY => c.p4
571 ,P_BENCHMARK_JOB_FLAG => c.p5
572 ,P_BENCHMARK_JOB_ID => L_BENCHMARK_JOB_ID
573 ,P_EMP_RIGHTS_FLAG => c.p6
574 ,P_JOB_GROUP_ID => L_JOB_GROUP_ID
575 ,P_ATTRIBUTE_CATEGORY => c.p7
576 ,P_ATTRIBUTE1 => c.p8
577 ,P_ATTRIBUTE2 => c.p9
578 ,P_ATTRIBUTE3 => c.p10
579 ,P_ATTRIBUTE4 => c.p11
580 ,P_ATTRIBUTE5 => c.p12
581 ,P_ATTRIBUTE6 => c.p13
582 ,P_ATTRIBUTE7 => c.p14
583 ,P_ATTRIBUTE8 => c.p15
584 ,P_ATTRIBUTE9 => c.p16
585 ,P_ATTRIBUTE10 => c.p17
589 ,P_ATTRIBUTE14 => c.p21
586 ,P_ATTRIBUTE11 => c.p18
587 ,P_ATTRIBUTE12 => c.p19
588 ,P_ATTRIBUTE13 => c.p20
590 ,P_ATTRIBUTE15 => c.p22
591 ,P_ATTRIBUTE16 => c.p23
592 ,P_ATTRIBUTE17 => c.p24
593 ,P_ATTRIBUTE18 => c.p25
594 ,P_ATTRIBUTE19 => c.p26
595 ,P_ATTRIBUTE20 => c.p27
596 ,P_JOB_INFORMATION_CATEGORY => c.p28
597 ,P_JOB_INFORMATION1 => c.p29
598 ,P_JOB_INFORMATION2 => c.p30
599 ,P_JOB_INFORMATION3 => c.p31
600 ,P_JOB_INFORMATION4 => c.p32
601 ,P_JOB_INFORMATION5 => c.p33
602 ,P_JOB_INFORMATION6 => c.p34
603 ,P_JOB_INFORMATION7 => c.p35
604 ,P_JOB_INFORMATION8 => c.p36
605 ,P_JOB_INFORMATION9 => c.p37
606 ,P_JOB_INFORMATION10 => c.p38
607 ,P_JOB_INFORMATION11 => c.p39
608 ,P_JOB_INFORMATION12 => c.p40
609 ,P_JOB_INFORMATION13 => c.p41
610 ,P_JOB_INFORMATION14 => c.p42
611 ,P_JOB_INFORMATION15 => c.p43
612 ,P_JOB_INFORMATION16 => c.p44
613 ,P_JOB_INFORMATION17 => c.p45
614 ,P_JOB_INFORMATION18 => c.p46
615 ,P_JOB_INFORMATION19 => c.p47
616 ,P_JOB_INFORMATION20 => c.p48
617 ,P_SEGMENT1 => c.p49
618 ,P_SEGMENT2 => c.p50
619 ,P_SEGMENT3 => c.p51
620 ,P_SEGMENT4 => c.p52
621 ,P_SEGMENT5 => c.p53
622 ,P_SEGMENT6 => c.p54
623 ,P_SEGMENT7 => c.p55
624 ,P_SEGMENT8 => c.p56
625 ,P_SEGMENT9 => c.p57
626 ,P_SEGMENT10 => c.p58
627 ,P_SEGMENT11 => c.p59
628 ,P_SEGMENT12 => c.p60
629 ,P_SEGMENT13 => c.p61
630 ,P_SEGMENT14 => c.p62
631 ,P_SEGMENT15 => c.p63
632 ,P_SEGMENT16 => c.p64
633 ,P_SEGMENT17 => c.p65
634 ,P_SEGMENT18 => c.p66
635 ,P_SEGMENT19 => c.p67
636 ,P_SEGMENT20 => c.p68
637 ,P_SEGMENT21 => c.p69
638 ,P_SEGMENT22 => c.p70
639 ,P_SEGMENT23 => c.p71
640 ,P_SEGMENT24 => c.p72
641 ,P_SEGMENT25 => c.p73
642 ,P_SEGMENT26 => c.p74
643 ,P_SEGMENT27 => c.p75
644 ,P_SEGMENT28 => c.p76
645 ,P_SEGMENT29 => c.p77
646 ,P_SEGMENT30 => c.p78
647 ,P_CONCAT_SEGMENTS => c.p79
648 ,P_LANGUAGE_CODE => c.p80
649 ,P_JOB_ID => c.p81
650 ,P_OBJECT_VERSION_NUMBER => c.p82
651 ,P_JOB_DEFINITION_ID => c.p83
652 ,P_NAME => c.p84);
653 hr_data_pump.api_trc_off;
654 
655 --
656 update hr_pump_batch_lines l set
657 l.pval081 = decode(c.p81,null,cn,c.p81),
658 l.pval082 = decode(c.p82,null,cn,c.p82),
659 l.pval083 = decode(c.p83,null,cn,c.p83),
660 l.pval084 = decode(c.p84,null,cn,c.p84)
661 where l.rowid = c.myrowid;
662 --
663 close cr;
664 --
665 hr_data_pump.exit('call');
666 exception
667  when hr_multi_message.error_message_exist then
668    if cr%isopen then
669     close cr;
670    end if;
674   close cr;
671    hr_pump_utils.set_multi_msg_error_flag(true);
672  when others then
673  if cr%isopen then
675  end if;
676  raise;
677 end call;
678 end hrdpp_CREATE_JOB;