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