[Home] [Help]
PACKAGE: APPS.GMF_LAYERS
Source
1 PACKAGE GMF_LAYERS AUTHID CURRENT_USER AS
2 /* $Header: GMFLAYRS.pls 120.2.12020000.2 2013/02/11 21:14:16 pvkanetk 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 p_Create_vib IN VARCHAR2 DEFAULT 'Y');
55
56 PROCEDURE Create_Outgoing_Layers
57 ( p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
59 p_tran_rec IN GMF_LAYERS.TRANS_REC_TYPE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2);
63
64 PROCEDURE Create_Resource_Layers
65 ( p_api_version IN NUMBER,
66 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
67 p_rsrc_rec IN gme_resource_txns%ROWTYPE,
68 p_doc_qty IN NUMBER,
69 p_doc_um IN VARCHAR2,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2);
73
74 -- Begin Additions for relayering concurrent request.
75
76 PROCEDURE log_message
77 ( p_table_name IN VARCHAR2,
78 p_procedure_name IN VARCHAR2,
79 p_parameters IN VARCHAR2,
80 p_message IN VARCHAR2,
81 p_error_type IN VARCHAR2);
82
83 PROCEDURE Delete_old_layers
84 ( p_batch_id IN NUMBER);
85
86 PROCEDURE Delete_period_layers
87 ( p_batch_id IN NUMBER,
88 p_period_id IN NUMBER);
89
90 PROCEDURE Recreate_outgoing_layers
91 ( p_batch_id IN NUMBER,
92 p_period_id IN NUMBER);
93
94 PROCEDURE Recreate_resource_layers
95 ( p_batch_id IN NUMBER,
96 p_period_id IN NUMBER);
97
98 PROCEDURE Recreate_incoming_layers
99 ( p_batch_id IN NUMBER,
100 p_period_id IN NUMBER);
101
102 PROCEDURE Finalize_batch
103 ( p_batch_id IN NUMBER,
104 p_period_id IN NUMBER);
105
106
107 PROCEDURE Relayer
108 ( errbuf OUT NOCOPY VARCHAR2,
109 retcode OUT NOCOPY VARCHAR2,
110 p_legal_entity_id IN NUMBER,
111 p_calendar_code IN VARCHAR2,
112 p_period_code IN VARCHAR2,
113 p_cost_type_id IN NUMBER,
114 p_org_id IN NUMBER DEFAULT NULL,
115 p_batch_id IN NUMBER DEFAULT NULL);
116
117 -- END Additions for relayering concurrent request.
118
119 END GMF_LAYERS;