[Home] [Help]
PACKAGE: APPS.OE_INBOUND_INT
Source
1 PACKAGE Oe_Inbound_Int AS
2 /* $Header: OEXOEINS.pls 120.1.12010000.1 2008/07/25 07:51:25 appldev ship $ */
3 --
4 -- Global check
5 --
6 G_check_action_ret_status VARCHAR2(10) := 'S';
7
8 --
9 -- Functions that convert traditional PL/SQL complex types
10 -- (Record, Table, etc.,) to PL/SQL object types (these are the ones
11 -- understood by the web service adapter); and vice-versa.
12 --
13 FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
14 RETURN OE_ORDER_PUB_HEADER_REC_TYPE;
15
16 FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
17 RETURN OE_ORDER_PUB.HEADER_REC_TYPE;
18
19 FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
20 RETURN OE_ORDER_PUB_HEADER_VAL_REC_T;
21
22 FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
23 RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
24
25 FUNCTION PL_TO_SQL26(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE)
26 RETURN OE_ORDER_PUB_HEADER_ADJ_REC_T;
27
28 FUNCTION SQL_TO_PL26(aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T)
29 RETURN OE_ORDER_PUB.HEADER_ADJ_REC_TYPE;
30
31 FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
32 RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T;
33
34 FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
35 RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
36
37 FUNCTION PL_TO_SQL27(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE)
38 RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_R;
39
40 FUNCTION SQL_TO_PL27(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R)
41 RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE;
42
43 FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
44 RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T;
45
46 FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
47 RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
48
49 FUNCTION PL_TO_SQL28(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE)
50 RETURN OE_ORDER_PUB_HEADER_PRICE_AT6;
51
52 FUNCTION SQL_TO_PL28(aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6)
53 RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE;
54
55 FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)
56 RETURN OE_ORDER_PUB_HEADER_PRICE_ATT;
57
58 FUNCTION SQL_TO_PL5(aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT)
59 RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
60
61 FUNCTION PL_TO_SQL29(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE)
62 RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_R;
63
64 FUNCTION SQL_TO_PL29(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R)
65 RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE;
66
67 FUNCTION PL_TO_SQL6(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE)
68 RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_T;
69
70 FUNCTION SQL_TO_PL6(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T)
71 RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
72
73 FUNCTION PL_TO_SQL30(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE)
74 RETURN OE_ORDER_PUB_HEADER_ADJ_ASSO6;
75
76 FUNCTION SQL_TO_PL30(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6)
77 RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE;
78
79 FUNCTION PL_TO_SQL7(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE)
80 RETURN OE_ORDER_PUB_HEADER_ADJ_ASSOC;
81
82 FUNCTION SQL_TO_PL7(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC)
83 RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
84
85 FUNCTION PL_TO_SQL31(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE)
86 RETURN OE_ORDER_PUB_HEADER_SCREDIT_R;
87
88 FUNCTION SQL_TO_PL31(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R)
89 RETURN OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE;
90
91 FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)
92 RETURN OE_ORDER_PUB_HEADER_SCREDIT_T;
93
94 FUNCTION SQL_TO_PL8(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T)
95 RETURN OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
96
97 FUNCTION PL_TO_SQL32(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE)
98 RETURN OE_ORDER_PUB_HEADER_SCREDIT11;
99
100 FUNCTION SQL_TO_PL32(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11)
101 RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;
102
103 FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
104 RETURN OE_ORDER_PUB_HEADER_SCREDIT_V;
105
106 FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
107 RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
108
109 FUNCTION PL_TO_SQL33(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE)
110 RETURN OE_ORDER_PUB_HEADER_PAYMENT_R;
111
112 FUNCTION SQL_TO_PL33(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R)
113 RETURN OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE;
114
115 FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)
116 RETURN OE_ORDER_PUB_HEADER_PAYMENT_T;
117
118 FUNCTION SQL_TO_PL10(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T)
119 RETURN OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
120
121 FUNCTION PL_TO_SQL34(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE)
122 RETURN OE_ORDER_PUB_HEADER_PAYMENT_5;
123
124 FUNCTION SQL_TO_PL34(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5)
125 RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE;
126
127 FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)
128 RETURN OE_ORDER_PUB_HEADER_PAYMENT_V;
129
130 FUNCTION SQL_TO_PL11(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V)
131 RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
132
133 FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)
134 RETURN OE_ORDER_PUB_LINE_REC_TYPE;
135
136 FUNCTION SQL_TO_PL35(aSqlItem OE_ORDER_PUB_LINE_REC_TYPE)
137 RETURN OE_ORDER_PUB.LINE_REC_TYPE;
138
139 FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)
140 RETURN OE_ORDER_PUB_LINE_TBL_TYPE;
141
142 FUNCTION SQL_TO_PL12(aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE)
143 RETURN OE_ORDER_PUB.LINE_TBL_TYPE;
144
145 FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)
146 RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP;
147
148 FUNCTION SQL_TO_PL36(aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP)
149 RETURN OE_ORDER_PUB.LINE_VAL_REC_TYPE;
150
151 FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
152 RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP;
153
154 FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
155 RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
156
157 FUNCTION PL_TO_SQL37(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE)
158 RETURN OE_ORDER_PUB_LINE_ADJ_REC_TYP;
159
160 FUNCTION SQL_TO_PL37(aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP)
161 RETURN OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
162
163 FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
164 RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
165
166 FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
167 RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
168
169 FUNCTION PL_TO_SQL38(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE)
170 RETURN OE_ORDER_PUB_LINE_ADJ_VAL_REC;
171
172 FUNCTION SQL_TO_PL38(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC)
173 RETURN OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE;
174
175 FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)
176 RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL;
177
178 FUNCTION SQL_TO_PL15(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL)
179 RETURN OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
180
181 FUNCTION PL_TO_SQL39(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE)
182 RETURN OE_ORDER_PUB_LINE_PRICE_ATT_R;
183
184 FUNCTION SQL_TO_PL39(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R)
185 RETURN OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE;
186
187 FUNCTION PL_TO_SQL16(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE)
188 RETURN OE_ORDER_PUB_LINE_PRICE_ATT_T;
189
190 FUNCTION SQL_TO_PL16(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T)
191 RETURN OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
192
193 FUNCTION PL_TO_SQL40(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE)
194 RETURN OE_ORDER_PUB_LINE_ADJ_ATT_REC;
195
196 FUNCTION SQL_TO_PL40(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC)
197 RETURN OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE;
198
199 FUNCTION PL_TO_SQL17(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE)
200 RETURN OE_ORDER_PUB_LINE_ADJ_ATT_TBL;
201
202 FUNCTION SQL_TO_PL17(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL)
203 RETURN OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
204
205 FUNCTION PL_TO_SQL41(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE)
206 RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_R;
207
208 FUNCTION SQL_TO_PL41(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R)
209 RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE;
210
211 FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)
212 RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T;
213
214 FUNCTION SQL_TO_PL18(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T)
215 RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
216
217 FUNCTION PL_TO_SQL42(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE)
218 RETURN OE_ORDER_PUB_LINE_SCREDIT_REC;
219
220 FUNCTION SQL_TO_PL42(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC)
221 RETURN OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE;
222
223 FUNCTION PL_TO_SQL19(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE)
224 RETURN OE_ORDER_PUB_LINE_SCREDIT_TBL;
225
226 FUNCTION SQL_TO_PL19(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL)
227 RETURN OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
228
229 FUNCTION PL_TO_SQL43(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE)
230 RETURN OE_ORDER_PUB_LINE_SCREDIT_VA6;
231
232 FUNCTION SQL_TO_PL43(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6)
233 RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;
234
235 FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
236 RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL;
237
238 FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
239 RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
240
241 FUNCTION PL_TO_SQL44(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE)
242 RETURN OE_ORDER_PUB_LINE_PAYMENT_REC;
243
244 FUNCTION SQL_TO_PL44(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC)
245 RETURN OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE;
246
247 FUNCTION PL_TO_SQL21(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE)
248 RETURN OE_ORDER_PUB_LINE_PAYMENT_TBL;
249
250 FUNCTION SQL_TO_PL21(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL)
251 RETURN OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
252
253 FUNCTION PL_TO_SQL45(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE)
254 RETURN OE_ORDER_PUB_LINE_PAYMENT_VA3;
255
256 FUNCTION SQL_TO_PL45(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3)
257 RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;
258
259 FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
260 RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL;
261
262 FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
263 RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
264
265 FUNCTION PL_TO_SQL46(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE)
266 RETURN OE_ORDER_PUB_LOT_SERIAL_REC_T;
267
268 FUNCTION SQL_TO_PL46(aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T)
269 RETURN OE_ORDER_PUB.LOT_SERIAL_REC_TYPE;
270
271 FUNCTION PL_TO_SQL23(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE)
272 RETURN OE_ORDER_PUB_LOT_SERIAL_TBL_T;
273
274 FUNCTION SQL_TO_PL23(aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T)
275 RETURN OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
276
277 FUNCTION PL_TO_SQL47(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE)
278 RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_R;
279
280 FUNCTION SQL_TO_PL47(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R)
281 RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE;
282
283 FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
284 RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T;
285
286 FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
287 RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
288
289 FUNCTION PL_TO_SQL48(aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE)
290 RETURN OE_ORDER_PUB_REQUEST_REC_TYPE;
291
292 FUNCTION SQL_TO_PL48(aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE)
293 RETURN OE_ORDER_PUB.REQUEST_REC_TYPE;
294
295 FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
296 RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE;
297
298 FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
299 RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE;
300
301 --
302 -- Utility procedures
303 --
304 PROCEDURE Convert_Line_null_to_miss(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type);
305 PROCEDURE Convert_hdr_null_to_miss (p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type);
306
307 --
308 -- Webservice Adapter wrapper for Oe_Order_Pub.Process_Order(...) API
309 -- with the newer signature.
310 --
311 PROCEDURE Process_Order (
312 P_API_VERSION_NUMBER NUMBER,
313 P_INIT_MSG_LIST VARCHAR2,
314 P_RETURN_VALUES VARCHAR2,
315 P_ACTION_COMMIT VARCHAR2,
316 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
317 X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
318 P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
319 P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
320 P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
321 P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
322 P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
323 P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
324 P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
325 P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
326 P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
327 P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
328 P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
329 P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
330 P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
334 P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
331 P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
332 P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
333 P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
335 P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
336 P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
337 P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
338 P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
339 P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
340 P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
341 P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
342 P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
343 P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
344 P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
345 P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
346 P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
347 P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
348 P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
349 P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
350 P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
351 P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
352 P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
353 P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
354 P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
355 P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
356 P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
357 P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
358 P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
359 P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
360 P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
361 P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
362 P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
363 P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
364 P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
365 P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
366 P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
367 X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
368 X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
369 X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
370 X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
371 X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,
372 X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,
373 X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC ,
374 X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,
375 X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,
376 X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
377 X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,
378 X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,
379 X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,
380 X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
381 X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,
382 X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
383 X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
384 X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,
385 X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL ,
386 X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,
387 X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
388 X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
389 X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
390 X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
391 X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
392 P_RTRIM_DATA VARCHAR2
393 );
394
395 --
396 -- Webservice Adapter wrapper for Oe_Order_Pub.Process_Order(...) API
397 -- This is a deprecated signature, and retained only for backward
398 -- compatibility reasons.
399 --
400 -- Clients should use the equivalent OE_INBOUND_INT.Process_Order(...)
401 -- with the newer signature (for all practical purposes).
402 --
403 PROCEDURE Process_Order (
407 P_ACTION_COMMIT VARCHAR2,
404 P_API_VERSION_NUMBER NUMBER,
405 P_INIT_MSG_LIST VARCHAR2,
406 P_RETURN_VALUES VARCHAR2,
408 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
409 X_MSG_COUNT OUT NOCOPY NUMBER,
413 P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
410 X_MSG_DATA OUT NOCOPY VARCHAR2,
411 P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
412 P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
414 P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
415 P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
416 P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
417 P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
418 P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
419 P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
420 P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
421 P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
422 P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
423 P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
424 P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
425 P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
426 P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
427 P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
428 P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
429 P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
430 P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
431 P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
432 P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
433 P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
434 P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
435 P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
436 P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
437 P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
438 P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
439 P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
440 P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
441 P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
442 P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
443 P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
444 P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
445 P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
446 P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
447 P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
448 P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
449 P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
450 P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
451 P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
452 P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
453 P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
454 P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
455 P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
456 P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
457 P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
458 P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
459 P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
460 X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
461 X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
462 X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
463 X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
464 X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,
465 X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,
466 X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC ,
467 X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,
468 X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,
469 X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
470 X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,
471 X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,
472 X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,
473 X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
474 X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,
475 X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
476 X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
477 X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,
478 X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL ,
479 X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,
480 X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
481 X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
482 X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
483 X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
484 X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
485 P_RTRIM_DATA VARCHAR2
486 );
487
488
489 END Oe_Inbound_Int;