[Home] [Help]
1669: begin
1670:
1671: select 1, max (direct_item_sequence_id), sum(nvl(required_quantity,0))
1672: into l_status , l_direct_item_id, l_required_quantity
1673: from wip_eam_direct_items
1674: where wip_entity_id = l_wip_entity_id
1675: and organization_id = l_organization_id
1676: and operation_seq_num = l_operation_seq_num
1677: and description = l_item_description;
1677: and description = l_item_description;
1678:
1679: select uom
1680: into l_uom
1681: from wip_eam_direct_items
1682: where wip_entity_id = l_wip_entity_id
1683: and organization_id = l_organization_id
1684: and operation_seq_num = l_operation_seq_num
1685: and description = l_item_description
1713:
1714:
1715: if (l_quantity_received > l_required_quantity ) then
1716:
1717: update wip_eam_direct_items
1718: set required_quantity = l_quantity_received
1719: where wip_entity_id = l_wip_entity_id
1720: and organization_id = l_organization_id
1721: and operation_seq_num = l_operation_seq_num
1723:
1724: end if;
1725:
1726: if ( l_order_type_lookup_code = 'AMOUNT') then
1727: update wip_eam_direct_items
1728: set required_quantity = nvl(l_quantity_received,0),
1729: amount = amount + p_unit_price
1730: where wip_entity_id = l_wip_entity_id
1731: and organization_id = l_organization_id
1739: WHEN NO_DATA_FOUND then
1740:
1741:
1742:
1743: insert into WIP_EAM_DIRECT_ITEMS
1744: (DESCRIPTION,
1745: PURCHASING_CATEGORY_ID,
1746: DIRECT_ITEM_SEQUENCE_ID,
1747: OPERATION_SEQ_NUM,
1785: FND_GLOBAL.USER_ID,
1786: l_order_type_lookup_code,
1787: l_unit_price );
1788:
1789: end; -- end of insertion into WIP_EAM_DIRECT_ITEMS table
1790:
1791: end if; -- end of l_resource_seq_num
1792:
1793: end if; -- end of l_item_id, l_operation_seq_num, l_organization_id not null