eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_BUSINESSEVENTS_PVT dependencies on DPP_TRANSACTION_LINES_ALL

Line 237: FROM dpp_transaction_lines_all

233: INSERT INTO DPP_TRANSACTION_LINES_GT(transaction_header_id,
234: transaction_line_id)
235: SELECT transaction_header_id,
236: transaction_line_id
237: FROM dpp_transaction_lines_all
238: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID;
239: EXCEPTION
240: WHEN OTHERS THEN
241: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

Line 290: FROM dpp_transaction_lines_all lines

286: inventory_item_id,
287: supplier_new_price new_price,
288: UOM,
289: headers.trx_currency currency
290: FROM dpp_transaction_lines_all lines
291: WHERE headers.Transaction_header_id = lines.Transaction_header_id
292: AND nvl(lines.UPDATE_ITEM_LIST_PRICE,''N'') = ''N'') LINES
293: FROM dpp_transaction_headers_all headers
294: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 296: FROM dpp_transaction_lines_all

292: AND nvl(lines.UPDATE_ITEM_LIST_PRICE,''N'') = ''N'') LINES
293: FROM dpp_transaction_headers_all headers
294: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
295: 'AND EXISTS (SELECT Transaction_header_id
296: FROM dpp_transaction_lines_all
297: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
298: AND nvl(UPDATE_ITEM_LIST_PRICE,''N'') = ''N'')'
299: );
300: dbms_xmlquery.setRowTag(l_queryCtx

Line 312: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

308: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
309: dbms_xmlquery.closeContext(l_queryCtx);
310:
311: IF l_row_count >0 THEN
312: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
313: UPDATE DPP_TRANSACTION_LINES_ALL
314: SET update_item_list_price = 'P',
315: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
316: last_updated_by = l_user_id,

Line 313: UPDATE DPP_TRANSACTION_LINES_ALL

309: dbms_xmlquery.closeContext(l_queryCtx);
310:
311: IF l_row_count >0 THEN
312: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
313: UPDATE DPP_TRANSACTION_LINES_ALL
314: SET update_item_list_price = 'P',
315: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
316: last_updated_by = l_user_id,
317: last_update_date = sysdate,

Line 324: DPP_UTILITY_PVT.debug_message('Unable to Update the column update_item_list_price in DPP_TRANSACTION_LINES_ALL Table');

320: AND nvl(update_item_list_price, 'N') = 'N';
321:
322: IF SQL%ROWCOUNT = 0 THEN
323: l_return_status := FND_API.G_RET_STS_ERROR;
324: DPP_UTILITY_PVT.debug_message('Unable to Update the column update_item_list_price in DPP_TRANSACTION_LINES_ALL Table');
325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
326: END IF;
327:
328: END IF;

Line 344: FROM dpp_transaction_lines_all lines

340: CURSOR(select transaction_line_id,
341: inventory_item_id,
342: supplier_new_price new_price,
343: headers.trx_currency currency
344: FROM dpp_transaction_lines_all lines
345: WHERE headers.Transaction_header_id = lines.Transaction_header_id
346: AND nvl(lines.NOTIFY_OUTBOUND_PRICELIST,''N'') <> ''D'') LINES
347: FROM dpp_transaction_headers_all headers
348: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 350: FROM dpp_transaction_lines_all

346: AND nvl(lines.NOTIFY_OUTBOUND_PRICELIST,''N'') <> ''D'') LINES
347: FROM dpp_transaction_headers_all headers
348: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
349: 'AND EXISTS (SELECT Transaction_header_id
350: FROM dpp_transaction_lines_all
351: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
352: AND nvl(NOTIFY_OUTBOUND_PRICELIST,''N'') <> ''D'')'
353: );
354: dbms_xmlquery.setRowTag(l_queryCtx

Line 366: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

362: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
363: dbms_xmlquery.closeContext(l_queryCtx);
364:
365: IF l_row_count >0 THEN
366: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
367: UPDATE DPP_TRANSACTION_LINES_ALL
368: SET NOTIFY_OUTBOUND_PRICELIST = 'P',
369: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
370: last_updated_by = l_user_id,

Line 367: UPDATE DPP_TRANSACTION_LINES_ALL

363: dbms_xmlquery.closeContext(l_queryCtx);
364:
365: IF l_row_count >0 THEN
366: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
367: UPDATE DPP_TRANSACTION_LINES_ALL
368: SET NOTIFY_OUTBOUND_PRICELIST = 'P',
369: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
370: last_updated_by = l_user_id,
371: last_update_date = sysdate,

Line 378: DPP_UTILITY_PVT.debug_message('Unable to Update the column NOTIFY_OUTBOUND_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');

374: AND nvl(NOTIFY_OUTBOUND_PRICELIST,'N') <> 'D';
375:
376: IF SQL%ROWCOUNT = 0 THEN
377: l_return_status := FND_API.G_RET_STS_ERROR;
378: DPP_UTILITY_PVT.debug_message('Unable to Update the column NOTIFY_OUTBOUND_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: END IF;
382:

Line 388: FROM dpp_transaction_lines_all

384: --Calculate the value of the claim header amount
385: BEGIN
386: SELECT SUM(nvl(claim_amount,0))
387: INTO l_claim_hdr_amt
388: FROM dpp_transaction_lines_all
389: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID
390: AND to_number(supp_dist_claim_id) = p_txn_hdr_rec.claim_id;
391: EXCEPTION
392: WHEN NO_DATA_FOUND THEN

Line 435: FROM dpp_transaction_lines_all lines

431: approved_inventory claim_quantity,
432: UOM,'
433: ||p_txn_hdr_rec.claim_id||'claim_id,
434: headers.trx_currency currency
435: FROM dpp_transaction_lines_all lines
436: WHERE headers.Transaction_header_id = lines.Transaction_header_id
437: AND lines.supp_dist_claim_id = '||p_txn_hdr_rec.claim_id||') LINES
438: FROM dpp_transaction_headers_all headers
439: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID

Line 467: FROM dpp_transaction_lines_all lines

463: CURSOR(select transaction_line_id,
464: inventory_item_id,
465: supplier_new_price new_price,
466: headers.trx_currency currency
467: FROM dpp_transaction_lines_all lines
468: WHERE headers.Transaction_header_id = lines.Transaction_header_id
469: AND nvl(lines.NOTIFY_INBOUND_PRICELIST,''N'') <> ''D'') LINES
470: FROM dpp_transaction_headers_all headers
471: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 473: FROM dpp_transaction_lines_all

469: AND nvl(lines.NOTIFY_INBOUND_PRICELIST,''N'') <> ''D'') LINES
470: FROM dpp_transaction_headers_all headers
471: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
472: 'AND EXISTS (SELECT Transaction_header_id
473: FROM dpp_transaction_lines_all
474: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
475: AND nvl(NOTIFY_INBOUND_PRICELIST,''N'') <> ''D'')'
476: );
477: dbms_xmlquery.setRowTag(l_queryCtx

Line 489: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

485: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
486: dbms_xmlquery.closeContext(l_queryCtx);
487:
488: IF l_row_count >0 THEN
489: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
490: UPDATE DPP_TRANSACTION_LINES_ALL
491: SET NOTIFY_INBOUND_PRICELIST = 'P',
492: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
493: last_updated_by = l_user_id,

Line 490: UPDATE DPP_TRANSACTION_LINES_ALL

486: dbms_xmlquery.closeContext(l_queryCtx);
487:
488: IF l_row_count >0 THEN
489: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
490: UPDATE DPP_TRANSACTION_LINES_ALL
491: SET NOTIFY_INBOUND_PRICELIST = 'P',
492: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
493: last_updated_by = l_user_id,
494: last_update_date = sysdate,

Line 501: DPP_UTILITY_PVT.debug_message('Unable to Update the column NOTIFY_INBOUND_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');

497: AND nvl(NOTIFY_INBOUND_PRICELIST,'N') <> 'D';
498:
499: IF SQL%ROWCOUNT = 0 THEN
500: l_return_status := FND_API.G_RET_STS_ERROR;
501: DPP_UTILITY_PVT.debug_message('Unable to Update the column NOTIFY_INBOUND_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504: END IF;
505:

Line 521: FROM dpp_transaction_lines_all lines

517: CURSOR(select transaction_line_id,
518: inventory_item_id,
519: supplier_new_price new_price,
520: headers.trx_currency currency
521: FROM dpp_transaction_lines_all lines
522: WHERE headers.Transaction_header_id = lines.Transaction_header_id
523: AND nvl(lines.NOTIFY_PROMOTIONS_PRICELIST,''N'') <> ''D'') LINES
524: FROM dpp_transaction_headers_all headers
525: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 527: FROM dpp_transaction_lines_all

523: AND nvl(lines.NOTIFY_PROMOTIONS_PRICELIST,''N'') <> ''D'') LINES
524: FROM dpp_transaction_headers_all headers
525: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
526: 'AND EXISTS (SELECT Transaction_header_id
527: FROM dpp_transaction_lines_all
528: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
529: AND nvl(NOTIFY_PROMOTIONS_PRICELIST,''N'') <> ''D'')'
530: );
531: dbms_xmlquery.setRowTag(l_queryCtx

Line 543: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

539: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
540: dbms_xmlquery.closeContext(l_queryCtx);
541:
542: IF l_row_count >0 THEN
543: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
544: UPDATE DPP_TRANSACTION_LINES_ALL
545: SET NOTIFY_PROMOTIONS_PRICELIST = 'P',
546: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
547: last_updated_by = l_user_id,

Line 544: UPDATE DPP_TRANSACTION_LINES_ALL

540: dbms_xmlquery.closeContext(l_queryCtx);
541:
542: IF l_row_count >0 THEN
543: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
544: UPDATE DPP_TRANSACTION_LINES_ALL
545: SET NOTIFY_PROMOTIONS_PRICELIST = 'P',
546: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
547: last_updated_by = l_user_id,
548: last_update_date = sysdate,

Line 555: DPP_UTILITY_PVT.debug_message('Unable to Update the column NOTIFY_PROMOTIONS_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');

551: AND nvl(NOTIFY_PROMOTIONS_PRICELIST,'N') <> 'D';
552:
553: IF SQL%ROWCOUNT = 0 THEN
554: l_return_status := FND_API.G_RET_STS_ERROR;
555: DPP_UTILITY_PVT.debug_message('Unable to Update the column NOTIFY_PROMOTIONS_PRICELIST in DPP_TRANSACTION_LINES_ALL Table');
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END IF;
558: END IF;
559: ELSIF p_txn_hdr_rec.process_code = 'INVC' THEN

Line 638: FROM dpp_transaction_lines_all lines

634: supplier_new_price new_price,
635: headers.trx_currency currency,
636: UOM,
637: price_change
638: FROM dpp_transaction_lines_all lines
639: WHERE headers.Transaction_header_id = lines.Transaction_header_id
640: AND nvl(lines.UPDATE_INVENTORY_COSTING,''N'') = ''N'') LINES
641: FROM dpp_transaction_headers_all headers
642: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 644: FROM dpp_transaction_lines_all

