APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_LOT_NUMBERS

Line 46: from mtl_lot_numbers

42: select 1
43: into count_assigned
44: from dual
45: where exists (select 1
46: from mtl_lot_numbers
47: where status_id = p_status_id);
48:
49: if count_assigned >0 then
50: return TRUE;

Line 970: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

966:
967: PROCEDURE SET_MS_FLAGS(
968: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE
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

Line 972: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL

968: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE
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

Line 986: UPDATE mtl_lot_numbers SET inventory_atp_code =rec_ms.inventory_atp_code,

982: OPEN cur_ms;
983: FETCH cur_ms INTO rec_ms;
984: CLOSE cur_ms;
985: IF p_lot_number IS NOT NULL THEN
986: UPDATE mtl_lot_numbers SET inventory_atp_code =rec_ms.inventory_atp_code,
987: availability_type =rec_ms.reservable_type,
988: reservable_type =rec_ms.availability_type
989: WHERE organization_id = p_org_id
990: AND lot_number = p_lot_number