eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYGROUP_PUB dependencies on DBMS_XMLQUERY

Line 19229: | The code below uses DBMS_XMLQuery() to generate XML

19225: | NOTES:
19226: |
19227: | XML generation from PLSQL is evolving rapidly.
19228: |
19229: | The code below uses DBMS_XMLQuery() to generate XML
19230: | from a SELECT statement.
19231: |
19232: | DBMS_XMLQuery() uses Java code internally, and is slow.
19233: |

Line 19232: | DBMS_XMLQuery() uses Java code internally, and is slow.

Line 19253: l_ctx DBMS_XMLQuery.ctxType;

19249: IS
19250: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.getXMLClob';
19251: l_xml_clob CLOB := NULL;
19252:
19253: l_ctx DBMS_XMLQuery.ctxType;
19254: l_sql VARCHAR2(2000);
19255: l_sqlcode NUMBER;
19256: l_sqlerrm VARCHAR2(300);
19257:

Line 19266: * Replace DBMS_XMLQuery with DBMS_XMLGEN or SQLX

19262:
19263: /*
19264: * Note:
19265: *
19266: * Replace DBMS_XMLQuery with DBMS_XMLGEN or SQLX
19267: * when Oracle 9i is minimum requirement in tech
19268: * stack (see notes above).
19269: */
19270:

Line 19291: l_ctx := DBMS_XMLQuery.newContext(l_sql);

19287: || 'WHERE payment_service_request_id = :payreq_id '
19288: || 'AND document_status <> :doc_status '
19289: || 'AND payment_id IS NOT NULL';
19290:
19291: l_ctx := DBMS_XMLQuery.newContext(l_sql);
19292: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
19293: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_PAY_CREATED);
19294: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
19295:

Line 19292: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);

19288: || 'AND document_status <> :doc_status '
19289: || 'AND payment_id IS NOT NULL';
19290:
19291: l_ctx := DBMS_XMLQuery.newContext(l_sql);
19292: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
19293: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_PAY_CREATED);
19294: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
19295:
19296: /* raise an exception if no rows were found */

Line 19293: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_PAY_CREATED);

19289: || 'AND payment_id IS NOT NULL';
19290:
19291: l_ctx := DBMS_XMLQuery.newContext(l_sql);
19292: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
19293: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_PAY_CREATED);
19294: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
19295:
19296: /* raise an exception if no rows were found */
19297: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);

Line 19294: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);

19290:
19291: l_ctx := DBMS_XMLQuery.newContext(l_sql);
19292: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
19293: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_PAY_CREATED);
19294: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
19295:
19296: /* raise an exception if no rows were found */
19297: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
19298: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);

Line 19297: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);

19293: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_PAY_CREATED);
19294: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
19295:
19296: /* raise an exception if no rows were found */
19297: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
19298: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
19299: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
19300:
19301: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);

Line 19298: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);

19294: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
19295:
19296: /* raise an exception if no rows were found */
19297: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
19298: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
19299: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
19300:
19301: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
19302: DBMS_XMLQuery.closeContext(l_ctx);

Line 19299: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);

19295:
19296: /* raise an exception if no rows were found */
19297: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
19298: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
19299: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
19300:
19301: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
19302: DBMS_XMLQuery.closeContext(l_ctx);
19303: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 19301: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);

19297: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
19298: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
19299: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
19300:
19301: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
19302: DBMS_XMLQuery.closeContext(l_ctx);
19303: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
19304: print_debuginfo(l_module_name, 'EXIT');
19305: END IF;

Line 19302: DBMS_XMLQuery.closeContext(l_ctx);

19298: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
19299: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
19300:
19301: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
19302: DBMS_XMLQuery.closeContext(l_ctx);
19303: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
19304: print_debuginfo(l_module_name, 'EXIT');
19305: END IF;
19306:

Line 19313: DBMS_XMLQuery.getExceptionContent(l_ctx, l_sqlcode, l_sqlerrm);

19309: EXCEPTION
19310:
19311: WHEN OTHERS THEN
19312:
19313: DBMS_XMLQuery.getExceptionContent(l_ctx, l_sqlcode, l_sqlerrm);
19314: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
19315: print_debuginfo(l_module_name, 'SQL code: ' || l_sqlcode);
19316: print_debuginfo(l_module_name, 'SQL err msg: '|| l_sqlerrm);
19317: END IF;