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.

APPS.XX_BPEL_CALLPROCESSORDEREBS11I dependencies on OE_INBOUND_INT

Line 8: aSqlItem := oe_inbound_int.PL_TO_SQL1(aPlsqlItem);

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)

Line 16: aPlsqlItem := oe_inbound_int.SQL_TO_PL1(aSqlItem);

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)

Line 24: aSqlItem := oe_inbound_int.PL_TO_SQL2(aPlsqlItem);

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)

Line 32: aPlsqlItem := oe_inbound_int.SQL_TO_PL2(aSqlItem);

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)

Line 40: aSqlItem := oe_inbound_int.PL_TO_SQL26(aPlsqlItem);

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)

Line 48: aPlsqlItem := oe_inbound_int.SQL_TO_PL26(aSqlItem);

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)

Line 56: aSqlItem := oe_inbound_int.PL_TO_SQL3(aPlsqlItem);

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)

Line 64: aPlsqlItem := oe_inbound_int.SQL_TO_PL3(aSqlItem);

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)

Line 72: aSqlItem := oe_inbound_int.PL_TO_SQL27(aPlsqlItem);

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)

Line 80: aPlsqlItem := oe_inbound_int.SQL_TO_PL27(aSqlItem);

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)

Line 88: aSqlItem := oe_inbound_int.PL_TO_SQL4(aPlsqlItem);

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)

Line 96: aPlsqlItem := oe_inbound_int.SQL_TO_PL4(aSqlItem);

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)

Line 104: aSqlItem := oe_inbound_int.PL_TO_SQL28(aPlsqlItem);

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)

Line 112: aPlsqlItem := oe_inbound_int.SQL_TO_PL28(aSqlItem);

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)

Line 120: aSqlItem := oe_inbound_int.PL_TO_SQL5(aPlsqlItem);

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)

Line 128: aPlsqlItem := oe_inbound_int.SQL_TO_PL5(aSqlItem);

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)

Line 136: aSqlItem := oe_inbound_int.PL_TO_SQL29(aPlsqlItem);

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)

Line 144: aPlsqlItem := oe_inbound_int.SQL_TO_PL29(aSqlItem);

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)

Line 152: aSqlItem := oe_inbound_int.PL_TO_SQL6(aPlsqlItem);

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)

Line 160: aPlsqlItem := oe_inbound_int.SQL_TO_PL6(aSqlItem);

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)

Line 168: aSqlItem := oe_inbound_int.PL_TO_SQL30(aPlsqlItem);

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)

Line 176: aPlsqlItem := oe_inbound_int.SQL_TO_PL30(aSqlItem);

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)

Line 184: aSqlItem := oe_inbound_int.PL_TO_SQL7(aPlsqlItem);

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)

Line 192: aPlsqlItem := oe_inbound_int. SQL_TO_PL7(aSqlItem);

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)

Line 200: aSqlItem := oe_inbound_int.PL_TO_SQL31(aPlsqlItem);

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)

Line 208: aPlsqlItem := oe_inbound_int.SQL_TO_PL31(aSqlItem);

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)

Line 216: aSqlItem := oe_inbound_int.PL_TO_SQL8(aPlsqlItem);

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)

Line 224: aPlsqlItem := oe_inbound_int.SQL_TO_PL8(aSqlItem);

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)

Line 232: aSqlItem := oe_inbound_int.PL_TO_SQL32(aPlsqlItem);

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)

Line 240: aPlsqlItem := oe_inbound_int.SQL_TO_PL32(aSqlItem);

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)

Line 248: aSqlItem := oe_inbound_int.PL_TO_SQL9(aPlsqlItem);

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)

Line 256: aPlsqlItem := oe_inbound_int.SQL_TO_PL9(aSqlItem);

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)

Line 264: aSqlItem := oe_inbound_int.PL_TO_SQL33(aPlsqlItem);

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)

Line 272: aPlsqlItem := oe_inbound_int.SQL_TO_PL33(aSqlItem);

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)

