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

Line 1920: l_ctx DBMS_XMLQuery.ctxType;

1916: IS
1917: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.getXMLClob';
1918: l_xml_clob CLOB := NULL;
1919:
1920: l_ctx DBMS_XMLQuery.ctxType;
1921: l_sql VARCHAR2(2000);
1922: l_sqlcode NUMBER;
1923: l_sqlerrm VARCHAR2(300);
1924:

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

1946: || 'WHERE payment_service_request_id = :payreq_id '
1947: || 'AND (internal_bank_account_id IS NULL '
1948: || 'OR payment_profile_id IS NULL)';
1949:
1950: l_ctx := DBMS_XMLQuery.newContext(l_sql);
1951: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
1952: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
1953:
1954: /* raise an exception if no rows were found */

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

1947: || 'AND (internal_bank_account_id IS NULL '
1948: || 'OR payment_profile_id IS NULL)';
1949:
1950: l_ctx := DBMS_XMLQuery.newContext(l_sql);
1951: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
1952: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
1953:
1954: /* raise an exception if no rows were found */
1955: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);

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

1948: || 'OR payment_profile_id IS NULL)';
1949:
1950: l_ctx := DBMS_XMLQuery.newContext(l_sql);
1951: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
1952: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
1953:
1954: /* raise an exception if no rows were found */
1955: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
1956: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);

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

1951: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
1952: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
1953:
1954: /* raise an exception if no rows were found */
1955: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
1956: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
1957: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
1958:
1959: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);

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

1952: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
1953:
1954: /* raise an exception if no rows were found */
1955: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
1956: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
1957: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
1958:
1959: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
1960: DBMS_XMLQuery.closeContext(l_ctx);

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

1953:
1954: /* raise an exception if no rows were found */
1955: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
1956: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
1957: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
1958:
1959: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
1960: DBMS_XMLQuery.closeContext(l_ctx);
1961:

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

1955: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
1956: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
1957: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
1958:
1959: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
1960: DBMS_XMLQuery.closeContext(l_ctx);
1961:
1962: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1963: print_debuginfo(l_module_name, 'EXIT');

Line 1960: DBMS_XMLQuery.closeContext(l_ctx);

1956: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
1957: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
1958:
1959: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
1960: DBMS_XMLQuery.closeContext(l_ctx);
1961:
1962: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1963: print_debuginfo(l_module_name, 'EXIT');
1964: END IF;

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

1968: EXCEPTION
1969:
1970: WHEN OTHERS THEN
1971:
1972: DBMS_XMLQuery.getExceptionContent(l_ctx, l_sqlcode, l_sqlerrm);
1973:
1974: IF (G_LEVEL_STATEMENT >= G_CUR_RUNTIME_LEVEL) THEN
1975: print_debuginfo(l_module_name, 'SQL code: ' || l_sqlcode);
1976: END IF;