1: package body amw_scope_pvt_w as
2: /* $Header: amwwscpb.pls 120.0 2005/05/31 21:35:35 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy amw_scope_pvt.sub_tbl_type, a0 JTF_VARCHAR2_TABLE_200
4: ) as
5: ddindx binary_integer; indx binary_integer;
355:
356:
357:
358:
359: amw_scope_pvt_w.rosetta_table_copy_in_p1(ddp_subsidiary_tbl, p8_a0
360: );
361:
362: amw_scope_pvt_w.rosetta_table_copy_in_p5(ddp_lob_tbl, p9_a0
363: );
358:
359: amw_scope_pvt_w.rosetta_table_copy_in_p1(ddp_subsidiary_tbl, p8_a0
360: );
361:
362: amw_scope_pvt_w.rosetta_table_copy_in_p5(ddp_lob_tbl, p9_a0
363: );
364:
365: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_tbl, p10_a0
366: );
361:
362: amw_scope_pvt_w.rosetta_table_copy_in_p5(ddp_lob_tbl, p9_a0
363: );
364:
365: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_tbl, p10_a0
366: );
367:
368: amw_scope_pvt_w.rosetta_table_copy_in_p11(ddp_process_tbl, p11_a0
369: );
364:
365: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_tbl, p10_a0
366: );
367:
368: amw_scope_pvt_w.rosetta_table_copy_in_p11(ddp_process_tbl, p11_a0
369: );
370:
371:
372:
415: ddindx binary_integer; indx binary_integer;
416: begin
417:
418: -- copy data to the local IN or IN-OUT args, if any
419: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_tbl, p0_a0
420: );
421:
422:
423:
445:
446: -- copy data to the local IN or IN-OUT args, if any
447:
448:
449: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_tbl, p2_a0
450: );
451:
452:
453: -- here's the delegated call to the old PL/SQL routine
459: -- copy data back from the local variables to OUT or IN-OUT args, if any
460:
461:
462:
463: amw_scope_pvt_w.rosetta_table_copy_out_p9(ddp_org_new_tbl, p3_a0
464: );
465: end;
466:
467: procedure generate_subsidiary_list(p_entity_id NUMBER
481:
482: -- copy data to the local IN or IN-OUT args, if any
483:
484:
485: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_new_tbl, p2_a0
486: );
487:
488: amw_scope_pvt_w.rosetta_table_copy_in_p1(ddp_subsidiary_tbl, p3_a0
489: );
484:
485: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_new_tbl, p2_a0
486: );
487:
488: amw_scope_pvt_w.rosetta_table_copy_in_p1(ddp_subsidiary_tbl, p3_a0
489: );
490:
491:
492:
503:
504:
505:
506:
507: amw_scope_pvt_w.rosetta_table_copy_out_p3(ddp_sub_new_tbl, p5_a0
508: );
509: end;
510:
511: procedure generate_lob_list(p_entity_id NUMBER
528:
529: -- copy data to the local IN or IN-OUT args, if any
530:
531:
532: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_new_tbl, p2_a0
533: );
534:
535: amw_scope_pvt_w.rosetta_table_copy_in_p1(ddp_subsidiary_tbl, p3_a0
536: );
531:
532: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_new_tbl, p2_a0
533: );
534:
535: amw_scope_pvt_w.rosetta_table_copy_in_p1(ddp_subsidiary_tbl, p3_a0
536: );
537:
538:
539: amw_scope_pvt_w.rosetta_table_copy_in_p5(ddp_lob_tbl, p5_a0
535: amw_scope_pvt_w.rosetta_table_copy_in_p1(ddp_subsidiary_tbl, p3_a0
536: );
537:
538:
539: amw_scope_pvt_w.rosetta_table_copy_in_p5(ddp_lob_tbl, p5_a0
540: );
541:
542:
543:
558:
559:
560:
561:
562: amw_scope_pvt_w.rosetta_table_copy_out_p7(ddp_lob_new_tbl, p7_a0
563: );
564: end;
565:
566: procedure populate_process_hierarchy(p_api_version_number NUMBER
588:
589:
590:
591:
592: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_tbl, p6_a0
593: );
594:
595: amw_scope_pvt_w.rosetta_table_copy_in_p11(ddp_process_tbl, p7_a0
596: );
591:
592: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_tbl, p6_a0
593: );
594:
595: amw_scope_pvt_w.rosetta_table_copy_in_p11(ddp_process_tbl, p7_a0
596: );
597:
598:
599:
639:
640: -- copy data to the local IN or IN-OUT args, if any
641:
642:
643: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_tbl, p2_a0
644: );
645:
646: amw_scope_pvt_w.rosetta_table_copy_in_p11(ddp_process_tbl, p3_a0
647: );
642:
643: amw_scope_pvt_w.rosetta_table_copy_in_p9(ddp_org_tbl, p2_a0
644: );
645:
646: amw_scope_pvt_w.rosetta_table_copy_in_p11(ddp_process_tbl, p3_a0
647: );
648:
649:
650: -- here's the delegated call to the old PL/SQL routine
689:
690:
691:
692:
693: amw_scope_pvt_w.rosetta_table_copy_in_p13(ddp_proc_hier_tbl, p7_a0
694: , p7_a1
695: , p7_a2
696: , p7_a3
697: );
724:
725:
726: end;
727:
728: end amw_scope_pvt_w;