640: AND nvl(lines.UPDATE_INVENTORY_COSTING,''N'') = ''N'') LINES
641: FROM dpp_transaction_headers_all headers
642: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
643: 'AND EXISTS (SELECT Transaction_header_id
644: FROM dpp_transaction_lines_all
645: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
646: AND nvl(UPDATE_INVENTORY_COSTING,''N'') = ''N'')'
647: );
648: dbms_xmlquery.setRowTag(l_queryCtx

Line 660: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

656: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
657: dbms_xmlquery.closeContext(l_queryCtx);
658:
659: IF l_row_count >0 THEN
660: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
661: UPDATE DPP_TRANSACTION_LINES_ALL
662: SET UPDATE_INVENTORY_COSTING = 'P',
663: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
664: last_updated_by = l_user_id,

Line 661: UPDATE DPP_TRANSACTION_LINES_ALL

657: dbms_xmlquery.closeContext(l_queryCtx);
658:
659: IF l_row_count >0 THEN
660: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
661: UPDATE DPP_TRANSACTION_LINES_ALL
662: SET UPDATE_INVENTORY_COSTING = 'P',
663: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
664: last_updated_by = l_user_id,
665: last_update_date = sysdate,

Line 672: DPP_UTILITY_PVT.debug_message('Unable to Update the column UPDATE_INVENTORY_COSTING in DPP_TRANSACTION_LINES_ALL Table');

668: AND nvl(UPDATE_INVENTORY_COSTING,'N') = 'N';
669:
670: IF SQL%ROWCOUNT = 0 THEN
671: l_return_status := FND_API.G_RET_STS_ERROR;
672: DPP_UTILITY_PVT.debug_message('Unable to Update the column UPDATE_INVENTORY_COSTING in DPP_TRANSACTION_LINES_ALL Table');
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675: END IF;
676: ELSE

Line 704: FROM dpp_transaction_lines_all lines

700: inventory_item_id,
701: supplier_new_price new_price,
702: UOM,
703: headers.trx_currency currency
704: FROM dpp_transaction_lines_all lines
705: WHERE headers.Transaction_header_id = lines.Transaction_header_id
706: AND nvl(lines.NOTIFY_PURCHASING_DOCS,''N'') <> ''D'') LINES
707: FROM dpp_transaction_headers_all headers
708: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 710: FROM dpp_transaction_lines_all

