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 8911: | The code below uses DBMS_XMLQuery() to generate XML

8907: | NOTES:
8908: |
8909: | XML generation from PLSQL is evolving rapidly.
8910: |
8911: | The code below uses DBMS_XMLQuery() to generate XML
8912: | from a SELECT statement.
8913: |
8914: | DBMS_XMLQuery() uses Java code internally, and is slow.
8915: |

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

Line 8935: l_ctx DBMS_XMLQuery.ctxType;

8931: IS
8932: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.getXMLClob';
8933: l_xml_clob CLOB := NULL;
8934:
8935: l_ctx DBMS_XMLQuery.ctxType;
8936: l_sql VARCHAR2(2000);
8937: l_sqlcode NUMBER;
8938: l_sqlerrm VARCHAR2(300);
8939:

Line 8947: * Replace DBMS_XMLQuery with DBMS_XMLGEN or SQLX

8943:
8944: /*
8945: * Note:
8946: *
8947: * Replace DBMS_XMLQuery with DBMS_XMLGEN or SQLX
8948: * when Oracle 9i is minimum requirement in tech
8949: * stack (see notes above).
8950: */
8951:

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

8968: || 'WHERE payment_service_request_id = :payreq_id '
8969: || 'AND document_status <> :doc_status '
8970: || 'AND payment_id IS NOT NULL';
8971:
8972: l_ctx := DBMS_XMLQuery.newContext(l_sql);
8973: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
8974: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_PAY_CREATED);
8975: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
8976:

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

8969: || 'AND document_status <> :doc_status '
8970: || 'AND payment_id IS NOT NULL';
8971:
8972: l_ctx := DBMS_XMLQuery.newContext(l_sql);
8973: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
8974: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_PAY_CREATED);
8975: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
8976:
8977: /* raise an exception if no rows were found */

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

8970: || 'AND payment_id IS NOT NULL';
8971:
8972: l_ctx := DBMS_XMLQuery.newContext(l_sql);
8973: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
8974: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_PAY_CREATED);
8975: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
8976:
8977: /* raise an exception if no rows were found */
8978: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);

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

8971:
8972: l_ctx := DBMS_XMLQuery.newContext(l_sql);
8973: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
8974: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_PAY_CREATED);
8975: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
8976:
8977: /* raise an exception if no rows were found */
8978: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
8979: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);

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

8974: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_PAY_CREATED);
8975: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
8976:
8977: /* raise an exception if no rows were found */
8978: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
8979: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
8980: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
8981:
8982: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);

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

8975: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
8976:
8977: /* raise an exception if no rows were found */
8978: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
8979: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
8980: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
8981:
8982: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
8983: DBMS_XMLQuery.closeContext(l_ctx);

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

8976:
8977: /* raise an exception if no rows were found */
8978: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
8979: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
8980: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
8981:
8982: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
8983: DBMS_XMLQuery.closeContext(l_ctx);
8984:

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

8978: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
8979: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
8980: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
8981:
8982: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
8983: DBMS_XMLQuery.closeContext(l_ctx);
8984:
8985: print_debuginfo(l_module_name, 'EXIT');
8986:

Line 8983: DBMS_XMLQuery.closeContext(l_ctx);

8979: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
8980: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
8981:
8982: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
8983: DBMS_XMLQuery.closeContext(l_ctx);
8984:
8985: print_debuginfo(l_module_name, 'EXIT');
8986:
8987: RETURN l_xml_clob;

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

8989: EXCEPTION
8990:
8991: WHEN OTHERS THEN
8992:
8993: DBMS_XMLQuery.getExceptionContent(l_ctx, l_sqlcode, l_sqlerrm);
8994: print_debuginfo(l_module_name, 'SQL code: ' || l_sqlcode);
8995: print_debuginfo(l_module_name, 'SQL err msg: '|| l_sqlerrm);
8996:
8997: /*