DBA Data[Home] [Help]

APPS.OKL_REP_PVT_W dependencies on OKL_REP_PVT

Line 1: package body okl_rep_pvt_w as

1: package body okl_rep_pvt_w as
2: /* $Header: OKLIREPB.pls 120.0 2007/12/10 18:28:25 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rep_pvt.repv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rep_pvt.repv_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_rep_pvt_w as
2: /* $Header: OKLIREPB.pls 120.0 2007/12/10 18:28:25 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rep_pvt.repv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_300
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 60: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

56: end loop;
57: end if;
58: end if;
59: end rosetta_table_copy_in_p2;
60: procedure rosetta_table_copy_out_p2(t okl_rep_pvt.repv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_VARCHAR2_TABLE_300
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_VARCHAR2_TABLE_100
64: , a4 out nocopy JTF_NUMBER_TABLE

Line 179: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE

175: end if;
176: end if;
177: end rosetta_table_copy_out_p2;
178:
179: procedure rosetta_table_copy_in_p5(t out nocopy okl_rep_pvt.rep_tbl_type, a0 JTF_NUMBER_TABLE
180: , a1 JTF_VARCHAR2_TABLE_300
181: , a2 JTF_NUMBER_TABLE
182: , a3 JTF_VARCHAR2_TABLE_100
183: , a4 JTF_NUMBER_TABLE

Line 228: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

224: end loop;
225: end if;
226: end if;
227: end rosetta_table_copy_in_p5;
228: procedure rosetta_table_copy_out_p5(t okl_rep_pvt.rep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
229: , a1 out nocopy JTF_VARCHAR2_TABLE_300
230: , a2 out nocopy JTF_NUMBER_TABLE
231: , a3 out nocopy JTF_VARCHAR2_TABLE_100
232: , a4 out nocopy JTF_NUMBER_TABLE

Line 327: procedure rosetta_table_copy_in_p8(t out nocopy okl_rep_pvt.okl_reports_tl_tbl_type, a0 JTF_NUMBER_TABLE

323: end if;
324: end if;
325: end rosetta_table_copy_out_p5;
326:
327: procedure rosetta_table_copy_in_p8(t out nocopy okl_rep_pvt.okl_reports_tl_tbl_type, a0 JTF_NUMBER_TABLE
328: , a1 JTF_VARCHAR2_TABLE_100
329: , a2 JTF_VARCHAR2_TABLE_100
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_300

Line 366: procedure rosetta_table_copy_out_p8(t okl_rep_pvt.okl_reports_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

362: end loop;
363: end if;
364: end if;
365: end rosetta_table_copy_in_p8;
366: procedure rosetta_table_copy_out_p8(t okl_rep_pvt.okl_reports_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_VARCHAR2_TABLE_100
368: , a2 out nocopy JTF_VARCHAR2_TABLE_100
369: , a3 out nocopy JTF_VARCHAR2_TABLE_100
370: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 488: ddp_repv_rec okl_rep_pvt.repv_rec_type;

484: , p6_a19 out nocopy VARCHAR2
485: )
486:
487: as
488: ddp_repv_rec okl_rep_pvt.repv_rec_type;
489: ddx_repv_rec okl_rep_pvt.repv_rec_type;
490: ddindx binary_integer; indx binary_integer;
491: begin
492:

Line 489: ddx_repv_rec okl_rep_pvt.repv_rec_type;

485: )
486:
487: as
488: ddp_repv_rec okl_rep_pvt.repv_rec_type;
489: ddx_repv_rec okl_rep_pvt.repv_rec_type;
490: ddindx binary_integer; indx binary_integer;
491: begin
492:
493: -- copy data to the local IN or IN-OUT args, if any

Line 522: okl_rep_pvt.insert_row(p_api_version,

518: ddp_repv_rec.sfwt_flag := p5_a19;
519:
520:
521: -- here's the delegated call to the old PL/SQL routine
522: okl_rep_pvt.insert_row(p_api_version,
523: p_init_msg_list,
524: x_return_status,
525: x_msg_count,
526: x_msg_data,

Line 614: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;

610: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
611: )
612:
613: as
614: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
615: ddx_repv_tbl okl_rep_pvt.repv_tbl_type;
616: ddpx_error_tbl okl_api.error_tbl_type;
617: ddindx binary_integer; indx binary_integer;
618: begin

Line 615: ddx_repv_tbl okl_rep_pvt.repv_tbl_type;

611: )
612:
613: as
614: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
615: ddx_repv_tbl okl_rep_pvt.repv_tbl_type;
616: ddpx_error_tbl okl_api.error_tbl_type;
617: ddindx binary_integer; indx binary_integer;
618: begin
619:

Line 626: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0

622:
623:
624:
625:
626: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0
627: , p5_a1
628: , p5_a2
629: , p5_a3
630: , p5_a4

Line 659: okl_rep_pvt.insert_row(p_api_version,

655: , p7_a6
656: );
657:
658: -- here's the delegated call to the old PL/SQL routine
659: okl_rep_pvt.insert_row(p_api_version,
660: p_init_msg_list,
661: x_return_status,
662: x_msg_count,
663: x_msg_data,

Line 675: okl_rep_pvt_w.rosetta_table_copy_out_p2(ddx_repv_tbl, p6_a0

671:
672:
673:
674:
675: okl_rep_pvt_w.rosetta_table_copy_out_p2(ddx_repv_tbl, p6_a0
676: , p6_a1
677: , p6_a2
678: , p6_a3
679: , p6_a4

Line 755: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;

751: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
752: )
753:
754: as
755: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
756: ddx_repv_tbl okl_rep_pvt.repv_tbl_type;
757: ddindx binary_integer; indx binary_integer;
758: begin
759:

Line 756: ddx_repv_tbl okl_rep_pvt.repv_tbl_type;

752: )
753:
754: as
755: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
756: ddx_repv_tbl okl_rep_pvt.repv_tbl_type;
757: ddindx binary_integer; indx binary_integer;
758: begin
759:
760: -- copy data to the local IN or IN-OUT args, if any

Line 766: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0

762:
763:
764:
765:
766: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0
767: , p5_a1
768: , p5_a2
769: , p5_a3
770: , p5_a4

Line 790: okl_rep_pvt.insert_row(p_api_version,

786: );
787:
788:
789: -- here's the delegated call to the old PL/SQL routine
790: okl_rep_pvt.insert_row(p_api_version,
791: p_init_msg_list,
792: x_return_status,
793: x_msg_count,
794: x_msg_data,

Line 805: okl_rep_pvt_w.rosetta_table_copy_out_p2(ddx_repv_tbl, p6_a0

801:
802:
803:
804:
805: okl_rep_pvt_w.rosetta_table_copy_out_p2(ddx_repv_tbl, p6_a0
806: , p6_a1
807: , p6_a2
808: , p6_a3
809: , p6_a4

Line 856: ddp_repv_rec okl_rep_pvt.repv_rec_type;

852: , p5_a19 VARCHAR2
853: )
854:
855: as
856: ddp_repv_rec okl_rep_pvt.repv_rec_type;
857: ddindx binary_integer; indx binary_integer;
858: begin
859:
860: -- copy data to the local IN or IN-OUT args, if any

Line 888: okl_rep_pvt.lock_row(p_api_version,

884: ddp_repv_rec.source_lang := p5_a18;
885: ddp_repv_rec.sfwt_flag := p5_a19;
886:
887: -- here's the delegated call to the old PL/SQL routine
888: okl_rep_pvt.lock_row(p_api_version,
889: p_init_msg_list,
890: x_return_status,
891: x_msg_count,
892: x_msg_data,

Line 938: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;

934: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
935: )
936:
937: as
938: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
939: ddpx_error_tbl okl_api.error_tbl_type;
940: ddindx binary_integer; indx binary_integer;
941: begin
942:

Line 949: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0

945:
946:
947:
948:
949: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0
950: , p5_a1
951: , p5_a2
952: , p5_a3
953: , p5_a4

Line 981: okl_rep_pvt.lock_row(p_api_version,

977: , p6_a6
978: );
979:
980: -- here's the delegated call to the old PL/SQL routine
981: okl_rep_pvt.lock_row(p_api_version,
982: p_init_msg_list,
983: x_return_status,
984: x_msg_count,
985: x_msg_data,

Line 1034: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;

1030: , p5_a19 JTF_VARCHAR2_TABLE_100
1031: )
1032:
1033: as
1034: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
1035: ddindx binary_integer; indx binary_integer;
1036: begin
1037:
1038: -- copy data to the local IN or IN-OUT args, if any

Line 1044: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0

1040:
1041:
1042:
1043:
1044: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0
1045: , p5_a1
1046: , p5_a2
1047: , p5_a3
1048: , p5_a4

Line 1067: okl_rep_pvt.lock_row(p_api_version,

1063: , p5_a19
1064: );
1065:
1066: -- here's the delegated call to the old PL/SQL routine
1067: okl_rep_pvt.lock_row(p_api_version,
1068: p_init_msg_list,
1069: x_return_status,
1070: x_msg_count,
1071: x_msg_data,

Line 1130: ddp_repv_rec okl_rep_pvt.repv_rec_type;

1126: , p6_a19 out nocopy VARCHAR2
1127: )
1128:
1129: as
1130: ddp_repv_rec okl_rep_pvt.repv_rec_type;
1131: ddx_repv_rec okl_rep_pvt.repv_rec_type;
1132: ddindx binary_integer; indx binary_integer;
1133: begin
1134:

Line 1131: ddx_repv_rec okl_rep_pvt.repv_rec_type;

1127: )
1128:
1129: as
1130: ddp_repv_rec okl_rep_pvt.repv_rec_type;
1131: ddx_repv_rec okl_rep_pvt.repv_rec_type;
1132: ddindx binary_integer; indx binary_integer;
1133: begin
1134:
1135: -- copy data to the local IN or IN-OUT args, if any

Line 1164: okl_rep_pvt.update_row(p_api_version,

1160: ddp_repv_rec.sfwt_flag := p5_a19;
1161:
1162:
1163: -- here's the delegated call to the old PL/SQL routine
1164: okl_rep_pvt.update_row(p_api_version,
1165: p_init_msg_list,
1166: x_return_status,
1167: x_msg_count,
1168: x_msg_data,

Line 1256: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;

1252: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1253: )
1254:
1255: as
1256: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
1257: ddx_repv_tbl okl_rep_pvt.repv_tbl_type;
1258: ddpx_error_tbl okl_api.error_tbl_type;
1259: ddindx binary_integer; indx binary_integer;
1260: begin

Line 1257: ddx_repv_tbl okl_rep_pvt.repv_tbl_type;

1253: )
1254:
1255: as
1256: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
1257: ddx_repv_tbl okl_rep_pvt.repv_tbl_type;
1258: ddpx_error_tbl okl_api.error_tbl_type;
1259: ddindx binary_integer; indx binary_integer;
1260: begin
1261:

Line 1268: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0

1264:
1265:
1266:
1267:
1268: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0
1269: , p5_a1
1270: , p5_a2
1271: , p5_a3
1272: , p5_a4

Line 1301: okl_rep_pvt.update_row(p_api_version,

1297: , p7_a6
1298: );
1299:
1300: -- here's the delegated call to the old PL/SQL routine
1301: okl_rep_pvt.update_row(p_api_version,
1302: p_init_msg_list,
1303: x_return_status,
1304: x_msg_count,
1305: x_msg_data,

Line 1317: okl_rep_pvt_w.rosetta_table_copy_out_p2(ddx_repv_tbl, p6_a0

1313:
1314:
1315:
1316:
1317: okl_rep_pvt_w.rosetta_table_copy_out_p2(ddx_repv_tbl, p6_a0
1318: , p6_a1
1319: , p6_a2
1320: , p6_a3
1321: , p6_a4

Line 1397: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;

1393: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
1394: )
1395:
1396: as
1397: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
1398: ddx_repv_tbl okl_rep_pvt.repv_tbl_type;
1399: ddindx binary_integer; indx binary_integer;
1400: begin
1401:

Line 1398: ddx_repv_tbl okl_rep_pvt.repv_tbl_type;

1394: )
1395:
1396: as
1397: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
1398: ddx_repv_tbl okl_rep_pvt.repv_tbl_type;
1399: ddindx binary_integer; indx binary_integer;
1400: begin
1401:
1402: -- copy data to the local IN or IN-OUT args, if any

Line 1408: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0

1404:
1405:
1406:
1407:
1408: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0
1409: , p5_a1
1410: , p5_a2
1411: , p5_a3
1412: , p5_a4

Line 1432: okl_rep_pvt.update_row(p_api_version,

1428: );
1429:
1430:
1431: -- here's the delegated call to the old PL/SQL routine
1432: okl_rep_pvt.update_row(p_api_version,
1433: p_init_msg_list,
1434: x_return_status,
1435: x_msg_count,
1436: x_msg_data,

Line 1447: okl_rep_pvt_w.rosetta_table_copy_out_p2(ddx_repv_tbl, p6_a0

1443:
1444:
1445:
1446:
1447: okl_rep_pvt_w.rosetta_table_copy_out_p2(ddx_repv_tbl, p6_a0
1448: , p6_a1
1449: , p6_a2
1450: , p6_a3
1451: , p6_a4

Line 1498: ddp_repv_rec okl_rep_pvt.repv_rec_type;

1494: , p5_a19 VARCHAR2
1495: )
1496:
1497: as
1498: ddp_repv_rec okl_rep_pvt.repv_rec_type;
1499: ddindx binary_integer; indx binary_integer;
1500: begin
1501:
1502: -- copy data to the local IN or IN-OUT args, if any

Line 1530: okl_rep_pvt.delete_row(p_api_version,

1526: ddp_repv_rec.source_lang := p5_a18;
1527: ddp_repv_rec.sfwt_flag := p5_a19;
1528:
1529: -- here's the delegated call to the old PL/SQL routine
1530: okl_rep_pvt.delete_row(p_api_version,
1531: p_init_msg_list,
1532: x_return_status,
1533: x_msg_count,
1534: x_msg_data,

Line 1580: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;

1576: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1577: )
1578:
1579: as
1580: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
1581: ddpx_error_tbl okl_api.error_tbl_type;
1582: ddindx binary_integer; indx binary_integer;
1583: begin
1584:

Line 1591: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0

1587:
1588:
1589:
1590:
1591: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0
1592: , p5_a1
1593: , p5_a2
1594: , p5_a3
1595: , p5_a4

Line 1623: okl_rep_pvt.delete_row(p_api_version,

1619: , p6_a6
1620: );
1621:
1622: -- here's the delegated call to the old PL/SQL routine
1623: okl_rep_pvt.delete_row(p_api_version,
1624: p_init_msg_list,
1625: x_return_status,
1626: x_msg_count,
1627: x_msg_data,

Line 1676: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;

1672: , p5_a19 JTF_VARCHAR2_TABLE_100
1673: )
1674:
1675: as
1676: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
1677: ddindx binary_integer; indx binary_integer;
1678: begin
1679:
1680: -- copy data to the local IN or IN-OUT args, if any

Line 1686: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0

1682:
1683:
1684:
1685:
1686: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0
1687: , p5_a1
1688: , p5_a2
1689: , p5_a3
1690: , p5_a4

Line 1709: okl_rep_pvt.delete_row(p_api_version,

1705: , p5_a19
1706: );
1707:
1708: -- here's the delegated call to the old PL/SQL routine
1709: okl_rep_pvt.delete_row(p_api_version,
1710: p_init_msg_list,
1711: x_return_status,
1712: x_msg_count,
1713: x_msg_data,

Line 1752: ddp_repv_rec okl_rep_pvt.repv_rec_type;

1748: , p5_a19 VARCHAR2
1749: )
1750:
1751: as
1752: ddp_repv_rec okl_rep_pvt.repv_rec_type;
1753: ddindx binary_integer; indx binary_integer;
1754: begin
1755:
1756: -- copy data to the local IN or IN-OUT args, if any

Line 1784: okl_rep_pvt.validate_row(p_api_version,

1780: ddp_repv_rec.source_lang := p5_a18;
1781: ddp_repv_rec.sfwt_flag := p5_a19;
1782:
1783: -- here's the delegated call to the old PL/SQL routine
1784: okl_rep_pvt.validate_row(p_api_version,
1785: p_init_msg_list,
1786: x_return_status,
1787: x_msg_count,
1788: x_msg_data,

Line 1834: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;

1830: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1831: )
1832:
1833: as
1834: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
1835: ddpx_error_tbl okl_api.error_tbl_type;
1836: ddindx binary_integer; indx binary_integer;
1837: begin
1838:

Line 1845: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0

1841:
1842:
1843:
1844:
1845: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0
1846: , p5_a1
1847: , p5_a2
1848: , p5_a3
1849: , p5_a4

Line 1877: okl_rep_pvt.validate_row(p_api_version,

1873: , p6_a6
1874: );
1875:
1876: -- here's the delegated call to the old PL/SQL routine
1877: okl_rep_pvt.validate_row(p_api_version,
1878: p_init_msg_list,
1879: x_return_status,
1880: x_msg_count,
1881: x_msg_data,

Line 1930: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;

1926: , p5_a19 JTF_VARCHAR2_TABLE_100
1927: )
1928:
1929: as
1930: ddp_repv_tbl okl_rep_pvt.repv_tbl_type;
1931: ddindx binary_integer; indx binary_integer;
1932: begin
1933:
1934: -- copy data to the local IN or IN-OUT args, if any

Line 1940: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0

1936:
1937:
1938:
1939:
1940: okl_rep_pvt_w.rosetta_table_copy_in_p2(ddp_repv_tbl, p5_a0
1941: , p5_a1
1942: , p5_a2
1943: , p5_a3
1944: , p5_a4

Line 1963: okl_rep_pvt.validate_row(p_api_version,

1959: , p5_a19
1960: );
1961:
1962: -- here's the delegated call to the old PL/SQL routine
1963: okl_rep_pvt.validate_row(p_api_version,
1964: p_init_msg_list,
1965: x_return_status,
1966: x_msg_count,
1967: x_msg_data,

Line 1978: end okl_rep_pvt_w;

1974:
1975:
1976: end;
1977:
1978: end okl_rep_pvt_w;