[Home] [Help]
PACKAGE: APPS.GME_TRANS_ENGINE_UTIL
Source
1 PACKAGE gme_trans_engine_util AS
2 /* $Header: GMEUTXNS.pls 120.1 2005/06/03 10:57:03 appldev $
3 +=========================================================================+
4 | Copyright (c) 2000 Oracle Corporation |
5 | TVP, Reading, England |
6 | All rights reserved |
7 +=========================================================================+
8 | FILENAME |
9 | GMEUTXNS.pls |
10 | |
11 | DESCRIPTION |
12 | This package contains private definitions For |
13 | GME Material And Resource Transaction Load Routines |
14 | |
15 | HISTORY |
16 | 12-FEB-2001 H.Verdding |
17 | 15-APR-2004 Vipul Vaish BUG#3528006 |
18 | Added the set_default_lot_for_new_batch procedure for performance |
19 | enhancement. |
20 +=========================================================================+
21 API Name : GME_TRANS_ENGINE_UTIL
22 Type : Public
23 Function : This package contains public procedures used to create
24 Pre-reqs : N/A
25 Parameters: Per function
26
27 Current Vers : 1.0
28
29 Previous Vers : 1.0
30
31 Initial Vers : 1.0
32 Notes
33 */
34 PROCEDURE load_mat_and_rsc_trans (
35 p_batch_row IN gme_batch_header%ROWTYPE
36 ,x_mat_row_count OUT NOCOPY NUMBER
37 ,x_rsc_row_count OUT NOCOPY NUMBER
38 ,x_return_status OUT NOCOPY VARCHAR2);
39
40 FUNCTION build_trans_rec (
41 p_tran_row IN gme_inventory_txns_gtmp%ROWTYPE
42 ,x_tran_rec OUT NOCOPY gmi_trans_engine_pub.ictran_rec)
43 RETURN BOOLEAN;
44
45 PROCEDURE load_rsrc_trans (
46 p_batch_row IN gme_batch_header%ROWTYPE
47 ,x_rsc_row_count OUT NOCOPY NUMBER
48 ,x_return_status OUT NOCOPY VARCHAR2);
49
50 PROCEDURE set_default_lot_for_batch (
51 p_batch_row IN gme_batch_header%ROWTYPE
52 ,x_return_status OUT NOCOPY VARCHAR2);
53
54 PROCEDURE set_default_lot_for_new_batch (
55 x_return_status OUT NOCOPY VARCHAR2);
56
57 PROCEDURE deduce_transaction_warehouse (
58 p_transaction IN ic_tran_pnd%ROWTYPE
59 ,p_item_master IN ic_item_mst%ROWTYPE
60 ,x_whse_code OUT NOCOPY ps_whse_eff.whse_code%TYPE
61 ,x_return_status OUT NOCOPY VARCHAR2);
62
63 PROCEDURE get_default_lot (
64 p_line_id IN gme_material_details.material_detail_id%TYPE
65 ,x_def_trans_id OUT NOCOPY ic_tran_pnd.trans_id%TYPE
66 ,x_is_plain OUT NOCOPY BOOLEAN
67 ,x_return_status OUT NOCOPY VARCHAR2);
68
69 p_default_loct VARCHAR2 (80) := fnd_profile.VALUE ('IC$DEFAULT_LOCT');
70 END gme_trans_engine_util;