DBA Data[Home] [Help]

APPS.DPP_COVEREDINVENTORY_PVT dependencies on DPP_INVENTORY_DETAILS_ADJ_ALL

Line 664: -- Delete existing rows in DPP_INVENTORY_DETAILS_ADJ_ALL (if any)

660: l_txn_lines_tbl(i).onhand_inventory := NVL(l_covered_inv_tbl(i).Onhand_Quantity,0);
661:
662: BEGIN
663: DPP_UTILITY_PVT.debug_message('Org Id: ' || l_inv_hdr_rec.org_id || 'transaction_line_id ' || l_covered_inv_tbl(i).Transaction_Line_Id);
664: -- Delete existing rows in DPP_INVENTORY_DETAILS_ADJ_ALL (if any)
665: SELECT
666: inventory_details_id
667: BULK COLLECT INTO
668: inventory_details_ids

Line 677: FROM DPP_INVENTORY_DETAILS_ADJ_ALL

673: AND transaction_line_id = l_covered_inv_tbl(i).Transaction_Line_Id;
674:
675: FORALL indx IN inventory_details_ids.FIRST .. inventory_details_ids .LAST
676: DELETE
677: FROM DPP_INVENTORY_DETAILS_ADJ_ALL
678: WHERE INVENTORY_DETAILS_ID = inventory_details_ids(indx);
679:
680: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)
681: DELETE

Line 757: INSERT INTO DPP_INVENTORY_DETAILS_ADJ_ALL(

753: END IF;
754: END IF;
755: END;
756:
757: INSERT INTO DPP_INVENTORY_DETAILS_ADJ_ALL(
758: inv_details_adj_id,
759: inventory_details_id,
760: date_received,
761: days_out,