PACKAGE: APPS.INV_TABLE_LOCK_PVT

Source

1 PACKAGE INV_TABLE_LOCK_PVT AUTHID CURRENT_USER AS
2 /* $Header: INVLOCKS.pls 120.4.12010000.2 2009/05/15 22:34:02 musinha ship $ */
3 
4  FUNCTION lock_onhand_records (
5           p_organization_id   IN NUMBER
6         , p_inventory_item_id IN NUMBER
7         , p_revision          IN VARCHAR2
8         , p_lot               IN VARCHAR2
9         , p_subinventory      IN VARCHAR2
10         , p_locator           IN VARCHAR2
11 	      , p_issue_receipt     IN NUMBER
12         , p_header_id         IN NUMBER) RETURN BOOLEAN;
13 
14  PROCEDURE get_lock_handle (
15           p_header_id   IN         NUMBER
16         , p_lock_name   IN         VARCHAR2
17 			  , x_lock_handle OUT NOCOPY VARCHAR2);
18 
19  PROCEDURE release_locks;
20 
21  PROCEDURE release_locks(
22           p_header_id IN NUMBER
23         , p_commit    IN NUMBER DEFAULT 0);
24 
25  -- Bug 6636261: Acquiring lock for a row in MLN
26  PROCEDURE lock_lot_record ( p_organization_id   IN NUMBER
27                             ,p_inventory_item_id IN NUMBER
28                             ,p_lot IN VARCHAR2);
29 
30  -- Bug 6636261: Acquiring lock handle for a row in MLN
31  PROCEDURE get_lot_lock_handle ( p_lock_name IN VARCHAR2
32                                 ,x_lock_handle OUT NOCOPY VARCHAR2 );
33 
34 
35 END INV_TABLE_LOCK_PVT;