APPS.HR_H2PI_UPLOAD dependencies on DBMS_LOB

Line 21: if dbms_lob.getlength(p_locator) > length('') + length('

17: l_proc varchar2(73) := g_package || 'insert_xml_into_table';
18:
19: BEGIN
20: hr_utility.set_location('Entering:'|| l_proc, 10);
21: if dbms_lob.getlength(p_locator) > length('') + length(' 22: l_saveCtx := DBMS_XMLSave.newContext(p_table_name);
23: DBMS_XMLSave.setDateFormat(l_saveCtx,null);
24: l_rows := DBMS_XMLSave.insertXML(l_saveCtx,p_locator);
25: DBMS_XMLSave.closeContext(l_saveCtx);

Line 152: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

148: --
149: -- FOR HR_H2PI_EMPLOYEES table.
150: --
151: l_dest_clob_loc := get_clob_locator('HR_H2PI_EMPLOYEES');
152: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
153: --
154: hr_utility.set_location(l_proc, 20);
155: <>
156: loop

Line 160: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

156: loop
157: utl_file.get_line(l_fp,l_line);
158: l_text := l_line;
159: if l_text is not null then
160: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
161: end if;
162: if (l_text = '')
163: OR (l_text = '') then
164: exit ;

Line 169: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

165: end if;
166: end loop hr_h2pi_employees;
167: --
168: insert_xml_into_table('HR_H2PI_EMPLOYEES',l_dest_clob_loc);
169: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
170: --
171:
172: --
173: -- FOR HR_H2PI_ADDRESSES table.

Line 176: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

172: --
173: -- FOR HR_H2PI_ADDRESSES table.
174: --
175: l_dest_clob_loc := get_clob_locator('HR_H2PI_ADDRESSES');
176: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
177: --
178: hr_utility.set_location('Entering:'|| l_proc, 30);
179: <>
180: loop

Line 184: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

180: loop
181: utl_file.get_line(l_fp,l_line);
182: l_text := l_line;
183: if l_text is not null then
184: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
185: end if;
186: if (l_text = '')
187: OR (l_text = '') then
188: exit ;

Line 193: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

189: end if;
190: end loop hr_h2pi_addresses;
191: --
192: insert_xml_into_table('HR_H2PI_ADDRESSES',l_dest_clob_loc);
193: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
194: --
195:
196: --
197: -- FOR HR_H2PI_LOCATIONS table.

Line 200: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

196: --
197: -- FOR HR_H2PI_LOCATIONS table.
198: --
199: l_dest_clob_loc := get_clob_locator('HR_H2PI_LOCATIONS');
200: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
201: --
202: hr_utility.set_location('Entering:'|| l_proc, 40);
203: <>
204: loop

Line 208: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

204: loop
205: utl_file.get_line(l_fp,l_line);
206: l_text := l_line;
207: if l_text is not null then
208: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
209: end if;
210: if (l_text = '')
211: OR (l_text = '') then
212: exit ;

Line 217: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

213: end if;
214: end loop hr_h2pi_addresses;
215: --
216: insert_xml_into_table('HR_H2PI_LOCATIONS',l_dest_clob_loc);
217: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
218: --
219:
220: --
221: -- FOR HR_H2PI_ASSIGNMENTS table.

Line 224: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

220: --
221: -- FOR HR_H2PI_ASSIGNMENTS table.
222: --
223: l_dest_clob_loc := get_clob_locator('HR_H2PI_ASSIGNMENTS');
224: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
225: --
226: hr_utility.set_location('Entering:'|| l_proc, 50);
227: <>
228: loop

Line 232: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

228: loop
229: utl_file.get_line(l_fp,l_line);
230: l_text := l_line;
231: if l_text is not null then
232: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
233: end if;
234: if (l_text = '')
235: OR (l_text = '') then
236: exit ;

Line 241: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

237: end if;
238: end loop hr_h2pi_addresses;
239: --
240: insert_xml_into_table('HR_H2PI_ASSIGNMENTS',l_dest_clob_loc);
241: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
242:
243: --
244: -- FOR HR_H2PI_PAY_BASES table.
245: --

Line 247: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

243: --
244: -- FOR HR_H2PI_PAY_BASES table.
245: --
246: l_dest_clob_loc := get_clob_locator('HR_H2PI_PAY_BASES');
247: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
248: --
249: hr_utility.set_location('Entering:'|| l_proc, 60);
250: <>
251: loop

Line 255: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

251: loop
252: utl_file.get_line(l_fp,l_line);
253: l_text := l_line;
254: if l_text is not null then
255: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
256: end if;
257: if (l_text = '')
258: OR (l_text = '') then
259: exit ;

Line 264: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

260: end if;
261: end loop hr_h2pi_pay_bases;
262: --
263: insert_xml_into_table('HR_H2PI_PAY_BASES',l_dest_clob_loc);
264: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
265:
266: --
267: -- FOR HR_H2PI_HR_ORGANIZATIONS table.
268: --

Line 270: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

266: --
267: -- FOR HR_H2PI_HR_ORGANIZATIONS table.
268: --
269: l_dest_clob_loc := get_clob_locator('HR_H2PI_HR_ORGANIZATIONS');
270: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
271: --
272: hr_utility.set_location('Entering:'|| l_proc, 70);
273: <>
274: loop

Line 278: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

274: loop
275: utl_file.get_line(l_fp,l_line);
276: l_text := l_line;
277: if l_text is not null then
278: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
279: end if;
280: if l_text = '' then exit ; end if;
281: if (l_text = '')
282: OR (l_text = '') then

Line 288: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

284: end if;
285: end loop hr_h2pi_hr_organizations;
286: --
287: insert_xml_into_table('HR_H2PI_HR_ORGANIZATIONS',l_dest_clob_loc);
288: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
289:
290:
291: --
292: -- FOR HR_H2PI_PAYROLLS table.

Line 295: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

291: --
292: -- FOR HR_H2PI_PAYROLLS table.
293: --
294: l_dest_clob_loc := get_clob_locator('HR_H2PI_PAYROLLS');
295: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
296: --
297: hr_utility.set_location('Entering:'|| l_proc, 80);
298: <>
299: loop

Line 303: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

299: loop
300: utl_file.get_line(l_fp,l_line);
301: l_text := l_line;
302: if l_text is not null then
303: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
304: end if;
305: if (l_text = '')
306: OR (l_text = '') then
307: exit ;

Line 312: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

308: end if;
309: end loop hr_h2pi_payrolls;
310: --
311: insert_xml_into_table('HR_H2PI_PAYROLLS',l_dest_clob_loc);
312: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
313:
314:
315: --
316: -- FOR HR_H2PI_ELEMENT_TYPES table.

Line 319: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

315: --
316: -- FOR HR_H2PI_ELEMENT_TYPES table.
317: --
318: l_dest_clob_loc := get_clob_locator('HR_H2PI_ELEMENT_TYPES');
319: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
320: --
321: hr_utility.set_location('Entering:'|| l_proc, 90);
322: <>
323: loop

Line 327: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

323: loop
324: utl_file.get_line(l_fp,l_line);
325: l_text := l_line;
326: if l_text is not null then
327: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
328: end if;
329: if (l_text = '')
330: OR (l_text = '') then
331: exit ;

Line 336: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

332: end if;
333: end loop hr_h2pi_element_types;
334: --
335: insert_xml_into_table('HR_H2PI_ELEMENT_TYPES',l_dest_clob_loc);
336: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
337: --
338:
339: --
340: -- FOR HR_H2PI_INPUT_VALUES table.

Line 343: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

339: --
340: -- FOR HR_H2PI_INPUT_VALUES table.
341: --
342: l_dest_clob_loc := get_clob_locator('HR_H2PI_INPUT_VALUES');
343: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
344: --
345: hr_utility.set_location('Entering:'|| l_proc, 100);
346: <>
347: loop

Line 351: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

347: loop
348: utl_file.get_line(l_fp,l_line);
349: l_text := l_line;
350: if l_text is not null then
351: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
352: end if;
353: if (l_text = '')
354: OR (l_text = '') then
355: exit ;

Line 360: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

356: end if;
357: end loop hr_h2pi_input_values;
358: --
359: insert_xml_into_table('HR_H2PI_INPUT_VALUES',l_dest_clob_loc);
360: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
361: --
362:
363: --
364: -- FOR HR_H2PI_ELEMENT_LINKS table.

Line 367: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

363: --
364: -- FOR HR_H2PI_ELEMENT_LINKS table.
365: --
366: l_dest_clob_loc := get_clob_locator('HR_H2PI_ELEMENT_LINKS');
367: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
368: hr_utility.set_location('Entering:'|| l_proc,110);
369: --
370: <>
371: loop

Line 375: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

371: loop
372: utl_file.get_line(l_fp,l_line);
373: l_text := l_line;
374: if l_text is not null then
375: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
376: end if;
377: if (l_text = '')
378: OR (l_text = '') then
379: exit ;

Line 384: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

380: end if;
381: end loop hr_h2pi_element_links;
382: --
383: insert_xml_into_table('HR_H2PI_ELEMENT_LINKS',l_dest_clob_loc);
384: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
385: --
386:
387: --
388: -- FOR HR_H2PI_BG_AND_GRE table.

Line 391: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

387: --
388: -- FOR HR_H2PI_BG_AND_GRE table.
389: --
390: l_dest_clob_loc := get_clob_locator('HR_H2PI_BG_AND_GRE');
391: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
392: --
393: hr_utility.set_location('Entering:'|| l_proc, 120);
394: <>
395: loop

Line 399: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

395: loop
396: utl_file.get_line(l_fp,l_line);
397: l_text := l_line;
398: if l_text is not null then
399: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
400: end if;
401: if (l_text = '')
402: OR (l_text = '') then
403: exit ;

Line 408: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

404: end if;
405: end loop hr_h2pi_bg_and_gre;
406: --
407: insert_xml_into_table('HR_H2PI_BG_AND_GRE',l_dest_clob_loc);
408: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
409: --
410:
411: --
412: --

Line 416: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

412: --
413: -- FOR HR_H2PI_ORG_PAYMENT_METHODS table.
414: --
415: l_dest_clob_loc := get_clob_locator('HR_H2PI_ORG_PAYMENT_METHODS');
416: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
417: --
418: hr_utility.set_location('Entering:'|| l_proc, 130);
419: <>
420: loop

Line 424: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

420: loop
421: utl_file.get_line(l_fp,l_line);
422: l_text := l_line;
423: if l_text is not null then
424: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
425: end if;
426: if (l_text = '')
427: OR (l_text = '') then
428: exit ;

Line 433: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

429: end if;
430: end loop hr_h2pi_org_payment_methods;
431: --
432: insert_xml_into_table('HR_H2PI_ORG_PAYMENT_METHODS',l_dest_clob_loc);
433: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
434: --
435:
436: --
437: -- FOR HR_H2PI_PATCH_STATUS table.

Line 440: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

436: --
437: -- FOR HR_H2PI_PATCH_STATUS table.
438: --
439: l_dest_clob_loc := get_clob_locator('HR_H2PI_PATCH_STATUS');
440: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
441: --
442: hr_utility.set_location('Entering:'|| l_proc, 140);
443: <>
444: loop

Line 448: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

444: loop
445: utl_file.get_line(l_fp,l_line);
446: l_text := l_line;
447: if l_text is not null then
448: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
449: end if;
450: if (l_text = '')
451: OR (l_text = '') then
452: exit ;

Line 457: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

453: end if;
454: end loop hr_h2pi_patch_status;
455: --
456: insert_xml_into_table('HR_H2PI_PATCH_STATUS',l_dest_clob_loc);
457: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
458: --
459:
460: --
461: -- FOR HR_H2PI_FEDERAL_TAX_RULES table.

Line 464: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

460: --
461: -- FOR HR_H2PI_FEDERAL_TAX_RULES table.
462: --
463: l_dest_clob_loc := get_clob_locator('HR_H2PI_FEDERAL_TAX_RULES');
464: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
465: --
466: hr_utility.set_location('Entering:'|| l_proc, 150);
467: <>
468: loop

Line 472: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

468: loop
469: utl_file.get_line(l_fp,l_line);
470: l_text := l_line;
471: if l_text is not null then
472: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
473: end if;
474: if (l_text = '')
475: OR (l_text = '') then
476: exit ;

Line 481: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

477: end if;
478: end loop hr_h2pi_federal_tax_rules;
479: --
480: insert_xml_into_table('HR_H2PI_FEDERAL_TAX_RULES',l_dest_clob_loc);
481: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
482: --
483:
484: --
485: -- FOR HR_H2PI_STATE_TAX_RULES table.

Line 488: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

484: --
485: -- FOR HR_H2PI_STATE_TAX_RULES table.
486: --
487: l_dest_clob_loc := get_clob_locator('HR_H2PI_STATE_TAX_RULES');
488: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
489: --
490: hr_utility.set_location('Entering:'|| l_proc, 160);
491: <>
492: loop

Line 496: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

492: loop
493: utl_file.get_line(l_fp,l_line);
494: l_text := l_line;
495: if l_text is not null then
496: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
497: end if;
498: if (l_text = '')
499: OR (l_text = '') then
500: exit ;

Line 505: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

501: end if;
502: end loop hr_h2pi_state_tax_rules;
503: --
504: insert_xml_into_table('HR_H2PI_STATE_TAX_RULES',l_dest_clob_loc);
505: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
506: --
507:
508: --
509: -- FOR HR_H2PI_COUNTY_TAX_RULES table.

Line 512: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

508: --
509: -- FOR HR_H2PI_COUNTY_TAX_RULES table.
510: --
511: l_dest_clob_loc := get_clob_locator('HR_H2PI_COUNTY_TAX_RULES');
512: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
513: --
514: hr_utility.set_location('Entering:'|| l_proc, 170);
515: <>
516: loop

Line 520: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

516: loop
517: utl_file.get_line(l_fp,l_line);
518: l_text := l_line;
519: if l_text is not null then
520: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
521: end if;
522: if (l_text = '')
523: OR (l_text = '') then
524: exit ;

Line 529: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

525: end if;
526: end loop hr_h2pi_county_tax_rules;
527: --
528: insert_xml_into_table('HR_H2PI_COUNTY_TAX_RULES',l_dest_clob_loc);
529: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
530: --
531:
532: --
533: -- FOR HR_H2PI_CITY_TAX_RULES table.

Line 536: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

532: --
533: -- FOR HR_H2PI_CITY_TAX_RULES table.
534: --
535: l_dest_clob_loc := get_clob_locator('HR_H2PI_CITY_TAX_RULES');
536: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
537: --
538: hr_utility.set_location('Entering:'|| l_proc, 180);
539: <>
540: loop

Line 544: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

540: loop
541: utl_file.get_line(l_fp,l_line);
542: l_text := l_line;
543: if l_text is not null then
544: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
545: end if;
546: if (l_text = '')
547: OR (l_text = '') then
548: exit ;

Line 553: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

549: end if;
550: end loop hr_h2pi_city_tax_rules;
551: --
552: insert_xml_into_table('HR_H2PI_CITY_TAX_RULES',l_dest_clob_loc);
553: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
554: --
555:
556: --
557: -- FOR HR_H2PI_ORGANIZATION_CLASS table.

Line 560: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

556: --
557: -- FOR HR_H2PI_ORGANIZATION_CLASS table.
558: --
559: l_dest_clob_loc := get_clob_locator('HR_H2PI_ORGANIZATION_CLASS');
560: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
561: --
562: hr_utility.set_location('Entering:'|| l_proc, 190);
563: <>
564: loop

Line 568: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

564: loop
565: utl_file.get_line(l_fp,l_line);
566: l_text := l_line;
567: if l_text is not null then
568: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
569: end if;
570: if (l_text = '')
571: OR (l_text = '') then
572: exit ;

Line 577: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

573: end if;
574: end loop hr_h2pi_organization_class;
575: --
576: insert_xml_into_table('HR_H2PI_ORGANIZATION_CLASS',l_dest_clob_loc);
577: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
578: --
579:
580: --
581: -- FOR HR_H2PI_PERIODS_OF_SERVICE table.

Line 584: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

580: --
581: -- FOR HR_H2PI_PERIODS_OF_SERVICE table.
582: --
583: l_dest_clob_loc := get_clob_locator('HR_H2PI_PERIODS_OF_SERVICE');
584: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
585: --
586: hr_utility.set_location('Entering:'|| l_proc, 200);
587: <>
588: loop

Line 592: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

588: loop
589: utl_file.get_line(l_fp,l_line);
590: l_text := l_line;
591: if l_text is not null then
592: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
593: end if;
594: if (l_text = '')
595: OR (l_text = '') then
596: exit ;

Line 601: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

597: end if;
598: end loop hr_h2pi_periods_of_service;
599: --
600: insert_xml_into_table('HR_H2PI_PERIODS_OF_SERVICE',l_dest_clob_loc);
601: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
602: --
603: --
604: -- FOR HR_H2PI_SALARIES table.
605: --

Line 607: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

603: --
604: -- FOR HR_H2PI_SALARIES table.
605: --
606: l_dest_clob_loc := get_clob_locator('HR_H2PI_SALARIES');
607: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
608: --
609: hr_utility.set_location('Entering:'|| l_proc, 210);
610: <>
611: loop

Line 615: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

611: loop
612: utl_file.get_line(l_fp,l_line);
613: l_text := l_line;
614: if l_text is not null then
615: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
616: end if;
617: if (l_text = '')
618: OR (l_text = '') then
619: exit ;

Line 624: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

620: end if;
621: end loop hr_h2pi_salaries;
622: --
623: insert_xml_into_table('HR_H2PI_SALARIES',l_dest_clob_loc);
624: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
625: --
626:
627: --
628: -- FOR HR_H2PI_ORGANIZATION_INFO table.

Line 631: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

627: --
628: -- FOR HR_H2PI_ORGANIZATION_INFO table.
629: --
630: l_dest_clob_loc := get_clob_locator('HR_H2PI_ORGANIZATION_INFO');
631: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
632: --
633: hr_utility.set_location('Entering:'|| l_proc, 220);
634: <>
635: loop

Line 639: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

635: loop
636: utl_file.get_line(l_fp,l_line);
637: l_text := l_line;
638: if l_text is not null then
639: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
640: end if;
641: if (l_text = '')
642: OR (l_text = '') then
643: exit ;

Line 648: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

644: end if;
645: end loop hr_h2pi_organization_info;
646: --
647: insert_xml_into_table('HR_H2PI_ORGANIZATION_INFO',l_dest_clob_loc);
648: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
649: --
650:
651: --
652: -- FOR HR_H2PI_COST_ALLOCATIONS table.

Line 655: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

651: --
652: -- FOR HR_H2PI_COST_ALLOCATIONS table.
653: --
654: l_dest_clob_loc := get_clob_locator('HR_H2PI_COST_ALLOCATIONS');
655: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
656: --
657: hr_utility.set_location('Entering:'|| l_proc, 230);
658: <>
659: loop

Line 663: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

659: loop
660: utl_file.get_line(l_fp,l_line);
661: l_text := l_line;
662: if l_text is not null then
663: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
664: end if;
665: if (l_text = '')
666: OR (l_text = '') then
667: exit ;

Line 672: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

668: end if;
669: end loop hr_h2pi_cost_allocations;
670: --
671: insert_xml_into_table('HR_H2PI_COST_ALLOCATIONS',l_dest_clob_loc);
672: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
673: --
674:
675: --
676: -- FOR HR_H2PI_PAYMENT_METHODS table.

Line 679: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

675: --
676: -- FOR HR_H2PI_PAYMENT_METHODS table.
677: --
678: l_dest_clob_loc := get_clob_locator('HR_H2PI_PAYMENT_METHODS');
679: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
680: --
681: hr_utility.set_location('Entering:'|| l_proc, 240);
682: <>
683: loop

Line 687: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

683: loop
684: utl_file.get_line(l_fp,l_line);
685: l_text := l_line;
686: if l_text is not null then
687: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
688: end if;
689: if (l_text = '')
690: OR (l_text = '') then
691: exit ;

Line 696: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

692: end if;
693: end loop hr_h2pi_payment_methods;
694: --
695: insert_xml_into_table('HR_H2PI_PAYMENT_METHODS',l_dest_clob_loc);
696: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
697: --
698:
699: --
700: -- FOR HR_H2PI_ELEMENT_NAMES table.

Line 703: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

699: --
700: -- FOR HR_H2PI_ELEMENT_NAMES table.
701: --
702: l_dest_clob_loc := get_clob_locator('HR_H2PI_ELEMENT_NAMES');
703: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
704: --
705: hr_utility.set_location('Entering:'|| l_proc, 250);
706: <>
707: loop

Line 711: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

707: loop
708: utl_file.get_line(l_fp,l_line);
709: l_text := l_line;
710: if l_text is not null then
711: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
712: end if;
713: if (l_text = '')
714: OR (l_text = '') then
715: exit ;

Line 720: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

716: end if;
717: end loop hr_h2pi_element_names;
718: --
719: insert_xml_into_table('HR_H2PI_ELEMENT_NAMES',l_dest_clob_loc);
720: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
721: --
722:
723: --
724: -- FOR HR_H2PI_ELEMENT_ENTRIES table.

Line 727: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

723: --
724: -- FOR HR_H2PI_ELEMENT_ENTRIES table.
725: --
726: l_dest_clob_loc := get_clob_locator('HR_H2PI_ELEMENT_ENTRIES');
727: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
728: --
729: hr_utility.set_location('Entering:'|| l_proc, 260);
730: <>
731: loop

Line 735: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

731: loop
732: utl_file.get_line(l_fp,l_line);
733: l_text := l_line;
734: if l_text is not null then
735: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
736: end if;
737: if l_text = '' then exit ; end if;
738: if (l_text = '')
739: OR (l_text = '') then

Line 745: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

741: end if;
742: end loop hr_h2pi_element_entries;
743: --
744: insert_xml_into_table('HR_H2PI_ELEMENT_ENTRIES',l_dest_clob_loc);
745: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
746: --
747:
748: --
749: -- FOR HR_H2PI_ELEMENT_ENTRY_VALUES table.

Line 752: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

748: --
749: -- FOR HR_H2PI_ELEMENT_ENTRY_VALUES table.
750: --
751: l_dest_clob_loc := get_clob_locator('HR_H2PI_ELEMENT_ENTRY_VALUES');
752: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
753: --
754: <>
755: hr_utility.set_location('Entering:'|| l_proc, 270);
756: loop

Line 760: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

756: loop
757: utl_file.get_line(l_fp,l_line);
758: l_text := l_line;
759: if l_text is not null then
760: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
761: end if;
762: if l_text = '' then exit ; end if;
763: if (l_text = '')
764: OR (l_text = '') then

Line 770: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

766: end if;
767: end loop hr_h2pi_element_entry_values;
768: --
769: insert_xml_into_table('HR_H2PI_ELEMENT_ENTRY_VALUES',l_dest_clob_loc);
770: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
771: --
772:
773:
774: --

Line 778: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

774: --
775: -- FOR HR_H2PI_US_MODIFIED_GEOCODES table.
776: --
777: l_dest_clob_loc := get_clob_locator('HR_H2PI_US_MODIFIED_GEOCODES');
778: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
779: --
780: <>
781: hr_utility.set_location('Entering:'|| l_proc, 280);
782: loop

Line 786: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

782: loop
783: utl_file.get_line(l_fp,l_line);
784: l_text := l_line;
785: if l_text is not null then
786: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
787: end if;
788: if l_text = '' then exit ; end if;
789: if (l_text = '')
790: OR (l_text = '') then

Line 796: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

792: end if;
793: end loop HR_H2PI_US_MODIFIED_GEOCODES;
794: --
795: insert_xml_into_table('HR_H2PI_US_MODIFIED_GEOCODES',l_dest_clob_loc);
796: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
797: --
798:
799: --
800: -- FOR HR_H2PI_US_CITY_NAMES table.

Line 803: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);

799: --
800: -- FOR HR_H2PI_US_CITY_NAMES table.
801: --
802: l_dest_clob_loc := get_clob_locator('HR_H2PI_US_CITY_NAMES');
803: dbms_lob.createtemporary(l_dest_clob_loc,TRUE);
804: --
805: <>
806: hr_utility.set_location('Entering:'|| l_proc, 290);
807: loop

Line 811: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);

807: loop
808: utl_file.get_line(l_fp,l_line);
809: l_text := l_line;
810: if l_text is not null then
811: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
812: end if;
813: if l_text = '' then exit ; end if;
814: if (l_text = '')
815: OR (l_text = '') then

Line 821: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);

817: end if;
818: end loop HR_H2PI_US_CITY_NAMES;
819: --
820: insert_xml_into_table('HR_H2PI_US_CITY_NAMES',l_dest_clob_loc);
821: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
822: --
823: utl_file.fclose(l_fp);
824:
825: --commit;