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.PON_FORMS_UTIL_PVT dependencies on DBMS_XMLQUERY

Line 1686: l_queryCtx DBMS_XMLquery.ctxType;

1682: ';
1683:
1684: l_xml_query Varchar2(31500);
1685: l_form_code Varchar2(30);
1686: l_queryCtx DBMS_XMLquery.ctxType;
1687:
1688: l_schemOffset Number;
1689: l_xmlTagOffset INTEGER;
1690: l_documentOffset BINARY_INTEGER;

Line 1725: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);

1721: x_xml_query := l_xml_query;
1722:
1723: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' GOT QUERY FORM SCHEMA ');
1724:
1725: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1726: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1727: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1728: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1729: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');

Line 1726: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name

1722:
1723: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' GOT QUERY FORM SCHEMA ');
1724:
1725: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1726: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1727: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1728: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1729: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');
1730: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);

Line 1727: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name

1723: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' GOT QUERY FORM SCHEMA ');
1724:
1725: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1726: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1727: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1728: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1729: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');
1730: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);
1731: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );

Line 1728: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);

1724:
1725: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1726: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1727: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1728: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1729: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');
1730: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);
1731: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );
1732:

Line 1729: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');

1725: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1726: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1727: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1728: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1729: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');
1730: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);
1731: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );
1732:
1733: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' STARTING SCHEMA GENERATION');

Line 1730: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);

1726: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1727: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1728: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1729: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');
1730: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);
1731: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );
1732:
1733: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' STARTING SCHEMA GENERATION');
1734:

Line 1731: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );

1727: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1728: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1729: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');
1730: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);
1731: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );
1732:
1733: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' STARTING SCHEMA GENERATION');
1734:
1735: p_schema:=DBMS_XMLquery.GETXML(l_queryCtx,2);

Line 1735: p_schema:=DBMS_XMLquery.GETXML(l_queryCtx,2);

1731: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );
1732:
1733: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' STARTING SCHEMA GENERATION');
1734:
1735: p_schema:=DBMS_XMLquery.GETXML(l_queryCtx,2);
1736:
1737: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' GOT SCHEMA ');
1738:
1739: g_mode := 'XML';

Line 1743: DBMS_XMLQUERY.closecontext(l_queryCtx);

1739: g_mode := 'XML';
1740:
1741: rollback to SAVEPOINT PON_XMLSCHEMA;
1742:
1743: DBMS_XMLQUERY.closecontext(l_queryCtx);
1744:
1745: l_schemOffset := DBMS_LOB.INSTR(p_schema,'')+12;
1746: DBMS_LOB.TRIM(p_schema,l_schemOffset);
1747:

Line 1780: DBMS_XMLquery.closecontext (l_queryCtx);

1776: l_err_msg := SUBSTR(SQLERRM, 1, 200);
1777: print_error_log(l_api_name, 'p_form_id = '||p_form_id||' SCHEMA GENERATION FAILED l_err_num = '||l_err_num||' l_err_msg = '||l_err_msg);
1778: p_result := 1;
1779: p_error := PON_AUCTION_PKG.getMessage ('PON_FM_SCHEMA_GENERATION_FAIL');
1780: DBMS_XMLquery.closecontext (l_queryCtx);
1781:
1782: End GENERATE_XMLSCHEMA;
1783:
1784:

Line 1803: l_queryCtx DBMS_XMLquery.ctxType;

1799: l_err_num NUMBER;
1800: l_err_msg VARCHAR2(200);
1801: l_xml_query Varchar2(31500);
1802: l_form_code Varchar2(30);
1803: l_queryCtx DBMS_XMLquery.ctxType;
1804:
1805: l_api_name CONSTANT VARCHAR2(30) := 'GENERATE_XML';
1806:
1807: Begin

Line 1838: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);

1834: end if;
1835:
1836: print_debug_log(l_api_name, 'Got Xml Query for GENERATE_XML p_form_id = '||p_form_id);
1837:
1838: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1839: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1840: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1841: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1842: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);

Line 1839: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name

1835:
1836: print_debug_log(l_api_name, 'Got Xml Query for GENERATE_XML p_form_id = '||p_form_id);
1837:
1838: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1839: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1840: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1841: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1842: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);
1843: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);

Line 1840: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name

1836: print_debug_log(l_api_name, 'Got Xml Query for GENERATE_XML p_form_id = '||p_form_id);
1837:
1838: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1839: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1840: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1841: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1842: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);
1843: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);
1844:

Line 1841: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);

1837:
1838: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1839: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1840: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1841: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1842: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);
1843: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);
1844:
1845: print_debug_log(l_api_name, 'All values bound for GENERATE_XML p_form_id = '||p_form_id);

Line 1842: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);

1838: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1839: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1840: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1841: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1842: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);
1843: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);
1844:
1845: print_debug_log(l_api_name, 'All values bound for GENERATE_XML p_form_id = '||p_form_id);
1846:

Line 1843: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);

1839: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1840: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1841: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1842: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);
1843: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);
1844:
1845: print_debug_log(l_api_name, 'All values bound for GENERATE_XML p_form_id = '||p_form_id);
1846:
1847: p_xml:=DBMS_XMLquery.GETXML(l_queryCtx, 0);

Line 1847: p_xml:=DBMS_XMLquery.GETXML(l_queryCtx, 0);

1843: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);
1844:
1845: print_debug_log(l_api_name, 'All values bound for GENERATE_XML p_form_id = '||p_form_id);
1846:
1847: p_xml:=DBMS_XMLquery.GETXML(l_queryCtx, 0);
1848: DBMS_XMLQUERY.closecontext(l_queryCtx);
1849:
1850: exception
1851: when others then

Line 1848: DBMS_XMLQUERY.closecontext(l_queryCtx);

1844:
1845: print_debug_log(l_api_name, 'All values bound for GENERATE_XML p_form_id = '||p_form_id);
1846:
1847: p_xml:=DBMS_XMLquery.GETXML(l_queryCtx, 0);
1848: DBMS_XMLQUERY.closecontext(l_queryCtx);
1849:
1850: exception
1851: when others then
1852: l_err_num := SQLCODE;

Line 1857: DBMS_XMLquery.closecontext (l_queryCtx);

1853: l_err_msg := SUBSTR(SQLERRM, 1, 200);
1854: print_error_log(l_api_name, 'p_form_id = '||p_form_id||' GENERATE_XML FAILED l_err_num = '||l_err_num||' l_err_msg = '||l_err_msg);
1855: p_result := 1;
1856: p_error := PON_AUCTION_PKG.getMessage ('PON_FM_XML_GENERATION_FAIL');
1857: DBMS_XMLquery.closecontext (l_queryCtx);
1858:
1859: End GENERATE_XML;
1860:
1861: