APPS.DPP_LISTPRICE_PVT dependencies on DPP_OUTPUT_XML_GT

Line 201: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,

197: , p_Revision_rec => l_revision_rec
198: );
199: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
200: l_item_cost_tbl(i).update_status := 'Y';
201: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,
202: NewPrice,
203: Currency,
204: Reason_For_Failure)
205: VALUES(l_item_cost_tbl(i).item_number,

Line 217: INSERT INTO DPP_OUTPUT_XML_GT(

213: l_item_cost_tbl(i).Reason_For_Failure := NVL(l_item_cost_tbl(i).Reason_For_Failure,' ')
214: ||'Org ID: '||Item_rec.organization_id
215: ||' Error: '||l_error_tbl(j).MESSAGE_TEXT;
216:
217: INSERT INTO DPP_OUTPUT_XML_GT(
218: Item_Number,NewPrice,
219: Currency,Reason_For_Failure)
220: VALUES(
221: l_item_cost_tbl(i).item_number,l_item_rec.list_price_per_unit,

Line 242: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,

238: INTO l_item_number
239: FROM mtl_system_items_kfv
240: WHERE inventory_item_id = l_item_cost_tbl(i).inventory_item_id;
241:
242: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,
243: NewPrice,
244: Currency,
245: Reason_For_Failure)
246: VALUES(l_item_number,

Line 271: from DPP_OUTPUT_XML_GT

267: CURSOR (Select Item_Number ITEMNUMBER,
268: NewPrice NEWPRICE,
269: Currency CURRENCY,
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;