1 PACKAGE gme_complete_batch_pvt AUTHID CURRENT_USER AS
2 /* $Header: GMEVCMBS.pls 120.4 2005/10/12 14:33:44 anewbury noship $ */
3
4 PROCEDURE complete_batch
5 (p_batch_header_rec IN gme_batch_header%ROWTYPE
6 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
7 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
8 ,x_return_status OUT NOCOPY VARCHAR2);
9
10 PROCEDURE process_material
11 (p_material_detail_rec IN gme_material_details%ROWTYPE
12 ,p_yield IN BOOLEAN
13 ,p_trans_date IN DATE
14 ,p_update_inv_ind IN VARCHAR2
15 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
16 ,x_return_status OUT NOCOPY VARCHAR2);
17
18 PROCEDURE yield_material(p_material_dtl_rec IN gme_material_details%ROWTYPE
19 ,p_yield_qty IN NUMBER
20 ,p_trans_date IN DATE
21 ,p_item_rec IN mtl_system_items_b%ROWTYPE
22 ,p_force_unconsumed IN VARCHAR2
23 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
24 ,x_actual_qty OUT NOCOPY NUMBER
25 ,x_return_status OUT NOCOPY VARCHAR2);
26
27 PROCEDURE build_and_create_transaction
28 (p_mtl_dtl_rec IN gme_material_details%ROWTYPE
29 ,p_pp_lot_rec IN gme_pending_product_lots%ROWTYPE
30 ,p_subinv IN VARCHAR2
31 ,p_locator_id IN NUMBER
32 ,p_trans_date IN DATE
33 ,p_yield_qty IN NUMBER
34 ,p_revision IN VARCHAR2 DEFAULT NULL
35 ,p_sec_uom_code IN VARCHAR2 DEFAULT NULL
36 ,x_actual_qty IN OUT NOCOPY NUMBER
37 ,x_return_status OUT NOCOPY VARCHAR2);
38
39 PROCEDURE constr_mmti
40 (p_mtl_dtl_rec IN gme_material_details%ROWTYPE
41 ,p_yield_qty IN NUMBER
42 ,p_subinv IN VARCHAR2
43 ,p_locator_id IN NUMBER
44 ,p_revision IN VARCHAR2
45 ,p_pp_lot_rec IN gme_pending_product_lots%ROWTYPE
46 ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
47 ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
48 ,x_sec_qty OUT NOCOPY NUMBER
49 ,x_dtl_qty OUT NOCOPY NUMBER
50 ,x_return_status OUT NOCOPY VARCHAR2);
51
52 PROCEDURE validate_batch_for_complete
53 (p_batch_header_rec IN gme_batch_header%ROWTYPE
54 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
55 ,x_return_status OUT NOCOPY VARCHAR2);
56
57
58 END gme_complete_batch_pvt;