[Home] [Help]
PACKAGE BODY: APPS.ASO_QUOTE_EBIZAD
Source
4 * @rep:scope public
1 PACKAGE BODY ASO_QUOTE_EBIZAD AS
2 /* $Header: asopebzb.pls 120.1 2010/08/20 21:31:50 cazhou noship $ */
3 /*
5 * @rep:product ASO
6 * @rep:displayname Order Capture
7 * @rep:lifecycle active
8 * @rep:compatibility S
9 * @rep:category BUSINESS_ENTITY ASO_QUOTE
10 */
11
12
13 /*-- Start of Comments
14 -- Package name : ASO_QUOTE_EBIZAD
15 -- Purpose :
16 -- These public APIs wrapper for the ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE. The wrapper exposes this service to be invoked from the Oracle Apps Adapter by using the SQL
17 -- Object types for the parameter instead of the PL SQL Record types. This is done by defining the Functions to convert from SQL Object type to and from PL SQL Object
18 -- type and in the CREATE_QUOTE_SERVICE procedure invokes the ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE after doing the required convertion from the SQL object type to
19 --PL/SQL record type. The return values from ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE is converted from PL/SQL Record Type to SQL Object types.
20 --
21 -- History : In SQL_TO_PL27 ORGANIZATION_ID is set to FND_API.G_MISS_NUM if NULL to avoid error in creating quote with line items.
22 -- In CREATE_QUOTE_SERVICE call to po_moac_utils_pvt.set_org_context(P_QTE_HEADER_REC_.ORG_ID); added
23 -- NOTE :
24
28
25 -- End of Comments
26 */
27
29 FUNCTION PL_TO_SQL19(aPlsqlItem ASO_QUOTE_PUB.CONTROL_REC_TYPE)
30 RETURN ASO_QUOTE_PUB_CONTROL_REC_TYP IS
31 aSqlItem ASO_QUOTE_PUB_CONTROL_REC_TYP;
32 BEGIN
33 -- initialize the object
34 aSqlItem := ASO_QUOTE_PUB_CONTROL_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
35 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
36 aSqlItem.AUTO_VERSION_FLAG := aPlsqlItem.AUTO_VERSION_FLAG;
37 aSqlItem.PRICING_REQUEST_TYPE := aPlsqlItem.PRICING_REQUEST_TYPE;
38 aSqlItem.HEADER_PRICING_EVENT := aPlsqlItem.HEADER_PRICING_EVENT;
39 aSqlItem.LINE_PRICING_EVENT := aPlsqlItem.LINE_PRICING_EVENT;
40 aSqlItem.CALCULATE_TAX_FLAG := aPlsqlItem.CALCULATE_TAX_FLAG;
41 aSqlItem.CALCULATE_FREIGHT_CHARGE_FLAG := aPlsqlItem.CALCULATE_FREIGHT_CHARGE_FLAG;
42 aSqlItem.FUNCTIONALITY_CODE := aPlsqlItem.FUNCTIONALITY_CODE;
43 aSqlItem.COPY_TASK_FLAG := aPlsqlItem.COPY_TASK_FLAG;
44 aSqlItem.COPY_NOTES_FLAG := aPlsqlItem.COPY_NOTES_FLAG;
45 aSqlItem.COPY_ATT_FLAG := aPlsqlItem.COPY_ATT_FLAG;
46 aSqlItem.DEACTIVATE_ALL := aPlsqlItem.DEACTIVATE_ALL;
47 aSqlItem.PRICE_MODE := aPlsqlItem.PRICE_MODE;
48 aSqlItem.QUOTE_SOURCE := aPlsqlItem.QUOTE_SOURCE;
49 aSqlItem.DEPENDENCY_FLAG := aPlsqlItem.DEPENDENCY_FLAG;
50 aSqlItem.DEFAULTING_FLAG := aPlsqlItem.DEFAULTING_FLAG;
51 aSqlItem.DEFAULTING_FWK_FLAG := aPlsqlItem.DEFAULTING_FWK_FLAG;
52 aSqlItem.APPLICATION_TYPE_CODE := aPlsqlItem.APPLICATION_TYPE_CODE;
53 RETURN aSqlItem;
54 END PL_TO_SQL19;
55 FUNCTION SQL_TO_PL0(aSqlItem ASO_QUOTE_PUB_CONTROL_REC_TYP)
56 RETURN ASO_QUOTE_PUB.CONTROL_REC_TYPE IS
57 aPlsqlItem ASO_QUOTE_PUB.CONTROL_REC_TYPE;
58 BEGIN
59 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
60 aPlsqlItem.AUTO_VERSION_FLAG := aSqlItem.AUTO_VERSION_FLAG;
61 aPlsqlItem.PRICING_REQUEST_TYPE := aSqlItem.PRICING_REQUEST_TYPE;
62 aPlsqlItem.HEADER_PRICING_EVENT := aSqlItem.HEADER_PRICING_EVENT;
63 aPlsqlItem.LINE_PRICING_EVENT := aSqlItem.LINE_PRICING_EVENT;
64 aPlsqlItem.CALCULATE_TAX_FLAG := aSqlItem.CALCULATE_TAX_FLAG;
65 aPlsqlItem.CALCULATE_FREIGHT_CHARGE_FLAG := aSqlItem.CALCULATE_FREIGHT_CHARGE_FLAG;
66 aPlsqlItem.FUNCTIONALITY_CODE := aSqlItem.FUNCTIONALITY_CODE;
67 aPlsqlItem.COPY_TASK_FLAG := aSqlItem.COPY_TASK_FLAG;
68 aPlsqlItem.COPY_NOTES_FLAG := aSqlItem.COPY_NOTES_FLAG;
69 aPlsqlItem.COPY_ATT_FLAG := aSqlItem.COPY_ATT_FLAG;
70 aPlsqlItem.DEACTIVATE_ALL := aSqlItem.DEACTIVATE_ALL;
71 aPlsqlItem.PRICE_MODE := aSqlItem.PRICE_MODE;
72 aPlsqlItem.QUOTE_SOURCE := aSqlItem.QUOTE_SOURCE;
73 aPlsqlItem.DEPENDENCY_FLAG := aSqlItem.DEPENDENCY_FLAG;
74 aPlsqlItem.DEFAULTING_FLAG := aSqlItem.DEFAULTING_FLAG;
75 aPlsqlItem.DEFAULTING_FWK_FLAG := aSqlItem.DEFAULTING_FWK_FLAG;
76 aPlsqlItem.APPLICATION_TYPE_CODE := aSqlItem.APPLICATION_TYPE_CODE;
77 RETURN aPlsqlItem;
78 END SQL_TO_PL0;
79 FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
80 RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_ IS
81 aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_;
82 BEGIN
83 -- initialize the object
84 aSqlItem := ASO_QUOTE_PUB_QTE_HEADER_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
85 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
86 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
87 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
88 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
89 NULL, NULL);
90 aSqlItem.QUOTE_HEADER_ID := aPlsqlItem.QUOTE_HEADER_ID;
91 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
92 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
93 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
94 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
95 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
96 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
97 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
98 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
99 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
100 aSqlItem.ORG_ID := aPlsqlItem.ORG_ID;
101 aSqlItem.QUOTE_NAME := aPlsqlItem.QUOTE_NAME;
102 aSqlItem.QUOTE_NUMBER := aPlsqlItem.QUOTE_NUMBER;
103 aSqlItem.QUOTE_VERSION := aPlsqlItem.QUOTE_VERSION;
104 aSqlItem.QUOTE_STATUS_ID := aPlsqlItem.QUOTE_STATUS_ID;
105 aSqlItem.QUOTE_SOURCE_CODE := aPlsqlItem.QUOTE_SOURCE_CODE;
106 aSqlItem.QUOTE_EXPIRATION_DATE := aPlsqlItem.QUOTE_EXPIRATION_DATE;
107 aSqlItem.PRICE_FROZEN_DATE := aPlsqlItem.PRICE_FROZEN_DATE;
108 aSqlItem.QUOTE_PASSWORD := aPlsqlItem.QUOTE_PASSWORD;
109 aSqlItem.ORIGINAL_SYSTEM_REFERENCE := aPlsqlItem.ORIGINAL_SYSTEM_REFERENCE;
110 aSqlItem.PARTY_ID := aPlsqlItem.PARTY_ID;
111 aSqlItem.CUST_ACCOUNT_ID := aPlsqlItem.CUST_ACCOUNT_ID;
112 aSqlItem.INVOICE_TO_CUST_ACCOUNT_ID := aPlsqlItem.INVOICE_TO_CUST_ACCOUNT_ID;
113 aSqlItem.ORG_CONTACT_ID := aPlsqlItem.ORG_CONTACT_ID;
114 aSqlItem.PHONE_ID := aPlsqlItem.PHONE_ID;
115 aSqlItem.INVOICE_TO_PARTY_SITE_ID := aPlsqlItem.INVOICE_TO_PARTY_SITE_ID;
116 aSqlItem.INVOICE_TO_PARTY_ID := aPlsqlItem.INVOICE_TO_PARTY_ID;
117 aSqlItem.ORIG_MKTG_SOURCE_CODE_ID := aPlsqlItem.ORIG_MKTG_SOURCE_CODE_ID;
118 aSqlItem.MARKETING_SOURCE_CODE_ID := aPlsqlItem.MARKETING_SOURCE_CODE_ID;
119 aSqlItem.ORDER_TYPE_ID := aPlsqlItem.ORDER_TYPE_ID;
120 aSqlItem.QUOTE_CATEGORY_CODE := aPlsqlItem.QUOTE_CATEGORY_CODE;
121 aSqlItem.ORDERED_DATE := aPlsqlItem.ORDERED_DATE;
125 aSqlItem.PRICE_LIST_ID := aPlsqlItem.PRICE_LIST_ID;
122 aSqlItem.ACCOUNTING_RULE_ID := aPlsqlItem.ACCOUNTING_RULE_ID;
123 aSqlItem.INVOICING_RULE_ID := aPlsqlItem.INVOICING_RULE_ID;
124 aSqlItem.EMPLOYEE_PERSON_ID := aPlsqlItem.EMPLOYEE_PERSON_ID;
126 aSqlItem.CURRENCY_CODE := aPlsqlItem.CURRENCY_CODE;
127 aSqlItem.TOTAL_LIST_PRICE := aPlsqlItem.TOTAL_LIST_PRICE;
128 aSqlItem.TOTAL_ADJUSTED_AMOUNT := aPlsqlItem.TOTAL_ADJUSTED_AMOUNT;
129 aSqlItem.TOTAL_ADJUSTED_PERCENT := aPlsqlItem.TOTAL_ADJUSTED_PERCENT;
130 aSqlItem.TOTAL_TAX := aPlsqlItem.TOTAL_TAX;
131 aSqlItem.TOTAL_SHIPPING_CHARGE := aPlsqlItem.TOTAL_SHIPPING_CHARGE;
132 aSqlItem.SURCHARGE := aPlsqlItem.SURCHARGE;
133 aSqlItem.TOTAL_QUOTE_PRICE := aPlsqlItem.TOTAL_QUOTE_PRICE;
134 aSqlItem.PAYMENT_AMOUNT := aPlsqlItem.PAYMENT_AMOUNT;
135 aSqlItem.EXCHANGE_RATE := aPlsqlItem.EXCHANGE_RATE;
136 aSqlItem.EXCHANGE_TYPE_CODE := aPlsqlItem.EXCHANGE_TYPE_CODE;
137 aSqlItem.EXCHANGE_RATE_DATE := aPlsqlItem.EXCHANGE_RATE_DATE;
138 aSqlItem.CONTRACT_ID := aPlsqlItem.CONTRACT_ID;
139 aSqlItem.SALES_CHANNEL_CODE := aPlsqlItem.SALES_CHANNEL_CODE;
140 aSqlItem.ORDER_ID := aPlsqlItem.ORDER_ID;
141 aSqlItem.ORDER_NUMBER := aPlsqlItem.ORDER_NUMBER;
142 aSqlItem.FFM_REQUEST_ID := aPlsqlItem.FFM_REQUEST_ID;
143 aSqlItem.QTE_CONTRACT_ID := aPlsqlItem.QTE_CONTRACT_ID;
144 aSqlItem.ATTRIBUTE_CATEGORY := aPlsqlItem.ATTRIBUTE_CATEGORY;
145 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
146 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
147 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
148 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
149 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
150 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
151 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
152 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
153 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
154 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
155 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
156 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
157 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
158 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
159 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
160 aSqlItem.SALESREP_FIRST_NAME := aPlsqlItem.SALESREP_FIRST_NAME;
161 aSqlItem.SALESREP_LAST_NAME := aPlsqlItem.SALESREP_LAST_NAME;
162 aSqlItem.PRICE_LIST_NAME := aPlsqlItem.PRICE_LIST_NAME;
163 aSqlItem.QUOTE_STATUS_CODE := aPlsqlItem.QUOTE_STATUS_CODE;
164 aSqlItem.QUOTE_STATUS := aPlsqlItem.QUOTE_STATUS;
165 aSqlItem.PARTY_NAME := aPlsqlItem.PARTY_NAME;
166 aSqlItem.PARTY_TYPE := aPlsqlItem.PARTY_TYPE;
167 aSqlItem.PERSON_FIRST_NAME := aPlsqlItem.PERSON_FIRST_NAME;
168 aSqlItem.PERSON_MIDDLE_NAME := aPlsqlItem.PERSON_MIDDLE_NAME;
169 aSqlItem.PERSON_LAST_NAME := aPlsqlItem.PERSON_LAST_NAME;
170 aSqlItem.MARKETING_SOURCE_NAME := aPlsqlItem.MARKETING_SOURCE_NAME;
171 aSqlItem.MARKETING_SOURCE_CODE := aPlsqlItem.MARKETING_SOURCE_CODE;
172 aSqlItem.ORDER_TYPE_NAME := aPlsqlItem.ORDER_TYPE_NAME;
173 aSqlItem.INVOICE_TO_PARTY_NAME := aPlsqlItem.INVOICE_TO_PARTY_NAME;
174 aSqlItem.INVOICE_TO_CONTACT_FIRST_NAME := aPlsqlItem.INVOICE_TO_CONTACT_FIRST_NAME;
175 aSqlItem.INVOICE_TO_CONTACT_MIDDLE_NAME := aPlsqlItem.INVOICE_TO_CONTACT_MIDDLE_NAME;
176 aSqlItem.INVOICE_TO_CONTACT_LAST_NAME := aPlsqlItem.INVOICE_TO_CONTACT_LAST_NAME;
177 aSqlItem.INVOICE_TO_ADDRESS1 := aPlsqlItem.INVOICE_TO_ADDRESS1;
178 aSqlItem.INVOICE_TO_ADDRESS2 := aPlsqlItem.INVOICE_TO_ADDRESS2;
179 aSqlItem.INVOICE_TO_ADDRESS3 := aPlsqlItem.INVOICE_TO_ADDRESS3;
180 aSqlItem.INVOICE_TO_ADDRESS4 := aPlsqlItem.INVOICE_TO_ADDRESS4;
181 aSqlItem.INVOICE_TO_COUNTRY_CODE := aPlsqlItem.INVOICE_TO_COUNTRY_CODE;
182 aSqlItem.INVOICE_TO_COUNTRY := aPlsqlItem.INVOICE_TO_COUNTRY;
183 aSqlItem.INVOICE_TO_CITY := aPlsqlItem.INVOICE_TO_CITY;
184 aSqlItem.INVOICE_TO_POSTAL_CODE := aPlsqlItem.INVOICE_TO_POSTAL_CODE;
185 aSqlItem.INVOICE_TO_STATE := aPlsqlItem.INVOICE_TO_STATE;
186 aSqlItem.INVOICE_TO_PROVINCE := aPlsqlItem.INVOICE_TO_PROVINCE;
187 aSqlItem.INVOICE_TO_COUNTY := aPlsqlItem.INVOICE_TO_COUNTY;
188 aSqlItem.RESOURCE_ID := aPlsqlItem.RESOURCE_ID;
189 aSqlItem.CONTRACT_TEMPLATE_ID := aPlsqlItem.CONTRACT_TEMPLATE_ID;
190 aSqlItem.CONTRACT_TEMPLATE_MAJOR_VER := aPlsqlItem.CONTRACT_TEMPLATE_MAJOR_VER;
191 aSqlItem.CONTRACT_REQUESTER_ID := aPlsqlItem.CONTRACT_REQUESTER_ID;
192 aSqlItem.CONTRACT_APPROVAL_LEVEL := aPlsqlItem.CONTRACT_APPROVAL_LEVEL;
193 aSqlItem.PUBLISH_FLAG := aPlsqlItem.PUBLISH_FLAG;
194 aSqlItem.RESOURCE_GRP_ID := aPlsqlItem.RESOURCE_GRP_ID;
195 aSqlItem.SOLD_TO_PARTY_SITE_ID := aPlsqlItem.SOLD_TO_PARTY_SITE_ID;
196 aSqlItem.DISPLAY_ARITHMETIC_OPERATOR := aPlsqlItem.DISPLAY_ARITHMETIC_OPERATOR;
197 aSqlItem.MAX_VERSION_FLAG := aPlsqlItem.MAX_VERSION_FLAG;
198 aSqlItem.QUOTE_TYPE := aPlsqlItem.QUOTE_TYPE;
199 aSqlItem.QUOTE_DESCRIPTION := aPlsqlItem.QUOTE_DESCRIPTION;
200 aSqlItem.CALL_BATCH_VALIDATION_FLAG := aPlsqlItem.CALL_BATCH_VALIDATION_FLAG;
201 aSqlItem.CUST_PARTY_ID := aPlsqlItem.CUST_PARTY_ID;
202 aSqlItem.INVOICE_TO_CUST_PARTY_ID := aPlsqlItem.INVOICE_TO_CUST_PARTY_ID;
203 aSqlItem.MINISITE_ID := aPlsqlItem.MINISITE_ID;
204 aSqlItem.PRICING_STATUS_INDICATOR := aPlsqlItem.PRICING_STATUS_INDICATOR;
205 aSqlItem.TAX_STATUS_INDICATOR := aPlsqlItem.TAX_STATUS_INDICATOR;
206 aSqlItem.PRICE_UPDATED_DATE := aPlsqlItem.PRICE_UPDATED_DATE;
207 aSqlItem.TAX_UPDATED_DATE := aPlsqlItem.TAX_UPDATED_DATE;
208 aSqlItem.RECALCULATE_FLAG := aPlsqlItem.RECALCULATE_FLAG;
209 aSqlItem.BATCH_PRICE_FLAG := aPlsqlItem.BATCH_PRICE_FLAG;
210 aSqlItem.PRICE_REQUEST_ID := aPlsqlItem.PRICE_REQUEST_ID;
211 aSqlItem.CREDIT_UPDATE_DATE := aPlsqlItem.CREDIT_UPDATE_DATE;
212 aSqlItem.CUSTOMER_NAME_AND_TITLE := aPlsqlItem.CUSTOMER_NAME_AND_TITLE;
213 aSqlItem.CUSTOMER_SIGNATURE_DATE := aPlsqlItem.CUSTOMER_SIGNATURE_DATE;
214 aSqlItem.SUPPLIER_NAME_AND_TITLE := aPlsqlItem.SUPPLIER_NAME_AND_TITLE;
215 aSqlItem.SUPPLIER_SIGNATURE_DATE := aPlsqlItem.SUPPLIER_SIGNATURE_DATE;
216 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
220 aSqlItem.AUTOMATIC_TAX_FLAG := aPlsqlItem.AUTOMATIC_TAX_FLAG;
217 aSqlItem.ASSISTANCE_REQUESTED := aPlsqlItem.ASSISTANCE_REQUESTED;
218 aSqlItem.ASSISTANCE_REASON_CODE := aPlsqlItem.ASSISTANCE_REASON_CODE;
219 aSqlItem.AUTOMATIC_PRICE_FLAG := aPlsqlItem.AUTOMATIC_PRICE_FLAG;
221 aSqlItem.END_CUSTOMER_PARTY_ID := aPlsqlItem.END_CUSTOMER_PARTY_ID;
222 aSqlItem.END_CUSTOMER_PARTY_SITE_ID := aPlsqlItem.END_CUSTOMER_PARTY_SITE_ID;
223 aSqlItem.END_CUSTOMER_CUST_ACCOUNT_ID := aPlsqlItem.END_CUSTOMER_CUST_ACCOUNT_ID;
224 aSqlItem.END_CUSTOMER_CUST_PARTY_ID := aPlsqlItem.END_CUSTOMER_CUST_PARTY_ID;
225 aSqlItem.ATTRIBUTE16 := aPlsqlItem.ATTRIBUTE16;
226 aSqlItem.ATTRIBUTE17 := aPlsqlItem.ATTRIBUTE17;
227 aSqlItem.ATTRIBUTE18 := aPlsqlItem.ATTRIBUTE18;
228 aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
229 aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
230 aSqlItem.HEADER_PAYNOW_CHARGES := aPlsqlItem.HEADER_PAYNOW_CHARGES;
231 RETURN aSqlItem;
232 END PL_TO_SQL0;
233 FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)
234 RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE IS
235 aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
236 BEGIN
237 aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
238 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
239 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
240 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
241 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
242 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
243 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
244 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
245 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
246 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
247 aPlsqlItem.ORG_ID := aSqlItem.ORG_ID;
248 aPlsqlItem.QUOTE_NAME := aSqlItem.QUOTE_NAME;
249 aPlsqlItem.QUOTE_NUMBER := aSqlItem.QUOTE_NUMBER;
250 aPlsqlItem.QUOTE_VERSION := aSqlItem.QUOTE_VERSION;
251 aPlsqlItem.QUOTE_STATUS_ID := aSqlItem.QUOTE_STATUS_ID;
252 aPlsqlItem.QUOTE_SOURCE_CODE := aSqlItem.QUOTE_SOURCE_CODE;
253 aPlsqlItem.QUOTE_EXPIRATION_DATE := aSqlItem.QUOTE_EXPIRATION_DATE;
254 aPlsqlItem.PRICE_FROZEN_DATE := aSqlItem.PRICE_FROZEN_DATE;
255 aPlsqlItem.QUOTE_PASSWORD := aSqlItem.QUOTE_PASSWORD;
256 aPlsqlItem.ORIGINAL_SYSTEM_REFERENCE := aSqlItem.ORIGINAL_SYSTEM_REFERENCE;
257 aPlsqlItem.PARTY_ID := aSqlItem.PARTY_ID;
258 aPlsqlItem.CUST_ACCOUNT_ID := aSqlItem.CUST_ACCOUNT_ID;
259 aPlsqlItem.INVOICE_TO_CUST_ACCOUNT_ID := aSqlItem.INVOICE_TO_CUST_ACCOUNT_ID;
260 aPlsqlItem.ORG_CONTACT_ID := aSqlItem.ORG_CONTACT_ID;
261 aPlsqlItem.PHONE_ID := aSqlItem.PHONE_ID;
262 aPlsqlItem.INVOICE_TO_PARTY_SITE_ID := aSqlItem.INVOICE_TO_PARTY_SITE_ID;
263 aPlsqlItem.INVOICE_TO_PARTY_ID := aSqlItem.INVOICE_TO_PARTY_ID;
264 aPlsqlItem.ORIG_MKTG_SOURCE_CODE_ID := aSqlItem.ORIG_MKTG_SOURCE_CODE_ID;
265 aPlsqlItem.MARKETING_SOURCE_CODE_ID := aSqlItem.MARKETING_SOURCE_CODE_ID;
266 aPlsqlItem.ORDER_TYPE_ID := aSqlItem.ORDER_TYPE_ID;
267 aPlsqlItem.QUOTE_CATEGORY_CODE := aSqlItem.QUOTE_CATEGORY_CODE;
268 aPlsqlItem.ORDERED_DATE := aSqlItem.ORDERED_DATE;
269 aPlsqlItem.ACCOUNTING_RULE_ID := aSqlItem.ACCOUNTING_RULE_ID;
270 aPlsqlItem.INVOICING_RULE_ID := aSqlItem.INVOICING_RULE_ID;
271 aPlsqlItem.EMPLOYEE_PERSON_ID := aSqlItem.EMPLOYEE_PERSON_ID;
272 aPlsqlItem.PRICE_LIST_ID := aSqlItem.PRICE_LIST_ID;
273 aPlsqlItem.CURRENCY_CODE := aSqlItem.CURRENCY_CODE;
274 aPlsqlItem.TOTAL_LIST_PRICE := aSqlItem.TOTAL_LIST_PRICE;
275 aPlsqlItem.TOTAL_ADJUSTED_AMOUNT := aSqlItem.TOTAL_ADJUSTED_AMOUNT;
276 aPlsqlItem.TOTAL_ADJUSTED_PERCENT := aSqlItem.TOTAL_ADJUSTED_PERCENT;
277 aPlsqlItem.TOTAL_TAX := aSqlItem.TOTAL_TAX;
278 aPlsqlItem.TOTAL_SHIPPING_CHARGE := aSqlItem.TOTAL_SHIPPING_CHARGE;
279 aPlsqlItem.SURCHARGE := aSqlItem.SURCHARGE;
280 aPlsqlItem.TOTAL_QUOTE_PRICE := aSqlItem.TOTAL_QUOTE_PRICE;
281 aPlsqlItem.PAYMENT_AMOUNT := aSqlItem.PAYMENT_AMOUNT;
282 aPlsqlItem.EXCHANGE_RATE := aSqlItem.EXCHANGE_RATE;
283 aPlsqlItem.EXCHANGE_TYPE_CODE := aSqlItem.EXCHANGE_TYPE_CODE;
284 aPlsqlItem.EXCHANGE_RATE_DATE := aSqlItem.EXCHANGE_RATE_DATE;
285 aPlsqlItem.CONTRACT_ID := aSqlItem.CONTRACT_ID;
286 aPlsqlItem.SALES_CHANNEL_CODE := aSqlItem.SALES_CHANNEL_CODE;
287 aPlsqlItem.ORDER_ID := aSqlItem.ORDER_ID;
288 aPlsqlItem.ORDER_NUMBER := aSqlItem.ORDER_NUMBER;
289 aPlsqlItem.FFM_REQUEST_ID := aSqlItem.FFM_REQUEST_ID;
290 aPlsqlItem.QTE_CONTRACT_ID := aSqlItem.QTE_CONTRACT_ID;
291 aPlsqlItem.ATTRIBUTE_CATEGORY := aSqlItem.ATTRIBUTE_CATEGORY;
292 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
293 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
294 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
295 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
296 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
297 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
298 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
299 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
300 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
301 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
302 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
303 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
304 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
305 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
306 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
307 aPlsqlItem.SALESREP_FIRST_NAME := aSqlItem.SALESREP_FIRST_NAME;
308 aPlsqlItem.SALESREP_LAST_NAME := aSqlItem.SALESREP_LAST_NAME;
309 aPlsqlItem.PRICE_LIST_NAME := aSqlItem.PRICE_LIST_NAME;
310 aPlsqlItem.QUOTE_STATUS_CODE := aSqlItem.QUOTE_STATUS_CODE;
311 aPlsqlItem.QUOTE_STATUS := aSqlItem.QUOTE_STATUS;
312 aPlsqlItem.PARTY_NAME := aSqlItem.PARTY_NAME;
313 aPlsqlItem.PARTY_TYPE := aSqlItem.PARTY_TYPE;
314 aPlsqlItem.PERSON_FIRST_NAME := aSqlItem.PERSON_FIRST_NAME;
315 aPlsqlItem.PERSON_MIDDLE_NAME := aSqlItem.PERSON_MIDDLE_NAME;
316 aPlsqlItem.PERSON_LAST_NAME := aSqlItem.PERSON_LAST_NAME;
320 aPlsqlItem.INVOICE_TO_PARTY_NAME := aSqlItem.INVOICE_TO_PARTY_NAME;
317 aPlsqlItem.MARKETING_SOURCE_NAME := aSqlItem.MARKETING_SOURCE_NAME;
318 aPlsqlItem.MARKETING_SOURCE_CODE := aSqlItem.MARKETING_SOURCE_CODE;
319 aPlsqlItem.ORDER_TYPE_NAME := aSqlItem.ORDER_TYPE_NAME;
321 aPlsqlItem.INVOICE_TO_CONTACT_FIRST_NAME := aSqlItem.INVOICE_TO_CONTACT_FIRST_NAME;
322 aPlsqlItem.INVOICE_TO_CONTACT_MIDDLE_NAME := aSqlItem.INVOICE_TO_CONTACT_MIDDLE_NAME;
323 aPlsqlItem.INVOICE_TO_CONTACT_LAST_NAME := aSqlItem.INVOICE_TO_CONTACT_LAST_NAME;
324 aPlsqlItem.INVOICE_TO_ADDRESS1 := aSqlItem.INVOICE_TO_ADDRESS1;
325 aPlsqlItem.INVOICE_TO_ADDRESS2 := aSqlItem.INVOICE_TO_ADDRESS2;
326 aPlsqlItem.INVOICE_TO_ADDRESS3 := aSqlItem.INVOICE_TO_ADDRESS3;
327 aPlsqlItem.INVOICE_TO_ADDRESS4 := aSqlItem.INVOICE_TO_ADDRESS4;
328 aPlsqlItem.INVOICE_TO_COUNTRY_CODE := aSqlItem.INVOICE_TO_COUNTRY_CODE;
329 aPlsqlItem.INVOICE_TO_COUNTRY := aSqlItem.INVOICE_TO_COUNTRY;
330 aPlsqlItem.INVOICE_TO_CITY := aSqlItem.INVOICE_TO_CITY;
331 aPlsqlItem.INVOICE_TO_POSTAL_CODE := aSqlItem.INVOICE_TO_POSTAL_CODE;
332 aPlsqlItem.INVOICE_TO_STATE := aSqlItem.INVOICE_TO_STATE;
333 aPlsqlItem.INVOICE_TO_PROVINCE := aSqlItem.INVOICE_TO_PROVINCE;
334 aPlsqlItem.INVOICE_TO_COUNTY := aSqlItem.INVOICE_TO_COUNTY;
335 aPlsqlItem.RESOURCE_ID := aSqlItem.RESOURCE_ID;
336 aPlsqlItem.CONTRACT_TEMPLATE_ID := aSqlItem.CONTRACT_TEMPLATE_ID;
337 aPlsqlItem.CONTRACT_TEMPLATE_MAJOR_VER := aSqlItem.CONTRACT_TEMPLATE_MAJOR_VER;
338 aPlsqlItem.CONTRACT_REQUESTER_ID := aSqlItem.CONTRACT_REQUESTER_ID;
339 aPlsqlItem.CONTRACT_APPROVAL_LEVEL := aSqlItem.CONTRACT_APPROVAL_LEVEL;
340 aPlsqlItem.PUBLISH_FLAG := aSqlItem.PUBLISH_FLAG;
341 aPlsqlItem.RESOURCE_GRP_ID := aSqlItem.RESOURCE_GRP_ID;
342 aPlsqlItem.SOLD_TO_PARTY_SITE_ID := aSqlItem.SOLD_TO_PARTY_SITE_ID;
343 aPlsqlItem.DISPLAY_ARITHMETIC_OPERATOR := aSqlItem.DISPLAY_ARITHMETIC_OPERATOR;
344 aPlsqlItem.MAX_VERSION_FLAG := aSqlItem.MAX_VERSION_FLAG;
345 aPlsqlItem.QUOTE_TYPE := aSqlItem.QUOTE_TYPE;
346 aPlsqlItem.QUOTE_DESCRIPTION := aSqlItem.QUOTE_DESCRIPTION;
347 aPlsqlItem.CALL_BATCH_VALIDATION_FLAG := aSqlItem.CALL_BATCH_VALIDATION_FLAG;
348 aPlsqlItem.CUST_PARTY_ID := aSqlItem.CUST_PARTY_ID;
349 aPlsqlItem.INVOICE_TO_CUST_PARTY_ID := aSqlItem.INVOICE_TO_CUST_PARTY_ID;
350 aPlsqlItem.MINISITE_ID := aSqlItem.MINISITE_ID;
351 aPlsqlItem.PRICING_STATUS_INDICATOR := aSqlItem.PRICING_STATUS_INDICATOR;
352 aPlsqlItem.TAX_STATUS_INDICATOR := aSqlItem.TAX_STATUS_INDICATOR;
353 aPlsqlItem.PRICE_UPDATED_DATE := aSqlItem.PRICE_UPDATED_DATE;
354 aPlsqlItem.TAX_UPDATED_DATE := aSqlItem.TAX_UPDATED_DATE;
355 aPlsqlItem.RECALCULATE_FLAG := aSqlItem.RECALCULATE_FLAG;
356 aPlsqlItem.BATCH_PRICE_FLAG := aSqlItem.BATCH_PRICE_FLAG;
357 aPlsqlItem.PRICE_REQUEST_ID := aSqlItem.PRICE_REQUEST_ID;
358 aPlsqlItem.CREDIT_UPDATE_DATE := aSqlItem.CREDIT_UPDATE_DATE;
359 aPlsqlItem.CUSTOMER_NAME_AND_TITLE := aSqlItem.CUSTOMER_NAME_AND_TITLE;
360 aPlsqlItem.CUSTOMER_SIGNATURE_DATE := aSqlItem.CUSTOMER_SIGNATURE_DATE;
361 aPlsqlItem.SUPPLIER_NAME_AND_TITLE := aSqlItem.SUPPLIER_NAME_AND_TITLE;
362 aPlsqlItem.SUPPLIER_SIGNATURE_DATE := aSqlItem.SUPPLIER_SIGNATURE_DATE;
363 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
364 aPlsqlItem.ASSISTANCE_REQUESTED := aSqlItem.ASSISTANCE_REQUESTED;
365 aPlsqlItem.ASSISTANCE_REASON_CODE := aSqlItem.ASSISTANCE_REASON_CODE;
366 aPlsqlItem.AUTOMATIC_PRICE_FLAG := aSqlItem.AUTOMATIC_PRICE_FLAG;
367 aPlsqlItem.AUTOMATIC_TAX_FLAG := aSqlItem.AUTOMATIC_TAX_FLAG;
368 aPlsqlItem.END_CUSTOMER_PARTY_ID := aSqlItem.END_CUSTOMER_PARTY_ID;
369 aPlsqlItem.END_CUSTOMER_PARTY_SITE_ID := aSqlItem.END_CUSTOMER_PARTY_SITE_ID;
370 aPlsqlItem.END_CUSTOMER_CUST_ACCOUNT_ID := aSqlItem.END_CUSTOMER_CUST_ACCOUNT_ID;
371 aPlsqlItem.END_CUSTOMER_CUST_PARTY_ID := aSqlItem.END_CUSTOMER_CUST_PARTY_ID;
372 aPlsqlItem.ATTRIBUTE16 := aSqlItem.ATTRIBUTE16;
373 aPlsqlItem.ATTRIBUTE17 := aSqlItem.ATTRIBUTE17;
374 aPlsqlItem.ATTRIBUTE18 := aSqlItem.ATTRIBUTE18;
375 aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
376 aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
377 aPlsqlItem.HEADER_PAYNOW_CHARGES := aSqlItem.HEADER_PAYNOW_CHARGES;
378 RETURN aPlsqlItem;
379 END SQL_TO_PL1;
380 FUNCTION PL_TO_SQL20(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE)
381 RETURN ASO_QUOTE_PUB_PRICE_ATTRIBU34 IS
382 aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34;
383 BEGIN
384 -- initialize the object
385 aSqlItem := ASO_QUOTE_PUB_PRICE_ATTRIBU34(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
386 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
387 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
388 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
389 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
390 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
391 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
392 aSqlItem.PRICE_ATTRIBUTE_ID := aPlsqlItem.PRICE_ATTRIBUTE_ID;
393 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
394 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
395 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
396 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
397 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
398 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
399 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
400 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
404 aSqlItem.FLEX_TITLE := aPlsqlItem.FLEX_TITLE;
401 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
402 aSqlItem.QUOTE_HEADER_ID := aPlsqlItem.QUOTE_HEADER_ID;
403 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
405 aSqlItem.PRICING_CONTEXT := aPlsqlItem.PRICING_CONTEXT;
406 aSqlItem.PRICING_ATTRIBUTE1 := aPlsqlItem.PRICING_ATTRIBUTE1;
407 aSqlItem.PRICING_ATTRIBUTE2 := aPlsqlItem.PRICING_ATTRIBUTE2;
408 aSqlItem.PRICING_ATTRIBUTE3 := aPlsqlItem.PRICING_ATTRIBUTE3;
409 aSqlItem.PRICING_ATTRIBUTE4 := aPlsqlItem.PRICING_ATTRIBUTE4;
410 aSqlItem.PRICING_ATTRIBUTE5 := aPlsqlItem.PRICING_ATTRIBUTE5;
411 aSqlItem.PRICING_ATTRIBUTE6 := aPlsqlItem.PRICING_ATTRIBUTE6;
412 aSqlItem.PRICING_ATTRIBUTE7 := aPlsqlItem.PRICING_ATTRIBUTE7;
413 aSqlItem.PRICING_ATTRIBUTE8 := aPlsqlItem.PRICING_ATTRIBUTE8;
414 aSqlItem.PRICING_ATTRIBUTE9 := aPlsqlItem.PRICING_ATTRIBUTE9;
415 aSqlItem.PRICING_ATTRIBUTE10 := aPlsqlItem.PRICING_ATTRIBUTE10;
416 aSqlItem.PRICING_ATTRIBUTE11 := aPlsqlItem.PRICING_ATTRIBUTE11;
417 aSqlItem.PRICING_ATTRIBUTE12 := aPlsqlItem.PRICING_ATTRIBUTE12;
418 aSqlItem.PRICING_ATTRIBUTE13 := aPlsqlItem.PRICING_ATTRIBUTE13;
419 aSqlItem.PRICING_ATTRIBUTE14 := aPlsqlItem.PRICING_ATTRIBUTE14;
420 aSqlItem.PRICING_ATTRIBUTE15 := aPlsqlItem.PRICING_ATTRIBUTE15;
421 aSqlItem.PRICING_ATTRIBUTE16 := aPlsqlItem.PRICING_ATTRIBUTE16;
422 aSqlItem.PRICING_ATTRIBUTE17 := aPlsqlItem.PRICING_ATTRIBUTE17;
423 aSqlItem.PRICING_ATTRIBUTE18 := aPlsqlItem.PRICING_ATTRIBUTE18;
424 aSqlItem.PRICING_ATTRIBUTE19 := aPlsqlItem.PRICING_ATTRIBUTE19;
425 aSqlItem.PRICING_ATTRIBUTE20 := aPlsqlItem.PRICING_ATTRIBUTE20;
426 aSqlItem.PRICING_ATTRIBUTE21 := aPlsqlItem.PRICING_ATTRIBUTE21;
427 aSqlItem.PRICING_ATTRIBUTE22 := aPlsqlItem.PRICING_ATTRIBUTE22;
428 aSqlItem.PRICING_ATTRIBUTE23 := aPlsqlItem.PRICING_ATTRIBUTE23;
429 aSqlItem.PRICING_ATTRIBUTE24 := aPlsqlItem.PRICING_ATTRIBUTE24;
430 aSqlItem.PRICING_ATTRIBUTE25 := aPlsqlItem.PRICING_ATTRIBUTE25;
431 aSqlItem.PRICING_ATTRIBUTE26 := aPlsqlItem.PRICING_ATTRIBUTE26;
432 aSqlItem.PRICING_ATTRIBUTE27 := aPlsqlItem.PRICING_ATTRIBUTE27;
433 aSqlItem.PRICING_ATTRIBUTE28 := aPlsqlItem.PRICING_ATTRIBUTE28;
434 aSqlItem.PRICING_ATTRIBUTE29 := aPlsqlItem.PRICING_ATTRIBUTE29;
435 aSqlItem.PRICING_ATTRIBUTE30 := aPlsqlItem.PRICING_ATTRIBUTE30;
436 aSqlItem.PRICING_ATTRIBUTE31 := aPlsqlItem.PRICING_ATTRIBUTE31;
440 aSqlItem.PRICING_ATTRIBUTE35 := aPlsqlItem.PRICING_ATTRIBUTE35;
437 aSqlItem.PRICING_ATTRIBUTE32 := aPlsqlItem.PRICING_ATTRIBUTE32;
438 aSqlItem.PRICING_ATTRIBUTE33 := aPlsqlItem.PRICING_ATTRIBUTE33;
439 aSqlItem.PRICING_ATTRIBUTE34 := aPlsqlItem.PRICING_ATTRIBUTE34;
441 aSqlItem.PRICING_ATTRIBUTE36 := aPlsqlItem.PRICING_ATTRIBUTE36;
442 aSqlItem.PRICING_ATTRIBUTE37 := aPlsqlItem.PRICING_ATTRIBUTE37;
443 aSqlItem.PRICING_ATTRIBUTE38 := aPlsqlItem.PRICING_ATTRIBUTE38;
444 aSqlItem.PRICING_ATTRIBUTE39 := aPlsqlItem.PRICING_ATTRIBUTE39;
445 aSqlItem.PRICING_ATTRIBUTE40 := aPlsqlItem.PRICING_ATTRIBUTE40;
446 aSqlItem.PRICING_ATTRIBUTE41 := aPlsqlItem.PRICING_ATTRIBUTE41;
447 aSqlItem.PRICING_ATTRIBUTE42 := aPlsqlItem.PRICING_ATTRIBUTE42;
448 aSqlItem.PRICING_ATTRIBUTE43 := aPlsqlItem.PRICING_ATTRIBUTE43;
449 aSqlItem.PRICING_ATTRIBUTE44 := aPlsqlItem.PRICING_ATTRIBUTE44;
450 aSqlItem.PRICING_ATTRIBUTE45 := aPlsqlItem.PRICING_ATTRIBUTE45;
451 aSqlItem.PRICING_ATTRIBUTE46 := aPlsqlItem.PRICING_ATTRIBUTE46;
452 aSqlItem.PRICING_ATTRIBUTE47 := aPlsqlItem.PRICING_ATTRIBUTE47;
453 aSqlItem.PRICING_ATTRIBUTE48 := aPlsqlItem.PRICING_ATTRIBUTE48;
454 aSqlItem.PRICING_ATTRIBUTE49 := aPlsqlItem.PRICING_ATTRIBUTE49;
455 aSqlItem.PRICING_ATTRIBUTE50 := aPlsqlItem.PRICING_ATTRIBUTE50;
456 aSqlItem.PRICING_ATTRIBUTE51 := aPlsqlItem.PRICING_ATTRIBUTE51;
457 aSqlItem.PRICING_ATTRIBUTE52 := aPlsqlItem.PRICING_ATTRIBUTE52;
458 aSqlItem.PRICING_ATTRIBUTE53 := aPlsqlItem.PRICING_ATTRIBUTE53;
459 aSqlItem.PRICING_ATTRIBUTE54 := aPlsqlItem.PRICING_ATTRIBUTE54;
460 aSqlItem.PRICING_ATTRIBUTE55 := aPlsqlItem.PRICING_ATTRIBUTE55;
461 aSqlItem.PRICING_ATTRIBUTE56 := aPlsqlItem.PRICING_ATTRIBUTE56;
462 aSqlItem.PRICING_ATTRIBUTE57 := aPlsqlItem.PRICING_ATTRIBUTE57;
463 aSqlItem.PRICING_ATTRIBUTE58 := aPlsqlItem.PRICING_ATTRIBUTE58;
464 aSqlItem.PRICING_ATTRIBUTE59 := aPlsqlItem.PRICING_ATTRIBUTE59;
465 aSqlItem.PRICING_ATTRIBUTE60 := aPlsqlItem.PRICING_ATTRIBUTE60;
466 aSqlItem.PRICING_ATTRIBUTE61 := aPlsqlItem.PRICING_ATTRIBUTE61;
467 aSqlItem.PRICING_ATTRIBUTE62 := aPlsqlItem.PRICING_ATTRIBUTE62;
468 aSqlItem.PRICING_ATTRIBUTE63 := aPlsqlItem.PRICING_ATTRIBUTE63;
469 aSqlItem.PRICING_ATTRIBUTE64 := aPlsqlItem.PRICING_ATTRIBUTE64;
470 aSqlItem.PRICING_ATTRIBUTE65 := aPlsqlItem.PRICING_ATTRIBUTE65;
474 aSqlItem.PRICING_ATTRIBUTE69 := aPlsqlItem.PRICING_ATTRIBUTE69;
471 aSqlItem.PRICING_ATTRIBUTE66 := aPlsqlItem.PRICING_ATTRIBUTE66;
472 aSqlItem.PRICING_ATTRIBUTE67 := aPlsqlItem.PRICING_ATTRIBUTE67;
473 aSqlItem.PRICING_ATTRIBUTE68 := aPlsqlItem.PRICING_ATTRIBUTE68;
475 aSqlItem.PRICING_ATTRIBUTE70 := aPlsqlItem.PRICING_ATTRIBUTE70;
476 aSqlItem.PRICING_ATTRIBUTE71 := aPlsqlItem.PRICING_ATTRIBUTE71;
477 aSqlItem.PRICING_ATTRIBUTE72 := aPlsqlItem.PRICING_ATTRIBUTE72;
478 aSqlItem.PRICING_ATTRIBUTE73 := aPlsqlItem.PRICING_ATTRIBUTE73;
479 aSqlItem.PRICING_ATTRIBUTE74 := aPlsqlItem.PRICING_ATTRIBUTE74;
480 aSqlItem.PRICING_ATTRIBUTE75 := aPlsqlItem.PRICING_ATTRIBUTE75;
481 aSqlItem.PRICING_ATTRIBUTE76 := aPlsqlItem.PRICING_ATTRIBUTE76;
482 aSqlItem.PRICING_ATTRIBUTE77 := aPlsqlItem.PRICING_ATTRIBUTE77;
483 aSqlItem.PRICING_ATTRIBUTE78 := aPlsqlItem.PRICING_ATTRIBUTE78;
484 aSqlItem.PRICING_ATTRIBUTE79 := aPlsqlItem.PRICING_ATTRIBUTE79;
485 aSqlItem.PRICING_ATTRIBUTE80 := aPlsqlItem.PRICING_ATTRIBUTE80;
486 aSqlItem.PRICING_ATTRIBUTE81 := aPlsqlItem.PRICING_ATTRIBUTE81;
487 aSqlItem.PRICING_ATTRIBUTE82 := aPlsqlItem.PRICING_ATTRIBUTE82;
488 aSqlItem.PRICING_ATTRIBUTE83 := aPlsqlItem.PRICING_ATTRIBUTE83;
489 aSqlItem.PRICING_ATTRIBUTE84 := aPlsqlItem.PRICING_ATTRIBUTE84;
490 aSqlItem.PRICING_ATTRIBUTE85 := aPlsqlItem.PRICING_ATTRIBUTE85;
491 aSqlItem.PRICING_ATTRIBUTE86 := aPlsqlItem.PRICING_ATTRIBUTE86;
492 aSqlItem.PRICING_ATTRIBUTE87 := aPlsqlItem.PRICING_ATTRIBUTE87;
493 aSqlItem.PRICING_ATTRIBUTE88 := aPlsqlItem.PRICING_ATTRIBUTE88;
494 aSqlItem.PRICING_ATTRIBUTE89 := aPlsqlItem.PRICING_ATTRIBUTE89;
495 aSqlItem.PRICING_ATTRIBUTE90 := aPlsqlItem.PRICING_ATTRIBUTE90;
496 aSqlItem.PRICING_ATTRIBUTE91 := aPlsqlItem.PRICING_ATTRIBUTE91;
497 aSqlItem.PRICING_ATTRIBUTE92 := aPlsqlItem.PRICING_ATTRIBUTE92;
498 aSqlItem.PRICING_ATTRIBUTE93 := aPlsqlItem.PRICING_ATTRIBUTE93;
499 aSqlItem.PRICING_ATTRIBUTE94 := aPlsqlItem.PRICING_ATTRIBUTE94;
500 aSqlItem.PRICING_ATTRIBUTE95 := aPlsqlItem.PRICING_ATTRIBUTE95;
501 aSqlItem.PRICING_ATTRIBUTE96 := aPlsqlItem.PRICING_ATTRIBUTE96;
502 aSqlItem.PRICING_ATTRIBUTE97 := aPlsqlItem.PRICING_ATTRIBUTE97;
503 aSqlItem.PRICING_ATTRIBUTE98 := aPlsqlItem.PRICING_ATTRIBUTE98;
504 aSqlItem.PRICING_ATTRIBUTE99 := aPlsqlItem.PRICING_ATTRIBUTE99;
505 aSqlItem.PRICING_ATTRIBUTE100 := aPlsqlItem.PRICING_ATTRIBUTE100;
506 aSqlItem.CONTEXT := aPlsqlItem.CONTEXT;
507 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
508 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
509 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
510 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
511 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
512 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
513 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
514 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
515 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
516 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
517 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
518 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
519 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
520 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
521 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
522 aSqlItem.ATTRIBUTE16 := aPlsqlItem.ATTRIBUTE16;
523 aSqlItem.ATTRIBUTE17 := aPlsqlItem.ATTRIBUTE17;
524 aSqlItem.ATTRIBUTE18 := aPlsqlItem.ATTRIBUTE18;
525 aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
526 aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
527 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
528 RETURN aSqlItem;
529 END PL_TO_SQL20;
530 FUNCTION SQL_TO_PL20(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34)
531 RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE IS
532 aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE;
533 BEGIN
534 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
535 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
536 aPlsqlItem.PRICE_ATTRIBUTE_ID := aSqlItem.PRICE_ATTRIBUTE_ID;
537 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
538 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
539 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
540 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
541 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
542 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
543 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
544 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
545 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
546 aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
547 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
548 aPlsqlItem.FLEX_TITLE := aSqlItem.FLEX_TITLE;
549 aPlsqlItem.PRICING_CONTEXT := aSqlItem.PRICING_CONTEXT;
550 aPlsqlItem.PRICING_ATTRIBUTE1 := aSqlItem.PRICING_ATTRIBUTE1;
551 aPlsqlItem.PRICING_ATTRIBUTE2 := aSqlItem.PRICING_ATTRIBUTE2;
552 aPlsqlItem.PRICING_ATTRIBUTE3 := aSqlItem.PRICING_ATTRIBUTE3;
553 aPlsqlItem.PRICING_ATTRIBUTE4 := aSqlItem.PRICING_ATTRIBUTE4;
554 aPlsqlItem.PRICING_ATTRIBUTE5 := aSqlItem.PRICING_ATTRIBUTE5;
555 aPlsqlItem.PRICING_ATTRIBUTE6 := aSqlItem.PRICING_ATTRIBUTE6;
556 aPlsqlItem.PRICING_ATTRIBUTE7 := aSqlItem.PRICING_ATTRIBUTE7;
557 aPlsqlItem.PRICING_ATTRIBUTE8 := aSqlItem.PRICING_ATTRIBUTE8;
558 aPlsqlItem.PRICING_ATTRIBUTE9 := aSqlItem.PRICING_ATTRIBUTE9;
559
560 aPlsqlItem.PRICING_ATTRIBUTE10 := aSqlItem.PRICING_ATTRIBUTE10;
561 aPlsqlItem.PRICING_ATTRIBUTE11 := aSqlItem.PRICING_ATTRIBUTE11;
562 aPlsqlItem.PRICING_ATTRIBUTE12 := aSqlItem.PRICING_ATTRIBUTE12;
563 aPlsqlItem.PRICING_ATTRIBUTE13 := aSqlItem.PRICING_ATTRIBUTE13;
564 aPlsqlItem.PRICING_ATTRIBUTE14 := aSqlItem.PRICING_ATTRIBUTE14;
565 aPlsqlItem.PRICING_ATTRIBUTE15 := aSqlItem.PRICING_ATTRIBUTE15;
566 aPlsqlItem.PRICING_ATTRIBUTE16 := aSqlItem.PRICING_ATTRIBUTE16;
567 aPlsqlItem.PRICING_ATTRIBUTE17 := aSqlItem.PRICING_ATTRIBUTE17;
568 aPlsqlItem.PRICING_ATTRIBUTE18 := aSqlItem.PRICING_ATTRIBUTE18;
569 aPlsqlItem.PRICING_ATTRIBUTE19 := aSqlItem.PRICING_ATTRIBUTE19;
573 aPlsqlItem.PRICING_ATTRIBUTE23 := aSqlItem.PRICING_ATTRIBUTE23;
570 aPlsqlItem.PRICING_ATTRIBUTE20 := aSqlItem.PRICING_ATTRIBUTE20;
571 aPlsqlItem.PRICING_ATTRIBUTE21 := aSqlItem.PRICING_ATTRIBUTE21;
572 aPlsqlItem.PRICING_ATTRIBUTE22 := aSqlItem.PRICING_ATTRIBUTE22;
574 aPlsqlItem.PRICING_ATTRIBUTE24 := aSqlItem.PRICING_ATTRIBUTE24;
575 aPlsqlItem.PRICING_ATTRIBUTE25 := aSqlItem.PRICING_ATTRIBUTE25;
576 aPlsqlItem.PRICING_ATTRIBUTE26 := aSqlItem.PRICING_ATTRIBUTE26;
577 aPlsqlItem.PRICING_ATTRIBUTE27 := aSqlItem.PRICING_ATTRIBUTE27;
578 aPlsqlItem.PRICING_ATTRIBUTE28 := aSqlItem.PRICING_ATTRIBUTE28;
579 aPlsqlItem.PRICING_ATTRIBUTE29 := aSqlItem.PRICING_ATTRIBUTE29;
580 aPlsqlItem.PRICING_ATTRIBUTE30 := aSqlItem.PRICING_ATTRIBUTE30;
581 aPlsqlItem.PRICING_ATTRIBUTE31 := aSqlItem.PRICING_ATTRIBUTE31;
582 aPlsqlItem.PRICING_ATTRIBUTE32 := aSqlItem.PRICING_ATTRIBUTE32;
583 aPlsqlItem.PRICING_ATTRIBUTE33 := aSqlItem.PRICING_ATTRIBUTE33;
584 aPlsqlItem.PRICING_ATTRIBUTE34 := aSqlItem.PRICING_ATTRIBUTE34;
585 aPlsqlItem.PRICING_ATTRIBUTE35 := aSqlItem.PRICING_ATTRIBUTE35;
586 aPlsqlItem.PRICING_ATTRIBUTE36 := aSqlItem.PRICING_ATTRIBUTE36;
587 aPlsqlItem.PRICING_ATTRIBUTE37 := aSqlItem.PRICING_ATTRIBUTE37;
588 aPlsqlItem.PRICING_ATTRIBUTE38 := aSqlItem.PRICING_ATTRIBUTE38;
589 aPlsqlItem.PRICING_ATTRIBUTE39 := aSqlItem.PRICING_ATTRIBUTE39;
590 aPlsqlItem.PRICING_ATTRIBUTE40 := aSqlItem.PRICING_ATTRIBUTE40;
591 aPlsqlItem.PRICING_ATTRIBUTE41 := aSqlItem.PRICING_ATTRIBUTE41;
592 aPlsqlItem.PRICING_ATTRIBUTE42 := aSqlItem.PRICING_ATTRIBUTE42;
593 aPlsqlItem.PRICING_ATTRIBUTE43 := aSqlItem.PRICING_ATTRIBUTE43;
594 aPlsqlItem.PRICING_ATTRIBUTE44 := aSqlItem.PRICING_ATTRIBUTE44;
595 aPlsqlItem.PRICING_ATTRIBUTE45 := aSqlItem.PRICING_ATTRIBUTE45;
596 aPlsqlItem.PRICING_ATTRIBUTE46 := aSqlItem.PRICING_ATTRIBUTE46;
597 aPlsqlItem.PRICING_ATTRIBUTE47 := aSqlItem.PRICING_ATTRIBUTE47;
598 aPlsqlItem.PRICING_ATTRIBUTE48 := aSqlItem.PRICING_ATTRIBUTE48;
599 aPlsqlItem.PRICING_ATTRIBUTE49 := aSqlItem.PRICING_ATTRIBUTE49;
600 aPlsqlItem.PRICING_ATTRIBUTE50 := aSqlItem.PRICING_ATTRIBUTE50;
601 aPlsqlItem.PRICING_ATTRIBUTE51 := aSqlItem.PRICING_ATTRIBUTE51;
602 aPlsqlItem.PRICING_ATTRIBUTE52 := aSqlItem.PRICING_ATTRIBUTE52;
603 aPlsqlItem.PRICING_ATTRIBUTE53 := aSqlItem.PRICING_ATTRIBUTE53;
604 aPlsqlItem.PRICING_ATTRIBUTE54 := aSqlItem.PRICING_ATTRIBUTE54;
605 aPlsqlItem.PRICING_ATTRIBUTE55 := aSqlItem.PRICING_ATTRIBUTE55;
606 aPlsqlItem.PRICING_ATTRIBUTE56 := aSqlItem.PRICING_ATTRIBUTE56;
607 aPlsqlItem.PRICING_ATTRIBUTE57 := aSqlItem.PRICING_ATTRIBUTE57;
608 aPlsqlItem.PRICING_ATTRIBUTE58 := aSqlItem.PRICING_ATTRIBUTE58;
609 aPlsqlItem.PRICING_ATTRIBUTE59 := aSqlItem.PRICING_ATTRIBUTE59;
610 aPlsqlItem.PRICING_ATTRIBUTE60 := aSqlItem.PRICING_ATTRIBUTE60;
611 aPlsqlItem.PRICING_ATTRIBUTE61 := aSqlItem.PRICING_ATTRIBUTE61;
612 aPlsqlItem.PRICING_ATTRIBUTE62 := aSqlItem.PRICING_ATTRIBUTE62;
613 aPlsqlItem.PRICING_ATTRIBUTE63 := aSqlItem.PRICING_ATTRIBUTE63;
614 aPlsqlItem.PRICING_ATTRIBUTE64 := aSqlItem.PRICING_ATTRIBUTE64;
615 aPlsqlItem.PRICING_ATTRIBUTE65 := aSqlItem.PRICING_ATTRIBUTE65;
616 aPlsqlItem.PRICING_ATTRIBUTE66 := aSqlItem.PRICING_ATTRIBUTE66;
617 aPlsqlItem.PRICING_ATTRIBUTE67 := aSqlItem.PRICING_ATTRIBUTE67;
618 aPlsqlItem.PRICING_ATTRIBUTE68 := aSqlItem.PRICING_ATTRIBUTE68;
619 aPlsqlItem.PRICING_ATTRIBUTE69 := aSqlItem.PRICING_ATTRIBUTE69;
620 aPlsqlItem.PRICING_ATTRIBUTE70 := aSqlItem.PRICING_ATTRIBUTE70;
621 aPlsqlItem.PRICING_ATTRIBUTE71 := aSqlItem.PRICING_ATTRIBUTE71;
622 aPlsqlItem.PRICING_ATTRIBUTE72 := aSqlItem.PRICING_ATTRIBUTE72;
623 aPlsqlItem.PRICING_ATTRIBUTE73 := aSqlItem.PRICING_ATTRIBUTE73;
624 aPlsqlItem.PRICING_ATTRIBUTE74 := aSqlItem.PRICING_ATTRIBUTE74;
625 aPlsqlItem.PRICING_ATTRIBUTE75 := aSqlItem.PRICING_ATTRIBUTE75;
626 aPlsqlItem.PRICING_ATTRIBUTE76 := aSqlItem.PRICING_ATTRIBUTE76;
627 aPlsqlItem.PRICING_ATTRIBUTE77 := aSqlItem.PRICING_ATTRIBUTE77;
628 aPlsqlItem.PRICING_ATTRIBUTE78 := aSqlItem.PRICING_ATTRIBUTE78;
629 aPlsqlItem.PRICING_ATTRIBUTE79 := aSqlItem.PRICING_ATTRIBUTE79;
630 aPlsqlItem.PRICING_ATTRIBUTE80 := aSqlItem.PRICING_ATTRIBUTE80;
631 aPlsqlItem.PRICING_ATTRIBUTE81 := aSqlItem.PRICING_ATTRIBUTE81;
632 aPlsqlItem.PRICING_ATTRIBUTE82 := aSqlItem.PRICING_ATTRIBUTE82;
633 aPlsqlItem.PRICING_ATTRIBUTE83 := aSqlItem.PRICING_ATTRIBUTE83;
634 aPlsqlItem.PRICING_ATTRIBUTE84 := aSqlItem.PRICING_ATTRIBUTE84;
635 aPlsqlItem.PRICING_ATTRIBUTE85 := aSqlItem.PRICING_ATTRIBUTE85;
636 aPlsqlItem.PRICING_ATTRIBUTE86 := aSqlItem.PRICING_ATTRIBUTE86;
637 aPlsqlItem.PRICING_ATTRIBUTE87 := aSqlItem.PRICING_ATTRIBUTE87;
638 aPlsqlItem.PRICING_ATTRIBUTE88 := aSqlItem.PRICING_ATTRIBUTE88;
639 aPlsqlItem.PRICING_ATTRIBUTE89 := aSqlItem.PRICING_ATTRIBUTE89;
640 aPlsqlItem.PRICING_ATTRIBUTE90 := aSqlItem.PRICING_ATTRIBUTE90;
641 aPlsqlItem.PRICING_ATTRIBUTE91 := aSqlItem.PRICING_ATTRIBUTE91;
642 aPlsqlItem.PRICING_ATTRIBUTE92 := aSqlItem.PRICING_ATTRIBUTE92;
643 aPlsqlItem.PRICING_ATTRIBUTE93 := aSqlItem.PRICING_ATTRIBUTE93;
644 aPlsqlItem.PRICING_ATTRIBUTE94 := aSqlItem.PRICING_ATTRIBUTE94;
645 aPlsqlItem.PRICING_ATTRIBUTE95 := aSqlItem.PRICING_ATTRIBUTE95;
646 aPlsqlItem.PRICING_ATTRIBUTE96 := aSqlItem.PRICING_ATTRIBUTE96;
647 aPlsqlItem.PRICING_ATTRIBUTE97 := aSqlItem.PRICING_ATTRIBUTE97;
648 aPlsqlItem.PRICING_ATTRIBUTE98 := aSqlItem.PRICING_ATTRIBUTE98;
649 aPlsqlItem.PRICING_ATTRIBUTE99 := aSqlItem.PRICING_ATTRIBUTE99;
650 aPlsqlItem.PRICING_ATTRIBUTE100 := aSqlItem.PRICING_ATTRIBUTE100;
651 aPlsqlItem.CONTEXT := aSqlItem.CONTEXT;
652 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
653 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
654 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
655 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
656 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
657 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
658 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
659 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
660 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
661 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
665 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
662 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
663 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
664 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
666 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
667 aPlsqlItem.ATTRIBUTE16 := aSqlItem.ATTRIBUTE16;
668 aPlsqlItem.ATTRIBUTE17 := aSqlItem.ATTRIBUTE17;
669 aPlsqlItem.ATTRIBUTE18 := aSqlItem.ATTRIBUTE18;
670 aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
671 aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
672 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
673 RETURN aPlsqlItem;
674 END SQL_TO_PL20;
675 FUNCTION PL_TO_SQL3(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE)
676 RETURN ASO_QUOTE_PUB_PRICE_ATTRIBUTE IS
677 aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE;
678 BEGIN
679 -- initialize the table
680 aSqlItem := ASO_QUOTE_PUB_PRICE_ATTRIBUTE();
681 IF aPlsqlItem.COUNT > 0 THEN
682 aSqlItem.EXTEND(aPlsqlItem.COUNT);
683 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
684 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL20(aPlsqlItem(I));
685 END LOOP;
686 END IF;
687 RETURN aSqlItem;
688 END PL_TO_SQL3;
689 FUNCTION SQL_TO_PL2(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE)
690 RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE IS
691 aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
692 BEGIN
693 -- Added to take care of 'reference to uninitialized collection' error.
694 begin
695 FOR I IN 1..aSqlItem.COUNT LOOP
696 aPlsqlItem(I) := SQL_TO_PL20(aSqlItem(I));
697 END LOOP;
698 exception
699 when others then
700 null;
701 end;
702 RETURN aPlsqlItem;
703 END SQL_TO_PL2;
704 FUNCTION PL_TO_SQL21(aPlsqlItem ASO_QUOTE_PUB.PAYMENT_REC_TYPE)
705 RETURN ASO_QUOTE_PUB_PAYMENT_REC_TYP IS
706 aSqlItem ASO_QUOTE_PUB_PAYMENT_REC_TYP;
707 BEGIN
708 -- initialize the object
709 aSqlItem := ASO_QUOTE_PUB_PAYMENT_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
710 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
711 NULL, NULL, NULL, NULL, NULL);
712 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
713 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
714 aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
715 aSqlItem.PAYMENT_ID := aPlsqlItem.PAYMENT_ID;
716 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
717 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
718 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
719 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
720 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
721 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
722 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
723 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
724 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
725 aSqlItem.QUOTE_HEADER_ID := aPlsqlItem.QUOTE_HEADER_ID;
726 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
727 aSqlItem.QUOTE_SHIPMENT_ID := aPlsqlItem.QUOTE_SHIPMENT_ID;
728 aSqlItem.PAYMENT_TYPE_CODE := aPlsqlItem.PAYMENT_TYPE_CODE;
729 aSqlItem.PAYMENT_REF_NUMBER := aPlsqlItem.PAYMENT_REF_NUMBER;
730 aSqlItem.PAYMENT_OPTION := aPlsqlItem.PAYMENT_OPTION;
731 aSqlItem.PAYMENT_TERM_ID := aPlsqlItem.PAYMENT_TERM_ID;
732 aSqlItem.CREDIT_CARD_CODE := aPlsqlItem.CREDIT_CARD_CODE;
733 aSqlItem.CREDIT_CARD_HOLDER_NAME := aPlsqlItem.CREDIT_CARD_HOLDER_NAME;
734 aSqlItem.CREDIT_CARD_EXPIRATION_DATE := aPlsqlItem.CREDIT_CARD_EXPIRATION_DATE;
735 aSqlItem.CREDIT_CARD_APPROVAL_CODE := aPlsqlItem.CREDIT_CARD_APPROVAL_CODE;
736 aSqlItem.CREDIT_CARD_APPROVAL_DATE := aPlsqlItem.CREDIT_CARD_APPROVAL_DATE;
737 aSqlItem.PAYMENT_AMOUNT := aPlsqlItem.PAYMENT_AMOUNT;
738 aSqlItem.ATTRIBUTE_CATEGORY := aPlsqlItem.ATTRIBUTE_CATEGORY;
739 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
740 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
741 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
742 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
743 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
744 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
745 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
746 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
747 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
748 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
749 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
750 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
751 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
752 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
753 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
754 aSqlItem.CUST_PO_NUMBER := aPlsqlItem.CUST_PO_NUMBER;
755 aSqlItem.CVV2 := aPlsqlItem.CVV2;
756 aSqlItem.PAYMENT_TERM_ID_FROM := aPlsqlItem.PAYMENT_TERM_ID_FROM;
757 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
758 aSqlItem.CUST_PO_LINE_NUMBER := aPlsqlItem.CUST_PO_LINE_NUMBER;
759 aSqlItem.ATTRIBUTE16 := aPlsqlItem.ATTRIBUTE16;
760 aSqlItem.ATTRIBUTE17 := aPlsqlItem.ATTRIBUTE17;
761 aSqlItem.ATTRIBUTE18 := aPlsqlItem.ATTRIBUTE18;
762 aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
763 aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
764 aSqlItem.CARD_ID := aPlsqlItem.CARD_ID;
765 aSqlItem.INSTR_ASSIGNMENT_ID := aPlsqlItem.INSTR_ASSIGNMENT_ID;
766 aSqlItem.INSTRUMENT_ID := aPlsqlItem.INSTRUMENT_ID;
767 aSqlItem.TRXN_EXTENSION_ID := aPlsqlItem.TRXN_EXTENSION_ID;
768 RETURN aSqlItem;
769 END PL_TO_SQL21;
770 FUNCTION SQL_TO_PL21(aSqlItem ASO_QUOTE_PUB_PAYMENT_REC_TYP)
771 RETURN ASO_QUOTE_PUB.PAYMENT_REC_TYPE IS
772 aPlsqlItem ASO_QUOTE_PUB.PAYMENT_REC_TYPE;
773 BEGIN
777 aPlsqlItem.PAYMENT_ID := aSqlItem.PAYMENT_ID;
774 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
775 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
776 aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
778 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
779 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
780 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
781 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
782 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
783 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
784 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
785 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
786 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
787 aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
788 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
789 aPlsqlItem.QUOTE_SHIPMENT_ID := aSqlItem.QUOTE_SHIPMENT_ID;
790 aPlsqlItem.PAYMENT_TYPE_CODE := aSqlItem.PAYMENT_TYPE_CODE;
791 aPlsqlItem.PAYMENT_REF_NUMBER := aSqlItem.PAYMENT_REF_NUMBER;
792 aPlsqlItem.PAYMENT_OPTION := aSqlItem.PAYMENT_OPTION;
793 aPlsqlItem.PAYMENT_TERM_ID := aSqlItem.PAYMENT_TERM_ID;
794 aPlsqlItem.CREDIT_CARD_CODE := aSqlItem.CREDIT_CARD_CODE;
795 aPlsqlItem.CREDIT_CARD_HOLDER_NAME := aSqlItem.CREDIT_CARD_HOLDER_NAME;
796 aPlsqlItem.CREDIT_CARD_EXPIRATION_DATE := aSqlItem.CREDIT_CARD_EXPIRATION_DATE;
797 aPlsqlItem.CREDIT_CARD_APPROVAL_CODE := aSqlItem.CREDIT_CARD_APPROVAL_CODE;
798 aPlsqlItem.CREDIT_CARD_APPROVAL_DATE := aSqlItem.CREDIT_CARD_APPROVAL_DATE;
799 aPlsqlItem.PAYMENT_AMOUNT := aSqlItem.PAYMENT_AMOUNT;
800 aPlsqlItem.ATTRIBUTE_CATEGORY := aSqlItem.ATTRIBUTE_CATEGORY;
801 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
802 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
803 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
804 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
805 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
806 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
807 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
808 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
809 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
810 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
811 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
812 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
813 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
814 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
815 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
816 aPlsqlItem.CUST_PO_NUMBER := aSqlItem.CUST_PO_NUMBER;
817 aPlsqlItem.CVV2 := aSqlItem.CVV2;
818 aPlsqlItem.PAYMENT_TERM_ID_FROM := aSqlItem.PAYMENT_TERM_ID_FROM;
819 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
820 aPlsqlItem.CUST_PO_LINE_NUMBER := aSqlItem.CUST_PO_LINE_NUMBER;
821 aPlsqlItem.ATTRIBUTE16 := aSqlItem.ATTRIBUTE16;
822 aPlsqlItem.ATTRIBUTE17 := aSqlItem.ATTRIBUTE17;
823 aPlsqlItem.ATTRIBUTE18 := aSqlItem.ATTRIBUTE18;
824 aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
825 aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
826 aPlsqlItem.CARD_ID := aSqlItem.CARD_ID;
827 aPlsqlItem.INSTR_ASSIGNMENT_ID := aSqlItem.INSTR_ASSIGNMENT_ID;
828 aPlsqlItem.INSTRUMENT_ID := aSqlItem.INSTRUMENT_ID;
829 aPlsqlItem.TRXN_EXTENSION_ID := aSqlItem.TRXN_EXTENSION_ID;
830 RETURN aPlsqlItem;
831 END SQL_TO_PL21;
832 FUNCTION PL_TO_SQL4(aPlsqlItem ASO_QUOTE_PUB.PAYMENT_TBL_TYPE)
833 RETURN ASO_QUOTE_PUB_PAYMENT_TBL_TYP IS
834 aSqlItem ASO_QUOTE_PUB_PAYMENT_TBL_TYP;
835 BEGIN
836 -- initialize the table
837 aSqlItem := ASO_QUOTE_PUB_PAYMENT_TBL_TYP();
838 IF aPlsqlItem.COUNT > 0 THEN
839 aSqlItem.EXTEND(aPlsqlItem.COUNT);
840 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
841 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL21(aPlsqlItem(I));
842 END LOOP;
843 END IF;
844 RETURN aSqlItem;
845 END PL_TO_SQL4;
846 FUNCTION SQL_TO_PL3(aSqlItem ASO_QUOTE_PUB_PAYMENT_TBL_TYP)
847 RETURN ASO_QUOTE_PUB.PAYMENT_TBL_TYPE IS
848 aPlsqlItem ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
849 BEGIN
850 begin
851 FOR I IN 1..aSqlItem.COUNT LOOP
852 aPlsqlItem(I) := SQL_TO_PL21(aSqlItem(I));
853 END LOOP;
854 exception
855 when others then
856 null;
857 end;
858 RETURN aPlsqlItem;
859 END SQL_TO_PL3;
860 FUNCTION PL_TO_SQL5(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_REC_TYPE)
861 RETURN ASO_QUOTE_PUB_SHIPMENT_REC_TY IS
862 aSqlItem ASO_QUOTE_PUB_SHIPMENT_REC_TY;
863 BEGIN
864 -- initialize the object
865 aSqlItem := ASO_QUOTE_PUB_SHIPMENT_REC_TY(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
866 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
867 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
868 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
869 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
870 aSqlItem.SHIPMENT_ID := aPlsqlItem.SHIPMENT_ID;
871 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
872 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
873 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
874 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
875 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
876 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
877 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
878 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
879 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
880 aSqlItem.QUOTE_HEADER_ID := aPlsqlItem.QUOTE_HEADER_ID;
881 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
882 aSqlItem.PROMISE_DATE := aPlsqlItem.PROMISE_DATE;
886 aSqlItem.SHIP_TO_PARTY_ID := aPlsqlItem.SHIP_TO_PARTY_ID;
883 aSqlItem.REQUEST_DATE := aPlsqlItem.REQUEST_DATE;
884 aSqlItem.SCHEDULE_SHIP_DATE := aPlsqlItem.SCHEDULE_SHIP_DATE;
885 aSqlItem.SHIP_TO_PARTY_SITE_ID := aPlsqlItem.SHIP_TO_PARTY_SITE_ID;
887 aSqlItem.SHIP_TO_CUST_ACCOUNT_ID := aPlsqlItem.SHIP_TO_CUST_ACCOUNT_ID;
888 aSqlItem.SHIP_PARTIAL_FLAG := aPlsqlItem.SHIP_PARTIAL_FLAG;
889 aSqlItem.SHIP_SET_ID := aPlsqlItem.SHIP_SET_ID;
890 aSqlItem.SHIP_METHOD_CODE := aPlsqlItem.SHIP_METHOD_CODE;
891 aSqlItem.FREIGHT_TERMS_CODE := aPlsqlItem.FREIGHT_TERMS_CODE;
892 aSqlItem.FREIGHT_CARRIER_CODE := aPlsqlItem.FREIGHT_CARRIER_CODE;
893 aSqlItem.FOB_CODE := aPlsqlItem.FOB_CODE;
894 aSqlItem.SHIPPING_INSTRUCTIONS := aPlsqlItem.SHIPPING_INSTRUCTIONS;
895 aSqlItem.PACKING_INSTRUCTIONS := aPlsqlItem.PACKING_INSTRUCTIONS;
896 aSqlItem.SHIP_QUOTE_PRICE := aPlsqlItem.SHIP_QUOTE_PRICE;
897 aSqlItem.QUANTITY := aPlsqlItem.QUANTITY;
898 aSqlItem.PRICING_QUANTITY := aPlsqlItem.PRICING_QUANTITY;
899 aSqlItem.RESERVED_QUANTITY := aPlsqlItem.RESERVED_QUANTITY;
900 aSqlItem.RESERVATION_ID := aPlsqlItem.RESERVATION_ID;
901 aSqlItem.ORDER_LINE_ID := aPlsqlItem.ORDER_LINE_ID;
902 aSqlItem.SHIP_TO_PARTY_NAME := aPlsqlItem.SHIP_TO_PARTY_NAME;
903 aSqlItem.SHIP_TO_CONTACT_FIRST_NAME := aPlsqlItem.SHIP_TO_CONTACT_FIRST_NAME;
904 aSqlItem.SHIP_TO_CONTACT_MIDDLE_NAME := aPlsqlItem.SHIP_TO_CONTACT_MIDDLE_NAME;
905 aSqlItem.SHIP_TO_CONTACT_LAST_NAME := aPlsqlItem.SHIP_TO_CONTACT_LAST_NAME;
906 aSqlItem.SHIP_TO_ADDRESS1 := aPlsqlItem.SHIP_TO_ADDRESS1;
907 aSqlItem.SHIP_TO_ADDRESS2 := aPlsqlItem.SHIP_TO_ADDRESS2;
908 aSqlItem.SHIP_TO_ADDRESS3 := aPlsqlItem.SHIP_TO_ADDRESS3;
909 aSqlItem.SHIP_TO_ADDRESS4 := aPlsqlItem.SHIP_TO_ADDRESS4;
910 aSqlItem.SHIP_TO_COUNTRY_CODE := aPlsqlItem.SHIP_TO_COUNTRY_CODE;
911 aSqlItem.SHIP_TO_COUNTRY := aPlsqlItem.SHIP_TO_COUNTRY;
912 aSqlItem.SHIP_TO_CITY := aPlsqlItem.SHIP_TO_CITY;
913 aSqlItem.SHIP_TO_POSTAL_CODE := aPlsqlItem.SHIP_TO_POSTAL_CODE;
914 aSqlItem.SHIP_TO_STATE := aPlsqlItem.SHIP_TO_STATE;
915 aSqlItem.SHIP_TO_PROVINCE := aPlsqlItem.SHIP_TO_PROVINCE;
916 aSqlItem.SHIP_TO_COUNTY := aPlsqlItem.SHIP_TO_COUNTY;
917 aSqlItem.ATTRIBUTE_CATEGORY := aPlsqlItem.ATTRIBUTE_CATEGORY;
918 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
919 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
920 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
921 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
922 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
923 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
924 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
925 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
926 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
927 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
928 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
929 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
930 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
931 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
932 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
933 aSqlItem.SHIPMENT_PRIORITY_CODE := aPlsqlItem.SHIPMENT_PRIORITY_CODE;
934 aSqlItem.SHIP_FROM_ORG_ID := aPlsqlItem.SHIP_FROM_ORG_ID;
935 aSqlItem.SHIP_TO_CUST_PARTY_ID := aPlsqlItem.SHIP_TO_CUST_PARTY_ID;
936 aSqlItem.SHIP_METHOD_CODE_FROM := aPlsqlItem.SHIP_METHOD_CODE_FROM;
937 aSqlItem.FREIGHT_TERMS_CODE_FROM := aPlsqlItem.FREIGHT_TERMS_CODE_FROM;
938 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
939 aSqlItem.REQUEST_DATE_TYPE := aPlsqlItem.REQUEST_DATE_TYPE;
940 aSqlItem.DEMAND_CLASS_CODE := aPlsqlItem.DEMAND_CLASS_CODE;
941 aSqlItem.ATTRIBUTE16 := aPlsqlItem.ATTRIBUTE16;
942 aSqlItem.ATTRIBUTE17 := aPlsqlItem.ATTRIBUTE17;
943 aSqlItem.ATTRIBUTE18 := aPlsqlItem.ATTRIBUTE18;
944 aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
945 aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
946 RETURN aSqlItem;
947 END PL_TO_SQL5;
948 FUNCTION SQL_TO_PL4(aSqlItem ASO_QUOTE_PUB_SHIPMENT_REC_TY)
949 RETURN ASO_QUOTE_PUB.SHIPMENT_REC_TYPE IS
950 aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
951 BEGIN
952 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
953 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
954 aPlsqlItem.SHIPMENT_ID := aSqlItem.SHIPMENT_ID;
955 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
956 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
957 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
958 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
959 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
960 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
961 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
962 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
963 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
964 aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
965 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
966 aPlsqlItem.PROMISE_DATE := aSqlItem.PROMISE_DATE;
967 aPlsqlItem.REQUEST_DATE := aSqlItem.REQUEST_DATE;
968 aPlsqlItem.SCHEDULE_SHIP_DATE := aSqlItem.SCHEDULE_SHIP_DATE;
969 aPlsqlItem.SHIP_TO_PARTY_SITE_ID := aSqlItem.SHIP_TO_PARTY_SITE_ID;
970 aPlsqlItem.SHIP_TO_PARTY_ID := aSqlItem.SHIP_TO_PARTY_ID;
971 aPlsqlItem.SHIP_TO_CUST_ACCOUNT_ID := aSqlItem.SHIP_TO_CUST_ACCOUNT_ID;
972 aPlsqlItem.SHIP_PARTIAL_FLAG := aSqlItem.SHIP_PARTIAL_FLAG;
973 aPlsqlItem.SHIP_SET_ID := aSqlItem.SHIP_SET_ID;
974 aPlsqlItem.SHIP_METHOD_CODE := aSqlItem.SHIP_METHOD_CODE;
975 aPlsqlItem.FREIGHT_TERMS_CODE := aSqlItem.FREIGHT_TERMS_CODE;
976 aPlsqlItem.FREIGHT_CARRIER_CODE := aSqlItem.FREIGHT_CARRIER_CODE;
977 aPlsqlItem.FOB_CODE := aSqlItem.FOB_CODE;
978 aPlsqlItem.SHIPPING_INSTRUCTIONS := aSqlItem.SHIPPING_INSTRUCTIONS;
979 aPlsqlItem.PACKING_INSTRUCTIONS := aSqlItem.PACKING_INSTRUCTIONS;
980 aPlsqlItem.SHIP_QUOTE_PRICE := aSqlItem.SHIP_QUOTE_PRICE;
981 aPlsqlItem.QUANTITY := aSqlItem.QUANTITY;
982 aPlsqlItem.PRICING_QUANTITY := aSqlItem.PRICING_QUANTITY;
983 aPlsqlItem.RESERVED_QUANTITY := aSqlItem.RESERVED_QUANTITY;
987 aPlsqlItem.SHIP_TO_CONTACT_FIRST_NAME := aSqlItem.SHIP_TO_CONTACT_FIRST_NAME;
984 aPlsqlItem.RESERVATION_ID := aSqlItem.RESERVATION_ID;
985 aPlsqlItem.ORDER_LINE_ID := aSqlItem.ORDER_LINE_ID;
986 aPlsqlItem.SHIP_TO_PARTY_NAME := aSqlItem.SHIP_TO_PARTY_NAME;
988 aPlsqlItem.SHIP_TO_CONTACT_MIDDLE_NAME := aSqlItem.SHIP_TO_CONTACT_MIDDLE_NAME;
989 aPlsqlItem.SHIP_TO_CONTACT_LAST_NAME := aSqlItem.SHIP_TO_CONTACT_LAST_NAME;
990 aPlsqlItem.SHIP_TO_ADDRESS1 := aSqlItem.SHIP_TO_ADDRESS1;
991 aPlsqlItem.SHIP_TO_ADDRESS2 := aSqlItem.SHIP_TO_ADDRESS2;
992 aPlsqlItem.SHIP_TO_ADDRESS3 := aSqlItem.SHIP_TO_ADDRESS3;
993 aPlsqlItem.SHIP_TO_ADDRESS4 := aSqlItem.SHIP_TO_ADDRESS4;
994 aPlsqlItem.SHIP_TO_COUNTRY_CODE := aSqlItem.SHIP_TO_COUNTRY_CODE;
995 aPlsqlItem.SHIP_TO_COUNTRY := aSqlItem.SHIP_TO_COUNTRY;
996 aPlsqlItem.SHIP_TO_CITY := aSqlItem.SHIP_TO_CITY;
997 aPlsqlItem.SHIP_TO_POSTAL_CODE := aSqlItem.SHIP_TO_POSTAL_CODE;
998 aPlsqlItem.SHIP_TO_STATE := aSqlItem.SHIP_TO_STATE;
999 aPlsqlItem.SHIP_TO_PROVINCE := aSqlItem.SHIP_TO_PROVINCE;
1000 aPlsqlItem.SHIP_TO_COUNTY := aSqlItem.SHIP_TO_COUNTY;
1001 aPlsqlItem.ATTRIBUTE_CATEGORY := aSqlItem.ATTRIBUTE_CATEGORY;
1002 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
1003 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
1004 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
1005 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
1006 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
1007 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
1008 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
1009 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
1010 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
1011 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
1012 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
1013 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
1014 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
1015 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
1016 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
1017 aPlsqlItem.SHIPMENT_PRIORITY_CODE := aSqlItem.SHIPMENT_PRIORITY_CODE;
1018 aPlsqlItem.SHIP_FROM_ORG_ID := aSqlItem.SHIP_FROM_ORG_ID;
1019 aPlsqlItem.SHIP_TO_CUST_PARTY_ID := aSqlItem.SHIP_TO_CUST_PARTY_ID;
1020 aPlsqlItem.SHIP_METHOD_CODE_FROM := aSqlItem.SHIP_METHOD_CODE_FROM;
1021 aPlsqlItem.FREIGHT_TERMS_CODE_FROM := aSqlItem.FREIGHT_TERMS_CODE_FROM;
1022 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1023 aPlsqlItem.REQUEST_DATE_TYPE := aSqlItem.REQUEST_DATE_TYPE;
1024 aPlsqlItem.DEMAND_CLASS_CODE := aSqlItem.DEMAND_CLASS_CODE;
1025 aPlsqlItem.ATTRIBUTE16 := aSqlItem.ATTRIBUTE16;
1026 aPlsqlItem.ATTRIBUTE17 := aSqlItem.ATTRIBUTE17;
1027 aPlsqlItem.ATTRIBUTE18 := aSqlItem.ATTRIBUTE18;
1028 aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
1029 aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
1030 RETURN aPlsqlItem;
1031 END SQL_TO_PL4;
1032 FUNCTION PL_TO_SQL22(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE)
1033 RETURN ASO_QUOTE_PUB_FREIGHT_CHARG35 IS
1034 aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35;
1035 BEGIN
1036 -- initialize the object
1037 aSqlItem := ASO_QUOTE_PUB_FREIGHT_CHARG35(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1038 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1039 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1040 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
1041 aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
1042 aSqlItem.FREIGHT_CHARGE_ID := aPlsqlItem.FREIGHT_CHARGE_ID;
1043 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
1044 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
1045 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
1046 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
1047 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
1048 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
1049 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
1050 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
1051 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
1052 aSqlItem.QUOTE_SHIPMENT_ID := aPlsqlItem.QUOTE_SHIPMENT_ID;
1053 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
1054 aSqlItem.FREIGHT_CHARGE_TYPE_ID := aPlsqlItem.FREIGHT_CHARGE_TYPE_ID;
1055 aSqlItem.CHARGE_AMOUNT := aPlsqlItem.CHARGE_AMOUNT;
1056 aSqlItem.ATTRIBUTE_CATEGORY := aPlsqlItem.ATTRIBUTE_CATEGORY;
1057 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
1058 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
1059 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
1060 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
1061 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
1062 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
1063 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
1064 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
1065 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
1066 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
1067 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
1068 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
1069 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
1070 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
1071 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
1072 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1073 RETURN aSqlItem;
1074 END PL_TO_SQL22;
1075 FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
1076 RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE IS
1077 aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
1078 BEGIN
1079 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1080 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1081 aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
1082 aPlsqlItem.FREIGHT_CHARGE_ID := aSqlItem.FREIGHT_CHARGE_ID;
1083 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
1084 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
1085 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
1086 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
1090 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
1087 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
1088 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
1089 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
1091 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
1092 aPlsqlItem.QUOTE_SHIPMENT_ID := aSqlItem.QUOTE_SHIPMENT_ID;
1093 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
1094 aPlsqlItem.FREIGHT_CHARGE_TYPE_ID := aSqlItem.FREIGHT_CHARGE_TYPE_ID;
1095 aPlsqlItem.CHARGE_AMOUNT := aSqlItem.CHARGE_AMOUNT;
1096 aPlsqlItem.ATTRIBUTE_CATEGORY := aSqlItem.ATTRIBUTE_CATEGORY;
1097 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
1098 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
1099 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
1100 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
1101 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
1102 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
1103 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
1104 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
1105 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
1106 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
1107 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
1108 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
1109 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
1110 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
1111 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
1112 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1113 RETURN aPlsqlItem;
1114 END SQL_TO_PL22;
1115 FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
1116 RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_ IS
1117 aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_;
1118 BEGIN
1119 -- initialize the table
1120 aSqlItem := ASO_QUOTE_PUB_FREIGHT_CHARGE_();
1121 IF aPlsqlItem.COUNT > 0 THEN
1122 aSqlItem.EXTEND(aPlsqlItem.COUNT);
1123 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1124 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL22(aPlsqlItem(I));
1125 END LOOP;
1126 END IF;
1127 RETURN aSqlItem;
1128 END PL_TO_SQL6;
1129 FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
1130 RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE IS
1131 aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
1132 BEGIN
1133 BEGIN
1134 FOR I IN 1..aSqlItem.COUNT LOOP
1135 aPlsqlItem(I) := SQL_TO_PL22(aSqlItem(I));
1136 END LOOP;
1137 EXCEPTION
1138 WHEN OTHERS THEN
1139 NULL;
1140 END;
1141 RETURN aPlsqlItem;
1142 END SQL_TO_PL5;
1143 FUNCTION PL_TO_SQL23(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE)
1144 RETURN ASO_QUOTE_PUB_TAX_DETAIL_REC_ IS
1145 aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_REC_;
1146 BEGIN
1147 -- initialize the object
1148 aSqlItem := ASO_QUOTE_PUB_TAX_DETAIL_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1149 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1150 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1151 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
1152 aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
1153 aSqlItem.TAX_DETAIL_ID := aPlsqlItem.TAX_DETAIL_ID;
1157 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
1154 aSqlItem.QUOTE_HEADER_ID := aPlsqlItem.QUOTE_HEADER_ID;
1155 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
1156 aSqlItem.QUOTE_SHIPMENT_ID := aPlsqlItem.QUOTE_SHIPMENT_ID;
1158 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
1159 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
1160 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
1161 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
1162 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
1163 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
1164 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
1165 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
1166 aSqlItem.ORIG_TAX_CODE := aPlsqlItem.ORIG_TAX_CODE;
1167 aSqlItem.TAX_CODE := aPlsqlItem.TAX_CODE;
1168 aSqlItem.TAX_RATE := aPlsqlItem.TAX_RATE;
1169 aSqlItem.TAX_DATE := aPlsqlItem.TAX_DATE;
1170 aSqlItem.TAX_AMOUNT := aPlsqlItem.TAX_AMOUNT;
1171 aSqlItem.TAX_EXEMPT_FLAG := aPlsqlItem.TAX_EXEMPT_FLAG;
1172 aSqlItem.TAX_EXEMPT_NUMBER := aPlsqlItem.TAX_EXEMPT_NUMBER;
1173 aSqlItem.TAX_EXEMPT_REASON_CODE := aPlsqlItem.TAX_EXEMPT_REASON_CODE;
1174 aSqlItem.ATTRIBUTE_CATEGORY := aPlsqlItem.ATTRIBUTE_CATEGORY;
1175 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
1176 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
1177 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
1178 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
1179 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
1180 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
1181 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
1185 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
1182 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
1183 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
1184 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
1186 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
1187 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
1188 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
1189 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
1190 aSqlItem.TAX_INCLUSIVE_FLAG := aPlsqlItem.TAX_INCLUSIVE_FLAG;
1191 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1192 aSqlItem.ATTRIBUTE16 := aPlsqlItem.ATTRIBUTE16;
1193 aSqlItem.ATTRIBUTE17 := aPlsqlItem.ATTRIBUTE17;
1194 aSqlItem.ATTRIBUTE18 := aPlsqlItem.ATTRIBUTE18;
1195 aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
1196 aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
1197 aSqlItem.TAX_RATE_ID := aPlsqlItem.TAX_RATE_ID;
1198 RETURN aSqlItem;
1199 END PL_TO_SQL23;
1200 FUNCTION SQL_TO_PL23(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_REC_)
1201 RETURN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE IS
1202 aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE;
1203 BEGIN
1204 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1205 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1206 aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
1207 aPlsqlItem.TAX_DETAIL_ID := aSqlItem.TAX_DETAIL_ID;
1208 aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
1209 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
1210 aPlsqlItem.QUOTE_SHIPMENT_ID := aSqlItem.QUOTE_SHIPMENT_ID;
1211 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
1212 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
1213 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
1214 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
1215 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
1216 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
1217 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
1218 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
1219 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
1220 aPlsqlItem.ORIG_TAX_CODE := aSqlItem.ORIG_TAX_CODE;
1221 aPlsqlItem.TAX_CODE := aSqlItem.TAX_CODE;
1222 aPlsqlItem.TAX_RATE := aSqlItem.TAX_RATE;
1223 aPlsqlItem.TAX_DATE := aSqlItem.TAX_DATE;
1224 aPlsqlItem.TAX_AMOUNT := aSqlItem.TAX_AMOUNT;
1225 aPlsqlItem.TAX_EXEMPT_FLAG := aSqlItem.TAX_EXEMPT_FLAG;
1226 aPlsqlItem.TAX_EXEMPT_NUMBER := aSqlItem.TAX_EXEMPT_NUMBER;
1227 aPlsqlItem.TAX_EXEMPT_REASON_CODE := aSqlItem.TAX_EXEMPT_REASON_CODE;
1228 aPlsqlItem.ATTRIBUTE_CATEGORY := aSqlItem.ATTRIBUTE_CATEGORY;
1229 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
1230 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
1231 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
1232 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
1233 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
1234 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
1235 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
1236 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
1237 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
1238 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
1239 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
1240 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
1241 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
1242 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
1243 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
1244 aPlsqlItem.TAX_INCLUSIVE_FLAG := aSqlItem.TAX_INCLUSIVE_FLAG;
1245 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1246 aPlsqlItem.ATTRIBUTE16 := aSqlItem.ATTRIBUTE16;
1247 aPlsqlItem.ATTRIBUTE17 := aSqlItem.ATTRIBUTE17;
1248 aPlsqlItem.ATTRIBUTE18 := aSqlItem.ATTRIBUTE18;
1249 aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
1250 aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
1251 aPlsqlItem.TAX_RATE_ID := aSqlItem.TAX_RATE_ID;
1252 RETURN aPlsqlItem;
1253 END SQL_TO_PL23;
1254 FUNCTION PL_TO_SQL7(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE)
1255 RETURN ASO_QUOTE_PUB_TAX_DETAIL_TBL_ IS
1256 aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_TBL_;
1257 BEGIN
1258 -- initialize the table
1259 aSqlItem := ASO_QUOTE_PUB_TAX_DETAIL_TBL_();
1260 IF aPlsqlItem.COUNT > 0 THEN
1261 aSqlItem.EXTEND(aPlsqlItem.COUNT);
1262 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1263 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL23(aPlsqlItem(I));
1264 END LOOP;
1265 END IF;
1266 RETURN aSqlItem;
1267 END PL_TO_SQL7;
1268 FUNCTION SQL_TO_PL6(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_TBL_)
1269 RETURN ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE IS
1270 aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
1271 BEGIN
1272 begin
1273 FOR I IN 1..aSqlItem.COUNT LOOP
1274 aPlsqlItem(I) := SQL_TO_PL23(aSqlItem(I));
1275 END LOOP;
1276 exception
1277 when others then
1278 null;
1279 end;
1280 RETURN aPlsqlItem;
1281 END SQL_TO_PL6;
1282 FUNCTION PL_TO_SQL24(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE)
1283 RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_36 IS
1284 aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36;
1285 BEGIN
1286 -- initialize the object
1287 aSqlItem := ASO_QUOTE_PUB_LINE_ATTRIBS_36(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1291 aSqlItem.LINE_ATTRIBUTE_ID := aPlsqlItem.LINE_ATTRIBUTE_ID;
1288 NULL, NULL, NULL);
1289 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
1290 aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
1292 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
1293 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
1294 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
1295 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
1296 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
1297 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
1298 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
1299 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
1300 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
1301 aSqlItem.QUOTE_HEADER_ID := aPlsqlItem.QUOTE_HEADER_ID;
1302 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
1303 aSqlItem.QUOTE_SHIPMENT_ID := aPlsqlItem.QUOTE_SHIPMENT_ID;
1304 aSqlItem.ATTRIBUTE_TYPE_CODE := aPlsqlItem.ATTRIBUTE_TYPE_CODE;
1305 aSqlItem.NAME := aPlsqlItem.NAME;
1306 aSqlItem.VALUE := aPlsqlItem.VALUE;
1307 aSqlItem.VALUE_TYPE := aPlsqlItem.VALUE_TYPE;
1308 aSqlItem.STATUS := aPlsqlItem.STATUS;
1309 aSqlItem.APPLICATION_ID := aPlsqlItem.APPLICATION_ID;
1310 aSqlItem.START_DATE_ACTIVE := aPlsqlItem.START_DATE_ACTIVE;
1311 aSqlItem.END_DATE_ACTIVE := aPlsqlItem.END_DATE_ACTIVE;
1312 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1313 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1314 RETURN aSqlItem;
1315 END PL_TO_SQL24;
1316 FUNCTION SQL_TO_PL24(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36)
1317 RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE IS
1318 aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE;
1319 BEGIN
1320 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1321 aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
1322 aPlsqlItem.LINE_ATTRIBUTE_ID := aSqlItem.LINE_ATTRIBUTE_ID;
1323 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
1324 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
1325 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
1326 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
1327 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
1328 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
1329 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
1330 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
1331 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
1332 aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
1333 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
1334 aPlsqlItem.QUOTE_SHIPMENT_ID := aSqlItem.QUOTE_SHIPMENT_ID;
1335 aPlsqlItem.ATTRIBUTE_TYPE_CODE := aSqlItem.ATTRIBUTE_TYPE_CODE;
1336 aPlsqlItem.NAME := aSqlItem.NAME;
1337 aPlsqlItem.VALUE := aSqlItem.VALUE;
1338 aPlsqlItem.VALUE_TYPE := aSqlItem.VALUE_TYPE;
1339 aPlsqlItem.STATUS := aSqlItem.STATUS;
1340 aPlsqlItem.APPLICATION_ID := aSqlItem.APPLICATION_ID;
1341 aPlsqlItem.START_DATE_ACTIVE := aSqlItem.START_DATE_ACTIVE;
1342 aPlsqlItem.END_DATE_ACTIVE := aSqlItem.END_DATE_ACTIVE;
1343 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1344 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1345 RETURN aPlsqlItem;
1346 END SQL_TO_PL24;
1347 FUNCTION PL_TO_SQL8(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE)
1348 RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_EX IS
1349 aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX;
1350 BEGIN
1351 -- initialize the table
1352 aSqlItem := ASO_QUOTE_PUB_LINE_ATTRIBS_EX();
1353 IF aPlsqlItem.COUNT > 0 THEN
1354 aSqlItem.EXTEND(aPlsqlItem.COUNT);
1355 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1356 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL24(aPlsqlItem(I));
1357 END LOOP;
1358 END IF;
1359 RETURN aSqlItem;
1360 END PL_TO_SQL8;
1361 FUNCTION SQL_TO_PL7(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX)
1362 RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE IS
1363 aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
1364 BEGIN
1365 BEGIN
1366 FOR I IN 1..aSqlItem.COUNT LOOP
1367 aPlsqlItem(I) := SQL_TO_PL24(aSqlItem(I));
1368 END LOOP;
1369 EXCEPTION
1370 WHEN OTHERS THEN
1371 NULL;
1372 END;
1373
1374 RETURN aPlsqlItem;
1375 END SQL_TO_PL7;
1376 FUNCTION PL_TO_SQL25(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE)
1377 RETURN ASO_QUOTE_PUB_SALES_CREDIT_RE IS
1378 aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_RE;
1379 BEGIN
1380 -- initialize the object
1381 aSqlItem := ASO_QUOTE_PUB_SALES_CREDIT_RE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1382 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1383 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
1384 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1385 aSqlItem.SALES_CREDIT_ID := aPlsqlItem.SALES_CREDIT_ID;
1386 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
1387 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
1388 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
1389 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
1390 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
1394 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
1391 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
1392 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
1393 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
1395 aSqlItem.QUOTE_HEADER_ID := aPlsqlItem.QUOTE_HEADER_ID;
1396 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
1397 aSqlItem.PERCENT := aPlsqlItem.PERCENT;
1398 aSqlItem.RESOURCE_ID := aPlsqlItem.RESOURCE_ID;
1399 aSqlItem.FIRST_NAME := aPlsqlItem.FIRST_NAME;
1400 aSqlItem.LAST_NAME := aPlsqlItem.LAST_NAME;
1401 aSqlItem.SALES_CREDIT_TYPE := aPlsqlItem.SALES_CREDIT_TYPE;
1402 aSqlItem.RESOURCE_GROUP_ID := aPlsqlItem.RESOURCE_GROUP_ID;
1403 aSqlItem.EMPLOYEE_PERSON_ID := aPlsqlItem.EMPLOYEE_PERSON_ID;
1404 aSqlItem.SALES_CREDIT_TYPE_ID := aPlsqlItem.SALES_CREDIT_TYPE_ID;
1405 aSqlItem.ATTRIBUTE_CATEGORY_CODE := aPlsqlItem.ATTRIBUTE_CATEGORY_CODE;
1406 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
1407 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
1408 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
1409 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
1410 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
1411 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
1412 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
1413 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
1414 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
1415 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
1416 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
1417 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
1418 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
1422 aSqlItem.SYSTEM_ASSIGNED_FLAG := aPlsqlItem.SYSTEM_ASSIGNED_FLAG;
1419 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
1420 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
1421 aSqlItem.CREDIT_RULE_ID := aPlsqlItem.CREDIT_RULE_ID;
1423 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1424 aSqlItem.ATTRIBUTE16 := aPlsqlItem.ATTRIBUTE16;
1425 aSqlItem.ATTRIBUTE17 := aPlsqlItem.ATTRIBUTE17;
1426 aSqlItem.ATTRIBUTE18 := aPlsqlItem.ATTRIBUTE18;
1427 aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
1428 aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
1429 RETURN aSqlItem;
1430 END PL_TO_SQL25;
1431 FUNCTION SQL_TO_PL25(aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_RE)
1432 RETURN ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE IS
1433 aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE;
1434 BEGIN
1435 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1436 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1437 aPlsqlItem.SALES_CREDIT_ID := aSqlItem.SALES_CREDIT_ID;
1438 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
1439 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
1440 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
1441 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
1442 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
1443 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
1444 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
1445 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
1446 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
1447 aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
1448 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
1449 aPlsqlItem.PERCENT := aSqlItem.PERCENT;
1450 aPlsqlItem.RESOURCE_ID := aSqlItem.RESOURCE_ID;
1451 aPlsqlItem.FIRST_NAME := aSqlItem.FIRST_NAME;
1452 aPlsqlItem.LAST_NAME := aSqlItem.LAST_NAME;
1453 aPlsqlItem.SALES_CREDIT_TYPE := aSqlItem.SALES_CREDIT_TYPE;
1454 aPlsqlItem.RESOURCE_GROUP_ID := aSqlItem.RESOURCE_GROUP_ID;
1455 aPlsqlItem.EMPLOYEE_PERSON_ID := aSqlItem.EMPLOYEE_PERSON_ID;
1456 aPlsqlItem.SALES_CREDIT_TYPE_ID := aSqlItem.SALES_CREDIT_TYPE_ID;
1457 aPlsqlItem.ATTRIBUTE_CATEGORY_CODE := aSqlItem.ATTRIBUTE_CATEGORY_CODE;
1458 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
1459 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
1460 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
1461 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
1462 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
1463 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
1464 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
1465 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
1466 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
1467 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
1468 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
1469 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
1470 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
1471 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
1472 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
1473 aPlsqlItem.CREDIT_RULE_ID := aSqlItem.CREDIT_RULE_ID;
1474 aPlsqlItem.SYSTEM_ASSIGNED_FLAG := aSqlItem.SYSTEM_ASSIGNED_FLAG;
1475 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1476 aPlsqlItem.ATTRIBUTE16 := aSqlItem.ATTRIBUTE16;
1477 aPlsqlItem.ATTRIBUTE17 := aSqlItem.ATTRIBUTE17;
1478 aPlsqlItem.ATTRIBUTE18 := aSqlItem.ATTRIBUTE18;
1482 END SQL_TO_PL25;
1479 aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
1480 aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
1481 RETURN aPlsqlItem;
1483 FUNCTION PL_TO_SQL9(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE)
1484 RETURN ASO_QUOTE_PUB_SALES_CREDIT_TB IS
1485 aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_TB;
1486 BEGIN
1487 -- initialize the table
1488 aSqlItem := ASO_QUOTE_PUB_SALES_CREDIT_TB();
1489 IF aPlsqlItem.COUNT > 0 THEN
1490 aSqlItem.EXTEND(aPlsqlItem.COUNT);
1491 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1492 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL25(aPlsqlItem(I));
1493 END LOOP;
1494 END IF;
1495 RETURN aSqlItem;
1496 END PL_TO_SQL9;
1497 FUNCTION SQL_TO_PL8(aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_TB)
1498 RETURN ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE IS
1499 aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
1500 BEGIN
1501 begin
1502 FOR I IN 1..aSqlItem.COUNT LOOP
1503 aPlsqlItem(I) := SQL_TO_PL25(aSqlItem(I));
1504 END LOOP;
1505 exception
1506 when others then
1507 null;
1508 end;
1509 RETURN aPlsqlItem;
1510 END SQL_TO_PL8;
1511 FUNCTION PL_TO_SQL26(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE)
1512 RETURN ASO_QUOTE_PUB_QUOTE_PARTY_REC IS
1513 aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_REC;
1514 BEGIN
1515 -- initialize the object
1516 aSqlItem := ASO_QUOTE_PUB_QUOTE_PARTY_REC(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1517 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1518 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
1519 aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
1520 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1521 aSqlItem.QUOTE_PARTY_ID := aPlsqlItem.QUOTE_PARTY_ID;
1522 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
1523 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
1524 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
1525 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
1526 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
1527 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
1528 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
1529 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
1530 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
1531 aSqlItem.QUOTE_HEADER_ID := aPlsqlItem.QUOTE_HEADER_ID;
1532 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
1533 aSqlItem.QUOTE_SHIPMENT_ID := aPlsqlItem.QUOTE_SHIPMENT_ID;
1534 aSqlItem.PARTY_TYPE := aPlsqlItem.PARTY_TYPE;
1535 aSqlItem.PARTY_ID := aPlsqlItem.PARTY_ID;
1536 aSqlItem.PARTY_OBJECT_TYPE := aPlsqlItem.PARTY_OBJECT_TYPE;
1537 aSqlItem.PARTY_OBJECT_ID := aPlsqlItem.PARTY_OBJECT_ID;
1538 aSqlItem.ATTRIBUTE_CATEGORY := aPlsqlItem.ATTRIBUTE_CATEGORY;
1539 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
1540 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
1541 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
1542 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
1543 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
1544 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
1545 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
1546 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
1547 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
1548 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
1549 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
1550 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
1554 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1551 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
1552 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
1553 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
1555 RETURN aSqlItem;
1556 END PL_TO_SQL26;
1557 FUNCTION SQL_TO_PL26(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_REC)
1558 RETURN ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE IS
1559 aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE;
1560 BEGIN
1561 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1562 aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
1563 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1564 aPlsqlItem.QUOTE_PARTY_ID := aSqlItem.QUOTE_PARTY_ID;
1565 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
1566 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
1567 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
1568 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
1569 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
1570 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
1571 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
1575 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
1572 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
1573 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
1574 aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
1576 aPlsqlItem.QUOTE_SHIPMENT_ID := aSqlItem.QUOTE_SHIPMENT_ID;
1577 aPlsqlItem.PARTY_TYPE := aSqlItem.PARTY_TYPE;
1578 aPlsqlItem.PARTY_ID := aSqlItem.PARTY_ID;
1579 aPlsqlItem.PARTY_OBJECT_TYPE := aSqlItem.PARTY_OBJECT_TYPE;
1580 aPlsqlItem.PARTY_OBJECT_ID := aSqlItem.PARTY_OBJECT_ID;
1581 aPlsqlItem.ATTRIBUTE_CATEGORY := aSqlItem.ATTRIBUTE_CATEGORY;
1582 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
1583 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
1584 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
1585 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
1586 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
1587 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
1588 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
1589 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
1590 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
1591 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
1592 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
1593 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
1594 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
1595 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
1596 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
1597 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1598 RETURN aPlsqlItem;
1599 END SQL_TO_PL26;
1600 FUNCTION PL_TO_SQL10(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE)
1601 RETURN ASO_QUOTE_PUB_QUOTE_PARTY_TBL IS
1602 aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL;
1603 BEGIN
1604 -- initialize the table
1605 aSqlItem := ASO_QUOTE_PUB_QUOTE_PARTY_TBL();
1606 IF aPlsqlItem.COUNT > 0 THEN
1607 aSqlItem.EXTEND(aPlsqlItem.COUNT);
1608 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1609 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL26(aPlsqlItem(I));
1610 END LOOP;
1611 END IF;
1612 RETURN aSqlItem;
1613 END PL_TO_SQL10;
1614 FUNCTION SQL_TO_PL9(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL)
1615 RETURN ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE IS
1616 aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
1617 BEGIN
1618 BEGIN
1619
1620 FOR I IN 1..aSqlItem.COUNT LOOP
1621 aPlsqlItem(I) := SQL_TO_PL26(aSqlItem(I));
1622 END LOOP;
1623 EXCEPTION
1624 WHEN OTHERS THEN
1625 NULL;
1626 END;
1627 RETURN aPlsqlItem;
1628 END SQL_TO_PL9;
1629 FUNCTION PL_TO_SQL27(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_REC_TYPE)
1630 RETURN ASO_QUOTE_PUB_QTE_LINE_REC_TY IS
1631 aSqlItem ASO_QUOTE_PUB_QTE_LINE_REC_TY;
1632 BEGIN
1633 -- initialize the object
1634 aSqlItem := ASO_QUOTE_PUB_QTE_LINE_REC_TY(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1635 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1636 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1637 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1638 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1639 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
1640 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
1641 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
1642 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
1643 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
1644 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
1645 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
1646 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
1647 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
1648 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
1649 aSqlItem.QUOTE_HEADER_ID := aPlsqlItem.QUOTE_HEADER_ID;
1650 aSqlItem.ORG_ID := aPlsqlItem.ORG_ID;
1651 aSqlItem.LINE_CATEGORY_CODE := aPlsqlItem.LINE_CATEGORY_CODE;
1652 aSqlItem.ITEM_TYPE_CODE := aPlsqlItem.ITEM_TYPE_CODE;
1653 aSqlItem.LINE_NUMBER := aPlsqlItem.LINE_NUMBER;
1654 aSqlItem.START_DATE_ACTIVE := aPlsqlItem.START_DATE_ACTIVE;
1655 aSqlItem.END_DATE_ACTIVE := aPlsqlItem.END_DATE_ACTIVE;
1656 aSqlItem.ORDER_LINE_TYPE_ID := aPlsqlItem.ORDER_LINE_TYPE_ID;
1657 aSqlItem.INVOICE_TO_PARTY_SITE_ID := aPlsqlItem.INVOICE_TO_PARTY_SITE_ID;
1658 aSqlItem.INVOICE_TO_PARTY_ID := aPlsqlItem.INVOICE_TO_PARTY_ID;
1659 aSqlItem.INVOICE_TO_CUST_ACCOUNT_ID := aPlsqlItem.INVOICE_TO_CUST_ACCOUNT_ID;
1660 aSqlItem.ORGANIZATION_ID := aPlsqlItem.ORGANIZATION_ID;
1661 aSqlItem.INVENTORY_ITEM_ID := aPlsqlItem.INVENTORY_ITEM_ID;
1662 aSqlItem.QUANTITY := aPlsqlItem.QUANTITY;
1663 aSqlItem.UOM_CODE := aPlsqlItem.UOM_CODE;
1664 aSqlItem.PRICING_QUANTITY_UOM := aPlsqlItem.PRICING_QUANTITY_UOM;
1665 aSqlItem.MARKETING_SOURCE_CODE_ID := aPlsqlItem.MARKETING_SOURCE_CODE_ID;
1666 aSqlItem.PRICE_LIST_ID := aPlsqlItem.PRICE_LIST_ID;
1667 aSqlItem.PRICE_LIST_LINE_ID := aPlsqlItem.PRICE_LIST_LINE_ID;
1668 aSqlItem.CURRENCY_CODE := aPlsqlItem.CURRENCY_CODE;
1669 aSqlItem.LINE_LIST_PRICE := aPlsqlItem.LINE_LIST_PRICE;
1670 aSqlItem.LINE_ADJUSTED_AMOUNT := aPlsqlItem.LINE_ADJUSTED_AMOUNT;
1671 aSqlItem.LINE_ADJUSTED_PERCENT := aPlsqlItem.LINE_ADJUSTED_PERCENT;
1672 aSqlItem.LINE_QUOTE_PRICE := aPlsqlItem.LINE_QUOTE_PRICE;
1673 aSqlItem.RELATED_ITEM_ID := aPlsqlItem.RELATED_ITEM_ID;
1674 aSqlItem.ITEM_RELATIONSHIP_TYPE := aPlsqlItem.ITEM_RELATIONSHIP_TYPE;
1675 aSqlItem.ACCOUNTING_RULE_ID := aPlsqlItem.ACCOUNTING_RULE_ID;
1676 aSqlItem.INVOICING_RULE_ID := aPlsqlItem.INVOICING_RULE_ID;
1680 aSqlItem.SECTION_ID := aPlsqlItem.SECTION_ID;
1677 aSqlItem.SPLIT_SHIPMENT_FLAG := aPlsqlItem.SPLIT_SHIPMENT_FLAG;
1678 aSqlItem.BACKORDER_FLAG := aPlsqlItem.BACKORDER_FLAG;
1679 aSqlItem.MINISITE_ID := aPlsqlItem.MINISITE_ID;
1681 aSqlItem.SELLING_PRICE_CHANGE := aPlsqlItem.SELLING_PRICE_CHANGE;
1682 aSqlItem.RECALCULATE_FLAG := aPlsqlItem.RECALCULATE_FLAG;
1683 aSqlItem.ATTRIBUTE_CATEGORY := aPlsqlItem.ATTRIBUTE_CATEGORY;
1684 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
1685 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
1686 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
1687 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
1688 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
1689 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
1690 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
1691 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
1692 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
1693 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
1694 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
1695 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
1696 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
1697 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
1698 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
1699 aSqlItem.FFM_CONTENT_NAME := aPlsqlItem.FFM_CONTENT_NAME;
1700 aSqlItem.FFM_DOCUMENT_TYPE := aPlsqlItem.FFM_DOCUMENT_TYPE;
1701 aSqlItem.FFM_MEDIA_TYPE := aPlsqlItem.FFM_MEDIA_TYPE;
1702 aSqlItem.FFM_MEDIA_ID := aPlsqlItem.FFM_MEDIA_ID;
1703 aSqlItem.FFM_CONTENT_TYPE := aPlsqlItem.FFM_CONTENT_TYPE;
1704 aSqlItem.FFM_USER_NOTE := aPlsqlItem.FFM_USER_NOTE;
1705 aSqlItem.PRICED_PRICE_LIST_ID := aPlsqlItem.PRICED_PRICE_LIST_ID;
1706 aSqlItem.AGREEMENT_ID := aPlsqlItem.AGREEMENT_ID;
1707 aSqlItem.COMMITMENT_ID := aPlsqlItem.COMMITMENT_ID;
1708 aSqlItem.DISPLAY_ARITHMETIC_OPERATOR := aPlsqlItem.DISPLAY_ARITHMETIC_OPERATOR;
1709 aSqlItem.PRICING_STATUS_CODE := aPlsqlItem.PRICING_STATUS_CODE;
1710 aSqlItem.PRICING_STATUS_TEXT := aPlsqlItem.PRICING_STATUS_TEXT;
1711 aSqlItem.LINE_TYPE_SOURCE_FLAG := aPlsqlItem.LINE_TYPE_SOURCE_FLAG;
1712 aSqlItem.SERVICE_ITEM_FLAG := aPlsqlItem.SERVICE_ITEM_FLAG;
1713 aSqlItem.SERVICEABLE_PRODUCT_FLAG := aPlsqlItem.SERVICEABLE_PRODUCT_FLAG;
1714 aSqlItem.INVOICE_TO_CUST_PARTY_ID := aPlsqlItem.INVOICE_TO_CUST_PARTY_ID;
1715 aSqlItem.IS_LINE_CHANGED_FLAG := aPlsqlItem.IS_LINE_CHANGED_FLAG;
1716 aSqlItem.UI_LINE_NUMBER := aPlsqlItem.UI_LINE_NUMBER;
1717 aSqlItem.PRICING_LINE_TYPE_INDICATOR := aPlsqlItem.PRICING_LINE_TYPE_INDICATOR;
1718 aSqlItem.ITEM_REVISION := aPlsqlItem.ITEM_REVISION;
1719 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1720 aSqlItem.SHIP_MODEL_COMPLETE_FLAG := aPlsqlItem.SHIP_MODEL_COMPLETE_FLAG;
1721 aSqlItem.END_CUSTOMER_PARTY_ID := aPlsqlItem.END_CUSTOMER_PARTY_ID;
1722 aSqlItem.END_CUSTOMER_PARTY_SITE_ID := aPlsqlItem.END_CUSTOMER_PARTY_SITE_ID;
1723 aSqlItem.END_CUSTOMER_CUST_ACCOUNT_ID := aPlsqlItem.END_CUSTOMER_CUST_ACCOUNT_ID;
1724 aSqlItem.END_CUSTOMER_CUST_PARTY_ID := aPlsqlItem.END_CUSTOMER_CUST_PARTY_ID;
1725 aSqlItem.CHARGE_PERIODICITY_CODE := aPlsqlItem.CHARGE_PERIODICITY_CODE;
1726 aSqlItem.ATTRIBUTE16 := aPlsqlItem.ATTRIBUTE16;
1727 aSqlItem.ATTRIBUTE17 := aPlsqlItem.ATTRIBUTE17;
1728 aSqlItem.ATTRIBUTE18 := aPlsqlItem.ATTRIBUTE18;
1729 aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
1730 aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
1731 aSqlItem.LINE_PAYNOW_CHARGES := aPlsqlItem.LINE_PAYNOW_CHARGES;
1732 aSqlItem.LINE_PAYNOW_TAX := aPlsqlItem.LINE_PAYNOW_TAX;
1733 aSqlItem.LINE_PAYNOW_SUBTOTAL := aPlsqlItem.LINE_PAYNOW_SUBTOTAL;
1734 aSqlItem.PRICING_QUANTITY := aPlsqlItem.PRICING_QUANTITY;
1735 aSqlItem.CONFIG_MODEL_TYPE := aPlsqlItem.CONFIG_MODEL_TYPE;
1736 RETURN aSqlItem;
1737 END PL_TO_SQL27;
1738 FUNCTION SQL_TO_PL27(aSqlItem ASO_QUOTE_PUB_QTE_LINE_REC_TY)
1739 RETURN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE IS
1740 aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
1741 BEGIN
1742 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1743 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
1744 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
1745 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
1746 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
1747 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
1748 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
1749 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
1750 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
1751 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
1752 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
1753 aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
1754 aPlsqlItem.ORG_ID := aSqlItem.ORG_ID;
1755 aPlsqlItem.LINE_CATEGORY_CODE := aSqlItem.LINE_CATEGORY_CODE;
1756 aPlsqlItem.ITEM_TYPE_CODE := aSqlItem.ITEM_TYPE_CODE;
1757 aPlsqlItem.LINE_NUMBER := aSqlItem.LINE_NUMBER;
1758 aPlsqlItem.START_DATE_ACTIVE := aSqlItem.START_DATE_ACTIVE;
1759 aPlsqlItem.END_DATE_ACTIVE := aSqlItem.END_DATE_ACTIVE;
1760 aPlsqlItem.ORDER_LINE_TYPE_ID := aSqlItem.ORDER_LINE_TYPE_ID;
1761 aPlsqlItem.INVOICE_TO_PARTY_SITE_ID := aSqlItem.INVOICE_TO_PARTY_SITE_ID;
1762 aPlsqlItem.INVOICE_TO_PARTY_ID := aSqlItem.INVOICE_TO_PARTY_ID;
1763 aPlsqlItem.INVOICE_TO_CUST_ACCOUNT_ID := aSqlItem.INVOICE_TO_CUST_ACCOUNT_ID;
1764 aPlsqlItem.ORGANIZATION_ID := aSqlItem.ORGANIZATION_ID;
1765 IF( aPlsqlItem.ORGANIZATION_ID IS NULL)then
1766 aPlsqlItem.ORGANIZATION_ID := FND_API.G_MISS_NUM ;
1767 END IF ;
1768 aPlsqlItem.INVENTORY_ITEM_ID := aSqlItem.INVENTORY_ITEM_ID;
1769 aPlsqlItem.QUANTITY := aSqlItem.QUANTITY;
1770 aPlsqlItem.UOM_CODE := aSqlItem.UOM_CODE;
1771 aPlsqlItem.PRICING_QUANTITY_UOM := aSqlItem.PRICING_QUANTITY_UOM;
1772 aPlsqlItem.MARKETING_SOURCE_CODE_ID := aSqlItem.MARKETING_SOURCE_CODE_ID;
1773 aPlsqlItem.PRICE_LIST_ID := aSqlItem.PRICE_LIST_ID;
1774 aPlsqlItem.PRICE_LIST_LINE_ID := aSqlItem.PRICE_LIST_LINE_ID;
1775 aPlsqlItem.CURRENCY_CODE := aSqlItem.CURRENCY_CODE;
1776 aPlsqlItem.LINE_LIST_PRICE := aSqlItem.LINE_LIST_PRICE;
1777 aPlsqlItem.LINE_ADJUSTED_AMOUNT := aSqlItem.LINE_ADJUSTED_AMOUNT;
1778 aPlsqlItem.LINE_ADJUSTED_PERCENT := aSqlItem.LINE_ADJUSTED_PERCENT;
1779 aPlsqlItem.LINE_QUOTE_PRICE := aSqlItem.LINE_QUOTE_PRICE;
1780 aPlsqlItem.RELATED_ITEM_ID := aSqlItem.RELATED_ITEM_ID;
1781 aPlsqlItem.ITEM_RELATIONSHIP_TYPE := aSqlItem.ITEM_RELATIONSHIP_TYPE;
1782 aPlsqlItem.ACCOUNTING_RULE_ID := aSqlItem.ACCOUNTING_RULE_ID;
1783 aPlsqlItem.INVOICING_RULE_ID := aSqlItem.INVOICING_RULE_ID;
1784 aPlsqlItem.SPLIT_SHIPMENT_FLAG := aSqlItem.SPLIT_SHIPMENT_FLAG;
1785 aPlsqlItem.BACKORDER_FLAG := aSqlItem.BACKORDER_FLAG;
1786 aPlsqlItem.MINISITE_ID := aSqlItem.MINISITE_ID;
1787 aPlsqlItem.SECTION_ID := aSqlItem.SECTION_ID;
1788 aPlsqlItem.SELLING_PRICE_CHANGE := aSqlItem.SELLING_PRICE_CHANGE;
1789 aPlsqlItem.RECALCULATE_FLAG := aSqlItem.RECALCULATE_FLAG;
1790 aPlsqlItem.ATTRIBUTE_CATEGORY := aSqlItem.ATTRIBUTE_CATEGORY;
1791 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
1795 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
1792 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
1793 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
1794 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
1796 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
1797 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
1798 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
1799 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
1800 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
1801 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
1802 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
1803 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
1804 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
1805 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
1806 aPlsqlItem.FFM_CONTENT_NAME := aSqlItem.FFM_CONTENT_NAME;
1807 aPlsqlItem.FFM_DOCUMENT_TYPE := aSqlItem.FFM_DOCUMENT_TYPE;
1808 aPlsqlItem.FFM_MEDIA_TYPE := aSqlItem.FFM_MEDIA_TYPE;
1809 aPlsqlItem.FFM_MEDIA_ID := aSqlItem.FFM_MEDIA_ID;
1810 aPlsqlItem.FFM_CONTENT_TYPE := aSqlItem.FFM_CONTENT_TYPE;
1811 aPlsqlItem.FFM_USER_NOTE := aSqlItem.FFM_USER_NOTE;
1812 aPlsqlItem.PRICED_PRICE_LIST_ID := aSqlItem.PRICED_PRICE_LIST_ID;
1813 aPlsqlItem.AGREEMENT_ID := aSqlItem.AGREEMENT_ID;
1814 aPlsqlItem.COMMITMENT_ID := aSqlItem.COMMITMENT_ID;
1815 aPlsqlItem.DISPLAY_ARITHMETIC_OPERATOR := aSqlItem.DISPLAY_ARITHMETIC_OPERATOR;
1816 aPlsqlItem.PRICING_STATUS_CODE := aSqlItem.PRICING_STATUS_CODE;
1817 aPlsqlItem.PRICING_STATUS_TEXT := aSqlItem.PRICING_STATUS_TEXT;
1818 aPlsqlItem.LINE_TYPE_SOURCE_FLAG := aSqlItem.LINE_TYPE_SOURCE_FLAG;
1819 aPlsqlItem.SERVICE_ITEM_FLAG := aSqlItem.SERVICE_ITEM_FLAG;
1820 aPlsqlItem.SERVICEABLE_PRODUCT_FLAG := aSqlItem.SERVICEABLE_PRODUCT_FLAG;
1821 aPlsqlItem.INVOICE_TO_CUST_PARTY_ID := aSqlItem.INVOICE_TO_CUST_PARTY_ID;
1822 aPlsqlItem.IS_LINE_CHANGED_FLAG := aSqlItem.IS_LINE_CHANGED_FLAG;
1823 aPlsqlItem.UI_LINE_NUMBER := aSqlItem.UI_LINE_NUMBER;
1824 aPlsqlItem.PRICING_LINE_TYPE_INDICATOR := aSqlItem.PRICING_LINE_TYPE_INDICATOR;
1825 aPlsqlItem.ITEM_REVISION := aSqlItem.ITEM_REVISION;
1826 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1827 aPlsqlItem.SHIP_MODEL_COMPLETE_FLAG := aSqlItem.SHIP_MODEL_COMPLETE_FLAG;
1828 aPlsqlItem.END_CUSTOMER_PARTY_ID := aSqlItem.END_CUSTOMER_PARTY_ID;
1829 aPlsqlItem.END_CUSTOMER_PARTY_SITE_ID := aSqlItem.END_CUSTOMER_PARTY_SITE_ID;
1830 aPlsqlItem.END_CUSTOMER_CUST_ACCOUNT_ID := aSqlItem.END_CUSTOMER_CUST_ACCOUNT_ID;
1831 aPlsqlItem.END_CUSTOMER_CUST_PARTY_ID := aSqlItem.END_CUSTOMER_CUST_PARTY_ID;
1832 aPlsqlItem.CHARGE_PERIODICITY_CODE := aSqlItem.CHARGE_PERIODICITY_CODE;
1833 aPlsqlItem.ATTRIBUTE16 := aSqlItem.ATTRIBUTE16;
1834 aPlsqlItem.ATTRIBUTE17 := aSqlItem.ATTRIBUTE17;
1835 aPlsqlItem.ATTRIBUTE18 := aSqlItem.ATTRIBUTE18;
1836 aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
1837 aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
1838 aPlsqlItem.LINE_PAYNOW_CHARGES := aSqlItem.LINE_PAYNOW_CHARGES;
1839 aPlsqlItem.LINE_PAYNOW_TAX := aSqlItem.LINE_PAYNOW_TAX;
1840 aPlsqlItem.LINE_PAYNOW_SUBTOTAL := aSqlItem.LINE_PAYNOW_SUBTOTAL;
1841 aPlsqlItem.PRICING_QUANTITY := aSqlItem.PRICING_QUANTITY;
1842 aPlsqlItem.CONFIG_MODEL_TYPE := aSqlItem.CONFIG_MODEL_TYPE;
1843 RETURN aPlsqlItem;
1844 END SQL_TO_PL27;
1845 FUNCTION PL_TO_SQL1(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE)
1846 RETURN ASO_QUOTE_PUB_QTE_LINE_TBL_TY IS
1847 aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY;
1848 BEGIN
1849 -- initialize the table
1850 aSqlItem := ASO_QUOTE_PUB_QTE_LINE_TBL_TY();
1851 IF aPlsqlItem.COUNT > 0 THEN
1852 aSqlItem.EXTEND(aPlsqlItem.COUNT);
1853 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1854 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL27(aPlsqlItem(I));
1855 END LOOP;
1856 END IF;
1857 RETURN aSqlItem;
1858 END PL_TO_SQL1;
1859 FUNCTION SQL_TO_PL10(aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY)
1860 RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE IS
1861 aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
1862 BEGIN
1863 begin
1864 FOR I IN 1..aSqlItem.COUNT LOOP
1865 aPlsqlItem(I) := SQL_TO_PL27(aSqlItem(I));
1866 END LOOP;
1867 exception
1868 when others then
1869 null;
1870 end;
1871 RETURN aPlsqlItem;
1872 END SQL_TO_PL10;
1873 FUNCTION PL_TO_SQL28(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE)
1874 RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_RE IS
1875 aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE;
1876 BEGIN
1877 -- initialize the object
1878 aSqlItem := ASO_QUOTE_PUB_QTE_LINE_DTL_RE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1879 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1880 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1881 NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1882 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1883 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
1884 aSqlItem.QUOTE_LINE_DETAIL_ID := aPlsqlItem.QUOTE_LINE_DETAIL_ID;
1885 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
1886 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
1887 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
1888 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
1889 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
1890 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
1891 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
1892 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
1893 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
1894 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
1895 aSqlItem.CONFIG_HEADER_ID := aPlsqlItem.CONFIG_HEADER_ID;
1896 aSqlItem.CONFIG_REVISION_NUM := aPlsqlItem.CONFIG_REVISION_NUM;
1897 aSqlItem.CONFIG_ITEM_ID := aPlsqlItem.CONFIG_ITEM_ID;
1898 aSqlItem.COMPLETE_CONFIGURATION_FLAG := aPlsqlItem.COMPLETE_CONFIGURATION_FLAG;
1899 aSqlItem.VALID_CONFIGURATION_FLAG := aPlsqlItem.VALID_CONFIGURATION_FLAG;
1900 aSqlItem.COMPONENT_CODE := aPlsqlItem.COMPONENT_CODE;
1901 aSqlItem.SERVICE_COTERMINATE_FLAG := aPlsqlItem.SERVICE_COTERMINATE_FLAG;
1902 aSqlItem.SERVICE_DURATION := aPlsqlItem.SERVICE_DURATION;
1903 aSqlItem.SERVICE_PERIOD := aPlsqlItem.SERVICE_PERIOD;
1904 aSqlItem.SERVICE_UNIT_SELLING_PERCENT := aPlsqlItem.SERVICE_UNIT_SELLING_PERCENT;
1905 aSqlItem.SERVICE_UNIT_LIST_PERCENT := aPlsqlItem.SERVICE_UNIT_LIST_PERCENT;
1906 aSqlItem.SERVICE_NUMBER := aPlsqlItem.SERVICE_NUMBER;
1907 aSqlItem.UNIT_PERCENT_BASE_PRICE := aPlsqlItem.UNIT_PERCENT_BASE_PRICE;
1908 aSqlItem.ATTRIBUTE_CATEGORY := aPlsqlItem.ATTRIBUTE_CATEGORY;
1909 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
1910 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
1911 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
1912 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
1913 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
1914 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
1915 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
1916 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
1917 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
1918 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
1919 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
1920 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
1921 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
1922 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
1923 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
1924 aSqlItem.SERVICE_REF_TYPE_CODE := aPlsqlItem.SERVICE_REF_TYPE_CODE;
1925 aSqlItem.SERVICE_REF_ORDER_NUMBER := aPlsqlItem.SERVICE_REF_ORDER_NUMBER;
1926 aSqlItem.SERVICE_REF_LINE_NUMBER := aPlsqlItem.SERVICE_REF_LINE_NUMBER;
1927 aSqlItem.SERVICE_REF_QTE_LINE_INDEX := aPlsqlItem.SERVICE_REF_QTE_LINE_INDEX;
1928 aSqlItem.SERVICE_REF_LINE_ID := aPlsqlItem.SERVICE_REF_LINE_ID;
1929 aSqlItem.SERVICE_REF_SYSTEM_ID := aPlsqlItem.SERVICE_REF_SYSTEM_ID;
1930 aSqlItem.SERVICE_REF_OPTION_NUMB := aPlsqlItem.SERVICE_REF_OPTION_NUMB;
1931 aSqlItem.SERVICE_REF_SHIPMENT_NUMB := aPlsqlItem.SERVICE_REF_SHIPMENT_NUMB;
1932 aSqlItem.RETURN_REF_TYPE := aPlsqlItem.RETURN_REF_TYPE;
1933 aSqlItem.RETURN_REF_HEADER_ID := aPlsqlItem.RETURN_REF_HEADER_ID;
1934 aSqlItem.RETURN_REF_LINE_ID := aPlsqlItem.RETURN_REF_LINE_ID;
1935 aSqlItem.RETURN_ATTRIBUTE1 := aPlsqlItem.RETURN_ATTRIBUTE1;
1936 aSqlItem.RETURN_ATTRIBUTE2 := aPlsqlItem.RETURN_ATTRIBUTE2;
1937 aSqlItem.RETURN_ATTRIBUTE3 := aPlsqlItem.RETURN_ATTRIBUTE3;
1938 aSqlItem.RETURN_ATTRIBUTE4 := aPlsqlItem.RETURN_ATTRIBUTE4;
1939 aSqlItem.RETURN_ATTRIBUTE5 := aPlsqlItem.RETURN_ATTRIBUTE5;
1940 aSqlItem.RETURN_ATTRIBUTE6 := aPlsqlItem.RETURN_ATTRIBUTE6;
1941 aSqlItem.RETURN_ATTRIBUTE7 := aPlsqlItem.RETURN_ATTRIBUTE7;
1942 aSqlItem.RETURN_ATTRIBUTE8 := aPlsqlItem.RETURN_ATTRIBUTE8;
1943 aSqlItem.RETURN_ATTRIBUTE9 := aPlsqlItem.RETURN_ATTRIBUTE9;
1944 aSqlItem.RETURN_ATTRIBUTE10 := aPlsqlItem.RETURN_ATTRIBUTE10;
1945 aSqlItem.RETURN_ATTRIBUTE11 := aPlsqlItem.RETURN_ATTRIBUTE11;
1946 aSqlItem.RETURN_ATTRIBUTE15 := aPlsqlItem.RETURN_ATTRIBUTE15;
1947 aSqlItem.RETURN_ATTRIBUTE12 := aPlsqlItem.RETURN_ATTRIBUTE12;
1948 aSqlItem.RETURN_ATTRIBUTE13 := aPlsqlItem.RETURN_ATTRIBUTE13;
1949 aSqlItem.RETURN_ATTRIBUTE14 := aPlsqlItem.RETURN_ATTRIBUTE14;
1950 aSqlItem.RETURN_ATTRIBUTE_CATEGORY := aPlsqlItem.RETURN_ATTRIBUTE_CATEGORY;
1951 aSqlItem.RETURN_REASON_CODE := aPlsqlItem.RETURN_REASON_CODE;
1952 aSqlItem.CHANGE_REASON_CODE := aPlsqlItem.CHANGE_REASON_CODE;
1953 aSqlItem.PARENT_CONFIG_ITEM_ID := aPlsqlItem.PARENT_CONFIG_ITEM_ID;
1954 aSqlItem.REF_TYPE_CODE := aPlsqlItem.REF_TYPE_CODE;
1955 aSqlItem.REF_LINE_ID := aPlsqlItem.REF_LINE_ID;
1956 aSqlItem.REF_LINE_INDEX := aPlsqlItem.REF_LINE_INDEX;
1957 aSqlItem.INSTANCE_ID := aPlsqlItem.INSTANCE_ID;
1958 aSqlItem.BOM_SORT_ORDER := aPlsqlItem.BOM_SORT_ORDER;
1959 aSqlItem.CONFIG_DELTA := aPlsqlItem.CONFIG_DELTA;
1960 aSqlItem.CONFIG_INSTANCE_NAME := aPlsqlItem.CONFIG_INSTANCE_NAME;
1961 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1962 aSqlItem.TOP_MODEL_LINE_ID := aPlsqlItem.TOP_MODEL_LINE_ID;
1963 aSqlItem.TOP_MODEL_LINE_INDEX := aPlsqlItem.TOP_MODEL_LINE_INDEX;
1964 aSqlItem.ATO_LINE_ID := aPlsqlItem.ATO_LINE_ID;
1965 aSqlItem.ATO_LINE_INDEX := aPlsqlItem.ATO_LINE_INDEX;
1966 aSqlItem.COMPONENT_SEQUENCE_ID := aPlsqlItem.COMPONENT_SEQUENCE_ID;
1967 aSqlItem.ATTRIBUTE16 := aPlsqlItem.ATTRIBUTE16;
1968 aSqlItem.ATTRIBUTE17 := aPlsqlItem.ATTRIBUTE17;
1969 aSqlItem.ATTRIBUTE18 := aPlsqlItem.ATTRIBUTE18;
1970 aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
1971 aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
1972 RETURN aSqlItem;
1973 END PL_TO_SQL28;
1974 FUNCTION SQL_TO_PL28(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE)
1975 RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE IS
1976 aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE;
1977 BEGIN
1978 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1979 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1980 aPlsqlItem.QUOTE_LINE_DETAIL_ID := aSqlItem.QUOTE_LINE_DETAIL_ID;
1981 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
1982 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
1983 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
1984 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
1985 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
1986 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
1987 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
1988 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
1989 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
1990 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
1991 aPlsqlItem.CONFIG_HEADER_ID := aSqlItem.CONFIG_HEADER_ID;
1992 aPlsqlItem.CONFIG_REVISION_NUM := aSqlItem.CONFIG_REVISION_NUM;
1993 aPlsqlItem.CONFIG_ITEM_ID := aSqlItem.CONFIG_ITEM_ID;
1994 aPlsqlItem.COMPLETE_CONFIGURATION_FLAG := aSqlItem.COMPLETE_CONFIGURATION_FLAG;
1995 aPlsqlItem.VALID_CONFIGURATION_FLAG := aSqlItem.VALID_CONFIGURATION_FLAG;
1996 aPlsqlItem.COMPONENT_CODE := aSqlItem.COMPONENT_CODE;
1997 aPlsqlItem.SERVICE_COTERMINATE_FLAG := aSqlItem.SERVICE_COTERMINATE_FLAG;
1998 aPlsqlItem.SERVICE_DURATION := aSqlItem.SERVICE_DURATION;
1999 aPlsqlItem.SERVICE_PERIOD := aSqlItem.SERVICE_PERIOD;
2000 aPlsqlItem.SERVICE_UNIT_SELLING_PERCENT := aSqlItem.SERVICE_UNIT_SELLING_PERCENT;
2004 aPlsqlItem.ATTRIBUTE_CATEGORY := aSqlItem.ATTRIBUTE_CATEGORY;
2001 aPlsqlItem.SERVICE_UNIT_LIST_PERCENT := aSqlItem.SERVICE_UNIT_LIST_PERCENT;
2002 aPlsqlItem.SERVICE_NUMBER := aSqlItem.SERVICE_NUMBER;
2003 aPlsqlItem.UNIT_PERCENT_BASE_PRICE := aSqlItem.UNIT_PERCENT_BASE_PRICE;
2005 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
2006 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
2007 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
2008 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
2009 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
2010 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
2011 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
2012 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
2013 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
2014 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
2015 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
2016 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
2017 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
2018 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
2019 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
2020 aPlsqlItem.SERVICE_REF_TYPE_CODE := aSqlItem.SERVICE_REF_TYPE_CODE;
2021 aPlsqlItem.SERVICE_REF_ORDER_NUMBER := aSqlItem.SERVICE_REF_ORDER_NUMBER;
2022 aPlsqlItem.SERVICE_REF_LINE_NUMBER := aSqlItem.SERVICE_REF_LINE_NUMBER;
2023 aPlsqlItem.SERVICE_REF_QTE_LINE_INDEX := aSqlItem.SERVICE_REF_QTE_LINE_INDEX;
2024 aPlsqlItem.SERVICE_REF_LINE_ID := aSqlItem.SERVICE_REF_LINE_ID;
2025 aPlsqlItem.SERVICE_REF_SYSTEM_ID := aSqlItem.SERVICE_REF_SYSTEM_ID;
2026 aPlsqlItem.SERVICE_REF_OPTION_NUMB := aSqlItem.SERVICE_REF_OPTION_NUMB;
2027 aPlsqlItem.SERVICE_REF_SHIPMENT_NUMB := aSqlItem.SERVICE_REF_SHIPMENT_NUMB;
2028 aPlsqlItem.RETURN_REF_TYPE := aSqlItem.RETURN_REF_TYPE;
2029 aPlsqlItem.RETURN_REF_HEADER_ID := aSqlItem.RETURN_REF_HEADER_ID;
2030 aPlsqlItem.RETURN_REF_LINE_ID := aSqlItem.RETURN_REF_LINE_ID;
2031 aPlsqlItem.RETURN_ATTRIBUTE1 := aSqlItem.RETURN_ATTRIBUTE1;
2032 aPlsqlItem.RETURN_ATTRIBUTE2 := aSqlItem.RETURN_ATTRIBUTE2;
2033 aPlsqlItem.RETURN_ATTRIBUTE3 := aSqlItem.RETURN_ATTRIBUTE3;
2034 aPlsqlItem.RETURN_ATTRIBUTE4 := aSqlItem.RETURN_ATTRIBUTE4;
2035 aPlsqlItem.RETURN_ATTRIBUTE5 := aSqlItem.RETURN_ATTRIBUTE5;
2036 aPlsqlItem.RETURN_ATTRIBUTE6 := aSqlItem.RETURN_ATTRIBUTE6;
2037 aPlsqlItem.RETURN_ATTRIBUTE7 := aSqlItem.RETURN_ATTRIBUTE7;
2038 aPlsqlItem.RETURN_ATTRIBUTE8 := aSqlItem.RETURN_ATTRIBUTE8;
2039 aPlsqlItem.RETURN_ATTRIBUTE9 := aSqlItem.RETURN_ATTRIBUTE9;
2040 aPlsqlItem.RETURN_ATTRIBUTE10 := aSqlItem.RETURN_ATTRIBUTE10;
2041 aPlsqlItem.RETURN_ATTRIBUTE11 := aSqlItem.RETURN_ATTRIBUTE11;
2042 aPlsqlItem.RETURN_ATTRIBUTE15 := aSqlItem.RETURN_ATTRIBUTE15;
2043 aPlsqlItem.RETURN_ATTRIBUTE12 := aSqlItem.RETURN_ATTRIBUTE12;
2044 aPlsqlItem.RETURN_ATTRIBUTE13 := aSqlItem.RETURN_ATTRIBUTE13;
2045 aPlsqlItem.RETURN_ATTRIBUTE14 := aSqlItem.RETURN_ATTRIBUTE14;
2046 aPlsqlItem.RETURN_ATTRIBUTE_CATEGORY := aSqlItem.RETURN_ATTRIBUTE_CATEGORY;
2047 aPlsqlItem.RETURN_REASON_CODE := aSqlItem.RETURN_REASON_CODE;
2048 aPlsqlItem.CHANGE_REASON_CODE := aSqlItem.CHANGE_REASON_CODE;
2049 aPlsqlItem.PARENT_CONFIG_ITEM_ID := aSqlItem.PARENT_CONFIG_ITEM_ID;
2050 aPlsqlItem.REF_TYPE_CODE := aSqlItem.REF_TYPE_CODE;
2051 aPlsqlItem.REF_LINE_ID := aSqlItem.REF_LINE_ID;
2052 aPlsqlItem.REF_LINE_INDEX := aSqlItem.REF_LINE_INDEX;
2053 aPlsqlItem.INSTANCE_ID := aSqlItem.INSTANCE_ID;
2054 aPlsqlItem.BOM_SORT_ORDER := aSqlItem.BOM_SORT_ORDER;
2055 aPlsqlItem.CONFIG_DELTA := aSqlItem.CONFIG_DELTA;
2056 aPlsqlItem.CONFIG_INSTANCE_NAME := aSqlItem.CONFIG_INSTANCE_NAME;
2057 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2058 aPlsqlItem.TOP_MODEL_LINE_ID := aSqlItem.TOP_MODEL_LINE_ID;
2059 aPlsqlItem.TOP_MODEL_LINE_INDEX := aSqlItem.TOP_MODEL_LINE_INDEX;
2060 aPlsqlItem.ATO_LINE_ID := aSqlItem.ATO_LINE_ID;
2061 aPlsqlItem.ATO_LINE_INDEX := aSqlItem.ATO_LINE_INDEX;
2062 aPlsqlItem.COMPONENT_SEQUENCE_ID := aSqlItem.COMPONENT_SEQUENCE_ID;
2063 aPlsqlItem.ATTRIBUTE16 := aSqlItem.ATTRIBUTE16;
2064 aPlsqlItem.ATTRIBUTE17 := aSqlItem.ATTRIBUTE17;
2065 aPlsqlItem.ATTRIBUTE18 := aSqlItem.ATTRIBUTE18;
2066 aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
2067 aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
2068 RETURN aPlsqlItem;
2069 END SQL_TO_PL28;
2070 FUNCTION PL_TO_SQL2(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE)
2071 RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_TB IS
2072 aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB;
2073 BEGIN
2074 -- initialize the table
2075 aSqlItem := ASO_QUOTE_PUB_QTE_LINE_DTL_TB();
2076 IF aPlsqlItem.COUNT > 0 THEN
2077 aSqlItem.EXTEND(aPlsqlItem.COUNT);
2078 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2079 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL28(aPlsqlItem(I));
2080 END LOOP;
2081 END IF;
2082 RETURN aSqlItem;
2083 END PL_TO_SQL2;
2084 FUNCTION SQL_TO_PL11(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB)
2085 RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE IS
2086 aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2087 BEGIN
2088 begin
2089 FOR I IN 1..aSqlItem.COUNT LOOP
2090 aPlsqlItem(I) := SQL_TO_PL28(aSqlItem(I));
2091 END LOOP;
2092 exception
2093 when others then
2094 null;
2095 end;
2096 RETURN aPlsqlItem;
2097 END SQL_TO_PL11;
2098 FUNCTION PL_TO_SQL29(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE)
2099 RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_RE IS
2100 aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_RE;
2101 BEGIN
2102 -- initialize the object
2103 aSqlItem := ASO_QUOTE_PUB_LINE_RLTSHIP_RE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2104 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2105 aSqlItem.LINE_RELATIONSHIP_ID := aPlsqlItem.LINE_RELATIONSHIP_ID;
2106 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
2107 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
2108 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
2109 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
2113 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
2110 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
2111 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
2112 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
2114 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
2115 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
2116 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
2117 aSqlItem.RELATED_QUOTE_LINE_ID := aPlsqlItem.RELATED_QUOTE_LINE_ID;
2118 aSqlItem.RELATED_QTE_LINE_INDEX := aPlsqlItem.RELATED_QTE_LINE_INDEX;
2119 aSqlItem.RELATIONSHIP_TYPE_CODE := aPlsqlItem.RELATIONSHIP_TYPE_CODE;
2120 aSqlItem.RECIPROCAL_FLAG := aPlsqlItem.RECIPROCAL_FLAG;
2121 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2122 RETURN aSqlItem;
2123 END PL_TO_SQL29;
2124 FUNCTION SQL_TO_PL29(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_RE)
2125 RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE IS
2126 aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE;
2127 BEGIN
2128 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2129 aPlsqlItem.LINE_RELATIONSHIP_ID := aSqlItem.LINE_RELATIONSHIP_ID;
2130 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
2131 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
2132 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
2133 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
2134 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
2135 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
2136 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
2137 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
2138 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
2139 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
2140 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
2141 aPlsqlItem.RELATED_QUOTE_LINE_ID := aSqlItem.RELATED_QUOTE_LINE_ID;
2142 aPlsqlItem.RELATED_QTE_LINE_INDEX := aSqlItem.RELATED_QTE_LINE_INDEX;
2143 aPlsqlItem.RELATIONSHIP_TYPE_CODE := aSqlItem.RELATIONSHIP_TYPE_CODE;
2144 aPlsqlItem.RECIPROCAL_FLAG := aSqlItem.RECIPROCAL_FLAG;
2145 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2146 RETURN aPlsqlItem;
2147 END SQL_TO_PL29;
2148 FUNCTION PL_TO_SQL11(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE)
2149 RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_TB IS
2150 aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB;
2151 BEGIN
2155 aSqlItem.EXTEND(aPlsqlItem.COUNT);
2152 -- initialize the table
2153 aSqlItem := ASO_QUOTE_PUB_LINE_RLTSHIP_TB();
2154 IF aPlsqlItem.COUNT > 0 THEN
2156 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2157 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL29(aPlsqlItem(I));
2158 END LOOP;
2159 END IF;
2160 RETURN aSqlItem;
2161 END PL_TO_SQL11;
2162 FUNCTION SQL_TO_PL12(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB)
2163 RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE IS
2164 aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2165 BEGIN
2166 begin
2167 FOR I IN 1..aSqlItem.COUNT LOOP
2168 aPlsqlItem(I) := SQL_TO_PL29(aSqlItem(I));
2169 END LOOP;
2170 exception
2171 when others then
2172 null;
2173 end;
2174 RETURN aPlsqlItem;
2175 END SQL_TO_PL12;
2176 FUNCTION PL_TO_SQL30(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE)
2177 RETURN ASO_QUOTE_PUB_PRICE_ADJ_REC_T IS
2178 aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_REC_T;
2179 BEGIN
2180 -- initialize the object
2181 aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_REC_T(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2182 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2183 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2184 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2185 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2186 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
2187 aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
2188 aSqlItem.PRICE_ADJUSTMENT_ID := aPlsqlItem.PRICE_ADJUSTMENT_ID;
2189 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
2190 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
2191 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
2192 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
2193 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
2194 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
2195 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
2196 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
2197 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
2198 aSqlItem.QUOTE_HEADER_ID := aPlsqlItem.QUOTE_HEADER_ID;
2199 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
2200 aSqlItem.QUOTE_SHIPMENT_ID := aPlsqlItem.QUOTE_SHIPMENT_ID;
2201 aSqlItem.MODIFIER_HEADER_ID := aPlsqlItem.MODIFIER_HEADER_ID;
2202 aSqlItem.MODIFIER_LINE_ID := aPlsqlItem.MODIFIER_LINE_ID;
2203 aSqlItem.MODIFIER_LINE_TYPE_CODE := aPlsqlItem.MODIFIER_LINE_TYPE_CODE;
2204 aSqlItem.MODIFIER_MECHANISM_TYPE_CODE := aPlsqlItem.MODIFIER_MECHANISM_TYPE_CODE;
2205 aSqlItem.MODIFIED_FROM := aPlsqlItem.MODIFIED_FROM;
2206 aSqlItem.MODIFIED_TO := aPlsqlItem.MODIFIED_TO;
2207 aSqlItem.OPERAND := aPlsqlItem.OPERAND;
2208 aSqlItem.ARITHMETIC_OPERATOR := aPlsqlItem.ARITHMETIC_OPERATOR;
2209 aSqlItem.AUTOMATIC_FLAG := aPlsqlItem.AUTOMATIC_FLAG;
2210 aSqlItem.UPDATE_ALLOWABLE_FLAG := aPlsqlItem.UPDATE_ALLOWABLE_FLAG;
2211 aSqlItem.UPDATED_FLAG := aPlsqlItem.UPDATED_FLAG;
2212 aSqlItem.APPLIED_FLAG := aPlsqlItem.APPLIED_FLAG;
2213 aSqlItem.ON_INVOICE_FLAG := aPlsqlItem.ON_INVOICE_FLAG;
2217 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
2214 aSqlItem.PRICING_PHASE_ID := aPlsqlItem.PRICING_PHASE_ID;
2215 aSqlItem.ATTRIBUTE_CATEGORY := aPlsqlItem.ATTRIBUTE_CATEGORY;
2216 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
2218 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
2219 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
2220 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
2221 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
2222 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
2223 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
2224 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
2225 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
2226 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
2227 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
2228 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
2229 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
2230 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
2231 aSqlItem.ORIG_SYS_DISCOUNT_REF := aPlsqlItem.ORIG_SYS_DISCOUNT_REF;
2232 aSqlItem.CHANGE_SEQUENCE := aPlsqlItem.CHANGE_SEQUENCE;
2233 aSqlItem.UPDATE_ALLOWED := aPlsqlItem.UPDATE_ALLOWED;
2234 aSqlItem.CHANGE_REASON_CODE := aPlsqlItem.CHANGE_REASON_CODE;
2235 aSqlItem.CHANGE_REASON_TEXT := aPlsqlItem.CHANGE_REASON_TEXT;
2236 aSqlItem.COST_ID := aPlsqlItem.COST_ID;
2237 aSqlItem.TAX_CODE := aPlsqlItem.TAX_CODE;
2238 aSqlItem.TAX_EXEMPT_FLAG := aPlsqlItem.TAX_EXEMPT_FLAG;
2239 aSqlItem.TAX_EXEMPT_NUMBER := aPlsqlItem.TAX_EXEMPT_NUMBER;
2240 aSqlItem.TAX_EXEMPT_REASON_CODE := aPlsqlItem.TAX_EXEMPT_REASON_CODE;
2241 aSqlItem.PARENT_ADJUSTMENT_ID := aPlsqlItem.PARENT_ADJUSTMENT_ID;
2242 aSqlItem.INVOICED_FLAG := aPlsqlItem.INVOICED_FLAG;
2243 aSqlItem.ESTIMATED_FLAG := aPlsqlItem.ESTIMATED_FLAG;
2244 aSqlItem.INC_IN_SALES_PERFORMANCE := aPlsqlItem.INC_IN_SALES_PERFORMANCE;
2245 aSqlItem.SPLIT_ACTION_CODE := aPlsqlItem.SPLIT_ACTION_CODE;
2246 aSqlItem.ADJUSTED_AMOUNT := aPlsqlItem.ADJUSTED_AMOUNT;
2247 aSqlItem.CHARGE_TYPE_CODE := aPlsqlItem.CHARGE_TYPE_CODE;
2248 aSqlItem.CHARGE_SUBTYPE_CODE := aPlsqlItem.CHARGE_SUBTYPE_CODE;
2249 aSqlItem.RANGE_BREAK_QUANTITY := aPlsqlItem.RANGE_BREAK_QUANTITY;
2250 aSqlItem.ACCRUAL_CONVERSION_RATE := aPlsqlItem.ACCRUAL_CONVERSION_RATE;
2251 aSqlItem.PRICING_GROUP_SEQUENCE := aPlsqlItem.PRICING_GROUP_SEQUENCE;
2252 aSqlItem.ACCRUAL_FLAG := aPlsqlItem.ACCRUAL_FLAG;
2253 aSqlItem.LIST_LINE_NO := aPlsqlItem.LIST_LINE_NO;
2254 aSqlItem.SOURCE_SYSTEM_CODE := aPlsqlItem.SOURCE_SYSTEM_CODE;
2255 aSqlItem.BENEFIT_QTY := aPlsqlItem.BENEFIT_QTY;
2256 aSqlItem.BENEFIT_UOM_CODE := aPlsqlItem.BENEFIT_UOM_CODE;
2257 aSqlItem.PRINT_ON_INVOICE_FLAG := aPlsqlItem.PRINT_ON_INVOICE_FLAG;
2258 aSqlItem.EXPIRATION_DATE := aPlsqlItem.EXPIRATION_DATE;
2259 aSqlItem.REBATE_TRANSACTION_TYPE_CODE := aPlsqlItem.REBATE_TRANSACTION_TYPE_CODE;
2260 aSqlItem.REBATE_TRANSACTION_REFERENCE := aPlsqlItem.REBATE_TRANSACTION_REFERENCE;
2261 aSqlItem.REBATE_PAYMENT_SYSTEM_CODE := aPlsqlItem.REBATE_PAYMENT_SYSTEM_CODE;
2262 aSqlItem.REDEEMED_DATE := aPlsqlItem.REDEEMED_DATE;
2263 aSqlItem.REDEEMED_FLAG := aPlsqlItem.REDEEMED_FLAG;
2264 aSqlItem.MODIFIER_LEVEL_CODE := aPlsqlItem.MODIFIER_LEVEL_CODE;
2265 aSqlItem.PRICE_BREAK_TYPE_CODE := aPlsqlItem.PRICE_BREAK_TYPE_CODE;
2266 aSqlItem.SUBSTITUTION_ATTRIBUTE := aPlsqlItem.SUBSTITUTION_ATTRIBUTE;
2267 aSqlItem.PRORATION_TYPE_CODE := aPlsqlItem.PRORATION_TYPE_CODE;
2268 aSqlItem.INCLUDE_ON_RETURNS_FLAG := aPlsqlItem.INCLUDE_ON_RETURNS_FLAG;
2269 aSqlItem.CREDIT_OR_CHARGE_FLAG := aPlsqlItem.CREDIT_OR_CHARGE_FLAG;
2270 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2271 aSqlItem.ATTRIBUTE16 := aPlsqlItem.ATTRIBUTE16;
2272 aSqlItem.ATTRIBUTE17 := aPlsqlItem.ATTRIBUTE17;
2273 aSqlItem.ATTRIBUTE18 := aPlsqlItem.ATTRIBUTE18;
2274 aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
2275 aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
2276 aSqlItem.OPERAND_PER_PQTY := aPlsqlItem.OPERAND_PER_PQTY;
2277 aSqlItem.ADJUSTED_AMOUNT_PER_PQTY := aPlsqlItem.ADJUSTED_AMOUNT_PER_PQTY;
2278 RETURN aSqlItem;
2279 END PL_TO_SQL30;
2280 FUNCTION SQL_TO_PL30(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_REC_T)
2281 RETURN ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE IS
2282 aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE;
2283 BEGIN
2284 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2285 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
2286 aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
2287 aPlsqlItem.PRICE_ADJUSTMENT_ID := aSqlItem.PRICE_ADJUSTMENT_ID;
2288 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
2289 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
2290 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
2291 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
2292 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
2293 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
2294 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
2295 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
2296 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
2297 aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
2298 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
2299 aPlsqlItem.QUOTE_SHIPMENT_ID := aSqlItem.QUOTE_SHIPMENT_ID;
2300 aPlsqlItem.MODIFIER_HEADER_ID := aSqlItem.MODIFIER_HEADER_ID;
2301 aPlsqlItem.MODIFIER_LINE_ID := aSqlItem.MODIFIER_LINE_ID;
2302 aPlsqlItem.MODIFIER_LINE_TYPE_CODE := aSqlItem.MODIFIER_LINE_TYPE_CODE;
2303 aPlsqlItem.MODIFIER_MECHANISM_TYPE_CODE := aSqlItem.MODIFIER_MECHANISM_TYPE_CODE;
2304 aPlsqlItem.MODIFIED_FROM := aSqlItem.MODIFIED_FROM;
2305 aPlsqlItem.MODIFIED_TO := aSqlItem.MODIFIED_TO;
2306 aPlsqlItem.OPERAND := aSqlItem.OPERAND;
2307 aPlsqlItem.ARITHMETIC_OPERATOR := aSqlItem.ARITHMETIC_OPERATOR;
2308 aPlsqlItem.AUTOMATIC_FLAG := aSqlItem.AUTOMATIC_FLAG;
2309 aPlsqlItem.UPDATE_ALLOWABLE_FLAG := aSqlItem.UPDATE_ALLOWABLE_FLAG;
2310 aPlsqlItem.UPDATED_FLAG := aSqlItem.UPDATED_FLAG;
2311 aPlsqlItem.APPLIED_FLAG := aSqlItem.APPLIED_FLAG;
2312 aPlsqlItem.ON_INVOICE_FLAG := aSqlItem.ON_INVOICE_FLAG;
2316 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
2313 aPlsqlItem.PRICING_PHASE_ID := aSqlItem.PRICING_PHASE_ID;
2314 aPlsqlItem.ATTRIBUTE_CATEGORY := aSqlItem.ATTRIBUTE_CATEGORY;
2315 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
2317 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
2318 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
2319 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
2320 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
2321 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
2322 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
2323 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
2324 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
2325 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
2326 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
2327 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
2328 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
2329 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
2330 aPlsqlItem.ORIG_SYS_DISCOUNT_REF := aSqlItem.ORIG_SYS_DISCOUNT_REF;
2331 aPlsqlItem.CHANGE_SEQUENCE := aSqlItem.CHANGE_SEQUENCE;
2332 aPlsqlItem.UPDATE_ALLOWED := aSqlItem.UPDATE_ALLOWED;
2333 aPlsqlItem.CHANGE_REASON_CODE := aSqlItem.CHANGE_REASON_CODE;
2334 aPlsqlItem.CHANGE_REASON_TEXT := aSqlItem.CHANGE_REASON_TEXT;
2335 aPlsqlItem.COST_ID := aSqlItem.COST_ID;
2336 aPlsqlItem.TAX_CODE := aSqlItem.TAX_CODE;
2337 aPlsqlItem.TAX_EXEMPT_FLAG := aSqlItem.TAX_EXEMPT_FLAG;
2338 aPlsqlItem.TAX_EXEMPT_NUMBER := aSqlItem.TAX_EXEMPT_NUMBER;
2339 aPlsqlItem.TAX_EXEMPT_REASON_CODE := aSqlItem.TAX_EXEMPT_REASON_CODE;
2340 aPlsqlItem.PARENT_ADJUSTMENT_ID := aSqlItem.PARENT_ADJUSTMENT_ID;
2341 aPlsqlItem.INVOICED_FLAG := aSqlItem.INVOICED_FLAG;
2342 aPlsqlItem.ESTIMATED_FLAG := aSqlItem.ESTIMATED_FLAG;
2343 aPlsqlItem.INC_IN_SALES_PERFORMANCE := aSqlItem.INC_IN_SALES_PERFORMANCE;
2344 aPlsqlItem.SPLIT_ACTION_CODE := aSqlItem.SPLIT_ACTION_CODE;
2345 aPlsqlItem.ADJUSTED_AMOUNT := aSqlItem.ADJUSTED_AMOUNT;
2346 aPlsqlItem.CHARGE_TYPE_CODE := aSqlItem.CHARGE_TYPE_CODE;
2347 aPlsqlItem.CHARGE_SUBTYPE_CODE := aSqlItem.CHARGE_SUBTYPE_CODE;
2348 aPlsqlItem.RANGE_BREAK_QUANTITY := aSqlItem.RANGE_BREAK_QUANTITY;
2349 aPlsqlItem.ACCRUAL_CONVERSION_RATE := aSqlItem.ACCRUAL_CONVERSION_RATE;
2350 aPlsqlItem.PRICING_GROUP_SEQUENCE := aSqlItem.PRICING_GROUP_SEQUENCE;
2351 aPlsqlItem.ACCRUAL_FLAG := aSqlItem.ACCRUAL_FLAG;
2352 aPlsqlItem.LIST_LINE_NO := aSqlItem.LIST_LINE_NO;
2353 aPlsqlItem.SOURCE_SYSTEM_CODE := aSqlItem.SOURCE_SYSTEM_CODE;
2354 aPlsqlItem.BENEFIT_QTY := aSqlItem.BENEFIT_QTY;
2355 aPlsqlItem.BENEFIT_UOM_CODE := aSqlItem.BENEFIT_UOM_CODE;
2356 aPlsqlItem.PRINT_ON_INVOICE_FLAG := aSqlItem.PRINT_ON_INVOICE_FLAG;
2357 aPlsqlItem.EXPIRATION_DATE := aSqlItem.EXPIRATION_DATE;
2358 aPlsqlItem.REBATE_TRANSACTION_TYPE_CODE := aSqlItem.REBATE_TRANSACTION_TYPE_CODE;
2359 aPlsqlItem.REBATE_TRANSACTION_REFERENCE := aSqlItem.REBATE_TRANSACTION_REFERENCE;
2360 aPlsqlItem.REBATE_PAYMENT_SYSTEM_CODE := aSqlItem.REBATE_PAYMENT_SYSTEM_CODE;
2361 aPlsqlItem.REDEEMED_DATE := aSqlItem.REDEEMED_DATE;
2362 aPlsqlItem.REDEEMED_FLAG := aSqlItem.REDEEMED_FLAG;
2363 aPlsqlItem.MODIFIER_LEVEL_CODE := aSqlItem.MODIFIER_LEVEL_CODE;
2364 aPlsqlItem.PRICE_BREAK_TYPE_CODE := aSqlItem.PRICE_BREAK_TYPE_CODE;
2365 aPlsqlItem.SUBSTITUTION_ATTRIBUTE := aSqlItem.SUBSTITUTION_ATTRIBUTE;
2366 aPlsqlItem.PRORATION_TYPE_CODE := aSqlItem.PRORATION_TYPE_CODE;
2367 aPlsqlItem.INCLUDE_ON_RETURNS_FLAG := aSqlItem.INCLUDE_ON_RETURNS_FLAG;
2368 aPlsqlItem.CREDIT_OR_CHARGE_FLAG := aSqlItem.CREDIT_OR_CHARGE_FLAG;
2369 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2370 aPlsqlItem.ATTRIBUTE16 := aSqlItem.ATTRIBUTE16;
2371 aPlsqlItem.ATTRIBUTE17 := aSqlItem.ATTRIBUTE17;
2372 aPlsqlItem.ATTRIBUTE18 := aSqlItem.ATTRIBUTE18;
2373 aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
2374 aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
2375 aPlsqlItem.OPERAND_PER_PQTY := aSqlItem.OPERAND_PER_PQTY;
2376 aPlsqlItem.ADJUSTED_AMOUNT_PER_PQTY := aSqlItem.ADJUSTED_AMOUNT_PER_PQTY;
2377 RETURN aPlsqlItem;
2378 END SQL_TO_PL30;
2379 FUNCTION PL_TO_SQL12(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE)
2380 RETURN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T IS
2381 aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_TBL_T;
2382 BEGIN
2383 -- initialize the table
2384 aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_TBL_T();
2385 IF aPlsqlItem.COUNT > 0 THEN
2386 aSqlItem.EXTEND(aPlsqlItem.COUNT);
2387 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2388 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL30(aPlsqlItem(I));
2389 END LOOP;
2390 END IF;
2391 RETURN aSqlItem;
2392 END PL_TO_SQL12;
2393 FUNCTION SQL_TO_PL13(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_TBL_T)
2394 RETURN ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE IS
2395 aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2396 BEGIN
2397 begin
2398 FOR I IN 1..aSqlItem.COUNT LOOP
2399 aPlsqlItem(I) := SQL_TO_PL30(aSqlItem(I));
2400 END LOOP;
2401 exception
2402 when others then
2403 null;
2404 end;
2405 RETURN aPlsqlItem;
2406 END SQL_TO_PL13;
2407 FUNCTION PL_TO_SQL31(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE)
2408 RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATT37 IS
2409 aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37;
2410 BEGIN
2411 -- initialize the object
2412 aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_ATT37(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2413 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2414 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
2415 aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
2416 aSqlItem.PRICE_ADJ_INDEX := aPlsqlItem.PRICE_ADJ_INDEX;
2417 aSqlItem.PRICE_ADJ_ATTRIB_ID := aPlsqlItem.PRICE_ADJ_ATTRIB_ID;
2418 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
2419 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
2420 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
2421 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
2422 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
2423 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
2424 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
2425 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
2426 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
2427 aSqlItem.PRICE_ADJUSTMENT_ID := aPlsqlItem.PRICE_ADJUSTMENT_ID;
2428 aSqlItem.PRICING_CONTEXT := aPlsqlItem.PRICING_CONTEXT;
2429 aSqlItem.PRICING_ATTRIBUTE := aPlsqlItem.PRICING_ATTRIBUTE;
2430 aSqlItem.PRICING_ATTR_VALUE_FROM := aPlsqlItem.PRICING_ATTR_VALUE_FROM;
2431 aSqlItem.PRICING_ATTR_VALUE_TO := aPlsqlItem.PRICING_ATTR_VALUE_TO;
2432 aSqlItem.COMPARISON_OPERATOR := aPlsqlItem.COMPARISON_OPERATOR;
2433 aSqlItem.FLEX_TITLE := aPlsqlItem.FLEX_TITLE;
2434 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2435 RETURN aSqlItem;
2436 END PL_TO_SQL31;
2437 FUNCTION SQL_TO_PL31(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37)
2438 RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE IS
2439 aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE;
2440 BEGIN
2441 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2442 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
2443 aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
2444 aPlsqlItem.PRICE_ADJ_INDEX := aSqlItem.PRICE_ADJ_INDEX;
2445 aPlsqlItem.PRICE_ADJ_ATTRIB_ID := aSqlItem.PRICE_ADJ_ATTRIB_ID;
2446 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
2447 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
2448 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
2449 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
2450 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
2451 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
2452 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
2453 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
2454 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
2455 aPlsqlItem.PRICE_ADJUSTMENT_ID := aSqlItem.PRICE_ADJUSTMENT_ID;
2456 aPlsqlItem.PRICING_CONTEXT := aSqlItem.PRICING_CONTEXT;
2457 aPlsqlItem.PRICING_ATTRIBUTE := aSqlItem.PRICING_ATTRIBUTE;
2458 aPlsqlItem.PRICING_ATTR_VALUE_FROM := aSqlItem.PRICING_ATTR_VALUE_FROM;
2459 aPlsqlItem.PRICING_ATTR_VALUE_TO := aSqlItem.PRICING_ATTR_VALUE_TO;
2460 aPlsqlItem.COMPARISON_OPERATOR := aSqlItem.COMPARISON_OPERATOR;
2461 aPlsqlItem.FLEX_TITLE := aSqlItem.FLEX_TITLE;
2462 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2463 RETURN aPlsqlItem;
2464 END SQL_TO_PL31;
2465 FUNCTION PL_TO_SQL13(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE)
2466 RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_ IS
2467 aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_;
2468 BEGIN
2469 -- initialize the table
2470 aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_ATTR_();
2471 IF aPlsqlItem.COUNT > 0 THEN
2472 aSqlItem.EXTEND(aPlsqlItem.COUNT);
2473 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2474 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL31(aPlsqlItem(I));
2475 END LOOP;
2476 END IF;
2477 RETURN aSqlItem;
2478 END PL_TO_SQL13;
2479 FUNCTION SQL_TO_PL14(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_)
2480 RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE IS
2481 aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2482 BEGIN
2483 BEGIN
2484 FOR I IN 1..aSqlItem.COUNT LOOP
2485 aPlsqlItem(I) := SQL_TO_PL31(aSqlItem(I));
2486 END LOOP;
2487 exception
2488 when others then
2489 null;
2490 end;
2491 RETURN aPlsqlItem;
2492 END SQL_TO_PL14;
2493 FUNCTION PL_TO_SQL32(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE)
2494 RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLT38 IS
2495 aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38;
2496 BEGIN
2497 -- initialize the object
2498 aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_RLT38(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2499 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2500 aSqlItem.ADJ_RELATIONSHIP_ID := aPlsqlItem.ADJ_RELATIONSHIP_ID;
2501 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
2502 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
2503 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
2504 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
2505 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
2506 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
2507 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
2508 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
2509 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
2510 aSqlItem.QUOTE_LINE_ID := aPlsqlItem.QUOTE_LINE_ID;
2511 aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
2512 aSqlItem.QUOTE_SHIPMENT_ID := aPlsqlItem.QUOTE_SHIPMENT_ID;
2513 aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
2514 aSqlItem.PRICE_ADJUSTMENT_ID := aPlsqlItem.PRICE_ADJUSTMENT_ID;
2515 aSqlItem.PRICE_ADJ_INDEX := aPlsqlItem.PRICE_ADJ_INDEX;
2516 aSqlItem.RLTD_PRICE_ADJ_ID := aPlsqlItem.RLTD_PRICE_ADJ_ID;
2517 aSqlItem.RLTD_PRICE_ADJ_INDEX := aPlsqlItem.RLTD_PRICE_ADJ_INDEX;
2518 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2519 RETURN aSqlItem;
2520 END PL_TO_SQL32;
2521 FUNCTION SQL_TO_PL32(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38)
2522 RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE IS
2523 aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE;
2524 BEGIN
2525 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2526 aPlsqlItem.ADJ_RELATIONSHIP_ID := aSqlItem.ADJ_RELATIONSHIP_ID;
2527 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
2528 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
2529 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
2530 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
2531 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
2532 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
2533 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
2534 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
2535 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
2536 aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
2537 aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
2538 aPlsqlItem.QUOTE_SHIPMENT_ID := aSqlItem.QUOTE_SHIPMENT_ID;
2539 aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
2540 aPlsqlItem.PRICE_ADJUSTMENT_ID := aSqlItem.PRICE_ADJUSTMENT_ID;
2541 aPlsqlItem.PRICE_ADJ_INDEX := aSqlItem.PRICE_ADJ_INDEX;
2542 aPlsqlItem.RLTD_PRICE_ADJ_ID := aSqlItem.RLTD_PRICE_ADJ_ID;
2543 aPlsqlItem.RLTD_PRICE_ADJ_INDEX := aSqlItem.RLTD_PRICE_ADJ_INDEX;
2544 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2545 RETURN aPlsqlItem;
2546 END SQL_TO_PL32;
2547 FUNCTION PL_TO_SQL14(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE)
2548 RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH IS
2549 aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH;
2550 BEGIN
2551 -- initialize the table
2552 aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_RLTSH();
2553 IF aPlsqlItem.COUNT > 0 THEN
2554 aSqlItem.EXTEND(aPlsqlItem.COUNT);
2555 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2556 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL32(aPlsqlItem(I));
2557 END LOOP;
2558 END IF ;
2559 RETURN aSqlItem;
2560 END PL_TO_SQL14;
2561 FUNCTION SQL_TO_PL15(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH)
2562 RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE IS
2563 aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2564 BEGIN
2565 begin
2566 FOR I IN 1..aSqlItem.COUNT LOOP
2567 aPlsqlItem(I) := SQL_TO_PL32(aSqlItem(I));
2568 END LOOP;
2569 exception
2570 when others then
2571 null;
2572 end;
2573 RETURN aPlsqlItem;
2574 END SQL_TO_PL15;
2575 FUNCTION PL_TO_SQL15(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE)
2576 RETURN ASO_QUOTE_PUB_SHIPMENT_TBL_TY IS
2577 aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY;
2578 BEGIN
2579 -- initialize the table
2580 aSqlItem := ASO_QUOTE_PUB_SHIPMENT_TBL_TY();
2581 IF aPlsqlItem.COUNT > 0 THEN
2582 aSqlItem.EXTEND(aPlsqlItem.COUNT);
2583 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2584 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL5(aPlsqlItem(I));
2585 END LOOP;
2586 END IF;
2587 RETURN aSqlItem;
2588 END PL_TO_SQL15;
2589 FUNCTION SQL_TO_PL16(aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY)
2590 RETURN ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE IS
2591 aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2592 BEGIN
2593 begin
2594 FOR I IN 1..aSqlItem.COUNT LOOP
2595 aPlsqlItem(I) := SQL_TO_PL4(aSqlItem(I));
2596 END LOOP;
2597 exception
2598 when others then
2599 null;
2600 end;
2601 RETURN aPlsqlItem;
2602 END SQL_TO_PL16;
2603 FUNCTION PL_TO_SQL33(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE)
2604 RETURN ASO_QUOTE_PUB_QTE_ACCESS_REC_ IS
2605 aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_REC_;
2606 BEGIN
2607 -- initialize the object
2608 aSqlItem := ASO_QUOTE_PUB_QTE_ACCESS_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2609 NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2610 aSqlItem.ACCESS_ID := aPlsqlItem.ACCESS_ID;
2611 aSqlItem.QUOTE_NUMBER := aPlsqlItem.QUOTE_NUMBER;
2612 aSqlItem.RESOURCE_ID := aPlsqlItem.RESOURCE_ID;
2613 aSqlItem.RESOURCE_GRP_ID := aPlsqlItem.RESOURCE_GRP_ID;
2614 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
2615 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
2616 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
2617 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
2618 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
2619 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
2620 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
2621 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
2622 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
2623 aSqlItem.KEEP_FLAG := aPlsqlItem.KEEP_FLAG;
2624 aSqlItem.UPDATE_ACCESS_FLAG := aPlsqlItem.UPDATE_ACCESS_FLAG;
2625 aSqlItem.CREATED_BY_TAP_FLAG := aPlsqlItem.CREATED_BY_TAP_FLAG;
2626 aSqlItem.TERRITORY_ID := aPlsqlItem.TERRITORY_ID;
2627 aSqlItem.TERRITORY_SOURCE_FLAG := aPlsqlItem.TERRITORY_SOURCE_FLAG;
2628 aSqlItem.ROLE_ID := aPlsqlItem.ROLE_ID;
2629 aSqlItem.ATTRIBUTE_CATEGORY := aPlsqlItem.ATTRIBUTE_CATEGORY;
2630 aSqlItem.ATTRIBUTE1 := aPlsqlItem.ATTRIBUTE1;
2631 aSqlItem.ATTRIBUTE2 := aPlsqlItem.ATTRIBUTE2;
2632 aSqlItem.ATTRIBUTE3 := aPlsqlItem.ATTRIBUTE3;
2633 aSqlItem.ATTRIBUTE4 := aPlsqlItem.ATTRIBUTE4;
2634 aSqlItem.ATTRIBUTE5 := aPlsqlItem.ATTRIBUTE5;
2635 aSqlItem.ATTRIBUTE6 := aPlsqlItem.ATTRIBUTE6;
2636 aSqlItem.ATTRIBUTE7 := aPlsqlItem.ATTRIBUTE7;
2637 aSqlItem.ATTRIBUTE8 := aPlsqlItem.ATTRIBUTE8;
2638 aSqlItem.ATTRIBUTE9 := aPlsqlItem.ATTRIBUTE9;
2639 aSqlItem.ATTRIBUTE10 := aPlsqlItem.ATTRIBUTE10;
2640 aSqlItem.ATTRIBUTE11 := aPlsqlItem.ATTRIBUTE11;
2641 aSqlItem.ATTRIBUTE12 := aPlsqlItem.ATTRIBUTE12;
2642 aSqlItem.ATTRIBUTE13 := aPlsqlItem.ATTRIBUTE13;
2643 aSqlItem.ATTRIBUTE14 := aPlsqlItem.ATTRIBUTE14;
2644 aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
2645 aSqlItem.BATCH_PRICE_FLAG := aPlsqlItem.BATCH_PRICE_FLAG;
2646 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2647 aSqlItem.ATTRIBUTE16 := aPlsqlItem.ATTRIBUTE16;
2648 aSqlItem.ATTRIBUTE17 := aPlsqlItem.ATTRIBUTE17;
2649 aSqlItem.ATTRIBUTE18 := aPlsqlItem.ATTRIBUTE18;
2650 aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
2651 aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
2652 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2653 RETURN aSqlItem;
2654 END PL_TO_SQL33;
2655 FUNCTION SQL_TO_PL33(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_REC_)
2656 RETURN ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE IS
2657 aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE;
2658 BEGIN
2659 aPlsqlItem.ACCESS_ID := aSqlItem.ACCESS_ID;
2660 aPlsqlItem.QUOTE_NUMBER := aSqlItem.QUOTE_NUMBER;
2661 aPlsqlItem.RESOURCE_ID := aSqlItem.RESOURCE_ID;
2662 aPlsqlItem.RESOURCE_GRP_ID := aSqlItem.RESOURCE_GRP_ID;
2663 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
2664 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
2665 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
2666 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
2667 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
2668 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
2669 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
2670 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
2671 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
2672 aPlsqlItem.KEEP_FLAG := aSqlItem.KEEP_FLAG;
2673 aPlsqlItem.UPDATE_ACCESS_FLAG := aSqlItem.UPDATE_ACCESS_FLAG;
2674 aPlsqlItem.CREATED_BY_TAP_FLAG := aSqlItem.CREATED_BY_TAP_FLAG;
2675 aPlsqlItem.TERRITORY_ID := aSqlItem.TERRITORY_ID;
2676 aPlsqlItem.TERRITORY_SOURCE_FLAG := aSqlItem.TERRITORY_SOURCE_FLAG;
2677 aPlsqlItem.ROLE_ID := aSqlItem.ROLE_ID;
2678 aPlsqlItem.ATTRIBUTE_CATEGORY := aSqlItem.ATTRIBUTE_CATEGORY;
2679 aPlsqlItem.ATTRIBUTE1 := aSqlItem.ATTRIBUTE1;
2680 aPlsqlItem.ATTRIBUTE2 := aSqlItem.ATTRIBUTE2;
2681 aPlsqlItem.ATTRIBUTE3 := aSqlItem.ATTRIBUTE3;
2682 aPlsqlItem.ATTRIBUTE4 := aSqlItem.ATTRIBUTE4;
2683 aPlsqlItem.ATTRIBUTE5 := aSqlItem.ATTRIBUTE5;
2684 aPlsqlItem.ATTRIBUTE6 := aSqlItem.ATTRIBUTE6;
2685 aPlsqlItem.ATTRIBUTE7 := aSqlItem.ATTRIBUTE7;
2686 aPlsqlItem.ATTRIBUTE8 := aSqlItem.ATTRIBUTE8;
2687 aPlsqlItem.ATTRIBUTE9 := aSqlItem.ATTRIBUTE9;
2688 aPlsqlItem.ATTRIBUTE10 := aSqlItem.ATTRIBUTE10;
2689 aPlsqlItem.ATTRIBUTE11 := aSqlItem.ATTRIBUTE11;
2690 aPlsqlItem.ATTRIBUTE12 := aSqlItem.ATTRIBUTE12;
2691 aPlsqlItem.ATTRIBUTE13 := aSqlItem.ATTRIBUTE13;
2692 aPlsqlItem.ATTRIBUTE14 := aSqlItem.ATTRIBUTE14;
2693 aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
2694 aPlsqlItem.BATCH_PRICE_FLAG := aSqlItem.BATCH_PRICE_FLAG;
2695 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2696 aPlsqlItem.ATTRIBUTE16 := aSqlItem.ATTRIBUTE16;
2697 aPlsqlItem.ATTRIBUTE17 := aSqlItem.ATTRIBUTE17;
2698 aPlsqlItem.ATTRIBUTE18 := aSqlItem.ATTRIBUTE18;
2699 aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
2700 aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
2701 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2702 RETURN aPlsqlItem;
2703 END SQL_TO_PL33;
2704 FUNCTION PL_TO_SQL16(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE)
2705 RETURN ASO_QUOTE_PUB_QTE_ACCESS_TBL_ IS
2706 aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_;
2707 BEGIN
2708 -- initialize the table
2709 aSqlItem := ASO_QUOTE_PUB_QTE_ACCESS_TBL_();
2710 IF aPlsqlItem.COUNT > 0 THEN
2711 aSqlItem.EXTEND(aPlsqlItem.COUNT);
2712 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2713 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL33(aPlsqlItem(I));
2714 END LOOP;
2715 END IF;
2716 RETURN aSqlItem;
2717 END PL_TO_SQL16;
2718 FUNCTION SQL_TO_PL17(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_)
2719 RETURN ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE IS
2720 aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2721 BEGIN
2722 BEGIN
2723 FOR I IN 1..aSqlItem.COUNT LOOP
2724 aPlsqlItem(I) := SQL_TO_PL33(aSqlItem(I));
2725 END LOOP;
2726 EXCEPTION
2727 WHEN OTHERS THEN
2728 NULL;
2729 END;
2730 RETURN aPlsqlItem;
2731 END SQL_TO_PL17;
2732 FUNCTION PL_TO_SQL34(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_REC_TYPE)
2733 RETURN ASO_QUOTE_PUB_TEMPLATE_REC_TY IS
2734 aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY;
2735 BEGIN
2736 -- initialize the object
2737 aSqlItem := ASO_QUOTE_PUB_TEMPLATE_REC_TY(NULL);
2738 aSqlItem.TEMPLATE_ID := aPlsqlItem.TEMPLATE_ID;
2739 RETURN aSqlItem;
2740 END PL_TO_SQL34;
2741 FUNCTION SQL_TO_PL34(aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY)
2742 RETURN ASO_QUOTE_PUB.TEMPLATE_REC_TYPE IS
2743 aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_REC_TYPE;
2744 BEGIN
2745 aPlsqlItem.TEMPLATE_ID := aSqlItem.TEMPLATE_ID;
2746 RETURN aPlsqlItem;
2747 END SQL_TO_PL34;
2748 FUNCTION PL_TO_SQL17(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE)
2749 RETURN ASO_QUOTE_PUB_TEMPLATE_TBL_TY IS
2750 aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY;
2751 BEGIN
2752 -- initialize the table
2753 aSqlItem := ASO_QUOTE_PUB_TEMPLATE_TBL_TY();
2754 IF aPlsqlItem.COUNT > 0 THEN
2755 aSqlItem.EXTEND(aPlsqlItem.COUNT);
2756 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2757 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL34(aPlsqlItem(I));
2758 END LOOP;
2759 END IF;
2760 RETURN aSqlItem;
2761 END PL_TO_SQL17;
2762 FUNCTION SQL_TO_PL18(aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY)
2763 RETURN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE IS
2764 aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2765 BEGIN
2766 BEGIN
2767 FOR I IN 1..aSqlItem.COUNT LOOP
2768 aPlsqlItem(I) := SQL_TO_PL34(aSqlItem(I));
2769 END LOOP;
2770 EXCEPTION
2771 WHEN OTHERS THEN
2772 NULL;
2773 END;
2774 RETURN aPlsqlItem;
2775 END SQL_TO_PL18;
2776 FUNCTION PL_TO_SQL35(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE)
2777 RETURN ASO_QUOTE_PUB_RELATED_OBJ_REC IS
2778 aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC;
2779 BEGIN
2780 -- initialize the object
2781 aSqlItem := ASO_QUOTE_PUB_RELATED_OBJ_REC(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2782 aSqlItem.RELATED_OBJECT_ID := aPlsqlItem.RELATED_OBJECT_ID;
2783 aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
2784 aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
2785 aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
2786 aSqlItem.LAST_UPDATED_BY := aPlsqlItem.LAST_UPDATED_BY;
2787 aSqlItem.LAST_UPDATE_LOGIN := aPlsqlItem.LAST_UPDATE_LOGIN;
2788 aSqlItem.REQUEST_ID := aPlsqlItem.REQUEST_ID;
2789 aSqlItem.PROGRAM_APPLICATION_ID := aPlsqlItem.PROGRAM_APPLICATION_ID;
2790 aSqlItem.PROGRAM_ID := aPlsqlItem.PROGRAM_ID;
2791 aSqlItem.PROGRAM_UPDATE_DATE := aPlsqlItem.PROGRAM_UPDATE_DATE;
2792 aSqlItem.QUOTE_OBJECT_TYPE_CODE := aPlsqlItem.QUOTE_OBJECT_TYPE_CODE;
2793 aSqlItem.QUOTE_OBJECT_ID := aPlsqlItem.QUOTE_OBJECT_ID;
2794 aSqlItem.OBJECT_TYPE_CODE := aPlsqlItem.OBJECT_TYPE_CODE;
2795 aSqlItem.OBJECT_ID := aPlsqlItem.OBJECT_ID;
2796 aSqlItem.RELATIONSHIP_TYPE_CODE := aPlsqlItem.RELATIONSHIP_TYPE_CODE;
2797 aSqlItem.RECIPROCAL_FLAG := aPlsqlItem.RECIPROCAL_FLAG;
2798 aSqlItem.QUOTE_OBJECT_CODE := aPlsqlItem.QUOTE_OBJECT_CODE;
2799 aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2800 aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2801 RETURN aSqlItem;
2802 END PL_TO_SQL35;
2803 FUNCTION SQL_TO_PL35(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC)
2804 RETURN ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE IS
2805 aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
2806 BEGIN
2807 aPlsqlItem.RELATED_OBJECT_ID := aSqlItem.RELATED_OBJECT_ID;
2808 aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
2809 aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
2810 aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
2811 aPlsqlItem.LAST_UPDATED_BY := aSqlItem.LAST_UPDATED_BY;
2812 aPlsqlItem.LAST_UPDATE_LOGIN := aSqlItem.LAST_UPDATE_LOGIN;
2813 aPlsqlItem.REQUEST_ID := aSqlItem.REQUEST_ID;
2814 aPlsqlItem.PROGRAM_APPLICATION_ID := aSqlItem.PROGRAM_APPLICATION_ID;
2815 aPlsqlItem.PROGRAM_ID := aSqlItem.PROGRAM_ID;
2816 aPlsqlItem.PROGRAM_UPDATE_DATE := aSqlItem.PROGRAM_UPDATE_DATE;
2817 aPlsqlItem.QUOTE_OBJECT_TYPE_CODE := aSqlItem.QUOTE_OBJECT_TYPE_CODE;
2818 aPlsqlItem.QUOTE_OBJECT_ID := aSqlItem.QUOTE_OBJECT_ID;
2819 aPlsqlItem.OBJECT_TYPE_CODE := aSqlItem.OBJECT_TYPE_CODE;
2820 aPlsqlItem.OBJECT_ID := aSqlItem.OBJECT_ID;
2821 aPlsqlItem.RELATIONSHIP_TYPE_CODE := aSqlItem.RELATIONSHIP_TYPE_CODE;
2822 aPlsqlItem.RECIPROCAL_FLAG := aSqlItem.RECIPROCAL_FLAG;
2823 aPlsqlItem.QUOTE_OBJECT_CODE := aSqlItem.QUOTE_OBJECT_CODE;
2824 aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2825 aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2826 RETURN aPlsqlItem;
2830 aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL;
2827 END SQL_TO_PL35;
2828 FUNCTION PL_TO_SQL18(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE)
2829 RETURN ASO_QUOTE_PUB_RELATED_OBJ_TBL IS
2831 BEGIN
2832 -- initialize the table
2833 aSqlItem := ASO_QUOTE_PUB_RELATED_OBJ_TBL();
2834 IF aPlsqlItem.COUNT > 0 THEN
2835 aSqlItem.EXTEND(aPlsqlItem.COUNT);
2836 FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2837 aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL35(aPlsqlItem(I));
2838 END LOOP;
2839 END IF;
2840 RETURN aSqlItem;
2841 END PL_TO_SQL18;
2842 FUNCTION SQL_TO_PL19(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL)
2843 RETURN ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE IS
2844 aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2845 BEGIN
2846 BEGIN
2847 FOR I IN 1..aSqlItem.COUNT LOOP
2848 aPlsqlItem(I) := SQL_TO_PL35(aSqlItem(I));
2849 END LOOP;
2850 EXCEPTION
2851 WHEN OTHERS THEN
2852 NULL;
2853 END;
2854 RETURN aPlsqlItem;
2855 END SQL_TO_PL19;
2856
2857 PROCEDURE CREATE_QUOTE_SERVICE (
2858 P_API_VERSION_NUMBER IN NUMBER,
2859 P_INIT_MSG_LIST IN VARCHAR2,
2860 P_COMMIT IN VARCHAR2,
2861 P_VALIDATION_LEVEL IN NUMBER,
2862 P_CONTROL_REC IN ASO_QUOTE_PUB_CONTROL_REC_TYP,
2863 P_QTE_HEADER_REC IN ASO_QUOTE_PUB_QTE_HEADER_REC_,
2864 P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2865 P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2866 P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2867 P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2868 P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2869 P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2870 P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2871 P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2872 P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2873 P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2874 P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2875 P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2876 P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2877 P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2878 P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2879 P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2880 P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2881 P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2882 P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2883 P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2884 P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2885 P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2886 P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2887 P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2888 P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2889 X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
2890 X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2891 X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2892 X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2893 X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2894 X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2895 X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2896 X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2897 X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2898 X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2899 X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2900 X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2901 X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2902 X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2903 X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2904 X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2905 X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2906 X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2907 X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2908 X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2909 X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2910 X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2911 X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2912 X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2913 X_TEMPLATE_TBL OUT NOCOPY ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2914 X_RELATED_OBJ_TBL OUT NOCOPY ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2915 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2916 X_MSG_COUNT OUT NOCOPY NUMBER,
2917 X_MSG_DATA OUT NOCOPY VARCHAR2
2918 )
2919
2920 IS
2921 P_CONTROL_REC_ APPS.ASO_QUOTE_PUB.CONTROL_REC_TYPE;
2922
2923 P_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2924 P_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2925 P_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2926 P_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2927 P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2928 P_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2929 P_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2930 P_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2931 P_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2932 P_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2933 P_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2934 P_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2935 P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2936 P_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2937 P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2938 P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2939 P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2940 P_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2941 P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2942 P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2943 P_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2944 P_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2945 P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2946 P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2947 P_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2948 P_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2949 X_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2950 X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2951 X_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2952 X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2953 X_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2954 X_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2955 X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2956 X_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2957 X_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2958 X_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2959 X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2960 X_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2961 X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2962 X_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2963 X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2964 X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2965 X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2966 X_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2967 X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2968 X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2969 X_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2970 X_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2971 X_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2972 X_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2973 X_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2974 X_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2975 x_msg_data_temp VARCHAR2(2000);
2976 lx_msg_index_out NUMBER;
2977 BEGIN
2978 P_CONTROL_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL0(P_CONTROL_REC);
2979 P_QTE_HEADER_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL1(P_QTE_HEADER_REC);
2980 P_HD_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_HD_PRICE_ATTRIBUTES_TBL);
2981 P_HD_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_HD_PAYMENT_TBL);
2982 P_HD_SHIPMENT_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL4(P_HD_SHIPMENT_REC);
2983 P_HD_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_HD_FREIGHT_CHARGE_TBL);
2984 P_HD_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_HD_TAX_DETAIL_TBL);
2985 P_HD_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_HD_ATTR_EXT_TBL);
2986 P_HD_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_HD_SALES_CREDIT_TBL);
2987 P_HD_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_HD_QUOTE_PARTY_TBL);
2988 P_QTE_LINE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL10(P_QTE_LINE_TBL);
2989 P_QTE_LINE_DTL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL11(P_QTE_LINE_DTL_TBL);
2990 P_LINE_ATTR_EXT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL7(P_LINE_ATTR_EXT_TBL);
2991 P_LINE_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL12(P_LINE_RLTSHIP_TBL);
2992 P_PRICE_ADJUSTMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL13(P_PRICE_ADJUSTMENT_TBL);
2993 P_PRICE_ADJ_ATTR_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL14(P_PRICE_ADJ_ATTR_TBL);
2994 P_PRICE_ADJ_RLTSHIP_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL15(P_PRICE_ADJ_RLTSHIP_TBL);
2995 P_LN_PRICE_ATTRIBUTES_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL2(P_LN_PRICE_ATTRIBUTES_TBL);
2996 P_LN_PAYMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL3(P_LN_PAYMENT_TBL);
2997 P_LN_SHIPMENT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL16(P_LN_SHIPMENT_TBL);
2998 P_LN_FREIGHT_CHARGE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL5(P_LN_FREIGHT_CHARGE_TBL);
2999 P_LN_TAX_DETAIL_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL6(P_LN_TAX_DETAIL_TBL);
3000 P_LN_SALES_CREDIT_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL8(P_LN_SALES_CREDIT_TBL);
3001 P_LN_QUOTE_PARTY_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL9(P_LN_QUOTE_PARTY_TBL);
3002 P_QTE_ACCESS_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL17(P_QTE_ACCESS_TBL);
3003 P_TEMPLATE_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL18(P_TEMPLATE_TBL);
3004 P_RELATED_OBJ_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL19(P_RELATED_OBJ_TBL);
3005
3006 po_moac_utils_pvt.set_org_context(P_QTE_HEADER_REC_.ORG_ID);
3007
3008 APPS.ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE(1.0,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,P_CONTROL_REC_,P_QTE_HEADER_REC_,P_HD_PRICE_ATTRIBUTES_TBL_,P_HD_PAYMENT_TBL_,
3009 P_HD_SHIPMENT_REC_,P_HD_FREIGHT_CHARGE_TBL_,P_HD_TAX_DETAIL_TBL_,P_HD_ATTR_EXT_TBL_,P_HD_SALES_CREDIT_TBL_,P_HD_QUOTE_PARTY_TBL_,P_QTE_LINE_TBL_,P_QTE_LINE_DTL_TBL_,
3010 P_LINE_ATTR_EXT_TBL_,P_LINE_RLTSHIP_TBL_,P_PRICE_ADJUSTMENT_TBL_,P_PRICE_ADJ_ATTR_TBL_,P_PRICE_ADJ_RLTSHIP_TBL_,P_LN_PRICE_ATTRIBUTES_TBL_,P_LN_PAYMENT_TBL_,P_LN_SHIPMENT_TBL_,
3011 P_LN_FREIGHT_CHARGE_TBL_,P_LN_TAX_DETAIL_TBL_,P_LN_SALES_CREDIT_TBL_,P_LN_QUOTE_PARTY_TBL_,P_QTE_ACCESS_TBL_,P_TEMPLATE_TBL_,P_RELATED_OBJ_TBL_,X_QTE_HEADER_REC_,
3012 X_QTE_LINE_TBL_,X_QTE_LINE_DTL_TBL_,X_HD_PRICE_ATTRIBUTES_TBL_,X_HD_PAYMENT_TBL_,X_HD_SHIPMENT_REC_,X_HD_FREIGHT_CHARGE_TBL_,X_HD_TAX_DETAIL_TBL_,
3013 X_HD_ATTR_EXT_TBL_,X_HD_SALES_CREDIT_TBL_,X_HD_QUOTE_PARTY_TBL_,X_LINE_ATTR_EXT_TBL_,X_LINE_RLTSHIP_TBL_,X_PRICE_ADJUSTMENT_TBL_,X_PRICE_ADJ_ATTR_TBL_,X_PRICE_ADJ_RLTSHIP_TBL_,
3014 X_LN_PRICE_ATTRIBUTES_TBL_,X_LN_PAYMENT_TBL_,X_LN_SHIPMENT_TBL_,X_LN_FREIGHT_CHARGE_TBL_,X_LN_TAX_DETAIL_TBL_,X_LN_SALES_CREDIT_TBL_,X_LN_QUOTE_PARTY_TBL_,X_QTE_ACCESS_TBL_,
3015 X_TEMPLATE_TBL_,X_RELATED_OBJ_TBL_,X_RETURN_STATUS,X_MSG_COUNT,X_MSG_DATA);
3016
3017 X_QTE_HEADER_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL0(X_QTE_HEADER_REC_);
3018 X_QTE_LINE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL1(X_QTE_LINE_TBL_);
3019 X_QTE_LINE_DTL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL2(X_QTE_LINE_DTL_TBL_);
3020 X_HD_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_HD_PRICE_ATTRIBUTES_TBL_);
3021 X_HD_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_HD_PAYMENT_TBL_);
3022 X_HD_SHIPMENT_REC := ASO_QUOTE_EBIZAD.PL_TO_SQL5(X_HD_SHIPMENT_REC_);
3023 X_HD_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_HD_FREIGHT_CHARGE_TBL_);
3024 X_HD_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_HD_TAX_DETAIL_TBL_);
3025 X_HD_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_HD_ATTR_EXT_TBL_);
3026 X_HD_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_HD_SALES_CREDIT_TBL_);
3027 X_HD_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_HD_QUOTE_PARTY_TBL_);
3028 X_LINE_ATTR_EXT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL8(X_LINE_ATTR_EXT_TBL_);
3029 X_LINE_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL11(X_LINE_RLTSHIP_TBL_);
3030 X_PRICE_ADJUSTMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL12(X_PRICE_ADJUSTMENT_TBL_);
3031 X_PRICE_ADJ_ATTR_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL13(X_PRICE_ADJ_ATTR_TBL_);
3032 X_PRICE_ADJ_RLTSHIP_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL14(X_PRICE_ADJ_RLTSHIP_TBL_);
3033 X_LN_PRICE_ATTRIBUTES_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL3(X_LN_PRICE_ATTRIBUTES_TBL_);
3034 X_LN_PAYMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL4(X_LN_PAYMENT_TBL_);
3035 X_LN_SHIPMENT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL15(X_LN_SHIPMENT_TBL_);
3036 X_LN_FREIGHT_CHARGE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL6(X_LN_FREIGHT_CHARGE_TBL_);
3037 X_LN_TAX_DETAIL_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL7(X_LN_TAX_DETAIL_TBL_);
3038 X_LN_SALES_CREDIT_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL9(X_LN_SALES_CREDIT_TBL_);
3039 X_LN_QUOTE_PARTY_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL10(X_LN_QUOTE_PARTY_TBL_);
3040 X_QTE_ACCESS_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL16(X_QTE_ACCESS_TBL_);
3041 X_TEMPLATE_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL17(X_TEMPLATE_TBL_);
3042 X_RELATED_OBJ_TBL := ASO_QUOTE_EBIZAD.PL_TO_SQL18(X_RELATED_OBJ_TBL_);
3043
3044 IF X_MSG_COUNT > 0 THEN
3045 FOR i IN 1..X_MSG_COUNT LOOP
3046 fnd_msg_pub.get(p_msg_index =>i,
3047 p_encoded => 'F',
3048 p_data => x_msg_data_temp,
3049 p_msg_index_out => lx_msg_index_out);
3050
3051 X_MSG_DATA := X_MSG_DATA || x_msg_data_temp;
3052 fnd_msg_pub.delete_msg;
3053 x_msg_count := 1;
3054
3055 END LOOP;
3056 END IF;
3057
3058 END CREATE_QUOTE_SERVICE;
3059
3060 END ASO_QUOTE_EBIZAD;