DBA Data[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;