APPS.DPP_UTILITY_PVT dependencies on DPP_INVENTORY_DETAILS_ALL

Line 1366: FROM DPP_INVENTORY_DETAILS_ALL

1362: DELETE
1363: FROM DPP_INVENTORY_DETAILS_ADJ_ALL
1364: WHERE INVENTORY_DETAILS_ID IN
1365: (SELECT INVENTORY_DETAILS_ID
1366: FROM DPP_INVENTORY_DETAILS_ALL
1367: WHERE org_id = l_hdr_rec.org_id
1368: AND transaction_line_id = l_inventorydetails_tbl(i).Transaction_Line_Id);
1369:
1370: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)

Line 1370: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)

1366: FROM DPP_INVENTORY_DETAILS_ALL
1367: WHERE org_id = l_hdr_rec.org_id
1368: AND transaction_line_id = l_inventorydetails_tbl(i).Transaction_Line_Id);
1369:
1370: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)
1371: DELETE
1372: FROM DPP_INVENTORY_DETAILS_ALL
1373: WHERE org_id = l_hdr_rec.org_id
1374: AND transaction_line_id = l_inventorydetails_tbl(i).Transaction_Line_Id;

Line 1372: FROM DPP_INVENTORY_DETAILS_ALL

1368: AND transaction_line_id = l_inventorydetails_tbl(i).Transaction_Line_Id);
1369:
1370: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)
1371: DELETE
1372: FROM DPP_INVENTORY_DETAILS_ALL
1373: WHERE org_id = l_hdr_rec.org_id
1374: AND transaction_line_id = l_inventorydetails_tbl(i).Transaction_Line_Id;
1375: --Get the ware house level details only if the covered inventory is > 0
1376: IF l_inventorydetails_tbl(i).covered_quantity > 0 THEN

Line 1385: INSERT INTO DPP_INVENTORY_DETAILS_ALL(

1381:
1382: SELECT DPP_INVENTORY_DETAILS_SEQ.nextval INTO l_inv_details_id FROM DUAL;
1383: l_flag := 'N';
1384: -- Insert new row
1385: INSERT INTO DPP_INVENTORY_DETAILS_ALL(
1386: inventory_details_id,
1387: transaction_line_id,
1388: quantity,
1389: uom,

Line 1477: UPDATE DPP_INVENTORY_DETAILS_ALL

1473: );
1474:
1475: END LOOP; -- rct loop
1476: IF l_flag = 'Y' THEN
1477: UPDATE DPP_INVENTORY_DETAILS_ALL
1478: SET include_flag = 'Y',
1479: object_version_number = object_version_number + 1,
1480: last_update_date = l_sysdate,
1481: last_updated_by = l_user_id,