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_AE_CHEQUE_REPORT dependencies on DBMS_LOB

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

305:
306: vXMLTable.DELETE;
307: vCtr := 1;
308:
309: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
310: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
311: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
312: clob_to_blob(l_xfdf_string,l_xfdf_blob);
313: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

306: vXMLTable.DELETE;
307: vCtr := 1;
308:
309: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
310: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
311: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
312: clob_to_blob(l_xfdf_string,l_xfdf_blob);
313: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
314:

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

307: vCtr := 1;
308:
309: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
310: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
311: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
312: clob_to_blob(l_xfdf_string,l_xfdf_blob);
313: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
314:
315:

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

309: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
310: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
311: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
312: clob_to_blob(l_xfdf_string,l_xfdf_blob);
313: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
314:
315:
316: l_str_rep_label := '' || get_lookup_meaning('AE_FORM_LABELS','AE_CHQR') || '';
317: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_label),l_str_rep_label);

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

313: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
314:
315:
316: l_str_rep_label := '' || get_lookup_meaning('AE_FORM_LABELS','AE_CHQR') || '';
317: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_label),l_str_rep_label);
318:
319: l_str_py_label := '' || get_lookup_meaning('AE_FORM_LABELS','PY_LABEL') || '';
320: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_label),l_str_py_label);
321:

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

316: l_str_rep_label := '' || get_lookup_meaning('AE_FORM_LABELS','AE_CHQR') || '';
317: dbms_lob.writeAppend( l_xfdf_string, length(l_str_rep_label),l_str_rep_label);
318:
319: l_str_py_label := '' || get_lookup_meaning('AE_FORM_LABELS','PY_LABEL') || '';
320: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_label),l_str_py_label);
321:
322: l_str_py_name := '' ||''|| ''; /* Added for Bug No : 9454120 */
323: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_name),l_str_py_name);
324:

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

319: l_str_py_label := '' || get_lookup_meaning('AE_FORM_LABELS','PY_LABEL') || '';
320: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_label),l_str_py_label);
321:
322: l_str_py_name := '' ||''|| ''; /* Added for Bug No : 9454120 */
323: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_name),l_str_py_name);
324:
325: l_str_n := '' || get_lookup_meaning('AE_FORM_LABELS','S_NO') || '';
326: dbms_lob.writeAppend( l_xfdf_string, length(l_str_n),l_str_n);
327:

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

322: l_str_py_name := '' ||''|| ''; /* Added for Bug No : 9454120 */
323: dbms_lob.writeAppend( l_xfdf_string, length(l_str_py_name),l_str_py_name);
324:
325: l_str_n := '' || get_lookup_meaning('AE_FORM_LABELS','S_NO') || '';
326: dbms_lob.writeAppend( l_xfdf_string, length(l_str_n),l_str_n);
327:
328: l_str_name_l := '' || get_lookup_meaning('AE_FORM_LABELS','NAME') || '';
329: dbms_lob.writeAppend( l_xfdf_string, length(l_str_name_l),l_str_name_l);
330:

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

325: l_str_n := '' || get_lookup_meaning('AE_FORM_LABELS','S_NO') || '';
326: dbms_lob.writeAppend( l_xfdf_string, length(l_str_n),l_str_n);
327:
328: l_str_name_l := '' || get_lookup_meaning('AE_FORM_LABELS','NAME') || '';
329: dbms_lob.writeAppend( l_xfdf_string, length(l_str_name_l),l_str_name_l);
330:
331: l_str_eno_l := '' || get_lookup_meaning('AE_FORM_LABELS','EMP_NO') || '';
332: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eno_l),l_str_eno_l);
333:

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

328: l_str_name_l := '' || get_lookup_meaning('AE_FORM_LABELS','NAME') || '';
329: dbms_lob.writeAppend( l_xfdf_string, length(l_str_name_l),l_str_name_l);
330:
331: l_str_eno_l := '' || get_lookup_meaning('AE_FORM_LABELS','EMP_NO') || '';
332: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eno_l),l_str_eno_l);
333:
334: l_str_org_l := '' || get_lookup_meaning('AE_FORM_LABELS','ORG_L') || '';
335: dbms_lob.writeAppend( l_xfdf_string, length(l_str_org_l),l_str_org_l);
336:

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

331: l_str_eno_l := '' || get_lookup_meaning('AE_FORM_LABELS','EMP_NO') || '';
332: dbms_lob.writeAppend( l_xfdf_string, length(l_str_eno_l),l_str_eno_l);
333:
334: l_str_org_l := '' || get_lookup_meaning('AE_FORM_LABELS','ORG_L') || '';
335: dbms_lob.writeAppend( l_xfdf_string, length(l_str_org_l),l_str_org_l);
336:
337: l_str_job_l := '' || get_lookup_meaning('AE_FORM_LABELS','JOB_L') || '';
338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_job_l),l_str_job_l);
339:

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

