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_IN_LOCATION

Source


4  * Generated for API: hr_in_location_api.create_in_location
1 package body hrdpp_create_in_location as
2 /*
3  * Generated by hr_pump_meta_mapper at: 2012/11/27 04:11:57
5  */
6 --
7 dh constant date := hr_api.g_date;
8 nh constant number := hr_api.g_number;
9 vh constant varchar2(64) := hr_api.g_varchar2;
10 c_sot constant date := to_date('01010001','DDMMYYYY');
11 cn constant varchar2(32) := '<NULL>';
12 dn constant date := null;
13 nn constant number := null;
14 vn constant varchar2(1) := null;
15 --
16 function dc(p in date) return varchar2 is
17 begin
18 if p<c_sot then
19  if p<>trunc(p) then
20   return to_char(p,'SYYYY/MM/DD HH24:MI:SS');
21  end if;
22  return to_char(p,'SYYYY/MM/DD');
23 elsif p<>trunc(p) then
24  return to_char(p,'YYYY/MM/DD HH24:MI:SS');
25 end if;
26 return to_char(p,'YYYY/MM/DD');
27 end dc;
28 function d(p in varchar2) return date is
29 begin
30 if length(p)=10 then
31 return to_date(p,'YYYY/MM/DD');
32 elsif length(p)=19 then
33 return to_date(p,'YYYY/MM/DD HH24:MI:SS');
34 elsif length(p)=11 then
35 return to_date(p,'SYYYY/MM/DD');
36 elsif length(p)=20 then
37 return to_date(p,'SYYYY/MM/DD HH24:MI:SS');
38 end if;
39 -- Try default format as last resort.
40 return to_date(p,'YYYY/MM/DD');
41 end d;
42 function n(p in varchar2) return number is
43 begin
44 return to_number(p);
45 end n;
46 function dd(p in date,i in varchar2)
47 return varchar2 is
48 begin
49 if upper(i) = 'N' then return dc(p);
50 else return cn; end if;
51 end dd;
52 function nd(p in number,i in varchar2)
53 return varchar2 is
54 begin
55 if upper(i) = 'N' then return to_char(p);
56 else return cn; end if;
57 end nd;
58 --
59 procedure iuk
60 (p_batch_line_id  in number,
61 p_user_key_value in varchar2,
62 p_unique_key_id  in number)
63 is
64 begin
65 hr_data_pump.entry('ins_user_key');
66 insert into hr_pump_batch_line_user_keys
67 (user_key_id, batch_line_id,user_key_value,unique_key_id)
68 values
69 (hr_pump_batch_line_user_keys_s.nextval,
70 p_batch_line_id,
71 p_user_key_value,
72 p_unique_key_id);
73 hr_data_pump.exit('ins_user_key');
74 end iuk;
75 --
76 procedure insert_batch_lines
77 (p_batch_id      in number
78 ,p_data_pump_batch_line_id in number default null
79 ,p_data_pump_business_grp_name in varchar2 default null
80 ,p_user_sequence in number default null
81 ,p_link_value    in number default null
82 ,P_EFFECTIVE_DATE in date
83 ,P_LANGUAGE_CODE in varchar2 default null
84 ,P_LOCATION_CODE in varchar2
85 ,P_DESCRIPTION in varchar2 default null
86 ,P_TIMEZONE_CODE in varchar2 default null
87 ,P_ECE_TP_LOCATION_CODE in varchar2 default null
88 ,P_FLAT_DOOR_BLOCK in varchar2
89 ,P_BUILDING_VILLAGE in varchar2 default null
90 ,P_ROAD_STREET in varchar2 default null
91 ,P_BILL_TO_SITE_FLAG in varchar2 default null
92 ,P_IN_ORGANIZATION_FLAG in varchar2 default null
93 ,P_INACTIVE_DATE in date default null
94 ,P_OFFICE_SITE_FLAG in varchar2 default null
95 ,P_POSTAL_CODE in varchar2 default null
96 ,P_RECEIVING_SITE_FLAG in varchar2 default null
97 ,P_SHIP_TO_SITE_FLAG in varchar2 default null
98 ,P_STYLE in varchar2 default null
99 ,P_TAX_NAME in varchar2 default null
100 ,P_TELEPHONE_NUMBER in varchar2 default null
101 ,P_FAX_NUMBER in varchar2 default null
102 ,P_AREA in varchar2 default null
103 ,P_TOWN_CITY_DISTRICT in varchar2
104 ,P_STATE_UT in varchar2 default null
105 ,P_EMAIL in varchar2 default null
106 ,P_ATTRIBUTE_CATEGORY in varchar2 default null
107 ,P_ATTRIBUTE1 in varchar2 default null
108 ,P_ATTRIBUTE2 in varchar2 default null
109 ,P_ATTRIBUTE3 in varchar2 default null
110 ,P_ATTRIBUTE4 in varchar2 default null
111 ,P_ATTRIBUTE5 in varchar2 default null
112 ,P_ATTRIBUTE6 in varchar2 default null
113 ,P_ATTRIBUTE7 in varchar2 default null
114 ,P_ATTRIBUTE8 in varchar2 default null
115 ,P_ATTRIBUTE9 in varchar2 default null
116 ,P_ATTRIBUTE10 in varchar2 default null
117 ,P_ATTRIBUTE11 in varchar2 default null
118 ,P_ATTRIBUTE12 in varchar2 default null
119 ,P_ATTRIBUTE13 in varchar2 default null
120 ,P_ATTRIBUTE14 in varchar2 default null
121 ,P_ATTRIBUTE15 in varchar2 default null
122 ,P_ATTRIBUTE16 in varchar2 default null
123 ,P_ATTRIBUTE17 in varchar2 default null
124 ,P_ATTRIBUTE18 in varchar2 default null
125 ,P_ATTRIBUTE19 in varchar2 default null
126 ,P_ATTRIBUTE20 in varchar2 default null
127 ,P_GLOBAL_ATTRIBUTE_CATEGORY in varchar2 default null
128 ,P_GLOBAL_ATTRIBUTE1 in varchar2 default null
129 ,P_GLOBAL_ATTRIBUTE2 in varchar2 default null
130 ,P_GLOBAL_ATTRIBUTE3 in varchar2 default null
131 ,P_GLOBAL_ATTRIBUTE4 in varchar2 default null
132 ,P_GLOBAL_ATTRIBUTE5 in varchar2 default null
133 ,P_GLOBAL_ATTRIBUTE6 in varchar2 default null
134 ,P_GLOBAL_ATTRIBUTE7 in varchar2 default null
135 ,P_GLOBAL_ATTRIBUTE8 in varchar2 default null
136 ,P_GLOBAL_ATTRIBUTE9 in varchar2 default null
137 ,P_GLOBAL_ATTRIBUTE10 in varchar2 default null
138 ,P_GLOBAL_ATTRIBUTE11 in varchar2 default null
139 ,P_GLOBAL_ATTRIBUTE12 in varchar2 default null
140 ,P_GLOBAL_ATTRIBUTE13 in varchar2 default null
141 ,P_GLOBAL_ATTRIBUTE14 in varchar2 default null
142 ,P_GLOBAL_ATTRIBUTE15 in varchar2 default null
143 ,P_GLOBAL_ATTRIBUTE16 in varchar2 default null
144 ,P_GLOBAL_ATTRIBUTE17 in varchar2 default null
148 ,P_COUNTRY in varchar2 default null
145 ,P_GLOBAL_ATTRIBUTE18 in varchar2 default null
146 ,P_GLOBAL_ATTRIBUTE19 in varchar2 default null
147 ,P_GLOBAL_ATTRIBUTE20 in varchar2 default null
149 ,P_SHIP_TO_LOCATION_ID in number default null) is
150 blid number := p_data_pump_batch_line_id;
151 begin
152 if blid is not null then
153 delete from hr_pump_batch_lines where batch_line_id = blid;
154 delete from hr_pump_batch_exceptions
155 where source_type = 'BATCH_LINE' and source_id = blid;
156 end if;
157 insert into hr_pump_batch_lines
158 (batch_id
159 ,batch_line_id
160 ,business_group_name
161 ,api_module_id
162 ,line_status
163 ,user_sequence
164 ,link_value
165 ,pval001
166 ,pval002
167 ,pval003
168 ,pval004
169 ,pval005
170 ,pval006
171 ,pval007
172 ,pval008
173 ,pval009
174 ,pval010
175 ,pval011
176 ,pval012
177 ,pval013
178 ,pval014
179 ,pval015
180 ,pval016
181 ,pval017
182 ,pval018
183 ,pval019
184 ,pval020
185 ,pval021
186 ,pval022
187 ,pval023
188 ,pval024
189 ,pval025
190 ,pval026
191 ,pval027
192 ,pval028
193 ,pval029
194 ,pval030
195 ,pval031
196 ,pval032
197 ,pval033
198 ,pval034
199 ,pval035
200 ,pval036
201 ,pval037
202 ,pval038
203 ,pval039
204 ,pval040
205 ,pval041
206 ,pval042
207 ,pval043
208 ,pval044
209 ,pval045
210 ,pval046
211 ,pval047
212 ,pval048
213 ,pval049
214 ,pval050
215 ,pval051
216 ,pval052
217 ,pval053
218 ,pval054
219 ,pval055
220 ,pval056
221 ,pval057
222 ,pval058
223 ,pval059
224 ,pval060
225 ,pval061
226 ,pval062
227 ,pval063
228 ,pval064
229 ,pval065
230 ,pval066
231 ,pval069
232 ,pval070)
233 values
234 (p_batch_id
235 ,nvl(blid,hr_pump_batch_lines_s.nextval)
236 ,p_data_pump_business_grp_name
237 ,3225
238 ,'U'
239 ,p_user_sequence
240 ,p_link_value
241 ,dc(P_EFFECTIVE_DATE)
242 ,P_LANGUAGE_CODE
243 ,P_LOCATION_CODE
244 ,P_DESCRIPTION
245 ,P_TIMEZONE_CODE
246 ,P_ECE_TP_LOCATION_CODE
247 ,P_FLAT_DOOR_BLOCK
248 ,P_BUILDING_VILLAGE
249 ,P_ROAD_STREET
250 ,P_BILL_TO_SITE_FLAG
251 ,P_IN_ORGANIZATION_FLAG
252 ,dc(P_INACTIVE_DATE)
253 ,P_OFFICE_SITE_FLAG
254 ,P_POSTAL_CODE
255 ,P_RECEIVING_SITE_FLAG
256 ,P_SHIP_TO_SITE_FLAG
257 ,P_STYLE
258 ,P_TAX_NAME
259 ,P_TELEPHONE_NUMBER
260 ,P_FAX_NUMBER
261 ,P_AREA
262 ,P_TOWN_CITY_DISTRICT
263 ,P_STATE_UT
264 ,P_EMAIL
265 ,P_ATTRIBUTE_CATEGORY
266 ,P_ATTRIBUTE1
267 ,P_ATTRIBUTE2
268 ,P_ATTRIBUTE3
269 ,P_ATTRIBUTE4
270 ,P_ATTRIBUTE5
271 ,P_ATTRIBUTE6
272 ,P_ATTRIBUTE7
273 ,P_ATTRIBUTE8
274 ,P_ATTRIBUTE9
275 ,P_ATTRIBUTE10
276 ,P_ATTRIBUTE11
277 ,P_ATTRIBUTE12
278 ,P_ATTRIBUTE13
279 ,P_ATTRIBUTE14
280 ,P_ATTRIBUTE15
281 ,P_ATTRIBUTE16
282 ,P_ATTRIBUTE17
283 ,P_ATTRIBUTE18
284 ,P_ATTRIBUTE19
285 ,P_ATTRIBUTE20
286 ,P_GLOBAL_ATTRIBUTE_CATEGORY
287 ,P_GLOBAL_ATTRIBUTE1
288 ,P_GLOBAL_ATTRIBUTE2
289 ,P_GLOBAL_ATTRIBUTE3
290 ,P_GLOBAL_ATTRIBUTE4
291 ,P_GLOBAL_ATTRIBUTE5
292 ,P_GLOBAL_ATTRIBUTE6
293 ,P_GLOBAL_ATTRIBUTE7
294 ,P_GLOBAL_ATTRIBUTE8
295 ,P_GLOBAL_ATTRIBUTE9
296 ,P_GLOBAL_ATTRIBUTE10
297 ,P_GLOBAL_ATTRIBUTE11
298 ,P_GLOBAL_ATTRIBUTE12
299 ,P_GLOBAL_ATTRIBUTE13
300 ,P_GLOBAL_ATTRIBUTE14
301 ,P_GLOBAL_ATTRIBUTE15
302 ,P_GLOBAL_ATTRIBUTE16
303 ,P_GLOBAL_ATTRIBUTE17
304 ,P_GLOBAL_ATTRIBUTE18
305 ,P_GLOBAL_ATTRIBUTE19
306 ,P_GLOBAL_ATTRIBUTE20
307 ,P_COUNTRY
308 ,P_SHIP_TO_LOCATION_ID);
309 end insert_batch_lines;
310 --
311 procedure call
315 select l.rowid myrowid,
312 (p_business_group_id in number,
313 p_batch_line_id     in number) is
314 cursor cr is
316 decode(l.pval001,cn,dn,d(l.pval001)) p1,
317 decode(l.pval002,cn,vn,vn,vn,l.pval002) p2,
318 l.pval002 d2,
319 decode(l.pval003,cn,vn,l.pval003) p3,
320 decode(l.pval004,cn,vn,vn,vn,l.pval004) p4,
321 l.pval004 d4,
322 decode(l.pval005,cn,vn,vn,vn,l.pval005) p5,
323 l.pval005 d5,
324 decode(l.pval006,cn,vn,vn,vn,l.pval006) p6,
325 l.pval006 d6,
326 decode(l.pval007,cn,vn,l.pval007) p7,
327 decode(l.pval008,cn,vn,vn,vn,l.pval008) p8,
328 l.pval008 d8,
329 decode(l.pval009,cn,vn,vn,vn,l.pval009) p9,
330 l.pval009 d9,
331 decode(l.pval010,cn,vn,vn,vn,
332  hr_pump_get.gl(l.pval010,'YES_NO',d(l.pval001),l.pval002)) p10,
333 l.pval010 d10,
334 decode(l.pval011,cn,vn,vn,vn,
335  hr_pump_get.gl(l.pval011,'YES_NO',d(l.pval001),l.pval002)) p11,
336 l.pval011 d11,
337 decode(l.pval012,cn,dn,vn,dn,d(l.pval012)) p12,
338 l.pval012 d12,
339 decode(l.pval013,cn,vn,vn,vn,
340  hr_pump_get.gl(l.pval013,'YES_NO',d(l.pval001),l.pval002)) p13,
341 l.pval013 d13,
342 decode(l.pval014,cn,vn,vn,vn,l.pval014) p14,
343 l.pval014 d14,
344 decode(l.pval015,cn,vn,vn,vn,
345  hr_pump_get.gl(l.pval015,'YES_NO',d(l.pval001),l.pval002)) p15,
346 l.pval015 d15,
347 decode(l.pval016,cn,vn,vn,vn,
348  hr_pump_get.gl(l.pval016,'YES_NO',d(l.pval001),l.pval002)) p16,
349 l.pval016 d16,
350 decode(l.pval017,cn,vn,vn,vn,l.pval017) p17,
351 l.pval017 d17,
352 decode(l.pval018,cn,vn,vn,vn,l.pval018) p18,
353 l.pval018 d18,
354 decode(l.pval019,cn,vn,vn,vn,l.pval019) p19,
355 l.pval019 d19,
356 decode(l.pval020,cn,vn,vn,vn,l.pval020) p20,
357 l.pval020 d20,
358 decode(l.pval021,cn,vn,vn,vn,l.pval021) p21,
359 l.pval021 d21,
360 decode(l.pval022,cn,vn,l.pval022) p22,
361 decode(l.pval023,cn,vn,vn,vn,l.pval023) p23,
362 l.pval023 d23,
363 decode(l.pval024,cn,vn,vn,vn,l.pval024) p24,
364 l.pval024 d24,
365 decode(l.pval025,cn,vn,vn,vn,l.pval025) p25,
366 l.pval025 d25,
367 decode(l.pval026,cn,vn,vn,vn,l.pval026) p26,
368 l.pval026 d26,
369 decode(l.pval027,cn,vn,vn,vn,l.pval027) p27,
370 l.pval027 d27,
371 decode(l.pval028,cn,vn,vn,vn,l.pval028) p28,
372 l.pval028 d28,
373 decode(l.pval029,cn,vn,vn,vn,l.pval029) p29,
374 l.pval029 d29,
375 decode(l.pval030,cn,vn,vn,vn,l.pval030) p30,
376 l.pval030 d30,
377 decode(l.pval031,cn,vn,vn,vn,l.pval031) p31,
378 l.pval031 d31,
379 decode(l.pval032,cn,vn,vn,vn,l.pval032) p32,
380 l.pval032 d32,
381 decode(l.pval033,cn,vn,vn,vn,l.pval033) p33,
382 l.pval033 d33,
383 decode(l.pval034,cn,vn,vn,vn,l.pval034) p34,
384 l.pval034 d34,
385 decode(l.pval035,cn,vn,vn,vn,l.pval035) p35,
386 l.pval035 d35,
387 decode(l.pval036,cn,vn,vn,vn,l.pval036) p36,
388 l.pval036 d36,
389 decode(l.pval037,cn,vn,vn,vn,l.pval037) p37,
390 l.pval037 d37,
391 decode(l.pval038,cn,vn,vn,vn,l.pval038) p38,
392 l.pval038 d38,
393 decode(l.pval039,cn,vn,vn,vn,l.pval039) p39,
394 l.pval039 d39,
395 decode(l.pval040,cn,vn,vn,vn,l.pval040) p40,
396 l.pval040 d40,
397 decode(l.pval041,cn,vn,vn,vn,l.pval041) p41,
398 l.pval041 d41,
399 decode(l.pval042,cn,vn,vn,vn,l.pval042) p42,
400 l.pval042 d42,
401 decode(l.pval043,cn,vn,vn,vn,l.pval043) p43,
402 l.pval043 d43,
403 decode(l.pval044,cn,vn,vn,vn,l.pval044) p44,
404 l.pval044 d44,
405 decode(l.pval045,cn,vn,vn,vn,l.pval045) p45,
406 l.pval045 d45,
407 decode(l.pval046,cn,vn,vn,vn,l.pval046) p46,
408 l.pval046 d46,
409 decode(l.pval047,cn,vn,vn,vn,l.pval047) p47,
410 l.pval047 d47,
411 decode(l.pval048,cn,vn,vn,vn,l.pval048) p48,
412 l.pval048 d48,
413 decode(l.pval049,cn,vn,vn,vn,l.pval049) p49,
414 l.pval049 d49,
415 decode(l.pval050,cn,vn,vn,vn,l.pval050) p50,
416 l.pval050 d50,
417 decode(l.pval051,cn,vn,vn,vn,l.pval051) p51,
418 l.pval051 d51,
419 decode(l.pval052,cn,vn,vn,vn,l.pval052) p52,
420 l.pval052 d52,
421 decode(l.pval053,cn,vn,vn,vn,l.pval053) p53,
422 l.pval053 d53,
423 decode(l.pval054,cn,vn,vn,vn,l.pval054) p54,
424 l.pval054 d54,
425 decode(l.pval055,cn,vn,vn,vn,l.pval055) p55,
426 l.pval055 d55,
427 decode(l.pval056,cn,vn,vn,vn,l.pval056) p56,
428 l.pval056 d56,
429 decode(l.pval057,cn,vn,vn,vn,l.pval057) p57,
430 l.pval057 d57,
431 decode(l.pval058,cn,vn,vn,vn,l.pval058) p58,
432 l.pval058 d58,
433 decode(l.pval059,cn,vn,vn,vn,l.pval059) p59,
434 l.pval059 d59,
435 decode(l.pval060,cn,vn,vn,vn,l.pval060) p60,
436 l.pval060 d60,
437 decode(l.pval061,cn,vn,vn,vn,l.pval061) p61,
438 l.pval061 d61,
439 decode(l.pval062,cn,vn,vn,vn,l.pval062) p62,
440 l.pval062 d62,
441 decode(l.pval063,cn,vn,vn,vn,l.pval063) p63,
442 l.pval063 d63,
443 decode(l.pval064,cn,vn,vn,vn,l.pval064) p64,
444 l.pval064 d64,
445 decode(l.pval065,cn,vn,vn,vn,l.pval065) p65,
446 l.pval065 d65,
447 decode(l.pval066,cn,vn,vn,vn,l.pval066) p66,
448 l.pval066 d66,
449 l.pval067 p67,
450 l.pval068 p68,
451 decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
452 l.pval069 d69,
453 decode(l.pval070,cn,nn,vn,nn,n(l.pval070)) p70,
454 l.pval070 d70
455 from hr_pump_batch_lines l
456 where l.batch_line_id = p_batch_line_id;
457 --
458 c cr%rowtype;
459 l_validate boolean := false;
460 L_TP_HEADER_ID number;
461 L_COUNTRY varchar2(2000);
462 L_DESIGNATED_RECEIVER_ID number;
463 L_OPERATING_UNIT_ID number;
464 L_INVENTORY_ORGANIZATION_ID number;
465 L_SHIP_TO_LOCATION_ID number;
466 --
467 begin
471 if cr%notfound then
468 hr_data_pump.entry('call');
469 open cr;
470 fetch cr into c;
472 hr_utility.set_message(800,'HR_50326_DP_NO_ROW');
473 hr_utility.set_message_token('TABLE','HR_PUMP_BATCH_LINES');
474 hr_utility.set_message_token('COLUMN','P_BATCH_LINE_ID');
475 hr_utility.set_message_token('VALUE',p_batch_line_id);
476 hr_utility.raise_error;
477 end if;
478 --
479 L_TP_HEADER_ID := 
480 PER_IN_DATA_PUMP.get_tp_header_id;
481 --
482 if c.p69 is null then
483 L_COUNTRY:=vn;
484 else
485 L_COUNTRY := 
486 hr_pump_get.GET_COUNTRY
487 (P_COUNTRY => c.p69);
488 end if;
489 --
490 L_DESIGNATED_RECEIVER_ID := 
491 PER_IN_DATA_PUMP.get_designated_receiver_id;
492 --
493 L_OPERATING_UNIT_ID := 
494 PER_IN_DATA_PUMP.get_operating_unit_id;
495 --
496 L_INVENTORY_ORGANIZATION_ID := 
497 PER_IN_DATA_PUMP.get_inventory_organization_id;
498 --
499 if c.p70 is null then
500 L_SHIP_TO_LOCATION_ID:=nn;
501 else
502 L_SHIP_TO_LOCATION_ID := 
503 PER_IN_DATA_PUMP.get_ship_to_location_id
504 (P_SHIP_TO_LOCATION_ID => c.p70);
505 end if;
506 --
507 hr_data_pump.api_trc_on;
508 hr_in_location_api.create_in_location
509 (p_validate => l_validate
510 ,P_EFFECTIVE_DATE => c.p1
511 ,P_LANGUAGE_CODE => c.p2
512 ,P_LOCATION_CODE => c.p3
513 ,P_DESCRIPTION => c.p4
514 ,P_TIMEZONE_CODE => c.p5
515 ,P_TP_HEADER_ID => L_TP_HEADER_ID
516 ,P_ECE_TP_LOCATION_CODE => c.p6
517 ,P_FLAT_DOOR_BLOCK => c.p7
518 ,P_BUILDING_VILLAGE => c.p8
519 ,P_ROAD_STREET => c.p9
520 ,P_BILL_TO_SITE_FLAG => c.p10
521 ,P_COUNTRY => L_COUNTRY
522 ,P_DESIGNATED_RECEIVER_ID => L_DESIGNATED_RECEIVER_ID
523 ,P_IN_ORGANIZATION_FLAG => c.p11
524 ,P_INACTIVE_DATE => c.p12
525 ,P_OPERATING_UNIT_ID => L_OPERATING_UNIT_ID
526 ,P_INVENTORY_ORGANIZATION_ID => L_INVENTORY_ORGANIZATION_ID
527 ,P_OFFICE_SITE_FLAG => c.p13
528 ,P_POSTAL_CODE => c.p14
529 ,P_RECEIVING_SITE_FLAG => c.p15
530 ,P_SHIP_TO_LOCATION_ID => L_SHIP_TO_LOCATION_ID
531 ,P_SHIP_TO_SITE_FLAG => c.p16
532 ,P_STYLE => c.p17
533 ,P_TAX_NAME => c.p18
534 ,P_TELEPHONE_NUMBER => c.p19
535 ,P_FAX_NUMBER => c.p20
536 ,P_AREA => c.p21
537 ,P_TOWN_CITY_DISTRICT => c.p22
538 ,P_STATE_UT => c.p23
539 ,P_EMAIL => c.p24
540 ,P_ATTRIBUTE_CATEGORY => c.p25
541 ,P_ATTRIBUTE1 => c.p26
542 ,P_ATTRIBUTE2 => c.p27
543 ,P_ATTRIBUTE3 => c.p28
544 ,P_ATTRIBUTE4 => c.p29
545 ,P_ATTRIBUTE5 => c.p30
546 ,P_ATTRIBUTE6 => c.p31
547 ,P_ATTRIBUTE7 => c.p32
548 ,P_ATTRIBUTE8 => c.p33
549 ,P_ATTRIBUTE9 => c.p34
550 ,P_ATTRIBUTE10 => c.p35
551 ,P_ATTRIBUTE11 => c.p36
552 ,P_ATTRIBUTE12 => c.p37
553 ,P_ATTRIBUTE13 => c.p38
554 ,P_ATTRIBUTE14 => c.p39
555 ,P_ATTRIBUTE15 => c.p40
556 ,P_ATTRIBUTE16 => c.p41
557 ,P_ATTRIBUTE17 => c.p42
558 ,P_ATTRIBUTE18 => c.p43
559 ,P_ATTRIBUTE19 => c.p44
560 ,P_ATTRIBUTE20 => c.p45
561 ,P_GLOBAL_ATTRIBUTE_CATEGORY => c.p46
562 ,P_GLOBAL_ATTRIBUTE1 => c.p47
563 ,P_GLOBAL_ATTRIBUTE2 => c.p48
564 ,P_GLOBAL_ATTRIBUTE3 => c.p49
565 ,P_GLOBAL_ATTRIBUTE4 => c.p50
566 ,P_GLOBAL_ATTRIBUTE5 => c.p51
567 ,P_GLOBAL_ATTRIBUTE6 => c.p52
568 ,P_GLOBAL_ATTRIBUTE7 => c.p53
569 ,P_GLOBAL_ATTRIBUTE8 => c.p54
570 ,P_GLOBAL_ATTRIBUTE9 => c.p55
571 ,P_GLOBAL_ATTRIBUTE10 => c.p56
572 ,P_GLOBAL_ATTRIBUTE11 => c.p57
573 ,P_GLOBAL_ATTRIBUTE12 => c.p58
574 ,P_GLOBAL_ATTRIBUTE13 => c.p59
575 ,P_GLOBAL_ATTRIBUTE14 => c.p60
576 ,P_GLOBAL_ATTRIBUTE15 => c.p61
577 ,P_GLOBAL_ATTRIBUTE16 => c.p62
578 ,P_GLOBAL_ATTRIBUTE17 => c.p63
579 ,P_GLOBAL_ATTRIBUTE18 => c.p64
580 ,P_GLOBAL_ATTRIBUTE19 => c.p65
581 ,P_GLOBAL_ATTRIBUTE20 => c.p66
582 ,p_business_group_id => p_business_group_id
583 ,P_LOCATION_ID => c.p67
584 ,P_OBJECT_VERSION_NUMBER => c.p68);
585 hr_data_pump.api_trc_off;
586 
587 --
588 update hr_pump_batch_lines l set
589 l.pval067 = decode(c.p67,null,cn,c.p67),
590 l.pval068 = decode(c.p68,null,cn,c.p68)
591 where l.rowid = c.myrowid;
592 --
593 close cr;
594 --
595 hr_data_pump.exit('call');
596 exception
597  when hr_multi_message.error_message_exist then
598    if cr%isopen then
599     close cr;
600    end if;
601    hr_pump_utils.set_multi_msg_error_flag(true);
602  when others then
603  if cr%isopen then
604   close cr;
605  end if;
606  raise;
607 end call;
608 end hrdpp_create_in_location;