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

Line 1376: DBMS_LOB.createtemporary(temp_clob, TRUE);

1372:
1373: -- INSERT INTO ns_debug (LONGVAL) values (G_common_pdr_stmt);
1374: gmp_debug_message('G_common_pdr_stmt ' );
1375:
1376: DBMS_LOB.createtemporary(temp_clob, TRUE);
1377: DBMS_LOB.createtemporary(result, TRUE);
1378:
1379: -- generate XML data
1380: temp_clob := DBMS_XMLQUERY.getXML (G_common_pdr_stmt ); -- Bug: 9265463

Line 1377: DBMS_LOB.createtemporary(result, TRUE);

1373: -- INSERT INTO ns_debug (LONGVAL) values (G_common_pdr_stmt);
1374: gmp_debug_message('G_common_pdr_stmt ' );
1375:
1376: DBMS_LOB.createtemporary(temp_clob, TRUE);
1377: DBMS_LOB.createtemporary(result, TRUE);
1378:
1379: -- generate XML data
1380: temp_clob := DBMS_XMLQUERY.getXML (G_common_pdr_stmt ); -- Bug: 9265463
1381: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

Line 1381: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

1377: DBMS_LOB.createtemporary(result, TRUE);
1378:
1379: -- generate XML data
1380: temp_clob := DBMS_XMLQUERY.getXML (G_common_pdr_stmt ); -- Bug: 9265463
1381: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1382: pattern => '>',
1383: offset => 1,
1384: nth => 1);
1385: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);

Line 1388: DBMS_LOB.erase (temp_clob, l_offset,1);

1384: nth => 1);
1385: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);
1386:
1387: -- Remove the header
1388: DBMS_LOB.erase (temp_clob, l_offset,1);
1389:
1390: -- The following line of code ensures that XML data
1391: -- generated here uses the right encoding
1392: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

Line 1392: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

1388: DBMS_LOB.erase (temp_clob, l_offset,1);
1389:
1390: -- The following line of code ensures that XML data
1391: -- generated here uses the right encoding
1392: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
1393:
1394: -- Append the rest to xml output
1395: DBMS_LOB.append (result, temp_clob);
1396:

Line 1395: DBMS_LOB.append (result, temp_clob);

1391: -- generated here uses the right encoding
1392: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
1393:
1394: -- Append the rest to xml output
1395: DBMS_LOB.append (result, temp_clob);
1396:
1397: -- close context and free memory
1398: -- DBMS_XMLGEN.closeContext(qryctx);
1399: DBMS_LOB.FREETEMPORARY (temp_clob);

Line 1399: DBMS_LOB.FREETEMPORARY (temp_clob);

1395: DBMS_LOB.append (result, temp_clob);
1396:
1397: -- close context and free memory
1398: -- DBMS_XMLGEN.closeContext(qryctx);
1399: DBMS_LOB.FREETEMPORARY (temp_clob);
1400: -- B7481907 Rajesh Patangya Ends
1401:
1402: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1403:

Line 1406: DBMS_LOB.FREETEMPORARY (result);

1402: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1403:
1404: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1405: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,1,x_seq_num );
1406: DBMS_LOB.FREETEMPORARY (result);
1407: ps_generate_output(x_seq_num,1);
1408:
1409: ELSE /* Not Combined PDR */
1410:

Line 1454: DBMS_LOB.createtemporary(temp_clob, TRUE);

1450: END IF;
1451: G_horiz_pdr_stmt := G_horiz_pdr_stmt || ' FROM DUAL ';
1452:
1453: -- B7481907 Rajesh Patangya starts
1454: DBMS_LOB.createtemporary(temp_clob, TRUE);
1455: DBMS_LOB.createtemporary(result, TRUE);
1456:
1457: -- generate XML data
1458: temp_clob := DBMS_XMLQUERY.getXML (G_horiz_pdr_stmt ); -- Bug: 9265463

Line 1455: DBMS_LOB.createtemporary(result, TRUE);

1451: G_horiz_pdr_stmt := G_horiz_pdr_stmt || ' FROM DUAL ';
1452:
1453: -- B7481907 Rajesh Patangya starts
1454: DBMS_LOB.createtemporary(temp_clob, TRUE);
1455: DBMS_LOB.createtemporary(result, TRUE);
1456:
1457: -- generate XML data
1458: temp_clob := DBMS_XMLQUERY.getXML (G_horiz_pdr_stmt ); -- Bug: 9265463
1459: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

Line 1459: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

1455: DBMS_LOB.createtemporary(result, TRUE);
1456:
1457: -- generate XML data
1458: temp_clob := DBMS_XMLQUERY.getXML (G_horiz_pdr_stmt ); -- Bug: 9265463
1459: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1460: pattern => '>',
1461: offset => 1,
1462: nth => 1);
1463: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);

Line 1466: DBMS_LOB.erase (temp_clob, l_offset,1);

1462: nth => 1);
1463: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);
1464:
1465: -- Remove the header
1466: DBMS_LOB.erase (temp_clob, l_offset,1);
1467:
1468: -- The following line of code ensures that XML data
1469: -- generated here uses the right encoding
1470: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

Line 1470: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

1466: DBMS_LOB.erase (temp_clob, l_offset,1);
1467:
1468: -- The following line of code ensures that XML data
1469: -- generated here uses the right encoding
1470: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
1471:
1472: -- Append the rest to xml output
1473: DBMS_LOB.append (result, temp_clob);
1474:

Line 1473: DBMS_LOB.append (result, temp_clob);

1469: -- generated here uses the right encoding
1470: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
1471:
1472: -- Append the rest to xml output
1473: DBMS_LOB.append (result, temp_clob);
1474:
1475: -- close context and free memory
1476: -- DBMS_XMLGEN.closeContext(qryctx);
1477: DBMS_LOB.FREETEMPORARY (temp_clob);

Line 1477: DBMS_LOB.FREETEMPORARY (temp_clob);

1473: DBMS_LOB.append (result, temp_clob);
1474:
1475: -- close context and free memory
1476: -- DBMS_XMLGEN.closeContext(qryctx);
1477: DBMS_LOB.FREETEMPORARY (temp_clob);
1478: -- B7481907 Rajesh Patangya Ends
1479:
1480: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1481:

Line 1484: DBMS_LOB.FREETEMPORARY (result);

1480: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1481:
1482: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1483: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,2,x_seq_num );
1484: DBMS_LOB.FREETEMPORARY (result);
1485: ps_generate_output(x_seq_num,2);
1486:
1487: -- INSERT INTO ns_debug (col3) values (G_horiz_pdr_stmt);
1488:

Line 1526: DBMS_LOB.createtemporary(temp_clob, TRUE);

1522: END IF;
1523: G_vert_pdr_stmt := G_vert_pdr_stmt || ' FROM DUAL ';
1524:
1525: -- B7481907 Rajesh Patangya starts
1526: DBMS_LOB.createtemporary(temp_clob, TRUE);
1527: DBMS_LOB.createtemporary(result, TRUE);
1528:
1529: -- generate XML data
1530: temp_clob := DBMS_XMLQUERY.getXML (G_vert_pdr_stmt ); -- Bug: 9265463

Line 1527: DBMS_LOB.createtemporary(result, TRUE);

1523: G_vert_pdr_stmt := G_vert_pdr_stmt || ' FROM DUAL ';
1524:
1525: -- B7481907 Rajesh Patangya starts
1526: DBMS_LOB.createtemporary(temp_clob, TRUE);
1527: DBMS_LOB.createtemporary(result, TRUE);
1528:
1529: -- generate XML data
1530: temp_clob := DBMS_XMLQUERY.getXML (G_vert_pdr_stmt ); -- Bug: 9265463
1531: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

Line 1531: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

1527: DBMS_LOB.createtemporary(result, TRUE);
1528:
1529: -- generate XML data
1530: temp_clob := DBMS_XMLQUERY.getXML (G_vert_pdr_stmt ); -- Bug: 9265463
1531: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1532: pattern => '>',
1533: offset => 1,
1534: nth => 1);
1535: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);

Line 1538: DBMS_LOB.erase (temp_clob, l_offset,1);

1534: nth => 1);
1535: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);
1536:
1537: -- Remove the header
1538: DBMS_LOB.erase (temp_clob, l_offset,1);
1539:
1540: -- The following line of code ensures that XML data
1541: -- generated here uses the right encoding
1542: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

Line 1542: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

1538: DBMS_LOB.erase (temp_clob, l_offset,1);
1539:
1540: -- The following line of code ensures that XML data
1541: -- generated here uses the right encoding
1542: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
1543:
1544: -- Append the rest to xml output
1545: DBMS_LOB.append (result, temp_clob);
1546:

Line 1545: DBMS_LOB.append (result, temp_clob);

1541: -- generated here uses the right encoding
1542: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
1543:
1544: -- Append the rest to xml output
1545: DBMS_LOB.append (result, temp_clob);
1546:
1547: -- close context and free memory
1548: -- DBMS_XMLGEN.closeContext(qryctx);
1549: DBMS_LOB.FREETEMPORARY (temp_clob);

Line 1549: DBMS_LOB.FREETEMPORARY (temp_clob);

1545: DBMS_LOB.append (result, temp_clob);
1546:
1547: -- close context and free memory
1548: -- DBMS_XMLGEN.closeContext(qryctx);
1549: DBMS_LOB.FREETEMPORARY (temp_clob);
1550: -- B7481907 Rajesh Patangya Ends
1551:
1552: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1553:

Line 1556: DBMS_LOB.FREETEMPORARY (result);

1552: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1553:
1554: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1555: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,3,x_seq_num );
1556: DBMS_LOB.FREETEMPORARY (result);
1557: ps_generate_output(x_seq_num,3);
1558:
1559: -- INSERT INTO ns_debug (col3) values (G_vert_pdr_stmt);
1560:

Line 1598: DBMS_LOB.createtemporary(temp_clob, TRUE);

1594: END IF;
1595: G_excep_pdr_stmt := G_excep_pdr_stmt || ' FROM DUAL ';
1596:
1597: -- B7481907 Rajesh Patangya starts
1598: DBMS_LOB.createtemporary(temp_clob, TRUE);
1599: DBMS_LOB.createtemporary(result, TRUE);
1600:
1601: -- generate XML data
1602: temp_clob := DBMS_XMLQUERY.getXML (G_excep_pdr_stmt ); -- Bug: 9265463

Line 1599: DBMS_LOB.createtemporary(result, TRUE);

1595: G_excep_pdr_stmt := G_excep_pdr_stmt || ' FROM DUAL ';
1596:
1597: -- B7481907 Rajesh Patangya starts
1598: DBMS_LOB.createtemporary(temp_clob, TRUE);
1599: DBMS_LOB.createtemporary(result, TRUE);
1600:
1601: -- generate XML data
1602: temp_clob := DBMS_XMLQUERY.getXML (G_excep_pdr_stmt ); -- Bug: 9265463
1603: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

Line 1603: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

1599: DBMS_LOB.createtemporary(result, TRUE);
1600:
1601: -- generate XML data
1602: temp_clob := DBMS_XMLQUERY.getXML (G_excep_pdr_stmt ); -- Bug: 9265463
1603: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1604: pattern => '>',
1605: offset => 1,
1606: nth => 1);
1607: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);

Line 1610: DBMS_LOB.erase (temp_clob, l_offset,1);

1606: nth => 1);
1607: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);
1608:
1609: -- Remove the header
1610: DBMS_LOB.erase (temp_clob, l_offset,1);
1611:
1612: -- The following line of code ensures that XML data
1613: -- generated here uses the right encoding
1614: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

Line 1614: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

1610: DBMS_LOB.erase (temp_clob, l_offset,1);
1611:
1612: -- The following line of code ensures that XML data
1613: -- generated here uses the right encoding
1614: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
1615:
1616: -- Append the rest to xml output
1617: DBMS_LOB.append (result, temp_clob);
1618:

Line 1617: DBMS_LOB.append (result, temp_clob);

1613: -- generated here uses the right encoding
1614: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
1615:
1616: -- Append the rest to xml output
1617: DBMS_LOB.append (result, temp_clob);
1618:
1619: -- close context and free memory
1620: -- DBMS_XMLGEN.closeContext(qryctx);
1621: DBMS_LOB.FREETEMPORARY (temp_clob);

Line 1621: DBMS_LOB.FREETEMPORARY (temp_clob);

1617: DBMS_LOB.append (result, temp_clob);
1618:
1619: -- close context and free memory
1620: -- DBMS_XMLGEN.closeContext(qryctx);
1621: DBMS_LOB.FREETEMPORARY (temp_clob);
1622: -- B7481907 Rajesh Patangya Ends
1623:
1624: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1625:

Line 1629: DBMS_LOB.FREETEMPORARY (result);

1625:
1626: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1627: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,4,x_seq_num );
1628: -- INSERT INTO temp_r1(xml_file, file_type, pdr_xml_id) VALUES(result,4,x_seq_num );
1629: DBMS_LOB.FREETEMPORARY (result);
1630: ps_generate_output(x_seq_num,4);
1631:
1632: -- INSERT INTO ns_debug (col3) values (G_excep_pdr_stmt);
1633:

Line 1671: DBMS_LOB.createtemporary(temp_clob, TRUE);

1667: END IF;
1668: G_act_pdr_stmt := G_act_pdr_stmt || ' FROM DUAL ';
1669:
1670: -- B7481907 Rajesh Patangya starts
1671: DBMS_LOB.createtemporary(temp_clob, TRUE);
1672: DBMS_LOB.createtemporary(result, TRUE);
1673:
1674: -- generate XML data
1675: temp_clob := DBMS_XMLQUERY.getXML (G_act_pdr_stmt ); -- Bug: 9265463

Line 1672: DBMS_LOB.createtemporary(result, TRUE);

1668: G_act_pdr_stmt := G_act_pdr_stmt || ' FROM DUAL ';
1669:
1670: -- B7481907 Rajesh Patangya starts
1671: DBMS_LOB.createtemporary(temp_clob, TRUE);
1672: DBMS_LOB.createtemporary(result, TRUE);
1673:
1674: -- generate XML data
1675: temp_clob := DBMS_XMLQUERY.getXML (G_act_pdr_stmt ); -- Bug: 9265463
1676: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

Line 1676: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,

1672: DBMS_LOB.createtemporary(result, TRUE);
1673:
1674: -- generate XML data
1675: temp_clob := DBMS_XMLQUERY.getXML (G_act_pdr_stmt ); -- Bug: 9265463
1676: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1677: pattern => '>',
1678: offset => 1,
1679: nth => 1);
1680: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);

Line 1683: DBMS_LOB.erase (temp_clob, l_offset,1);

1679: nth => 1);
1680: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_offset - '||l_offset);
1681:
1682: -- Remove the header
1683: DBMS_LOB.erase (temp_clob, l_offset,1);
1684:
1685: -- The following line of code ensures that XML data
1686: -- generated here uses the right encoding
1687: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

Line 1687: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

1683: DBMS_LOB.erase (temp_clob, l_offset,1);
1684:
1685: -- The following line of code ensures that XML data
1686: -- generated here uses the right encoding
1687: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
1688:
1689: -- Append the rest to xml output
1690: DBMS_LOB.append (result, temp_clob);
1691:

Line 1690: DBMS_LOB.append (result, temp_clob);

1686: -- generated here uses the right encoding
1687: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
1688:
1689: -- Append the rest to xml output
1690: DBMS_LOB.append (result, temp_clob);
1691:
1692: -- close context and free memory
1693: -- DBMS_XMLGEN.closeContext(qryctx);
1694: DBMS_LOB.FREETEMPORARY (temp_clob);

Line 1694: DBMS_LOB.FREETEMPORARY (temp_clob);

