[Home] [Help]
PACKAGE: APPS.GML_GASNO_X
Source
1 PACKAGE GML_GASNO_X AUTHID CURRENT_USER as
2 /* $Header: GMLSNOXS.pls 115.2 99/07/16 06:19:02 porting ship $ */
3 /*============================ GML_GASNO_X ================================*/
4 /*===========================================================================
5 PACKAGE NAME: GML_GASNO_X
6
7 DESCRIPTION: Contains the stub procedures called during the Gateway
8 export process. These procedures may be customized as
9 necessary to populate extension tables.
10
11 CLIENT/SERVER: Server
12
13 LIBRARY NAME: None
14
15 PROCEDURE/FUNCTIONS: Populate_SHP_Ext()
16 Populate_STX_Ext()
17 Populate_ORD_Ext()
18 Populate_OAC_Ext()
19 Populate_OTX_Ext()
20 Populate_DTL_Ext()
21 Populate_DAC_Ext()
22 Populate_DTX_Ext()
23 Populate_ALL_Ext()
24
25 NOTES: To run the script:
26
27 sql> start GMLSNOXS.pls
28
29 HISTORY 02/15/99 dgrailic Created.
30 05/12/99 dgrailic For 11i, modified names from ECE_ to GML_
31
32 /*===========================================================================
33 PROCEDURE NAME: Populate_SHP_Ext
34
35 DESCRIPTION: Stub procedure to populate shipment extension table.
36
37 PARAMETERS: p_SHP_Key IN NUMBER
38 p_SHP_Table IN ece_flatfile_pvt.Interface_tbl_type
39
40 DESIGN REFERENCES: GASNO_hld.rtf.
41
42 ALGORITHM:
43
44 NOTES:
45
46 OPEN ISSUES:
47
48 CLOSED ISSUES:
49
50 CHANGE HISTORY: 03/10/99 mmacary Created.
51
52 ===========================================================================*/
53
54 PROCEDURE Populate_SHP_Ext (
55 p_SHP_Key IN NUMBER,
56 p_SHP_Table IN ece_flatfile_pvt.Interface_tbl_type );
57
58 /*===========================================================================
59 PROCEDURE NAME: Populate_STX_Ext
60
61 DESCRIPTION: Stub procedure to populate Shipment text ext. table
62
63 PARAMETERS: p_STX_Key IN NUMBER
64 p_STX_Table IN ece_flatfile_pvt.Interface_tbl_type
65
66 DESIGN REFERENCES: GASNO_hld.rtf.
67
68 ALGORITHM:
69
70 NOTES:
71
72 OPEN ISSUES:
73
74 CLOSED ISSUES:
75
76 CHANGE HISTORY: 02/24/99 dgrailic Created.
77
78 ===========================================================================*/
79
80 PROCEDURE Populate_STX_Ext (
81 p_STX_Key IN NUMBER,
82 p_STX_Table IN ece_flatfile_pvt.Interface_tbl_type );
83
84 /*===========================================================================
85 PROCEDURE NAME: Populate_ORD_Ext
86
87 DESCRIPTION: Stub procedure to populate Order extension table.
88
89 PARAMETERS: p_ORD_Key IN NUMBER
90 p_ORD_Table IN ece_flatfile_pvt.Interface_tbl_type
91
92 DESIGN REFERENCES: GASNO_hld.rtf.
93
94 ALGORITHM:
95
96 NOTES:
97
98 OPEN ISSUES:
99
100 CLOSED ISSUES:
101
102 CHANGE HISTORY: 02/24/99 dgrailic Created.
103
104 ===========================================================================*/
105
106 PROCEDURE Populate_ORD_Ext (
107 p_ORD_Key IN NUMBER,
108 p_ORD_Table IN ece_flatfile_pvt.Interface_tbl_type );
109
110 /*===========================================================================
111 PROCEDURE NAME: Populate_OAC_Ext
112
113 DESCRIPTION: Stub procedure to populate Order Charges ext table.
114
115 PARAMETERS: p_OAC_Key IN NUMBER
116 p_OAC_Table IN ece_flatfile_pvt.Interface_tbl_type
117
118 DESIGN REFERENCES: GASNO_hld.rtf.
119
120 ALGORITHM:
121
122 NOTES:
123
124 OPEN ISSUES:
125
126 CLOSED ISSUES:
127
128 CHANGE HISTORY: 02/24/99 dgrailic Created.
129
130 ===========================================================================*/
131
132 PROCEDURE Populate_OAC_Ext (
133 p_OAC_Key IN NUMBER,
134 p_OAC_Table IN ece_flatfile_pvt.Interface_tbl_type );
135
136 /*===========================================================================
137 PROCEDURE NAME: Populate_OTX_Ext
138
139 DESCRIPTION: Stub procedure to populate Order Text extension table.
140
141 PARAMETERS: p_OTX_Key IN NUMBER
142 p_OTX_Table IN ece_flatfile_pvt.Interface_tbl_type
143
144 DESIGN REFERENCES: GASNO_hld.rtf.
145
146 ALGORITHM:
147
148 NOTES:
149
150 OPEN ISSUES:
151
152 CLOSED ISSUES:
153
154 CHANGE HISTORY: 02/24/99 dgrailic Created.
155
156 ===========================================================================*/
157
158 PROCEDURE Populate_OTX_Ext (
159 p_OTX_Key IN NUMBER,
160 p_OTX_Table IN ece_flatfile_pvt.Interface_tbl_type );
161
162 /*===========================================================================
163 PROCEDURE NAME: Populate_DTL_Ext
164
165 DESCRIPTION: Stub procedure to populate Detail extension table.
166
167 PARAMETERS: p_DTL_Key IN NUMBER
168 p_DTL_Table IN ece_flatfile_pvt.Interface_tbl_type
169
170 DESIGN REFERENCES: GASNO_hld.rtf.
171
172 ALGORITHM:
173
174 NOTES:
175
176 OPEN ISSUES:
177
178 CLOSED ISSUES:
179
180 CHANGE HISTORY: 02/24/99 dgrailic Created.
181
182 ===========================================================================*/
183
184 PROCEDURE Populate_DTL_Ext (
185 p_DTL_Key IN NUMBER,
186 p_DTL_Table IN ece_flatfile_pvt.Interface_tbl_type );
187
188 /*===========================================================================
189 PROCEDURE NAME: Populate_DAC_Ext
190
191 DESCRIPTION: Stub procedure to populate Detail Charges ext table.
192
193 PARAMETERS: p_DAC_Key IN NUMBER
194 p_DAC_Table IN ece_flatfile_pvt.Interface_tbl_type
195
196 DESIGN REFERENCES: GASNO_hld.rtf.
197
198 ALGORITHM:
199
200 NOTES:
201
202 OPEN ISSUES:
203
204 CLOSED ISSUES:
205
206 CHANGE HISTORY: 02/24/99 dgrailic Created.
207
208 ===========================================================================*/
209
210 PROCEDURE Populate_DAC_Ext (
211 p_DAC_Key IN NUMBER,
212 p_DAC_Table IN ece_flatfile_pvt.Interface_tbl_type );
213
214 /*===========================================================================
215 PROCEDURE NAME: Populate_DTX_Ext
216
217 DESCRIPTION: Stub procedure to populate Detail Text extension table.
218
219 PARAMETERS: p_DTX_Key IN NUMBER
220 p_DTX_Table IN ece_flatfile_pvt.Interface_tbl_type
221
222 DESIGN REFERENCES: GASNO_hld.rtf.
223
224 ALGORITHM:
225
226 NOTES:
227
228 OPEN ISSUES:
229
230 CLOSED ISSUES:
231
232 CHANGE HISTORY: 02/24/99 dgrailic Created.
233
234 ===========================================================================*/
235
236 PROCEDURE Populate_DTX_Ext (
237 p_DTX_Key IN NUMBER,
238 p_DTX_Table IN ece_flatfile_pvt.Interface_tbl_type );
239
240 /*===========================================================================
241 PROCEDURE NAME: Populate_ALL_Ext
242
243 DESCRIPTION: Stub procedure to populate Detail allocations (lot info)
244 extension table.
245
246 PARAMETERS: p_ALL_Key IN NUMBER
247 p_ALL_Table IN ece_flatfile_pvt.Interface_tbl_type
248
249 DESIGN REFERENCES: GASNO_hld.rtf.
250
251 ALGORITHM:
252
253 NOTES:
254
255 OPEN ISSUES:
256
257 CLOSED ISSUES:
258
259 CHANGE HISTORY: 02/24/99 dgrailic Created.
260
261 ===========================================================================*/
262
263 PROCEDURE Populate_ALL_Ext (
264 p_ALL_Key IN NUMBER,
265 p_ALL_Table IN ece_flatfile_pvt.Interface_tbl_type );
266
267 END GML_GASNO_X;