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 1750: l_queryCtx DBMS_XMLquery.ctxType;

1746: ';
1747:
1748: l_xml_query Varchar2(31500);
1749: l_form_code Varchar2(30);
1750: l_queryCtx DBMS_XMLquery.ctxType;
1751:
1752: l_schemOffset Number;
1753: l_xmlTagOffset INTEGER;
1754: l_documentOffset BINARY_INTEGER;

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

1785: x_xml_query := l_xml_query;
1786:
1787: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' GOT QUERY FORM SCHEMA ');
1788:
1789: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1790: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1791: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1792: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1793: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');

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

1786:
1787: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' GOT QUERY FORM SCHEMA ');
1788:
1789: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1790: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1791: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1792: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1793: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');
1794: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);

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

1787: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' GOT QUERY FORM SCHEMA ');
1788:
1789: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1790: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1791: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1792: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1793: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');
1794: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);
1795: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );

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

1788:
1789: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1790: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1791: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1792: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1793: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');
1794: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);
1795: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );
1796:

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

1789: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1790: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1791: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1792: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1793: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');
1794: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);
1795: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );
1796:
1797: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' STARTING SCHEMA GENERATION');

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

1790: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1791: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1792: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1793: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');
1794: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);
1795: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );
1796:
1797: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' STARTING SCHEMA GENERATION');
1798:

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

1791: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1792: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1793: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE','XML_SCHEMA_GENERATION');
1794: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',g_dummy_pk);
1795: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );
1796:
1797: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' STARTING SCHEMA GENERATION');
1798:
1799: p_schema:=DBMS_XMLquery.GETXML(l_queryCtx,2);

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

1795: -- DBMS_XMLquery.setXSLT(l_queryCtx,ldoc );
1796:
1797: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' STARTING SCHEMA GENERATION');
1798:
1799: p_schema:=DBMS_XMLquery.GETXML(l_queryCtx,2);
1800:
1801: print_debug_log(l_api_name, 'p_form_id = '||p_form_id||' GOT SCHEMA ');
1802:
1803: g_mode := 'XML';

Line 1807: DBMS_XMLQUERY.closecontext(l_queryCtx);

1803: g_mode := 'XML';
1804:
1805: rollback to SAVEPOINT PON_XMLSCHEMA;
1806:
1807: DBMS_XMLQUERY.closecontext(l_queryCtx);
1808:
1809: l_schemOffset := DBMS_LOB.INSTR(p_schema,'')+12;
1810: DBMS_LOB.TRIM(p_schema,l_schemOffset);
1811:

Line 1844: DBMS_XMLquery.closecontext (l_queryCtx);

1840: l_err_msg := SUBSTR(SQLERRM, 1, 200);
1841: 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);
1842: p_result := 1;
1843: p_error := PON_AUCTION_PKG.getMessage ('PON_FM_SCHEMA_GENERATION_FAIL');
1844: DBMS_XMLquery.closecontext (l_queryCtx);
1845:
1846: End GENERATE_XMLSCHEMA;
1847:
1848:

Line 1867: l_queryCtx DBMS_XMLquery.ctxType;

1863: l_err_num NUMBER;
1864: l_err_msg VARCHAR2(200);
1865: l_xml_query Varchar2(31500);
1866: l_form_code Varchar2(30);
1867: l_queryCtx DBMS_XMLquery.ctxType;
1868:
1869: l_api_name CONSTANT VARCHAR2(30) := 'GENERATE_XML';
1870:
1871: Begin

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

1898: end if;
1899:
1900: print_debug_log(l_api_name, 'Got Xml Query for GENERATE_XML p_form_id = '||p_form_id);
1901:
1902: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1903: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1904: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1905: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1906: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);

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

1899:
1900: print_debug_log(l_api_name, 'Got Xml Query for GENERATE_XML p_form_id = '||p_form_id);
1901:
1902: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1903: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1904: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1905: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1906: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);
1907: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);

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

1900: print_debug_log(l_api_name, 'Got Xml Query for GENERATE_XML p_form_id = '||p_form_id);
1901:
1902: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1903: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1904: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1905: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1906: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);
1907: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);
1908:

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

1901:
1902: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1903: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1904: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1905: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1906: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);
1907: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);
1908:
1909: print_debug_log(l_api_name, 'All values bound for GENERATE_XML p_form_id = '||p_form_id);

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

1902: l_queryCtx := DBMS_XMLquery.newContext(l_xml_query);
1903: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1904: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1905: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1906: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);
1907: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);
1908:
1909: print_debug_log(l_api_name, 'All values bound for GENERATE_XML p_form_id = '||p_form_id);
1910:

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

1903: DBMS_XMLQuery.setDateFormat(l_queryCtx,'dd/mm/yyyy HH:mm:ss'); -- sets the row tag name
1904: DBMS_XMLQuery.setRowTag(l_queryCtx,l_form_code || '_ROW'); -- sets the row tag name
1905: DBMS_XMLQuery.setRowSetTag(l_queryCtx,l_form_code);
1906: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_CODE',p_entity_code);
1907: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);
1908:
1909: print_debug_log(l_api_name, 'All values bound for GENERATE_XML p_form_id = '||p_form_id);
1910:
1911: p_xml:=DBMS_XMLquery.GETXML(l_queryCtx, 0);

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

1907: DBMS_XMLQuery.setBindValue(l_queryCtx,'ENTITY_PK1',p_entity_pk1);
1908:
1909: print_debug_log(l_api_name, 'All values bound for GENERATE_XML p_form_id = '||p_form_id);
1910:
1911: p_xml:=DBMS_XMLquery.GETXML(l_queryCtx, 0);
1912: DBMS_XMLQUERY.closecontext(l_queryCtx);
1913:
1914: exception
1915: when others then

Line 1912: DBMS_XMLQUERY.closecontext(l_queryCtx);

1908:
1909: print_debug_log(l_api_name, 'All values bound for GENERATE_XML p_form_id = '||p_form_id);
1910:
1911: p_xml:=DBMS_XMLquery.GETXML(l_queryCtx, 0);
1912: DBMS_XMLQUERY.closecontext(l_queryCtx);
1913:
1914: exception
1915: when others then
1916: l_err_num := SQLCODE;

Line 1921: DBMS_XMLquery.closecontext (l_queryCtx);

1917: l_err_msg := SUBSTR(SQLERRM, 1, 200);
1918: 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);
1919: p_result := 1;
1920: p_error := PON_AUCTION_PKG.getMessage ('PON_FM_XML_GENERATION_FAIL');
1921: DBMS_XMLquery.closecontext (l_queryCtx);
1922:
1923: End GENERATE_XML;
1924:
1925: