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.

APPS.PAY_KW_CHEQUE_REPORT dependencies on DBMS_LOB

Line 324: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);

320:
321: vXMLTable.DELETE;
322: vCtr := 1;
323:
324: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
325: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
326: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
327: clob_to_blob(l_xfdf_string,l_xfdf_blob);
328: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 325: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

321: vXMLTable.DELETE;
322: vCtr := 1;
323:
324: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
325: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
326: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
327: clob_to_blob(l_xfdf_string,l_xfdf_blob);
328: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
329:

Line 326: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);

322: vCtr := 1;
323:
324: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
325: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
326: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
327: clob_to_blob(l_xfdf_string,l_xfdf_blob);
328: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
329:
330:

Line 328: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

324: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
325: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
326: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
327: clob_to_blob(l_xfdf_string,l_xfdf_blob);
328: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
329:
330:
331: l_str_rep_label := '' || get_lookup_meaning('KW_FORM_LABELS','KW_CHQR') || '';
332: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_label),l_str_rep_label);

Line 332: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_label),l_str_rep_label);

328: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
329:
330:
331: l_str_rep_label := '' || get_lookup_meaning('KW_FORM_LABELS','KW_CHQR') || '';
332: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_label),l_str_rep_label);
333:
334: l_str_py_label := '' || get_lookup_meaning('KW_FORM_LABELS','PY_LABEL') || '';
335: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_label),l_str_py_label);
336:

Line 335: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_label),l_str_py_label);

331: l_str_rep_label := '' || get_lookup_meaning('KW_FORM_LABELS','KW_CHQR') || '';
332: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_label),l_str_rep_label);
333:
334: l_str_py_label := '' || get_lookup_meaning('KW_FORM_LABELS','PY_LABEL') || '';
335: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_label),l_str_py_label);
336:
337: l_str_py_name := '' || l_py_name || '';
338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_name),l_str_py_name);
339:

Line 338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_name),l_str_py_name);

334: l_str_py_label := '' || get_lookup_meaning('KW_FORM_LABELS','PY_LABEL') || '';
335: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_label),l_str_py_label);
336:
337: l_str_py_name := '' || l_py_name || '';
338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_name),l_str_py_name);
339:
340: l_str_n := '' || get_lookup_meaning('KW_FORM_LABELS','S_NO') || '';
341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_n),l_str_n);
342:

Line 341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_n),l_str_n);

337: l_str_py_name := '' || l_py_name || '';
338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_name),l_str_py_name);
339:
340: l_str_n := '' || get_lookup_meaning('KW_FORM_LABELS','S_NO') || '';
341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_n),l_str_n);
342:
343: l_str_name_l := '' || get_lookup_meaning('KW_FORM_LABELS','NAME') || '';
344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_name_l),l_str_name_l);
345:

Line 344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_name_l),l_str_name_l);

340: l_str_n := '' || get_lookup_meaning('KW_FORM_LABELS','S_NO') || '';
341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_n),l_str_n);
342:
343: l_str_name_l := '' || get_lookup_meaning('KW_FORM_LABELS','NAME') || '';
344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_name_l),l_str_name_l);
345:
346: l_str_eno_l := '' || get_lookup_meaning('KW_FORM_LABELS','EMP_NO') || '';
347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eno_l),l_str_eno_l);
348:

Line 347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eno_l),l_str_eno_l);

343: l_str_name_l := '' || get_lookup_meaning('KW_FORM_LABELS','NAME') || '';
344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_name_l),l_str_name_l);
345:
346: l_str_eno_l := '' || get_lookup_meaning('KW_FORM_LABELS','EMP_NO') || '';
347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eno_l),l_str_eno_l);
348:
349: l_str_org_l := '' || get_lookup_meaning('KW_FORM_LABELS','ORG_L') || '';
350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_org_l),l_str_org_l);
351:

Line 350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_org_l),l_str_org_l);

346: l_str_eno_l := '' || get_lookup_meaning('KW_FORM_LABELS','EMP_NO') || '';
347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eno_l),l_str_eno_l);
348:
349: l_str_org_l := '' || get_lookup_meaning('KW_FORM_LABELS','ORG_L') || '';
350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_org_l),l_str_org_l);
351:
352: l_str_job_l := '' || get_lookup_meaning('KW_FORM_LABELS','JOB_L') || '';
353: dbms_lob.writeAppend( l_xfdf_string, length(l_str_job_l),l_str_job_l);
354:

Line 353: dbms_lob.writeAppend( l_xfdf_string, length(l_str_job_l),l_str_job_l);

