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