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 767: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

763:
764: PROCEDURE SET_MS_FLAGS(
765: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE
766: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
767: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
768: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
769: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL
770: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL
771: ,p_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE DEFAULT NULL

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

765: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE
766: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
767: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
768: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
769: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL
770: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL
771: ,p_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE DEFAULT NULL
772: ) AS
773: CURSOR cur_ms IS SELECT inventory_atp_code

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

779: OPEN cur_ms;
780: FETCH cur_ms INTO rec_ms;
781: CLOSE cur_ms;
782: IF p_lot_number IS NOT NULL THEN
783: UPDATE mtl_lot_numbers SET inventory_atp_code =rec_ms.inventory_atp_code,
784: availability_type =rec_ms.reservable_type,
785: reservable_type =rec_ms.availability_type
786: WHERE organization_id = p_org_id
787: AND lot_number = p_lot_number