APPS.CSM_QUERY_PKG dependencies on DBMS_XMLGEN

Line 876: qrycontext DBMS_XMLGEN.ctxHandle;

872: l_xml_blob BLOB;
873: l_more BOOLEAN := TRUE;
874: l_query_using VARCHAR2(4000);
875: rows_processed INTEGER;
876: qrycontext DBMS_XMLGEN.ctxHandle;
877: l_instance_id NUMBER;
878: l_dest_offset NUMBER := 1;
879: l_Src_offset NUMBER := 1;
880: l_language NUMBER := 0;

Line 949: qrycontext := DBMS_XMLGEN.newcontext(l_QUERY_TEXT1 || l_QUERY_TEXT2) ;

945: IF (UPPER(l_QUERY_TYPE) ='SQL' OR UPPER(l_QUERY_TYPE) ='PROCEDURE') THEN
946:
947: IF UPPER(l_QUERY_TYPE) = 'SQL' THEN
948:
949: qrycontext := DBMS_XMLGEN.newcontext(l_QUERY_TEXT1 || l_QUERY_TEXT2) ;
950:
951: FOR l_variable_rec IN c_get_variables(p_USER_ID,p_QUERY_ID,p_INSTANCE_ID)
952: LOOP
953: IF UPPER(l_variable_rec.VARIABLE_TYPE) = 'DATE' THEN

Line 954: DBMS_XMLGEN.setbindvalue (qrycontext, l_variable_rec.VARIABLE_ID, l_variable_rec.VARIABLE_VALUE_DATE);

950:
951: FOR l_variable_rec IN c_get_variables(p_USER_ID,p_QUERY_ID,p_INSTANCE_ID)
952: LOOP
953: IF UPPER(l_variable_rec.VARIABLE_TYPE) = 'DATE' THEN
954: DBMS_XMLGEN.setbindvalue (qrycontext, l_variable_rec.VARIABLE_ID, l_variable_rec.VARIABLE_VALUE_DATE);
955: ELSE
956: DBMS_XMLGEN.setbindvalue (qrycontext, l_variable_rec.VARIABLE_ID, l_variable_rec.VARIABLE_VALUE_CHAR);
957: END IF;
958: END LOOP;

Line 956: DBMS_XMLGEN.setbindvalue (qrycontext, l_variable_rec.VARIABLE_ID, l_variable_rec.VARIABLE_VALUE_CHAR);

952: LOOP
953: IF UPPER(l_variable_rec.VARIABLE_TYPE) = 'DATE' THEN
954: DBMS_XMLGEN.setbindvalue (qrycontext, l_variable_rec.VARIABLE_ID, l_variable_rec.VARIABLE_VALUE_DATE);
955: ELSE
956: DBMS_XMLGEN.setbindvalue (qrycontext, l_variable_rec.VARIABLE_ID, l_variable_rec.VARIABLE_VALUE_CHAR);
957: END IF;
958: END LOOP;
959: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
960: --Execute the SQL query

Line 959: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);

955: ELSE
956: DBMS_XMLGEN.setbindvalue (qrycontext, l_variable_rec.VARIABLE_ID, l_variable_rec.VARIABLE_VALUE_CHAR);
957: END IF;
958: END LOOP;
959: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
960: --Execute the SQL query
961: l_xml := DBMS_XMLGEN.getxml (qrycontext);
962:
963: END IF;

Line 961: l_xml := DBMS_XMLGEN.getxml (qrycontext);

957: END IF;
958: END LOOP;
959: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
960: --Execute the SQL query
961: l_xml := DBMS_XMLGEN.getxml (qrycontext);
962:
963: END IF;
964:
965: IF UPPER(l_QUERY_TYPE) ='PROCEDURE' THEN