[Home] [Help]
PACKAGE BODY: APPS.QA_RESULTS_PKG
Source
1 PACKAGE BODY QA_RESULTS_PKG as
2 /* $Header: qltrestb.plb 120.3.12010000.2 2010/04/26 17:16:38 ntungare ship $ */
3
4 --
5 -- Modified the proc signature and implementation
6 -- to include the database columns added for ASO support.
7 -- rkunchal Thu Jul 25 01:43:48 PDT 2002
8 --
9 --
10 -- See Bug 2588213
11 -- To support the element Maintenance Op Seq Number
12 -- to be used along with Maintenance Workorder
13 -- rkunchal Mon Sep 23 23:46:28 PDT 2002
14 --
15
16 -- Modified the signature to include NCM Hardcode Elements.
17 -- suramasw Thu Oct 31 10:48:59 PST 2002.
18 -- Bug 2449067.
19
20
21 -- Modified the signature to include CAR Hardcode Elements.
22 -- anagarwa Thu Nov 14 13:03:35 PST 2002
23 --
24
25 -- Modified the signature to include new hardcoded element followup activity, transfer license plate number
26 -- saugupta
27
28 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
29 X_Collection_Id NUMBER,
30 X_Occurrence IN OUT NOCOPY NUMBER,
31 X_Last_Update_Date DATE,
32 X_Qa_Last_Update_Date DATE,
33 X_Last_Updated_By NUMBER,
34 X_Qa_Last_Updated_By NUMBER,
35 X_Creation_Date DATE,
36 X_Qa_Creation_Date DATE,
37 X_Created_By NUMBER,
38 X_Qa_Created_By NUMBER,
39 X_Last_Update_Login NUMBER,
40 X_Transaction_Number NUMBER,
41 X_Txn_Header_Id NUMBER,
42 X_Organization_Id NUMBER,
43 X_Plan_Id NUMBER,
44 X_Spec_Id NUMBER,
45 X_Transaction_Id NUMBER,
46 X_Department_Id NUMBER,
47 X_To_Department_Id NUMBER,
48 X_Resource_Id NUMBER,
49 X_Quantity NUMBER,
50 X_Item_Id NUMBER,
51 X_Uom VARCHAR2,
52 X_Revision VARCHAR2,
53 X_Subinventory VARCHAR2,
54 X_Locator_Id NUMBER,
55 X_Lot_Number VARCHAR2,
56 X_Serial_Number VARCHAR2,
57 X_Comp_Item_Id NUMBER,
58 X_Comp_Uom VARCHAR2,
59 X_Comp_Revision VARCHAR2,
60 X_Comp_Subinventory VARCHAR2,
61 X_Comp_Locator_Id NUMBER,
62 X_Comp_Lot_Number VARCHAR2,
63 X_Comp_Serial_Number VARCHAR2,
64 X_Wip_Entity_Id NUMBER,
65 X_Line_Id NUMBER,
66 X_To_Op_Seq_Num NUMBER,
67 X_From_Op_Seq_Num NUMBER,
68 X_Vendor_Id NUMBER,
69 X_Receipt_Num VARCHAR2,
70 X_Po_Header_Id NUMBER,
71 -- bug 9652549 CLM changes
72 X_Po_Line_Num VARCHAR2,
73 X_Po_Release_Id NUMBER,
74 X_Po_Shipment_Num NUMBER,
75 X_Customer_Id NUMBER,
76 X_So_Header_Id NUMBER,
77 X_Rma_Header_Id NUMBER,
78 X_Transaction_Date DATE,
79 X_Status VARCHAR2,
80 X_Project_Id Number ,
81 X_Task_Id Number ,
82 X_LPN_ID Number,
83 X_XFR_LPN_ID NUMBER,
84 X_Contract_ID Number,
85 X_Contract_Line_ID Number,
86 X_Deliverable_ID Number,
87 X_Asset_Group_ID NUMBER,
88 X_Asset_Number VARCHAR2,
89 X_Asset_Instance_ID NUMBER, --dgupta: R12 EAM Integration. Bug 4345492
90 X_Asset_Activity_ID NUMBER,
91 X_Followup_Activity_ID NUMBER,
92 X_Work_Order_ID NUMBER,
93 X_Character1 VARCHAR2,
94 X_Character2 VARCHAR2,
95 X_Character3 VARCHAR2,
96 X_Character4 VARCHAR2,
97 X_Character5 VARCHAR2,
98 X_Character6 VARCHAR2,
99 X_Character7 VARCHAR2,
100 X_Character8 VARCHAR2,
101 X_Character9 VARCHAR2,
102 X_Character10 VARCHAR2,
103 X_Character11 VARCHAR2,
104 X_Character12 VARCHAR2,
105 X_Character13 VARCHAR2,
106 X_Character14 VARCHAR2,
107 X_Character15 VARCHAR2,
108 X_Character16 VARCHAR2,
109 X_Character17 VARCHAR2,
110 X_Character18 VARCHAR2,
111 X_Character19 VARCHAR2,
112 X_Character20 VARCHAR2,
113 X_Character21 VARCHAR2,
114 X_Character22 VARCHAR2,
115 X_Character23 VARCHAR2,
116 X_Character24 VARCHAR2,
117 X_Character25 VARCHAR2,
118 X_Character26 VARCHAR2,
119 X_Character27 VARCHAR2,
120 X_Character28 VARCHAR2,
121 X_Character29 VARCHAR2,
122 X_Character30 VARCHAR2,
123 X_Character31 VARCHAR2,
124 X_Character32 VARCHAR2,
125 X_Character33 VARCHAR2,
126 X_Character34 VARCHAR2,
127 X_Character35 VARCHAR2,
128 X_Character36 VARCHAR2,
129 X_Character37 VARCHAR2,
130 X_Character38 VARCHAR2,
131 X_Character39 VARCHAR2,
132 X_Character40 VARCHAR2,
133 X_Character41 VARCHAR2,
134 X_Character42 VARCHAR2,
135 X_Character43 VARCHAR2,
136 X_Character44 VARCHAR2,
137 X_Character45 VARCHAR2,
138 X_Character46 VARCHAR2,
139 X_Character47 VARCHAR2,
140 X_Character48 VARCHAR2,
141 X_Character49 VARCHAR2,
142 X_Character50 VARCHAR2,
143 X_Character51 VARCHAR2,
144 X_Character52 VARCHAR2,
145 X_Character53 VARCHAR2,
146 X_Character54 VARCHAR2,
147 X_Character55 VARCHAR2,
148 X_Character56 VARCHAR2,
149 X_Character57 VARCHAR2,
150 X_Character58 VARCHAR2,
151 X_Character59 VARCHAR2,
152 X_Character60 VARCHAR2,
153 X_Character61 VARCHAR2,
154 X_Character62 VARCHAR2,
155 X_Character63 VARCHAR2,
156 X_Character64 VARCHAR2,
157 X_Character65 VARCHAR2,
158 X_Character66 VARCHAR2,
159 X_Character67 VARCHAR2,
160 X_Character68 VARCHAR2,
161 X_Character69 VARCHAR2,
162 X_Character70 VARCHAR2,
163 X_Character71 VARCHAR2,
164 X_Character72 VARCHAR2,
165 X_Character73 VARCHAR2,
166 X_Character74 VARCHAR2,
167 X_Character75 VARCHAR2,
168 X_Character76 VARCHAR2,
169 X_Character77 VARCHAR2,
170 X_Character78 VARCHAR2,
171 X_Character79 VARCHAR2,
172 X_Character80 VARCHAR2,
173 X_Character81 VARCHAR2,
174 X_Character82 VARCHAR2,
175 X_Character83 VARCHAR2,
176 X_Character84 VARCHAR2,
177 X_Character85 VARCHAR2,
178 X_Character86 VARCHAR2,
179 X_Character87 VARCHAR2,
180 X_Character88 VARCHAR2,
181 X_Character89 VARCHAR2,
182 X_Character90 VARCHAR2,
183 X_Character91 VARCHAR2,
184 X_Character92 VARCHAR2,
185 X_Character93 VARCHAR2,
186 X_Character94 VARCHAR2,
187 X_Character95 VARCHAR2,
188 X_Character96 VARCHAR2,
189 X_Character97 VARCHAR2,
190 X_Character98 VARCHAR2,
191 X_Character99 VARCHAR2,
192 X_Character100 VARCHAR2,
193 X_Sequence1 VARCHAR2,
194 X_Sequence2 VARCHAR2,
195 X_Sequence3 VARCHAR2,
196 X_Sequence4 VARCHAR2,
197 X_Sequence5 VARCHAR2,
198 X_Sequence6 VARCHAR2,
199 X_Sequence7 VARCHAR2,
200 X_Sequence8 VARCHAR2,
201 X_Sequence9 VARCHAR2,
202 X_Sequence10 VARCHAR2,
203 X_Sequence11 VARCHAR2,
204 X_Sequence12 VARCHAR2,
205 X_Sequence13 VARCHAR2,
206 X_Sequence14 VARCHAR2,
207 X_Sequence15 VARCHAR2,
208 X_Comment1 VARCHAR2,
209 X_Comment2 VARCHAR2,
210 X_Comment3 VARCHAR2,
211 X_Comment4 VARCHAR2,
212 X_Comment5 VARCHAR2,
213 X_Party_Id NUMBER,
214 X_Csi_Instance_Id NUMBER,
215 X_Counter_Id NUMBER,
216 X_Counter_Reading_Id NUMBER,
217 X_Ahl_Mr_Id NUMBER,
218 X_Cs_Incident_Id NUMBER,
222 X_Disposition_Action VARCHAR2,
219 X_Wip_Rework_Id NUMBER,
220 X_Disposition_Source VARCHAR2,
221 X_Disposition VARCHAR2,
223 X_Disposition_Status VARCHAR2,
224 X_Mti_Transaction_Header_Id NUMBER,
225 X_Mti_Transaction_Interface_Id NUMBER,
229 X_Wmt_Transaction_Id NUMBER,
226 X_Mmt_Transaction_Id NUMBER,
227 X_Wjsi_Group_Id NUMBER,
228 X_Wmti_Group_Id NUMBER,
230 X_Rti_Interface_Transaction_Id NUMBER,
231 X_Maintenance_Op_Seq NUMBER,
232 X_Bill_Reference_Id NUMBER,
233 X_Routing_Reference_Id NUMBER,
234 X_To_Subinventory VARCHAR2,
235 X_To_Locator_Id NUMBER,
236 X_Concurrent_Request_Id NUMBER,
237 X_Lot_Status_Id NUMBER,
238 X_Serial_Status_Id NUMBER,
239 X_Nonconformance_Source VARCHAR2,
240 X_Nonconform_Severity VARCHAR2,
241 X_Nonconform_Priority VARCHAR2,
242 X_Nonconformance_Type VARCHAR2,
243 X_Nonconformance_Code VARCHAR2,
244 X_Nonconformance_Status VARCHAR2,
245 X_Date_Opened DATE,
246 X_Date_Closed DATE,
247 X_Days_To_Close NUMBER,
248 X_Rcv_Transaction_Id NUMBER,
249 X_Request_Source VARCHAR2,
250 X_Request_Priority VARCHAR2,
251 X_Request_Severity VARCHAR2,
252 X_Request_Status VARCHAR2,
253 X_Eco_Name VARCHAR2,
254 /* R12 DR Integration. Bug 4345489 Start */
255 X_REPAIR_LINE_ID NUMBER,
256 X_JTF_TASK_ID NUMBER,
257 /* R12 DR Integration. Bug 4345489 End*/
258
259 -- R12 OPM Deviations. Bug 4345503 Start
260 X_PROCESS_BATCH_ID NUMBER,
261 X_PROCESS_BATCHSTEP_ID NUMBER,
262 X_PROCESS_OPERATION_ID NUMBER,
263 X_PROCESS_ACTIVITY_ID NUMBER,
264 X_PROCESS_RESOURCE_ID NUMBER,
265 X_PROCESS_PARAMETER_ID NUMBER
266 -- R12 OPM Deviations. Bug 4345503 End
267
268
269 ) IS
270 CURSOR C IS SELECT rowid FROM QA_RESULTS
271 WHERE plan_id = x_plan_id
272 AND collection_id = X_Collection_Id
273 and occurrence = X_Occurrence;
274 CURSOR C2 IS SELECT qa_occurrence_s.nextval FROM dual;
275 BEGIN
276 if (X_Occurrence is NULL) then
277 OPEN C2;
278 FETCH C2 INTO X_Occurrence;
279 CLOSE C2;
280 end if;
281
282 -- Modified the signature to include new hardcoded element followup activity, transfer license plate number
283 -- saugupta
284
285 INSERT INTO QA_RESULTS(
286 collection_id,
287 occurrence,
288 last_update_date,
289 qa_last_update_date,
290 last_updated_by,
291 qa_last_updated_by,
292 creation_date,
293 qa_creation_date,
294 created_by,
295 qa_created_by,
296 last_update_login,
297 transaction_number,
298 txn_header_id,
299 organization_id,
300 plan_id,
301 spec_id,
302 transaction_id,
303 department_id,
304 to_department_id,
305 resource_id,
306 quantity,
307 item_id,
308 uom,
309 revision,
310 subinventory,
311 locator_id,
312 lot_number,
313 serial_number,
314 comp_item_id,
315 comp_uom,
316 comp_revision,
317 comp_subinventory,
318 comp_locator_id,
319 comp_lot_number,
320 comp_serial_number,
324 from_op_seq_num,
321 wip_entity_id,
322 line_id,
323 to_op_seq_num,
325 vendor_id,
326 receipt_num,
327 po_header_id,
328 po_line_num,
329 po_release_id,
330 po_shipment_num,
331 customer_id,
332 so_header_id,
333 rma_header_id,
334 transaction_date,
335 status ,
336 Project_Id,
337 Task_Id,
338 LPN_ID,
339 XFR_LPN_ID,
340 Contract_ID,
341 Contract_Line_ID,
342 Deliverable_ID,
343 Asset_Group_ID,
344 Asset_Number,
345 Asset_Instance_ID, --dgupta: R12 EAM Integration. Bug 4345492
346 Asset_Activity_ID,
347 Followup_Activity_ID,
348 Work_order_ID,
349 character1,
350 character2,
351 character3,
352 character4,
353 character5,
354 character6,
355 character7,
356 character8,
357 character9,
358 character10,
359 character11,
360 character12,
361 character13,
362 character14,
363 character15,
364 character16,
365 character17,
366 character18,
367 character19,
368 character20,
369 character21,
370 character22,
371 character23,
372 character24,
373 character25,
374 character26,
375 character27,
376 character28,
377 character29,
378 character30,
379 character31,
380 character32,
381 character33,
382 character34,
383 character35,
384 character36,
385 character37,
386 character38,
387 character39,
388 character40,
389 character41,
390 character42,
391 character43,
392 character44,
393 character45,
394 character46,
395 character47,
396 character48,
397 character49,
398 character50,
399 character51,
400 character52,
401 character53,
402 character54,
403 character55,
404 character56,
405 character57,
406 character58,
407 character59,
408 character60,
409 character61,
410 character62,
411 character63,
412 character64,
413 character65,
414 character66,
415 character67,
416 character68,
417 character69,
418 character70,
419 character71,
420 character72,
421 character73,
422 character74,
423 character75,
424 character76,
425 character77,
426 character78,
427 character79,
428 character80,
429 character81,
430 character82,
431 character83,
432 character84,
433 character85,
434 character86,
435 character87,
436 character88,
437 character89,
438 character90,
439 character91,
440 character92,
441 character93,
442 character94,
443 character95,
444 character96,
445 character97,
446 character98,
447 character99,
448 character100,
449 sequence1,
450 sequence2,
451 sequence3,
452 sequence4,
453 sequence5,
454 sequence6,
455 sequence7,
456 sequence8,
457 sequence9,
458 sequence10,
459 sequence11,
460 sequence12,
461 sequence13,
462 sequence14,
463 sequence15,
464 comment1,
465 comment2,
466 comment3,
467 comment4,
468 comment5,
469 party_id,
470 csi_instance_id,
471 counter_id,
472 counter_reading_id,
473 ahl_mr_id,
474 cs_incident_id,
475 wip_rework_id,
476 disposition_source,
477 disposition,
478 disposition_action,
479 disposition_status,
480 mti_transaction_header_id,
481 mti_transaction_interface_id,
482 mmt_transaction_id,
483 wjsi_group_id,
484 wmti_group_id,
485 wmt_transaction_id,
486 rti_interface_transaction_id,
487 maintenance_op_seq,
488 bill_reference_id,
489 routing_reference_id,
490 to_subinventory,
491 to_locator_id,
492 concurrent_request_id,
493 lot_status_id,
494 serial_status_id,
495 nonconformance_source,
496 nonconform_severity,
497 nonconform_priority,
501 date_opened,
498 nonconformance_type,
499 nonconformance_code,
500 nonconformance_status,
502 date_closed,
503 days_to_close,
504 rcv_transaction_id,
505 request_source,
506 request_priority,
507 request_severity,
508 request_status,
509 eco_name,
510 /* R12 DR Integration. Bug 4345489 Start */
511 repair_line_id,
512 jtf_task_id,
513 /* R12 DR Integration. Bug 4345489 End */
514 -- R12 OPM Deviations. Bug 4345503 Start
515 PROCESS_BATCH_ID,
516 PROCESS_BATCHSTEP_ID,
517 PROCESS_OPERATION_ID,
518 PROCESS_ACTIVITY_ID,
519 PROCESS_RESOURCE_ID,
520 PROCESS_PARAMETER_ID
521 -- R12 OPM Deviations. Bug 4345503 End
522 ) VALUES (
523 X_Collection_Id,
524 X_Occurrence,
525 X_Last_Update_Date,
526 X_Qa_Last_Update_Date,
527 X_Last_Updated_By,
528 X_Qa_Last_Updated_By,
529 X_Creation_Date,
530 X_Qa_Creation_Date,
531 X_Created_By,
532 X_Qa_Created_By,
533 X_Last_Update_Login,
534 X_Transaction_Number,
535 X_Txn_Header_Id,
536 X_Organization_Id,
537 X_Plan_Id,
538 X_Spec_Id,
539 X_Transaction_Id,
540 X_Department_Id,
541 X_To_Department_Id,
542 X_Resource_Id,
543 X_Quantity,
544 X_Item_Id,
545 X_Uom,
546 X_Revision,
547 X_Subinventory,
548 X_Locator_Id,
549 X_Lot_Number,
550 X_Serial_Number,
551 X_Comp_Item_Id,
552 X_Comp_Uom,
553 X_Comp_Revision,
554 X_Comp_Subinventory,
555 X_Comp_Locator_Id,
556 X_Comp_Lot_Number,
557 X_Comp_Serial_Number,
558 X_Wip_Entity_Id,
559 X_Line_Id,
560 X_To_Op_Seq_Num,
561 X_From_Op_Seq_Num,
562 X_Vendor_Id,
563 X_Receipt_Num,
564 X_Po_Header_Id,
565 X_Po_Line_Num,
566 X_Po_Release_Id,
567 X_Po_Shipment_Num,
568 X_Customer_Id,
569 X_So_Header_Id,
570 X_Rma_Header_Id,
571 X_Transaction_Date,
572 X_Status ,
573 X_Project_Id,
574 X_Task_Id ,
575 X_LPN_ID,
576 X_XFR_LPN_ID,
577 X_Contract_ID,
578 X_Contract_Line_ID,
579 X_Deliverable_ID,
580 X_Asset_Group_ID,
581 X_Asset_Number,
582 X_Asset_Instance_ID, --dgupta: R12 EAM Integration. Bug 4345492
583 X_Asset_Activity_ID,
584 X_Followup_Activity_ID,
585 X_Work_Order_ID,
586 X_Character1,
587 X_Character2,
588 X_Character3,
589 X_Character4,
590 X_Character5,
594 X_Character9,
591 X_Character6,
592 X_Character7,
593 X_Character8,
595 X_Character10,
596 X_Character11,
597 X_Character12,
598 X_Character13,
599 X_Character14,
600 X_Character15,
601 X_Character16,
605 X_Character20,
602 X_Character17,
603 X_Character18,
604 X_Character19,
606 X_Character21,
607 X_Character22,
608 X_Character23,
609 X_Character24,
610 X_Character25,
611 X_Character26,
612 X_Character27,
613 X_Character28,
614 X_Character29,
615 X_Character30,
616 X_Character31,
617 X_Character32,
618 X_Character33,
619 X_Character34,
620 X_Character35,
621 X_Character36,
622 X_Character37,
623 X_Character38,
624 X_Character39,
625 X_Character40,
626 X_Character41,
627 X_Character42,
628 X_Character43,
629 X_Character44,
630 X_Character45,
631 X_Character46,
632 X_Character47,
633 X_Character48,
634 X_Character49,
635 X_Character50,
636 X_Character51,
637 X_Character52,
638 X_Character53,
639 X_Character54,
640 X_Character55,
641 X_Character56,
642 X_Character57,
643 X_Character58,
644 X_Character59,
645 X_Character60,
646 X_Character61,
647 X_Character62,
648 X_Character63,
649 X_Character64,
650 X_Character65,
651 X_Character66,
652 X_Character67,
653 X_Character68,
654 X_Character69,
655 X_Character70,
656 X_Character71,
657 X_Character72,
658 X_Character73,
659 X_Character74,
660 X_Character75,
661 X_Character76,
662 X_Character77,
663 X_Character78,
664 X_Character79,
665 X_Character80,
666 X_Character81,
667 X_Character82,
668 X_Character83,
669 X_Character84,
670 X_Character85,
671 X_Character86,
672 X_Character87,
673 X_Character88,
674 X_Character89,
675 X_Character90,
676 X_Character91,
677 X_Character92,
678 X_Character93,
679 X_Character94,
680 X_Character95,
681 X_Character96,
682 X_Character97,
683 X_Character98,
684 X_Character99,
685 X_Character100,
686 X_Sequence1,
687 X_Sequence2,
688 X_Sequence3,
689 X_Sequence4,
690 X_Sequence5,
691 X_Sequence6,
692 X_Sequence7,
693 X_Sequence8,
694 X_Sequence9,
695 X_Sequence10,
696 X_Sequence11,
697 X_Sequence12,
698 X_Sequence13,
699 X_Sequence14,
700 X_Sequence15,
701 X_Comment1,
702 X_Comment2,
703 X_Comment3,
704 X_Comment4,
705 X_Comment5,
706 X_Party_Id,
707 X_Csi_Instance_Id,
708 X_Counter_Id,
709 X_Counter_Reading_Id,
710 X_Ahl_Mr_Id,
711 X_Cs_Incident_Id,
712 X_Wip_Rework_Id,
713 X_Disposition_Source,
714 X_Disposition,
715 X_Disposition_Action,
716 X_Disposition_Status,
717 X_Mti_Transaction_Header_Id,
718 X_Mti_Transaction_Interface_Id,
719 X_Mmt_Transaction_Id,
720 X_Wjsi_Group_Id,
721 X_Wmti_Group_Id,
722 X_Wmt_Transaction_Id,
723 X_Rti_Interface_Transaction_Id,
724 X_Maintenance_Op_Seq,
725 X_Bill_Reference_Id,
726 X_Routing_Reference_Id,
727 X_To_Subinventory,
728 X_To_Locator_Id,
729 X_Concurrent_Request_Id,
730 X_Lot_Status_Id,
731 X_Serial_Status_Id,
732 X_Nonconformance_Source,
733 X_Nonconform_Severity,
734 X_Nonconform_Priority,
735 X_Nonconformance_Type,
736 X_Nonconformance_Code,
737 X_Nonconformance_Status,
738 X_Date_Opened,
739 X_Date_Closed,
740 X_Days_To_Close,
741 X_Rcv_Transaction_Id,
742 X_Request_Source,
743 X_Request_Priority,
744 X_Request_Severity,
745 X_Request_Status,
746 X_Eco_Name,
747 /* R12 DR Integration. Bug 4345489 Start */
748 X_REPAIR_LINE_ID,
749 X_JTF_TASK_ID,
750 /* R12 DR Integration. Bug 4345489 End */
751 -- R12 OPM Deviations. Bug 4345503 Start
752 X_PROCESS_BATCH_ID,
753 X_PROCESS_BATCHSTEP_ID,
754 X_PROCESS_OPERATION_ID,
755 X_PROCESS_ACTIVITY_ID,
756 X_PROCESS_RESOURCE_ID,
757 X_PROCESS_PARAMETER_ID
758 -- R12 OPM Deviations. Bug 4345503 End
759 );
760
761 OPEN C;
762 FETCH C INTO X_Rowid;
763 if (C%NOTFOUND) then
764 CLOSE C;
765 Raise NO_DATA_FOUND;
769
766 end if;
767 CLOSE C;
768 END Insert_Row;
770 --
771 -- Modified the proc signature and implementation
772 -- to include the database columns added for ASO support.
773 -- rkunchal Thu Jul 25 01:43:48 PDT 2002
774 --
775 --
776 -- See Bug 2588213
777 -- To support the element Maintenance Op Seq Number
778 -- to be used along with Maintenance Workorder
779 -- rkunchal Mon Sep 23 23:46:28 PDT 2002
780 --
781
782 -- Modified the signature to include NCM Hardcode Elements.
783 -- suramasw Thu Oct 31 10:48:59 PST 2002.
784 -- Bug 2449067.
785
789 -- modified the signature for new hardcoded elements followup_activity, transfer license plate number
786 -- Modified the signature to include CAR Hardcode Elements.
787 -- anagarwa Thu Nov 14 13:03:35 PST 2002
788
790 -- saugupta
791
792 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
793 X_Collection_Id NUMBER,
794 X_Occurrence NUMBER,
795 X_Qa_Last_Update_Date DATE,
796 X_Qa_Last_Updated_By NUMBER,
797 X_Qa_Creation_Date DATE,
798 X_Qa_Created_By NUMBER,
799 X_Transaction_Number NUMBER,
800 X_Txn_Header_Id NUMBER,
801 X_Organization_Id NUMBER,
802 X_Plan_Id NUMBER,
803 X_Spec_Id NUMBER,
804 X_Transaction_Id NUMBER,
805 X_Department_Id NUMBER,
806 X_To_Department_Id NUMBER,
807 X_Resource_Id NUMBER,
808 X_Quantity NUMBER,
809 X_Item_Id NUMBER,
810 X_Uom VARCHAR2,
811 X_Revision VARCHAR2,
812 X_Subinventory VARCHAR2,
813 X_Locator_Id NUMBER,
814 X_Lot_Number VARCHAR2,
815 X_Serial_Number VARCHAR2,
816 X_Comp_Item_Id NUMBER,
817 X_Comp_Uom VARCHAR2,
818 X_Comp_Revision VARCHAR2,
819 X_Comp_Subinventory VARCHAR2,
820 X_Comp_Locator_Id NUMBER,
821 X_Comp_Lot_Number VARCHAR2,
822 X_Comp_Serial_Number VARCHAR2,
823 X_Wip_Entity_Id NUMBER,
824 X_Line_Id NUMBER,
825 X_To_Op_Seq_Num NUMBER,
826 X_From_Op_Seq_Num NUMBER,
827 X_Vendor_Id NUMBER,
828 X_Receipt_Num VARCHAR2,
829 X_Po_Header_Id NUMBER,
830 -- bug 9652549 CLM changes
831 X_Po_Line_Num VARCHAR2,
832 X_Po_Release_Id NUMBER,
833 X_Po_Shipment_Num NUMBER,
834 X_Customer_Id NUMBER,
835 X_So_Header_Id NUMBER,
836 X_Rma_Header_Id NUMBER,
837 X_Transaction_Date DATE,
838 X_Status VARCHAR2,
839 X_Project_Id NUMBER ,
840 X_Task_Id NUMBER ,
841 X_LPN_ID NUMBER,
842 X_XFR_LPN_ID NUMBER,
843 X_Contract_ID Number,
844 X_Contract_Line_ID Number,
845 X_Deliverable_ID Number,
846 X_Asset_Group_ID NUMBER,
847 X_Asset_Number VARCHAR2,
848 X_Asset_Instance_ID NUMBER, --dgupta: R12 EAM Integration. Bug 4345492
849 X_Asset_Activity_ID NUMBER,
850 X_Followup_Activity_ID NUMBER,
851 X_Work_Order_ID NUMBER,
852 X_Character1 VARCHAR2,
853 X_Character2 VARCHAR2,
854 X_Character3 VARCHAR2,
855 X_Character4 VARCHAR2,
856 X_Character5 VARCHAR2,
860 X_Character9 VARCHAR2,
857 X_Character6 VARCHAR2,
858 X_Character7 VARCHAR2,
859 X_Character8 VARCHAR2,
861 X_Character10 VARCHAR2,
862 X_Character11 VARCHAR2,
863 X_Character12 VARCHAR2,
864 X_Character13 VARCHAR2,
865 X_Character14 VARCHAR2,
866 X_Character15 VARCHAR2,
867 X_Character16 VARCHAR2,
868 X_Character17 VARCHAR2,
869 X_Character18 VARCHAR2,
870 X_Character19 VARCHAR2,
871 X_Character20 VARCHAR2,
872 X_Character21 VARCHAR2,
873 X_Character22 VARCHAR2,
874 X_Character23 VARCHAR2,
875 X_Character24 VARCHAR2,
876 X_Character25 VARCHAR2,
877 X_Character26 VARCHAR2,
878 X_Character27 VARCHAR2,
879 X_Character28 VARCHAR2,
880 X_Character29 VARCHAR2,
881 X_Character30 VARCHAR2,
882 X_Character31 VARCHAR2,
883 X_Character32 VARCHAR2,
884 X_Character33 VARCHAR2,
885 X_Character34 VARCHAR2,
886 X_Character35 VARCHAR2,
887 X_Character36 VARCHAR2,
888 X_Character37 VARCHAR2,
889 X_Character38 VARCHAR2,
890 X_Character39 VARCHAR2,
891 X_Character40 VARCHAR2,
892 X_Character41 VARCHAR2,
893 X_Character42 VARCHAR2,
894 X_Character43 VARCHAR2,
895 X_Character44 VARCHAR2,
899 X_Character48 VARCHAR2,
896 X_Character45 VARCHAR2,
897 X_Character46 VARCHAR2,
898 X_Character47 VARCHAR2,
900 X_Character49 VARCHAR2,
901 X_Character50 VARCHAR2,
902 X_Character51 VARCHAR2,
903 X_Character52 VARCHAR2,
904 X_Character53 VARCHAR2,
908 X_Character57 VARCHAR2,
905 X_Character54 VARCHAR2,
906 X_Character55 VARCHAR2,
907 X_Character56 VARCHAR2,
909 X_Character58 VARCHAR2,
910 X_Character59 VARCHAR2,
911 X_Character60 VARCHAR2,
912 X_Character61 VARCHAR2,
913 X_Character62 VARCHAR2,
914 X_Character63 VARCHAR2,
915 X_Character64 VARCHAR2,
916 X_Character65 VARCHAR2,
917 X_Character66 VARCHAR2,
918 X_Character67 VARCHAR2,
919 X_Character68 VARCHAR2,
920 X_Character69 VARCHAR2,
921 X_Character70 VARCHAR2,
922 X_Character71 VARCHAR2,
923 X_Character72 VARCHAR2,
924 X_Character73 VARCHAR2,
925 X_Character74 VARCHAR2,
926 X_Character75 VARCHAR2,
927 X_Character76 VARCHAR2,
928 X_Character77 VARCHAR2,
929 X_Character78 VARCHAR2,
930 X_Character79 VARCHAR2,
931 X_Character80 VARCHAR2,
932 X_Character81 VARCHAR2,
933 X_Character82 VARCHAR2,
934 X_Character83 VARCHAR2,
935 X_Character84 VARCHAR2,
936 X_Character85 VARCHAR2,
937 X_Character86 VARCHAR2,
938 X_Character87 VARCHAR2,
939 X_Character88 VARCHAR2,
940 X_Character89 VARCHAR2,
941 X_Character90 VARCHAR2,
942 X_Character91 VARCHAR2,
943 X_Character92 VARCHAR2,
944 X_Character93 VARCHAR2,
945 X_Character94 VARCHAR2,
946 X_Character95 VARCHAR2,
947 X_Character96 VARCHAR2,
948 X_Character97 VARCHAR2,
949 X_Character98 VARCHAR2,
950 X_Character99 VARCHAR2,
951 X_Character100 VARCHAR2,
952 X_Sequence1 VARCHAR2,
953 X_Sequence2 VARCHAR2,
954 X_Sequence3 VARCHAR2,
955 X_Sequence4 VARCHAR2,
956 X_Sequence5 VARCHAR2,
957 X_Sequence6 VARCHAR2,
958 X_Sequence7 VARCHAR2,
959 X_Sequence8 VARCHAR2,
960 X_Sequence9 VARCHAR2,
961 X_Sequence10 VARCHAR2,
962 X_Sequence11 VARCHAR2,
963 X_Sequence12 VARCHAR2,
964 X_Sequence13 VARCHAR2,
965 X_Sequence14 VARCHAR2,
966 X_Sequence15 VARCHAR2,
967 X_Comment1 VARCHAR2,
968 X_Comment2 VARCHAR2,
969 X_Comment3 VARCHAR2,
970 X_Comment4 VARCHAR2,
971 X_Comment5 VARCHAR2,
972 X_Party_Id NUMBER,
973 X_Csi_Instance_Id NUMBER,
974 X_Counter_Id NUMBER,
975 X_Counter_Reading_Id NUMBER,
976 X_Ahl_Mr_Id NUMBER,
977 X_Cs_Incident_Id NUMBER,
978 X_Wip_Rework_Id NUMBER,
979 X_Disposition_Source VARCHAR2,
980 X_Disposition VARCHAR2,
981 X_Disposition_Action VARCHAR2,
982 X_Disposition_Status VARCHAR2,
983 X_Mti_Transaction_Header_Id NUMBER,
984 X_Mti_Transaction_Interface_Id NUMBER,
985 X_Mmt_Transaction_Id NUMBER,
986 X_Wjsi_Group_Id NUMBER,
987 X_Wmti_Group_Id NUMBER,
988 X_Wmt_Transaction_Id NUMBER,
989 X_Rti_Interface_Transaction_Id NUMBER,
990 X_Maintenance_Op_Seq NUMBER,
991 X_Bill_Reference_Id NUMBER,
992 X_Routing_Reference_Id NUMBER,
993 X_To_Subinventory VARCHAR2,
994 X_To_Locator_Id NUMBER,
998 X_Nonconformance_Source VARCHAR2,
995 X_Concurrent_Request_Id NUMBER,
996 X_Lot_Status_Id NUMBER,
997 X_Serial_Status_Id NUMBER,
999 X_Nonconform_Severity VARCHAR2,
1000 X_Nonconform_Priority VARCHAR2,
1001 X_Nonconformance_Type VARCHAR2,
1002 X_Nonconformance_Code VARCHAR2,
1003 X_Nonconformance_Status VARCHAR2,
1004 X_Date_Opened DATE,
1005 X_Date_Closed DATE,
1006 X_Days_To_Close NUMBER,
1007 X_Rcv_Transaction_Id NUMBER,
1008 X_Request_Source VARCHAR2,
1009 X_Request_Priority VARCHAR2,
1010 X_Request_Severity VARCHAR2,
1011 X_Request_Status VARCHAR2,
1012 X_Eco_Name VARCHAR2,
1013 /* R12 DR Integration. Bug 4345489 Start */
1014 X_REPAIR_LINE_ID NUMBER,
1015 X_JTF_TASK_ID NUMBER,
1016 /* R12 DR Integration. Bug 4345489 End */
1017 -- R12 OPM Deviations. Bug 4345503 Start
1018 X_PROCESS_BATCH_ID NUMBER,
1019 X_PROCESS_BATCHSTEP_ID NUMBER,
1020 X_PROCESS_OPERATION_ID NUMBER,
1021 X_PROCESS_ACTIVITY_ID NUMBER,
1022 X_PROCESS_RESOURCE_ID NUMBER,
1023 X_PROCESS_PARAMETER_ID NUMBER
1024 -- R12 OPM Deviations. Bug 4345503 End
1025 ) IS
1026 CURSOR C IS
1027 SELECT *
1028 FROM QA_RESULTS
1029 WHERE rowid = X_Rowid
1030 FOR UPDATE of Occurrence NOWAIT;
1031 Recinfo C%ROWTYPE;
1032
1033
1034 BEGIN
1035 OPEN C;
1036 FETCH C INTO Recinfo;
1037 if (C%NOTFOUND) then
1038 CLOSE C;
1039 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1040 APP_EXCEPTION.Raise_Exception;
1041 end if;
1042 CLOSE C;
1043 if (
1044
1045 (Recinfo.collection_id = X_Collection_Id)
1046 AND (Recinfo.occurrence = X_Occurrence)
1047 AND (Recinfo.qa_last_update_date = X_Qa_Last_Update_Date)
1048 AND (Recinfo.qa_last_updated_by = X_Qa_Last_Updated_By)
1049 AND (Recinfo.qa_creation_date = X_Qa_Creation_Date)
1050 AND (Recinfo.qa_created_by = X_Qa_Created_By)
1051 AND ( (Recinfo.transaction_number = X_Transaction_Number)
1052 OR ( (Recinfo.transaction_number IS NULL)
1053 AND (X_Transaction_Number IS NULL)))
1054 AND ( (Recinfo.txn_header_id = X_Txn_Header_Id)
1055 OR ( (Recinfo.txn_header_id IS NULL)
1056 AND (X_Txn_Header_Id IS NULL)))
1057 AND (Recinfo.organization_id = X_Organization_Id)
1058 AND (Recinfo.plan_id = X_Plan_Id)
1059 AND ( (Recinfo.spec_id = X_Spec_Id)
1060 OR ( (Recinfo.spec_id IS NULL)
1061 AND (X_Spec_Id IS NULL)))
1062 AND ( (Recinfo.transaction_id = X_Transaction_Id)
1063 OR ( (Recinfo.transaction_id IS NULL)
1064 AND (X_Transaction_Id IS NULL)))
1065 AND ( (Recinfo.department_id = X_Department_Id)
1066 OR ( (Recinfo.department_id IS NULL)
1067 AND (X_Department_Id IS NULL)))
1068 AND ( (Recinfo.to_department_id = X_To_Department_Id)
1069 OR ( (Recinfo.to_department_id IS NULL)
1070 AND (X_To_Department_Id IS NULL)))
1071 AND ( (Recinfo.resource_id = X_Resource_Id)
1072 OR ( (Recinfo.resource_id IS NULL)
1073 AND (X_Resource_Id IS NULL)))
1074 AND ( (Recinfo.quantity = X_Quantity)
1075 OR ( (Recinfo.quantity IS NULL)
1076 AND (X_Quantity IS NULL)))
1077 AND ( (Recinfo.item_id = X_Item_Id)
1078 OR ( (Recinfo.item_id IS NULL)
1079 AND (X_Item_Id IS NULL)))
1080 AND ( (Recinfo.uom = X_Uom)
1081 OR ( (Recinfo.uom IS NULL)
1082 AND (X_Uom IS NULL)))
1083 AND ( (Recinfo.revision = X_Revision)
1084 OR ( (Recinfo.revision IS NULL)
1085 AND (X_Revision IS NULL)))
1086 AND ( (Recinfo.subinventory = X_Subinventory)
1087 OR ( (Recinfo.subinventory IS NULL)
1088 AND (X_Subinventory IS NULL)))
1089 AND ( (Recinfo.locator_id = X_Locator_Id)
1090 OR ( (Recinfo.locator_id IS NULL)
1091 AND (X_Locator_Id IS NULL)))
1092 AND ( (Recinfo.lot_number = X_Lot_Number)
1093 OR ( (Recinfo.lot_number IS NULL)
1094 AND (X_Lot_Number IS NULL)))
1095 AND ( (Recinfo.serial_number = X_Serial_Number)
1096 OR ( (Recinfo.serial_number IS NULL)
1097 AND (X_Serial_Number IS NULL)))
1098 AND ( (Recinfo.comp_item_id = X_Comp_Item_Id)
1099 OR ( (Recinfo.comp_item_id IS NULL)
1100 AND (X_Comp_Item_Id IS NULL)))
1101 AND ( (Recinfo.comp_uom = X_Comp_Uom)
1102 OR ( (Recinfo.comp_uom IS NULL)
1103 AND (X_Comp_Uom IS NULL)))
1104 AND ( (Recinfo.comp_revision = X_Comp_Revision)
1105 OR ( (Recinfo.comp_revision IS NULL)
1109 AND (X_Comp_Subinventory IS NULL)))
1106 AND (X_Comp_Revision IS NULL)))
1107 AND ( (Recinfo.comp_subinventory = X_Comp_Subinventory)
1108 OR ( (Recinfo.comp_subinventory IS NULL)
1110 AND ( (Recinfo.comp_locator_id = X_Comp_Locator_Id)
1111 OR ( (Recinfo.comp_locator_id IS NULL)
1112 AND (X_Comp_Locator_Id IS NULL)))
1113 AND ( (Recinfo.comp_lot_number = X_Comp_Lot_Number)
1114 OR ( (Recinfo.comp_lot_number IS NULL)
1115 AND (X_Comp_Lot_Number IS NULL)))
1116 AND ( (Recinfo.comp_serial_number = X_Comp_Serial_Number)
1117 OR ( (Recinfo.comp_serial_number IS NULL)
1118 AND (X_Comp_Serial_Number IS NULL)))
1119 AND ( (Recinfo.wip_entity_id = X_Wip_Entity_Id)
1120 OR ( (Recinfo.wip_entity_id IS NULL)
1121 AND (X_Wip_Entity_Id IS NULL)))
1122 AND ( (Recinfo.line_id = X_Line_Id)
1123 OR ( (Recinfo.line_id IS NULL)
1124 AND (X_Line_Id IS NULL)))
1125 AND ( (Recinfo.to_op_seq_num = X_To_Op_Seq_Num)
1126 OR ( (Recinfo.to_op_seq_num IS NULL)
1127 AND (X_To_Op_Seq_Num IS NULL)))
1128 AND ( (Recinfo.from_op_seq_num = X_From_Op_Seq_Num)
1129 OR ( (Recinfo.from_op_seq_num IS NULL)
1130 AND (X_From_Op_Seq_Num IS NULL)))
1131 AND ( (Recinfo.vendor_id = X_Vendor_Id)
1132 OR ( (Recinfo.vendor_id IS NULL)
1133 AND (X_Vendor_Id IS NULL)))
1134 AND ( (Recinfo.receipt_num = X_Receipt_Num)
1135 OR ( (Recinfo.receipt_num IS NULL)
1136 AND (X_Receipt_Num IS NULL)))
1137 AND ( (Recinfo.po_header_id = X_Po_Header_Id)
1138 OR ( (Recinfo.po_header_id IS NULL)
1139 AND (X_Po_Header_Id IS NULL)))
1140 AND ( (Recinfo.po_line_num = X_Po_Line_Num)
1141 OR ( (Recinfo.po_line_num IS NULL)
1142 AND (X_Po_Line_Num IS NULL)))
1143 AND ( (Recinfo.po_release_id = X_Po_Release_Id)
1144 OR ( (Recinfo.po_release_id IS NULL)
1145 AND (X_Po_Release_Id IS NULL)))
1146 AND ( (Recinfo.po_shipment_num = X_Po_Shipment_Num)
1147 OR ( (Recinfo.po_shipment_num IS NULL)
1148 AND (X_Po_Shipment_Num IS NULL)))
1149 AND ( (Recinfo.customer_id = X_Customer_Id)
1150 OR ( (Recinfo.customer_id IS NULL)
1151 AND (X_Customer_Id IS NULL)))
1152 AND ( (Recinfo.so_header_id = X_So_Header_Id)
1153 OR ( (Recinfo.so_header_id IS NULL)
1154 AND (X_So_Header_Id IS NULL)))
1155 AND ( (Recinfo.rma_header_id = X_Rma_Header_Id)
1156 OR ( (Recinfo.rma_header_id IS NULL)
1157 AND (X_Rma_Header_Id IS NULL)))
1158 AND ( (Recinfo.transaction_date = X_Transaction_Date)
1159 OR ( (Recinfo.transaction_date IS NULL)
1160 AND (X_Transaction_Date IS NULL)))
1161 AND ( (Recinfo.status = X_Status )
1162 OR ( (Recinfo.status IS NULL)
1163 AND ( X_Status IS NULL)))
1164 AND ( (Recinfo.Project_Id = X_Project_Id )
1165 OR ( (Recinfo.Project_Id IS NULL)
1166 AND ( X_Project_Id IS NULL)))
1167 AND ( (Recinfo.Task_Id = X_Task_Id )
1168 OR ( (Recinfo.Task_Id IS NULL)
1169 AND ( X_Task_Id IS NULL)))
1170 AND ( (Recinfo.LPN_ID = X_LPN_ID )
1171 OR ( (Recinfo.LPN_ID IS NULL)
1172 AND ( X_LPN_ID IS NULL)))
1173 AND ( (Recinfo.XFR_LPN_ID = X_XFR_LPN_ID )
1174 OR ( (Recinfo.XFR_LPN_ID IS NULL)
1175 AND ( X_XFR_LPN_ID IS NULL)))
1176 AND ( (Recinfo.Contract_ID = X_Contract_ID )
1177 OR ( (Recinfo.Contract_ID IS NULL)
1178 AND ( X_Contract_ID IS NULL)))
1179 AND ( (Recinfo.Contract_Line_ID = X_Contract_Line_ID )
1180 OR ( (Recinfo.Contract_Line_ID IS NULL)
1181 AND ( X_Contract_Line_ID IS NULL)))
1182 AND ( (Recinfo.Deliverable_ID = X_Deliverable_ID )
1183 OR ( (Recinfo.Deliverable_ID IS NULL)
1184 AND ( X_Deliverable_ID IS NULL)))
1185 AND ( (Recinfo.Asset_Group_ID = X_Asset_Group_ID )
1186 OR ( (Recinfo.Asset_Group_ID IS NULL)
1187 AND ( X_Asset_Group_ID IS NULL)))
1188 AND ( (Recinfo.Asset_Number = X_Asset_Number )
1189 OR ( (Recinfo.Asset_Number IS NULL)
1190 AND ( X_Asset_Number IS NULL)))
1191 --dgupta: Start R12 EAM Integration. Bug 4345492
1192 AND ( (Recinfo.Asset_Instance_ID = X_Asset_Instance_ID )
1193 OR ( (Recinfo.Asset_Instance_ID IS NULL)
1194 AND ( X_Asset_Instance_ID IS NULL)))
1195 --dgupta: End R12 EAM Integration. Bug 4345492
1196 AND ( (Recinfo.Asset_Activity_ID = X_Asset_Activity_ID )
1197 OR ( (Recinfo.Asset_Activity_ID IS NULL)
1198 AND ( X_Asset_Activity_ID IS NULL)))
1199 AND ( (Recinfo.Followup_Activity_ID = X_Followup_Activity_ID )
1200 OR ( (Recinfo.Followup_Activity_ID IS NULL)
1201 AND ( X_Followup_Activity_ID IS NULL)))
1202 AND ( (Recinfo.Work_Order_ID = X_Work_Order_ID )
1203 OR ( (Recinfo.Work_Order_ID IS NULL)
1204 AND ( X_Work_Order_ID IS NULL)))
1205
1206 /* R12 DR Integration. Bug 4345489 Start */
1207 AND ( (Recinfo.Repair_line_ID = X_REPAIR_LINE_ID )
1211 OR ( (Recinfo.Jtf_Task_ID IS NULL)
1208 OR ( (Recinfo.Repair_line_ID IS NULL)
1209 AND ( X_Repair_Line_ID IS NULL)))
1210 AND ( (Recinfo.Jtf_task_ID = X_JTF_TASK_ID )
1212 AND ( X_Jtf_Task_ID IS NULL)))
1213 /* R12 DR Integration. Bug 4345489 End */
1214
1215 -- R12 OPM Deviations. Bug 4345503 Start
1216 AND ( (Recinfo.PROCESS_BATCH_ID = X_PROCESS_BATCH_ID)
1217 OR ( (Recinfo.PROCESS_BATCH_ID IS NULL)
1218 AND (X_PROCESS_BATCH_ID IS NULL)))
1219 AND ( (Recinfo.PROCESS_BATCHSTEP_ID = X_PROCESS_BATCHSTEP_ID)
1220 OR ( (Recinfo.PROCESS_BATCHSTEP_ID IS NULL)
1221 AND (X_PROCESS_BATCHSTEP_ID IS NULL)))
1222 AND ( (Recinfo.PROCESS_OPERATION_ID = X_PROCESS_OPERATION_ID)
1223 OR ( (Recinfo.PROCESS_OPERATION_ID IS NULL)
1224 AND (X_PROCESS_OPERATION_ID IS NULL)))
1225 AND ( (Recinfo.PROCESS_ACTIVITY_ID = X_PROCESS_ACTIVITY_ID)
1226 OR ( (Recinfo.PROCESS_ACTIVITY_ID IS NULL)
1227 AND (X_PROCESS_ACTIVITY_ID IS NULL)))
1228 AND ( (Recinfo.PROCESS_RESOURCE_ID = X_PROCESS_RESOURCE_ID)
1229 OR ( (Recinfo.PROCESS_RESOURCE_ID IS NULL)
1230 AND (X_PROCESS_RESOURCE_ID IS NULL)))
1231 AND ( (Recinfo.PROCESS_PARAMETER_ID = X_PROCESS_PARAMETER_ID)
1232 OR ( (Recinfo.PROCESS_PARAMETER_ID IS NULL)
1233 AND (X_PROCESS_PARAMETER_ID IS NULL)))
1234 -- R12 OPM Deviations. Bug 4345503 Start
1235 ) then
1236 null;
1237 else
1238 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1239 APP_EXCEPTION.Raise_Exception;
1240 end if;
1241
1242 if ( ( (Recinfo.character2 = X_Character2)
1243 OR ( (Recinfo.character2 IS NULL)
1244 AND (X_Character2 IS NULL)))
1245 AND ( (Recinfo.character3 = X_Character3)
1246 OR ( (Recinfo.character3 IS NULL)
1247 AND (X_Character3 IS NULL)))
1248 AND ( (Recinfo.character4 = X_Character4)
1249 OR ( (Recinfo.character4 IS NULL)
1250 AND (X_Character4 IS NULL)))
1251 AND ( (Recinfo.character5 = X_Character5)
1252 OR ( (Recinfo.character5 IS NULL)
1253 AND (X_Character5 IS NULL)))
1254 AND ( (Recinfo.character6 = X_Character6)
1255 OR ( (Recinfo.character6 IS NULL)
1256 AND (X_Character6 IS NULL)))
1257 AND ( (Recinfo.character7 = X_Character7)
1258 OR ( (Recinfo.character7 IS NULL)
1259 AND (X_Character7 IS NULL)))
1260 AND ( (Recinfo.character8 = X_Character8)
1261 OR ( (Recinfo.character8 IS NULL)
1262 AND (X_Character8 IS NULL)))
1263 AND ( (Recinfo.character9 = X_Character9)
1264 OR ( (Recinfo.character9 IS NULL)
1265 AND (X_Character9 IS NULL)))
1266 AND ( (Recinfo.character10 = X_Character10)
1267 OR ( (Recinfo.character10 IS NULL)
1268 AND (X_Character10 IS NULL)))
1269 AND ( (Recinfo.character11 = X_Character11)
1270 OR ( (Recinfo.character11 IS NULL)
1271 AND (X_Character11 IS NULL)))
1272 AND ( (Recinfo.character12 = X_Character12)
1273 OR ( (Recinfo.character12 IS NULL)
1274 AND (X_Character12 IS NULL)))
1275 AND ( (Recinfo.character13 = X_Character13)
1276 OR ( (Recinfo.character13 IS NULL)
1277 AND (X_Character13 IS NULL)))
1278 AND ( (Recinfo.character14 = X_Character14)
1279 OR ( (Recinfo.character14 IS NULL)
1280 AND (X_Character14 IS NULL)))
1281 AND ( (Recinfo.character15 = X_Character15)
1282 OR ( (Recinfo.character15 IS NULL)
1283 AND (X_Character15 IS NULL)))
1284 AND ( (Recinfo.character16 = X_Character16)
1285 OR ( (Recinfo.character16 IS NULL)
1286 AND (X_Character16 IS NULL)))
1287 AND ( (Recinfo.character17 = X_Character17)
1288 OR ( (Recinfo.character17 IS NULL)
1289 AND (X_Character17 IS NULL)))
1290 AND ( (Recinfo.character18 = X_Character18)
1291 OR ( (Recinfo.character18 IS NULL)
1292 AND (X_Character18 IS NULL)))
1293 AND ( (Recinfo.character19 = X_Character19)
1294 OR ( (Recinfo.character19 IS NULL)
1295 AND (X_Character19 IS NULL)))
1296 AND ( (Recinfo.character20 = X_Character20)
1297 OR ( (Recinfo.character20 IS NULL)
1298 AND (X_Character20 IS NULL)))
1299 AND ( (Recinfo.character21 = X_Character21)
1300 OR ( (Recinfo.character21 IS NULL)
1301 AND (X_Character21 IS NULL)))
1302 AND ( (Recinfo.character22 = X_Character22)
1303 OR ( (Recinfo.character22 IS NULL)
1304 AND (X_Character22 IS NULL)))
1305 AND ( (Recinfo.character23 = X_Character23)
1306 OR ( (Recinfo.character23 IS NULL)
1307 AND (X_Character23 IS NULL)))
1308 AND ( (Recinfo.character24 = X_Character24)
1309 OR ( (Recinfo.character24 IS NULL)
1310 AND (X_Character24 IS NULL)))
1311 AND ( (Recinfo.character25 = X_Character25)
1312 OR ( (Recinfo.character25 IS NULL)
1313 AND (X_Character25 IS NULL)))
1314 AND ( (Recinfo.character26 = X_Character26)
1315 OR ( (Recinfo.character26 IS NULL)
1316 AND (X_Character26 IS NULL)))
1320 AND ( (Recinfo.character28 = X_Character28)
1317 AND ( (Recinfo.character27 = X_Character27)
1318 OR ( (Recinfo.character27 IS NULL)
1319 AND (X_Character27 IS NULL)))
1321 OR ( (Recinfo.character28 IS NULL)
1322 AND (X_Character28 IS NULL)))
1323 AND ( (Recinfo.character29 = X_Character29)
1324 OR ( (Recinfo.character29 IS NULL)
1325 AND (X_Character29 IS NULL)))
1326 AND ( (Recinfo.character30 = X_Character30)
1327 OR ( (Recinfo.character30 IS NULL)
1328 AND (X_Character30 IS NULL)))
1329 AND ( (Recinfo.character31 = X_Character31)
1330 OR ( (Recinfo.character31 IS NULL)
1331 AND (X_Character31 IS NULL)))
1332 AND ( (Recinfo.character32 = X_Character32)
1333 OR ( (Recinfo.character32 IS NULL)
1334 AND (X_Character32 IS NULL)))
1335 AND ( (Recinfo.character33 = X_Character33)
1336 OR ( (Recinfo.character33 IS NULL)
1337 AND (X_Character33 IS NULL)))
1338 AND ( (Recinfo.character34 = X_Character34)
1339 OR ( (Recinfo.character34 IS NULL)
1340 AND (X_Character34 IS NULL)))
1341 AND ( (Recinfo.character35 = X_Character35)
1342 OR ( (Recinfo.character35 IS NULL)
1343 AND (X_Character35 IS NULL)))
1344 AND ( (Recinfo.character36 = X_Character36)
1345 OR ( (Recinfo.character36 IS NULL)
1346 AND (X_Character36 IS NULL)))
1347 AND ( (Recinfo.character37 = X_Character37)
1348 OR ( (Recinfo.character37 IS NULL)
1349 AND (X_Character37 IS NULL)))
1350 AND ( (Recinfo.character38 = X_Character38)
1351 OR ( (Recinfo.character38 IS NULL)
1352 AND (X_Character38 IS NULL)))
1353 AND ( (Recinfo.character39 = X_Character39)
1354 OR ( (Recinfo.character39 IS NULL)
1355 AND (X_Character39 IS NULL)))
1356 AND ( (Recinfo.character40 = X_Character40)
1357 OR ( (Recinfo.character40 IS NULL)
1358 AND (X_Character40 IS NULL)))
1359 ) then
1360 return;
1361 else
1362 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1363 APP_EXCEPTION.Raise_Exception;
1364 end if;
1365
1366 if ( ( (Recinfo.character41 = X_Character41)
1367 OR ( (Recinfo.character41 IS NULL)
1368 AND (X_Character41 IS NULL)))
1369 AND ( (Recinfo.character42 = X_Character42)
1370 OR ( (Recinfo.character42 IS NULL)
1371 AND (X_Character42 IS NULL)))
1372 AND ( (Recinfo.character43 = X_Character43)
1373 OR ( (Recinfo.character43 IS NULL)
1374 AND (X_Character43 IS NULL)))
1375 AND ( (Recinfo.character44 = X_Character44)
1376 OR ( (Recinfo.character44 IS NULL)
1377 AND (X_Character44 IS NULL)))
1378 AND ( (Recinfo.character45 = X_Character45)
1379 OR ( (Recinfo.character45 IS NULL)
1380 AND (X_Character45 IS NULL)))
1381 AND ( (Recinfo.character46 = X_Character46)
1382 OR ( (Recinfo.character46 IS NULL)
1383 AND (X_Character46 IS NULL)))
1384 AND ( (Recinfo.character47 = X_Character47)
1385 OR ( (Recinfo.character47 IS NULL)
1386 AND (X_Character47 IS NULL)))
1387 AND ( (Recinfo.character48 = X_Character48)
1388 OR ( (Recinfo.character48 IS NULL)
1389 AND (X_Character48 IS NULL)))
1390 AND ( (Recinfo.character49 = X_Character49)
1391 OR ( (Recinfo.character49 IS NULL)
1392 AND (X_Character49 IS NULL)))
1393 AND ( (Recinfo.character50 = X_Character50)
1394 OR ( (Recinfo.character50 IS NULL)
1395 AND (X_Character50 IS NULL)))
1396 AND ( (Recinfo.character51 = X_Character51)
1397 OR ( (Recinfo.character51 IS NULL)
1398 AND (X_Character51 IS NULL)))
1399 AND ( (Recinfo.character52 = X_Character52)
1400 OR ( (Recinfo.character52 IS NULL)
1401 AND (X_Character52 IS NULL)))
1402 AND ( (Recinfo.character53 = X_Character53)
1403 OR ( (Recinfo.character53 IS NULL)
1404 AND (X_Character53 IS NULL)))
1405 AND ( (Recinfo.character54 = X_Character54)
1406 OR ( (Recinfo.character54 IS NULL)
1407 AND (X_Character54 IS NULL)))
1408 AND ( (Recinfo.character55 = X_Character55)
1409 OR ( (Recinfo.character55 IS NULL)
1410 AND (X_Character55 IS NULL)))
1411 AND ( (Recinfo.character56 = X_Character56)
1412 OR ( (Recinfo.character56 IS NULL)
1413 AND (X_Character56 IS NULL)))
1414 AND ( (Recinfo.character57 = X_Character57)
1415 OR ( (Recinfo.character57 IS NULL)
1416 AND (X_Character57 IS NULL)))
1417 AND ( (Recinfo.character58 = X_Character58)
1418 OR ( (Recinfo.character58 IS NULL)
1419 AND (X_Character58 IS NULL)))
1420 AND ( (Recinfo.character59 = X_Character59)
1421 OR ( (Recinfo.character59 IS NULL)
1422 AND (X_Character59 IS NULL)))
1423 AND ( (Recinfo.character60 = X_Character60)
1424 OR ( (Recinfo.character60 IS NULL)
1425 AND (X_Character60 IS NULL)))
1429 AND ( (Recinfo.character62 = X_Character62)
1426 AND ( (Recinfo.character61 = X_Character61)
1427 OR ( (Recinfo.character61 IS NULL)
1428 AND (X_Character61 IS NULL)))
1430 OR ( (Recinfo.character62 IS NULL)
1431 AND (X_Character62 IS NULL)))
1432 AND ( (Recinfo.character63 = X_Character63)
1433 OR ( (Recinfo.character63 IS NULL)
1434 AND (X_Character63 IS NULL)))
1435 AND ( (Recinfo.character64 = X_Character64)
1436 OR ( (Recinfo.character64 IS NULL)
1437 AND (X_Character64 IS NULL)))
1438 AND ( (Recinfo.character65 = X_Character65)
1439 OR ( (Recinfo.character65 IS NULL)
1440 AND (X_Character65 IS NULL)))
1441 AND ( (Recinfo.character66 = X_Character66)
1442 OR ( (Recinfo.character66 IS NULL)
1443 AND (X_Character66 IS NULL)))
1444 AND ( (Recinfo.character67 = X_Character67)
1445 OR ( (Recinfo.character67 IS NULL)
1446 AND (X_Character67 IS NULL)))
1447 AND ( (Recinfo.character68 = X_Character68)
1448 OR ( (Recinfo.character68 IS NULL)
1449 AND (X_Character68 IS NULL)))
1450 AND ( (Recinfo.character69 = X_Character69)
1451 OR ( (Recinfo.character69 IS NULL)
1452 AND (X_Character69 IS NULL)))
1453 AND ( (Recinfo.character70 = X_Character70)
1454 OR ( (Recinfo.character70 IS NULL)
1455 AND (X_Character70 IS NULL)))
1456 AND ( (Recinfo.character71 = X_Character71)
1457 OR ( (Recinfo.character71 IS NULL)
1458 AND (X_Character71 IS NULL)))
1459 AND ( (Recinfo.character72 = X_Character72)
1460 OR ( (Recinfo.character72 IS NULL)
1461 AND (X_Character72 IS NULL)))
1462 AND ( (Recinfo.character73 = X_Character73)
1463 OR ( (Recinfo.character73 IS NULL)
1464 AND (X_Character73 IS NULL)))
1465 AND ( (Recinfo.character74 = X_Character74)
1466 OR ( (Recinfo.character74 IS NULL)
1467 AND (X_Character74 IS NULL)))
1468 AND ( (Recinfo.character75 = X_Character75)
1469 OR ( (Recinfo.character75 IS NULL)
1470 AND (X_Character75 IS NULL)))
1471 AND ( (Recinfo.character76 = X_Character76)
1472 OR ( (Recinfo.character76 IS NULL)
1473 AND (X_Character76 IS NULL)))
1474 AND ( (Recinfo.character77 = X_Character77)
1475 OR ( (Recinfo.character77 IS NULL)
1476 AND (X_Character77 IS NULL)))
1477 AND ( (Recinfo.character78 = X_Character78)
1478 OR ( (Recinfo.character78 IS NULL)
1479 AND (X_Character78 IS NULL)))
1480 AND ( (Recinfo.character79 = X_Character79)
1481 OR ( (Recinfo.character79 IS NULL)
1482 AND (X_Character79 IS NULL)))
1483 AND ( (Recinfo.character80 = X_Character80)
1484 OR ( (Recinfo.character80 IS NULL)
1485 AND (X_Character80 IS NULL)))
1486 ) then
1487 return;
1488 else
1489 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1490 APP_EXCEPTION.Raise_Exception;
1491 end if;
1492
1493 if ( ( (Recinfo.character81 = X_Character81)
1494 OR ( (Recinfo.character81 IS NULL)
1495 AND (X_Character81 IS NULL)))
1496 AND ( (Recinfo.character82 = X_Character82)
1497 OR ( (Recinfo.character82 IS NULL)
1498 AND (X_Character82 IS NULL)))
1499 AND ( (Recinfo.character83 = X_Character83)
1500 OR ( (Recinfo.character83 IS NULL)
1501 AND (X_Character83 IS NULL)))
1502 AND ( (Recinfo.character84 = X_Character84)
1503 OR ( (Recinfo.character84 IS NULL)
1504 AND (X_Character84 IS NULL)))
1505 AND ( (Recinfo.character85 = X_Character85)
1506 OR ( (Recinfo.character85 IS NULL)
1507 AND (X_Character85 IS NULL)))
1508 AND ( (Recinfo.character86 = X_Character86)
1509 OR ( (Recinfo.character86 IS NULL)
1510 AND (X_Character86 IS NULL)))
1511 AND ( (Recinfo.character87 = X_Character87)
1512 OR ( (Recinfo.character87 IS NULL)
1513 AND (X_Character87 IS NULL)))
1514 AND ( (Recinfo.character88 = X_Character88)
1515 OR ( (Recinfo.character88 IS NULL)
1516 AND (X_Character88 IS NULL)))
1517 AND ( (Recinfo.character89 = X_Character89)
1518 OR ( (Recinfo.character89 IS NULL)
1519 AND (X_Character89 IS NULL)))
1520 AND ( (Recinfo.character90 = X_Character90)
1521 OR ( (Recinfo.character90 IS NULL)
1522 AND (X_Character90 IS NULL)))
1523 AND ( (Recinfo.character91 = X_Character91)
1524 OR ( (Recinfo.character91 IS NULL)
1525 AND (X_Character91 IS NULL)))
1526 AND ( (Recinfo.character92 = X_Character92)
1527 OR ( (Recinfo.character92 IS NULL)
1528 AND (X_Character92 IS NULL)))
1529 AND ( (Recinfo.character93 = X_Character93)
1530 OR ( (Recinfo.character93 IS NULL)
1531 AND (X_Character93 IS NULL)))
1532 AND ( (Recinfo.character94 = X_Character94)
1533 OR ( (Recinfo.character94 IS NULL)
1534 AND (X_Character94 IS NULL)))
1538 AND ( (Recinfo.character96 = X_Character96)
1535 AND ( (Recinfo.character95 = X_Character95)
1536 OR ( (Recinfo.character95 IS NULL)
1537 AND (X_Character95 IS NULL)))
1539 OR ( (Recinfo.character96 IS NULL)
1540 AND (X_Character96 IS NULL)))
1541 AND ( (Recinfo.character97 = X_Character97)
1542 OR ( (Recinfo.character97 IS NULL)
1543 AND (X_Character97 IS NULL)))
1544 AND ( (Recinfo.character98 = X_Character98)
1545 OR ( (Recinfo.character98 IS NULL)
1546 AND (X_Character98 IS NULL)))
1547 AND ( (Recinfo.character99 = X_Character99)
1548 OR ( (Recinfo.character99 IS NULL)
1549 AND (X_Character99 IS NULL)))
1550 AND ( (Recinfo.character100 = X_Character100)
1551 OR ( (Recinfo.character100 IS NULL)
1552 AND (X_Character100 IS NULL)))
1553 ) then
1554 return;
1555 else
1556 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1557 APP_EXCEPTION.Raise_Exception;
1558 end if;
1559
1560 if ( ( (Recinfo.sequence1 = X_Sequence1)
1561 OR ( (Recinfo.sequence1 IS NULL)
1562 AND (X_Sequence1 IS NULL)))
1563 AND ( (Recinfo.sequence2 = X_Sequence2)
1564 OR ( (Recinfo.sequence2 IS NULL)
1565 AND (X_Sequence2 IS NULL)))
1566 AND ( (Recinfo.sequence3 = X_Sequence3)
1567 OR ( (Recinfo.sequence3 IS NULL)
1568 AND (X_Sequence3 IS NULL)))
1569 AND ( (Recinfo.sequence4 = X_Sequence4)
1570 OR ( (Recinfo.sequence4 IS NULL)
1571 AND (X_Sequence4 IS NULL)))
1572 AND ( (Recinfo.sequence5 = X_Sequence5)
1573 OR ( (Recinfo.sequence5 IS NULL)
1574 AND (X_Sequence5 IS NULL)))
1575 AND ( (Recinfo.sequence6 = X_Sequence6)
1576 OR ( (Recinfo.sequence6 IS NULL)
1577 AND (X_Sequence6 IS NULL)))
1578 AND ( (Recinfo.sequence7 = X_Sequence7)
1579 OR ( (Recinfo.sequence7 IS NULL)
1580 AND (X_Sequence7 IS NULL)))
1581 AND ( (Recinfo.sequence8 = X_Sequence8)
1582 OR ( (Recinfo.sequence8 IS NULL)
1583 AND (X_Sequence8 IS NULL)))
1584 AND ( (Recinfo.sequence9 = X_Sequence9)
1585 OR ( (Recinfo.sequence9 IS NULL)
1586 AND (X_Sequence9 IS NULL)))
1587 AND ( (Recinfo.sequence10 = X_Sequence10)
1588 OR ( (Recinfo.sequence10 IS NULL)
1589 AND (X_Sequence10 IS NULL)))
1590 AND ( (Recinfo.sequence11 = X_Sequence11)
1591 OR ( (Recinfo.sequence11 IS NULL)
1592 AND (X_Sequence11 IS NULL)))
1593 AND ( (Recinfo.sequence12 = X_Sequence12)
1594 OR ( (Recinfo.sequence12 IS NULL)
1595 AND (X_Sequence12 IS NULL)))
1596 AND ( (Recinfo.sequence13 = X_Sequence13)
1597 OR ( (Recinfo.sequence13 IS NULL)
1598 AND (X_Sequence13 IS NULL)))
1599 AND ( (Recinfo.sequence14 = X_Sequence14)
1600 OR ( (Recinfo.sequence14 IS NULL)
1601 AND (X_Sequence14 IS NULL)))
1602 AND ( (Recinfo.sequence15 = X_Sequence15)
1603 OR ( (Recinfo.sequence15 IS NULL)
1604 AND (X_Sequence15 IS NULL)))
1605 AND ( (Recinfo.comment1 = X_Comment1)
1606 OR ( (Recinfo.comment1 IS NULL)
1607 AND (X_Comment1 IS NULL)))
1608 AND ( (Recinfo.comment2 = X_Comment2)
1609 OR ( (Recinfo.comment2 IS NULL)
1610 AND (X_Comment2 IS NULL)))
1611 AND ( (Recinfo.comment3 = X_Comment3)
1612 OR ( (Recinfo.comment3 IS NULL)
1613 AND (X_Comment3 IS NULL)))
1614 AND ( (Recinfo.comment4 = X_Comment4)
1615 OR ( (Recinfo.comment4 IS NULL)
1616 AND (X_Comment4 IS NULL)))
1617 AND ( (Recinfo.comment5 = X_Comment5)
1618 OR ( (Recinfo.comment5 IS NULL)
1619 AND (X_Comment5 IS NULL)))
1620 AND ( (Recinfo.party_id = X_Party_Id)
1621 OR ( (Recinfo.party_id IS NULL)
1622 AND (X_Party_Id IS NULL)))
1623 AND ( (Recinfo.csi_instance_id = X_Csi_Instance_Id)
1624 OR ( (Recinfo.csi_instance_id IS NULL)
1625 AND (X_Csi_Instance_Id IS NULL)))
1626 AND ( (Recinfo.counter_id = X_Counter_Id)
1627 OR ( (Recinfo.counter_id IS NULL)
1628 AND (X_Counter_Id IS NULL)))
1629 AND ( (Recinfo.counter_reading_id = X_Counter_Reading_Id)
1630 OR ( (Recinfo.counter_reading_id IS NULL)
1631 AND (X_Counter_Reading_Id IS NULL)))
1632 AND ( (Recinfo.ahl_mr_id = X_Ahl_Mr_Id)
1633 OR ( (Recinfo.ahl_mr_id IS NULL)
1634 AND (X_Ahl_Mr_Id IS NULL)))
1635 AND ( (Recinfo.cs_incident_id = X_Cs_Incident_Id)
1636 OR ( (Recinfo.cs_incident_id IS NULL)
1637 AND (X_Cs_Incident_Id IS NULL)))
1638 AND ( (Recinfo.wip_rework_id = X_Wip_Rework_Id)
1639 OR ( (Recinfo.wip_rework_id IS NULL)
1640 AND (X_Wip_Rework_Id IS NULL)))
1641 AND ( (Recinfo.disposition_source = X_Disposition_Source)
1642 OR ( (Recinfo.disposition_source IS NULL)
1643 AND (X_Disposition_Source IS NULL)))
1644 AND ( (Recinfo.disposition = X_Disposition)
1648 OR ( (Recinfo.disposition_action IS NULL)
1645 OR ( (Recinfo.disposition IS NULL)
1646 AND (X_Disposition IS NULL)))
1647 AND ( (Recinfo.disposition_action = X_Disposition_Action)
1649 AND (X_Disposition_Action IS NULL)))
1650 AND ( (Recinfo.disposition_status = X_Disposition_Status)
1651 OR ( (Recinfo.disposition_status IS NULL)
1652 AND (X_Disposition_Status IS NULL)))
1653 AND ( (Recinfo.mti_transaction_header_id = X_Mti_Transaction_Header_Id)
1654 OR ( (Recinfo.mti_transaction_header_id IS NULL)
1655 AND (X_Mti_Transaction_Header_Id IS NULL)))
1656 AND ( (Recinfo.mti_transaction_interface_id = X_Mti_Transaction_Interface_Id)
1657 OR ( (Recinfo.mti_transaction_interface_id IS NULL)
1658 AND (X_Mti_Transaction_Interface_Id IS NULL)))
1659 AND ( (Recinfo.mmt_transaction_id = X_Mmt_Transaction_Id)
1660 OR ( (Recinfo.mmt_transaction_id IS NULL)
1661 AND (X_Mmt_Transaction_Id IS NULL)))
1662 AND ( (Recinfo.wjsi_group_id = X_Wjsi_Group_Id)
1663 OR ( (Recinfo.wjsi_group_id IS NULL)
1664 AND (X_Wjsi_Group_Id IS NULL)))
1665 AND ( (Recinfo.wmti_group_id = X_Wmti_Group_Id)
1666 OR ( (Recinfo.wmti_group_id IS NULL)
1667 AND (X_Wmti_Group_Id IS NULL)))
1668 AND ( (Recinfo.wmt_transaction_id = X_Wmt_Transaction_Id)
1669 OR ( (Recinfo.wmt_transaction_id IS NULL)
1670 AND (X_Wmt_Transaction_Id IS NULL)))
1671 AND ( (Recinfo.rti_interface_transaction_id = X_Rti_Interface_Transaction_Id)
1672 OR ( (Recinfo.rti_interface_transaction_id IS NULL)
1673 AND (X_Rti_Interface_Transaction_Id IS NULL)))
1674 AND ( (Recinfo.maintenance_op_seq = X_Maintenance_Op_Seq)
1675 OR ( (Recinfo.maintenance_op_seq IS NULL)
1676 AND (X_Maintenance_Op_Seq IS NULL)))
1677 AND ( (Recinfo.bill_reference_id = X_Bill_Reference_Id)
1678 OR ( (Recinfo.bill_reference_id IS NULL)
1679 AND (X_Bill_Reference_Id IS NULL)))
1680 AND ( (Recinfo.routing_reference_id = X_Routing_Reference_Id)
1681 OR ( (Recinfo.routing_reference_id IS NULL)
1682 AND (X_Routing_Reference_Id IS NULL)))
1683 AND ( (Recinfo.to_subinventory = X_To_Subinventory)
1684 OR ( (Recinfo.to_subinventory IS NULL)
1685 AND (X_To_Subinventory IS NULL)))
1686 AND ( (Recinfo.to_locator_id = X_To_Locator_Id)
1687 OR ( (Recinfo.to_locator_id IS NULL)
1688 AND (X_To_Locator_Id IS NULL)))
1689 AND ( (Recinfo.concurrent_request_id = X_Concurrent_Request_Id )
1690 OR ( (Recinfo.concurrent_request_id IS NULL)
1691 AND (X_Concurrent_Request_Id IS NULL)))
1692 AND ( (Recinfo.lot_status_id = X_Lot_Status_Id)
1693 OR ( (Recinfo.lot_status_id IS NULL)
1694 AND (X_Lot_Status_Id IS NULL)))
1695 AND ( (Recinfo.serial_status_id = X_Serial_Status_Id)
1696 OR ( (Recinfo.serial_status_id IS NULL)
1697 AND (X_Serial_Status_Id IS NULL)))
1698 AND ( (Recinfo.nonconformance_source = X_Nonconformance_Source)
1699 OR ( (Recinfo.nonconformance_source IS NULL)
1700 AND (X_Nonconformance_Source IS NULL)))
1701 AND ( (Recinfo.nonconform_severity = X_Nonconform_Severity)
1702 OR ( (Recinfo.nonconform_severity IS NULL)
1703 AND (X_Nonconform_Severity IS NULL)))
1704 AND ( (Recinfo.nonconform_priority = X_Nonconform_Priority)
1705 OR ( (Recinfo.nonconform_priority IS NULL)
1706 AND (X_Nonconform_Priority IS NULL)))
1707 AND ( (Recinfo.nonconformance_type = X_Nonconformance_Type)
1708 OR ( (Recinfo.nonconformance_type IS NULL)
1709 AND (X_Nonconformance_Type IS NULL)))
1710 AND ( (Recinfo.nonconformance_code = X_Nonconformance_Code)
1711 OR ( (Recinfo.nonconformance_code IS NULL)
1712 AND (X_Nonconformance_Code IS NULL)))
1713 AND ( (Recinfo.nonconformance_status = X_Nonconformance_Status)
1714 OR ( (Recinfo.nonconformance_status IS NULL)
1715 AND (X_Nonconformance_Status IS NULL)))
1716 AND ( (Recinfo.date_opened = X_Date_Opened)
1717 OR ( (Recinfo.date_opened IS NULL)
1718 AND (X_Date_Opened IS NULL)))
1719 AND ( (Recinfo.date_closed = X_Date_Closed)
1720 OR ( (Recinfo.date_closed IS NULL)
1721 AND (X_Date_Closed IS NULL)))
1722 AND ( (Recinfo.days_to_close = X_Days_To_Close)
1723 OR ( (Recinfo.days_to_close IS NULL)
1724 AND (X_Days_To_Close IS NULL)))
1725 AND ( (Recinfo.rcv_transaction_id = X_Rcv_Transaction_Id)
1726 OR ( (Recinfo.rcv_transaction_id IS NULL)
1727 AND (X_Rcv_Transaction_Id IS NULL)))
1728 AND ( (Recinfo.request_source = X_Request_Source)
1729 OR ( (Recinfo.request_source IS NULL)
1730 AND (X_Request_Source IS NULL)))
1731 AND ( (Recinfo.request_priority = X_Request_Priority)
1732 OR ( (Recinfo.request_priority IS NULL)
1733 AND (X_Request_Priority IS NULL)))
1734 AND ( (Recinfo.request_severity = X_Request_Severity)
1735 OR ( (Recinfo.request_severity IS NULL)
1736 AND (X_Request_Severity IS NULL)))
1737 AND ( (Recinfo.request_status = X_Request_Status)
1738 OR ( (Recinfo.request_status IS NULL)
1742 AND (X_Eco_Name IS NULL)))
1739 AND (X_Request_Status IS NULL)))
1740 AND ( (Recinfo.eco_name = X_Eco_Name )
1741 OR ( (Recinfo.eco_name IS NULL)
1743 ) then
1744 return;
1745 else
1746 FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1747 APP_EXCEPTION.Raise_Exception;
1748 end if;
1749
1750 END Lock_Row;
1751
1752
1753 --
1754 -- Modified the proc signature and implementation
1755 -- to include the database columns added for ASO support.
1756 -- rkunchal Thu Jul 25 01:43:48 PDT 2002
1757 --
1758 --
1759 -- See Bug 2588213
1760 -- To support the element Maintenance Op Seq Number
1761 -- to be used along with Maintenance Workorder
1762 -- rkunchal Mon Sep 23 23:46:28 PDT 2002
1763 --
1764
1765 -- Modified the signature to include NCM Hardcode Elements.
1766 -- suramasw Thu Oct 31 10:48:59 PST 2002.
1767 -- Bug 2449067.
1768
1769 -- Modified the signature to include CAR Hardcode Elements.
1770 -- anagarwa Thu Nov 14 13:03:35 PST 2002
1771
1772 -- Modified the signature to include new hardcoded elements followup activity, Transfer license plate number
1773 -- saugupta
1774
1775 PROCEDURE Update_Row(X_Rowid VARCHAR2,
1776 X_Collection_Id NUMBER,
1777 X_Occurrence NUMBER,
1778 X_Last_Update_Date DATE,
1779 X_Qa_Last_Update_Date DATE,
1780 X_Last_Updated_By NUMBER,
1781 X_Qa_Last_Updated_By NUMBER,
1782 X_Qa_Creation_Date DATE,
1783 X_Qa_Created_By NUMBER,
1784 X_Last_Update_Login NUMBER,
1785 X_Transaction_Number NUMBER,
1786 X_Txn_Header_Id NUMBER,
1787 X_Organization_Id NUMBER,
1788 X_Plan_Id NUMBER,
1789 X_Spec_Id NUMBER,
1790 X_Transaction_Id NUMBER,
1791 X_Department_Id NUMBER,
1792 X_To_Department_Id NUMBER,
1793 X_Resource_Id NUMBER,
1794 X_Quantity NUMBER,
1795 X_Item_Id NUMBER,
1796 X_Uom VARCHAR2,
1797 X_Revision VARCHAR2,
1798 X_Subinventory VARCHAR2,
1799 X_Locator_Id NUMBER,
1800 X_Lot_Number VARCHAR2,
1801 X_Serial_Number VARCHAR2,
1802 X_Comp_Item_Id NUMBER,
1803 X_Comp_Uom VARCHAR2,
1804 X_Comp_Revision VARCHAR2,
1805 X_Comp_Subinventory VARCHAR2,
1806 X_Comp_Locator_Id NUMBER,
1807 X_Comp_Lot_Number VARCHAR2,
1808 X_Comp_Serial_Number VARCHAR2,
1809 X_Wip_Entity_Id NUMBER,
1810 X_Line_Id NUMBER,
1811 X_To_Op_Seq_Num NUMBER,
1812 X_From_Op_Seq_Num NUMBER,
1813 X_Vendor_Id NUMBER,
1814 X_Receipt_Num VARCHAR2,
1815 X_Po_Header_Id NUMBER,
1816 -- bug 9652549 CLM changes
1817 X_Po_Line_Num VARCHAR2,
1818 X_Po_Release_Id NUMBER,
1819 X_Po_Shipment_Num NUMBER,
1820 X_Customer_Id NUMBER,
1821 X_So_Header_Id NUMBER,
1822 X_Rma_Header_Id NUMBER,
1823 X_Transaction_Date DATE,
1824 X_Status VARCHAR2,
1825 X_Project_Id NUMBER ,
1826 X_Task_ID NUMBER,
1827 X_LPN_ID NUMBER,
1828 X_XFR_LPN_ID NUMBER,
1829 X_Contract_ID NUMBER,
1830 X_Contract_Line_ID NUMBER,
1831 X_Deliverable_ID NUMBER,
1832 X_Asset_Group_ID NUMBER,
1833 X_Asset_Number VARCHAR2,
1834 X_Asset_Instance_ID NUMBER, --dgupta: R12 EAM Integration. Bug 4345492
1835 X_Asset_Activity_ID NUMBER,
1836 X_Followup_Activity_ID NUMBER,
1837 X_Work_Order_ID NUMBER,
1838 X_Character1 VARCHAR2,
1839 X_Character2 VARCHAR2,
1840 X_Character3 VARCHAR2,
1841 X_Character4 VARCHAR2,
1842 X_Character5 VARCHAR2,
1843 X_Character6 VARCHAR2,
1844 X_Character7 VARCHAR2,
1845 X_Character8 VARCHAR2,
1846 X_Character9 VARCHAR2,
1847 X_Character10 VARCHAR2,
1848 X_Character11 VARCHAR2,
1849 X_Character12 VARCHAR2,
1853 X_Character16 VARCHAR2,
1850 X_Character13 VARCHAR2,
1851 X_Character14 VARCHAR2,
1852 X_Character15 VARCHAR2,
1854 X_Character17 VARCHAR2,
1855 X_Character18 VARCHAR2,
1856 X_Character19 VARCHAR2,
1857 X_Character20 VARCHAR2,
1858 X_Character21 VARCHAR2,
1859 X_Character22 VARCHAR2,
1860 X_Character23 VARCHAR2,
1861 X_Character24 VARCHAR2,
1862 X_Character25 VARCHAR2,
1863 X_Character26 VARCHAR2,
1864 X_Character27 VARCHAR2,
1865 X_Character28 VARCHAR2,
1866 X_Character29 VARCHAR2,
1867 X_Character30 VARCHAR2,
1868 X_Character31 VARCHAR2,
1869 X_Character32 VARCHAR2,
1870 X_Character33 VARCHAR2,
1871 X_Character34 VARCHAR2,
1872 X_Character35 VARCHAR2,
1873 X_Character36 VARCHAR2,
1874 X_Character37 VARCHAR2,
1875 X_Character38 VARCHAR2,
1876 X_Character39 VARCHAR2,
1877 X_Character40 VARCHAR2,
1878 X_Character41 VARCHAR2,
1879 X_Character42 VARCHAR2,
1880 X_Character43 VARCHAR2,
1881 X_Character44 VARCHAR2,
1882 X_Character45 VARCHAR2,
1883 X_Character46 VARCHAR2,
1884 X_Character47 VARCHAR2,
1885 X_Character48 VARCHAR2,
1886 X_Character49 VARCHAR2,
1887 X_Character50 VARCHAR2,
1888 X_Character51 VARCHAR2,
1889 X_Character52 VARCHAR2,
1890 X_Character53 VARCHAR2,
1891 X_Character54 VARCHAR2,
1892 X_Character55 VARCHAR2,
1893 X_Character56 VARCHAR2,
1894 X_Character57 VARCHAR2,
1895 X_Character58 VARCHAR2,
1896 X_Character59 VARCHAR2,
1897 X_Character60 VARCHAR2,
1898 X_Character61 VARCHAR2,
1899 X_Character62 VARCHAR2,
1900 X_Character63 VARCHAR2,
1901 X_Character64 VARCHAR2,
1902 X_Character65 VARCHAR2,
1903 X_Character66 VARCHAR2,
1904 X_Character67 VARCHAR2,
1905 X_Character68 VARCHAR2,
1906 X_Character69 VARCHAR2,
1907 X_Character70 VARCHAR2,
1908 X_Character71 VARCHAR2,
1909 X_Character72 VARCHAR2,
1910 X_Character73 VARCHAR2,
1911 X_Character74 VARCHAR2,
1912 X_Character75 VARCHAR2,
1913 X_Character76 VARCHAR2,
1914 X_Character77 VARCHAR2,
1915 X_Character78 VARCHAR2,
1916 X_Character79 VARCHAR2,
1917 X_Character80 VARCHAR2,
1918 X_Character81 VARCHAR2,
1919 X_Character82 VARCHAR2,
1920 X_Character83 VARCHAR2,
1921 X_Character84 VARCHAR2,
1922 X_Character85 VARCHAR2,
1923 X_Character86 VARCHAR2,
1924 X_Character87 VARCHAR2,
1925 X_Character88 VARCHAR2,
1926 X_Character89 VARCHAR2,
1927 X_Character90 VARCHAR2,
1928 X_Character91 VARCHAR2,
1929 X_Character92 VARCHAR2,
1930 X_Character93 VARCHAR2,
1931 X_Character94 VARCHAR2,
1932 X_Character95 VARCHAR2,
1933 X_Character96 VARCHAR2,
1934 X_Character97 VARCHAR2,
1935 X_Character98 VARCHAR2,
1936 X_Character99 VARCHAR2,
1937 X_Character100 VARCHAR2,
1938 X_Sequence1 VARCHAR2,
1939 X_Sequence2 VARCHAR2,
1943 X_Sequence6 VARCHAR2,
1940 X_Sequence3 VARCHAR2,
1941 X_Sequence4 VARCHAR2,
1942 X_Sequence5 VARCHAR2,
1944 X_Sequence7 VARCHAR2,
1945 X_Sequence8 VARCHAR2,
1946 X_Sequence9 VARCHAR2,
1947 X_Sequence10 VARCHAR2,
1948 X_Sequence11 VARCHAR2,
1949 X_Sequence12 VARCHAR2,
1950 X_Sequence13 VARCHAR2,
1951 X_Sequence14 VARCHAR2,
1952 X_Sequence15 VARCHAR2,
1953 X_Comment1 VARCHAR2,
1954 X_Comment2 VARCHAR2,
1955 X_Comment3 VARCHAR2,
1956 X_Comment4 VARCHAR2,
1957 X_Comment5 VARCHAR2,
1958 X_Party_Id NUMBER,
1959 X_Csi_Instance_Id NUMBER,
1960 X_Counter_Id NUMBER,
1961 X_Counter_Reading_Id NUMBER,
1962 X_Ahl_Mr_Id NUMBER,
1963 X_Cs_Incident_Id NUMBER,
1964 X_Wip_Rework_Id NUMBER,
1965 X_Disposition_Source VARCHAR2,
1966 X_Disposition VARCHAR2,
1967 X_Disposition_Action VARCHAR2,
1968 X_Disposition_Status VARCHAR2,
1969 X_Mti_Transaction_Header_Id NUMBER,
1970 X_Mti_Transaction_Interface_Id NUMBER,
1971 X_Mmt_Transaction_Id NUMBER,
1972 X_Wjsi_Group_Id NUMBER,
1973 X_Wmti_Group_Id NUMBER,
1974 X_Wmt_Transaction_Id NUMBER,
1975 X_Rti_Interface_Transaction_Id NUMBER,
1976 X_Maintenance_Op_Seq NUMBER,
1977 X_Bill_Reference_Id NUMBER,
1978 X_Routing_Reference_Id NUMBER,
1979 X_To_Subinventory VARCHAR2,
1980 X_To_Locator_Id NUMBER,
1981 X_Concurrent_Request_Id NUMBER,
1982 X_Lot_Status_Id NUMBER,
1983 X_Serial_Status_Id NUMBER,
1984 X_Nonconformance_Source VARCHAR2,
1985 X_Nonconform_Severity VARCHAR2,
1986 X_Nonconform_Priority VARCHAR2,
1987 X_Nonconformance_Type VARCHAR2,
1988 X_Nonconformance_Code VARCHAR2,
1989 X_Nonconformance_Status VARCHAR2,
1990 X_Date_Opened DATE,
1991 X_Date_Closed DATE,
1992 X_Days_To_Close NUMBER,
1993 X_Rcv_Transaction_Id NUMBER,
1994 X_Request_Source VARCHAR2,
1995 X_Request_Priority VARCHAR2,
1996 X_Request_Severity VARCHAR2,
1997 X_Request_Status VARCHAR2,
1998 X_Eco_Name VARCHAR2,
1999 /* R12 DR Integration. Bug 4345489 Start*/
2000 X_REPAIR_LINE_ID NUMBER,
2001 X_JTF_TASK_ID NUMBER,
2002 /* R12 DR Integration. Bug 4345489 End*/
2003
2004 -- R12 OPM Deviations. Bug 4345503 Start
2005 X_PROCESS_BATCH_ID NUMBER,
2006 X_PROCESS_BATCHSTEP_ID NUMBER,
2007 X_PROCESS_OPERATION_ID NUMBER,
2008 X_PROCESS_ACTIVITY_ID NUMBER,
2009 X_PROCESS_RESOURCE_ID NUMBER,
2010 X_PROCESS_PARAMETER_ID NUMBER
2011 -- R12 OPM Deviations. Bug 4345503 End
2012 ) IS
2013 BEGIN
2014 UPDATE QA_RESULTS
2015 SET
2016 collection_id = X_Collection_Id,
2017 occurrence = X_Occurrence,
2018 last_update_date = X_Last_Update_Date,
2019 qa_last_update_date = X_Qa_Last_Update_Date,
2020 last_updated_by = X_Last_Updated_By,
2021 qa_last_updated_by = X_Qa_Last_Updated_By,
2022 qa_creation_date = X_Qa_Creation_Date,
2023 qa_created_by = X_Qa_Created_By,
2024 last_update_login = X_Last_Update_Login,
2025 transaction_number = X_Transaction_Number,
2026 txn_header_id = X_Txn_Header_Id,
2027 organization_id = X_Organization_Id,
2028 plan_id = X_Plan_Id,
2029 spec_id = X_Spec_Id,
2030 transaction_id = X_Transaction_Id,
2031 department_id = X_Department_Id,
2032 to_department_id = X_To_Department_Id,
2033 resource_id = X_Resource_Id,
2034 quantity = X_Quantity,
2035 item_id = X_Item_Id,
2039 locator_id = X_Locator_Id,
2036 uom = X_Uom,
2037 revision = X_Revision,
2038 subinventory = X_Subinventory,
2040 lot_number = X_Lot_Number,
2041 serial_number = X_Serial_Number,
2042 comp_item_id = X_Comp_Item_Id,
2043 comp_uom = X_Comp_Uom,
2044 comp_revision = X_Comp_Revision,
2045 comp_subinventory = X_Comp_Subinventory,
2046 comp_locator_id = X_Comp_Locator_Id,
2047 comp_lot_number = X_Comp_Lot_Number,
2048 comp_serial_number = X_Comp_Serial_Number,
2049 wip_entity_id = X_Wip_Entity_Id,
2050 line_id = X_Line_Id,
2051 to_op_seq_num = X_To_Op_Seq_Num,
2052 from_op_seq_num = X_From_Op_Seq_Num,
2053 vendor_id = X_Vendor_Id,
2054 receipt_num = X_Receipt_Num,
2055 po_header_id = X_Po_Header_Id,
2056 po_line_num = X_Po_Line_Num,
2057 po_release_id = X_Po_Release_Id,
2058 po_shipment_num = X_Po_Shipment_Num,
2059 customer_id = X_Customer_Id,
2060 so_header_id = X_So_Header_Id,
2061 rma_header_id = X_Rma_Header_Id,
2062 transaction_date = X_Transaction_Date,
2063 status = X_Status ,
2064 Project_Id = X_Project_Id,
2065 Task_Id = X_Task_Id ,
2066 LPN_ID = X_LPN_ID,
2067 XFR_LPN_ID = X_XFR_LPN_ID,
2068 Contract_ID = X_Contract_ID,
2069 Contract_Line_ID = X_Contract_Line_ID,
2070 Deliverable_ID = X_Deliverable_ID,
2071 Asset_Group_ID = X_Asset_Group_ID,
2072 Asset_Number = X_Asset_Number,
2073 Asset_Instance_ID = X_Asset_Instance_ID, --dgupta: R12 EAM Integration. Bug 4345492
2074 Asset_Activity_ID = X_Asset_Activity_ID,
2075 Followup_Activity_ID = X_Followup_Activity_ID,
2076 Work_Order_ID = X_Work_Order_ID,
2077 character1 = X_Character1,
2078 character2 = X_Character2,
2079 character3 = X_Character3,
2080 character4 = X_Character4,
2081 character5 = X_Character5,
2082 character6 = X_Character6,
2083 character7 = X_Character7,
2084 character8 = X_Character8,
2085 character9 = X_Character9,
2086 character10 = X_Character10,
2087 character11 = X_Character11,
2088 character12 = X_Character12,
2089 character13 = X_Character13,
2090 character14 = X_Character14,
2091 character15 = X_Character15,
2092 character16 = X_Character16,
2093 character17 = X_Character17,
2094 character18 = X_Character18,
2095 character19 = X_Character19,
2096 character20 = X_Character20,
2097 character21 = X_Character21,
2098 character22 = X_Character22,
2099 character23 = X_Character23,
2100 character24 = X_Character24,
2101 character25 = X_Character25,
2102 character26 = X_Character26,
2103 character27 = X_Character27,
2104 character28 = X_Character28,
2105 character29 = X_Character29,
2106 character30 = X_Character30,
2107 character31 = X_Character31,
2108 character32 = X_Character32,
2109 character33 = X_Character33,
2110 character34 = X_Character34,
2111 character35 = X_Character35,
2112 character36 = X_Character36,
2113 character37 = X_Character37,
2114 character38 = X_Character38,
2115 character39 = X_Character39,
2116 character40 = X_Character40,
2117 character41 = X_Character41,
2118 character42 = X_Character42,
2119 character43 = X_Character43,
2120 character44 = X_Character44,
2121 character45 = X_Character45,
2122 character46 = X_Character46,
2123 character47 = X_Character47,
2124 character48 = X_Character48,
2125 character49 = X_Character49,
2126 character50 = X_Character50,
2127 character51 = X_Character51,
2128 character52 = X_Character52,
2129 character53 = X_Character53,
2130 character54 = X_Character54,
2131 character55 = X_Character55,
2132 character56 = X_Character56,
2136 character60 = X_Character60,
2133 character57 = X_Character57,
2134 character58 = X_Character58,
2135 character59 = X_Character59,
2137 character61 = X_Character61,
2138 character62 = X_Character62,
2139 character63 = X_Character63,
2140 character64 = X_Character64,
2141 character65 = X_Character65,
2142 character66 = X_Character66,
2143 character67 = X_Character67,
2144 character68 = X_Character68,
2145 character69 = X_Character69,
2146 character70 = X_Character70,
2147 character71 = X_Character71,
2148 character72 = X_Character72,
2149 character73 = X_Character73,
2150 character74 = X_Character74,
2151 character75 = X_Character75,
2152 character76 = X_Character76,
2153 character77 = X_Character77,
2154 character78 = X_Character78,
2155 character79 = X_Character79,
2156 character80 = X_Character80,
2157 character81 = X_Character81,
2158 character82 = X_Character82,
2159 character83 = X_Character83,
2160 character84 = X_Character84,
2161 character85 = X_Character85,
2162 character86 = X_Character86,
2163 character87 = X_Character87,
2164 character88 = X_Character88,
2165 character89 = X_Character89,
2166 character90 = X_Character90,
2167 character91 = X_Character91,
2168 character92 = X_Character92,
2169 character93 = X_Character93,
2170 character94 = X_Character94,
2171 character95 = X_Character95,
2172 character96 = X_Character96,
2173 character97 = X_Character97,
2174 character98 = X_Character98,
2175 character99 = X_Character99,
2176 character100 = X_Character100,
2177 sequence1 = X_Sequence1,
2178 sequence2 = X_Sequence2,
2179 sequence3 = X_Sequence3,
2180 sequence4 = X_Sequence4,
2181 sequence5 = X_Sequence5,
2182 sequence6 = X_Sequence6,
2183 sequence7 = X_Sequence7,
2184 sequence8 = X_Sequence8,
2185 sequence9 = X_Sequence9,
2186 sequence10 = X_Sequence10,
2187 sequence11 = X_Sequence11,
2188 sequence12 = X_Sequence12,
2189 sequence13 = X_Sequence13,
2190 sequence14 = X_Sequence14,
2191 sequence15 = X_Sequence15,
2192 comment1 = X_Comment1,
2193 comment2 = X_Comment2,
2194 comment3 = X_Comment3,
2195 comment4 = X_Comment4,
2196 comment5 = X_Comment5,
2197 party_id = X_Party_Id,
2198 csi_instance_id = X_Csi_Instance_Id,
2199 counter_id = X_Counter_Id,
2200 counter_reading_id = X_Counter_Reading_Id,
2201 ahl_mr_id = X_Ahl_Mr_Id,
2202 cs_incident_id = X_Cs_Incident_Id,
2203 wip_rework_id = X_Wip_Rework_Id,
2204 disposition_source = X_Disposition_Source,
2205 disposition = X_Disposition,
2206 disposition_action = X_Disposition_Action,
2207 disposition_status = X_Disposition_Status,
2208 mti_transaction_header_id = X_Mti_Transaction_Header_Id,
2209 mti_transaction_interface_id = X_Mti_Transaction_Interface_Id,
2210 mmt_transaction_id = X_Mmt_Transaction_Id,
2211 wjsi_group_id = X_Wjsi_Group_Id,
2212 wmti_group_id = X_Wmti_Group_Id,
2213 wmt_transaction_id = X_Wmt_Transaction_Id,
2214 rti_interface_transaction_id = X_Rti_Interface_Transaction_Id,
2215 maintenance_op_seq = X_Maintenance_Op_Seq,
2216 bill_reference_id = X_Bill_Reference_Id,
2217 routing_reference_id = X_Routing_Reference_Id,
2218 to_subinventory = X_To_Subinventory,
2219 to_locator_id = X_To_Locator_Id,
2220 concurrent_request_id = X_Concurrent_Request_Id,
2221 lot_status_id = X_Lot_Status_Id,
2222 serial_status_id = X_Serial_Status_Id,
2223 nonconformance_source = X_Nonconformance_Source,
2224 nonconform_severity = X_Nonconform_Severity,
2225 nonconform_priority = X_Nonconform_Priority,
2226 nonconformance_type = X_Nonconformance_Type,
2230 date_closed = X_Date_Closed,
2227 nonconformance_code = X_Nonconformance_Code,
2228 nonconformance_status = X_Nonconformance_Status,
2229 date_opened = X_Date_Opened,
2231 days_to_close = X_Days_To_Close,
2232 rcv_transaction_id = X_Rcv_Transaction_Id,
2233 request_source = X_Request_Source,
2234 request_priority = X_Request_Priority,
2235 request_severity = X_Request_Severity,
2236 request_status = X_Request_Status,
2237 eco_name = X_Eco_Name,
2238 /* R12 DR Integration. Bug 4345489 Start */
2239 repair_line_id = X_REPAIR_LINE_ID,
2240 jtf_task_id = X_JTF_TASK_ID,
2241 /* R12 DR Integration. Bug 4345489 End */
2242
2243 -- R12 OPM Deviations. Bug 4345503 Start
2244 PROCESS_BATCH_ID = X_PROCESS_BATCH_ID,
2245 PROCESS_BATCHSTEP_ID = X_PROCESS_BATCHSTEP_ID,
2246 PROCESS_OPERATION_ID = X_PROCESS_OPERATION_ID,
2247 PROCESS_ACTIVITY_ID = X_PROCESS_ACTIVITY_ID,
2248 PROCESS_RESOURCE_ID = X_PROCESS_RESOURCE_ID,
2249 PROCESS_PARAMETER_ID = X_PROCESS_PARAMETER_ID
2250 -- R12 OPM Deviations. Bug 4345503 End
2251 WHERE rowid = X_Rowid;
2252
2253 if (SQL%NOTFOUND) then
2254 Raise NO_DATA_FOUND;
2255 end if;
2256 END Update_Row;
2257
2258 PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
2259 BEGIN
2260 DELETE FROM QA_RESULTS
2261 WHERE rowid = X_Rowid;
2262
2263 if (SQL%NOTFOUND) then
2264 Raise NO_DATA_FOUND;
2265 end if;
2266 END Delete_Row;
2267
2268
2269 END QA_RESULTS_PKG;