706: AND nvl(lines.NOTIFY_PURCHASING_DOCS,''N'') <> ''D'') LINES
707: FROM dpp_transaction_headers_all headers
708: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
709: 'AND EXISTS (SELECT Transaction_header_id
710: FROM dpp_transaction_lines_all
711: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
712: AND nvl(NOTIFY_PURCHASING_DOCS,''N'') <> ''D'')'
713: );
714: dbms_xmlquery.setRowTag(l_queryCtx

Line 726: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

722: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
723: dbms_xmlquery.closeContext(l_queryCtx);
724:
725: IF l_row_count >0 THEN
726: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
727: UPDATE DPP_TRANSACTION_LINES_ALL
728: SET notify_purchasing_docs = 'P',
729: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
730: last_updated_by = l_user_id,

Line 727: UPDATE DPP_TRANSACTION_LINES_ALL

723: dbms_xmlquery.closeContext(l_queryCtx);
724:
725: IF l_row_count >0 THEN
726: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
727: UPDATE DPP_TRANSACTION_LINES_ALL
728: SET notify_purchasing_docs = 'P',
729: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
730: last_updated_by = l_user_id,
731: last_update_date = sysdate,

Line 738: DPP_UTILITY_PVT.debug_message('Unable to Update the column notify_purchasing_docs in DPP_TRANSACTION_LINES_ALL Table');

734: AND nvl(notify_purchasing_docs ,'N') <> 'D';
735:
736: IF SQL%ROWCOUNT = 0 THEN
737: l_return_status := FND_API.G_RET_STS_ERROR;
738: DPP_UTILITY_PVT.debug_message('Unable to Update the column notify_purchasing_docs in DPP_TRANSACTION_LINES_ALL Table');
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: END IF;
741: END IF;
742: ELSIF p_txn_hdr_rec.process_code = 'UPDTPO' THEN

Line 756: FROM dpp_transaction_lines_all lines

752: inventory_item_id,
753: supplier_new_price new_price,
754: UOM,
755: headers.trx_currency currency
756: FROM dpp_transaction_lines_all lines
757: WHERE headers.Transaction_header_id = lines.Transaction_header_id
758: AND nvl(lines.UPDATE_PURCHASING_DOCS,''N'') = ''N'') LINES
759: FROM dpp_transaction_headers_all headers
760: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 762: FROM dpp_transaction_lines_all