Line 280: aSqlItem := oe_inbound_int.PL_TO_SQL10(aPlsqlItem);

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)

Line 288: aPlsqlItem := oe_inbound_int.SQL_TO_PL10(aSqlItem);

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)

Line 296: aSqlItem := oe_inbound_int.PL_TO_SQL34(aPlsqlItem);

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)

Line 304: aPlsqlItem := oe_inbound_int.SQL_TO_PL34(aSqlItem);

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)

Line 312: aSqlItem := oe_inbound_int.PL_TO_SQL11(aPlsqlItem);

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)

Line 320: aPlsqlItem := oe_inbound_int.SQL_TO_PL11(aSqlItem);

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)

Line 328: aSqlItem := oe_inbound_int.PL_TO_SQL35(aPlsqlItem);

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)

Line 336: aPlsqlItem := oe_inbound_int.SQL_TO_PL35(aSqlItem);

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)

Line 344: aSqlItem := oe_inbound_int.PL_TO_SQL12(aPlsqlItem);

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)

Line 352: aPlsqlItem := oe_inbound_int.SQL_TO_PL12(aSqlItem);

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)

Line 360: aSqlItem := oe_inbound_int.PL_TO_SQL36(aPlsqlItem);

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)

Line 368: aPlsqlItem := oe_inbound_int.SQL_TO_PL36(aSqlItem);

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)

Line 376: aSqlItem := oe_inbound_int.PL_TO_SQL13(aPlsqlItem);

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)

Line 384: aPlsqlItem := oe_inbound_int.SQL_TO_PL13(aSqlItem);

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)

Line 392: aSqlItem := oe_inbound_int.PL_TO_SQL37(aPlsqlItem);

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)

Line 400: aPlsqlItem := oe_inbound_int.SQL_TO_PL37(aSqlItem);

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)

Line 408: aSqlItem := oe_inbound_int.PL_TO_SQL14(aPlsqlItem);

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)

Line 416: aPlsqlItem := oe_inbound_int.SQL_TO_PL14(aSqlItem);

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);
417: RETURN aPlsqlItem;
418: END SQL_TO_PL14;
419:
420: FUNCTION PL_TO_SQL38(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE)

Line 424: aSqlItem := oe_inbound_int.PL_TO_SQL38(aPlsqlItem);

420: FUNCTION PL_TO_SQL38(aPlsqlItem OE_ORDER_PUB.LINE_ADJ_VAL_REC_TYPE)
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)

Line 432: aPlsqlItem := oe_inbound_int.SQL_TO_PL38(aSqlItem);

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)

Line 440: aSqlItem := oe_inbound_int.PL_TO_SQL15(aPlsqlItem);

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)

Line 448: aPlsqlItem := oe_inbound_int.SQL_TO_PL15(aSqlItem);

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)

Line 456: aSqlItem := oe_inbound_int.PL_TO_SQL39(aPlsqlItem);

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)

Line 464: aPlsqlItem := oe_inbound_int.SQL_TO_PL39(aSqlItem);

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)

Line 472: aSqlItem := oe_inbound_int.PL_TO_SQL16(aPlsqlItem);

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)

Line 480: aPlsqlItem := oe_inbound_int.SQL_TO_PL16(aSqlItem);

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)

Line 488: aSqlItem := oe_inbound_int.PL_TO_SQL40(aPlsqlItem);

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)

Line 496: aPlsqlItem := oe_inbound_int.SQL_TO_PL40(aSqlItem);

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)

Line 504: aSqlItem := oe_inbound_int.PL_TO_SQL17(aPlsqlItem);

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)

Line 512: aPlsqlItem := oe_inbound_int.SQL_TO_PL17(aSqlItem);

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)

Line 520: aSqlItem := oe_inbound_int.PL_TO_SQL41(aPlsqlItem);

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)

Line 528: aPlsqlItem := oe_inbound_int.SQL_TO_PL41(aSqlItem);

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)

Line 536: aSqlItem := oe_inbound_int.PL_TO_SQL18(aPlsqlItem);

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)

