APPS.DPP_LISTPRICE_PVT dependencies on DBMS_XMLQUERY

Line 68: l_queryCtx dbms_xmlquery.ctxType;

64: l_error_tbl INV_ITEM_GRP.Error_tbl_type;
65: l_revision_rec INV_ITEM_GRP.Item_Revision_Rec_Type;
66:
67: l_output_xml CLOB;
68: l_queryCtx dbms_xmlquery.ctxType;
69: l_Transaction_Number CLOB;
70: l_control_level NUMBER;
71: l_count NUMBER;
72: l_reason fnd_new_messages.message_text%TYPE;

Line 266: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER,

262: END IF;
263:
264: BEGIN
265: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
266: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER,
267: CURSOR (Select Item_Number ITEMNUMBER,
268: NewPrice NEWPRICE,
269: Currency CURRENCY,
270: Reason_For_Failure REASON

Line 274: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');

270: Reason_For_Failure REASON
271: from DPP_OUTPUT_XML_GT
272: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual');
273: ELSE
274: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
275: END IF;
276: dbms_xmlquery.setRowTag(l_queryCtx
277: ,'ROOT'
278: );

Line 276: dbms_xmlquery.setRowTag(l_queryCtx

272: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual');
273: ELSE
274: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
275: END IF;
276: dbms_xmlquery.setRowTag(l_queryCtx
277: ,'ROOT'
278: );
279: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
280: dbms_xmlquery.closeContext(l_queryCtx);

Line 279: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);

275: END IF;
276: dbms_xmlquery.setRowTag(l_queryCtx
277: ,'ROOT'
278: );
279: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
280: dbms_xmlquery.closeContext(l_queryCtx);
281: EXCEPTION
282: WHEN OTHERS THEN
283: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 280: dbms_xmlquery.closeContext(l_queryCtx);

276: dbms_xmlquery.setRowTag(l_queryCtx
277: ,'ROOT'
278: );
279: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
280: dbms_xmlquery.closeContext(l_queryCtx);
281: EXCEPTION
282: WHEN OTHERS THEN
283: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');