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.INV_XML_REPORTS dependencies on DBMS_XMLGEN

Line 21: qryctx DBMS_XMLGEN.ctxhandle;

17: , p_to_item IN VARCHAR2
18: , p_from_subinv IN VARCHAR2
19: , p_to_subinv IN VARCHAR2) IS
20:
21: qryctx DBMS_XMLGEN.ctxhandle;
22: v_result CLOB;
23: QUERY VARCHAR2 (32000);
24: BEGIN
25: --#11703502 Character date international calendar support Added calendar_aware in date function arguments

Line 157: qryctx := DBMS_XMLGEN.newcontext (QUERY);

153: || p_organization_id;
154:
155: fnd_file.put_line (fnd_file.LOG, query);
156:
157: qryctx := DBMS_XMLGEN.newcontext (QUERY);
158:
159: LOOP
160: -- now get the result
161: v_result := DBMS_XMLGEN.getxml (qryctx);

Line 161: v_result := DBMS_XMLGEN.getxml (qryctx);

157: qryctx := DBMS_XMLGEN.newcontext (QUERY);
158:
159: LOOP
160: -- now get the result
161: v_result := DBMS_XMLGEN.getxml (qryctx);
162:
163: -- if there were no rows processed, then quit
164: IF v_result IS NULL THEN
165: EXIT;

Line 172: DBMS_XMLGEN.closecontext (qryctx);

168: xml_transfer (p_xml_clob => v_result);
169: END LOOP;
170:
171: --close context
172: DBMS_XMLGEN.closecontext (qryctx);
173:
174: EXCEPTION
175: WHEN OTHERS THEN
176: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure LOT_INVENTORY_REPORT ' || SQLCODE || ' ' || SQLERRM);

Line 186: qryctx DBMS_XMLGEN.ctxhandle;

182: , p_organization_id IN NUMBER
183: , p_from_item IN VARCHAR2
184: , p_to_item IN VARCHAR2) IS
185:
186: qryctx DBMS_XMLGEN.ctxhandle;
187: v_result CLOB;
188: QUERY VARCHAR2 (32000);
189: BEGIN
190: --#11703502 Character date international calendar support Added calendar_aware in date function arguments

Line 243: qryctx := DBMS_XMLGEN.newcontext (QUERY);

239: where mp.organization_id = '
240: || p_organization_id;
241:
242: fnd_file.put_line (fnd_file.LOG, query);
243: qryctx := DBMS_XMLGEN.newcontext (QUERY);
244:
245: LOOP
246: -- now get the result
247: v_result := DBMS_XMLGEN.getxml (qryctx);

Line 247: v_result := DBMS_XMLGEN.getxml (qryctx);

243: qryctx := DBMS_XMLGEN.newcontext (QUERY);
244:
245: LOOP
246: -- now get the result
247: v_result := DBMS_XMLGEN.getxml (qryctx);
248:
249: -- if there were no rows processed, then quit
250: IF v_result IS NULL THEN
251: EXIT;

Line 258: DBMS_XMLGEN.closecontext (qryctx);

254: xml_transfer (p_xml_clob => v_result);
255: END LOOP;
256:
257: --close context
258: DBMS_XMLGEN.closecontext (qryctx);
259:
260: EXCEPTION
261: WHEN OTHERS THEN
262: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure LOT_MASTER_REPORT ' || SQLCODE || ' ' || SQLERRM);

Line 272: qryctx DBMS_XMLGEN.ctxhandle;

268: , p_from_status IN VARCHAR2
269: , p_to_status IN VARCHAR2
270: , p_sort_order IN NUMBER) IS
271:
272: qryctx DBMS_XMLGEN.ctxhandle;
273: v_result CLOB;
274: QUERY VARCHAR2 (32000);
275: l_order VARCHAR2 (10);
276: l_range VARCHAR2 (170) := NULL;

Line 375: qryctx := DBMS_XMLGEN.newcontext (QUERY);

371: QUERY := QUERY || ' ORDER BY mv.status_code ' || l_order;
372:
373: fnd_file.put_line (fnd_file.LOG, query);
374:
375: qryctx := DBMS_XMLGEN.newcontext (QUERY);
376:
377: LOOP
378: -- now get the result
379: v_result := DBMS_XMLGEN.getxml (qryctx);

Line 379: v_result := DBMS_XMLGEN.getxml (qryctx);

375: qryctx := DBMS_XMLGEN.newcontext (QUERY);
376:
377: LOOP
378: -- now get the result
379: v_result := DBMS_XMLGEN.getxml (qryctx);
380:
381: -- if there were no rows processed, then quit
382: IF v_result IS NULL THEN
383: EXIT;

Line 390: DBMS_XMLGEN.closecontext (qryctx);

386: xml_transfer (p_xml_clob => v_result);
387: END LOOP;
388:
389: --close context
390: DBMS_XMLGEN.closecontext (qryctx);
391:
392: EXCEPTION
393: WHEN OTHERS THEN
394: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure MAT_STATUS_DEF_REPORT ' || SQLCODE || ' ' || SQLERRM);

Line 407: qryctx DBMS_XMLGEN.ctxhandle;

403: , p_to_lot IN VARCHAR2
404: , p_from_date IN VARCHAR2
405: , p_to_date IN VARCHAR2) IS
406:
407: qryctx DBMS_XMLGEN.ctxhandle;
408: v_result CLOB;
409: QUERY VARCHAR2 (32000);
410: p_from_dt DATE := fnd_date.canonical_to_date(p_from_date);
411: p_to_dt DATE := fnd_date.canonical_to_date(p_to_date);

Line 496: qryctx := DBMS_XMLGEN.newcontext (QUERY);

492: ORDER BY msi.concatenated_segments';
493:
494: fnd_file.put_line (fnd_file.LOG, query);
495:
496: qryctx := DBMS_XMLGEN.newcontext (QUERY);
497:
498: LOOP
499: -- now get the result
500: v_result := DBMS_XMLGEN.getxml (qryctx);

Line 500: v_result := DBMS_XMLGEN.getxml (qryctx);

496: qryctx := DBMS_XMLGEN.newcontext (QUERY);
497:
498: LOOP
499: -- now get the result
500: v_result := DBMS_XMLGEN.getxml (qryctx);
501:
502: -- if there were no rows processed, then quit
503: IF v_result IS NULL THEN
504: EXIT;

Line 511: DBMS_XMLGEN.closecontext (qryctx);

507: xml_transfer (p_xml_clob => v_result);
508: END LOOP;
509:
510: --close context
511: DBMS_XMLGEN.closecontext (qryctx);
512:
513: EXCEPTION
514: WHEN OTHERS THEN
515: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure GRADE_CHANGE_HISTORY_REPORT ' || SQLCODE || ' ' || SQLERRM);