DBA Data[Home] [Help]

PACKAGE: APPS.XX_BPEL_CALLPROCESSORDEREBS11I

Source


1 PACKAGE XX_BPEL_CALLPROCESSORDEREBS11I AUTHID CURRENT_USER AS
2 /* $Header: OEXCGNIS.pls 120.2 2008/03/20 07:54:03 sahvivek noship $ */
3 
4         -- Global check
5         G_check_action_ret_status varchar2(10) := 'S';
6 	FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
7  	RETURN OE_ORDER_PUB_HEADER_REC_TYPE;
8 
9 	FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
10 	RETURN OE_ORDER_PUB.HEADER_REC_TYPE;
11 
12 	FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
13  	RETURN OE_ORDER_PUB_HEADER_VAL_REC_T;
14 
15 	FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
16 	RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
17 
18 	FUNCTION PL_TO_SQL26(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE)
19  	RETURN OE_ORDER_PUB_HEADER_ADJ_REC_T;
20 
21 	FUNCTION SQL_TO_PL26(aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T)
22 	RETURN OE_ORDER_PUB.HEADER_ADJ_REC_TYPE;
23 
24 	FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
25  	RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T;
26 
27 	FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
28 	RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
29 
30 	FUNCTION PL_TO_SQL27(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE)
31  	RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_R;
32 
33 	FUNCTION SQL_TO_PL27(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R)
34 	RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE;
35 
36 	FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
37  	RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T;
38 
39 	FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
40 	RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
41 
42 	FUNCTION PL_TO_SQL28(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE)
43  	RETURN OE_ORDER_PUB_HEADER_PRICE_AT6;
44 
45 	FUNCTION SQL_TO_PL28(aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6)
46 	RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE;
47 
48 	FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)
49  	RETURN OE_ORDER_PUB_HEADER_PRICE_ATT;
50 
51 	FUNCTION SQL_TO_PL5(aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT)
52 	RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
53 
54 	FUNCTION PL_TO_SQL29(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE)
55  	RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_R;
56 
57 	FUNCTION SQL_TO_PL29(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R)
58 	RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE;
59 
60 	FUNCTION PL_TO_SQL6(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE)
61  	RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_T;
62 
63 	FUNCTION SQL_TO_PL6(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T)
64 	RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
65 
66 	FUNCTION PL_TO_SQL30(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE)
67  	RETURN OE_ORDER_PUB_HEADER_ADJ_ASSO6;
68 
69 	FUNCTION SQL_TO_PL30(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6)
70 	RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE;
71 
72 	FUNCTION PL_TO_SQL7(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE)
73  	RETURN OE_ORDER_PUB_HEADER_ADJ_ASSOC;
74 
75 	FUNCTION SQL_TO_PL7(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC)
76 	RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
77 
78 	FUNCTION PL_TO_SQL31(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE)
79  	RETURN OE_ORDER_PUB_HEADER_SCREDIT_R;
80 
81 	FUNCTION SQL_TO_PL31(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R)
82 	RETURN OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE;
83 
84 	FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)
85  	RETURN OE_ORDER_PUB_HEADER_SCREDIT_T;
86 
87 	FUNCTION SQL_TO_PL8(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T)
88 	RETURN OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
89 
90 	FUNCTION PL_TO_SQL32(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE)
91  	RETURN OE_ORDER_PUB_HEADER_SCREDIT11;
92 
93 	FUNCTION SQL_TO_PL32(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11)
94 	RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;
95 
96 	FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
97  	RETURN OE_ORDER_PUB_HEADER_SCREDIT_V;
98 
99 	FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
100 	RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
101 
102 	FUNCTION PL_TO_SQL33(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE)
103  	RETURN OE_ORDER_PUB_HEADER_PAYMENT_R;
104 
105 	FUNCTION SQL_TO_PL33(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R)
106 	RETURN OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE;
107 
108 	FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)
109  	RETURN OE_ORDER_PUB_HEADER_PAYMENT_T;
110 
111 	FUNCTION SQL_TO_PL10(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T)
112 	RETURN OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
113 
114 	FUNCTION PL_TO_SQL34(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE)
115  	RETURN OE_ORDER_PUB_HEADER_PAYMENT_5;
116 
117 	FUNCTION SQL_TO_PL34(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5)
118 	RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE;
119 
120 	FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)
121  	RETURN OE_ORDER_PUB_HEADER_PAYMENT_V;
122 
123 	FUNCTION SQL_TO_PL11(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V)
124 	RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
125 
126 	FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)
127  	RETURN OE_ORDER_PUB_LINE_REC_TYPE;
128 
129 	FUNCTION SQL_TO_PL35(aSqlItem OE_ORDER_PUB_LINE_REC_TYPE)
130 	RETURN OE_ORDER_PUB.LINE_REC_TYPE;
131 
132 	FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)
133  	RETURN OE_ORDER_PUB_LINE_TBL_TYPE;
134 
135 	FUNCTION SQL_TO_PL12(aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE)
136 	RETURN OE_ORDER_PUB.LINE_TBL_TYPE;
137 
138 	FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)
139  	RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP;
140 
141 	FUNCTION SQL_TO_PL36(aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP)
142 	RETURN OE_ORDER_PUB.LINE_VAL_REC_TYPE;
143 
144 	FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
145  	RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP;
146 
147 	FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
148 	RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
149 
150 	FUNCTION PL_TO_SQL37(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE)
151  	RETURN OE_ORDER_PUB_LINE_ADJ_REC_TYP;
152 
153 	FUNCTION SQL_TO_PL37(aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP)
154 	RETURN OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
155 
156 	FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
157  	RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
158 
159 	FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
160 	RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
161 
162 	FUNCTION PL_TO_SQL38(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE)
163  	RETURN OE_ORDER_PUB_LINE_ADJ_VAL_REC;
164 
165 	FUNCTION SQL_TO_PL38(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC)
166 	RETURN OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE;
167 
168 	FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)
169  	RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL;
170 
171 	FUNCTION SQL_TO_PL15(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL)
172 	RETURN OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
173 
174 	FUNCTION PL_TO_SQL39(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE)
175  	RETURN OE_ORDER_PUB_LINE_PRICE_ATT_R;
176 
177 	FUNCTION SQL_TO_PL39(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R)
178 	RETURN OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE;
179 
180 	FUNCTION PL_TO_SQL16(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE)
181  	RETURN OE_ORDER_PUB_LINE_PRICE_ATT_T;
182 
183 	FUNCTION SQL_TO_PL16(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T)
184 	RETURN OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
185 
186 	FUNCTION PL_TO_SQL40(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE)
187  	RETURN OE_ORDER_PUB_LINE_ADJ_ATT_REC;
188 
189 	FUNCTION SQL_TO_PL40(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC)
190 	RETURN OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE;
191 
192 	FUNCTION PL_TO_SQL17(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE)
193  	RETURN OE_ORDER_PUB_LINE_ADJ_ATT_TBL;
194 
195 	FUNCTION SQL_TO_PL17(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL)
196 	RETURN OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
197 
198 	FUNCTION PL_TO_SQL41(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE)
199  	RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_R;
200 
201 	FUNCTION SQL_TO_PL41(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R)
202 	RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE;
203 
204 	FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)
205  	RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T;
206 
207 	FUNCTION SQL_TO_PL18(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T)
208 	RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
209 
210 	FUNCTION PL_TO_SQL42(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE)
211  	RETURN OE_ORDER_PUB_LINE_SCREDIT_REC;
212 
213 	FUNCTION SQL_TO_PL42(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC)
214 	RETURN OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE;
215 
216 	FUNCTION PL_TO_SQL19(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE)
217  	RETURN OE_ORDER_PUB_LINE_SCREDIT_TBL;
218 
219 	FUNCTION SQL_TO_PL19(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL)
220 	RETURN OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
221 
222 	FUNCTION PL_TO_SQL43(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE)
223  	RETURN OE_ORDER_PUB_LINE_SCREDIT_VA6;
224 
225 	FUNCTION SQL_TO_PL43(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6)
226 	RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;
227 
228 	FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
229  	RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL;
230 
231 	FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
232 	RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
233 
234 	FUNCTION PL_TO_SQL44(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE)
235  	RETURN OE_ORDER_PUB_LINE_PAYMENT_REC;
236 
237 	FUNCTION SQL_TO_PL44(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC)
238 	RETURN OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE;
239 
240 	FUNCTION PL_TO_SQL21(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE)
241  	RETURN OE_ORDER_PUB_LINE_PAYMENT_TBL;
242 
243 	FUNCTION SQL_TO_PL21(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL)
244 	RETURN OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
245 
246 	FUNCTION PL_TO_SQL45(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE)
247  	RETURN OE_ORDER_PUB_LINE_PAYMENT_VA3;
248 
249 	FUNCTION SQL_TO_PL45(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3)
250 	RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;
251 
252 	FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
253  	RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL;
254 
255 	FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
256 	RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
257 
258 	FUNCTION PL_TO_SQL46(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE)
259  	RETURN OE_ORDER_PUB_LOT_SERIAL_REC_T;
260 
261 	FUNCTION SQL_TO_PL46(aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T)
262 	RETURN OE_ORDER_PUB.LOT_SERIAL_REC_TYPE;
263 
264 	FUNCTION PL_TO_SQL23(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE)
265  	RETURN OE_ORDER_PUB_LOT_SERIAL_TBL_T;
266 
267 	FUNCTION SQL_TO_PL23(aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T)
268 	RETURN OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
269 
270 	FUNCTION PL_TO_SQL47(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE)
271  	RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_R;
272 
273 	FUNCTION SQL_TO_PL47(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R)
274 	RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE;
275 
276 	FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
277  	RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T;
278 
279 	FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
280 	RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
281 
282 	FUNCTION PL_TO_SQL48(aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE)
283  	RETURN OE_ORDER_PUB_REQUEST_REC_TYPE;
284 
285 	FUNCTION SQL_TO_PL48(aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE)
286 	RETURN OE_ORDER_PUB.REQUEST_REC_TYPE;
287 
288 	FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
289  	RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE;
290 
291 	FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
292 	RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE;
293 
294     PROCEDURE Convert_Line_null_to_miss(p_x_line_rec IN OUT NOCOPY  OE_Order_PUB.Line_Rec_Type);
295     PROCEDURE Convert_hdr_null_to_miss (p_x_header_rec IN OUT NOCOPY  OE_Order_PUB.Header_Rec_Type);
296 
297     PROCEDURE OE_ORDER_PUB$PROCESS_ORDER (
298         P_API_VERSION_NUMBER NUMBER,
299         P_INIT_MSG_LIST VARCHAR2,
300         P_RETURN_VALUES VARCHAR2,
301         P_ACTION_COMMIT VARCHAR2,
302         X_RETURN_STATUS OUT NOCOPY VARCHAR2,
303         X_MSG_COUNT OUT NOCOPY NUMBER,
304         X_MSG_DATA OUT NOCOPY VARCHAR2,
305         P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
306         P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
307         P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
308         P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
309         P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
310         P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
311         P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
312         P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
313         P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
314         P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
315         P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
316         P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
317         P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
318         P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
319         P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
320         P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
324         P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
321         P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
322         P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
323         P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
325         P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
326         P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
327         P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
328         P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
329         P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
330         P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
331         P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
332         P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
333         P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
334         P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
335         P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
336         P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
337         P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
338         P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
339         P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
340         P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
341         P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
342         P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
343         P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
344         P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
345         P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
346         P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
347         P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
348         P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
349         P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
350         P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
351         P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
352         P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
353         P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
354         X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
355         X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
356         X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
357         X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
358         X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
359         X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
360         X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
361         X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
362         X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
363         X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
364         X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
365         X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
366         X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
367         X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
368         X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
369         X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
370         X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
371         X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
372         X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
373         X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
374         X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
375         X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
376         X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
377         X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T,
378         X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
379         P_RTRIM_DATA VARCHAR2);
380 END XX_BPEL_CALLPROCESSORDEREBS11I;