334: l_str_org_l := '' || get_lookup_meaning('AE_FORM_LABELS','ORG_L') || '';
335: dbms_lob.writeAppend( l_xfdf_string, length(l_str_org_l),l_str_org_l);
336:
337: l_str_job_l := '' || get_lookup_meaning('AE_FORM_LABELS','JOB_L') || '';
338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_job_l),l_str_job_l);
339:
340: l_str_amt_l := '' || get_lookup_meaning('AE_FORM_LABELS','AMOUNT') || '';
341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_amt_l),l_str_amt_l);
342:

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

337: l_str_job_l := '' || get_lookup_meaning('AE_FORM_LABELS','JOB_L') || '';
338: dbms_lob.writeAppend( l_xfdf_string, length(l_str_job_l),l_str_job_l);
339:
340: l_str_amt_l := '' || get_lookup_meaning('AE_FORM_LABELS','AMOUNT') || '';
341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_amt_l),l_str_amt_l);
342:
343: l_str_chq_l := '' || get_lookup_meaning('AE_FORM_LABELS','CHQ_L') || '';
344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chq_l),l_str_chq_l);
345:

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

340: l_str_amt_l := '' || get_lookup_meaning('AE_FORM_LABELS','AMOUNT') || '';
341: dbms_lob.writeAppend( l_xfdf_string, length(l_str_amt_l),l_str_amt_l);
342:
343: l_str_chq_l := '' || get_lookup_meaning('AE_FORM_LABELS','CHQ_L') || '';
344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chq_l),l_str_chq_l);
345:
346: l_str_pd_l := '' || get_lookup_meaning('AE_FORM_LABELS','PD_L') || '';
347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pd_l),l_str_pd_l);
348:

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

343: l_str_chq_l := '' || get_lookup_meaning('AE_FORM_LABELS','CHQ_L') || '';
344: dbms_lob.writeAppend( l_xfdf_string, length(l_str_chq_l),l_str_chq_l);
345:
346: l_str_pd_l := '' || get_lookup_meaning('AE_FORM_LABELS','PD_L') || '';
347: dbms_lob.writeAppend( l_xfdf_string, length(l_str_pd_l),l_str_pd_l);
348:
349:
350:
351: hr_utility.set_location('Entering CHQR ',10);

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

445: Exit when csr_chq_det%NOTFOUND;
446:
447: l_amount_fm := to_char(l_amount,lg_format_mask);
448:
449: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
450:
451: l_str_seq := ''||seq||'';
452: l_str_er_name1 := ''||substr(l_full_name,1,60)||'';
453: l_str_er_name2 := ''||l_employee_number||'';

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

456: l_str_er_name5 := ''||l_amount_fm||'';
457: l_str_er_name6 := ''||l_chq_number||'';
458: l_str_er_name7 := ''||l_pay_date||'';
459:
460: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq), l_str_seq);
461: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);
462: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
463: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
464: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);

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

457: l_str_er_name6 := ''||l_chq_number||'';
458: l_str_er_name7 := ''||l_pay_date||'';
459:
460: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq), l_str_seq);
461: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);
462: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
463: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
464: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
465: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);

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

458: l_str_er_name7 := ''||l_pay_date||'';
459:
460: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq), l_str_seq);
461: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);
462: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
463: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
464: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
465: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
466: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);

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

459:
460: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq), l_str_seq);
461: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);
462: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
463: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
464: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
465: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
466: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);
467: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);

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

460: dbms_lob.writeAppend( l_xfdf_string, length(l_str_seq), l_str_seq);
461: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);
462: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
463: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
464: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
465: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
466: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);
467: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);
468:

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

461: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name1), l_str_er_name1);
462: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
463: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
464: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
465: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
466: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);
467: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);
468:
469: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

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

462: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name2), l_str_er_name2);
463: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
464: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
465: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
466: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);
467: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);
468:
469: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
470: seq := seq + 1;

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

463: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name3), l_str_er_name3);
464: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name4), l_str_er_name4);
465: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
466: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);
467: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);
468:
469: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
470: seq := seq + 1;
471: END LOOP;

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

465: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name5), l_str_er_name5);
466: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name6), l_str_er_name6);
467: dbms_lob.writeAppend( l_xfdf_string, length(l_str_er_name7), l_str_er_name7);
468:
469: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
470: seq := seq + 1;
471: END LOOP;
472: CLOSE csr_chq_det;
473: j := j + 1;

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

474:
475: END LOOP;
476: End If;
477:
478: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
479:
480: hr_utility.set_location('Finished creating xml data for Procedure CHQR ',20);
481:
482: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);

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

