[Home] [Help]
PACKAGE BODY: APPS.GML_GPOAO_X
Source
1 PACKAGE BODY GML_GPOAO_X as
2 /* $Header: GMLPAOXB.pls 115.0 99/07/16 06:16:26 porting s $ */
3 /*============================ GML_GPOAO_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 GMLPAOXB.pls
49
50 HISTORY 02/24/99 dgrailic Created.
51 05/17/99 dgrailic Modified to use GML_ prefix
52
53 ===========================================================================*/
54
55
56 /*===========================================================================
57
58 PROCEDURE NAME: Populate_ORD_Ext
59
60 PURPOSE: This procedure populates the extension tables at the
61 Order level.
62
63 ===========================================================================*/
64
65 PROCEDURE Populate_ORD_Ext (
66 p_ORD_Key IN NUMBER,
67 p_ORD_Table IN ece_flatfile_pvt.Interface_tbl_type )
68 IS
69
70 BEGIN
71
72 /*
73 **
74 ** Custom code to populate the Delivery level extension table goes here.
75 **
76 */
77
78 NULL;
79
80 END Populate_ORD_Ext;
81
82 /*===========================================================================
83
84 PROCEDURE NAME: Populate_OAC_Ext
85
86 PURPOSE: This procedure populates the extension tables at the
87 Order Charges level.
88
89 ===========================================================================*/
90
91 PROCEDURE Populate_OAC_Ext (
92 p_OAC_Key IN NUMBER,
93 p_OAC_Table IN ece_flatfile_pvt.Interface_tbl_type )
94 IS
95
96 BEGIN
97
98 /*
99 **
100 ** Custom code to populate the Delivery level extension table goes here.
101 **
102 */
103
104 NULL;
105
106 END Populate_OAC_Ext;
107
108 /*===========================================================================
109
110 PROCEDURE NAME: Populate_OTX_Ext
111
112 PURPOSE: This procedure populates the extension tables at the
113 Order Text level.
114
115 ===========================================================================*/
116
117 PROCEDURE Populate_OTX_Ext (
118 p_OTX_Key IN NUMBER,
119 p_OTX_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_OTX_Ext;
133
134 /*===========================================================================
135
136 PROCEDURE NAME: Populate_DTL_Ext
137
138 PURPOSE: This procedure populates the extension tables at the
139 Datail level.
140
141 ===========================================================================*/
142
143 PROCEDURE Populate_DTL_Ext (
144 p_DTL_Key IN NUMBER,
145 p_DTL_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_DTL_Ext;
159
160 /*===========================================================================
161
162 PROCEDURE NAME: Populate_DAC_Ext
163
164 PURPOSE: This procedure populates the extension tables at the
165 Detail Charges level.
166
167 ===========================================================================*/
168
169 PROCEDURE Populate_DAC_Ext (
170 p_DAC_Key IN NUMBER,
171 p_DAC_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_DAC_Ext;
185
186 /*===========================================================================
187
188 PROCEDURE NAME: Populate_DTX_Ext
189
190 PURPOSE: This procedure populates the extension tables at the
191 Detail Text level.
192
193 ===========================================================================*/
194
195 PROCEDURE Populate_DTX_Ext (
196 p_DTX_Key IN NUMBER,
197 p_DTX_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_DTX_Ext;
211
212 /*===========================================================================
213
214 PROCEDURE NAME: Populate_ALL_Ext
215
216 PURPOSE: This procedure populates the extension tables at the
217 Datail Allocations (lot info) level.
218
219 ===========================================================================*/
220
221 PROCEDURE Populate_ALL_Ext (
222 p_ALL_Key IN NUMBER,
223 p_ALL_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_ALL_Ext;
237
238
239 END GML_GPOAO_X;