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.PSP_XMLGEN dependencies on DBMS_LOB

Line 87: dbms_lob.write(l_xml, length(' '), 1, ' ');

83: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
84: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
85: dbms_xmlgen.closecontext(qryctx1);
86: l_xml := xmlresult1;
87: dbms_lob.write(l_xml, length(' '), 1, ' ');
88: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
89: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(' '), l_resultOffset +1);
90: RETURN l_xml;
91: EXCEPTION

Line 88: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

84: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
85: dbms_xmlgen.closecontext(qryctx1);
86: l_xml := xmlresult1;
87: dbms_lob.write(l_xml, length(' '), 1, ' ');
88: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
89: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(' '), l_resultOffset +1);
90: RETURN l_xml;
91: EXCEPTION
92: WHEN OTHERS THEN

Line 89: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(' '), l_resultOffset +1);

85: dbms_xmlgen.closecontext(qryctx1);
86: l_xml := xmlresult1;
87: dbms_lob.write(l_xml, length(' '), 1, ' ');
88: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
89: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(' '), l_resultOffset +1);
90: RETURN l_xml;
91: EXCEPTION
92: WHEN OTHERS THEN
93: OPEN add_report_error_cur(sqlerrm);

Line 361: dbms_lob.write(l_xml, length(l_report_info), 1, l_report_info);

357: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
358: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
359: dbms_xmlgen.closecontext(qryctx1);
360: l_xml := xmlresult1;
361: dbms_lob.write(l_xml, length(l_report_info), 1, l_report_info);
362: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
363: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
364:
365: IF (l_layout_type = 'EMP') THEN

Line 362: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

358: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
359: dbms_xmlgen.closecontext(qryctx1);
360: l_xml := xmlresult1;
361: dbms_lob.write(l_xml, length(l_report_info), 1, l_report_info);
362: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
363: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
364:
365: IF (l_layout_type = 'EMP') THEN
366:

Line 363: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);

359: dbms_xmlgen.closecontext(qryctx1);
360: l_xml := xmlresult1;
361: dbms_lob.write(l_xml, length(l_report_info), 1, l_report_info);
362: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
363: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
364:
365: IF (l_layout_type = 'EMP') THEN
366:
367: dbms_lob.writeappend(l_xml, length(' '), ' ');

Line 367: dbms_lob.writeappend(l_xml, length(' '), ' ');

363: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);
364:
365: IF (l_layout_type = 'EMP') THEN
366:
367: dbms_lob.writeappend(l_xml, length(' '), ' ');
368:
369: IF (p_request_id IS NULL) THEN
370:
371: query1 := 'SELECT person_xml FROM psp_eff_reports per WHERE per.status_code IN (''A'', ''N'') '

Line 386: dbms_lob.copy(l_xml, l_person_xml, dbms_lob.getlength(l_person_xml), dbms_lob.getlength(l_xml), 1);

382: LOOP
383: FETCH person_xml_cur INTO l_person_xml;
384: EXIT WHEN person_xml_cur%NOTFOUND;
385:
386: dbms_lob.copy(l_xml, l_person_xml, dbms_lob.getlength(l_person_xml), dbms_lob.getlength(l_xml), 1);
387: END LOOP;
388: CLOSE person_xml_cur;
389:
390: dbms_lob.writeappend(l_xml, length(''), '');

Line 390: dbms_lob.writeappend(l_xml, length(''), '');

386: dbms_lob.copy(l_xml, l_person_xml, dbms_lob.getlength(l_person_xml), dbms_lob.getlength(l_xml), 1);
387: END LOOP;
388: CLOSE person_xml_cur;
389:
390: dbms_lob.writeappend(l_xml, length(''), '');
391: ELSE
392:
393: OPEN sort_option2_cur(l_request_id);
394: l_sort_option1 := NULL;

Line 414: dbms_lob.writeappend(l_xml, length(' '), ' ');

