[Home] [Help]
148: --
149: -- Call user procedure Get_User_Project_Supply
150: -- if user provides further specific business logic
151: -- for defaulting.
152: -- Updates Wip_Requirement_Operations with the
153: -- new supply subinventory and supply locator.
154: --
155: PJM_UserProjectLocator_Pub.Get_UserProjectSupply(
156: p_item_id,
1296: --
1297: --
1298: -- The assumption for this procedure is that
1299: -- the supply subinventory/locator value of those
1300: -- wip_requirement_operations should be common locators.
1301: --
1302: -- Parameters :
1303: -- IN : p_organization_id IN NUMBER
1304: -- : p_locator_id IN NUMBER
1414: -- for project jobs.
1415: --
1416: -- The assumption for this procedure is that
1417: -- the supply subinventory/locator value of those
1418: -- wip_requirement_operations should be common locators.
1419: --
1420: -- Parameters :
1421: -- IN : p_organization_id IN NUMBER
1422: -- : p_wip_entity_id IN NUMBER
1456: SELECT rop.inventory_item_id,
1457: rop.supply_subinventory,
1458: rop.supply_locator_id,
1459: rop.wip_supply_type, rop.rowid
1460: FROM wip_requirement_operations rop
1461: WHERE rop.organization_id = V_org_id
1462: AND rop.wip_entity_id = V_wip_entity_id
1463: AND rop.supply_locator_id is not null
1464: ORDER BY rop.operation_seq_num
1519: raise locator_exe;
1520: else
1521: if L_supply_loc_id <> 0 then
1522: begin
1523: UPDATE wip_requirement_operations rop
1524: SET rop.supply_locator_id = L_supply_loc_id
1525: WHERE rop.rowid = L_row_id;
1526: exception
1527: when others then