349: l_str_org_l := '' || get_lookup_meaning('KW_FORM_LABELS','ORG_L') || '';
350: dbms_lob.writeAppend( l_xfdf_string, length(l_str_org_l),l_str_org_l);
351:
352: l_str_job_l := '' || get_lookup_meaning('KW_FORM_LABELS','JOB_L') || '';
353: dbms_lob.writeAppend( l_xfdf_string, length(l_str_job_l),l_str_job_l);
354:
355: l_str_amt_l := '' || get_lookup_meaning('KW_FORM_LABELS','AMOUNT') || '';
356: dbms_lob.writeAppend( l_xfdf_string, length(l_str_amt_l),l_str_amt_l);
357:

Line 356: dbms_lob.writeAppend( l_xfdf_string, length(l_str_amt_l),l_str_amt_l);

352: l_str_job_l := '' || get_lookup_meaning('KW_FORM_LABELS','JOB_L') || '';
353: dbms_lob.writeAppend( l_xfdf_string, length(l_str_job_l),l_str_job_l);
354:
355: l_str_amt_l := '' || get_lookup_meaning('KW_FORM_LABELS','AMOUNT') || '';
356: dbms_lob.writeAppend( l_xfdf_string, length(l_str_amt_l),l_str_amt_l);
357:
358: l_str_chq_l := '' || get_lookup_meaning('KW_FORM_LABELS','CHQ_L') || '';
359: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chq_l),l_str_chq_l);
360:

Line 359: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chq_l),l_str_chq_l);

355: l_str_amt_l := '' || get_lookup_meaning('KW_FORM_LABELS','AMOUNT') || '';
356: dbms_lob.writeAppend( l_xfdf_string, length(l_str_amt_l),l_str_amt_l);
357:
358: l_str_chq_l := '' || get_lookup_meaning('KW_FORM_LABELS','CHQ_L') || '';
359: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chq_l),l_str_chq_l);
360:
361: l_str_pd_l := '' || get_lookup_meaning('KW_FORM_LABELS','PD_L') || '';
362: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pd_l),l_str_pd_l);
363:

Line 362: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pd_l),l_str_pd_l);

358: l_str_chq_l := '' || get_lookup_meaning('KW_FORM_LABELS','CHQ_L') || '';
359: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chq_l),l_str_chq_l);
360:
361: l_str_pd_l := '' || get_lookup_meaning('KW_FORM_LABELS','PD_L') || '';
362: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pd_l),l_str_pd_l);
363:
364:
365:
366: hr_utility.set_location('Entering CHQR ',10);

Line 464: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

460: Exit when csr_chq_det%NOTFOUND;
461:
462: l_amount_fm := to_char(l_amount,lg_format_mask);
463:
464: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
465:
466: l_str_seq := ''||seq||'';
467: l_str_er_name1 := ''||substr(l_full_name,1,60)||'';
468: l_str_er_name2 := ''||l_employee_number||'';

Line 475: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq), l_str_seq);

471: l_str_er_name5 := ''||l_amount_fm||'';
472: l_str_er_name6 := ''||l_chq_number||'';
473: l_str_er_name7 := ''||l_pay_date||'';
474:
475: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq), l_str_seq);
476: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);
477: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
478: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
479: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);

Line 476: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);

472: l_str_er_name6 := ''||l_chq_number||'';
473: l_str_er_name7 := ''||l_pay_date||'';
474:
475: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq), l_str_seq);
476: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);
477: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
478: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
479: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
480: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);

Line 477: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);

473: l_str_er_name7 := ''||l_pay_date||'';
474:
475: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq), l_str_seq);
476: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);
477: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
478: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
479: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
480: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
481: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);

Line 478: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);

474:
475: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq), l_str_seq);
476: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);
477: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
478: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
479: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
480: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
481: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);
482: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);

Line 479: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);

475: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq), l_str_seq);
476: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);
477: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
478: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
479: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
480: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
481: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);
482: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);
483:

Line 480: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);

476: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);
477: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
478: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
479: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
480: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
481: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);
482: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);
483:
484: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 481: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);

477: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
478: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
479: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
480: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
481: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);
482: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);
483:
484: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
485: seq := seq + 1;

Line 482: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);

478: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
479: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
480: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
481: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);
482: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);
483:
484: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
485: seq := seq + 1;
486: END LOOP;

Line 484: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

480: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
481: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);
482: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);
483:
484: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
485: seq := seq + 1;
486: END LOOP;
487: CLOSE csr_chq_det;
488: j := j + 1;

Line 493: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

489:
490: END LOOP;
491: End If;
492:
493: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
494:
495: hr_utility.set_location('Finished creating xml data for Procedure CHQR ',20);
496:
497: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);

Line 497: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);

