[Home] [Help]
PACKAGE BODY: APPS.ASO_QUOTE_HEADERS_PKG
Source
1 PACKAGE BODY ASO_QUOTE_HEADERS_PKG as
2 /* $Header: asotqteb.pls 120.0 2005/05/31 12:17:54 appldev noship $ */
3 -- Start of Comments
4 -- Package name : ASO_QUOTE_HEADERS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_QUOTE_HEADERS_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotqteb.pls';
13
14 PROCEDURE Insert_Row(
15 px_QUOTE_HEADER_ID IN OUT NOCOPY NUMBER,
16 p_CREATION_DATE DATE,
17 p_CREATED_BY NUMBER,
18 p_LAST_UPDATE_DATE DATE,
19 p_LAST_UPDATED_BY NUMBER,
20 p_LAST_UPDATE_LOGIN NUMBER,
21 p_REQUEST_ID NUMBER,
22 p_PROGRAM_APPLICATION_ID NUMBER,
23 p_PROGRAM_ID NUMBER,
24 p_PROGRAM_UPDATE_DATE DATE,
25 p_ORG_ID NUMBER,
26 p_QUOTE_NAME VARCHAR2,
27 p_QUOTE_NUMBER NUMBER,
28 p_QUOTE_VERSION NUMBER,
29 p_QUOTE_STATUS_ID NUMBER,
30 p_QUOTE_SOURCE_CODE VARCHAR2,
31 p_QUOTE_EXPIRATION_DATE DATE,
32 p_PRICE_FROZEN_DATE DATE,
33 p_QUOTE_PASSWORD VARCHAR2,
34 p_ORIGINAL_SYSTEM_REFERENCE VARCHAR2,
35 p_PARTY_ID NUMBER,
36 p_CUST_ACCOUNT_ID NUMBER,
37 p_INVOICE_TO_CUST_ACCOUNT_ID NUMBER,
38 p_ORG_CONTACT_ID NUMBER,
39 p_PHONE_ID NUMBER,
40 p_INVOICE_TO_PARTY_SITE_ID NUMBER,
41 p_INVOICE_TO_PARTY_ID NUMBER,
42 p_ORIG_MKTG_SOURCE_CODE_ID NUMBER,
43 p_MARKETING_SOURCE_CODE_ID NUMBER,
44 p_ORDER_TYPE_ID NUMBER,
45 p_QUOTE_CATEGORY_CODE VARCHAR2,
46 p_ORDERED_DATE DATE,
47 p_ACCOUNTING_RULE_ID NUMBER,
48 p_INVOICING_RULE_ID NUMBER,
49 p_EMPLOYEE_PERSON_ID NUMBER,
50 p_PRICE_LIST_ID NUMBER,
51 p_CURRENCY_CODE VARCHAR2,
52 p_TOTAL_LIST_PRICE NUMBER,
53 p_TOTAL_ADJUSTED_AMOUNT NUMBER,
54 p_TOTAL_ADJUSTED_PERCENT NUMBER,
55 p_TOTAL_TAX NUMBER,
56 p_TOTAL_SHIPPING_CHARGE NUMBER,
57 p_SURCHARGE NUMBER,
58 p_TOTAL_QUOTE_PRICE NUMBER,
59 p_PAYMENT_AMOUNT NUMBER,
60 p_EXCHANGE_RATE NUMBER,
61 p_EXCHANGE_TYPE_CODE VARCHAR2,
62 p_EXCHANGE_RATE_DATE DATE,
63 p_CONTRACT_ID NUMBER,
64 p_SALES_CHANNEL_CODE VARCHAR2,
65 p_ORDER_ID NUMBER,
66 p_RESOURCE_ID NUMBER,
67 p_ATTRIBUTE_CATEGORY VARCHAR2,
68 p_ATTRIBUTE1 VARCHAR2,
69 p_ATTRIBUTE2 VARCHAR2,
70 p_ATTRIBUTE3 VARCHAR2,
71 p_ATTRIBUTE4 VARCHAR2,
72 p_ATTRIBUTE5 VARCHAR2,
73 p_ATTRIBUTE6 VARCHAR2,
74 p_ATTRIBUTE7 VARCHAR2,
75 p_ATTRIBUTE8 VARCHAR2,
76 p_ATTRIBUTE9 VARCHAR2,
77 p_ATTRIBUTE10 VARCHAR2,
78 p_ATTRIBUTE11 VARCHAR2,
79 p_ATTRIBUTE12 VARCHAR2,
80 p_ATTRIBUTE13 VARCHAR2,
81 p_ATTRIBUTE14 VARCHAR2,
82 p_ATTRIBUTE15 VARCHAR2,
83 p_ATTRIBUTE16 VARCHAR2,
84 p_ATTRIBUTE17 VARCHAR2,
85 p_ATTRIBUTE18 VARCHAR2,
86 p_ATTRIBUTE19 VARCHAR2,
87 p_ATTRIBUTE20 VARCHAR2,
88 p_CONTRACT_TEMPLATE_ID NUMBER,
89 p_CONTRACT_TEMPLATE_MAJOR_VER NUMBER,
90 p_CONTRACT_REQUESTER_ID NUMBER,
91 p_CONTRACT_APPROVAL_LEVEL VARCHAR2,
92 p_PUBLISH_FLAG VARCHAR2,
93 p_RESOURCE_GRP_ID NUMBER,
94 p_SOLD_TO_PARTY_SITE_ID NUMBER,
95 p_DISPLAY_ARITHMETIC_OPERATOR varchar2,
96 p_MAX_VERSION_FLAG VARCHAR2,
97 p_QUOTE_TYPE VARCHAR2,
98 p_QUOTE_DESCRIPTION VARCHAR2,
99 p_MINISITE_ID NUMBER,
100 p_CUST_PARTY_ID NUMBER,
101 p_INVOICE_TO_CUST_PARTY_ID NUMBER,
102 p_PRICING_STATUS_INDICATOR VARCHAR2,
103 p_TAX_STATUS_INDICATOR VARCHAR2,
104 p_PRICE_UPDATED_DATE DATE,
105 p_TAX_UPDATED_DATE DATE,
106 p_RECALCULATE_FLAG VARCHAR2,
107 p_PRICE_REQUEST_ID NUMBER,
108 p_CREDIT_UPDATE_DATE DATE,
109 -- hyang new okc
110 P_Customer_Name_And_Title VARCHAR2,
111 P_Customer_Signature_Date DATE,
112 P_Supplier_Name_And_Title VARCHAR2,
113 P_Supplier_Signature_Date DATE,
114 -- end of hyang new okc
115 p_END_CUSTOMER_PARTY_ID NUMBER,
116 p_END_CUSTOMER_CUST_PARTY_ID NUMBER,
117 p_END_CUSTOMER_PARTY_SITE_ID NUMBER,
118 p_END_CUSTOMER_CUST_ACCOUNT_ID NUMBER,
119 p_OBJECT_VERSION_NUMBER NUMBER,
120 p_ASSISTANCE_REQUESTED VARCHAR2,
121 p_ASSISTANCE_REASON_CODE VARCHAR2,
122 p_AUTOMATIC_PRICE_FLAG VARCHAR2,
123 p_AUTOMATIC_TAX_FLAG VARCHAR2,
124 p_HEADER_PAYNOW_CHARGES NUMBER
125 )
126
127 IS
128 CURSOR C2 IS SELECT ASO_QUOTE_HEADERS_S.nextval FROM sys.dual;
129 BEGIN
130 If (px_QUOTE_HEADER_ID IS NULL) OR (px_QUOTE_HEADER_ID = FND_API.G_MISS_NUM) then
131 OPEN C2;
132 FETCH C2 INTO px_QUOTE_HEADER_ID;
133 CLOSE C2;
134 End If;
135
136 INSERT INTO ASO_QUOTE_HEADERS_ALL(
137 QUOTE_HEADER_ID,
138 CREATION_DATE,
139 CREATED_BY,
140 LAST_UPDATE_DATE,
141 LAST_UPDATED_BY,
142 LAST_UPDATE_LOGIN,
143 REQUEST_ID,
144 PROGRAM_APPLICATION_ID,
145 PROGRAM_ID,
146 PROGRAM_UPDATE_DATE,
147 ORG_ID,
148 QUOTE_NAME,
149 QUOTE_NUMBER,
150 QUOTE_VERSION,
151 QUOTE_STATUS_ID,
152 QUOTE_SOURCE_CODE,
153 QUOTE_EXPIRATION_DATE,
154 PRICE_FROZEN_DATE,
155 QUOTE_PASSWORD,
156 ORIGINAL_SYSTEM_REFERENCE,
157 PARTY_ID,
158 CUST_ACCOUNT_ID,
159 INVOICE_TO_CUST_ACCOUNT_ID,
160 ORG_CONTACT_ID,
161 PHONE_ID,
162 INVOICE_TO_PARTY_SITE_ID,
163 INVOICE_TO_PARTY_ID,
164 ORIG_MKTG_SOURCE_CODE_ID,
165 MARKETING_SOURCE_CODE_ID,
166 ORDER_TYPE_ID,
167 QUOTE_CATEGORY_CODE,
168 ORDERED_DATE,
169 ACCOUNTING_RULE_ID,
170 INVOICING_RULE_ID,
171 EMPLOYEE_PERSON_ID,
172 PRICE_LIST_ID,
173 CURRENCY_CODE,
174 TOTAL_LIST_PRICE,
175 TOTAL_ADJUSTED_AMOUNT,
176 TOTAL_ADJUSTED_PERCENT,
177 TOTAL_TAX,
178 TOTAL_SHIPPING_CHARGE,
179 SURCHARGE,
180 TOTAL_QUOTE_PRICE,
181 PAYMENT_AMOUNT,
182 EXCHANGE_RATE,
183 EXCHANGE_TYPE_CODE,
184 EXCHANGE_RATE_DATE,
185 CONTRACT_ID,
186 SALES_CHANNEL_CODE,
187 ORDER_ID,
188 RESOURCE_ID,
189 ATTRIBUTE_CATEGORY,
190 ATTRIBUTE1,
191 ATTRIBUTE2,
192 ATTRIBUTE3,
193 ATTRIBUTE4,
194 ATTRIBUTE5,
195 ATTRIBUTE6,
196 ATTRIBUTE7,
197 ATTRIBUTE8,
198 ATTRIBUTE9,
199 ATTRIBUTE10,
200 ATTRIBUTE11,
201 ATTRIBUTE12,
202 ATTRIBUTE13,
203 ATTRIBUTE14,
204 ATTRIBUTE15,
205 ATTRIBUTE16,
206 ATTRIBUTE17,
207 ATTRIBUTE18,
208 ATTRIBUTE19,
209 ATTRIBUTE20,
210 CONTRACT_TEMPLATE_ID,
211 CONTRACT_TEMPLATE_MAJOR_VER,
212 CONTRACT_REQUESTER_ID,
213 CONTRACT_APPROVAL_LEVEL,
214 PUBLISH_FLAG,
215 RESOURCE_GRP_ID,
216 SOLD_TO_PARTY_SITE_ID,
217 DISPLAY_ARITHMETIC_OPERATOR ,
218 MAX_VERSION_FLAG,
219 QUOTE_TYPE,
220 QUOTE_DESCRIPTION,
221 MINISITE_ID,
222 CUST_PARTY_ID,
223 INVOICE_TO_CUST_PARTY_ID,
224 PRICING_STATUS_INDICATOR,
225 TAX_STATUS_INDICATOR,
226 PRICE_UPDATED_DATE,
227 TAX_UPDATED_DATE,
228 RECALCULATE_FLAG,
229 PRICE_REQUEST_ID,
230 CREDIT_UPDATE_DATE,
231 -- hyang new okc
232 Customer_Name_And_Title,
233 Customer_Signature_Date,
234 Supplier_Name_And_Title,
235 Supplier_Signature_Date,
236 -- end of hyang new okc
237 END_CUSTOMER_PARTY_ID,
238 END_CUSTOMER_CUST_PARTY_ID,
239 END_CUSTOMER_PARTY_SITE_ID,
240 END_CUSTOMER_CUST_ACCOUNT_ID,
241 OBJECT_VERSION_NUMBER,
242 ASSISTANCE_REQUESTED,
243 ASSISTANCE_REASON_CODE,
244 AUTOMATIC_PRICE_FLAG,
245 AUTOMATIC_TAX_FLAG,
246 HEADER_PAYNOW_CHARGES
247
248 ) VALUES (
249 px_QUOTE_HEADER_ID,
250 ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
251 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
252 ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
253 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
254 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
255 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
256 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
257 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
258 ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
259 decode( p_ORG_ID, FND_API.G_MISS_NUM, NULL, p_ORG_ID),
260 decode( p_QUOTE_NAME, FND_API.G_MISS_CHAR, NULL, p_QUOTE_NAME),
261 decode( p_QUOTE_NUMBER, FND_API.G_MISS_NUM, NULL, p_QUOTE_NUMBER),
262 decode( p_QUOTE_VERSION, FND_API.G_MISS_NUM, NULL, p_QUOTE_VERSION),
263 decode( p_QUOTE_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_STATUS_ID),
264 decode( p_QUOTE_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_QUOTE_SOURCE_CODE),
265 ASO_UTILITY_PVT.decode( p_QUOTE_EXPIRATION_DATE, FND_API.G_MISS_DATE, NULL, p_QUOTE_EXPIRATION_DATE),
266 ASO_UTILITY_PVT.decode( p_PRICE_FROZEN_DATE, FND_API.G_MISS_DATE, NULL, p_PRICE_FROZEN_DATE),
267 decode( p_QUOTE_PASSWORD, FND_API.G_MISS_CHAR, NULL, p_QUOTE_PASSWORD),
268 decode( p_ORIGINAL_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, NULL, p_ORIGINAL_SYSTEM_REFERENCE),
269 decode( p_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_PARTY_ID),
270 decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_CUST_ACCOUNT_ID),
271 decode( p_INVOICE_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_INVOICE_TO_CUST_ACCOUNT_ID),
272 decode( p_ORG_CONTACT_ID, FND_API.G_MISS_NUM, NULL, p_ORG_CONTACT_ID),
273 decode( p_PHONE_ID, FND_API.G_MISS_NUM, NULL, p_PHONE_ID),
274 decode( p_INVOICE_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_INVOICE_TO_PARTY_SITE_ID),
275 decode( p_INVOICE_TO_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INVOICE_TO_PARTY_ID),
276 decode( p_ORIG_MKTG_SOURCE_CODE_ID, FND_API.G_MISS_NUM, NULL, p_ORIG_MKTG_SOURCE_CODE_ID),
277 decode( p_MARKETING_SOURCE_CODE_ID, FND_API.G_MISS_NUM, NULL, p_MARKETING_SOURCE_CODE_ID),
278 decode( p_ORDER_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_TYPE_ID),
279 decode( p_QUOTE_CATEGORY_CODE, FND_API.G_MISS_CHAR, NULL, p_QUOTE_CATEGORY_CODE),
280 ASO_UTILITY_PVT.decode( p_ORDERED_DATE, FND_API.G_MISS_DATE, NULL, p_ORDERED_DATE),
281 decode( p_ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM, NULL, p_ACCOUNTING_RULE_ID),
282 decode( p_INVOICING_RULE_ID, FND_API.G_MISS_NUM, NULL, p_INVOICING_RULE_ID),
283 decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
284 decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, NULL, p_PRICE_LIST_ID),
285 decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
286 decode( p_TOTAL_LIST_PRICE, FND_API.G_MISS_NUM, NULL, p_TOTAL_LIST_PRICE),
287 decode( p_TOTAL_ADJUSTED_AMOUNT, FND_API.G_MISS_NUM, NULL, p_TOTAL_ADJUSTED_AMOUNT),
288 decode( p_TOTAL_ADJUSTED_PERCENT, FND_API.G_MISS_NUM, NULL, p_TOTAL_ADJUSTED_PERCENT),
289 decode( p_TOTAL_TAX, FND_API.G_MISS_NUM, NULL, p_TOTAL_TAX),
290 decode( p_TOTAL_SHIPPING_CHARGE, FND_API.G_MISS_NUM, NULL, p_TOTAL_SHIPPING_CHARGE),
291 decode( p_SURCHARGE, FND_API.G_MISS_NUM, NULL, p_SURCHARGE),
292 decode( p_TOTAL_QUOTE_PRICE, FND_API.G_MISS_NUM, NULL, p_TOTAL_QUOTE_PRICE),
293 decode( p_PAYMENT_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PAYMENT_AMOUNT),
294 decode( p_EXCHANGE_RATE, FND_API.G_MISS_NUM, NULL, p_EXCHANGE_RATE),
295 decode( p_EXCHANGE_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_EXCHANGE_TYPE_CODE),
296 ASO_UTILITY_PVT.decode( p_EXCHANGE_RATE_DATE, FND_API.G_MISS_DATE, NULL, p_EXCHANGE_RATE_DATE),
297 decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_ID),
298 decode( p_SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR, NULL, p_SALES_CHANNEL_CODE),
299 decode( p_ORDER_ID, FND_API.G_MISS_NUM, NULL, p_ORDER_ID),
300 decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_ID),
301 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
302 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
303 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
304 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
305 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
306 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
307 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
308 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
309 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
310 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
311 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
312 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
313 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
314 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
315 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
316 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
317 decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
318 decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
319 decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
320 decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
321 decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
322 decode( p_CONTRACT_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_TEMPLATE_ID),
323 decode( p_CONTRACT_TEMPLATE_MAJOR_VER, FND_API.G_MISS_NUM, NULL, p_CONTRACT_TEMPLATE_MAJOR_VER),
324 decode( p_CONTRACT_REQUESTER_ID, FND_API.G_MISS_NUM, NULL, p_CONTRACT_REQUESTER_ID),
325 decode( p_CONTRACT_APPROVAL_LEVEL, FND_API.G_MISS_CHAR, NULL, p_CONTRACT_APPROVAL_LEVEL),
326 decode( p_PUBLISH_FLAG, FND_API.G_MISS_CHAR, NULL, p_PUBLISH_FLAG),
327 decode( p_RESOURCE_GRP_ID, FND_API.G_MISS_NUM, NULL, p_RESOURCE_GRP_ID),
328 decode( p_SOLD_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_SOLD_TO_PARTY_SITE_ID),
329 decode( p_DISPLAY_ARITHMETIC_OPERATOR,FND_API.G_MISS_CHAR, NULL,p_DISPLAY_ARITHMETIC_OPERATOR),
330 decode( p_MAX_VERSION_FLAG,FND_API.G_MISS_CHAR, NULL,p_MAX_VERSION_FLAG),
331 decode( p_QUOTE_TYPE,FND_API.G_MISS_CHAR, NULL,p_QUOTE_TYPE),
332 decode( p_QUOTE_DESCRIPTION,FND_API.G_MISS_CHAR, NULL,p_QUOTE_DESCRIPTION),
333 decode( p_MINISITE_ID, FND_API.G_MISS_NUM, NULL, p_MINISITE_ID),
334 decode( p_CUST_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_CUST_PARTY_ID),
335 decode( p_INVOICE_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_INVOICE_TO_CUST_PARTY_ID),
339 decode( p_TAX_UPDATED_DATE,FND_API.G_MISS_DATE, NULL,p_TAX_UPDATED_DATE),
336 decode( p_PRICING_STATUS_INDICATOR,FND_API.G_MISS_CHAR, NULL,p_PRICING_STATUS_INDICATOR),
337 decode( p_TAX_STATUS_INDICATOR,FND_API.G_MISS_CHAR, NULL,p_TAX_STATUS_INDICATOR),
338 decode( p_PRICE_UPDATED_DATE,FND_API.G_MISS_DATE, NULL,p_PRICE_UPDATED_DATE),
340 decode( p_RECALCULATE_FLAG,FND_API.G_MISS_CHAR, NULL,p_RECALCULATE_FLAG),
341 decode( p_PRICE_REQUEST_ID,FND_API.G_MISS_NUM, NULL,p_PRICE_REQUEST_ID),
342 decode( p_CREDIT_UPDATE_DATE,FND_API.G_MISS_DATE, NULL,p_CREDIT_UPDATE_DATE),
343 -- hyang new okc
344 DECODE( P_Customer_Name_And_Title, FND_API.G_MISS_CHAR, NULL, P_Customer_Name_And_Title),
345 DECODE( P_Customer_Signature_Date, FND_API.G_MISS_DATE, NULL, P_Customer_Signature_Date),
346 DECODE( P_Supplier_Name_And_Title, FND_API.G_MISS_CHAR, NULL, P_Supplier_Name_And_Title),
347 DECODE( P_Supplier_Signature_Date, FND_API.G_MISS_DATE, NULL, P_Supplier_Signature_Date),
348 -- end of hyang new okc
349 decode( p_END_CUSTOMER_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_END_CUSTOMER_PARTY_ID),
350 decode( p_END_CUSTOMER_CUST_PARTY_ID, FND_API.G_MISS_NUM, NULL, p_END_CUSTOMER_CUST_PARTY_ID),
351 decode( p_END_CUSTOMER_PARTY_SITE_ID, FND_API.G_MISS_NUM, NULL, p_END_CUSTOMER_PARTY_SITE_ID),
352 decode( p_END_CUSTOMER_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, NULL, p_END_CUSTOMER_CUST_ACCOUNT_ID),
353 decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER),
354 decode( p_ASSISTANCE_REQUESTED, FND_API.G_MISS_CHAR, NULL, p_ASSISTANCE_REQUESTED),
355 decode( p_ASSISTANCE_REASON_CODE, FND_API.G_MISS_CHAR, NULL, p_ASSISTANCE_REASON_CODE),
356 decode( p_AUTOMATIC_PRICE_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_PRICE_FLAG),
357 decode( p_AUTOMATIC_TAX_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_TAX_FLAG),
358 decode( p_HEADER_PAYNOW_CHARGES,FND_API.G_MISS_NUM,NULL,p_HEADER_PAYNOW_CHARGES)
359 );
360 End Insert_Row;
361
362 PROCEDURE Update_Row(
363 p_QUOTE_HEADER_ID NUMBER,
364 p_CREATION_DATE DATE,
365 p_CREATED_BY NUMBER,
366 p_LAST_UPDATE_DATE DATE,
367 p_LAST_UPDATED_BY NUMBER,
368 p_LAST_UPDATE_LOGIN NUMBER,
369 p_REQUEST_ID NUMBER,
370 p_PROGRAM_APPLICATION_ID NUMBER,
371 p_PROGRAM_ID NUMBER,
372 p_PROGRAM_UPDATE_DATE DATE,
373 p_ORG_ID NUMBER,
374 p_QUOTE_NAME VARCHAR2,
375 p_QUOTE_NUMBER NUMBER,
376 p_QUOTE_VERSION NUMBER,
377 p_QUOTE_STATUS_ID NUMBER,
378 p_QUOTE_SOURCE_CODE VARCHAR2,
379 p_QUOTE_EXPIRATION_DATE DATE,
380 p_PRICE_FROZEN_DATE DATE,
381 p_QUOTE_PASSWORD VARCHAR2,
382 p_ORIGINAL_SYSTEM_REFERENCE VARCHAR2,
383 p_PARTY_ID NUMBER,
384 p_CUST_ACCOUNT_ID NUMBER,
385 p_INVOICE_TO_CUST_ACCOUNT_ID NUMBER,
386 p_ORG_CONTACT_ID NUMBER,
387 p_PHONE_ID NUMBER,
388 p_INVOICE_TO_PARTY_SITE_ID NUMBER,
389 p_INVOICE_TO_PARTY_ID NUMBER,
390 p_ORIG_MKTG_SOURCE_CODE_ID NUMBER,
391 p_MARKETING_SOURCE_CODE_ID NUMBER,
392 p_ORDER_TYPE_ID NUMBER,
393 p_QUOTE_CATEGORY_CODE VARCHAR2,
394 p_ORDERED_DATE DATE,
395 p_ACCOUNTING_RULE_ID NUMBER,
396 p_INVOICING_RULE_ID NUMBER,
397 p_EMPLOYEE_PERSON_ID NUMBER,
398 p_PRICE_LIST_ID NUMBER,
399 p_CURRENCY_CODE VARCHAR2,
400 p_TOTAL_LIST_PRICE NUMBER,
401 p_TOTAL_ADJUSTED_AMOUNT NUMBER,
402 p_TOTAL_ADJUSTED_PERCENT NUMBER,
403 p_TOTAL_TAX NUMBER,
404 p_TOTAL_SHIPPING_CHARGE NUMBER,
405 p_SURCHARGE NUMBER,
406 p_TOTAL_QUOTE_PRICE NUMBER,
407 p_PAYMENT_AMOUNT NUMBER,
408 p_EXCHANGE_RATE NUMBER,
409 p_EXCHANGE_TYPE_CODE VARCHAR2,
410 p_EXCHANGE_RATE_DATE DATE,
411 p_CONTRACT_ID NUMBER,
412 p_SALES_CHANNEL_CODE VARCHAR2,
413 p_ORDER_ID NUMBER,
414 p_RESOURCE_ID NUMBER,
415 p_ATTRIBUTE_CATEGORY VARCHAR2,
416 p_ATTRIBUTE1 VARCHAR2,
417 p_ATTRIBUTE2 VARCHAR2,
418 p_ATTRIBUTE3 VARCHAR2,
419 p_ATTRIBUTE4 VARCHAR2,
420 p_ATTRIBUTE5 VARCHAR2,
421 p_ATTRIBUTE6 VARCHAR2,
422 p_ATTRIBUTE7 VARCHAR2,
423 p_ATTRIBUTE8 VARCHAR2,
424 p_ATTRIBUTE9 VARCHAR2,
425 p_ATTRIBUTE10 VARCHAR2,
426 p_ATTRIBUTE11 VARCHAR2,
427 p_ATTRIBUTE12 VARCHAR2,
428 p_ATTRIBUTE13 VARCHAR2,
429 p_ATTRIBUTE14 VARCHAR2,
430 p_ATTRIBUTE15 VARCHAR2,
431 p_ATTRIBUTE16 VARCHAR2,
432 p_ATTRIBUTE17 VARCHAR2,
433 p_ATTRIBUTE18 VARCHAR2,
434 p_ATTRIBUTE19 VARCHAR2,
435 p_ATTRIBUTE20 VARCHAR2,
436 p_CONTRACT_TEMPLATE_ID NUMBER,
437 p_CONTRACT_TEMPLATE_MAJOR_VER NUMBER,
438 p_CONTRACT_REQUESTER_ID NUMBER,
439 p_CONTRACT_APPROVAL_LEVEL VARCHAR2,
440 p_PUBLISH_FLAG VARCHAR2,
441 p_RESOURCE_GRP_ID NUMBER,
442 p_SOLD_TO_PARTY_SITE_ID NUMBER,
443 p_DISPLAY_ARITHMETIC_OPERATOR varchar2,
444 p_MAX_VERSION_FLAG VARCHAR2,
448 p_CUST_PARTY_ID NUMBER,
445 p_QUOTE_TYPE VARCHAR2,
446 p_QUOTE_DESCRIPTION VARCHAR2,
447 p_MINISITE_ID NUMBER,
449 p_INVOICE_TO_CUST_PARTY_ID NUMBER,
450 p_PRICING_STATUS_INDICATOR VARCHAR2,
451 p_TAX_STATUS_INDICATOR VARCHAR2,
452 p_PRICE_UPDATED_DATE DATE,
453 p_TAX_UPDATED_DATE DATE,
454 p_RECALCULATE_FLAG VARCHAR2,
455 p_PRICE_REQUEST_ID NUMBER,
456 p_CREDIT_UPDATE_DATE DATE,
457 -- hyang new okc
458 P_Customer_Name_And_Title VARCHAR2,
459 P_Customer_Signature_Date DATE,
460 P_Supplier_Name_And_Title VARCHAR2,
461 P_Supplier_Signature_Date DATE,
462 -- end of hyang new okc
463 p_END_CUSTOMER_PARTY_ID NUMBER,
464 p_END_CUSTOMER_CUST_PARTY_ID NUMBER,
465 p_END_CUSTOMER_PARTY_SITE_ID NUMBER,
466 p_END_CUSTOMER_CUST_ACCOUNT_ID NUMBER,
467 p_OBJECT_VERSION_NUMBER NUMBER,
468 p_ASSISTANCE_REQUESTED VARCHAR2,
469 p_ASSISTANCE_REASON_CODE VARCHAR2,
470 p_AUTOMATIC_PRICE_FLAG VARCHAR2,
471 p_AUTOMATIC_TAX_FLAG VARCHAR2,
472 p_HEADER_PAYNOW_CHARGES NUMBER
473 )
474
475 IS
476 BEGIN
477 Update ASO_QUOTE_HEADERS_ALL
478 SET
479 /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
480 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
481 LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
482 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
483 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
484 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
485 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
486 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
487 PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
488 ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
489 QUOTE_NAME = decode( p_QUOTE_NAME, FND_API.G_MISS_CHAR, QUOTE_NAME, p_QUOTE_NAME),
490 QUOTE_NUMBER = decode( p_QUOTE_NUMBER, FND_API.G_MISS_NUM, QUOTE_NUMBER, p_QUOTE_NUMBER),
491 QUOTE_VERSION = decode( p_QUOTE_VERSION, FND_API.G_MISS_NUM, QUOTE_VERSION, p_QUOTE_VERSION),
492 QUOTE_STATUS_ID = decode( p_QUOTE_STATUS_ID, FND_API.G_MISS_NUM, QUOTE_STATUS_ID, p_QUOTE_STATUS_ID),
493 QUOTE_SOURCE_CODE = decode( p_QUOTE_SOURCE_CODE, FND_API.G_MISS_CHAR, QUOTE_SOURCE_CODE, p_QUOTE_SOURCE_CODE),
494 QUOTE_EXPIRATION_DATE = ASO_UTILITY_PVT.decode( p_QUOTE_EXPIRATION_DATE, FND_API.G_MISS_DATE, QUOTE_EXPIRATION_DATE, p_QUOTE_EXPIRATION_DATE),
495 PRICE_FROZEN_DATE = ASO_UTILITY_PVT.decode( p_PRICE_FROZEN_DATE, FND_API.G_MISS_DATE, PRICE_FROZEN_DATE, p_PRICE_FROZEN_DATE),
496 QUOTE_PASSWORD = decode( p_QUOTE_PASSWORD, FND_API.G_MISS_CHAR, QUOTE_PASSWORD, p_QUOTE_PASSWORD),
497 ORIGINAL_SYSTEM_REFERENCE = decode( p_ORIGINAL_SYSTEM_REFERENCE, FND_API.G_MISS_CHAR, ORIGINAL_SYSTEM_REFERENCE, p_ORIGINAL_SYSTEM_REFERENCE),
498 PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
499 CUST_ACCOUNT_ID = decode( p_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, CUST_ACCOUNT_ID, p_CUST_ACCOUNT_ID),
500 INVOICE_TO_CUST_ACCOUNT_ID = decode( p_INVOICE_TO_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, INVOICE_TO_CUST_ACCOUNT_ID, p_INVOICE_TO_CUST_ACCOUNT_ID),
501 ORG_CONTACT_ID = decode( p_ORG_CONTACT_ID, FND_API.G_MISS_NUM, ORG_CONTACT_ID, p_ORG_CONTACT_ID),
502 PHONE_ID = decode( p_PHONE_ID, FND_API.G_MISS_NUM, PHONE_ID, p_PHONE_ID),
503 INVOICE_TO_PARTY_SITE_ID = decode( p_INVOICE_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, INVOICE_TO_PARTY_SITE_ID, p_INVOICE_TO_PARTY_SITE_ID),
504 INVOICE_TO_PARTY_ID = decode( p_INVOICE_TO_PARTY_ID, FND_API.G_MISS_NUM, INVOICE_TO_PARTY_ID, p_INVOICE_TO_PARTY_ID),
505 ORIG_MKTG_SOURCE_CODE_ID = decode( p_ORIG_MKTG_SOURCE_CODE_ID, FND_API.G_MISS_NUM, ORIG_MKTG_SOURCE_CODE_ID, p_ORIG_MKTG_SOURCE_CODE_ID),
506 MARKETING_SOURCE_CODE_ID = decode( p_MARKETING_SOURCE_CODE_ID, FND_API.G_MISS_NUM, MARKETING_SOURCE_CODE_ID, p_MARKETING_SOURCE_CODE_ID),
507 ORDER_TYPE_ID = decode( p_ORDER_TYPE_ID, FND_API.G_MISS_NUM, ORDER_TYPE_ID, p_ORDER_TYPE_ID),
508 QUOTE_CATEGORY_CODE = decode( p_QUOTE_CATEGORY_CODE, FND_API.G_MISS_CHAR, QUOTE_CATEGORY_CODE, p_QUOTE_CATEGORY_CODE),
509 ORDERED_DATE = ASO_UTILITY_PVT.decode( p_ORDERED_DATE, FND_API.G_MISS_DATE, ORDERED_DATE, p_ORDERED_DATE),
510 ACCOUNTING_RULE_ID = decode( p_ACCOUNTING_RULE_ID, FND_API.G_MISS_NUM, ACCOUNTING_RULE_ID, p_ACCOUNTING_RULE_ID),
511 INVOICING_RULE_ID = decode( p_INVOICING_RULE_ID, FND_API.G_MISS_NUM, INVOICING_RULE_ID, p_INVOICING_RULE_ID),
512 EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, EMPLOYEE_PERSON_ID, p_EMPLOYEE_PERSON_ID),
513 PRICE_LIST_ID = decode( p_PRICE_LIST_ID, FND_API.G_MISS_NUM, PRICE_LIST_ID, p_PRICE_LIST_ID),
514 CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
515 TOTAL_LIST_PRICE = decode( p_TOTAL_LIST_PRICE, FND_API.G_MISS_NUM, TOTAL_LIST_PRICE, p_TOTAL_LIST_PRICE),
516 TOTAL_ADJUSTED_AMOUNT = decode( p_TOTAL_ADJUSTED_AMOUNT, FND_API.G_MISS_NUM, TOTAL_ADJUSTED_AMOUNT, p_TOTAL_ADJUSTED_AMOUNT),
520 SURCHARGE = decode( p_SURCHARGE, FND_API.G_MISS_NUM, SURCHARGE, p_SURCHARGE),
517 TOTAL_ADJUSTED_PERCENT = decode( p_TOTAL_ADJUSTED_PERCENT, FND_API.G_MISS_NUM, TOTAL_ADJUSTED_PERCENT, p_TOTAL_ADJUSTED_PERCENT),
518 TOTAL_TAX = decode( p_TOTAL_TAX, FND_API.G_MISS_NUM, TOTAL_TAX, p_TOTAL_TAX),
519 TOTAL_SHIPPING_CHARGE = decode( p_TOTAL_SHIPPING_CHARGE, FND_API.G_MISS_NUM, TOTAL_SHIPPING_CHARGE, p_TOTAL_SHIPPING_CHARGE),
521 TOTAL_QUOTE_PRICE = decode( p_TOTAL_QUOTE_PRICE, FND_API.G_MISS_NUM, TOTAL_QUOTE_PRICE, p_TOTAL_QUOTE_PRICE),
522 PAYMENT_AMOUNT = decode( p_PAYMENT_AMOUNT, FND_API.G_MISS_NUM, PAYMENT_AMOUNT, p_PAYMENT_AMOUNT),
523 EXCHANGE_RATE = decode( p_EXCHANGE_RATE, FND_API.G_MISS_NUM, EXCHANGE_RATE, p_EXCHANGE_RATE),
524 EXCHANGE_TYPE_CODE = decode( p_EXCHANGE_TYPE_CODE, FND_API.G_MISS_CHAR, EXCHANGE_TYPE_CODE, p_EXCHANGE_TYPE_CODE),
525 EXCHANGE_RATE_DATE = ASO_UTILITY_PVT.decode( p_EXCHANGE_RATE_DATE, FND_API.G_MISS_DATE, EXCHANGE_RATE_DATE, p_EXCHANGE_RATE_DATE),
526 CONTRACT_ID = decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, CONTRACT_ID, p_CONTRACT_ID),
527 SALES_CHANNEL_CODE = decode( p_SALES_CHANNEL_CODE, FND_API.G_MISS_CHAR, SALES_CHANNEL_CODE, p_SALES_CHANNEL_CODE),
528 ORDER_ID = decode( p_ORDER_ID, FND_API.G_MISS_NUM, ORDER_ID, p_ORDER_ID),
529 RESOURCE_ID = decode( p_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, p_RESOURCE_ID),
530 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
531 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
532 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
533 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
534 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
535 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
536 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
537 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
538 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
539 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
540 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
541 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
542 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
543 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
544 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
545 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
546 ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
547 ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
548 ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
549 ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
550 ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
551 CONTRACT_TEMPLATE_ID = decode( p_CONTRACT_TEMPLATE_ID, FND_API.G_MISS_NUM, CONTRACT_TEMPLATE_ID, p_CONTRACT_TEMPLATE_ID),
552 CONTRACT_TEMPLATE_MAJOR_VER = decode( p_CONTRACT_TEMPLATE_MAJOR_VER, FND_API.G_MISS_NUM, CONTRACT_TEMPLATE_MAJOR_VER, p_CONTRACT_TEMPLATE_MAJOR_VER),
553 CONTRACT_REQUESTER_ID = decode( p_CONTRACT_REQUESTER_ID, FND_API.G_MISS_NUM, CONTRACT_REQUESTER_ID, p_CONTRACT_REQUESTER_ID),
554 CONTRACT_APPROVAL_LEVEL = decode( p_CONTRACT_APPROVAL_LEVEL, FND_API.G_MISS_CHAR, CONTRACT_APPROVAL_LEVEL, p_CONTRACT_APPROVAL_LEVEL),
555 PUBLISH_FLAG = decode( p_PUBLISH_FLAG, FND_API.G_MISS_CHAR, PUBLISH_FLAG, p_PUBLISH_FLAG),
556 RESOURCE_GRP_ID = decode( p_RESOURCE_GRP_ID, FND_API.G_MISS_NUM, RESOURCE_GRP_ID, p_RESOURCE_GRP_ID),
557 SOLD_TO_PARTY_SITE_ID = decode( p_SOLD_TO_PARTY_SITE_ID, FND_API.G_MISS_NUM, SOLD_TO_PARTY_SITE_ID, p_SOLD_TO_PARTY_SITE_ID),
558 DISPLAY_ARITHMETIC_OPERATOR = decode(p_DISPLAY_ARITHMETIC_OPERATOR,FND_API.G_MISS_CHAR,DISPLAY_ARITHMETIC_OPERATOR,p_DISPLAY_ARITHMETIC_OPERATOR),
559 MAX_VERSION_FLAG = decode(p_MAX_VERSION_FLAG,FND_API.G_MISS_CHAR,MAX_VERSION_FLAG,p_MAX_VERSION_FLAG),
560 QUOTE_TYPE = decode(p_QUOTE_TYPE,FND_API.G_MISS_CHAR,QUOTE_TYPE,p_QUOTE_TYPE),
561 QUOTE_DESCRIPTION = decode(p_QUOTE_DESCRIPTION,FND_API.G_MISS_CHAR,QUOTE_DESCRIPTION,p_QUOTE_DESCRIPTION),
562 MINISITE_ID = decode(p_MINISITE_ID, FND_API.G_MISS_NUM, MINISITE_ID, p_MINISITE_ID),
563 CUST_PARTY_ID = decode(p_CUST_PARTY_ID, FND_API.G_MISS_NUM, CUST_PARTY_ID, p_CUST_PARTY_ID),
564 INVOICE_TO_CUST_PARTY_ID = decode(p_INVOICE_TO_CUST_PARTY_ID, FND_API.G_MISS_NUM, INVOICE_TO_CUST_PARTY_ID, p_INVOICE_TO_CUST_PARTY_ID),
565
566 PRICING_STATUS_INDICATOR = decode( p_PRICING_STATUS_INDICATOR, FND_API.G_MISS_CHAR, PRICING_STATUS_INDICATOR, p_PRICING_STATUS_INDICATOR),
567
568 TAX_STATUS_INDICATOR = decode( p_TAX_STATUS_INDICATOR, FND_API.G_MISS_CHAR, TAX_STATUS_INDICATOR, p_TAX_STATUS_INDICATOR),
569
570 PRICE_UPDATED_DATE = decode( p_PRICE_UPDATED_DATE, FND_API.G_MISS_DATE, PRICE_UPDATED_DATE, p_PRICE_UPDATED_DATE),
571
572 TAX_UPDATED_DATE = decode( p_TAX_UPDATED_DATE, FND_API.G_MISS_DATE, TAX_UPDATED_DATE, p_TAX_UPDATED_DATE),
576 -- hyang new okc
573 RECALCULATE_FLAG = decode( p_RECALCULATE_FLAG, FND_API.G_MISS_CHAR, RECALCULATE_FLAG, p_RECALCULATE_FLAG),
574 PRICE_REQUEST_ID = decode( p_PRICE_REQUEST_ID, FND_API.G_MISS_NUM, PRICE_REQUEST_ID, p_PRICE_REQUEST_ID),
575 CREDIT_UPDATE_DATE = decode( p_CREDIT_UPDATE_DATE, FND_API.G_MISS_DATE, CREDIT_UPDATE_DATE, p_CREDIT_UPDATE_DATE),
577 Customer_Name_And_Title = DECODE( P_Customer_Name_And_Title, FND_API.G_MISS_CHAR, Customer_Name_And_Title, P_Customer_Name_And_Title),
578 Customer_Signature_Date = DECODE( P_Customer_Signature_Date, FND_API.G_MISS_DATE, Customer_Signature_Date, P_Customer_Signature_Date),
579 Supplier_Name_And_Title = DECODE( P_Supplier_Name_And_Title, FND_API.G_MISS_CHAR, Supplier_Name_And_Title, P_Supplier_Name_And_Title),
580 Supplier_Signature_Date = DECODE( P_Supplier_Signature_Date, FND_API.G_MISS_DATE, Supplier_Signature_Date, P_Supplier_Signature_Date),
581 -- end of hyang new okc
582 END_CUSTOMER_PARTY_ID = decode( p_END_CUSTOMER_PARTY_ID, FND_API.G_MISS_NUM, END_CUSTOMER_PARTY_ID, p_END_CUSTOMER_PARTY_ID),
583 END_CUSTOMER_CUST_PARTY_ID = decode( p_END_CUSTOMER_CUST_PARTY_ID, FND_API.G_MISS_NUM, END_CUSTOMER_CUST_PARTY_ID, p_END_CUSTOMER_CUST_PARTY_ID),
584 END_CUSTOMER_PARTY_SITE_ID = decode( p_END_CUSTOMER_PARTY_SITE_ID, FND_API.G_MISS_NUM, END_CUSTOMER_PARTY_SITE_ID, p_END_CUSTOMER_PARTY_SITE_ID),
585 END_CUSTOMER_CUST_ACCOUNT_ID = decode( p_END_CUSTOMER_CUST_ACCOUNT_ID, FND_API.G_MISS_NUM, END_CUSTOMER_CUST_ACCOUNT_ID, p_END_CUSTOMER_CUST_ACCOUNT_ID),
586 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1),
587 ASSISTANCE_REQUESTED = decode( p_ASSISTANCE_REQUESTED, FND_API.G_MISS_CHAR, ASSISTANCE_REQUESTED, p_ASSISTANCE_REQUESTED),
588 ASSISTANCE_REASON_CODE = decode( p_ASSISTANCE_REASON_CODE, FND_API.G_MISS_CHAR, ASSISTANCE_REASON_CODE, p_ASSISTANCE_REASON_CODE),
589 AUTOMATIC_PRICE_FLAG = decode( p_AUTOMATIC_PRICE_FLAG, FND_API.G_MISS_CHAR, AUTOMATIC_PRICE_FLAG, p_AUTOMATIC_PRICE_FLAG),
590 AUTOMATIC_TAX_FLAG = decode( p_AUTOMATIC_TAX_FLAG, FND_API.G_MISS_CHAR, AUTOMATIC_TAX_FLAG, p_AUTOMATIC_TAX_FLAG),
591 HEADER_PAYNOW_CHARGES = decode( p_HEADER_PAYNOW_CHARGES,FND_API.G_MISS_NUM,HEADER_PAYNOW_CHARGES,p_HEADER_PAYNOW_CHARGES)
592
593
594 where QUOTE_HEADER_ID = p_QUOTE_HEADER_ID;
595
596 If (SQL%NOTFOUND) then
597 RAISE NO_DATA_FOUND;
598 End If;
599 END Update_Row;
600
601 PROCEDURE Delete_Row(
602 p_QUOTE_HEADER_ID NUMBER)
603 IS
604 BEGIN
605 DELETE FROM ASO_QUOTE_HEADERS_ALL
606 WHERE QUOTE_HEADER_ID = p_QUOTE_HEADER_ID;
607 If (SQL%NOTFOUND) then
608 RAISE NO_DATA_FOUND;
609 End If;
610 END Delete_Row;
611
612 PROCEDURE Lock_Row(
613 --p_OBJECT_VERSION_NUMBER NUMBER,
614 p_QUOTE_HEADER_ID NUMBER,
615 p_CREATION_DATE DATE,
616 p_CREATED_BY NUMBER,
617 p_LAST_UPDATE_DATE DATE,
618 p_LAST_UPDATED_BY NUMBER,
619 p_LAST_UPDATE_LOGIN NUMBER,
620 p_REQUEST_ID NUMBER,
621 p_PROGRAM_APPLICATION_ID NUMBER,
622 p_PROGRAM_ID NUMBER,
623 p_PROGRAM_UPDATE_DATE DATE,
624 p_ORG_ID NUMBER,
625 p_QUOTE_NAME VARCHAR2,
626 p_QUOTE_NUMBER NUMBER,
627 p_QUOTE_VERSION NUMBER,
628 p_QUOTE_STATUS_ID NUMBER,
629 p_QUOTE_SOURCE_CODE VARCHAR2,
630 p_QUOTE_EXPIRATION_DATE DATE,
631 p_PRICE_FROZEN_DATE DATE,
632 p_QUOTE_PASSWORD VARCHAR2,
633 p_ORIGINAL_SYSTEM_REFERENCE VARCHAR2,
634 p_PARTY_ID NUMBER,
635 p_CUST_ACCOUNT_ID NUMBER,
636 p_ORG_CONTACT_ID NUMBER,
637 p_PHONE_ID NUMBER,
638 p_INVOICE_TO_PARTY_SITE_ID NUMBER,
639 p_INVOICE_TO_PARTY_ID NUMBER,
640 p_ORIG_MKTG_SOURCE_CODE_ID NUMBER,
641 p_MARKETING_SOURCE_CODE_ID NUMBER,
642 p_ORDER_TYPE_ID NUMBER,
643 p_QUOTE_CATEGORY_CODE VARCHAR2,
644 p_ORDERED_DATE DATE,
645 p_ACCOUNTING_RULE_ID NUMBER,
646 p_INVOICING_RULE_ID NUMBER,
647 p_EMPLOYEE_PERSON_ID NUMBER,
648 p_PRICE_LIST_ID NUMBER,
649 p_CURRENCY_CODE VARCHAR2,
650 p_TOTAL_LIST_PRICE NUMBER,
651 p_TOTAL_ADJUSTED_AMOUNT NUMBER,
652 p_TOTAL_ADJUSTED_PERCENT NUMBER,
653 p_TOTAL_TAX NUMBER,
654 p_TOTAL_SHIPPING_CHARGE NUMBER,
655 p_SURCHARGE NUMBER,
656 p_TOTAL_QUOTE_PRICE NUMBER,
657 p_PAYMENT_AMOUNT NUMBER,
658 p_EXCHANGE_RATE NUMBER,
659 p_EXCHANGE_TYPE_CODE VARCHAR2,
660 p_EXCHANGE_RATE_DATE DATE,
661 p_CONTRACT_ID NUMBER,
662 p_SALES_CHANNEL_CODE VARCHAR2,
663 p_ORDER_ID NUMBER,
664 p_ATTRIBUTE_CATEGORY VARCHAR2,
665 p_ATTRIBUTE1 VARCHAR2,
666 p_ATTRIBUTE2 VARCHAR2,
667 p_ATTRIBUTE3 VARCHAR2,
668 p_ATTRIBUTE4 VARCHAR2,
669 p_ATTRIBUTE5 VARCHAR2,
670 p_ATTRIBUTE6 VARCHAR2,
671 p_ATTRIBUTE7 VARCHAR2,
672 p_ATTRIBUTE8 VARCHAR2,
673 p_ATTRIBUTE9 VARCHAR2,
674 p_ATTRIBUTE10 VARCHAR2,
675 p_ATTRIBUTE11 VARCHAR2,
676 p_ATTRIBUTE12 VARCHAR2,
677 p_ATTRIBUTE13 VARCHAR2,
681 p_CONTRACT_TEMPLATE_MAJOR_VER NUMBER,
678 p_ATTRIBUTE14 VARCHAR2,
679 p_ATTRIBUTE15 VARCHAR2 /*,
680 p_CONTRACT_TEMPLATE_ID NUMBER,
682 p_CONTRACT_REQUESTER_ID NUMBER,
683 p_CONTRACT_APPROVAL_LEVEL VARCHAR2,
684 p_PUBLISH_FLAG VARCHAR2,
685 p_RESOURCE_GRP_ID NUMBER,
686 p_SOLD_TO_PARTY_SITE_ID NUMBER,
687 p_DISPLAY_ARITHMETIC_OPERATOR varchar2,
688 p_MAX_VERSION_FLAG VARCHAR2 */
689 /*
690 p_QUOTE_TYPE VARCHAR2,
691 p_QUOTE_DESCRIPTION VARCHAR2
692 */
693 )
694
695 IS
696 CURSOR C IS
697 SELECT ATTRIBUTE11,
698 --OBJECT_VERSION_NUMBER,
699 ATTRIBUTE12,
700 ATTRIBUTE13,
701 ATTRIBUTE14,
702 ATTRIBUTE15,
703 QUOTE_HEADER_ID,
704 CREATION_DATE,
705 CREATED_BY,
706 LAST_UPDATE_DATE,
707 LAST_UPDATED_BY,
708 LAST_UPDATE_LOGIN,
709 REQUEST_ID,
710 PROGRAM_APPLICATION_ID,
711 PROGRAM_ID,
712 PROGRAM_UPDATE_DATE,
713 ORG_ID,
714 QUOTE_NAME,
715 QUOTE_NUMBER,
716 QUOTE_VERSION,
717 QUOTE_STATUS_ID,
718 QUOTE_SOURCE_CODE,
719 QUOTE_EXPIRATION_DATE,
720 PRICE_FROZEN_DATE,
721 QUOTE_PASSWORD,
722 ORIGINAL_SYSTEM_REFERENCE,
723 PARTY_ID,
724 CUST_ACCOUNT_ID,
725 ORG_CONTACT_ID,
726 PHONE_ID,
727 INVOICE_TO_PARTY_SITE_ID,
728 INVOICE_TO_PARTY_ID,
729 ORIG_MKTG_SOURCE_CODE_ID,
730 MARKETING_SOURCE_CODE_ID,
731 ORDER_TYPE_ID,
732 QUOTE_CATEGORY_CODE,
733 ORDERED_DATE,
734 ACCOUNTING_RULE_ID,
735 INVOICING_RULE_ID,
736 EMPLOYEE_PERSON_ID,
737 PRICE_LIST_ID,
738 CURRENCY_CODE,
739 TOTAL_LIST_PRICE,
740 TOTAL_ADJUSTED_AMOUNT,
741 TOTAL_ADJUSTED_PERCENT,
742 TOTAL_TAX,
743 TOTAL_SHIPPING_CHARGE,
744 SURCHARGE,
745 TOTAL_QUOTE_PRICE,
746 PAYMENT_AMOUNT,
747 EXCHANGE_RATE,
748 EXCHANGE_TYPE_CODE,
749 EXCHANGE_RATE_DATE,
750 CONTRACT_ID,
751 SALES_CHANNEL_CODE,
752 ORDER_ID,
753 ATTRIBUTE_CATEGORY,
754 ATTRIBUTE1,
755 ATTRIBUTE2,
756 ATTRIBUTE3,
757 ATTRIBUTE4,
758 ATTRIBUTE5,
759 ATTRIBUTE6,
760 ATTRIBUTE7,
761 ATTRIBUTE8,
762 ATTRIBUTE9,
763 ATTRIBUTE10 /*,
764 CONTRACT_TEMPLATE_ID ,
765 CONTRACT_TEMPLATE_MAJOR_VER ,
766 CONTRACT_REQUESTER_ID ,
767 CONTRACT_APPROVAL_LEVEL ,
768 PUBLISH_FLAG ,
769 RESOURCE_GRP_ID ,
770 SOLD_TO_PARTY_SITE_ID ,
771 DISPLAY_ARITHMETIC_OPERATOR ,
772 MAX_VERSION_FLAG */
773 /*
774 QUOTE_TYPE,
775 QUOTE_DESCRIPTION
776 */
777 FROM ASO_QUOTE_HEADERS_ALL
778 WHERE QUOTE_HEADER_ID = p_QUOTE_HEADER_ID
779 FOR UPDATE of QUOTE_HEADER_ID NOWAIT;
780 Recinfo C%ROWTYPE;
781 BEGIN
782 OPEN C;
783 FETCH C INTO Recinfo;
784 If (C%NOTFOUND) then
785 CLOSE C;
786 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
787 APP_EXCEPTION.RAISE_EXCEPTION;
788 End If;
789 CLOSE C;
790 if (
791
792 /*
793 ( Recinfo.QUOTE_HEADER_ID = p_QUOTE_HEADER_ID)
794 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
795 OR ( ( Recinfo.CREATION_DATE IS NULL )
796 AND ( p_CREATION_DATE IS NULL )))
797 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
798 OR ( ( Recinfo.CREATED_BY IS NULL )
799 AND ( p_CREATED_BY IS NULL )))
800 AND
801 */
802 ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
803 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
804 AND ( p_LAST_UPDATE_DATE IS NULL )))
805 /*
806 AND
807 ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
808 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
809 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
810 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
811 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
812 AND ( p_LAST_UPDATED_BY IS NULL )))
813 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
814 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
815 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
816 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
817 OR ( ( Recinfo.REQUEST_ID IS NULL )
818 AND ( p_REQUEST_ID IS NULL )))
819 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
820 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
821 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
822 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
823 OR ( ( Recinfo.PROGRAM_ID IS NULL )
824 AND ( p_PROGRAM_ID IS NULL )))
825 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
826 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
827 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
828 AND ( ( Recinfo.ORG_ID = p_ORG_ID)
829 OR ( ( Recinfo.ORG_ID IS NULL )
830 AND ( p_ORG_ID IS NULL )))
831 AND ( ( Recinfo.QUOTE_NAME = p_QUOTE_NAME)
832 OR ( ( Recinfo.QUOTE_NAME IS NULL )
833 AND ( p_QUOTE_NAME IS NULL )))
834 AND ( ( Recinfo.QUOTE_NUMBER = p_QUOTE_NUMBER)
838 OR ( ( Recinfo.QUOTE_VERSION IS NULL )
835 OR ( ( Recinfo.QUOTE_NUMBER IS NULL )
836 AND ( p_QUOTE_NUMBER IS NULL )))
837 AND ( ( Recinfo.QUOTE_VERSION = p_QUOTE_VERSION)
839 AND ( p_QUOTE_VERSION IS NULL )))
840 AND ( ( Recinfo.QUOTE_STATUS_ID = p_QUOTE_STATUS_ID)
841 OR ( ( Recinfo.QUOTE_STATUS_ID IS NULL )
842 AND ( p_QUOTE_STATUS_ID IS NULL )))
843 AND ( ( Recinfo.QUOTE_SOURCE_CODE = p_QUOTE_SOURCE_CODE)
844 OR ( ( Recinfo.QUOTE_SOURCE_CODE IS NULL )
845 AND ( p_QUOTE_SOURCE_CODE IS NULL )))
846 AND ( ( Recinfo.QUOTE_EXPIRATION_DATE = p_QUOTE_EXPIRATION_DATE)
847 OR ( ( Recinfo.QUOTE_EXPIRATION_DATE IS NULL )
848 AND ( p_QUOTE_EXPIRATION_DATE IS NULL )))
849 AND ( ( Recinfo.PRICE_FROZEN_DATE = p_PRICE_FROZEN_DATE)
850 OR ( ( Recinfo.PRICE_FROZEN_DATE IS NULL )
851 AND ( p_PRICE_FROZEN_DATE IS NULL )))
852 AND ( ( Recinfo.QUOTE_PASSWORD = p_QUOTE_PASSWORD)
853 OR ( ( Recinfo.QUOTE_PASSWORD IS NULL )
854 AND ( p_QUOTE_PASSWORD IS NULL )))
855 AND ( ( Recinfo.ORIGINAL_SYSTEM_REFERENCE = p_ORIGINAL_SYSTEM_REFERENCE)
856 OR ( ( Recinfo.ORIGINAL_SYSTEM_REFERENCE IS NULL )
857 AND ( p_ORIGINAL_SYSTEM_REFERENCE IS NULL )))
858 AND ( ( Recinfo.PARTY_ID = p_PARTY_ID)
859 OR ( ( Recinfo.PARTY_ID IS NULL )
860 AND ( p_PARTY_ID IS NULL )))
861 AND ( ( Recinfo.CUST_ACCOUNT_ID = p_CUST_ACCOUNT_ID)
862 OR ( ( Recinfo.CUST_ACCOUNT_ID IS NULL )
863 AND ( p_CUST_ACCOUNT_ID IS NULL )))
864 AND ( ( Recinfo.ORG_CONTACT_ID = p_ORG_CONTACT_ID)
865 OR ( ( Recinfo.ORG_CONTACT_ID IS NULL )
866 AND ( p_ORG_CONTACT_ID IS NULL )))
867 AND ( ( Recinfo.PHONE_ID = p_PHONE_ID)
868 OR ( ( Recinfo.PHONE_ID IS NULL )
869 AND ( p_PHONE_ID IS NULL )))
870 AND ( ( Recinfo.INVOICE_TO_PARTY_SITE_ID = p_INVOICE_TO_PARTY_SITE_ID)
871 OR ( ( Recinfo.INVOICE_TO_PARTY_SITE_ID IS NULL )
872 AND ( p_INVOICE_TO_PARTY_SITE_ID IS NULL )))
873 AND ( ( Recinfo.INVOICE_TO_PARTY_ID = p_INVOICE_TO_PARTY_ID)
874 OR ( ( Recinfo.INVOICE_TO_PARTY_ID IS NULL )
875 AND ( p_INVOICE_TO_PARTY_ID IS NULL )))
876 AND ( ( Recinfo.ORIG_MKTG_SOURCE_CODE_ID = p_ORIG_MKTG_SOURCE_CODE_ID)
877 OR ( ( Recinfo.ORIG_MKTG_SOURCE_CODE_ID IS NULL )
878 AND ( p_ORIG_MKTG_SOURCE_CODE_ID IS NULL )))
879 AND ( ( Recinfo.MARKETING_SOURCE_CODE_ID = p_MARKETING_SOURCE_CODE_ID)
880 OR ( ( Recinfo.MARKETING_SOURCE_CODE_ID IS NULL )
881 AND ( p_MARKETING_SOURCE_CODE_ID IS NULL )))
882 AND ( ( Recinfo.ORDER_TYPE_ID = p_ORDER_TYPE_ID)
883 OR ( ( Recinfo.ORDER_TYPE_ID IS NULL )
884 AND ( p_ORDER_TYPE_ID IS NULL )))
885 AND ( ( Recinfo.QUOTE_CATEGORY_CODE = p_QUOTE_CATEGORY_CODE)
886 OR ( ( Recinfo.QUOTE_CATEGORY_CODE IS NULL )
887 AND ( p_QUOTE_CATEGORY_CODE IS NULL )))
888 AND ( ( Recinfo.ORDERED_DATE = p_ORDERED_DATE)
889 OR ( ( Recinfo.ORDERED_DATE IS NULL )
890 AND ( p_ORDERED_DATE IS NULL )))
891 AND ( ( Recinfo.ACCOUNTING_RULE_ID = p_ACCOUNTING_RULE_ID)
892 OR ( ( Recinfo.ACCOUNTING_RULE_ID IS NULL )
893 AND ( p_ACCOUNTING_RULE_ID IS NULL )))
894 AND ( ( Recinfo.INVOICING_RULE_ID = p_INVOICING_RULE_ID)
895 OR ( ( Recinfo.INVOICING_RULE_ID IS NULL )
896 AND ( p_INVOICING_RULE_ID IS NULL )))
897 AND ( ( Recinfo.EMPLOYEE_PERSON_ID = p_EMPLOYEE_PERSON_ID)
898 OR ( ( Recinfo.EMPLOYEE_PERSON_ID IS NULL )
899 AND ( p_EMPLOYEE_PERSON_ID IS NULL )))
900 AND ( ( Recinfo.PRICE_LIST_ID = p_PRICE_LIST_ID)
901 OR ( ( Recinfo.PRICE_LIST_ID IS NULL )
902 AND ( p_PRICE_LIST_ID IS NULL )))
903 AND ( ( Recinfo.CURRENCY_CODE = p_CURRENCY_CODE)
904 OR ( ( Recinfo.CURRENCY_CODE IS NULL )
905 AND ( p_CURRENCY_CODE IS NULL )))
906 AND ( ( Recinfo.TOTAL_LIST_PRICE = p_TOTAL_LIST_PRICE)
907 OR ( ( Recinfo.TOTAL_LIST_PRICE IS NULL )
908 AND ( p_TOTAL_LIST_PRICE IS NULL )))
909 AND ( ( Recinfo.TOTAL_ADJUSTED_AMOUNT = p_TOTAL_ADJUSTED_AMOUNT)
910 OR ( ( Recinfo.TOTAL_ADJUSTED_AMOUNT IS NULL )
911 AND ( p_TOTAL_ADJUSTED_AMOUNT IS NULL )))
912 AND ( ( Recinfo.TOTAL_ADJUSTED_PERCENT = p_TOTAL_ADJUSTED_PERCENT)
913 OR ( ( Recinfo.TOTAL_ADJUSTED_PERCENT IS NULL )
914 AND ( p_TOTAL_ADJUSTED_PERCENT IS NULL )))
915 AND ( ( Recinfo.TOTAL_TAX = p_TOTAL_TAX)
916 OR ( ( Recinfo.TOTAL_TAX IS NULL )
917 AND ( p_TOTAL_TAX IS NULL )))
918 AND ( ( Recinfo.TOTAL_SHIPPING_CHARGE = p_TOTAL_SHIPPING_CHARGE)
919 OR ( ( Recinfo.TOTAL_SHIPPING_CHARGE IS NULL )
920 AND ( p_TOTAL_SHIPPING_CHARGE IS NULL )))
921 AND ( ( Recinfo.SURCHARGE = p_SURCHARGE)
922 OR ( ( Recinfo.SURCHARGE IS NULL )
923 AND ( p_SURCHARGE IS NULL )))
924 AND ( ( Recinfo.TOTAL_QUOTE_PRICE = p_TOTAL_QUOTE_PRICE)
928 OR ( ( Recinfo.PAYMENT_AMOUNT IS NULL )
925 OR ( ( Recinfo.TOTAL_QUOTE_PRICE IS NULL )
926 AND ( p_TOTAL_QUOTE_PRICE IS NULL )))
927 AND ( ( Recinfo.PAYMENT_AMOUNT = p_PAYMENT_AMOUNT)
929 AND ( p_PAYMENT_AMOUNT IS NULL )))
930 AND ( ( Recinfo.EXCHANGE_RATE = p_EXCHANGE_RATE)
931 OR ( ( Recinfo.EXCHANGE_RATE IS NULL )
932 AND ( p_EXCHANGE_RATE IS NULL )))
933 AND ( ( Recinfo.EXCHANGE_TYPE_CODE = p_EXCHANGE_TYPE_CODE)
934 OR ( ( Recinfo.EXCHANGE_TYPE_CODE IS NULL )
935 AND ( p_EXCHANGE_TYPE_CODE IS NULL )))
936 AND ( ( Recinfo.EXCHANGE_RATE_DATE = p_EXCHANGE_RATE_DATE)
937 OR ( ( Recinfo.EXCHANGE_RATE_DATE IS NULL )
938 AND ( p_EXCHANGE_RATE_DATE IS NULL )))
939 AND ( ( Recinfo.CONTRACT_ID = p_CONTRACT_ID)
940 OR ( ( Recinfo.CONTRACT_ID IS NULL )
941 AND ( p_CONTRACT_ID IS NULL )))
942 AND ( ( Recinfo.SALES_CHANNEL_CODE = p_SALES_CHANNEL_CODE)
943 OR ( ( Recinfo.SALES_CHANNEL_CODE IS NULL )
944 AND ( p_SALES_CHANNEL_CODE IS NULL )))
945 AND ( ( Recinfo.ORDER_ID = p_ORDER_ID)
946 OR ( ( Recinfo.ORDER_ID IS NULL )
947 AND ( p_ORDER_ID IS NULL )))
948 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
949 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
950 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
951 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
952 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
953 AND ( p_ATTRIBUTE1 IS NULL )))
954 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
955 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
956 AND ( p_ATTRIBUTE2 IS NULL )))
957 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
958 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
959 AND ( p_ATTRIBUTE3 IS NULL )))
960 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
961 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
962 AND ( p_ATTRIBUTE4 IS NULL )))
963 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
964 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
965 AND ( p_ATTRIBUTE5 IS NULL )))
966 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
967 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
968 AND ( p_ATTRIBUTE6 IS NULL )))
969 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
970 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
971 AND ( p_ATTRIBUTE7 IS NULL )))
972 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
973 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
974 AND ( p_ATTRIBUTE8 IS NULL )))
975 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
976 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
977 AND ( p_ATTRIBUTE9 IS NULL )))
978 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
979 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
980 AND ( p_ATTRIBUTE10 IS NULL )))
981 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
982 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
983 AND ( p_ATTRIBUTE11 IS NULL )))
984 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
985 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
986 AND ( p_ATTRIBUTE12 IS NULL )))
987 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
988 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
989 AND ( p_ATTRIBUTE13 IS NULL )))
990 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
991 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
992 AND ( p_ATTRIBUTE14 IS NULL )))
993 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
994 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
995 AND ( p_ATTRIBUTE15 IS NULL )))
996 */
997 ) then
998 return;
999 else
1000 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1001 APP_EXCEPTION.RAISE_EXCEPTION;
1002 End If;
1003 END Lock_Row;
1004
1005 End ASO_QUOTE_HEADERS_PKG;