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

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

4459: | NOTES:
4460: |
4461: | XML generation from PLSQL is evolving rapidly.
4462: |
4463: | The code below uses DBMS_XMLQuery() to generate XML
4464: | from a SELECT statement.
4465: |
4466: | DBMS_XMLQuery() uses Java code internally, and is slow.
4467: |

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

Line 4488: l_ctx DBMS_XMLQuery.ctxType;

4484: IS
4485: l_module_name VARCHAR2(200) := G_PKG_NAME || '.getXMLClob';
4486: l_xml_clob CLOB := NULL;
4487:
4488: l_ctx DBMS_XMLQuery.ctxType;
4489: l_sql VARCHAR2(2000);
4490: l_sqlcode NUMBER;
4491: l_sqlerrm VARCHAR2(300);
4492:

Line 4502: * Replace DBMS_XMLQuery with DBMS_XMLGEN or SQLX

4498: END IF;
4499: /*
4500: * Note:
4501: *
4502: * Replace DBMS_XMLQuery with DBMS_XMLGEN or SQLX
4503: * when Oracle 9i is minimum requirement in tech
4504: * stack (see notes above).
4505: */
4506:

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

4514: || 'FROM IBY_PAY_INSTRUCTIONS_ALL '
4515: || 'WHERE payment_instruction_id = :p_ins_id '
4516: || 'AND payment_instruction_status <> :p_ins_status';
4517:
4518: l_ctx := DBMS_XMLQuery.newContext(l_sql);
4519: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_id', p_pay_instruction_id);
4520: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_status', p_instruction_status);
4521: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
4522:

Line 4519: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_id', p_pay_instruction_id);

4515: || 'WHERE payment_instruction_id = :p_ins_id '
4516: || 'AND payment_instruction_status <> :p_ins_status';
4517:
4518: l_ctx := DBMS_XMLQuery.newContext(l_sql);
4519: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_id', p_pay_instruction_id);
4520: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_status', p_instruction_status);
4521: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
4522:
4523: /* raise an exception if no rows were found */

Line 4520: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_status', p_instruction_status);

4516: || 'AND payment_instruction_status <> :p_ins_status';
4517:
4518: l_ctx := DBMS_XMLQuery.newContext(l_sql);
4519: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_id', p_pay_instruction_id);
4520: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_status', p_instruction_status);
4521: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
4522:
4523: /* raise an exception if no rows were found */
4524: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);

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

4517:
4518: l_ctx := DBMS_XMLQuery.newContext(l_sql);
4519: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_id', p_pay_instruction_id);
4520: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_status', p_instruction_status);
4521: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
4522:
4523: /* raise an exception if no rows were found */
4524: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
4525: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);

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

4520: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_status', p_instruction_status);
4521: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
4522:
4523: /* raise an exception if no rows were found */
4524: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
4525: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
4526: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
4527:
4528: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);

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

4521: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
4522:
4523: /* raise an exception if no rows were found */
4524: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
4525: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
4526: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
4527:
4528: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
4529: DBMS_XMLQuery.closeContext(l_ctx);

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

4522:
4523: /* raise an exception if no rows were found */
4524: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
4525: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
4526: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
4527:
4528: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
4529: DBMS_XMLQuery.closeContext(l_ctx);
4530:

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

4524: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
4525: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
4526: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
4527:
4528: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
4529: DBMS_XMLQuery.closeContext(l_ctx);
4530:
4531: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4532: print_debuginfo(l_module_name, 'EXIT');

Line 4529: DBMS_XMLQuery.closeContext(l_ctx);

4525: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
4526: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
4527:
4528: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
4529: DBMS_XMLQuery.closeContext(l_ctx);
4530:
4531: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4532: print_debuginfo(l_module_name, 'EXIT');
4533:

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

4537: EXCEPTION
4538:
4539: WHEN OTHERS THEN
4540:
4541: DBMS_XMLQuery.getExceptionContent(l_ctx, l_sqlcode, l_sqlerrm);
4542: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4543: print_debuginfo(l_module_name, 'SQL code: ' || l_sqlcode);
4544: print_debuginfo(l_module_name, 'SQL err msg: '|| l_sqlerrm);
4545: