APPS.INV_XML_REPORTS dependencies on DBMS_XMLGEN

Line 12: qryctx DBMS_XMLGEN.ctxhandle;

8: , p_to_item IN VARCHAR2
9: , p_from_subinv IN VARCHAR2
10: , p_to_subinv IN VARCHAR2) IS
11:
12: qryctx DBMS_XMLGEN.ctxhandle;
13: v_result CLOB;
14: QUERY VARCHAR2 (32000);
15: BEGIN
16: QUERY :=

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

105: || p_organization_id;
106:
107: fnd_file.put_line (fnd_file.LOG, query);
108:
109: qryctx := DBMS_XMLGEN.newcontext (QUERY);
110:
111: LOOP
112: -- now get the result
113: v_result := DBMS_XMLGEN.getxml (qryctx);

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

109: qryctx := DBMS_XMLGEN.newcontext (QUERY);
110:
111: LOOP
112: -- now get the result
113: v_result := DBMS_XMLGEN.getxml (qryctx);
114:
115: -- if there were no rows processed, then quit
116: IF v_result IS NULL THEN
117: EXIT;

Line 124: DBMS_XMLGEN.closecontext (qryctx);

120: xml_transfer (p_xml_clob => v_result);
121: END LOOP;
122:
123: --close context
124: DBMS_XMLGEN.closecontext (qryctx);
125:
126: EXCEPTION
127: WHEN OTHERS THEN
128: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure LOT_INVENTORY_REPORT ' || SQLCODE || ' ' || SQLERRM);

Line 138: qryctx DBMS_XMLGEN.ctxhandle;

134: , p_organization_id IN NUMBER
135: , p_from_item IN VARCHAR2
136: , p_to_item IN VARCHAR2) IS
137:
138: qryctx DBMS_XMLGEN.ctxhandle;
139: v_result CLOB;
140: QUERY VARCHAR2 (32000);
141: BEGIN
142: QUERY :=

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

190: where mp.organization_id = '
191: || p_organization_id;
192:
193: fnd_file.put_line (fnd_file.LOG, query);
194: qryctx := DBMS_XMLGEN.newcontext (QUERY);
195:
196: LOOP
197: -- now get the result
198: v_result := DBMS_XMLGEN.getxml (qryctx);

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

194: qryctx := DBMS_XMLGEN.newcontext (QUERY);
195:
196: LOOP
197: -- now get the result
198: v_result := DBMS_XMLGEN.getxml (qryctx);
199:
200: -- if there were no rows processed, then quit
201: IF v_result IS NULL THEN
202: EXIT;

Line 209: DBMS_XMLGEN.closecontext (qryctx);

205: xml_transfer (p_xml_clob => v_result);
206: END LOOP;
207:
208: --close context
209: DBMS_XMLGEN.closecontext (qryctx);
210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure LOT_MASTER_REPORT ' || SQLCODE || ' ' || SQLERRM);

Line 223: qryctx DBMS_XMLGEN.ctxhandle;

219: , p_from_status IN VARCHAR2
220: , p_to_status IN VARCHAR2
221: , p_sort_order IN NUMBER) IS
222:
223: qryctx DBMS_XMLGEN.ctxhandle;
224: v_result CLOB;
225: QUERY VARCHAR2 (32000);
226: l_order VARCHAR2 (10);
227: l_range VARCHAR2 (170) := NULL;

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

318: QUERY := QUERY || ' ORDER BY mv.status_code ' || l_order;
319:
320: fnd_file.put_line (fnd_file.LOG, query);
321:
322: qryctx := DBMS_XMLGEN.newcontext (QUERY);
323:
324: LOOP
325: -- now get the result
326: v_result := DBMS_XMLGEN.getxml (qryctx);

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

322: qryctx := DBMS_XMLGEN.newcontext (QUERY);
323:
324: LOOP
325: -- now get the result
326: v_result := DBMS_XMLGEN.getxml (qryctx);
327:
328: -- if there were no rows processed, then quit
329: IF v_result IS NULL THEN
330: EXIT;

Line 337: DBMS_XMLGEN.closecontext (qryctx);

333: xml_transfer (p_xml_clob => v_result);
334: END LOOP;
335:
336: --close context
337: DBMS_XMLGEN.closecontext (qryctx);
338:
339: EXCEPTION
340: WHEN OTHERS THEN
341: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure MAT_STATUS_DEF_REPORT ' || SQLCODE || ' ' || SQLERRM);

Line 354: qryctx DBMS_XMLGEN.ctxhandle;

350: , p_to_lot IN VARCHAR2
351: , p_from_date IN VARCHAR2
352: , p_to_date IN VARCHAR2) IS
353:
354: qryctx DBMS_XMLGEN.ctxhandle;
355: v_result CLOB;
356: QUERY VARCHAR2 (32000);
357: p_from_dt DATE := fnd_date.canonical_to_date(p_from_date);
358: p_to_dt DATE := fnd_date.canonical_to_date(p_to_date);

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

438: ORDER BY msi.concatenated_segments';
439:
440: fnd_file.put_line (fnd_file.LOG, query);
441:
442: qryctx := DBMS_XMLGEN.newcontext (QUERY);
443:
444: LOOP
445: -- now get the result
446: v_result := DBMS_XMLGEN.getxml (qryctx);

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

442: qryctx := DBMS_XMLGEN.newcontext (QUERY);
443:
444: LOOP
445: -- now get the result
446: v_result := DBMS_XMLGEN.getxml (qryctx);
447:
448: -- if there were no rows processed, then quit
449: IF v_result IS NULL THEN
450: EXIT;

Line 457: DBMS_XMLGEN.closecontext (qryctx);

453: xml_transfer (p_xml_clob => v_result);
454: END LOOP;
455:
456: --close context
457: DBMS_XMLGEN.closecontext (qryctx);
458:
459: EXCEPTION
460: WHEN OTHERS THEN
461: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure GRADE_CHANGE_HISTORY_REPORT ' || SQLCODE || ' ' || SQLERRM);