PACKAGE: APPS.INV_MATERIAL_STATUS_PKG

Source

1 PACKAGE INV_MATERIAL_STATUS_PKG AUTHID CURRENT_USER as
2 /* $Header: INVMSPVS.pls 120.4.12020000.2 2012/08/06 23:07:54 rahubatr 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 p_lpn_id                mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
37 )RETURN BOOLEAN;
38 
39 /* ER 7530736: Overloaded Method */
40 FUNCTION validate_mtstatus(
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
50 )RETURN BOOLEAN;
51 
52 /* bug 10171471 call VALIDATE_MTSTATUS to Return char  */
53 FUNCTION VALIDATE_MTSTATUS2 (
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 
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 );
72 
73 --END INVCONV kkillams
74 
75 END INV_MATERIAL_STATUS_PKG;