758: AND nvl(lines.UPDATE_PURCHASING_DOCS,''N'') = ''N'') LINES
759: FROM dpp_transaction_headers_all headers
760: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
761: 'AND EXISTS (SELECT Transaction_header_id
762: FROM dpp_transaction_lines_all
763: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
764: AND nvl(UPDATE_PURCHASING_DOCS,''N'') = ''N'')'
765: );
766: dbms_xmlquery.setRowTag(l_queryCtx

Line 778: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

774: l_row_count := dbms_xmlquery.getNumRowsProcessed(l_queryCtx);
775: dbms_xmlquery.closeContext(l_queryCtx);
776:
777: IF l_row_count >0 THEN
778: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
779: UPDATE DPP_TRANSACTION_LINES_ALL
780: SET UPDATE_PURCHASING_DOCS = 'P',
781: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
782: last_updated_by = l_user_id,

Line 779: UPDATE DPP_TRANSACTION_LINES_ALL

775: dbms_xmlquery.closeContext(l_queryCtx);
776:
777: IF l_row_count >0 THEN
778: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
779: UPDATE DPP_TRANSACTION_LINES_ALL
780: SET UPDATE_PURCHASING_DOCS = 'P',
781: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
782: last_updated_by = l_user_id,
783: last_update_date = sysdate,

Line 790: DPP_UTILITY_PVT.debug_message('Unable to Update the column UPDATE_PURCHASING_DOCS in DPP_TRANSACTION_LINES_ALL Table');

786: AND nvl(UPDATE_PURCHASING_DOCS ,'N')= 'N';
787:
788: IF SQL%ROWCOUNT = 0 THEN
789: l_return_status := FND_API.G_RET_STS_ERROR;
790: DPP_UTILITY_PVT.debug_message('Unable to Update the column UPDATE_PURCHASING_DOCS in DPP_TRANSACTION_LINES_ALL Table');
791: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
792: END IF;
793: END IF;
794: ELSIF p_txn_hdr_rec.process_code = 'DSTRINVCL' THEN

Line 855: FROM dpp_transaction_lines_all dtl,

851: dtl.claim_amount claim_line_amount,
852: dtl.approved_inventory CLAIM_QUANTITY,
853: dtl.UOM,
854: headers.trx_currency currency
855: FROM dpp_transaction_lines_all dtl,
856: DPP_TRANSACTION_LINES_GT dtlg
857: WHERE headers.Transaction_header_id = dtl.Transaction_header_id
858: AND dtl.transaction_line_id = dtlg.transaction_line_id
859: AND '||dtl_price_change||'

Line 865: FROM dpp_transaction_lines_all dtla,

861: AND nvl(dtl.SUPP_DIST_CLAIM_STATUS,''N'') = ''N'') LINES
862: FROM dpp_transaction_headers_all headers
863: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
864: 'AND EXISTS (SELECT dtla.Transaction_header_id
865: FROM dpp_transaction_lines_all dtla,
866: DPP_TRANSACTION_LINES_GT dtg
867: WHERE dtla.Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||'
868: AND dtla.transaction_line_id = dtg.transaction_line_id
869: AND nvl(dtla.SUPP_DIST_CLAIM_STATUS,''N'') = ''N''

