APPS.CSM_QUERY_PKG dependencies on DBMS_LOB

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

1012: RETURN;
1013: END IF;
1014: END IF;
1015:
1016: IF DBMS_LOB.GETLENGTH(l_xml) > 0 THEN
1017: --Convert the XML output into BLOB and store it in the DB
1018: dbms_lob.createtemporary(l_xml_blob,TRUE);
1019: DBMS_LOB.convertToBlob(l_xml_blob,l_xml,DBMS_LOB.LOBMAXSIZE,
1020: l_dest_offset,l_src_offset,DBMS_LOB.default_csid,l_language,l_warning);

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

1014: END IF;
1015:
1016: IF DBMS_LOB.GETLENGTH(l_xml) > 0 THEN
1017: --Convert the XML output into BLOB and store it in the DB
1018: dbms_lob.createtemporary(l_xml_blob,TRUE);
1019: DBMS_LOB.convertToBlob(l_xml_blob,l_xml,DBMS_LOB.LOBMAXSIZE,
1020: l_dest_offset,l_src_offset,DBMS_LOB.default_csid,l_language,l_warning);
1021: IF l_rs_access_id IS NOT NULL THEN
1022: UPDATE CSM_QUERY_RESULTS_ACC

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

1015:
1016: IF DBMS_LOB.GETLENGTH(l_xml) > 0 THEN
1017: --Convert the XML output into BLOB and store it in the DB
1018: dbms_lob.createtemporary(l_xml_blob,TRUE);
1019: DBMS_LOB.convertToBlob(l_xml_blob,l_xml,DBMS_LOB.LOBMAXSIZE,
1020: l_dest_offset,l_src_offset,DBMS_LOB.default_csid,l_language,l_warning);
1021: IF l_rs_access_id IS NOT NULL THEN
1022: UPDATE CSM_QUERY_RESULTS_ACC
1023: SET RESULT = l_xml_blob,

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

1016: IF DBMS_LOB.GETLENGTH(l_xml) > 0 THEN
1017: --Convert the XML output into BLOB and store it in the DB
1018: dbms_lob.createtemporary(l_xml_blob,TRUE);
1019: DBMS_LOB.convertToBlob(l_xml_blob,l_xml,DBMS_LOB.LOBMAXSIZE,
1020: l_dest_offset,l_src_offset,DBMS_LOB.default_csid,l_language,l_warning);
1021: IF l_rs_access_id IS NOT NULL THEN
1022: UPDATE CSM_QUERY_RESULTS_ACC
1023: SET RESULT = l_xml_blob,
1024: LAST_UPDATE_DATE = sysdate,