1 PACKAGE gme_release_batch_pvt AS
2 /* $Header: GMEVRLBS.pls 120.9.12010000.1 2008/07/25 10:31:32 appldev ship $ */
3
4 g_bypass_txn_creation NUMBER := 0;
5
6 PROCEDURE release_batch
7 (p_batch_header_rec IN gme_batch_header%ROWTYPE
8 ,p_phantom_product_id IN NUMBER DEFAULT NULL
9 ,p_yield IN BOOLEAN DEFAULT NULL
10 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
11 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
12 ,x_return_status OUT NOCOPY VARCHAR2);
13
14 PROCEDURE process_ingredient
15 (p_material_detail_rec IN gme_material_details%ROWTYPE
16 ,p_consume IN BOOLEAN
17 ,p_trans_date IN DATE
18 ,p_update_inv_ind IN VARCHAR2
19 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
20 ,x_return_status OUT NOCOPY VARCHAR2);
21
22 PROCEDURE consume_material(p_material_dtl_rec IN gme_material_details%ROWTYPE
23 ,p_consume_qty IN NUMBER := NULL
24 ,p_trans_date IN DATE := NULL
25 ,p_item_rec IN mtl_system_items_b%ROWTYPE
26 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
27 ,x_actual_qty OUT NOCOPY NUMBER
28 ,x_return_status OUT NOCOPY VARCHAR2);
29 PROCEDURE build_and_create_transaction
30 (p_rsrv_rec IN mtl_reservations%ROWTYPE
31 ,p_lot_divisible_flag IN VARCHAR2 DEFAULT NULL -- required for lot non divisible
32 ,p_dispense_ind IN VARCHAR2 DEFAULT NULL
33 ,p_subinv IN VARCHAR2 DEFAULT NULL
34 ,p_locator_id IN NUMBER DEFAULT NULL
35 ,p_att IN NUMBER DEFAULT NULL
36 ,p_satt IN NUMBER DEFAULT NULL
37 ,p_primary_uom_code IN VARCHAR2 DEFAULT NULL
38 ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE
39 ,p_trans_date IN DATE
40 ,p_consume_qty IN NUMBER
41 ,p_revision IN VARCHAR2 DEFAULT NULL
42 ,p_secondary_uom_code IN VARCHAR2 DEFAULT NULL
43 ,x_actual_qty IN OUT NOCOPY NUMBER
44 ,x_return_status OUT NOCOPY VARCHAR2);
45
46 PROCEDURE constr_mmti_from_reservation
47 (p_rsrv_rec IN mtl_reservations%ROWTYPE
48 ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
49 ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
50 ,x_return_status OUT NOCOPY VARCHAR2);
51
52 PROCEDURE constr_mmti_from_qty_tree
53 (p_mtl_dtl_rec IN gme_material_details%ROWTYPE
54 ,p_subinv IN VARCHAR2
55 ,p_locator_id IN NUMBER
56 ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
57 ,x_return_status OUT NOCOPY VARCHAR2);
58
59 PROCEDURE create_batch_exception
60 (p_material_dtl_rec IN gme_material_details%ROWTYPE
61 ,p_pending_move_order_ind IN BOOLEAN := NULL
62 ,p_pending_rsrv_ind IN BOOLEAN := NULL
63 ,p_transacted_qty IN NUMBER := NULL
64 ,p_exception_qty IN NUMBER := NULL
65 ,p_force_unconsumed IN VARCHAR2 := fnd_api.g_true
66 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
67 ,x_return_status OUT NOCOPY VARCHAR2);
68
69 PROCEDURE check_unexploded_phantom(p_batch_id IN NUMBER
70 ,p_auto_by_step IN NUMBER
71 ,p_batchstep_id IN NUMBER
72 ,x_return_status OUT NOCOPY VARCHAR2);
73
74 PROCEDURE validate_batch_for_release (p_batch_header_rec IN gme_batch_header%ROWTYPE
75 ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
76 ,x_return_status OUT NOCOPY VARCHAR2);
77
78
79 END gme_release_batch_pvt;