Line 544: aPlsqlItem := oe_inbound_int.SQL_TO_PL18(aSqlItem);

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)

Line 552: aSqlItem := oe_inbound_int.PL_TO_SQL42(aPlsqlItem);

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)

Line 560: aPlsqlItem := oe_inbound_int.SQL_TO_PL42(aSqlItem);

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)

Line 568: aSqlItem := oe_inbound_int.PL_TO_SQL19(aPlsqlItem);

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;
571:
572: FUNCTION SQL_TO_PL19(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL)

Line 576: aPlsqlItem := oe_inbound_int.SQL_TO_PL19(aSqlItem);

572: FUNCTION SQL_TO_PL19(aSqlItem OE_ORDER_PUB_LINE_SCREDIT_TBL)
573: RETURN OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE IS
574: aPlsqlItem OE_ORDER_PUB.LINE_SCREDIT_TBL_TYPE;
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)

Line 584: aSqlItem := oe_inbound_int.PL_TO_SQL43(aPlsqlItem);

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)

Line 592: aPlsqlItem := oe_inbound_int.SQL_TO_PL43(aSqlItem);

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)

Line 600: aSqlItem := oe_inbound_int.PL_TO_SQL20(aPlsqlItem);

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)

Line 608: aPlsqlItem := oe_inbound_int.SQL_TO_PL20(aSqlItem);

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)

Line 616: aSqlItem := oe_inbound_int.PL_TO_SQL44(aPlsqlItem);

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)

Line 624: aPlsqlItem := oe_inbound_int.SQL_TO_PL44(aSqlItem);

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:

Line 633: aSqlItem := oe_inbound_int.PL_TO_SQL21(aPlsqlItem);

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)

Line 641: aPlsqlItem := oe_inbound_int.SQL_TO_PL21(aSqlItem);

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)

Line 649: aSqlItem := oe_inbound_int.PL_TO_SQL45(aPlsqlItem);

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)

Line 657: aPlsqlItem := oe_inbound_int.SQL_TO_PL45(aSqlItem);

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)

Line 665: aSqlItem := oe_inbound_int.PL_TO_SQL22(aPlsqlItem);

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:

Line 674: aPlsqlItem := oe_inbound_int.SQL_TO_PL22(aSqlItem);

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)

Line 682: aSqlItem := oe_inbound_int.PL_TO_SQL46(aPlsqlItem);

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)

Line 690: aPlsqlItem := oe_inbound_int.SQL_TO_PL46(aSqlItem);

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)

Line 698: aSqlItem := oe_inbound_int.PL_TO_SQL23(aPlsqlItem);

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)

Line 706: aPlsqlItem := oe_inbound_int.SQL_TO_PL23(aSqlItem);

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)

Line 714: aSqlItem := oe_inbound_int.PL_TO_SQL47(aPlsqlItem);

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)

Line 722: aPlsqlItem := oe_inbound_int.SQL_TO_PL47(aSqlItem);

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:
726: FUNCTION PL_TO_SQL24(aPlsqlItem OE_ORDER_PUB.LOT_SERIAL_VAL_TBL_TYPE)

Line 730: aSqlItem := oe_inbound_int.PL_TO_SQL24(aPlsqlItem);

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;
729: BEGIN
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)

Line 738: aPlsqlItem := oe_inbound_int.SQL_TO_PL24(aSqlItem);

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)

Line 746: aSqlItem := oe_inbound_int.PL_TO_SQL48(aPlsqlItem);

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)

Line 754: aPlsqlItem := oe_inbound_int.SQL_TO_PL48(aSqlItem);

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)

Line 762: aSqlItem := oe_inbound_int.PL_TO_SQL25(aPlsqlItem);

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)

Line 770: aPlsqlItem := oe_inbound_int.SQL_TO_PL25(aSqlItem);

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:

Line 860: oe_inbound_int.Process_Order (

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,

Line 953: oe_inbound_int.Convert_line_null_to_miss( p_x_line_rec);

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);

Line 967: oe_inbound_int.Convert_hdr_null_to_miss(p_x_header_rec);

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);