1: package body okl_report_pvt_w as
2: /* $Header: OKLEREPB.pls 120.0 2007/12/10 18:27:42 dcshanmu noship $ */
3: procedure create_report(p_api_version NUMBER
4: , p_init_msg_list VARCHAR2
5: , x_return_status out nocopy VARCHAR2
47: , p6_a19 out nocopy VARCHAR2
48: )
49:
50: as
51: ddp_repv_rec okl_report_pvt.repv_rec_type;
52: ddx_repv_rec okl_report_pvt.repv_rec_type;
53: ddindx binary_integer; indx binary_integer;
54: begin
55:
48: )
49:
50: as
51: ddp_repv_rec okl_report_pvt.repv_rec_type;
52: ddx_repv_rec okl_report_pvt.repv_rec_type;
53: ddindx binary_integer; indx binary_integer;
54: begin
55:
56: -- copy data to the local IN or IN-OUT args, if any
81: ddp_repv_rec.sfwt_flag := p5_a19;
82:
83:
84: -- here's the delegated call to the old PL/SQL routine
85: okl_report_pvt.create_report(p_api_version,
86: p_init_msg_list,
87: x_return_status,
88: x_msg_count,
89: x_msg_data,
166: , p6_a19 out nocopy VARCHAR2
167: )
168:
169: as
170: ddp_repv_rec okl_report_pvt.repv_rec_type;
171: ddx_repv_rec okl_report_pvt.repv_rec_type;
172: ddindx binary_integer; indx binary_integer;
173: begin
174:
167: )
168:
169: as
170: ddp_repv_rec okl_report_pvt.repv_rec_type;
171: ddx_repv_rec okl_report_pvt.repv_rec_type;
172: ddindx binary_integer; indx binary_integer;
173: begin
174:
175: -- copy data to the local IN or IN-OUT args, if any
200: ddp_repv_rec.sfwt_flag := p5_a19;
201:
202:
203: -- here's the delegated call to the old PL/SQL routine
204: okl_report_pvt.update_report(p_api_version,
205: p_init_msg_list,
206: x_return_status,
207: x_msg_count,
208: x_msg_data,
265: , p5_a19 VARCHAR2
266: )
267:
268: as
269: ddp_repv_rec okl_report_pvt.repv_rec_type;
270: ddindx binary_integer; indx binary_integer;
271: begin
272:
273: -- copy data to the local IN or IN-OUT args, if any
297: ddp_repv_rec.source_lang := p5_a18;
298: ddp_repv_rec.sfwt_flag := p5_a19;
299:
300: -- here's the delegated call to the old PL/SQL routine
301: okl_report_pvt.delete_report(p_api_version,
302: p_init_msg_list,
303: x_return_status,
304: x_msg_count,
305: x_msg_data,
340: , p5_a19 VARCHAR2
341: )
342:
343: as
344: ddp_repv_rec okl_report_pvt.repv_rec_type;
345: ddindx binary_integer; indx binary_integer;
346: begin
347:
348: -- copy data to the local IN or IN-OUT args, if any
372: ddp_repv_rec.source_lang := p5_a18;
373: ddp_repv_rec.sfwt_flag := p5_a19;
374:
375: -- here's the delegated call to the old PL/SQL routine
376: okl_report_pvt.lock_report(p_api_version,
377: p_init_msg_list,
378: x_return_status,
379: x_msg_count,
380: x_msg_data,
435: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
436: )
437:
438: as
439: ddp_repv_tbl okl_report_pvt.repv_tbl_type;
440: ddx_repv_tbl okl_report_pvt.repv_tbl_type;
441: ddindx binary_integer; indx binary_integer;
442: begin
443:
436: )
437:
438: as
439: ddp_repv_tbl okl_report_pvt.repv_tbl_type;
440: ddx_repv_tbl okl_report_pvt.repv_tbl_type;
441: ddindx binary_integer; indx binary_integer;
442: begin
443:
444: -- copy data to the local IN or IN-OUT args, if any
470: );
471:
472:
473: -- here's the delegated call to the old PL/SQL routine
474: okl_report_pvt.create_report(p_api_version,
475: p_init_msg_list,
476: x_return_status,
477: x_msg_count,
478: x_msg_data,
556: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
557: )
558:
559: as
560: ddp_repv_tbl okl_report_pvt.repv_tbl_type;
561: ddx_repv_tbl okl_report_pvt.repv_tbl_type;
562: ddindx binary_integer; indx binary_integer;
563: begin
564:
557: )
558:
559: as
560: ddp_repv_tbl okl_report_pvt.repv_tbl_type;
561: ddx_repv_tbl okl_report_pvt.repv_tbl_type;
562: ddindx binary_integer; indx binary_integer;
563: begin
564:
565: -- copy data to the local IN or IN-OUT args, if any
591: );
592:
593:
594: -- here's the delegated call to the old PL/SQL routine
595: okl_report_pvt.update_report(p_api_version,
596: p_init_msg_list,
597: x_return_status,
598: x_msg_count,
599: x_msg_data,
657: , p5_a19 JTF_VARCHAR2_TABLE_100
658: )
659:
660: as
661: ddp_repv_tbl okl_report_pvt.repv_tbl_type;
662: ddindx binary_integer; indx binary_integer;
663: begin
664:
665: -- copy data to the local IN or IN-OUT args, if any
690: , p5_a19
691: );
692:
693: -- here's the delegated call to the old PL/SQL routine
694: okl_report_pvt.delete_report(p_api_version,
695: p_init_msg_list,
696: x_return_status,
697: x_msg_count,
698: x_msg_data,
733: , p5_a19 JTF_VARCHAR2_TABLE_100
734: )
735:
736: as
737: ddp_repv_tbl okl_report_pvt.repv_tbl_type;
738: ddindx binary_integer; indx binary_integer;
739: begin
740:
741: -- copy data to the local IN or IN-OUT args, if any
766: , p5_a19
767: );
768:
769: -- here's the delegated call to the old PL/SQL routine
770: okl_report_pvt.lock_report(p_api_version,
771: p_init_msg_list,
772: x_return_status,
773: x_msg_count,
774: x_msg_data,
813: , p6_a11 out nocopy NUMBER
814: )
815:
816: as
817: ddp_rpp_rec okl_report_pvt.rpp_rec_type;
818: ddx_rpp_rec okl_report_pvt.rpp_rec_type;
819: ddindx binary_integer; indx binary_integer;
820: begin
821:
814: )
815:
816: as
817: ddp_rpp_rec okl_report_pvt.rpp_rec_type;
818: ddx_rpp_rec okl_report_pvt.rpp_rec_type;
819: ddindx binary_integer; indx binary_integer;
820: begin
821:
822: -- copy data to the local IN or IN-OUT args, if any
839: ddp_rpp_rec.last_update_login := p5_a11;
840:
841:
842: -- here's the delegated call to the old PL/SQL routine
843: okl_report_pvt.create_report_parameters(p_api_version,
844: p_init_msg_list,
845: x_return_status,
846: x_msg_count,
847: x_msg_data,
900: , p6_a11 out nocopy NUMBER
901: )
902:
903: as
904: ddp_rpp_rec okl_report_pvt.rpp_rec_type;
905: ddx_rpp_rec okl_report_pvt.rpp_rec_type;
906: ddindx binary_integer; indx binary_integer;
907: begin
908:
901: )
902:
903: as
904: ddp_rpp_rec okl_report_pvt.rpp_rec_type;
905: ddx_rpp_rec okl_report_pvt.rpp_rec_type;
906: ddindx binary_integer; indx binary_integer;
907: begin
908:
909: -- copy data to the local IN or IN-OUT args, if any
926: ddp_rpp_rec.last_update_login := p5_a11;
927:
928:
929: -- here's the delegated call to the old PL/SQL routine
930: okl_report_pvt.update_report_parameters(p_api_version,
931: p_init_msg_list,
932: x_return_status,
933: x_msg_count,
934: x_msg_data,
975: , p5_a11 NUMBER
976: )
977:
978: as
979: ddp_rpp_rec okl_report_pvt.rpp_rec_type;
980: ddindx binary_integer; indx binary_integer;
981: begin
982:
983: -- copy data to the local IN or IN-OUT args, if any
999: ddp_rpp_rec.last_update_date := p5_a10;
1000: ddp_rpp_rec.last_update_login := p5_a11;
1001:
1002: -- here's the delegated call to the old PL/SQL routine
1003: okl_report_pvt.delete_report_parameters(p_api_version,
1004: p_init_msg_list,
1005: x_return_status,
1006: x_msg_count,
1007: x_msg_data,
1034: , p5_a11 NUMBER
1035: )
1036:
1037: as
1038: ddp_rpp_rec okl_report_pvt.rpp_rec_type;
1039: ddindx binary_integer; indx binary_integer;
1040: begin
1041:
1042: -- copy data to the local IN or IN-OUT args, if any
1058: ddp_rpp_rec.last_update_date := p5_a10;
1059: ddp_rpp_rec.last_update_login := p5_a11;
1060:
1061: -- here's the delegated call to the old PL/SQL routine
1062: okl_report_pvt.lock_report_parameters(p_api_version,
1063: p_init_msg_list,
1064: x_return_status,
1065: x_msg_count,
1066: x_msg_data,
1105: , p6_a11 out nocopy JTF_NUMBER_TABLE
1106: )
1107:
1108: as
1109: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
1110: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
1111: ddindx binary_integer; indx binary_integer;
1112: begin
1113:
1106: )
1107:
1108: as
1109: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
1110: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
1111: ddindx binary_integer; indx binary_integer;
1112: begin
1113:
1114: -- copy data to the local IN or IN-OUT args, if any
1132: );
1133:
1134:
1135: -- here's the delegated call to the old PL/SQL routine
1136: okl_report_pvt.create_report_parameters(p_api_version,
1137: p_init_msg_list,
1138: x_return_status,
1139: x_msg_count,
1140: x_msg_data,
1194: , p6_a11 out nocopy JTF_NUMBER_TABLE
1195: )
1196:
1197: as
1198: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
1199: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
1200: ddindx binary_integer; indx binary_integer;
1201: begin
1202:
1195: )
1196:
1197: as
1198: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
1199: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
1200: ddindx binary_integer; indx binary_integer;
1201: begin
1202:
1203: -- copy data to the local IN or IN-OUT args, if any
1221: );
1222:
1223:
1224: -- here's the delegated call to the old PL/SQL routine
1225: okl_report_pvt.update_report_parameters(p_api_version,
1226: p_init_msg_list,
1227: x_return_status,
1228: x_msg_count,
1229: x_msg_data,
1271: , p5_a11 JTF_NUMBER_TABLE
1272: )
1273:
1274: as
1275: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
1276: ddindx binary_integer; indx binary_integer;
1277: begin
1278:
1279: -- copy data to the local IN or IN-OUT args, if any
1296: , p5_a11
1297: );
1298:
1299: -- here's the delegated call to the old PL/SQL routine
1300: okl_report_pvt.delete_report_parameters(p_api_version,
1301: p_init_msg_list,
1302: x_return_status,
1303: x_msg_count,
1304: x_msg_data,
1331: , p5_a11 JTF_NUMBER_TABLE
1332: )
1333:
1334: as
1335: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
1336: ddindx binary_integer; indx binary_integer;
1337: begin
1338:
1339: -- copy data to the local IN or IN-OUT args, if any
1356: , p5_a11
1357: );
1358:
1359: -- here's the delegated call to the old PL/SQL routine
1360: okl_report_pvt.lock_report_parameters(p_api_version,
1361: p_init_msg_list,
1362: x_return_status,
1363: x_msg_count,
1364: x_msg_data,
1399: , p6_a9 out nocopy NUMBER
1400: )
1401:
1402: as
1403: ddp_rap_rec okl_report_pvt.rap_rec_type;
1404: ddx_rap_rec okl_report_pvt.rap_rec_type;
1405: ddindx binary_integer; indx binary_integer;
1406: begin
1407:
1400: )
1401:
1402: as
1403: ddp_rap_rec okl_report_pvt.rap_rec_type;
1404: ddx_rap_rec okl_report_pvt.rap_rec_type;
1405: ddindx binary_integer; indx binary_integer;
1406: begin
1407:
1408: -- copy data to the local IN or IN-OUT args, if any
1423: ddp_rap_rec.last_update_login := p5_a9;
1424:
1425:
1426: -- here's the delegated call to the old PL/SQL routine
1427: okl_report_pvt.create_report_acc_parameters(p_api_version,
1428: p_init_msg_list,
1429: x_return_status,
1430: x_msg_count,
1431: x_msg_data,
1478: , p6_a9 out nocopy NUMBER
1479: )
1480:
1481: as
1482: ddp_rap_rec okl_report_pvt.rap_rec_type;
1483: ddx_rap_rec okl_report_pvt.rap_rec_type;
1484: ddindx binary_integer; indx binary_integer;
1485: begin
1486:
1479: )
1480:
1481: as
1482: ddp_rap_rec okl_report_pvt.rap_rec_type;
1483: ddx_rap_rec okl_report_pvt.rap_rec_type;
1484: ddindx binary_integer; indx binary_integer;
1485: begin
1486:
1487: -- copy data to the local IN or IN-OUT args, if any
1502: ddp_rap_rec.last_update_login := p5_a9;
1503:
1504:
1505: -- here's the delegated call to the old PL/SQL routine
1506: okl_report_pvt.update_report_acc_parameters(p_api_version,
1507: p_init_msg_list,
1508: x_return_status,
1509: x_msg_count,
1510: x_msg_data,
1547: , p5_a9 NUMBER
1548: )
1549:
1550: as
1551: ddp_rap_rec okl_report_pvt.rap_rec_type;
1552: ddindx binary_integer; indx binary_integer;
1553: begin
1554:
1555: -- copy data to the local IN or IN-OUT args, if any
1569: ddp_rap_rec.last_update_date := p5_a8;
1570: ddp_rap_rec.last_update_login := p5_a9;
1571:
1572: -- here's the delegated call to the old PL/SQL routine
1573: okl_report_pvt.delete_report_acc_parameters(p_api_version,
1574: p_init_msg_list,
1575: x_return_status,
1576: x_msg_count,
1577: x_msg_data,
1602: , p5_a9 NUMBER
1603: )
1604:
1605: as
1606: ddp_rap_rec okl_report_pvt.rap_rec_type;
1607: ddindx binary_integer; indx binary_integer;
1608: begin
1609:
1610: -- copy data to the local IN or IN-OUT args, if any
1624: ddp_rap_rec.last_update_date := p5_a8;
1625: ddp_rap_rec.last_update_login := p5_a9;
1626:
1627: -- here's the delegated call to the old PL/SQL routine
1628: okl_report_pvt.lock_report_acc_parameters(p_api_version,
1629: p_init_msg_list,
1630: x_return_status,
1631: x_msg_count,
1632: x_msg_data,
1667: , p6_a9 out nocopy JTF_NUMBER_TABLE
1668: )
1669:
1670: as
1671: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
1672: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
1673: ddindx binary_integer; indx binary_integer;
1674: begin
1675:
1668: )
1669:
1670: as
1671: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
1672: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
1673: ddindx binary_integer; indx binary_integer;
1674: begin
1675:
1676: -- copy data to the local IN or IN-OUT args, if any
1692: );
1693:
1694:
1695: -- here's the delegated call to the old PL/SQL routine
1696: okl_report_pvt.create_report_acc_parameters(p_api_version,
1697: p_init_msg_list,
1698: x_return_status,
1699: x_msg_count,
1700: x_msg_data,
1748: , p6_a9 out nocopy JTF_NUMBER_TABLE
1749: )
1750:
1751: as
1752: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
1753: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
1754: ddindx binary_integer; indx binary_integer;
1755: begin
1756:
1749: )
1750:
1751: as
1752: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
1753: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
1754: ddindx binary_integer; indx binary_integer;
1755: begin
1756:
1757: -- copy data to the local IN or IN-OUT args, if any
1773: );
1774:
1775:
1776: -- here's the delegated call to the old PL/SQL routine
1777: okl_report_pvt.update_report_acc_parameters(p_api_version,
1778: p_init_msg_list,
1779: x_return_status,
1780: x_msg_count,
1781: x_msg_data,
1819: , p5_a9 JTF_NUMBER_TABLE
1820: )
1821:
1822: as
1823: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
1824: ddindx binary_integer; indx binary_integer;
1825: begin
1826:
1827: -- copy data to the local IN or IN-OUT args, if any
1842: , p5_a9
1843: );
1844:
1845: -- here's the delegated call to the old PL/SQL routine
1846: okl_report_pvt.delete_report_acc_parameters(p_api_version,
1847: p_init_msg_list,
1848: x_return_status,
1849: x_msg_count,
1850: x_msg_data,
1875: , p5_a9 JTF_NUMBER_TABLE
1876: )
1877:
1878: as
1879: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
1880: ddindx binary_integer; indx binary_integer;
1881: begin
1882:
1883: -- copy data to the local IN or IN-OUT args, if any
1898: , p5_a9
1899: );
1900:
1901: -- here's the delegated call to the old PL/SQL routine
1902: okl_report_pvt.lock_report_acc_parameters(p_api_version,
1903: p_init_msg_list,
1904: x_return_status,
1905: x_msg_count,
1906: x_msg_data,
1939: , p6_a8 out nocopy NUMBER
1940: )
1941:
1942: as
1943: ddp_rps_rec okl_report_pvt.rps_rec_type;
1944: ddx_rps_rec okl_report_pvt.rps_rec_type;
1945: ddindx binary_integer; indx binary_integer;
1946: begin
1947:
1940: )
1941:
1942: as
1943: ddp_rps_rec okl_report_pvt.rps_rec_type;
1944: ddx_rps_rec okl_report_pvt.rps_rec_type;
1945: ddindx binary_integer; indx binary_integer;
1946: begin
1947:
1948: -- copy data to the local IN or IN-OUT args, if any
1962: ddp_rps_rec.last_update_login := p5_a8;
1963:
1964:
1965: -- here's the delegated call to the old PL/SQL routine
1966: okl_report_pvt.create_report_strm_parameters(p_api_version,
1967: p_init_msg_list,
1968: x_return_status,
1969: x_msg_count,
1970: x_msg_data,
2014: , p6_a8 out nocopy NUMBER
2015: )
2016:
2017: as
2018: ddp_rps_rec okl_report_pvt.rps_rec_type;
2019: ddx_rps_rec okl_report_pvt.rps_rec_type;
2020: ddindx binary_integer; indx binary_integer;
2021: begin
2022:
2015: )
2016:
2017: as
2018: ddp_rps_rec okl_report_pvt.rps_rec_type;
2019: ddx_rps_rec okl_report_pvt.rps_rec_type;
2020: ddindx binary_integer; indx binary_integer;
2021: begin
2022:
2023: -- copy data to the local IN or IN-OUT args, if any
2037: ddp_rps_rec.last_update_login := p5_a8;
2038:
2039:
2040: -- here's the delegated call to the old PL/SQL routine
2041: okl_report_pvt.update_report_strm_parameters(p_api_version,
2042: p_init_msg_list,
2043: x_return_status,
2044: x_msg_count,
2045: x_msg_data,
2080: , p5_a8 NUMBER
2081: )
2082:
2083: as
2084: ddp_rps_rec okl_report_pvt.rps_rec_type;
2085: ddindx binary_integer; indx binary_integer;
2086: begin
2087:
2088: -- copy data to the local IN or IN-OUT args, if any
2101: ddp_rps_rec.last_update_date := p5_a7;
2102: ddp_rps_rec.last_update_login := p5_a8;
2103:
2104: -- here's the delegated call to the old PL/SQL routine
2105: okl_report_pvt.delete_report_strm_parameters(p_api_version,
2106: p_init_msg_list,
2107: x_return_status,
2108: x_msg_count,
2109: x_msg_data,
2133: , p5_a8 NUMBER
2134: )
2135:
2136: as
2137: ddp_rps_rec okl_report_pvt.rps_rec_type;
2138: ddindx binary_integer; indx binary_integer;
2139: begin
2140:
2141: -- copy data to the local IN or IN-OUT args, if any
2154: ddp_rps_rec.last_update_date := p5_a7;
2155: ddp_rps_rec.last_update_login := p5_a8;
2156:
2157: -- here's the delegated call to the old PL/SQL routine
2158: okl_report_pvt.lock_report_strm_parameters(p_api_version,
2159: p_init_msg_list,
2160: x_return_status,
2161: x_msg_count,
2162: x_msg_data,
2195: , p6_a8 out nocopy JTF_NUMBER_TABLE
2196: )
2197:
2198: as
2199: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
2200: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
2201: ddindx binary_integer; indx binary_integer;
2202: begin
2203:
2196: )
2197:
2198: as
2199: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
2200: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
2201: ddindx binary_integer; indx binary_integer;
2202: begin
2203:
2204: -- copy data to the local IN or IN-OUT args, if any
2219: );
2220:
2221:
2222: -- here's the delegated call to the old PL/SQL routine
2223: okl_report_pvt.create_report_strm_parameters(p_api_version,
2224: p_init_msg_list,
2225: x_return_status,
2226: x_msg_count,
2227: x_msg_data,
2272: , p6_a8 out nocopy JTF_NUMBER_TABLE
2273: )
2274:
2275: as
2276: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
2277: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
2278: ddindx binary_integer; indx binary_integer;
2279: begin
2280:
2273: )
2274:
2275: as
2276: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
2277: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
2278: ddindx binary_integer; indx binary_integer;
2279: begin
2280:
2281: -- copy data to the local IN or IN-OUT args, if any
2296: );
2297:
2298:
2299: -- here's the delegated call to the old PL/SQL routine
2300: okl_report_pvt.update_report_strm_parameters(p_api_version,
2301: p_init_msg_list,
2302: x_return_status,
2303: x_msg_count,
2304: x_msg_data,
2340: , p5_a8 JTF_NUMBER_TABLE
2341: )
2342:
2343: as
2344: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
2345: ddindx binary_integer; indx binary_integer;
2346: begin
2347:
2348: -- copy data to the local IN or IN-OUT args, if any
2362: , p5_a8
2363: );
2364:
2365: -- here's the delegated call to the old PL/SQL routine
2366: okl_report_pvt.delete_report_strm_parameters(p_api_version,
2367: p_init_msg_list,
2368: x_return_status,
2369: x_msg_count,
2370: x_msg_data,
2394: , p5_a8 JTF_NUMBER_TABLE
2395: )
2396:
2397: as
2398: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
2399: ddindx binary_integer; indx binary_integer;
2400: begin
2401:
2402: -- copy data to the local IN or IN-OUT args, if any
2416: , p5_a8
2417: );
2418:
2419: -- here's the delegated call to the old PL/SQL routine
2420: okl_report_pvt.lock_report_strm_parameters(p_api_version,
2421: p_init_msg_list,
2422: x_return_status,
2423: x_msg_count,
2424: x_msg_data,
2459: , p6_a9 out nocopy NUMBER
2460: )
2461:
2462: as
2463: ddp_rtp_rec okl_report_pvt.rtp_rec_type;
2464: ddx_rtp_rec okl_report_pvt.rtp_rec_type;
2465: ddindx binary_integer; indx binary_integer;
2466: begin
2467:
2460: )
2461:
2462: as
2463: ddp_rtp_rec okl_report_pvt.rtp_rec_type;
2464: ddx_rtp_rec okl_report_pvt.rtp_rec_type;
2465: ddindx binary_integer; indx binary_integer;
2466: begin
2467:
2468: -- copy data to the local IN or IN-OUT args, if any
2483: ddp_rtp_rec.last_update_login := p5_a9;
2484:
2485:
2486: -- here's the delegated call to the old PL/SQL routine
2487: okl_report_pvt.create_report_trx_parameters(p_api_version,
2488: p_init_msg_list,
2489: x_return_status,
2490: x_msg_count,
2491: x_msg_data,
2538: , p6_a9 out nocopy NUMBER
2539: )
2540:
2541: as
2542: ddp_rtp_rec okl_report_pvt.rtp_rec_type;
2543: ddx_rtp_rec okl_report_pvt.rtp_rec_type;
2544: ddindx binary_integer; indx binary_integer;
2545: begin
2546:
2539: )
2540:
2541: as
2542: ddp_rtp_rec okl_report_pvt.rtp_rec_type;
2543: ddx_rtp_rec okl_report_pvt.rtp_rec_type;
2544: ddindx binary_integer; indx binary_integer;
2545: begin
2546:
2547: -- copy data to the local IN or IN-OUT args, if any
2562: ddp_rtp_rec.last_update_login := p5_a9;
2563:
2564:
2565: -- here's the delegated call to the old PL/SQL routine
2566: okl_report_pvt.update_report_trx_parameters(p_api_version,
2567: p_init_msg_list,
2568: x_return_status,
2569: x_msg_count,
2570: x_msg_data,
2607: , p5_a9 NUMBER
2608: )
2609:
2610: as
2611: ddp_rtp_rec okl_report_pvt.rtp_rec_type;
2612: ddindx binary_integer; indx binary_integer;
2613: begin
2614:
2615: -- copy data to the local IN or IN-OUT args, if any
2629: ddp_rtp_rec.last_update_date := p5_a8;
2630: ddp_rtp_rec.last_update_login := p5_a9;
2631:
2632: -- here's the delegated call to the old PL/SQL routine
2633: okl_report_pvt.delete_report_trx_parameters(p_api_version,
2634: p_init_msg_list,
2635: x_return_status,
2636: x_msg_count,
2637: x_msg_data,
2662: , p5_a9 NUMBER
2663: )
2664:
2665: as
2666: ddp_rtp_rec okl_report_pvt.rtp_rec_type;
2667: ddindx binary_integer; indx binary_integer;
2668: begin
2669:
2670: -- copy data to the local IN or IN-OUT args, if any
2684: ddp_rtp_rec.last_update_date := p5_a8;
2685: ddp_rtp_rec.last_update_login := p5_a9;
2686:
2687: -- here's the delegated call to the old PL/SQL routine
2688: okl_report_pvt.lock_report_trx_parameters(p_api_version,
2689: p_init_msg_list,
2690: x_return_status,
2691: x_msg_count,
2692: x_msg_data,
2727: , p6_a9 out nocopy JTF_NUMBER_TABLE
2728: )
2729:
2730: as
2731: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
2732: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
2733: ddindx binary_integer; indx binary_integer;
2734: begin
2735:
2728: )
2729:
2730: as
2731: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
2732: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
2733: ddindx binary_integer; indx binary_integer;
2734: begin
2735:
2736: -- copy data to the local IN or IN-OUT args, if any
2752: );
2753:
2754:
2755: -- here's the delegated call to the old PL/SQL routine
2756: okl_report_pvt.create_report_trx_parameters(p_api_version,
2757: p_init_msg_list,
2758: x_return_status,
2759: x_msg_count,
2760: x_msg_data,
2808: , p6_a9 out nocopy JTF_NUMBER_TABLE
2809: )
2810:
2811: as
2812: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
2813: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
2814: ddindx binary_integer; indx binary_integer;
2815: begin
2816:
2809: )
2810:
2811: as
2812: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
2813: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
2814: ddindx binary_integer; indx binary_integer;
2815: begin
2816:
2817: -- copy data to the local IN or IN-OUT args, if any
2833: );
2834:
2835:
2836: -- here's the delegated call to the old PL/SQL routine
2837: okl_report_pvt.update_report_trx_parameters(p_api_version,
2838: p_init_msg_list,
2839: x_return_status,
2840: x_msg_count,
2841: x_msg_data,
2879: , p5_a9 JTF_NUMBER_TABLE
2880: )
2881:
2882: as
2883: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
2884: ddindx binary_integer; indx binary_integer;
2885: begin
2886:
2887: -- copy data to the local IN or IN-OUT args, if any
2902: , p5_a9
2903: );
2904:
2905: -- here's the delegated call to the old PL/SQL routine
2906: okl_report_pvt.delete_report_trx_parameters(p_api_version,
2907: p_init_msg_list,
2908: x_return_status,
2909: x_msg_count,
2910: x_msg_data,
2935: , p5_a9 JTF_NUMBER_TABLE
2936: )
2937:
2938: as
2939: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
2940: ddindx binary_integer; indx binary_integer;
2941: begin
2942:
2943: -- copy data to the local IN or IN-OUT args, if any
2958: , p5_a9
2959: );
2960:
2961: -- here's the delegated call to the old PL/SQL routine
2962: okl_report_pvt.lock_report_trx_parameters(p_api_version,
2963: p_init_msg_list,
2964: x_return_status,
2965: x_msg_count,
2966: x_msg_data,
3103: , p14_a9 out nocopy JTF_NUMBER_TABLE
3104: )
3105:
3106: as
3107: ddp_repv_rec okl_report_pvt.repv_rec_type;
3108: ddx_repv_rec okl_report_pvt.repv_rec_type;
3109: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3110: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3111: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3104: )
3105:
3106: as
3107: ddp_repv_rec okl_report_pvt.repv_rec_type;
3108: ddx_repv_rec okl_report_pvt.repv_rec_type;
3109: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3110: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3111: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3112: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3105:
3106: as
3107: ddp_repv_rec okl_report_pvt.repv_rec_type;
3108: ddx_repv_rec okl_report_pvt.repv_rec_type;
3109: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3110: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3111: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3112: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3113: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3106: as
3107: ddp_repv_rec okl_report_pvt.repv_rec_type;
3108: ddx_repv_rec okl_report_pvt.repv_rec_type;
3109: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3110: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3111: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3112: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3113: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3114: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3107: ddp_repv_rec okl_report_pvt.repv_rec_type;
3108: ddx_repv_rec okl_report_pvt.repv_rec_type;
3109: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3110: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3111: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3112: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3113: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3114: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3115: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
3108: ddx_repv_rec okl_report_pvt.repv_rec_type;
3109: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3110: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3111: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3112: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3113: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3114: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3115: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
3116: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
3109: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3110: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3111: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3112: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3113: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3114: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3115: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
3116: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
3117: ddindx binary_integer; indx binary_integer;
3110: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3111: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3112: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3113: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3114: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3115: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
3116: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
3117: ddindx binary_integer; indx binary_integer;
3118: begin
3111: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3112: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3113: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3114: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3115: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
3116: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
3117: ddindx binary_integer; indx binary_integer;
3118: begin
3119:
3112: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3113: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3114: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3115: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
3116: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
3117: ddindx binary_integer; indx binary_integer;
3118: begin
3119:
3120: -- copy data to the local IN or IN-OUT args, if any
3198: );
3199:
3200:
3201: -- here's the delegated call to the old PL/SQL routine
3202: okl_report_pvt.create_report(p_api_version,
3203: p_init_msg_list,
3204: x_return_status,
3205: x_msg_count,
3206: x_msg_data,
3426: , p14_a9 out nocopy JTF_NUMBER_TABLE
3427: )
3428:
3429: as
3430: ddp_repv_rec okl_report_pvt.repv_rec_type;
3431: ddx_repv_rec okl_report_pvt.repv_rec_type;
3432: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3433: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3434: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3427: )
3428:
3429: as
3430: ddp_repv_rec okl_report_pvt.repv_rec_type;
3431: ddx_repv_rec okl_report_pvt.repv_rec_type;
3432: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3433: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3434: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3435: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3428:
3429: as
3430: ddp_repv_rec okl_report_pvt.repv_rec_type;
3431: ddx_repv_rec okl_report_pvt.repv_rec_type;
3432: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3433: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3434: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3435: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3436: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3429: as
3430: ddp_repv_rec okl_report_pvt.repv_rec_type;
3431: ddx_repv_rec okl_report_pvt.repv_rec_type;
3432: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3433: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3434: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3435: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3436: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3437: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3430: ddp_repv_rec okl_report_pvt.repv_rec_type;
3431: ddx_repv_rec okl_report_pvt.repv_rec_type;
3432: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3433: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3434: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3435: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3436: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3437: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3438: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
3431: ddx_repv_rec okl_report_pvt.repv_rec_type;
3432: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3433: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3434: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3435: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3436: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3437: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3438: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
3439: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
3432: ddp_rpp_tbl okl_report_pvt.rpp_tbl_type;
3433: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3434: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3435: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3436: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3437: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3438: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
3439: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
3440: ddindx binary_integer; indx binary_integer;
3433: ddx_rpp_tbl okl_report_pvt.rpp_tbl_type;
3434: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3435: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3436: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3437: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3438: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
3439: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
3440: ddindx binary_integer; indx binary_integer;
3441: begin
3434: ddp_rap_tbl okl_report_pvt.rap_tbl_type;
3435: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3436: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3437: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3438: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
3439: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
3440: ddindx binary_integer; indx binary_integer;
3441: begin
3442:
3435: ddx_rap_tbl okl_report_pvt.rap_tbl_type;
3436: ddp_rps_tbl okl_report_pvt.rps_tbl_type;
3437: ddx_rps_tbl okl_report_pvt.rps_tbl_type;
3438: ddp_rtp_tbl okl_report_pvt.rtp_tbl_type;
3439: ddx_rtp_tbl okl_report_pvt.rtp_tbl_type;
3440: ddindx binary_integer; indx binary_integer;
3441: begin
3442:
3443: -- copy data to the local IN or IN-OUT args, if any
3521: );
3522:
3523:
3524: -- here's the delegated call to the old PL/SQL routine
3525: okl_report_pvt.update_report(p_api_version,
3526: p_init_msg_list,
3527: x_return_status,
3528: x_msg_count,
3529: x_msg_data,
3619: , p14_a9
3620: );
3621: end;
3622:
3623: end okl_report_pvt_w;