APPS.IBY_ASSIGN_PUB dependencies on DBMS_XMLQUERY

Line 1814: l_ctx DBMS_XMLQuery.ctxType;

1810: IS
1811: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.getXMLClob';
1812: l_xml_clob CLOB := NULL;
1813:
1814: l_ctx DBMS_XMLQuery.ctxType;
1815: l_sql VARCHAR2(2000);
1816: l_sqlcode NUMBER;
1817: l_sqlerrm VARCHAR2(300);
1818:

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

1838: || 'WHERE payment_service_request_id = :payreq_id '
1839: || 'AND (internal_bank_account_id IS NULL '
1840: || 'OR payment_profile_id IS NULL)';
1841:
1842: l_ctx := DBMS_XMLQuery.newContext(l_sql);
1843: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
1844: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
1845:
1846: /* raise an exception if no rows were found */

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

1839: || 'AND (internal_bank_account_id IS NULL '
1840: || 'OR payment_profile_id IS NULL)';
1841:
1842: l_ctx := DBMS_XMLQuery.newContext(l_sql);
1843: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
1844: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
1845:
1846: /* raise an exception if no rows were found */
1847: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);

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

1840: || 'OR payment_profile_id IS NULL)';
1841:
1842: l_ctx := DBMS_XMLQuery.newContext(l_sql);
1843: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
1844: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
1845:
1846: /* raise an exception if no rows were found */
1847: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
1848: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);

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

1843: DBMS_XMLQuery.setBindValue(l_ctx, 'payreq_id', p_payreq_id);
1844: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
1845:
1846: /* raise an exception if no rows were found */
1847: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
1848: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
1849: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
1850:
1851: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);

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

1844: DBMS_XMLQuery.useNullAttributeIndicator(l_ctx, TRUE);
1845:
1846: /* raise an exception if no rows were found */
1847: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
1848: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
1849: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
1850:
1851: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
1852: DBMS_XMLQuery.closeContext(l_ctx);

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

1845:
1846: /* raise an exception if no rows were found */
1847: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
1848: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
1849: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
1850:
1851: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
1852: DBMS_XMLQuery.closeContext(l_ctx);
1853:

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

1847: DBMS_XMLQuery.setRaiseException(l_ctx, TRUE);
1848: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
1849: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
1850:
1851: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
1852: DBMS_XMLQuery.closeContext(l_ctx);
1853:
1854: print_debuginfo(l_module_name, 'EXIT');
1855:

Line 1852: DBMS_XMLQuery.closeContext(l_ctx);

1848: DBMS_XMLQuery.setRaiseNoRowsException(l_ctx, TRUE);
1849: DBMS_XMLQuery.propagateOriginalException(l_ctx, TRUE);
1850:
1851: l_xml_clob := DBMS_XMLQuery.getXML(l_ctx);
1852: DBMS_XMLQuery.closeContext(l_ctx);
1853:
1854: print_debuginfo(l_module_name, 'EXIT');
1855:
1856: RETURN l_xml_clob;

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

1858: EXCEPTION
1859:
1860: WHEN OTHERS THEN
1861:
1862: DBMS_XMLQuery.getExceptionContent(l_ctx, l_sqlcode, l_sqlerrm);
1863: print_debuginfo(l_module_name, 'SQL code: ' || l_sqlcode);
1864: print_debuginfo(l_module_name, 'SQL err msg: '|| l_sqlerrm);
1865:
1866: /*