APPS.CS_SR_DUP_CHK_PVT_W dependencies on CS_SR_DUP_CHK_PVT

Line 1: package body cs_sr_dup_chk_pvt_w as

1: package body cs_sr_dup_chk_pvt_w as
2: /* $Header: csdupwb.pls 120.0 2011/12/16 11:47:11 shramana noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: ) as
20: ddindx binary_integer; indx binary_integer;

Line 39: procedure rosetta_table_copy_out_p1(t cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 out nocopy JTF_NUMBER_TABLE

35: end loop;
36: end if;
37: end if;
38: end rosetta_table_copy_in_p1;
39: procedure rosetta_table_copy_out_p1(t cs_sr_dup_chk_pvt.cs_extended_attr_tbl, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_VARCHAR2_TABLE_100
41: , a2 out nocopy JTF_VARCHAR2_TABLE_100
42: ) as
43: ddindx binary_integer; indx binary_integer;

Line 73: procedure rosetta_table_copy_in_p3(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 JTF_NUMBER_TABLE

69: end if;
70: end if;
71: end rosetta_table_copy_out_p1;
72:
73: procedure rosetta_table_copy_in_p3(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_2000
75: ) as
76: ddindx binary_integer; indx binary_integer;
77: begin

Line 94: procedure rosetta_table_copy_out_p3(t cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 out nocopy JTF_NUMBER_TABLE

90: end loop;
91: end if;
92: end if;
93: end rosetta_table_copy_in_p3;
94: procedure rosetta_table_copy_out_p3(t cs_sr_dup_chk_pvt.sr_dupl_tbl, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
96: ) as
97: ddindx binary_integer; indx binary_integer;
98: begin

Line 123: procedure rosetta_table_copy_in_p5(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 JTF_NUMBER_TABLE

119: end if;
120: end if;
121: end rosetta_table_copy_out_p3;
122:
123: procedure rosetta_table_copy_in_p5(t out nocopy cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 JTF_NUMBER_TABLE
124: , a1 JTF_NUMBER_TABLE
125: , a2 JTF_NUMBER_TABLE
126: , a3 JTF_VARCHAR2_TABLE_2000
127: ) as

Line 148: procedure rosetta_table_copy_out_p5(t cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 out nocopy JTF_NUMBER_TABLE

144: end loop;
145: end if;
146: end if;
147: end rosetta_table_copy_in_p5;
148: procedure rosetta_table_copy_out_p5(t cs_sr_dup_chk_pvt.sr_dupl_link_tbl, a0 out nocopy JTF_NUMBER_TABLE
149: , a1 out nocopy JTF_NUMBER_TABLE
150: , a2 out nocopy JTF_NUMBER_TABLE
151: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
152: ) as

Line 219: ddp_cs_extended_attr cs_sr_dup_chk_pvt.cs_extended_attr_tbl;

215: , x_msg_data out nocopy VARCHAR2
216: )
217:
218: as
219: ddp_cs_extended_attr cs_sr_dup_chk_pvt.cs_extended_attr_tbl;
220: ddp_incident_address cs_sr_dup_chk_pvt.cs_incident_address_rec;
221: ddx_sr_dupl_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
222: ddindx binary_integer; indx binary_integer;
223: begin

Line 220: ddp_incident_address cs_sr_dup_chk_pvt.cs_incident_address_rec;

216: )
217:
218: as
219: ddp_cs_extended_attr cs_sr_dup_chk_pvt.cs_extended_attr_tbl;
220: ddp_incident_address cs_sr_dup_chk_pvt.cs_incident_address_rec;
221: ddx_sr_dupl_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
222: ddindx binary_integer; indx binary_integer;
223: begin
224:

Line 221: ddx_sr_dupl_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;

217:
218: as
219: ddp_cs_extended_attr cs_sr_dup_chk_pvt.cs_extended_attr_tbl;
220: ddp_incident_address cs_sr_dup_chk_pvt.cs_incident_address_rec;
221: ddx_sr_dupl_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
222: ddindx binary_integer; indx binary_integer;
223: begin
224:
225: -- copy data to the local IN or IN-OUT args, if any

Line 238: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p1(ddp_cs_extended_attr, p12_a0

234:
235:
236:
237:
238: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p1(ddp_cs_extended_attr, p12_a0
239: , p12_a1
240: , p12_a2
241: );
242:

Line 258: cs_sr_dup_chk_pvt.duplicate_check(p_api_version,

254:
255:
256:
257: -- here's the delegated call to the old PL/SQL routine
258: cs_sr_dup_chk_pvt.duplicate_check(p_api_version,
259: p_init_msg_list,
260: p_commit,
261: p_validation_level,
262: p_incident_id,

Line 295: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p3(ddx_sr_dupl_rec, p15_a0

291:
292:
293:
294:
295: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p3(ddx_sr_dupl_rec, p15_a0
296: , p15_a1
297: );
298:
299:

Line 325: ddp_cs_extended_attr cs_sr_dup_chk_pvt.cs_extended_attr_tbl;

321: , p_return_status out nocopy VARCHAR2
322: )
323:
324: as
325: ddp_cs_extended_attr cs_sr_dup_chk_pvt.cs_extended_attr_tbl;
326: ddp_incident_address cs_sr_dup_chk_pvt.cs_incident_address_rec;
327: ddp_cs_ea_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
328: ddindx binary_integer; indx binary_integer;
329: begin

Line 326: ddp_incident_address cs_sr_dup_chk_pvt.cs_incident_address_rec;

322: )
323:
324: as
325: ddp_cs_extended_attr cs_sr_dup_chk_pvt.cs_extended_attr_tbl;
326: ddp_incident_address cs_sr_dup_chk_pvt.cs_incident_address_rec;
327: ddp_cs_ea_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
328: ddindx binary_integer; indx binary_integer;
329: begin
330:

Line 327: ddp_cs_ea_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;

323:
324: as
325: ddp_cs_extended_attr cs_sr_dup_chk_pvt.cs_extended_attr_tbl;
326: ddp_incident_address cs_sr_dup_chk_pvt.cs_incident_address_rec;
327: ddp_cs_ea_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
328: ddindx binary_integer; indx binary_integer;
329: begin
330:
331: -- copy data to the local IN or IN-OUT args, if any

Line 334: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p1(ddp_cs_extended_attr, p2_a0

330:
331: -- copy data to the local IN or IN-OUT args, if any
332:
333:
334: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p1(ddp_cs_extended_attr, p2_a0
335: , p2_a1
336: , p2_a2
337: );
338:

Line 353: cs_sr_dup_chk_pvt.check_ea_duplicate_setup(p_incident_id,

349:
350:
351:
352: -- here's the delegated call to the old PL/SQL routine
353: cs_sr_dup_chk_pvt.check_ea_duplicate_setup(p_incident_id,
354: p_incident_type_id,
355: ddp_cs_extended_attr,
356: ddp_incident_address,
357: p_ea_attr_dup_flag,

Line 369: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p3(ddp_cs_ea_dup_rec, p5_a0

365:
366:
367:
368:
369: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p3(ddp_cs_ea_dup_rec, p5_a0
370: , p5_a1
371: );
372:
373:

Line 398: ddp_cs_extended_attr cs_sr_dup_chk_pvt.cs_extended_attr_tbl;

394: , p_return_status out nocopy VARCHAR2
395: )
396:
397: as
398: ddp_cs_extended_attr cs_sr_dup_chk_pvt.cs_extended_attr_tbl;
399: ddp_incident_address cs_sr_dup_chk_pvt.cs_incident_address_rec;
400: ddp_cs_ea_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
401: ddindx binary_integer; indx binary_integer;
402: begin

Line 399: ddp_incident_address cs_sr_dup_chk_pvt.cs_incident_address_rec;

395: )
396:
397: as
398: ddp_cs_extended_attr cs_sr_dup_chk_pvt.cs_extended_attr_tbl;
399: ddp_incident_address cs_sr_dup_chk_pvt.cs_incident_address_rec;
400: ddp_cs_ea_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
401: ddindx binary_integer; indx binary_integer;
402: begin
403:

Line 400: ddp_cs_ea_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;

396:
397: as
398: ddp_cs_extended_attr cs_sr_dup_chk_pvt.cs_extended_attr_tbl;
399: ddp_incident_address cs_sr_dup_chk_pvt.cs_incident_address_rec;
400: ddp_cs_ea_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
401: ddindx binary_integer; indx binary_integer;
402: begin
403:
404: -- copy data to the local IN or IN-OUT args, if any

Line 407: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p1(ddp_cs_extended_attr, p2_a0

403:
404: -- copy data to the local IN or IN-OUT args, if any
405:
406:
407: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p1(ddp_cs_extended_attr, p2_a0
408: , p2_a1
409: , p2_a2
410: );
411:

Line 426: cs_sr_dup_chk_pvt.perform_ea_duplicate(p_incident_id,

422:
423:
424:
425: -- here's the delegated call to the old PL/SQL routine
426: cs_sr_dup_chk_pvt.perform_ea_duplicate(p_incident_id,
427: p_incident_type_id,
428: ddp_cs_extended_attr,
429: ddp_incident_address,
430: p_ea_attr_dup_flag,

Line 442: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p3(ddp_cs_ea_dup_rec, p5_a0

438:
439:
440:
441:
442: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p3(ddp_cs_ea_dup_rec, p5_a0
443: , p5_a1
444: );
445:
446:

Line 465: ddp_cs_sr_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;

461: , p_return_status out nocopy VARCHAR2
462: )
463:
464: as
465: ddp_cs_sr_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
466: ddindx binary_integer; indx binary_integer;
467: begin
468:
469: -- copy data to the local IN or IN-OUT args, if any

Line 477: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p3(ddp_cs_sr_dup_rec, p7_a0

473:
474:
475:
476:
477: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p3(ddp_cs_sr_dup_rec, p7_a0
478: , p7_a1
479: );
480:
481:

Line 485: cs_sr_dup_chk_pvt.perform_dup_on_sr_field(p_customer_product_id,

481:
482:
483:
484: -- here's the delegated call to the old PL/SQL routine
485: cs_sr_dup_chk_pvt.perform_dup_on_sr_field(p_customer_product_id,
486: p_customer_id,
487: p_inventory_item_id,
488: p_instance_serial_number,
489: p_current_serial_number,

Line 505: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p3(ddp_cs_sr_dup_rec, p7_a0

501:
502:
503:
504:
505: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p3(ddp_cs_sr_dup_rec, p7_a0
506: , p7_a1
507: );
508:
509:

Line 524: ddp_cs_sr_dup_link_rec cs_sr_dup_chk_pvt.sr_dupl_link_tbl;

520: , p_return_status out nocopy VARCHAR2
521: )
522:
523: as
524: ddp_cs_sr_dup_link_rec cs_sr_dup_chk_pvt.sr_dupl_link_tbl;
525: ddindx binary_integer; indx binary_integer;
526: begin
527:
528: -- copy data to the local IN or IN-OUT args, if any

Line 531: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p5(ddp_cs_sr_dup_link_rec, p2_a0

527:
528: -- copy data to the local IN or IN-OUT args, if any
529:
530:
531: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p5(ddp_cs_sr_dup_link_rec, p2_a0
532: , p2_a1
533: , p2_a2
534: , p2_a3
535: );

Line 540: cs_sr_dup_chk_pvt.check_sr_instance_dup(p_customer_product_id,

536:
537:
538:
539: -- here's the delegated call to the old PL/SQL routine
540: cs_sr_dup_chk_pvt.check_sr_instance_dup(p_customer_product_id,
541: p_incident_id,
542: ddp_cs_sr_dup_link_rec,
543: p_cs_sr_dup_flag,
544: p_return_status);

Line 549: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p5(ddp_cs_sr_dup_link_rec, p2_a0

545:
546: -- copy data back from the local variables to OUT or IN-OUT args, if any
547:
548:
549: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p5(ddp_cs_sr_dup_link_rec, p2_a0
550: , p2_a1
551: , p2_a2
552: , p2_a3
553: );

Line 571: ddp_cs_sr_dup_link_rec cs_sr_dup_chk_pvt.sr_dupl_link_tbl;

567: , p_return_status out nocopy VARCHAR2
568: )
569:
570: as
571: ddp_cs_sr_dup_link_rec cs_sr_dup_chk_pvt.sr_dupl_link_tbl;
572: ddindx binary_integer; indx binary_integer;
573: begin
574:
575: -- copy data to the local IN or IN-OUT args, if any

Line 580: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p5(ddp_cs_sr_dup_link_rec, p4_a0

576:
577:
578:
579:
580: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p5(ddp_cs_sr_dup_link_rec, p4_a0
581: , p4_a1
582: , p4_a2
583: , p4_a3
584: );

Line 589: cs_sr_dup_chk_pvt.check_sr_serialnum_dup(p_instance_serial_number,

585:
586:
587:
588: -- here's the delegated call to the old PL/SQL routine
589: cs_sr_dup_chk_pvt.check_sr_serialnum_dup(p_instance_serial_number,
590: p_current_serial_number,
591: p_inv_item_serial_number,
592: p_incident_id,
593: ddp_cs_sr_dup_link_rec,

Line 602: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p5(ddp_cs_sr_dup_link_rec, p4_a0

598:
599:
600:
601:
602: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p5(ddp_cs_sr_dup_link_rec, p4_a0
603: , p4_a1
604: , p4_a2
605: , p4_a3
606: );

Line 623: ddp_cs_sr_dup_link_rec cs_sr_dup_chk_pvt.sr_dupl_link_tbl;

619: , p_return_status out nocopy VARCHAR2
620: )
621:
622: as
623: ddp_cs_sr_dup_link_rec cs_sr_dup_chk_pvt.sr_dupl_link_tbl;
624: ddindx binary_integer; indx binary_integer;
625: begin
626:
627: -- copy data to the local IN or IN-OUT args, if any

Line 631: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p5(ddp_cs_sr_dup_link_rec, p3_a0

627: -- copy data to the local IN or IN-OUT args, if any
628:
629:
630:
631: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p5(ddp_cs_sr_dup_link_rec, p3_a0
632: , p3_a1
633: , p3_a2
634: , p3_a3
635: );

Line 640: cs_sr_dup_chk_pvt.check_sr_custprod_dup(p_customer_id,

636:
637:
638:
639: -- here's the delegated call to the old PL/SQL routine
640: cs_sr_dup_chk_pvt.check_sr_custprod_dup(p_customer_id,
641: p_inventory_item_id,
642: p_incident_id,
643: ddp_cs_sr_dup_link_rec,
644: p_cs_sr_dup_flag,

Line 651: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p5(ddp_cs_sr_dup_link_rec, p3_a0

647: -- copy data back from the local variables to OUT or IN-OUT args, if any
648:
649:
650:
651: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p5(ddp_cs_sr_dup_link_rec, p3_a0
652: , p3_a1
653: , p3_a2
654: , p3_a3
655: );

Line 675: ddp_cs_sr_dup_link_rec cs_sr_dup_chk_pvt.sr_dupl_link_tbl;

671: , p_return_status out nocopy VARCHAR2
672: )
673:
674: as
675: ddp_cs_sr_dup_link_rec cs_sr_dup_chk_pvt.sr_dupl_link_tbl;
676: ddindx binary_integer; indx binary_integer;
677: begin
678:
679: -- copy data to the local IN or IN-OUT args, if any

Line 686: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p5(ddp_cs_sr_dup_link_rec, p6_a0

682:
683:
684:
685:
686: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p5(ddp_cs_sr_dup_link_rec, p6_a0
687: , p6_a1
688: , p6_a2
689: , p6_a3
690: );

Line 695: cs_sr_dup_chk_pvt.check_sr_custprodserial_dup(p_customer_id,

691:
692:
693:
694: -- here's the delegated call to the old PL/SQL routine
695: cs_sr_dup_chk_pvt.check_sr_custprodserial_dup(p_customer_id,
696: p_inventory_item_id,
697: p_instance_serial_number,
698: p_current_serial_number,
699: p_inv_item_serial_number,

Line 712: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p5(ddp_cs_sr_dup_link_rec, p6_a0

708:
709:
710:
711:
712: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p5(ddp_cs_sr_dup_link_rec, p6_a0
713: , p6_a1
714: , p6_a2
715: , p6_a3
716: );

Line 737: ddp_cs_ea_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;

733: , p_return_status out nocopy VARCHAR2
734: )
735:
736: as
737: ddp_cs_ea_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
738: ddp_cs_sr_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
739: ddp_sr_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
740: ddindx binary_integer; indx binary_integer;
741: begin

Line 738: ddp_cs_sr_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;

734: )
735:
736: as
737: ddp_cs_ea_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
738: ddp_cs_sr_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
739: ddp_sr_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
740: ddindx binary_integer; indx binary_integer;
741: begin
742:

Line 739: ddp_sr_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;

735:
736: as
737: ddp_cs_ea_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
738: ddp_cs_sr_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
739: ddp_sr_dup_rec cs_sr_dup_chk_pvt.sr_dupl_tbl;
740: ddindx binary_integer; indx binary_integer;
741: begin
742:
743: -- copy data to the local IN or IN-OUT args, if any

Line 744: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p3(ddp_cs_ea_dup_rec, p0_a0

740: ddindx binary_integer; indx binary_integer;
741: begin
742:
743: -- copy data to the local IN or IN-OUT args, if any
744: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p3(ddp_cs_ea_dup_rec, p0_a0
745: , p0_a1
746: );
747:
748:

Line 749: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p3(ddp_cs_sr_dup_rec, p2_a0

745: , p0_a1
746: );
747:
748:
749: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p3(ddp_cs_sr_dup_rec, p2_a0
750: , p2_a1
751: );
752:
753:

Line 757: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p3(ddp_sr_dup_rec, p7_a0

753:
754:
755:
756:
757: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p3(ddp_sr_dup_rec, p7_a0
758: , p7_a1
759: );
760:
761:

Line 764: cs_sr_dup_chk_pvt.construct_unique_list_dup_sr(ddp_cs_ea_dup_rec,

760:
761:
762:
763: -- here's the delegated call to the old PL/SQL routine
764: cs_sr_dup_chk_pvt.construct_unique_list_dup_sr(ddp_cs_ea_dup_rec,
765: p_ea_attr_dup_flag,
766: ddp_cs_sr_dup_rec,
767: p_cs_sr_dup_flag,
768: p_dup_from,

Line 783: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p3(ddp_sr_dup_rec, p7_a0

779:
780:
781:
782:
783: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p3(ddp_sr_dup_rec, p7_a0
784: , p7_a1
785: );
786:
787:

Line 800: ddp_dup_found_tbl cs_sr_dup_chk_pvt.sr_dupl_link_tbl;

796: , p_return_status out nocopy VARCHAR2
797: )
798:
799: as
800: ddp_dup_found_tbl cs_sr_dup_chk_pvt.sr_dupl_link_tbl;
801: ddp_dup_tbl cs_sr_dup_chk_pvt.sr_dupl_tbl;
802: ddindx binary_integer; indx binary_integer;
803: begin
804:

Line 801: ddp_dup_tbl cs_sr_dup_chk_pvt.sr_dupl_tbl;

797: )
798:
799: as
800: ddp_dup_found_tbl cs_sr_dup_chk_pvt.sr_dupl_link_tbl;
801: ddp_dup_tbl cs_sr_dup_chk_pvt.sr_dupl_tbl;
802: ddindx binary_integer; indx binary_integer;
803: begin
804:
805: -- copy data to the local IN or IN-OUT args, if any

Line 806: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p5(ddp_dup_found_tbl, p0_a0

802: ddindx binary_integer; indx binary_integer;
803: begin
804:
805: -- copy data to the local IN or IN-OUT args, if any
806: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p5(ddp_dup_found_tbl, p0_a0
807: , p0_a1
808: , p0_a2
809: , p0_a3
810: );

Line 812: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p3(ddp_dup_tbl, p1_a0

808: , p0_a2
809: , p0_a3
810: );
811:
812: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p3(ddp_dup_tbl, p1_a0
813: , p1_a1
814: );
815:
816:

Line 818: cs_sr_dup_chk_pvt.check_dup_sr_link(ddp_dup_found_tbl,

814: );
815:
816:
817: -- here's the delegated call to the old PL/SQL routine
818: cs_sr_dup_chk_pvt.check_dup_sr_link(ddp_dup_found_tbl,
819: ddp_dup_tbl,
820: p_return_status);
821:
822: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 824: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p3(ddp_dup_tbl, p1_a0

820: p_return_status);
821:
822: -- copy data back from the local variables to OUT or IN-OUT args, if any
823:
824: cs_sr_dup_chk_pvt_w.rosetta_table_copy_out_p3(ddp_dup_tbl, p1_a0
825: , p1_a1
826: );
827:
828: end;

Line 836: ddp_dup_tbl cs_sr_dup_chk_pvt.sr_dupl_tbl;

832: , p_sr_link_id NUMBER
833: ) return varchar2
834:
835: as
836: ddp_dup_tbl cs_sr_dup_chk_pvt.sr_dupl_tbl;
837: ddindx binary_integer; indx binary_integer;
838: ddrosetta_retval varchar2(4000);
839: begin
840:

Line 842: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p3(ddp_dup_tbl, p0_a0

838: ddrosetta_retval varchar2(4000);
839: begin
840:
841: -- copy data to the local IN or IN-OUT args, if any
842: cs_sr_dup_chk_pvt_w.rosetta_table_copy_in_p3(ddp_dup_tbl, p0_a0
843: , p0_a1
844: );
845:
846:

Line 848: ddrosetta_retval := cs_sr_dup_chk_pvt.check_if_already_in_list(ddp_dup_tbl,

844: );
845:
846:
847: -- here's the delegated call to the old PL/SQL routine
848: ddrosetta_retval := cs_sr_dup_chk_pvt.check_if_already_in_list(ddp_dup_tbl,
849: p_sr_link_id);
850:
851: -- copy data back from the local variables to OUT or IN-OUT args, if any
852:

Line 857: end cs_sr_dup_chk_pvt_w;

853:
854: return ddrosetta_retval;
855: end;
856:
857: end cs_sr_dup_chk_pvt_w;