APPS.GMPPSRP dependencies on DBMS_LOB

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

702: -- DELETE FROM GMP_BUCKETED_XML_GTMP;
703: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, x_stmt);
704:
705: -- B7481907 Rajesh Patangya starts
706: DBMS_LOB.createtemporary(temp_clob, TRUE);
707: DBMS_LOB.createtemporary(result, TRUE);
708:
709: qryctx := dbms_xmlgen.newcontext(x_stmt);
710:

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

703: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, x_stmt);
704:
705: -- B7481907 Rajesh Patangya starts
706: DBMS_LOB.createtemporary(temp_clob, TRUE);
707: DBMS_LOB.createtemporary(result, TRUE);
708:
709: qryctx := dbms_xmlgen.newcontext(x_stmt);
710:
711: -- generate XML data

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

709: qryctx := dbms_xmlgen.newcontext(x_stmt);
710:
711: -- generate XML data
712: DBMS_XMLGEN.getXML (qryctx, temp_clob, DBMS_XMLGEN.none);
713: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
714: pattern => '>',
715: offset => 1,
716: nth => 1);
717: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_offset - '||l_offset);

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

716: nth => 1);
717: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_offset - '||l_offset);
718:
719: -- Remove the header
720: DBMS_LOB.erase (temp_clob, l_offset,1);
721:
722: -- The following line of code ensures that XML data
723: -- generated here uses the right encoding
724: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);

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

720: DBMS_LOB.erase (temp_clob, l_offset,1);
721:
722: -- The following line of code ensures that XML data
723: -- generated here uses the right encoding
724: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
725:
726: -- Append the rest to xml output
727: DBMS_LOB.append (result, temp_clob);
728:

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

723: -- generated here uses the right encoding
724: DBMS_LOB.writeappend (result, length(l_xml_header), l_xml_header);
725:
726: -- Append the rest to xml output
727: DBMS_LOB.append (result, temp_clob);
728:
729: -- close context and free memory
730: DBMS_XMLGEN.closeContext(qryctx);
731: DBMS_LOB.FREETEMPORARY (temp_clob);

Line 731: DBMS_LOB.FREETEMPORARY (temp_clob);

727: DBMS_LOB.append (result, temp_clob);
728:
729: -- close context and free memory
730: DBMS_XMLGEN.closeContext(qryctx);
731: DBMS_LOB.FREETEMPORARY (temp_clob);
732: -- B7481907 Rajesh Patangya Ends
733:
734: seq_stmt := 'select gmp_matl_rep_id_s.nextval from dual ';
735: EXECUTE IMMEDIATE seq_stmt INTO x_seq_num ;

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

1120: FROM gmp_bucketed_xml_temp
1121: WHERE bckt_matl_xml_id = p_sequence_num;
1122: l_limit:= 1;
1123:
1124: l_len := DBMS_LOB.GETLENGTH (l_file);
1125: LOOP
1126: IF l_len > l_limit THEN
1127: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1128: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);

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

1123:
1124: l_len := DBMS_LOB.GETLENGTH (l_file);
1125: LOOP
1126: IF l_len > l_limit THEN
1127: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1128: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);
1129: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
1130: file_varchar2 := NULL;
1131: l_limit:= l_limit + 10;

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

1129: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
1130: file_varchar2 := NULL;
1131: l_limit:= l_limit + 10;
1132: ELSE
1133: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
1134: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
1135: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
1136: file_varchar2 := NULL;
1137: EXIT;