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 1511: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER,

1507: --Get the output XML from DPP_OUTPUT_XML_GT table
1508: l_Transaction_Number := '''' || l_txn_hdr_rec.Transaction_Number || '''';
1509:
1510: IF x_return_status IN (FND_API.G_RET_STS_ERROR, FND_API.G_RET_STS_UNEXP_ERROR) THEN
1511: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER,
1512: CURSOR (Select Item_Number ITEMNUMBER,
1513: inventory_org_name ORGNAME,
1514: NewPrice NEWPRICE,
1515: Currency CURRENCY,

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

1516: Reason_For_Failure REASON
1517: from DPP_OUTPUT_XML_GT
1518: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual');
1519: ELSE
1520: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
1521: END IF;
1522:
1523: dbms_xmlquery.setRowTag(l_queryCtx, 'ROOT');
1524: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);

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

1519: ELSE
1520: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
1521: END IF;
1522:
1523: dbms_xmlquery.setRowTag(l_queryCtx, 'ROOT');
1524: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1525: dbms_xmlquery.closeContext(l_queryCtx);
1526:
1527: EXCEPTION

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

1520: l_queryCtx := dbms_xmlquery.newContext('SELECT '||l_Transaction_Number||' TXNNUMBER from dual');
1521: END IF;
1522:
1523: dbms_xmlquery.setRowTag(l_queryCtx, 'ROOT');
1524: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1525: dbms_xmlquery.closeContext(l_queryCtx);
1526:
1527: EXCEPTION
1528: WHEN OTHERS THEN

Line 1525: dbms_xmlquery.closeContext(l_queryCtx);

1521: END IF;
1522:
1523: dbms_xmlquery.setRowTag(l_queryCtx, 'ROOT');
1524: l_output_xml := dbms_xmlquery.getXml(l_queryCtx);
1525: dbms_xmlquery.closeContext(l_queryCtx);
1526:
1527: EXCEPTION
1528: WHEN OTHERS THEN
1529: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;