1 PACKAGE Oe_Inbound_Int AUTHID CURRENT_USER AS
2 /* $Header: OEXOEINS.pls 120.8 2012/03/21 09:31:37 sahvivek ship $ */
3 /*#
4 * This API allows clients to perform various operations on sales orders.
5 * @rep:product ONT
6 * @rep:scope public
7 * @rep:lifecycle active
8 * @rep:category BUSINESS_ENTITY ONT_SALES_ORDER
9 * @rep:displayname Sales Order Services
10 */
11 --
12 -- Global check
13 --
14 G_check_action_ret_status VARCHAR2(10) := 'S';
15
16 --
17 -- Functions that convert traditional PL/SQL complex types
18 -- (Record, Table, etc.,) to PL/SQL object types (these are the ones
19 -- understood by the web service adapter); and vice-versa.
20 --
21 FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
22 RETURN OE_ORDER_PUB_HEADER_REC_TYPE;
23
24 FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
25 RETURN OE_ORDER_PUB.HEADER_REC_TYPE;
26
27 FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
28 RETURN OE_ORDER_PUB_HEADER_VAL_REC_T;
29
30 FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
31 RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
32
33 FUNCTION PL_TO_SQL26(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE)
34 RETURN OE_ORDER_PUB_HEADER_ADJ_REC_T;
35
36 FUNCTION SQL_TO_PL26(aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T)
37 RETURN OE_ORDER_PUB.HEADER_ADJ_REC_TYPE;
38
39 FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
40 RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T;
41
42 FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
43 RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
44
45 FUNCTION PL_TO_SQL27(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE)
46 RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_R;
47
48 FUNCTION SQL_TO_PL27(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R)
49 RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE;
50
51 FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
52 RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T;
53
54 FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
55 RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
56
57 FUNCTION PL_TO_SQL28(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE)
58 RETURN OE_ORDER_PUB_HEADER_PRICE_AT6;
59
60 FUNCTION SQL_TO_PL28(aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6)
61 RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE;
62
63 FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)
64 RETURN OE_ORDER_PUB_HEADER_PRICE_ATT;
65
66 FUNCTION SQL_TO_PL5(aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT)
67 RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
68
69 FUNCTION PL_TO_SQL29(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE)
70 RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_R;
71
72 FUNCTION SQL_TO_PL29(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R)
73 RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE;
74
75 FUNCTION PL_TO_SQL6(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE)
76 RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_T;
77
78 FUNCTION SQL_TO_PL6(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T)
79 RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
80
81 FUNCTION PL_TO_SQL30(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE)
82 RETURN OE_ORDER_PUB_HEADER_ADJ_ASSO6;
83
84 FUNCTION SQL_TO_PL30(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6)
85 RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE;
86
87 FUNCTION PL_TO_SQL7(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE)
88 RETURN OE_ORDER_PUB_HEADER_ADJ_ASSOC;
89
90 FUNCTION SQL_TO_PL7(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC)
91 RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
92
93 FUNCTION PL_TO_SQL31(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE)
94 RETURN OE_ORDER_PUB_HEADER_SCREDIT_R;
95
96 FUNCTION SQL_TO_PL31(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R)
97 RETURN OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE;
98
99 FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)
100 RETURN OE_ORDER_PUB_HEADER_SCREDIT_T;
101
102 FUNCTION SQL_TO_PL8(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T)
103 RETURN OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
104
105 FUNCTION PL_TO_SQL32(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE)
106 RETURN OE_ORDER_PUB_HEADER_SCREDIT11;
107
108 FUNCTION SQL_TO_PL32(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11)
109 RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;
110
111 FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
112 RETURN OE_ORDER_PUB_HEADER_SCREDIT_V;
113
114 FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
115 RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
116
117 FUNCTION PL_TO_SQL33(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE)
118 RETURN OE_ORDER_PUB_HEADER_PAYMENT_R;
119
120 FUNCTION SQL_TO_PL33(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R)
121 RETURN OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE;
122
123 FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)
124 RETURN OE_ORDER_PUB_HEADER_PAYMENT_T;
125
126 FUNCTION SQL_TO_PL10(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T)
127 RETURN OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
128
129 FUNCTION PL_TO_SQL34(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE)
130 RETURN OE_ORDER_PUB_HEADER_PAYMENT_5;
131
132 FUNCTION SQL_TO_PL34(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5)
133 RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE;
134
135 FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)
136 RETURN OE_ORDER_PUB_HEADER_PAYMENT_V;
137
138 FUNCTION SQL_TO_PL11(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V)
139 RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
140
141 FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)
142 RETURN OE_ORDER_PUB_LINE_REC_TYPE;
143
144 FUNCTION SQL_TO_PL35(aSqlItem OE_ORDER_PUB_LINE_REC_TYPE)
145 RETURN OE_ORDER_PUB.LINE_REC_TYPE;
146
147 FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)
148 RETURN OE_ORDER_PUB_LINE_TBL_TYPE;
149
150 FUNCTION SQL_TO_PL12(aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE)
151 RETURN OE_ORDER_PUB.LINE_TBL_TYPE;
152
153 FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)
154 RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP;
155
156 FUNCTION SQL_TO_PL36(aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP)
157 RETURN OE_ORDER_PUB.LINE_VAL_REC_TYPE;
158
159 FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
160 RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP;
161
162 FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
163 RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
164
165 FUNCTION PL_TO_SQL37(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE)
166 RETURN OE_ORDER_PUB_LINE_ADJ_REC_TYP;
167
168 FUNCTION SQL_TO_PL37(aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP)
169 RETURN OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
170
171 FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
172 RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
173
174 FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
175 RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
176
177 FUNCTION PL_TO_SQL38(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE)
178 RETURN OE_ORDER_PUB_LINE_ADJ_VAL_REC;
179
180 FUNCTION SQL_TO_PL38(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC)
181 RETURN OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE;
182
183 FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)
184 RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL;
185
186 FUNCTION SQL_TO_PL15(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL)
187 RETURN OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
188
189 FUNCTION PL_TO_SQL39(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE)
190 RETURN OE_ORDER_PUB_LINE_PRICE_ATT_R;
191
192 FUNCTION SQL_TO_PL39(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R)
193 RETURN OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE;
194
195 FUNCTION PL_TO_SQL16(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE)
196 RETURN OE_ORDER_PUB_LINE_PRICE_ATT_T;
197
198 FUNCTION SQL_TO_PL16(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T)
199 RETURN OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
200
201 FUNCTION PL_TO_SQL40(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE)
202 RETURN OE_ORDER_PUB_LINE_ADJ_ATT_REC;
203
204 FUNCTION SQL_TO_PL40(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC)
205 RETURN OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE;
206
207 FUNCTION PL_TO_SQL17(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE)
208 RETURN OE_ORDER_PUB_LINE_ADJ_ATT_TBL;
209
210 FUNCTION SQL_TO_PL17(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL)
211 RETURN OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
212
213 FUNCTION PL_TO_SQL41(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE)
214 RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_R;
215
216 FUNCTION SQL_TO_PL41(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R)
217 RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE;
218
219 FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)
220 RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T;
221
222 FUNCTION SQL_TO_PL18(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T)
223 RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
224
225 FUNCTION PL_TO_SQL42(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE)
226 RETURN OE_ORDER_PUB_LINE_SCREDIT_REC;
227
228 FUNCTION SQL_TO_PL42(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC)
229 RETURN OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE;
230
231 FUNCTION PL_TO_SQL19(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE)
232 RETURN OE_ORDER_PUB_LINE_SCREDIT_TBL;
233
234 FUNCTION SQL_TO_PL19(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL)
235 RETURN OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
236
237 FUNCTION PL_TO_SQL43(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE)
238 RETURN OE_ORDER_PUB_LINE_SCREDIT_VA6;
239
240 FUNCTION SQL_TO_PL43(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6)
241 RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;
242
243 FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
244 RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL;
245
246 FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
247 RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
248
249 FUNCTION PL_TO_SQL44(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE)
250 RETURN OE_ORDER_PUB_LINE_PAYMENT_REC;
251
252 FUNCTION SQL_TO_PL44(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC)
253 RETURN OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE;
254
255 FUNCTION PL_TO_SQL21(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE)
256 RETURN OE_ORDER_PUB_LINE_PAYMENT_TBL;
257
258 FUNCTION SQL_TO_PL21(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL)
259 RETURN OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
260
261 FUNCTION PL_TO_SQL45(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE)
262 RETURN OE_ORDER_PUB_LINE_PAYMENT_VA3;
263
264 FUNCTION SQL_TO_PL45(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3)
265 RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;
266
267 FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
268 RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL;
269
270 FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
271 RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
272
273 FUNCTION PL_TO_SQL46(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE)
274 RETURN OE_ORDER_PUB_LOT_SERIAL_REC_T;
275
276 FUNCTION SQL_TO_PL46(aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T)
277 RETURN OE_ORDER_PUB.LOT_SERIAL_REC_TYPE;
278
279 FUNCTION PL_TO_SQL23(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE)
280 RETURN OE_ORDER_PUB_LOT_SERIAL_TBL_T;
281
282 FUNCTION SQL_TO_PL23(aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T)
283 RETURN OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
284
285 FUNCTION PL_TO_SQL47(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE)
286 RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_R;
287
288 FUNCTION SQL_TO_PL47(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R)
289 RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE;
290
291 FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
292 RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T;
293
294 FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
295 RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
296
297 FUNCTION PL_TO_SQL48(aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE)
298 RETURN OE_ORDER_PUB_REQUEST_REC_TYPE;
299
300 FUNCTION SQL_TO_PL48(aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE)
301 RETURN OE_ORDER_PUB.REQUEST_REC_TYPE;
302
303 FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
304 RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE;
305
306 FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
307 RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE;
308
309 --
310 -- Utility procedures
311 --
312 PROCEDURE Convert_Line_null_to_miss(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type);
313 PROCEDURE Convert_hdr_null_to_miss (p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type);
314
315 --
316 -- Webservice Adapter wrapper for Oe_Order_Pub.Process_Order(...) API
317 -- with the newer signature.
318 -- Annotation description modified for Bug 13824252
319 /*#
320 * Use this procedure to build Oracle Applications Adapter based web services that
321 * create, update or delete Sales Orders in the Order Management system.It is optimized
322 * for usage in web services and recommended for this purpose over Process Order API.
323 * DO NOT use Process Order API ( Oe_Order_Pub.Process_Order() ) for WSDL generation
324 * if this API is already in use, or if Order-To-Cash PIP is installed. In addition to
325 * allowing direct changes to the sales order, this API supports the application of header
326 * and line level price adjustments, pricing attributes, sales credits, and payments.
327 * Lot and Serial number information are supported for return lines. This API also
328 * supports action requests that allow users to execute a variety of actions such as
329 * booking, hold application and removal, automatic attachments, fullfillment set
330 * application and removal, match and reserve for Configured items, get ship method
331 * and freight rates (both individually and together), and the linking and delinking
332 * of Configured items.
333 * @param P_API_VERSION_NUMBER API version used to check call compatibility
334 * @param P_INIT_MSG_LIST Parameter that determines whether internal message tables should be initialized
335 * @param P_RETURN_VALUES Parameter determines whether ids should be converted to values for population in the output value parameters
336 * @param P_ACTION_COMMIT Parameter determines whether a database commit be issued by this API after requested operation (Create/Update sales order)
337 * @param X_RETURN_STATUS Return status of API call
338 * @param X_MESSAGES Output table containing processing messages generated in the current call of API
339 * @param P_HEADER_REC Input record structure containing current header-level ID information for an order
340 * @param P_OLD_HEADER_REC Input record structure containing old header-level ID information for an order
341 * @param P_HEADER_VAL_REC Input record structure containing current header-level value information for an order
342 * @param P_OLD_HEADER_VAL_REC Input record structure containing old header-level value information for an order
343 * @param P_HEADER_ADJ_TBL Input table containing current header-level ID information for price adjustments
344 * @param P_OLD_HEADER_ADJ_TBL Input table containing old header-level ID information for price adjustments
345 * @param P_HEADER_ADJ_VAL_TBL Input table containing current header-level value information for price adjustments
346 * @param P_OLD_HEADER_ADJ_VAL_TBL Input table containing old header-level value information for price adjustments
347 * @param P_HEADER_PRICE_ATT_TBL Input table containing current header-level information for pricing attributes
348 * @param p_old_Header_Price_Att_tbl Input table containing old header-level information for pricing attributes
349 * @param p_Header_Adj_Att_tbl Input table containing current header-level adjustment attributes
350 * @param p_old_Header_Adj_Att_tbl Input table containing old header-level adjustment attributes
351 * @param p_Header_Adj_Assoc_tbl Input table containing current information about relationships between header-level adjustments
352 * @param p_old_Header_Adj_Assoc_tbl Input table containing old information about relationships between header-level adjustments
353 * @param p_Header_Scredit_tbl Input table containing current header-level ID information for sales credits
354 * @param p_old_Header_Scredit_tbl Input table containing old header-level ID information for sales credits
355 * @param p_Header_Scredit_val_tbl Input table containing current header-level value information for sales credits
356 * @param p_old_Header_Scredit_val_tbl Input table containing old header-level value information for sales credits
357 * @param p_Header_Payment_tbl Input table containing current header-level ID information for payments
361 * @param p_line_tbl Input table containing current line-level ID information for an order
358 * @param p_old_Header_Payment_tbl Input table containing old header-level ID information for payments
359 * @param p_Header_Payment_val_tbl Input table containing current header-level value information for payments
360 * @param p_old_Header_Payment_val_tbl Input table containing old header-level value information for payments
362 * @param p_old_line_tbl Input table containing old line-level ID information for an order
363 * @param p_line_val_tbl Input table containing current line-level value information for an order
364 * @param p_old_line_val_tbl Input table containing old line-level value information for an order
365 * @param p_Line_Adj_tbl Input table containing current line-level ID information for price adjustments
366 * @param p_old_Line_Adj_tbl Input table containing old line-level ID information for price adjustments
367 * @param p_Line_Adj_val_tbl Input table containing current line-level value information for price adjustments
368 * @param p_old_Line_Adj_val_tbl Input table containing old line-level value information for price adjustments
369 * @param p_Line_price_Att_tbl Input table containing current line-level information for pricing attributes
370 * @param p_old_Line_Price_Att_tbl Input table containing old line-level information for pricing attributes
371 * @param p_Line_Adj_Att_tbl Input table containing current line-level adjustment attributes
372 * @param p_old_Line_Adj_Att_tbl Input table containing old line-level adjustment attributes
373 * @param p_Line_Adj_Assoc_tbl Input table containing current information about relationships between line-level adjustments
374 * @param p_old_Line_Adj_Assoc_tbl Input table containing old information about relationships between line-level adjustments
375 * @param p_Line_Scredit_tbl Input table containing current line-level ID information for sales credits
376 * @param p_old_Line_Scredit_tbl Input table containing old line-level ID information for sales credits
377 * @param p_Line_Scredit_val_tbl Input table containing current line-level value information for sales credits
378 * @param p_old_Line_Scredit_val_tbl Input table containing old line-level value information for sales credits
379 * @param p_Line_Payment_tbl Input table containing current line-level ID information for payments
380 * @param p_old_Line_Payment_tbl Input table containing old line-level ID information for payments
381 * @param p_Line_Payment_val_tbl Input table containing current line-level value information for payments
382 * @param p_old_Line_Payment_val_tbl Input table containing current line-level value information for payments
383 * @param p_Lot_Serial_tbl Input table containing current ID information for lot and serial numbers
384 * @param p_old_Lot_Serial_tbl Input table containing old ID information for lot and serial numbers
385 * @param p_Lot_Serial_val_tbl Input table containing current value information for lot and serial numbers
386 * @param p_old_Lot_Serial_val_tbl Input table containing old value information for lot and serial numbers
387 * @param p_action_request_tbl Input table containing delayed requests
388 * @param x_header_rec Output record structure containing current header-level ID information for an order
389 * @param x_header_val_rec Output record structure containing current header-level value information for an order (if p_return_values was passed as true)
390 * @param x_Header_Adj_tbl Output table containing current header-level ID information for price adjustments
391 * @param x_Header_Adj_val_tbl Output table containing current header-level value information for price adjustments (if p_return_values was passed as true)
392 * @param x_Header_price_Att_tbl Output table containing current header-level information for pricing attributes
393 * @param x_Header_Adj_Att_tbl Output table containing current header-level adjustment attributes
394 * @param x_Header_Adj_Assoc_tbl Output table containing current information about relationships between header-level adjustments
395 * @param x_Header_Scredit_tbl Output table containing current header-level ID information for sales credits
396 * @param x_Header_Scredit_val_tbl Output table containing current header-level value information for sales credits (if p_return_values was passed as true)
397 * @param x_Header_Payment_tbl Output table containing current header-level ID information for payments
398 * @param x_Header_Payment_val_tbl Output table containing current header-level value information for payments (if p_return_values was passed as true)
399 * @param x_line_tbl Output table containing current line-level ID information for an order
400 * @param x_line_val_tbl Output table containing current line-level value information for an order (if p_return_values was passed as true)
401 * @param x_Line_Adj_tbl Output table containing current line-level ID information for price adjustments
402 * @param x_Line_Adj_val_tbl Output table containing current line-level value information for price adjustments (if p_return_values was passed as true)
403 * @param x_Line_price_Att_tbl Output table containing current line-level information for pricing attributes
404 * @param x_Line_Adj_Att_tbl Output table containing current line-level adjustment attributes
405 * @param x_Line_Adj_Assoc_tbl Output table containing current information about relationships between line-level adjustments
406 * @param x_Line_Scredit_tbl Output table containing current line-level ID information for sales credits
407 * @param x_Line_Scredit_val_tbl Output table containing current line-level value information for sales credits (if p_return_values was passed as true)
408 * @param x_Line_Payment_tbl Output table containing current line-level ID information for payments
409 * @param x_Line_Payment_val_tbl Output table containing current line-level value information for payments (if p_return_values was passed as true)
410 * @param x_Lot_Serial_tbl Output table containing current ID information for lot and serial numbers
411 * @param x_Lot_Serial_val_tbl Output table containing current value information for lot and serial numbers (if p_return_values was passed as true)
412 * @param x_action_request_tbl Output table containing delayed requests
413 * @param p_rtrim_data Parameter specifying whether to right-trim the input data
414 * @rep:scope public
415 * @rep:lifecycle active
416 * @rep:category BUSINESS_ENTITY ONT_SALES_ORDER
420 P_API_VERSION_NUMBER NUMBER,
417 * @rep:displayname Sales Order Service
418 */
419 PROCEDURE Process_Order (
421 P_INIT_MSG_LIST VARCHAR2,
422 P_RETURN_VALUES VARCHAR2,
423 P_ACTION_COMMIT VARCHAR2,
424 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
425 X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
426 P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
427 P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
428 P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
429 P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
430 P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
431 P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
432 P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
433 P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
434 P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
435 P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
436 P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
437 P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
438 P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
439 P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
440 P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
441 P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
442 P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
443 P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
444 P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
445 P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
446 P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
447 P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
448 P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
449 P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
450 P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
451 P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
452 P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
453 P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
454 P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
455 P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
456 P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
457 P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
458 P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
459 P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
460 P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
461 P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
462 P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
463 P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
464 P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
465 P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
466 P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
467 P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
468 P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
469 P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
470 P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
471 P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
472 P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
473 P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
474 P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
475 X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
476 X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
477 X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
478 X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
479 X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,
480 X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,
481 X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC ,
482 X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,
483 X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,
484 X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
485 X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,
486 X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,
487 X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,
488 X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
489 X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,
490 X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
491 X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
492 X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,
493 X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL ,
494 X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,
495 X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
496 X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
497 X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
498 X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
499 X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
500 P_RTRIM_DATA VARCHAR2
501 );
502
503 --
504 -- Webservice Adapter wrapper for Oe_Order_Pub.Process_Order(...) API
505 -- This is a deprecated signature, and retained only for backward
506 -- compatibility reasons.
510 --
507 --
508 -- Clients should use the equivalent OE_INBOUND_INT.Process_Order(...)
509 -- with the newer signature (for all practical purposes).
511 PROCEDURE Process_Order (
512 P_API_VERSION_NUMBER NUMBER,
513 P_INIT_MSG_LIST VARCHAR2,
514 P_RETURN_VALUES VARCHAR2,
515 P_ACTION_COMMIT VARCHAR2,
516 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
517 X_MSG_COUNT OUT NOCOPY NUMBER,
518 X_MSG_DATA OUT NOCOPY VARCHAR2,
519 P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
520 P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
521 P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
522 P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
523 P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
524 P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
525 P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
526 P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
527 P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
528 P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
529 P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
530 P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
531 P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
532 P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
533 P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
534 P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
535 P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
536 P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
537 P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
538 P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
539 P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
540 P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
541 P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
542 P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
543 P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
544 P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
545 P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
546 P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
547 P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
548 P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
549 P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
550 P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
551 P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
552 P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
553 P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
554 P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
555 P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
556 P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
557 P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
558 P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
559 P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
560 P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
561 P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
562 P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
563 P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
564 P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
565 P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
566 P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
567 P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
568 X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE ,
569 X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T ,
570 X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T ,
571 X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T ,
572 X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT ,
573 X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T ,
574 X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC ,
575 X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T ,
576 X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V ,
577 X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T ,
578 X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V ,
579 X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE ,
580 X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP ,
581 X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
582 X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL ,
583 X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T ,
584 X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL ,
585 X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T ,
586 X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL ,
587 X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL ,
588 X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL ,
589 X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL ,
590 X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T ,
591 X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
592 X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE ,
593 P_RTRIM_DATA VARCHAR2
594 );
595
596 --
597 -- O2C25
601 --
598 --
599 -- Process_Order_25(...) specifically created to perform Process Order
600 -- operations in O2C25 code line.
602 ----------
603 PROCEDURE Process_Order_25 (
604 P_API_VERSION_NUMBER NUMBER,
605 P_INIT_MSG_LIST VARCHAR2,
606 P_RETURN_VALUES VARCHAR2,
607 P_ACTION_COMMIT VARCHAR2,
608 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
609 X_MESSAGES OUT NOCOPY OE_MESSAGE_OBJ_T,
610 P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
611 P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
612 P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
613 P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
614 P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
615 P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
616 P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
617 P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
618 P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
619 P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
620 P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
621 P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
622 P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
623 P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
624 P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
625 P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
626 P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
627 P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
628 P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
629 P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
630 P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
631 P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
632 P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
633 P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
634 P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
635 P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
636 P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
637 P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
638 P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
639 P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
640 P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
641 P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
642 P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
643 P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
644 P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
645 P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
646 P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
647 P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
648 P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
649 P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
650 P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
651 P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
652 P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
653 P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
654 P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
655 P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
656 P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
657 P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
658 P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
659 X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HDR_REC25,
660 X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
661 X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
662 X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
663 X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
664 X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
665 X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
666 X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
667 X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
668 X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
669 X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
670 X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TAB25,
671 X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
672 X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP ,
673 X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
674 X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
675 X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
676 X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
677 X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
678 X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
679 X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
680 X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
681 X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
682 X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T ,
683 X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
684 P_RTRIM_DATA VARCHAR2
685 );
686 ---------- O2C25
687
688
689 END Oe_Inbound_Int;
[Home] [Help]