1 PACKAGE inv_trx_relief_c_pvt AS
2 /* $Header: INVRSV8S.pls 120.2 2006/06/13 14:44:19 aalex noship $*/
3 -- This procedure should be called only by TrxRsvRelief in inldqc.ppc
4 PROCEDURE rsv_relief
5 ( x_return_status OUT NOCOPY VARCHAR2, -- return status
6 x_msg_count OUT NOCOPY NUMBER,
7 x_msg_data OUT NOCOPY VARCHAR2,
8 x_ship_qty OUT NOCOPY NUMBER, -- shipped quantity
9 x_userline OUT NOCOPY VARCHAR2, -- user line number
10 x_demand_class OUT NOCOPY VARCHAR2, -- demand class
11 x_mps_flag OUT NOCOPY NUMBER, -- mrp installed or not (1 yes, 0 no)
12 p_organization_id IN NUMBER, -- org id
13 p_inventory_item_id IN NUMBER, -- inventory item id
14 p_subinv IN VARCHAR2, -- subinventory
15 p_locator IN NUMBER, -- locator id
16 p_lotnumber IN VARCHAR2, -- lot number
17 p_revision IN VARCHAR2, -- revision
18 p_dsrc_type IN NUMBER, -- demand source type
19 p_header_id IN NUMBER, -- demand source header id
20 p_dsrc_name IN VARCHAR2, -- demand source name
21 p_dsrc_line IN NUMBER, -- demand source line id
22 p_dsrc_delivery IN NUMBER, -- demand source delivery
23 p_qty_at_puom IN NUMBER, -- primary quantity
24 p_lpn_id IN NUMBER default NULL
25 );
26
27 -- INVCONV BEGIN
28 -- Overload to process secondary quantities alongside primary quantities
29 PROCEDURE rsv_relief
30 ( x_return_status OUT NOCOPY VARCHAR2, -- return status
31 x_msg_count OUT NOCOPY NUMBER,
32 x_msg_data OUT NOCOPY VARCHAR2,
33 x_ship_qty OUT NOCOPY NUMBER, -- shipped quantity
34 x_secondary_ship_qty OUT NOCOPY NUMBER, -- secondary shipped quantity INVCONV SPECIFIC
35 x_userline OUT NOCOPY VARCHAR2, -- user line number
36 x_demand_class OUT NOCOPY VARCHAR2, -- demand class
37 x_mps_flag OUT NOCOPY NUMBER, -- mrp installed or not (1 yes, 0 no)
38 p_organization_id IN NUMBER, -- org id
39 p_inventory_item_id IN NUMBER, -- inventory item id
40 p_subinv IN VARCHAR2, -- subinventory
41 p_locator IN NUMBER, -- locator id
42 p_lotnumber IN VARCHAR2, -- lot number
43 p_revision IN VARCHAR2, -- revision
44 p_dsrc_type IN NUMBER, -- demand source type
45 p_header_id IN NUMBER, -- demand source header id
46 p_dsrc_name IN VARCHAR2, -- demand source name
47 p_dsrc_line IN NUMBER, -- demand source line id
48 p_dsrc_delivery IN NUMBER, -- demand source delivery
49 p_qty_at_puom IN NUMBER, -- primary quantity
50 p_qty_at_suom IN NUMBER, -- secondary quantity INVCONV SPECIFIC
51 p_lpn_id IN NUMBER default NULL,
52 p_transaction_id IN NUMBER DEFAULT NULL -- Bug 3517647: Passing transaction id
53
54 );
55 -- INVCONV END
56
57 FUNCTION rsv_relieve(p_transaction_header_id NUMBER) RETURN NUMBER;
58 END inv_trx_relief_c_pvt;