410: END IF;
411: END LOOP;
412: CLOSE sort_option2_cur;
413:
414: dbms_lob.writeappend(l_xml, length(' '), ' ');
415: IF (p_request_id IS NULL) THEN
416: query1 := 'SELECT investigator_person_id, investigator_name, investigator_org_name, investigator_primary_org_id, '
417: || 'TRIM(TO_CHAR(SUM(proposed_salary_amt), ''' || l_num30_fmask || ''')) total_pi_proposed_salary, '
418: || 'TRIM(TO_CHAR(SUM(actual_salary_amt), ''' || l_num30_fmask || ''')) total_pi_actual_salary FROM '

Line 454: dbms_lob.writeappend(l_xml, length('

450: ---- 4429787
451: l_investigator_name := convert_xml_controls(l_investigator_name);
452: l_investigator_org_name := convert_xml_controls(l_investigator_org_name);
453:
454: dbms_lob.writeappend(l_xml, length('
455: ' || TO_CHAR(l_investigator_id) || '
456: ' || l_investigator_name || '
457: ' || l_investigator_org_name || '
458: ' || TO_CHAR(l_investigator_primary_org_id) || '

Line 472: -- dbms_lob.writeappend(l_xml, length(' '), ' ');

468: ' || l_total_pi_actual_salary || '
469: ' || l_show_hide_fyi_flag || '
470: ');
471:
472: -- dbms_lob.writeappend(l_xml, length(' '), ' ');
473:
474: query2 := 'SELECT person_xml FROM psp_eff_reports per WHERE per.effort_report_id IN (SELECT perd.effort_report_id '
475: || 'FROM psp_eff_report_details perd WHERE perd.investigator_person_id = ' || TO_CHAR(l_investigator_id) || ')'
476: || ' AND request_id = ' || TO_CHAR(l_request_id) || ' AND status_code <> ''R''' || l_emp_sort_option;

Line 481: l_resultOffset := DBMS_LOB.INSTR(l_person_xml,'>');

477: OPEN person_xml_cur FOR query2;
478: LOOP
479: FETCH person_xml_cur INTO l_person_xml;
480: EXIT WHEN person_xml_cur%NOTFOUND;
481: l_resultOffset := DBMS_LOB.INSTR(l_person_xml,'>');
482: dbms_lob.copy(l_xml, l_person_xml, dbms_lob.getlength(l_person_xml), dbms_lob.getlength(l_xml), 1);
483: END LOOP;
484: CLOSE person_xml_cur;
485:

Line 482: dbms_lob.copy(l_xml, l_person_xml, dbms_lob.getlength(l_person_xml), dbms_lob.getlength(l_xml), 1);

478: LOOP
479: FETCH person_xml_cur INTO l_person_xml;
480: EXIT WHEN person_xml_cur%NOTFOUND;
481: l_resultOffset := DBMS_LOB.INSTR(l_person_xml,'>');
482: dbms_lob.copy(l_xml, l_person_xml, dbms_lob.getlength(l_person_xml), dbms_lob.getlength(l_xml), 1);
483: END LOOP;
484: CLOSE person_xml_cur;
485:
486: -- dbms_lob.writeappend(l_xml, length(' '), ' ');

Line 486: -- dbms_lob.writeappend(l_xml, length(' '), ' ');

482: dbms_lob.copy(l_xml, l_person_xml, dbms_lob.getlength(l_person_xml), dbms_lob.getlength(l_xml), 1);
483: END LOOP;
484: CLOSE person_xml_cur;
485:
486: -- dbms_lob.writeappend(l_xml, length(' '), ' ');
487:
488: --Bug 4334816: START
489: -- Including the WorkFlow Note in Pdf
490:

Line 515: IF (dbms_lob.getlength(xmlresult1) > 0) THEN

511: dbms_xmlgen.setRowTag(qryCtx1, 'G_APPROVER');
512: dbms_xmlgen.setRowSetTag(qryCtx1, 'LIST_G_APPROVER');
513: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
514: dbms_xmlgen.closecontext(qryctx1);
515: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
516: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
517: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
518: END IF;
519: dbms_lob.writeappend(l_xml, length(' '), ' ');

