DBA Data[Home] [Help]

PACKAGE: APPS.INV_RESERVATION_LOCK_PVT

Source


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;