APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_ITEM_LOCATIONS

Line 32: from mtl_item_locations

28: select 1
29: into count_assigned
30: from dual
31: where exists (select 1
32: from mtl_item_locations
33: where status_id = p_status_id);
34:
35: if count_assigned >0 then
36: return TRUE;

Line 973: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL

969: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
970: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
971: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
972: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL
973: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL
974: ,p_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE DEFAULT NULL
975: ) AS
976: CURSOR cur_ms IS SELECT inventory_atp_code
977: ,reservable_type

Line 1007: UPDATE MTL_ITEM_LOCATIONS SET inventory_atp_code =rec_ms.inventory_atp_code,

1003: AND inventory_item_id = p_inventory_item_id;
1004: */
1005: NULL;
1006: ELSIF p_inventory_location_id IS NOT NULL THEN
1007: UPDATE MTL_ITEM_LOCATIONS SET inventory_atp_code =rec_ms.inventory_atp_code,
1008: availability_type =rec_ms.reservable_type,
1009: reservable_type =rec_ms.availability_type
1010: WHERE organization_id = p_org_id
1011: AND inventory_location_id = p_inventory_location_id;