[Home] [Help]
147: --
148: -- Call user procedure Get_User_Project_Supply
149: -- if user provides further specific business logic
150: -- for defaulting.
151: -- Updates Wip_Requirement_Operations with the
152: -- new supply subinventory and supply locator.
153: --
154: PJM_UserProjectLocator_Pub.Get_UserProjectSupply(
155: p_item_id,
1241: --
1242: --
1243: -- The assumption for this procedure is that
1244: -- the supply subinventory/locator value of those
1245: -- wip_requirement_operations should be common locators.
1246: --
1247: -- Parameters :
1248: -- IN : p_organization_id IN NUMBER
1249: -- : p_locator_id IN NUMBER
1355: -- for project jobs.
1356: --
1357: -- The assumption for this procedure is that
1358: -- the supply subinventory/locator value of those
1359: -- wip_requirement_operations should be common locators.
1360: --
1361: -- Parameters :
1362: -- IN : p_organization_id IN NUMBER
1363: -- : p_wip_entity_id IN NUMBER
1397: SELECT rop.inventory_item_id,
1398: rop.supply_subinventory,
1399: rop.supply_locator_id,
1400: rop.wip_supply_type, rop.rowid
1401: FROM wip_requirement_operations rop
1402: WHERE rop.organization_id = V_org_id
1403: AND rop.wip_entity_id = V_wip_entity_id
1404: AND rop.supply_locator_id is not null
1405: ORDER BY rop.operation_seq_num
1460: raise locator_exe;
1461: else
1462: if L_supply_loc_id <> 0 then
1463: begin
1464: UPDATE wip_requirement_operations rop
1465: SET rop.supply_locator_id = L_supply_loc_id
1466: WHERE rop.rowid = L_row_id;
1467: exception
1468: when others then