1 PACKAGE gme_unrelease_batch_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVURBS.pls 120.8.12010000.2 2009/04/28 00:38:24 srpuri ship $ */
3 PROCEDURE unrelease_batch (
4 p_batch_header_rec IN gme_batch_header%ROWTYPE
5 ,p_create_resv_pend_lots IN NUMBER
6 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
7 ,x_return_status OUT NOCOPY VARCHAR2);
8
9 PROCEDURE revert_material_full (
10 p_material_detail_rec IN gme_material_details%ROWTYPE
11 ,p_create_resv_pend_lots IN NUMBER
12 ,p_ignore_transactable IN BOOLEAN DEFAULT FALSE
13 ,x_actual_qty OUT NOCOPY NUMBER
14 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
15 ,x_return_status OUT NOCOPY VARCHAR2);
16
17 PROCEDURE unrelease_material (
18 p_material_detail_rec IN gme_material_details%ROWTYPE
19 ,p_update_inventory_ind IN VARCHAR2
20 ,p_create_resv_pend_lots IN NUMBER
21 ,p_from_batch IN BOOLEAN
22 ,x_return_status OUT NOCOPY VARCHAR2);
23
24 PROCEDURE validate_batch_for_unrelease
25 (p_batch_hdr_rec IN gme_batch_header%ROWTYPE
26 ,x_return_status OUT NOCOPY VARCHAR2);
27
28 -- nsinghi Bug5176319. Added the proc.
29 PROCEDURE create_matl_resv_pplot (
30 p_material_dtl_id IN NUMBER,
31 p_transaction_id IN NUMBER, -- Bug 6997483
32 x_return_status OUT NOCOPY VARCHAR2);
33
34 PROCEDURE create_resv_pplot (
35 p_material_detail_rec IN gme_material_details%ROWTYPE
36 ,p_mmt_rec IN mtl_material_transactions%ROWTYPE
37 ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
38 ,x_return_status OUT NOCOPY VARCHAR2);
39
40 /* Bug 5021522 added function RETURNS TRUE if inv will go negative and org control does not allow it */
41 FUNCTION check_inv_negative(p_mmt_rec IN mtl_material_transactions%ROWTYPE,
42 p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl,
43 p_org_neg_control IN NUMBER DEFAULT gme_common_pvt.g_allow_neg_inv,
44 p_item_no IN VARCHAR2) RETURN BOOLEAN;
45 END gme_unrelease_batch_pvt;