1690: DBMS_LOB.append (result, temp_clob);
1691:
1692: -- close context and free memory
1693: -- DBMS_XMLGEN.closeContext(qryctx);
1694: DBMS_LOB.FREETEMPORARY (temp_clob);
1695: -- B7481907 Rajesh Patangya Ends
1696:
1697: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1698:

Line 1701: DBMS_LOB.FREETEMPORARY (result);

1697: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
1698:
1699: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;
1700: INSERT INTO gmp_pdr_xml_temp(xml_file, file_type, pdr_xml_id) VALUES(result,5,x_seq_num );
1701: DBMS_LOB.FREETEMPORARY (result);
1702: ps_generate_output(x_seq_num,5);
1703:
1704: -- INSERT INTO ns_debug (col3) values (G_act_pdr_stmt);
1705:

Line 2011: l_len := DBMS_LOB.GETLENGTH (l_file);

2007: FROM gmp_pdr_xml_temp
2008: WHERE pdr_xml_id = p_sequence_num;
2009: l_limit:= 1;
2010: /* changed the Number from 10 to 15, becuase it is trimiing the First Standard Line */
2011: l_len := DBMS_LOB.GETLENGTH (l_file);
2012: gmp_debug_message('l_len :'||l_len );
2013:
2014: LOOP
2015: IF l_len > l_limit THEN

Line 2016: --BUG 6646373 DBMS_LOB.SUBSTR was failing for multi byte character as l_file being CLOB type variable.

2012: gmp_debug_message('l_len :'||l_len );
2013:
2014: LOOP
2015: IF l_len > l_limit THEN
2016: --BUG 6646373 DBMS_LOB.SUBSTR was failing for multi byte character as l_file being CLOB type variable.
2017: --Introduced another clob variable m_file and after trimming it assigned to the varchar type variable.
2018: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2019: M_FILE := DBMS_LOB.SUBSTR (l_file,1024,l_limit);
2020: -- Vpedarla 8605434

Line 2018: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);

2014: LOOP
2015: IF l_len > l_limit THEN
2016: --BUG 6646373 DBMS_LOB.SUBSTR was failing for multi byte character as l_file being CLOB type variable.
2017: --Introduced another clob variable m_file and after trimming it assigned to the varchar type variable.
2018: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2019: M_FILE := DBMS_LOB.SUBSTR (l_file,1024,l_limit);
2020: -- Vpedarla 8605434
2021: -- file_varchar2:=trim(M_FILE);
2022: file_varchar2:=M_FILE;

Line 2019: M_FILE := DBMS_LOB.SUBSTR (l_file,1024,l_limit);

2015: IF l_len > l_limit THEN
2016: --BUG 6646373 DBMS_LOB.SUBSTR was failing for multi byte character as l_file being CLOB type variable.
2017: --Introduced another clob variable m_file and after trimming it assigned to the varchar type variable.
2018: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2019: M_FILE := DBMS_LOB.SUBSTR (l_file,1024,l_limit);
2020: -- Vpedarla 8605434
2021: -- file_varchar2:=trim(M_FILE);
2022: file_varchar2:=M_FILE;
2023: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);

Line 2032: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);

2028: file_varchar2 := NULL;
2029: m_file :=NULL;
2030: l_limit:= l_limit + 1024;
2031: ELSE
2032: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2033: M_FILE := DBMS_LOB.SUBSTR (l_file,1024,l_limit);
2034: -- Vpedarla 8605434
2035: -- file_varchar2:=trim(M_FILE);
2036: file_varchar2:=M_FILE;

Line 2033: M_FILE := DBMS_LOB.SUBSTR (l_file,1024,l_limit);

2029: m_file :=NULL;
2030: l_limit:= l_limit + 1024;
2031: ELSE
2032: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2033: M_FILE := DBMS_LOB.SUBSTR (l_file,1024,l_limit);
2034: -- Vpedarla 8605434
2035: -- file_varchar2:=trim(M_FILE);
2036: file_varchar2:=M_FILE;
2037: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);