1 PACKAGE INV_RESERVATION_LOCK_PVT AS
2 /* $Header: INVLRSVS.pls 120.0 2005/06/30 12:18:25 vipartha noship $ */
3
4 /**** This package is called to create a user-defined lock on the supply or
5 the demand document line between the time the line is queried and the
6 reservations are being created or modified. Equivalent to the lock on the
7 quantity tree for inventory supplies ****/
8
9 PROCEDURE lock_supply_demand_record
10 (p_organization_id IN NUMBER
11 ,p_inventory_item_id IN NUMBER
12 ,p_source_type_id IN NUMBER
13 ,p_source_header_id IN NUMBER
14 ,p_source_line_id IN NUMBER
15 ,p_source_line_detail IN NUMBER
16 ,x_lock_handle OUT NOCOPY VARCHAR2
17 ,x_lock_status OUT NOCOPY NUMBER);
18
19 /**** This package is called to get the lock handle on the supply or
20 the demand document line when the lock is being created ****/
21 PROCEDURE get_lock_handle
22 (p_lock_name IN VARCHAR2,
23 x_lock_handle OUT NOCOPY VARCHAR2);
24
25 /**** This package is called to release the lock of supply or
26 the demand document after the lock has been created and the reservations
27 have been successfully created/ modified ****/
28 PROCEDURE release_lock(p_lock_handle IN VARCHAR2);
29 END INV_RESERVATION_LOCK_PVT;