APPS.DPP_ITEMCOST_PVT dependencies on DBMS_XMLQUERY

Line 139: l_queryCtx dbms_xmlquery.ctxType;

135: l_transaction_number VARCHAR2(50);
136: l_sysdate DATE := sysdate;
137: l_trunc_sysdate DATE := trunc(sysdate);
138: l_output_xml CLOB;
139: l_queryCtx dbms_xmlquery.ctxType;
140:
141: --- Begin Added for A/c Generator W/f ---
142: l_itemtype VARCHAR2(30) := 'OZFACCTG';
143: l_itemkey VARCHAR2(38);

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

1547: --Get the output XML from DPP_OUTPUT_XML_GT table
1548: l_Transaction_Number := '''' || l_txn_hdr_rec.Transaction_Number || '''';
1549:
1550: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
1551: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER,
1552: CURSOR (Select Item_Number ITEMNUMBER,
1553: inventory_org_name ORGNAME,
1554: NewPrice NEWPRICE,
1555: Currency CURRENCY,

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

1556: Reason_For_Failure REASON
1557: from DPP_OUTPUT_XML_GT
1558: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual');
1559: ELSE
1560: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
1561: END IF;
1562:
1563: dbms_xmlquery.setRowTag(l_queryCtx, 'ROOT');
1564: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);

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

1559: ELSE
1560: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
1561: END IF;
1562:
1563: dbms_xmlquery.setRowTag(l_queryCtx, 'ROOT');
1564: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1565: dbms_xmlquery.closeContext(l_queryCtx);
1566:
1567: EXCEPTION

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

1560: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
1561: END IF;
1562:
1563: dbms_xmlquery.setRowTag(l_queryCtx, 'ROOT');
1564: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1565: dbms_xmlquery.closeContext(l_queryCtx);
1566:
1567: EXCEPTION
1568: WHEN OTHERS THEN

Line 1565: dbms_xmlquery.closeContext(l_queryCtx);

1561: END IF;
1562:
1563: dbms_xmlquery.setRowTag(l_queryCtx, 'ROOT');
1564: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1565: dbms_xmlquery.closeContext(l_queryCtx);
1566:
1567: EXCEPTION
1568: WHEN OTHERS THEN
1569: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;