[Home] [Help]
1: package body eam_pmdef_pub_w as
2: /* $Header: EAMWPMDB.pls 120.2 2005/10/14 12:11:19 hkarmach noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy eam_pmdef_pub.pm_activities_grp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
540: ddp_pm_schedule_rec.eam_last_cyclic_act := p7_a45;
541: ddp_pm_schedule_rec.maintenance_object_id := p7_a46;
542: ddp_pm_schedule_rec.maintenance_object_type := p7_a47;
543:
544: eam_pmdef_pub_w.rosetta_table_copy_in_p2(ddp_pm_activities_tbl, p8_a0
545: , p8_a1
546: , p8_a2
547: , p8_a3
548: , p8_a4
549: , p8_a5
550: , p8_a6
551: );
552:
553: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_day_interval_rules_tbl, p9_a0
554: , p9_a1
555: , p9_a2
556: , p9_a3
557: , p9_a4
564: , p9_a11
565: , p9_a12
566: );
567:
568: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_runtime_rules_tbl, p10_a0
569: , p10_a1
570: , p10_a2
571: , p10_a3
572: , p10_a4
579: , p10_a11
580: , p10_a12
581: );
582:
583: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_list_date_rules_tbl, p11_a0
584: , p11_a1
585: , p11_a2
586: , p11_a3
587: , p11_a4
794: ddp_pm_schedule_rec.eam_last_cyclic_act := p7_a45;
795: ddp_pm_schedule_rec.maintenance_object_id := p7_a46;
796: ddp_pm_schedule_rec.maintenance_object_type := p7_a47;
797:
798: eam_pmdef_pub_w.rosetta_table_copy_in_p2(ddp_pm_activities_tbl, p8_a0
799: , p8_a1
800: , p8_a2
801: , p8_a3
802: , p8_a4
803: , p8_a5
804: , p8_a6
805: );
806:
807: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_day_interval_rules_tbl, p9_a0
808: , p9_a1
809: , p9_a2
810: , p9_a3
811: , p9_a4
818: , p9_a11
819: , p9_a12
820: );
821:
822: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_runtime_rules_tbl, p10_a0
823: , p10_a1
824: , p10_a2
825: , p10_a3
826: , p10_a4
833: , p10_a11
834: , p10_a12
835: );
836:
837: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_list_date_rules_tbl, p11_a0
838: , p11_a1
839: , p11_a2
840: , p11_a3
841: , p11_a4
1182: ddrosetta_retval boolean;
1183: begin
1184:
1185: -- copy data to the local IN or IN-OUT args, if any
1186: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_rules_tbl, p0_a0
1187: , p0_a1
1188: , p0_a2
1189: , p0_a3
1190: , p0_a4
1236: ddrosetta_retval boolean;
1237: begin
1238:
1239: -- copy data to the local IN or IN-OUT args, if any
1240: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_rules_tbl, p0_a0
1241: , p0_a1
1242: , p0_a2
1243: , p0_a3
1244: , p0_a4
1290: ddrosetta_retval boolean;
1291: begin
1292:
1293: -- copy data to the local IN or IN-OUT args, if any
1294: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_rules_tbl, p0_a0
1295: , p0_a1
1296: , p0_a2
1297: , p0_a3
1298: , p0_a4
1470: ddp_pm_schedule_rec.eam_last_cyclic_act := p0_a45;
1471: ddp_pm_schedule_rec.maintenance_object_id := p0_a46;
1472: ddp_pm_schedule_rec.maintenance_object_type := p0_a47;
1473:
1474: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_day_interval_rules_tbl, p1_a0
1475: , p1_a1
1476: , p1_a2
1477: , p1_a3
1478: , p1_a4
1485: , p1_a11
1486: , p1_a12
1487: );
1488:
1489: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_runtime_rules_tbl, p2_a0
1490: , p2_a1
1491: , p2_a2
1492: , p2_a3
1493: , p2_a4
1500: , p2_a11
1501: , p2_a12
1502: );
1503:
1504: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_list_date_rules_tbl, p3_a0
1505: , p3_a1
1506: , p3_a2
1507: , p3_a3
1508: , p3_a4
1627: ddp_pm_activity_grp_rec.day_tolerance := p0_a4;
1628: ddp_pm_activity_grp_rec.next_service_start_date := p0_a5;
1629: ddp_pm_activity_grp_rec.next_service_end_date := p0_a6;
1630:
1631: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_runtime_rules_tbl, p1_a0
1632: , p1_a1
1633: , p1_a2
1634: , p1_a3
1635: , p1_a4
1938: l_activities varchar2(80);
1939: begin
1940:
1941: -- copy data to the local IN or IN-OUT args, if any
1942: eam_pmdef_pub_w.rosetta_table_copy_in_p2(ddp_pm_activities_grp_tbl, p0_a0
1943: , p0_a1
1944: , p0_a2
1945: , p0_a3
1946: , p0_a4
1947: , p0_a5
1948: , p0_a6
1949: );
1950:
1951: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_pm_runtime_rules_tbl, p1_a0
1952: , p1_a1
1953: , p1_a2
1954: , p1_a3
1955: , p1_a4
2050: ddindx binary_integer; indx binary_integer;
2051: begin
2052:
2053: -- copy data to the local IN or IN-OUT args, if any
2054: eam_pmdef_pub_w.rosetta_table_copy_in_p6(ddp_date_table, p0_a0
2055: , p0_a1
2056: , p0_a2
2057: );
2058:
2065:
2066: -- copy data back from the local variables to OUT or IN-OUT args, if any
2067:
2068:
2069: eam_pmdef_pub_w.rosetta_table_copy_out_p6(ddx_sorted_date_table, p2_a0
2070: , p2_a1
2071: , p2_a2
2072: );
2073: end;
2087: ddindx binary_integer; indx binary_integer;
2088: begin
2089:
2090: -- copy data to the local IN or IN-OUT args, if any
2091: eam_pmdef_pub_w.rosetta_table_copy_in_p8(ddp_num_table, p0_a0
2092: , p0_a1
2093: , p0_a2
2094: );
2095:
2102:
2103: -- copy data back from the local variables to OUT or IN-OUT args, if any
2104:
2105:
2106: eam_pmdef_pub_w.rosetta_table_copy_out_p8(ddx_sorted_num_table, p2_a0
2107: , p2_a1
2108: , p2_a2
2109: );
2110: end;
2157: ddindx binary_integer; indx binary_integer;
2158: begin
2159:
2160: -- copy data to the local IN or IN-OUT args, if any
2161: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_rules_tbl1, p0_a0
2162: , p0_a1
2163: , p0_a2
2164: , p0_a3
2165: , p0_a4
2172: , p0_a11
2173: , p0_a12
2174: );
2175:
2176: eam_pmdef_pub_w.rosetta_table_copy_in_p4(ddp_rules_tbl2, p1_a0
2177: , p1_a1
2178: , p1_a2
2179: , p1_a3
2180: , p1_a4
2196:
2197: -- copy data back from the local variables to OUT or IN-OUT args, if any
2198:
2199:
2200: eam_pmdef_pub_w.rosetta_table_copy_out_p4(ddx_merged_rules_tbl, p2_a0
2201: , p2_a1
2202: , p2_a2
2203: , p2_a3
2204: , p2_a4
2212: , p2_a12
2213: );
2214: end;
2215:
2216: end eam_pmdef_pub_w;