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

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

317:
318: -- LOG_MESSAGE(x_stmt);
319:
320: -- B7481907 Rajesh Patangya starts
321: DBMS_LOB.createtemporary(temp_clob, TRUE);
322: DBMS_LOB.createtemporary(result1, TRUE);
323:
324: qryctx := dbms_xmlgen.newcontext(x_stmt);
325:

Line 322: DBMS_LOB.createtemporary(result1, TRUE);

318: -- LOG_MESSAGE(x_stmt);
319:
320: -- B7481907 Rajesh Patangya starts
321: DBMS_LOB.createtemporary(temp_clob, TRUE);
322: DBMS_LOB.createtemporary(result1, TRUE);
323:
324: qryctx := dbms_xmlgen.newcontext(x_stmt);
325:
326: -- generate XML data

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

324: qryctx := dbms_xmlgen.newcontext(x_stmt);
325:
326: -- generate XML data
327: DBMS_XMLGEN.getXML (qryctx, temp_clob, DBMS_XMLGEN.none);
328: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
329: pattern => '>',
330: offset => 1,
331: nth => 1);
332: LOG_MESSAGE('l_offset - '||l_offset);

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

331: nth => 1);
332: LOG_MESSAGE('l_offset - '||l_offset);
333:
334: -- Remove the header
335: DBMS_LOB.erase (temp_clob, l_offset,1);
336:
337: -- The following line of code ensures that XML data
338: -- generated here uses the right encoding
339: DBMS_LOB.writeappend (result1, length(l_xml_header), l_xml_header);

Line 339: DBMS_LOB.writeappend (result1, length(l_xml_header), l_xml_header);

335: DBMS_LOB.erase (temp_clob, l_offset,1);
336:
337: -- The following line of code ensures that XML data
338: -- generated here uses the right encoding
339: DBMS_LOB.writeappend (result1, length(l_xml_header), l_xml_header);
340:
341: -- Append the rest to xml output
342: DBMS_LOB.append (result1, temp_clob);
343:

Line 342: DBMS_LOB.append (result1, temp_clob);

338: -- generated here uses the right encoding
339: DBMS_LOB.writeappend (result1, length(l_xml_header), l_xml_header);
340:
341: -- Append the rest to xml output
342: DBMS_LOB.append (result1, temp_clob);
343:
344: -- close context and free memory
345: DBMS_XMLGEN.closeContext(qryctx);
346: DBMS_LOB.FREETEMPORARY (temp_clob);

Line 346: DBMS_LOB.FREETEMPORARY (temp_clob);

342: DBMS_LOB.append (result1, temp_clob);
343:
344: -- close context and free memory
345: DBMS_XMLGEN.closeContext(qryctx);
346: DBMS_LOB.FREETEMPORARY (temp_clob);
347: -- B7481907 Rajesh Patangya Ends
348:
349: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
350: EXECUTE IMMEDIATE seq_stmt INTO resdisp_rpt_id ;

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

528:
529: LOG_MESSAGE(x_stmt1);
530:
531: -- B7481907 Rajesh Patangya starts
532: DBMS_LOB.createtemporary(temp_clob, TRUE);
533: DBMS_LOB.createtemporary(result1, TRUE);
534:
535: qryctx := dbms_xmlgen.newcontext(x_stmt1);
536:

Line 533: DBMS_LOB.createtemporary(result1, TRUE);

529: LOG_MESSAGE(x_stmt1);
530:
531: -- B7481907 Rajesh Patangya starts
532: DBMS_LOB.createtemporary(temp_clob, TRUE);
533: DBMS_LOB.createtemporary(result1, TRUE);
534:
535: qryctx := dbms_xmlgen.newcontext(x_stmt1);
536:
537: -- generate XML data

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

535: qryctx := dbms_xmlgen.newcontext(x_stmt1);
536:
537: -- generate XML data
538: DBMS_XMLGEN.getXML (qryctx, temp_clob, DBMS_XMLGEN.none);
539: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
540: pattern => '>',
541: offset => 1,
542: nth => 1);
543: LOG_MESSAGE('l_offset - '||l_offset);

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

