DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on DPP_INVENTORY_DETAILS_ADJ_ALL

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

1321: --IF covered inventory is negative then reassign it to 0
1322: IF l_inventorydetails_tbl(i).covered_quantity < 0 THEN
1323: l_inventorydetails_tbl(i).covered_quantity := 0;
1324: END IF;
1325: -- Delete existing rows in DPP_INVENTORY_DETAILS_ADJ_ALL (if any)
1326: DELETE
1327: FROM DPP_INVENTORY_DETAILS_ADJ_ALL
1328: WHERE INVENTORY_DETAILS_ID IN
1329: (SELECT INVENTORY_DETAILS_ID

Line 1327: FROM DPP_INVENTORY_DETAILS_ADJ_ALL

1323: l_inventorydetails_tbl(i).covered_quantity := 0;
1324: END IF;
1325: -- Delete existing rows in DPP_INVENTORY_DETAILS_ADJ_ALL (if any)
1326: DELETE
1327: FROM DPP_INVENTORY_DETAILS_ADJ_ALL
1328: WHERE INVENTORY_DETAILS_ID IN
1329: (SELECT INVENTORY_DETAILS_ID
1330: FROM DPP_INVENTORY_DETAILS_ALL
1331: WHERE org_id = l_hdr_rec.org_id

Line 1405: INTO DPP_INVENTORY_DETAILS_ADJ_ALL(

1401: END IF;
1402: END;
1403:
1404: INSERT
1405: INTO DPP_INVENTORY_DETAILS_ADJ_ALL(
1406: inv_details_adj_id,
1407: inventory_details_id,
1408: date_received,
1409: days_out,