[Home] [Help]
PACKAGE BODY: APPS.OE_OUTBOUND_INT
Source
1 PACKAGE BODY Oe_Outbound_Int AS
2 /* $Header: OEXOEOBB.pls 120.4 2011/04/25 07:04:08 snimmaga ship $ */
3
4 FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
5 RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS
6 aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;
7 BEGIN
8 -- initialize the object
9 aSqlItem := OE_ACKNOWLEDGMENT_PUB_HEADER_(NULL, NULL, NULL, NULL, NULL,
10 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
11 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
12 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
13 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
14 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
15 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
16 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
17 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
18 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
19 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
20 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
21 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
22 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
23 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
24 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
25 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
26 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
27 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
28 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
29 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
30 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
31 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
32 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
33 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
34 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
35 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
36
37 aSqlItem.IB_OWNER_CODE := aPlsqlItem.IB_OWNER_CODE;
38 aSqlItem.IB_CURRENT_LOCATION_CODE := aPlsqlItem.IB_CURRENT_LOCATION_CODE;
39 aSqlItem.IB_INSTALLED_AT_LOCATION_CODE := aPlsqlItem.IB_INSTALLED_AT_LOCATION_CODE;
40 aSqlItem.INVOICE_CUSTOMER_ID := aPlsqlItem.INVOICE_CUSTOMER_ID;
41 aSqlItem.DELIVER_TO_CUSTOMER_ID := aPlsqlItem.DELIVER_TO_CUSTOMER_ID;
42 aSqlItem.ACCOUNTING_RULE_DURATION := aPlsqlItem.ACCOUNTING_RULE_DURATION;
43 aSqlItem.ATTRIBUTE16 := aPlsqlItem.ATTRIBUTE16;
44 aSqlItem.ATTRIBUTE17 := aPlsqlItem.ATTRIBUTE17;
45 aSqlItem.ATTRIBUTE18 := aPlsqlItem.ATTRIBUTE18;
46 aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
47 aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
48 aSqlItem.ACKNOWLEDGMENT_TYPE := aPlsqlItem.ACKNOWLEDGMENT_TYPE;
49 aSqlItem.BLANKET_NUMBER := aPlsqlItem.BLANKET_NUMBER;
50 aSqlItem.BOOKED_DATE := aPlsqlItem.BOOKED_DATE;
51 aSqlItem.FLOW_STATUS_CODE := aPlsqlItem.FLOW_STATUS_CODE;
52 aSqlItem.CREDIT_CARD_APPROVAL_DATE := aPlsqlItem.CREDIT_CARD_APPROVAL_DATE;
53 aSqlItem.PAYMENT_TYPE_CODE := aPlsqlItem.PAYMENT_TYPE_CODE;
54 aSqlItem.PAYMENT_AMOUNT := aPlsqlItem.PAYMENT_AMOUNT;
55 aSqlItem.CHECK_NUMBER := aPlsqlItem.CHECK_NUMBER;
56 aSqlItem.CREDIT_CARD_CODE := aPlsqlItem.CREDIT_CARD_CODE;
57 aSqlItem.CREDIT_CARD_HOLDER_NAME := aPlsqlItem.CREDIT_CARD_HOLDER_NAME;
58 aSqlItem.CREDIT_CARD_NUMBER := aPlsqlItem.CREDIT_CARD_NUMBER;
59 aSqlItem.CREDIT_CARD_EXPIRATION_DATE := aPlsqlItem.CREDIT_CARD_EXPIRATION_DATE;
60 aSqlItem.CREDIT_CARD_APPROVAL_CODE := aPlsqlItem.CREDIT_CARD_APPROVAL_CODE;
61 aSqlItem.CUSTOMER_PREFERENCE_SET_CODE := aPlsqlItem.CUSTOMER_PREFERENCE_SET_CODE;
62 aSqlItem.SALES_CHANNEL_CODE := aPlsqlItem.SALES_CHANNEL_CODE;
63 aSqlItem.SOLD_TO_PHONE_ID := aPlsqlItem.SOLD_TO_PHONE_ID;
64 aSqlItem.SHIP_TO_PROVINCE := aPlsqlItem.SHIP_TO_PROVINCE;
65 aSqlItem.SHIP_TO_SITE_INT := aPlsqlItem.SHIP_TO_SITE_INT;
66 aSqlItem.SHIP_TO_STATE := aPlsqlItem.SHIP_TO_STATE;
67 aSqlItem.SHIP_TOLERANCE_ABOVE := aPlsqlItem.SHIP_TOLERANCE_ABOVE;
68 aSqlItem.SHIP_TOLERANCE_BELOW := aPlsqlItem.SHIP_TOLERANCE_BELOW;
69 aSqlItem.SHIPMENT_PRIORITY := aPlsqlItem.SHIPMENT_PRIORITY;
70 aSqlItem.SHIPMENT_PRIORITY_CODE := aPlsqlItem.SHIPMENT_PRIORITY_CODE;
71 aSqlItem.SHIPMENT_PRIORITY_CODE_INT := aPlsqlItem.SHIPMENT_PRIORITY_CODE_INT;
72 aSqlItem.SHIPPING_INSTRUCTIONS := aPlsqlItem.SHIPPING_INSTRUCTIONS;
73 aSqlItem.SHIPPING_METHOD := aPlsqlItem.SHIPPING_METHOD;
74 aSqlItem.SHIPPING_METHOD_CODE := aPlsqlItem.SHIPPING_METHOD_CODE;
75 aSqlItem.SOLD_TO_CONTACT := aPlsqlItem.SOLD_TO_CONTACT;
76 aSqlItem.SOLD_TO_CONTACT_ID := aPlsqlItem.SOLD_TO_CONTACT_ID;
77 aSqlItem.SOURCE_DOCUMENT_ID := aPlsqlItem.SOURCE_DOCUMENT_ID;
78 aSqlItem.SOURCE_DOCUMENT_TYPE_ID := aPlsqlItem.SOURCE_DOCUMENT_TYPE_ID;
79 aSqlItem.SUBMISSION_DATETIME := aPlsqlItem.SUBMISSION_DATETIME;
80 aSqlItem.TAX_EXEMPT_FLAG := aPlsqlItem.TAX_EXEMPT_FLAG;
81 aSqlItem.TAX_EXEMPT_NUMBER := aPlsqlItem.TAX_EXEMPT_NUMBER;
82 aSqlItem.TAX_EXEMPT_REASON := aPlsqlItem.TAX_EXEMPT_REASON;
83 aSqlItem.TAX_EXEMPT_REASON_CODE := aPlsqlItem.TAX_EXEMPT_REASON_CODE;
84 aSqlItem.TAX_POINT := aPlsqlItem.TAX_POINT;
85 aSqlItem.TAX_POINT_CODE := aPlsqlItem.TAX_POINT_CODE;
86 aSqlItem.TRANSACTIONAL_CURR := aPlsqlItem.TRANSACTIONAL_CURR;
87 aSqlItem.TRANSACTIONAL_CURR_CODE := aPlsqlItem.TRANSACTIONAL_CURR_CODE;
88 aSqlItem.VERSION_NUMBER := aPlsqlItem.VERSION_NUMBER;
89 aSqlItem.CUSTOMER_PAYMENT_TERM_ID := aPlsqlItem.CUSTOMER_PAYMENT_TERM_ID;
90 aSqlItem.DROP_SHIP_FLAG := aPlsqlItem.DROP_SHIP_FLAG;
91 aSqlItem.ORDER_CATEGORY_CODE := aPlsqlItem.ORDER_CATEGORY_CODE;
92 aSqlItem.SOLD_TO_ADDRESS1 := aPlsqlItem.SOLD_TO_ADDRESS1;
93 aSqlItem.SOLD_TO_ADDRESS2 := aPlsqlItem.SOLD_TO_ADDRESS2;
94 aSqlItem.SOLD_TO_ADDRESS3 := aPlsqlItem.SOLD_TO_ADDRESS3;
95 aSqlItem.SOLD_TO_ADDRESS4 := aPlsqlItem.SOLD_TO_ADDRESS4;
96 aSqlItem.SOLD_TO_CITY := aPlsqlItem.SOLD_TO_CITY;
97 aSqlItem.SOLD_TO_POSTAL_CODE := aPlsqlItem.SOLD_TO_POSTAL_CODE;
98 aSqlItem.SOLD_TO_COUNTRY := aPlsqlItem.SOLD_TO_COUNTRY;
99 aSqlItem.SOLD_TO_STATE := aPlsqlItem.SOLD_TO_STATE;
100 aSqlItem.SOLD_TO_COUNTY := aPlsqlItem.SOLD_TO_COUNTY;
101 aSqlItem.SOLD_TO_PROVINCE := aPlsqlItem.SOLD_TO_PROVINCE;
102 aSqlItem.SOLD_TO_CONTACT_LAST_NAME := aPlsqlItem.SOLD_TO_CONTACT_LAST_NAME;
103 aSqlItem.SOLD_TO_CONTACT_FIRST_NAME := aPlsqlItem.SOLD_TO_CONTACT_FIRST_NAME;
104 aSqlItem.SHIP_TO_EDI_LOCATION_CODE := aPlsqlItem.SHIP_TO_EDI_LOCATION_CODE;
105 aSqlItem.SOLD_TO_EDI_LOCATION_CODE := aPlsqlItem.SOLD_TO_EDI_LOCATION_CODE;
106 aSqlItem.BILL_TO_EDI_LOCATION_CODE := aPlsqlItem.BILL_TO_EDI_LOCATION_CODE;
107 aSqlItem.CUSTOMER_PAYMENT_TERM := aPlsqlItem.CUSTOMER_PAYMENT_TERM;
108 aSqlItem.SHIP_FROM_ADDRESS_1 := aPlsqlItem.SHIP_FROM_ADDRESS_1;
109 aSqlItem.SHIP_FROM_ADDRESS_2 := aPlsqlItem.SHIP_FROM_ADDRESS_2;
110 aSqlItem.SHIP_FROM_ADDRESS_3 := aPlsqlItem.SHIP_FROM_ADDRESS_3;
111 aSqlItem.SHIP_FROM_CITY := aPlsqlItem.SHIP_FROM_CITY;
112 aSqlItem.SHIP_FROM_POSTAL_CODE := aPlsqlItem.SHIP_FROM_POSTAL_CODE;
113 aSqlItem.SHIP_FROM_COUNTRY := aPlsqlItem.SHIP_FROM_COUNTRY;
114 aSqlItem.SHIP_FROM_EDI_LOCATION_CODE := aPlsqlItem.SHIP_FROM_EDI_LOCATION_CODE;
115 aSqlItem.SHIP_FROM_REGION1 := aPlsqlItem.SHIP_FROM_REGION1;
116 aSqlItem.SHIP_FROM_REGION2 := aPlsqlItem.SHIP_FROM_REGION2;
117 aSqlItem.SHIP_FROM_REGION3 := aPlsqlItem.SHIP_FROM_REGION3;
118 aSqlItem.SHIP_FROM_ADDRESS_ID := aPlsqlItem.SHIP_FROM_ADDRESS_ID;
119 aSqlItem.SOLD_TO_ADDRESS_ID := aPlsqlItem.SOLD_TO_ADDRESS_ID;
120 aSqlItem.SHIP_TO_ADDRESS_ID := aPlsqlItem.SHIP_TO_ADDRESS_ID;
121 aSqlItem.INVOICE_ADDRESS_ID := aPlsqlItem.INVOICE_ADDRESS_ID;
122 aSqlItem.SHIP_TO_ADDRESS_CODE := aPlsqlItem.SHIP_TO_ADDRESS_CODE;
123 aSqlItem.TP_CONTEXT := aPlsqlItem.TP_CONTEXT;
124 aSqlItem.TP_ATTRIBUTE1 := aPlsqlItem.TP_ATTRIBUTE1;
125 aSqlItem.TP_ATTRIBUTE2 := aPlsqlItem.TP_ATTRIBUTE2;
126 aSqlItem.TP_ATTRIBUTE3 := aPlsqlItem.TP_ATTRIBUTE3;
127 aSqlItem.TP_ATTRIBUTE4 := aPlsqlItem.TP_ATTRIBUTE4;
128 aSqlItem.TP_ATTRIBUTE5 := aPlsqlItem.TP_ATTRIBUTE5;
129 aSqlItem.TP_ATTRIBUTE6 := aPlsqlItem.TP_ATTRIBUTE6;
130 aSqlItem.TP_ATTRIBUTE7 := aPlsqlItem.TP_ATTRIBUTE7;
131 aSqlItem.TP_ATTRIBUTE8 := aPlsqlItem.TP_ATTRIBUTE8;
132 aSqlItem.TP_ATTRIBUTE9 := aPlsqlItem.TP_ATTRIBUTE9;
133 aSqlItem.TP_ATTRIBUTE10 := aPlsqlItem.TP_ATTRIBUTE10;
134 aSqlItem.TP_ATTRIBUTE11 := aPlsqlItem.TP_ATTRIBUTE11;
135 aSqlItem.TP_ATTRIBUTE12 := aPlsqlItem.TP_ATTRIBUTE12;
136 aSqlItem.TP_ATTRIBUTE13 := aPlsqlItem.TP_ATTRIBUTE13;
137 aSqlItem.TP_ATTRIBUTE14 := aPlsqlItem.TP_ATTRIBUTE14;
138 aSqlItem.TP_ATTRIBUTE15 := aPlsqlItem.TP_ATTRIBUTE15;
139 aSqlItem.XML_MESSAGE_ID := aPlsqlItem.XML_MESSAGE_ID;
140 aSqlItem.SHIP_TO_CUSTOMER_ID := aPlsqlItem.SHIP_TO_CUSTOMER_ID;
141 aSqlItem.ORDER_FIRMED_DATE := aPlsqlItem.ORDER_FIRMED_DATE;
142 aSqlItem.DELIVER_TO_ADDRESS1 := aPlsqlItem.DELIVER_TO_ADDRESS1;
143 aSqlItem.DELIVER_TO_ADDRESS2 := aPlsqlItem.DELIVER_TO_ADDRESS2;
144 aSqlItem.DELIVER_TO_ADDRESS3 := aPlsqlItem.DELIVER_TO_ADDRESS3;
145 aSqlItem.DELIVER_TO_ADDRESS4 := aPlsqlItem.DELIVER_TO_ADDRESS4;
146 aSqlItem.DELIVER_TO_CITY := aPlsqlItem.DELIVER_TO_CITY;
147 aSqlItem.DELIVER_TO_COUNTRY := aPlsqlItem.DELIVER_TO_COUNTRY;
148 aSqlItem.DELIVER_TO_COUNTY := aPlsqlItem.DELIVER_TO_COUNTY;
149 aSqlItem.DELIVER_TO_POSTAL_CODE := aPlsqlItem.DELIVER_TO_POSTAL_CODE;
150 aSqlItem.DELIVER_TO_PROVINCE := aPlsqlItem.DELIVER_TO_PROVINCE;
151 aSqlItem.TRANSACTION_PHASE_CODE := aPlsqlItem.TRANSACTION_PHASE_CODE;
152 aSqlItem.SALES_DOCUMENT_NAME := aPlsqlItem.SALES_DOCUMENT_NAME;
153 aSqlItem.QUOTE_NUMBER := aPlsqlItem.QUOTE_NUMBER;
154 aSqlItem.QUOTE_DATE := aPlsqlItem.QUOTE_DATE;
155 aSqlItem.USER_STATUS_CODE := aPlsqlItem.USER_STATUS_CODE;
156 aSqlItem.SOLD_TO_SITE_USE_ID := aPlsqlItem.SOLD_TO_SITE_USE_ID;
157 aSqlItem.SUPPLIER_SIGNATURE := aPlsqlItem.SUPPLIER_SIGNATURE;
158 aSqlItem.SUPPLIER_SIGNATURE_DATE := aPlsqlItem.SUPPLIER_SIGNATURE_DATE;
159 aSqlItem.CUSTOMER_SIGNATURE := aPlsqlItem.CUSTOMER_SIGNATURE;
160 aSqlItem.CUSTOMER_SIGNATURE_DATE := aPlsqlItem.CUSTOMER_SIGNATURE_DATE;
161 aSqlItem.SOLD_TO_PARTY_NUMBER := aPlsqlItem.SOLD_TO_PARTY_NUMBER;
162 aSqlItem.SHIP_TO_PARTY_NUMBER := aPlsqlItem.SHIP_TO_PARTY_NUMBER;
163 aSqlItem.INVOICE_TO_PARTY_NUMBER := aPlsqlItem.INVOICE_TO_PARTY_NUMBER;
164 aSqlItem.DELIVER_TO_PARTY_NUMBER := aPlsqlItem.DELIVER_TO_PARTY_NUMBER;
165 aSqlItem.END_CUSTOMER_NUMBER := aPlsqlItem.END_CUSTOMER_NUMBER;
166 aSqlItem.END_CUSTOMER_PARTY_NUMBER := aPlsqlItem.END_CUSTOMER_PARTY_NUMBER;
167 aSqlItem.END_CUSTOMER_ID := aPlsqlItem.END_CUSTOMER_ID;
168 aSqlItem.END_CUSTOMER_CONTACT_ID := aPlsqlItem.END_CUSTOMER_CONTACT_ID;
169 aSqlItem.END_CUSTOMER_SITE_USE_ID := aPlsqlItem.END_CUSTOMER_SITE_USE_ID;
170 aSqlItem.END_CUSTOMER_ADDRESS1 := aPlsqlItem.END_CUSTOMER_ADDRESS1;
171 aSqlItem.END_CUSTOMER_ADDRESS2 := aPlsqlItem.END_CUSTOMER_ADDRESS2;
172 aSqlItem.END_CUSTOMER_ADDRESS3 := aPlsqlItem.END_CUSTOMER_ADDRESS3;
173 aSqlItem.END_CUSTOMER_ADDRESS4 := aPlsqlItem.END_CUSTOMER_ADDRESS4;
174 aSqlItem.END_CUSTOMER_CITY := aPlsqlItem.END_CUSTOMER_CITY;
175 aSqlItem.END_CUSTOMER_POSTAL_CODE := aPlsqlItem.END_CUSTOMER_POSTAL_CODE;
176 aSqlItem.END_CUSTOMER_COUNTRY := aPlsqlItem.END_CUSTOMER_COUNTRY;
177 aSqlItem.END_CUSTOMER_STATE := aPlsqlItem.END_CUSTOMER_STATE;
178 aSqlItem.END_CUSTOMER_COUNTY := aPlsqlItem.END_CUSTOMER_COUNTY;
179 aSqlItem.END_CUSTOMER_PROVINCE := aPlsqlItem.END_CUSTOMER_PROVINCE;
180 aSqlItem.END_CUSTOMER_CONTACT := aPlsqlItem.END_CUSTOMER_CONTACT;
181 aSqlItem.END_CUSTOMER_CONTACT_LAST_NAME := aPlsqlItem.END_CUSTOMER_CONTACT_LAST_NAME;
182 aSqlItem.END_CUSTOMER_CONTACT_FIRST_NAM := aPlsqlItem.END_CUSTOMER_CONTACT_FIRST_NAM;
183 aSqlItem.END_CUSTOMER_NAME := aPlsqlItem.END_CUSTOMER_NAME;
184 aSqlItem.IB_OWNER := aPlsqlItem.IB_OWNER;
185 aSqlItem.IB_CURRENT_LOCATION := aPlsqlItem.IB_CURRENT_LOCATION;
186 aSqlItem.IB_INSTALLED_AT_LOCATION := aPlsqlItem.IB_INSTALLED_AT_LOCATION;
187 aSqlItem.SOLD_TO_LOCATION_ADDRESS1 := aPlsqlItem.SOLD_TO_LOCATION_ADDRESS1;
188 aSqlItem.SOLD_TO_LOCATION_ADDRESS2 := aPlsqlItem.SOLD_TO_LOCATION_ADDRESS2;
189 aSqlItem.SOLD_TO_LOCATION_ADDRESS3 := aPlsqlItem.SOLD_TO_LOCATION_ADDRESS3;
190 aSqlItem.SOLD_TO_LOCATION_ADDRESS4 := aPlsqlItem.SOLD_TO_LOCATION_ADDRESS4;
191 aSqlItem.SOLD_TO_LOCATION_CITY := aPlsqlItem.SOLD_TO_LOCATION_CITY;
192 aSqlItem.SOLD_TO_LOCATION_POSTAL_CODE := aPlsqlItem.SOLD_TO_LOCATION_POSTAL_CODE;
193 aSqlItem.SOLD_TO_LOCATION_COUNTRY := aPlsqlItem.SOLD_TO_LOCATION_COUNTRY;
194 aSqlItem.GLOBAL_ATTRIBUTE12 := aPlsqlItem.GLOBAL_ATTRIBUTE12;
195 aSqlItem.GLOBAL_ATTRIBUTE13 := aPlsqlItem.GLOBAL_ATTRIBUTE13;
196 aSqlItem.GLOBAL_ATTRIBUTE14 := aPlsqlItem.GLOBAL_ATTRIBUTE14;
197 aSqlItem.GLOBAL_ATTRIBUTE15 := aPlsqlItem.GLOBAL_ATTRIBUTE15;
198 aSqlItem.GLOBAL_ATTRIBUTE16 := aPlsqlItem.GLOBAL_ATTRIBUTE16;
199 aSqlItem.GLOBAL_ATTRIBUTE17 := aPlsqlItem.GLOBAL_ATTRIBUTE17;
200 aSqlItem.GLOBAL_ATTRIBUTE18 := aPlsqlItem.GLOBAL_ATTRIBUTE18;
201 aSqlItem.GLOBAL_ATTRIBUTE19 := aPlsqlItem.GLOBAL_ATTRIBUTE19;
202 aSqlItem.GLOBAL_ATTRIBUTE20 := aPlsqlItem.GLOBAL_ATTRIBUTE20;
203 aSqlItem.HEADER_PO_CONTEXT := aPlsqlItem.HEADER_PO_CONTEXT;
204 aSqlItem.INTERFACE_STATUS := aPlsqlItem.INTERFACE_STATUS;
205 aSqlItem.INVOICE_ADDRESS_1 := aPlsqlItem.INVOICE_ADDRESS_1;
206 aSqlItem.INVOICE_ADDRESS_2 := aPlsqlItem.INVOICE_ADDRESS_2;
207 aSqlItem.INVOICE_ADDRESS_3 := aPlsqlItem.INVOICE_ADDRESS_3;
208 aSqlItem.INVOICE_ADDRESS_4 := aPlsqlItem.INVOICE_ADDRESS_4;
209 aSqlItem.INVOICE_CITY := aPlsqlItem.INVOICE_CITY;
210 aSqlItem.INVOICE_COUNTRY := aPlsqlItem.INVOICE_COUNTRY;
211 aSqlItem.INVOICE_COUNTY := aPlsqlItem.INVOICE_COUNTY;
212 aSqlItem.INVOICE_CUSTOMER := aPlsqlItem.INVOICE_CUSTOMER;
213 aSqlItem.INVOICE_CUSTOMER_NUMBER := aPlsqlItem.INVOICE_CUSTOMER_NUMBER;
214 aSqlItem.INVOICE_POSTAL_CODE := aPlsqlItem.INVOICE_POSTAL_CODE;
215 aSqlItem.INVOICE_PROVINCE_INT := aPlsqlItem.INVOICE_PROVINCE_INT;
216 aSqlItem.INVOICE_SITE := aPlsqlItem.INVOICE_SITE;
217 aSqlItem.INVOICE_SITE_CODE := aPlsqlItem.INVOICE_SITE_CODE;
218 aSqlItem.INVOICE_STATE := aPlsqlItem.INVOICE_STATE;
219 aSqlItem.INVOICE_TO_CONTACT := aPlsqlItem.INVOICE_TO_CONTACT;
220 aSqlItem.INVOICE_TO_CONTACT_FIRST_NAME := aPlsqlItem.INVOICE_TO_CONTACT_FIRST_NAME;
221 aSqlItem.INVOICE_TO_CONTACT_ID := aPlsqlItem.INVOICE_TO_CONTACT_ID;
222 aSqlItem.INVOICE_TO_CONTACT_LAST_NAME := aPlsqlItem.INVOICE_TO_CONTACT_LAST_NAME;
223 aSqlItem.INVOICE_TO_ORG := aPlsqlItem.INVOICE_TO_ORG;
224 aSqlItem.INVOICE_TO_ORG_ID := aPlsqlItem.INVOICE_TO_ORG_ID;
225 aSqlItem.INVOICE_TOLERANCE_ABOVE := aPlsqlItem.INVOICE_TOLERANCE_ABOVE;
226 aSqlItem.INVOICE_TOLERANCE_BELOW := aPlsqlItem.INVOICE_TOLERANCE_BELOW;
227 aSqlItem.INVOICING_RULE := aPlsqlItem.INVOICING_RULE;
228 aSqlItem.INVOICING_RULE_ID := aPlsqlItem.INVOICING_RULE_ID;
229 aSqlItem.OPEN_FLAG := aPlsqlItem.OPEN_FLAG;
230 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
231 aSqlItem.ORDER_DATE_TYPE_CODE := aPlsqlItem.ORDER_DATE_TYPE_CODE;
232 aSqlItem.ORDER_SOURCE := aPlsqlItem.ORDER_SOURCE;
233 aSqlItem.ORDER_SOURCE_ID := aPlsqlItem.ORDER_SOURCE_ID;
234 aSqlItem.ORDER_TYPE := aPlsqlItem.ORDER_TYPE;
235 aSqlItem.ORDER_TYPE_ID := aPlsqlItem.ORDER_TYPE_ID;
236 aSqlItem.ORDERED_BY_CONTACT_FIRST_NAME := aPlsqlItem.ORDERED_BY_CONTACT_FIRST_NAME;
237 aSqlItem.ORDERED_BY_CONTACT_LAST_NAME := aPlsqlItem.ORDERED_BY_CONTACT_LAST_NAME;
238 aSqlItem.PACKING_INSTRUCTIONS := aPlsqlItem.PACKING_INSTRUCTIONS;
239 aSqlItem.PARTIAL_SHIPMENTS_ALLOWED := aPlsqlItem.PARTIAL_SHIPMENTS_ALLOWED;
240 aSqlItem.PAYMENT_TERM_ID := aPlsqlItem.PAYMENT_TERM_ID;
241 aSqlItem.PAYMENT_TERM := aPlsqlItem.PAYMENT_TERM;
242 aSqlItem.PO_ATTRIBUTE_1 := aPlsqlItem.PO_ATTRIBUTE_1;
243 aSqlItem.PO_ATTRIBUTE_2 := aPlsqlItem.PO_ATTRIBUTE_2;
244 aSqlItem.PO_ATTRIBUTE_3 := aPlsqlItem.PO_ATTRIBUTE_3;
245 aSqlItem.PO_ATTRIBUTE_4 := aPlsqlItem.PO_ATTRIBUTE_4;
246 aSqlItem.PO_ATTRIBUTE_5 := aPlsqlItem.PO_ATTRIBUTE_5;
247 aSqlItem.PO_ATTRIBUTE_6 := aPlsqlItem.PO_ATTRIBUTE_6;
248 aSqlItem.PO_ATTRIBUTE_7 := aPlsqlItem.PO_ATTRIBUTE_7;
249 aSqlItem.PO_ATTRIBUTE_8 := aPlsqlItem.PO_ATTRIBUTE_8;
250 aSqlItem.PO_ATTRIBUTE_9 := aPlsqlItem.PO_ATTRIBUTE_9;
251 aSqlItem.PO_ATTRIBUTE_10 := aPlsqlItem.PO_ATTRIBUTE_10;
252 aSqlItem.PO_ATTRIBUTE_11 := aPlsqlItem.PO_ATTRIBUTE_11;
253 aSqlItem.PO_ATTRIBUTE_12 := aPlsqlItem.PO_ATTRIBUTE_12;
254 aSqlItem.PO_ATTRIBUTE_13 := aPlsqlItem.PO_ATTRIBUTE_13;
255 aSqlItem.PO_ATTRIBUTE_14 := aPlsqlItem.PO_ATTRIBUTE_14;
256 aSqlItem.PO_ATTRIBUTE_15 := aPlsqlItem.PO_ATTRIBUTE_15;
257 aSqlItem.PO_REVISION_DATE := aPlsqlItem.PO_REVISION_DATE;
258 aSqlItem.PROGRAM := aPlsqlItem.PROGRAM;
259 aSqlItem.PROGRAM_APPLICATION := aPlsqlItem.PROGRAM_APPLICATION;
260 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
261 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
262 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
263 aSqlItem.RELATED_PO_NUMBER := aPlsqlItem.RELATED_PO_NUMBER;
264 aSqlItem.REMAINDER_ORDERS_ALLOWED := aPlsqlItem.REMAINDER_ORDERS_ALLOWED;
265 aSqlItem.REQUEST_DATE := aPlsqlItem.REQUEST_DATE;
266 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
267 aSqlItem.RETURN_REASON_CODE := aPlsqlItem.RETURN_REASON_CODE;
268 aSqlItem.SALESREP_ID := aPlsqlItem.SALESREP_ID;
269 aSqlItem.SALESREP := aPlsqlItem.SALESREP;
270 aSqlItem.SHIP_TO_ADDRESS_1 := aPlsqlItem.SHIP_TO_ADDRESS_1;
271 aSqlItem.SHIP_TO_ADDRESS_2 := aPlsqlItem.SHIP_TO_ADDRESS_2;
272 aSqlItem.SHIP_TO_ADDRESS_3 := aPlsqlItem.SHIP_TO_ADDRESS_3;
273 aSqlItem.SHIP_TO_ADDRESS_4 := aPlsqlItem.SHIP_TO_ADDRESS_4;
274 aSqlItem.SHIP_TO_CITY := aPlsqlItem.SHIP_TO_CITY;
275 aSqlItem.SHIP_TO_CONTACT := aPlsqlItem.SHIP_TO_CONTACT;
276 aSqlItem.SHIP_TO_CONTACT_FIRST_NAME := aPlsqlItem.SHIP_TO_CONTACT_FIRST_NAME;
277 aSqlItem.SHIP_TO_CONTACT_ID := aPlsqlItem.SHIP_TO_CONTACT_ID;
278 aSqlItem.SHIP_TO_CONTACT_LAST_NAME := aPlsqlItem.SHIP_TO_CONTACT_LAST_NAME;
279 aSqlItem.SHIP_TO_COUNTRY := aPlsqlItem.SHIP_TO_COUNTRY;
280 aSqlItem.SHIP_TO_COUNTY := aPlsqlItem.SHIP_TO_COUNTY;
281 aSqlItem.SHIP_TO_CUSTOMER := aPlsqlItem.SHIP_TO_CUSTOMER;
282 aSqlItem.SHIP_TO_CUSTOMER_NUMBER := aPlsqlItem.SHIP_TO_CUSTOMER_NUMBER;
283 aSqlItem.SHIP_TO_POSTAL_CODE := aPlsqlItem.SHIP_TO_POSTAL_CODE;
284 aSqlItem.FIRST_ACK_CODE := aPlsqlItem.FIRST_ACK_CODE;
285 aSqlItem.LAST_ACK_CODE := aPlsqlItem.LAST_ACK_CODE;
286 aSqlItem.FIRST_ACK_DATE := aPlsqlItem.FIRST_ACK_DATE;
287 aSqlItem.LAST_ACK_DATE := aPlsqlItem.LAST_ACK_DATE;
288 aSqlItem.BUYER_SELLER_FLAG := aPlsqlItem.BUYER_SELLER_FLAG;
289 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
290 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
291 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
292 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
293 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
294 aSqlItem.BOOKED_FLAG := aPlsqlItem.BOOKED_FLAG;
295 aSqlItem.AGREEMENT_ID := aPlsqlItem.AGREEMENT_ID;
296 aSqlItem.AGREEMENT := aPlsqlItem.AGREEMENT;
297 aSqlItem.AGREEMENT_NAME := aPlsqlItem.AGREEMENT_NAME;
298 aSqlItem.CONTEXT := aPlsqlItem.CONTEXT;
299 aSqlItem.PRICE_LIST := aPlsqlItem.PRICE_LIST;
300 aSqlItem.PRICE_LIST_ID := aPlsqlItem.PRICE_LIST_ID;
301 aSqlItem.PRICING_DATE := aPlsqlItem.PRICING_DATE;
302 aSqlItem.SHIP_FROM_ORG_ID := aPlsqlItem.SHIP_FROM_ORG_ID;
303 aSqlItem.SHIP_FROM_ORG := aPlsqlItem.SHIP_FROM_ORG;
304 aSqlItem.SHIP_TO_ORG_ID := aPlsqlItem.SHIP_TO_ORG_ID;
305 aSqlItem.SHIP_TO_ORG := aPlsqlItem.SHIP_TO_ORG;
306 aSqlItem.SOLD_FROM_ORG := aPlsqlItem.SOLD_FROM_ORG;
307 aSqlItem.SOLD_FROM_ORG_ID := aPlsqlItem.SOLD_FROM_ORG_ID;
308 aSqlItem.SOLD_TO_ORG := aPlsqlItem.SOLD_TO_ORG;
309 aSqlItem.SOLD_TO_ORG_ID := aPlsqlItem.SOLD_TO_ORG_ID;
310 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
311 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
312 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
313 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
314 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
315 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
316 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
317 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
318 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
319 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
320 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
321 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
322 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
323 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
324 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
325 aSqlItem.CANCELLED_FLAG := aPlsqlItem.CANCELLED_FLAG;
326 aSqlItem.CLOSED_FLAG := aPlsqlItem.CLOSED_FLAG;
327 aSqlItem.CONVERSION_RATE := aPlsqlItem.CONVERSION_RATE;
328 aSqlItem.CONVERSION_RATE_DATE := aPlsqlItem.CONVERSION_RATE_DATE;
329 aSqlItem.CONVERSION_TYPE := aPlsqlItem.CONVERSION_TYPE;
330 aSqlItem.CONVERSION_TYPE_CODE := aPlsqlItem.CONVERSION_TYPE_CODE;
331 aSqlItem.CUST_PO_NUMBER := aPlsqlItem.CUST_PO_NUMBER;
332 aSqlItem.CUSTOMER_ID := aPlsqlItem.CUSTOMER_ID;
333 aSqlItem.CUSTOMER_NAME := aPlsqlItem.CUSTOMER_NAME;
334 aSqlItem.CUSTOMER_NUMBER := aPlsqlItem.CUSTOMER_NUMBER;
335 aSqlItem.DELIVER_TO_CONTACT := aPlsqlItem.DELIVER_TO_CONTACT;
336 aSqlItem.DELIVER_TO_CONTACT_ID := aPlsqlItem.DELIVER_TO_CONTACT_ID;
337 aSqlItem.DELIVER_TO_CUSTOMER := aPlsqlItem.DELIVER_TO_CUSTOMER;
338 aSqlItem.DELIVER_TO_CUSTOMER_NUMBER := aPlsqlItem.DELIVER_TO_CUSTOMER_NUMBER;
339 aSqlItem.DELIVER_TO_ORG := aPlsqlItem.DELIVER_TO_ORG;
340 aSqlItem.DELIVER_TO_ORG_ID := aPlsqlItem.DELIVER_TO_ORG_ID;
341 aSqlItem.DEMAND_CLASS := aPlsqlItem.DEMAND_CLASS;
342 aSqlItem.DEMAND_CLASS_CODE := aPlsqlItem.DEMAND_CLASS_CODE;
343 aSqlItem.EARLIEST_SCHEDULE_LIMIT := aPlsqlItem.EARLIEST_SCHEDULE_LIMIT;
344 aSqlItem.LATEST_SCHEDULE_LIMIT := aPlsqlItem.LATEST_SCHEDULE_LIMIT;
345 aSqlItem.ERROR_FLAG := aPlsqlItem.ERROR_FLAG;
346 aSqlItem.EXPIRATION_DATE := aPlsqlItem.EXPIRATION_DATE;
347 aSqlItem.FOB_POINT := aPlsqlItem.FOB_POINT;
348 aSqlItem.FOB_POINT_CODE := aPlsqlItem.FOB_POINT_CODE;
349 aSqlItem.FREIGHT_CARRIER_CODE := aPlsqlItem.FREIGHT_CARRIER_CODE;
350 aSqlItem.FREIGHT_TERMS := aPlsqlItem.FREIGHT_TERMS;
351 aSqlItem.FREIGHT_TERMS_CODE := aPlsqlItem.FREIGHT_TERMS_CODE;
352 aSqlItem.GLOBAL_ATTRIBUTE_CATEGORY := aPlsqlItem.GLOBAL_ATTRIBUTE_CATEGORY;
353 aSqlItem.GLOBAL_ATTRIBUTE1 := aPlsqlItem.GLOBAL_ATTRIBUTE1;
354 aSqlItem.GLOBAL_ATTRIBUTE2 := aPlsqlItem.GLOBAL_ATTRIBUTE2;
355 aSqlItem.GLOBAL_ATTRIBUTE3 := aPlsqlItem.GLOBAL_ATTRIBUTE3;
356 aSqlItem.GLOBAL_ATTRIBUTE4 := aPlsqlItem.GLOBAL_ATTRIBUTE4;
357 aSqlItem.GLOBAL_ATTRIBUTE5 := aPlsqlItem.GLOBAL_ATTRIBUTE5;
358 aSqlItem.GLOBAL_ATTRIBUTE6 := aPlsqlItem.GLOBAL_ATTRIBUTE6;
359 aSqlItem.GLOBAL_ATTRIBUTE7 := aPlsqlItem.GLOBAL_ATTRIBUTE7;
360 aSqlItem.GLOBAL_ATTRIBUTE8 := aPlsqlItem.GLOBAL_ATTRIBUTE8;
361 aSqlItem.GLOBAL_ATTRIBUTE9 := aPlsqlItem.GLOBAL_ATTRIBUTE9;
362 aSqlItem.GLOBAL_ATTRIBUTE10 := aPlsqlItem.GLOBAL_ATTRIBUTE10;
363 aSqlItem.GLOBAL_ATTRIBUTE11 := aPlsqlItem.GLOBAL_ATTRIBUTE11;
364 aSqlItem.DELIVER_TO_STATE := aPlsqlItem.DELIVER_TO_STATE;
365 aSqlItem.SOLD_TO_LOCATION_STATE := aPlsqlItem.SOLD_TO_LOCATION_STATE;
366 aSqlItem.SOLD_TO_LOCATION_COUNTY := aPlsqlItem.SOLD_TO_LOCATION_COUNTY;
367 aSqlItem.SOLD_TO_LOCATION_PROVINCE := aPlsqlItem.SOLD_TO_LOCATION_PROVINCE;
368 aSqlItem.HEADER_ID := aPlsqlItem.HEADER_ID;
369 aSqlItem.ORIG_SYS_DOCUMENT_REF := aPlsqlItem.ORIG_SYS_DOCUMENT_REF;
370 aSqlItem.ORDER_NUMBER := aPlsqlItem.ORDER_NUMBER;
371 aSqlItem.ORDERED_DATE := aPlsqlItem.ORDERED_DATE;
372 aSqlItem.ORG_ID := aPlsqlItem.ORG_ID;
373 aSqlItem.CHANGE_DATE := aPlsqlItem.CHANGE_DATE;
374 aSqlItem.CHANGE_SEQUENCE := aPlsqlItem.CHANGE_SEQUENCE;
375 aSqlItem.ACCOUNTING_RULE_ID := aPlsqlItem.ACCOUNTING_RULE_ID;
376 aSqlItem.ACCOUNTING_RULE := aPlsqlItem.ACCOUNTING_RULE;
377 aSqlItem.ACKNOWLEDGMENT_FLAG := aPlsqlItem.ACKNOWLEDGMENT_FLAG;
378 RETURN aSqlItem;
379 END PL_TO_SQL2;
380 FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
381 RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS
382 aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
383 BEGIN
384 aPlsqlItem.IB_OWNER_CODE := aSqlItem.IB_OWNER_CODE;
385 aPlsqlItem.IB_CURRENT_LOCATION_CODE := aSqlItem.IB_CURRENT_LOCATION_CODE;
386 aPlsqlItem.IB_INSTALLED_AT_LOCATION_CODE := aSqlItem.IB_INSTALLED_AT_LOCATION_CODE;
387 aPlsqlItem.INVOICE_CUSTOMER_ID := aSqlItem.INVOICE_CUSTOMER_ID;
388 aPlsqlItem.DELIVER_TO_CUSTOMER_ID := aSqlItem.DELIVER_TO_CUSTOMER_ID;
389 aPlsqlItem.ACCOUNTING_RULE_DURATION := aSqlItem.ACCOUNTING_RULE_DURATION;
390 aPlsqlItem.ATTRIBUTE16 := aSqlItem.ATTRIBUTE16;
391 aPlsqlItem.ATTRIBUTE17 := aSqlItem.ATTRIBUTE17;
392 aPlsqlItem.ATTRIBUTE18 := aSqlItem.ATTRIBUTE18;
393 aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
394 aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
395 aPlsqlItem.ACKNOWLEDGMENT_TYPE := aSqlItem.ACKNOWLEDGMENT_TYPE;
396 aPlsqlItem.BLANKET_NUMBER := aSqlItem.BLANKET_NUMBER;
397 aPlsqlItem.BOOKED_DATE := aSqlItem.BOOKED_DATE;
398 aPlsqlItem.FLOW_STATUS_CODE := aSqlItem.FLOW_STATUS_CODE;
399 aPlsqlItem.CREDIT_CARD_APPROVAL_DATE := aSqlItem.CREDIT_CARD_APPROVAL_DATE;
400 aPlsqlItem.PAYMENT_TYPE_CODE := aSqlItem.PAYMENT_TYPE_CODE;
401 aPlsqlItem.PAYMENT_AMOUNT := aSqlItem.PAYMENT_AMOUNT;
402 aPlsqlItem.CHECK_NUMBER := aSqlItem.CHECK_NUMBER;
403 aPlsqlItem.CREDIT_CARD_CODE := aSqlItem.CREDIT_CARD_CODE;
404 aPlsqlItem.CREDIT_CARD_HOLDER_NAME := aSqlItem.CREDIT_CARD_HOLDER_NAME;
405 aPlsqlItem.CREDIT_CARD_NUMBER := aSqlItem.CREDIT_CARD_NUMBER;
406 aPlsqlItem.CREDIT_CARD_EXPIRATION_DATE := aSqlItem.CREDIT_CARD_EXPIRATION_DATE;
407 aPlsqlItem.CREDIT_CARD_APPROVAL_CODE := aSqlItem.CREDIT_CARD_APPROVAL_CODE;
408 aPlsqlItem.CUSTOMER_PREFERENCE_SET_CODE := aSqlItem.CUSTOMER_PREFERENCE_SET_CODE;
409 aPlsqlItem.SALES_CHANNEL_CODE := aSqlItem.SALES_CHANNEL_CODE;
410 aPlsqlItem.SOLD_TO_PHONE_ID := aSqlItem.SOLD_TO_PHONE_ID;
411 aPlsqlItem.SHIP_TO_PROVINCE := aSqlItem.SHIP_TO_PROVINCE;
412 aPlsqlItem.SHIP_TO_SITE_INT := aSqlItem.SHIP_TO_SITE_INT;
413 aPlsqlItem.SHIP_TO_STATE := aSqlItem.SHIP_TO_STATE;
414 aPlsqlItem.SHIP_TOLERANCE_ABOVE := aSqlItem.SHIP_TOLERANCE_ABOVE;
415 aPlsqlItem.SHIP_TOLERANCE_BELOW := aSqlItem.SHIP_TOLERANCE_BELOW;
416 aPlsqlItem.SHIPMENT_PRIORITY := aSqlItem.SHIPMENT_PRIORITY;
417 aPlsqlItem.SHIPMENT_PRIORITY_CODE := aSqlItem.SHIPMENT_PRIORITY_CODE;
418 aPlsqlItem.SHIPMENT_PRIORITY_CODE_INT := aSqlItem.SHIPMENT_PRIORITY_CODE_INT;
419 aPlsqlItem.SHIPPING_INSTRUCTIONS := aSqlItem.SHIPPING_INSTRUCTIONS;
420 aPlsqlItem.SHIPPING_METHOD := aSqlItem.SHIPPING_METHOD;
421 aPlsqlItem.SHIPPING_METHOD_CODE := aSqlItem.SHIPPING_METHOD_CODE;
422 aPlsqlItem.SOLD_TO_CONTACT := aSqlItem.SOLD_TO_CONTACT;
423 aPlsqlItem.SOLD_TO_CONTACT_ID := aSqlItem.SOLD_TO_CONTACT_ID;
424 aPlsqlItem.SOURCE_DOCUMENT_ID := aSqlItem.SOURCE_DOCUMENT_ID;
425 aPlsqlItem.SOURCE_DOCUMENT_TYPE_ID := aSqlItem.SOURCE_DOCUMENT_TYPE_ID;
426 aPlsqlItem.SUBMISSION_DATETIME := aSqlItem.SUBMISSION_DATETIME;
427 aPlsqlItem.TAX_EXEMPT_FLAG := aSqlItem.TAX_EXEMPT_FLAG;
428 aPlsqlItem.TAX_EXEMPT_NUMBER := aSqlItem.TAX_EXEMPT_NUMBER;
429 aPlsqlItem.TAX_EXEMPT_REASON := aSqlItem.TAX_EXEMPT_REASON;
430 aPlsqlItem.TAX_EXEMPT_REASON_CODE := aSqlItem.TAX_EXEMPT_REASON_CODE;
431 aPlsqlItem.TAX_POINT := aSqlItem.TAX_POINT;
432 aPlsqlItem.TAX_POINT_CODE := aSqlItem.TAX_POINT_CODE;
433 aPlsqlItem.TRANSACTIONAL_CURR := aSqlItem.TRANSACTIONAL_CURR;
434 aPlsqlItem.TRANSACTIONAL_CURR_CODE := aSqlItem.TRANSACTIONAL_CURR_CODE;
435 aPlsqlItem.VERSION_NUMBER := aSqlItem.VERSION_NUMBER;
436 aPlsqlItem.CUSTOMER_PAYMENT_TERM_ID := aSqlItem.CUSTOMER_PAYMENT_TERM_ID;
437 aPlsqlItem.DROP_SHIP_FLAG := aSqlItem.DROP_SHIP_FLAG;
438 aPlsqlItem.ORDER_CATEGORY_CODE := aSqlItem.ORDER_CATEGORY_CODE;
439 aPlsqlItem.SOLD_TO_ADDRESS1 := aSqlItem.SOLD_TO_ADDRESS1;
440 aPlsqlItem.SOLD_TO_ADDRESS2 := aSqlItem.SOLD_TO_ADDRESS2;
441 aPlsqlItem.SOLD_TO_ADDRESS3 := aSqlItem.SOLD_TO_ADDRESS3;
442 aPlsqlItem.SOLD_TO_ADDRESS4 := aSqlItem.SOLD_TO_ADDRESS4;
443 aPlsqlItem.SOLD_TO_CITY := aSqlItem.SOLD_TO_CITY;
444 aPlsqlItem.SOLD_TO_POSTAL_CODE := aSqlItem.SOLD_TO_POSTAL_CODE;
445 aPlsqlItem.SOLD_TO_COUNTRY := aSqlItem.SOLD_TO_COUNTRY;
446 aPlsqlItem.SOLD_TO_STATE := aSqlItem.SOLD_TO_STATE;
447 aPlsqlItem.SOLD_TO_COUNTY := aSqlItem.SOLD_TO_COUNTY;
448 aPlsqlItem.SOLD_TO_PROVINCE := aSqlItem.SOLD_TO_PROVINCE;
449 aPlsqlItem.SOLD_TO_CONTACT_LAST_NAME := aSqlItem.SOLD_TO_CONTACT_LAST_NAME;
450 aPlsqlItem.SOLD_TO_CONTACT_FIRST_NAME := aSqlItem.SOLD_TO_CONTACT_FIRST_NAME;
451 aPlsqlItem.SHIP_TO_EDI_LOCATION_CODE := aSqlItem.SHIP_TO_EDI_LOCATION_CODE;
452 aPlsqlItem.SOLD_TO_EDI_LOCATION_CODE := aSqlItem.SOLD_TO_EDI_LOCATION_CODE;
453 aPlsqlItem.BILL_TO_EDI_LOCATION_CODE := aSqlItem.BILL_TO_EDI_LOCATION_CODE;
454 aPlsqlItem.CUSTOMER_PAYMENT_TERM := aSqlItem.CUSTOMER_PAYMENT_TERM;
455 aPlsqlItem.SHIP_FROM_ADDRESS_1 := aSqlItem.SHIP_FROM_ADDRESS_1;
456 aPlsqlItem.SHIP_FROM_ADDRESS_2 := aSqlItem.SHIP_FROM_ADDRESS_2;
457 aPlsqlItem.SHIP_FROM_ADDRESS_3 := aSqlItem.SHIP_FROM_ADDRESS_3;
458 aPlsqlItem.SHIP_FROM_CITY := aSqlItem.SHIP_FROM_CITY;
459 aPlsqlItem.SHIP_FROM_POSTAL_CODE := aSqlItem.SHIP_FROM_POSTAL_CODE;
460 aPlsqlItem.SHIP_FROM_COUNTRY := aSqlItem.SHIP_FROM_COUNTRY;
461 aPlsqlItem.SHIP_FROM_EDI_LOCATION_CODE := aSqlItem.SHIP_FROM_EDI_LOCATION_CODE;
462 aPlsqlItem.SHIP_FROM_REGION1 := aSqlItem.SHIP_FROM_REGION1;
463 aPlsqlItem.SHIP_FROM_REGION2 := aSqlItem.SHIP_FROM_REGION2;
464 aPlsqlItem.SHIP_FROM_REGION3 := aSqlItem.SHIP_FROM_REGION3;
465 aPlsqlItem.SHIP_FROM_ADDRESS_ID := aSqlItem.SHIP_FROM_ADDRESS_ID;
466 aPlsqlItem.SOLD_TO_ADDRESS_ID := aSqlItem.SOLD_TO_ADDRESS_ID;
467 aPlsqlItem.SHIP_TO_ADDRESS_ID := aSqlItem.SHIP_TO_ADDRESS_ID;
468 aPlsqlItem.INVOICE_ADDRESS_ID := aSqlItem.INVOICE_ADDRESS_ID;
469 aPlsqlItem.SHIP_TO_ADDRESS_CODE := aSqlItem.SHIP_TO_ADDRESS_CODE;
470 aPlsqlItem.TP_CONTEXT := aSqlItem.TP_CONTEXT;
471 aPlsqlItem.TP_ATTRIBUTE1 := aSqlItem.TP_ATTRIBUTE1;
472 aPlsqlItem.TP_ATTRIBUTE2 := aSqlItem.TP_ATTRIBUTE2;
473 aPlsqlItem.TP_ATTRIBUTE3 := aSqlItem.TP_ATTRIBUTE3;
474 aPlsqlItem.TP_ATTRIBUTE4 := aSqlItem.TP_ATTRIBUTE4;
475 aPlsqlItem.TP_ATTRIBUTE5 := aSqlItem.TP_ATTRIBUTE5;
476 aPlsqlItem.TP_ATTRIBUTE6 := aSqlItem.TP_ATTRIBUTE6;
477 aPlsqlItem.TP_ATTRIBUTE7 := aSqlItem.TP_ATTRIBUTE7;
478 aPlsqlItem.TP_ATTRIBUTE8 := aSqlItem.TP_ATTRIBUTE8;
479 aPlsqlItem.TP_ATTRIBUTE9 := aSqlItem.TP_ATTRIBUTE9;
480 aPlsqlItem.TP_ATTRIBUTE10 := aSqlItem.TP_ATTRIBUTE10;
481 aPlsqlItem.TP_ATTRIBUTE11 := aSqlItem.TP_ATTRIBUTE11;
482 aPlsqlItem.TP_ATTRIBUTE12 := aSqlItem.TP_ATTRIBUTE12;
483 aPlsqlItem.TP_ATTRIBUTE13 := aSqlItem.TP_ATTRIBUTE13;
484 aPlsqlItem.TP_ATTRIBUTE14 := aSqlItem.TP_ATTRIBUTE14;
485 aPlsqlItem.TP_ATTRIBUTE15 := aSqlItem.TP_ATTRIBUTE15;
486 aPlsqlItem.XML_MESSAGE_ID := aSqlItem.XML_MESSAGE_ID;
487 aPlsqlItem.SHIP_TO_CUSTOMER_ID := aSqlItem.SHIP_TO_CUSTOMER_ID;
488 aPlsqlItem.ORDER_FIRMED_DATE := aSqlItem.ORDER_FIRMED_DATE;
489 aPlsqlItem.DELIVER_TO_ADDRESS1 := aSqlItem.DELIVER_TO_ADDRESS1;
490 aPlsqlItem.DELIVER_TO_ADDRESS2 := aSqlItem.DELIVER_TO_ADDRESS2;
491 aPlsqlItem.DELIVER_TO_ADDRESS3 := aSqlItem.DELIVER_TO_ADDRESS3;
492 aPlsqlItem.DELIVER_TO_ADDRESS4 := aSqlItem.DELIVER_TO_ADDRESS4;
493 aPlsqlItem.DELIVER_TO_CITY := aSqlItem.DELIVER_TO_CITY;
494 aPlsqlItem.DELIVER_TO_COUNTRY := aSqlItem.DELIVER_TO_COUNTRY;
495 aPlsqlItem.DELIVER_TO_COUNTY := aSqlItem.DELIVER_TO_COUNTY;
496 aPlsqlItem.DELIVER_TO_POSTAL_CODE := aSqlItem.DELIVER_TO_POSTAL_CODE;
497 aPlsqlItem.DELIVER_TO_PROVINCE := aSqlItem.DELIVER_TO_PROVINCE;
498 aPlsqlItem.TRANSACTION_PHASE_CODE := aSqlItem.TRANSACTION_PHASE_CODE;
499 aPlsqlItem.SALES_DOCUMENT_NAME := aSqlItem.SALES_DOCUMENT_NAME;
500 aPlsqlItem.QUOTE_NUMBER := aSqlItem.QUOTE_NUMBER;
501 aPlsqlItem.QUOTE_DATE := aSqlItem.QUOTE_DATE;
502 aPlsqlItem.USER_STATUS_CODE := aSqlItem.USER_STATUS_CODE;
503 aPlsqlItem.SOLD_TO_SITE_USE_ID := aSqlItem.SOLD_TO_SITE_USE_ID;
504 aPlsqlItem.SUPPLIER_SIGNATURE := aSqlItem.SUPPLIER_SIGNATURE;
505 aPlsqlItem.SUPPLIER_SIGNATURE_DATE := aSqlItem.SUPPLIER_SIGNATURE_DATE;
506 aPlsqlItem.CUSTOMER_SIGNATURE := aSqlItem.CUSTOMER_SIGNATURE;
507 aPlsqlItem.CUSTOMER_SIGNATURE_DATE := aSqlItem.CUSTOMER_SIGNATURE_DATE;
508 aPlsqlItem.SOLD_TO_PARTY_NUMBER := aSqlItem.SOLD_TO_PARTY_NUMBER;
509 aPlsqlItem.SHIP_TO_PARTY_NUMBER := aSqlItem.SHIP_TO_PARTY_NUMBER;
510 aPlsqlItem.INVOICE_TO_PARTY_NUMBER := aSqlItem.INVOICE_TO_PARTY_NUMBER;
511 aPlsqlItem.DELIVER_TO_PARTY_NUMBER := aSqlItem.DELIVER_TO_PARTY_NUMBER;
512 aPlsqlItem.END_CUSTOMER_NUMBER := aSqlItem.END_CUSTOMER_NUMBER;
513 aPlsqlItem.END_CUSTOMER_PARTY_NUMBER := aSqlItem.END_CUSTOMER_PARTY_NUMBER;
514 aPlsqlItem.END_CUSTOMER_ID := aSqlItem.END_CUSTOMER_ID;
515 aPlsqlItem.END_CUSTOMER_CONTACT_ID := aSqlItem.END_CUSTOMER_CONTACT_ID;
516 aPlsqlItem.END_CUSTOMER_SITE_USE_ID := aSqlItem.END_CUSTOMER_SITE_USE_ID;
517 aPlsqlItem.END_CUSTOMER_ADDRESS1 := aSqlItem.END_CUSTOMER_ADDRESS1;
518 aPlsqlItem.END_CUSTOMER_ADDRESS2 := aSqlItem.END_CUSTOMER_ADDRESS2;
519 aPlsqlItem.END_CUSTOMER_ADDRESS3 := aSqlItem.END_CUSTOMER_ADDRESS3;
520 aPlsqlItem.END_CUSTOMER_ADDRESS4 := aSqlItem.END_CUSTOMER_ADDRESS4;
521 aPlsqlItem.END_CUSTOMER_CITY := aSqlItem.END_CUSTOMER_CITY;
522 aPlsqlItem.END_CUSTOMER_POSTAL_CODE := aSqlItem.END_CUSTOMER_POSTAL_CODE;
523 aPlsqlItem.END_CUSTOMER_COUNTRY := aSqlItem.END_CUSTOMER_COUNTRY;
524 aPlsqlItem.END_CUSTOMER_STATE := aSqlItem.END_CUSTOMER_STATE;
525 aPlsqlItem.END_CUSTOMER_COUNTY := aSqlItem.END_CUSTOMER_COUNTY;
526 aPlsqlItem.END_CUSTOMER_PROVINCE := aSqlItem.END_CUSTOMER_PROVINCE;
527 aPlsqlItem.END_CUSTOMER_CONTACT := aSqlItem.END_CUSTOMER_CONTACT;
528 aPlsqlItem.END_CUSTOMER_CONTACT_LAST_NAME := aSqlItem.END_CUSTOMER_CONTACT_LAST_NAME;
529 aPlsqlItem.END_CUSTOMER_CONTACT_FIRST_NAM := aSqlItem.END_CUSTOMER_CONTACT_FIRST_NAM;
530 aPlsqlItem.END_CUSTOMER_NAME := aSqlItem.END_CUSTOMER_NAME;
531 aPlsqlItem.IB_OWNER := aSqlItem.IB_OWNER;
532 aPlsqlItem.IB_CURRENT_LOCATION := aSqlItem.IB_CURRENT_LOCATION;
533 aPlsqlItem.IB_INSTALLED_AT_LOCATION := aSqlItem.IB_INSTALLED_AT_LOCATION;
534 aPlsqlItem.SOLD_TO_LOCATION_ADDRESS1 := aSqlItem.SOLD_TO_LOCATION_ADDRESS1;
535 aPlsqlItem.SOLD_TO_LOCATION_ADDRESS2 := aSqlItem.SOLD_TO_LOCATION_ADDRESS2;
536 aPlsqlItem.SOLD_TO_LOCATION_ADDRESS3 := aSqlItem.SOLD_TO_LOCATION_ADDRESS3;
537 aPlsqlItem.SOLD_TO_LOCATION_ADDRESS4 := aSqlItem.SOLD_TO_LOCATION_ADDRESS4;
538 aPlsqlItem.SOLD_TO_LOCATION_CITY := aSqlItem.SOLD_TO_LOCATION_CITY;
539 aPlsqlItem.SOLD_TO_LOCATION_POSTAL_CODE := aSqlItem.SOLD_TO_LOCATION_POSTAL_CODE;
540 aPlsqlItem.SOLD_TO_LOCATION_COUNTRY := aSqlItem.SOLD_TO_LOCATION_COUNTRY;
541 aPlsqlItem.GLOBAL_ATTRIBUTE12 := aSqlItem.GLOBAL_ATTRIBUTE12;
542 aPlsqlItem.GLOBAL_ATTRIBUTE13 := aSqlItem.GLOBAL_ATTRIBUTE13;
543 aPlsqlItem.GLOBAL_ATTRIBUTE14 := aSqlItem.GLOBAL_ATTRIBUTE14;
544 aPlsqlItem.GLOBAL_ATTRIBUTE15 := aSqlItem.GLOBAL_ATTRIBUTE15;
545 aPlsqlItem.GLOBAL_ATTRIBUTE16 := aSqlItem.GLOBAL_ATTRIBUTE16;
546 aPlsqlItem.GLOBAL_ATTRIBUTE17 := aSqlItem.GLOBAL_ATTRIBUTE17;
547 aPlsqlItem.GLOBAL_ATTRIBUTE18 := aSqlItem.GLOBAL_ATTRIBUTE18;
548 aPlsqlItem.GLOBAL_ATTRIBUTE19 := aSqlItem.GLOBAL_ATTRIBUTE19;
549 aPlsqlItem.GLOBAL_ATTRIBUTE20 := aSqlItem.GLOBAL_ATTRIBUTE20;
550 aPlsqlItem.HEADER_PO_CONTEXT := aSqlItem.HEADER_PO_CONTEXT;
551 aPlsqlItem.INTERFACE_STATUS := aSqlItem.INTERFACE_STATUS;
552 aPlsqlItem.INVOICE_ADDRESS_1 := aSqlItem.INVOICE_ADDRESS_1;
553 aPlsqlItem.INVOICE_ADDRESS_2 := aSqlItem.INVOICE_ADDRESS_2;
554 aPlsqlItem.INVOICE_ADDRESS_3 := aSqlItem.INVOICE_ADDRESS_3;
555 aPlsqlItem.INVOICE_ADDRESS_4 := aSqlItem.INVOICE_ADDRESS_4;
556 aPlsqlItem.INVOICE_CITY := aSqlItem.INVOICE_CITY;
557 aPlsqlItem.INVOICE_COUNTRY := aSqlItem.INVOICE_COUNTRY;
558 aPlsqlItem.INVOICE_COUNTY := aSqlItem.INVOICE_COUNTY;
559 aPlsqlItem.INVOICE_CUSTOMER := aSqlItem.INVOICE_CUSTOMER;
560 aPlsqlItem.INVOICE_CUSTOMER_NUMBER := aSqlItem.INVOICE_CUSTOMER_NUMBER;
561 aPlsqlItem.INVOICE_POSTAL_CODE := aSqlItem.INVOICE_POSTAL_CODE;
562 aPlsqlItem.INVOICE_PROVINCE_INT := aSqlItem.INVOICE_PROVINCE_INT;
563 aPlsqlItem.INVOICE_SITE := aSqlItem.INVOICE_SITE;
564 aPlsqlItem.INVOICE_SITE_CODE := aSqlItem.INVOICE_SITE_CODE;
565 aPlsqlItem.INVOICE_STATE := aSqlItem.INVOICE_STATE;
566 aPlsqlItem.INVOICE_TO_CONTACT := aSqlItem.INVOICE_TO_CONTACT;
567 aPlsqlItem.INVOICE_TO_CONTACT_FIRST_NAME := aSqlItem.INVOICE_TO_CONTACT_FIRST_NAME;
568 aPlsqlItem.INVOICE_TO_CONTACT_ID := aSqlItem.INVOICE_TO_CONTACT_ID;
569 aPlsqlItem.INVOICE_TO_CONTACT_LAST_NAME := aSqlItem.INVOICE_TO_CONTACT_LAST_NAME;
570 aPlsqlItem.INVOICE_TO_ORG := aSqlItem.INVOICE_TO_ORG;
571 aPlsqlItem.INVOICE_TO_ORG_ID := aSqlItem.INVOICE_TO_ORG_ID;
572 aPlsqlItem.INVOICE_TOLERANCE_ABOVE := aSqlItem.INVOICE_TOLERANCE_ABOVE;
573 aPlsqlItem.INVOICE_TOLERANCE_BELOW := aSqlItem.INVOICE_TOLERANCE_BELOW;
574 aPlsqlItem.INVOICING_RULE := aSqlItem.INVOICING_RULE;
575 aPlsqlItem.INVOICING_RULE_ID := aSqlItem.INVOICING_RULE_ID;
576 aPlsqlItem.OPEN_FLAG := aSqlItem.OPEN_FLAG;
577 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
578 aPlsqlItem.ORDER_DATE_TYPE_CODE := aSqlItem.ORDER_DATE_TYPE_CODE;
579 aPlsqlItem.ORDER_SOURCE := aSqlItem.ORDER_SOURCE;
580 aPlsqlItem.ORDER_SOURCE_ID := aSqlItem.ORDER_SOURCE_ID;
581 aPlsqlItem.ORDER_TYPE := aSqlItem.ORDER_TYPE;
582 aPlsqlItem.ORDER_TYPE_ID := aSqlItem.ORDER_TYPE_ID;
583 aPlsqlItem.ORDERED_BY_CONTACT_FIRST_NAME := aSqlItem.ORDERED_BY_CONTACT_FIRST_NAME;
584 aPlsqlItem.ORDERED_BY_CONTACT_LAST_NAME := aSqlItem.ORDERED_BY_CONTACT_LAST_NAME;
585 aPlsqlItem.PACKING_INSTRUCTIONS := aSqlItem.PACKING_INSTRUCTIONS;
586 aPlsqlItem.PARTIAL_SHIPMENTS_ALLOWED := aSqlItem.PARTIAL_SHIPMENTS_ALLOWED;
587 aPlsqlItem.PAYMENT_TERM_ID := aSqlItem.PAYMENT_TERM_ID;
588 aPlsqlItem.PAYMENT_TERM := aSqlItem.PAYMENT_TERM;
589 aPlsqlItem.PO_ATTRIBUTE_1 := aSqlItem.PO_ATTRIBUTE_1;
590 aPlsqlItem.PO_ATTRIBUTE_2 := aSqlItem.PO_ATTRIBUTE_2;
591 aPlsqlItem.PO_ATTRIBUTE_3 := aSqlItem.PO_ATTRIBUTE_3;
592 aPlsqlItem.PO_ATTRIBUTE_4 := aSqlItem.PO_ATTRIBUTE_4;
593 aPlsqlItem.PO_ATTRIBUTE_5 := aSqlItem.PO_ATTRIBUTE_5;
594 aPlsqlItem.PO_ATTRIBUTE_6 := aSqlItem.PO_ATTRIBUTE_6;
595 aPlsqlItem.PO_ATTRIBUTE_7 := aSqlItem.PO_ATTRIBUTE_7;
596 aPlsqlItem.PO_ATTRIBUTE_8 := aSqlItem.PO_ATTRIBUTE_8;
597 aPlsqlItem.PO_ATTRIBUTE_9 := aSqlItem.PO_ATTRIBUTE_9;
598 aPlsqlItem.PO_ATTRIBUTE_10 := aSqlItem.PO_ATTRIBUTE_10;
599 aPlsqlItem.PO_ATTRIBUTE_11 := aSqlItem.PO_ATTRIBUTE_11;
600 aPlsqlItem.PO_ATTRIBUTE_12 := aSqlItem.PO_ATTRIBUTE_12;
601 aPlsqlItem.PO_ATTRIBUTE_13 := aSqlItem.PO_ATTRIBUTE_13;
602 aPlsqlItem.PO_ATTRIBUTE_14 := aSqlItem.PO_ATTRIBUTE_14;
603 aPlsqlItem.PO_ATTRIBUTE_15 := aSqlItem.PO_ATTRIBUTE_15;
604 aPlsqlItem.PO_REVISION_DATE := aSqlItem.PO_REVISION_DATE;
605 aPlsqlItem.PROGRAM := aSqlItem.PROGRAM;
606 aPlsqlItem.PROGRAM_APPLICATION := aSqlItem.PROGRAM_APPLICATION;
607 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
608 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
609 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
610 aPlsqlItem.RELATED_PO_NUMBER := aSqlItem.RELATED_PO_NUMBER;
611 aPlsqlItem.REMAINDER_ORDERS_ALLOWED := aSqlItem.REMAINDER_ORDERS_ALLOWED;
612 aPlsqlItem.REQUEST_DATE := aSqlItem.REQUEST_DATE;
613 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
614 aPlsqlItem.RETURN_REASON_CODE := aSqlItem.RETURN_REASON_CODE;
615 aPlsqlItem.SALESREP_ID := aSqlItem.SALESREP_ID;
616 aPlsqlItem.SALESREP := aSqlItem.SALESREP;
617 aPlsqlItem.SHIP_TO_ADDRESS_1 := aSqlItem.SHIP_TO_ADDRESS_1;
618 aPlsqlItem.SHIP_TO_ADDRESS_2 := aSqlItem.SHIP_TO_ADDRESS_2;
619 aPlsqlItem.SHIP_TO_ADDRESS_3 := aSqlItem.SHIP_TO_ADDRESS_3;
620 aPlsqlItem.SHIP_TO_ADDRESS_4 := aSqlItem.SHIP_TO_ADDRESS_4;
621 aPlsqlItem.SHIP_TO_CITY := aSqlItem.SHIP_TO_CITY;
622 aPlsqlItem.SHIP_TO_CONTACT := aSqlItem.SHIP_TO_CONTACT;
623 aPlsqlItem.SHIP_TO_CONTACT_FIRST_NAME := aSqlItem.SHIP_TO_CONTACT_FIRST_NAME;
624 aPlsqlItem.SHIP_TO_CONTACT_ID := aSqlItem.SHIP_TO_CONTACT_ID;
625 aPlsqlItem.SHIP_TO_CONTACT_LAST_NAME := aSqlItem.SHIP_TO_CONTACT_LAST_NAME;
626 aPlsqlItem.SHIP_TO_COUNTRY := aSqlItem.SHIP_TO_COUNTRY;
627 aPlsqlItem.SHIP_TO_COUNTY := aSqlItem.SHIP_TO_COUNTY;
628 aPlsqlItem.SHIP_TO_CUSTOMER := aSqlItem.SHIP_TO_CUSTOMER;
629 aPlsqlItem.SHIP_TO_CUSTOMER_NUMBER := aSqlItem.SHIP_TO_CUSTOMER_NUMBER;
630 aPlsqlItem.SHIP_TO_POSTAL_CODE := aSqlItem.SHIP_TO_POSTAL_CODE;
631 aPlsqlItem.FIRST_ACK_CODE := aSqlItem.FIRST_ACK_CODE;
632 aPlsqlItem.LAST_ACK_CODE := aSqlItem.LAST_ACK_CODE;
633 aPlsqlItem.FIRST_ACK_DATE := aSqlItem.FIRST_ACK_DATE;
634 aPlsqlItem.LAST_ACK_DATE := aSqlItem.LAST_ACK_DATE;
635 aPlsqlItem.BUYER_SELLER_FLAG := aSqlItem.BUYER_SELLER_FLAG;
636 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
637 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
638 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
639 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
640 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
641 aPlsqlItem.BOOKED_FLAG := aSqlItem.BOOKED_FLAG;
642 aPlsqlItem.AGREEMENT_ID := aSqlItem.AGREEMENT_ID;
643 aPlsqlItem.AGREEMENT := aSqlItem.AGREEMENT;
644 aPlsqlItem.AGREEMENT_NAME := aSqlItem.AGREEMENT_NAME;
645 aPlsqlItem.CONTEXT := aSqlItem.CONTEXT;
646 aPlsqlItem.PRICE_LIST := aSqlItem.PRICE_LIST;
647 aPlsqlItem.PRICE_LIST_ID := aSqlItem.PRICE_LIST_ID;
648 aPlsqlItem.PRICING_DATE := aSqlItem.PRICING_DATE;
649 aPlsqlItem.SHIP_FROM_ORG_ID := aSqlItem.SHIP_FROM_ORG_ID;
650 aPlsqlItem.SHIP_FROM_ORG := aSqlItem.SHIP_FROM_ORG;
651 aPlsqlItem.SHIP_TO_ORG_ID := aSqlItem.SHIP_TO_ORG_ID;
652 aPlsqlItem.SHIP_TO_ORG := aSqlItem.SHIP_TO_ORG;
653 aPlsqlItem.SOLD_FROM_ORG := aSqlItem.SOLD_FROM_ORG;
654 aPlsqlItem.SOLD_FROM_ORG_ID := aSqlItem.SOLD_FROM_ORG_ID;
655 aPlsqlItem.SOLD_TO_ORG := aSqlItem.SOLD_TO_ORG;
656 aPlsqlItem.SOLD_TO_ORG_ID := aSqlItem.SOLD_TO_ORG_ID;
657 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
658 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
659 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
660 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
661 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
662 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
663 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
664 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
665 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
666 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
667 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
668 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
669 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
670 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
671 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
672 aPlsqlItem.CANCELLED_FLAG := aSqlItem.CANCELLED_FLAG;
673 aPlsqlItem.CLOSED_FLAG := aSqlItem.CLOSED_FLAG;
674 aPlsqlItem.CONVERSION_RATE := aSqlItem.CONVERSION_RATE;
675 aPlsqlItem.CONVERSION_RATE_DATE := aSqlItem.CONVERSION_RATE_DATE;
676 aPlsqlItem.CONVERSION_TYPE := aSqlItem.CONVERSION_TYPE;
677 aPlsqlItem.CONVERSION_TYPE_CODE := aSqlItem.CONVERSION_TYPE_CODE;
678 aPlsqlItem.CUST_PO_NUMBER := aSqlItem.CUST_PO_NUMBER;
679 aPlsqlItem.CUSTOMER_ID := aSqlItem.CUSTOMER_ID;
680 aPlsqlItem.CUSTOMER_NAME := aSqlItem.CUSTOMER_NAME;
681 aPlsqlItem.CUSTOMER_NUMBER := aSqlItem.CUSTOMER_NUMBER;
682 aPlsqlItem.DELIVER_TO_CONTACT := aSqlItem.DELIVER_TO_CONTACT;
683 aPlsqlItem.DELIVER_TO_CONTACT_ID := aSqlItem.DELIVER_TO_CONTACT_ID;
684 aPlsqlItem.DELIVER_TO_CUSTOMER := aSqlItem.DELIVER_TO_CUSTOMER;
685 aPlsqlItem.DELIVER_TO_CUSTOMER_NUMBER := aSqlItem.DELIVER_TO_CUSTOMER_NUMBER;
686 aPlsqlItem.DELIVER_TO_ORG := aSqlItem.DELIVER_TO_ORG;
687 aPlsqlItem.DELIVER_TO_ORG_ID := aSqlItem.DELIVER_TO_ORG_ID;
688 aPlsqlItem.DEMAND_CLASS := aSqlItem.DEMAND_CLASS;
689 aPlsqlItem.DEMAND_CLASS_CODE := aSqlItem.DEMAND_CLASS_CODE;
690 aPlsqlItem.EARLIEST_SCHEDULE_LIMIT := aSqlItem.EARLIEST_SCHEDULE_LIMIT;
691 aPlsqlItem.LATEST_SCHEDULE_LIMIT := aSqlItem.LATEST_SCHEDULE_LIMIT;
692 aPlsqlItem.ERROR_FLAG := aSqlItem.ERROR_FLAG;
693 aPlsqlItem.EXPIRATION_DATE := aSqlItem.EXPIRATION_DATE;
694 aPlsqlItem.FOB_POINT := aSqlItem.FOB_POINT;
695 aPlsqlItem.FOB_POINT_CODE := aSqlItem.FOB_POINT_CODE;
696 aPlsqlItem.FREIGHT_CARRIER_CODE := aSqlItem.FREIGHT_CARRIER_CODE;
697 aPlsqlItem.FREIGHT_TERMS := aSqlItem.FREIGHT_TERMS;
698 aPlsqlItem.FREIGHT_TERMS_CODE := aSqlItem.FREIGHT_TERMS_CODE;
699 aPlsqlItem.GLOBAL_ATTRIBUTE_CATEGORY := aSqlItem.GLOBAL_ATTRIBUTE_CATEGORY;
700 aPlsqlItem.GLOBAL_ATTRIBUTE1 := aSqlItem.GLOBAL_ATTRIBUTE1;
701 aPlsqlItem.GLOBAL_ATTRIBUTE2 := aSqlItem.GLOBAL_ATTRIBUTE2;
702 aPlsqlItem.GLOBAL_ATTRIBUTE3 := aSqlItem.GLOBAL_ATTRIBUTE3;
703 aPlsqlItem.GLOBAL_ATTRIBUTE4 := aSqlItem.GLOBAL_ATTRIBUTE4;
704 aPlsqlItem.GLOBAL_ATTRIBUTE5 := aSqlItem.GLOBAL_ATTRIBUTE5;
705 aPlsqlItem.GLOBAL_ATTRIBUTE6 := aSqlItem.GLOBAL_ATTRIBUTE6;
706 aPlsqlItem.GLOBAL_ATTRIBUTE7 := aSqlItem.GLOBAL_ATTRIBUTE7;
707 aPlsqlItem.GLOBAL_ATTRIBUTE8 := aSqlItem.GLOBAL_ATTRIBUTE8;
708 aPlsqlItem.GLOBAL_ATTRIBUTE9 := aSqlItem.GLOBAL_ATTRIBUTE9;
709 aPlsqlItem.GLOBAL_ATTRIBUTE10 := aSqlItem.GLOBAL_ATTRIBUTE10;
710 aPlsqlItem.GLOBAL_ATTRIBUTE11 := aSqlItem.GLOBAL_ATTRIBUTE11;
711 aPlsqlItem.DELIVER_TO_STATE := aSqlItem.DELIVER_TO_STATE;
712 aPlsqlItem.SOLD_TO_LOCATION_STATE := aSqlItem.SOLD_TO_LOCATION_STATE;
713 aPlsqlItem.SOLD_TO_LOCATION_COUNTY := aSqlItem.SOLD_TO_LOCATION_COUNTY;
714 aPlsqlItem.SOLD_TO_LOCATION_PROVINCE := aSqlItem.SOLD_TO_LOCATION_PROVINCE;
715 aPlsqlItem.HEADER_ID := aSqlItem.HEADER_ID;
716 aPlsqlItem.ORIG_SYS_DOCUMENT_REF := aSqlItem.ORIG_SYS_DOCUMENT_REF;
717 aPlsqlItem.ORDER_NUMBER := aSqlItem.ORDER_NUMBER;
718 aPlsqlItem.ORDERED_DATE := aSqlItem.ORDERED_DATE;
719 aPlsqlItem.ORG_ID := aSqlItem.ORG_ID;
720 aPlsqlItem.CHANGE_DATE := aSqlItem.CHANGE_DATE;
721 aPlsqlItem.CHANGE_SEQUENCE := aSqlItem.CHANGE_SEQUENCE;
722 aPlsqlItem.ACCOUNTING_RULE_ID := aSqlItem.ACCOUNTING_RULE_ID;
723 aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;
724 aPlsqlItem.ACKNOWLEDGMENT_FLAG := aSqlItem.ACKNOWLEDGMENT_FLAG;
725 RETURN aPlsqlItem;
726 END SQL_TO_PL2;
727 FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)
728 RETURN OE_SYNC_ORDER_PVT_HEADER_ACK_ IS
729 aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_;
730 BEGIN
731 -- initialize the table
732 aSqlItem := OE_SYNC_ORDER_PVT_HEADER_ACK_();
733 aSqlItem.EXTEND(aPlsqlItem.COUNT);
734 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
735 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL2(aPlsqlItem(I));
736 END LOOP;
737 RETURN aSqlItem;
738 END PL_TO_SQL0;
739 FUNCTION SQL_TO_PL0(aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_)
740 RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE IS
741 aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
742 BEGIN
743 FOR I IN 1..aSqlItem.COUNT LOOP
744 aPlsqlItem(I) := SQL_TO_PL2(aSqlItem(I));
745 END LOOP;
746 RETURN aPlsqlItem;
747 END SQL_TO_PL0;
748 FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
749 RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS
750 aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;
751 BEGIN
752 -- initialize the object
753 aSqlItem := OE_ACKNOWLEDGMENT_PUB_LINE_AC(NULL, NULL, NULL, NULL,
754 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
755 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
756 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
757 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
758 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
759 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
760 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
761 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
762 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
763 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
764 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
765 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
766 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
767 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
768 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
769 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
770 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
771 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
772 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
773 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
774 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
775 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
776 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
777 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
778 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
779 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
780 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
781 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
782 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
783 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
784 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
785 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
786 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
787 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
788 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
789 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
790 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
791 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
792 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
793 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
794 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
795 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
796 NULL);
797
798 aSqlItem.END_CUSTOMER_CONTACT_LAST_NAME := aPlsqlItem.END_CUSTOMER_CONTACT_LAST_NAME;
799 aSqlItem.END_CUSTOMER_CONTACT_FIRST_NAM := aPlsqlItem.END_CUSTOMER_CONTACT_FIRST_NAM;
800 aSqlItem.END_CUSTOMER_NAME := aPlsqlItem.END_CUSTOMER_NAME;
801 aSqlItem.IB_OWNER := aPlsqlItem.IB_OWNER;
802 aSqlItem.IB_CURRENT_LOCATION := aPlsqlItem.IB_CURRENT_LOCATION;
803 aSqlItem.IB_INSTALLED_AT_LOCATION := aPlsqlItem.IB_INSTALLED_AT_LOCATION;
804 aSqlItem.ORDER_FIRMED_DATE := aPlsqlItem.ORDER_FIRMED_DATE;
805 aSqlItem.ACTUAL_FULFILLMENT_DATE := aPlsqlItem.ACTUAL_FULFILLMENT_DATE;
806 aSqlItem.COMMITMENT := aPlsqlItem.COMMITMENT;
807 aSqlItem.CUSTOMER_PAYMENT_TERM := aPlsqlItem.CUSTOMER_PAYMENT_TERM;
808 aSqlItem.DELIVER_TO_ADDRESS1 := aPlsqlItem.DELIVER_TO_ADDRESS1;
809 aSqlItem.DELIVER_TO_ADDRESS2 := aPlsqlItem.DELIVER_TO_ADDRESS2;
810 aSqlItem.DELIVER_TO_ADDRESS3 := aPlsqlItem.DELIVER_TO_ADDRESS3;
811 aSqlItem.DELIVER_TO_ADDRESS4 := aPlsqlItem.DELIVER_TO_ADDRESS4;
812 aSqlItem.DELIVER_TO_CITY := aPlsqlItem.DELIVER_TO_CITY;
813 aSqlItem.DELIVER_TO_COUNTRY := aPlsqlItem.DELIVER_TO_COUNTRY;
814 aSqlItem.DELIVER_TO_COUNTY := aPlsqlItem.DELIVER_TO_COUNTY;
815 aSqlItem.DELIVER_TO_POSTAL_CODE := aPlsqlItem.DELIVER_TO_POSTAL_CODE;
816 aSqlItem.DELIVER_TO_PROVINCE := aPlsqlItem.DELIVER_TO_PROVINCE;
817 aSqlItem.DELIVER_TO_STATE := aPlsqlItem.DELIVER_TO_STATE;
818 aSqlItem.INVOICE_ADDRESS_1 := aPlsqlItem.INVOICE_ADDRESS_1;
819 aSqlItem.INVOICE_ADDRESS_2 := aPlsqlItem.INVOICE_ADDRESS_2;
820 aSqlItem.INVOICE_ADDRESS_3 := aPlsqlItem.INVOICE_ADDRESS_3;
821 aSqlItem.INVOICE_ADDRESS_4 := aPlsqlItem.INVOICE_ADDRESS_4;
822 aSqlItem.INVOICE_COUNTRY := aPlsqlItem.INVOICE_COUNTRY;
823 aSqlItem.INVOICE_COUNTY := aPlsqlItem.INVOICE_COUNTY;
824 aSqlItem.INVOICE_POSTAL_CODE := aPlsqlItem.INVOICE_POSTAL_CODE;
825 aSqlItem.INVOICE_STATE := aPlsqlItem.INVOICE_STATE;
826 aSqlItem.IB_OWNER_CODE := aPlsqlItem.IB_OWNER_CODE;
827 aSqlItem.IB_CURRENT_LOCATION_CODE := aPlsqlItem.IB_CURRENT_LOCATION_CODE;
828 aSqlItem.IB_INSTALLED_AT_LOCATION_CODE := aPlsqlItem.IB_INSTALLED_AT_LOCATION_CODE;
829 aSqlItem.CONFIG_REV_NBR := aPlsqlItem.CONFIG_REV_NBR;
830 aSqlItem.CONFIG_HEADER_ID := aPlsqlItem.CONFIG_HEADER_ID;
831 aSqlItem.SHIP_FROM_ADDRESS_1 := aPlsqlItem.SHIP_FROM_ADDRESS_1;
832 aSqlItem.SHIP_FROM_ADDRESS_2 := aPlsqlItem.SHIP_FROM_ADDRESS_2;
833 aSqlItem.SHIP_FROM_ADDRESS_3 := aPlsqlItem.SHIP_FROM_ADDRESS_3;
834 aSqlItem.SHIP_FROM_CITY := aPlsqlItem.SHIP_FROM_CITY;
835 aSqlItem.SHIP_FROM_POSTAL_CODE := aPlsqlItem.SHIP_FROM_POSTAL_CODE;
836 aSqlItem.SHIP_FROM_COUNTRY := aPlsqlItem.SHIP_FROM_COUNTRY;
837 aSqlItem.SHIP_FROM_EDI_LOCATION_CODE := aPlsqlItem.SHIP_FROM_EDI_LOCATION_CODE;
838 aSqlItem.SHIP_FROM_REGION1 := aPlsqlItem.SHIP_FROM_REGION1;
839 aSqlItem.SHIP_FROM_REGION2 := aPlsqlItem.SHIP_FROM_REGION2;
840 aSqlItem.SHIP_FROM_REGION3 := aPlsqlItem.SHIP_FROM_REGION3;
841 aSqlItem.SHIP_FROM_ADDRESS_ID := aPlsqlItem.SHIP_FROM_ADDRESS_ID;
842 aSqlItem.SHIP_TO_ADDRESS_CODE := aPlsqlItem.SHIP_TO_ADDRESS_CODE;
843 aSqlItem.SHIP_TO_ADDRESS_NAME := aPlsqlItem.SHIP_TO_ADDRESS_NAME;
844 aSqlItem.SHIP_TO_ADDRESS_ID := aPlsqlItem.SHIP_TO_ADDRESS_ID;
845 aSqlItem.INVOICE_ADDRESS_CODE := aPlsqlItem.INVOICE_ADDRESS_CODE;
846 aSqlItem.INVOICE_ADDRESS_NAME := aPlsqlItem.INVOICE_ADDRESS_NAME;
847 aSqlItem.DELIVER_TO_CUSTOMER := aPlsqlItem.DELIVER_TO_CUSTOMER;
848 aSqlItem.SERVICED_LINE_ID := aPlsqlItem.SERVICED_LINE_ID;
849 aSqlItem.SERVICE_REFERENCE_ORDER := aPlsqlItem.SERVICE_REFERENCE_ORDER;
850 aSqlItem.SERVICE_REFERENCE_LINE := aPlsqlItem.SERVICE_REFERENCE_LINE;
851 aSqlItem.SERVICE_REFERENCE_SYSTEM := aPlsqlItem.SERVICE_REFERENCE_SYSTEM;
852 aSqlItem.TP_CONTEXT := aPlsqlItem.TP_CONTEXT;
853 aSqlItem.TP_ATTRIBUTE1 := aPlsqlItem.TP_ATTRIBUTE1;
854 aSqlItem.TP_ATTRIBUTE2 := aPlsqlItem.TP_ATTRIBUTE2;
855 aSqlItem.TP_ATTRIBUTE3 := aPlsqlItem.TP_ATTRIBUTE3;
856 aSqlItem.TP_ATTRIBUTE4 := aPlsqlItem.TP_ATTRIBUTE4;
857 aSqlItem.TP_ATTRIBUTE5 := aPlsqlItem.TP_ATTRIBUTE5;
858 aSqlItem.TP_ATTRIBUTE6 := aPlsqlItem.TP_ATTRIBUTE6;
859 aSqlItem.TP_ATTRIBUTE7 := aPlsqlItem.TP_ATTRIBUTE7;
860 aSqlItem.TP_ATTRIBUTE8 := aPlsqlItem.TP_ATTRIBUTE8;
861 aSqlItem.TP_ATTRIBUTE9 := aPlsqlItem.TP_ATTRIBUTE9;
862 aSqlItem.TP_ATTRIBUTE10 := aPlsqlItem.TP_ATTRIBUTE10;
863 aSqlItem.TP_ATTRIBUTE11 := aPlsqlItem.TP_ATTRIBUTE11;
864 aSqlItem.TP_ATTRIBUTE12 := aPlsqlItem.TP_ATTRIBUTE12;
865 aSqlItem.TP_ATTRIBUTE13 := aPlsqlItem.TP_ATTRIBUTE13;
866 aSqlItem.TP_ATTRIBUTE14 := aPlsqlItem.TP_ATTRIBUTE14;
867 aSqlItem.TP_ATTRIBUTE15 := aPlsqlItem.TP_ATTRIBUTE15;
868 aSqlItem.SPLIT_FROM_SHIPMENT_REF := aPlsqlItem.SPLIT_FROM_SHIPMENT_REF;
869 aSqlItem.SHIP_TO_CUSTOMER_ID := aPlsqlItem.SHIP_TO_CUSTOMER_ID;
870 aSqlItem.INVOICE_TO_CUSTOMER_ID := aPlsqlItem.INVOICE_TO_CUSTOMER_ID;
871 aSqlItem.UNIT_SELLING_PRICE_PER_PQTY := aPlsqlItem.UNIT_SELLING_PRICE_PER_PQTY;
872 aSqlItem.DELIVER_TO_CUSTOMER_ID := aPlsqlItem.DELIVER_TO_CUSTOMER_ID;
873 aSqlItem.SHIP_TO_CUSTOMER_NAME := aPlsqlItem.SHIP_TO_CUSTOMER_NAME;
874 aSqlItem.SHIP_TO_CUSTOMER_NUMBER := aPlsqlItem.SHIP_TO_CUSTOMER_NUMBER;
875 aSqlItem.INVOICE_TO_CUSTOMER_NAME := aPlsqlItem.INVOICE_TO_CUSTOMER_NAME;
876 aSqlItem.INVOICE_TO_CUSTOMER_NUMBER := aPlsqlItem.INVOICE_TO_CUSTOMER_NUMBER;
877 aSqlItem.DELIVER_TO_CUSTOMER_NAME := aPlsqlItem.DELIVER_TO_CUSTOMER_NAME;
878 aSqlItem.DELIVER_TO_CUSTOMER_NUMBER := aPlsqlItem.DELIVER_TO_CUSTOMER_NUMBER;
879 aSqlItem.ACCOUNTING_RULE_DURATION := aPlsqlItem.ACCOUNTING_RULE_DURATION;
880 aSqlItem.ATTRIBUTE16 := aPlsqlItem.ATTRIBUTE16;
881 aSqlItem.ATTRIBUTE17 := aPlsqlItem.ATTRIBUTE17;
882 aSqlItem.ATTRIBUTE18 := aPlsqlItem.ATTRIBUTE18;
883 aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
884 aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
885 aSqlItem.ACKNOWLEDGMENT_TYPE := aPlsqlItem.ACKNOWLEDGMENT_TYPE;
886 aSqlItem.USER_ITEM_DESCRIPTION := aPlsqlItem.USER_ITEM_DESCRIPTION;
887 aSqlItem.BLANKET_NUMBER := aPlsqlItem.BLANKET_NUMBER;
888 aSqlItem.BLANKET_LINE_NUMBER := aPlsqlItem.BLANKET_LINE_NUMBER;
889 aSqlItem.ORIGINAL_INVENTORY_ITEM_ID := aPlsqlItem.ORIGINAL_INVENTORY_ITEM_ID;
890 aSqlItem.ORIGINAL_ORDERED_ITEM_ID := aPlsqlItem.ORIGINAL_ORDERED_ITEM_ID;
891 aSqlItem.ORIGINAL_ORDERED_ITEM := aPlsqlItem.ORIGINAL_ORDERED_ITEM;
892 aSqlItem.ORDERED_ITEM := aPlsqlItem.ORDERED_ITEM;
893 aSqlItem.INVOICE_INTERFACE_STATUS_CODE := aPlsqlItem.INVOICE_INTERFACE_STATUS_CODE;
894 aSqlItem.PREFERRED_GRADE := aPlsqlItem.PREFERRED_GRADE;
895 aSqlItem.ORDERED_QUANTITY2 := aPlsqlItem.ORDERED_QUANTITY2;
896 aSqlItem.ORDERED_QUANTITY_UOM2 := aPlsqlItem.ORDERED_QUANTITY_UOM2;
897 aSqlItem.SHIPPING_QUANTITY2 := aPlsqlItem.SHIPPING_QUANTITY2;
898 aSqlItem.CANCELLED_QUANTITY2 := aPlsqlItem.CANCELLED_QUANTITY2;
899 aSqlItem.SHIPPED_QUANTITY2 := aPlsqlItem.SHIPPED_QUANTITY2;
900 aSqlItem.SHIPPING_QUANTITY_UOM2 := aPlsqlItem.SHIPPING_QUANTITY_UOM2;
901 aSqlItem.FULFILLED_QUANTITY2 := aPlsqlItem.FULFILLED_QUANTITY2;
902 aSqlItem.REVENUE_AMOUNT := aPlsqlItem.REVENUE_AMOUNT;
903 aSqlItem.FULFILLMENT_DATE := aPlsqlItem.FULFILLMENT_DATE;
904 aSqlItem.ORIGINAL_ITEM_IDENTIFIER_TYPE := aPlsqlItem.ORIGINAL_ITEM_IDENTIFIER_TYPE;
905 aSqlItem.ITEM_SUBSTITUTION_TYPE_CODE := aPlsqlItem.ITEM_SUBSTITUTION_TYPE_CODE;
906 aSqlItem.AUTO_SELECTED_QUANTITY := aPlsqlItem.AUTO_SELECTED_QUANTITY;
907 aSqlItem.ORDERED_ITEM_ID := aPlsqlItem.ORDERED_ITEM_ID;
908 aSqlItem.ITEM_IDENTIFIER_TYPE := aPlsqlItem.ITEM_IDENTIFIER_TYPE;
909 aSqlItem.END_ITEM_UNIT_NUMBER := aPlsqlItem.END_ITEM_UNIT_NUMBER;
910 aSqlItem.RETURN_ATTRIBUTE13 := aPlsqlItem.RETURN_ATTRIBUTE13;
911 aSqlItem.RETURN_ATTRIBUTE14 := aPlsqlItem.RETURN_ATTRIBUTE14;
912 aSqlItem.RETURN_ATTRIBUTE15 := aPlsqlItem.RETURN_ATTRIBUTE15;
913 aSqlItem.RETURN_ATTRIBUTE2 := aPlsqlItem.RETURN_ATTRIBUTE2;
914 aSqlItem.RETURN_ATTRIBUTE3 := aPlsqlItem.RETURN_ATTRIBUTE3;
915 aSqlItem.RETURN_ATTRIBUTE4 := aPlsqlItem.RETURN_ATTRIBUTE4;
916 aSqlItem.RETURN_ATTRIBUTE5 := aPlsqlItem.RETURN_ATTRIBUTE5;
917 aSqlItem.RETURN_ATTRIBUTE6 := aPlsqlItem.RETURN_ATTRIBUTE6;
918 aSqlItem.RETURN_ATTRIBUTE7 := aPlsqlItem.RETURN_ATTRIBUTE7;
919 aSqlItem.RETURN_ATTRIBUTE8 := aPlsqlItem.RETURN_ATTRIBUTE8;
920 aSqlItem.RETURN_ATTRIBUTE9 := aPlsqlItem.RETURN_ATTRIBUTE9;
921 aSqlItem.RETURN_CONTEXT := aPlsqlItem.RETURN_CONTEXT;
922 aSqlItem.RETURN_REASON_CODE := aPlsqlItem.RETURN_REASON_CODE;
923 aSqlItem.RLA_SCHEDULE_TYPE_CODE := aPlsqlItem.RLA_SCHEDULE_TYPE_CODE;
924 aSqlItem.SALESREP_ID := aPlsqlItem.SALESREP_ID;
925 aSqlItem.SALESREP := aPlsqlItem.SALESREP;
926 aSqlItem.SCHEDULE_ARRIVAL_DATE := aPlsqlItem.SCHEDULE_ARRIVAL_DATE;
927 aSqlItem.SCHEDULE_SHIP_DATE := aPlsqlItem.SCHEDULE_SHIP_DATE;
928 aSqlItem.SCHEDULE_ITEM_DETAIL := aPlsqlItem.SCHEDULE_ITEM_DETAIL;
929 aSqlItem.SCHEDULE_STATUS_CODE := aPlsqlItem.SCHEDULE_STATUS_CODE;
930 aSqlItem.SHIP_MODEL_COMPLETE_FLAG := aPlsqlItem.SHIP_MODEL_COMPLETE_FLAG;
931 aSqlItem.SHIP_SET_ID := aPlsqlItem.SHIP_SET_ID;
932 aSqlItem.SHIP_SET_NAME := aPlsqlItem.SHIP_SET_NAME;
933 aSqlItem.SHIP_TO_ADDRESS1 := aPlsqlItem.SHIP_TO_ADDRESS1;
934 aSqlItem.SHIP_TO_ADDRESS2 := aPlsqlItem.SHIP_TO_ADDRESS2;
935 aSqlItem.SHIP_TO_ADDRESS3 := aPlsqlItem.SHIP_TO_ADDRESS3;
936 aSqlItem.SHIP_TO_ADDRESS4 := aPlsqlItem.SHIP_TO_ADDRESS4;
937 aSqlItem.SHIP_TO_CITY := aPlsqlItem.SHIP_TO_CITY;
938 aSqlItem.SHIP_TO_CONTACT := aPlsqlItem.SHIP_TO_CONTACT;
939 aSqlItem.SHIP_TO_CONTACT_AREA_CODE1 := aPlsqlItem.SHIP_TO_CONTACT_AREA_CODE1;
940 aSqlItem.SHIP_TO_CONTACT_AREA_CODE2 := aPlsqlItem.SHIP_TO_CONTACT_AREA_CODE2;
941 aSqlItem.SHIP_TO_CONTACT_AREA_CODE3 := aPlsqlItem.SHIP_TO_CONTACT_AREA_CODE3;
942 aSqlItem.SHIP_TO_CONTACT_FIRST_NAME := aPlsqlItem.SHIP_TO_CONTACT_FIRST_NAME;
943 aSqlItem.SHIP_TO_CONTACT_ID := aPlsqlItem.SHIP_TO_CONTACT_ID;
944 aSqlItem.SHIP_TO_CONTACT_JOB_TITLE := aPlsqlItem.SHIP_TO_CONTACT_JOB_TITLE;
945 aSqlItem.SHIP_TO_CONTACT_LAST_NAME := aPlsqlItem.SHIP_TO_CONTACT_LAST_NAME;
946 aSqlItem.SHIP_TO_COUNTRY := aPlsqlItem.SHIP_TO_COUNTRY;
947 aSqlItem.SHIP_TO_COUNTY := aPlsqlItem.SHIP_TO_COUNTY;
948 aSqlItem.SHIP_TO_POSTAL_CODE := aPlsqlItem.SHIP_TO_POSTAL_CODE;
949 aSqlItem.SHIP_TO_STATE := aPlsqlItem.SHIP_TO_STATE;
950 aSqlItem.SHIP_TOLERANCE_ABOVE := aPlsqlItem.SHIP_TOLERANCE_ABOVE;
951 aSqlItem.SHIP_TOLERANCE_BELOW := aPlsqlItem.SHIP_TOLERANCE_BELOW;
952 aSqlItem.SHIPMENT_NUMBER := aPlsqlItem.SHIPMENT_NUMBER;
953 aSqlItem.SHIPMENT_PRIORITY := aPlsqlItem.SHIPMENT_PRIORITY;
954 aSqlItem.SHIPMENT_PRIORITY_CODE := aPlsqlItem.SHIPMENT_PRIORITY_CODE;
955 aSqlItem.SHIPPED_QUANTITY := aPlsqlItem.SHIPPED_QUANTITY;
956 aSqlItem.SHIPPING_METHOD := aPlsqlItem.SHIPPING_METHOD;
957 aSqlItem.SHIPPING_METHOD_CODE := aPlsqlItem.SHIPPING_METHOD_CODE;
958 aSqlItem.SHIPPING_QUANTITY := aPlsqlItem.SHIPPING_QUANTITY;
959 aSqlItem.SHIPPING_QUANTITY_UOM := aPlsqlItem.SHIPPING_QUANTITY_UOM;
960 aSqlItem.SORT_ORDER := aPlsqlItem.SORT_ORDER;
961 aSqlItem.SOURCE_DOCUMENT_ID := aPlsqlItem.SOURCE_DOCUMENT_ID;
962 aSqlItem.SOURCE_DOCUMENT_LINE_ID := aPlsqlItem.SOURCE_DOCUMENT_LINE_ID;
963 aSqlItem.SOURCE_DOCUMENT_TYPE_ID := aPlsqlItem.SOURCE_DOCUMENT_TYPE_ID;
964 aSqlItem.SOURCE_TYPE_CODE := aPlsqlItem.SOURCE_TYPE_CODE;
965 aSqlItem.SPLIT_FROM_LINE_ID := aPlsqlItem.SPLIT_FROM_LINE_ID;
966 aSqlItem.SUBINVENTORY := aPlsqlItem.SUBINVENTORY;
967 aSqlItem.SUBMISSION_DATETIME := aPlsqlItem.SUBMISSION_DATETIME;
968 aSqlItem.TASK := aPlsqlItem.TASK;
969 aSqlItem.TASK_ID := aPlsqlItem.TASK_ID;
970 aSqlItem.TAX := aPlsqlItem.TAX;
971 aSqlItem.TAX_CODE := aPlsqlItem.TAX_CODE;
972 aSqlItem.TAX_DATE := aPlsqlItem.TAX_DATE;
973 aSqlItem.TAX_EXEMPT_FLAG := aPlsqlItem.TAX_EXEMPT_FLAG;
974 aSqlItem.TAX_EXEMPT_NUMBER := aPlsqlItem.TAX_EXEMPT_NUMBER;
975 aSqlItem.TAX_EXEMPT_REASON := aPlsqlItem.TAX_EXEMPT_REASON;
976 aSqlItem.TAX_EXEMPT_REASON_CODE := aPlsqlItem.TAX_EXEMPT_REASON_CODE;
977 aSqlItem.TAX_POINT := aPlsqlItem.TAX_POINT;
978 aSqlItem.TAX_POINT_CODE := aPlsqlItem.TAX_POINT_CODE;
979 aSqlItem.TAX_RATE := aPlsqlItem.TAX_RATE;
980 aSqlItem.TAX_VALUE := aPlsqlItem.TAX_VALUE;
981 aSqlItem.UNIT_LIST_PRICE := aPlsqlItem.UNIT_LIST_PRICE;
982 aSqlItem.UNIT_SELLING_PRICE := aPlsqlItem.UNIT_SELLING_PRICE;
983 aSqlItem.VEH_CUS_ITEM_CUM_KEY_ID := aPlsqlItem.VEH_CUS_ITEM_CUM_KEY_ID;
984 aSqlItem.VISIBLE_DEMAND_FLAG := aPlsqlItem.VISIBLE_DEMAND_FLAG;
985 aSqlItem.CUSTOMER_LINE_NUMBER := aPlsqlItem.CUSTOMER_LINE_NUMBER;
986 aSqlItem.CUSTOMER_SHIPMENT_NUMBER := aPlsqlItem.CUSTOMER_SHIPMENT_NUMBER;
987 aSqlItem.CUSTOMER_ITEM_NET_PRICE := aPlsqlItem.CUSTOMER_ITEM_NET_PRICE;
988 aSqlItem.CUSTOMER_PAYMENT_TERM_ID := aPlsqlItem.CUSTOMER_PAYMENT_TERM_ID;
989 aSqlItem.DROP_SHIP_FLAG := aPlsqlItem.DROP_SHIP_FLAG;
990 aSqlItem.SPLIT_FROM_LINE_REF := aPlsqlItem.SPLIT_FROM_LINE_REF;
991 aSqlItem.SHIP_TO_EDI_LOCATION_CODE := aPlsqlItem.SHIP_TO_EDI_LOCATION_CODE;
992 aSqlItem.SERVICE_TXN_REASON_CODE := aPlsqlItem.SERVICE_TXN_REASON_CODE;
993 aSqlItem.SERVICE_TXN_COMMENTS := aPlsqlItem.SERVICE_TXN_COMMENTS;
994 aSqlItem.SERVICE_DURATION := aPlsqlItem.SERVICE_DURATION;
995 aSqlItem.SERVICE_START_DATE := aPlsqlItem.SERVICE_START_DATE;
996 aSqlItem.SERVICE_END_DATE := aPlsqlItem.SERVICE_END_DATE;
997 aSqlItem.SERVICE_COTERMINATE_FLAG := aPlsqlItem.SERVICE_COTERMINATE_FLAG;
998 aSqlItem.SERVICE_NUMBER := aPlsqlItem.SERVICE_NUMBER;
999 aSqlItem.SERVICE_PERIOD := aPlsqlItem.SERVICE_PERIOD;
1000 aSqlItem.SERVICE_REFERENCE_TYPE_CODE := aPlsqlItem.SERVICE_REFERENCE_TYPE_CODE;
1001 aSqlItem.SERVICE_REFERENCE_LINE_ID := aPlsqlItem.SERVICE_REFERENCE_LINE_ID;
1002 aSqlItem.SERVICE_REFERENCE_SYSTEM_ID := aPlsqlItem.SERVICE_REFERENCE_SYSTEM_ID;
1003 aSqlItem.CREDIT_INVOICE_LINE_ID := aPlsqlItem.CREDIT_INVOICE_LINE_ID;
1004 aSqlItem.SHIP_TO_PROVINCE := aPlsqlItem.SHIP_TO_PROVINCE;
1005 aSqlItem.INVOICE_PROVINCE := aPlsqlItem.INVOICE_PROVINCE;
1006 aSqlItem.BILL_TO_EDI_LOCATION_CODE := aPlsqlItem.BILL_TO_EDI_LOCATION_CODE;
1007 aSqlItem.INVOICE_CITY := aPlsqlItem.INVOICE_CITY;
1008 aSqlItem.INVENTORY_ITEM_SEGMENT_17 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_17;
1009 aSqlItem.INVENTORY_ITEM_SEGMENT_18 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_18;
1010 aSqlItem.INVENTORY_ITEM_SEGMENT_19 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_19;
1011 aSqlItem.INVENTORY_ITEM_SEGMENT_2 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_2;
1012 aSqlItem.INVENTORY_ITEM_SEGMENT_20 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_20;
1013 aSqlItem.INVENTORY_ITEM_SEGMENT_3 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_3;
1014 aSqlItem.INVENTORY_ITEM_SEGMENT_4 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_4;
1015 aSqlItem.INVENTORY_ITEM_SEGMENT_5 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_5;
1016 aSqlItem.INVENTORY_ITEM_SEGMENT_6 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_6;
1017 aSqlItem.INVENTORY_ITEM_SEGMENT_7 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_7;
1018 aSqlItem.INVENTORY_ITEM_SEGMENT_8 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_8;
1019 aSqlItem.INVENTORY_ITEM_SEGMENT_9 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_9;
1020 aSqlItem.INVOICE_COMPLETE_FLAG := aPlsqlItem.INVOICE_COMPLETE_FLAG;
1021 aSqlItem.INVOICE_SET_ID := aPlsqlItem.INVOICE_SET_ID;
1022 aSqlItem.INVOICE_SET_NAME := aPlsqlItem.INVOICE_SET_NAME;
1023 aSqlItem.INVOICE_NUMBER := aPlsqlItem.INVOICE_NUMBER;
1024 aSqlItem.INVOICE_TO_CONTACT := aPlsqlItem.INVOICE_TO_CONTACT;
1025 aSqlItem.INVOICE_TO_CONTACT_ID := aPlsqlItem.INVOICE_TO_CONTACT_ID;
1026 aSqlItem.INVOICE_TO_ORG := aPlsqlItem.INVOICE_TO_ORG;
1027 aSqlItem.INVOICE_TO_ORG_ID := aPlsqlItem.INVOICE_TO_ORG_ID;
1028 aSqlItem.INVOICE_TOLERANCE_ABOVE := aPlsqlItem.INVOICE_TOLERANCE_ABOVE;
1029 aSqlItem.INVOICE_TOLERANCE_BELOW := aPlsqlItem.INVOICE_TOLERANCE_BELOW;
1030 aSqlItem.INVOICING_RULE := aPlsqlItem.INVOICING_RULE;
1031 aSqlItem.INVOICING_RULE_ID := aPlsqlItem.INVOICING_RULE_ID;
1032 aSqlItem.ITEM_INPUT := aPlsqlItem.ITEM_INPUT;
1033 aSqlItem.ITEM_REVISION := aPlsqlItem.ITEM_REVISION;
1034 aSqlItem.ITEM_TYPE_CODE := aPlsqlItem.ITEM_TYPE_CODE;
1035 aSqlItem.LATEST_ACCEPTABLE_DATE := aPlsqlItem.LATEST_ACCEPTABLE_DATE;
1036 aSqlItem.LINE_CATEGORY_CODE := aPlsqlItem.LINE_CATEGORY_CODE;
1037 aSqlItem.LINE_ID := aPlsqlItem.LINE_ID;
1038 aSqlItem.LINE_NUMBER := aPlsqlItem.LINE_NUMBER;
1039 aSqlItem.LINE_PO_CONTEXT := aPlsqlItem.LINE_PO_CONTEXT;
1040 aSqlItem.LINE_TYPE := aPlsqlItem.LINE_TYPE;
1041 aSqlItem.LINE_TYPE_ID := aPlsqlItem.LINE_TYPE_ID;
1042 aSqlItem.LINK_TO_LINE_ID := aPlsqlItem.LINK_TO_LINE_ID;
1043 aSqlItem.LINK_TO_LINE_REF := aPlsqlItem.LINK_TO_LINE_REF;
1044 aSqlItem.LOAD_SEQ_NUMBER := aPlsqlItem.LOAD_SEQ_NUMBER;
1045 aSqlItem.LOT := aPlsqlItem.LOT;
1046 aSqlItem.MATERIAL_COST := aPlsqlItem.MATERIAL_COST;
1047 aSqlItem.MATERIAL_OVERHEAD_COST := aPlsqlItem.MATERIAL_OVERHEAD_COST;
1048 aSqlItem.MODEL_GROUP_NUMBER := aPlsqlItem.MODEL_GROUP_NUMBER;
1049 aSqlItem.OPEN_FLAG := aPlsqlItem.OPEN_FLAG;
1050 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1051 aSqlItem.OPTION_FLAG := aPlsqlItem.OPTION_FLAG;
1052 aSqlItem.OPTION_NUMBER := aPlsqlItem.OPTION_NUMBER;
1053 aSqlItem.ORDER_QUANTITY_UOM := aPlsqlItem.ORDER_QUANTITY_UOM;
1054 aSqlItem.ORDER_SOURCE := aPlsqlItem.ORDER_SOURCE;
1055 aSqlItem.ORDER_SOURCE_ID := aPlsqlItem.ORDER_SOURCE_ID;
1056 aSqlItem.ORDERED_QUANTITY := aPlsqlItem.ORDERED_QUANTITY;
1057 aSqlItem.ORG_ID := aPlsqlItem.ORG_ID;
1058 aSqlItem.OUTSIDE_PROCESSING_COST := aPlsqlItem.OUTSIDE_PROCESSING_COST;
1059 aSqlItem.ORIG_SYS_SHIPMENT_REF := aPlsqlItem.ORIG_SYS_SHIPMENT_REF;
1060 aSqlItem.OVER_SHIP_REASON_CODE := aPlsqlItem.OVER_SHIP_REASON_CODE;
1061 aSqlItem.OVER_SHIP_RESOLVED_FLAG := aPlsqlItem.OVER_SHIP_RESOLVED_FLAG;
1062 aSqlItem.OVERHEAD_COST := aPlsqlItem.OVERHEAD_COST;
1063 aSqlItem.PAYMENT_TERM := aPlsqlItem.PAYMENT_TERM;
1064 aSqlItem.PAYMENT_TERM_ID := aPlsqlItem.PAYMENT_TERM_ID;
1065 aSqlItem.PAYMENT_TRX := aPlsqlItem.PAYMENT_TRX;
1066 aSqlItem.PAYMENT_TRX_ID := aPlsqlItem.PAYMENT_TRX_ID;
1067 aSqlItem.PLANNING_PROD_SEQ_NUM := aPlsqlItem.PLANNING_PROD_SEQ_NUM;
1068 aSqlItem.PRICING_ATTRIBUTE1 := aPlsqlItem.PRICING_ATTRIBUTE1;
1069 aSqlItem.PRICING_ATTRIBUTE10 := aPlsqlItem.PRICING_ATTRIBUTE10;
1070 aSqlItem.PRICING_ATTRIBUTE2 := aPlsqlItem.PRICING_ATTRIBUTE2;
1071 aSqlItem.PRICING_ATTRIBUTE3 := aPlsqlItem.PRICING_ATTRIBUTE3;
1072 aSqlItem.PRICING_ATTRIBUTE4 := aPlsqlItem.PRICING_ATTRIBUTE4;
1073 aSqlItem.PRICING_ATTRIBUTE5 := aPlsqlItem.PRICING_ATTRIBUTE5;
1074 aSqlItem.PRICING_ATTRIBUTE6 := aPlsqlItem.PRICING_ATTRIBUTE6;
1075 aSqlItem.PRICING_ATTRIBUTE7 := aPlsqlItem.PRICING_ATTRIBUTE7;
1076 aSqlItem.PRICING_ATTRIBUTE8 := aPlsqlItem.PRICING_ATTRIBUTE8;
1077 aSqlItem.PRICING_ATTRIBUTE9 := aPlsqlItem.PRICING_ATTRIBUTE9;
1078 aSqlItem.PRICING_CONTEXT := aPlsqlItem.PRICING_CONTEXT;
1079 aSqlItem.PRICING_DATE := aPlsqlItem.PRICING_DATE;
1080 aSqlItem.PRICING_QUANTITY := aPlsqlItem.PRICING_QUANTITY;
1081 aSqlItem.PRICING_QUANTITY_UOM := aPlsqlItem.PRICING_QUANTITY_UOM;
1082 aSqlItem.PROGRAM := aPlsqlItem.PROGRAM;
1083 aSqlItem.PROGRAM_APPLICATION := aPlsqlItem.PROGRAM_APPLICATION;
1084 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
1085 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
1086 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
1087 aSqlItem.PROJECT := aPlsqlItem.PROJECT;
1088 aSqlItem.PROJECT_ID := aPlsqlItem.PROJECT_ID;
1089 aSqlItem.PROMISE_DATE := aPlsqlItem.PROMISE_DATE;
1090 aSqlItem.REFERENCE_HEADER := aPlsqlItem.REFERENCE_HEADER;
1091 aSqlItem.REFERENCE_HEADER_ID := aPlsqlItem.REFERENCE_HEADER_ID;
1092 aSqlItem.REFERENCE_LINE := aPlsqlItem.REFERENCE_LINE;
1093 aSqlItem.REFERENCE_LINE_ID := aPlsqlItem.REFERENCE_LINE_ID;
1094 aSqlItem.REFERENCE_TYPE := aPlsqlItem.REFERENCE_TYPE;
1095 aSqlItem.RELATED_PO_NUMBER := aPlsqlItem.RELATED_PO_NUMBER;
1096 aSqlItem.REQUEST_DATE := aPlsqlItem.REQUEST_DATE;
1097 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
1098 aSqlItem.RESERVED_QUANTITY := aPlsqlItem.RESERVED_QUANTITY;
1099 aSqlItem.RESOURCE_COST := aPlsqlItem.RESOURCE_COST;
1100 aSqlItem.RETURN_ATTRIBUTE1 := aPlsqlItem.RETURN_ATTRIBUTE1;
1101 aSqlItem.RETURN_ATTRIBUTE10 := aPlsqlItem.RETURN_ATTRIBUTE10;
1102 aSqlItem.RETURN_ATTRIBUTE11 := aPlsqlItem.RETURN_ATTRIBUTE11;
1103 aSqlItem.RETURN_ATTRIBUTE12 := aPlsqlItem.RETURN_ATTRIBUTE12;
1104 aSqlItem.DELIVER_TO_CONTACT_ID := aPlsqlItem.DELIVER_TO_CONTACT_ID;
1105 aSqlItem.DELIVER_TO_ORG := aPlsqlItem.DELIVER_TO_ORG;
1106 aSqlItem.DELIVER_TO_ORG_ID := aPlsqlItem.DELIVER_TO_ORG_ID;
1107 aSqlItem.DELIVERY_LEAD_TIME := aPlsqlItem.DELIVERY_LEAD_TIME;
1108 aSqlItem.DEMAND_BUCKET_TYPE := aPlsqlItem.DEMAND_BUCKET_TYPE;
1109 aSqlItem.DEMAND_BUCKET_TYPE_CODE := aPlsqlItem.DEMAND_BUCKET_TYPE_CODE;
1110 aSqlItem.DEMAND_CLASS := aPlsqlItem.DEMAND_CLASS;
1111 aSqlItem.DEMAND_CLASS_CODE := aPlsqlItem.DEMAND_CLASS_CODE;
1112 aSqlItem.DEMAND_STREAM := aPlsqlItem.DEMAND_STREAM;
1113 aSqlItem.DEP_PLAN_REQUIRED_FLAG := aPlsqlItem.DEP_PLAN_REQUIRED_FLAG;
1114 aSqlItem.DPW_ASSIGNED_FLAG := aPlsqlItem.DPW_ASSIGNED_FLAG;
1115 aSqlItem.EARLIEST_ACCEPTABLE_DATE := aPlsqlItem.EARLIEST_ACCEPTABLE_DATE;
1116 aSqlItem.ERROR_FLAG := aPlsqlItem.ERROR_FLAG;
1117 aSqlItem.EXPLOSION_DATE := aPlsqlItem.EXPLOSION_DATE;
1118 aSqlItem.FOB_POINT := aPlsqlItem.FOB_POINT;
1119 aSqlItem.FOB_POINT_CODE := aPlsqlItem.FOB_POINT_CODE;
1120 aSqlItem.FREIGHT_CARRIER_CODE := aPlsqlItem.FREIGHT_CARRIER_CODE;
1121 aSqlItem.FREIGHT_TERMS := aPlsqlItem.FREIGHT_TERMS;
1122 aSqlItem.FREIGHT_TERMS_CODE := aPlsqlItem.FREIGHT_TERMS_CODE;
1123 aSqlItem.FULFILLED_QUANTITY := aPlsqlItem.FULFILLED_QUANTITY;
1124 aSqlItem.FULFILLMENT_SET_ID := aPlsqlItem.FULFILLMENT_SET_ID;
1125 aSqlItem.FULFILLMENT_SET_NAME := aPlsqlItem.FULFILLMENT_SET_NAME;
1126 aSqlItem.GLOBAL_ATTRIBUTE_CATEGORY := aPlsqlItem.GLOBAL_ATTRIBUTE_CATEGORY;
1127 aSqlItem.GLOBAL_ATTRIBUTE1 := aPlsqlItem.GLOBAL_ATTRIBUTE1;
1128 aSqlItem.GLOBAL_ATTRIBUTE10 := aPlsqlItem.GLOBAL_ATTRIBUTE10;
1129 aSqlItem.GLOBAL_ATTRIBUTE11 := aPlsqlItem.GLOBAL_ATTRIBUTE11;
1130 aSqlItem.GLOBAL_ATTRIBUTE12 := aPlsqlItem.GLOBAL_ATTRIBUTE12;
1131 aSqlItem.GLOBAL_ATTRIBUTE13 := aPlsqlItem.GLOBAL_ATTRIBUTE13;
1132 aSqlItem.GLOBAL_ATTRIBUTE14 := aPlsqlItem.GLOBAL_ATTRIBUTE14;
1133 aSqlItem.GLOBAL_ATTRIBUTE15 := aPlsqlItem.GLOBAL_ATTRIBUTE15;
1134 aSqlItem.GLOBAL_ATTRIBUTE16 := aPlsqlItem.GLOBAL_ATTRIBUTE16;
1135 aSqlItem.GLOBAL_ATTRIBUTE17 := aPlsqlItem.GLOBAL_ATTRIBUTE17;
1136 aSqlItem.GLOBAL_ATTRIBUTE18 := aPlsqlItem.GLOBAL_ATTRIBUTE18;
1137 aSqlItem.GLOBAL_ATTRIBUTE19 := aPlsqlItem.GLOBAL_ATTRIBUTE19;
1138 aSqlItem.GLOBAL_ATTRIBUTE2 := aPlsqlItem.GLOBAL_ATTRIBUTE2;
1139 aSqlItem.GLOBAL_ATTRIBUTE20 := aPlsqlItem.GLOBAL_ATTRIBUTE20;
1140 aSqlItem.GLOBAL_ATTRIBUTE3 := aPlsqlItem.GLOBAL_ATTRIBUTE3;
1141 aSqlItem.GLOBAL_ATTRIBUTE4 := aPlsqlItem.GLOBAL_ATTRIBUTE4;
1142 aSqlItem.GLOBAL_ATTRIBUTE5 := aPlsqlItem.GLOBAL_ATTRIBUTE5;
1143 aSqlItem.GLOBAL_ATTRIBUTE6 := aPlsqlItem.GLOBAL_ATTRIBUTE6;
1144 aSqlItem.GLOBAL_ATTRIBUTE7 := aPlsqlItem.GLOBAL_ATTRIBUTE7;
1145 aSqlItem.GLOBAL_ATTRIBUTE8 := aPlsqlItem.GLOBAL_ATTRIBUTE8;
1146 aSqlItem.GLOBAL_ATTRIBUTE9 := aPlsqlItem.GLOBAL_ATTRIBUTE9;
1147 aSqlItem.INDUSTRY_ATTRIBUTE1 := aPlsqlItem.INDUSTRY_ATTRIBUTE1;
1148 aSqlItem.INDUSTRY_ATTRIBUTE10 := aPlsqlItem.INDUSTRY_ATTRIBUTE10;
1149 aSqlItem.INDUSTRY_ATTRIBUTE11 := aPlsqlItem.INDUSTRY_ATTRIBUTE11;
1150 aSqlItem.INDUSTRY_ATTRIBUTE12 := aPlsqlItem.INDUSTRY_ATTRIBUTE12;
1151 aSqlItem.INDUSTRY_ATTRIBUTE13 := aPlsqlItem.INDUSTRY_ATTRIBUTE13;
1152 aSqlItem.INDUSTRY_ATTRIBUTE14 := aPlsqlItem.INDUSTRY_ATTRIBUTE14;
1153 aSqlItem.INDUSTRY_ATTRIBUTE15 := aPlsqlItem.INDUSTRY_ATTRIBUTE15;
1154 aSqlItem.INDUSTRY_ATTRIBUTE16 := aPlsqlItem.INDUSTRY_ATTRIBUTE16;
1155 aSqlItem.INDUSTRY_ATTRIBUTE17 := aPlsqlItem.INDUSTRY_ATTRIBUTE17;
1156 aSqlItem.INDUSTRY_ATTRIBUTE18 := aPlsqlItem.INDUSTRY_ATTRIBUTE18;
1157 aSqlItem.INDUSTRY_ATTRIBUTE19 := aPlsqlItem.INDUSTRY_ATTRIBUTE19;
1158 aSqlItem.INDUSTRY_ATTRIBUTE2 := aPlsqlItem.INDUSTRY_ATTRIBUTE2;
1159 aSqlItem.INDUSTRY_ATTRIBUTE20 := aPlsqlItem.INDUSTRY_ATTRIBUTE20;
1160 aSqlItem.INDUSTRY_ATTRIBUTE21 := aPlsqlItem.INDUSTRY_ATTRIBUTE21;
1161 aSqlItem.INDUSTRY_ATTRIBUTE22 := aPlsqlItem.INDUSTRY_ATTRIBUTE22;
1162 aSqlItem.INDUSTRY_ATTRIBUTE23 := aPlsqlItem.INDUSTRY_ATTRIBUTE23;
1163 aSqlItem.INDUSTRY_ATTRIBUTE24 := aPlsqlItem.INDUSTRY_ATTRIBUTE24;
1164 aSqlItem.INDUSTRY_ATTRIBUTE25 := aPlsqlItem.INDUSTRY_ATTRIBUTE25;
1165 aSqlItem.INDUSTRY_ATTRIBUTE26 := aPlsqlItem.INDUSTRY_ATTRIBUTE26;
1166 aSqlItem.INDUSTRY_ATTRIBUTE27 := aPlsqlItem.INDUSTRY_ATTRIBUTE27;
1167 aSqlItem.INDUSTRY_ATTRIBUTE28 := aPlsqlItem.INDUSTRY_ATTRIBUTE28;
1168 aSqlItem.INDUSTRY_ATTRIBUTE29 := aPlsqlItem.INDUSTRY_ATTRIBUTE29;
1169 aSqlItem.INDUSTRY_ATTRIBUTE3 := aPlsqlItem.INDUSTRY_ATTRIBUTE3;
1170 aSqlItem.INDUSTRY_ATTRIBUTE30 := aPlsqlItem.INDUSTRY_ATTRIBUTE30;
1171 aSqlItem.INDUSTRY_ATTRIBUTE4 := aPlsqlItem.INDUSTRY_ATTRIBUTE4;
1172 aSqlItem.INDUSTRY_ATTRIBUTE5 := aPlsqlItem.INDUSTRY_ATTRIBUTE5;
1173 aSqlItem.INDUSTRY_ATTRIBUTE6 := aPlsqlItem.INDUSTRY_ATTRIBUTE6;
1174 aSqlItem.INDUSTRY_ATTRIBUTE7 := aPlsqlItem.INDUSTRY_ATTRIBUTE7;
1175 aSqlItem.INDUSTRY_ATTRIBUTE8 := aPlsqlItem.INDUSTRY_ATTRIBUTE8;
1176 aSqlItem.INDUSTRY_ATTRIBUTE9 := aPlsqlItem.INDUSTRY_ATTRIBUTE9;
1177 aSqlItem.INDUSTRY_CONTEXT := aPlsqlItem.INDUSTRY_CONTEXT;
1178 aSqlItem.INTMED_SHIP_TO_CONTACT_ID := aPlsqlItem.INTMED_SHIP_TO_CONTACT_ID;
1179 aSqlItem.INTMED_SHIP_TO_ORG_ID := aPlsqlItem.INTMED_SHIP_TO_ORG_ID;
1180 aSqlItem.INTERFACE_STATUS := aPlsqlItem.INTERFACE_STATUS;
1181 aSqlItem.INVENTORY_ITEM := aPlsqlItem.INVENTORY_ITEM;
1182 aSqlItem.INVENTORY_ITEM_ID := aPlsqlItem.INVENTORY_ITEM_ID;
1183 aSqlItem.INVENTORY_ITEM_SEGMENT_1 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_1;
1184 aSqlItem.INVENTORY_ITEM_SEGMENT_10 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_10;
1185 aSqlItem.INVENTORY_ITEM_SEGMENT_11 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_11;
1186 aSqlItem.INVENTORY_ITEM_SEGMENT_12 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_12;
1187 aSqlItem.INVENTORY_ITEM_SEGMENT_13 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_13;
1188 aSqlItem.INVENTORY_ITEM_SEGMENT_14 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_14;
1189 aSqlItem.INVENTORY_ITEM_SEGMENT_15 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_15;
1190 aSqlItem.INVENTORY_ITEM_SEGMENT_16 := aPlsqlItem.INVENTORY_ITEM_SEGMENT_16;
1191 aSqlItem.SHIP_TO_PARTY_NUMBER := aPlsqlItem.SHIP_TO_PARTY_NUMBER;
1192 aSqlItem.INVOICE_TO_PARTY_NUMBER := aPlsqlItem.INVOICE_TO_PARTY_NUMBER;
1193 aSqlItem.DELIVER_TO_PARTY_NUMBER := aPlsqlItem.DELIVER_TO_PARTY_NUMBER;
1194 aSqlItem.END_CUSTOMER_NUMBER := aPlsqlItem.END_CUSTOMER_NUMBER;
1195 aSqlItem.END_CUSTOMER_PARTY_NUMBER := aPlsqlItem.END_CUSTOMER_PARTY_NUMBER;
1196 aSqlItem.END_CUSTOMER_ID := aPlsqlItem.END_CUSTOMER_ID;
1197 aSqlItem.END_CUSTOMER_CONTACT_ID := aPlsqlItem.END_CUSTOMER_CONTACT_ID;
1198 aSqlItem.END_CUSTOMER_SITE_USE_ID := aPlsqlItem.END_CUSTOMER_SITE_USE_ID;
1199 aSqlItem.END_CUSTOMER_ADDRESS1 := aPlsqlItem.END_CUSTOMER_ADDRESS1;
1200 aSqlItem.END_CUSTOMER_ADDRESS2 := aPlsqlItem.END_CUSTOMER_ADDRESS2;
1201 aSqlItem.END_CUSTOMER_ADDRESS3 := aPlsqlItem.END_CUSTOMER_ADDRESS3;
1202 aSqlItem.END_CUSTOMER_ADDRESS4 := aPlsqlItem.END_CUSTOMER_ADDRESS4;
1203 aSqlItem.END_CUSTOMER_CITY := aPlsqlItem.END_CUSTOMER_CITY;
1204 aSqlItem.END_CUSTOMER_POSTAL_CODE := aPlsqlItem.END_CUSTOMER_POSTAL_CODE;
1205 aSqlItem.END_CUSTOMER_COUNTRY := aPlsqlItem.END_CUSTOMER_COUNTRY;
1206 aSqlItem.END_CUSTOMER_STATE := aPlsqlItem.END_CUSTOMER_STATE;
1207 aSqlItem.END_CUSTOMER_COUNTY := aPlsqlItem.END_CUSTOMER_COUNTY;
1208 aSqlItem.END_CUSTOMER_PROVINCE := aPlsqlItem.END_CUSTOMER_PROVINCE;
1209 aSqlItem.END_CUSTOMER_CONTACT := aPlsqlItem.END_CUSTOMER_CONTACT;
1210 aSqlItem.SHIPPING_INSTRUCTIONS := aPlsqlItem.SHIPPING_INSTRUCTIONS;
1211 aSqlItem.PACKING_INSTRUCTIONS := aPlsqlItem.PACKING_INSTRUCTIONS;
1212 aSqlItem.INVOICED_QUANTITY := aPlsqlItem.INVOICED_QUANTITY;
1213 aSqlItem.REFERENCE_CUSTOMER_TRX_LINE_ID := aPlsqlItem.REFERENCE_CUSTOMER_TRX_LINE_ID;
1214 aSqlItem.SPLIT_BY := aPlsqlItem.SPLIT_BY;
1215 aSqlItem.LINE_SET_ID := aPlsqlItem.LINE_SET_ID;
1216 aSqlItem.UNIT_LIST_PERCENT := aPlsqlItem.UNIT_LIST_PERCENT;
1217 aSqlItem.UNIT_SELLING_PERCENT := aPlsqlItem.UNIT_SELLING_PERCENT;
1218 aSqlItem.UNIT_PERCENT_BASE_PRICE := aPlsqlItem.UNIT_PERCENT_BASE_PRICE;
1219 aSqlItem.RE_SOURCE_FLAG := aPlsqlItem.RE_SOURCE_FLAG;
1220 aSqlItem.FLOW_STATUS_CODE := aPlsqlItem.FLOW_STATUS_CODE;
1221 aSqlItem.UNIT_LIST_PRICE_PER_PQTY := aPlsqlItem.UNIT_LIST_PRICE_PER_PQTY;
1222 aSqlItem.UNIT_SELLING_PRICE_PQTY := aPlsqlItem.UNIT_SELLING_PRICE_PQTY;
1223 aSqlItem.ITEM_RELATIONSHIP_TYPE := aPlsqlItem.ITEM_RELATIONSHIP_TYPE;
1224 aSqlItem.HEADER_ID := aPlsqlItem.HEADER_ID;
1225 aSqlItem.ORIG_SYS_DOCUMENT_REF := aPlsqlItem.ORIG_SYS_DOCUMENT_REF;
1226 aSqlItem.ORIG_SYS_LINE_REF := aPlsqlItem.ORIG_SYS_LINE_REF;
1227 aSqlItem.CHANGE_DATE := aPlsqlItem.CHANGE_DATE;
1228 aSqlItem.CHANGE_SEQUENCE := aPlsqlItem.CHANGE_SEQUENCE;
1229 aSqlItem.ACCOUNTING_RULE := aPlsqlItem.ACCOUNTING_RULE;
1230 aSqlItem.ORDER_NUMBER := aPlsqlItem.ORDER_NUMBER;
1231 aSqlItem.ACCOUNTING_RULE_ID := aPlsqlItem.ACCOUNTING_RULE_ID;
1232 aSqlItem.ACKNOWLEDGMENT_FLAG := aPlsqlItem.ACKNOWLEDGMENT_FLAG;
1233 aSqlItem.FIRST_ACK_CODE := aPlsqlItem.FIRST_ACK_CODE;
1234 aSqlItem.LAST_ACK_CODE := aPlsqlItem.LAST_ACK_CODE;
1235 aSqlItem.FIRST_ACK_DATE := aPlsqlItem.FIRST_ACK_DATE;
1236 aSqlItem.LAST_ACK_DATE := aPlsqlItem.LAST_ACK_DATE;
1237 aSqlItem.BUYER_SELLER_FLAG := aPlsqlItem.BUYER_SELLER_FLAG;
1238 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
1239 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
1240 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
1241 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
1242 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
1243 aSqlItem.ACTUAL_ARRIVAL_DATE := aPlsqlItem.ACTUAL_ARRIVAL_DATE;
1244 aSqlItem.ACTUAL_SHIPMENT_DATE := aPlsqlItem.ACTUAL_SHIPMENT_DATE;
1245 aSqlItem.AGREEMENT := aPlsqlItem.AGREEMENT;
1246 aSqlItem.AGREEMENT_ID := aPlsqlItem.AGREEMENT_ID;
1247 aSqlItem.ARRIVAL_SET_ID := aPlsqlItem.ARRIVAL_SET_ID;
1248 aSqlItem.ARRIVAL_SET_NAME := aPlsqlItem.ARRIVAL_SET_NAME;
1249 aSqlItem.PRICE_LIST := aPlsqlItem.PRICE_LIST;
1250 aSqlItem.PRICE_LIST_ID := aPlsqlItem.PRICE_LIST_ID;
1251 aSqlItem.SHIP_FROM_ORG := aPlsqlItem.SHIP_FROM_ORG;
1252 aSqlItem.SHIP_FROM_ORG_ID := aPlsqlItem.SHIP_FROM_ORG_ID;
1253 aSqlItem.SHIP_TO_ORG := aPlsqlItem.SHIP_TO_ORG;
1254 aSqlItem.SHIP_TO_ORG_ID := aPlsqlItem.SHIP_TO_ORG_ID;
1255 aSqlItem.SOLD_FROM_ORG := aPlsqlItem.SOLD_FROM_ORG;
1256 aSqlItem.SOLD_FROM_ORG_ID := aPlsqlItem.SOLD_FROM_ORG_ID;
1257 aSqlItem.SOLD_TO_ORG := aPlsqlItem.SOLD_TO_ORG;
1258 aSqlItem.SOLD_TO_ORG_ID := aPlsqlItem.SOLD_TO_ORG_ID;
1259 aSqlItem.ATO_LINE_ID := aPlsqlItem.ATO_LINE_ID;
1260 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
1261 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
1262 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
1263 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
1264 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
1265 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
1266 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
1267 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
1268 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
1269 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
1270 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
1271 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
1272 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
1273 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
1274 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
1275 aSqlItem.AUTHORIZED_TO_SHIP_FLAG := aPlsqlItem.AUTHORIZED_TO_SHIP_FLAG;
1276 aSqlItem.BOOKED_FLAG := aPlsqlItem.BOOKED_FLAG;
1277 aSqlItem.CALCULATE_PRICE_FLAG := aPlsqlItem.CALCULATE_PRICE_FLAG;
1278 aSqlItem.CANCELLED_FLAG := aPlsqlItem.CANCELLED_FLAG;
1279 aSqlItem.CANCELLED_QUANTITY := aPlsqlItem.CANCELLED_QUANTITY;
1280 aSqlItem.CLOSED_FLAG := aPlsqlItem.CLOSED_FLAG;
1281 aSqlItem.COMMITMENT_ID := aPlsqlItem.COMMITMENT_ID;
1282 aSqlItem.COMPONENT_CODE := aPlsqlItem.COMPONENT_CODE;
1283 aSqlItem.COMPONENT_NUMBER := aPlsqlItem.COMPONENT_NUMBER;
1284 aSqlItem.COMPONENT_SEQUENCE_ID := aPlsqlItem.COMPONENT_SEQUENCE_ID;
1285 aSqlItem.CONFIG_DISPLAY_SEQUENCE := aPlsqlItem.CONFIG_DISPLAY_SEQUENCE;
1286 aSqlItem.CONFIGURATION_ID := aPlsqlItem.CONFIGURATION_ID;
1287 aSqlItem.CONFIG_LINE_REF := aPlsqlItem.CONFIG_LINE_REF;
1288 aSqlItem.TOP_MODEL_LINE_ID := aPlsqlItem.TOP_MODEL_LINE_ID;
1289 aSqlItem.CONTEXT := aPlsqlItem.CONTEXT;
1290 aSqlItem.CONTRACT_PO_NUMBER := aPlsqlItem.CONTRACT_PO_NUMBER;
1291 aSqlItem.COST_TYPE := aPlsqlItem.COST_TYPE;
1292 aSqlItem.COST_TYPE_ID := aPlsqlItem.COST_TYPE_ID;
1293 aSqlItem.COSTING_DATE := aPlsqlItem.COSTING_DATE;
1294 aSqlItem.CUST_MODEL_SERIAL_NUMBER := aPlsqlItem.CUST_MODEL_SERIAL_NUMBER;
1295 aSqlItem.CUST_PO_NUMBER := aPlsqlItem.CUST_PO_NUMBER;
1296 aSqlItem.CUST_PRODUCTION_SEQ_NUM := aPlsqlItem.CUST_PRODUCTION_SEQ_NUM;
1297 aSqlItem.CUSTOMER_DOCK := aPlsqlItem.CUSTOMER_DOCK;
1298 aSqlItem.CUSTOMER_DOCK_CODE := aPlsqlItem.CUSTOMER_DOCK_CODE;
1299 aSqlItem.CUSTOMER_ITEM := aPlsqlItem.CUSTOMER_ITEM;
1300 aSqlItem.CUSTOMER_ITEM_ID := aPlsqlItem.CUSTOMER_ITEM_ID;
1301 aSqlItem.CUSTOMER_ITEM_REVISION := aPlsqlItem.CUSTOMER_ITEM_REVISION;
1302 aSqlItem.CUSTOMER_JOB := aPlsqlItem.CUSTOMER_JOB;
1303 aSqlItem.CUSTOMER_PRODUCTION_LINE := aPlsqlItem.CUSTOMER_PRODUCTION_LINE;
1304 aSqlItem.CUSTOMER_TRX_LINE_ID := aPlsqlItem.CUSTOMER_TRX_LINE_ID;
1305 aSqlItem.DELIVERY_ID := aPlsqlItem.DELIVERY_ID;
1306 aSqlItem.DELIVER_TO_CONTACT := aPlsqlItem.DELIVER_TO_CONTACT;
1307 RETURN aSqlItem;
1308 END PL_TO_SQL3;
1309 FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
1310 RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE IS
1311 aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
1312 BEGIN
1313 aPlsqlItem.END_CUSTOMER_CONTACT_LAST_NAME := aSqlItem.END_CUSTOMER_CONTACT_LAST_NAME;
1314 aPlsqlItem.END_CUSTOMER_CONTACT_FIRST_NAM := aSqlItem.END_CUSTOMER_CONTACT_FIRST_NAM;
1315 aPlsqlItem.END_CUSTOMER_NAME := aSqlItem.END_CUSTOMER_NAME;
1316 aPlsqlItem.IB_OWNER := aSqlItem.IB_OWNER;
1317 aPlsqlItem.IB_CURRENT_LOCATION := aSqlItem.IB_CURRENT_LOCATION;
1318 aPlsqlItem.IB_INSTALLED_AT_LOCATION := aSqlItem.IB_INSTALLED_AT_LOCATION;
1319 aPlsqlItem.ORDER_FIRMED_DATE := aSqlItem.ORDER_FIRMED_DATE;
1320 aPlsqlItem.ACTUAL_FULFILLMENT_DATE := aSqlItem.ACTUAL_FULFILLMENT_DATE;
1321 aPlsqlItem.COMMITMENT := aSqlItem.COMMITMENT;
1322 aPlsqlItem.CUSTOMER_PAYMENT_TERM := aSqlItem.CUSTOMER_PAYMENT_TERM;
1323 aPlsqlItem.DELIVER_TO_ADDRESS1 := aSqlItem.DELIVER_TO_ADDRESS1;
1324 aPlsqlItem.DELIVER_TO_ADDRESS2 := aSqlItem.DELIVER_TO_ADDRESS2;
1325 aPlsqlItem.DELIVER_TO_ADDRESS3 := aSqlItem.DELIVER_TO_ADDRESS3;
1326 aPlsqlItem.DELIVER_TO_ADDRESS4 := aSqlItem.DELIVER_TO_ADDRESS4;
1327 aPlsqlItem.DELIVER_TO_CITY := aSqlItem.DELIVER_TO_CITY;
1328 aPlsqlItem.DELIVER_TO_COUNTRY := aSqlItem.DELIVER_TO_COUNTRY;
1329 aPlsqlItem.DELIVER_TO_COUNTY := aSqlItem.DELIVER_TO_COUNTY;
1330 aPlsqlItem.DELIVER_TO_POSTAL_CODE := aSqlItem.DELIVER_TO_POSTAL_CODE;
1331 aPlsqlItem.DELIVER_TO_PROVINCE := aSqlItem.DELIVER_TO_PROVINCE;
1332 aPlsqlItem.DELIVER_TO_STATE := aSqlItem.DELIVER_TO_STATE;
1333 aPlsqlItem.INVOICE_ADDRESS_1 := aSqlItem.INVOICE_ADDRESS_1;
1334 aPlsqlItem.INVOICE_ADDRESS_2 := aSqlItem.INVOICE_ADDRESS_2;
1335 aPlsqlItem.INVOICE_ADDRESS_3 := aSqlItem.INVOICE_ADDRESS_3;
1336 aPlsqlItem.INVOICE_ADDRESS_4 := aSqlItem.INVOICE_ADDRESS_4;
1337 aPlsqlItem.INVOICE_COUNTRY := aSqlItem.INVOICE_COUNTRY;
1338 aPlsqlItem.INVOICE_COUNTY := aSqlItem.INVOICE_COUNTY;
1339 aPlsqlItem.INVOICE_POSTAL_CODE := aSqlItem.INVOICE_POSTAL_CODE;
1340 aPlsqlItem.INVOICE_STATE := aSqlItem.INVOICE_STATE;
1341 aPlsqlItem.IB_OWNER_CODE := aSqlItem.IB_OWNER_CODE;
1342 aPlsqlItem.IB_CURRENT_LOCATION_CODE := aSqlItem.IB_CURRENT_LOCATION_CODE;
1343 aPlsqlItem.IB_INSTALLED_AT_LOCATION_CODE := aSqlItem.IB_INSTALLED_AT_LOCATION_CODE;
1344 aPlsqlItem.CONFIG_REV_NBR := aSqlItem.CONFIG_REV_NBR;
1345 aPlsqlItem.CONFIG_HEADER_ID := aSqlItem.CONFIG_HEADER_ID;
1346 aPlsqlItem.SHIP_FROM_ADDRESS_1 := aSqlItem.SHIP_FROM_ADDRESS_1;
1347 aPlsqlItem.SHIP_FROM_ADDRESS_2 := aSqlItem.SHIP_FROM_ADDRESS_2;
1348 aPlsqlItem.SHIP_FROM_ADDRESS_3 := aSqlItem.SHIP_FROM_ADDRESS_3;
1349 aPlsqlItem.SHIP_FROM_CITY := aSqlItem.SHIP_FROM_CITY;
1350 aPlsqlItem.SHIP_FROM_POSTAL_CODE := aSqlItem.SHIP_FROM_POSTAL_CODE;
1351 aPlsqlItem.SHIP_FROM_COUNTRY := aSqlItem.SHIP_FROM_COUNTRY;
1352 aPlsqlItem.SHIP_FROM_EDI_LOCATION_CODE := aSqlItem.SHIP_FROM_EDI_LOCATION_CODE;
1353 aPlsqlItem.SHIP_FROM_REGION1 := aSqlItem.SHIP_FROM_REGION1;
1354 aPlsqlItem.SHIP_FROM_REGION2 := aSqlItem.SHIP_FROM_REGION2;
1355 aPlsqlItem.SHIP_FROM_REGION3 := aSqlItem.SHIP_FROM_REGION3;
1356 aPlsqlItem.SHIP_FROM_ADDRESS_ID := aSqlItem.SHIP_FROM_ADDRESS_ID;
1357 aPlsqlItem.SHIP_TO_ADDRESS_CODE := aSqlItem.SHIP_TO_ADDRESS_CODE;
1358 aPlsqlItem.SHIP_TO_ADDRESS_NAME := aSqlItem.SHIP_TO_ADDRESS_NAME;
1359 aPlsqlItem.SHIP_TO_ADDRESS_ID := aSqlItem.SHIP_TO_ADDRESS_ID;
1360 aPlsqlItem.INVOICE_ADDRESS_CODE := aSqlItem.INVOICE_ADDRESS_CODE;
1361 aPlsqlItem.INVOICE_ADDRESS_NAME := aSqlItem.INVOICE_ADDRESS_NAME;
1362 aPlsqlItem.DELIVER_TO_CUSTOMER := aSqlItem.DELIVER_TO_CUSTOMER;
1363 aPlsqlItem.SERVICED_LINE_ID := aSqlItem.SERVICED_LINE_ID;
1364 aPlsqlItem.SERVICE_REFERENCE_ORDER := aSqlItem.SERVICE_REFERENCE_ORDER;
1365 aPlsqlItem.SERVICE_REFERENCE_LINE := aSqlItem.SERVICE_REFERENCE_LINE;
1366 aPlsqlItem.SERVICE_REFERENCE_SYSTEM := aSqlItem.SERVICE_REFERENCE_SYSTEM;
1367 aPlsqlItem.TP_CONTEXT := aSqlItem.TP_CONTEXT;
1368 aPlsqlItem.TP_ATTRIBUTE1 := aSqlItem.TP_ATTRIBUTE1;
1369 aPlsqlItem.TP_ATTRIBUTE2 := aSqlItem.TP_ATTRIBUTE2;
1370 aPlsqlItem.TP_ATTRIBUTE3 := aSqlItem.TP_ATTRIBUTE3;
1371 aPlsqlItem.TP_ATTRIBUTE4 := aSqlItem.TP_ATTRIBUTE4;
1372 aPlsqlItem.TP_ATTRIBUTE5 := aSqlItem.TP_ATTRIBUTE5;
1373 aPlsqlItem.TP_ATTRIBUTE6 := aSqlItem.TP_ATTRIBUTE6;
1374 aPlsqlItem.TP_ATTRIBUTE7 := aSqlItem.TP_ATTRIBUTE7;
1375 aPlsqlItem.TP_ATTRIBUTE8 := aSqlItem.TP_ATTRIBUTE8;
1376 aPlsqlItem.TP_ATTRIBUTE9 := aSqlItem.TP_ATTRIBUTE9;
1377 aPlsqlItem.TP_ATTRIBUTE10 := aSqlItem.TP_ATTRIBUTE10;
1378 aPlsqlItem.TP_ATTRIBUTE11 := aSqlItem.TP_ATTRIBUTE11;
1379 aPlsqlItem.TP_ATTRIBUTE12 := aSqlItem.TP_ATTRIBUTE12;
1380 aPlsqlItem.TP_ATTRIBUTE13 := aSqlItem.TP_ATTRIBUTE13;
1381 aPlsqlItem.TP_ATTRIBUTE14 := aSqlItem.TP_ATTRIBUTE14;
1382 aPlsqlItem.TP_ATTRIBUTE15 := aSqlItem.TP_ATTRIBUTE15;
1383 aPlsqlItem.SPLIT_FROM_SHIPMENT_REF := aSqlItem.SPLIT_FROM_SHIPMENT_REF;
1384 aPlsqlItem.SHIP_TO_CUSTOMER_ID := aSqlItem.SHIP_TO_CUSTOMER_ID;
1385 aPlsqlItem.INVOICE_TO_CUSTOMER_ID := aSqlItem.INVOICE_TO_CUSTOMER_ID;
1386 aPlsqlItem.UNIT_SELLING_PRICE_PER_PQTY := aSqlItem.UNIT_SELLING_PRICE_PER_PQTY;
1387 aPlsqlItem.DELIVER_TO_CUSTOMER_ID := aSqlItem.DELIVER_TO_CUSTOMER_ID;
1388 aPlsqlItem.SHIP_TO_CUSTOMER_NAME := aSqlItem.SHIP_TO_CUSTOMER_NAME;
1389 aPlsqlItem.SHIP_TO_CUSTOMER_NUMBER := aSqlItem.SHIP_TO_CUSTOMER_NUMBER;
1390 aPlsqlItem.INVOICE_TO_CUSTOMER_NAME := aSqlItem.INVOICE_TO_CUSTOMER_NAME;
1391 aPlsqlItem.INVOICE_TO_CUSTOMER_NUMBER := aSqlItem.INVOICE_TO_CUSTOMER_NUMBER;
1392 aPlsqlItem.DELIVER_TO_CUSTOMER_NAME := aSqlItem.DELIVER_TO_CUSTOMER_NAME;
1393 aPlsqlItem.DELIVER_TO_CUSTOMER_NUMBER := aSqlItem.DELIVER_TO_CUSTOMER_NUMBER;
1394 aPlsqlItem.ACCOUNTING_RULE_DURATION := aSqlItem.ACCOUNTING_RULE_DURATION;
1395 aPlsqlItem.ATTRIBUTE16 := aSqlItem.ATTRIBUTE16;
1396 aPlsqlItem.ATTRIBUTE17 := aSqlItem.ATTRIBUTE17;
1397 aPlsqlItem.ATTRIBUTE18 := aSqlItem.ATTRIBUTE18;
1398 aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
1399 aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
1400 aPlsqlItem.ACKNOWLEDGMENT_TYPE := aSqlItem.ACKNOWLEDGMENT_TYPE;
1401 aPlsqlItem.USER_ITEM_DESCRIPTION := aSqlItem.USER_ITEM_DESCRIPTION;
1402 aPlsqlItem.BLANKET_NUMBER := aSqlItem.BLANKET_NUMBER;
1403 aPlsqlItem.BLANKET_LINE_NUMBER := aSqlItem.BLANKET_LINE_NUMBER;
1404 aPlsqlItem.ORIGINAL_INVENTORY_ITEM_ID := aSqlItem.ORIGINAL_INVENTORY_ITEM_ID;
1405 aPlsqlItem.ORIGINAL_ORDERED_ITEM_ID := aSqlItem.ORIGINAL_ORDERED_ITEM_ID;
1406 aPlsqlItem.ORIGINAL_ORDERED_ITEM := aSqlItem.ORIGINAL_ORDERED_ITEM;
1407 aPlsqlItem.ORDERED_ITEM := aSqlItem.ORDERED_ITEM;
1408 aPlsqlItem.INVOICE_INTERFACE_STATUS_CODE := aSqlItem.INVOICE_INTERFACE_STATUS_CODE;
1409 aPlsqlItem.PREFERRED_GRADE := aSqlItem.PREFERRED_GRADE;
1410 aPlsqlItem.ORDERED_QUANTITY2 := aSqlItem.ORDERED_QUANTITY2;
1411 aPlsqlItem.ORDERED_QUANTITY_UOM2 := aSqlItem.ORDERED_QUANTITY_UOM2;
1412 aPlsqlItem.SHIPPING_QUANTITY2 := aSqlItem.SHIPPING_QUANTITY2;
1413 aPlsqlItem.CANCELLED_QUANTITY2 := aSqlItem.CANCELLED_QUANTITY2;
1414 aPlsqlItem.SHIPPED_QUANTITY2 := aSqlItem.SHIPPED_QUANTITY2;
1415 aPlsqlItem.SHIPPING_QUANTITY_UOM2 := aSqlItem.SHIPPING_QUANTITY_UOM2;
1416 aPlsqlItem.FULFILLED_QUANTITY2 := aSqlItem.FULFILLED_QUANTITY2;
1417 aPlsqlItem.REVENUE_AMOUNT := aSqlItem.REVENUE_AMOUNT;
1418 aPlsqlItem.FULFILLMENT_DATE := aSqlItem.FULFILLMENT_DATE;
1419 aPlsqlItem.ORIGINAL_ITEM_IDENTIFIER_TYPE := aSqlItem.ORIGINAL_ITEM_IDENTIFIER_TYPE;
1420 aPlsqlItem.ITEM_SUBSTITUTION_TYPE_CODE := aSqlItem.ITEM_SUBSTITUTION_TYPE_CODE;
1421 aPlsqlItem.AUTO_SELECTED_QUANTITY := aSqlItem.AUTO_SELECTED_QUANTITY;
1422 aPlsqlItem.ORDERED_ITEM_ID := aSqlItem.ORDERED_ITEM_ID;
1423 aPlsqlItem.ITEM_IDENTIFIER_TYPE := aSqlItem.ITEM_IDENTIFIER_TYPE;
1424 aPlsqlItem.END_ITEM_UNIT_NUMBER := aSqlItem.END_ITEM_UNIT_NUMBER;
1425 aPlsqlItem.RETURN_ATTRIBUTE13 := aSqlItem.RETURN_ATTRIBUTE13;
1426 aPlsqlItem.RETURN_ATTRIBUTE14 := aSqlItem.RETURN_ATTRIBUTE14;
1427 aPlsqlItem.RETURN_ATTRIBUTE15 := aSqlItem.RETURN_ATTRIBUTE15;
1428 aPlsqlItem.RETURN_ATTRIBUTE2 := aSqlItem.RETURN_ATTRIBUTE2;
1429 aPlsqlItem.RETURN_ATTRIBUTE3 := aSqlItem.RETURN_ATTRIBUTE3;
1430 aPlsqlItem.RETURN_ATTRIBUTE4 := aSqlItem.RETURN_ATTRIBUTE4;
1431 aPlsqlItem.RETURN_ATTRIBUTE5 := aSqlItem.RETURN_ATTRIBUTE5;
1432 aPlsqlItem.RETURN_ATTRIBUTE6 := aSqlItem.RETURN_ATTRIBUTE6;
1433 aPlsqlItem.RETURN_ATTRIBUTE7 := aSqlItem.RETURN_ATTRIBUTE7;
1434 aPlsqlItem.RETURN_ATTRIBUTE8 := aSqlItem.RETURN_ATTRIBUTE8;
1435 aPlsqlItem.RETURN_ATTRIBUTE9 := aSqlItem.RETURN_ATTRIBUTE9;
1436 aPlsqlItem.RETURN_CONTEXT := aSqlItem.RETURN_CONTEXT;
1437 aPlsqlItem.RETURN_REASON_CODE := aSqlItem.RETURN_REASON_CODE;
1438 aPlsqlItem.RLA_SCHEDULE_TYPE_CODE := aSqlItem.RLA_SCHEDULE_TYPE_CODE;
1439 aPlsqlItem.SALESREP_ID := aSqlItem.SALESREP_ID;
1440 aPlsqlItem.SALESREP := aSqlItem.SALESREP;
1441 aPlsqlItem.SCHEDULE_ARRIVAL_DATE := aSqlItem.SCHEDULE_ARRIVAL_DATE;
1442 aPlsqlItem.SCHEDULE_SHIP_DATE := aSqlItem.SCHEDULE_SHIP_DATE;
1443 aPlsqlItem.SCHEDULE_ITEM_DETAIL := aSqlItem.SCHEDULE_ITEM_DETAIL;
1444 aPlsqlItem.SCHEDULE_STATUS_CODE := aSqlItem.SCHEDULE_STATUS_CODE;
1445 aPlsqlItem.SHIP_MODEL_COMPLETE_FLAG := aSqlItem.SHIP_MODEL_COMPLETE_FLAG;
1446 aPlsqlItem.SHIP_SET_ID := aSqlItem.SHIP_SET_ID;
1447 aPlsqlItem.SHIP_SET_NAME := aSqlItem.SHIP_SET_NAME;
1448 aPlsqlItem.SHIP_TO_ADDRESS1 := aSqlItem.SHIP_TO_ADDRESS1;
1449 aPlsqlItem.SHIP_TO_ADDRESS2 := aSqlItem.SHIP_TO_ADDRESS2;
1450 aPlsqlItem.SHIP_TO_ADDRESS3 := aSqlItem.SHIP_TO_ADDRESS3;
1451 aPlsqlItem.SHIP_TO_ADDRESS4 := aSqlItem.SHIP_TO_ADDRESS4;
1452 aPlsqlItem.SHIP_TO_CITY := aSqlItem.SHIP_TO_CITY;
1453 aPlsqlItem.SHIP_TO_CONTACT := aSqlItem.SHIP_TO_CONTACT;
1454 aPlsqlItem.SHIP_TO_CONTACT_AREA_CODE1 := aSqlItem.SHIP_TO_CONTACT_AREA_CODE1;
1455 aPlsqlItem.SHIP_TO_CONTACT_AREA_CODE2 := aSqlItem.SHIP_TO_CONTACT_AREA_CODE2;
1456 aPlsqlItem.SHIP_TO_CONTACT_AREA_CODE3 := aSqlItem.SHIP_TO_CONTACT_AREA_CODE3;
1457 aPlsqlItem.SHIP_TO_CONTACT_FIRST_NAME := aSqlItem.SHIP_TO_CONTACT_FIRST_NAME;
1458 aPlsqlItem.SHIP_TO_CONTACT_ID := aSqlItem.SHIP_TO_CONTACT_ID;
1459 aPlsqlItem.SHIP_TO_CONTACT_JOB_TITLE := aSqlItem.SHIP_TO_CONTACT_JOB_TITLE;
1460 aPlsqlItem.SHIP_TO_CONTACT_LAST_NAME := aSqlItem.SHIP_TO_CONTACT_LAST_NAME;
1461 aPlsqlItem.SHIP_TO_COUNTRY := aSqlItem.SHIP_TO_COUNTRY;
1462 aPlsqlItem.SHIP_TO_COUNTY := aSqlItem.SHIP_TO_COUNTY;
1463 aPlsqlItem.SHIP_TO_POSTAL_CODE := aSqlItem.SHIP_TO_POSTAL_CODE;
1464 aPlsqlItem.SHIP_TO_STATE := aSqlItem.SHIP_TO_STATE;
1465 aPlsqlItem.SHIP_TOLERANCE_ABOVE := aSqlItem.SHIP_TOLERANCE_ABOVE;
1466 aPlsqlItem.SHIP_TOLERANCE_BELOW := aSqlItem.SHIP_TOLERANCE_BELOW;
1467 aPlsqlItem.SHIPMENT_NUMBER := aSqlItem.SHIPMENT_NUMBER;
1468 aPlsqlItem.SHIPMENT_PRIORITY := aSqlItem.SHIPMENT_PRIORITY;
1469 aPlsqlItem.SHIPMENT_PRIORITY_CODE := aSqlItem.SHIPMENT_PRIORITY_CODE;
1470 aPlsqlItem.SHIPPED_QUANTITY := aSqlItem.SHIPPED_QUANTITY;
1471 aPlsqlItem.SHIPPING_METHOD := aSqlItem.SHIPPING_METHOD;
1472 aPlsqlItem.SHIPPING_METHOD_CODE := aSqlItem.SHIPPING_METHOD_CODE;
1473 aPlsqlItem.SHIPPING_QUANTITY := aSqlItem.SHIPPING_QUANTITY;
1474 aPlsqlItem.SHIPPING_QUANTITY_UOM := aSqlItem.SHIPPING_QUANTITY_UOM;
1475 aPlsqlItem.SORT_ORDER := aSqlItem.SORT_ORDER;
1476 aPlsqlItem.SOURCE_DOCUMENT_ID := aSqlItem.SOURCE_DOCUMENT_ID;
1477 aPlsqlItem.SOURCE_DOCUMENT_LINE_ID := aSqlItem.SOURCE_DOCUMENT_LINE_ID;
1478 aPlsqlItem.SOURCE_DOCUMENT_TYPE_ID := aSqlItem.SOURCE_DOCUMENT_TYPE_ID;
1479 aPlsqlItem.SOURCE_TYPE_CODE := aSqlItem.SOURCE_TYPE_CODE;
1480 aPlsqlItem.SPLIT_FROM_LINE_ID := aSqlItem.SPLIT_FROM_LINE_ID;
1481 aPlsqlItem.SUBINVENTORY := aSqlItem.SUBINVENTORY;
1482 aPlsqlItem.SUBMISSION_DATETIME := aSqlItem.SUBMISSION_DATETIME;
1483 aPlsqlItem.TASK := aSqlItem.TASK;
1484 aPlsqlItem.TASK_ID := aSqlItem.TASK_ID;
1485 aPlsqlItem.TAX := aSqlItem.TAX;
1486 aPlsqlItem.TAX_CODE := aSqlItem.TAX_CODE;
1487 aPlsqlItem.TAX_DATE := aSqlItem.TAX_DATE;
1488 aPlsqlItem.TAX_EXEMPT_FLAG := aSqlItem.TAX_EXEMPT_FLAG;
1489 aPlsqlItem.TAX_EXEMPT_NUMBER := aSqlItem.TAX_EXEMPT_NUMBER;
1490 aPlsqlItem.TAX_EXEMPT_REASON := aSqlItem.TAX_EXEMPT_REASON;
1491 aPlsqlItem.TAX_EXEMPT_REASON_CODE := aSqlItem.TAX_EXEMPT_REASON_CODE;
1492 aPlsqlItem.TAX_POINT := aSqlItem.TAX_POINT;
1493 aPlsqlItem.TAX_POINT_CODE := aSqlItem.TAX_POINT_CODE;
1494 aPlsqlItem.TAX_RATE := aSqlItem.TAX_RATE;
1495 aPlsqlItem.TAX_VALUE := aSqlItem.TAX_VALUE;
1496 aPlsqlItem.UNIT_LIST_PRICE := aSqlItem.UNIT_LIST_PRICE;
1497 aPlsqlItem.UNIT_SELLING_PRICE := aSqlItem.UNIT_SELLING_PRICE;
1498 aPlsqlItem.VEH_CUS_ITEM_CUM_KEY_ID := aSqlItem.VEH_CUS_ITEM_CUM_KEY_ID;
1499 aPlsqlItem.VISIBLE_DEMAND_FLAG := aSqlItem.VISIBLE_DEMAND_FLAG;
1500 aPlsqlItem.CUSTOMER_LINE_NUMBER := aSqlItem.CUSTOMER_LINE_NUMBER;
1501 aPlsqlItem.CUSTOMER_SHIPMENT_NUMBER := aSqlItem.CUSTOMER_SHIPMENT_NUMBER;
1502 aPlsqlItem.CUSTOMER_ITEM_NET_PRICE := aSqlItem.CUSTOMER_ITEM_NET_PRICE;
1503 aPlsqlItem.CUSTOMER_PAYMENT_TERM_ID := aSqlItem.CUSTOMER_PAYMENT_TERM_ID;
1504 aPlsqlItem.DROP_SHIP_FLAG := aSqlItem.DROP_SHIP_FLAG;
1505 aPlsqlItem.SPLIT_FROM_LINE_REF := aSqlItem.SPLIT_FROM_LINE_REF;
1506 aPlsqlItem.SHIP_TO_EDI_LOCATION_CODE := aSqlItem.SHIP_TO_EDI_LOCATION_CODE;
1507 aPlsqlItem.SERVICE_TXN_REASON_CODE := aSqlItem.SERVICE_TXN_REASON_CODE;
1508 aPlsqlItem.SERVICE_TXN_COMMENTS := aSqlItem.SERVICE_TXN_COMMENTS;
1509 aPlsqlItem.SERVICE_DURATION := aSqlItem.SERVICE_DURATION;
1510 aPlsqlItem.SERVICE_START_DATE := aSqlItem.SERVICE_START_DATE;
1511 aPlsqlItem.SERVICE_END_DATE := aSqlItem.SERVICE_END_DATE;
1512 aPlsqlItem.SERVICE_COTERMINATE_FLAG := aSqlItem.SERVICE_COTERMINATE_FLAG;
1513 aPlsqlItem.SERVICE_NUMBER := aSqlItem.SERVICE_NUMBER;
1514 aPlsqlItem.SERVICE_PERIOD := aSqlItem.SERVICE_PERIOD;
1515 aPlsqlItem.SERVICE_REFERENCE_TYPE_CODE := aSqlItem.SERVICE_REFERENCE_TYPE_CODE;
1516 aPlsqlItem.SERVICE_REFERENCE_LINE_ID := aSqlItem.SERVICE_REFERENCE_LINE_ID;
1517 aPlsqlItem.SERVICE_REFERENCE_SYSTEM_ID := aSqlItem.SERVICE_REFERENCE_SYSTEM_ID;
1518 aPlsqlItem.CREDIT_INVOICE_LINE_ID := aSqlItem.CREDIT_INVOICE_LINE_ID;
1519 aPlsqlItem.SHIP_TO_PROVINCE := aSqlItem.SHIP_TO_PROVINCE;
1520 aPlsqlItem.INVOICE_PROVINCE := aSqlItem.INVOICE_PROVINCE;
1521 aPlsqlItem.BILL_TO_EDI_LOCATION_CODE := aSqlItem.BILL_TO_EDI_LOCATION_CODE;
1522 aPlsqlItem.INVOICE_CITY := aSqlItem.INVOICE_CITY;
1523 aPlsqlItem.INVENTORY_ITEM_SEGMENT_17 := aSqlItem.INVENTORY_ITEM_SEGMENT_17;
1524 aPlsqlItem.INVENTORY_ITEM_SEGMENT_18 := aSqlItem.INVENTORY_ITEM_SEGMENT_18;
1525 aPlsqlItem.INVENTORY_ITEM_SEGMENT_19 := aSqlItem.INVENTORY_ITEM_SEGMENT_19;
1526 aPlsqlItem.INVENTORY_ITEM_SEGMENT_2 := aSqlItem.INVENTORY_ITEM_SEGMENT_2;
1527 aPlsqlItem.INVENTORY_ITEM_SEGMENT_20 := aSqlItem.INVENTORY_ITEM_SEGMENT_20;
1528 aPlsqlItem.INVENTORY_ITEM_SEGMENT_3 := aSqlItem.INVENTORY_ITEM_SEGMENT_3;
1529 aPlsqlItem.INVENTORY_ITEM_SEGMENT_4 := aSqlItem.INVENTORY_ITEM_SEGMENT_4;
1530 aPlsqlItem.INVENTORY_ITEM_SEGMENT_5 := aSqlItem.INVENTORY_ITEM_SEGMENT_5;
1531 aPlsqlItem.INVENTORY_ITEM_SEGMENT_6 := aSqlItem.INVENTORY_ITEM_SEGMENT_6;
1532 aPlsqlItem.INVENTORY_ITEM_SEGMENT_7 := aSqlItem.INVENTORY_ITEM_SEGMENT_7;
1533 aPlsqlItem.INVENTORY_ITEM_SEGMENT_8 := aSqlItem.INVENTORY_ITEM_SEGMENT_8;
1534 aPlsqlItem.INVENTORY_ITEM_SEGMENT_9 := aSqlItem.INVENTORY_ITEM_SEGMENT_9;
1535 aPlsqlItem.INVOICE_COMPLETE_FLAG := aSqlItem.INVOICE_COMPLETE_FLAG;
1536 aPlsqlItem.INVOICE_SET_ID := aSqlItem.INVOICE_SET_ID;
1537 aPlsqlItem.INVOICE_SET_NAME := aSqlItem.INVOICE_SET_NAME;
1538 aPlsqlItem.INVOICE_NUMBER := aSqlItem.INVOICE_NUMBER;
1539 aPlsqlItem.INVOICE_TO_CONTACT := aSqlItem.INVOICE_TO_CONTACT;
1540 aPlsqlItem.INVOICE_TO_CONTACT_ID := aSqlItem.INVOICE_TO_CONTACT_ID;
1541 aPlsqlItem.INVOICE_TO_ORG := aSqlItem.INVOICE_TO_ORG;
1542 aPlsqlItem.INVOICE_TO_ORG_ID := aSqlItem.INVOICE_TO_ORG_ID;
1543 aPlsqlItem.INVOICE_TOLERANCE_ABOVE := aSqlItem.INVOICE_TOLERANCE_ABOVE;
1544 aPlsqlItem.INVOICE_TOLERANCE_BELOW := aSqlItem.INVOICE_TOLERANCE_BELOW;
1545 aPlsqlItem.INVOICING_RULE := aSqlItem.INVOICING_RULE;
1546 aPlsqlItem.INVOICING_RULE_ID := aSqlItem.INVOICING_RULE_ID;
1547 aPlsqlItem.ITEM_INPUT := aSqlItem.ITEM_INPUT;
1548 aPlsqlItem.ITEM_REVISION := aSqlItem.ITEM_REVISION;
1549 aPlsqlItem.ITEM_TYPE_CODE := aSqlItem.ITEM_TYPE_CODE;
1550 aPlsqlItem.LATEST_ACCEPTABLE_DATE := aSqlItem.LATEST_ACCEPTABLE_DATE;
1551 aPlsqlItem.LINE_CATEGORY_CODE := aSqlItem.LINE_CATEGORY_CODE;
1552 aPlsqlItem.LINE_ID := aSqlItem.LINE_ID;
1553 aPlsqlItem.LINE_NUMBER := aSqlItem.LINE_NUMBER;
1554 aPlsqlItem.LINE_PO_CONTEXT := aSqlItem.LINE_PO_CONTEXT;
1555 aPlsqlItem.LINE_TYPE := aSqlItem.LINE_TYPE;
1556 aPlsqlItem.LINE_TYPE_ID := aSqlItem.LINE_TYPE_ID;
1557 aPlsqlItem.LINK_TO_LINE_ID := aSqlItem.LINK_TO_LINE_ID;
1558 aPlsqlItem.LINK_TO_LINE_REF := aSqlItem.LINK_TO_LINE_REF;
1559 aPlsqlItem.LOAD_SEQ_NUMBER := aSqlItem.LOAD_SEQ_NUMBER;
1560 aPlsqlItem.LOT := aSqlItem.LOT;
1561 aPlsqlItem.MATERIAL_COST := aSqlItem.MATERIAL_COST;
1562 aPlsqlItem.MATERIAL_OVERHEAD_COST := aSqlItem.MATERIAL_OVERHEAD_COST;
1563 aPlsqlItem.MODEL_GROUP_NUMBER := aSqlItem.MODEL_GROUP_NUMBER;
1564 aPlsqlItem.OPEN_FLAG := aSqlItem.OPEN_FLAG;
1565 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1566 aPlsqlItem.OPTION_FLAG := aSqlItem.OPTION_FLAG;
1567 aPlsqlItem.OPTION_NUMBER := aSqlItem.OPTION_NUMBER;
1568 aPlsqlItem.ORDER_QUANTITY_UOM := aSqlItem.ORDER_QUANTITY_UOM;
1569 aPlsqlItem.ORDER_SOURCE := aSqlItem.ORDER_SOURCE;
1570 aPlsqlItem.ORDER_SOURCE_ID := aSqlItem.ORDER_SOURCE_ID;
1571 aPlsqlItem.ORDERED_QUANTITY := aSqlItem.ORDERED_QUANTITY;
1572 aPlsqlItem.ORG_ID := aSqlItem.ORG_ID;
1573 aPlsqlItem.OUTSIDE_PROCESSING_COST := aSqlItem.OUTSIDE_PROCESSING_COST;
1574 aPlsqlItem.ORIG_SYS_SHIPMENT_REF := aSqlItem.ORIG_SYS_SHIPMENT_REF;
1575 aPlsqlItem.OVER_SHIP_REASON_CODE := aSqlItem.OVER_SHIP_REASON_CODE;
1576 aPlsqlItem.OVER_SHIP_RESOLVED_FLAG := aSqlItem.OVER_SHIP_RESOLVED_FLAG;
1577 aPlsqlItem.OVERHEAD_COST := aSqlItem.OVERHEAD_COST;
1578 aPlsqlItem.PAYMENT_TERM := aSqlItem.PAYMENT_TERM;
1579 aPlsqlItem.PAYMENT_TERM_ID := aSqlItem.PAYMENT_TERM_ID;
1580 aPlsqlItem.PAYMENT_TRX := aSqlItem.PAYMENT_TRX;
1581 aPlsqlItem.PAYMENT_TRX_ID := aSqlItem.PAYMENT_TRX_ID;
1582 aPlsqlItem.PLANNING_PROD_SEQ_NUM := aSqlItem.PLANNING_PROD_SEQ_NUM;
1583 aPlsqlItem.PRICING_ATTRIBUTE1 := aSqlItem.PRICING_ATTRIBUTE1;
1584 aPlsqlItem.PRICING_ATTRIBUTE10 := aSqlItem.PRICING_ATTRIBUTE10;
1585 aPlsqlItem.PRICING_ATTRIBUTE2 := aSqlItem.PRICING_ATTRIBUTE2;
1586 aPlsqlItem.PRICING_ATTRIBUTE3 := aSqlItem.PRICING_ATTRIBUTE3;
1587 aPlsqlItem.PRICING_ATTRIBUTE4 := aSqlItem.PRICING_ATTRIBUTE4;
1588 aPlsqlItem.PRICING_ATTRIBUTE5 := aSqlItem.PRICING_ATTRIBUTE5;
1589 aPlsqlItem.PRICING_ATTRIBUTE6 := aSqlItem.PRICING_ATTRIBUTE6;
1590 aPlsqlItem.PRICING_ATTRIBUTE7 := aSqlItem.PRICING_ATTRIBUTE7;
1591 aPlsqlItem.PRICING_ATTRIBUTE8 := aSqlItem.PRICING_ATTRIBUTE8;
1592 aPlsqlItem.PRICING_ATTRIBUTE9 := aSqlItem.PRICING_ATTRIBUTE9;
1593 aPlsqlItem.PRICING_CONTEXT := aSqlItem.PRICING_CONTEXT;
1594 aPlsqlItem.PRICING_DATE := aSqlItem.PRICING_DATE;
1595 aPlsqlItem.PRICING_QUANTITY := aSqlItem.PRICING_QUANTITY;
1596 aPlsqlItem.PRICING_QUANTITY_UOM := aSqlItem.PRICING_QUANTITY_UOM;
1597 aPlsqlItem.PROGRAM := aSqlItem.PROGRAM;
1598 aPlsqlItem.PROGRAM_APPLICATION := aSqlItem.PROGRAM_APPLICATION;
1599 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
1600 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
1601 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
1602 aPlsqlItem.PROJECT := aSqlItem.PROJECT;
1603 aPlsqlItem.PROJECT_ID := aSqlItem.PROJECT_ID;
1604 aPlsqlItem.PROMISE_DATE := aSqlItem.PROMISE_DATE;
1605 aPlsqlItem.REFERENCE_HEADER := aSqlItem.REFERENCE_HEADER;
1606 aPlsqlItem.REFERENCE_HEADER_ID := aSqlItem.REFERENCE_HEADER_ID;
1607 aPlsqlItem.REFERENCE_LINE := aSqlItem.REFERENCE_LINE;
1608 aPlsqlItem.REFERENCE_LINE_ID := aSqlItem.REFERENCE_LINE_ID;
1609 aPlsqlItem.REFERENCE_TYPE := aSqlItem.REFERENCE_TYPE;
1610 aPlsqlItem.RELATED_PO_NUMBER := aSqlItem.RELATED_PO_NUMBER;
1611 aPlsqlItem.REQUEST_DATE := aSqlItem.REQUEST_DATE;
1612 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
1613 aPlsqlItem.RESERVED_QUANTITY := aSqlItem.RESERVED_QUANTITY;
1614 aPlsqlItem.RESOURCE_COST := aSqlItem.RESOURCE_COST;
1615 aPlsqlItem.RETURN_ATTRIBUTE1 := aSqlItem.RETURN_ATTRIBUTE1;
1616 aPlsqlItem.RETURN_ATTRIBUTE10 := aSqlItem.RETURN_ATTRIBUTE10;
1617 aPlsqlItem.RETURN_ATTRIBUTE11 := aSqlItem.RETURN_ATTRIBUTE11;
1618 aPlsqlItem.RETURN_ATTRIBUTE12 := aSqlItem.RETURN_ATTRIBUTE12;
1619 aPlsqlItem.DELIVER_TO_CONTACT_ID := aSqlItem.DELIVER_TO_CONTACT_ID;
1620 aPlsqlItem.DELIVER_TO_ORG := aSqlItem.DELIVER_TO_ORG;
1621 aPlsqlItem.DELIVER_TO_ORG_ID := aSqlItem.DELIVER_TO_ORG_ID;
1622 aPlsqlItem.DELIVERY_LEAD_TIME := aSqlItem.DELIVERY_LEAD_TIME;
1623 aPlsqlItem.DEMAND_BUCKET_TYPE := aSqlItem.DEMAND_BUCKET_TYPE;
1624 aPlsqlItem.DEMAND_BUCKET_TYPE_CODE := aSqlItem.DEMAND_BUCKET_TYPE_CODE;
1625 aPlsqlItem.DEMAND_CLASS := aSqlItem.DEMAND_CLASS;
1626 aPlsqlItem.DEMAND_CLASS_CODE := aSqlItem.DEMAND_CLASS_CODE;
1627 aPlsqlItem.DEMAND_STREAM := aSqlItem.DEMAND_STREAM;
1628 aPlsqlItem.DEP_PLAN_REQUIRED_FLAG := aSqlItem.DEP_PLAN_REQUIRED_FLAG;
1629 aPlsqlItem.DPW_ASSIGNED_FLAG := aSqlItem.DPW_ASSIGNED_FLAG;
1630 aPlsqlItem.EARLIEST_ACCEPTABLE_DATE := aSqlItem.EARLIEST_ACCEPTABLE_DATE;
1631 aPlsqlItem.ERROR_FLAG := aSqlItem.ERROR_FLAG;
1632 aPlsqlItem.EXPLOSION_DATE := aSqlItem.EXPLOSION_DATE;
1633 aPlsqlItem.FOB_POINT := aSqlItem.FOB_POINT;
1634 aPlsqlItem.FOB_POINT_CODE := aSqlItem.FOB_POINT_CODE;
1635 aPlsqlItem.FREIGHT_CARRIER_CODE := aSqlItem.FREIGHT_CARRIER_CODE;
1636 aPlsqlItem.FREIGHT_TERMS := aSqlItem.FREIGHT_TERMS;
1637 aPlsqlItem.FREIGHT_TERMS_CODE := aSqlItem.FREIGHT_TERMS_CODE;
1638 aPlsqlItem.FULFILLED_QUANTITY := aSqlItem.FULFILLED_QUANTITY;
1639 aPlsqlItem.FULFILLMENT_SET_ID := aSqlItem.FULFILLMENT_SET_ID;
1640 aPlsqlItem.FULFILLMENT_SET_NAME := aSqlItem.FULFILLMENT_SET_NAME;
1641 aPlsqlItem.GLOBAL_ATTRIBUTE_CATEGORY := aSqlItem.GLOBAL_ATTRIBUTE_CATEGORY;
1642 aPlsqlItem.GLOBAL_ATTRIBUTE1 := aSqlItem.GLOBAL_ATTRIBUTE1;
1643 aPlsqlItem.GLOBAL_ATTRIBUTE10 := aSqlItem.GLOBAL_ATTRIBUTE10;
1644 aPlsqlItem.GLOBAL_ATTRIBUTE11 := aSqlItem.GLOBAL_ATTRIBUTE11;
1645 aPlsqlItem.GLOBAL_ATTRIBUTE12 := aSqlItem.GLOBAL_ATTRIBUTE12;
1646 aPlsqlItem.GLOBAL_ATTRIBUTE13 := aSqlItem.GLOBAL_ATTRIBUTE13;
1647 aPlsqlItem.GLOBAL_ATTRIBUTE14 := aSqlItem.GLOBAL_ATTRIBUTE14;
1648 aPlsqlItem.GLOBAL_ATTRIBUTE15 := aSqlItem.GLOBAL_ATTRIBUTE15;
1649 aPlsqlItem.GLOBAL_ATTRIBUTE16 := aSqlItem.GLOBAL_ATTRIBUTE16;
1650 aPlsqlItem.GLOBAL_ATTRIBUTE17 := aSqlItem.GLOBAL_ATTRIBUTE17;
1651 aPlsqlItem.GLOBAL_ATTRIBUTE18 := aSqlItem.GLOBAL_ATTRIBUTE18;
1652 aPlsqlItem.GLOBAL_ATTRIBUTE19 := aSqlItem.GLOBAL_ATTRIBUTE19;
1653 aPlsqlItem.GLOBAL_ATTRIBUTE2 := aSqlItem.GLOBAL_ATTRIBUTE2;
1654 aPlsqlItem.GLOBAL_ATTRIBUTE20 := aSqlItem.GLOBAL_ATTRIBUTE20;
1655 aPlsqlItem.GLOBAL_ATTRIBUTE3 := aSqlItem.GLOBAL_ATTRIBUTE3;
1656 aPlsqlItem.GLOBAL_ATTRIBUTE4 := aSqlItem.GLOBAL_ATTRIBUTE4;
1657 aPlsqlItem.GLOBAL_ATTRIBUTE5 := aSqlItem.GLOBAL_ATTRIBUTE5;
1658 aPlsqlItem.GLOBAL_ATTRIBUTE6 := aSqlItem.GLOBAL_ATTRIBUTE6;
1659 aPlsqlItem.GLOBAL_ATTRIBUTE7 := aSqlItem.GLOBAL_ATTRIBUTE7;
1660 aPlsqlItem.GLOBAL_ATTRIBUTE8 := aSqlItem.GLOBAL_ATTRIBUTE8;
1661 aPlsqlItem.GLOBAL_ATTRIBUTE9 := aSqlItem.GLOBAL_ATTRIBUTE9;
1662 aPlsqlItem.INDUSTRY_ATTRIBUTE1 := aSqlItem.INDUSTRY_ATTRIBUTE1;
1663 aPlsqlItem.INDUSTRY_ATTRIBUTE10 := aSqlItem.INDUSTRY_ATTRIBUTE10;
1664 aPlsqlItem.INDUSTRY_ATTRIBUTE11 := aSqlItem.INDUSTRY_ATTRIBUTE11;
1665 aPlsqlItem.INDUSTRY_ATTRIBUTE12 := aSqlItem.INDUSTRY_ATTRIBUTE12;
1666 aPlsqlItem.INDUSTRY_ATTRIBUTE13 := aSqlItem.INDUSTRY_ATTRIBUTE13;
1667 aPlsqlItem.INDUSTRY_ATTRIBUTE14 := aSqlItem.INDUSTRY_ATTRIBUTE14;
1668 aPlsqlItem.INDUSTRY_ATTRIBUTE15 := aSqlItem.INDUSTRY_ATTRIBUTE15;
1669 aPlsqlItem.INDUSTRY_ATTRIBUTE16 := aSqlItem.INDUSTRY_ATTRIBUTE16;
1670 aPlsqlItem.INDUSTRY_ATTRIBUTE17 := aSqlItem.INDUSTRY_ATTRIBUTE17;
1671 aPlsqlItem.INDUSTRY_ATTRIBUTE18 := aSqlItem.INDUSTRY_ATTRIBUTE18;
1672 aPlsqlItem.INDUSTRY_ATTRIBUTE19 := aSqlItem.INDUSTRY_ATTRIBUTE19;
1673 aPlsqlItem.INDUSTRY_ATTRIBUTE2 := aSqlItem.INDUSTRY_ATTRIBUTE2;
1674 aPlsqlItem.INDUSTRY_ATTRIBUTE20 := aSqlItem.INDUSTRY_ATTRIBUTE20;
1675 aPlsqlItem.INDUSTRY_ATTRIBUTE21 := aSqlItem.INDUSTRY_ATTRIBUTE21;
1676 aPlsqlItem.INDUSTRY_ATTRIBUTE22 := aSqlItem.INDUSTRY_ATTRIBUTE22;
1677 aPlsqlItem.INDUSTRY_ATTRIBUTE23 := aSqlItem.INDUSTRY_ATTRIBUTE23;
1678 aPlsqlItem.INDUSTRY_ATTRIBUTE24 := aSqlItem.INDUSTRY_ATTRIBUTE24;
1679 aPlsqlItem.INDUSTRY_ATTRIBUTE25 := aSqlItem.INDUSTRY_ATTRIBUTE25;
1680 aPlsqlItem.INDUSTRY_ATTRIBUTE26 := aSqlItem.INDUSTRY_ATTRIBUTE26;
1681 aPlsqlItem.INDUSTRY_ATTRIBUTE27 := aSqlItem.INDUSTRY_ATTRIBUTE27;
1682 aPlsqlItem.INDUSTRY_ATTRIBUTE28 := aSqlItem.INDUSTRY_ATTRIBUTE28;
1683 aPlsqlItem.INDUSTRY_ATTRIBUTE29 := aSqlItem.INDUSTRY_ATTRIBUTE29;
1684 aPlsqlItem.INDUSTRY_ATTRIBUTE3 := aSqlItem.INDUSTRY_ATTRIBUTE3;
1685 aPlsqlItem.INDUSTRY_ATTRIBUTE30 := aSqlItem.INDUSTRY_ATTRIBUTE30;
1686 aPlsqlItem.INDUSTRY_ATTRIBUTE4 := aSqlItem.INDUSTRY_ATTRIBUTE4;
1687 aPlsqlItem.INDUSTRY_ATTRIBUTE5 := aSqlItem.INDUSTRY_ATTRIBUTE5;
1688 aPlsqlItem.INDUSTRY_ATTRIBUTE6 := aSqlItem.INDUSTRY_ATTRIBUTE6;
1689 aPlsqlItem.INDUSTRY_ATTRIBUTE7 := aSqlItem.INDUSTRY_ATTRIBUTE7;
1690 aPlsqlItem.INDUSTRY_ATTRIBUTE8 := aSqlItem.INDUSTRY_ATTRIBUTE8;
1691 aPlsqlItem.INDUSTRY_ATTRIBUTE9 := aSqlItem.INDUSTRY_ATTRIBUTE9;
1692 aPlsqlItem.INDUSTRY_CONTEXT := aSqlItem.INDUSTRY_CONTEXT;
1693 aPlsqlItem.INTMED_SHIP_TO_CONTACT_ID := aSqlItem.INTMED_SHIP_TO_CONTACT_ID;
1694 aPlsqlItem.INTMED_SHIP_TO_ORG_ID := aSqlItem.INTMED_SHIP_TO_ORG_ID;
1695 aPlsqlItem.INTERFACE_STATUS := aSqlItem.INTERFACE_STATUS;
1696 aPlsqlItem.INVENTORY_ITEM := aSqlItem.INVENTORY_ITEM;
1697 aPlsqlItem.INVENTORY_ITEM_ID := aSqlItem.INVENTORY_ITEM_ID;
1698 aPlsqlItem.INVENTORY_ITEM_SEGMENT_1 := aSqlItem.INVENTORY_ITEM_SEGMENT_1;
1699 aPlsqlItem.INVENTORY_ITEM_SEGMENT_10 := aSqlItem.INVENTORY_ITEM_SEGMENT_10;
1700 aPlsqlItem.INVENTORY_ITEM_SEGMENT_11 := aSqlItem.INVENTORY_ITEM_SEGMENT_11;
1701 aPlsqlItem.INVENTORY_ITEM_SEGMENT_12 := aSqlItem.INVENTORY_ITEM_SEGMENT_12;
1702 aPlsqlItem.INVENTORY_ITEM_SEGMENT_13 := aSqlItem.INVENTORY_ITEM_SEGMENT_13;
1703 aPlsqlItem.INVENTORY_ITEM_SEGMENT_14 := aSqlItem.INVENTORY_ITEM_SEGMENT_14;
1704 aPlsqlItem.INVENTORY_ITEM_SEGMENT_15 := aSqlItem.INVENTORY_ITEM_SEGMENT_15;
1705 aPlsqlItem.INVENTORY_ITEM_SEGMENT_16 := aSqlItem.INVENTORY_ITEM_SEGMENT_16;
1706 aPlsqlItem.SHIP_TO_PARTY_NUMBER := aSqlItem.SHIP_TO_PARTY_NUMBER;
1707 aPlsqlItem.INVOICE_TO_PARTY_NUMBER := aSqlItem.INVOICE_TO_PARTY_NUMBER;
1708 aPlsqlItem.DELIVER_TO_PARTY_NUMBER := aSqlItem.DELIVER_TO_PARTY_NUMBER;
1709 aPlsqlItem.END_CUSTOMER_NUMBER := aSqlItem.END_CUSTOMER_NUMBER;
1710 aPlsqlItem.END_CUSTOMER_PARTY_NUMBER := aSqlItem.END_CUSTOMER_PARTY_NUMBER;
1711 aPlsqlItem.END_CUSTOMER_ID := aSqlItem.END_CUSTOMER_ID;
1712 aPlsqlItem.END_CUSTOMER_CONTACT_ID := aSqlItem.END_CUSTOMER_CONTACT_ID;
1713 aPlsqlItem.END_CUSTOMER_SITE_USE_ID := aSqlItem.END_CUSTOMER_SITE_USE_ID;
1714 aPlsqlItem.END_CUSTOMER_ADDRESS1 := aSqlItem.END_CUSTOMER_ADDRESS1;
1715 aPlsqlItem.END_CUSTOMER_ADDRESS2 := aSqlItem.END_CUSTOMER_ADDRESS2;
1716 aPlsqlItem.END_CUSTOMER_ADDRESS3 := aSqlItem.END_CUSTOMER_ADDRESS3;
1717 aPlsqlItem.END_CUSTOMER_ADDRESS4 := aSqlItem.END_CUSTOMER_ADDRESS4;
1718 aPlsqlItem.END_CUSTOMER_CITY := aSqlItem.END_CUSTOMER_CITY;
1719 aPlsqlItem.END_CUSTOMER_POSTAL_CODE := aSqlItem.END_CUSTOMER_POSTAL_CODE;
1720 aPlsqlItem.END_CUSTOMER_COUNTRY := aSqlItem.END_CUSTOMER_COUNTRY;
1721 aPlsqlItem.END_CUSTOMER_STATE := aSqlItem.END_CUSTOMER_STATE;
1722 aPlsqlItem.END_CUSTOMER_COUNTY := aSqlItem.END_CUSTOMER_COUNTY;
1723 aPlsqlItem.END_CUSTOMER_PROVINCE := aSqlItem.END_CUSTOMER_PROVINCE;
1724 aPlsqlItem.END_CUSTOMER_CONTACT := aSqlItem.END_CUSTOMER_CONTACT;
1725 aPlsqlItem.SHIPPING_INSTRUCTIONS := aSqlItem.SHIPPING_INSTRUCTIONS;
1726 aPlsqlItem.PACKING_INSTRUCTIONS := aSqlItem.PACKING_INSTRUCTIONS;
1727 aPlsqlItem.INVOICED_QUANTITY := aSqlItem.INVOICED_QUANTITY;
1728 aPlsqlItem.REFERENCE_CUSTOMER_TRX_LINE_ID := aSqlItem.REFERENCE_CUSTOMER_TRX_LINE_ID;
1729 aPlsqlItem.SPLIT_BY := aSqlItem.SPLIT_BY;
1730 aPlsqlItem.LINE_SET_ID := aSqlItem.LINE_SET_ID;
1731 aPlsqlItem.UNIT_LIST_PERCENT := aSqlItem.UNIT_LIST_PERCENT;
1732 aPlsqlItem.UNIT_SELLING_PERCENT := aSqlItem.UNIT_SELLING_PERCENT;
1733 aPlsqlItem.UNIT_PERCENT_BASE_PRICE := aSqlItem.UNIT_PERCENT_BASE_PRICE;
1734 aPlsqlItem.RE_SOURCE_FLAG := aSqlItem.RE_SOURCE_FLAG;
1735 aPlsqlItem.FLOW_STATUS_CODE := aSqlItem.FLOW_STATUS_CODE;
1736 aPlsqlItem.UNIT_LIST_PRICE_PER_PQTY := aSqlItem.UNIT_LIST_PRICE_PER_PQTY;
1737 aPlsqlItem.UNIT_SELLING_PRICE_PQTY := aSqlItem.UNIT_SELLING_PRICE_PQTY;
1738 aPlsqlItem.ITEM_RELATIONSHIP_TYPE := aSqlItem.ITEM_RELATIONSHIP_TYPE;
1739 aPlsqlItem.HEADER_ID := aSqlItem.HEADER_ID;
1740 aPlsqlItem.ORIG_SYS_DOCUMENT_REF := aSqlItem.ORIG_SYS_DOCUMENT_REF;
1741 aPlsqlItem.ORIG_SYS_LINE_REF := aSqlItem.ORIG_SYS_LINE_REF;
1742 aPlsqlItem.CHANGE_DATE := aSqlItem.CHANGE_DATE;
1743 aPlsqlItem.CHANGE_SEQUENCE := aSqlItem.CHANGE_SEQUENCE;
1744 aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;
1745 aPlsqlItem.ORDER_NUMBER := aSqlItem.ORDER_NUMBER;
1746 aPlsqlItem.ACCOUNTING_RULE_ID := aSqlItem.ACCOUNTING_RULE_ID;
1747 aPlsqlItem.ACKNOWLEDGMENT_FLAG := aSqlItem.ACKNOWLEDGMENT_FLAG;
1748 aPlsqlItem.FIRST_ACK_CODE := aSqlItem.FIRST_ACK_CODE;
1749 aPlsqlItem.LAST_ACK_CODE := aSqlItem.LAST_ACK_CODE;
1750 aPlsqlItem.FIRST_ACK_DATE := aSqlItem.FIRST_ACK_DATE;
1751 aPlsqlItem.LAST_ACK_DATE := aSqlItem.LAST_ACK_DATE;
1752 aPlsqlItem.BUYER_SELLER_FLAG := aSqlItem.BUYER_SELLER_FLAG;
1753 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
1754 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
1755 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
1756 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
1757 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
1758 aPlsqlItem.ACTUAL_ARRIVAL_DATE := aSqlItem.ACTUAL_ARRIVAL_DATE;
1759 aPlsqlItem.ACTUAL_SHIPMENT_DATE := aSqlItem.ACTUAL_SHIPMENT_DATE;
1760 aPlsqlItem.AGREEMENT := aSqlItem.AGREEMENT;
1761 aPlsqlItem.AGREEMENT_ID := aSqlItem.AGREEMENT_ID;
1762 aPlsqlItem.ARRIVAL_SET_ID := aSqlItem.ARRIVAL_SET_ID;
1763 aPlsqlItem.ARRIVAL_SET_NAME := aSqlItem.ARRIVAL_SET_NAME;
1764 aPlsqlItem.PRICE_LIST := aSqlItem.PRICE_LIST;
1765 aPlsqlItem.PRICE_LIST_ID := aSqlItem.PRICE_LIST_ID;
1766 aPlsqlItem.SHIP_FROM_ORG := aSqlItem.SHIP_FROM_ORG;
1767 aPlsqlItem.SHIP_FROM_ORG_ID := aSqlItem.SHIP_FROM_ORG_ID;
1768 aPlsqlItem.SHIP_TO_ORG := aSqlItem.SHIP_TO_ORG;
1769 aPlsqlItem.SHIP_TO_ORG_ID := aSqlItem.SHIP_TO_ORG_ID;
1770 aPlsqlItem.SOLD_FROM_ORG := aSqlItem.SOLD_FROM_ORG;
1771 aPlsqlItem.SOLD_FROM_ORG_ID := aSqlItem.SOLD_FROM_ORG_ID;
1772 aPlsqlItem.SOLD_TO_ORG := aSqlItem.SOLD_TO_ORG;
1773 aPlsqlItem.SOLD_TO_ORG_ID := aSqlItem.SOLD_TO_ORG_ID;
1774 aPlsqlItem.ATO_LINE_ID := aSqlItem.ATO_LINE_ID;
1775 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
1776 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
1777 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
1778 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
1779 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
1780 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
1781 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
1782 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
1783 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
1784 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
1785 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
1786 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
1787 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
1788 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
1789 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
1790 aPlsqlItem.AUTHORIZED_TO_SHIP_FLAG := aSqlItem.AUTHORIZED_TO_SHIP_FLAG;
1791 aPlsqlItem.BOOKED_FLAG := aSqlItem.BOOKED_FLAG;
1792 aPlsqlItem.CALCULATE_PRICE_FLAG := aSqlItem.CALCULATE_PRICE_FLAG;
1793 aPlsqlItem.CANCELLED_FLAG := aSqlItem.CANCELLED_FLAG;
1794 aPlsqlItem.CANCELLED_QUANTITY := aSqlItem.CANCELLED_QUANTITY;
1795 aPlsqlItem.CLOSED_FLAG := aSqlItem.CLOSED_FLAG;
1796 aPlsqlItem.COMMITMENT_ID := aSqlItem.COMMITMENT_ID;
1797 aPlsqlItem.COMPONENT_CODE := aSqlItem.COMPONENT_CODE;
1798 aPlsqlItem.COMPONENT_NUMBER := aSqlItem.COMPONENT_NUMBER;
1799 aPlsqlItem.COMPONENT_SEQUENCE_ID := aSqlItem.COMPONENT_SEQUENCE_ID;
1800 aPlsqlItem.CONFIG_DISPLAY_SEQUENCE := aSqlItem.CONFIG_DISPLAY_SEQUENCE;
1801 aPlsqlItem.CONFIGURATION_ID := aSqlItem.CONFIGURATION_ID;
1802 aPlsqlItem.CONFIG_LINE_REF := aSqlItem.CONFIG_LINE_REF;
1803 aPlsqlItem.TOP_MODEL_LINE_ID := aSqlItem.TOP_MODEL_LINE_ID;
1804 aPlsqlItem.CONTEXT := aSqlItem.CONTEXT;
1805 aPlsqlItem.CONTRACT_PO_NUMBER := aSqlItem.CONTRACT_PO_NUMBER;
1806 aPlsqlItem.COST_TYPE := aSqlItem.COST_TYPE;
1807 aPlsqlItem.COST_TYPE_ID := aSqlItem.COST_TYPE_ID;
1808 aPlsqlItem.COSTING_DATE := aSqlItem.COSTING_DATE;
1809 aPlsqlItem.CUST_MODEL_SERIAL_NUMBER := aSqlItem.CUST_MODEL_SERIAL_NUMBER;
1810 aPlsqlItem.CUST_PO_NUMBER := aSqlItem.CUST_PO_NUMBER;
1811 aPlsqlItem.CUST_PRODUCTION_SEQ_NUM := aSqlItem.CUST_PRODUCTION_SEQ_NUM;
1812 aPlsqlItem.CUSTOMER_DOCK := aSqlItem.CUSTOMER_DOCK;
1813 aPlsqlItem.CUSTOMER_DOCK_CODE := aSqlItem.CUSTOMER_DOCK_CODE;
1814 aPlsqlItem.CUSTOMER_ITEM := aSqlItem.CUSTOMER_ITEM;
1815 aPlsqlItem.CUSTOMER_ITEM_ID := aSqlItem.CUSTOMER_ITEM_ID;
1816 aPlsqlItem.CUSTOMER_ITEM_REVISION := aSqlItem.CUSTOMER_ITEM_REVISION;
1817 aPlsqlItem.CUSTOMER_JOB := aSqlItem.CUSTOMER_JOB;
1818 aPlsqlItem.CUSTOMER_PRODUCTION_LINE := aSqlItem.CUSTOMER_PRODUCTION_LINE;
1819 aPlsqlItem.CUSTOMER_TRX_LINE_ID := aSqlItem.CUSTOMER_TRX_LINE_ID;
1820 aPlsqlItem.DELIVERY_ID := aSqlItem.DELIVERY_ID;
1821 aPlsqlItem.DELIVER_TO_CONTACT := aSqlItem.DELIVER_TO_CONTACT;
1822 RETURN aPlsqlItem;
1823 END SQL_TO_PL3;
1824 FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)
1825 RETURN OE_SYNC_ORDER_PVT_LINE_ACK_TB IS
1826 aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB;
1827 BEGIN
1828 -- initialize the table
1829 aSqlItem := OE_SYNC_ORDER_PVT_LINE_ACK_TB();
1830 aSqlItem.EXTEND(aPlsqlItem.COUNT);
1831 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1832 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL3(aPlsqlItem(I));
1833 END LOOP;
1834 RETURN aSqlItem;
1835 END PL_TO_SQL1;
1836 FUNCTION SQL_TO_PL1(aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB)
1837 RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE IS
1838 aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
1839 BEGIN
1840 FOR I IN 1..aSqlItem.COUNT LOOP
1841 aPlsqlItem(I) := SQL_TO_PL3(aSqlItem(I));
1842 END LOOP;
1843 RETURN aPlsqlItem;
1844 END SQL_TO_PL1;
1845
1846 PROCEDURE Sync_Order (
1847 P_HEADER_ID NUMBER,
1848 P_HDR_REQ_ID NUMBER,
1849 P_LINE_ID NUMBER,
1850 P_LIN_REQ_ID NUMBER,
1851 P_HOLD_SOURCE_ID NUMBER,
1852 P_ORDER_HOLD_ID NUMBER,
1853 P_CHANGE_TYPE VARCHAR2,
1854 P_HDR_ACK_TBL OUT NOCOPY OE_SYNC_ORDER_PVT_HEADER_ACK_,
1855 P_LINE_ACK_TBL OUT NOCOPY OE_SYNC_ORDER_PVT_LINE_ACK_TB,
1856 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1857 X_MSG_COUNT OUT NOCOPY NUMBER,
1858 X_MSG_DATA OUT NOCOPY VARCHAR2)
1859 IS
1860
1861 P_HDR_ACK_TBL_ OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
1862 P_LINE_ACK_TBL_ OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
1863 BEGIN
1864
1865 oe_debug_pub.add('Entering Procedure Sync_Order');
1866
1867 OE_SYNC_ORDER_PVT.PROCESS_ORDER_SYNC(
1868 P_HEADER_ID,
1869 P_HDR_REQ_ID,
1870 P_LINE_ID,
1871 P_LIN_REQ_ID,
1872 P_HOLD_SOURCE_ID,
1873 P_ORDER_HOLD_ID,
1874 P_CHANGE_TYPE,
1875 P_HDR_ACK_TBL_,
1876 P_LINE_ACK_TBL_,
1877 X_RETURN_STATUS,
1878 X_MSG_COUNT,
1879 X_MSG_DATA);
1880
1881 IF P_HDR_ACK_TBL_.count > 0 THEN
1882 oe_debug_pub.add('Before assigning P_HDR_ACK_TBL');
1883 P_HDR_ACK_TBL := BPEL_UPDATEORDEREBS11I10TOCOMS.PL_TO_SQL0(P_HDR_ACK_TBL_);
1884 oe_debug_pub.add('After assigning P_HDR_ACK_TBL');
1885 END IF;
1886
1887 IF P_LINE_ACK_TBL_.count > 0 THEN
1888 oe_debug_pub.add('Before assigning P_LINE_ACK_TBL');
1889 P_LINE_ACK_TBL := BPEL_UPDATEORDEREBS11I10TOCOMS.PL_TO_SQL1(P_LINE_ACK_TBL_);
1890 oe_debug_pub.add('After assigning P_LINE_ACK_TBL');
1891 END IF;
1892
1893 oe_debug_pub.add('Exiting Procedure Sync_Order');
1894 END Sync_Order;
1895
1896 ----- O2C25
1897 PROCEDURE Sync_Order_25
1898 (P_HEADER_ID NUMBER,
1899 P_HDR_REQ_ID NUMBER,
1900 P_LINE_ID NUMBER,
1901 P_LIN_REQ_ID NUMBER,
1902 P_HOLD_SOURCE_ID NUMBER,
1903 P_ORDER_HOLD_ID NUMBER,
1904 P_CHANGE_TYPE VARCHAR2,
1905 P_HDR_ACK_TBL25 OUT NOCOPY oe_ack_pub_hdr_tab25,
1906 P_LINE_ACK_TBL25 OUT NOCOPY oe_ack_pub_line_tab25,
1907 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1908 X_MSG_COUNT OUT NOCOPY NUMBER,
1909 X_MSG_DATA OUT NOCOPY VARCHAR2
1910 )
1911 IS
1912 P_HDR_ACK_TBL_ OE_SYNC_ORDER_PVT_HEADER_ACK_;
1913 P_LINE_ACK_TBL_ OE_SYNC_ORDER_PVT_LINE_ACK_TB;
1914
1915 l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1916 BEGIN
1917 IF l_debug_level > 0 THEN
1918 oe_debug_pub.add('Entering Procedure Sync_Order_25', 1);
1919 END IF;
1920
1921 IF l_debug_level > 0 THEN
1922 oe_debug_pub.ADD(' Before calling Oe_Inbound_Int.Sync_Order...', 1);
1923 END IF;
1924
1925 Oe_Outbound_Int.Sync_Order(
1926 P_HEADER_ID,
1927 P_HDR_REQ_ID,
1928 P_LINE_ID,
1929 P_LIN_REQ_ID,
1930 P_HOLD_SOURCE_ID,
1931 P_ORDER_HOLD_ID,
1932 P_CHANGE_TYPE,
1933 P_HDR_ACK_TBL_,
1934 P_LINE_ACK_TBL_,
1935 X_RETURN_STATUS,
1936 X_MSG_COUNT,
1937 X_MSG_DATA
1938 );
1939
1940 IF l_debug_level > 0 THEN
1941 oe_debug_pub.ADD(' After returning from Oe_Inbound_Int.Sync_Order...', 1);
1942 END IF;
1943
1944 BEGIN
1945 IF P_HDR_ACK_TBL_.count > 0 THEN
1946 IF l_debug_level > 0 THEN
1947 oe_debug_pub.add('Before assigning P_HDR_ACK_TBL25', 1);
1948 END IF;
1949 -- Write conversion logic between the PL/SQL record type and the
1950 -- PL/SQL object type.
1951 Oe_Genesis_Util.hdr_ack_tab_to_hdr_ack_tab25(
1952 p_hdr_ack_tab => P_HDR_ACK_TBL_,
1953 x_hdr_ack_tab25 => P_HDR_ACK_TBL25
1954 );
1955
1956 IF l_debug_level > 0 THEN
1957 oe_debug_pub.add('After assigning P_HDR_ACK_TBL25', 1);
1958 END IF;
1959 END IF;
1960 EXCEPTION
1961 WHEN Others THEN
1962 IF l_debug_level > 0 THEN
1963 oe_debug_pub.ADD(' Exception in deriving p_hdr_ack_tbl25 records.');
1964 oe_debug_pub.ADD(' Error: ' || SQLERRM);
1965 END IF;
1966 END;
1967
1968 BEGIN
1969 IF P_LINE_ACK_TBL_.count > 0 THEN
1970 -- Write conversion logic between the PL/SQL record type and the
1971 -- PL/SQL object type.
1972 IF l_debug_level > 0 THEN
1973 oe_debug_pub.add('Before assigning P_LINE_ACK_TBL25', 1);
1974 END IF;
1975
1976 Oe_Genesis_Util.line_ack_tab_to_line_ack_tab25(
1977 p_line_ack_tab => P_LINE_ACK_TBL_ ,
1978 x_line_ack_tab25 => P_LINE_ACK_TBL25
1979 );
1980
1981 IF l_debug_level > 0 THEN
1982 oe_debug_pub.add('After assigning P_LINE_ACK_TBL25', 1);
1983 END IF;
1984 END IF;
1985 EXCEPTION
1986 -- This happens when only a header level action is performed e.g.,
1987 -- header level hold.
1988 WHEN Others THEN
1989 IF l_debug_level > 0 THEN
1990 oe_debug_pub.ADD(' Exception in deriving p_line_ack_tbl25 records.');
1991 oe_debug_pub.ADD(' Error: ' || SQLERRM);
1992 END IF;
1993 END;
1994
1995
1996 -- Based on the profile options' set up, derive/compute the values of
1997 -- freight charges and tax roll-up on the acknowledgement header/line
1998 -- objects.
1999
2000 -- Header level tax roll-up is required.
2001 IF Nvl(fnd_profile.Value('ONT_TAX_ROLLUP_HDR_AIA'), fnd_api.g_miss_char)
2002 = 'Y'
2003 THEN
2004 IF l_debug_level > 0 THEN
2005 oe_debug_pub.ADD(' Profile ONT_TAX_ROLLUP_HDR_AIA has a value: Y');
2006 END IF;
2007
2008 BEGIN
2009 FOR i IN p_hdr_ack_tbl25.first..p_hdr_ack_tbl25.last
2010 LOOP
2011 Oe_Oe_Totals_Summary.Global_Totals(p_hdr_ack_tbl25(i).header_id);
2012 p_hdr_ack_tbl25(i).tax_value :=
2013 Oe_Oe_Totals_Summary.Taxes(p_hdr_ack_tbl25(i).header_id);
2014 END LOOP;
2015 EXCEPTION
2016 WHEN Others THEN
2017 IF l_debug_level > 0 THEN
2018 oe_debug_pub.ADD(' Exception in looping over p_hdr_ack_tbl25...');
2019 oe_debug_pub.ADD(' Error: ' || SQLERRM);
2020 END IF;
2021 END;
2022 END IF; -- Check on ONT_TAX_ROLLUP_HDR_AIA profile option value.
2023
2024 -- Header level freight charges roll up is required.
2025 IF Nvl(fnd_profile.Value('ONT_CHARGES_ROLLUP_HDR_AIA'), fnd_api.g_miss_char)
2026 = 'Y'
2027 THEN
2028 IF l_debug_level > 0 THEN
2029 oe_debug_pub.ADD(' Profile ONT_CHARGES_ROLLUP_HDR_AIA has a value: Y');
2030 END IF;
2031
2032 BEGIN
2033 FOR i IN p_hdr_ack_tbl25.first..p_hdr_ack_tbl25.last
2034 LOOP
2035 p_hdr_ack_tbl25(i).freight_charge :=
2036 Oe_Oe_Totals_Summary.Charges(p_hdr_ack_tbl25(i).header_id);
2037 END LOOP;
2038 EXCEPTION
2039 WHEN Others THEN
2040 IF l_debug_level > 0 THEN
2041 oe_debug_pub.ADD(' Exception in looping over p_hdr_ack_tbl25...');
2042 oe_debug_pub.ADD(' Error: ' || SQLERRM);
2043 END IF;
2044 END;
2045 END IF; -- Check on ONT_CHARGES_ROLLUP_HDR_AIA profile option value.
2046
2047 -- Line level freight charges rollup is required.
2048 IF Nvl(fnd_profile.Value('ONT_CHARGES_ROLLUP_LINE_AIA'), fnd_api.g_miss_char)
2049 = 'Y'
2050 THEN
2051 IF l_debug_level > 0 THEN
2052 oe_debug_pub.ADD(' Profile ONT_CHARGES_ROLLUP_HDR_AIA has a value: Y');
2053 END IF;
2054
2055 BEGIN
2056 FOR i IN p_line_ack_tbl25.first..p_line_ack_tbl25.last
2057 LOOP
2058 p_line_ack_tbl25(i).freight_charge :=
2059 Oe_Oe_Totals_Summary.Line_Charges(
2060 p_line_ack_tbl25(i).header_id,
2061 p_line_ack_tbl25(i).line_id
2062 );
2063 END LOOP;
2064 EXCEPTION
2065 WHEN Others THEN
2066 IF l_debug_level > 0 THEN
2067 oe_debug_pub.ADD(' Exception in looping over p_hdr_ack_tbl25...');
2068 oe_debug_pub.ADD(' Error: ' || SQLERRM);
2069 END IF;
2070 END;
2071 END IF; -- Check on ONT_CHARGES_ROLLUP_LINE_AIA profile option value.
2072
2073 IF l_debug_level > 0 THEN
2074 oe_debug_pub.add('Exiting Procedure Sync_Order_25', 1);
2075 END IF;
2076
2077 END;
2078 ----- O2C25
2079
2080
2081 END Oe_Outbound_Int;