Line 888: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

884: IF l_row_count >0 THEN
885: IF p_txn_hdr_rec.claim_creation_source = 'EXEDTLS' THEN
886:
887: IF (l_price_change_flag = 'N') THEN -- Only Price Decrease Lines
888: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
889: UPDATE DPP_TRANSACTION_LINES_ALL
890: SET SUPP_DIST_CLAIM_STATUS = 'P',
891: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
892: last_updated_by = l_user_id,

Line 889: UPDATE DPP_TRANSACTION_LINES_ALL

885: IF p_txn_hdr_rec.claim_creation_source = 'EXEDTLS' THEN
886:
887: IF (l_price_change_flag = 'N') THEN -- Only Price Decrease Lines
888: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
889: UPDATE DPP_TRANSACTION_LINES_ALL
890: SET SUPP_DIST_CLAIM_STATUS = 'P',
891: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
892: last_updated_by = l_user_id,
893: last_update_date = sysdate,

Line 902: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');

898: AND nvl(price_change,0) > 0;
899:
900: IF SQL%ROWCOUNT = 0 THEN
901: l_return_status := FND_API.G_RET_STS_ERROR;
902: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END IF;
905: --Update those lines to Y who have the approved inventory as 0
906: UPDATE DPP_TRANSACTION_LINES_ALL

Line 906: UPDATE DPP_TRANSACTION_LINES_ALL

902: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END IF;
905: --Update those lines to Y who have the approved inventory as 0
906: UPDATE DPP_TRANSACTION_LINES_ALL
907: SET SUPP_DIST_CLAIM_STATUS = 'Y',
908: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
909: last_updated_by = l_user_id,
910: last_update_date = sysdate,

Line 916: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table

912: WHERE transaction_header_id = p_txn_hdr_rec.Transaction_Header_ID
913: AND nvl(SUPP_DIST_CLAIM_STATUS ,'N')= 'N'
914: AND (nvl(approved_inventory,0) = 0 OR nvl(price_change,0) <= 0);
915: ELSE -- Both Price Increase and Price Decrease Lines
916: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
917: UPDATE DPP_TRANSACTION_LINES_ALL
918: SET SUPP_DIST_CLAIM_STATUS = 'P',
919: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
920: last_updated_by = l_user_id,

Line 917: UPDATE DPP_TRANSACTION_LINES_ALL

913: AND nvl(SUPP_DIST_CLAIM_STATUS ,'N')= 'N'
914: AND (nvl(approved_inventory,0) = 0 OR nvl(price_change,0) <= 0);
915: ELSE -- Both Price Increase and Price Decrease Lines
916: --Update the line status to PENDING in the DPP_TRANSACTION_LINES_ALL table
917: UPDATE DPP_TRANSACTION_LINES_ALL
918: SET SUPP_DIST_CLAIM_STATUS = 'P',
919: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
920: last_updated_by = l_user_id,
921: last_update_date = sysdate,

Line 930: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');

926: AND nvl(price_change,0) <> 0;
927:
928: IF SQL%ROWCOUNT = 0 THEN
929: l_return_status := FND_API.G_RET_STS_ERROR;
930: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');
931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: END IF;
933: --Update those lines to Y who have the approved inventory as 0
934: UPDATE DPP_TRANSACTION_LINES_ALL

Line 934: UPDATE DPP_TRANSACTION_LINES_ALL

930: DPP_UTILITY_PVT.debug_message('Unable to Update the column SUPP_DIST_CLAIM_STATUS in DPP_TRANSACTION_LINES_ALL Table');
931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: END IF;
933: --Update those lines to Y who have the approved inventory as 0
934: UPDATE DPP_TRANSACTION_LINES_ALL
935: SET SUPP_DIST_CLAIM_STATUS = 'Y',
936: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER +1,
937: last_updated_by = l_user_id,
938: last_update_date = sysdate,

Line 1088: FROM dpp_transaction_lines_all lines

1084: ||l_exe_dtl_id||'Execution_detail_id,
1085: CURSOR(select transaction_line_id,
1086: inventory_item_id,
1087: UOM
1088: FROM dpp_transaction_lines_all lines
1089: WHERE headers.Transaction_header_id = lines.Transaction_header_id
1090: AND lines.price_change > 0 ) LINES
1091: FROM dpp_transaction_headers_all headers
1092: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||

Line 1094: FROM dpp_transaction_lines_all

1090: AND lines.price_change > 0 ) LINES
1091: FROM dpp_transaction_headers_all headers
1092: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1093: 'AND EXISTS (SELECT Transaction_header_id
1094: FROM dpp_transaction_lines_all
1095: WHERE price_change > 0
1096: AND Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||')'
1097: );
1098: dbms_xmlquery.setRowTag(l_queryCtx

Line 1121: FROM dpp_transaction_lines_all lines

1117: ||l_user_id||'user_id,'
1118: ||l_exe_dtl_id||'Execution_detail_id,
1119: CURSOR(select transaction_line_id,
1120: inventory_item_id
1121: FROM dpp_transaction_lines_all lines
1122: WHERE headers.Transaction_header_id = lines.Transaction_header_id) LINES
1123: FROM dpp_transaction_headers_all headers
1124: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1125: 'AND EXISTS (SELECT Transaction_header_id

Line 1126: FROM dpp_transaction_lines_all

1122: WHERE headers.Transaction_header_id = lines.Transaction_header_id) LINES
1123: FROM dpp_transaction_headers_all headers
1124: WHERE headers.Transaction_header_id = ' ||p_txn_hdr_rec.Transaction_Header_ID||
1125: 'AND EXISTS (SELECT Transaction_header_id
1126: FROM dpp_transaction_lines_all
1127: WHERE Transaction_header_id = '||p_txn_hdr_rec.Transaction_Header_ID||')'
1128: );
1129: dbms_xmlquery.setRowTag(l_queryCtx
1130: , 'HEADER'