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