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:
69: /* pll.price_override,
70: nvl(pll.price_override,pol.unit_price) unit_price*/
71: CURSOR po_cur(p_inventory_item_id IN NUMBER, p_org_id IN NUMBER, p_vendor_id IN NUMBER) IS

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

661: END IF;
662: --Get the output XML from DPP_OUTPUT_XML_GT table
663: l_Transaction_Number := ''''||l_item_price_rec.Transaction_Number||'''';
664: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
665: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER,
666: CURSOR (Select Item_Number ITEMNUMBER,
667: Document_Type POTYPE,
668: Document_Number PONUMBER,
669: Line_Number LINENUMBER,

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

671: from DPP_OUTPUT_XML_GT
672: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual'
673: );
674: ELSE
675: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
676: END IF;
677: dbms_xmlquery.setRowTag(l_queryCtx,'ROOT');
678: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
679: dbms_xmlquery.closeContext(l_queryCtx);

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

673: );
674: ELSE
675: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
676: END IF;
677: dbms_xmlquery.setRowTag(l_queryCtx,'ROOT');
678: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
679: dbms_xmlquery.closeContext(l_queryCtx);
680: EXCEPTION
681: WHEN OTHERS THEN

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

674: ELSE
675: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
676: END IF;
677: dbms_xmlquery.setRowTag(l_queryCtx,'ROOT');
678: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
679: dbms_xmlquery.closeContext(l_queryCtx);
680: EXCEPTION
681: WHEN OTHERS THEN
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 679: dbms_xmlquery.closeContext(l_queryCtx);

675: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
676: END IF;
677: dbms_xmlquery.setRowTag(l_queryCtx,'ROOT');
678: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
679: dbms_xmlquery.closeContext(l_queryCtx);
680: EXCEPTION
681: WHEN OTHERS THEN
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');