Line 516: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

512: dbms_xmlgen.setRowSetTag(qryCtx1, 'LIST_G_APPROVER');
513: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
514: dbms_xmlgen.closecontext(qryctx1);
515: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
516: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
517: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
518: END IF;
519: dbms_lob.writeappend(l_xml, length(' '), ' ');
520:

Line 517: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);

513: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
514: dbms_xmlgen.closecontext(qryctx1);
515: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
516: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
517: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
518: END IF;
519: dbms_lob.writeappend(l_xml, length(' '), ' ');
520:
521: END LOOP;

Line 519: dbms_lob.writeappend(l_xml, length(' '), ' ');

515: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
516: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
517: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
518: END IF;
519: dbms_lob.writeappend(l_xml, length(' '), ' ');
520:
521: END LOOP;
522: CLOSE investigator_cur;
523:

Line 524: dbms_lob.writeappend(l_xml, length(' '), ' ');

520:
521: END LOOP;
522: CLOSE investigator_cur;
523:
524: dbms_lob.writeappend(l_xml, length(' '), ' ');
525: END IF;
526:
527: dbms_lob.writeappend(l_xml, length(''), '');
528:

Line 527: dbms_lob.writeappend(l_xml, length(''), '');

523:
524: dbms_lob.writeappend(l_xml, length(' '), ' ');
525: END IF;
526:
527: dbms_lob.writeappend(l_xml, length(''), '');
528:
529: RETURN l_xml;
530: EXCEPTION
531: WHEN OTHERS THEN

Line 737: dbms_lob.write(l_xml, length(l_employee_info), 1, l_employee_info);

733: dbms_xmlquery.setRowSetTag(qryCtx2, 'EMP_DFF');
734: xmlresult1 := dbms_xmlquery.getXML(qryCtx2, dbms_xmlgen.NONE);
735: dbms_xmlquery.closecontext(qryctx2);
736: l_xml := xmlresult1;
737: dbms_lob.write(l_xml, length(l_employee_info), 1, l_employee_info);
738: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
739: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_employee_info), l_resultOffset +1);
740:
741:

Line 738: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

734: xmlresult1 := dbms_xmlquery.getXML(qryCtx2, dbms_xmlgen.NONE);
735: dbms_xmlquery.closecontext(qryctx2);
736: l_xml := xmlresult1;
737: dbms_lob.write(l_xml, length(l_employee_info), 1, l_employee_info);
738: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
739: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_employee_info), l_resultOffset +1);
740:
741:
742:

Line 739: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_employee_info), l_resultOffset +1);