478: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
479:
480: hr_utility.set_location('Finished creating xml data for Procedure CHQR ',20);
481:
482: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
483: clob_to_blob(l_xfdf_string,l_xfdf_blob);
484:
485:
486: /*EXCEPTION

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

543: l_str7 := '
544:
545:
546: ';
547: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
548: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
549: if vXMLTable.COUNT > 0 then
550: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
551: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

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

544:
545:
546: ';
547: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
548: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
549: if vXMLTable.COUNT > 0 then
550: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
551: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
552: l_str8 := vXMLTable(ctr_table).TagName;

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

546: ';
547: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
548: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
549: if vXMLTable.COUNT > 0 then
550: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
551: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
552: l_str8 := vXMLTable(ctr_table).TagName;
553: l_str9 := vXMLTable(ctr_table).TagValue;
554: if (l_str9 is not null) then

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

553: l_str9 := vXMLTable(ctr_table).TagValue;
554: if (l_str9 is not null) then
555: /* Added CDATA to handle special characters Bug No:9454120 */
556: l_str9 := '';
557: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
558: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
559: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
560: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
561: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

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

554: if (l_str9 is not null) then
555: /* Added CDATA to handle special characters Bug No:9454120 */
556: l_str9 := '';
557: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
558: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
559: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
560: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
561: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
562: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

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

555: /* Added CDATA to handle special characters Bug No:9454120 */
556: l_str9 := '';
557: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
558: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
559: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
560: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
561: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
562: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
563: elsif (l_str9 is null and l_str8 is not null) then

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

556: l_str9 := '';
557: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
558: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
559: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
560: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
561: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
562: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
563: elsif (l_str9 is null and l_str8 is not null) then
564: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

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

557: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
558: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
559: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
560: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
561: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
562: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
563: elsif (l_str9 is null and l_str8 is not null) then
564: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
565: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

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

558: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
559: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
560: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
561: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
562: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
563: elsif (l_str9 is null and l_str8 is not null) then
564: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
565: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
566: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

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

560: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
561: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
562: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
563: elsif (l_str9 is null and l_str8 is not null) then
564: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
565: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
566: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
567: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
568: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

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

561: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
562: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
563: elsif (l_str9 is null and l_str8 is not null) then
564: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
565: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
566: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
567: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
568: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
569: else

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

562: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
563: elsif (l_str9 is null and l_str8 is not null) then
564: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
565: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
566: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
567: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
568: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
569: else
570: null;

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

563: elsif (l_str9 is null and l_str8 is not null) then
564: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
565: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
566: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
567: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
568: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
569: else
570: null;
571: end if;

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

564: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
565: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
566: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
567: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
568: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
569: else
570: null;
571: end if;
572: END LOOP;

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

569: else
570: null;
571: end if;
572: END LOOP;
573: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
574: else
575: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
576: end if;
577: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

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

571: end if;
572: END LOOP;
573: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
574: else
575: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
576: end if;
577: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
578: clob_to_blob(l_xfdf_string,p_xfdf_blob);
579: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

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

573: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
574: else
575: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
576: end if;
577: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
578: clob_to_blob(l_xfdf_string,p_xfdf_blob);
579: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
580: --return p_xfdf_blob;
581: EXCEPTION

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

601: begin
602: l_buffer_len := 20000;
603: hr_utility.set_location('Entered Procedure clob to blob',120);
604: select userenv('LANGUAGE') into g_nls_db_char from dual;
605: l_length_clob := dbms_lob.getlength(p_clob);
606: l_offset := 1;
607: while l_length_clob > 0 loop
608: hr_utility.trace('l_length_clob '|| l_length_clob);
609: if l_length_clob < l_buffer_len then

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

610: l_chunk_len := l_length_clob;
611: else
612: l_chunk_len := l_buffer_len;
613: end if;
614: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
615: fnd_file.put_line(fnd_file.log,l_varchar_buffer);
616: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
617: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
618: 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 620: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);

616: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
617: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
618: 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));
619: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
620: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
621: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
622: l_blob_offset := l_blob_offset + l_raw_buffer_len;
623: l_offset := l_offset + l_chunk_len;
624: l_length_clob := l_length_clob - l_chunk_len;

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

617: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
618: 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));
619: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
620: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
621: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
622: l_blob_offset := l_blob_offset + l_raw_buffer_len;
623: l_offset := l_offset + l_chunk_len;
624: l_length_clob := l_length_clob - l_chunk_len;
625: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

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

621: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
622: l_blob_offset := l_blob_offset + l_raw_buffer_len;
623: l_offset := l_offset + l_chunk_len;
624: l_length_clob := l_length_clob - l_chunk_len;
625: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
626: end loop;
627: hr_utility.set_location('Finished Procedure clob to blob ',130);
628: end clob_to_blob;
629: ------------------------------------------------------------------