[Home] [Help]
PACKAGE BODY: APPS.GML_GASNO_X
Source
1 PACKAGE BODY GML_GASNO_X as
2 /* $Header: GMLSNOXB.pls 115.2 99/07/16 06:18:58 porting ship $ */
3 /*============================ GML_GASNO_X ================================*/
4 /*============================================================================
5 PURPOSE: Creates stub procedures for extracting Order data into
6 Gateway extension tables. These procedures are called during
7 the standard Gateway Outbound OPM PO ack export process, and
8 may be customized as necessary.
9
10 Each procedure takes two parameters: a 'key' value, and a
11 PL/SQL table.
12
13 The 'key' value is the TRANSACTION_RECORD_ID value, which is
14 the primary key for both the interface table and the extension
15 table.
16
17 'Source_tbl_type' is a PL/SQL table typedef with the following
18 structure:
19
20 data_loc_id NUMBER
21 table_name VARCHAR2(50) -- Interface table name
22 column_name VARCHAR2(50) -- Interface column name
23 base_table_name VARCHAR2(50) -- Application table name
24 base_column_name VARCHAR2(50) -- Application column name
25 xref_category_id NUMBER -- Cross-reference category
26 xref_key1_source_column VARCHAR2(50) -- Cross-reference source 1
27 xref_key2_source_column VARCHAR2(50) -- Cross-reference source 2
28 xref_key3_source_column VARCHAR2(50) -- Cross-reference source 3
29 xref_key4_source_column VARCHAR2(50) -- Cross-reference source 4
30 xref_key5_source_column VARCHAR2(50) -- Cross-reference source 5
31 data_type VARCHAR2(50) -- Data type
32 data_length NUMBER -- Data length
33 int_val VARCHAR2(400) -- Interface table value
34 ext_val1 VARCHAR2(80) -- Cross-reference value 1
35 ext_val2 VARCHAR2(80) -- Cross-reference value 2
36 ext_val3 VARCHAR2(80) -- Cross-reference value 3
37 ext_val4 VARCHAR2(80) -- Cross-reference value 4
38 ext_val5 VARCHAR2(80) -- Cross-reference value 5
39
40 Each record in the PL/SQL table represents a single column
41 in the interface table. The 'int_val' attribute holds the
42 value stored in the interface table column (converted to
43 VARCHAR2).
44
45
46 NOTES: To run the script:
47
48 sql> start GMLSNOXB.pls
49
50 HISTORY 02/24/99 dgrailic Created.
51 03/10/99 mmacary modified.
52 05/12/99 dgrailic For 11i, modified names from ECE_ to GML_
53 ===========================================================================*/
54
55 /*===========================================================================
56
57 PROCEDURE NAME: Populate_SHP_Ext
58
59 PURPOSE: This procedure populates the extension tables at the
60 Shipment level.
61
62 ===========================================================================*/
63
64 PROCEDURE Populate_SHP_Ext (
65 p_SHP_Key IN NUMBER,
66 p_SHP_Table IN ece_flatfile_pvt.Interface_tbl_type )
67 IS
68
69 BEGIN
70
71 /*
72 **
73 ** Custom code to populate the Delivery level extension table goes here.
74 **
75 */
76
77 NULL;
78
79 END Populate_SHP_Ext;
80
81 /*===========================================================================
82
83 PROCEDURE NAME: Populate_STX_Ext
84
85 PURPOSE: This procedure populates the extension tables at the
86 Shipment Text level.
87
88 ===========================================================================*/
89
90 PROCEDURE Populate_STX_Ext (
91 p_STX_Key IN NUMBER,
92 p_STX_Table IN ece_flatfile_pvt.Interface_tbl_type )
93 IS
94
95 BEGIN
96
97 /*
98 **
99 ** Custom code to populate the Delivery level extension table goes here.
100 **
101 */
102
103 NULL;
104
105 END Populate_STX_Ext;
106
107
108 /*===========================================================================
109
110 PROCEDURE NAME: Populate_ORD_Ext
111
112 PURPOSE: This procedure populates the extension tables at the
113 Order level.
114
115 ===========================================================================*/
116
117 PROCEDURE Populate_ORD_Ext (
118 p_ORD_Key IN NUMBER,
119 p_ORD_Table IN ece_flatfile_pvt.Interface_tbl_type )
120 IS
121
122 BEGIN
123
124 /*
125 **
126 ** Custom code to populate the Delivery level extension table goes here.
127 **
128 */
129
130 NULL;
131
132 END Populate_ORD_Ext;
133
134 /*===========================================================================
135
136 PROCEDURE NAME: Populate_OAC_Ext
137
138 PURPOSE: This procedure populates the extension tables at the
139 Order Charges level.
140
141 ===========================================================================*/
142
143 PROCEDURE Populate_OAC_Ext (
144 p_OAC_Key IN NUMBER,
145 p_OAC_Table IN ece_flatfile_pvt.Interface_tbl_type )
146 IS
147
148 BEGIN
149
150 /*
151 **
152 ** Custom code to populate the Delivery level extension table goes here.
153 **
154 */
155
156 NULL;
157
158 END Populate_OAC_Ext;
159
160 /*===========================================================================
161
162 PROCEDURE NAME: Populate_OTX_Ext
163
164 PURPOSE: This procedure populates the extension tables at the
165 Order Text level.
166
167 ===========================================================================*/
168
169 PROCEDURE Populate_OTX_Ext (
170 p_OTX_Key IN NUMBER,
171 p_OTX_Table IN ece_flatfile_pvt.Interface_tbl_type )
172 IS
173
174 BEGIN
175
176 /*
177 **
178 ** Custom code to populate the Delivery level extension table goes here.
179 **
180 */
181
182 NULL;
183
184 END Populate_OTX_Ext;
185
186 /*===========================================================================
187
188 PROCEDURE NAME: Populate_DTL_Ext
189
190 PURPOSE: This procedure populates the extension tables at the
191 Datail level.
192
193 ===========================================================================*/
194
195 PROCEDURE Populate_DTL_Ext (
196 p_DTL_Key IN NUMBER,
197 p_DTL_Table IN ece_flatfile_pvt.Interface_tbl_type )
198 IS
199
200 BEGIN
201
202 /*
203 **
204 ** Custom code to populate the Delivery level extension table goes here.
205 **
206 */
207
208 NULL;
209
210 END Populate_DTL_Ext;
211
212 /*===========================================================================
213
214 PROCEDURE NAME: Populate_DAC_Ext
215
216 PURPOSE: This procedure populates the extension tables at the
217 Detail Charges level.
218
222 p_DAC_Key IN NUMBER,
219 ===========================================================================*/
220
221 PROCEDURE Populate_DAC_Ext (
223 p_DAC_Table IN ece_flatfile_pvt.Interface_tbl_type )
224 IS
225
226 BEGIN
227
228 /*
229 **
230 ** Custom code to populate the Delivery level extension table goes here.
231 **
232 */
233
234 NULL;
235
236 END Populate_DAC_Ext;
237
238 /*===========================================================================
239
240 PROCEDURE NAME: Populate_DTX_Ext
241
242 PURPOSE: This procedure populates the extension tables at the
243 Detail Text level.
244
245 ===========================================================================*/
246
247 PROCEDURE Populate_DTX_Ext (
248 p_DTX_Key IN NUMBER,
249 p_DTX_Table IN ece_flatfile_pvt.Interface_tbl_type )
250 IS
251
252 BEGIN
253
254 /*
255 **
256 ** Custom code to populate the Delivery level extension table goes here.
257 **
258 */
259
260 NULL;
261
262 END Populate_DTX_Ext;
263
264 /*===========================================================================
265
266 PROCEDURE NAME: Populate_ALL_Ext
267
268 PURPOSE: This procedure populates the extension tables at the
269 Datail Allocations (lot info) level.
270
271 ===========================================================================*/
272
273 PROCEDURE Populate_ALL_Ext (
274 p_ALL_Key IN NUMBER,
275 p_ALL_Table IN ece_flatfile_pvt.Interface_tbl_type )
276 IS
277
278 BEGIN
279
280 /*
281 **
282 ** Custom code to populate the Delivery level extension table goes here.
283 **
284 */
285
286 NULL;
287
288 END Populate_ALL_Ext;
289
290
291 END GML_GASNO_X;