735: dbms_xmlquery.closecontext(qryctx2);
736: l_xml := xmlresult1;
737: dbms_lob.write(l_xml, length(l_employee_info), 1, l_employee_info);
738: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
739: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_employee_info), l_resultOffset +1);
740:
741:
742:
743: query1 := 'select TRIM(TO_CHAR(SUM(NVL(proposed_salary_amt, 0)), ''' || l_num25_fmask || ''')) total_emp_proposed_salary, '

Line 758: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

754: dbms_xmlgen.setRowTag(qryCtx1, NULL);
755: dbms_xmlgen.setRowSetTag(qryCtx1, 'TOTAL_EMP');
756: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
757: dbms_xmlgen.closecontext(qryctx1);
758: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
759: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
760: dbms_lob.writeappend(l_xml, length(' '), ' ');
761:
762: OPEN assign_cur(p_effort_report_id);

Line 759: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);

755: dbms_xmlgen.setRowSetTag(qryCtx1, 'TOTAL_EMP');
756: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
757: dbms_xmlgen.closecontext(qryctx1);
758: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
759: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
760: dbms_lob.writeappend(l_xml, length(' '), ' ');
761:
762: OPEN assign_cur(p_effort_report_id);
763: LOOP

Line 760: dbms_lob.writeappend(l_xml, length(' '), ' ');

756: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
757: dbms_xmlgen.closecontext(qryctx1);
758: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
759: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
760: dbms_lob.writeappend(l_xml, length(' '), ' ');
761:
762: OPEN assign_cur(p_effort_report_id);
763: LOOP
764: FETCH assign_cur INTO l_assignment_id, l_assignment_number;

Line 772: dbms_lob.writeappend(l_xml, length('' || TO_CHAR(l_assignment_id) ||

768: IF (l_assignment_id IS NOT NULL) THEN
769: l_assignment_check := l_assignment_check || ' AND assignment_id = ' || TO_CHAR(l_assignment_id);
770: END IF;
771: --- applied strip controls for 4429787
772: dbms_lob.writeappend(l_xml, length('' || TO_CHAR(l_assignment_id) ||
773: '' || convert_xml_controls(l_assignment_number) || ' '),
774: '' || TO_CHAR(l_assignment_id) || '' ||
775: convert_xml_controls(l_assignment_number) || ' ');
776:

Line 792: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

788: dbms_xmlgen.setRowTag(qryCtx1, NULL);
789: dbms_xmlgen.setRowSetTag(qryCtx1, 'TOTAL_ASG');
790: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
791: dbms_xmlgen.closecontext(qryctx1);
792: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
793: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
794:
795:
796: /* Changes for Hospital effort report :START */

Line 793: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);

789: dbms_xmlgen.setRowSetTag(qryCtx1, 'TOTAL_ASG');
790: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
791: dbms_xmlgen.closecontext(qryctx1);
792: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
793: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
794:
795:
796: /* Changes for Hospital effort report :START */
797: dbms_lob.writeappend(l_xml, length(' '), ' ');

Line 797: dbms_lob.writeappend(l_xml, length(' '), ' ');

793: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
794:
795:
796: /* Changes for Hospital effort report :START */
797: dbms_lob.writeappend(l_xml, length(' '), ' ');
798:
799: OPEN grouping_category_csr(l_assignment_id);
800: LOOP
801: FETCH grouping_category_csr INTO l_grouping_category, l_layout_option_order;

Line 803: --dbms_lob.writeappend(l_xml, length(' '), ' ');

799: OPEN grouping_category_csr(l_assignment_id);
800: LOOP
801: FETCH grouping_category_csr INTO l_grouping_category, l_layout_option_order;
802: EXIT WHEN grouping_category_csr%NOTFOUND;
803: --dbms_lob.writeappend(l_xml, length(' '), ' ');
804:
805: query1 := 'select TRIM(TO_CHAR(SUM(NVL(proposed_salary_amt, 0)), ''' || l_num25_fmask || ''')) total_proposed_salary, '
806: || 'TRIM(TO_CHAR(SUM(NVL(proposed_effort_percent, 0)), ''999G990D00'')) total_proposed_effort, '
807: || 'TRIM(TO_CHAR(SUM(NVL(committed_cost_share, 0)), ''999G990D00'')) total_cost_share, '

Line 835: -- l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

831: dbms_xmlgen.setRowSetTag(qryCtx1, NULL);
832: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
833: dbms_xmlgen.closecontext(qryctx1);
834: xmlresult1 := SUBSTR(xmlresult1, 1, LENGTH(xmlresult1) - 15);
835: -- l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
836: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
837:
838:
839: query1 := 'SELECT TRIM(TO_CHAR(perd.ACTUAL_SALARY_AMT, ''' || l_num25_fmask || ''')) actual_salary_amt, '

Line 836: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);

832: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
833: dbms_xmlgen.closecontext(qryctx1);
834: xmlresult1 := SUBSTR(xmlresult1, 1, LENGTH(xmlresult1) - 15);
835: -- l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
836: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
837:
838:
839: query1 := 'SELECT TRIM(TO_CHAR(perd.ACTUAL_SALARY_AMT, ''' || l_num25_fmask || ''')) actual_salary_amt, '
840: || 'TRIM(TO_CHAR(perd.PAYROLL_PERCENT, ''999G990D00'')) payroll_percent, '

Line 862: IF (dbms_lob.getlength(xmlresult1) > 0) THEN

858: dbms_xmlgen.setRowTag(qryCtx1, 'G_CATEGORYDETAILS');
859: dbms_xmlgen.setRowSetTag(qryCtx1, 'LIST_G_CATEGORYDETAILS');
860: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
861: dbms_xmlgen.closecontext(qryctx1);
862: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
863: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
864: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
865: END IF;
866:

Line 863: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

859: dbms_xmlgen.setRowSetTag(qryCtx1, 'LIST_G_CATEGORYDETAILS');
860: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
861: dbms_xmlgen.closecontext(qryctx1);
862: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
863: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
864: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
865: END IF;
866:
867:

Line 864: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);

860: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
861: dbms_xmlgen.closecontext(qryctx1);
862: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
863: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
864: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
865: END IF;
866:
867:
868: dbms_lob.writeappend(l_xml, length(' '), ' ');

Line 868: dbms_lob.writeappend(l_xml, length(' '), ' ');

864: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
865: END IF;
866:
867:
868: dbms_lob.writeappend(l_xml, length(' '), ' ');
869:
870: END LOOP;
871: CLOSE grouping_category_csr;
872: dbms_lob.writeappend(l_xml, length(' '), ' ');

Line 872: dbms_lob.writeappend(l_xml, length(' '), ' ');

868: dbms_lob.writeappend(l_xml, length(' '), ' ');
869:
870: END LOOP;
871: CLOSE grouping_category_csr;
872: dbms_lob.writeappend(l_xml, length(' '), ' ');
873:
874: /*
875:
876: query1 := 'select TRIM(TO_CHAR(SUM(NVL(proposed_salary_amt, 0)), ''' || l_num25_fmask || ''')) total_spon_proposed_salary, '

Line 895: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

891: dbms_xmlgen.setRowTag(qryCtx1, NULL);
892: dbms_xmlgen.setRowSetTag(qryCtx1, 'TOTAL_SPONSORED');
893: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
894: dbms_xmlgen.closecontext(qryctx1);
895: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
896: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
897:
898: query1 := 'select TRIM(TO_CHAR(SUM(NVL(proposed_salary_amt, 0)), ''' || l_num25_fmask || ''')) total_nspon_proposed_salary, '
899: || 'TRIM(TO_CHAR(SUM(NVL(proposed_effort_percent, 0)), ''999G990D00'')) total_nspon_proposed_effort, '

Line 896: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);

892: dbms_xmlgen.setRowSetTag(qryCtx1, 'TOTAL_SPONSORED');
893: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
894: dbms_xmlgen.closecontext(qryctx1);
895: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
896: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
897:
898: query1 := 'select TRIM(TO_CHAR(SUM(NVL(proposed_salary_amt, 0)), ''' || l_num25_fmask || ''')) total_nspon_proposed_salary, '
899: || 'TRIM(TO_CHAR(SUM(NVL(proposed_effort_percent, 0)), ''999G990D00'')) total_nspon_proposed_effort, '
900: || 'TRIM(TO_CHAR(SUM(NVL(committed_cost_share, 0)), ''999G990D00'')) total_nspon_cost_share, '

Line 917: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

913: dbms_xmlgen.setRowTag(qryCtx1, NULL);
914: dbms_xmlgen.setRowSetTag(qryCtx1, 'TOTAL_NON_SPONSORED');
915: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
916: dbms_xmlgen.closecontext(qryctx1);
917: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
918: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
919:
920: query1 := 'select TRIM(TO_CHAR(SUM(NVL(proposed_salary_amt, 0)), ''' || l_num25_fmask || ''')) total_gl_proposed_salary, '
921: || 'TRIM(TO_CHAR(SUM(NVL(proposed_effort_percent, 0)), ''999G990D00'')) total_gl_proposed_effort, '

Line 918: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);

914: dbms_xmlgen.setRowSetTag(qryCtx1, 'TOTAL_NON_SPONSORED');
915: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
916: dbms_xmlgen.closecontext(qryctx1);
917: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
918: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
919:
920: query1 := 'select TRIM(TO_CHAR(SUM(NVL(proposed_salary_amt, 0)), ''' || l_num25_fmask || ''')) total_gl_proposed_salary, '
921: || 'TRIM(TO_CHAR(SUM(NVL(proposed_effort_percent, 0)), ''999G990D00'')) total_gl_proposed_effort, '
922: || 'TRIM(TO_CHAR(SUM(NVL(committed_cost_share, 0)), ''999G990D00'')) total_gl_cost_share, '

Line 945: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

941: dbms_xmlgen.setRowTag(qryCtx1, NULL);
942: dbms_xmlgen.setRowSetTag(qryCtx1, 'TOTAL_GL');
943: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
944: dbms_xmlgen.closecontext(qryctx1);
945: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
946: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
947:
948: query1 := 'SELECT TRIM(TO_CHAR(perd.ACTUAL_SALARY_AMT, ''' || l_num25_fmask || ''')) actual_salary_amt, '
949: || 'TRIM(TO_CHAR(perd.PAYROLL_PERCENT, ''999G990D00'')) payroll_percent, '

Line 946: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);

942: dbms_xmlgen.setRowSetTag(qryCtx1, 'TOTAL_GL');
943: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
944: dbms_xmlgen.closecontext(qryctx1);
945: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
946: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
947:
948: query1 := 'SELECT TRIM(TO_CHAR(perd.ACTUAL_SALARY_AMT, ''' || l_num25_fmask || ''')) actual_salary_amt, '
949: || 'TRIM(TO_CHAR(perd.PAYROLL_PERCENT, ''999G990D00'')) payroll_percent, '
950: || 'TRIM(TO_CHAR(perd.PROPOSED_SALARY_AMT, ''' || l_num25_fmask || ''')) proposed_salary_amt, '

Line 968: IF (dbms_lob.getlength(xmlresult1) > 0) THEN

964: dbms_xmlgen.setRowTag(qryCtx1, 'G_SPONSORED');
965: dbms_xmlgen.setRowSetTag(qryCtx1, 'LIST_G_SPONSORED');
966: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
967: dbms_xmlgen.closecontext(qryctx1);
968: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
969: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
970: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
971: END IF;
972:

Line 969: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

965: dbms_xmlgen.setRowSetTag(qryCtx1, 'LIST_G_SPONSORED');
966: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
967: dbms_xmlgen.closecontext(qryctx1);
968: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
969: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
970: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
971: END IF;
972:
973: query1 := 'SELECT TRIM(TO_CHAR(perd.ACTUAL_SALARY_AMT, ''' || l_num25_fmask || ''')) actual_salary_amt, '

Line 970: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);

966: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
967: dbms_xmlgen.closecontext(qryctx1);
968: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
969: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
970: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
971: END IF;
972:
973: query1 := 'SELECT TRIM(TO_CHAR(perd.ACTUAL_SALARY_AMT, ''' || l_num25_fmask || ''')) actual_salary_amt, '
974: || 'TRIM(TO_CHAR(perd.PAYROLL_PERCENT, ''999G990D00'')) payroll_percent, '

Line 993: IF (dbms_lob.getlength(xmlresult1) > 0) THEN

989: dbms_xmlgen.setRowTag(qryCtx1, 'G_NON_SPONSORED');
990: dbms_xmlgen.setRowSetTag(qryCtx1, 'LIST_G_NON_SPONSORED');
991: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
992: dbms_xmlgen.closecontext(qryctx1);
993: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
994: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
995: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
996: END IF;
997:

Line 994: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

990: dbms_xmlgen.setRowSetTag(qryCtx1, 'LIST_G_NON_SPONSORED');
991: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
992: dbms_xmlgen.closecontext(qryctx1);
993: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
994: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
995: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
996: END IF;
997:
998: query1 := 'SELECT TRIM(TO_CHAR(perd.ACTUAL_SALARY_AMT, ''' || l_num25_fmask || ''')) actual_salary_amt, '

Line 995: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);

991: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
992: dbms_xmlgen.closecontext(qryctx1);
993: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
994: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
995: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
996: END IF;
997:
998: query1 := 'SELECT TRIM(TO_CHAR(perd.ACTUAL_SALARY_AMT, ''' || l_num25_fmask || ''')) actual_salary_amt, '
999: || 'TRIM(TO_CHAR(perd.PAYROLL_PERCENT, ''999G990D00'')) payroll_percent, '

Line 1025: IF (dbms_lob.getlength(xmlresult1) > 0) THEN

1021: dbms_xmlgen.setRowTag(qryCtx1, 'G_GL');
1022: dbms_xmlgen.setRowSetTag(qryCtx1, 'LIST_G_GL');
1023: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1024: dbms_xmlgen.closecontext(qryctx1);
1025: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
1026: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
1027: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
1028: END IF;
1029: */

Line 1026: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

1022: dbms_xmlgen.setRowSetTag(qryCtx1, 'LIST_G_GL');
1023: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1024: dbms_xmlgen.closecontext(qryctx1);
1025: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
1026: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
1027: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
1028: END IF;
1029: */
1030: /* Changes for Hospital effort report : END */

Line 1027: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);

1023: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1024: dbms_xmlgen.closecontext(qryctx1);
1025: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
1026: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
1027: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
1028: END IF;
1029: */
1030: /* Changes for Hospital effort report : END */
1031:

Line 1032: dbms_lob.writeappend(l_xml, length(' '), ' ');

1028: END IF;
1029: */
1030: /* Changes for Hospital effort report : END */
1031:
1032: dbms_lob.writeappend(l_xml, length(' '), ' ');
1033: END LOOP;
1034: CLOSE assign_cur;
1035: dbms_lob.writeappend(l_xml, length(' '), ' ');
1036:

Line 1035: dbms_lob.writeappend(l_xml, length(' '), ' ');

1031:
1032: dbms_lob.writeappend(l_xml, length(' '), ' ');
1033: END LOOP;
1034: CLOSE assign_cur;
1035: dbms_lob.writeappend(l_xml, length(' '), ' ');
1036:
1037: --Bug 4334816: START
1038: -- Including the WorkFlow Note in Pdf
1039: /*

Line 1078: IF (dbms_lob.getlength(xmlresult1) > 0) THEN

1074: dbms_xmlgen.setRowTag(qryCtx1, 'G_APPROVER');
1075: dbms_xmlgen.setRowSetTag(qryCtx1, 'LIST_G_APPROVER');
1076: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1077: dbms_xmlgen.closecontext(qryctx1);
1078: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
1079: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
1080: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
1081: END IF;
1082:

Line 1079: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

1075: dbms_xmlgen.setRowSetTag(qryCtx1, 'LIST_G_APPROVER');
1076: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1077: dbms_xmlgen.closecontext(qryctx1);
1078: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
1079: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
1080: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
1081: END IF;
1082:
1083: dbms_lob.writeappend(l_xml, length(' '), ' ');

Line 1080: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);

1076: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1077: dbms_xmlgen.closecontext(qryctx1);
1078: IF (dbms_lob.getlength(xmlresult1) > 0) THEN
1079: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
1080: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
1081: END IF;
1082:
1083: dbms_lob.writeappend(l_xml, length(' '), ' ');
1084: ELSE

Line 1083: dbms_lob.writeappend(l_xml, length(' '), ' ');

1079: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
1080: dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, dbms_lob.getlength(l_xml), l_resultOffset +1);
1081: END IF;
1082:
1083: dbms_lob.writeappend(l_xml, length(' '), ' ');
1084: ELSE
1085: ---- 4429787 : replaced variables with col names
1086: query1 := 'SELECT ' || TO_CHAR(p_person_id) || ' person_id, er.full_name employee_name, employee_number '
1087: || ' employee_number, '|| to_char(p_emp_primary_org_id) || ' organization_id, emp_primary_org_name '

Line 1112: l_resultOffset := DBMS_LOB.INSTR(l_xml,'>');

1108: dbms_xmlgen.setRowsetTag(qryCtx1, 'LIST_G_PERSON');
1109: dbms_xmlgen.setRowTag(qryCtx1, 'G_PERSON');
1110: --dbms_xmlgen.setRowsetTag(qryCtx1, 'LIST_G_PERSON');
1111: l_xml := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1112: l_resultOffset := DBMS_LOB.INSTR(l_xml,'>');
1113: dbms_lob.write(l_xml, LENGTH(RPAD(' ', l_resultOffset, ' ')), 1, RPAD(' ', l_resultOffset, ' '));
1114: -- dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, 1, l_resultOffset +1);
1115: dbms_xmlgen.closecontext(qryctx1);
1116: END IF;

Line 1113: dbms_lob.write(l_xml, LENGTH(RPAD(' ', l_resultOffset, ' ')), 1, RPAD(' ', l_resultOffset, ' '));

1109: dbms_xmlgen.setRowTag(qryCtx1, 'G_PERSON');
1110: --dbms_xmlgen.setRowsetTag(qryCtx1, 'LIST_G_PERSON');
1111: l_xml := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1112: l_resultOffset := DBMS_LOB.INSTR(l_xml,'>');
1113: dbms_lob.write(l_xml, LENGTH(RPAD(' ', l_resultOffset, ' ')), 1, RPAD(' ', l_resultOffset, ' '));
1114: -- dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, 1, l_resultOffset +1);
1115: dbms_xmlgen.closecontext(qryctx1);
1116: END IF;
1117:

Line 1114: -- dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, 1, l_resultOffset +1);

1110: --dbms_xmlgen.setRowsetTag(qryCtx1, 'LIST_G_PERSON');
1111: l_xml := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1112: l_resultOffset := DBMS_LOB.INSTR(l_xml,'>');
1113: dbms_lob.write(l_xml, LENGTH(RPAD(' ', l_resultOffset, ' ')), 1, RPAD(' ', l_resultOffset, ' '));
1114: -- dbms_lob.copy(l_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, 1, l_resultOffset +1);
1115: dbms_xmlgen.closecontext(qryctx1);
1116: END IF;
1117:
1118: RETURN l_xml;

Line 1372: l_document_length := DBMS_LOB.getlength(l_document);

1368:
1369: l_file_name := 'PSP_ER_' || l_item_key || '.pdf' ; -- Bug 7229792
1370:
1371: hr_utility.trace('LD Debug l_pdf_file_id = '||l_pdf_file_id);
1372: l_document_length := DBMS_LOB.getlength(l_document);
1373: DBMS_LOB.copy(p_document, l_document, l_document_length, 1, 1);
1374: p_document_type:='application/pdf; name='|| l_file_name; -- Bug 7229792
1375:
1376: EXCEPTION

Line 1373: DBMS_LOB.copy(p_document, l_document, l_document_length, 1, 1);

1369: l_file_name := 'PSP_ER_' || l_item_key || '.pdf' ; -- Bug 7229792
1370:
1371: hr_utility.trace('LD Debug l_pdf_file_id = '||l_pdf_file_id);
1372: l_document_length := DBMS_LOB.getlength(l_document);
1373: DBMS_LOB.copy(p_document, l_document, l_document_length, 1, 1);
1374: p_document_type:='application/pdf; name='|| l_file_name; -- Bug 7229792
1375:
1376: EXCEPTION
1377: WHEN OTHERS THEN