1 PACKAGE QA_RESULTS_PKG as
2 /* $Header: qltrestb.pls 120.3 2005/06/11 08:53:51 appldev $ */
3
4 --
5 -- Modified the proc signature to include the
6 -- database columns added for ASO support.
7 -- All the new columns are appended after party_id
8 -- rkunchal Thu Jul 25 01:43:48 PDT 2002
9 --
10 --
11 -- See Bug 2588213
12 -- To support the element Maintenance Op Seq Number
13 -- to be used along with Maintenance Workorder
14 -- rkunchal Mon Sep 23 23:46:28 PDT 2002
15 --
16
17 -- Modified the signature to include NCM Hardcode Elements.
18 -- suramasw Thu Oct 31 10:48:59 PST 2002.
19 -- Bug 2449067.
20
21 -- anagarwa Thu Nov 14 14:26:50 PST 2002
22 -- Modified the signature to include CAR Hardcode Elements.
23
24 -- modified the following to include new hardcoded element followup activity, transfer license plate number
25 -- saugupta
26
27 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
28 X_Collection_Id NUMBER,
29 X_Occurrence IN OUT NOCOPY NUMBER,
30 X_Last_Update_Date DATE,
31 X_Qa_Last_Update_Date DATE,
32 X_Last_Updated_By NUMBER,
33 X_Qa_Last_Updated_By NUMBER,
34 X_Creation_Date DATE,
35 X_Qa_Creation_Date DATE,
36 X_Created_By NUMBER,
37 X_Qa_Created_By NUMBER,
38 X_Last_Update_Login NUMBER,
39 X_Transaction_Number NUMBER,
40 X_Txn_Header_Id NUMBER,
41 X_Organization_Id NUMBER,
42 X_Plan_Id NUMBER,
43 X_Spec_Id NUMBER,
44 X_Transaction_Id NUMBER,
45 X_Department_Id NUMBER,
46 X_To_Department_Id NUMBER,
47 X_Resource_Id NUMBER,
48 X_Quantity NUMBER,
49 X_Item_Id NUMBER,
50 X_Uom VARCHAR2,
51 X_Revision VARCHAR2,
52 X_Subinventory VARCHAR2,
53 X_Locator_Id NUMBER,
54 X_Lot_Number VARCHAR2,
55 X_Serial_Number VARCHAR2,
56 X_Comp_Item_Id NUMBER,
57 X_Comp_Uom VARCHAR2,
58 X_Comp_Revision VARCHAR2,
59 X_Comp_Subinventory VARCHAR2,
60 X_Comp_Locator_Id NUMBER,
61 X_Comp_Lot_Number VARCHAR2,
62 X_Comp_Serial_Number VARCHAR2,
63 X_Wip_Entity_Id NUMBER,
64 X_Line_Id NUMBER,
65 X_To_Op_Seq_Num NUMBER,
66 X_From_Op_Seq_Num NUMBER,
67 X_Vendor_Id NUMBER,
68 X_Receipt_Num VARCHAR2,
69 X_Po_Header_Id NUMBER,
70 X_Po_Line_Num NUMBER,
71 X_Po_Release_Id NUMBER,
72 X_Po_Shipment_Num NUMBER,
73 X_Customer_Id NUMBER,
74 X_So_Header_Id NUMBER,
75 X_Rma_Header_Id NUMBER,
76 X_Transaction_Date DATE,
77 X_Status VARCHAR2,
78 X_Project_Id NUMBER ,
79 X_Task_Id NUMBER,
80 X_LPN_ID NUMBER,
81 X_XFR_LPN_ID NUMBER,
82 X_Contract_ID NUMBER,
83 X_Contract_Line_ID NUMBER,
84 X_Deliverable_ID NUMBER,
85 X_Asset_Group_ID NUMBER,
86 X_Asset_Number VARCHAR2,
87 X_Asset_Instance_ID NUMBER, --dgupta: R12 EAM Integration. Bug 4345492
88 X_Asset_Activity_ID NUMBER,
89 X_Followup_Activity_ID NUMBER,
90 X_Work_Order_ID NUMBER,
91 X_Character1 VARCHAR2,
92 X_Character2 VARCHAR2,
93 X_Character3 VARCHAR2,
94 X_Character4 VARCHAR2,
95 X_Character5 VARCHAR2,
96 X_Character6 VARCHAR2,
97 X_Character7 VARCHAR2,
98 X_Character8 VARCHAR2,
99 X_Character9 VARCHAR2,
100 X_Character10 VARCHAR2,
101 X_Character11 VARCHAR2,
102 X_Character12 VARCHAR2,
103 X_Character13 VARCHAR2,
104 X_Character14 VARCHAR2,
105 X_Character15 VARCHAR2,
106 X_Character16 VARCHAR2,
107 X_Character17 VARCHAR2,
108 X_Character18 VARCHAR2,
109 X_Character19 VARCHAR2,
110 X_Character20 VARCHAR2,
111 X_Character21 VARCHAR2,
112 X_Character22 VARCHAR2,
113 X_Character23 VARCHAR2,
114 X_Character24 VARCHAR2,
115 X_Character25 VARCHAR2,
116 X_Character26 VARCHAR2,
117 X_Character27 VARCHAR2,
118 X_Character28 VARCHAR2,
119 X_Character29 VARCHAR2,
120 X_Character30 VARCHAR2,
121 X_Character31 VARCHAR2,
122 X_Character32 VARCHAR2,
123 X_Character33 VARCHAR2,
124 X_Character34 VARCHAR2,
125 X_Character35 VARCHAR2,
126 X_Character36 VARCHAR2,
127 X_Character37 VARCHAR2,
128 X_Character38 VARCHAR2,
129 X_Character39 VARCHAR2,
130 X_Character40 VARCHAR2,
131 X_Character41 VARCHAR2,
132 X_Character42 VARCHAR2,
133 X_Character43 VARCHAR2,
134 X_Character44 VARCHAR2,
135 X_Character45 VARCHAR2,
136 X_Character46 VARCHAR2,
137 X_Character47 VARCHAR2,
138 X_Character48 VARCHAR2,
139 X_Character49 VARCHAR2,
140 X_Character50 VARCHAR2,
141 X_Character51 VARCHAR2,
142 X_Character52 VARCHAR2,
143 X_Character53 VARCHAR2,
144 X_Character54 VARCHAR2,
145 X_Character55 VARCHAR2,
146 X_Character56 VARCHAR2,
147 X_Character57 VARCHAR2,
148 X_Character58 VARCHAR2,
149 X_Character59 VARCHAR2,
150 X_Character60 VARCHAR2,
151 X_Character61 VARCHAR2,
152 X_Character62 VARCHAR2,
153 X_Character63 VARCHAR2,
154 X_Character64 VARCHAR2,
155 X_Character65 VARCHAR2,
156 X_Character66 VARCHAR2,
157 X_Character67 VARCHAR2,
158 X_Character68 VARCHAR2,
159 X_Character69 VARCHAR2,
160 X_Character70 VARCHAR2,
161 X_Character71 VARCHAR2,
162 X_Character72 VARCHAR2,
163 X_Character73 VARCHAR2,
164 X_Character74 VARCHAR2,
165 X_Character75 VARCHAR2,
166 X_Character76 VARCHAR2,
167 X_Character77 VARCHAR2,
168 X_Character78 VARCHAR2,
169 X_Character79 VARCHAR2,
170 X_Character80 VARCHAR2,
171 X_Character81 VARCHAR2,
172 X_Character82 VARCHAR2,
173 X_Character83 VARCHAR2,
174 X_Character84 VARCHAR2,
175 X_Character85 VARCHAR2,
176 X_Character86 VARCHAR2,
177 X_Character87 VARCHAR2,
178 X_Character88 VARCHAR2,
179 X_Character89 VARCHAR2,
180 X_Character90 VARCHAR2,
181 X_Character91 VARCHAR2,
182 X_Character92 VARCHAR2,
183 X_Character93 VARCHAR2,
184 X_Character94 VARCHAR2,
185 X_Character95 VARCHAR2,
186 X_Character96 VARCHAR2,
187 X_Character97 VARCHAR2,
188 X_Character98 VARCHAR2,
189 X_Character99 VARCHAR2,
190 X_Character100 VARCHAR2,
191 X_Sequence1 VARCHAR2,
192 X_Sequence2 VARCHAR2,
193 X_Sequence3 VARCHAR2,
194 X_Sequence4 VARCHAR2,
195 X_Sequence5 VARCHAR2,
196 X_Sequence6 VARCHAR2,
197 X_Sequence7 VARCHAR2,
198 X_Sequence8 VARCHAR2,
199 X_Sequence9 VARCHAR2,
200 X_Sequence10 VARCHAR2,
201 X_Sequence11 VARCHAR2,
202 X_Sequence12 VARCHAR2,
203 X_Sequence13 VARCHAR2,
204 X_Sequence14 VARCHAR2,
205 X_Sequence15 VARCHAR2,
206 X_Comment1 VARCHAR2,
207 X_Comment2 VARCHAR2,
208 X_Comment3 VARCHAR2,
209 X_Comment4 VARCHAR2,
210 X_Comment5 VARCHAR2,
211 X_Party_Id NUMBER,
212 X_Csi_Instance_Id NUMBER,
213 X_Counter_Id NUMBER,
214 X_Counter_Reading_Id NUMBER,
215 X_Ahl_Mr_Id NUMBER,
216 X_Cs_Incident_Id NUMBER,
217 X_Wip_Rework_Id NUMBER,
218 X_Disposition_Source VARCHAR2,
219 X_Disposition VARCHAR2,
220 X_Disposition_Action VARCHAR2,
221 X_Disposition_Status VARCHAR2,
222 X_Mti_Transaction_Header_Id NUMBER,
223 X_Mti_Transaction_Interface_Id NUMBER,
224 X_Mmt_Transaction_Id NUMBER,
225 X_Wjsi_Group_Id NUMBER,
226 X_Wmti_Group_Id NUMBER,
227 X_Wmt_Transaction_Id NUMBER,
228 X_Rti_Interface_Transaction_Id NUMBER,
229 X_Maintenance_Op_Seq NUMBER,
230 X_Bill_Reference_Id NUMBER,
231 X_Routing_Reference_Id NUMBER,
232 X_To_Subinventory VARCHAR2,
233 X_To_Locator_Id NUMBER,
234 X_Concurrent_Request_Id NUMBER,
235 X_Lot_Status_Id NUMBER,
236 X_Serial_Status_Id NUMBER,
237 X_Nonconformance_Source VARCHAR2,
238 X_Nonconform_Severity VARCHAR2,
239 X_Nonconform_Priority VARCHAR2,
240 X_Nonconformance_Type VARCHAR2,
241 X_Nonconformance_Code VARCHAR2,
242 X_Nonconformance_Status VARCHAR2,
243 X_Date_Opened DATE,
244 X_Date_Closed DATE,
245 X_Days_To_Close NUMBER,
246 X_Rcv_Transaction_Id NUMBER,
247 X_Request_Source VARCHAR2,
248 X_Request_Priority VARCHAR2,
249 X_Request_Severity VARCHAR2,
250 X_Request_Status VARCHAR2,
251 X_Eco_Name VARCHAR2,
252 /* R12 DR Integration. Bug 4345489 Start */
253 X_REPAIR_LINE_ID NUMBER,
254 X_JTF_TASK_ID NUMBER,
255 /* R12 DR Integration. Bug 4345489 End */
256
257 -- R12 OPM Deviations. Bug 4345503 Start
258 X_PROCESS_BATCH_ID NUMBER,
259 X_PROCESS_BATCHSTEP_ID NUMBER,
260 X_PROCESS_OPERATION_ID NUMBER,
261 X_PROCESS_ACTIVITY_ID NUMBER,
262 X_PROCESS_RESOURCE_ID NUMBER,
263 X_PROCESS_PARAMETER_ID NUMBER
264 -- R12 OPM Deviations. Bug 4345503 End
265 );
266
267 --
268 -- Modified the proc signature to include the
269 -- database columns added for ASO support.
270 -- All the new columns are appended after party_id
271 -- rkunchal Thu Jul 25 01:43:48 PDT 2002
272 --
273 --
274 -- See Bug 2588213
275 -- To support the element Maintenance Op Seq Number
276 -- to be used along with Maintenance Workorder
277 -- rkunchal Mon Sep 23 23:46:28 PDT 2002
278 --
279
280 -- Modified the signature to include NCM Hardcode Elements.
281 -- suramasw Thu Oct 31 10:48:59 PST 2002.
282 -- Bug 2449067.
283
284 -- anagarwa Thu Nov 14 14:26:50 PST 2002
285 -- Modified the signature to include CAR Hardcode Elements.
286
290 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
287 -- Modified the following to include new hardcoded element followup activity, transfer license plate number
288 -- saugupta
289
291 X_Collection_Id NUMBER,
292 X_Occurrence NUMBER,
293 X_Qa_Last_Update_Date DATE,
294 X_Qa_Last_Updated_By NUMBER,
295 X_Qa_Creation_Date DATE,
296 X_Qa_Created_By NUMBER,
297 X_Transaction_Number NUMBER,
298 X_Txn_Header_Id NUMBER,
299 X_Organization_Id NUMBER,
300 X_Plan_Id NUMBER,
301 X_Spec_Id NUMBER,
302 X_Transaction_Id NUMBER,
303 X_Department_Id NUMBER,
304 X_To_Department_Id NUMBER,
305 X_Resource_Id NUMBER,
306 X_Quantity NUMBER,
307 X_Item_Id NUMBER,
308 X_Uom VARCHAR2,
309 X_Revision VARCHAR2,
310 X_Subinventory VARCHAR2,
311 X_Locator_Id NUMBER,
312 X_Lot_Number VARCHAR2,
313 X_Serial_Number VARCHAR2,
314 X_Comp_Item_Id NUMBER,
315 X_Comp_Uom VARCHAR2,
316 X_Comp_Revision VARCHAR2,
317 X_Comp_Subinventory VARCHAR2,
318 X_Comp_Locator_Id NUMBER,
319 X_Comp_Lot_Number VARCHAR2,
320 X_Comp_Serial_Number VARCHAR2,
321 X_Wip_Entity_Id NUMBER,
322 X_Line_Id NUMBER,
323 X_To_Op_Seq_Num NUMBER,
324 X_From_Op_Seq_Num NUMBER,
325 X_Vendor_Id NUMBER,
326 X_Receipt_Num VARCHAR2,
327 X_Po_Header_Id NUMBER,
328 X_Po_Line_Num NUMBER,
329 X_Po_Release_Id NUMBER,
330 X_Po_Shipment_Num NUMBER,
331 X_Customer_Id NUMBER,
332 X_So_Header_Id NUMBER,
333 X_Rma_Header_Id NUMBER,
334 X_Transaction_Date DATE,
335 X_Status VARCHAR2,
336 X_Project_Id NUMBER,
337 X_TASK_ID NUMBER ,
338 X_LPN_ID NUMBER,
339 X_XFR_LPN_ID NUMBER,
340 X_Contract_ID NUMBER,
341 X_Contract_Line_ID NUMBER,
342 X_Deliverable_ID NUMBER,
343 X_Asset_Group_ID NUMBER,
344 X_Asset_Number VARCHAR2,
345 X_Asset_Instance_ID NUMBER, --dgupta: R12 EAM Integration. Bug 4345492
346 X_Asset_Activity_ID NUMBER,
347 X_Followup_Activity_ID NUMBER,
348 X_Work_Order_ID NUMBER,
349 X_Character1 VARCHAR2,
350 X_Character2 VARCHAR2,
351 X_Character3 VARCHAR2,
352 X_Character4 VARCHAR2,
353 X_Character5 VARCHAR2,
354 X_Character6 VARCHAR2,
355 X_Character7 VARCHAR2,
356 X_Character8 VARCHAR2,
357 X_Character9 VARCHAR2,
358 X_Character10 VARCHAR2,
359 X_Character11 VARCHAR2,
360 X_Character12 VARCHAR2,
361 X_Character13 VARCHAR2,
362 X_Character14 VARCHAR2,
363 X_Character15 VARCHAR2,
364 X_Character16 VARCHAR2,
365 X_Character17 VARCHAR2,
366 X_Character18 VARCHAR2,
367 X_Character19 VARCHAR2,
368 X_Character20 VARCHAR2,
369 X_Character21 VARCHAR2,
370 X_Character22 VARCHAR2,
371 X_Character23 VARCHAR2,
372 X_Character24 VARCHAR2,
373 X_Character25 VARCHAR2,
374 X_Character26 VARCHAR2,
375 X_Character27 VARCHAR2,
376 X_Character28 VARCHAR2,
380 X_Character32 VARCHAR2,
377 X_Character29 VARCHAR2,
378 X_Character30 VARCHAR2,
379 X_Character31 VARCHAR2,
381 X_Character33 VARCHAR2,
382 X_Character34 VARCHAR2,
383 X_Character35 VARCHAR2,
384 X_Character36 VARCHAR2,
385 X_Character37 VARCHAR2,
386 X_Character38 VARCHAR2,
387 X_Character39 VARCHAR2,
388 X_Character40 VARCHAR2,
389 X_Character41 VARCHAR2,
390 X_Character42 VARCHAR2,
391 X_Character43 VARCHAR2,
392 X_Character44 VARCHAR2,
393 X_Character45 VARCHAR2,
394 X_Character46 VARCHAR2,
395 X_Character47 VARCHAR2,
396 X_Character48 VARCHAR2,
397 X_Character49 VARCHAR2,
398 X_Character50 VARCHAR2,
399 X_Character51 VARCHAR2,
400 X_Character52 VARCHAR2,
401 X_Character53 VARCHAR2,
402 X_Character54 VARCHAR2,
403 X_Character55 VARCHAR2,
404 X_Character56 VARCHAR2,
405 X_Character57 VARCHAR2,
406 X_Character58 VARCHAR2,
407 X_Character59 VARCHAR2,
408 X_Character60 VARCHAR2,
409 X_Character61 VARCHAR2,
410 X_Character62 VARCHAR2,
411 X_Character63 VARCHAR2,
412 X_Character64 VARCHAR2,
413 X_Character65 VARCHAR2,
414 X_Character66 VARCHAR2,
415 X_Character67 VARCHAR2,
416 X_Character68 VARCHAR2,
417 X_Character69 VARCHAR2,
418 X_Character70 VARCHAR2,
419 X_Character71 VARCHAR2,
420 X_Character72 VARCHAR2,
421 X_Character73 VARCHAR2,
422 X_Character74 VARCHAR2,
423 X_Character75 VARCHAR2,
424 X_Character76 VARCHAR2,
425 X_Character77 VARCHAR2,
426 X_Character78 VARCHAR2,
427 X_Character79 VARCHAR2,
428 X_Character80 VARCHAR2,
429 X_Character81 VARCHAR2,
430 X_Character82 VARCHAR2,
431 X_Character83 VARCHAR2,
432 X_Character84 VARCHAR2,
433 X_Character85 VARCHAR2,
434 X_Character86 VARCHAR2,
435 X_Character87 VARCHAR2,
436 X_Character88 VARCHAR2,
437 X_Character89 VARCHAR2,
438 X_Character90 VARCHAR2,
439 X_Character91 VARCHAR2,
440 X_Character92 VARCHAR2,
441 X_Character93 VARCHAR2,
442 X_Character94 VARCHAR2,
443 X_Character95 VARCHAR2,
444 X_Character96 VARCHAR2,
445 X_Character97 VARCHAR2,
446 X_Character98 VARCHAR2,
447 X_Character99 VARCHAR2,
448 X_Character100 VARCHAR2,
449 X_Sequence1 VARCHAR2,
450 X_Sequence2 VARCHAR2,
451 X_Sequence3 VARCHAR2,
452 X_Sequence4 VARCHAR2,
453 X_Sequence5 VARCHAR2,
454 X_Sequence6 VARCHAR2,
455 X_Sequence7 VARCHAR2,
456 X_Sequence8 VARCHAR2,
457 X_Sequence9 VARCHAR2,
458 X_Sequence10 VARCHAR2,
459 X_Sequence11 VARCHAR2,
460 X_Sequence12 VARCHAR2,
461 X_Sequence13 VARCHAR2,
465 X_Comment2 VARCHAR2,
462 X_Sequence14 VARCHAR2,
463 X_Sequence15 VARCHAR2,
464 X_Comment1 VARCHAR2,
466 X_Comment3 VARCHAR2,
467 X_Comment4 VARCHAR2,
468 X_Comment5 VARCHAR2,
469 X_Party_Id NUMBER,
470 X_Csi_Instance_Id NUMBER,
471 X_Counter_Id NUMBER,
472 X_Counter_Reading_Id NUMBER,
473 X_Ahl_Mr_Id NUMBER,
474 X_Cs_Incident_Id NUMBER,
475 X_Wip_Rework_Id NUMBER,
476 X_Disposition_Source VARCHAR2,
477 X_Disposition VARCHAR2,
478 X_Disposition_Action VARCHAR2,
479 X_Disposition_Status VARCHAR2,
480 X_Mti_Transaction_Header_Id NUMBER,
481 X_Mti_Transaction_Interface_Id NUMBER,
482 X_Mmt_Transaction_Id NUMBER,
483 X_Wjsi_Group_Id NUMBER,
484 X_Wmti_Group_Id NUMBER,
485 X_Wmt_Transaction_Id NUMBER,
486 X_Rti_Interface_Transaction_Id NUMBER,
487 X_Maintenance_Op_Seq NUMBER,
488 X_Bill_Reference_Id NUMBER,
489 X_Routing_Reference_Id NUMBER,
490 X_To_Subinventory VARCHAR2,
491 X_To_Locator_Id NUMBER,
492 X_Concurrent_Request_Id NUMBER,
493 X_Lot_Status_Id NUMBER,
494 X_Serial_Status_Id NUMBER,
495 X_Nonconformance_Source VARCHAR2,
496 X_Nonconform_Severity VARCHAR2,
497 X_Nonconform_Priority VARCHAR2,
498 X_Nonconformance_Type VARCHAR2,
499 X_Nonconformance_Code VARCHAR2,
500 X_Nonconformance_Status VARCHAR2,
501 X_Date_Opened DATE,
502 X_Date_Closed DATE,
503 X_Days_To_Close NUMBER,
504 X_Rcv_Transaction_Id NUMBER,
505 X_Request_Source VARCHAR2,
506 X_Request_Priority VARCHAR2,
507 X_Request_Severity VARCHAR2,
508 X_Request_Status VARCHAR2,
509 X_Eco_Name VARCHAR2,
510 /* R12 DR Integration. Bug 4345489 Start */
511 X_REPAIR_LINE_ID NUMBER,
512 X_JTF_TASK_ID NUMBER,
513 /* R12 DR Integration. Bug 4345489 End */
514
515 -- R12 OPM Deviations. Bug 4345503 Start
516 X_PROCESS_BATCH_ID NUMBER,
517 X_PROCESS_BATCHSTEP_ID NUMBER,
518 X_PROCESS_OPERATION_ID NUMBER,
519 X_PROCESS_ACTIVITY_ID NUMBER,
520 X_PROCESS_RESOURCE_ID NUMBER,
521 X_PROCESS_PARAMETER_ID NUMBER
522 -- R12 OPM Deviations. Bug 4345503 End
523 );
524
525 --
526 -- Modified the proc signature to include the
527 -- database columns added for ASO support.
528 -- All the new columns are appended after party_id
529 -- rkunchal Thu Jul 25 01:43:48 PDT 2002
530 --
531 --
532 -- See Bug 2588213
533 -- To support the element Maintenance Op Seq Number
534 -- to be used along with Maintenance Workorder
535 -- rkunchal Mon Sep 23 23:46:28 PDT 2002
536 --
537
538 -- Modified the signature to include NCM Hardcode Elements.
539 -- suramasw Thu Oct 31 10:48:59 PST 2002.
540 -- Bug 2449067.
541
542 -- anagarwa Thu Nov 14 14:26:50 PST 2002
543 -- Modified the signature to include CAR Hardcode Elements.
544
545 -- the following to include new hardcoded element followup activity, transfer license plate number
546 -- saugupta
547
548 PROCEDURE Update_Row(X_Rowid VARCHAR2,
549 X_Collection_Id NUMBER,
550 X_Occurrence NUMBER,
551 X_Last_Update_Date DATE,
552 X_Qa_Last_Update_Date DATE,
553 X_Last_Updated_By NUMBER,
554 X_Qa_Last_Updated_By NUMBER,
555 X_Qa_Creation_Date DATE,
556 X_Qa_Created_By NUMBER,
557 X_Last_Update_Login NUMBER,
558 X_Transaction_Number NUMBER,
559 X_Txn_Header_Id NUMBER,
560 X_Organization_Id NUMBER,
564 X_Department_Id NUMBER,
561 X_Plan_Id NUMBER,
562 X_Spec_Id NUMBER,
563 X_Transaction_Id NUMBER,
565 X_To_Department_Id NUMBER,
566 X_Resource_Id NUMBER,
567 X_Quantity NUMBER,
568 X_Item_Id NUMBER,
569 X_Uom VARCHAR2,
570 X_Revision VARCHAR2,
571 X_Subinventory VARCHAR2,
572 X_Locator_Id NUMBER,
573 X_Lot_Number VARCHAR2,
574 X_Serial_Number VARCHAR2,
575 X_Comp_Item_Id NUMBER,
576 X_Comp_Uom VARCHAR2,
577 X_Comp_Revision VARCHAR2,
578 X_Comp_Subinventory VARCHAR2,
579 X_Comp_Locator_Id NUMBER,
580 X_Comp_Lot_Number VARCHAR2,
581 X_Comp_Serial_Number VARCHAR2,
582 X_Wip_Entity_Id NUMBER,
583 X_Line_Id NUMBER,
584 X_To_Op_Seq_Num NUMBER,
585 X_From_Op_Seq_Num NUMBER,
586 X_Vendor_Id NUMBER,
587 X_Receipt_Num VARCHAR2,
588 X_Po_Header_Id NUMBER,
589 X_Po_Line_Num NUMBER,
590 X_Po_Release_Id NUMBER,
591 X_Po_Shipment_Num NUMBER,
592 X_Customer_Id NUMBER,
593 X_So_Header_Id NUMBER,
594 X_Rma_Header_Id NUMBER,
595 X_Transaction_Date DATE,
596 X_Status VARCHAR2,
597 X_Project_Id NUMBER ,
598 X_Task_Id NUMBER ,
599 X_LPN_ID NUMBER,
600 X_XFR_LPN_ID NUMBER,
601 X_Contract_ID NUMBER,
602 X_Contract_Line_ID NUMBER,
603 X_Deliverable_ID NUMBER,
604 X_Asset_Group_ID NUMBER,
605 X_Asset_Number VARCHAR2,
606 X_Asset_Instance_ID NUMBER, --dgupta: R12 EAM Integration. Bug 4345492
607 X_Asset_Activity_ID NUMBER,
608 X_Followup_Activity_ID NUMBER,
609 X_Work_Order_ID NUMBER,
610 X_Character1 VARCHAR2,
611 X_Character2 VARCHAR2,
612 X_Character3 VARCHAR2,
613 X_Character4 VARCHAR2,
614 X_Character5 VARCHAR2,
615 X_Character6 VARCHAR2,
616 X_Character7 VARCHAR2,
617 X_Character8 VARCHAR2,
618 X_Character9 VARCHAR2,
619 X_Character10 VARCHAR2,
620 X_Character11 VARCHAR2,
621 X_Character12 VARCHAR2,
622 X_Character13 VARCHAR2,
623 X_Character14 VARCHAR2,
624 X_Character15 VARCHAR2,
625 X_Character16 VARCHAR2,
626 X_Character17 VARCHAR2,
627 X_Character18 VARCHAR2,
628 X_Character19 VARCHAR2,
629 X_Character20 VARCHAR2,
630 X_Character21 VARCHAR2,
631 X_Character22 VARCHAR2,
632 X_Character23 VARCHAR2,
633 X_Character24 VARCHAR2,
634 X_Character25 VARCHAR2,
635 X_Character26 VARCHAR2,
636 X_Character27 VARCHAR2,
637 X_Character28 VARCHAR2,
638 X_Character29 VARCHAR2,
639 X_Character30 VARCHAR2,
640 X_Character31 VARCHAR2,
641 X_Character32 VARCHAR2,
642 X_Character33 VARCHAR2,
643 X_Character34 VARCHAR2,
644 X_Character35 VARCHAR2,
645 X_Character36 VARCHAR2,
646 X_Character37 VARCHAR2,
647 X_Character38 VARCHAR2,
648 X_Character39 VARCHAR2,
649 X_Character40 VARCHAR2,
653 X_Character44 VARCHAR2,
650 X_Character41 VARCHAR2,
651 X_Character42 VARCHAR2,
652 X_Character43 VARCHAR2,
654 X_Character45 VARCHAR2,
655 X_Character46 VARCHAR2,
656 X_Character47 VARCHAR2,
657 X_Character48 VARCHAR2,
658 X_Character49 VARCHAR2,
659 X_Character50 VARCHAR2,
660 X_Character51 VARCHAR2,
661 X_Character52 VARCHAR2,
662 X_Character53 VARCHAR2,
663 X_Character54 VARCHAR2,
664 X_Character55 VARCHAR2,
665 X_Character56 VARCHAR2,
666 X_Character57 VARCHAR2,
667 X_Character58 VARCHAR2,
668 X_Character59 VARCHAR2,
669 X_Character60 VARCHAR2,
670 X_Character61 VARCHAR2,
671 X_Character62 VARCHAR2,
672 X_Character63 VARCHAR2,
673 X_Character64 VARCHAR2,
674 X_Character65 VARCHAR2,
675 X_Character66 VARCHAR2,
676 X_Character67 VARCHAR2,
677 X_Character68 VARCHAR2,
678 X_Character69 VARCHAR2,
679 X_Character70 VARCHAR2,
680 X_Character71 VARCHAR2,
681 X_Character72 VARCHAR2,
682 X_Character73 VARCHAR2,
683 X_Character74 VARCHAR2,
684 X_Character75 VARCHAR2,
685 X_Character76 VARCHAR2,
686 X_Character77 VARCHAR2,
687 X_Character78 VARCHAR2,
688 X_Character79 VARCHAR2,
689 X_Character80 VARCHAR2,
690 X_Character81 VARCHAR2,
691 X_Character82 VARCHAR2,
692 X_Character83 VARCHAR2,
693 X_Character84 VARCHAR2,
694 X_Character85 VARCHAR2,
695 X_Character86 VARCHAR2,
696 X_Character87 VARCHAR2,
697 X_Character88 VARCHAR2,
698 X_Character89 VARCHAR2,
699 X_Character90 VARCHAR2,
700 X_Character91 VARCHAR2,
701 X_Character92 VARCHAR2,
702 X_Character93 VARCHAR2,
703 X_Character94 VARCHAR2,
704 X_Character95 VARCHAR2,
705 X_Character96 VARCHAR2,
706 X_Character97 VARCHAR2,
707 X_Character98 VARCHAR2,
708 X_Character99 VARCHAR2,
709 X_Character100 VARCHAR2,
710 X_Sequence1 VARCHAR2,
711 X_Sequence2 VARCHAR2,
712 X_Sequence3 VARCHAR2,
713 X_Sequence4 VARCHAR2,
714 X_Sequence5 VARCHAR2,
715 X_Sequence6 VARCHAR2,
716 X_Sequence7 VARCHAR2,
717 X_Sequence8 VARCHAR2,
718 X_Sequence9 VARCHAR2,
719 X_Sequence10 VARCHAR2,
720 X_Sequence11 VARCHAR2,
721 X_Sequence12 VARCHAR2,
722 X_Sequence13 VARCHAR2,
723 X_Sequence14 VARCHAR2,
724 X_Sequence15 VARCHAR2,
725 X_Comment1 VARCHAR2,
726 X_Comment2 VARCHAR2,
727 X_Comment3 VARCHAR2,
728 X_Comment4 VARCHAR2,
729 X_Comment5 VARCHAR2,
730 X_Party_Id NUMBER,
731 X_Csi_Instance_Id NUMBER,
732 X_Counter_Id NUMBER,
733 X_Counter_Reading_Id NUMBER,
737 X_Disposition_Source VARCHAR2,
734 X_Ahl_Mr_Id NUMBER,
735 X_Cs_Incident_Id NUMBER,
736 X_Wip_Rework_Id NUMBER,
738 X_Disposition VARCHAR2,
739 X_Disposition_Action VARCHAR2,
740 X_Disposition_Status VARCHAR2,
741 X_Mti_Transaction_Header_Id NUMBER,
742 X_Mti_Transaction_Interface_Id NUMBER,
743 X_Mmt_Transaction_Id NUMBER,
744 X_Wjsi_Group_Id NUMBER,
745 X_Wmti_Group_Id NUMBER,
746 X_Wmt_Transaction_Id NUMBER,
747 X_Rti_Interface_Transaction_Id NUMBER,
748 X_Maintenance_Op_Seq NUMBER,
749 X_Bill_Reference_Id NUMBER,
750 X_Routing_Reference_Id NUMBER,
751 X_To_Subinventory VARCHAR2,
752 X_To_Locator_Id NUMBER,
753 X_Concurrent_Request_Id NUMBER,
754 X_Lot_Status_Id NUMBER,
755 X_Serial_Status_Id NUMBER,
756 X_Nonconformance_Source VARCHAR2,
757 X_Nonconform_Severity VARCHAR2,
758 X_Nonconform_Priority VARCHAR2,
762 X_Date_Opened DATE,
759 X_Nonconformance_Type VARCHAR2,
760 X_Nonconformance_Code VARCHAR2,
761 X_Nonconformance_Status VARCHAR2,
763 X_Date_Closed DATE,
764 X_Days_To_Close NUMBER,
765 X_Rcv_Transaction_Id NUMBER,
766 X_Request_Source VARCHAR2,
767 X_Request_Priority VARCHAR2,
768 X_Request_Severity VARCHAR2,
769 X_Request_Status VARCHAR2,
770 X_Eco_Name VARCHAR2,
771 /* R12 DR Integration. Bug 4345489 Start */
772 X_REPAIR_LINE_ID NUMBER,
773 X_JTF_TASK_ID NUMBER,
774 /* R12 DR Integration. Bug 4345489 End */
775 -- R12 OPM Deviations. Bug 4345503 Start
776 X_PROCESS_BATCH_ID NUMBER,
777 X_PROCESS_BATCHSTEP_ID NUMBER,
778 X_PROCESS_OPERATION_ID NUMBER,
779 X_PROCESS_ACTIVITY_ID NUMBER,
780 X_PROCESS_RESOURCE_ID NUMBER,
781 X_PROCESS_PARAMETER_ID NUMBER
782 -- R12 OPM Deviations. Bug 4345503 End
783 );
784 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
785
786 END QA_RESULTS_PKG;
|
|
|