eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SIP_PVT_W dependencies on OKL_SIP_PVT

Line 1: package body okl_sip_pvt_w as

1: package body okl_sip_pvt_w as
2: /* $Header: OKLISIPB.pls 120.1 2005/10/30 04:00:59 appldev noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

Line 115: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

111: end loop;
112: end if;
113: end if;
114: end rosetta_table_copy_in_p2;
115: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_VARCHAR2_TABLE_100
118: , a3 out nocopy JTF_VARCHAR2_TABLE_100
119: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 324: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE

320: end if;
321: end if;
322: end rosetta_table_copy_out_p2;
323:
324: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE
325: , a1 JTF_VARCHAR2_TABLE_200
326: , a2 JTF_VARCHAR2_TABLE_2000
327: , a3 JTF_VARCHAR2_TABLE_100
328: , a4 JTF_VARCHAR2_TABLE_100

Line 363: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

359: end loop;
360: end if;
361: end if;
362: end rosetta_table_copy_in_p5;
363: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
364: , a1 out nocopy JTF_VARCHAR2_TABLE_200
365: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
366: , a3 out nocopy JTF_VARCHAR2_TABLE_100
367: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 437: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE

433: end if;
434: end if;
435: end rosetta_table_copy_out_p5;
436:
437: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE
438: , a1 JTF_NUMBER_TABLE
439: , a2 JTF_VARCHAR2_TABLE_100
440: , a3 JTF_VARCHAR2_TABLE_100
441: , a4 JTF_DATE_TABLE

Line 524: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

520: end loop;
521: end if;
522: end if;
523: end rosetta_table_copy_in_p8;
524: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
525: , a1 out nocopy JTF_NUMBER_TABLE
526: , a2 out nocopy JTF_VARCHAR2_TABLE_100
527: , a3 out nocopy JTF_VARCHAR2_TABLE_100
528: , a4 out nocopy JTF_DATE_TABLE

Line 802: ddp_sipv_rec okl_sip_pvt.sipv_rec_type;

798: , p5_a37 NUMBER := 0-1962.0724
799: )
800:
801: as
802: ddp_sipv_rec okl_sip_pvt.sipv_rec_type;
803: ddx_sipv_rec okl_sip_pvt.sipv_rec_type;
804: ddindx binary_integer; indx binary_integer;
805: begin
806:

Line 803: ddx_sipv_rec okl_sip_pvt.sipv_rec_type;

799: )
800:
801: as
802: ddp_sipv_rec okl_sip_pvt.sipv_rec_type;
803: ddx_sipv_rec okl_sip_pvt.sipv_rec_type;
804: ddindx binary_integer; indx binary_integer;
805: begin
806:
807: -- copy data to the local IN or IN-OUT args, if any

Line 854: okl_sip_pvt.insert_row(p_api_version,

850: ddp_sipv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
851:
852:
853: -- here's the delegated call to the old PL/SQL routine
854: okl_sip_pvt.insert_row(p_api_version,
855: p_init_msg_list,
856: x_return_status,
857: x_msg_count,
858: x_msg_data,

Line 993: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;

989: , p6_a37 out nocopy JTF_NUMBER_TABLE
990: )
991:
992: as
993: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;
994: ddx_sipv_tbl okl_sip_pvt.sipv_tbl_type;
995: ddindx binary_integer; indx binary_integer;
996: begin
997:

Line 994: ddx_sipv_tbl okl_sip_pvt.sipv_tbl_type;

990: )
991:
992: as
993: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;
994: ddx_sipv_tbl okl_sip_pvt.sipv_tbl_type;
995: ddindx binary_integer; indx binary_integer;
996: begin
997:
998: -- copy data to the local IN or IN-OUT args, if any

Line 1004: okl_sip_pvt_w.rosetta_table_copy_in_p2(ddp_sipv_tbl, p5_a0

1000:
1001:
1002:
1003:
1004: okl_sip_pvt_w.rosetta_table_copy_in_p2(ddp_sipv_tbl, p5_a0
1005: , p5_a1
1006: , p5_a2
1007: , p5_a3
1008: , p5_a4

Line 1046: okl_sip_pvt.insert_row(p_api_version,

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

Line 1061: okl_sip_pvt_w.rosetta_table_copy_out_p2(ddx_sipv_tbl, p6_a0

1057:
1058:
1059:
1060:
1061: okl_sip_pvt_w.rosetta_table_copy_out_p2(ddx_sipv_tbl, p6_a0
1062: , p6_a1
1063: , p6_a2
1064: , p6_a3
1065: , p6_a4

Line 1148: ddp_sipv_rec okl_sip_pvt.sipv_rec_type;

1144: , p5_a37 NUMBER := 0-1962.0724
1145: )
1146:
1147: as
1148: ddp_sipv_rec okl_sip_pvt.sipv_rec_type;
1149: ddindx binary_integer; indx binary_integer;
1150: begin
1151:
1152: -- copy data to the local IN or IN-OUT args, if any

Line 1198: okl_sip_pvt.lock_row(p_api_version,

1194: ddp_sipv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1195: ddp_sipv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1196:
1197: -- here's the delegated call to the old PL/SQL routine
1198: okl_sip_pvt.lock_row(p_api_version,
1199: p_init_msg_list,
1200: x_return_status,
1201: x_msg_count,
1202: x_msg_data,

Line 1259: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;

1255: , p5_a37 JTF_NUMBER_TABLE
1256: )
1257:
1258: as
1259: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;
1260: ddindx binary_integer; indx binary_integer;
1261: begin
1262:
1263: -- copy data to the local IN or IN-OUT args, if any

Line 1269: okl_sip_pvt_w.rosetta_table_copy_in_p2(ddp_sipv_tbl, p5_a0

1265:
1266:
1267:
1268:
1269: okl_sip_pvt_w.rosetta_table_copy_in_p2(ddp_sipv_tbl, p5_a0
1270: , p5_a1
1271: , p5_a2
1272: , p5_a3
1273: , p5_a4

Line 1310: okl_sip_pvt.lock_row(p_api_version,

1306: , p5_a37
1307: );
1308:
1309: -- here's the delegated call to the old PL/SQL routine
1310: okl_sip_pvt.lock_row(p_api_version,
1311: p_init_msg_list,
1312: x_return_status,
1313: x_msg_count,
1314: x_msg_data,

Line 1409: ddp_sipv_rec okl_sip_pvt.sipv_rec_type;

1405: , p5_a37 NUMBER := 0-1962.0724
1406: )
1407:
1408: as
1409: ddp_sipv_rec okl_sip_pvt.sipv_rec_type;
1410: ddx_sipv_rec okl_sip_pvt.sipv_rec_type;
1411: ddindx binary_integer; indx binary_integer;
1412: begin
1413:

Line 1410: ddx_sipv_rec okl_sip_pvt.sipv_rec_type;

1406: )
1407:
1408: as
1409: ddp_sipv_rec okl_sip_pvt.sipv_rec_type;
1410: ddx_sipv_rec okl_sip_pvt.sipv_rec_type;
1411: ddindx binary_integer; indx binary_integer;
1412: begin
1413:
1414: -- copy data to the local IN or IN-OUT args, if any

Line 1461: okl_sip_pvt.update_row(p_api_version,

1457: ddp_sipv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1458:
1459:
1460: -- here's the delegated call to the old PL/SQL routine
1461: okl_sip_pvt.update_row(p_api_version,
1462: p_init_msg_list,
1463: x_return_status,
1464: x_msg_count,
1465: x_msg_data,

Line 1600: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;

1596: , p6_a37 out nocopy JTF_NUMBER_TABLE
1597: )
1598:
1599: as
1600: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;
1601: ddx_sipv_tbl okl_sip_pvt.sipv_tbl_type;
1602: ddindx binary_integer; indx binary_integer;
1603: begin
1604:

Line 1601: ddx_sipv_tbl okl_sip_pvt.sipv_tbl_type;

1597: )
1598:
1599: as
1600: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;
1601: ddx_sipv_tbl okl_sip_pvt.sipv_tbl_type;
1602: ddindx binary_integer; indx binary_integer;
1603: begin
1604:
1605: -- copy data to the local IN or IN-OUT args, if any

Line 1611: okl_sip_pvt_w.rosetta_table_copy_in_p2(ddp_sipv_tbl, p5_a0

1607:
1608:
1609:
1610:
1611: okl_sip_pvt_w.rosetta_table_copy_in_p2(ddp_sipv_tbl, p5_a0
1612: , p5_a1
1613: , p5_a2
1614: , p5_a3
1615: , p5_a4

Line 1653: okl_sip_pvt.update_row(p_api_version,

1649: );
1650:
1651:
1652: -- here's the delegated call to the old PL/SQL routine
1653: okl_sip_pvt.update_row(p_api_version,
1654: p_init_msg_list,
1655: x_return_status,
1656: x_msg_count,
1657: x_msg_data,

Line 1668: okl_sip_pvt_w.rosetta_table_copy_out_p2(ddx_sipv_tbl, p6_a0

1664:
1665:
1666:
1667:
1668: okl_sip_pvt_w.rosetta_table_copy_out_p2(ddx_sipv_tbl, p6_a0
1669: , p6_a1
1670: , p6_a2
1671: , p6_a3
1672: , p6_a4

Line 1755: ddp_sipv_rec okl_sip_pvt.sipv_rec_type;

1751: , p5_a37 NUMBER := 0-1962.0724
1752: )
1753:
1754: as
1755: ddp_sipv_rec okl_sip_pvt.sipv_rec_type;
1756: ddindx binary_integer; indx binary_integer;
1757: begin
1758:
1759: -- copy data to the local IN or IN-OUT args, if any

Line 1805: okl_sip_pvt.delete_row(p_api_version,

1801: ddp_sipv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
1802: ddp_sipv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
1803:
1804: -- here's the delegated call to the old PL/SQL routine
1805: okl_sip_pvt.delete_row(p_api_version,
1806: p_init_msg_list,
1807: x_return_status,
1808: x_msg_count,
1809: x_msg_data,

Line 1866: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;

1862: , p5_a37 JTF_NUMBER_TABLE
1863: )
1864:
1865: as
1866: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;
1867: ddindx binary_integer; indx binary_integer;
1868: begin
1869:
1870: -- copy data to the local IN or IN-OUT args, if any

Line 1876: okl_sip_pvt_w.rosetta_table_copy_in_p2(ddp_sipv_tbl, p5_a0

1872:
1873:
1874:
1875:
1876: okl_sip_pvt_w.rosetta_table_copy_in_p2(ddp_sipv_tbl, p5_a0
1877: , p5_a1
1878: , p5_a2
1879: , p5_a3
1880: , p5_a4

Line 1917: okl_sip_pvt.delete_row(p_api_version,

1913: , p5_a37
1914: );
1915:
1916: -- here's the delegated call to the old PL/SQL routine
1917: okl_sip_pvt.delete_row(p_api_version,
1918: p_init_msg_list,
1919: x_return_status,
1920: x_msg_count,
1921: x_msg_data,

Line 1978: ddp_sipv_rec okl_sip_pvt.sipv_rec_type;

1974: , p5_a37 NUMBER := 0-1962.0724
1975: )
1976:
1977: as
1978: ddp_sipv_rec okl_sip_pvt.sipv_rec_type;
1979: ddindx binary_integer; indx binary_integer;
1980: begin
1981:
1982: -- copy data to the local IN or IN-OUT args, if any

Line 2028: okl_sip_pvt.validate_row(p_api_version,

2024: ddp_sipv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a36);
2025: ddp_sipv_rec.last_update_login := rosetta_g_miss_num_map(p5_a37);
2026:
2027: -- here's the delegated call to the old PL/SQL routine
2028: okl_sip_pvt.validate_row(p_api_version,
2029: p_init_msg_list,
2030: x_return_status,
2031: x_msg_count,
2032: x_msg_data,

Line 2089: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;

2085: , p5_a37 JTF_NUMBER_TABLE
2086: )
2087:
2088: as
2089: ddp_sipv_tbl okl_sip_pvt.sipv_tbl_type;
2090: ddindx binary_integer; indx binary_integer;
2091: begin
2092:
2093: -- copy data to the local IN or IN-OUT args, if any

Line 2099: okl_sip_pvt_w.rosetta_table_copy_in_p2(ddp_sipv_tbl, p5_a0

2095:
2096:
2097:
2098:
2099: okl_sip_pvt_w.rosetta_table_copy_in_p2(ddp_sipv_tbl, p5_a0
2100: , p5_a1
2101: , p5_a2
2102: , p5_a3
2103: , p5_a4

Line 2140: okl_sip_pvt.validate_row(p_api_version,

2136: , p5_a37
2137: );
2138:
2139: -- here's the delegated call to the old PL/SQL routine
2140: okl_sip_pvt.validate_row(p_api_version,
2141: p_init_msg_list,
2142: x_return_status,
2143: x_msg_count,
2144: x_msg_data,

Line 2155: end okl_sip_pvt_w;

2151:
2152:
2153: end;
2154:
2155: end okl_sip_pvt_w;