493: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
494:
495: hr_utility.set_location('Finished creating xml data for Procedure CHQR ',20);
496:
497: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
498: clob_to_blob(l_xfdf_string,l_xfdf_blob);
499:
500:
501: /*EXCEPTION

Line 562: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);

558: l_str7 := '
559:
560:
561: ';
562: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
563: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
564: if vXMLTable.COUNT > 0 then
565: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
566: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

Line 563: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

559:
560:
561: ';
562: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
563: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
564: if vXMLTable.COUNT > 0 then
565: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
566: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
567: l_str8 := vXMLTable(ctr_table).TagName;

Line 565: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

561: ';
562: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
563: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
564: if vXMLTable.COUNT > 0 then
565: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
566: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
567: l_str8 := vXMLTable(ctr_table).TagName;
568: l_str9 := vXMLTable(ctr_table).TagValue;
569: if (l_str9 is not null) then

Line 570: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );

566: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
567: l_str8 := vXMLTable(ctr_table).TagName;
568: l_str9 := vXMLTable(ctr_table).TagValue;
569: if (l_str9 is not null) then
570: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
571: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
572: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
573: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
574: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

Line 571: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);

567: l_str8 := vXMLTable(ctr_table).TagName;
568: l_str9 := vXMLTable(ctr_table).TagValue;
569: if (l_str9 is not null) then
570: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
571: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
572: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
573: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
574: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
575: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

Line 572: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );

568: l_str9 := vXMLTable(ctr_table).TagValue;
569: if (l_str9 is not null) then
570: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
571: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
572: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
573: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
574: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
575: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
576: elsif (l_str9 is null and l_str8 is not null) then

Line 573: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );

569: if (l_str9 is not null) then
570: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
571: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
572: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
573: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
574: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
575: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
576: elsif (l_str9 is null and l_str8 is not null) then
577: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

Line 574: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

570: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
571: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
572: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
573: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
574: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
575: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
576: elsif (l_str9 is null and l_str8 is not null) then
577: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
578: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

Line 575: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

571: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
572: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
573: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
574: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
575: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
576: elsif (l_str9 is null and l_str8 is not null) then
577: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
578: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
579: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

Line 577: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

573: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
574: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
575: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
576: elsif (l_str9 is null and l_str8 is not null) then
577: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
578: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
579: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
580: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
581: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

Line 578: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

574: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
575: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
576: elsif (l_str9 is null and l_str8 is not null) then
577: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
578: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
579: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
580: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
581: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
582: else

Line 579: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

575: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
576: elsif (l_str9 is null and l_str8 is not null) then
577: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
578: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
579: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
580: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
581: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
582: else
583: null;

Line 580: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);

576: elsif (l_str9 is null and l_str8 is not null) then
577: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
578: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
579: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
580: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
581: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
582: else
583: null;
584: end if;

Line 581: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

577: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
578: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
579: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
580: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
581: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
582: else
583: null;
584: end if;
585: END LOOP;

Line 586: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );

582: else
583: null;
584: end if;
585: END LOOP;
586: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
587: else
588: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
589: end if;
590: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

Line 588: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );

584: end if;
585: END LOOP;
586: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
587: else
588: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
589: end if;
590: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
591: clob_to_blob(l_xfdf_string,p_xfdf_blob);
592: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

Line 590: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

586: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
587: else
588: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
589: end if;
590: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
591: clob_to_blob(l_xfdf_string,p_xfdf_blob);
592: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
593: --return p_xfdf_blob;
594: EXCEPTION

Line 618: l_length_clob := dbms_lob.getlength(p_clob);

614: begin
615: l_buffer_len := 20000;
616: hr_utility.set_location('Entered Procedure clob to blob',120);
617: select userenv('LANGUAGE') into g_nls_db_char from dual;
618: l_length_clob := dbms_lob.getlength(p_clob);
619: l_offset := 1;
620: while l_length_clob > 0 loop
621: hr_utility.trace('l_length_clob '|| l_length_clob);
622: if l_length_clob < l_buffer_len then

Line 627: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);

623: l_chunk_len := l_length_clob;
624: else
625: l_chunk_len := l_buffer_len;
626: end if;
627: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
628: fnd_file.put_line(fnd_file.log,l_varchar_buffer);
629: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
630: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
631: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));

Line 633: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);

629: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
630: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
631: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
632: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
633: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
634: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
635: l_blob_offset := l_blob_offset + l_raw_buffer_len;
636: l_offset := l_offset + l_chunk_len;
637: l_length_clob := l_length_clob - l_chunk_len;

Line 634: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);

630: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
631: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
632: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
633: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
634: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
635: l_blob_offset := l_blob_offset + l_raw_buffer_len;
636: l_offset := l_offset + l_chunk_len;
637: l_length_clob := l_length_clob - l_chunk_len;
638: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

Line 638: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

634: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
635: l_blob_offset := l_blob_offset + l_raw_buffer_len;
636: l_offset := l_offset + l_chunk_len;
637: l_length_clob := l_length_clob - l_chunk_len;
638: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
639: end loop;
640: hr_utility.set_location('Finished Procedure clob to blob ',130);
641: end clob_to_blob;
642: ------------------------------------------------------------------