APPS.DPP_PURCHASEPRICE_PVT dependencies on DBMS_XMLQUERY

Line 67: l_queryCtx dbms_xmlquery.ctxType;

63: l_user_name VARCHAR2(100);
64:
65: --OutputXML
66: l_output_xml CLOB;
67: l_queryCtx dbms_xmlquery.ctxType;
68: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_PURCHASEPRICE_PVT.UPDATE_PURCHASEPRICE';
69:
70: /* pll.price_override,
71: nvl(pll.price_override,pol.unit_price) unit_price*/

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

653:
654: --Get the output XML from DPP_OUTPUT_XML_GT table
655: l_Transaction_Number := ''''||l_item_price_rec.Transaction_Number||'''';
656: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
657: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER,
658: CURSOR (Select Item_Number ITEMNUMBER,
659: Document_Type POTYPE,
660: Document_Number PONUMBER,
661: Line_Number LINENUMBER,

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

663: from DPP_OUTPUT_XML_GT
664: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual'
665: );
666: ELSE
667: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
668: END IF;
669: dbms_xmlquery.setRowTag(l_queryCtx,'ROOT');
670: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
671: dbms_xmlquery.closeContext(l_queryCtx);

Line 669: dbms_xmlquery.setRowTag(l_queryCtx,'ROOT');

665: );
666: ELSE
667: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
668: END IF;
669: dbms_xmlquery.setRowTag(l_queryCtx,'ROOT');
670: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
671: dbms_xmlquery.closeContext(l_queryCtx);
672: EXCEPTION
673: WHEN OTHERS THEN

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

666: ELSE
667: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
668: END IF;
669: dbms_xmlquery.setRowTag(l_queryCtx,'ROOT');
670: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
671: dbms_xmlquery.closeContext(l_queryCtx);
672: EXCEPTION
673: WHEN OTHERS THEN
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 671: dbms_xmlquery.closeContext(l_queryCtx);

667: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
668: END IF;
669: dbms_xmlquery.setRowTag(l_queryCtx,'ROOT');
670: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
671: dbms_xmlquery.closeContext(l_queryCtx);
672: EXCEPTION
673: WHEN OTHERS THEN
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');