DBA Data[Home] [Help]

APPS.OKL_LRT_PVT_W dependencies on OKL_LRT_PVT

Line 1: package body okl_lrt_pvt_w as

1: package body okl_lrt_pvt_w as
2: /* $Header: OKLILRTB.pls 120.2 2005/07/05 12:29:31 asawanka noship $ */
3: procedure rosetta_table_copy_in_p27(t out nocopy okl_lrt_pvt.lrtv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p27(t out nocopy okl_lrt_pvt.lrtv_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_lrt_pvt_w as
2: /* $Header: OKLILRTB.pls 120.2 2005/07/05 12:29:31 asawanka noship $ */
3: procedure rosetta_table_copy_in_p27(t out nocopy okl_lrt_pvt.lrtv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 98: procedure rosetta_table_copy_out_p27(t okl_lrt_pvt.lrtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

94: end loop;
95: end if;
96: end if;
97: end rosetta_table_copy_in_p27;
98: procedure rosetta_table_copy_out_p27(t okl_lrt_pvt.lrtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_NUMBER_TABLE
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_NUMBER_TABLE
102: , a4 out nocopy JTF_NUMBER_TABLE

Line 312: procedure rosetta_table_copy_in_p29(t out nocopy okl_lrt_pvt.lrt_tbl_type, a0 JTF_NUMBER_TABLE

308: end if;
309: end if;
310: end rosetta_table_copy_out_p27;
311:
312: procedure rosetta_table_copy_in_p29(t out nocopy okl_lrt_pvt.lrt_tbl_type, a0 JTF_NUMBER_TABLE
313: , a1 JTF_NUMBER_TABLE
314: , a2 JTF_VARCHAR2_TABLE_200
315: , a3 JTF_VARCHAR2_TABLE_100
316: , a4 JTF_DATE_TABLE

Line 403: procedure rosetta_table_copy_out_p29(t okl_lrt_pvt.lrt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

399: end loop;
400: end if;
401: end if;
402: end rosetta_table_copy_in_p29;
403: procedure rosetta_table_copy_out_p29(t okl_lrt_pvt.lrt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
404: , a1 out nocopy JTF_NUMBER_TABLE
405: , a2 out nocopy JTF_VARCHAR2_TABLE_200
406: , a3 out nocopy JTF_VARCHAR2_TABLE_100
407: , a4 out nocopy JTF_DATE_TABLE

Line 607: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrt_pvt.lrttl_tbl_type, a0 JTF_NUMBER_TABLE

603: end if;
604: end if;
605: end rosetta_table_copy_out_p29;
606:
607: procedure rosetta_table_copy_in_p31(t out nocopy okl_lrt_pvt.lrttl_tbl_type, a0 JTF_NUMBER_TABLE
608: , a1 JTF_VARCHAR2_TABLE_100
609: , a2 JTF_VARCHAR2_TABLE_100
610: , a3 JTF_VARCHAR2_TABLE_100
611: , a4 JTF_VARCHAR2_TABLE_2000

Line 644: procedure rosetta_table_copy_out_p31(t okl_lrt_pvt.lrttl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

640: end loop;
641: end if;
642: end if;
643: end rosetta_table_copy_in_p31;
644: procedure rosetta_table_copy_out_p31(t okl_lrt_pvt.lrttl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
645: , a1 out nocopy JTF_VARCHAR2_TABLE_100
646: , a2 out nocopy JTF_VARCHAR2_TABLE_100
647: , a3 out nocopy JTF_VARCHAR2_TABLE_100
648: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 799: ddp_lrtv_rec okl_lrt_pvt.lrtv_rec_type;

795: , p6_a38 out nocopy NUMBER
796: )
797:
798: as
799: ddp_lrtv_rec okl_lrt_pvt.lrtv_rec_type;
800: ddx_lrtv_rec okl_lrt_pvt.lrtv_rec_type;
801: ddindx binary_integer; indx binary_integer;
802: begin
803:

Line 800: ddx_lrtv_rec okl_lrt_pvt.lrtv_rec_type;

796: )
797:
798: as
799: ddp_lrtv_rec okl_lrt_pvt.lrtv_rec_type;
800: ddx_lrtv_rec okl_lrt_pvt.lrtv_rec_type;
801: ddindx binary_integer; indx binary_integer;
802: begin
803:
804: -- copy data to the local IN or IN-OUT args, if any

Line 852: okl_lrt_pvt.insert_row(p_api_version,

848: ddp_lrtv_rec.orig_rate_set_id := p5_a38;
849:
850:
851: -- here's the delegated call to the old PL/SQL routine
852: okl_lrt_pvt.insert_row(p_api_version,
853: p_init_msg_list,
854: x_return_status,
855: x_msg_count,
856: x_msg_data,

Line 994: ddp_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;

990: , p6_a38 out nocopy JTF_NUMBER_TABLE
991: )
992:
993: as
994: ddp_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;
995: ddx_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;
996: ddindx binary_integer; indx binary_integer;
997: begin
998:

Line 995: ddx_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;

991: )
992:
993: as
994: ddp_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;
995: ddx_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;
996: ddindx binary_integer; indx binary_integer;
997: begin
998:
999: -- copy data to the local IN or IN-OUT args, if any

Line 1005: okl_lrt_pvt_w.rosetta_table_copy_in_p27(ddp_lrtv_tbl, p5_a0

1001:
1002:
1003:
1004:
1005: okl_lrt_pvt_w.rosetta_table_copy_in_p27(ddp_lrtv_tbl, p5_a0
1006: , p5_a1
1007: , p5_a2
1008: , p5_a3
1009: , p5_a4

Line 1048: okl_lrt_pvt.insert_row(p_api_version,

1044: );
1045:
1046:
1047: -- here's the delegated call to the old PL/SQL routine
1048: okl_lrt_pvt.insert_row(p_api_version,
1049: p_init_msg_list,
1050: x_return_status,
1051: x_msg_count,
1052: x_msg_data,

Line 1063: okl_lrt_pvt_w.rosetta_table_copy_out_p27(ddx_lrtv_tbl, p6_a0

1059:
1060:
1061:
1062:
1063: okl_lrt_pvt_w.rosetta_table_copy_out_p27(ddx_lrtv_tbl, p6_a0
1064: , p6_a1
1065: , p6_a2
1066: , p6_a3
1067: , p6_a4

Line 1152: ddp_lrtv_rec okl_lrt_pvt.lrtv_rec_type;

1148: , p5_a38 NUMBER
1149: )
1150:
1151: as
1152: ddp_lrtv_rec okl_lrt_pvt.lrtv_rec_type;
1153: ddindx binary_integer; indx binary_integer;
1154: begin
1155:
1156: -- copy data to the local IN or IN-OUT args, if any

Line 1203: okl_lrt_pvt.lock_row(p_api_version,

1199: ddp_lrtv_rec.end_of_term_id := p5_a37;
1200: ddp_lrtv_rec.orig_rate_set_id := p5_a38;
1201:
1202: -- here's the delegated call to the old PL/SQL routine
1203: okl_lrt_pvt.lock_row(p_api_version,
1204: p_init_msg_list,
1205: x_return_status,
1206: x_msg_count,
1207: x_msg_data,

Line 1265: ddp_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;

1261: , p5_a38 JTF_NUMBER_TABLE
1262: )
1263:
1264: as
1265: ddp_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;
1266: ddindx binary_integer; indx binary_integer;
1267: begin
1268:
1269: -- copy data to the local IN or IN-OUT args, if any

Line 1275: okl_lrt_pvt_w.rosetta_table_copy_in_p27(ddp_lrtv_tbl, p5_a0

1271:
1272:
1273:
1274:
1275: okl_lrt_pvt_w.rosetta_table_copy_in_p27(ddp_lrtv_tbl, p5_a0
1276: , p5_a1
1277: , p5_a2
1278: , p5_a3
1279: , p5_a4

Line 1317: okl_lrt_pvt.lock_row(p_api_version,

1313: , p5_a38
1314: );
1315:
1316: -- here's the delegated call to the old PL/SQL routine
1317: okl_lrt_pvt.lock_row(p_api_version,
1318: p_init_msg_list,
1319: x_return_status,
1320: x_msg_count,
1321: x_msg_data,

Line 1418: ddp_lrtv_rec okl_lrt_pvt.lrtv_rec_type;

1414: , p6_a38 out nocopy NUMBER
1415: )
1416:
1417: as
1418: ddp_lrtv_rec okl_lrt_pvt.lrtv_rec_type;
1419: ddx_lrtv_rec okl_lrt_pvt.lrtv_rec_type;
1420: ddindx binary_integer; indx binary_integer;
1421: begin
1422:

Line 1419: ddx_lrtv_rec okl_lrt_pvt.lrtv_rec_type;

1415: )
1416:
1417: as
1418: ddp_lrtv_rec okl_lrt_pvt.lrtv_rec_type;
1419: ddx_lrtv_rec okl_lrt_pvt.lrtv_rec_type;
1420: ddindx binary_integer; indx binary_integer;
1421: begin
1422:
1423: -- copy data to the local IN or IN-OUT args, if any

Line 1471: okl_lrt_pvt.update_row(p_api_version,

1467: ddp_lrtv_rec.orig_rate_set_id := p5_a38;
1468:
1469:
1470: -- here's the delegated call to the old PL/SQL routine
1471: okl_lrt_pvt.update_row(p_api_version,
1472: p_init_msg_list,
1473: x_return_status,
1474: x_msg_count,
1475: x_msg_data,

Line 1613: ddp_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;

1609: , p6_a38 out nocopy JTF_NUMBER_TABLE
1610: )
1611:
1612: as
1613: ddp_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;
1614: ddx_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;
1615: ddindx binary_integer; indx binary_integer;
1616: begin
1617:

Line 1614: ddx_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;

1610: )
1611:
1612: as
1613: ddp_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;
1614: ddx_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;
1615: ddindx binary_integer; indx binary_integer;
1616: begin
1617:
1618: -- copy data to the local IN or IN-OUT args, if any

Line 1624: okl_lrt_pvt_w.rosetta_table_copy_in_p27(ddp_lrtv_tbl, p5_a0

1620:
1621:
1622:
1623:
1624: okl_lrt_pvt_w.rosetta_table_copy_in_p27(ddp_lrtv_tbl, p5_a0
1625: , p5_a1
1626: , p5_a2
1627: , p5_a3
1628: , p5_a4

Line 1667: okl_lrt_pvt.update_row(p_api_version,

1663: );
1664:
1665:
1666: -- here's the delegated call to the old PL/SQL routine
1667: okl_lrt_pvt.update_row(p_api_version,
1668: p_init_msg_list,
1669: x_return_status,
1670: x_msg_count,
1671: x_msg_data,

Line 1682: okl_lrt_pvt_w.rosetta_table_copy_out_p27(ddx_lrtv_tbl, p6_a0

1678:
1679:
1680:
1681:
1682: okl_lrt_pvt_w.rosetta_table_copy_out_p27(ddx_lrtv_tbl, p6_a0
1683: , p6_a1
1684: , p6_a2
1685: , p6_a3
1686: , p6_a4

Line 1771: ddp_lrtv_rec okl_lrt_pvt.lrtv_rec_type;

1767: , p5_a38 NUMBER
1768: )
1769:
1770: as
1771: ddp_lrtv_rec okl_lrt_pvt.lrtv_rec_type;
1772: ddindx binary_integer; indx binary_integer;
1773: begin
1774:
1775: -- copy data to the local IN or IN-OUT args, if any

Line 1822: okl_lrt_pvt.delete_row(p_api_version,

1818: ddp_lrtv_rec.end_of_term_id := p5_a37;
1819: ddp_lrtv_rec.orig_rate_set_id := p5_a38;
1820:
1821: -- here's the delegated call to the old PL/SQL routine
1822: okl_lrt_pvt.delete_row(p_api_version,
1823: p_init_msg_list,
1824: x_return_status,
1825: x_msg_count,
1826: x_msg_data,

Line 1884: ddp_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;

1880: , p5_a38 JTF_NUMBER_TABLE
1881: )
1882:
1883: as
1884: ddp_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;
1885: ddindx binary_integer; indx binary_integer;
1886: begin
1887:
1888: -- copy data to the local IN or IN-OUT args, if any

Line 1894: okl_lrt_pvt_w.rosetta_table_copy_in_p27(ddp_lrtv_tbl, p5_a0

1890:
1891:
1892:
1893:
1894: okl_lrt_pvt_w.rosetta_table_copy_in_p27(ddp_lrtv_tbl, p5_a0
1895: , p5_a1
1896: , p5_a2
1897: , p5_a3
1898: , p5_a4

Line 1936: okl_lrt_pvt.delete_row(p_api_version,

1932: , p5_a38
1933: );
1934:
1935: -- here's the delegated call to the old PL/SQL routine
1936: okl_lrt_pvt.delete_row(p_api_version,
1937: p_init_msg_list,
1938: x_return_status,
1939: x_msg_count,
1940: x_msg_data,

Line 1998: ddp_lrtv_rec okl_lrt_pvt.lrtv_rec_type;

1994: , p5_a38 NUMBER
1995: )
1996:
1997: as
1998: ddp_lrtv_rec okl_lrt_pvt.lrtv_rec_type;
1999: ddindx binary_integer; indx binary_integer;
2000: begin
2001:
2002: -- copy data to the local IN or IN-OUT args, if any

Line 2049: okl_lrt_pvt.validate_row(p_api_version,

2045: ddp_lrtv_rec.end_of_term_id := p5_a37;
2046: ddp_lrtv_rec.orig_rate_set_id := p5_a38;
2047:
2048: -- here's the delegated call to the old PL/SQL routine
2049: okl_lrt_pvt.validate_row(p_api_version,
2050: p_init_msg_list,
2051: x_return_status,
2052: x_msg_count,
2053: x_msg_data,

Line 2111: ddp_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;

2107: , p5_a38 JTF_NUMBER_TABLE
2108: )
2109:
2110: as
2111: ddp_lrtv_tbl okl_lrt_pvt.lrtv_tbl_type;
2112: ddindx binary_integer; indx binary_integer;
2113: begin
2114:
2115: -- copy data to the local IN or IN-OUT args, if any

Line 2121: okl_lrt_pvt_w.rosetta_table_copy_in_p27(ddp_lrtv_tbl, p5_a0

2117:
2118:
2119:
2120:
2121: okl_lrt_pvt_w.rosetta_table_copy_in_p27(ddp_lrtv_tbl, p5_a0
2122: , p5_a1
2123: , p5_a2
2124: , p5_a3
2125: , p5_a4

Line 2163: okl_lrt_pvt.validate_row(p_api_version,

2159: , p5_a38
2160: );
2161:
2162: -- here's the delegated call to the old PL/SQL routine
2163: okl_lrt_pvt.validate_row(p_api_version,
2164: p_init_msg_list,
2165: x_return_status,
2166: x_msg_count,
2167: x_msg_data,

Line 2178: end okl_lrt_pvt_w;

2174:
2175:
2176: end;
2177:
2178: end okl_lrt_pvt_w;