eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.XX_BPEL_CALLPROCESSORDEREBS11I

Source


1 PACKAGE BODY XX_BPEL_CALLPROCESSORDEREBS11I AS
2 /* $Header: OEXCGNIB.pls 120.3 2008/03/20 07:54:34 sahvivek noship $ */
3 
4 	FUNCTION PL_TO_SQL1(aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE)
5  	RETURN OE_ORDER_PUB_HEADER_REC_TYPE IS
6 	aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE;
7 	BEGIN
8     aSqlItem  :=  oe_inbound_int.PL_TO_SQL1(aPlsqlItem);
9 		RETURN aSqlItem;
10 	END PL_TO_SQL1;
11 
12 	FUNCTION SQL_TO_PL1(aSqlItem OE_ORDER_PUB_HEADER_REC_TYPE)
13 	RETURN OE_ORDER_PUB.HEADER_REC_TYPE IS
14 	aPlsqlItem OE_ORDER_PUB.HEADER_REC_TYPE;
15 	BEGIN
16     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL1(aSqlItem);
17 		RETURN aPlsqlItem;
18 	END SQL_TO_PL1;
19 
20 	FUNCTION PL_TO_SQL2(aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE)
21  	RETURN OE_ORDER_PUB_HEADER_VAL_REC_T IS
22 	aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T;
23 	BEGIN
24     aSqlItem  :=  oe_inbound_int.PL_TO_SQL2(aPlsqlItem);
25 		RETURN aSqlItem;
26 	END PL_TO_SQL2;
27 
28 	FUNCTION SQL_TO_PL2(aSqlItem OE_ORDER_PUB_HEADER_VAL_REC_T)
29 	RETURN OE_ORDER_PUB.HEADER_VAL_REC_TYPE IS
30 	aPlsqlItem OE_ORDER_PUB.HEADER_VAL_REC_TYPE;
31 	BEGIN
32     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL2(aSqlItem);
33 		RETURN aPlsqlItem;
34 	END SQL_TO_PL2;
35 
36 	FUNCTION PL_TO_SQL26(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE)
37  	RETURN OE_ORDER_PUB_HEADER_ADJ_REC_T IS
38 	aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T;
39 	BEGIN
40     aSqlItem  :=  oe_inbound_int.PL_TO_SQL26(aPlsqlItem);
41 		RETURN aSqlItem;
42 	END PL_TO_SQL26;
43 
44 	FUNCTION SQL_TO_PL26(aSqlItem OE_ORDER_PUB_HEADER_ADJ_REC_T)
45 	RETURN OE_ORDER_PUB.HEADER_ADJ_REC_TYPE IS
46 	aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_REC_TYPE;
47 	BEGIN
48     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL26(aSqlItem);
49 		RETURN aPlsqlItem;
50 	END SQL_TO_PL26;
51 
52 	FUNCTION PL_TO_SQL3(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE)
53  	RETURN OE_ORDER_PUB_HEADER_ADJ_TBL_T IS
54 	aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T;
55 	BEGIN
56     aSqlItem  :=  oe_inbound_int.PL_TO_SQL3(aPlsqlItem);
57 		RETURN aSqlItem;
58 	END PL_TO_SQL3;
59 
60 	FUNCTION SQL_TO_PL3(aSqlItem OE_ORDER_PUB_HEADER_ADJ_TBL_T)
61 	RETURN OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE IS
62 	aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_TBL_TYPE;
63 	BEGIN
64     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL3(aSqlItem);
65 		RETURN aPlsqlItem;
66 	END SQL_TO_PL3;
67 
68 	FUNCTION PL_TO_SQL27(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE)
69  	RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_R IS
70 	aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R;
71 	BEGIN
72     aSqlItem  :=  oe_inbound_int.PL_TO_SQL27(aPlsqlItem);
73 		RETURN aSqlItem;
74 	END PL_TO_SQL27;
75 
76 	FUNCTION SQL_TO_PL27(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_R)
77 	RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE IS
78 	aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_REC_TYPE;
79 	BEGIN
80      aPlsqlItem   :=  oe_inbound_int.SQL_TO_PL27(aSqlItem);
81 		RETURN aPlsqlItem;
82 	END SQL_TO_PL27;
83 
84 	FUNCTION PL_TO_SQL4(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE)
85  	RETURN OE_ORDER_PUB_HEADER_ADJ_VAL_T IS
86 	aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T;
87 	BEGIN
88      aSqlItem   :=  oe_inbound_int.PL_TO_SQL4(aPlsqlItem);
89 		RETURN aSqlItem;
90 	END PL_TO_SQL4;
91 
92 	FUNCTION SQL_TO_PL4(aSqlItem OE_ORDER_PUB_HEADER_ADJ_VAL_T)
93 	RETURN OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE IS
94 	aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_VAL_TBL_TYPE;
95 	BEGIN
96     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL4(aSqlItem);
97 		RETURN aPlsqlItem;
98 	END SQL_TO_PL4;
99 
100 	FUNCTION PL_TO_SQL28(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE)
101  	RETURN OE_ORDER_PUB_HEADER_PRICE_AT6 IS
102 	aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6;
103 	BEGIN
104      aSqlItem   :=  oe_inbound_int.PL_TO_SQL28(aPlsqlItem);
105 		RETURN aSqlItem;
106 	END PL_TO_SQL28;
107 
108 	FUNCTION SQL_TO_PL28(aSqlItem OE_ORDER_PUB_HEADER_PRICE_AT6)
109 	RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE IS
110 	  aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_REC_TYPE;
111 	BEGIN
112     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL28(aSqlItem);
113 		RETURN aPlsqlItem;
114 	END SQL_TO_PL28;
115 
116 	FUNCTION PL_TO_SQL5(aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE)
117  	RETURN OE_ORDER_PUB_HEADER_PRICE_ATT IS
118 	  aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT;
119 	BEGIN
120     aSqlItem  :=  oe_inbound_int.PL_TO_SQL5(aPlsqlItem);
121 		RETURN aSqlItem;
122 	END PL_TO_SQL5;
123 
124 	FUNCTION SQL_TO_PL5(aSqlItem OE_ORDER_PUB_HEADER_PRICE_ATT)
125 	RETURN OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE IS
126 	aPlsqlItem OE_ORDER_PUB.HEADER_PRICE_ATT_TBL_TYPE;
127 	BEGIN
128     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL5(aSqlItem);
129 		RETURN aPlsqlItem;
130 	END SQL_TO_PL5;
131 
132 	FUNCTION PL_TO_SQL29(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE)
133  	RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_R IS
134 	aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R;
135 	BEGIN
136     aSqlItem  :=  oe_inbound_int.PL_TO_SQL29(aPlsqlItem);
137 		RETURN aSqlItem;
138 	END PL_TO_SQL29;
139 
140 	FUNCTION SQL_TO_PL29(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_R)
141 	RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE IS
142 	aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_REC_TYPE;
143 	BEGIN
144     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL29(aSqlItem);
145 		RETURN aPlsqlItem;
146 	END SQL_TO_PL29;
147 
148 	FUNCTION PL_TO_SQL6(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE)
149  	RETURN OE_ORDER_PUB_HEADER_ADJ_ATT_T IS
150 	aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T;
151 	BEGIN
152     aSqlItem := oe_inbound_int.PL_TO_SQL6(aPlsqlItem);
153 		RETURN aSqlItem;
154 	END PL_TO_SQL6;
155 
156 	FUNCTION SQL_TO_PL6(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ATT_T)
157 	RETURN OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE IS
158 	aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ATT_TBL_TYPE;
159   BEGIN
160     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL6(aSqlItem);
161 		RETURN aPlsqlItem;
162 	END SQL_TO_PL6;
163 
164 	FUNCTION PL_TO_SQL30(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE)
165  	RETURN OE_ORDER_PUB_HEADER_ADJ_ASSO6 IS
166 	aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6;
167 	BEGIN
168     aSqlItem  :=  oe_inbound_int.PL_TO_SQL30(aPlsqlItem);
169 		RETURN aSqlItem;
170 	END PL_TO_SQL30;
171 
172 	FUNCTION SQL_TO_PL30(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSO6)
173 	RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE IS
174 	aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_REC_TYPE;
175 	BEGIN
176     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL30(aSqlItem);
177 		RETURN aPlsqlItem;
178 	END SQL_TO_PL30;
179 
180 	FUNCTION PL_TO_SQL7(aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE)
181  	RETURN OE_ORDER_PUB_HEADER_ADJ_ASSOC IS
182 	aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC;
183 	BEGIN
184     aSqlItem  :=  oe_inbound_int.PL_TO_SQL7(aPlsqlItem);
185 		RETURN aSqlItem;
186 	END PL_TO_SQL7;
187 
188 	FUNCTION SQL_TO_PL7(aSqlItem OE_ORDER_PUB_HEADER_ADJ_ASSOC)
189 	RETURN OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE IS
190 	aPlsqlItem OE_ORDER_PUB.HEADER_ADJ_ASSOC_TBL_TYPE;
191 	BEGIN
192     aPlsqlItem  :=  oe_inbound_int. SQL_TO_PL7(aSqlItem);
193 		RETURN aPlsqlItem;
194 	END SQL_TO_PL7;
195 
196 	FUNCTION PL_TO_SQL31(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE)
197  	RETURN OE_ORDER_PUB_HEADER_SCREDIT_R IS
198 	aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R;
199 	BEGIN
200     aSqlItem  :=  oe_inbound_int.PL_TO_SQL31(aPlsqlItem);
201 		RETURN aSqlItem;
202 	END PL_TO_SQL31;
203 
204 	FUNCTION SQL_TO_PL31(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_R)
205 	RETURN OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE IS
206 	aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_REC_TYPE;
207 	BEGIN
208     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL31(aSqlItem);
209 		RETURN aPlsqlItem;
210 	END SQL_TO_PL31;
211 
212 	FUNCTION PL_TO_SQL8(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE)
213  	RETURN OE_ORDER_PUB_HEADER_SCREDIT_T IS
214 	aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T;
215 	BEGIN
216     aSqlItem  :=  oe_inbound_int.PL_TO_SQL8(aPlsqlItem);
217 		RETURN aSqlItem;
218 	END PL_TO_SQL8;
219 
220 	FUNCTION SQL_TO_PL8(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_T)
221 	RETURN OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE IS
222 	aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_TBL_TYPE;
223 	BEGIN
224     aPlsqlItem  := oe_inbound_int.SQL_TO_PL8(aSqlItem);
225 		RETURN aPlsqlItem;
226 	END SQL_TO_PL8;
227 
228 	FUNCTION PL_TO_SQL32(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE)
229  	RETURN OE_ORDER_PUB_HEADER_SCREDIT11 IS
230 	  aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11;
231 	BEGIN
232      aSqlItem :=  oe_inbound_int.PL_TO_SQL32(aPlsqlItem);
233 		RETURN aSqlItem;
234 	END PL_TO_SQL32;
235 
236 	FUNCTION SQL_TO_PL32(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT11)
237 	RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE IS
238 	aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_REC_TYPE;
239 	BEGIN
240     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL32(aSqlItem);
241 		RETURN aPlsqlItem;
242 	END SQL_TO_PL32;
243 
244 	FUNCTION PL_TO_SQL9(aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE)
245  	RETURN OE_ORDER_PUB_HEADER_SCREDIT_V IS
246 	aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V;
247 	BEGIN
248     aSqlItem  :=  oe_inbound_int.PL_TO_SQL9(aPlsqlItem);
249 		RETURN aSqlItem;
250 	END PL_TO_SQL9;
251 
252 	FUNCTION SQL_TO_PL9(aSqlItem OE_ORDER_PUB_HEADER_SCREDIT_V)
253 	RETURN OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE IS
254 	aPlsqlItem OE_ORDER_PUB.HEADER_SCREDIT_VAL_TBL_TYPE;
255 	BEGIN
256     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL9(aSqlItem);
257 		RETURN aPlsqlItem;
258 	END SQL_TO_PL9;
259 
260 	FUNCTION PL_TO_SQL33(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE)
261  	RETURN OE_ORDER_PUB_HEADER_PAYMENT_R IS
262 	aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R;
263 	BEGIN
264     aSqlItem  :=  oe_inbound_int.PL_TO_SQL33(aPlsqlItem);
265 		RETURN aSqlItem;
266 	END PL_TO_SQL33;
267 
268 	FUNCTION SQL_TO_PL33(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_R)
269 	RETURN OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE IS
270 	aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_REC_TYPE;
271 	BEGIN
272     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL33(aSqlItem);
273 		RETURN aPlsqlItem;
274 	END SQL_TO_PL33;
275 
276 	FUNCTION PL_TO_SQL10(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE)
277  	RETURN OE_ORDER_PUB_HEADER_PAYMENT_T IS
278 	aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T;
279 	BEGIN
280     aSqlItem  :=  oe_inbound_int.PL_TO_SQL10(aPlsqlItem);
281 		RETURN aSqlItem;
282 	END PL_TO_SQL10;
283 
284 	FUNCTION SQL_TO_PL10(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_T)
285 	RETURN OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE IS
286 	aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_TBL_TYPE;
287 	BEGIN
288     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL10(aSqlItem);
289 	  RETURN aPlsqlItem;
290 	END SQL_TO_PL10;
291 
292 	FUNCTION PL_TO_SQL34(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE)
293  	RETURN OE_ORDER_PUB_HEADER_PAYMENT_5 IS
294 	aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5;
295 	BEGIN
296     aSqlItem  :=  oe_inbound_int.PL_TO_SQL34(aPlsqlItem);
297 		RETURN aSqlItem;
298 	END PL_TO_SQL34;
299 
300 	FUNCTION SQL_TO_PL34(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_5)
301 	RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE IS
302 	aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_REC_TYPE;
303 	BEGIN
304     aPlsqlItem  := oe_inbound_int.SQL_TO_PL34(aSqlItem);
305 		RETURN aPlsqlItem;
306 	END SQL_TO_PL34;
307 
308 	FUNCTION PL_TO_SQL11(aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE)
309  	RETURN OE_ORDER_PUB_HEADER_PAYMENT_V IS
310 	aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V;
311 	BEGIN
312     aSqlItem  :=  oe_inbound_int.PL_TO_SQL11(aPlsqlItem);
313 		RETURN aSqlItem;
314 	END PL_TO_SQL11;
315 
316 	FUNCTION SQL_TO_PL11(aSqlItem OE_ORDER_PUB_HEADER_PAYMENT_V)
317 	RETURN OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE IS
318 	aPlsqlItem OE_ORDER_PUB.HEADER_PAYMENT_VAL_TBL_TYPE;
319 	BEGIN
320     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL11(aSqlItem);
321 		RETURN aPlsqlItem;
322 	END SQL_TO_PL11;
323 
324 	FUNCTION PL_TO_SQL35(aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE)
325  	RETURN OE_ORDER_PUB_LINE_REC_TYPE IS
326 	aSqlItem OE_ORDER_PUB_LINE_REC_TYPE;
327 	BEGIN
328     aSqlItem  :=  oe_inbound_int.PL_TO_SQL35(aPlsqlItem);
329 		RETURN aSqlItem;
330 	END PL_TO_SQL35;
331 
332 	FUNCTION SQL_TO_PL35(aSqlItem OE_ORDER_PUB_LINE_REC_TYPE)
333 	RETURN OE_ORDER_PUB.LINE_REC_TYPE IS
334 	aPlsqlItem OE_ORDER_PUB.LINE_REC_TYPE;
335 	BEGIN
336     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL35(aSqlItem);
337 		RETURN aPlsqlItem;
338 	END SQL_TO_PL35;
339 
340 	FUNCTION PL_TO_SQL12(aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE)
341  	RETURN OE_ORDER_PUB_LINE_TBL_TYPE IS
342 	aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE;
343 	BEGIN
344     aSqlItem := oe_inbound_int.PL_TO_SQL12(aPlsqlItem);
345 		RETURN aSqlItem;
346 	END PL_TO_SQL12;
347 
348 	FUNCTION SQL_TO_PL12(aSqlItem OE_ORDER_PUB_LINE_TBL_TYPE)
349 	RETURN OE_ORDER_PUB.LINE_TBL_TYPE IS
350 	aPlsqlItem OE_ORDER_PUB.LINE_TBL_TYPE;
351 	BEGIN
352     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL12(aSqlItem);
353 		RETURN aPlsqlItem;
354 	END SQL_TO_PL12;
355 
356 	FUNCTION PL_TO_SQL36(aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE)
357  	RETURN OE_ORDER_PUB_LINE_VAL_REC_TYP IS
358 	aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP;
359 	BEGIN
360     aSqlItem  :=  oe_inbound_int.PL_TO_SQL36(aPlsqlItem);
361 		RETURN aSqlItem;
362 	END PL_TO_SQL36;
363 
364 	FUNCTION SQL_TO_PL36(aSqlItem OE_ORDER_PUB_LINE_VAL_REC_TYP)
365 	RETURN OE_ORDER_PUB.LINE_VAL_REC_TYPE IS
366 	aPlsqlItem OE_ORDER_PUB.LINE_VAL_REC_TYPE;
367 	BEGIN
368     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL36(aSqlItem);
369 		RETURN aPlsqlItem;
370 	END SQL_TO_PL36;
371 
372 	FUNCTION PL_TO_SQL13(aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE)
373  	RETURN OE_ORDER_PUB_LINE_VAL_TBL_TYP IS
374 	aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP;
375 	BEGIN
376     aSqlItem  :=  oe_inbound_int.PL_TO_SQL13(aPlsqlItem);
377 		RETURN aSqlItem;
378 	END PL_TO_SQL13;
379 
380 	FUNCTION SQL_TO_PL13(aSqlItem OE_ORDER_PUB_LINE_VAL_TBL_TYP)
381 	RETURN OE_ORDER_PUB.LINE_VAL_TBL_TYPE IS
382 	aPlsqlItem OE_ORDER_PUB.LINE_VAL_TBL_TYPE;
383 	BEGIN
384     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL13(aSqlItem);
385 		RETURN aPlsqlItem;
386 	END SQL_TO_PL13;
387 
388 	FUNCTION PL_TO_SQL37(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE)
389  	RETURN OE_ORDER_PUB_LINE_ADJ_REC_TYP IS
390 	aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP;
391 	BEGIN
392     aSqlItem := oe_inbound_int.PL_TO_SQL37(aPlsqlItem);
393 		RETURN aSqlItem;
394 	END PL_TO_SQL37;
395 
396 	FUNCTION SQL_TO_PL37(aSqlItem OE_ORDER_PUB_LINE_ADJ_REC_TYP)
397 	RETURN OE_ORDER_PUB.LINE_ADJ_REC_TYPE IS
398 	aPlsqlItem OE_ORDER_PUB.LINE_ADJ_REC_TYPE;
399 	BEGIN
400     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL37(aSqlItem);
401 		RETURN aPlsqlItem;
402 	END SQL_TO_PL37;
403 
404 	FUNCTION PL_TO_SQL14(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE)
405  	RETURN OE_ORDER_PUB_LINE_ADJ_TBL_TYP IS
406 	aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP;
407 	BEGIN
408     aSqlItem  :=  oe_inbound_int.PL_TO_SQL14(aPlsqlItem);
409 		RETURN aSqlItem;
410 	END PL_TO_SQL14;
411 
412 	FUNCTION SQL_TO_PL14(aSqlItem OE_ORDER_PUB_LINE_ADJ_TBL_TYP)
413 	RETURN OE_ORDER_PUB.LINE_ADJ_TBL_TYPE IS
414 	aPlsqlItem OE_ORDER_PUB.LINE_ADJ_TBL_TYPE;
415 	BEGIN
416     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL14(aSqlItem);
420 	FUNCTION PL_TO_SQL38(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE)
417 	  RETURN aPlsqlItem;
418 	END SQL_TO_PL14;
419 
421  	RETURN OE_ORDER_PUB_LINE_ADJ_VAL_REC IS
422 	aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC;
423 	BEGIN
424     aSqlItem :=  oe_inbound_int.PL_TO_SQL38(aPlsqlItem);
425 	  RETURN aSqlItem;
426 	END PL_TO_SQL38;
427 
428 	FUNCTION SQL_TO_PL38(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_REC)
429 	RETURN OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE IS
430 	aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE;
431 	BEGIN
432     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL38(aSqlItem);
433 		RETURN aPlsqlItem;
434 	END SQL_TO_PL38;
435 
436 	FUNCTION PL_TO_SQL15(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE)
437  	RETURN OE_ORDER_PUB_LINE_ADJ_VAL_TBL IS
438 	aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL;
439 	BEGIN
440     aSqlItem  :=  oe_inbound_int.PL_TO_SQL15(aPlsqlItem);
441 		RETURN aSqlItem;
442 	END PL_TO_SQL15;
443 
444 	FUNCTION SQL_TO_PL15(aSqlItem OE_ORDER_PUB_LINE_ADJ_VAL_TBL)
445 	RETURN OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE IS
446 	aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_TBL_TYPE;
447 	BEGIN
448     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL15(aSqlItem);
449 		RETURN aPlsqlItem;
450 	END SQL_TO_PL15;
451 
452 	FUNCTION PL_TO_SQL39(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE)
453  	RETURN OE_ORDER_PUB_LINE_PRICE_ATT_R IS
454 	aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R;
455 	BEGIN
456     aSqlItem  :=  oe_inbound_int.PL_TO_SQL39(aPlsqlItem);
457 		RETURN aSqlItem;
458 	END PL_TO_SQL39;
459 
460 	FUNCTION SQL_TO_PL39(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_R)
461 	RETURN OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE IS
462 	aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_REC_TYPE;
463 	BEGIN
464     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL39(aSqlItem);
465 		RETURN aPlsqlItem;
466 	END SQL_TO_PL39;
467 
468 	FUNCTION PL_TO_SQL16(aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE)
469  	RETURN OE_ORDER_PUB_LINE_PRICE_ATT_T IS
470 	aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T;
471 	BEGIN
472     aSqlItem  :=  oe_inbound_int.PL_TO_SQL16(aPlsqlItem);
473 		RETURN aSqlItem;
474 	END PL_TO_SQL16;
475 
476 	FUNCTION SQL_TO_PL16(aSqlItem OE_ORDER_PUB_LINE_PRICE_ATT_T)
477 	RETURN OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE IS
478 	aPlsqlItem OE_ORDER_PUB.LINE_PRICE_ATT_TBL_TYPE;
479 	BEGIN
480     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL16(aSqlItem);
481 		RETURN aPlsqlItem;
482 	END SQL_TO_PL16;
483 
484 	FUNCTION PL_TO_SQL40(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE)
485  	RETURN OE_ORDER_PUB_LINE_ADJ_ATT_REC IS
486 	aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC;
487 	BEGIN
488     aSqlItem  :=  oe_inbound_int.PL_TO_SQL40(aPlsqlItem);
489 		RETURN aSqlItem;
490 	END PL_TO_SQL40;
491 
492 	FUNCTION SQL_TO_PL40(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_REC)
493 	RETURN OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE IS
494 	aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_REC_TYPE;
495 	BEGIN
496     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL40(aSqlItem);
497 		RETURN aPlsqlItem;
498 	END SQL_TO_PL40;
499 
500 	FUNCTION PL_TO_SQL17(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE)
501  	RETURN OE_ORDER_PUB_LINE_ADJ_ATT_TBL IS
502 	aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL;
503 	BEGIN
504     aSqlItem  :=  oe_inbound_int.PL_TO_SQL17(aPlsqlItem);
505 		RETURN aSqlItem;
506 	END PL_TO_SQL17;
507 
508 	FUNCTION SQL_TO_PL17(aSqlItem OE_ORDER_PUB_LINE_ADJ_ATT_TBL)
509 	RETURN OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE IS
510 	aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ATT_TBL_TYPE;
511 	BEGIN
512     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL17(aSqlItem);
513 		RETURN aPlsqlItem;
514 	END SQL_TO_PL17;
515 
516 	FUNCTION PL_TO_SQL41(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE)
517  	RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_R IS
518 	aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R;
519 	BEGIN
520     aSqlItem  :=  oe_inbound_int.PL_TO_SQL41(aPlsqlItem);
521 		RETURN aSqlItem;
522 	END PL_TO_SQL41;
523 
524 	FUNCTION SQL_TO_PL41(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_R)
525 	RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE IS
526 	aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_REC_TYPE;
527 	BEGIN
528     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL41(aSqlItem);
529 	  RETURN aPlsqlItem;
530 	END SQL_TO_PL41;
531 
532 	FUNCTION PL_TO_SQL18(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE)
533  	RETURN OE_ORDER_PUB_LINE_ADJ_ASSOC_T IS
534 	aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T;
535 	BEGIN
536     aSqlItem  := oe_inbound_int.PL_TO_SQL18(aPlsqlItem);
537 		RETURN aSqlItem;
538 	END PL_TO_SQL18;
539 
540 	FUNCTION SQL_TO_PL18(aSqlItem OE_ORDER_PUB_LINE_ADJ_ASSOC_T)
541 	RETURN OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE IS
542 	aPlsqlItem OE_ORDER_PUB.LINE_ADJ_ASSOC_TBL_TYPE;
543 	BEGIN
544     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL18(aSqlItem);
545 	  RETURN aPlsqlItem;
546 	END SQL_TO_PL18;
547 
548 	FUNCTION PL_TO_SQL42(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE)
549  	RETURN OE_ORDER_PUB_LINE_SCREDIT_REC IS
550 	  aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC;
551 	BEGIN
552     aSqlItem  :=  oe_inbound_int.PL_TO_SQL42(aPlsqlItem);
553 	  RETURN aSqlItem;
554 	END PL_TO_SQL42;
555 
556 	FUNCTION SQL_TO_PL42(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_REC)
557 	RETURN OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE IS
558 	aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_REC_TYPE;
559 	BEGIN
560     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL42(aSqlItem);
561 	  RETURN aPlsqlItem;
562 	END SQL_TO_PL42;
563 
564 	FUNCTION PL_TO_SQL19(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE)
565  	RETURN OE_ORDER_PUB_LINE_SCREDIT_TBL IS
566 	aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL;
567 	BEGIN
568     aSqlItem  :=  oe_inbound_int.PL_TO_SQL19(aPlsqlItem);
569 		RETURN aSqlItem;
570 	END PL_TO_SQL19;
574 	aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
571 
572 	FUNCTION SQL_TO_PL19(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL)
573 	RETURN OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE IS
575 	BEGIN
576     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL19(aSqlItem);
577 		RETURN aPlsqlItem;
578 	END SQL_TO_PL19;
579 
580 	FUNCTION PL_TO_SQL43(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE)
581  	RETURN OE_ORDER_PUB_LINE_SCREDIT_VA6 IS
582 	aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6;
583 	BEGIN
584     aSqlItem  :=  oe_inbound_int.PL_TO_SQL43(aPlsqlItem);
585 		RETURN aSqlItem;
586 	END PL_TO_SQL43;
587 
588 	FUNCTION SQL_TO_PL43(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VA6)
589 	RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE IS
590 	aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_REC_TYPE;
591 	BEGIN
592     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL43(aSqlItem);
593 		RETURN aPlsqlItem;
594 	END SQL_TO_PL43;
595 
596 	FUNCTION PL_TO_SQL20(aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE)
597  	RETURN OE_ORDER_PUB_LINE_SCREDIT_VAL IS
598 	aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL;
599 	BEGIN
600     aSqlItem  :=  oe_inbound_int.PL_TO_SQL20(aPlsqlItem);
601 		RETURN aSqlItem;
602 	END PL_TO_SQL20;
603 
604 	FUNCTION SQL_TO_PL20(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_VAL)
605 	RETURN OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE IS
606 	aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_VAL_TBL_TYPE;
607 	BEGIN
608     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL20(aSqlItem);
609 		RETURN aPlsqlItem;
610 	END SQL_TO_PL20;
611 
612 	FUNCTION PL_TO_SQL44(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE)
613  	RETURN OE_ORDER_PUB_LINE_PAYMENT_REC IS
614 	aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC;
615 	BEGIN
616     aSqlItem  :=  oe_inbound_int.PL_TO_SQL44(aPlsqlItem);
617 		RETURN aSqlItem;
618 	END PL_TO_SQL44;
619 
620 	FUNCTION SQL_TO_PL44(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_REC)
621 	RETURN OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE IS
622 	aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_REC_TYPE;
623 	BEGIN
624     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL44(aSqlItem);
625 		RETURN aPlsqlItem;
626 	END SQL_TO_PL44;
627 
628 
629 	FUNCTION PL_TO_SQL21(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE)
630  	RETURN OE_ORDER_PUB_LINE_PAYMENT_TBL IS
631 	aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL;
632 	BEGIN
633     aSqlItem  :=  oe_inbound_int.PL_TO_SQL21(aPlsqlItem);
634 		RETURN aSqlItem;
635 	END PL_TO_SQL21;
636 
637 	FUNCTION SQL_TO_PL21(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_TBL)
638 	RETURN OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE IS
639 	aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_TBL_TYPE;
640 	BEGIN
641     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL21(aSqlItem);
642 		RETURN aPlsqlItem;
643 	END SQL_TO_PL21;
644 
645 	FUNCTION PL_TO_SQL45(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE)
646  	RETURN OE_ORDER_PUB_LINE_PAYMENT_VA3 IS
647 	aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3;
648 	BEGIN
649     aSqlItem  :=  oe_inbound_int.PL_TO_SQL45(aPlsqlItem);
650 		RETURN aSqlItem;
651 	END PL_TO_SQL45;
652 
653 	FUNCTION SQL_TO_PL45(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VA3)
654 	RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE IS
655 	aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_REC_TYPE;
656 	BEGIN
657     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL45(aSqlItem);
658 		RETURN aPlsqlItem;
659 	END SQL_TO_PL45;
660 
661 	FUNCTION PL_TO_SQL22(aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE)
662  	RETURN OE_ORDER_PUB_LINE_PAYMENT_VAL IS
663 	aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL;
664 	BEGIN
665     aSqlItem  := oe_inbound_int.PL_TO_SQL22(aPlsqlItem);
666 		RETURN aSqlItem;
667 	END PL_TO_SQL22;
668 
669 
670 	FUNCTION SQL_TO_PL22(aSqlItem OE_ORDER_PUB_LINE_PAYMENT_VAL)
671 	RETURN OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE IS
672 	aPlsqlItem OE_ORDER_PUB.LINE_PAYMENT_VAL_TBL_TYPE;
673 	BEGIN
674     aPlsqlItem := oe_inbound_int.SQL_TO_PL22(aSqlItem);
675 		RETURN aPlsqlItem;
676 	END SQL_TO_PL22;
677 
678 	FUNCTION PL_TO_SQL46(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE)
679  	RETURN OE_ORDER_PUB_LOT_SERIAL_REC_T IS
680 	aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T;
681 	BEGIN
682     aSqlItem  :=  oe_inbound_int.PL_TO_SQL46(aPlsqlItem);
683 		RETURN aSqlItem;
684 	END PL_TO_SQL46;
685 
686 	FUNCTION SQL_TO_PL46(aSqlItem OE_ORDER_PUB_LOT_SERIAL_REC_T)
687 	RETURN OE_ORDER_PUB.LOT_SERIAL_REC_TYPE IS
688 	aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_REC_TYPE;
689 	BEGIN
690     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL46(aSqlItem);
691 		RETURN aPlsqlItem;
692 	END SQL_TO_PL46;
693 
694 	FUNCTION PL_TO_SQL23(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE)
695  	RETURN OE_ORDER_PUB_LOT_SERIAL_TBL_T IS
696 	aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T;
697 	BEGIN
698     aSqlItem  :=  oe_inbound_int.PL_TO_SQL23(aPlsqlItem);
699 		RETURN aSqlItem;
700 	END PL_TO_SQL23;
701 
702 	FUNCTION SQL_TO_PL23(aSqlItem OE_ORDER_PUB_LOT_SERIAL_TBL_T)
703 	RETURN OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE IS
704 	aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_TBL_TYPE;
705 	BEGIN
706     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL23(aSqlItem);
707 		RETURN aPlsqlItem;
708 	END SQL_TO_PL23;
709 
710 	FUNCTION PL_TO_SQL47(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE)
711  	RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_R IS
712 	aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R;
713 	BEGIN
714     aSqlItem  :=  oe_inbound_int.PL_TO_SQL47(aPlsqlItem);
715 		RETURN aSqlItem;
716 	END PL_TO_SQL47;
717 
718 	FUNCTION SQL_TO_PL47(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_R)
719 	RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE IS
720 	aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_REC_TYPE;
721 	BEGIN
722     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL47(aSqlItem);
723 		RETURN aPlsqlItem;
724 	END SQL_TO_PL47;
725 
729 	BEGIN
726 	FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)
727  	RETURN OE_ORDER_PUB_LOT_SERIAL_VAL_T IS
728 	aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T;
730     aSqlItem  :=  oe_inbound_int.PL_TO_SQL24(aPlsqlItem);
731 	  RETURN aSqlItem;
732 	END PL_TO_SQL24;
733 
734 	FUNCTION SQL_TO_PL24(aSqlItem OE_ORDER_PUB_LOT_SERIAL_VAL_T)
735 	RETURN OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE IS
736 	aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE;
737 	BEGIN
738     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL24(aSqlItem);
739 	  RETURN aPlsqlItem;
740 	END SQL_TO_PL24;
741 
742 	FUNCTION PL_TO_SQL48(aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE)
743  	RETURN OE_ORDER_PUB_REQUEST_REC_TYPE IS
744 	aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE;
745 	BEGIN
746     aSqlItem  :=  oe_inbound_int.PL_TO_SQL48(aPlsqlItem);
747 		RETURN aSqlItem;
748 	END PL_TO_SQL48;
749 
750 	FUNCTION SQL_TO_PL48(aSqlItem OE_ORDER_PUB_REQUEST_REC_TYPE)
751 	RETURN OE_ORDER_PUB.REQUEST_REC_TYPE IS
752 	aPlsqlItem OE_ORDER_PUB.REQUEST_REC_TYPE;
753 	BEGIN
754     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL48(aSqlItem);
755 		RETURN aPlsqlItem;
756 	END SQL_TO_PL48;
757 
758 	FUNCTION PL_TO_SQL25(aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE)
759  	RETURN OE_ORDER_PUB_REQUEST_TBL_TYPE IS
760 	aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE;
761 	BEGIN
762     aSqlItem  :=  oe_inbound_int.PL_TO_SQL25(aPlsqlItem);
763 		RETURN aSqlItem;
764 	END PL_TO_SQL25;
765 
766 	FUNCTION SQL_TO_PL25(aSqlItem OE_ORDER_PUB_REQUEST_TBL_TYPE)
767 	RETURN OE_ORDER_PUB.REQUEST_TBL_TYPE IS
768 	aPlsqlItem OE_ORDER_PUB.REQUEST_TBL_TYPE;
769 	BEGIN
770     aPlsqlItem  :=  oe_inbound_int.SQL_TO_PL25(aSqlItem);
771 		RETURN aPlsqlItem;
772 	END SQL_TO_PL25;
773 
774 
775 PROCEDURE OE_ORDER_PUB$PROCESS_ORDER (
776       P_API_VERSION_NUMBER NUMBER,P_INIT_MSG_LIST VARCHAR2,
777       P_RETURN_VALUES VARCHAR2, P_ACTION_COMMIT VARCHAR2,
778       X_RETURN_STATUS OUT NOCOPY VARCHAR2,
779       X_MSG_COUNT OUT NOCOPY NUMBER,
780       X_MSG_DATA OUT NOCOPY VARCHAR2,
781       P_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
782       P_OLD_HEADER_REC OE_ORDER_PUB_HEADER_REC_TYPE,
783       P_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
784       P_OLD_HEADER_VAL_REC OE_ORDER_PUB_HEADER_VAL_REC_T,
785       P_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
786       P_OLD_HEADER_ADJ_TBL OE_ORDER_PUB_HEADER_ADJ_TBL_T,
787       P_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
788       P_OLD_HEADER_ADJ_VAL_TBL OE_ORDER_PUB_HEADER_ADJ_VAL_T,
789       P_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
790       P_OLD_HEADER_PRICE_ATT_TBL OE_ORDER_PUB_HEADER_PRICE_ATT,
791       P_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
792       P_OLD_HEADER_ADJ_ATT_TBL OE_ORDER_PUB_HEADER_ADJ_ATT_T,
793       P_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
794       P_OLD_HEADER_ADJ_ASSOC_TBL OE_ORDER_PUB_HEADER_ADJ_ASSOC,
795       P_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
796       P_OLD_HEADER_SCREDIT_TBL OE_ORDER_PUB_HEADER_SCREDIT_T,
797       P_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
798       P_OLD_HEADER_SCREDIT_VAL_TBL OE_ORDER_PUB_HEADER_SCREDIT_V,
799       P_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
800       P_OLD_HEADER_PAYMENT_TBL OE_ORDER_PUB_HEADER_PAYMENT_T,
801       P_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
802       P_OLD_HEADER_PAYMENT_VAL_TBL OE_ORDER_PUB_HEADER_PAYMENT_V,
803       P_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
804       P_OLD_LINE_TBL OE_ORDER_PUB_LINE_TBL_TYPE,
805       P_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
806       P_OLD_LINE_VAL_TBL OE_ORDER_PUB_LINE_VAL_TBL_TYP,
807       P_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
808       P_OLD_LINE_ADJ_TBL OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
809       P_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
810       P_OLD_LINE_ADJ_VAL_TBL OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
811       P_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
812       P_OLD_LINE_PRICE_ATT_TBL OE_ORDER_PUB_LINE_PRICE_ATT_T,
813       P_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
814       P_OLD_LINE_ADJ_ATT_TBL OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
815       P_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
816       P_OLD_LINE_ADJ_ASSOC_TBL OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
817       P_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
818       P_OLD_LINE_SCREDIT_TBL OE_ORDER_PUB_LINE_SCREDIT_TBL,
819       P_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
820       P_OLD_LINE_SCREDIT_VAL_TBL OE_ORDER_PUB_LINE_SCREDIT_VAL,
821       P_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
822       P_OLD_LINE_PAYMENT_TBL OE_ORDER_PUB_LINE_PAYMENT_TBL,
823       P_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
824       P_OLD_LINE_PAYMENT_VAL_TBL OE_ORDER_PUB_LINE_PAYMENT_VAL,
825       P_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
826       P_OLD_LOT_SERIAL_TBL OE_ORDER_PUB_LOT_SERIAL_TBL_T,
827       P_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
828       P_OLD_LOT_SERIAL_VAL_TBL OE_ORDER_PUB_LOT_SERIAL_VAL_T,
829       P_ACTION_REQUEST_TBL OE_ORDER_PUB_REQUEST_TBL_TYPE,
830       X_HEADER_REC OUT NOCOPY OE_ORDER_PUB_HEADER_REC_TYPE,
831       X_HEADER_VAL_REC OUT NOCOPY OE_ORDER_PUB_HEADER_VAL_REC_T,
832       X_HEADER_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_TBL_T,
833       X_HEADER_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_VAL_T,
834       X_HEADER_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PRICE_ATT,
835       X_HEADER_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ATT_T,
836       X_HEADER_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_ADJ_ASSOC,
837       X_HEADER_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_T,
838       X_HEADER_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_SCREDIT_V,
839       X_HEADER_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_T,
840       X_HEADER_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_HEADER_PAYMENT_V,
841       X_LINE_TBL OUT NOCOPY OE_ORDER_PUB_LINE_TBL_TYPE,
842       X_LINE_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_VAL_TBL_TYP,
843       X_LINE_ADJ_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_TBL_TYP,
844       X_LINE_ADJ_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_VAL_TBL,
845       X_LINE_PRICE_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PRICE_ATT_T,
846       X_LINE_ADJ_ATT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ATT_TBL,
847       X_LINE_ADJ_ASSOC_TBL OUT NOCOPY OE_ORDER_PUB_LINE_ADJ_ASSOC_T,
848       X_LINE_SCREDIT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_TBL,
849       X_LINE_SCREDIT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_SCREDIT_VAL,
850       X_LINE_PAYMENT_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_TBL,
851       X_LINE_PAYMENT_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LINE_PAYMENT_VAL,
852       X_LOT_SERIAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_TBL_T,
853       X_LOT_SERIAL_VAL_TBL OUT NOCOPY OE_ORDER_PUB_LOT_SERIAL_VAL_T,
854       X_ACTION_REQUEST_TBL OUT NOCOPY OE_ORDER_PUB_REQUEST_TBL_TYPE,
855       P_RTRIM_DATA VARCHAR2
856       )
857  IS
858  BEGIN
859 
860       oe_inbound_int.Process_Order (
861         P_API_VERSION_NUMBER,
862         P_INIT_MSG_LIST,
863         P_RETURN_VALUES,
864         P_ACTION_COMMIT,
865         X_RETURN_STATUS,
866         X_MSG_COUNT,
867         X_MSG_DATA,
868         P_HEADER_REC,
869         P_OLD_HEADER_REC,
870         P_HEADER_VAL_REC,
871         P_OLD_HEADER_VAL_REC,
872         P_HEADER_ADJ_TBL,
873         P_OLD_HEADER_ADJ_TBL,
874         P_HEADER_ADJ_VAL_TBL,
875         P_OLD_HEADER_ADJ_VAL_TBL,
876         P_HEADER_PRICE_ATT_TBL,
877         P_OLD_HEADER_PRICE_ATT_TBL,
878         P_HEADER_ADJ_ATT_TBL,
879         P_OLD_HEADER_ADJ_ATT_TBL,
880         P_HEADER_ADJ_ASSOC_TBL,
881         P_OLD_HEADER_ADJ_ASSOC_TBL,
882         P_HEADER_SCREDIT_TBL,
883         P_OLD_HEADER_SCREDIT_TBL,
884         P_HEADER_SCREDIT_VAL_TBL,
885         P_OLD_HEADER_SCREDIT_VAL_TBL,
886         P_HEADER_PAYMENT_TBL,
887         P_OLD_HEADER_PAYMENT_TBL,
888         P_HEADER_PAYMENT_VAL_TBL,
889         P_OLD_HEADER_PAYMENT_VAL_TBL,
890         P_LINE_TBL,
891         P_OLD_LINE_TBL,
892         P_LINE_VAL_TBL,
893         P_OLD_LINE_VAL_TBL,
894         P_LINE_ADJ_TBL,
895         P_OLD_LINE_ADJ_TBL,
896         P_LINE_ADJ_VAL_TBL,
897         P_OLD_LINE_ADJ_VAL_TBL,
898         P_LINE_PRICE_ATT_TBL,
899         P_OLD_LINE_PRICE_ATT_TBL,
900         P_LINE_ADJ_ATT_TBL,
901         P_OLD_LINE_ADJ_ATT_TBL,
902         P_LINE_ADJ_ASSOC_TBL,
903         P_OLD_LINE_ADJ_ASSOC_TBL,
904         P_LINE_SCREDIT_TBL,
905         P_OLD_LINE_SCREDIT_TBL,
906         P_LINE_SCREDIT_VAL_TBL,
907         P_OLD_LINE_SCREDIT_VAL_TBL,
908         P_LINE_PAYMENT_TBL,
909         P_OLD_LINE_PAYMENT_TBL,
910         P_LINE_PAYMENT_VAL_TBL,
911         P_OLD_LINE_PAYMENT_VAL_TBL,
912         P_LOT_SERIAL_TBL,
913         P_OLD_LOT_SERIAL_TBL,
914         P_LOT_SERIAL_VAL_TBL,
915         P_OLD_LOT_SERIAL_VAL_TBL,
916         P_ACTION_REQUEST_TBL,
917         X_HEADER_REC,
918         X_HEADER_VAL_REC,
919         X_HEADER_ADJ_TBL,
920         X_HEADER_ADJ_VAL_TBL,
921         X_HEADER_PRICE_ATT_TBL,
922         X_HEADER_ADJ_ATT_TBL,
923         X_HEADER_ADJ_ASSOC_TBL,
924         X_HEADER_SCREDIT_TBL,
925         X_HEADER_SCREDIT_VAL_TBL,
926         X_HEADER_PAYMENT_TBL,
927         X_HEADER_PAYMENT_VAL_TBL,
928         X_LINE_TBL,
929         X_LINE_VAL_TBL,
930         X_LINE_ADJ_TBL,
931         X_LINE_ADJ_VAL_TBL,
932         X_LINE_PRICE_ATT_TBL,
933         X_LINE_ADJ_ATT_TBL,
934         X_LINE_ADJ_ASSOC_TBL,
935         X_LINE_SCREDIT_TBL,
936         X_LINE_SCREDIT_VAL_TBL,
937         X_LINE_PAYMENT_TBL,
938         X_LINE_PAYMENT_VAL_TBL,
939         X_LOT_SERIAL_TBL ,
940         X_LOT_SERIAL_VAL_TBL,
941         X_ACTION_REQUEST_TBL ,
942         P_RTRIM_DATA
943   );
944 END OE_ORDER_PUB$PROCESS_ORDER;
945 
946 
947 PROCEDURE Convert_line_null_to_miss
948 ( p_x_line_rec   IN OUT NOCOPY  OE_Order_PUB.Line_Rec_Type)
949 IS
950 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
951 BEGIN
952   oe_debug_pub.add('Entering Convert_line_null_to_miss', 1);
953   oe_inbound_int.Convert_line_null_to_miss( p_x_line_rec);
954   oe_debug_pub.add('Exiting CONVERT_LINE_NULL_TO_MISS', 1);
955 EXCEPTION
956     WHEN OTHERS THEN
957     oe_debug_pub.add('In Others CONVERT_LINE_NULL_TO_MISS', 1);
958     RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959 END Convert_Line_null_to_miss;
960 
961 
962 PROCEDURE Convert_hdr_null_to_miss
963 (   p_x_header_rec IN OUT NOCOPY  OE_Order_PUB.Header_Rec_Type)
964 IS
965 BEGIN
966     oe_debug_pub.add('Entering CONVERT_HDR_NULL_TO_MISS', 1);
967     oe_inbound_int.Convert_hdr_null_to_miss(p_x_header_rec);
968     oe_debug_pub.add('Exiting CONVERTHDR__NULL_TO_MISS', 1);
969 EXCEPTION
970     WHEN OTHERS THEN
971     oe_debug_pub.add('In Others Convert_hdr_null_to_miss', 1);
972     RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973 END Convert_hdr_null_to_miss;
974 
975 END XX_BPEL_CALLPROCESSORDEREBS11I;