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_VP_CAT_PVT_W dependencies on OKL_VP_CAT_PVT

Line 1: package body okl_vp_cat_pvt_w as

1: package body okl_vp_cat_pvt_w as
2: /* $Header: OKLICARB.pls 120.2 2005/08/02 07:14:01 asawanka 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_vp_cat_pvt.cat_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_vp_cat_pvt.cat_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_NUMBER_TABLE

Line 103: procedure rosetta_table_copy_out_p2(t okl_vp_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t okl_vp_cat_pvt.cat_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_100
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE

Line 282: procedure rosetta_table_copy_in_p5(t out nocopy okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 JTF_NUMBER_TABLE

278: end if;
279: end if;
280: end rosetta_table_copy_out_p2;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 JTF_NUMBER_TABLE
283: , a1 JTF_VARCHAR2_TABLE_100
284: , a2 JTF_VARCHAR2_TABLE_100
285: , a3 JTF_VARCHAR2_TABLE_100
286: , a4 JTF_NUMBER_TABLE

Line 329: procedure rosetta_table_copy_out_p5(t okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

325: end loop;
326: end if;
327: end if;
328: end rosetta_table_copy_in_p5;
329: procedure rosetta_table_copy_out_p5(t okl_vp_cat_pvt.okc_k_articles_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
330: , a1 out nocopy JTF_VARCHAR2_TABLE_100
331: , a2 out nocopy JTF_VARCHAR2_TABLE_100
332: , a3 out nocopy JTF_VARCHAR2_TABLE_100
333: , a4 out nocopy JTF_NUMBER_TABLE

Line 423: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE

419: end if;
420: end if;
421: end rosetta_table_copy_out_p5;
422:
423: procedure rosetta_table_copy_in_p8(t out nocopy okl_vp_cat_pvt.catv_tbl_type, a0 JTF_NUMBER_TABLE
424: , a1 JTF_NUMBER_TABLE
425: , a2 JTF_NUMBER_TABLE
426: , a3 JTF_NUMBER_TABLE
427: , a4 JTF_NUMBER_TABLE

Line 512: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

508: end loop;
509: end if;
510: end if;
511: end rosetta_table_copy_in_p8;
512: procedure rosetta_table_copy_out_p8(t okl_vp_cat_pvt.catv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
513: , a1 out nocopy JTF_NUMBER_TABLE
514: , a2 out nocopy JTF_NUMBER_TABLE
515: , a3 out nocopy JTF_NUMBER_TABLE
516: , a4 out nocopy JTF_NUMBER_TABLE

Line 791: ddp_catv_rec okl_vp_cat_pvt.catv_rec_type;

787: , p5_a35 NUMBER := 0-1962.0724
788: )
789:
790: as
791: ddp_catv_rec okl_vp_cat_pvt.catv_rec_type;
792: ddx_catv_rec okl_vp_cat_pvt.catv_rec_type;
793: ddindx binary_integer; indx binary_integer;
794: begin
795:

Line 792: ddx_catv_rec okl_vp_cat_pvt.catv_rec_type;

788: )
789:
790: as
791: ddp_catv_rec okl_vp_cat_pvt.catv_rec_type;
792: ddx_catv_rec okl_vp_cat_pvt.catv_rec_type;
793: ddindx binary_integer; indx binary_integer;
794: begin
795:
796: -- copy data to the local IN or IN-OUT args, if any

Line 841: okl_vp_cat_pvt.insert_row(p_api_version,

837: ddp_catv_rec.last_update_login := rosetta_g_miss_num_map(p5_a35);
838:
839:
840: -- here's the delegated call to the old PL/SQL routine
841: okl_vp_cat_pvt.insert_row(p_api_version,
842: p_init_msg_list,
843: x_return_status,
844: x_msg_count,
845: x_msg_data,

Line 974: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;

970: , p6_a35 out nocopy JTF_NUMBER_TABLE
971: )
972:
973: as
974: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
975: ddx_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
976: ddindx binary_integer; indx binary_integer;
977: begin
978:

Line 975: ddx_catv_tbl okl_vp_cat_pvt.catv_tbl_type;

971: )
972:
973: as
974: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
975: ddx_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
976: ddindx binary_integer; indx binary_integer;
977: begin
978:
979: -- copy data to the local IN or IN-OUT args, if any

Line 985: okl_vp_cat_pvt_w.rosetta_table_copy_in_p8(ddp_catv_tbl, p5_a0

981:
982:
983:
984:
985: okl_vp_cat_pvt_w.rosetta_table_copy_in_p8(ddp_catv_tbl, p5_a0
986: , p5_a1
987: , p5_a2
988: , p5_a3
989: , p5_a4

Line 1025: okl_vp_cat_pvt.insert_row(p_api_version,

1021: );
1022:
1023:
1024: -- here's the delegated call to the old PL/SQL routine
1025: okl_vp_cat_pvt.insert_row(p_api_version,
1026: p_init_msg_list,
1027: x_return_status,
1028: x_msg_count,
1029: x_msg_data,

Line 1040: okl_vp_cat_pvt_w.rosetta_table_copy_out_p8(ddx_catv_tbl, p6_a0

1036:
1037:
1038:
1039:
1040: okl_vp_cat_pvt_w.rosetta_table_copy_out_p8(ddx_catv_tbl, p6_a0
1041: , p6_a1
1042: , p6_a2
1043: , p6_a3
1044: , p6_a4

Line 1123: ddp_catv_rec okl_vp_cat_pvt.catv_rec_type;

1119: , p5_a35 NUMBER := 0-1962.0724
1120: )
1121:
1122: as
1123: ddp_catv_rec okl_vp_cat_pvt.catv_rec_type;
1124: ddindx binary_integer; indx binary_integer;
1125: begin
1126:
1127: -- copy data to the local IN or IN-OUT args, if any

Line 1171: okl_vp_cat_pvt.lock_row(p_api_version,

1167: ddp_catv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a34);
1168: ddp_catv_rec.last_update_login := rosetta_g_miss_num_map(p5_a35);
1169:
1170: -- here's the delegated call to the old PL/SQL routine
1171: okl_vp_cat_pvt.lock_row(p_api_version,
1172: p_init_msg_list,
1173: x_return_status,
1174: x_msg_count,
1175: x_msg_data,

Line 1230: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;

1226: , p5_a35 JTF_NUMBER_TABLE
1227: )
1228:
1229: as
1230: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
1231: ddindx binary_integer; indx binary_integer;
1232: begin
1233:
1234: -- copy data to the local IN or IN-OUT args, if any

Line 1240: okl_vp_cat_pvt_w.rosetta_table_copy_in_p8(ddp_catv_tbl, p5_a0

1236:
1237:
1238:
1239:
1240: okl_vp_cat_pvt_w.rosetta_table_copy_in_p8(ddp_catv_tbl, p5_a0
1241: , p5_a1
1242: , p5_a2
1243: , p5_a3
1244: , p5_a4

Line 1279: okl_vp_cat_pvt.lock_row(p_api_version,

1275: , p5_a35
1276: );
1277:
1278: -- here's the delegated call to the old PL/SQL routine
1279: okl_vp_cat_pvt.lock_row(p_api_version,
1280: p_init_msg_list,
1281: x_return_status,
1282: x_msg_count,
1283: x_msg_data,

Line 1374: ddp_catv_rec okl_vp_cat_pvt.catv_rec_type;

1370: , p5_a35 NUMBER := 0-1962.0724
1371: )
1372:
1373: as
1374: ddp_catv_rec okl_vp_cat_pvt.catv_rec_type;
1375: ddx_catv_rec okl_vp_cat_pvt.catv_rec_type;
1376: ddindx binary_integer; indx binary_integer;
1377: begin
1378:

Line 1375: ddx_catv_rec okl_vp_cat_pvt.catv_rec_type;

1371: )
1372:
1373: as
1374: ddp_catv_rec okl_vp_cat_pvt.catv_rec_type;
1375: ddx_catv_rec okl_vp_cat_pvt.catv_rec_type;
1376: ddindx binary_integer; indx binary_integer;
1377: begin
1378:
1379: -- copy data to the local IN or IN-OUT args, if any

Line 1424: okl_vp_cat_pvt.update_row(p_api_version,

1420: ddp_catv_rec.last_update_login := rosetta_g_miss_num_map(p5_a35);
1421:
1422:
1423: -- here's the delegated call to the old PL/SQL routine
1424: okl_vp_cat_pvt.update_row(p_api_version,
1425: p_init_msg_list,
1426: x_return_status,
1427: x_msg_count,
1428: x_msg_data,

Line 1557: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;

1553: , p6_a35 out nocopy JTF_NUMBER_TABLE
1554: )
1555:
1556: as
1557: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
1558: ddx_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
1559: ddindx binary_integer; indx binary_integer;
1560: begin
1561:

Line 1558: ddx_catv_tbl okl_vp_cat_pvt.catv_tbl_type;

1554: )
1555:
1556: as
1557: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
1558: ddx_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
1559: ddindx binary_integer; indx binary_integer;
1560: begin
1561:
1562: -- copy data to the local IN or IN-OUT args, if any

Line 1568: okl_vp_cat_pvt_w.rosetta_table_copy_in_p8(ddp_catv_tbl, p5_a0

1564:
1565:
1566:
1567:
1568: okl_vp_cat_pvt_w.rosetta_table_copy_in_p8(ddp_catv_tbl, p5_a0
1569: , p5_a1
1570: , p5_a2
1571: , p5_a3
1572: , p5_a4

Line 1608: okl_vp_cat_pvt.update_row(p_api_version,

1604: );
1605:
1606:
1607: -- here's the delegated call to the old PL/SQL routine
1608: okl_vp_cat_pvt.update_row(p_api_version,
1609: p_init_msg_list,
1610: x_return_status,
1611: x_msg_count,
1612: x_msg_data,

Line 1623: okl_vp_cat_pvt_w.rosetta_table_copy_out_p8(ddx_catv_tbl, p6_a0

1619:
1620:
1621:
1622:
1623: okl_vp_cat_pvt_w.rosetta_table_copy_out_p8(ddx_catv_tbl, p6_a0
1624: , p6_a1
1625: , p6_a2
1626: , p6_a3
1627: , p6_a4

Line 1706: ddp_catv_rec okl_vp_cat_pvt.catv_rec_type;

1702: , p5_a35 NUMBER := 0-1962.0724
1703: )
1704:
1705: as
1706: ddp_catv_rec okl_vp_cat_pvt.catv_rec_type;
1707: ddindx binary_integer; indx binary_integer;
1708: begin
1709:
1710: -- copy data to the local IN or IN-OUT args, if any

Line 1754: okl_vp_cat_pvt.delete_row(p_api_version,

1750: ddp_catv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a34);
1751: ddp_catv_rec.last_update_login := rosetta_g_miss_num_map(p5_a35);
1752:
1753: -- here's the delegated call to the old PL/SQL routine
1754: okl_vp_cat_pvt.delete_row(p_api_version,
1755: p_init_msg_list,
1756: x_return_status,
1757: x_msg_count,
1758: x_msg_data,

Line 1813: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;

1809: , p5_a35 JTF_NUMBER_TABLE
1810: )
1811:
1812: as
1813: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
1814: ddindx binary_integer; indx binary_integer;
1815: begin
1816:
1817: -- copy data to the local IN or IN-OUT args, if any

Line 1823: okl_vp_cat_pvt_w.rosetta_table_copy_in_p8(ddp_catv_tbl, p5_a0

1819:
1820:
1821:
1822:
1823: okl_vp_cat_pvt_w.rosetta_table_copy_in_p8(ddp_catv_tbl, p5_a0
1824: , p5_a1
1825: , p5_a2
1826: , p5_a3
1827: , p5_a4

Line 1862: okl_vp_cat_pvt.delete_row(p_api_version,

1858: , p5_a35
1859: );
1860:
1861: -- here's the delegated call to the old PL/SQL routine
1862: okl_vp_cat_pvt.delete_row(p_api_version,
1863: p_init_msg_list,
1864: x_return_status,
1865: x_msg_count,
1866: x_msg_data,

Line 1921: ddp_catv_rec okl_vp_cat_pvt.catv_rec_type;

1917: , p5_a35 NUMBER := 0-1962.0724
1918: )
1919:
1920: as
1921: ddp_catv_rec okl_vp_cat_pvt.catv_rec_type;
1922: ddindx binary_integer; indx binary_integer;
1923: begin
1924:
1925: -- copy data to the local IN or IN-OUT args, if any

Line 1969: okl_vp_cat_pvt.validate_row(p_api_version,

1965: ddp_catv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a34);
1966: ddp_catv_rec.last_update_login := rosetta_g_miss_num_map(p5_a35);
1967:
1968: -- here's the delegated call to the old PL/SQL routine
1969: okl_vp_cat_pvt.validate_row(p_api_version,
1970: p_init_msg_list,
1971: x_return_status,
1972: x_msg_count,
1973: x_msg_data,

Line 2028: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;

2024: , p5_a35 JTF_NUMBER_TABLE
2025: )
2026:
2027: as
2028: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
2029: ddindx binary_integer; indx binary_integer;
2030: begin
2031:
2032: -- copy data to the local IN or IN-OUT args, if any

Line 2038: okl_vp_cat_pvt_w.rosetta_table_copy_in_p8(ddp_catv_tbl, p5_a0

2034:
2035:
2036:
2037:
2038: okl_vp_cat_pvt_w.rosetta_table_copy_in_p8(ddp_catv_tbl, p5_a0
2039: , p5_a1
2040: , p5_a2
2041: , p5_a3
2042: , p5_a4

Line 2077: okl_vp_cat_pvt.validate_row(p_api_version,

2073: , p5_a35
2074: );
2075:
2076: -- here's the delegated call to the old PL/SQL routine
2077: okl_vp_cat_pvt.validate_row(p_api_version,
2078: p_init_msg_list,
2079: x_return_status,
2080: x_msg_count,
2081: x_msg_data,

Line 2131: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;

2127: , p0_a35 JTF_NUMBER_TABLE
2128: )
2129:
2130: as
2131: ddp_catv_tbl okl_vp_cat_pvt.catv_tbl_type;
2132: ddindx binary_integer; indx binary_integer;
2133: begin
2134:
2135: -- copy data to the local IN or IN-OUT args, if any

Line 2136: okl_vp_cat_pvt_w.rosetta_table_copy_in_p8(ddp_catv_tbl, p0_a0

2132: ddindx binary_integer; indx binary_integer;
2133: begin
2134:
2135: -- copy data to the local IN or IN-OUT args, if any
2136: okl_vp_cat_pvt_w.rosetta_table_copy_in_p8(ddp_catv_tbl, p0_a0
2137: , p0_a1
2138: , p0_a2
2139: , p0_a3
2140: , p0_a4

Line 2175: okl_vp_cat_pvt.insert_row_upg(ddp_catv_tbl);

2171: , p0_a35
2172: );
2173:
2174: -- here's the delegated call to the old PL/SQL routine
2175: okl_vp_cat_pvt.insert_row_upg(ddp_catv_tbl);
2176:
2177: -- copy data back from the local variables to OUT or IN-OUT args, if any
2178: end;
2179:

Line 2180: end okl_vp_cat_pvt_w;

2176:
2177: -- copy data back from the local variables to OUT or IN-OUT args, if any
2178: end;
2179:
2180: end okl_vp_cat_pvt_w;