542: nth => 1);
543: LOG_MESSAGE('l_offset - '||l_offset);
544:
545: -- Remove the header
546: DBMS_LOB.erase (temp_clob, l_offset,1);
547:
548: -- The following line of code ensures that XML data
549: -- generated here uses the right encoding
550: DBMS_LOB.writeappend (result1, length(l_xml_header), l_xml_header);

Line 550: DBMS_LOB.writeappend (result1, length(l_xml_header), l_xml_header);

546: DBMS_LOB.erase (temp_clob, l_offset,1);
547:
548: -- The following line of code ensures that XML data
549: -- generated here uses the right encoding
550: DBMS_LOB.writeappend (result1, length(l_xml_header), l_xml_header);
551:
552: -- Append the rest to xml output
553: DBMS_LOB.append (result1, temp_clob);
554:

Line 553: DBMS_LOB.append (result1, temp_clob);

549: -- generated here uses the right encoding
550: DBMS_LOB.writeappend (result1, length(l_xml_header), l_xml_header);
551:
552: -- Append the rest to xml output
553: DBMS_LOB.append (result1, temp_clob);
554:
555: -- close context and free memory
556: DBMS_XMLGEN.closeContext(qryctx);
557: DBMS_LOB.FREETEMPORARY (temp_clob);

Line 557: DBMS_LOB.FREETEMPORARY (temp_clob);

553: DBMS_LOB.append (result1, temp_clob);
554:
555: -- close context and free memory
556: DBMS_XMLGEN.closeContext(qryctx);
557: DBMS_LOB.FREETEMPORARY (temp_clob);
558: -- B7481907 Rajesh Patangya Ends
559:
560: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
561: EXECUTE IMMEDIATE seq_stmt INTO resdisp_rpt_id ;

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

884: FROM GMP_RESDISP_XML_TEMP
885: WHERE RESDISP_XML_RPT_ID = p_sequence_num;
886:
887: l_limit:= 1;
888: l_len := DBMS_LOB.GETLENGTH (l_file);
889: -- log_message (' l_len - '||l_len);
890:
891: LOOP
892: IF l_len > l_limit THEN

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

889: -- log_message (' l_len - '||l_len);
890:
891: LOOP
892: IF l_len > l_limit THEN
893: --BUG 6646373 DBMS_LOB.SUBSTR was failing for multi byte character as l_file being CLOB type variable.
894: --Introduced another clob variable m_file and after trimming it assigned to the varchar type variable.
895: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);
896: M_FILE := DBMS_LOB.SUBSTR (l_file,100,l_limit);
897: file_varchar2:=trim(M_FILE);

Line 895: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);

891: LOOP
892: IF l_len > l_limit THEN
893: --BUG 6646373 DBMS_LOB.SUBSTR was failing for multi byte character as l_file being CLOB type variable.
894: --Introduced another clob variable m_file and after trimming it assigned to the varchar type variable.
895: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);
896: M_FILE := DBMS_LOB.SUBSTR (l_file,100,l_limit);
897: file_varchar2:=trim(M_FILE);
898: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
899: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);

Line 896: M_FILE := DBMS_LOB.SUBSTR (l_file,100,l_limit);

892: IF l_len > l_limit THEN
893: --BUG 6646373 DBMS_LOB.SUBSTR was failing for multi byte character as l_file being CLOB type variable.
894: --Introduced another clob variable m_file and after trimming it assigned to the varchar type variable.
895: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);
896: M_FILE := DBMS_LOB.SUBSTR (l_file,100,l_limit);
897: file_varchar2:=trim(M_FILE);
898: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
899: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
900: file_varchar2 := NULL;

Line 904: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);

900: file_varchar2 := NULL;
901: m_file :=NULL;
902: l_limit:= l_limit + 100;
903: ELSE
904: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);
905: M_FILE := DBMS_LOB.SUBSTR (l_file,100,l_limit);
906: file_varchar2:=trim(M_FILE);
907: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
908: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);

Line 905: M_FILE := DBMS_LOB.SUBSTR (l_file,100,l_limit);

901: m_file :=NULL;
902: l_limit:= l_limit + 100;
903: ELSE
904: -- file_varchar2 := DBMS_LOB.SUBSTR (l_file,100,l_limit);
905: M_FILE := DBMS_LOB.SUBSTR (l_file,100,l_limit);
906: file_varchar2:=trim(M_FILE);
907: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
908: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
909: file_varchar2 := NULL;