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_VALIDATIONSETS_PUB dependencies on DBMS_XMLQUERY

Line 5538: l_ctx DBMS_XMLQuery.ctxType;

5534: IS
5535: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.getXMLClob';
5536: l_xml_clob CLOB := NULL;
5537:
5538: l_ctx DBMS_XMLQuery.ctxType;
5539: l_sql VARCHAR2(2000);
5540: l_sqlcode NUMBER;
5541: l_sqlerrm VARCHAR2(300);
5542:

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

5561: || 'FROM iby_docs_payable_all '
5562: || 'WHERE payment_service_request_id = :payreq_id '
5563: || 'AND document_status <> :doc_status';
5564:
5565: l_ctx := DBMS_XMLQuery.newContext(l_sql);
5566: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
5567: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_VALIDATED);
5568: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
5569:

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

5562: || 'WHERE payment_service_request_id = :payreq_id '
5563: || 'AND document_status <> :doc_status';
5564:
5565: l_ctx := DBMS_XMLQuery.newContext(l_sql);
5566: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
5567: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_VALIDATED);
5568: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
5569:
5570: /* raise an exception if no rows were found */

Line 5567: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_VALIDATED);

5563: || 'AND document_status <> :doc_status';
5564:
5565: l_ctx := DBMS_XMLQuery.newContext(l_sql);
5566: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
5567: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_VALIDATED);
5568: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
5569:
5570: /* raise an exception if no rows were found */
5571: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);

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

5564:
5565: l_ctx := DBMS_XMLQuery.newContext(l_sql);
5566: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
5567: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_VALIDATED);
5568: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
5569:
5570: /* raise an exception if no rows were found */
5571: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
5572: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);

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

5567: DBMS_XMLQuery.setBindValue(l_ctx, 'doc_status', DOC_STATUS_VALIDATED);
5568: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
5569:
5570: /* raise an exception if no rows were found */
5571: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
5572: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
5573: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
5574:
5575: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);

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

5568: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
5569:
5570: /* raise an exception if no rows were found */
5571: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
5572: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
5573: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
5574:
5575: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
5576: DBMS_XMLQuery.closeContext(l_ctx);

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

5569:
5570: /* raise an exception if no rows were found */
5571: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
5572: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
5573: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
5574:
5575: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
5576: DBMS_XMLQuery.closeContext(l_ctx);
5577:

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

5571: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
5572: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
5573: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
5574:
5575: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
5576: DBMS_XMLQuery.closeContext(l_ctx);
5577:
5578: print_debuginfo(l_module_name, 'EXIT');
5579:

Line 5576: DBMS_XMLQuery.closeContext(l_ctx);

5572: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
5573: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
5574:
5575: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
5576: DBMS_XMLQuery.closeContext(l_ctx);
5577:
5578: print_debuginfo(l_module_name, 'EXIT');
5579:
5580: RETURN l_xml_clob;

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

5581:
5582: EXCEPTION
5583:
5584: WHEN OTHERS THEN
5585: DBMS_XMLQuery.getExceptionContent(l_ctx, l_sqlcode, l_sqlerrm);
5586: print_debuginfo(l_module_name, 'SQL code: ' || l_sqlcode);
5587: print_debuginfo(l_module_name, 'SQL err msg: '|| l_sqlerrm);
5588:
5589: /*