APPS.CSM_HTML5_PKG dependencies on DBMS_XMLGEN

Line 157: qrycontext DBMS_XMLGEN.ctxHandle;

153: )
154: AS
155: l_QUERY_TEXT1 VARCHAR2(1000);
156: l_xml CLOB;
157: qrycontext DBMS_XMLGEN.ctxHandle;
158: BEGIN
159: /* Notes:
160: ======
161: 1. getXml fails when chr(31) or chr(0) is encountered in any of the column data

Line 174: qrycontext := DBMS_XMLGEN.newcontext(l_QUERY_TEXT1) ;

170: p_TABLE_NAME ||
171: ' WHERE ' || p_pk_name || ' = :PK_VALUE';
172:
173: --Execute the SQL query
174: qrycontext := DBMS_XMLGEN.newcontext(l_QUERY_TEXT1) ;
175: DBMS_XMLGEN.setBindValue(qrycontext, 'PK_VALUE', p_pk_value);
176: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
177:
178: l_xml := DBMS_XMLGEN.getxml (qrycontext);

Line 175: DBMS_XMLGEN.setBindValue(qrycontext, 'PK_VALUE', p_pk_value);

171: ' WHERE ' || p_pk_name || ' = :PK_VALUE';
172:
173: --Execute the SQL query
174: qrycontext := DBMS_XMLGEN.newcontext(l_QUERY_TEXT1) ;
175: DBMS_XMLGEN.setBindValue(qrycontext, 'PK_VALUE', p_pk_value);
176: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
177:
178: l_xml := DBMS_XMLGEN.getxml (qrycontext);
179: dbms_xmlgen.closeContext(qrycontext);

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

172:
173: --Execute the SQL query
174: qrycontext := DBMS_XMLGEN.newcontext(l_QUERY_TEXT1) ;
175: DBMS_XMLGEN.setBindValue(qrycontext, 'PK_VALUE', p_pk_value);
176: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
177:
178: l_xml := DBMS_XMLGEN.getxml (qrycontext);
179: dbms_xmlgen.closeContext(qrycontext);
180: x_XML_PAYLOAD := l_xml;

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

174: qrycontext := DBMS_XMLGEN.newcontext(l_QUERY_TEXT1) ;
175: DBMS_XMLGEN.setBindValue(qrycontext, 'PK_VALUE', p_pk_value);
176: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
177:
178: l_xml := DBMS_XMLGEN.getxml (qrycontext);
179: dbms_xmlgen.closeContext(qrycontext);
180: x_XML_PAYLOAD := l_xml;
181:
182: EXCEPTION WHEN OTHERS THEN

Line 179: dbms_xmlgen.closeContext(qrycontext);

175: DBMS_XMLGEN.setBindValue(qrycontext, 'PK_VALUE', p_pk_value);
176: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
177:
178: l_xml := DBMS_XMLGEN.getxml (qrycontext);
179: dbms_xmlgen.closeContext(qrycontext);
180: x_XML_PAYLOAD := l_xml;
181:
182: EXCEPTION WHEN OTHERS THEN
183: CSM_UTIL_PKG.LOG('Exception for Query:'||l_QUERY_TEXT1, 'CSM_HTML5_PKG.GET_XML_PAYLOAD', FND_LOG.LEVEL_PROCEDURE);