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

3904: | NOTES:
3905: |
3906: | XML generation from PLSQL is evolving rapidly.
3907: |
3908: | The code below uses DBMS_XMLQuery() to generate XML
3909: | from a SELECT statement.
3910: |
3911: | DBMS_XMLQuery() uses Java code internally, and is slow.
3912: |

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

Line 3933: l_ctx DBMS_XMLQuery.ctxType;

3929: IS
3930: l_module_name VARCHAR2(200) := G_PKG_NAME || '.getXMLClob';
3931: l_xml_clob CLOB := NULL;
3932:
3933: l_ctx DBMS_XMLQuery.ctxType;
3934: l_sql VARCHAR2(2000);
3935: l_sqlcode NUMBER;
3936: l_sqlerrm VARCHAR2(300);
3937:

Line 3945: * Replace DBMS_XMLQuery with DBMS_XMLGEN or SQLX

3941:
3942: /*
3943: * Note:
3944: *
3945: * Replace DBMS_XMLQuery with DBMS_XMLGEN or SQLX
3946: * when Oracle 9i is minimum requirement in tech
3947: * stack (see notes above).
3948: */
3949:

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

3957: || 'FROM IBY_PAY_INSTRUCTIONS_ALL '
3958: || 'WHERE payment_instruction_id = :p_ins_id '
3959: || 'AND payment_instruction_status <> :p_ins_status';
3960:
3961: l_ctx := DBMS_XMLQuery.newContext(l_sql);
3962: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_id', p_pay_instruction_id);
3963: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_status', p_instruction_status);
3964: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
3965:

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

3958: || 'WHERE payment_instruction_id = :p_ins_id '
3959: || 'AND payment_instruction_status <> :p_ins_status';
3960:
3961: l_ctx := DBMS_XMLQuery.newContext(l_sql);
3962: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_id', p_pay_instruction_id);
3963: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_status', p_instruction_status);
3964: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
3965:
3966: /* raise an exception if no rows were found */

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

3959: || 'AND payment_instruction_status <> :p_ins_status';
3960:
3961: l_ctx := DBMS_XMLQuery.newContext(l_sql);
3962: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_id', p_pay_instruction_id);
3963: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_status', p_instruction_status);
3964: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
3965:
3966: /* raise an exception if no rows were found */
3967: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);

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

3960:
3961: l_ctx := DBMS_XMLQuery.newContext(l_sql);
3962: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_id', p_pay_instruction_id);
3963: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_status', p_instruction_status);
3964: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
3965:
3966: /* raise an exception if no rows were found */
3967: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
3968: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);

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

3963: DBMS_XMLQuery.setBindValue(l_ctx, 'p_ins_status', p_instruction_status);
3964: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
3965:
3966: /* raise an exception if no rows were found */
3967: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
3968: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
3969: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
3970:
3971: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);

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

3964: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
3965:
3966: /* raise an exception if no rows were found */
3967: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
3968: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
3969: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
3970:
3971: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
3972: DBMS_XMLQuery.closeContext(l_ctx);

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

3965:
3966: /* raise an exception if no rows were found */
3967: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
3968: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
3969: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
3970:
3971: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
3972: DBMS_XMLQuery.closeContext(l_ctx);
3973:

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

3967: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
3968: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
3969: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
3970:
3971: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
3972: DBMS_XMLQuery.closeContext(l_ctx);
3973:
3974: print_debuginfo(l_module_name, 'EXIT');
3975:

Line 3972: DBMS_XMLQuery.closeContext(l_ctx);

3968: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
3969: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
3970:
3971: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
3972: DBMS_XMLQuery.closeContext(l_ctx);
3973:
3974: print_debuginfo(l_module_name, 'EXIT');
3975:
3976: RETURN l_xml_clob;

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

3978: EXCEPTION
3979:
3980: WHEN OTHERS THEN
3981:
3982: DBMS_XMLQuery.getExceptionContent(l_ctx, l_sqlcode, l_sqlerrm);
3983: print_debuginfo(l_module_name, 'SQL code: ' || l_sqlcode);
3984: print_debuginfo(l_module_name, 'SQL err msg: '|| l_sqlerrm);
3985:
3986: /*