DBA Data[Home] [Help]

APPS.DPP_COVEREDINVENTORY_PVT dependencies on DPP_INVENTORY_DETAILS_ADJ_ALL

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

715: BEGIN
716:
717: DPP_UTILITY_PVT.DEBUG_MESSAGE( FND_LOG.LEVEL_STATEMENT, 'dpp.plsql.' || L_FULL_NAME, 'Org Id: ' || l_inv_hdr_rec.org_id || 'transaction_line_id ' || l_covered_inv_tbl(i).Transaction_Line_Id);
718:
719: -- Delete existing rows in DPP_INVENTORY_DETAILS_ADJ_ALL (if any)
720: SELECT
721: inventory_details_id
722: BULK COLLECT INTO
723: inventory_details_ids

Line 732: FROM DPP_INVENTORY_DETAILS_ADJ_ALL

728: AND transaction_line_id = l_covered_inv_tbl(i).Transaction_Line_Id;
729:
730: FORALL indx IN inventory_details_ids.FIRST .. inventory_details_ids .LAST
731: DELETE
732: FROM DPP_INVENTORY_DETAILS_ADJ_ALL
733: WHERE INVENTORY_DETAILS_ID = inventory_details_ids(indx);
734:
735: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)
736: DELETE

Line 814: INSERT INTO DPP_INVENTORY_DETAILS_ADJ_ALL(

810: END IF;
811: END IF;
812: END;
813:
814: INSERT INTO DPP_INVENTORY_DETAILS_ADJ_ALL(
815: inv_details_adj_id,
816: inventory_details_id,
817: date_received,
818: days_out,