APPS.CST_PERITEMCOSTCHANGERPT_PVT dependencies on DBMS_XMLGEN

Line 177: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

173:
174:
175: /* create new context */
176: l_stmt_num := 40;
177: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
178: DBMS_XMLGEN.setRowSetTag (l_ctx,'ROWSET');
179: DBMS_XMLGEN.setRowTag (l_ctx, 'ROW');
180:
181: /* get XML */

Line 178: DBMS_XMLGEN.setRowSetTag (l_ctx,'ROWSET');

174:
175: /* create new context */
176: l_stmt_num := 40;
177: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
178: DBMS_XMLGEN.setRowSetTag (l_ctx,'ROWSET');
179: DBMS_XMLGEN.setRowTag (l_ctx, 'ROW');
180:
181: /* get XML */
182: l_stmt_num := 50;

Line 179: DBMS_XMLGEN.setRowTag (l_ctx, 'ROW');

175: /* create new context */
176: l_stmt_num := 40;
177: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
178: DBMS_XMLGEN.setRowSetTag (l_ctx,'ROWSET');
179: DBMS_XMLGEN.setRowTag (l_ctx, 'ROW');
180:
181: /* get XML */
182: l_stmt_num := 50;
183: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 183: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

179: DBMS_XMLGEN.setRowTag (l_ctx, 'ROW');
180:
181: /* get XML */
182: l_stmt_num := 50;
183: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
184:
185: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
186: l_offset := DBMS_LOB.instr (lob_loc => l_xml_temp,
187: pattern => '>',

Line 185: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN

181: /* get XML */
182: l_stmt_num := 50;
183: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
184:
185: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
186: l_offset := DBMS_LOB.instr (lob_loc => l_xml_temp,
187: pattern => '>',
188: offset => 1,
189: nth => 1);

Line 411: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);

407: i_item_from, i_item_to, l_currency_code;
408:
409: /* create new context */
410: l_stmt_num := 80;
411: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
412: DBMS_XMLGEN.setRowSetTag (l_ctx,'PARAMETERS');
413: DBMS_XMLGEN.setRowTag (l_ctx, NULL);
414:
415: /* get XML */

Line 412: DBMS_XMLGEN.setRowSetTag (l_ctx,'PARAMETERS');

408:
409: /* create new context */
410: l_stmt_num := 80;
411: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
412: DBMS_XMLGEN.setRowSetTag (l_ctx,'PARAMETERS');
413: DBMS_XMLGEN.setRowTag (l_ctx, NULL);
414:
415: /* get XML */
416: l_stmt_num := 90;

Line 413: DBMS_XMLGEN.setRowTag (l_ctx, NULL);

409: /* create new context */
410: l_stmt_num := 80;
411: l_ctx := DBMS_XMLGEN.newContext (l_ref_cur);
412: DBMS_XMLGEN.setRowSetTag (l_ctx,'PARAMETERS');
413: DBMS_XMLGEN.setRowTag (l_ctx, NULL);
414:
415: /* get XML */
416: l_stmt_num := 90;
417: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

Line 417: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);

413: DBMS_XMLGEN.setRowTag (l_ctx, NULL);
414:
415: /* get XML */
416: l_stmt_num := 90;
417: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
418:
419: l_stmt_num := 100;
420: /* Add the XML header as the first line of output. add data to end */
421: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN

Line 421: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN

417: DBMS_XMLGEN.getXML (l_ctx, l_xml_temp, DBMS_XMLGEN.none);
418:
419: l_stmt_num := 100;
420: /* Add the XML header as the first line of output. add data to end */
421: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
422: l_offset := DBMS_LOB.instr (lob_loc => l_xml_temp,
423: pattern => '>',
424: offset => 1,
425: nth => 1);

Line 435: DBMS_XMLGEN.closeContext(l_ctx);

431: END IF;
432:
433: l_stmt_num := 110;
434: /* close context and free memory */
435: DBMS_XMLGEN.closeContext(l_ctx);
436: CLOSE l_ref_cur;
437: DBMS_LOB.FREETEMPORARY (l_xml_temp);
438:
439: -- Standard call to get message count and if count is 1, get message info.