DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_HOOK dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 6: p_subinventory_code IN mtl_onhand_quantities_detail.subinventory_code%TYPE,

2: /* $Header: INVMSHKB.pls 120.0.12010000.2 2009/04/27 22:51:50 musinha noship $ */
3:
4: PROCEDURE validate_rsv_matstatus (p_old_status_id IN mtl_material_statuses.status_id%TYPE,
5: p_new_status_id IN mtl_material_statuses.status_id%TYPE,
6: p_subinventory_code IN mtl_onhand_quantities_detail.subinventory_code%TYPE,
7: p_locator_id IN mtl_onhand_quantities_detail.locator_id%TYPE,
8: p_organization_id IN mtl_secondary_inventories.organization_id%TYPE,
9: p_inventory_item_id IN mtl_onhand_quantities_detail.inventory_item_id%TYPE,
10: p_lot_number IN mtl_onhand_quantities_detail.lot_number%TYPE,

Line 7: p_locator_id IN mtl_onhand_quantities_detail.locator_id%TYPE,

3:
4: PROCEDURE validate_rsv_matstatus (p_old_status_id IN mtl_material_statuses.status_id%TYPE,
5: p_new_status_id IN mtl_material_statuses.status_id%TYPE,
6: p_subinventory_code IN mtl_onhand_quantities_detail.subinventory_code%TYPE,
7: p_locator_id IN mtl_onhand_quantities_detail.locator_id%TYPE,
8: p_organization_id IN mtl_secondary_inventories.organization_id%TYPE,
9: p_inventory_item_id IN mtl_onhand_quantities_detail.inventory_item_id%TYPE,
10: p_lot_number IN mtl_onhand_quantities_detail.lot_number%TYPE,
11: x_ret_status IN OUT NOCOPY BOOLEAN) IS

Line 9: p_inventory_item_id IN mtl_onhand_quantities_detail.inventory_item_id%TYPE,

5: p_new_status_id IN mtl_material_statuses.status_id%TYPE,
6: p_subinventory_code IN mtl_onhand_quantities_detail.subinventory_code%TYPE,
7: p_locator_id IN mtl_onhand_quantities_detail.locator_id%TYPE,
8: p_organization_id IN mtl_secondary_inventories.organization_id%TYPE,
9: p_inventory_item_id IN mtl_onhand_quantities_detail.inventory_item_id%TYPE,
10: p_lot_number IN mtl_onhand_quantities_detail.lot_number%TYPE,
11: x_ret_status IN OUT NOCOPY BOOLEAN) IS
12:
13: l_debug NUMBER;

Line 10: p_lot_number IN mtl_onhand_quantities_detail.lot_number%TYPE,

6: p_subinventory_code IN mtl_onhand_quantities_detail.subinventory_code%TYPE,
7: p_locator_id IN mtl_onhand_quantities_detail.locator_id%TYPE,
8: p_organization_id IN mtl_secondary_inventories.organization_id%TYPE,
9: p_inventory_item_id IN mtl_onhand_quantities_detail.inventory_item_id%TYPE,
10: p_lot_number IN mtl_onhand_quantities_detail.lot_number%TYPE,
11: x_ret_status IN OUT NOCOPY BOOLEAN) IS
12:
13: l_debug NUMBER;
14: BEGIN