DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 23: p_organization_id mtl_secondary_inventories.organization_id%TYPE,

19: p_old_status_id mtl_material_statuses.status_id%TYPE,
20: p_new_status_id mtl_material_statuses.status_id%TYPE ,
21: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
22: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
23: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
24: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE
25: )RETURN BOOLEAN;
26:
27: /* bug 6866429: Overloaded Method */

Line 33: p_organization_id mtl_secondary_inventories.organization_id%TYPE,

29: p_old_status_id mtl_material_statuses.status_id%TYPE,
30: p_new_status_id mtl_material_statuses.status_id%TYPE ,
31: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
32: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
33: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
34: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
35: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6866429 */
36: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
37: )RETURN BOOLEAN;

Line 45: p_organization_id mtl_secondary_inventories.organization_id%TYPE,

41: p_old_status_id mtl_material_statuses.status_id%TYPE,
42: p_new_status_id mtl_material_statuses.status_id%TYPE ,
43: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
44: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
45: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
46: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
47: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */
48: p_dummy_param NUMBER,
49: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066

Line 58: p_organization_id mtl_secondary_inventories.organization_id%TYPE,

54: p_old_status_id mtl_material_statuses.status_id%TYPE,
55: p_new_status_id mtl_material_statuses.status_id%TYPE ,
56: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
57: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
58: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
59: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
60: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE
61: )RETURN CHAR;
62:

Line 65: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE

61: )RETURN CHAR;
62:
63: PROCEDURE SET_MS_FLAGS(
64: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE
65: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
66: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
67: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
68: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL
69: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL

Line 67: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL

63: PROCEDURE SET_MS_FLAGS(
64: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE
65: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
66: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
67: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
68: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL
69: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL
70: ,p_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE DEFAULT NULL
71: );