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;