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');
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:
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:
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:
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:
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:
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:
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:
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:
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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: );
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:
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:
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:
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:
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: );
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:
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;
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:
853:
854: return ddrosetta_retval;
855: end;
856:
857: end cs_sr_dup_chk_pvt_w;