APPS.DPP_LISTPRICE_PVT dependencies on DUAL

Line 235: FROM dual;

231: l_item_cost_tbl(i).update_status := 'N';
232: l_return_status := FND_API.G_RET_STS_ERROR;
233: SELECT fnd_message.get_string('DPP','DPP_INVALID_ITEM')
234: INTO l_reason
235: FROM dual;
236:
237: SELECT DISTINCT(concatenated_segments)
238: INTO l_item_number
239: FROM mtl_system_items_kfv

Line 272: where Reason_For_Failure IS NOT NULL) TRANSACTION from dual');

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;
276: dbms_xmlquery.setRowTag(l_queryCtx

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

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;
276: dbms_xmlquery.setRowTag(l_queryCtx
277: ,'ROOT'
278: );

Line 296: FROM DUAL;

292: END IF;
293:
294: SELECT DECODE(x_return_status,'S','SUCCESS','WARNING')
295: INTO l_execution_status
296: FROM DUAL;
297:
298: l_exe_update_rec.Transaction_Header_ID := l_txn_hdr_rec.Transaction_Header_ID;
299: l_exe_update_rec.Org_ID := l_txn_hdr_rec.Org_ID;
300: l_exe_update_rec.Execution_Detail_ID := l_txn_hdr_rec.Execution_Detail_ID;