APPS.CSM_SR_EVENT_PKG dependencies on DBMS_LOB

Line 1705: IF DBMS_LOB.GETLENGTH(l_xml) > 0 THEN

1701: qrycontext := DBMS_XMLGEN.newcontext(l_SQL_TEXT) ;
1702:
1703: l_xml := DBMS_XMLGEN.getxml (qrycontext);
1704:
1705: IF DBMS_LOB.GETLENGTH(l_xml) > 0 THEN
1706: --Convert the XML output into BLOB and store it in the DB
1707: dbms_lob.createtemporary(l_xml_blob,TRUE);
1708: DBMS_LOB.convertToBlob(l_xml_blob,l_xml,DBMS_LOB.LOBMAXSIZE,
1709: l_dest_offset,l_src_offset,DBMS_LOB.default_csid,l_language,l_warning);

Line 1707: dbms_lob.createtemporary(l_xml_blob,TRUE);

1703: l_xml := DBMS_XMLGEN.getxml (qrycontext);
1704:
1705: IF DBMS_LOB.GETLENGTH(l_xml) > 0 THEN
1706: --Convert the XML output into BLOB and store it in the DB
1707: dbms_lob.createtemporary(l_xml_blob,TRUE);
1708: DBMS_LOB.convertToBlob(l_xml_blob,l_xml,DBMS_LOB.LOBMAXSIZE,
1709: l_dest_offset,l_src_offset,DBMS_LOB.default_csid,l_language,l_warning);
1710:
1711: CSM_QUERY_PKG.INSERT_RESULT

Line 1708: DBMS_LOB.convertToBlob(l_xml_blob,l_xml,DBMS_LOB.LOBMAXSIZE,

1704:
1705: IF DBMS_LOB.GETLENGTH(l_xml) > 0 THEN
1706: --Convert the XML output into BLOB and store it in the DB
1707: dbms_lob.createtemporary(l_xml_blob,TRUE);
1708: DBMS_LOB.convertToBlob(l_xml_blob,l_xml,DBMS_LOB.LOBMAXSIZE,
1709: l_dest_offset,l_src_offset,DBMS_LOB.default_csid,l_language,l_warning);
1710:
1711: CSM_QUERY_PKG.INSERT_RESULT
1712: ( p_USER_ID => l_USER_ID,

Line 1709: l_dest_offset,l_src_offset,DBMS_LOB.default_csid,l_language,l_warning);

1705: IF DBMS_LOB.GETLENGTH(l_xml) > 0 THEN
1706: --Convert the XML output into BLOB and store it in the DB
1707: dbms_lob.createtemporary(l_xml_blob,TRUE);
1708: DBMS_LOB.convertToBlob(l_xml_blob,l_xml,DBMS_LOB.LOBMAXSIZE,
1709: l_dest_offset,l_src_offset,DBMS_LOB.default_csid,l_language,l_warning);
1710:
1711: CSM_QUERY_PKG.INSERT_RESULT
1712: ( p_USER_ID => l_USER_ID,
1713: p_QUERY_ID => l_QUERY_ID,