[Home] [Help]
PACKAGE BODY: APPS.ASO_DEFAULTING_UTIL
Source
1 PACKAGE BODY ASO_DEFAULTING_UTIL AS
2 /* $Header: asovdhub.pls 120.6 2011/05/30 16:31:42 akushwah ship $ */
3 -- Package name : ASO_DEFAULTING_UTIL
4 -- Purpose :
5 -- History :
6 -- NOTE :
7 -- End of Comments
8
9
10 PROCEDURE Api_Rec_To_Row_Type
11 (
12 P_Entity_Code IN VARCHAR2,
13 P_Quote_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
14 := ASO_Quote_Pub.G_Miss_Qte_Header_Rec,
15 P_Header_Shipment_Rec IN ASO_Quote_Pub.Shipment_Rec_Type
16 := ASO_Quote_Pub.G_Miss_Shipment_Rec,
17 P_Header_Payment_Rec IN ASO_Quote_Pub.Payment_Rec_Type
18 := ASO_Quote_Pub.G_Miss_Payment_Rec,
19 P_Quote_Line_Rec IN ASO_Quote_Pub.Qte_Line_Rec_Type
20 := ASO_Quote_Pub.G_Miss_Qte_Line_Rec,
21 P_Line_Shipment_Rec IN ASO_Quote_Pub.Shipment_Rec_Type
22 := ASO_Quote_Pub.G_Miss_Shipment_Rec,
23 P_Line_Payment_Rec IN ASO_Quote_Pub.Payment_Rec_Type
24 := ASO_Quote_Pub.G_Miss_Payment_Rec,
25 P_Control_Rec IN ASO_Defaulting_Int.Control_Rec_Type
26 := ASO_Defaulting_Int.G_Miss_Control_Rec,
27 P_OPP_QTE_HEADER_REC IN ASO_OPP_QTE_PUB.OPP_QTE_IN_REC_TYPE
28 := ASO_OPP_QTE_PUB.G_MISS_OPP_QTE_IN_REC,
29 P_HEADER_MISC_REC IN ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE
30 := ASO_DEFAULTING_INT.G_MISS_HEADER_MISC_REC,
31 P_HEADER_TAX_DETAIL_REC IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE
32 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_REC,
33 P_LINE_MISC_REC IN ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE
34 := ASO_DEFAULTING_INT.G_MISS_LINE_MISC_REC,
35 P_LINE_TAX_DETAIL_REC IN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE
36 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_REC,
37 X_Qte_Header_Row_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_AK_Quote_Header_V%Rowtype,
38 X_Qte_Opportunity_Row_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_AK_Quote_Oppty_V%Rowtype,
39 X_Qte_Line_Row_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_AK_Quote_Line_V%Rowtype)
40
41 IS
42
43 CURSOR C_Party_Type(lc_party_id NUMBER) IS
44 SELECT Party_Type
45 FROM HZ_PARTIES
46 WHERE Party_Id = lc_party_id;
47
48 CURSOR C_Line_Party_Type(lc_quote_header_id NUMBER) IS
49 SELECT pty.Party_Type
50 FROM HZ_PARTIES pty, ASO_QUOTE_HEADERS_ALL hdr
51 WHERE pty.Party_Id = hdr.cust_party_id
52 AND hdr.quote_header_id = lc_quote_header_id;
53
54 CURSOR C_Product (lc_inv_item_id NUMBER, lc_organization_id NUMBER) IS
55 SELECT Segment1
56 FROM mtl_system_items_vl
57 WHERE inventory_item_id = lc_inv_item_id
58 AND organization_id = lc_organization_id;
59
60 BEGIN
61
62 IF P_Entity_Code = 'QUOTE_HEADER' THEN
63
64 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
65 p_control_rec.defaulting_flow_code like 'CREATE%' AND
66 P_Quote_Header_Rec.QUOTE_NAME IS NULL THEN
67 X_Qte_Header_Row_Rec.Q_QUOTE_NAME := FND_API.G_MISS_CHAR;
68 ELSE
69 X_Qte_Header_Row_Rec.Q_QUOTE_NAME := P_Quote_Header_Rec.QUOTE_NAME;
70 END IF;
71
72 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
73 p_control_rec.defaulting_flow_code like 'CREATE%' AND
74 P_Quote_Header_Rec.QUOTE_HEADER_ID IS NULL THEN
75 X_Qte_Header_Row_Rec.Q_QUOTE_HEADER_ID := FND_API.G_MISS_NUM;
76 ELSE
77 X_Qte_Header_Row_Rec.Q_QUOTE_HEADER_ID := P_Quote_Header_Rec.QUOTE_HEADER_ID;
78 END IF;
79
80 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
81 p_control_rec.defaulting_flow_code like 'CREATE%' AND
82 P_Quote_Header_Rec.CUST_ACCOUNT_ID IS NULL THEN
83 X_Qte_Header_Row_Rec.Q_CUST_ACCOUNT_ID := FND_API.G_MISS_NUM;
84 ELSE
85 X_Qte_Header_Row_Rec.Q_CUST_ACCOUNT_ID := P_Quote_Header_Rec.CUST_ACCOUNT_ID;
86 END IF;
87
88 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
89 p_control_rec.defaulting_flow_code like 'CREATE%' AND
90 P_Quote_Header_Rec.QUOTE_EXPIRATION_DATE IS NULL THEN
91 X_Qte_Header_Row_Rec.Q_QUOTE_EXPIRATION_DATE := FND_API.G_MISS_DATE;
92 ELSE
93 X_Qte_Header_Row_Rec.Q_QUOTE_EXPIRATION_DATE := P_Quote_Header_Rec.QUOTE_EXPIRATION_DATE;
94 END IF;
95
96 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
97 p_control_rec.defaulting_flow_code like 'CREATE%' AND
98 P_Quote_Header_Rec.QUOTE_STATUS_ID IS NULL THEN
99 X_Qte_Header_Row_Rec.Q_QUOTE_STATUS_ID := FND_API.G_MISS_NUM;
100 ELSE
101 X_Qte_Header_Row_Rec.Q_QUOTE_STATUS_ID := P_Quote_Header_Rec.QUOTE_STATUS_ID;
102 END IF;
103
104 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
105 p_control_rec.defaulting_flow_code like 'CREATE%' AND
106 P_Quote_Header_Rec.ORG_ID IS NULL THEN
107 X_Qte_Header_Row_Rec.Q_ORG_ID := FND_API.G_MISS_NUM;
108 ELSE
109 X_Qte_Header_Row_Rec.Q_ORG_ID := P_Quote_Header_Rec.ORG_ID;
110 END IF;
111
112 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
113 p_control_rec.defaulting_flow_code like 'CREATE%' AND
114 P_Quote_Header_Rec.CREATED_BY IS NULL THEN
115 X_Qte_Header_Row_Rec.Q_CREATED_BY := FND_API.G_MISS_NUM;
116 ELSE
117 X_Qte_Header_Row_Rec.Q_CREATED_BY := P_Quote_Header_Rec.CREATED_BY;
118 END IF;
119
120 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
121 p_control_rec.defaulting_flow_code like 'CREATE%' AND
122 P_Quote_Header_Rec.ORDER_TYPE_ID IS NULL THEN
123 X_Qte_Header_Row_Rec.Q_ORDER_TYPE_ID := FND_API.G_MISS_NUM;
124 ELSE
125 X_Qte_Header_Row_Rec.Q_ORDER_TYPE_ID := P_Quote_Header_Rec.ORDER_TYPE_ID;
126 END IF;
127
128 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
129 p_control_rec.defaulting_flow_code like 'CREATE%' AND
130 P_Quote_Header_Rec.CONTRACT_ID IS NULL THEN
131 X_Qte_Header_Row_Rec.Q_CONTRACT_ID := FND_API.G_MISS_NUM;
132 ELSE
133 X_Qte_Header_Row_Rec.Q_CONTRACT_ID := P_Quote_Header_Rec.CONTRACT_ID;
134 END IF;
135
136 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
137 p_control_rec.defaulting_flow_code like 'CREATE%' AND
138 P_Quote_Header_Rec.PRICE_LIST_ID IS NULL THEN
139 X_Qte_Header_Row_Rec.Q_PRICE_LIST_ID := FND_API.G_MISS_NUM;
140 ELSE
141 X_Qte_Header_Row_Rec.Q_PRICE_LIST_ID := P_Quote_Header_Rec.PRICE_LIST_ID;
142 END IF;
143
144 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
145 p_control_rec.defaulting_flow_code like 'CREATE%' AND
146 P_Quote_Header_Rec.CURRENCY_CODE IS NULL THEN
147 X_Qte_Header_Row_Rec.Q_CURRENCY_CODE := FND_API.G_MISS_CHAR;
148 ELSE
149 X_Qte_Header_Row_Rec.Q_CURRENCY_CODE := P_Quote_Header_Rec.CURRENCY_CODE;
150 END IF;
151
152 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
153 p_control_rec.defaulting_flow_code like 'CREATE%' AND
154 P_Quote_Header_Rec.PRICE_FROZEN_DATE IS NULL THEN
155 X_Qte_Header_Row_Rec.Q_PRICE_FROZEN_DATE := FND_API.G_MISS_DATE;
156 ELSE
157 X_Qte_Header_Row_Rec.Q_PRICE_FROZEN_DATE := P_Quote_Header_Rec.PRICE_FROZEN_DATE ;
158 END IF;
159
160 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
161 p_control_rec.defaulting_flow_code like 'CREATE%' AND
162 P_Quote_Header_Rec.CONTRACT_TEMPLATE_ID IS NULL THEN
163 X_Qte_Header_Row_Rec.Q_CONTRACT_TEMPLATE_ID := FND_API.G_MISS_NUM;
164 ELSE
165 X_Qte_Header_Row_Rec.Q_CONTRACT_TEMPLATE_ID := P_Quote_Header_Rec.CONTRACT_TEMPLATE_ID ;
166 END IF;
167
168 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
169 p_control_rec.defaulting_flow_code like 'CREATE%' AND
170 P_Quote_Header_Rec.RESOURCE_ID IS NULL THEN
171 X_Qte_Header_Row_Rec.Q_RESOURCE_ID := FND_API.G_MISS_NUM;
172 ELSE
173 X_Qte_Header_Row_Rec.Q_RESOURCE_ID := P_Quote_Header_Rec.RESOURCE_ID;
174 END IF;
175
176 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
177 p_control_rec.defaulting_flow_code like 'CREATE%' AND
178 P_Quote_Header_Rec.RESOURCE_GRP_ID IS NULL THEN
179 X_Qte_Header_Row_Rec.Q_RESOURCE_GRP_ID := FND_API.G_MISS_NUM;
180 ELSE
181 X_Qte_Header_Row_Rec.Q_RESOURCE_GRP_ID := P_Quote_Header_Rec.RESOURCE_GRP_ID;
182 END IF;
183
184 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
185 p_control_rec.defaulting_flow_code like 'CREATE%' AND
186 P_Quote_Header_Rec.SALES_CHANNEL_CODE IS NULL THEN
187 X_Qte_Header_Row_Rec.Q_SALES_CHANNEL_CODE := FND_API.G_MISS_CHAR;
188 ELSE
189 X_Qte_Header_Row_Rec.Q_SALES_CHANNEL_CODE := P_Quote_Header_Rec.SALES_CHANNEL_CODE;
190 END IF;
191
192 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
193 p_control_rec.defaulting_flow_code like 'CREATE%' AND
194 P_Quote_Header_Rec.MARKETING_SOURCE_CODE_ID IS NULL THEN
195 X_Qte_Header_Row_Rec.Q_MKTING_SRC_CODE_ID := FND_API.G_MISS_NUM;
196 ELSE
197 X_Qte_Header_Row_Rec.Q_MKTING_SRC_CODE_ID := P_Quote_Header_Rec.MARKETING_SOURCE_CODE_ID;
198 END IF;
199
200 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
201 p_control_rec.defaulting_flow_code like 'CREATE%' AND
202 P_Quote_Header_Rec.PARTY_ID IS NULL THEN
203 X_Qte_Header_Row_Rec.Q_PARTY_ID := FND_API.G_MISS_NUM;
204 ELSE
205 X_Qte_Header_Row_Rec.Q_PARTY_ID := P_Quote_Header_Rec.PARTY_ID;
206 END IF;
207
208 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
209 p_control_rec.defaulting_flow_code like 'CREATE%' AND
210 P_Quote_Header_Rec.PHONE_ID IS NULL THEN
211 X_Qte_Header_Row_Rec.Q_PHONE_ID := FND_API.G_MISS_NUM;
212 ELSE
213 X_Qte_Header_Row_Rec.Q_PHONE_ID := P_Quote_Header_Rec.PHONE_ID;
214 END IF;
215
216 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
217 p_control_rec.defaulting_flow_code like 'CREATE%' AND
218 P_Quote_Header_Rec.SOLD_TO_PARTY_SITE_ID IS NULL THEN
219 X_Qte_Header_Row_Rec.Q_SOLD_TO_PARTY_SITE_ID := FND_API.G_MISS_NUM;
220 /*** Start : Code change done for Bug 12406449 ***/
221 ELSIF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING FORM' AND
222 p_control_rec.defaulting_flow_code like 'CREATE%' AND
223 P_Quote_Header_Rec.SOLD_TO_PARTY_SITE_ID IS NOT NULL AND
224 P_Quote_Header_Rec.SOLD_TO_PARTY_SITE_ID <> FND_API.G_MISS_NUM THEN
225 X_Qte_Header_Row_Rec.Q_SOLD_TO_PARTY_SITE_ID := FND_API.G_MISS_NUM;
226 /*** End : Code change done for Bug 12406449 ***/
227 ELSE
228 X_Qte_Header_Row_Rec.Q_SOLD_TO_PARTY_SITE_ID := P_Quote_Header_Rec.SOLD_TO_PARTY_SITE_ID;
229 END IF;
230
231 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
232 p_control_rec.defaulting_flow_code like 'CREATE%' AND
233 P_Quote_Header_Rec.INVOICE_TO_CUST_PARTY_ID IS NULL THEN
234 X_Qte_Header_Row_Rec.Q_INV_TO_CUST_PTY_ID := FND_API.G_MISS_NUM;
235 ELSE
236 X_Qte_Header_Row_Rec.Q_INV_TO_CUST_PTY_ID := P_Quote_Header_Rec.INVOICE_TO_CUST_PARTY_ID;
237 END IF;
238
239 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
240 p_control_rec.defaulting_flow_code like 'CREATE%' AND
241 P_Quote_Header_Rec.INVOICE_TO_CUST_ACCOUNT_ID IS NULL THEN
242 X_Qte_Header_Row_Rec.Q_INV_TO_CUST_ACCT_ID := FND_API.G_MISS_NUM;
243 ELSE
244 X_Qte_Header_Row_Rec.Q_INV_TO_CUST_ACCT_ID := P_Quote_Header_Rec.INVOICE_TO_CUST_ACCOUNT_ID;
245 END IF;
246
247 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
248 p_control_rec.defaulting_flow_code like 'CREATE%' AND
249 P_Quote_Header_Rec.INVOICE_TO_PARTY_SITE_ID IS NULL THEN
250 X_Qte_Header_Row_Rec.Q_INV_TO_PTY_SITE_ID := FND_API.G_MISS_NUM;
251 ELSE
252 X_Qte_Header_Row_Rec.Q_INV_TO_PTY_SITE_ID := P_Quote_Header_Rec.INVOICE_TO_PARTY_SITE_ID ;
253 END IF;
254
255 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
256 p_control_rec.defaulting_flow_code like 'CREATE%' AND
257 P_Quote_Header_Rec.INVOICE_TO_PARTY_ID IS NULL THEN
258 X_Qte_Header_Row_Rec.Q_INV_TO_PTY_ID := FND_API.G_MISS_NUM;
259 ELSE
260 X_Qte_Header_Row_Rec.Q_INV_TO_PTY_ID := P_Quote_Header_Rec.INVOICE_TO_PARTY_ID;
261 END IF;
262
263 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
264 p_control_rec.defaulting_flow_code like 'CREATE%' AND
265 P_Quote_Header_Rec.CUST_PARTY_ID IS NULL THEN
266 X_Qte_Header_Row_Rec.Q_CUST_PARTY_ID := FND_API.G_MISS_NUM;
267 ELSE
268 X_Qte_Header_Row_Rec.Q_CUST_PARTY_ID := P_Quote_Header_Rec.CUST_PARTY_ID;
269 END IF;
270
271 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
272 p_control_rec.defaulting_flow_code like 'CREATE%' AND
273 P_Quote_Header_Rec.END_CUSTOMER_CUST_PARTY_ID IS NULL THEN
274 X_Qte_Header_Row_Rec.Q_END_CUST_CUST_PTY_ID := FND_API.G_MISS_NUM;
275 ELSE
276 X_Qte_Header_Row_Rec.Q_END_CUST_CUST_PTY_ID := P_Quote_Header_Rec.END_CUSTOMER_CUST_PARTY_ID;
277 END IF;
278
279 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
280 p_control_rec.defaulting_flow_code like 'CREATE%' AND
281 P_Quote_Header_Rec.END_CUSTOMER_CUST_ACCOUNT_ID IS NULL THEN
282 X_Qte_Header_Row_Rec.Q_END_CUST_CUST_ACCT_ID := FND_API.G_MISS_NUM;
283 ELSE
284 X_Qte_Header_Row_Rec.Q_END_CUST_CUST_ACCT_ID := P_Quote_Header_Rec.END_CUSTOMER_CUST_ACCOUNT_ID;
285 END IF;
286
287 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
288 p_control_rec.defaulting_flow_code like 'CREATE%' AND
289 P_Quote_Header_Rec.END_CUSTOMER_PARTY_SITE_ID IS NULL THEN
290 X_Qte_Header_Row_Rec.Q_END_CUST_PTY_SITE_ID := FND_API.G_MISS_NUM;
291 ELSE
292 X_Qte_Header_Row_Rec.Q_END_CUST_PTY_SITE_ID := P_Quote_Header_Rec.END_CUSTOMER_PARTY_SITE_ID ;
293 END IF;
294
295 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
296 p_control_rec.defaulting_flow_code like 'CREATE%' AND
297 P_Quote_Header_Rec.END_CUSTOMER_PARTY_ID IS NULL THEN
298 X_Qte_Header_Row_Rec.Q_END_CUST_PTY_ID := FND_API.G_MISS_NUM;
299 ELSE
300 X_Qte_Header_Row_Rec.Q_END_CUST_PTY_ID := P_Quote_Header_Rec.END_CUSTOMER_PARTY_ID;
301 END IF;
302
303 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
304 p_control_rec.defaulting_flow_code like 'CREATE%' AND
305 P_Quote_Header_Rec.AUTOMATIC_PRICE_FLAG IS NULL THEN
306 X_Qte_Header_Row_Rec.Q_AUTOMATIC_PRICE_FLAG := FND_API.G_MISS_CHAR;
307 ELSE
308 X_Qte_Header_Row_Rec.Q_AUTOMATIC_PRICE_FLAG := P_Quote_Header_Rec.AUTOMATIC_PRICE_FLAG ;
309 END IF;
310
311 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
312 p_control_rec.defaulting_flow_code like 'CREATE%' AND
313 P_Quote_Header_Rec.AUTOMATIC_TAX_FLAG IS NULL THEN
314 X_Qte_Header_Row_Rec.Q_AUTOMATIC_TAX_FLAG := FND_API.G_MISS_CHAR;
315 ELSE
316 X_Qte_Header_Row_Rec.Q_AUTOMATIC_TAX_FLAG := P_Quote_Header_Rec.AUTOMATIC_TAX_FLAG;
317 END IF;
318
319 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
320 p_control_rec.defaulting_flow_code like 'CREATE%' AND
321 P_Quote_Header_Rec.LAST_UPDATE_DATE IS NULL THEN
322 X_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
323 ELSE
324 X_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE := P_Quote_Header_Rec.LAST_UPDATE_DATE;
325 END IF;
326
327 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
328 p_control_rec.defaulting_flow_code like 'CREATE%' AND
329 P_Quote_Header_Rec.OBJECT_VERSION_NUMBER IS NULL THEN
330 X_Qte_Header_Row_Rec.Q_OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
331 ELSE
332 X_Qte_Header_Row_Rec.Q_OBJECT_VERSION_NUMBER := P_Quote_Header_Rec.OBJECT_VERSION_NUMBER ;
333 END IF;
334
335 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
336 p_control_rec.defaulting_flow_code like 'CREATE%' AND
337 P_Quote_Header_Rec.ATTRIBUTE_CATEGORY IS NULL THEN
338 X_Qte_Header_Row_Rec.Q_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
339 ELSE
340 X_Qte_Header_Row_Rec.Q_ATTRIBUTE_CATEGORY := P_Quote_Header_Rec.ATTRIBUTE_CATEGORY;
341 END IF;
342
343 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
344 p_control_rec.defaulting_flow_code like 'CREATE%' AND
345 P_Quote_Header_Rec.ATTRIBUTE1 IS NULL THEN
346 X_Qte_Header_Row_Rec.Q_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
347 ELSE
348 X_Qte_Header_Row_Rec.Q_ATTRIBUTE1 := P_Quote_Header_Rec.ATTRIBUTE1;
349 END IF;
350
351 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
352 p_control_rec.defaulting_flow_code like 'CREATE%' AND
353 P_Quote_Header_Rec.ATTRIBUTE2 IS NULL THEN
354 X_Qte_Header_Row_Rec.Q_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
355 ELSE
356 X_Qte_Header_Row_Rec.Q_ATTRIBUTE2 := P_Quote_Header_Rec.ATTRIBUTE2;
357 END IF;
358
359 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
360 p_control_rec.defaulting_flow_code like 'CREATE%' AND
361 P_Quote_Header_Rec.ATTRIBUTE3 IS NULL THEN
362 X_Qte_Header_Row_Rec.Q_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
363 ELSE
364 X_Qte_Header_Row_Rec.Q_ATTRIBUTE3 := P_Quote_Header_Rec.ATTRIBUTE3;
365 END IF;
366
367 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
368 p_control_rec.defaulting_flow_code like 'CREATE%' AND
369 P_Quote_Header_Rec.ATTRIBUTE4 IS NULL THEN
370 X_Qte_Header_Row_Rec.Q_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
371 ELSE
372 X_Qte_Header_Row_Rec.Q_ATTRIBUTE4 := P_Quote_Header_Rec.ATTRIBUTE4;
373 END IF;
374
375 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
376 p_control_rec.defaulting_flow_code like 'CREATE%' AND
377 P_Quote_Header_Rec.ATTRIBUTE5 IS NULL THEN
378 X_Qte_Header_Row_Rec.Q_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
379 ELSE
380 X_Qte_Header_Row_Rec.Q_ATTRIBUTE5 := P_Quote_Header_Rec.ATTRIBUTE5;
381 END IF;
382
383 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
384 p_control_rec.defaulting_flow_code like 'CREATE%' AND
385 P_Quote_Header_Rec.ATTRIBUTE6 IS NULL THEN
386 X_Qte_Header_Row_Rec.Q_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
387 ELSE
388 X_Qte_Header_Row_Rec.Q_ATTRIBUTE6 := P_Quote_Header_Rec.ATTRIBUTE6;
389 END IF;
390
391 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
392 p_control_rec.defaulting_flow_code like 'CREATE%' AND
393 P_Quote_Header_Rec.ATTRIBUTE7 IS NULL THEN
394 X_Qte_Header_Row_Rec.Q_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
395 ELSE
396 X_Qte_Header_Row_Rec.Q_ATTRIBUTE7 := P_Quote_Header_Rec.ATTRIBUTE7;
397 END IF;
398
399 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
400 p_control_rec.defaulting_flow_code like 'CREATE%' AND
401 P_Quote_Header_Rec.ATTRIBUTE8 IS NULL THEN
402 X_Qte_Header_Row_Rec.Q_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
403 ELSE
404 X_Qte_Header_Row_Rec.Q_ATTRIBUTE8 := P_Quote_Header_Rec.ATTRIBUTE8;
405 END IF;
406
407 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
408 p_control_rec.defaulting_flow_code like 'CREATE%' AND
409 P_Quote_Header_Rec.ATTRIBUTE9 IS NULL THEN
410 X_Qte_Header_Row_Rec.Q_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
411 ELSE
412 X_Qte_Header_Row_Rec.Q_ATTRIBUTE9 := P_Quote_Header_Rec.ATTRIBUTE9;
413 END IF;
414
415 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
416 p_control_rec.defaulting_flow_code like 'CREATE%' AND
417 P_Quote_Header_Rec.ATTRIBUTE10 IS NULL THEN
418 X_Qte_Header_Row_Rec.Q_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
419 ELSE
420 X_Qte_Header_Row_Rec.Q_ATTRIBUTE10 := P_Quote_Header_Rec.ATTRIBUTE10;
421 END IF;
422
423 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
424 p_control_rec.defaulting_flow_code like 'CREATE%' AND
425 P_Quote_Header_Rec.ATTRIBUTE11 IS NULL THEN
426 X_Qte_Header_Row_Rec.Q_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
427 ELSE
428 X_Qte_Header_Row_Rec.Q_ATTRIBUTE11 := P_Quote_Header_Rec.ATTRIBUTE11;
429 END IF;
430
431 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
432 p_control_rec.defaulting_flow_code like 'CREATE%' AND
433 P_Quote_Header_Rec.ATTRIBUTE12 IS NULL THEN
434 X_Qte_Header_Row_Rec.Q_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
435 ELSE
436 X_Qte_Header_Row_Rec.Q_ATTRIBUTE12 := P_Quote_Header_Rec.ATTRIBUTE12;
437 END IF;
438
439 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
440 p_control_rec.defaulting_flow_code like 'CREATE%' AND
441 P_Quote_Header_Rec.ATTRIBUTE13 IS NULL THEN
442 X_Qte_Header_Row_Rec.Q_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
443 ELSE
444 X_Qte_Header_Row_Rec.Q_ATTRIBUTE13 := P_Quote_Header_Rec.ATTRIBUTE13;
445 END IF;
446
447 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
448 p_control_rec.defaulting_flow_code like 'CREATE%' AND
449 P_Quote_Header_Rec.ATTRIBUTE14 IS NULL THEN
450 X_Qte_Header_Row_Rec.Q_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
451 ELSE
452 X_Qte_Header_Row_Rec.Q_ATTRIBUTE14 := P_Quote_Header_Rec.ATTRIBUTE14;
453 END IF;
454
455 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
456 p_control_rec.defaulting_flow_code like 'CREATE%' AND
457 P_Quote_Header_Rec.ATTRIBUTE15 IS NULL THEN
458 X_Qte_Header_Row_Rec.Q_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
459 ELSE
460 X_Qte_Header_Row_Rec.Q_ATTRIBUTE15 := P_Quote_Header_Rec.ATTRIBUTE15;
461 END IF;
462
463 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
464 p_control_rec.defaulting_flow_code like 'CREATE%' AND
465 P_Quote_Header_Rec.ATTRIBUTE16 IS NULL THEN
466 X_Qte_Header_Row_Rec.Q_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
467 ELSE
468 X_Qte_Header_Row_Rec.Q_ATTRIBUTE16 := P_Quote_Header_Rec.ATTRIBUTE16;
469 END IF;
470
471 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
472 p_control_rec.defaulting_flow_code like 'CREATE%' AND
473 P_Quote_Header_Rec.ATTRIBUTE17 IS NULL THEN
474 X_Qte_Header_Row_Rec.Q_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
475 ELSE
476 X_Qte_Header_Row_Rec.Q_ATTRIBUTE17 := P_Quote_Header_Rec.ATTRIBUTE17;
477 END IF;
478
479 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
480 p_control_rec.defaulting_flow_code like 'CREATE%' AND
481 P_Quote_Header_Rec.ATTRIBUTE18 IS NULL THEN
482 X_Qte_Header_Row_Rec.Q_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
483 ELSE
484 X_Qte_Header_Row_Rec.Q_ATTRIBUTE18 := P_Quote_Header_Rec.ATTRIBUTE18;
485 END IF;
486
487 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
488 p_control_rec.defaulting_flow_code like 'CREATE%' AND
489 P_Quote_Header_Rec.ATTRIBUTE19 IS NULL THEN
490 X_Qte_Header_Row_Rec.Q_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
491 ELSE
492 X_Qte_Header_Row_Rec.Q_ATTRIBUTE19 := P_Quote_Header_Rec.ATTRIBUTE19;
493 END IF;
494
495 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
496 p_control_rec.defaulting_flow_code like 'CREATE%' AND
497 P_Quote_Header_Rec.ATTRIBUTE20 IS NULL THEN
498 X_Qte_Header_Row_Rec.Q_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
499 ELSE
500 X_Qte_Header_Row_Rec.Q_ATTRIBUTE20 := P_Quote_Header_Rec.ATTRIBUTE20;
501 END IF;
502
503 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
504 p_control_rec.defaulting_flow_code like 'CREATE%' AND
505 P_Header_Shipment_Rec.SHIP_TO_CUST_PARTY_ID IS NULL THEN
506 X_Qte_Header_Row_Rec.Q_SHIP_TO_CUST_PARTY_ID := FND_API.G_MISS_NUM;
507 ELSE
508 X_Qte_Header_Row_Rec.Q_SHIP_TO_CUST_PARTY_ID :=P_Header_Shipment_Rec.SHIP_TO_CUST_PARTY_ID;
509 END IF;
510
511 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
512 p_control_rec.defaulting_flow_code like 'CREATE%' AND
513 P_Header_Shipment_Rec.SHIP_TO_CUST_ACCOUNT_ID IS NULL THEN
514 X_Qte_Header_Row_Rec.Q_SHIP_TO_CUST_ACCT_ID := FND_API.G_MISS_NUM;
515 ELSE
516 X_Qte_Header_Row_Rec.Q_SHIP_TO_CUST_ACCT_ID := P_Header_Shipment_Rec.SHIP_TO_CUST_ACCOUNT_ID;
517 END IF;
518
519 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
520 p_control_rec.defaulting_flow_code like 'CREATE%' AND
521 P_Header_Shipment_Rec.SHIP_TO_PARTY_SITE_ID IS NULL THEN
522 X_Qte_Header_Row_Rec.Q_SHIP_TO_PARTY_SITE_ID := FND_API.G_MISS_NUM;
523 ELSE
524 X_Qte_Header_Row_Rec.Q_SHIP_TO_PARTY_SITE_ID := P_Header_Shipment_Rec.SHIP_TO_PARTY_SITE_ID;
525 END IF;
526
527 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
528 p_control_rec.defaulting_flow_code like 'CREATE%' AND
529 P_Header_Shipment_Rec.SHIP_TO_PARTY_ID IS NULL THEN
530 X_Qte_Header_Row_Rec.Q_SHIP_TO_PARTY_ID := FND_API.G_MISS_NUM;
531 ELSE
532 X_Qte_Header_Row_Rec.Q_SHIP_TO_PARTY_ID := P_Header_Shipment_Rec.SHIP_TO_PARTY_ID;
533 END IF;
534
535 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
536 p_control_rec.defaulting_flow_code like 'CREATE%' AND
537 P_Header_Payment_Rec.PAYMENT_TERM_ID IS NULL THEN
538 X_Qte_Header_Row_Rec.Q_PAYMENT_TERM_ID := FND_API.G_MISS_NUM;
539 ELSE
540 X_Qte_Header_Row_Rec.Q_PAYMENT_TERM_ID := P_Header_Payment_Rec.PAYMENT_TERM_ID;
541 END IF;
542
543 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
544 p_control_rec.defaulting_flow_code like 'CREATE%' AND
545 P_Header_Payment_Rec.CUST_PO_NUMBER IS NULL THEN
546 X_Qte_Header_Row_Rec.Q_CUST_PO_NUMBER := FND_API.G_MISS_CHAR;
547 ELSE
548 X_Qte_Header_Row_Rec.Q_CUST_PO_NUMBER := P_Header_Payment_Rec.CUST_PO_NUMBER ;
549 END IF;
550
551 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
552 p_control_rec.defaulting_flow_code like 'CREATE%' AND
553 P_Header_Payment_Rec.CREDIT_CARD_CODE IS NULL THEN
554 X_Qte_Header_Row_Rec.Q_CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
555 ELSE
556 X_Qte_Header_Row_Rec.Q_CREDIT_CARD_CODE := P_Header_Payment_Rec.CREDIT_CARD_CODE ;
557 END IF;
558
559 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
560 p_control_rec.defaulting_flow_code like 'CREATE%' AND
561 P_Header_Payment_Rec.PAYMENT_REF_NUMBER IS NULL THEN
562 X_Qte_Header_Row_Rec.Q_PAYMENT_REF_NUMBER := FND_API.G_MISS_CHAR;
563 ELSE
564 X_Qte_Header_Row_Rec.Q_PAYMENT_REF_NUMBER := P_Header_Payment_Rec.PAYMENT_REF_NUMBER ;
565 END IF;
566
567 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
568 p_control_rec.defaulting_flow_code like 'CREATE%' AND
569 P_Header_Payment_Rec.CREDIT_CARD_HOLDER_NAME IS NULL THEN
570 X_Qte_Header_Row_Rec.Q_CREDIT_CARD_HLD_NAME := FND_API.G_MISS_CHAR;
571 ELSE
572 X_Qte_Header_Row_Rec.Q_CREDIT_CARD_HLD_NAME := P_Header_Payment_Rec.CREDIT_CARD_HOLDER_NAME ;
573 END IF;
574
575 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
576 p_control_rec.defaulting_flow_code like 'CREATE%' AND
577 P_Header_Payment_Rec.CREDIT_CARD_EXPIRATION_DATE IS NULL THEN
578 X_Qte_Header_Row_Rec.Q_CREDIT_CARD_EXP_DATE := FND_API.G_MISS_DATE;
579 ELSE
580 X_Qte_Header_Row_Rec.Q_CREDIT_CARD_EXP_DATE := P_Header_Payment_Rec.CREDIT_CARD_EXPIRATION_DATE ;
581 END IF;
582
583 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
584 p_control_rec.defaulting_flow_code like 'CREATE%' AND
585 P_Header_Payment_Rec.PAYMENT_TYPE_CODE IS NULL THEN
586 X_Qte_Header_Row_Rec.Q_PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
587 ELSE
588 X_Qte_Header_Row_Rec.Q_PAYMENT_TYPE_CODE := P_Header_Payment_Rec.PAYMENT_TYPE_CODE ;
589 END IF;
590
591 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
592 p_control_rec.defaulting_flow_code like 'CREATE%' AND
593 P_Header_Shipment_Rec.REQUEST_DATE_TYPE IS NULL THEN
594 X_Qte_Header_Row_Rec.Q_REQUEST_DATE_TYPE := FND_API.G_MISS_CHAR;
595 ELSE
596 X_Qte_Header_Row_Rec.Q_REQUEST_DATE_TYPE := P_Header_Shipment_Rec.REQUEST_DATE_TYPE ;
597 END IF;
598
599 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
600 p_control_rec.defaulting_flow_code like 'CREATE%' AND
601 P_Header_Shipment_Rec.REQUEST_DATE IS NULL THEN
602 X_Qte_Header_Row_Rec.Q_REQUEST_DATE := FND_API.G_MISS_DATE;
603 ELSE
604 X_Qte_Header_Row_Rec.Q_REQUEST_DATE := P_Header_Shipment_Rec.REQUEST_DATE ;
605 END IF;
606
607 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
608 p_control_rec.defaulting_flow_code like 'CREATE%' AND
609 P_Header_Shipment_Rec.SHIP_METHOD_CODE IS NULL THEN
610 X_Qte_Header_Row_Rec.Q_SHIP_METHOD_CODE := FND_API.G_MISS_CHAR;
611 ELSE
612 X_Qte_Header_Row_Rec.Q_SHIP_METHOD_CODE := P_Header_Shipment_Rec.SHIP_METHOD_CODE;
613 END IF;
614
615 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
616 p_control_rec.defaulting_flow_code like 'CREATE%' AND
617 P_Header_Shipment_Rec.SHIPMENT_PRIORITY_CODE IS NULL THEN
618 X_Qte_Header_Row_Rec.Q_SHIPMENT_PRIORITY_CODE := FND_API.G_MISS_CHAR;
619 ELSE
620 X_Qte_Header_Row_Rec.Q_SHIPMENT_PRIORITY_CODE := P_Header_Shipment_Rec.SHIPMENT_PRIORITY_CODE;
621 END IF;
622
623 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
624 p_control_rec.defaulting_flow_code like 'CREATE%' AND
625 P_Header_Shipment_Rec.FREIGHT_TERMS_CODE IS NULL THEN
626 X_Qte_Header_Row_Rec.Q_FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;
627 ELSE
628 X_Qte_Header_Row_Rec.Q_FREIGHT_TERMS_CODE := P_Header_Shipment_Rec.FREIGHT_TERMS_CODE;
629 END IF;
630
631 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
632 p_control_rec.defaulting_flow_code like 'CREATE%' AND
633 P_Header_Shipment_Rec.FOB_CODE IS NULL THEN
634 X_Qte_Header_Row_Rec.Q_FOB_CODE := FND_API.G_MISS_CHAR;
635 ELSE
636 X_Qte_Header_Row_Rec.Q_FOB_CODE := P_Header_Shipment_Rec.FOB_CODE;
637 END IF;
638
639 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
640 p_control_rec.defaulting_flow_code like 'CREATE%' AND
641 P_Header_Shipment_Rec.SHIPPING_INSTRUCTIONS IS NULL THEN
642 X_Qte_Header_Row_Rec.Q_SHIPPING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
643 ELSE
644 X_Qte_Header_Row_Rec.Q_SHIPPING_INSTRUCTIONS := P_Header_Shipment_Rec.SHIPPING_INSTRUCTIONS;
645 END IF;
646
647 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
648 p_control_rec.defaulting_flow_code like 'CREATE%' AND
649 P_Header_Shipment_Rec.PACKING_INSTRUCTIONS IS NULL THEN
650 X_Qte_Header_Row_Rec.Q_PACKING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
651 ELSE
652 X_Qte_Header_Row_Rec.Q_PACKING_INSTRUCTIONS := P_Header_Shipment_Rec.PACKING_INSTRUCTIONS;
653 END IF;
654
655 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
656 p_control_rec.defaulting_flow_code like 'CREATE%' AND
657 P_Header_Shipment_Rec.DEMAND_CLASS_CODE IS NULL THEN
658 X_Qte_Header_Row_Rec.Q_DEMAND_CLASS_CODE := FND_API.G_MISS_CHAR;
659 ELSE
660 X_Qte_Header_Row_Rec.Q_DEMAND_CLASS_CODE := P_Header_Shipment_Rec.DEMAND_CLASS_CODE;
661 END IF;
662
663 X_Qte_Header_Row_Rec.Q_APPLICATION_TYPE_CODE := P_Control_Rec.APPLICATION_TYPE_CODE;
664
665 OPEN C_Party_Type(P_Quote_Header_Rec.CUST_PARTY_ID);
666 FETCH C_Party_Type INTO X_Qte_Header_Row_Rec.Q_QUOTE_CUSTOMER_TYPE;
667 CLOSE C_Party_Type;
668
669 ELSIF P_Entity_Code = 'QUOTE_OPPTY' THEN
670
671 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
672 p_control_rec.defaulting_flow_code like 'CREATE%' AND
673 P_Quote_Header_Rec.QUOTE_NAME IS NULL THEN
674 X_Qte_Opportunity_Row_Rec.O_QUOTE_NAME := FND_API.G_MISS_CHAR;
675 ELSE
676 X_Qte_Opportunity_Row_Rec.O_QUOTE_NAME := P_Quote_Header_Rec.QUOTE_NAME;
677 END IF;
678
679 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
680 p_control_rec.defaulting_flow_code like 'CREATE%' AND
681 P_Quote_Header_Rec.QUOTE_HEADER_ID IS NULL THEN
682 X_Qte_Opportunity_Row_Rec.O_QUOTE_HEADER_ID := FND_API.G_MISS_NUM;
683 ELSE
684 X_Qte_Opportunity_Row_Rec.O_QUOTE_HEADER_ID := P_Quote_Header_Rec.QUOTE_HEADER_ID;
685 END IF;
686
687 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
688 p_control_rec.defaulting_flow_code like 'CREATE%' AND
689 P_Quote_Header_Rec.CUST_ACCOUNT_ID IS NULL THEN
690 X_Qte_Opportunity_Row_Rec.O_CUST_ACCOUNT_ID := FND_API.G_MISS_NUM;
691 ELSE
692 X_Qte_Opportunity_Row_Rec.O_CUST_ACCOUNT_ID := P_Quote_Header_Rec.CUST_ACCOUNT_ID;
693 END IF;
694
695 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
696 p_control_rec.defaulting_flow_code like 'CREATE%' AND
697 P_Quote_Header_Rec.QUOTE_EXPIRATION_DATE IS NULL THEN
698 X_Qte_Opportunity_Row_Rec.O_QUOTE_EXP_DATE := FND_API.G_MISS_DATE;
699 ELSE
700 X_Qte_Opportunity_Row_Rec.O_QUOTE_EXP_DATE := P_Quote_Header_Rec.QUOTE_EXPIRATION_DATE;
701 END IF;
702
703 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
704 p_control_rec.defaulting_flow_code like 'CREATE%' AND
705 P_Quote_Header_Rec.QUOTE_STATUS_ID IS NULL THEN
706 X_Qte_Opportunity_Row_Rec.O_QUOTE_STATUS_ID := FND_API.G_MISS_NUM;
707 ELSE
708 X_Qte_Opportunity_Row_Rec.O_QUOTE_STATUS_ID := P_Quote_Header_Rec.QUOTE_STATUS_ID;
709 END IF;
710
711 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
712 p_control_rec.defaulting_flow_code like 'CREATE%' AND
713 P_Quote_Header_Rec.ORG_ID IS NULL THEN
714 X_Qte_Opportunity_Row_Rec.O_ORG_ID := FND_API.G_MISS_NUM;
715 ELSE
716 X_Qte_Opportunity_Row_Rec.O_ORG_ID := P_Quote_Header_Rec.ORG_ID;
717 END IF;
718
719 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
720 p_control_rec.defaulting_flow_code like 'CREATE%' AND
721 P_Quote_Header_Rec.CREATED_BY IS NULL THEN
722 X_Qte_Opportunity_Row_Rec.O_CREATED_BY := FND_API.G_MISS_NUM;
723 ELSE
724 X_Qte_Opportunity_Row_Rec.O_CREATED_BY := P_Quote_Header_Rec.CREATED_BY;
725 END IF;
726
727 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
728 p_control_rec.defaulting_flow_code like 'CREATE%' AND
729 P_Quote_Header_Rec.ORDER_TYPE_ID IS NULL THEN
730 X_Qte_Opportunity_Row_Rec.O_ORDER_TYPE_ID := FND_API.G_MISS_NUM;
731 ELSE
732 X_Qte_Opportunity_Row_Rec.O_ORDER_TYPE_ID := P_Quote_Header_Rec.ORDER_TYPE_ID;
733 END IF;
734
735 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
736 p_control_rec.defaulting_flow_code like 'CREATE%' AND
737 P_Quote_Header_Rec.CONTRACT_ID IS NULL THEN
738 X_Qte_Opportunity_Row_Rec.O_CONTRACT_ID := FND_API.G_MISS_NUM;
739 ELSE
740 X_Qte_Opportunity_Row_Rec.O_CONTRACT_ID := P_Quote_Header_Rec.CONTRACT_ID;
741 END IF;
742
743 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
744 p_control_rec.defaulting_flow_code like 'CREATE%' AND
745 P_Quote_Header_Rec.PRICE_LIST_ID IS NULL THEN
746 X_Qte_Opportunity_Row_Rec.O_PRICE_LIST_ID := FND_API.G_MISS_NUM;
747 ELSE
748 X_Qte_Opportunity_Row_Rec.O_PRICE_LIST_ID := P_Quote_Header_Rec.PRICE_LIST_ID;
749 END IF;
750
751 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
752 p_control_rec.defaulting_flow_code like 'CREATE%' AND
753 P_Quote_Header_Rec.CURRENCY_CODE IS NULL THEN
754 X_Qte_Opportunity_Row_Rec.O_CURRENCY_CODE := FND_API.G_MISS_CHAR;
755 ELSE
756 X_Qte_Opportunity_Row_Rec.O_CURRENCY_CODE := P_Quote_Header_Rec.CURRENCY_CODE;
757 END IF;
758
759 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
760 p_control_rec.defaulting_flow_code like 'CREATE%' AND
761 P_Quote_Header_Rec.PRICE_FROZEN_DATE IS NULL THEN
762 X_Qte_Opportunity_Row_Rec.O_PRICE_FROZEN_DATE := FND_API.G_MISS_DATE;
763 ELSE
764 X_Qte_Opportunity_Row_Rec.O_PRICE_FROZEN_DATE := P_Quote_Header_Rec.PRICE_FROZEN_DATE ;
765 END IF;
766
767 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
768 p_control_rec.defaulting_flow_code like 'CREATE%' AND
769 P_Quote_Header_Rec.CONTRACT_TEMPLATE_ID IS NULL THEN
770 X_Qte_Opportunity_Row_Rec.O_CONTRACT_TEMPLATE_ID := FND_API.G_MISS_NUM;
771 ELSE
772 X_Qte_Opportunity_Row_Rec.O_CONTRACT_TEMPLATE_ID := P_Quote_Header_Rec.CONTRACT_TEMPLATE_ID ;
773 END IF;
774
775 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
776 p_control_rec.defaulting_flow_code like 'CREATE%' AND
777 P_Quote_Header_Rec.RESOURCE_ID IS NULL THEN
778 X_Qte_Opportunity_Row_Rec.O_RESOURCE_ID := FND_API.G_MISS_NUM;
779 ELSE
780 X_Qte_Opportunity_Row_Rec.O_RESOURCE_ID := P_Quote_Header_Rec.RESOURCE_ID;
781 END IF;
782
783 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
784 p_control_rec.defaulting_flow_code like 'CREATE%' AND
785 P_Quote_Header_Rec.RESOURCE_GRP_ID IS NULL THEN
786 X_Qte_Opportunity_Row_Rec.O_RESOURCE_GRP_ID := FND_API.G_MISS_NUM;
787 ELSE
788 X_Qte_Opportunity_Row_Rec.O_RESOURCE_GRP_ID := P_Quote_Header_Rec.RESOURCE_GRP_ID;
789 END IF;
790
791 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
792 p_control_rec.defaulting_flow_code like 'CREATE%' AND
793 P_Quote_Header_Rec.SALES_CHANNEL_CODE IS NULL THEN
794 X_Qte_Opportunity_Row_Rec.O_SALES_CHANNEL_CODE := FND_API.G_MISS_CHAR;
795 ELSE
796 X_Qte_Opportunity_Row_Rec.O_SALES_CHANNEL_CODE := P_Quote_Header_Rec.SALES_CHANNEL_CODE;
797 END IF;
798
799 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
800 p_control_rec.defaulting_flow_code like 'CREATE%' AND
801 P_Quote_Header_Rec.MARKETING_SOURCE_CODE_ID IS NULL THEN
802 X_Qte_Opportunity_Row_Rec.O_MKTING_SRC_CODE_ID := FND_API.G_MISS_NUM;
803 ELSE
804 X_Qte_Opportunity_Row_Rec.O_MKTING_SRC_CODE_ID := P_Quote_Header_Rec.MARKETING_SOURCE_CODE_ID;
805 END IF;
806
807 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
808 p_control_rec.defaulting_flow_code like 'CREATE%' AND
809 P_Quote_Header_Rec.PARTY_ID IS NULL THEN
810 X_Qte_Opportunity_Row_Rec.O_PARTY_ID := FND_API.G_MISS_NUM;
811 ELSE
812 X_Qte_Opportunity_Row_Rec.O_PARTY_ID := P_Quote_Header_Rec.PARTY_ID;
813 END IF;
814
815 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
816 p_control_rec.defaulting_flow_code like 'CREATE%' AND
817 P_Quote_Header_Rec.PHONE_ID IS NULL THEN
818 X_Qte_Opportunity_Row_Rec.O_PHONE_ID := FND_API.G_MISS_NUM;
819 ELSE
820 X_Qte_Opportunity_Row_Rec.O_PHONE_ID := P_Quote_Header_Rec.PHONE_ID;
821 END IF;
822
823 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
824 p_control_rec.defaulting_flow_code like 'CREATE%' AND
825 P_Quote_Header_Rec.SOLD_TO_PARTY_SITE_ID IS NULL THEN
826 X_Qte_Opportunity_Row_Rec.O_SOLD_TO_PARTY_SITE_ID := FND_API.G_MISS_NUM;
827 ELSE
828 X_Qte_Opportunity_Row_Rec.O_SOLD_TO_PARTY_SITE_ID := P_Quote_Header_Rec.SOLD_TO_PARTY_SITE_ID;
829 END IF;
830
831 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
832 p_control_rec.defaulting_flow_code like 'CREATE%' AND
833 P_Quote_Header_Rec.INVOICE_TO_CUST_PARTY_ID IS NULL THEN
834 X_Qte_Opportunity_Row_Rec.O_INV_CUST_PTY_ID := FND_API.G_MISS_NUM;
835 ELSE
836 X_Qte_Opportunity_Row_Rec.O_INV_CUST_PTY_ID := P_Quote_Header_Rec.INVOICE_TO_CUST_PARTY_ID;
837 END IF;
838
839 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
840 p_control_rec.defaulting_flow_code like 'CREATE%' AND
841 P_Quote_Header_Rec.INVOICE_TO_CUST_ACCOUNT_ID IS NULL THEN
842 X_Qte_Opportunity_Row_Rec.O_INV_CUST_ACCT_ID := FND_API.G_MISS_NUM;
843 ELSE
844 X_Qte_Opportunity_Row_Rec.O_INV_CUST_ACCT_ID := P_Quote_Header_Rec.INVOICE_TO_CUST_ACCOUNT_ID;
845 END IF;
846
847 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
848 p_control_rec.defaulting_flow_code like 'CREATE%' AND
849 P_Quote_Header_Rec.INVOICE_TO_PARTY_SITE_ID IS NULL THEN
850 X_Qte_Opportunity_Row_Rec.O_INV_PTY_SITE_ID := FND_API.G_MISS_NUM;
851 ELSE
852 X_Qte_Opportunity_Row_Rec.O_INV_PTY_SITE_ID := P_Quote_Header_Rec.INVOICE_TO_PARTY_SITE_ID ;
853 END IF;
854
855 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
856 p_control_rec.defaulting_flow_code like 'CREATE%' AND
857 P_Quote_Header_Rec.INVOICE_TO_PARTY_ID IS NULL THEN
858 X_Qte_Opportunity_Row_Rec.O_INV_PTY_ID := FND_API.G_MISS_NUM;
859 ELSE
860 X_Qte_Opportunity_Row_Rec.O_INV_PTY_ID := P_Quote_Header_Rec.INVOICE_TO_PARTY_ID;
861 END IF;
862
863 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
864 p_control_rec.defaulting_flow_code like 'CREATE%' AND
865 P_Quote_Header_Rec.CUST_PARTY_ID IS NULL THEN
866 X_Qte_Opportunity_Row_Rec.O_CUST_PARTY_ID := FND_API.G_MISS_NUM;
867 ELSE
868 X_Qte_Opportunity_Row_Rec.O_CUST_PARTY_ID := P_Quote_Header_Rec.CUST_PARTY_ID;
869 END IF;
870
871 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
872 p_control_rec.defaulting_flow_code like 'CREATE%' AND
873 P_Quote_Header_Rec.END_CUSTOMER_CUST_PARTY_ID IS NULL THEN
874 X_Qte_Opportunity_Row_Rec.O_END_CUST_CUST_PTY_ID := FND_API.G_MISS_NUM;
875 ELSE
876 X_Qte_Opportunity_Row_Rec.O_END_CUST_CUST_PTY_ID := P_Quote_Header_Rec.END_CUSTOMER_CUST_PARTY_ID;
877 END IF;
878
879 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
880 p_control_rec.defaulting_flow_code like 'CREATE%' AND
881 P_Quote_Header_Rec.END_CUSTOMER_CUST_ACCOUNT_ID IS NULL THEN
882 X_Qte_Opportunity_Row_Rec.O_END_CUST_CUST_ACCT_ID := FND_API.G_MISS_NUM;
883 ELSE
884 X_Qte_Opportunity_Row_Rec.O_END_CUST_CUST_ACCT_ID := P_Quote_Header_Rec.END_CUSTOMER_CUST_ACCOUNT_ID;
885 END IF;
886
887 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
888 p_control_rec.defaulting_flow_code like 'CREATE%' AND
889 P_Quote_Header_Rec.END_CUSTOMER_PARTY_SITE_ID IS NULL THEN
890 X_Qte_Opportunity_Row_Rec.O_END_CUST_PTY_SITE_ID := FND_API.G_MISS_NUM;
891 ELSE
892 X_Qte_Opportunity_Row_Rec.O_END_CUST_PTY_SITE_ID := P_Quote_Header_Rec.END_CUSTOMER_PARTY_SITE_ID ;
893 END IF;
894
895 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
896 p_control_rec.defaulting_flow_code like 'CREATE%' AND
897 P_Quote_Header_Rec.END_CUSTOMER_PARTY_ID IS NULL THEN
898 X_Qte_Opportunity_Row_Rec.O_END_CUST_PTY_ID := FND_API.G_MISS_NUM;
899 ELSE
900 X_Qte_Opportunity_Row_Rec.O_END_CUST_PTY_ID := P_Quote_Header_Rec.END_CUSTOMER_PARTY_ID;
901 END IF;
902
903 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
904 p_control_rec.defaulting_flow_code like 'CREATE%' AND
905 P_Quote_Header_Rec.AUTOMATIC_PRICE_FLAG IS NULL THEN
906 X_Qte_Opportunity_Row_Rec.O_AUTOMATIC_PRICE_FLAG := FND_API.G_MISS_CHAR;
907 ELSE
908 X_Qte_Opportunity_Row_Rec.O_AUTOMATIC_PRICE_FLAG := P_Quote_Header_Rec.AUTOMATIC_PRICE_FLAG ;
909 END IF;
910
911 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
912 p_control_rec.defaulting_flow_code like 'CREATE%' AND
913 P_Quote_Header_Rec.AUTOMATIC_TAX_FLAG IS NULL THEN
914 X_Qte_Opportunity_Row_Rec.O_AUTOMATIC_TAX_FLAG := FND_API.G_MISS_CHAR;
915 ELSE
916 X_Qte_Opportunity_Row_Rec.O_AUTOMATIC_TAX_FLAG := P_Quote_Header_Rec.AUTOMATIC_TAX_FLAG;
917 END IF;
918
919 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
920 p_control_rec.defaulting_flow_code like 'CREATE%' AND
921 P_Quote_Header_Rec.LAST_UPDATE_DATE IS NULL THEN
922 X_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
923 ELSE
924 X_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE := P_Quote_Header_Rec.LAST_UPDATE_DATE;
925 END IF;
926
927 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
928 p_control_rec.defaulting_flow_code like 'CREATE%' AND
929 P_Quote_Header_Rec.OBJECT_VERSION_NUMBER IS NULL THEN
930 X_Qte_Opportunity_Row_Rec.O_OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
931 ELSE
932 X_Qte_Opportunity_Row_Rec.O_OBJECT_VERSION_NUMBER := P_Quote_Header_Rec.OBJECT_VERSION_NUMBER ;
933 END IF;
934
935 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
936 p_control_rec.defaulting_flow_code like 'CREATE%' AND
937 P_Quote_Header_Rec.ATTRIBUTE_CATEGORY IS NULL THEN
938 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
939 ELSE
940 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE_CATEGORY := P_Quote_Header_Rec.ATTRIBUTE_CATEGORY;
941 END IF;
942
943 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
944 p_control_rec.defaulting_flow_code like 'CREATE%' AND
945 P_Quote_Header_Rec.ATTRIBUTE1 IS NULL THEN
946 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
947 ELSE
948 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE1 := P_Quote_Header_Rec.ATTRIBUTE1;
949 END IF;
950
951 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
952 p_control_rec.defaulting_flow_code like 'CREATE%' AND
953 P_Quote_Header_Rec.ATTRIBUTE2 IS NULL THEN
954 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
955 ELSE
956 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE2 := P_Quote_Header_Rec.ATTRIBUTE2;
957 END IF;
958
959 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
960 p_control_rec.defaulting_flow_code like 'CREATE%' AND
961 P_Quote_Header_Rec.ATTRIBUTE3 IS NULL THEN
962 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
963 ELSE
964 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE3 := P_Quote_Header_Rec.ATTRIBUTE3;
965 END IF;
966
967 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
968 p_control_rec.defaulting_flow_code like 'CREATE%' AND
969 P_Quote_Header_Rec.ATTRIBUTE4 IS NULL THEN
970 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
971 ELSE
972 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE4 := P_Quote_Header_Rec.ATTRIBUTE4;
973 END IF;
974
975 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
976 p_control_rec.defaulting_flow_code like 'CREATE%' AND
977 P_Quote_Header_Rec.ATTRIBUTE5 IS NULL THEN
978 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
979 ELSE
980 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE5 := P_Quote_Header_Rec.ATTRIBUTE5;
981 END IF;
982
983 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
984 p_control_rec.defaulting_flow_code like 'CREATE%' AND
985 P_Quote_Header_Rec.ATTRIBUTE6 IS NULL THEN
986 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
987 ELSE
988 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE6 := P_Quote_Header_Rec.ATTRIBUTE6;
989 END IF;
990
991 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
992 p_control_rec.defaulting_flow_code like 'CREATE%' AND
993 P_Quote_Header_Rec.ATTRIBUTE7 IS NULL THEN
994 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
995 ELSE
996 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE7 := P_Quote_Header_Rec.ATTRIBUTE7;
997 END IF;
998
999 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1000 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1001 P_Quote_Header_Rec.ATTRIBUTE8 IS NULL THEN
1002 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1003 ELSE
1004 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE8 := P_Quote_Header_Rec.ATTRIBUTE8;
1005 END IF;
1006
1007 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1008 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1009 P_Quote_Header_Rec.ATTRIBUTE9 IS NULL THEN
1010 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1011 ELSE
1012 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE9 := P_Quote_Header_Rec.ATTRIBUTE9;
1013 END IF;
1014
1015 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1016 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1017 P_Quote_Header_Rec.ATTRIBUTE10 IS NULL THEN
1018 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1019 ELSE
1020 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE10 := P_Quote_Header_Rec.ATTRIBUTE10;
1021 END IF;
1022
1023 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1024 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1025 P_Quote_Header_Rec.ATTRIBUTE11 IS NULL THEN
1026 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1027 ELSE
1028 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE11 := P_Quote_Header_Rec.ATTRIBUTE11;
1029 END IF;
1030
1031 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1032 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1033 P_Quote_Header_Rec.ATTRIBUTE12 IS NULL THEN
1034 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1035 ELSE
1036 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE12 := P_Quote_Header_Rec.ATTRIBUTE12;
1037 END IF;
1038
1039 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1040 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1041 P_Quote_Header_Rec.ATTRIBUTE13 IS NULL THEN
1042 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1043 ELSE
1044 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE13 := P_Quote_Header_Rec.ATTRIBUTE13;
1045 END IF;
1046
1047 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1048 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1049 P_Quote_Header_Rec.ATTRIBUTE14 IS NULL THEN
1050 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1051 ELSE
1052 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE14 := P_Quote_Header_Rec.ATTRIBUTE14;
1053 END IF;
1054
1055 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1056 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1057 P_Quote_Header_Rec.ATTRIBUTE15 IS NULL THEN
1058 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1059 ELSE
1060 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE15 := P_Quote_Header_Rec.ATTRIBUTE15;
1061 END IF;
1062
1063 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1064 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1065 P_Quote_Header_Rec.ATTRIBUTE16 IS NULL THEN
1066 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
1067 ELSE
1068 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE16 := P_Quote_Header_Rec.ATTRIBUTE16;
1069 END IF;
1070
1071 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1072 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1073 P_Quote_Header_Rec.ATTRIBUTE17 IS NULL THEN
1074 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
1075 ELSE
1076 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE17 := P_Quote_Header_Rec.ATTRIBUTE17;
1077 END IF;
1078
1079 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1080 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1081 P_Quote_Header_Rec.ATTRIBUTE18 IS NULL THEN
1082 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
1083 ELSE
1084 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE18 := P_Quote_Header_Rec.ATTRIBUTE18;
1085 END IF;
1086
1087 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1088 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1089 P_Quote_Header_Rec.ATTRIBUTE19 IS NULL THEN
1090 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
1091 ELSE
1092 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE19 := P_Quote_Header_Rec.ATTRIBUTE19;
1093 END IF;
1094
1095 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1096 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1097 P_Quote_Header_Rec.ATTRIBUTE20 IS NULL THEN
1098 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
1099 ELSE
1100 X_Qte_Opportunity_Row_Rec.O_ATTRIBUTE20 := P_Quote_Header_Rec.ATTRIBUTE20;
1101 END IF;
1102
1103 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1104 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1105 P_Header_Shipment_Rec.SHIP_TO_CUST_PARTY_ID IS NULL THEN
1106 X_Qte_Opportunity_Row_Rec.O_SHIP_TO_CUST_PTY_ID := FND_API.G_MISS_NUM;
1107 ELSE
1108 X_Qte_Opportunity_Row_Rec.O_SHIP_TO_CUST_PTY_ID :=P_Header_Shipment_Rec.SHIP_TO_CUST_PARTY_ID;
1109 END IF;
1110
1111 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1112 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1113 P_Header_Shipment_Rec.SHIP_TO_CUST_ACCOUNT_ID IS NULL THEN
1114 X_Qte_Opportunity_Row_Rec.O_SHIP_TO_CUST_ACCT_ID := FND_API.G_MISS_NUM;
1115 ELSE
1116 X_Qte_Opportunity_Row_Rec.O_SHIP_TO_CUST_ACCT_ID := P_Header_Shipment_Rec.SHIP_TO_CUST_ACCOUNT_ID;
1117 END IF;
1118
1119 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1120 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1121 P_Header_Shipment_Rec.SHIP_TO_PARTY_SITE_ID IS NULL THEN
1122 X_Qte_Opportunity_Row_Rec.O_SHIP_TO_PTY_SITE_ID := FND_API.G_MISS_NUM;
1123 ELSE
1124 X_Qte_Opportunity_Row_Rec.O_SHIP_TO_PTY_SITE_ID := P_Header_Shipment_Rec.SHIP_TO_PARTY_SITE_ID;
1125 END IF;
1126
1127 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1128 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1129 P_Header_Shipment_Rec.SHIP_TO_PARTY_ID IS NULL THEN
1130 X_Qte_Opportunity_Row_Rec.O_SHIP_TO_PTY_ID := FND_API.G_MISS_NUM;
1131 ELSE
1132 X_Qte_Opportunity_Row_Rec.O_SHIP_TO_PTY_ID := P_Header_Shipment_Rec.SHIP_TO_PARTY_ID;
1133 END IF;
1134
1135 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1136 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1137 P_Header_Payment_Rec.PAYMENT_TERM_ID IS NULL THEN
1138 X_Qte_Opportunity_Row_Rec.O_PAYMENT_TERM_ID := FND_API.G_MISS_NUM;
1139 ELSE
1140 X_Qte_Opportunity_Row_Rec.O_PAYMENT_TERM_ID := P_Header_Payment_Rec.PAYMENT_TERM_ID;
1141 END IF;
1142
1143 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1144 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1145 P_Header_Payment_Rec.CUST_PO_NUMBER IS NULL THEN
1146 X_Qte_Opportunity_Row_Rec.O_CUST_PO_NUMBER := FND_API.G_MISS_CHAR;
1147 ELSE
1148 X_Qte_Opportunity_Row_Rec.O_CUST_PO_NUMBER := P_Header_Payment_Rec.CUST_PO_NUMBER ;
1149 END IF;
1150
1151 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1152 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1153 P_Header_Payment_Rec.CREDIT_CARD_CODE IS NULL THEN
1154 X_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
1155 ELSE
1156 X_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_CODE := P_Header_Payment_Rec.CREDIT_CARD_CODE ;
1157 END IF;
1158
1159 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1160 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1161 P_Header_Payment_Rec.PAYMENT_REF_NUMBER IS NULL THEN
1162 X_Qte_Opportunity_Row_Rec.O_PAYMENT_REF_NUMBER := FND_API.G_MISS_CHAR;
1163 ELSE
1164 X_Qte_Opportunity_Row_Rec.O_PAYMENT_REF_NUMBER := P_Header_Payment_Rec.PAYMENT_REF_NUMBER ;
1165 END IF;
1166
1167 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1168 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1169 P_Header_Payment_Rec.CREDIT_CARD_HOLDER_NAME IS NULL THEN
1170 X_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_HLD_NAME := FND_API.G_MISS_CHAR;
1171 ELSE
1172 X_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_HLD_NAME := P_Header_Payment_Rec.CREDIT_CARD_HOLDER_NAME ;
1173 END IF;
1174
1175 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1176 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1177 P_Header_Payment_Rec.CREDIT_CARD_EXPIRATION_DATE IS NULL THEN
1178 X_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_EXP_DATE := FND_API.G_MISS_DATE;
1179 ELSE
1180 X_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_EXP_DATE := P_Header_Payment_Rec.CREDIT_CARD_EXPIRATION_DATE ;
1181 END IF;
1182
1183 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1184 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1185 P_Header_Payment_Rec.PAYMENT_TYPE_CODE IS NULL THEN
1186 X_Qte_Opportunity_Row_Rec.O_PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
1187 ELSE
1188 X_Qte_Opportunity_Row_Rec.O_PAYMENT_TYPE_CODE := P_Header_Payment_Rec.PAYMENT_TYPE_CODE ;
1189 END IF;
1190
1191 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1192 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1193 P_Header_Shipment_Rec.REQUEST_DATE_TYPE IS NULL THEN
1194 X_Qte_Opportunity_Row_Rec.O_REQUEST_DATE_TYPE := FND_API.G_MISS_CHAR;
1195 ELSE
1196 X_Qte_Opportunity_Row_Rec.O_REQUEST_DATE_TYPE := P_Header_Shipment_Rec.REQUEST_DATE_TYPE ;
1197 END IF;
1198
1199 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1200 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1201 P_Header_Shipment_Rec.REQUEST_DATE IS NULL THEN
1202 X_Qte_Opportunity_Row_Rec.O_REQUEST_DATE := FND_API.G_MISS_DATE;
1203 ELSE
1204 X_Qte_Opportunity_Row_Rec.O_REQUEST_DATE := P_Header_Shipment_Rec.REQUEST_DATE ;
1205 END IF;
1206
1207 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1208 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1209 P_Header_Shipment_Rec.SHIP_METHOD_CODE IS NULL THEN
1210 X_Qte_Opportunity_Row_Rec.O_SHIP_METHOD_CODE := FND_API.G_MISS_CHAR;
1211 ELSE
1212 X_Qte_Opportunity_Row_Rec.O_SHIP_METHOD_CODE := P_Header_Shipment_Rec.SHIP_METHOD_CODE;
1213 END IF;
1214
1215 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1216 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1217 P_Header_Shipment_Rec.SHIPMENT_PRIORITY_CODE IS NULL THEN
1218 X_Qte_Opportunity_Row_Rec.O_SHIPMENT_PRIORITY_CODE := FND_API.G_MISS_CHAR;
1219 ELSE
1220 X_Qte_Opportunity_Row_Rec.O_SHIPMENT_PRIORITY_CODE := P_Header_Shipment_Rec.SHIPMENT_PRIORITY_CODE;
1221 END IF;
1222
1223 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1224 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1225 P_Header_Shipment_Rec.FREIGHT_TERMS_CODE IS NULL THEN
1226 X_Qte_Opportunity_Row_Rec.O_FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;
1227 ELSE
1228 X_Qte_Opportunity_Row_Rec.O_FREIGHT_TERMS_CODE := P_Header_Shipment_Rec.FREIGHT_TERMS_CODE;
1229 END IF;
1230
1231 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1232 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1233 P_Header_Shipment_Rec.FOB_CODE IS NULL THEN
1234 X_Qte_Opportunity_Row_Rec.O_FOB_CODE := FND_API.G_MISS_CHAR;
1235 ELSE
1236 X_Qte_Opportunity_Row_Rec.O_FOB_CODE := P_Header_Shipment_Rec.FOB_CODE;
1237 END IF;
1238
1239 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1240 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1241 P_Header_Shipment_Rec.SHIPPING_INSTRUCTIONS IS NULL THEN
1242 X_Qte_Opportunity_Row_Rec.O_SHIPPING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
1243 ELSE
1244 X_Qte_Opportunity_Row_Rec.O_SHIPPING_INSTRUCTIONS := P_Header_Shipment_Rec.SHIPPING_INSTRUCTIONS;
1245 END IF;
1246
1247 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1248 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1249 P_Header_Shipment_Rec.PACKING_INSTRUCTIONS IS NULL THEN
1250 X_Qte_Opportunity_Row_Rec.O_PACKING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
1251 ELSE
1252 X_Qte_Opportunity_Row_Rec.O_PACKING_INSTRUCTIONS := P_Header_Shipment_Rec.PACKING_INSTRUCTIONS;
1253 END IF;
1254
1255 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1256 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1257 P_Header_Shipment_Rec.DEMAND_CLASS_CODE IS NULL THEN
1258 X_Qte_Opportunity_Row_Rec.O_DEMAND_CLASS_CODE := FND_API.G_MISS_CHAR;
1259 ELSE
1260 X_Qte_Opportunity_Row_Rec.O_DEMAND_CLASS_CODE := P_Header_Shipment_Rec.DEMAND_CLASS_CODE;
1261 END IF;
1262
1263 X_Qte_Opportunity_Row_Rec.O_APPLICATION_TYPE_CODE := P_Control_Rec.APPLICATION_TYPE_CODE;
1264
1265 OPEN C_Party_Type(P_Quote_Header_Rec.CUST_PARTY_ID);
1266 FETCH C_Party_Type INTO X_Qte_Opportunity_Row_Rec.O_QUOTE_TO_CUST_TYPE;
1267 CLOSE C_Party_Type;
1268
1269
1270 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1271 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1272 P_Opp_Qte_Header_Rec.OPPORTUNITY_ID IS NULL THEN
1273 X_Qte_Opportunity_Row_Rec.O_OPPTY_ID := FND_API.G_MISS_NUM;
1274 ELSE
1275 X_Qte_Opportunity_Row_Rec.O_OPPTY_ID := P_Opp_Qte_Header_Rec.OPPORTUNITY_ID;
1276 END IF;
1277
1278 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1279 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1280 P_Opp_Qte_Header_Rec.CURRENCY_CODE IS NULL THEN
1281 X_Qte_Opportunity_Row_Rec.O_OPPTY_CURRENCY_CODE := FND_API.G_MISS_CHAR;
1282 ELSE
1283 X_Qte_Opportunity_Row_Rec.O_OPPTY_CURRENCY_CODE := P_Opp_Qte_Header_Rec.CURRENCY_CODE;
1284 END IF;
1285
1286 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1287 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1288 P_Opp_Qte_Header_Rec.CHANNEL_CODE IS NULL THEN
1289 X_Qte_Opportunity_Row_Rec.O_OPPTY_CHANNEL_CODE := FND_API.G_MISS_CHAR;
1290 ELSE
1291 X_Qte_Opportunity_Row_Rec.O_OPPTY_CHANNEL_CODE := P_Opp_Qte_Header_Rec.CHANNEL_CODE;
1292 END IF;
1293
1294 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1295 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1296 P_Opp_Qte_Header_Rec.QUOTE_NAME IS NULL THEN
1297 X_Qte_Opportunity_Row_Rec.O_OPPTY_QUOTE_NAME := FND_API.G_MISS_CHAR;
1298 ELSE
1299 X_Qte_Opportunity_Row_Rec.O_OPPTY_QUOTE_NAME := P_Opp_Qte_Header_Rec.QUOTE_NAME;
1300 END IF;
1301
1302 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1303 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1304 P_Opp_Qte_Header_Rec.CUST_PARTY_ID IS NULL THEN
1305 X_Qte_Opportunity_Row_Rec.O_OPPTY_CUST_PARTY_ID := FND_API.G_MISS_NUM;
1306 ELSE
1307 X_Qte_Opportunity_Row_Rec.O_OPPTY_CUST_PARTY_ID := P_Opp_Qte_Header_Rec.CUST_PARTY_ID;
1308 END IF;
1309
1310 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1311 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1312 P_Opp_Qte_Header_Rec.MARKETING_SOURCE_CODE_ID IS NULL THEN
1313 X_Qte_Opportunity_Row_Rec.O_OPPTY_MKTG_SRC_CD_ID := FND_API.G_MISS_NUM;
1314 ELSE
1315 X_Qte_Opportunity_Row_Rec.O_OPPTY_MKTG_SRC_CD_ID := P_Opp_Qte_Header_Rec.MARKETING_SOURCE_CODE_ID;
1316 END IF;
1317
1318 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1319 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1320 P_Opp_Qte_Header_Rec.SOLD_TO_PARTY_SITE_ID IS NULL THEN
1321 X_Qte_Opportunity_Row_Rec.O_OPPTY_SLD_PTY_ST_ID := FND_API.G_MISS_NUM;
1322 ELSE
1323 X_Qte_Opportunity_Row_Rec.O_OPPTY_SLD_PTY_ST_ID := P_Opp_Qte_Header_Rec.SOLD_TO_PARTY_SITE_ID;
1324 END IF;
1325
1326 IF P_Control_Rec.APPLICATION_TYPE_CODE = 'QUOTING HTML' AND
1327 p_control_rec.defaulting_flow_code like 'CREATE%' AND
1328 P_Opp_Qte_Header_Rec.SOLD_TO_CONTACT_ID IS NULL THEN
1329 X_Qte_Opportunity_Row_Rec.O_OPPTY_SLD_TO_CONT_ID := FND_API.G_MISS_NUM;
1330 ELSE
1331 X_Qte_Opportunity_Row_Rec.O_OPPTY_SLD_TO_CONT_ID := P_Opp_Qte_Header_Rec.SOLD_TO_CONTACT_ID;
1332 END IF;
1333
1334 ELSIF P_Entity_Code = 'QUOTE_LINE' THEN
1335
1336 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1337 P_Quote_Line_Rec.QUOTE_HEADER_ID IS NULL THEN
1338 X_Qte_Line_Row_Rec.L_QUOTE_HEADER_ID := FND_API.G_MISS_NUM;
1339 ELSE
1340 X_Qte_Line_Row_Rec.L_QUOTE_HEADER_ID := P_Quote_Line_Rec.QUOTE_HEADER_ID;
1341 END IF;
1342
1343 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1344 P_Quote_Line_Rec.QUOTE_LINE_ID IS NULL THEN
1345 X_Qte_Line_Row_Rec.L_QUOTE_LINE_ID := FND_API.G_MISS_NUM;
1346 ELSE
1347 X_Qte_Line_Row_Rec.L_QUOTE_LINE_ID := P_Quote_Line_Rec.QUOTE_LINE_ID;
1348 END IF;
1349
1350 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1351 P_Quote_Line_Rec.LAST_UPDATE_DATE IS NULL THEN
1352 X_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
1353 ELSE
1354 X_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE := P_Quote_Line_Rec.LAST_UPDATE_DATE;
1355 END IF;
1356
1357 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1358 P_Quote_Line_Rec.OBJECT_VERSION_NUMBER IS NULL THEN
1359 X_Qte_Line_Row_Rec.L_OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
1360 ELSE
1361 X_Qte_Line_Row_Rec.L_OBJECT_VERSION_NUMBER := P_Quote_Line_Rec.OBJECT_VERSION_NUMBER;
1362 END IF;
1363
1364 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1365 P_Quote_Line_Rec.ATTRIBUTE_CATEGORY IS NULL THEN
1366 X_Qte_Line_Row_Rec.L_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
1367 ELSE
1368 X_Qte_Line_Row_Rec.L_ATTRIBUTE_CATEGORY := P_Quote_Line_Rec.ATTRIBUTE_CATEGORY;
1369 END IF;
1370
1371 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1372 P_Quote_Line_Rec.ATTRIBUTE1 IS NULL THEN
1373 X_Qte_Line_Row_Rec.L_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1374 ELSE
1375 X_Qte_Line_Row_Rec.L_ATTRIBUTE1 := P_Quote_Line_Rec.ATTRIBUTE1;
1376 END IF;
1377
1378 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1379 P_Quote_Line_Rec.ATTRIBUTE2 IS NULL THEN
1380 X_Qte_Line_Row_Rec.L_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1381 ELSE
1382 X_Qte_Line_Row_Rec.L_ATTRIBUTE2 := P_Quote_Line_Rec.ATTRIBUTE2;
1383 END IF;
1384
1385 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1386 P_Quote_Line_Rec.ATTRIBUTE3 IS NULL THEN
1387 X_Qte_Line_Row_Rec.L_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
1388 ELSE
1389 X_Qte_Line_Row_Rec.L_ATTRIBUTE3 := P_Quote_Line_Rec.ATTRIBUTE3;
1390 END IF;
1391
1392 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1393 P_Quote_Line_Rec.ATTRIBUTE4 IS NULL THEN
1394 X_Qte_Line_Row_Rec.L_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
1395 ELSE
1396 X_Qte_Line_Row_Rec.L_ATTRIBUTE4 := P_Quote_Line_Rec.ATTRIBUTE4;
1397 END IF;
1398
1399 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1400 P_Quote_Line_Rec.ATTRIBUTE5 IS NULL THEN
1401 X_Qte_Line_Row_Rec.L_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
1402 ELSE
1403 X_Qte_Line_Row_Rec.L_ATTRIBUTE5 := P_Quote_Line_Rec.ATTRIBUTE5;
1404 END IF;
1405
1406 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1407 P_Quote_Line_Rec.ATTRIBUTE6 IS NULL THEN
1408 X_Qte_Line_Row_Rec.L_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
1409 ELSE
1410 X_Qte_Line_Row_Rec.L_ATTRIBUTE6 := P_Quote_Line_Rec.ATTRIBUTE6;
1411 END IF;
1412
1413 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1414 P_Quote_Line_Rec.ATTRIBUTE7 IS NULL THEN
1415 X_Qte_Line_Row_Rec.L_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
1416 ELSE
1417 X_Qte_Line_Row_Rec.L_ATTRIBUTE7 := P_Quote_Line_Rec.ATTRIBUTE7;
1418 END IF;
1419
1420 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1421 P_Quote_Line_Rec.ATTRIBUTE8 IS NULL THEN
1422 X_Qte_Line_Row_Rec.L_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
1423 ELSE
1424 X_Qte_Line_Row_Rec.L_ATTRIBUTE8 := P_Quote_Line_Rec.ATTRIBUTE8;
1425 END IF;
1426
1427 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1428 P_Quote_Line_Rec.ATTRIBUTE9 IS NULL THEN
1429 X_Qte_Line_Row_Rec.L_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
1430 ELSE
1431 X_Qte_Line_Row_Rec.L_ATTRIBUTE9 := P_Quote_Line_Rec.ATTRIBUTE9;
1432 END IF;
1433
1434 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1435 P_Quote_Line_Rec.ATTRIBUTE10 IS NULL THEN
1436 X_Qte_Line_Row_Rec.L_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
1437 ELSE
1438 X_Qte_Line_Row_Rec.L_ATTRIBUTE10 := P_Quote_Line_Rec.ATTRIBUTE10;
1439 END IF;
1440
1441 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1442 P_Quote_Line_Rec.ATTRIBUTE11 IS NULL THEN
1443 X_Qte_Line_Row_Rec.L_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
1444 ELSE
1445 X_Qte_Line_Row_Rec.L_ATTRIBUTE11 := P_Quote_Line_Rec.ATTRIBUTE11;
1446 END IF;
1447
1448 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1449 P_Quote_Line_Rec.ATTRIBUTE12 IS NULL THEN
1450 X_Qte_Line_Row_Rec.L_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
1451 ELSE
1452 X_Qte_Line_Row_Rec.L_ATTRIBUTE12 := P_Quote_Line_Rec.ATTRIBUTE12;
1453 END IF;
1454
1455 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1456 P_Quote_Line_Rec.ATTRIBUTE13 IS NULL THEN
1457 X_Qte_Line_Row_Rec.L_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
1458 ELSE
1459 X_Qte_Line_Row_Rec.L_ATTRIBUTE13 := P_Quote_Line_Rec.ATTRIBUTE13;
1460 END IF;
1461
1462 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1463 P_Quote_Line_Rec.ATTRIBUTE14 IS NULL THEN
1464 X_Qte_Line_Row_Rec.L_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
1465 ELSE
1466 X_Qte_Line_Row_Rec.L_ATTRIBUTE14 := P_Quote_Line_Rec.ATTRIBUTE14;
1467 END IF;
1468
1469 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1470 P_Quote_Line_Rec.ATTRIBUTE15 IS NULL THEN
1471 X_Qte_Line_Row_Rec.L_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
1472 ELSE
1473 X_Qte_Line_Row_Rec.L_ATTRIBUTE15 := P_Quote_Line_Rec.ATTRIBUTE15;
1474 END IF;
1475
1476 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1477 P_Quote_Line_Rec.ATTRIBUTE16 IS NULL THEN
1478 X_Qte_Line_Row_Rec.L_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
1479 ELSE
1480 X_Qte_Line_Row_Rec.L_ATTRIBUTE16 := P_Quote_Line_Rec.ATTRIBUTE16;
1481 END IF;
1482
1483 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1484 P_Quote_Line_Rec.ATTRIBUTE17 IS NULL THEN
1485 X_Qte_Line_Row_Rec.L_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
1486 ELSE
1487 X_Qte_Line_Row_Rec.L_ATTRIBUTE17 := P_Quote_Line_Rec.ATTRIBUTE17;
1488 END IF;
1489
1490 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1491 P_Quote_Line_Rec.ATTRIBUTE18 IS NULL THEN
1492 X_Qte_Line_Row_Rec.L_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
1493 ELSE
1494 X_Qte_Line_Row_Rec.L_ATTRIBUTE18 := P_Quote_Line_Rec.ATTRIBUTE18;
1495 END IF;
1496
1497 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1498 P_Quote_Line_Rec.ATTRIBUTE19 IS NULL THEN
1499 X_Qte_Line_Row_Rec.L_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
1500 ELSE
1501 X_Qte_Line_Row_Rec.L_ATTRIBUTE19 := P_Quote_Line_Rec.ATTRIBUTE19;
1502 END IF;
1503
1504 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1505 P_Quote_Line_Rec.ATTRIBUTE20 IS NULL THEN
1506 X_Qte_Line_Row_Rec.L_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
1507 ELSE
1508 X_Qte_Line_Row_Rec.L_ATTRIBUTE20 := P_Quote_Line_Rec.ATTRIBUTE20;
1509 END IF;
1510
1511 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1512 P_Quote_Line_Rec.CREATED_BY IS NULL THEN
1513 X_Qte_Line_Row_Rec.L_CREATED_BY := FND_API.G_MISS_CHAR;
1514 ELSE
1515 X_Qte_Line_Row_Rec.L_CREATED_BY := P_Quote_Line_Rec.CREATED_BY;
1516 END IF;
1517
1518 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1519 P_Quote_Line_Rec.ORG_ID IS NULL THEN
1520 X_Qte_Line_Row_Rec.L_ORG_ID := FND_API.G_MISS_NUM;
1521 ELSE
1522 X_Qte_Line_Row_Rec.L_ORG_ID := P_Quote_Line_Rec.ORG_ID;
1523 END IF;
1524
1525 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1526 P_Quote_Line_Rec.ORDER_LINE_TYPE_ID IS NULL THEN
1527 X_Qte_Line_Row_Rec.L_ORDER_LINE_TYPE_ID := FND_API.G_MISS_NUM;
1528 ELSE
1529 X_Qte_Line_Row_Rec.L_ORDER_LINE_TYPE_ID := P_Quote_Line_Rec.ORDER_LINE_TYPE_ID;
1530 END IF;
1531
1532 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1533 P_Quote_Line_Rec.LINE_CATEGORY_CODE IS NULL THEN
1534 X_Qte_Line_Row_Rec.L_LINE_CATEGORY_CODE := FND_API.G_MISS_CHAR;
1535 ELSE
1536 X_Qte_Line_Row_Rec.L_LINE_CATEGORY_CODE := P_Quote_Line_Rec.LINE_CATEGORY_CODE;
1537 END IF;
1538
1539 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1540 P_Quote_Line_Rec.CHARGE_PERIODICITY_CODE IS NULL THEN
1541 X_Qte_Line_Row_Rec.L_PERIODICITY_CODE := FND_API.G_MISS_CHAR;
1542 ELSE
1543 X_Qte_Line_Row_Rec.L_PERIODICITY_CODE := P_Quote_Line_Rec.CHARGE_PERIODICITY_CODE;
1544 END IF;
1545
1546 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1547 P_Quote_Line_Rec.AGREEMENT_ID IS NULL THEN
1548 X_Qte_Line_Row_Rec.L_AGREEMENT_ID := FND_API.G_MISS_NUM;
1549 ELSE
1550 X_Qte_Line_Row_Rec.L_AGREEMENT_ID := P_Quote_Line_Rec.AGREEMENT_ID;
1551 END IF;
1552
1553 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1554 P_Quote_Line_Rec.PRICE_LIST_ID IS NULL THEN
1555 X_Qte_Line_Row_Rec.L_PRICE_LIST_ID := FND_API.G_MISS_NUM;
1556 ELSE
1557 X_Qte_Line_Row_Rec.L_PRICE_LIST_ID := P_Quote_Line_Rec.PRICE_LIST_ID;
1558 END IF;
1559
1560 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1561 P_Quote_Line_Rec.INVOICE_TO_CUST_ACCOUNT_ID IS NULL THEN
1562 X_Qte_Line_Row_Rec.L_INV_TO_CUST_ACCT_ID := FND_API.G_MISS_NUM;
1563 ELSE
1564 X_Qte_Line_Row_Rec.L_INV_TO_CUST_ACCT_ID := P_Quote_Line_Rec.INVOICE_TO_CUST_ACCOUNT_ID;
1565 END IF;
1566
1567 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1568 P_Quote_Line_Rec.INVOICE_TO_CUST_PARTY_ID IS NULL THEN
1569 X_Qte_Line_Row_Rec.L_INV_TO_CUST_PTY_ID := FND_API.G_MISS_NUM;
1570 ELSE
1571 X_Qte_Line_Row_Rec.L_INV_TO_CUST_PTY_ID := P_Quote_Line_Rec.INVOICE_TO_CUST_PARTY_ID;
1572 END IF;
1573
1574 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1575 P_Quote_Line_Rec.INVOICE_TO_PARTY_ID IS NULL THEN
1576 X_Qte_Line_Row_Rec.L_INV_TO_PTY_ID := FND_API.G_MISS_NUM;
1577 ELSE
1578 X_Qte_Line_Row_Rec.L_INV_TO_PTY_ID := P_Quote_Line_Rec.INVOICE_TO_PARTY_ID;
1579 END IF;
1580
1581 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1582 P_Quote_Line_Rec.INVOICE_TO_PARTY_SITE_ID IS NULL THEN
1583 X_Qte_Line_Row_Rec.L_INV_TO_PTY_SITE_ID := FND_API.G_MISS_NUM;
1584 ELSE
1585 X_Qte_Line_Row_Rec.L_INV_TO_PTY_SITE_ID := P_Quote_Line_Rec.INVOICE_TO_PARTY_SITE_ID;
1586 END IF;
1587
1588 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1589 P_Line_Shipment_Rec.SHIP_TO_CUST_ACCOUNT_ID IS NULL THEN
1590 X_Qte_Line_Row_Rec.L_SHIP_TO_CUST_ACCT_ID := FND_API.G_MISS_NUM;
1591 ELSE
1592 X_Qte_Line_Row_Rec.L_SHIP_TO_CUST_ACCT_ID := P_Line_Shipment_Rec.SHIP_TO_CUST_ACCOUNT_ID;
1593 END IF;
1594
1595 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1596 P_Line_Shipment_Rec.SHIP_TO_CUST_PARTY_ID IS NULL THEN
1597 X_Qte_Line_Row_Rec.L_SHIP_TO_CUST_PARTY_ID := FND_API.G_MISS_NUM;
1598 ELSE
1599 X_Qte_Line_Row_Rec.L_SHIP_TO_CUST_PARTY_ID := P_Line_Shipment_Rec.SHIP_TO_CUST_PARTY_ID;
1600 END IF;
1601
1602 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1603 P_Line_Shipment_Rec.SHIP_TO_PARTY_ID IS NULL THEN
1604 X_Qte_Line_Row_Rec.L_SHIP_TO_PARTY_ID := FND_API.G_MISS_NUM;
1605 ELSE
1606 X_Qte_Line_Row_Rec.L_SHIP_TO_PARTY_ID := P_Line_Shipment_Rec.SHIP_TO_PARTY_ID;
1607 END IF;
1608
1609 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1610 P_Line_Shipment_Rec.SHIP_TO_PARTY_SITE_ID IS NULL THEN
1611 X_Qte_Line_Row_Rec.L_SHIP_TO_PARTY_SITE_ID := FND_API.G_MISS_NUM;
1612 ELSE
1613 X_Qte_Line_Row_Rec.L_SHIP_TO_PARTY_SITE_ID := P_Line_Shipment_Rec.SHIP_TO_PARTY_SITE_ID;
1614 END IF;
1615
1616 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1617 P_Quote_Line_Rec.END_CUSTOMER_CUST_ACCOUNT_ID IS NULL THEN
1618 X_Qte_Line_Row_Rec.L_END_CUST_CUST_ACCT_ID := FND_API.G_MISS_NUM;
1619 ELSE
1620 X_Qte_Line_Row_Rec.L_END_CUST_CUST_ACCT_ID := P_Quote_Line_Rec.END_CUSTOMER_CUST_ACCOUNT_ID;
1621 END IF;
1622
1623 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1624 P_Quote_Line_Rec.END_CUSTOMER_CUST_PARTY_ID IS NULL THEN
1625 X_Qte_Line_Row_Rec.L_END_CUST_CUST_PTY_ID := FND_API.G_MISS_NUM;
1626 ELSE
1627 X_Qte_Line_Row_Rec.L_END_CUST_CUST_PTY_ID := P_Quote_Line_Rec.END_CUSTOMER_CUST_PARTY_ID;
1628 END IF;
1629
1630 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1631 P_Quote_Line_Rec.END_CUSTOMER_PARTY_ID IS NULL THEN
1632 X_Qte_Line_Row_Rec.L_END_CUST_PTY_ID := FND_API.G_MISS_NUM;
1633 ELSE
1634 X_Qte_Line_Row_Rec.L_END_CUST_PTY_ID := P_Quote_Line_Rec.END_CUSTOMER_PARTY_ID;
1635 END IF;
1636
1637 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1638 P_Quote_Line_Rec.END_CUSTOMER_PARTY_SITE_ID IS NULL THEN
1639 X_Qte_Line_Row_Rec.L_END_CUST_PTY_SITE_ID := FND_API.G_MISS_NUM;
1640 ELSE
1641 X_Qte_Line_Row_Rec.L_END_CUST_PTY_SITE_ID := P_Quote_Line_Rec.END_CUSTOMER_PARTY_SITE_ID;
1642 END IF;
1643
1644 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1645 P_Line_Payment_Rec.CREDIT_CARD_CODE IS NULL THEN
1646 X_Qte_Line_Row_Rec.L_CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
1647 ELSE
1648 X_Qte_Line_Row_Rec.L_CREDIT_CARD_CODE := P_Line_Payment_Rec.CREDIT_CARD_CODE;
1649 END IF;
1650
1651 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1652 P_Line_Payment_Rec.CREDIT_CARD_EXPIRATION_DATE IS NULL THEN
1653 X_Qte_Line_Row_Rec.L_CREDIT_CARD_EXP_DATE := FND_API.G_MISS_DATE;
1654 ELSE
1655 X_Qte_Line_Row_Rec.L_CREDIT_CARD_EXP_DATE := P_Line_Payment_Rec.CREDIT_CARD_EXPIRATION_DATE;
1656 END IF;
1657
1658 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1659 P_Line_Payment_Rec.CREDIT_CARD_HOLDER_NAME IS NULL THEN
1660 X_Qte_Line_Row_Rec.L_CREDIT_CARD_HLD_NAME := FND_API.G_MISS_CHAR;
1661 ELSE
1662 X_Qte_Line_Row_Rec.L_CREDIT_CARD_HLD_NAME := P_Line_Payment_Rec.CREDIT_CARD_HOLDER_NAME;
1663 END IF;
1664
1665 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1666 P_Line_Payment_Rec.CUST_PO_NUMBER IS NULL THEN
1667 X_Qte_Line_Row_Rec.L_CUST_PO_NUMBER := FND_API.G_MISS_CHAR;
1668 ELSE
1669 X_Qte_Line_Row_Rec.L_CUST_PO_NUMBER := P_Line_Payment_Rec.CUST_PO_NUMBER;
1670 END IF;
1671
1672 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1673 P_Line_Payment_Rec.CUST_PO_LINE_NUMBER IS NULL THEN
1674 X_Qte_Line_Row_Rec.L_CUST_PO_LINE_NUMBER := FND_API.G_MISS_CHAR;
1675 ELSE
1676 X_Qte_Line_Row_Rec.L_CUST_PO_LINE_NUMBER := P_Line_Payment_Rec.CUST_PO_LINE_NUMBER;
1677 END IF;
1678
1679 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1680 P_Line_Payment_Rec.PAYMENT_REF_NUMBER IS NULL THEN
1681 X_Qte_Line_Row_Rec.L_PAYMENT_REF_NUMBER := FND_API.G_MISS_CHAR;
1682 ELSE
1683 X_Qte_Line_Row_Rec.L_PAYMENT_REF_NUMBER := P_Line_Payment_Rec.PAYMENT_REF_NUMBER;
1684 END IF;
1685
1686 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1687 P_Line_Payment_Rec.PAYMENT_TERM_ID IS NULL THEN
1688 X_Qte_Line_Row_Rec.L_PAYMENT_TERM_ID := FND_API.G_MISS_NUM;
1689 ELSE
1690 X_Qte_Line_Row_Rec.L_PAYMENT_TERM_ID := P_Line_Payment_Rec.PAYMENT_TERM_ID;
1691 END IF;
1692
1693 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1694 P_Line_Payment_Rec.PAYMENT_TYPE_CODE IS NULL THEN
1695 X_Qte_Line_Row_Rec.L_PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
1696 ELSE
1697 X_Qte_Line_Row_Rec.L_PAYMENT_TYPE_CODE := P_Line_Payment_Rec.PAYMENT_TYPE_CODE;
1698 END IF;
1699
1700 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1701 P_Line_Shipment_Rec.REQUEST_DATE IS NULL THEN
1702 X_Qte_Line_Row_Rec.L_REQUEST_DATE := FND_API.G_MISS_DATE;
1703 ELSE
1704 X_Qte_Line_Row_Rec.L_REQUEST_DATE := P_Line_Shipment_Rec.REQUEST_DATE;
1705 END IF;
1706
1707 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1708 P_Line_Shipment_Rec.SHIP_METHOD_CODE IS NULL THEN
1709 X_Qte_Line_Row_Rec.L_SHIP_METHOD_CODE := FND_API.G_MISS_CHAR;
1710 ELSE
1711 X_Qte_Line_Row_Rec.L_SHIP_METHOD_CODE := P_Line_Shipment_Rec.SHIP_METHOD_CODE;
1712 END IF;
1713
1714 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1715 P_Line_Shipment_Rec.SHIPMENT_PRIORITY_CODE IS NULL THEN
1716 X_Qte_Line_Row_Rec.L_SHIPMENT_PRIORITY_CODE := FND_API.G_MISS_CHAR;
1717 ELSE
1718 X_Qte_Line_Row_Rec.L_SHIPMENT_PRIORITY_CODE := P_Line_Shipment_Rec.SHIPMENT_PRIORITY_CODE;
1719 END IF;
1720
1721 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1722 P_Line_Shipment_Rec.SHIP_FROM_ORG_ID IS NULL THEN
1723 X_Qte_Line_Row_Rec.L_SHIP_FROM_ORG_ID := FND_API.G_MISS_NUM;
1724 ELSE
1725 X_Qte_Line_Row_Rec.L_SHIP_FROM_ORG_ID := P_Line_Shipment_Rec.SHIP_FROM_ORG_ID;
1726 END IF;
1727
1728 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1729 P_Line_Shipment_Rec.DEMAND_CLASS_CODE IS NULL THEN
1730 X_Qte_Line_Row_Rec.L_DEMAND_CLASS_CODE := FND_API.G_MISS_CHAR;
1731 ELSE
1732 X_Qte_Line_Row_Rec.L_DEMAND_CLASS_CODE := P_Line_Shipment_Rec.DEMAND_CLASS_CODE;
1733 END IF;
1734
1735 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1736 P_Line_Shipment_Rec.FOB_CODE IS NULL THEN
1737 X_Qte_Line_Row_Rec.L_FOB_CODE := FND_API.G_MISS_CHAR;
1738 ELSE
1739 X_Qte_Line_Row_Rec.L_FOB_CODE := P_Line_Shipment_Rec.FOB_CODE;
1740 END IF;
1741
1742 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1743 P_Line_Shipment_Rec.FREIGHT_TERMS_CODE IS NULL THEN
1744 X_Qte_Line_Row_Rec.L_FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;
1745 ELSE
1746 X_Qte_Line_Row_Rec.L_FREIGHT_TERMS_CODE := P_Line_Shipment_Rec.FREIGHT_TERMS_CODE;
1747 END IF;
1748
1749 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1750 P_Line_Shipment_Rec.PACKING_INSTRUCTIONS IS NULL THEN
1751 X_Qte_Line_Row_Rec.L_PACKING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
1752 ELSE
1753 X_Qte_Line_Row_Rec.L_PACKING_INSTRUCTIONS := P_Line_Shipment_Rec.PACKING_INSTRUCTIONS;
1754 END IF;
1755
1756 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1757 P_Line_Shipment_Rec.SHIPPING_INSTRUCTIONS IS NULL THEN
1758 X_Qte_Line_Row_Rec.L_SHIPPING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
1759 ELSE
1760 X_Qte_Line_Row_Rec.L_SHIPPING_INSTRUCTIONS := P_Line_Shipment_Rec.SHIPPING_INSTRUCTIONS;
1761 END IF;
1762
1763 X_Qte_Line_Row_Rec.L_APPLICATION_TYPE_CODE := P_Control_Rec.APPLICATION_TYPE_CODE;
1764
1765 OPEN C_Line_Party_Type(P_Quote_Line_Rec.QUOTE_HEADER_ID);
1766 FETCH C_Line_Party_Type INTO X_Qte_Line_Row_Rec.L_QUOTE_CUSTOMER_TYPE;
1767 CLOSE C_Line_Party_Type;
1768
1769 OPEN C_Product(P_Quote_line_Rec.inventory_item_id, P_Quote_Line_Rec.organization_id);
1770 FETCH C_Product INTO X_Qte_Line_Row_Rec.L_PRODUCT;
1771 CLOSE C_Product;
1772
1773 -- Added to handle Inventory Item Id and Inventory Organization id
1774 -- Girish 9/30/2005
1775
1776 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1777 P_Quote_Line_Rec.INVENTORY_ITEM_ID IS NULL THEN
1778 X_Qte_Line_Row_Rec.L_INVENTORY_ITEM_ID := FND_API.G_MISS_CHAR;
1779 ELSE
1780 X_Qte_Line_Row_Rec.L_INVENTORY_ITEM_ID := P_Quote_Line_Rec.INVENTORY_ITEM_ID;
1781 END IF;
1782
1783 IF p_control_rec.defaulting_flow_code like 'CREATE%' AND
1784 P_Quote_Line_Rec.ORGANIZATION_ID IS NULL THEN
1785 X_Qte_Line_Row_Rec.L_ORGANIZATION_ID := FND_API.G_MISS_CHAR;
1786 ELSE
1787 X_Qte_Line_Row_Rec.L_ORGANIZATION_ID := P_Quote_Line_Rec.ORGANIZATION_ID;
1788 END IF;
1789
1790 -- End
1791
1792 END IF;
1793
1794 END Api_Rec_To_Row_Type;
1795
1796
1797
1798 PROCEDURE ROW_TO_API_REC_TYPE
1799 (
1800 P_Entity_Code IN VARCHAR2,
1801 P_Qte_Header_Row_Rec IN ASO_AK_Quote_Header_V%Rowtype,
1802 P_Qte_Opportunity_Row_Rec IN ASO_AK_Quote_Oppty_V%Rowtype,
1803 P_Qte_Line_Row_Rec IN ASO_AK_Quote_Line_V%Rowtype,
1804 X_Quote_Header_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_Quote_Pub.Qte_Header_Rec_Type,
1805 X_Header_Shipment_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_Quote_Pub.Shipment_Rec_Type,
1806 X_Header_Payment_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_Quote_Pub.Payment_Rec_Type,
1807 X_Quote_Line_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_Quote_Pub.Qte_Line_Rec_Type,
1808 X_Line_Shipment_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_Quote_Pub.Shipment_Rec_Type,
1809 X_Line_Payment_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_Quote_Pub.Payment_Rec_Type,
1810 X_HEADER_MISC_REC IN OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE,
1811 X_HEADER_TAX_DETAIL_REC IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE,
1812 X_LINE_MISC_REC IN OUT NOCOPY /* file.sql.39 change */ ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE,
1813 X_LINE_TAX_DETAIL_REC IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE)
1814
1815 IS
1816
1817 BEGIN
1818
1819 IF P_Entity_Code = 'QUOTE_HEADER' THEN
1820 X_Quote_Header_Rec.QUOTE_NAME := P_Qte_Header_Row_Rec.Q_QUOTE_NAME;
1821 X_Quote_Header_Rec.QUOTE_HEADER_ID := P_Qte_Header_Row_Rec.Q_QUOTE_HEADER_ID;
1822 X_Quote_Header_Rec.CUST_ACCOUNT_ID := P_Qte_Header_Row_Rec.Q_CUST_ACCOUNT_ID;
1823 X_Quote_Header_Rec.QUOTE_EXPIRATION_DATE := P_Qte_Header_Row_Rec.Q_QUOTE_EXPIRATION_DATE;
1824 X_Quote_Header_Rec.QUOTE_STATUS_ID := P_Qte_Header_Row_Rec.Q_QUOTE_STATUS_ID;
1825 X_Quote_Header_Rec.ORG_ID := P_Qte_Header_Row_Rec.Q_ORG_ID;
1826 X_Quote_Header_Rec.CREATED_BY := P_Qte_Header_Row_Rec.Q_CREATED_BY;
1827 X_Quote_Header_Rec.ORDER_TYPE_ID := P_Qte_Header_Row_Rec.Q_ORDER_TYPE_ID;
1828 X_Quote_Header_Rec.CONTRACT_ID := P_Qte_Header_Row_Rec.Q_CONTRACT_ID;
1829 X_Quote_Header_Rec.PRICE_LIST_ID := P_Qte_Header_Row_Rec.Q_PRICE_LIST_ID;
1830 X_Quote_Header_Rec.CURRENCY_CODE := P_Qte_Header_Row_Rec.Q_CURRENCY_CODE;
1831 X_Quote_Header_Rec.PRICE_FROZEN_DATE := P_Qte_Header_Row_Rec.Q_PRICE_FROZEN_DATE;
1832 X_Quote_Header_Rec.CONTRACT_TEMPLATE_ID := P_Qte_Header_Row_Rec.Q_CONTRACT_TEMPLATE_ID;
1833 X_Quote_Header_Rec.RESOURCE_ID := P_Qte_Header_Row_Rec.Q_RESOURCE_ID;
1834 X_Quote_Header_Rec.RESOURCE_GRP_ID := P_Qte_Header_Row_Rec.Q_RESOURCE_GRP_ID;
1835 X_Quote_Header_Rec.SALES_CHANNEL_CODE := P_Qte_Header_Row_Rec.Q_SALES_CHANNEL_CODE;
1836 X_Quote_Header_Rec.MARKETING_SOURCE_CODE_ID := P_Qte_Header_Row_Rec.Q_MKTING_SRC_CODE_ID;
1837 X_Quote_Header_Rec.PARTY_ID := P_Qte_Header_Row_Rec.Q_PARTY_ID;
1838 X_Quote_Header_Rec.PHONE_ID := P_Qte_Header_Row_Rec.Q_PHONE_ID;
1839 X_Quote_Header_Rec.SOLD_TO_PARTY_SITE_ID := P_Qte_Header_Row_Rec.Q_SOLD_TO_PARTY_SITE_ID ;
1840 X_Quote_Header_Rec.INVOICE_TO_CUST_PARTY_ID := P_Qte_Header_Row_Rec.Q_INV_TO_CUST_PTY_ID;
1841 X_Quote_Header_Rec.INVOICE_TO_CUST_ACCOUNT_ID := P_Qte_Header_Row_Rec.Q_INV_TO_CUST_ACCT_ID;
1842 X_Quote_Header_Rec.INVOICE_TO_PARTY_SITE_ID := P_Qte_Header_Row_Rec.Q_INV_TO_PTY_SITE_ID;
1843 X_Quote_Header_Rec.INVOICE_TO_PARTY_ID := P_Qte_Header_Row_Rec.Q_INV_TO_PTY_ID;
1844 X_Quote_Header_Rec.CUST_PARTY_ID := P_Qte_Header_Row_Rec.Q_CUST_PARTY_ID;
1845 X_Quote_Header_Rec.END_CUSTOMER_CUST_PARTY_ID := P_Qte_Header_Row_Rec.Q_END_CUST_CUST_PTY_ID;
1846 X_Quote_Header_Rec.END_CUSTOMER_CUST_ACCOUNT_ID := P_Qte_Header_Row_Rec.Q_END_CUST_CUST_ACCT_ID;
1847 X_Quote_Header_Rec.END_CUSTOMER_PARTY_SITE_ID := P_Qte_Header_Row_Rec.Q_END_CUST_PTY_SITE_ID ;
1848 X_Quote_Header_Rec.END_CUSTOMER_PARTY_ID := P_Qte_Header_Row_Rec.Q_END_CUST_PTY_ID;
1849 X_Quote_Header_Rec.AUTOMATIC_PRICE_FLAG := P_Qte_Header_Row_Rec.Q_AUTOMATIC_PRICE_FLAG ;
1850 X_Quote_Header_Rec.AUTOMATIC_TAX_FLAG := P_Qte_Header_Row_Rec.Q_AUTOMATIC_TAX_FLAG;
1851 X_Quote_Header_Rec.LAST_UPDATE_DATE := P_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE;
1852 X_Quote_Header_Rec.OBJECT_VERSION_NUMBER := P_Qte_Header_Row_Rec.Q_OBJECT_VERSION_NUMBER ;
1853 X_Quote_Header_Rec.ATTRIBUTE_CATEGORY := P_Qte_Header_Row_Rec.Q_ATTRIBUTE_CATEGORY;
1854 X_Quote_Header_Rec.ATTRIBUTE1 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE1;
1855 X_Quote_Header_Rec.ATTRIBUTE2 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE2;
1856 X_Quote_Header_Rec.ATTRIBUTE3 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE3;
1857 X_Quote_Header_Rec.ATTRIBUTE4 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE4;
1858 X_Quote_Header_Rec.ATTRIBUTE5 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE5;
1859 X_Quote_Header_Rec.ATTRIBUTE6 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE6;
1860 X_Quote_Header_Rec.ATTRIBUTE7 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE7;
1861 X_Quote_Header_Rec.ATTRIBUTE8 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE8;
1862 X_Quote_Header_Rec.ATTRIBUTE9 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE9;
1863 X_Quote_Header_Rec.ATTRIBUTE10 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE10;
1864 X_Quote_Header_Rec.ATTRIBUTE11 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE11;
1865 X_Quote_Header_Rec.ATTRIBUTE12 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE12;
1866 X_Quote_Header_Rec.ATTRIBUTE13 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE13;
1867 X_Quote_Header_Rec.ATTRIBUTE14 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE14;
1868 X_Quote_Header_Rec.ATTRIBUTE15 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE15;
1869 X_Quote_Header_Rec.ATTRIBUTE16 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE16;
1870 X_Quote_Header_Rec.ATTRIBUTE17 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE17;
1871 X_Quote_Header_Rec.ATTRIBUTE18 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE18;
1872 X_Quote_Header_Rec.ATTRIBUTE19 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE19;
1873 X_Quote_Header_Rec.ATTRIBUTE20 := P_Qte_Header_Row_Rec.Q_ATTRIBUTE20;
1874 X_Header_Shipment_Rec.SHIP_TO_CUST_PARTY_ID :=P_Qte_Header_Row_Rec.Q_SHIP_TO_CUST_PARTY_ID;
1875 X_Header_Shipment_Rec.SHIP_TO_CUST_ACCOUNT_ID := P_Qte_Header_Row_Rec.Q_SHIP_TO_CUST_ACCT_ID;
1876 X_Header_Shipment_Rec.SHIP_TO_PARTY_SITE_ID := P_Qte_Header_Row_Rec.Q_SHIP_TO_PARTY_SITE_ID;
1877 X_Header_Shipment_Rec.SHIP_TO_PARTY_ID := P_Qte_Header_Row_Rec.Q_SHIP_TO_PARTY_ID;
1878 X_Header_Payment_Rec.PAYMENT_TERM_ID := P_Qte_Header_Row_Rec.Q_PAYMENT_TERM_ID;
1879 X_Header_Payment_Rec.CUST_PO_NUMBER := P_Qte_Header_Row_Rec.Q_CUST_PO_NUMBER ;
1880 X_Header_Payment_Rec.CREDIT_CARD_CODE := P_Qte_Header_Row_Rec.Q_CREDIT_CARD_CODE ;
1881 X_Header_Payment_Rec.PAYMENT_REF_NUMBER := P_Qte_Header_Row_Rec.Q_PAYMENT_REF_NUMBER ;
1882 X_Header_Payment_Rec.CREDIT_CARD_HOLDER_NAME := P_Qte_Header_Row_Rec.Q_CREDIT_CARD_HLD_NAME ;
1883 X_Header_Payment_Rec.CREDIT_CARD_EXPIRATION_DATE := P_Qte_Header_Row_Rec.Q_CREDIT_CARD_EXP_DATE ;
1884 X_Header_Payment_Rec.PAYMENT_TYPE_CODE := P_Qte_Header_Row_Rec.Q_PAYMENT_TYPE_CODE ;
1885 X_Header_Shipment_Rec.REQUEST_DATE_TYPE := P_Qte_Header_Row_Rec.Q_REQUEST_DATE_TYPE ;
1886 X_Header_Shipment_Rec.REQUEST_DATE := P_Qte_Header_Row_Rec.Q_REQUEST_DATE ;
1887 X_Header_Shipment_Rec.SHIP_METHOD_CODE := P_Qte_Header_Row_Rec.Q_SHIP_METHOD_CODE;
1888 X_Header_Shipment_Rec.SHIPMENT_PRIORITY_CODE := P_Qte_Header_Row_Rec.Q_SHIPMENT_PRIORITY_CODE;
1889 X_Header_Shipment_Rec.FREIGHT_TERMS_CODE := P_Qte_Header_Row_Rec.Q_FREIGHT_TERMS_CODE;
1890 X_Header_Shipment_Rec.FOB_CODE := P_Qte_Header_Row_Rec.Q_FOB_CODE;
1891 X_Header_Shipment_Rec.SHIPPING_INSTRUCTIONS := P_Qte_Header_Row_Rec.Q_SHIPPING_INSTRUCTIONS;
1892 X_Header_Shipment_Rec.PACKING_INSTRUCTIONS := P_Qte_Header_Row_Rec.Q_PACKING_INSTRUCTIONS;
1893 X_Header_Shipment_Rec.DEMAND_CLASS_CODE := P_Qte_Header_Row_Rec.Q_DEMAND_CLASS_CODE;
1894
1895 ELSIF P_Entity_Code = 'QUOTE_OPPTY' THEN
1896 X_Quote_Header_Rec.QUOTE_NAME := P_Qte_Opportunity_Row_Rec.O_QUOTE_NAME;
1897 X_Quote_Header_Rec.QUOTE_HEADER_ID := P_Qte_Opportunity_Row_Rec.O_QUOTE_HEADER_ID;
1898 X_Quote_Header_Rec.CUST_ACCOUNT_ID := P_Qte_Opportunity_Row_Rec.O_CUST_ACCOUNT_ID;
1899 X_Quote_Header_Rec.QUOTE_EXPIRATION_DATE := P_Qte_Opportunity_Row_Rec.O_QUOTE_EXP_DATE;
1900 X_Quote_Header_Rec.QUOTE_STATUS_ID := P_Qte_Opportunity_Row_Rec.O_QUOTE_STATUS_ID;
1901 X_Quote_Header_Rec.ORG_ID := P_Qte_Opportunity_Row_Rec.O_ORG_ID;
1902 X_Quote_Header_Rec.CREATED_BY := P_Qte_Opportunity_Row_Rec.O_CREATED_BY;
1903 X_Quote_Header_Rec.ORDER_TYPE_ID := P_Qte_Opportunity_Row_Rec.O_ORDER_TYPE_ID;
1904 X_Quote_Header_Rec.CONTRACT_ID := P_Qte_Opportunity_Row_Rec.O_CONTRACT_ID;
1905 X_Quote_Header_Rec.PRICE_LIST_ID := P_Qte_Opportunity_Row_Rec.O_PRICE_LIST_ID;
1906 X_Quote_Header_Rec.CURRENCY_CODE := P_Qte_Opportunity_Row_Rec.O_CURRENCY_CODE;
1907 X_Quote_Header_Rec.PRICE_FROZEN_DATE := P_Qte_Opportunity_Row_Rec.O_PRICE_FROZEN_DATE;
1908 X_Quote_Header_Rec.CONTRACT_TEMPLATE_ID := P_Qte_Opportunity_Row_Rec.O_CONTRACT_TEMPLATE_ID;
1909 X_Quote_Header_Rec.RESOURCE_ID := P_Qte_Opportunity_Row_Rec.O_RESOURCE_ID;
1910 X_Quote_Header_Rec.RESOURCE_GRP_ID := P_Qte_Opportunity_Row_Rec.O_RESOURCE_GRP_ID;
1911 X_Quote_Header_Rec.SALES_CHANNEL_CODE := P_Qte_Opportunity_Row_Rec.O_SALES_CHANNEL_CODE;
1912 X_Quote_Header_Rec.MARKETING_SOURCE_CODE_ID := P_Qte_Opportunity_Row_Rec.O_MKTING_SRC_CODE_ID;
1913 X_Quote_Header_Rec.PARTY_ID := P_Qte_Opportunity_Row_Rec.O_PARTY_ID;
1914 X_Quote_Header_Rec.PHONE_ID := P_Qte_Opportunity_Row_Rec.O_PHONE_ID;
1915 X_Quote_Header_Rec.SOLD_TO_PARTY_SITE_ID := P_Qte_Opportunity_Row_Rec.O_SOLD_TO_PARTY_SITE_ID ;
1916 X_Quote_Header_Rec.INVOICE_TO_CUST_PARTY_ID := P_Qte_Opportunity_Row_Rec.O_INV_CUST_PTY_ID;
1917 X_Quote_Header_Rec.INVOICE_TO_CUST_ACCOUNT_ID := P_Qte_Opportunity_Row_Rec.O_INV_CUST_ACCT_ID;
1918 X_Quote_Header_Rec.INVOICE_TO_PARTY_SITE_ID := P_Qte_Opportunity_Row_Rec.O_INV_PTY_SITE_ID;
1919 X_Quote_Header_Rec.INVOICE_TO_PARTY_ID := P_Qte_Opportunity_Row_Rec.O_INV_PTY_ID;
1920 X_Quote_Header_Rec.CUST_PARTY_ID := P_Qte_Opportunity_Row_Rec.O_CUST_PARTY_ID;
1921 X_Quote_Header_Rec.END_CUSTOMER_CUST_PARTY_ID := P_Qte_Opportunity_Row_Rec.O_END_CUST_CUST_PTY_ID;
1922 X_Quote_Header_Rec.END_CUSTOMER_CUST_ACCOUNT_ID := P_Qte_Opportunity_Row_Rec.O_END_CUST_CUST_ACCT_ID;
1923 X_Quote_Header_Rec.END_CUSTOMER_PARTY_SITE_ID := P_Qte_Opportunity_Row_Rec.O_END_CUST_PTY_SITE_ID ;
1924 X_Quote_Header_Rec.END_CUSTOMER_PARTY_ID := P_Qte_Opportunity_Row_Rec.O_END_CUST_PTY_ID;
1925 X_Quote_Header_Rec.AUTOMATIC_PRICE_FLAG := P_Qte_Opportunity_Row_Rec.O_AUTOMATIC_PRICE_FLAG ;
1926 X_Quote_Header_Rec.AUTOMATIC_TAX_FLAG := P_Qte_Opportunity_Row_Rec.O_AUTOMATIC_TAX_FLAG;
1927 X_Quote_Header_Rec.LAST_UPDATE_DATE := P_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE;
1928 X_Quote_Header_Rec.OBJECT_VERSION_NUMBER := P_Qte_Opportunity_Row_Rec.O_OBJECT_VERSION_NUMBER ;
1929 X_Quote_Header_Rec.ATTRIBUTE_CATEGORY := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE_CATEGORY;
1930 X_Quote_Header_Rec.ATTRIBUTE1 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE1;
1931 X_Quote_Header_Rec.ATTRIBUTE2 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE2;
1932 X_Quote_Header_Rec.ATTRIBUTE3 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE3;
1933 X_Quote_Header_Rec.ATTRIBUTE4 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE4;
1934 X_Quote_Header_Rec.ATTRIBUTE5 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE5;
1935 X_Quote_Header_Rec.ATTRIBUTE6 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE6;
1936 X_Quote_Header_Rec.ATTRIBUTE7 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE7;
1937 X_Quote_Header_Rec.ATTRIBUTE8 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE8;
1938 X_Quote_Header_Rec.ATTRIBUTE9 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE9;
1939 X_Quote_Header_Rec.ATTRIBUTE10 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE10;
1940 X_Quote_Header_Rec.ATTRIBUTE11 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE11;
1941 X_Quote_Header_Rec.ATTRIBUTE12 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE12;
1942 X_Quote_Header_Rec.ATTRIBUTE13 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE13;
1943 X_Quote_Header_Rec.ATTRIBUTE14 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE14;
1944 X_Quote_Header_Rec.ATTRIBUTE15 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE15;
1945 X_Quote_Header_Rec.ATTRIBUTE16 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE16;
1946 X_Quote_Header_Rec.ATTRIBUTE17 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE17;
1947 X_Quote_Header_Rec.ATTRIBUTE18 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE18;
1948 X_Quote_Header_Rec.ATTRIBUTE19 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE19;
1949 X_Quote_Header_Rec.ATTRIBUTE20 := P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE20;
1950 X_Header_Shipment_Rec.SHIP_TO_CUST_PARTY_ID :=P_Qte_Opportunity_Row_Rec.O_SHIP_TO_CUST_PTY_ID;
1951 X_Header_Shipment_Rec.SHIP_TO_CUST_ACCOUNT_ID := P_Qte_Opportunity_Row_Rec.O_SHIP_TO_CUST_ACCT_ID;
1952 X_Header_Shipment_Rec.SHIP_TO_PARTY_SITE_ID := P_Qte_Opportunity_Row_Rec.O_SHIP_TO_PTY_SITE_ID;
1953 X_Header_Shipment_Rec.SHIP_TO_PARTY_ID := P_Qte_Opportunity_Row_Rec.O_SHIP_TO_PTY_ID;
1954 X_Header_Payment_Rec.PAYMENT_TERM_ID := P_Qte_Opportunity_Row_Rec.O_PAYMENT_TERM_ID;
1955 X_Header_Payment_Rec.CUST_PO_NUMBER := P_Qte_Opportunity_Row_Rec.O_CUST_PO_NUMBER ;
1956 X_Header_Payment_Rec.CREDIT_CARD_CODE := P_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_CODE ;
1957 X_Header_Payment_Rec.PAYMENT_REF_NUMBER := P_Qte_Opportunity_Row_Rec.O_PAYMENT_REF_NUMBER ;
1958 X_Header_Payment_Rec.CREDIT_CARD_HOLDER_NAME := P_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_HLD_NAME ;
1959 X_Header_Payment_Rec.CREDIT_CARD_EXPIRATION_DATE := P_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_EXP_DATE ;
1960 X_Header_Payment_Rec.PAYMENT_TYPE_CODE := P_Qte_Opportunity_Row_Rec.O_PAYMENT_TYPE_CODE ;
1961 X_Header_Shipment_Rec.REQUEST_DATE_TYPE := P_Qte_Opportunity_Row_Rec.O_REQUEST_DATE_TYPE ;
1962 X_Header_Shipment_Rec.REQUEST_DATE := P_Qte_Opportunity_Row_Rec.O_REQUEST_DATE ;
1963 X_Header_Shipment_Rec.SHIP_METHOD_CODE := P_Qte_Opportunity_Row_Rec.O_SHIP_METHOD_CODE;
1964 X_Header_Shipment_Rec.SHIPMENT_PRIORITY_CODE := P_Qte_Opportunity_Row_Rec.O_SHIPMENT_PRIORITY_CODE;
1965 X_Header_Shipment_Rec.FREIGHT_TERMS_CODE := P_Qte_Opportunity_Row_Rec.O_FREIGHT_TERMS_CODE;
1966 X_Header_Shipment_Rec.FOB_CODE := P_Qte_Opportunity_Row_Rec.O_FOB_CODE;
1967 X_Header_Shipment_Rec.SHIPPING_INSTRUCTIONS := P_Qte_Opportunity_Row_Rec.O_SHIPPING_INSTRUCTIONS;
1968 X_Header_Shipment_Rec.PACKING_INSTRUCTIONS := P_Qte_Opportunity_Row_Rec.O_PACKING_INSTRUCTIONS;
1969 X_Header_Shipment_Rec.DEMAND_CLASS_CODE := P_Qte_Opportunity_Row_Rec.O_DEMAND_CLASS_CODE;
1970
1971 ELSIF P_Entity_Code = 'QUOTE_LINE' THEN
1972
1973 IF aso_debug_pub.g_debug_flag = 'Y' THEN
1974 aso_debug_pub.ADD('X_Quote_Line_Rec.Inventory_Item_Id: ' || X_Quote_Line_Rec.Inventory_Item_Id,1,'N');
1975 aso_debug_pub.ADD('X_Quote_Line_Rec.uom_code: ' || X_Quote_Line_Rec.uom_code,1,'N');
1976 END IF;
1977
1978 X_Quote_Line_Rec.QUOTE_HEADER_ID := P_Qte_Line_Row_Rec.L_QUOTE_HEADER_ID;
1979 X_Quote_Line_Rec.QUOTE_LINE_ID := P_Qte_Line_Row_Rec.L_QUOTE_LINE_ID;
1980 X_Quote_Line_Rec.LAST_UPDATE_DATE := P_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE;
1981 X_Quote_Line_Rec.OBJECT_VERSION_NUMBER := P_Qte_Line_Row_Rec.L_OBJECT_VERSION_NUMBER;
1982 X_Quote_Line_Rec.ATTRIBUTE_CATEGORY := P_Qte_Line_Row_Rec.L_ATTRIBUTE_CATEGORY;
1983 X_Quote_Line_Rec.ATTRIBUTE1 := P_Qte_Line_Row_Rec.L_ATTRIBUTE1;
1984 X_Quote_Line_Rec.ATTRIBUTE2 := P_Qte_Line_Row_Rec.L_ATTRIBUTE2;
1985 X_Quote_Line_Rec.ATTRIBUTE3 := P_Qte_Line_Row_Rec.L_ATTRIBUTE3;
1986 X_Quote_Line_Rec.ATTRIBUTE4 := P_Qte_Line_Row_Rec.L_ATTRIBUTE4;
1987 X_Quote_Line_Rec.ATTRIBUTE5 := P_Qte_Line_Row_Rec.L_ATTRIBUTE5;
1988 X_Quote_Line_Rec.ATTRIBUTE6 := P_Qte_Line_Row_Rec.L_ATTRIBUTE6;
1989 X_Quote_Line_Rec.ATTRIBUTE7 := P_Qte_Line_Row_Rec.L_ATTRIBUTE7;
1990 X_Quote_Line_Rec.ATTRIBUTE8 := P_Qte_Line_Row_Rec.L_ATTRIBUTE8;
1991 X_Quote_Line_Rec.ATTRIBUTE9 := P_Qte_Line_Row_Rec.L_ATTRIBUTE9;
1992 X_Quote_Line_Rec.ATTRIBUTE10 := P_Qte_Line_Row_Rec.L_ATTRIBUTE10;
1993 X_Quote_Line_Rec.ATTRIBUTE11 := P_Qte_Line_Row_Rec.L_ATTRIBUTE11;
1994 X_Quote_Line_Rec.ATTRIBUTE12 := P_Qte_Line_Row_Rec.L_ATTRIBUTE12;
1995 X_Quote_Line_Rec.ATTRIBUTE13 := P_Qte_Line_Row_Rec.L_ATTRIBUTE13;
1996 X_Quote_Line_Rec.ATTRIBUTE14 := P_Qte_Line_Row_Rec.L_ATTRIBUTE14;
1997 X_Quote_Line_Rec.ATTRIBUTE15 := P_Qte_Line_Row_Rec.L_ATTRIBUTE15;
1998 X_Quote_Line_Rec.ATTRIBUTE16 := P_Qte_Line_Row_Rec.L_ATTRIBUTE16;
1999 X_Quote_Line_Rec.ATTRIBUTE17 := P_Qte_Line_Row_Rec.L_ATTRIBUTE17;
2000 X_Quote_Line_Rec.ATTRIBUTE18 := P_Qte_Line_Row_Rec.L_ATTRIBUTE18;
2001 X_Quote_Line_Rec.ATTRIBUTE19 := P_Qte_Line_Row_Rec.L_ATTRIBUTE19;
2002 X_Quote_Line_Rec.ATTRIBUTE20 := P_Qte_Line_Row_Rec.L_ATTRIBUTE20;
2003 X_Quote_Line_Rec.CREATED_BY := P_Qte_Line_Row_Rec.L_CREATED_BY;
2004 X_Quote_Line_Rec.ORG_ID := P_Qte_Line_Row_Rec.L_ORG_ID;
2005 X_Quote_Line_Rec.ORDER_LINE_TYPE_ID := P_Qte_Line_Row_Rec.L_ORDER_LINE_TYPE_ID;
2006 X_Quote_Line_Rec.LINE_CATEGORY_CODE := P_Qte_Line_Row_Rec.L_LINE_CATEGORY_CODE;
2007 X_Quote_Line_Rec.CHARGE_PERIODICITY_CODE := P_Qte_Line_Row_Rec.L_PERIODICITY_CODE;
2008 X_Quote_Line_Rec.AGREEMENT_ID := P_Qte_Line_Row_Rec.L_AGREEMENT_ID;
2009 X_Quote_Line_Rec.PRICE_LIST_ID := P_Qte_Line_Row_Rec.L_PRICE_LIST_ID;
2010 X_Quote_Line_Rec.INVOICE_TO_CUST_ACCOUNT_ID := P_Qte_Line_Row_Rec.L_INV_TO_CUST_ACCT_ID;
2011 X_Quote_Line_Rec.INVOICE_TO_CUST_PARTY_ID := P_Qte_Line_Row_Rec.L_INV_TO_CUST_PTY_ID;
2012 X_Quote_Line_Rec.INVOICE_TO_PARTY_ID := P_Qte_Line_Row_Rec.L_INV_TO_PTY_ID;
2013 X_Quote_Line_Rec.INVOICE_TO_PARTY_SITE_ID := P_Qte_Line_Row_Rec.L_INV_TO_PTY_SITE_ID;
2014 X_Quote_Line_Rec.END_CUSTOMER_CUST_ACCOUNT_ID := P_Qte_Line_Row_Rec.L_END_CUST_CUST_ACCT_ID;
2015 X_Quote_Line_Rec.END_CUSTOMER_CUST_PARTY_ID := P_Qte_Line_Row_Rec.L_END_CUST_CUST_PTY_ID;
2016 X_Quote_Line_Rec.END_CUSTOMER_PARTY_ID := P_Qte_Line_Row_Rec.L_END_CUST_PTY_ID;
2017 X_Quote_Line_Rec.END_CUSTOMER_PARTY_SITE_ID := P_Qte_Line_Row_Rec.L_END_CUST_PTY_SITE_ID;
2018
2019 IF X_Line_Payment_Rec.Operation_Code IS NULL OR X_Line_Payment_Rec.Operation_Code = FND_API.G_MISS_CHAR THEN
2020 X_Line_Payment_Rec.Operation_Code := 'CREATE';
2021 X_Line_Payment_Rec.qte_line_index := 1;
2022 ELSIF X_Line_Payment_Rec.Operation_Code = 'CREATE' THEN
2023 X_Line_Payment_Rec.qte_line_index := 1;
2024 END IF;
2025
2026 X_Line_Payment_Rec.CREDIT_CARD_CODE := P_Qte_Line_Row_Rec.L_CREDIT_CARD_CODE;
2027 X_Line_Payment_Rec.CREDIT_CARD_EXPIRATION_DATE := P_Qte_Line_Row_Rec.L_CREDIT_CARD_EXP_DATE;
2028 X_Line_Payment_Rec.CREDIT_CARD_HOLDER_NAME := P_Qte_Line_Row_Rec.L_CREDIT_CARD_HLD_NAME;
2029 X_Line_Payment_Rec.CUST_PO_NUMBER := P_Qte_Line_Row_Rec.L_CUST_PO_NUMBER;
2030 X_Line_Payment_Rec.CUST_PO_LINE_NUMBER := P_Qte_Line_Row_Rec.L_CUST_PO_LINE_NUMBER;
2031 X_Line_Payment_Rec.PAYMENT_REF_NUMBER := P_Qte_Line_Row_Rec.L_PAYMENT_REF_NUMBER;
2032 X_Line_Payment_Rec.PAYMENT_TERM_ID := P_Qte_Line_Row_Rec.L_PAYMENT_TERM_ID;
2033 X_Line_Payment_Rec.PAYMENT_TYPE_CODE := P_Qte_Line_Row_Rec.L_PAYMENT_TYPE_CODE;
2034
2035 IF X_Line_Shipment_Rec.Operation_Code IS NULL OR X_Line_Shipment_Rec.Operation_Code = FND_API.G_MISS_CHAR THEN
2036 X_Line_Shipment_Rec.Operation_Code := 'CREATE';
2037 X_Line_Shipment_Rec.qte_line_index := 1;
2038 ELSIF X_Line_Shipment_Rec.Operation_Code = 'CREATE' THEN
2039 X_Line_Shipment_Rec.qte_line_index := 1;
2040 END IF;
2041
2042 X_Line_Shipment_Rec.SHIP_TO_CUST_ACCOUNT_ID := P_Qte_Line_Row_Rec.L_SHIP_TO_CUST_ACCT_ID;
2043 X_Line_Shipment_Rec.SHIP_TO_CUST_PARTY_ID := P_Qte_Line_Row_Rec.L_SHIP_TO_CUST_PARTY_ID;
2044 X_Line_Shipment_Rec.SHIP_TO_PARTY_ID := P_Qte_Line_Row_Rec.L_SHIP_TO_PARTY_ID;
2045 X_Line_Shipment_Rec.SHIP_TO_PARTY_SITE_ID := P_Qte_Line_Row_Rec.L_SHIP_TO_PARTY_SITE_ID;
2046 X_Line_Shipment_Rec.REQUEST_DATE := P_Qte_Line_Row_Rec.L_REQUEST_DATE;
2047 X_Line_Shipment_Rec.SHIP_METHOD_CODE := P_Qte_Line_Row_Rec.L_SHIP_METHOD_CODE;
2048 X_Line_Shipment_Rec.SHIPMENT_PRIORITY_CODE := P_Qte_Line_Row_Rec.L_SHIPMENT_PRIORITY_CODE;
2049 X_Line_Shipment_Rec.SHIP_FROM_ORG_ID := P_Qte_Line_Row_Rec.L_SHIP_FROM_ORG_ID;
2050 X_Line_Shipment_Rec.DEMAND_CLASS_CODE := P_Qte_Line_Row_Rec.L_DEMAND_CLASS_CODE;
2051 X_Line_Shipment_Rec.FOB_CODE := P_Qte_Line_Row_Rec.L_FOB_CODE;
2052 X_Line_Shipment_Rec.FREIGHT_TERMS_CODE := P_Qte_Line_Row_Rec.L_FREIGHT_TERMS_CODE;
2053 X_Line_Shipment_Rec.PACKING_INSTRUCTIONS := P_Qte_Line_Row_Rec.L_PACKING_INSTRUCTIONS;
2054 X_Line_Shipment_Rec.SHIPPING_INSTRUCTIONS := P_Qte_Line_Row_Rec.L_SHIPPING_INSTRUCTIONS;
2055
2056 END IF;
2057
2058 END ROW_TO_API_REC_TYPE;
2059
2060
2061
2062 PROCEDURE Initialize_Row_Type
2063 (
2064 P_Entity_Code IN VARCHAR2,
2065 P_Qte_Header_Row_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_AK_Quote_Header_V%Rowtype,
2066 P_Qte_Opportunity_Row_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_AK_Quote_Oppty_V%Rowtype,
2067 P_Qte_Line_Row_Rec IN OUT NOCOPY /* file.sql.39 change */ ASO_AK_Quote_Line_V%Rowtype)
2068
2069 IS
2070
2071 BEGIN
2072
2073 IF P_Entity_Code = 'QUOTE_HEADER' THEN
2074 P_Qte_Header_Row_Rec.Q_QUOTE_NAME := FND_API.G_MISS_CHAR;
2075 P_Qte_Header_Row_Rec.Q_QUOTE_HEADER_ID := FND_API.G_MISS_NUM;
2076 P_Qte_Header_Row_Rec.Q_CUST_ACCOUNT_ID := FND_API.G_MISS_NUM;
2077 P_Qte_Header_Row_Rec.Q_QUOTE_EXPIRATION_DATE := FND_API.G_MISS_DATE;
2078 P_Qte_Header_Row_Rec.Q_QUOTE_STATUS_ID := FND_API.G_MISS_NUM;
2079 P_Qte_Header_Row_Rec.Q_ORG_ID := FND_API.G_MISS_NUM;
2080 P_Qte_Header_Row_Rec.Q_CREATED_BY := FND_API.G_MISS_NUM;
2081 P_Qte_Header_Row_Rec.Q_ORDER_TYPE_ID := FND_API.G_MISS_NUM;
2082 P_Qte_Header_Row_Rec.Q_CONTRACT_ID := FND_API.G_MISS_NUM;
2083 P_Qte_Header_Row_Rec.Q_PRICE_LIST_ID := FND_API.G_MISS_NUM;
2084 P_Qte_Header_Row_Rec.Q_CURRENCY_CODE := FND_API.G_MISS_CHAR;
2085 P_Qte_Header_Row_Rec.Q_PRICE_FROZEN_DATE := FND_API.G_MISS_DATE;
2086 P_Qte_Header_Row_Rec.Q_CONTRACT_TEMPLATE_ID := FND_API.G_MISS_NUM;
2087 P_Qte_Header_Row_Rec.Q_RESOURCE_ID := FND_API.G_MISS_NUM;
2088 P_Qte_Header_Row_Rec.Q_RESOURCE_GRP_ID := FND_API.G_MISS_NUM;
2089 P_Qte_Header_Row_Rec.Q_SALES_CHANNEL_CODE := FND_API.G_MISS_CHAR;
2090 P_Qte_Header_Row_Rec.Q_MKTING_SRC_CODE_ID := FND_API.G_MISS_NUM;
2091 P_Qte_Header_Row_Rec.Q_PARTY_ID := FND_API.G_MISS_NUM;
2092 P_Qte_Header_Row_Rec.Q_PHONE_ID := FND_API.G_MISS_NUM;
2093 P_Qte_Header_Row_Rec.Q_SOLD_TO_PARTY_SITE_ID := FND_API.G_MISS_NUM ;
2094 P_Qte_Header_Row_Rec.Q_INV_TO_CUST_PTY_ID := FND_API.G_MISS_NUM;
2095 P_Qte_Header_Row_Rec.Q_INV_TO_CUST_ACCT_ID := FND_API.G_MISS_NUM;
2096 P_Qte_Header_Row_Rec.Q_INV_TO_PTY_SITE_ID := FND_API.G_MISS_NUM;
2097 P_Qte_Header_Row_Rec.Q_INV_TO_PTY_ID := FND_API.G_MISS_NUM;
2098 P_Qte_Header_Row_Rec.Q_CUST_PARTY_ID := FND_API.G_MISS_NUM ;
2099 P_Qte_Header_Row_Rec.Q_END_CUST_CUST_PTY_ID := FND_API.G_MISS_NUM;
2100 P_Qte_Header_Row_Rec.Q_END_CUST_CUST_ACCT_ID := FND_API.G_MISS_NUM;
2101 P_Qte_Header_Row_Rec.Q_END_CUST_PTY_SITE_ID := FND_API.G_MISS_NUM;
2102 P_Qte_Header_Row_Rec.Q_END_CUST_PTY_ID := FND_API.G_MISS_NUM;
2103 P_Qte_Header_Row_Rec.Q_AUTOMATIC_PRICE_FLAG := FND_API.G_MISS_CHAR;
2104 P_Qte_Header_Row_Rec.Q_AUTOMATIC_TAX_FLAG := FND_API.G_MISS_CHAR;
2105 P_Qte_Header_Row_Rec.Q_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
2106 P_Qte_Header_Row_Rec.Q_OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
2107 P_Qte_Header_Row_Rec.Q_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
2108 P_Qte_Header_Row_Rec.Q_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
2109 P_Qte_Header_Row_Rec.Q_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
2110 P_Qte_Header_Row_Rec.Q_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
2111 P_Qte_Header_Row_Rec.Q_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
2112 P_Qte_Header_Row_Rec.Q_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
2113 P_Qte_Header_Row_Rec.Q_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
2114 P_Qte_Header_Row_Rec.Q_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
2115 P_Qte_Header_Row_Rec.Q_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
2116 P_Qte_Header_Row_Rec.Q_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
2117 P_Qte_Header_Row_Rec.Q_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
2118 P_Qte_Header_Row_Rec.Q_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
2119 P_Qte_Header_Row_Rec.Q_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
2120 P_Qte_Header_Row_Rec.Q_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
2121 P_Qte_Header_Row_Rec.Q_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
2122 P_Qte_Header_Row_Rec.Q_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
2123 P_Qte_Header_Row_Rec.Q_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
2124 P_Qte_Header_Row_Rec.Q_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
2125 P_Qte_Header_Row_Rec.Q_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
2126 P_Qte_Header_Row_Rec.Q_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
2127 P_Qte_Header_Row_Rec.Q_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
2128 P_Qte_Header_Row_Rec.Q_SHIP_TO_CUST_PARTY_ID := FND_API.G_MISS_NUM;
2129 P_Qte_Header_Row_Rec.Q_SHIP_TO_CUST_ACCT_ID := FND_API.G_MISS_NUM;
2130 P_Qte_Header_Row_Rec.Q_SHIP_TO_PARTY_SITE_ID := FND_API.G_MISS_NUM;
2131 P_Qte_Header_Row_Rec.Q_SHIP_TO_PARTY_ID := FND_API.G_MISS_NUM;
2132 P_Qte_Header_Row_Rec.Q_PAYMENT_TERM_ID := FND_API.G_MISS_NUM;
2133 P_Qte_Header_Row_Rec.Q_CUST_PO_NUMBER := FND_API.G_MISS_CHAR ;
2134 P_Qte_Header_Row_Rec.Q_CREDIT_CARD_CODE := FND_API.G_MISS_CHAR ;
2135 P_Qte_Header_Row_Rec.Q_PAYMENT_REF_NUMBER := FND_API.G_MISS_CHAR ;
2136 P_Qte_Header_Row_Rec.Q_CREDIT_CARD_HLD_NAME := FND_API.G_MISS_CHAR ;
2137 P_Qte_Header_Row_Rec.Q_CREDIT_CARD_EXP_DATE := FND_API.G_MISS_DATE ;
2138 P_Qte_Header_Row_Rec.Q_PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR ;
2139 P_Qte_Header_Row_Rec.Q_REQUEST_DATE_TYPE := FND_API.G_MISS_CHAR ;
2140 P_Qte_Header_Row_Rec.Q_REQUEST_DATE := FND_API.G_MISS_DATE;
2141 P_Qte_Header_Row_Rec.Q_SHIP_METHOD_CODE := FND_API.G_MISS_CHAR;
2142 P_Qte_Header_Row_Rec.Q_SHIPMENT_PRIORITY_CODE := FND_API.G_MISS_CHAR;
2143 P_Qte_Header_Row_Rec.Q_FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;
2144 P_Qte_Header_Row_Rec.Q_FOB_CODE := FND_API.G_MISS_CHAR;
2145 P_Qte_Header_Row_Rec.Q_SHIPPING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
2146 P_Qte_Header_Row_Rec.Q_PACKING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
2147 P_Qte_Header_Row_Rec.Q_DEMAND_CLASS_CODE := FND_API.G_MISS_CHAR;
2148 P_Qte_Header_Row_Rec.Q_APPLICATION_TYPE_CODE := FND_API.G_MISS_CHAR;
2149 P_Qte_Header_Row_Rec.Q_QUOTE_CUSTOMER_TYPE := FND_API.G_MISS_CHAR;
2150
2151 ELSIF P_Entity_Code = 'QUOTE_OPPTY' THEN
2152 P_Qte_Opportunity_Row_Rec.O_QUOTE_NAME := FND_API.G_MISS_CHAR;
2153 P_Qte_Opportunity_Row_Rec.O_QUOTE_HEADER_ID := FND_API.G_MISS_NUM;
2154 P_Qte_Opportunity_Row_Rec.O_CUST_ACCOUNT_ID := FND_API.G_MISS_NUM;
2155 P_Qte_Opportunity_Row_Rec.O_QUOTE_EXP_DATE := FND_API.G_MISS_DATE;
2156 P_Qte_Opportunity_Row_Rec.O_QUOTE_STATUS_ID := FND_API.G_MISS_NUM;
2157 P_Qte_Opportunity_Row_Rec.O_ORG_ID := FND_API.G_MISS_NUM;
2158 P_Qte_Opportunity_Row_Rec.O_CREATED_BY := FND_API.G_MISS_NUM;
2159 P_Qte_Opportunity_Row_Rec.O_ORDER_TYPE_ID := FND_API.G_MISS_NUM;
2160 P_Qte_Opportunity_Row_Rec.O_CONTRACT_ID := FND_API.G_MISS_NUM;
2161 P_Qte_Opportunity_Row_Rec.O_PRICE_LIST_ID := FND_API.G_MISS_NUM;
2162 P_Qte_Opportunity_Row_Rec.O_CURRENCY_CODE := FND_API.G_MISS_CHAR;
2163 P_Qte_Opportunity_Row_Rec.O_PRICE_FROZEN_DATE := FND_API.G_MISS_DATE;
2164 P_Qte_Opportunity_Row_Rec.O_CONTRACT_TEMPLATE_ID := FND_API.G_MISS_NUM;
2165 P_Qte_Opportunity_Row_Rec.O_RESOURCE_ID := FND_API.G_MISS_NUM;
2166 P_Qte_Opportunity_Row_Rec.O_RESOURCE_GRP_ID := FND_API.G_MISS_NUM;
2167 P_Qte_Opportunity_Row_Rec.O_SALES_CHANNEL_CODE := FND_API.G_MISS_CHAR;
2168 P_Qte_Opportunity_Row_Rec.O_MKTING_SRC_CODE_ID := FND_API.G_MISS_NUM;
2169 P_Qte_Opportunity_Row_Rec.O_PARTY_ID := FND_API.G_MISS_NUM;
2170 P_Qte_Opportunity_Row_Rec.O_PHONE_ID := FND_API.G_MISS_NUM;
2171 P_Qte_Opportunity_Row_Rec.O_SOLD_TO_PARTY_SITE_ID := FND_API.G_MISS_NUM ;
2172 P_Qte_Opportunity_Row_Rec.O_INV_CUST_PTY_ID := FND_API.G_MISS_NUM;
2173 P_Qte_Opportunity_Row_Rec.O_INV_CUST_ACCT_ID := FND_API.G_MISS_NUM;
2174 P_Qte_Opportunity_Row_Rec.O_INV_PTY_SITE_ID := FND_API.G_MISS_NUM;
2175 P_Qte_Opportunity_Row_Rec.O_INV_PTY_ID := FND_API.G_MISS_NUM;
2176 P_Qte_Opportunity_Row_Rec.O_CUST_PARTY_ID := FND_API.G_MISS_NUM ;
2177 P_Qte_Opportunity_Row_Rec.O_END_CUST_CUST_PTY_ID := FND_API.G_MISS_NUM;
2178 P_Qte_Opportunity_Row_Rec.O_END_CUST_CUST_ACCT_ID := FND_API.G_MISS_NUM;
2179 P_Qte_Opportunity_Row_Rec.O_END_CUST_PTY_SITE_ID := FND_API.G_MISS_NUM;
2180 P_Qte_Opportunity_Row_Rec.O_END_CUST_PTY_ID := FND_API.G_MISS_NUM;
2181 P_Qte_Opportunity_Row_Rec.O_AUTOMATIC_PRICE_FLAG := FND_API.G_MISS_CHAR;
2182 P_Qte_Opportunity_Row_Rec.O_AUTOMATIC_TAX_FLAG := FND_API.G_MISS_CHAR;
2183 P_Qte_Opportunity_Row_Rec.O_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
2184 P_Qte_Opportunity_Row_Rec.O_OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
2185 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
2186 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
2187 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
2188 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
2189 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
2190 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
2191 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
2192 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
2193 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
2194 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
2195 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
2196 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
2197 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
2198 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
2199 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
2200 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
2201 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
2202 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
2203 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
2204 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
2205 P_Qte_Opportunity_Row_Rec.O_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
2206 P_Qte_Opportunity_Row_Rec.O_SHIP_TO_CUST_PTY_ID := FND_API.G_MISS_NUM;
2207 P_Qte_Opportunity_Row_Rec.O_SHIP_TO_CUST_ACCT_ID := FND_API.G_MISS_NUM;
2208 P_Qte_Opportunity_Row_Rec.O_SHIP_TO_PTY_SITE_ID := FND_API.G_MISS_NUM;
2209 P_Qte_Opportunity_Row_Rec.O_SHIP_TO_PTY_ID := FND_API.G_MISS_NUM;
2210 P_Qte_Opportunity_Row_Rec.O_PAYMENT_TERM_ID := FND_API.G_MISS_NUM;
2211 P_Qte_Opportunity_Row_Rec.O_CUST_PO_NUMBER := FND_API.G_MISS_CHAR ;
2212 P_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_CODE := FND_API.G_MISS_CHAR ;
2213 P_Qte_Opportunity_Row_Rec.O_PAYMENT_REF_NUMBER := FND_API.G_MISS_CHAR ;
2214 P_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_HLD_NAME := FND_API.G_MISS_CHAR ;
2215 P_Qte_Opportunity_Row_Rec.O_CREDIT_CARD_EXP_DATE := FND_API.G_MISS_DATE ;
2216 P_Qte_Opportunity_Row_Rec.O_PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR ;
2217 P_Qte_Opportunity_Row_Rec.O_REQUEST_DATE_TYPE := FND_API.G_MISS_CHAR ;
2218 P_Qte_Opportunity_Row_Rec.O_REQUEST_DATE := FND_API.G_MISS_DATE;
2219 P_Qte_Opportunity_Row_Rec.O_SHIP_METHOD_CODE := FND_API.G_MISS_CHAR;
2220 P_Qte_Opportunity_Row_Rec.O_SHIPMENT_PRIORITY_CODE := FND_API.G_MISS_CHAR;
2221 P_Qte_Opportunity_Row_Rec.O_FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;
2222 P_Qte_Opportunity_Row_Rec.O_FOB_CODE := FND_API.G_MISS_CHAR;
2223 P_Qte_Opportunity_Row_Rec.O_SHIPPING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
2224 P_Qte_Opportunity_Row_Rec.O_PACKING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
2225 P_Qte_Opportunity_Row_Rec.O_DEMAND_CLASS_CODE := FND_API.G_MISS_CHAR;
2226 P_Qte_Opportunity_Row_Rec.O_APPLICATION_TYPE_CODE := FND_API.G_MISS_CHAR;
2227 P_Qte_Opportunity_Row_Rec.O_QUOTE_TO_CUST_TYPE := FND_API.G_MISS_CHAR;
2228 P_Qte_Opportunity_Row_Rec.O_OPPTY_ID := FND_API.G_MISS_NUM;
2229 P_Qte_Opportunity_Row_Rec.O_OPPTY_CURRENCY_CODE := FND_API.G_MISS_CHAR;
2230 P_Qte_Opportunity_Row_Rec.O_OPPTY_CHANNEL_CODE := FND_API.G_MISS_CHAR;
2231 P_Qte_Opportunity_Row_Rec.O_OPPTY_QUOTE_NAME := FND_API.G_MISS_CHAR;
2232 P_Qte_Opportunity_Row_Rec.O_OPPTY_CUST_PARTY_ID := FND_API.G_MISS_NUM;
2233 P_Qte_Opportunity_Row_Rec.O_OPPTY_MKTG_SRC_CD_ID := FND_API.G_MISS_NUM;
2234 P_Qte_Opportunity_Row_Rec.O_OPPTY_SLD_PTY_ST_ID := FND_API.G_MISS_NUM;
2235 P_Qte_Opportunity_Row_Rec.O_OPPTY_SLD_TO_CONT_ID := FND_API.G_MISS_NUM;
2236
2237 ELSIF P_Entity_Code = 'QUOTE_LINE' THEN
2238 P_Qte_Line_Row_Rec.L_QUOTE_HEADER_ID := FND_API.G_MISS_NUM;
2239 P_Qte_Line_Row_Rec.L_QUOTE_LINE_ID := FND_API.G_MISS_NUM;
2240 P_Qte_Line_Row_Rec.L_LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
2241 P_Qte_Line_Row_Rec.L_OBJECT_VERSION_NUMBER := FND_API.G_MISS_NUM;
2242 P_Qte_Line_Row_Rec.L_ATTRIBUTE_CATEGORY := FND_API.G_MISS_CHAR;
2243 P_Qte_Line_Row_Rec.L_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
2244 P_Qte_Line_Row_Rec.L_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
2245 P_Qte_Line_Row_Rec.L_ATTRIBUTE3 := FND_API.G_MISS_CHAR;
2246 P_Qte_Line_Row_Rec.L_ATTRIBUTE4 := FND_API.G_MISS_CHAR;
2247 P_Qte_Line_Row_Rec.L_ATTRIBUTE5 := FND_API.G_MISS_CHAR;
2248 P_Qte_Line_Row_Rec.L_ATTRIBUTE6 := FND_API.G_MISS_CHAR;
2249 P_Qte_Line_Row_Rec.L_ATTRIBUTE7 := FND_API.G_MISS_CHAR;
2250 P_Qte_Line_Row_Rec.L_ATTRIBUTE8 := FND_API.G_MISS_CHAR;
2251 P_Qte_Line_Row_Rec.L_ATTRIBUTE9 := FND_API.G_MISS_CHAR;
2252 P_Qte_Line_Row_Rec.L_ATTRIBUTE10 := FND_API.G_MISS_CHAR;
2253 P_Qte_Line_Row_Rec.L_ATTRIBUTE11 := FND_API.G_MISS_CHAR;
2254 P_Qte_Line_Row_Rec.L_ATTRIBUTE12 := FND_API.G_MISS_CHAR;
2255 P_Qte_Line_Row_Rec.L_ATTRIBUTE13 := FND_API.G_MISS_CHAR;
2256 P_Qte_Line_Row_Rec.L_ATTRIBUTE14 := FND_API.G_MISS_CHAR;
2257 P_Qte_Line_Row_Rec.L_ATTRIBUTE15 := FND_API.G_MISS_CHAR;
2258 P_Qte_Line_Row_Rec.L_ATTRIBUTE16 := FND_API.G_MISS_CHAR;
2259 P_Qte_Line_Row_Rec.L_ATTRIBUTE17 := FND_API.G_MISS_CHAR;
2260 P_Qte_Line_Row_Rec.L_ATTRIBUTE18 := FND_API.G_MISS_CHAR;
2261 P_Qte_Line_Row_Rec.L_ATTRIBUTE19 := FND_API.G_MISS_CHAR;
2262 P_Qte_Line_Row_Rec.L_ATTRIBUTE20 := FND_API.G_MISS_CHAR;
2263 P_Qte_Line_Row_Rec.L_CREATED_BY := FND_API.G_MISS_NUM;
2264 P_Qte_Line_Row_Rec.L_ORG_ID := FND_API.G_MISS_NUM;
2265 P_Qte_Line_Row_Rec.L_ORDER_LINE_TYPE_ID := FND_API.G_MISS_NUM;
2266 P_Qte_Line_Row_Rec.L_LINE_CATEGORY_CODE := FND_API.G_MISS_CHAR;
2267 P_Qte_Line_Row_Rec.L_PERIODICITY_CODE := FND_API.G_MISS_CHAR;
2268 P_Qte_Line_Row_Rec.L_AGREEMENT_ID := FND_API.G_MISS_NUM;
2269 P_Qte_Line_Row_Rec.L_PRICE_LIST_ID := FND_API.G_MISS_NUM;
2270 P_Qte_Line_Row_Rec.L_INV_TO_CUST_ACCT_ID := FND_API.G_MISS_NUM;
2271 P_Qte_Line_Row_Rec.L_INV_TO_CUST_PTY_ID := FND_API.G_MISS_NUM;
2272 P_Qte_Line_Row_Rec.L_INV_TO_PTY_ID := FND_API.G_MISS_NUM;
2273 P_Qte_Line_Row_Rec.L_INV_TO_PTY_SITE_ID := FND_API.G_MISS_NUM;
2274 P_Qte_Line_Row_Rec.L_SHIP_TO_CUST_ACCT_ID := FND_API.G_MISS_NUM;
2275 P_Qte_Line_Row_Rec.L_SHIP_TO_CUST_PARTY_ID := FND_API.G_MISS_NUM;
2276 P_Qte_Line_Row_Rec.L_SHIP_TO_PARTY_ID := FND_API.G_MISS_NUM;
2277 P_Qte_Line_Row_Rec.L_SHIP_TO_PARTY_SITE_ID := FND_API.G_MISS_NUM;
2278 P_Qte_Line_Row_Rec.L_END_CUST_CUST_ACCT_ID := FND_API.G_MISS_NUM;
2279 P_Qte_Line_Row_Rec.L_END_CUST_CUST_PTY_ID := FND_API.G_MISS_NUM;
2280 P_Qte_Line_Row_Rec.L_END_CUST_PTY_ID := FND_API.G_MISS_NUM;
2281 P_Qte_Line_Row_Rec.L_END_CUST_PTY_SITE_ID := FND_API.G_MISS_NUM;
2282 P_Qte_Line_Row_Rec.L_CREDIT_CARD_CODE := FND_API.G_MISS_CHAR;
2283 P_Qte_Line_Row_Rec.L_CREDIT_CARD_EXP_DATE := FND_API.G_MISS_DATE;
2284 P_Qte_Line_Row_Rec.L_CREDIT_CARD_HLD_NAME := FND_API.G_MISS_CHAR;
2285 P_Qte_Line_Row_Rec.L_CUST_PO_NUMBER := FND_API.G_MISS_CHAR;
2286 P_Qte_Line_Row_Rec.L_CUST_PO_LINE_NUMBER := FND_API.G_MISS_CHAR;
2287 P_Qte_Line_Row_Rec.L_PAYMENT_REF_NUMBER := FND_API.G_MISS_CHAR;
2288 P_Qte_Line_Row_Rec.L_PAYMENT_TERM_ID := FND_API.G_MISS_NUM;
2289 P_Qte_Line_Row_Rec.L_PAYMENT_TYPE_CODE := FND_API.G_MISS_CHAR;
2290 P_Qte_Line_Row_Rec.L_REQUEST_DATE := FND_API.G_MISS_DATE;
2291 P_Qte_Line_Row_Rec.L_SHIP_METHOD_CODE := FND_API.G_MISS_CHAR;
2292 P_Qte_Line_Row_Rec.L_SHIPMENT_PRIORITY_CODE := FND_API.G_MISS_CHAR;
2293 P_Qte_Line_Row_Rec.L_SHIP_FROM_ORG_ID := FND_API.G_MISS_NUM;
2294 P_Qte_Line_Row_Rec.L_DEMAND_CLASS_CODE := FND_API.G_MISS_CHAR;
2295 P_Qte_Line_Row_Rec.L_FOB_CODE := FND_API.G_MISS_CHAR;
2296 P_Qte_Line_Row_Rec.L_FREIGHT_TERMS_CODE := FND_API.G_MISS_CHAR;
2297 P_Qte_Line_Row_Rec.L_PACKING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
2298 P_Qte_Line_Row_Rec.L_SHIPPING_INSTRUCTIONS := FND_API.G_MISS_CHAR;
2299 P_Qte_Line_Row_Rec.L_APPLICATION_TYPE_CODE := FND_API.G_MISS_CHAR;
2300 P_Qte_Line_Row_Rec.L_QUOTE_CUSTOMER_TYPE := FND_API.G_MISS_CHAR;
2301
2302 END IF;
2303
2304 END Initialize_Row_Type;
2305
2306
2307 END ASO_DEFAULTING_UTIL;