PACKAGE: APPS.INV_MATERIAL_STATUS_PKG

Source

1 PACKAGE INV_MATERIAL_STATUS_PKG as
2 /* $Header: INVMSPVS.pls 120.1.12010000.2 2008/07/29 13:41:54 ptkumar ship $ */
3 
4 Function status_assigned(p_status_id IN NUMBER) return Boolean;
5 
6 Function get_default_locator_status(
7                            p_organization_id     IN NUMBER,
8                            p_sub_code            IN VARCHAR2
9                            ) return NUMBER;
10 
11 PROCEDURE  Initialize_status_rec(px_status_rec
12                                  IN OUT NOCOPY INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type );
13 
14 Procedure Insert_status_history(
15        p_status_rec  IN INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type );
16 
17 --INVCONV kkillams
18 FUNCTION VALIDATE_MTSTATUS(
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 */
28 FUNCTION VALIDATE_MTSTATUS(
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 )RETURN BOOLEAN;
37 
38 PROCEDURE SET_MS_FLAGS(
39  p_status_id                MTL_MATERIAL_STATUSES.STATUS_ID%TYPE
40 ,p_org_id                   MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
41 ,p_inventory_item_id        MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
42 ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
43 ,p_lot_number               MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL
44 ,p_inventory_location_id    MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL
45 ,p_serial_number            MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE DEFAULT NULL
46 );
47 
48 --END INVCONV kkillams
49 
50 END INV_MATERIAL_STATUS_PKG;