[Home] [Help]
PACKAGE BODY: APPS.CS_ESTIMATE_DETAILS_PKG
Source
1 PACKAGE BODY CS_ESTIMATE_DETAILS_PKG as
2 /* $Header: csxtchdb.pls 120.1.12000000.2 2007/06/29 10:56:14 vpremach ship $ */
3 -- Start of Comments
4 -- Package name : CS_ESTIMATE_DETAILS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CS_ESTIMATE_DETAILS_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csxtchdb.pls';
13
14 PROCEDURE Insert_Row(
15 p_ORG_ID NUMBER,
16 p_INCIDENT_ID NUMBER,
17 p_ORIGINAL_SOURCE_ID NUMBER,
18 p_ORIGINAL_SOURCE_CODE VARCHAR2,
19 p_SOURCE_ID NUMBER,
20 p_SOURCE_CODE VARCHAR2,
21 p_CONTRACT_LINE_ID NUMBER,
22 p_RATE_TYPE_CODE VARCHAR2,
23 p_CONTRACT_ID NUMBER,
24 p_COVERAGE_ID NUMBER,
25 p_COVERAGE_TXN_GROUP_ID NUMBER,
26 --p_EXCEPTION_COVERAGE_USED VARCHAR2,
27 p_CURRENCY_CODE VARCHAR2,
28 p_CONVERSION_RATE NUMBER,
29 p_CONVERSION_TYPE_CODE VARCHAR2,
30 p_CONVERSION_RATE_DATE DATE,
31 p_INVOICE_TO_ORG_ID NUMBER,
32 p_SHIP_TO_ORG_ID NUMBER,
33 p_PURCHASE_ORDER_NUM VARCHAR2,
34 p_ORDER_LINE_ID NUMBER,
35 p_LINE_TYPE_ID NUMBER,
36 p_LINE_CATEGORY_CODE VARCHAR2,
37 p_PRICE_LIST_HEADER_ID NUMBER,
38 p_LINE_NUMBER NUMBER,
39 p_INVENTORY_ITEM_ID NUMBER,
40 p_ITEM_REVISION VARCHAR2,
41 p_SERIAL_NUMBER VARCHAR2,
42 p_QUANTITY_REQUIRED NUMBER,
43 p_UNIT_OF_MEASURE_CODE VARCHAR2,
44 p_SELLING_PRICE NUMBER,
45 p_AFTER_WARRANTY_COST NUMBER,
46 --p_FUNC_CURR_AFT_WARR_COST NUMBER, -- Obsolete column 11/13/2002 mviswana
47 p_BUSINESS_PROCESS_ID NUMBER,
48 p_TRANSACTION_TYPE_ID NUMBER,
49 p_CUSTOMER_PRODUCT_ID NUMBER,
50 p_ORDER_HEADER_ID NUMBER,
51 p_INSTALLED_CP_RETURN_BY_DATE DATE,
52 p_NEW_CP_RETURN_BY_DATE DATE,
53 p_INTERFACE_TO_OE_FLAG VARCHAR2,
54 p_ROLLUP_FLAG VARCHAR2,
55 p_NO_CHARGE_FLAG VARCHAR2,
56 p_ADD_TO_ORDER_FLAG VARCHAR2,
57 p_RETURN_REASON_CODE VARCHAR2,
58 p_GENERATED_BY_BCA_ENGINE_FLAG VARCHAR2,
59 p_TRANSACTION_INVENTORY_ORG NUMBER,
60 p_TRANSACTION_SUB_INVENTORY VARCHAR2,
61 p_CHARGE_LINE_TYPE VARCHAR2,
62 p_SHIP_TO_ACCOUNT_ID NUMBER,
63 p_INVOICE_TO_ACCOUNT_ID NUMBER,
64 p_SHIP_TO_CONTACT_ID NUMBER,
65 p_BILL_TO_CONTACT_ID NUMBER,
66 p_LIST_PRICE NUMBER,
67 p_ACTIVITY_START_DATE_TIME DATE,
68 p_ACTIVITY_END_DATE_TIME DATE,
69 p_CONTRACT_DISCOUNT_AMOUNT NUMBER,
70 p_BILL_TO_PARTY_ID NUMBER,
71 p_SHIP_TO_PARTY_ID NUMBER,
72 p_PRICING_CONTEXT VARCHAR2,
73 p_PRICING_ATTRIBUTE1 VARCHAR2,
74 p_PRICING_ATTRIBUTE2 VARCHAR2,
75 p_PRICING_ATTRIBUTE3 VARCHAR2,
76 p_PRICING_ATTRIBUTE4 VARCHAR2,
77 p_PRICING_ATTRIBUTE5 VARCHAR2,
78 p_PRICING_ATTRIBUTE6 VARCHAR2,
79 p_PRICING_ATTRIBUTE7 VARCHAR2,
80 p_PRICING_ATTRIBUTE8 VARCHAR2,
81 p_PRICING_ATTRIBUTE9 VARCHAR2,
82 p_PRICING_ATTRIBUTE10 VARCHAR2,
83 p_PRICING_ATTRIBUTE11 VARCHAR2,
84 p_PRICING_ATTRIBUTE12 VARCHAR2,
85 p_PRICING_ATTRIBUTE13 VARCHAR2,
86 p_PRICING_ATTRIBUTE14 VARCHAR2,
87 p_PRICING_ATTRIBUTE15 VARCHAR2,
88 p_PRICING_ATTRIBUTE16 VARCHAR2,
89 p_PRICING_ATTRIBUTE17 VARCHAR2,
90 p_PRICING_ATTRIBUTE18 VARCHAR2,
91 p_PRICING_ATTRIBUTE19 VARCHAR2,
92 p_PRICING_ATTRIBUTE20 VARCHAR2,
93 p_PRICING_ATTRIBUTE21 VARCHAR2,
94 p_PRICING_ATTRIBUTE22 VARCHAR2,
95 p_PRICING_ATTRIBUTE23 VARCHAR2,
96 p_PRICING_ATTRIBUTE24 VARCHAR2,
97 p_PRICING_ATTRIBUTE25 VARCHAR2,
98 p_PRICING_ATTRIBUTE26 VARCHAR2,
99 p_PRICING_ATTRIBUTE27 VARCHAR2,
100 p_PRICING_ATTRIBUTE28 VARCHAR2,
101 p_PRICING_ATTRIBUTE29 VARCHAR2,
102 p_PRICING_ATTRIBUTE30 VARCHAR2,
103 p_PRICING_ATTRIBUTE31 VARCHAR2,
104 p_PRICING_ATTRIBUTE32 VARCHAR2,
105 p_PRICING_ATTRIBUTE33 VARCHAR2,
106 p_PRICING_ATTRIBUTE34 VARCHAR2,
107 p_PRICING_ATTRIBUTE35 VARCHAR2,
108 p_PRICING_ATTRIBUTE36 VARCHAR2,
109 p_PRICING_ATTRIBUTE37 VARCHAR2,
110 p_PRICING_ATTRIBUTE38 VARCHAR2,
111 p_PRICING_ATTRIBUTE39 VARCHAR2,
112 p_PRICING_ATTRIBUTE40 VARCHAR2,
113 p_PRICING_ATTRIBUTE41 VARCHAR2,
114 p_PRICING_ATTRIBUTE42 VARCHAR2,
115 p_PRICING_ATTRIBUTE43 VARCHAR2,
116 p_PRICING_ATTRIBUTE44 VARCHAR2,
117 p_PRICING_ATTRIBUTE45 VARCHAR2,
118 p_PRICING_ATTRIBUTE46 VARCHAR2,
119 p_PRICING_ATTRIBUTE47 VARCHAR2,
120 p_PRICING_ATTRIBUTE48 VARCHAR2,
121 p_PRICING_ATTRIBUTE49 VARCHAR2,
122 p_PRICING_ATTRIBUTE50 VARCHAR2,
123 p_PRICING_ATTRIBUTE51 VARCHAR2,
124 p_PRICING_ATTRIBUTE52 VARCHAR2,
125 p_PRICING_ATTRIBUTE53 VARCHAR2,
126 p_PRICING_ATTRIBUTE54 VARCHAR2,
127 p_PRICING_ATTRIBUTE55 VARCHAR2,
128 p_PRICING_ATTRIBUTE56 VARCHAR2,
129 p_PRICING_ATTRIBUTE57 VARCHAR2,
130 p_PRICING_ATTRIBUTE58 VARCHAR2,
131 p_PRICING_ATTRIBUTE59 VARCHAR2,
132 p_PRICING_ATTRIBUTE60 VARCHAR2,
133 p_PRICING_ATTRIBUTE61 VARCHAR2,
134 p_PRICING_ATTRIBUTE62 VARCHAR2,
135 p_PRICING_ATTRIBUTE63 VARCHAR2,
136 p_PRICING_ATTRIBUTE64 VARCHAR2,
137 p_PRICING_ATTRIBUTE65 VARCHAR2,
138 p_PRICING_ATTRIBUTE66 VARCHAR2,
139 p_PRICING_ATTRIBUTE67 VARCHAR2,
140 p_PRICING_ATTRIBUTE68 VARCHAR2,
141 p_PRICING_ATTRIBUTE69 VARCHAR2,
142 p_PRICING_ATTRIBUTE70 VARCHAR2,
143 p_PRICING_ATTRIBUTE71 VARCHAR2,
144 p_PRICING_ATTRIBUTE72 VARCHAR2,
145 p_PRICING_ATTRIBUTE73 VARCHAR2,
146 p_PRICING_ATTRIBUTE74 VARCHAR2,
147 p_PRICING_ATTRIBUTE75 VARCHAR2,
148 p_PRICING_ATTRIBUTE76 VARCHAR2,
149 p_PRICING_ATTRIBUTE77 VARCHAR2,
150 p_PRICING_ATTRIBUTE78 VARCHAR2,
151 p_PRICING_ATTRIBUTE79 VARCHAR2,
152 p_PRICING_ATTRIBUTE80 VARCHAR2,
153 p_PRICING_ATTRIBUTE81 VARCHAR2,
154 p_PRICING_ATTRIBUTE82 VARCHAR2,
155 p_PRICING_ATTRIBUTE83 VARCHAR2,
156 p_PRICING_ATTRIBUTE84 VARCHAR2,
157 p_PRICING_ATTRIBUTE85 VARCHAR2,
158 p_PRICING_ATTRIBUTE86 VARCHAR2,
159 p_PRICING_ATTRIBUTE87 VARCHAR2,
160 p_PRICING_ATTRIBUTE88 VARCHAR2,
161 p_PRICING_ATTRIBUTE89 VARCHAR2,
162 p_PRICING_ATTRIBUTE90 VARCHAR2,
163 p_PRICING_ATTRIBUTE91 VARCHAR2,
164 p_PRICING_ATTRIBUTE92 VARCHAR2,
165 p_PRICING_ATTRIBUTE93 VARCHAR2,
166 p_PRICING_ATTRIBUTE94 VARCHAR2,
167 p_PRICING_ATTRIBUTE95 VARCHAR2,
168 p_PRICING_ATTRIBUTE96 VARCHAR2,
169 p_PRICING_ATTRIBUTE97 VARCHAR2,
170 p_PRICING_ATTRIBUTE98 VARCHAR2,
171 p_PRICING_ATTRIBUTE99 VARCHAR2,
172 p_PRICING_ATTRIBUTE100 VARCHAR2,
173 p_ATTRIBUTE1 VARCHAR2,
174 p_ATTRIBUTE2 VARCHAR2,
175 p_ATTRIBUTE3 VARCHAR2,
176 p_ATTRIBUTE4 VARCHAR2,
177 p_ATTRIBUTE5 VARCHAR2,
178 p_ATTRIBUTE6 VARCHAR2,
179 p_ATTRIBUTE7 VARCHAR2,
180 p_ATTRIBUTE8 VARCHAR2,
181 p_ATTRIBUTE9 VARCHAR2,
182 p_ATTRIBUTE10 VARCHAR2,
183 p_ATTRIBUTE11 VARCHAR2,
184 p_ATTRIBUTE12 VARCHAR2,
185 p_ATTRIBUTE13 VARCHAR2,
186 p_ATTRIBUTE14 VARCHAR2,
187 p_ATTRIBUTE15 VARCHAR2,
188 p_CONTEXT VARCHAR2,
189 p_COVERAGE_BILL_RATE_ID NUMBER,
190 P_COVERAGE_BILLING_TYPE_ID NUMBER,
191 p_TXN_BILLING_TYPE_ID NUMBER,
192 p_SUBMIT_RESTRICTION_MESSAGE VARCHAR2, -- Added Column mviswana 07/23/2003
193 p_SUBMIT_ERROR_MESSAGE VARCHAR2, -- Added Column mviswana 07/23/2003
194 p_SUBMIT_FROM_SYSTEM VARCHAR2, -- Added Column mviswana 07/23/2003
195 p_LINE_SUBMITTED VARCHAR2, -- Added Column mviswana 07/23/2003
196 --p_EST_TAX_AMOUNT NUMBER, -- Obsolete column 11/13/2002 mviswana
197 --p_TAX_CODE VARCHAR2, -- Obsolete column 11/13/2002 mviswana
198 p_LAST_UPDATE_DATE DATE,
199 p_LAST_UPDATE_LOGIN NUMBER,
200 p_LAST_UPDATED_BY NUMBER,
201 p_CREATION_DATE DATE,
202 p_CREATED_BY NUMBER,
203 P_ESTIMATE_DETAIL_ID IN NUMBER,
204 x_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER)
205
206 IS
207 /* CURSOR C IS
208 SELECT CS_ESTIMATE_DETAILS_S.nextval
209 FROM sys.dual; */
210
211
212 BEGIN
213
214 /* IF (X_ESTIMATE_DETAIL_ID IS NULL) OR (X_ESTIMATE_DETAIL_ID = FND_API.G_MISS_NUM) THEN
215 OPEN C;
216 FETCH C INTO X_ESTIMATE_DETAIL_ID;
217 CLOSE C;
218 END IF; */
219
220
221 --dbms_output.put_line('inserting into estimate_detail_id =' || x_estimate_detail_id);
222
223 INSERT INTO CS_ESTIMATE_DETAILS(
224 ESTIMATE_DETAIL_ID,
225 ORG_ID,
226 INCIDENT_ID,
227 ORIGINAL_SOURCE_ID,
228 ORIGINAL_SOURCE_CODE,
229 SOURCE_ID,
230 SOURCE_CODE,
231 CONTRACT_LINE_ID,
232 RATE_TYPE_CODE,
233 CONTRACT_ID,
234 COVERAGE_ID,
235 COVERAGE_TXN_GROUP_ID,
236 --EXCEPTION_COVERAGE_USED,
237 CURRENCY_CODE,
238 CONVERSION_RATE,
239 CONVERSION_TYPE_CODE,
240 CONVERSION_RATE_DATE,
241 INVOICE_TO_ORG_ID,
242 SHIP_TO_ORG_ID,
243 PURCHASE_ORDER_NUM,
244 ORDER_LINE_ID,
245 LINE_TYPE_ID,
246 LINE_CATEGORY_CODE,
247 PRICE_LIST_HEADER_ID,
248 LINE_NUMBER,
249 INVENTORY_ITEM_ID,
250 ITEM_REVISION,
251 SERIAL_NUMBER,
252 QUANTITY_REQUIRED,
253 UNIT_OF_MEASURE_CODE,
254 SELLING_PRICE,
255 AFTER_WARRANTY_COST,
256 --FUNC_CURR_AFT_WARR_COST, -- Obsolete column 11/13/2002 mviswana
257 BUSINESS_PROCESS_ID,
258 TRANSACTION_TYPE_ID,
259 CUSTOMER_PRODUCT_ID,
260 ORDER_HEADER_ID,
261 INSTALLED_CP_RETURN_BY_DATE,
262 NEW_CP_RETURN_BY_DATE,
263 INTERFACE_TO_OE_FLAG,
264 ROLLUP_FLAG,
265 NO_CHARGE_FLAG,
266 ADD_TO_ORDER_FLAG,
267 RETURN_REASON_CODE,
268 GENERATED_BY_BCA_ENGINE_FLAG,
269 TRANSACTION_INVENTORY_ORG,
270 TRANSACTION_SUB_INVENTORY,
271 CHARGE_LINE_TYPE,
272 SHIP_TO_ACCOUNT_ID,
273 INVOICE_TO_ACCOUNT_ID,
274 SHIP_TO_CONTACT_ID,
275 BILL_TO_CONTACT_ID,
276 LIST_PRICE,
277 ACTIVITY_START_DATE_TIME,
278 ACTIVITY_END_DATE_TIME,
279 CONTRACT_DISCOUNT_AMOUNT,
280 BILL_TO_PARTY_ID,
281 SHIP_TO_PARTY_ID,
282 PRICING_CONTEXT,
283 PRICING_ATTRIBUTE1,
284 PRICING_ATTRIBUTE2,
285 PRICING_ATTRIBUTE3,
286 PRICING_ATTRIBUTE4,
287 PRICING_ATTRIBUTE5,
288 PRICING_ATTRIBUTE6,
289 PRICING_ATTRIBUTE7,
290 PRICING_ATTRIBUTE8,
291 PRICING_ATTRIBUTE9,
292 PRICING_ATTRIBUTE10,
293 PRICING_ATTRIBUTE11,
294 PRICING_ATTRIBUTE12,
295 PRICING_ATTRIBUTE13,
296 PRICING_ATTRIBUTE14,
297 PRICING_ATTRIBUTE15,
298 PRICING_ATTRIBUTE16,
299 PRICING_ATTRIBUTE17,
300 PRICING_ATTRIBUTE18,
301 PRICING_ATTRIBUTE19,
302 PRICING_ATTRIBUTE20,
303 PRICING_ATTRIBUTE21,
304 PRICING_ATTRIBUTE22,
305 PRICING_ATTRIBUTE23,
306 PRICING_ATTRIBUTE24,
307 PRICING_ATTRIBUTE25,
308 PRICING_ATTRIBUTE26,
309 PRICING_ATTRIBUTE27,
310 PRICING_ATTRIBUTE28,
311 PRICING_ATTRIBUTE29,
312 PRICING_ATTRIBUTE30,
313 PRICING_ATTRIBUTE31,
314 PRICING_ATTRIBUTE32,
315 PRICING_ATTRIBUTE33,
316 PRICING_ATTRIBUTE34,
317 PRICING_ATTRIBUTE35,
318 PRICING_ATTRIBUTE36,
319 PRICING_ATTRIBUTE37,
320 PRICING_ATTRIBUTE38,
321 PRICING_ATTRIBUTE39,
322 PRICING_ATTRIBUTE40,
323 PRICING_ATTRIBUTE41,
324 PRICING_ATTRIBUTE42,
325 PRICING_ATTRIBUTE43,
326 PRICING_ATTRIBUTE44,
327 PRICING_ATTRIBUTE45,
328 PRICING_ATTRIBUTE46,
329 PRICING_ATTRIBUTE47,
330 PRICING_ATTRIBUTE48,
331 PRICING_ATTRIBUTE49,
332 PRICING_ATTRIBUTE50,
333 PRICING_ATTRIBUTE51,
334 PRICING_ATTRIBUTE52,
335 PRICING_ATTRIBUTE53,
336 PRICING_ATTRIBUTE54,
337 PRICING_ATTRIBUTE55,
338 PRICING_ATTRIBUTE56,
339 PRICING_ATTRIBUTE57,
340 PRICING_ATTRIBUTE58,
341 PRICING_ATTRIBUTE59,
342 PRICING_ATTRIBUTE60,
343 PRICING_ATTRIBUTE61,
344 PRICING_ATTRIBUTE62,
345 PRICING_ATTRIBUTE63,
346 PRICING_ATTRIBUTE64,
347 PRICING_ATTRIBUTE65,
348 PRICING_ATTRIBUTE66,
349 PRICING_ATTRIBUTE67,
350 PRICING_ATTRIBUTE68,
351 PRICING_ATTRIBUTE69,
355 PRICING_ATTRIBUTE73,
352 PRICING_ATTRIBUTE70,
353 PRICING_ATTRIBUTE71,
354 PRICING_ATTRIBUTE72,
356 PRICING_ATTRIBUTE74,
357 PRICING_ATTRIBUTE75,
358 PRICING_ATTRIBUTE76,
359 PRICING_ATTRIBUTE77,
360 PRICING_ATTRIBUTE78,
361 PRICING_ATTRIBUTE79,
362 PRICING_ATTRIBUTE80,
363 PRICING_ATTRIBUTE81,
364 PRICING_ATTRIBUTE82,
365 PRICING_ATTRIBUTE83,
366 PRICING_ATTRIBUTE84,
367 PRICING_ATTRIBUTE85,
368 PRICING_ATTRIBUTE86,
369 PRICING_ATTRIBUTE87,
370 PRICING_ATTRIBUTE88,
371 PRICING_ATTRIBUTE89,
372 PRICING_ATTRIBUTE90,
373 PRICING_ATTRIBUTE91,
374 PRICING_ATTRIBUTE92,
375 PRICING_ATTRIBUTE93,
376 PRICING_ATTRIBUTE94,
377 PRICING_ATTRIBUTE95,
378 PRICING_ATTRIBUTE96,
379 PRICING_ATTRIBUTE97,
380 PRICING_ATTRIBUTE98,
381 PRICING_ATTRIBUTE99,
382 PRICING_ATTRIBUTE100,
383 ATTRIBUTE1,
384 ATTRIBUTE2,
385 ATTRIBUTE3,
386 ATTRIBUTE4,
387 ATTRIBUTE5,
388 ATTRIBUTE6,
389 ATTRIBUTE7,
390 ATTRIBUTE8,
391 ATTRIBUTE9,
392 ATTRIBUTE10,
393 ATTRIBUTE11,
394 ATTRIBUTE12,
395 ATTRIBUTE13,
396 ATTRIBUTE14,
397 ATTRIBUTE15,
398 CONTEXT,
399 COVERAGE_BILL_RATE_ID,
400 --Obsoleted to fix Bug # 3477626
401 -- COVERAGE_BILLING_TYPE_ID ,
402 TXN_BILLING_TYPE_ID,
403 SUBMIT_RESTRICTION_MESSAGE,
404 SUBMIT_ERROR_MESSAGE,
405 SUBMIT_FROM_SYSTEM,
406 LINE_SUBMITTED,
407 --EST_TAX_AMOUNT, -- Obsolete column 11/13/2002 mviswana
408 --TAX_CODE, --Obsolete column 11/13/2002 mviswana
409 LAST_UPDATE_DATE,
410 LAST_UPDATE_LOGIN,
411 LAST_UPDATED_BY,
412 CREATION_DATE,
413 CREATED_BY,
414 OBJECT_VERSION_NUMBER)
415 VALUES (
416 P_ESTIMATE_DETAIL_ID,
417 P_ORG_ID,
418 p_INCIDENT_ID,
419 p_ORIGINAL_SOURCE_ID,
420 p_ORIGINAL_SOURCE_CODE,
421 p_SOURCE_ID,
422 p_SOURCE_CODE,
423 p_CONTRACT_LINE_ID,
424 p_RATE_TYPE_CODE,
425 p_CONTRACT_ID,
426 p_COVERAGE_ID,
427 p_COVERAGE_TXN_GROUP_ID,
428 --p_EXCEPTION_COVERAGE_USED,
429 p_CURRENCY_CODE,
430 p_CONVERSION_RATE,
431 p_CONVERSION_TYPE_CODE,
432 p_CONVERSION_RATE_DATE,
433 p_INVOICE_TO_ORG_ID,
434 p_SHIP_TO_ORG_ID,
435 p_PURCHASE_ORDER_NUM,
436 p_ORDER_LINE_ID,
437 p_LINE_TYPE_ID,
438 p_LINE_CATEGORY_CODE,
439 p_PRICE_LIST_HEADER_ID,
440 p_LINE_NUMBER,
441 p_INVENTORY_ITEM_ID,
442 p_ITEM_REVISION,
443 p_SERIAL_NUMBER,
444 p_QUANTITY_REQUIRED,
445 p_UNIT_OF_MEASURE_CODE,
446 p_SELLING_PRICE,
447 p_AFTER_WARRANTY_COST,
448 --p_FUNC_CURR_AFT_WARR_COST, -- Obsolete column 11/13/2002 mviswana
449 p_BUSINESS_PROCESS_ID,
450 p_TRANSACTION_TYPE_ID,
451 p_CUSTOMER_PRODUCT_ID,
452 p_ORDER_HEADER_ID,
453 p_INSTALLED_CP_RETURN_BY_DATE,
454 p_NEW_CP_RETURN_BY_DATE,
455 p_INTERFACE_TO_OE_FLAG,
456 p_ROLLUP_FLAG,
457 p_NO_CHARGE_FLAG,
458 p_ADD_TO_ORDER_FLAG,
459 p_RETURN_REASON_CODE,
460 p_GENERATED_BY_BCA_ENGINE_FLAG,
461 p_TRANSACTION_INVENTORY_ORG,
462 p_TRANSACTION_SUB_INVENTORY,
463 p_CHARGE_LINE_TYPE,
464 p_SHIP_TO_ACCOUNT_ID,
465 p_INVOICE_TO_ACCOUNT_ID,
466 p_SHIP_TO_CONTACT_ID,
467 p_BILL_TO_CONTACT_ID,
468 p_LIST_PRICE,
469 p_ACTIVITY_START_DATE_TIME,
470 p_ACTIVITY_END_DATE_TIME,
471 p_CONTRACT_DISCOUNT_AMOUNT,
472 p_BILL_TO_PARTY_ID,
473 p_SHIP_TO_PARTY_ID,
474 p_PRICING_CONTEXT,
475 p_PRICING_ATTRIBUTE1,
476 p_PRICING_ATTRIBUTE2,
477 p_PRICING_ATTRIBUTE3,
478 p_PRICING_ATTRIBUTE4,
479 p_PRICING_ATTRIBUTE5,
480 p_PRICING_ATTRIBUTE6,
481 p_PRICING_ATTRIBUTE7,
482 p_PRICING_ATTRIBUTE8,
483 p_PRICING_ATTRIBUTE9,
484 p_PRICING_ATTRIBUTE10,
485 p_PRICING_ATTRIBUTE11,
486 p_PRICING_ATTRIBUTE12,
487 p_PRICING_ATTRIBUTE13,
488 p_PRICING_ATTRIBUTE14,
489 p_PRICING_ATTRIBUTE15,
490 p_PRICING_ATTRIBUTE16,
491 p_PRICING_ATTRIBUTE17,
492 p_PRICING_ATTRIBUTE18,
493 p_PRICING_ATTRIBUTE19,
494 p_PRICING_ATTRIBUTE20,
495 p_PRICING_ATTRIBUTE21,
496 p_PRICING_ATTRIBUTE22,
497 p_PRICING_ATTRIBUTE23,
498 p_PRICING_ATTRIBUTE24,
499 p_PRICING_ATTRIBUTE25,
500 p_PRICING_ATTRIBUTE26,
501 p_PRICING_ATTRIBUTE27,
505 p_PRICING_ATTRIBUTE31,
502 p_PRICING_ATTRIBUTE28,
503 p_PRICING_ATTRIBUTE29,
504 p_PRICING_ATTRIBUTE30,
506 p_PRICING_ATTRIBUTE32,
507 p_PRICING_ATTRIBUTE33,
508 p_PRICING_ATTRIBUTE34,
509 p_PRICING_ATTRIBUTE35,
510 p_PRICING_ATTRIBUTE36,
511 p_PRICING_ATTRIBUTE37,
512 p_PRICING_ATTRIBUTE38,
513 p_PRICING_ATTRIBUTE39,
514 p_PRICING_ATTRIBUTE40,
515 p_PRICING_ATTRIBUTE41,
516 p_PRICING_ATTRIBUTE42,
517 p_PRICING_ATTRIBUTE43,
518 p_PRICING_ATTRIBUTE44,
519 p_PRICING_ATTRIBUTE45,
520 p_PRICING_ATTRIBUTE46,
521 p_PRICING_ATTRIBUTE47,
522 p_PRICING_ATTRIBUTE48,
523 p_PRICING_ATTRIBUTE49,
524 p_PRICING_ATTRIBUTE50,
525 p_PRICING_ATTRIBUTE51,
526 p_PRICING_ATTRIBUTE52,
527 p_PRICING_ATTRIBUTE53,
528 p_PRICING_ATTRIBUTE54,
529 p_PRICING_ATTRIBUTE55,
530 p_PRICING_ATTRIBUTE56,
531 p_PRICING_ATTRIBUTE57,
532 p_PRICING_ATTRIBUTE58,
533 p_PRICING_ATTRIBUTE59,
534 p_PRICING_ATTRIBUTE60,
535 p_PRICING_ATTRIBUTE61,
536 p_PRICING_ATTRIBUTE62,
537 p_PRICING_ATTRIBUTE63,
538 p_PRICING_ATTRIBUTE64,
539 p_PRICING_ATTRIBUTE65,
540 p_PRICING_ATTRIBUTE66,
541 p_PRICING_ATTRIBUTE67,
542 p_PRICING_ATTRIBUTE68,
543 p_PRICING_ATTRIBUTE69,
544 p_PRICING_ATTRIBUTE70,
545 p_PRICING_ATTRIBUTE71,
546 p_PRICING_ATTRIBUTE72,
547 p_PRICING_ATTRIBUTE73,
548 p_PRICING_ATTRIBUTE74,
549 p_PRICING_ATTRIBUTE75,
550 p_PRICING_ATTRIBUTE76,
551 p_PRICING_ATTRIBUTE77,
552 p_PRICING_ATTRIBUTE78,
553 p_PRICING_ATTRIBUTE79,
554 p_PRICING_ATTRIBUTE80,
555 p_PRICING_ATTRIBUTE81,
556 p_PRICING_ATTRIBUTE82,
557 p_PRICING_ATTRIBUTE83,
558 p_PRICING_ATTRIBUTE84,
559 p_PRICING_ATTRIBUTE85,
560 p_PRICING_ATTRIBUTE86,
561 p_PRICING_ATTRIBUTE87,
562 p_PRICING_ATTRIBUTE88,
563 p_PRICING_ATTRIBUTE89,
564 p_PRICING_ATTRIBUTE90,
565 p_PRICING_ATTRIBUTE91,
566 p_PRICING_ATTRIBUTE92,
567 p_PRICING_ATTRIBUTE93,
568 p_PRICING_ATTRIBUTE94,
569 p_PRICING_ATTRIBUTE95,
570 p_PRICING_ATTRIBUTE96,
571 p_PRICING_ATTRIBUTE97,
572 p_PRICING_ATTRIBUTE98,
573 p_PRICING_ATTRIBUTE99,
574 p_PRICING_ATTRIBUTE100,
575 p_ATTRIBUTE1,
576 p_ATTRIBUTE2,
577 p_ATTRIBUTE3,
578 p_ATTRIBUTE4,
579 p_ATTRIBUTE5,
580 p_ATTRIBUTE6,
581 p_ATTRIBUTE7,
582 p_ATTRIBUTE8,
583 p_ATTRIBUTE9,
584 p_ATTRIBUTE10,
585 p_ATTRIBUTE11,
586 p_ATTRIBUTE12,
587 p_ATTRIBUTE13,
588 p_ATTRIBUTE14,
589 p_ATTRIBUTE15,
590 p_CONTEXT,
591 p_COVERAGE_BILL_RATE_ID,
592 --Obsoleted to fix Bug # 3477626
593 -- P_COVERAGE_BILLING_TYPE_ID ,
594 p_TXN_BILLING_TYPE_ID,
595 p_SUBMIT_RESTRICTION_MESSAGE , -- Added Column mviswana 07/23/2003
596 p_SUBMIT_ERROR_MESSAGE, -- Added Column mviswana 07/23/2003
597 p_SUBMIT_FROM_SYSTEM, -- Added Column mviswana 07/23/2003
598 p_LINE_SUBMITTED, -- Added Column mviswana 07/23/2003
599 --p_EST_TAX_AMOUNT, -- Obsolete column 11/13/2002 mviswana
600 --p_TAX_CODE, -- Obsolete column 11/13/2002 mviswana
601 p_LAST_UPDATE_DATE,
602 p_LAST_UPDATE_LOGIN,
603 p_LAST_UPDATED_BY,
604 p_CREATION_DATE,
605 p_CREATED_BY,
606 1
607 );
608
609 X_OBJECT_VERSION_NUMBER := 1;
610
611 -- dbms_output.put_line('after insert into cs_estimate_details');
612
613 End Insert_Row;
614
615 PROCEDURE Update_Row(
616 X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
617 p_ESTIMATE_DETAIL_ID NUMBER,
618 p_ORG_ID NUMBER,
619 p_INCIDENT_ID NUMBER,
620 p_ORIGINAL_SOURCE_ID NUMBER,
621 p_ORIGINAL_SOURCE_CODE VARCHAR2,
622 p_SOURCE_ID NUMBER,
623 p_SOURCE_CODE VARCHAR2,
624 p_CONTRACT_LINE_ID NUMBER,
625 p_RATE_TYPE_CODE VARCHAR2,
626 p_CONTRACT_ID NUMBER,
627 p_COVERAGE_ID NUMBER,
628 p_COVERAGE_TXN_GROUP_ID NUMBER,
629 --p_EXCEPTION_COVERAGE_USED VARCHAR2,
630 p_CURRENCY_CODE VARCHAR2,
631 p_CONVERSION_RATE NUMBER,
632 p_CONVERSION_TYPE_CODE VARCHAR2,
633 p_CONVERSION_RATE_DATE DATE,
637 p_ORDER_LINE_ID NUMBER,
634 p_INVOICE_TO_ORG_ID NUMBER,
635 p_SHIP_TO_ORG_ID NUMBER,
636 p_PURCHASE_ORDER_NUM VARCHAR2,
638 p_LINE_TYPE_ID NUMBER,
639 p_LINE_CATEGORY_CODE VARCHAR2,
640 p_PRICE_LIST_HEADER_ID NUMBER,
641 p_LINE_NUMBER NUMBER,
642 p_INVENTORY_ITEM_ID NUMBER,
643 p_ITEM_REVISION VARCHAR2,
644 p_SERIAL_NUMBER VARCHAR2,
645 p_QUANTITY_REQUIRED NUMBER,
646 p_UNIT_OF_MEASURE_CODE VARCHAR2,
647 p_SELLING_PRICE NUMBER,
648 p_AFTER_WARRANTY_COST NUMBER,
649 --p_FUNC_CURR_AFT_WARR_COST NUMBER, -- Obsolete column 11/13/2002 mviswana
650 p_BUSINESS_PROCESS_ID NUMBER,
651 p_TRANSACTION_TYPE_ID NUMBER,
652 p_CUSTOMER_PRODUCT_ID NUMBER,
653 p_ORDER_HEADER_ID NUMBER,
654 p_INSTALLED_CP_RETURN_BY_DATE DATE,
655 p_NEW_CP_RETURN_BY_DATE DATE,
656 p_INTERFACE_TO_OE_FLAG VARCHAR2,
657 p_ROLLUP_FLAG VARCHAR2,
658 p_NO_CHARGE_FLAG VARCHAR2,
659 p_ADD_TO_ORDER_FLAG VARCHAR2,
660 p_RETURN_REASON_CODE VARCHAR2,
661 p_GENERATED_BY_BCA_ENGINE_FLAG VARCHAR2,
662 p_TRANSACTION_INVENTORY_ORG NUMBER,
663 p_TRANSACTION_SUB_INVENTORY VARCHAR2,
664 p_CHARGE_LINE_TYPE VARCHAR2,
665 p_SHIP_TO_ACCOUNT_ID NUMBER,
666 p_INVOICE_TO_ACCOUNT_ID NUMBER,
667 p_SHIP_TO_CONTACT_ID NUMBER,
668 p_BILL_TO_CONTACT_ID NUMBER,
669 p_LIST_PRICE NUMBER,
670 p_ACTIVITY_START_DATE_TIME DATE,
671 p_ACTIVITY_END_DATE_TIME DATE,
672 p_CONTRACT_DISCOUNT_AMOUNT NUMBER,
673 p_BILL_TO_PARTY_ID NUMBER,
674 p_SHIP_TO_PARTY_ID NUMBER,
675 p_PRICING_CONTEXT VARCHAR2,
676 p_PRICING_ATTRIBUTE1 VARCHAR2,
677 p_PRICING_ATTRIBUTE2 VARCHAR2,
678 p_PRICING_ATTRIBUTE3 VARCHAR2,
679 p_PRICING_ATTRIBUTE4 VARCHAR2,
680 p_PRICING_ATTRIBUTE5 VARCHAR2,
681 p_PRICING_ATTRIBUTE6 VARCHAR2,
682 p_PRICING_ATTRIBUTE7 VARCHAR2,
683 p_PRICING_ATTRIBUTE8 VARCHAR2,
684 p_PRICING_ATTRIBUTE9 VARCHAR2,
685 p_PRICING_ATTRIBUTE10 VARCHAR2,
686 p_PRICING_ATTRIBUTE11 VARCHAR2,
687 p_PRICING_ATTRIBUTE12 VARCHAR2,
688 p_PRICING_ATTRIBUTE13 VARCHAR2,
689 p_PRICING_ATTRIBUTE14 VARCHAR2,
690 p_PRICING_ATTRIBUTE15 VARCHAR2,
691 p_PRICING_ATTRIBUTE16 VARCHAR2,
692 p_PRICING_ATTRIBUTE17 VARCHAR2,
693 p_PRICING_ATTRIBUTE18 VARCHAR2,
694 p_PRICING_ATTRIBUTE19 VARCHAR2,
695 p_PRICING_ATTRIBUTE20 VARCHAR2,
696 p_PRICING_ATTRIBUTE21 VARCHAR2,
697 p_PRICING_ATTRIBUTE22 VARCHAR2,
698 p_PRICING_ATTRIBUTE23 VARCHAR2,
699 p_PRICING_ATTRIBUTE24 VARCHAR2,
700 p_PRICING_ATTRIBUTE25 VARCHAR2,
701 p_PRICING_ATTRIBUTE26 VARCHAR2,
702 p_PRICING_ATTRIBUTE27 VARCHAR2,
703 p_PRICING_ATTRIBUTE28 VARCHAR2,
704 p_PRICING_ATTRIBUTE29 VARCHAR2,
705 p_PRICING_ATTRIBUTE30 VARCHAR2,
706 p_PRICING_ATTRIBUTE31 VARCHAR2,
707 p_PRICING_ATTRIBUTE32 VARCHAR2,
708 p_PRICING_ATTRIBUTE33 VARCHAR2,
709 p_PRICING_ATTRIBUTE34 VARCHAR2,
710 p_PRICING_ATTRIBUTE35 VARCHAR2,
711 p_PRICING_ATTRIBUTE36 VARCHAR2,
712 p_PRICING_ATTRIBUTE37 VARCHAR2,
713 p_PRICING_ATTRIBUTE38 VARCHAR2,
714 p_PRICING_ATTRIBUTE39 VARCHAR2,
715 p_PRICING_ATTRIBUTE40 VARCHAR2,
716 p_PRICING_ATTRIBUTE41 VARCHAR2,
717 p_PRICING_ATTRIBUTE42 VARCHAR2,
718 p_PRICING_ATTRIBUTE43 VARCHAR2,
719 p_PRICING_ATTRIBUTE44 VARCHAR2,
720 p_PRICING_ATTRIBUTE45 VARCHAR2,
721 p_PRICING_ATTRIBUTE46 VARCHAR2,
722 p_PRICING_ATTRIBUTE47 VARCHAR2,
723 p_PRICING_ATTRIBUTE48 VARCHAR2,
724 p_PRICING_ATTRIBUTE49 VARCHAR2,
725 p_PRICING_ATTRIBUTE50 VARCHAR2,
726 p_PRICING_ATTRIBUTE51 VARCHAR2,
727 p_PRICING_ATTRIBUTE52 VARCHAR2,
728 p_PRICING_ATTRIBUTE53 VARCHAR2,
732 p_PRICING_ATTRIBUTE57 VARCHAR2,
729 p_PRICING_ATTRIBUTE54 VARCHAR2,
730 p_PRICING_ATTRIBUTE55 VARCHAR2,
731 p_PRICING_ATTRIBUTE56 VARCHAR2,
733 p_PRICING_ATTRIBUTE58 VARCHAR2,
734 p_PRICING_ATTRIBUTE59 VARCHAR2,
735 p_PRICING_ATTRIBUTE60 VARCHAR2,
736 p_PRICING_ATTRIBUTE61 VARCHAR2,
737 p_PRICING_ATTRIBUTE62 VARCHAR2,
738 p_PRICING_ATTRIBUTE63 VARCHAR2,
739 p_PRICING_ATTRIBUTE64 VARCHAR2,
740 p_PRICING_ATTRIBUTE65 VARCHAR2,
741 p_PRICING_ATTRIBUTE66 VARCHAR2,
742 p_PRICING_ATTRIBUTE67 VARCHAR2,
743 p_PRICING_ATTRIBUTE68 VARCHAR2,
744 p_PRICING_ATTRIBUTE69 VARCHAR2,
745 p_PRICING_ATTRIBUTE70 VARCHAR2,
746 p_PRICING_ATTRIBUTE71 VARCHAR2,
747 p_PRICING_ATTRIBUTE72 VARCHAR2,
748 p_PRICING_ATTRIBUTE73 VARCHAR2,
749 p_PRICING_ATTRIBUTE74 VARCHAR2,
750 p_PRICING_ATTRIBUTE75 VARCHAR2,
751 p_PRICING_ATTRIBUTE76 VARCHAR2,
752 p_PRICING_ATTRIBUTE77 VARCHAR2,
753 p_PRICING_ATTRIBUTE78 VARCHAR2,
754 p_PRICING_ATTRIBUTE79 VARCHAR2,
755 p_PRICING_ATTRIBUTE80 VARCHAR2,
756 p_PRICING_ATTRIBUTE81 VARCHAR2,
757 p_PRICING_ATTRIBUTE82 VARCHAR2,
758 p_PRICING_ATTRIBUTE83 VARCHAR2,
759 p_PRICING_ATTRIBUTE84 VARCHAR2,
760 p_PRICING_ATTRIBUTE85 VARCHAR2,
761 p_PRICING_ATTRIBUTE86 VARCHAR2,
762 p_PRICING_ATTRIBUTE87 VARCHAR2,
763 p_PRICING_ATTRIBUTE88 VARCHAR2,
764 p_PRICING_ATTRIBUTE89 VARCHAR2,
765 p_PRICING_ATTRIBUTE90 VARCHAR2,
766 p_PRICING_ATTRIBUTE91 VARCHAR2,
767 p_PRICING_ATTRIBUTE92 VARCHAR2,
768 p_PRICING_ATTRIBUTE93 VARCHAR2,
769 p_PRICING_ATTRIBUTE94 VARCHAR2,
770 p_PRICING_ATTRIBUTE95 VARCHAR2,
771 p_PRICING_ATTRIBUTE96 VARCHAR2,
772 p_PRICING_ATTRIBUTE97 VARCHAR2,
773 p_PRICING_ATTRIBUTE98 VARCHAR2,
774 p_PRICING_ATTRIBUTE99 VARCHAR2,
775 p_PRICING_ATTRIBUTE100 VARCHAR2,
776 p_ATTRIBUTE1 VARCHAR2,
777 p_ATTRIBUTE2 VARCHAR2,
778 p_ATTRIBUTE3 VARCHAR2,
779 p_ATTRIBUTE4 VARCHAR2,
780 p_ATTRIBUTE5 VARCHAR2,
781 p_ATTRIBUTE6 VARCHAR2,
782 p_ATTRIBUTE7 VARCHAR2,
783 p_ATTRIBUTE8 VARCHAR2,
784 p_ATTRIBUTE9 VARCHAR2,
785 p_ATTRIBUTE10 VARCHAR2,
786 p_ATTRIBUTE11 VARCHAR2,
787 p_ATTRIBUTE12 VARCHAR2,
788 p_ATTRIBUTE13 VARCHAR2,
789 p_ATTRIBUTE14 VARCHAR2,
790 p_ATTRIBUTE15 VARCHAR2,
791 p_CONTEXT VARCHAR2,
792 p_COVERAGE_BILL_RATE_ID NUMBER,
793 P_COVERAGE_BILLING_TYPE_ID NUMBER,
794 p_TXN_BILLING_TYPE_ID NUMBER,
795 p_SUBMIT_RESTRICTION_MESSAGE VARCHAR2, -- Added Column mviswana 07/23/2003
796 p_SUBMIT_ERROR_MESSAGE VARCHAR2, -- Added Column mviswana 07/23/2003
797 p_SUBMIT_FROM_SYSTEM VARCHAR2, -- Added Column mviswana 07/23/2003
798 p_LINE_SUBMITTED VARCHAR2, -- Added Column mviswana 07/23/2003
799 --p_EST_TAX_AMOUNT NUMBER, -- Obsolete column 11/13/2002 mviswana
800 --p_TAX_CODE VARCHAR2, -- Obsolete column 11/13/2002 mviswana
801 p_LAST_UPDATE_DATE DATE,
802 p_LAST_UPDATE_LOGIN NUMBER,
803 p_LAST_UPDATED_BY NUMBER,
804 p_CREATION_DATE DATE,
805 p_CREATED_BY NUMBER)
806
807 IS
808
809 CURSOR C2 IS
810 SELECT OBJECT_VERSION_NUMBER
811 FROM CS_ESTIMATE_DETAILS
812 WHERE estimate_detail_id = p_estimate_detail_id;
813
814 BEGIN
815
816 OPEN C2;
817 FETCH C2 INTO X_OBJECT_VERSION_NUMBER;
818 CLOSE C2;
819
820 Update CS_ESTIMATE_DETAILS
821 SET
822 /* INCIDENT_ID = p_INCIDENT_ID,
823 ORG_ID = p_ORG_ID,
824 ORIGINAL_SOURCE_ID = p_ORIGINAL_SOURCE_ID,
825 ORIGINAL_SOURCE_CODE = p_ORIGINAL_SOURCE_CODE,
826 SOURCE_ID = p_SOURCE_ID,
827 SOURCE_CODE = p_SOURCE_CODE,
828 CONTRACT_ID = p_CONTRACT_ID,
829 COVERAGE_ID = p_COVERAGE_ID,
830 COVERAGE_TXN_GROUP_ID = p_COVERAGE_TXN_GROUP_ID,
834 CONVERSION_TYPE_CODE = p_CONVERSION_TYPE_CODE ,
831 --EXCEPTION_COVERAGE_USED = p_EXCEPTION_COVERAGE_USED,
832 CURRENCY_CODE = p_CURRENCY_CODE,
833 CONVERSION_RATE = p_CONVERSION_RATE,
835 CONVERSION_RATE_DATE = p_CONVERSION_RATE_DATE ,
836 INVOICE_TO_ORG_ID = p_INVOICE_TO_ORG_ID,
837 SHIP_TO_ORG_ID = p_SHIP_TO_ORG_ID,
838 PURCHASE_ORDER_NUM = p_PURCHASE_ORDER_NUM,
839 ORDER_LINE_ID = p_ORDER_LINE_ID, -- Obsolete column 11/13/2002 mviswana
840 LINE_TYPE_ID = p_LINE_TYPE_ID, -- Obsolete column 11/13/2002 mviswana
841 LINE_CATEGORY_CODE = p_LINE_CATEGORY_CODE,
842 PRICE_LIST_HEADER_ID = p_PRICE_LIST_HEADER_ID,
843 LINE_NUMBER = p_LINE_NUMBER,
844 INVENTORY_ITEM_ID = p_INVENTORY_ITEM_ID,
845 ITEM_REVISION = p_ITEM_REVISION,
846 SERIAL_NUMBER = p_SERIAL_NUMBER,
847 QUANTITY_REQUIRED = p_QUANTITY_REQUIRED,
848 UNIT_OF_MEASURE_CODE = p_UNIT_OF_MEASURE_CODE,
849 SELLING_PRICE = p_SELLING_PRICE,
850 AFTER_WARRANTY_COST = p_AFTER_WARRANTY_COST,
851 --FUNC_CURR_AFT_WARR_COST = p_FUNC_CURR_AFT_WARR_COST, -- Obsolete column 11/13/2002 mviswana
852 BUSINESS_PROCESS_ID = p_BUSINESS_PROCESS_ID,
853 TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID,
854 CUSTOMER_PRODUCT_ID = p_CUSTOMER_PRODUCT_ID,
855 ORDER_HEADER_ID = p_ORDER_HEADER_ID,
856 INSTALLED_CP_RETURN_BY_DATE = p_INSTALLED_CP_RETURN_BY_DATE,
857 NEW_CP_RETURN_BY_DATE = p_NEW_CP_RETURN_BY_DATE,
858 INTERFACE_TO_OE_FLAG = p_INTERFACE_TO_OE_FLAG,
859 ROLLUP_FLAG = p_ROLLUP_FLAG,
860 NO_CHARGE_FLAG = p_NO_CHARGE_FLAG,
861 ADD_TO_ORDER_FLAG = p_ADD_TO_ORDER_FLAG,
862 RETURN_REASON_CODE = p_RETURN_REASON_CODE,
863 GENERATED_BY_BCA_ENGINE_FLAG = p_GENERATED_BY_BCA_ENGINE_FLAG,
864 TRANSACTION_INVENTORY_ORG = p_TRANSACTION_INVENTORY_ORG,
865 TRANSACTION_SUB_INVENTORY = p_TRANSACTION_SUB_INVENTORY,
866 CHARGE_LINE_TYPE = p_CHARGE_LINE_TYPE,
867 SHIP_TO_ACCOUNT_ID = p_SHIP_TO_ACCOUNT_ID,
868 INVOICE_TO_ACCOUNT_ID = p_INVOICE_TO_ACCOUNT_ID,
869 SHIP_TO_CONTACT_ID = p_SHIP_TO_CONTACT_ID,
870 BILL_TO_CONTACT_ID = p_BILL_TO_CONTACT_ID,
871 LIST_PRICE = p_LIST_PRICE,
872 ACTIVITY_START_DATE_TIME = p_ACTIVITY_START_DATE_TIME,
873 ACTIVITY_END_DATE_TIME = p_ACTIVITY_END_DATE_TIME,
874 CONTRACT_DISCOUNT_AMOUNT = p_CONTRACT_DISCOUNT_AMOUNT,
875 BILL_TO_PARTY_ID = p_BILL_TO_PARTY_ID,
876 SHIP_TO_PARTY_ID = p_SHIP_TO_PARTY_ID,
877 PRICING_CONTEXT = p_PRICING_CONTEXT,
878 PRICING_ATTRIBUTE1 = p_PRICING_ATTRIBUTE1,
879 PRICING_ATTRIBUTE2 = p_PRICING_ATTRIBUTE2,
880 PRICING_ATTRIBUTE3 = p_PRICING_ATTRIBUTE3,
881 PRICING_ATTRIBUTE4 = p_PRICING_ATTRIBUTE4,
882 PRICING_ATTRIBUTE5 = p_PRICING_ATTRIBUTE5,
883 PRICING_ATTRIBUTE6 = p_PRICING_ATTRIBUTE6,
884 PRICING_ATTRIBUTE7 = p_PRICING_ATTRIBUTE7,
885 PRICING_ATTRIBUTE8 = p_PRICING_ATTRIBUTE8,
886 PRICING_ATTRIBUTE9 = p_PRICING_ATTRIBUTE9,
887 PRICING_ATTRIBUTE10 = p_PRICING_ATTRIBUTE10,
888 PRICING_ATTRIBUTE11 = p_PRICING_ATTRIBUTE11,
889 PRICING_ATTRIBUTE12 = p_PRICING_ATTRIBUTE12,
890 PRICING_ATTRIBUTE13 = p_PRICING_ATTRIBUTE13,
891 PRICING_ATTRIBUTE14 = p_PRICING_ATTRIBUTE14,
892 PRICING_ATTRIBUTE15 = p_PRICING_ATTRIBUTE15,
893 PRICING_ATTRIBUTE16 = p_PRICING_ATTRIBUTE16,
894 PRICING_ATTRIBUTE17 = p_PRICING_ATTRIBUTE17,
895 PRICING_ATTRIBUTE18 = p_PRICING_ATTRIBUTE18,
896 PRICING_ATTRIBUTE19 = p_PRICING_ATTRIBUTE19,
897 PRICING_ATTRIBUTE20 = p_PRICING_ATTRIBUTE20,
898 PRICING_ATTRIBUTE21 = p_PRICING_ATTRIBUTE21,
899 PRICING_ATTRIBUTE22 = p_PRICING_ATTRIBUTE22,
900 PRICING_ATTRIBUTE23 = p_PRICING_ATTRIBUTE23,
901 PRICING_ATTRIBUTE24 = p_PRICING_ATTRIBUTE24,
902 PRICING_ATTRIBUTE25 = p_PRICING_ATTRIBUTE25,
903 PRICING_ATTRIBUTE26 = p_PRICING_ATTRIBUTE26,
904 PRICING_ATTRIBUTE27 = p_PRICING_ATTRIBUTE27,
905 PRICING_ATTRIBUTE28 = p_PRICING_ATTRIBUTE28,
906 PRICING_ATTRIBUTE29 = p_PRICING_ATTRIBUTE29,
907 PRICING_ATTRIBUTE30 = p_PRICING_ATTRIBUTE30,
908 PRICING_ATTRIBUTE31 = p_PRICING_ATTRIBUTE31,
909 PRICING_ATTRIBUTE32 = p_PRICING_ATTRIBUTE32,
910 PRICING_ATTRIBUTE33 = p_PRICING_ATTRIBUTE33,
911 PRICING_ATTRIBUTE34 = p_PRICING_ATTRIBUTE34,
912 PRICING_ATTRIBUTE35 = p_PRICING_ATTRIBUTE35,
913 PRICING_ATTRIBUTE36 = p_PRICING_ATTRIBUTE36,
914 PRICING_ATTRIBUTE37 = p_PRICING_ATTRIBUTE37,
915 PRICING_ATTRIBUTE38 = p_PRICING_ATTRIBUTE38,
916 PRICING_ATTRIBUTE39 = p_PRICING_ATTRIBUTE39,
917 PRICING_ATTRIBUTE40 = p_PRICING_ATTRIBUTE40,
918 PRICING_ATTRIBUTE41 = p_PRICING_ATTRIBUTE41,
919 PRICING_ATTRIBUTE42 = p_PRICING_ATTRIBUTE42,
920 PRICING_ATTRIBUTE43 = p_PRICING_ATTRIBUTE43,
921 PRICING_ATTRIBUTE44 = p_PRICING_ATTRIBUTE44,
922 PRICING_ATTRIBUTE45 = p_PRICING_ATTRIBUTE45,
923 PRICING_ATTRIBUTE46 = p_PRICING_ATTRIBUTE46,
924 PRICING_ATTRIBUTE47 = p_PRICING_ATTRIBUTE47,
925 PRICING_ATTRIBUTE48 = p_PRICING_ATTRIBUTE48,
926 PRICING_ATTRIBUTE49 = p_PRICING_ATTRIBUTE49,
927 PRICING_ATTRIBUTE50 = p_PRICING_ATTRIBUTE50,
928 PRICING_ATTRIBUTE51 = p_PRICING_ATTRIBUTE51,
929 PRICING_ATTRIBUTE52 = p_PRICING_ATTRIBUTE52,
933 PRICING_ATTRIBUTE56 = p_PRICING_ATTRIBUTE56,
930 PRICING_ATTRIBUTE53 = p_PRICING_ATTRIBUTE53,
931 PRICING_ATTRIBUTE54 = p_PRICING_ATTRIBUTE54,
932 PRICING_ATTRIBUTE55 = p_PRICING_ATTRIBUTE55,
934 PRICING_ATTRIBUTE57 = p_PRICING_ATTRIBUTE57,
935 PRICING_ATTRIBUTE58 = p_PRICING_ATTRIBUTE58,
936 PRICING_ATTRIBUTE59 = p_PRICING_ATTRIBUTE59,
937 PRICING_ATTRIBUTE60 = p_PRICING_ATTRIBUTE60,
938 PRICING_ATTRIBUTE61 = p_PRICING_ATTRIBUTE61,
939 PRICING_ATTRIBUTE62 = p_PRICING_ATTRIBUTE62,
940 PRICING_ATTRIBUTE63 = p_PRICING_ATTRIBUTE63,
941 PRICING_ATTRIBUTE64 = p_PRICING_ATTRIBUTE64,
942 PRICING_ATTRIBUTE65 = p_PRICING_ATTRIBUTE65,
943 PRICING_ATTRIBUTE66 = p_PRICING_ATTRIBUTE66,
944 PRICING_ATTRIBUTE67 = p_PRICING_ATTRIBUTE67,
945 PRICING_ATTRIBUTE68 = p_PRICING_ATTRIBUTE68,
946 PRICING_ATTRIBUTE69 = p_PRICING_ATTRIBUTE69,
947 PRICING_ATTRIBUTE70 = p_PRICING_ATTRIBUTE70,
948 PRICING_ATTRIBUTE71 = p_PRICING_ATTRIBUTE71,
949 PRICING_ATTRIBUTE72 = p_PRICING_ATTRIBUTE72,
950 PRICING_ATTRIBUTE73 = p_PRICING_ATTRIBUTE73,
951 PRICING_ATTRIBUTE74 = p_PRICING_ATTRIBUTE74,
952 PRICING_ATTRIBUTE75 = p_PRICING_ATTRIBUTE75,
953 PRICING_ATTRIBUTE76 = p_PRICING_ATTRIBUTE76,
954 PRICING_ATTRIBUTE77 = p_PRICING_ATTRIBUTE77,
955 PRICING_ATTRIBUTE78 = p_PRICING_ATTRIBUTE78,
956 PRICING_ATTRIBUTE79 = p_PRICING_ATTRIBUTE79,
957 PRICING_ATTRIBUTE80 = p_PRICING_ATTRIBUTE80,
958 PRICING_ATTRIBUTE81 = p_PRICING_ATTRIBUTE81,
959 PRICING_ATTRIBUTE82 = p_PRICING_ATTRIBUTE82,
960 PRICING_ATTRIBUTE83 = p_PRICING_ATTRIBUTE83,
961 PRICING_ATTRIBUTE84 = p_PRICING_ATTRIBUTE84,
962 PRICING_ATTRIBUTE85 = p_PRICING_ATTRIBUTE85,
963 PRICING_ATTRIBUTE86 = p_PRICING_ATTRIBUTE86,
964 PRICING_ATTRIBUTE87 = p_PRICING_ATTRIBUTE87,
965 PRICING_ATTRIBUTE88 = p_PRICING_ATTRIBUTE88,
966 PRICING_ATTRIBUTE89 = p_PRICING_ATTRIBUTE89,
967 PRICING_ATTRIBUTE90 = p_PRICING_ATTRIBUTE90,
968 PRICING_ATTRIBUTE91 = p_PRICING_ATTRIBUTE91,
969 PRICING_ATTRIBUTE92 = p_PRICING_ATTRIBUTE92,
970 PRICING_ATTRIBUTE93 = p_PRICING_ATTRIBUTE93,
971 PRICING_ATTRIBUTE94 = p_PRICING_ATTRIBUTE94,
972 PRICING_ATTRIBUTE95 = p_PRICING_ATTRIBUTE95,
973 PRICING_ATTRIBUTE96 = p_PRICING_ATTRIBUTE96,
974 PRICING_ATTRIBUTE97 = p_PRICING_ATTRIBUTE97,
975 PRICING_ATTRIBUTE98 = p_PRICING_ATTRIBUTE98,
976 PRICING_ATTRIBUTE99 = p_PRICING_ATTRIBUTE99,
977 PRICING_ATTRIBUTE100 = p_PRICING_ATTRIBUTE100,
978 ATTRIBUTE1 = p_ATTRIBUTE1,
979 ATTRIBUTE2 = p_ATTRIBUTE2,
980 ATTRIBUTE3 = p_ATTRIBUTE3,
981 ATTRIBUTE4 = p_ATTRIBUTE4,
982 ATTRIBUTE5 = p_ATTRIBUTE5,
983 ATTRIBUTE6 = p_ATTRIBUTE6,
984 ATTRIBUTE7 = p_ATTRIBUTE7,
985 ATTRIBUTE8 = p_ATTRIBUTE8,
986 ATTRIBUTE9 = p_ATTRIBUTE9,
987 ATTRIBUTE10 = p_ATTRIBUTE10,
988 ATTRIBUTE11 = p_ATTRIBUTE11,
989 ATTRIBUTE12 = p_ATTRIBUTE12,
990 ATTRIBUTE13 = p_ATTRIBUTE13,
991 ATTRIBUTE14 = p_ATTRIBUTE14,
992 ATTRIBUTE15 = p_ATTRIBUTE15,
993 CONTEXT = p_CONTEXT,
994 COVERAGE_BILL_RATE_ID = p_COVERAGE_BILL_RATE_ID,
995 TXN_BILLING_TYPE_ID = p_TXN_BILLING_TYPE_ID,
996 --EST_TAX_AMOUNT = p_EST_TAX_AMOUNT, -- Obsolete column 11/13/2002 mviswana
997 --TAX_CODE = p_TAX_CODE, -- Obsolete column 11/13/2002 mviswana
998 LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
999 LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
1000 LAST_UPDATED_BY = p_LAST_UPDATED_BY,
1001 CREATION_DATE = p_CREATION_DATE,
1002 CREATED_BY = p_CREATED_BY,
1003 OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER+1 */
1004
1005 INCIDENT_ID = decode( p_INCIDENT_ID, FND_API.G_MISS_NUM, INCIDENT_ID, p_INCIDENT_ID),
1006 ORG_ID = decode( p_ORG_ID, FND_API.G_MISS_NUM, ORG_ID, p_ORG_ID),
1007 ORIGINAL_SOURCE_ID = decode( to_char(p_ORIGINAL_SOURCE_ID), FND_API.G_MISS_CHAR, ORIGINAL_SOURCE_ID, to_char(p_ORIGINAL_SOURCE_ID)),
1008 ORIGINAL_SOURCE_CODE = decode( p_ORIGINAL_SOURCE_CODE, FND_API.G_MISS_CHAR, ORIGINAL_SOURCE_CODE, p_ORIGINAL_SOURCE_CODE),
1009 SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID),
1010 SOURCE_CODE = decode( p_SOURCE_CODE, FND_API.G_MISS_CHAR, SOURCE_CODE, p_SOURCE_CODE),
1011 CONTRACT_LINE_ID = DECODE( p_CONTRACT_LINE_ID,FND_API.G_MISS_NUM,CONTRACT_LINE_ID, p_CONTRACT_LINE_ID),
1012 RATE_TYPE_CODE = DECODE(p_RATE_TYPE_CODE,FND_API.G_MISS_CHAR,RATE_TYPE_CODE, p_RATE_TYPE_CODE),
1013 CONTRACT_ID = decode( p_CONTRACT_ID, FND_API.G_MISS_NUM, CONTRACT_ID, p_CONTRACT_ID),
1014 COVERAGE_ID = decode( p_COVERAGE_ID, FND_API.G_MISS_NUM, COVERAGE_ID, p_COVERAGE_ID),
1015 COVERAGE_TXN_GROUP_ID = decode( p_COVERAGE_TXN_GROUP_ID, FND_API.G_MISS_NUM, COVERAGE_TXN_GROUP_ID, p_COVERAGE_TXN_GROUP_ID),
1016 --EXCEPTION_COVERAGE_USED = decode( p_EXCEPTION_COVERAGE_USED, FND_API.G_MISS_CHAR, EXCEPTION_COVERAGE_USED, p_EXCEPTION_COVERAGE_USED),
1017 CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
1018 CONVERSION_RATE = decode( p_CONVERSION_RATE, FND_API.G_MISS_NUM, CONVERSION_RATE, p_CONVERSION_RATE),
1019
1020 CONVERSION_TYPE_CODE = decode( p_CONVERSION_TYPE_CODE, FND_API.G_MISS_CHAR, CONVERSION_TYPE_CODE, p_CONVERSION_TYPE_CODE),
1021
1025 SHIP_TO_ORG_ID = decode( p_SHIP_TO_ORG_ID, FND_API.G_MISS_NUM, SHIP_TO_ORG_ID, p_SHIP_TO_ORG_ID),
1022 CONVERSION_RATE_DATE = decode( p_CONVERSION_RATE_DATE, FND_API.G_MISS_DATE, CONVERSION_RATE_DATE, p_CONVERSION_RATE_DATE),
1023
1024 INVOICE_TO_ORG_ID = decode( p_INVOICE_TO_ORG_ID, FND_API.G_MISS_NUM, INVOICE_TO_ORG_ID, p_INVOICE_TO_ORG_ID),
1026 PURCHASE_ORDER_NUM = decode( p_PURCHASE_ORDER_NUM, FND_API.G_MISS_CHAR, PURCHASE_ORDER_NUM, p_PURCHASE_ORDER_NUM),
1027 ORDER_LINE_ID = decode( p_ORDER_LINE_ID, FND_API.G_MISS_NUM, ORDER_LINE_ID, p_ORDER_LINE_ID),
1028
1029 LINE_TYPE_ID = decode( p_LINE_TYPE_ID, FND_API.G_MISS_NUM, LINE_TYPE_ID, p_LINE_TYPE_ID),
1030
1031 LINE_CATEGORY_CODE = decode( p_LINE_CATEGORY_CODE, FND_API.G_MISS_CHAR, LINE_CATEGORY_CODE, p_LINE_CATEGORY_CODE),
1032 PRICE_LIST_HEADER_ID = decode( p_PRICE_LIST_HEADER_ID, FND_API.G_MISS_NUM, PRICE_LIST_HEADER_ID, p_PRICE_LIST_HEADER_ID),
1033 LINE_NUMBER = decode( p_LINE_NUMBER, FND_API.G_MISS_NUM, LINE_NUMBER, p_LINE_NUMBER),
1034 INVENTORY_ITEM_ID = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID),
1035 ITEM_REVISION = decode( p_ITEM_REVISION, FND_API.G_MISS_CHAR, ITEM_REVISION, p_ITEM_REVISION),
1036 SERIAL_NUMBER = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, SERIAL_NUMBER, p_SERIAL_NUMBER),
1037 QUANTITY_REQUIRED = decode( p_QUANTITY_REQUIRED, FND_API.G_MISS_NUM, QUANTITY_REQUIRED, p_QUANTITY_REQUIRED),
1038 UNIT_OF_MEASURE_CODE = decode( p_UNIT_OF_MEASURE_CODE, FND_API.G_MISS_CHAR, UNIT_OF_MEASURE_CODE, p_UNIT_OF_MEASURE_CODE),
1039 SELLING_PRICE = decode( p_SELLING_PRICE, FND_API.G_MISS_NUM, SELLING_PRICE, p_SELLING_PRICE),
1040 AFTER_WARRANTY_COST = decode( p_AFTER_WARRANTY_COST, FND_API.G_MISS_NUM, AFTER_WARRANTY_COST, p_AFTER_WARRANTY_COST),
1041 --FUNC_CURR_AFT_WARR_COST = decode( p_FUNC_CURR_AFT_WARR_COST, FND_API.G_MISS_NUM, FUNC_CURR_AFT_WARR_COST, p_FUNC_CURR_AFT_WARR_COST),
1042 -- Obsolete column 11/13/2002 mviswana
1043 BUSINESS_PROCESS_ID = decode( p_BUSINESS_PROCESS_ID, FND_API.G_MISS_NUM, BUSINESS_PROCESS_ID, p_BUSINESS_PROCESS_ID),
1044 TRANSACTION_TYPE_ID = decode( p_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, TRANSACTION_TYPE_ID, p_TRANSACTION_TYPE_ID),
1045 CUSTOMER_PRODUCT_ID = decode( p_CUSTOMER_PRODUCT_ID, FND_API.G_MISS_NUM, CUSTOMER_PRODUCT_ID, p_CUSTOMER_PRODUCT_ID),
1046 ORDER_HEADER_ID = decode( p_ORDER_HEADER_ID, FND_API.G_MISS_NUM, ORDER_HEADER_ID, p_ORDER_HEADER_ID),
1047 INSTALLED_CP_RETURN_BY_DATE = decode( p_INSTALLED_CP_RETURN_BY_DATE, FND_API.G_MISS_DATE, INSTALLED_CP_RETURN_BY_DATE, p_INSTALLED_CP_RETURN_BY_DATE),
1048 NEW_CP_RETURN_BY_DATE = decode( p_NEW_CP_RETURN_BY_DATE, FND_API.G_MISS_DATE, NEW_CP_RETURN_BY_DATE, p_NEW_CP_RETURN_BY_DATE),
1049 INTERFACE_TO_OE_FLAG = decode( p_INTERFACE_TO_OE_FLAG, FND_API.G_MISS_CHAR, INTERFACE_TO_OE_FLAG, p_INTERFACE_TO_OE_FLAG),
1050 ROLLUP_FLAG = decode( p_ROLLUP_FLAG, FND_API.G_MISS_CHAR, ROLLUP_FLAG, p_ROLLUP_FLAG),
1051 NO_CHARGE_FLAG = decode( p_NO_CHARGE_FLAG, FND_API.G_MISS_CHAR, NO_CHARGE_FLAG, p_NO_CHARGE_FLAG),
1052 ADD_TO_ORDER_FLAG = decode( p_ADD_TO_ORDER_FLAG, FND_API.G_MISS_CHAR, ADD_TO_ORDER_FLAG, p_ADD_TO_ORDER_FLAG),
1053 RETURN_REASON_CODE = decode( p_RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, p_RETURN_REASON_CODE),
1054 GENERATED_BY_BCA_ENGINE_FLAG = decode(p_GENERATED_BY_BCA_ENGINE_FLAG,FND_API.G_MISS_CHAR,GENERATED_BY_BCA_ENGINE_FLAG,p_GENERATED_BY_BCA_ENGINE_FLAG),
1055 TRANSACTION_INVENTORY_ORG = decode(p_TRANSACTION_INVENTORY_ORG,FND_API.G_MISS_NUM,TRANSACTION_INVENTORY_ORG,p_TRANSACTION_INVENTORY_ORG),
1056 TRANSACTION_SUB_INVENTORY = decode(p_TRANSACTION_SUB_INVENTORY,FND_API.G_MISS_CHAR,TRANSACTION_SUB_INVENTORY,p_TRANSACTION_SUB_INVENTORY),
1057 CHARGE_LINE_TYPE = decode(p_CHARGE_LINE_TYPE,FND_API.G_MISS_CHAR,CHARGE_LINE_TYPE,p_CHARGE_LINE_TYPE),
1058 SHIP_TO_ACCOUNT_ID = decode(p_SHIP_TO_ACCOUNT_ID,FND_API.G_MISS_NUM,SHIP_TO_ACCOUNT_ID,p_SHIP_TO_ACCOUNT_ID),
1059 INVOICE_TO_ACCOUNT_ID = decode(p_INVOICE_TO_ACCOUNT_ID,FND_API.G_MISS_NUM,INVOICE_TO_ACCOUNT_ID,p_INVOICE_TO_ACCOUNT_ID),
1060 SHIP_TO_CONTACT_ID = decode(p_SHIP_TO_CONTACT_ID,FND_API.G_MISS_NUM,SHIP_TO_CONTACT_ID,p_SHIP_TO_CONTACT_ID),
1061 BILL_TO_CONTACT_ID = decode(p_BILL_TO_CONTACT_ID,FND_API.G_MISS_NUM,BILL_TO_CONTACT_ID,p_BILL_TO_CONTACT_ID),
1062 LIST_PRICE = decode(p_LIST_PRICE,FND_API.G_MISS_NUM,LIST_PRICE,p_LIST_PRICE),
1063 ACTIVITY_START_DATE_TIME = decode(p_ACTIVITY_START_DATE_TIME,FND_API.G_MISS_DATE,ACTIVITY_START_DATE_TIME,p_ACTIVITY_START_DATE_TIME),
1064 ACTIVITY_END_DATE_TIME = decode(p_ACTIVITY_END_DATE_TIME,FND_API.G_MISS_DATE,ACTIVITY_END_DATE_TIME,p_ACTIVITY_END_DATE_TIME),
1065 CONTRACT_DISCOUNT_AMOUNT = decode(p_CONTRACT_DISCOUNT_AMOUNT,FND_API.G_MISS_NUM,CONTRACT_DISCOUNT_AMOUNT,p_CONTRACT_DISCOUNT_AMOUNT),
1066 BILL_TO_PARTY_ID = decode(p_BILL_TO_PARTY_ID,FND_API.G_MISS_NUM,BILL_TO_PARTY_ID,p_BILL_TO_PARTY_ID),
1067 SHIP_TO_PARTY_ID = decode(p_SHIP_TO_PARTY_ID,FND_API.G_MISS_NUM,SHIP_TO_PARTY_ID,p_SHIP_TO_PARTY_ID),
1068 PRICING_CONTEXT = decode( p_PRICING_CONTEXT, FND_API.G_MISS_CHAR, PRICING_CONTEXT, p_PRICING_CONTEXT),
1069 PRICING_ATTRIBUTE1 = decode( p_PRICING_ATTRIBUTE1, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE1, p_PRICING_ATTRIBUTE1),
1070 PRICING_ATTRIBUTE2 = decode( p_PRICING_ATTRIBUTE2, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE2, p_PRICING_ATTRIBUTE2),
1071 PRICING_ATTRIBUTE3 = decode( p_PRICING_ATTRIBUTE3, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE3, p_PRICING_ATTRIBUTE3),
1072 PRICING_ATTRIBUTE4 = decode( p_PRICING_ATTRIBUTE4, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE4, p_PRICING_ATTRIBUTE4),
1076 PRICING_ATTRIBUTE8 = decode( p_PRICING_ATTRIBUTE8, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE8, p_PRICING_ATTRIBUTE8),
1073 PRICING_ATTRIBUTE5 = decode( p_PRICING_ATTRIBUTE5, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE5, p_PRICING_ATTRIBUTE5),
1074 PRICING_ATTRIBUTE6 = decode( p_PRICING_ATTRIBUTE6, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE6, p_PRICING_ATTRIBUTE6),
1075 PRICING_ATTRIBUTE7 = decode( p_PRICING_ATTRIBUTE7, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE7, p_PRICING_ATTRIBUTE7),
1077 PRICING_ATTRIBUTE9 = decode( p_PRICING_ATTRIBUTE9, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE9, p_PRICING_ATTRIBUTE9),
1078 PRICING_ATTRIBUTE10 = decode( p_PRICING_ATTRIBUTE10, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE10, p_PRICING_ATTRIBUTE10),
1079 PRICING_ATTRIBUTE11 = decode( p_PRICING_ATTRIBUTE11, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE11, p_PRICING_ATTRIBUTE11),
1080 PRICING_ATTRIBUTE12 = decode( p_PRICING_ATTRIBUTE12, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE12, p_PRICING_ATTRIBUTE12),
1081 PRICING_ATTRIBUTE13 = decode( p_PRICING_ATTRIBUTE13, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE13, p_PRICING_ATTRIBUTE13),
1082 PRICING_ATTRIBUTE14 = decode( p_PRICING_ATTRIBUTE14, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE14, p_PRICING_ATTRIBUTE14),
1083 PRICING_ATTRIBUTE15 = decode( p_PRICING_ATTRIBUTE15, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE15, p_PRICING_ATTRIBUTE15),
1084 PRICING_ATTRIBUTE16 = decode( p_PRICING_ATTRIBUTE16, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE16, p_PRICING_ATTRIBUTE16),
1085 PRICING_ATTRIBUTE17 = decode( p_PRICING_ATTRIBUTE17, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE17, p_PRICING_ATTRIBUTE17),
1086 PRICING_ATTRIBUTE18 = decode( p_PRICING_ATTRIBUTE18, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE18, p_PRICING_ATTRIBUTE18),
1087 PRICING_ATTRIBUTE19 = decode( p_PRICING_ATTRIBUTE19, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE19, p_PRICING_ATTRIBUTE19),
1088 PRICING_ATTRIBUTE20 = decode( p_PRICING_ATTRIBUTE20, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE20, p_PRICING_ATTRIBUTE20),
1089 PRICING_ATTRIBUTE21 = decode( p_PRICING_ATTRIBUTE21, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE21, p_PRICING_ATTRIBUTE21),
1090 PRICING_ATTRIBUTE22 = decode( p_PRICING_ATTRIBUTE22, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE22, p_PRICING_ATTRIBUTE22),
1091 PRICING_ATTRIBUTE23 = decode( p_PRICING_ATTRIBUTE23, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE23, p_PRICING_ATTRIBUTE23),
1092 PRICING_ATTRIBUTE24 = decode( p_PRICING_ATTRIBUTE24, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE24, p_PRICING_ATTRIBUTE24),
1093 PRICING_ATTRIBUTE25 = decode( p_PRICING_ATTRIBUTE25, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE25, p_PRICING_ATTRIBUTE25),
1094 PRICING_ATTRIBUTE26 = decode( p_PRICING_ATTRIBUTE26, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE26, p_PRICING_ATTRIBUTE26),
1095 PRICING_ATTRIBUTE27 = decode( p_PRICING_ATTRIBUTE27, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE27, p_PRICING_ATTRIBUTE27),
1096 PRICING_ATTRIBUTE28 = decode( p_PRICING_ATTRIBUTE28, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE28, p_PRICING_ATTRIBUTE28),
1097 PRICING_ATTRIBUTE29 = decode( p_PRICING_ATTRIBUTE29, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE29, p_PRICING_ATTRIBUTE29),
1098 PRICING_ATTRIBUTE30 = decode( p_PRICING_ATTRIBUTE30, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE30, p_PRICING_ATTRIBUTE30),
1099 PRICING_ATTRIBUTE31 = decode( p_PRICING_ATTRIBUTE31, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE31, p_PRICING_ATTRIBUTE31),
1100 PRICING_ATTRIBUTE32 = decode( p_PRICING_ATTRIBUTE32, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE32, p_PRICING_ATTRIBUTE32),
1101 PRICING_ATTRIBUTE33 = decode( p_PRICING_ATTRIBUTE33, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE33, p_PRICING_ATTRIBUTE33),
1102 PRICING_ATTRIBUTE34 = decode( p_PRICING_ATTRIBUTE34, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE34, p_PRICING_ATTRIBUTE34),
1103 PRICING_ATTRIBUTE35 = decode( p_PRICING_ATTRIBUTE35, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE35, p_PRICING_ATTRIBUTE35),
1104 PRICING_ATTRIBUTE36 = decode( p_PRICING_ATTRIBUTE36, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE36, p_PRICING_ATTRIBUTE36),
1105 PRICING_ATTRIBUTE37 = decode( p_PRICING_ATTRIBUTE37, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE37, p_PRICING_ATTRIBUTE37),
1106 PRICING_ATTRIBUTE38 = decode( p_PRICING_ATTRIBUTE38, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE38, p_PRICING_ATTRIBUTE38),
1107 PRICING_ATTRIBUTE39 = decode( p_PRICING_ATTRIBUTE39, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE39, p_PRICING_ATTRIBUTE39),
1108 PRICING_ATTRIBUTE40 = decode( p_PRICING_ATTRIBUTE40, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE40, p_PRICING_ATTRIBUTE40),
1109 PRICING_ATTRIBUTE41 = decode( p_PRICING_ATTRIBUTE41, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE41, p_PRICING_ATTRIBUTE41),
1110 PRICING_ATTRIBUTE42 = decode( p_PRICING_ATTRIBUTE42, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE42, p_PRICING_ATTRIBUTE42),
1111 PRICING_ATTRIBUTE43 = decode( p_PRICING_ATTRIBUTE43, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE43, p_PRICING_ATTRIBUTE43),
1112 PRICING_ATTRIBUTE44 = decode( p_PRICING_ATTRIBUTE44, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE44, p_PRICING_ATTRIBUTE44),
1113 PRICING_ATTRIBUTE45 = decode( p_PRICING_ATTRIBUTE45, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE45, p_PRICING_ATTRIBUTE45),
1114 PRICING_ATTRIBUTE46 = decode( p_PRICING_ATTRIBUTE46, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE46, p_PRICING_ATTRIBUTE46),
1115 PRICING_ATTRIBUTE47 = decode( p_PRICING_ATTRIBUTE47, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE47, p_PRICING_ATTRIBUTE47),
1116 PRICING_ATTRIBUTE48 = decode( p_PRICING_ATTRIBUTE48, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE48, p_PRICING_ATTRIBUTE48),
1117 PRICING_ATTRIBUTE49 = decode( p_PRICING_ATTRIBUTE49, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE49, p_PRICING_ATTRIBUTE49),
1118 PRICING_ATTRIBUTE50 = decode( p_PRICING_ATTRIBUTE50, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE50, p_PRICING_ATTRIBUTE50),
1119 PRICING_ATTRIBUTE51 = decode( p_PRICING_ATTRIBUTE51, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE51, p_PRICING_ATTRIBUTE51),
1123 PRICING_ATTRIBUTE55 = decode( p_PRICING_ATTRIBUTE55, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE55, p_PRICING_ATTRIBUTE55),
1120 PRICING_ATTRIBUTE52 = decode( p_PRICING_ATTRIBUTE52, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE52, p_PRICING_ATTRIBUTE52),
1121 PRICING_ATTRIBUTE53 = decode( p_PRICING_ATTRIBUTE53, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE53, p_PRICING_ATTRIBUTE53),
1122 PRICING_ATTRIBUTE54 = decode( p_PRICING_ATTRIBUTE54, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE54, p_PRICING_ATTRIBUTE54),
1124 PRICING_ATTRIBUTE56 = decode( p_PRICING_ATTRIBUTE56, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE56, p_PRICING_ATTRIBUTE56),
1125 PRICING_ATTRIBUTE57 = decode( p_PRICING_ATTRIBUTE57, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE57, p_PRICING_ATTRIBUTE57),
1126 PRICING_ATTRIBUTE58 = decode( p_PRICING_ATTRIBUTE58, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE58, p_PRICING_ATTRIBUTE58),
1127 PRICING_ATTRIBUTE59 = decode( p_PRICING_ATTRIBUTE59, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE59, p_PRICING_ATTRIBUTE59),
1128 PRICING_ATTRIBUTE60 = decode( p_PRICING_ATTRIBUTE60, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE60, p_PRICING_ATTRIBUTE60),
1129 PRICING_ATTRIBUTE61 = decode( p_PRICING_ATTRIBUTE61, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE61, p_PRICING_ATTRIBUTE61),
1130 PRICING_ATTRIBUTE62 = decode( p_PRICING_ATTRIBUTE62, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE62, p_PRICING_ATTRIBUTE62),
1131 PRICING_ATTRIBUTE63 = decode( p_PRICING_ATTRIBUTE63, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE63, p_PRICING_ATTRIBUTE63),
1132 PRICING_ATTRIBUTE64 = decode( p_PRICING_ATTRIBUTE64, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE64, p_PRICING_ATTRIBUTE64),
1133 PRICING_ATTRIBUTE65 = decode( p_PRICING_ATTRIBUTE65, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE65, p_PRICING_ATTRIBUTE65),
1134 PRICING_ATTRIBUTE66 = decode( p_PRICING_ATTRIBUTE66, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE66, p_PRICING_ATTRIBUTE66),
1135 PRICING_ATTRIBUTE67 = decode( p_PRICING_ATTRIBUTE67, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE67, p_PRICING_ATTRIBUTE67),
1136 PRICING_ATTRIBUTE68 = decode( p_PRICING_ATTRIBUTE68, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE68, p_PRICING_ATTRIBUTE68),
1137 PRICING_ATTRIBUTE69 = decode( p_PRICING_ATTRIBUTE69, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE69, p_PRICING_ATTRIBUTE69),
1138 PRICING_ATTRIBUTE70 = decode( p_PRICING_ATTRIBUTE70, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE70, p_PRICING_ATTRIBUTE70),
1139 PRICING_ATTRIBUTE71 = decode( p_PRICING_ATTRIBUTE71, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE71, p_PRICING_ATTRIBUTE71),
1140 PRICING_ATTRIBUTE72 = decode( p_PRICING_ATTRIBUTE72, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE72, p_PRICING_ATTRIBUTE72),
1141 PRICING_ATTRIBUTE73 = decode( p_PRICING_ATTRIBUTE73, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE73, p_PRICING_ATTRIBUTE73),
1142 PRICING_ATTRIBUTE74 = decode( p_PRICING_ATTRIBUTE74, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE74, p_PRICING_ATTRIBUTE74),
1143 PRICING_ATTRIBUTE75 = decode( p_PRICING_ATTRIBUTE75, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE75, p_PRICING_ATTRIBUTE75),
1144 PRICING_ATTRIBUTE76 = decode( p_PRICING_ATTRIBUTE76, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE76, p_PRICING_ATTRIBUTE76),
1145 PRICING_ATTRIBUTE77 = decode( p_PRICING_ATTRIBUTE77, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE77, p_PRICING_ATTRIBUTE77),
1146 PRICING_ATTRIBUTE78 = decode( p_PRICING_ATTRIBUTE78, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE78, p_PRICING_ATTRIBUTE78),
1147 PRICING_ATTRIBUTE79 = decode( p_PRICING_ATTRIBUTE79, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE79, p_PRICING_ATTRIBUTE79),
1148 PRICING_ATTRIBUTE80 = decode( p_PRICING_ATTRIBUTE80, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE80, p_PRICING_ATTRIBUTE80),
1149 PRICING_ATTRIBUTE81 = decode( p_PRICING_ATTRIBUTE81, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE81, p_PRICING_ATTRIBUTE81),
1150 PRICING_ATTRIBUTE82 = decode( p_PRICING_ATTRIBUTE82, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE82, p_PRICING_ATTRIBUTE82),
1151 PRICING_ATTRIBUTE83 = decode( p_PRICING_ATTRIBUTE83, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE83, p_PRICING_ATTRIBUTE83),
1152 PRICING_ATTRIBUTE84 = decode( p_PRICING_ATTRIBUTE84, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE84, p_PRICING_ATTRIBUTE84),
1153 PRICING_ATTRIBUTE85 = decode( p_PRICING_ATTRIBUTE85, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE85, p_PRICING_ATTRIBUTE85),
1154 PRICING_ATTRIBUTE86 = decode( p_PRICING_ATTRIBUTE86, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE86, p_PRICING_ATTRIBUTE86),
1155 PRICING_ATTRIBUTE87 = decode( p_PRICING_ATTRIBUTE87, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE87, p_PRICING_ATTRIBUTE87),
1156 PRICING_ATTRIBUTE88 = decode( p_PRICING_ATTRIBUTE88, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE88, p_PRICING_ATTRIBUTE88),
1157 PRICING_ATTRIBUTE89 = decode( p_PRICING_ATTRIBUTE89, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE89, p_PRICING_ATTRIBUTE89),
1158 PRICING_ATTRIBUTE90 = decode( p_PRICING_ATTRIBUTE90, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE90, p_PRICING_ATTRIBUTE90),
1159 PRICING_ATTRIBUTE91 = decode( p_PRICING_ATTRIBUTE91, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE91, p_PRICING_ATTRIBUTE91),
1160 PRICING_ATTRIBUTE92 = decode( p_PRICING_ATTRIBUTE92, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE92, p_PRICING_ATTRIBUTE92),
1161 PRICING_ATTRIBUTE93 = decode( p_PRICING_ATTRIBUTE93, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE93, p_PRICING_ATTRIBUTE93),
1162 PRICING_ATTRIBUTE94 = decode( p_PRICING_ATTRIBUTE94, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE94, p_PRICING_ATTRIBUTE94),
1163 PRICING_ATTRIBUTE95 = decode( p_PRICING_ATTRIBUTE95, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE95, p_PRICING_ATTRIBUTE95),
1164 PRICING_ATTRIBUTE96 = decode( p_PRICING_ATTRIBUTE96, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE96, p_PRICING_ATTRIBUTE96),
1165 PRICING_ATTRIBUTE97 = decode( p_PRICING_ATTRIBUTE97, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE97, p_PRICING_ATTRIBUTE97),
1166 PRICING_ATTRIBUTE98 = decode( p_PRICING_ATTRIBUTE98, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE98, p_PRICING_ATTRIBUTE98),
1167 PRICING_ATTRIBUTE99 = decode( p_PRICING_ATTRIBUTE99, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE99, p_PRICING_ATTRIBUTE99),
1171 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
1168 PRICING_ATTRIBUTE100 = decode( p_PRICING_ATTRIBUTE100, FND_API.G_MISS_CHAR, PRICING_ATTRIBUTE100, p_PRICING_ATTRIBUTE100),
1169 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
1170 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
1172 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
1173 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
1174 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
1175 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
1176 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
1177 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
1178 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
1179 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
1180 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
1181 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
1182 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
1183 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
1184 CONTEXT = decode( p_CONTEXT, FND_API.G_MISS_CHAR, CONTEXT, p_CONTEXT),
1185 COVERAGE_BILL_RATE_ID = decode( p_COVERAGE_BILL_RATE_ID, FND_API.G_MISS_NUM, COVERAGE_BILL_RATE_ID, p_COVERAGE_BILL_RATE_ID),
1186 --Obsoleted to fix Bug # 3477626
1187 -- COVERAGE_BILLING_TYPE_ID = decode( P_COVERAGE_BILLING_TYPE_ID, FND_API.G_MISS_NUM,COVERAGE_BILLING_TYPE_ID, p_COVERAGE_BILLING_TYPE_ID),
1188 TXN_BILLING_TYPE_ID = decode( p_TXN_BILLING_TYPE_ID, FND_API.G_MISS_NUM, TXN_BILLING_TYPE_ID, p_TXN_BILLING_TYPE_ID),
1189 SUBMIT_RESTRICTION_MESSAGE = decode( p_SUBMIT_RESTRICTION_MESSAGE, FND_API.G_MISS_CHAR, SUBMIT_RESTRICTION_MESSAGE, p_SUBMIT_RESTRICTION_MESSAGE),
1190 SUBMIT_ERROR_MESSAGE = decode( p_SUBMIT_ERROR_MESSAGE, FND_API.G_MISS_CHAR, SUBMIT_ERROR_MESSAGE, p_SUBMIT_ERROR_MESSAGE),
1191 SUBMIT_FROM_SYSTEM = decode( p_SUBMIT_FROM_SYSTEM, FND_API.G_MISS_CHAR, SUBMIT_FROM_SYSTEM, p_SUBMIT_FROM_SYSTEM),
1192 LINE_SUBMITTED = decode( p_LINE_SUBMITTED, FND_API.G_MISS_CHAR, LINE_SUBMITTED, p_LINE_SUBMITTED),
1193 --EST_TAX_AMOUNT = decode( p_EST_TAX_AMOUNT, FND_API.G_MISS_NUM, EST_TAX_AMOUNT, p_EST_TAX_AMOUNT),
1194 -- Obsolete column 11/13/2002 mviswana
1195 --TAX_CODE = decode( p_TAX_CODE, FND_API.G_MISS_CHAR, TAX_CODE, p_TAX_CODE),
1196 -- Obsolete column 11/13/2002 mviswana
1197 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
1198 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
1199 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
1200 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
1201 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
1202 OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER+1
1203 WHERE ESTIMATE_DETAIL_ID = p_ESTIMATE_DETAIL_ID;
1204
1205
1206 If (SQL%NOTFOUND) then
1207 RAISE NO_DATA_FOUND;
1208 End If;
1209
1210 X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER+1;
1211 END Update_Row;
1212
1213 PROCEDURE Delete_Row(
1214 p_ESTIMATE_DETAIL_ID NUMBER)
1215 IS
1216 BEGIN
1217 DELETE FROM CS_ESTIMATE_DETAILS
1218 WHERE ESTIMATE_DETAIL_ID = p_ESTIMATE_DETAIL_ID;
1219
1220 If (SQL%NOTFOUND) then
1221 RAISE NO_DATA_FOUND;
1222 End If;
1223
1224 END Delete_Row;
1225
1226 PROCEDURE Lock_Row(
1227 p_ESTIMATE_DETAIL_ID NUMBER,
1228 p_OBJECT_VERSION_NUMBER NUMBER)
1229
1230 IS
1231
1232 CURSOR C IS
1233 SELECT *
1234 FROM CS_ESTIMATE_DETAILS
1235 WHERE ESTIMATE_DETAIL_ID = p_ESTIMATE_DETAIL_ID
1236 AND OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
1237 FOR UPDATE of ESTIMATE_DETAIL_ID NOWAIT;
1238
1239 Recinfo C%ROWTYPE;
1240
1241 BEGIN
1242
1243 OPEN C;
1244 FETCH C INTO Recinfo;
1245 If (C%NOTFOUND) then
1246 CLOSE C;
1247 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1248 APP_EXCEPTION.RAISE_EXCEPTION;
1249 End If;
1250 CLOSE C;
1251 if (
1252 (Recinfo.ESTIMATE_DETAIL_ID = p_ESTIMATE_DETAIL_ID)
1253 AND (( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
1254 OR (( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
1255 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
1256 ) then
1257 return;
1258 else
1259 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1260 APP_EXCEPTION.RAISE_EXCEPTION;
1261 End If;
1262 END Lock_Row;
1263
1264 End CS_ESTIMATE_DETAILS_PKG;