[Home] [Help]
PACKAGE: APPS.GMF_LAYERS
Source
1 PACKAGE GMF_LAYERS AS
2 /* $Header: GMFLAYRS.pls 120.1.12010000.1 2008/07/30 05:32:50 appldev ship $
3
4 +==========================================================================+
5 | Copyright (c) 1998 Oracle Corporation |
6 | Redwood Shores, CA, USA |
7 | All rights reserved. |
8 +==========================================================================+
9 | FILE NAME |
10 | GMFLAYR.pls |
11 | |
12 | PACKAGE NAME |
13 | GMF_LAYERS |
14 | |
15 | DESCRIPTION |
16 | |
17 | CONTENTS |
18 | |
19 | HISTORY |
20 | |
21 +==========================================================================+
22 */
23
24 TYPE TRANS_REC_TYPE IS RECORD
25 (
26 TRANSACTION_ID mtl_material_transactions.transaction_id%TYPE
27 , TRANSACTION_SOURCE_TYPE_ID mtl_material_transactions.transaction_source_type_id%TYPE
28 , TRANSACTION_ACTION_ID mtl_material_transactions.transaction_action_id%TYPE
29 , TRANSACTION_TYPE_ID mtl_material_transactions.transaction_type_id%TYPE
30 , INVENTORY_ITEM_ID mtl_material_transactions.inventory_item_id%TYPE
31 , ORGANIZATION_ID mtl_material_transactions.organization_id%TYPE
32 , LOT_NUMBER mtl_transaction_lot_numbers.lot_number%TYPE
33 , TRANSACTION_DATE mtl_material_transactions.transaction_date%TYPE
34 , PRIMARY_QUANTITY mtl_material_transactions.primary_quantity%TYPE
35 , PRIMARY_UOM mtl_system_items_b.primary_uom_code%TYPE
36 , DOC_QTY NUMBER
37 , DOC_UOM gme_material_details.dtl_um%TYPE
38 , TRANSACTION_SOURCE_ID mtl_material_transactions.transaction_source_id%TYPE
39 , TRX_SOURCE_LINE_ID mtl_material_transactions.trx_source_line_id%TYPE
40 , REVERSE_ID mtl_material_transactions.source_line_id%TYPE
41 , LINE_TYPE gme_material_details.line_type%TYPE
42 , LAST_UPDATED_BY mtl_material_transactions.last_updated_by%TYPE
43 , CREATED_BY mtl_material_transactions.created_by%TYPE
44 , LAST_UPDATE_LOGIN mtl_material_transactions.last_update_login%TYPE
45 );
46
47 PROCEDURE Create_Incoming_Layers
48 ( p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50 p_tran_rec IN GMF_LAYERS.TRANS_REC_TYPE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2);
54
55 PROCEDURE Create_Outgoing_Layers
56 ( p_api_version IN NUMBER,
57 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58 p_tran_rec IN GMF_LAYERS.TRANS_REC_TYPE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2);
62
63 PROCEDURE Create_Resource_Layers
64 ( p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
66 p_rsrc_rec IN gme_resource_txns%ROWTYPE,
67 p_doc_qty IN NUMBER,
68 p_doc_um IN VARCHAR2,
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2);
72
73 END GMF_LAYERS;