DBA Data[Home] [Help]

PACKAGE: APPS.INV_TABLE_LOCK_PVT

Source


1 PACKAGE INV_TABLE_LOCK_PVT AS
2 /* $Header: INVLOCKS.pls 120.4 2006/03/25 07:11:13 ramarava 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 END INV_TABLE_LOCK_PVT;