APPS.DPP_UTILITY_PVT dependencies on DPP_INVENTORY_DETAILS_ALL

Line 1330: FROM DPP_INVENTORY_DETAILS_ALL

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
1332: AND transaction_line_id = l_inventorydetails_tbl(i).Transaction_Line_Id);
1333:
1334: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)

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

1330: FROM DPP_INVENTORY_DETAILS_ALL
1331: WHERE org_id = l_hdr_rec.org_id
1332: AND transaction_line_id = l_inventorydetails_tbl(i).Transaction_Line_Id);
1333:
1334: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)
1335: DELETE
1336: FROM DPP_INVENTORY_DETAILS_ALL
1337: WHERE org_id = l_hdr_rec.org_id
1338: AND transaction_line_id = l_inventorydetails_tbl(i).Transaction_Line_Id;

Line 1336: FROM DPP_INVENTORY_DETAILS_ALL

1332: AND transaction_line_id = l_inventorydetails_tbl(i).Transaction_Line_Id);
1333:
1334: -- Delete existing rows in DPP_INVENTORY_DETAILS_ALL (if any)
1335: DELETE
1336: FROM DPP_INVENTORY_DETAILS_ALL
1337: WHERE org_id = l_hdr_rec.org_id
1338: AND transaction_line_id = l_inventorydetails_tbl(i).Transaction_Line_Id;
1339: --Get the ware house level details only if the covered inventory is > 0
1340: IF l_inventorydetails_tbl(i).covered_quantity > 0 THEN

Line 1349: INSERT INTO DPP_INVENTORY_DETAILS_ALL(

1345:
1346: SELECT DPP_INVENTORY_DETAILS_SEQ.nextval INTO l_inv_details_id FROM DUAL;
1347: l_flag := 'N';
1348: -- Insert new row
1349: INSERT INTO DPP_INVENTORY_DETAILS_ALL(
1350: inventory_details_id,
1351: transaction_line_id,
1352: quantity,
1353: uom,

Line 1441: UPDATE DPP_INVENTORY_DETAILS_ALL

1437: );
1438:
1439: END LOOP; -- rct loop
1440: IF l_flag = 'Y' THEN
1441: UPDATE DPP_INVENTORY_DETAILS_ALL
1442: SET include_flag = 'Y',
1443: object_version_number = object_version_number + 1,
1444: last_update_date = l_sysdate,
1445: last_updated_by = l_user_id,