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_IPT_PVT_W dependencies on OKL_IPT_PVT

Line 1: package body okl_ipt_pvt_w as

1: package body okl_ipt_pvt_w as
2: /* $Header: OKLIIPTB.pls 115.7 2003/01/28 01:50:34 smoduga 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_ipt_pvt.ipt_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_ipt_pvt.ipt_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE

Line 113: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

109: end loop;
110: end if;
111: end if;
112: end rosetta_table_copy_in_p2;
113: procedure rosetta_table_copy_out_p2(t okl_ipt_pvt.ipt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114: , a1 out nocopy JTF_NUMBER_TABLE
115: , a2 out nocopy JTF_NUMBER_TABLE
116: , a3 out nocopy JTF_VARCHAR2_TABLE_100
117: , a4 out nocopy JTF_NUMBER_TABLE

Line 317: procedure rosetta_table_copy_in_p5(t out nocopy okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 JTF_NUMBER_TABLE

313: end if;
314: end if;
315: end rosetta_table_copy_out_p2;
316:
317: procedure rosetta_table_copy_in_p5(t out nocopy okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 JTF_NUMBER_TABLE
318: , a1 JTF_VARCHAR2_TABLE_100
319: , a2 JTF_VARCHAR2_TABLE_100
320: , a3 JTF_VARCHAR2_TABLE_100
321: , a4 JTF_VARCHAR2_TABLE_300

Line 356: procedure rosetta_table_copy_out_p5(t okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

352: end loop;
353: end if;
354: end if;
355: end rosetta_table_copy_in_p5;
356: procedure rosetta_table_copy_out_p5(t okl_ipt_pvt.okl_ins_products_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
357: , a1 out nocopy JTF_VARCHAR2_TABLE_100
358: , a2 out nocopy JTF_VARCHAR2_TABLE_100
359: , a3 out nocopy JTF_VARCHAR2_TABLE_100
360: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 430: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE

426: end if;
427: end if;
428: end rosetta_table_copy_out_p5;
429:
430: procedure rosetta_table_copy_in_p8(t out nocopy okl_ipt_pvt.iptv_tbl_type, a0 JTF_NUMBER_TABLE
431: , a1 JTF_NUMBER_TABLE
432: , a2 JTF_VARCHAR2_TABLE_100
433: , a3 JTF_NUMBER_TABLE
434: , a4 JTF_NUMBER_TABLE

Line 527: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

523: end loop;
524: end if;
525: end if;
526: end rosetta_table_copy_in_p8;
527: procedure rosetta_table_copy_out_p8(t okl_ipt_pvt.iptv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
528: , a1 out nocopy JTF_NUMBER_TABLE
529: , a2 out nocopy JTF_VARCHAR2_TABLE_100
530: , a3 out nocopy JTF_NUMBER_TABLE
531: , a4 out nocopy JTF_NUMBER_TABLE

Line 834: ddp_iptv_rec okl_ipt_pvt.iptv_rec_type;

830: , p5_a39 NUMBER := 0-1962.0724
831: )
832:
833: as
834: ddp_iptv_rec okl_ipt_pvt.iptv_rec_type;
835: ddx_iptv_rec okl_ipt_pvt.iptv_rec_type;
836: ddindx binary_integer; indx binary_integer;
837: begin
838:

Line 835: ddx_iptv_rec okl_ipt_pvt.iptv_rec_type;

831: )
832:
833: as
834: ddp_iptv_rec okl_ipt_pvt.iptv_rec_type;
835: ddx_iptv_rec okl_ipt_pvt.iptv_rec_type;
836: ddindx binary_integer; indx binary_integer;
837: begin
838:
839: -- copy data to the local IN or IN-OUT args, if any

Line 888: okl_ipt_pvt.insert_row(p_api_version,

884: ddp_iptv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
885:
886:
887: -- here's the delegated call to the old PL/SQL routine
888: okl_ipt_pvt.insert_row(p_api_version,
889: p_init_msg_list,
890: x_return_status,
891: x_msg_count,
892: x_msg_data,

Line 1033: ddp_iptv_tbl okl_ipt_pvt.iptv_tbl_type;

1029: , p6_a39 out nocopy JTF_NUMBER_TABLE
1030: )
1031:
1032: as
1033: ddp_iptv_tbl okl_ipt_pvt.iptv_tbl_type;
1034: ddx_iptv_tbl okl_ipt_pvt.iptv_tbl_type;
1035: ddindx binary_integer; indx binary_integer;
1036: begin
1037:

Line 1034: ddx_iptv_tbl okl_ipt_pvt.iptv_tbl_type;

1030: )
1031:
1032: as
1033: ddp_iptv_tbl okl_ipt_pvt.iptv_tbl_type;
1034: ddx_iptv_tbl okl_ipt_pvt.iptv_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_ipt_pvt_w.rosetta_table_copy_in_p8(ddp_iptv_tbl, p5_a0

1040:
1041:
1042:
1043:
1044: okl_ipt_pvt_w.rosetta_table_copy_in_p8(ddp_iptv_tbl, p5_a0
1045: , p5_a1
1046: , p5_a2
1047: , p5_a3
1048: , p5_a4

Line 1088: okl_ipt_pvt.insert_row(p_api_version,

1084: );
1085:
1086:
1087: -- here's the delegated call to the old PL/SQL routine
1088: okl_ipt_pvt.insert_row(p_api_version,
1089: p_init_msg_list,
1090: x_return_status,
1091: x_msg_count,
1092: x_msg_data,

Line 1103: okl_ipt_pvt_w.rosetta_table_copy_out_p8(ddx_iptv_tbl, p6_a0

1099:
1100:
1101:
1102:
1103: okl_ipt_pvt_w.rosetta_table_copy_out_p8(ddx_iptv_tbl, p6_a0
1104: , p6_a1
1105: , p6_a2
1106: , p6_a3
1107: , p6_a4

Line 1194: ddp_iptv_rec okl_ipt_pvt.iptv_rec_type;

1190: , p5_a39 NUMBER := 0-1962.0724
1191: )
1192:
1193: as
1194: ddp_iptv_rec okl_ipt_pvt.iptv_rec_type;
1195: ddindx binary_integer; indx binary_integer;
1196: begin
1197:
1198: -- copy data to the local IN or IN-OUT args, if any

Line 1246: okl_ipt_pvt.lock_row(p_api_version,

1242: ddp_iptv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
1243: ddp_iptv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1244:
1245: -- here's the delegated call to the old PL/SQL routine
1246: okl_ipt_pvt.lock_row(p_api_version,
1247: p_init_msg_list,
1248: x_return_status,
1249: x_msg_count,
1250: x_msg_data,

Line 1309: ddp_iptv_tbl okl_ipt_pvt.iptv_tbl_type;

1305: , p5_a39 JTF_NUMBER_TABLE
1306: )
1307:
1308: as
1309: ddp_iptv_tbl okl_ipt_pvt.iptv_tbl_type;
1310: ddindx binary_integer; indx binary_integer;
1311: begin
1312:
1313: -- copy data to the local IN or IN-OUT args, if any

Line 1319: okl_ipt_pvt_w.rosetta_table_copy_in_p8(ddp_iptv_tbl, p5_a0

1315:
1316:
1317:
1318:
1319: okl_ipt_pvt_w.rosetta_table_copy_in_p8(ddp_iptv_tbl, p5_a0
1320: , p5_a1
1321: , p5_a2
1322: , p5_a3
1323: , p5_a4

Line 1362: okl_ipt_pvt.lock_row(p_api_version,

1358: , p5_a39
1359: );
1360:
1361: -- here's the delegated call to the old PL/SQL routine
1362: okl_ipt_pvt.lock_row(p_api_version,
1363: p_init_msg_list,
1364: x_return_status,
1365: x_msg_count,
1366: x_msg_data,

Line 1465: ddp_iptv_rec okl_ipt_pvt.iptv_rec_type;

1461: , p5_a39 NUMBER := 0-1962.0724
1462: )
1463:
1464: as
1465: ddp_iptv_rec okl_ipt_pvt.iptv_rec_type;
1466: ddx_iptv_rec okl_ipt_pvt.iptv_rec_type;
1467: ddindx binary_integer; indx binary_integer;
1468: begin
1469:

Line 1466: ddx_iptv_rec okl_ipt_pvt.iptv_rec_type;

1462: )
1463:
1464: as
1465: ddp_iptv_rec okl_ipt_pvt.iptv_rec_type;
1466: ddx_iptv_rec okl_ipt_pvt.iptv_rec_type;
1467: ddindx binary_integer; indx binary_integer;
1468: begin
1469:
1470: -- copy data to the local IN or IN-OUT args, if any

Line 1519: okl_ipt_pvt.update_row(p_api_version,

1515: ddp_iptv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1516:
1517:
1518: -- here's the delegated call to the old PL/SQL routine
1519: okl_ipt_pvt.update_row(p_api_version,
1520: p_init_msg_list,
1521: x_return_status,
1522: x_msg_count,
1523: x_msg_data,

Line 1664: ddp_iptv_tbl okl_ipt_pvt.iptv_tbl_type;

1660: , p6_a39 out nocopy JTF_NUMBER_TABLE
1661: )
1662:
1663: as
1664: ddp_iptv_tbl okl_ipt_pvt.iptv_tbl_type;
1665: ddx_iptv_tbl okl_ipt_pvt.iptv_tbl_type;
1666: ddindx binary_integer; indx binary_integer;
1667: begin
1668:

Line 1665: ddx_iptv_tbl okl_ipt_pvt.iptv_tbl_type;

1661: )
1662:
1663: as
1664: ddp_iptv_tbl okl_ipt_pvt.iptv_tbl_type;
1665: ddx_iptv_tbl okl_ipt_pvt.iptv_tbl_type;
1666: ddindx binary_integer; indx binary_integer;
1667: begin
1668:
1669: -- copy data to the local IN or IN-OUT args, if any

Line 1675: okl_ipt_pvt_w.rosetta_table_copy_in_p8(ddp_iptv_tbl, p5_a0

1671:
1672:
1673:
1674:
1675: okl_ipt_pvt_w.rosetta_table_copy_in_p8(ddp_iptv_tbl, p5_a0
1676: , p5_a1
1677: , p5_a2
1678: , p5_a3
1679: , p5_a4

Line 1719: okl_ipt_pvt.update_row(p_api_version,

1715: );
1716:
1717:
1718: -- here's the delegated call to the old PL/SQL routine
1719: okl_ipt_pvt.update_row(p_api_version,
1720: p_init_msg_list,
1721: x_return_status,
1722: x_msg_count,
1723: x_msg_data,

Line 1734: okl_ipt_pvt_w.rosetta_table_copy_out_p8(ddx_iptv_tbl, p6_a0

1730:
1731:
1732:
1733:
1734: okl_ipt_pvt_w.rosetta_table_copy_out_p8(ddx_iptv_tbl, p6_a0
1735: , p6_a1
1736: , p6_a2
1737: , p6_a3
1738: , p6_a4

Line 1825: ddp_iptv_rec okl_ipt_pvt.iptv_rec_type;

1821: , p5_a39 NUMBER := 0-1962.0724
1822: )
1823:
1824: as
1825: ddp_iptv_rec okl_ipt_pvt.iptv_rec_type;
1826: ddindx binary_integer; indx binary_integer;
1827: begin
1828:
1829: -- copy data to the local IN or IN-OUT args, if any

Line 1877: okl_ipt_pvt.delete_row(p_api_version,

1873: ddp_iptv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
1874: ddp_iptv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
1875:
1876: -- here's the delegated call to the old PL/SQL routine
1877: okl_ipt_pvt.delete_row(p_api_version,
1878: p_init_msg_list,
1879: x_return_status,
1880: x_msg_count,
1881: x_msg_data,

Line 1940: ddp_iptv_tbl okl_ipt_pvt.iptv_tbl_type;

1936: , p5_a39 JTF_NUMBER_TABLE
1937: )
1938:
1939: as
1940: ddp_iptv_tbl okl_ipt_pvt.iptv_tbl_type;
1941: ddindx binary_integer; indx binary_integer;
1942: begin
1943:
1944: -- copy data to the local IN or IN-OUT args, if any

Line 1950: okl_ipt_pvt_w.rosetta_table_copy_in_p8(ddp_iptv_tbl, p5_a0

1946:
1947:
1948:
1949:
1950: okl_ipt_pvt_w.rosetta_table_copy_in_p8(ddp_iptv_tbl, p5_a0
1951: , p5_a1
1952: , p5_a2
1953: , p5_a3
1954: , p5_a4

Line 1993: okl_ipt_pvt.delete_row(p_api_version,

1989: , p5_a39
1990: );
1991:
1992: -- here's the delegated call to the old PL/SQL routine
1993: okl_ipt_pvt.delete_row(p_api_version,
1994: p_init_msg_list,
1995: x_return_status,
1996: x_msg_count,
1997: x_msg_data,

Line 2056: ddp_iptv_rec okl_ipt_pvt.iptv_rec_type;

2052: , p5_a39 NUMBER := 0-1962.0724
2053: )
2054:
2055: as
2056: ddp_iptv_rec okl_ipt_pvt.iptv_rec_type;
2057: ddindx binary_integer; indx binary_integer;
2058: begin
2059:
2060: -- copy data to the local IN or IN-OUT args, if any

Line 2108: okl_ipt_pvt.validate_row(p_api_version,

2104: ddp_iptv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a38);
2105: ddp_iptv_rec.last_update_login := rosetta_g_miss_num_map(p5_a39);
2106:
2107: -- here's the delegated call to the old PL/SQL routine
2108: okl_ipt_pvt.validate_row(p_api_version,
2109: p_init_msg_list,
2110: x_return_status,
2111: x_msg_count,
2112: x_msg_data,

Line 2171: ddp_iptv_tbl okl_ipt_pvt.iptv_tbl_type;

2167: , p5_a39 JTF_NUMBER_TABLE
2168: )
2169:
2170: as
2171: ddp_iptv_tbl okl_ipt_pvt.iptv_tbl_type;
2172: ddindx binary_integer; indx binary_integer;
2173: begin
2174:
2175: -- copy data to the local IN or IN-OUT args, if any

Line 2181: okl_ipt_pvt_w.rosetta_table_copy_in_p8(ddp_iptv_tbl, p5_a0

2177:
2178:
2179:
2180:
2181: okl_ipt_pvt_w.rosetta_table_copy_in_p8(ddp_iptv_tbl, p5_a0
2182: , p5_a1
2183: , p5_a2
2184: , p5_a3
2185: , p5_a4

Line 2224: okl_ipt_pvt.validate_row(p_api_version,

2220: , p5_a39
2221: );
2222:
2223: -- here's the delegated call to the old PL/SQL routine
2224: okl_ipt_pvt.validate_row(p_api_version,
2225: p_init_msg_list,
2226: x_return_status,
2227: x_msg_count,
2228: x_msg_data,

Line 2239: end okl_ipt_pvt_w;

2235:
2236:
2237: end;
2238:
2239: end okl_ipt_pvt_w;