[Home] [Help]
1279: FOR cur_row IN req_info(p_group_id,
1280: p_wip_entity_id,
1281: p_organization_id) LOOP
1282:
1283: DELETE FROM WIP_REQUIREMENT_OPERATIONS
1284: WHERE wip_entity_id = p_wip_entity_id
1285: AND organization_id = p_organization_id
1286: AND operation_seq_num = cur_row.operation_seq_num
1287: AND inventory_item_id = cur_row.inventory_item_id_old;
1352: p_organization_id) LOOP
1353:
1354: /** Fix for bug 2649338
1355: -- stripped off time part from date_required and mps_date_required **/
1356: INSERT INTO WIP_REQUIREMENT_OPERATIONS(
1357: wip_entity_id,
1358: organization_id,
1359: operation_seq_num,
1360: inventory_item_id,
1508: p_organization_id) LOOP
1509:
1510: SELECT required_quantity, wip_supply_type, supply_subinventory, supply_locator_id
1511: into l_required_quantity, l_wip_supply_type, l_supply_subinventory, l_supply_locator_id
1512: FROM wip_requirement_operations
1513: WHERE wip_entity_id = p_wip_entity_id
1514: AND organization_id = p_organization_id
1515: AND operation_seq_num = cur_row.operation_seq_num
1516: AND inventory_item_id = cur_row.inventory_item_id_old;
1572: /* update table */
1573: /** Fix for bug 2438722 - correct attribute cols updated **/
1574: /** Fix for bug 2649338
1575: -- stripped off time part from date_required and mps_date_required **/
1576: UPDATE WIP_REQUIREMENT_OPERATIONS
1577: SET inventory_item_id = NVL(cur_row.inventory_item_id_new,
1578: inventory_item_id),
1579: quantity_per_assembly = NVL(round(
1580: cur_row.quantity_per_assembly,6),
2244: /*END bug 3659006 */
2245:
2246: -- Start : Fix Bug#5116297/5129311
2247: -- Update date_required for Components on this Operation
2248: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
2249: SET WRO.DATE_REQUIRED =
2250: (SELECT FIRST_UNIT_START_DATE
2251: FROM WIP_OPERATIONS
2252: WHERE WIP_ENTITY_ID = p_wip_entity_id