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_STY_PVT_W dependencies on OKL_STY_PVT

Line 1: package body okl_sty_pvt_w as

1: package body okl_sty_pvt_w as
2: /* $Header: OKLISTYB.pls 120.3 2008/01/29 17:21:19 gkadarka ship $ */
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_sty_pvt.sty_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_sty_pvt.sty_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

Line 121: procedure rosetta_table_copy_out_p2(t okl_sty_pvt.sty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

117: end loop;
118: end if;
119: end if;
120: end rosetta_table_copy_in_p2;
121: procedure rosetta_table_copy_out_p2(t okl_sty_pvt.sty_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
122: , a1 out nocopy JTF_VARCHAR2_TABLE_100
123: , a2 out nocopy JTF_VARCHAR2_TABLE_200
124: , a3 out nocopy JTF_VARCHAR2_TABLE_100
125: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 345: procedure rosetta_table_copy_in_p5(t out nocopy okl_sty_pvt.okl_strm_type_tl_tbl_type, a0 JTF_NUMBER_TABLE

341: end if;
342: end if;
343: end rosetta_table_copy_out_p2;
344:
345: procedure rosetta_table_copy_in_p5(t out nocopy okl_sty_pvt.okl_strm_type_tl_tbl_type, a0 JTF_NUMBER_TABLE
346: , a1 JTF_VARCHAR2_TABLE_100
347: , a2 JTF_VARCHAR2_TABLE_100
348: , a3 JTF_VARCHAR2_TABLE_100
349: , a4 JTF_VARCHAR2_TABLE_200

Line 386: procedure rosetta_table_copy_out_p5(t okl_sty_pvt.okl_strm_type_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

382: end loop;
383: end if;
384: end if;
385: end rosetta_table_copy_in_p5;
386: procedure rosetta_table_copy_out_p5(t okl_sty_pvt.okl_strm_type_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
387: , a1 out nocopy JTF_VARCHAR2_TABLE_100
388: , a2 out nocopy JTF_VARCHAR2_TABLE_100
389: , a3 out nocopy JTF_VARCHAR2_TABLE_100
390: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 465: procedure rosetta_table_copy_in_p8(t out nocopy okl_sty_pvt.styv_tbl_type, a0 JTF_NUMBER_TABLE

461: end if;
462: end if;
463: end rosetta_table_copy_out_p5;
464:
465: procedure rosetta_table_copy_in_p8(t out nocopy okl_sty_pvt.styv_tbl_type, a0 JTF_NUMBER_TABLE
466: , a1 JTF_VARCHAR2_TABLE_200
467: , a2 JTF_VARCHAR2_TABLE_100
468: , a3 JTF_NUMBER_TABLE
469: , a4 JTF_VARCHAR2_TABLE_200

Line 572: procedure rosetta_table_copy_out_p8(t okl_sty_pvt.styv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

568: end loop;
569: end if;
570: end if;
571: end rosetta_table_copy_in_p8;
572: procedure rosetta_table_copy_out_p8(t okl_sty_pvt.styv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
573: , a1 out nocopy JTF_VARCHAR2_TABLE_200
574: , a2 out nocopy JTF_VARCHAR2_TABLE_100
575: , a3 out nocopy JTF_NUMBER_TABLE
576: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 914: ddp_styv_rec okl_sty_pvt.styv_rec_type;

910: , p5_a44 NUMBER := 0-1962.0724
911: )
912:
913: as
914: ddp_styv_rec okl_sty_pvt.styv_rec_type;
915: ddx_styv_rec okl_sty_pvt.styv_rec_type;
916: ddindx binary_integer; indx binary_integer;
917: begin
918:

Line 915: ddx_styv_rec okl_sty_pvt.styv_rec_type;

911: )
912:
913: as
914: ddp_styv_rec okl_sty_pvt.styv_rec_type;
915: ddx_styv_rec okl_sty_pvt.styv_rec_type;
916: ddindx binary_integer; indx binary_integer;
917: begin
918:
919: -- copy data to the local IN or IN-OUT args, if any

Line 973: okl_sty_pvt.insert_row(p_api_version,

969: ddp_styv_rec.contingency_id := rosetta_g_miss_num_map(p5_a44);
970:
971:
972: -- here's the delegated call to the old PL/SQL routine
973: okl_sty_pvt.insert_row(p_api_version,
974: p_init_msg_list,
975: x_return_status,
976: x_msg_count,
977: x_msg_data,

Line 1133: ddp_styv_tbl okl_sty_pvt.styv_tbl_type;

1129: , p6_a44 out nocopy JTF_NUMBER_TABLE
1130: )
1131:
1132: as
1133: ddp_styv_tbl okl_sty_pvt.styv_tbl_type;
1134: ddx_styv_tbl okl_sty_pvt.styv_tbl_type;
1135: ddindx binary_integer; indx binary_integer;
1136: begin
1137:

Line 1134: ddx_styv_tbl okl_sty_pvt.styv_tbl_type;

1130: )
1131:
1132: as
1133: ddp_styv_tbl okl_sty_pvt.styv_tbl_type;
1134: ddx_styv_tbl okl_sty_pvt.styv_tbl_type;
1135: ddindx binary_integer; indx binary_integer;
1136: begin
1137:
1138: -- copy data to the local IN or IN-OUT args, if any

Line 1144: okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0

1140:
1141:
1142:
1143:
1144: okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0
1145: , p5_a1
1146: , p5_a2
1147: , p5_a3
1148: , p5_a4

Line 1193: okl_sty_pvt.insert_row(p_api_version,

1189: );
1190:
1191:
1192: -- here's the delegated call to the old PL/SQL routine
1193: okl_sty_pvt.insert_row(p_api_version,
1194: p_init_msg_list,
1195: x_return_status,
1196: x_msg_count,
1197: x_msg_data,

Line 1208: okl_sty_pvt_w.rosetta_table_copy_out_p8(ddx_styv_tbl, p6_a0

1204:
1205:
1206:
1207:
1208: okl_sty_pvt_w.rosetta_table_copy_out_p8(ddx_styv_tbl, p6_a0
1209: , p6_a1
1210: , p6_a2
1211: , p6_a3
1212: , p6_a4

Line 1309: ddp_styv_rec okl_sty_pvt.styv_rec_type;

1305: , p5_a44 NUMBER := 0-1962.0724
1306: )
1307:
1308: as
1309: ddp_styv_rec okl_sty_pvt.styv_rec_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 1366: okl_sty_pvt.lock_row(p_api_version,

1362: ddp_styv_rec.short_description := p5_a43;
1363: ddp_styv_rec.contingency_id := rosetta_g_miss_num_map(p5_a44);
1364:
1365: -- here's the delegated call to the old PL/SQL routine
1366: okl_sty_pvt.lock_row(p_api_version,
1367: p_init_msg_list,
1368: x_return_status,
1369: x_msg_count,
1370: x_msg_data,

Line 1434: ddp_styv_tbl okl_sty_pvt.styv_tbl_type;

1430: , p5_a44 JTF_NUMBER_TABLE
1431: )
1432:
1433: as
1434: ddp_styv_tbl okl_sty_pvt.styv_tbl_type;
1435: ddindx binary_integer; indx binary_integer;
1436: begin
1437:
1438: -- copy data to the local IN or IN-OUT args, if any

Line 1444: okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0

1440:
1441:
1442:
1443:
1444: okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0
1445: , p5_a1
1446: , p5_a2
1447: , p5_a3
1448: , p5_a4

Line 1492: okl_sty_pvt.lock_row(p_api_version,

1488: , p5_a44
1489: );
1490:
1491: -- here's the delegated call to the old PL/SQL routine
1492: okl_sty_pvt.lock_row(p_api_version,
1493: p_init_msg_list,
1494: x_return_status,
1495: x_msg_count,
1496: x_msg_data,

Line 1605: ddp_styv_rec okl_sty_pvt.styv_rec_type;

1601: , p5_a44 NUMBER := 0-1962.0724
1602: )
1603:
1604: as
1605: ddp_styv_rec okl_sty_pvt.styv_rec_type;
1606: ddx_styv_rec okl_sty_pvt.styv_rec_type;
1607: ddindx binary_integer; indx binary_integer;
1608: begin
1609:

Line 1606: ddx_styv_rec okl_sty_pvt.styv_rec_type;

1602: )
1603:
1604: as
1605: ddp_styv_rec okl_sty_pvt.styv_rec_type;
1606: ddx_styv_rec okl_sty_pvt.styv_rec_type;
1607: ddindx binary_integer; indx binary_integer;
1608: begin
1609:
1610: -- copy data to the local IN or IN-OUT args, if any

Line 1664: okl_sty_pvt.update_row(p_api_version,

1660: ddp_styv_rec.contingency_id := rosetta_g_miss_num_map(p5_a44);
1661:
1662:
1663: -- here's the delegated call to the old PL/SQL routine
1664: okl_sty_pvt.update_row(p_api_version,
1665: p_init_msg_list,
1666: x_return_status,
1667: x_msg_count,
1668: x_msg_data,

Line 1824: ddp_styv_tbl okl_sty_pvt.styv_tbl_type;

1820: , p6_a44 out nocopy JTF_NUMBER_TABLE
1821: )
1822:
1823: as
1824: ddp_styv_tbl okl_sty_pvt.styv_tbl_type;
1825: ddx_styv_tbl okl_sty_pvt.styv_tbl_type;
1826: ddindx binary_integer; indx binary_integer;
1827: begin
1828:

Line 1825: ddx_styv_tbl okl_sty_pvt.styv_tbl_type;

1821: )
1822:
1823: as
1824: ddp_styv_tbl okl_sty_pvt.styv_tbl_type;
1825: ddx_styv_tbl okl_sty_pvt.styv_tbl_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 1835: okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0

1831:
1832:
1833:
1834:
1835: okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0
1836: , p5_a1
1837: , p5_a2
1838: , p5_a3
1839: , p5_a4

Line 1884: okl_sty_pvt.update_row(p_api_version,

1880: );
1881:
1882:
1883: -- here's the delegated call to the old PL/SQL routine
1884: okl_sty_pvt.update_row(p_api_version,
1885: p_init_msg_list,
1886: x_return_status,
1887: x_msg_count,
1888: x_msg_data,

Line 1899: okl_sty_pvt_w.rosetta_table_copy_out_p8(ddx_styv_tbl, p6_a0

1895:
1896:
1897:
1898:
1899: okl_sty_pvt_w.rosetta_table_copy_out_p8(ddx_styv_tbl, p6_a0
1900: , p6_a1
1901: , p6_a2
1902: , p6_a3
1903: , p6_a4

Line 2000: ddp_styv_rec okl_sty_pvt.styv_rec_type;

1996: , p5_a44 NUMBER := 0-1962.0724
1997: )
1998:
1999: as
2000: ddp_styv_rec okl_sty_pvt.styv_rec_type;
2001: ddindx binary_integer; indx binary_integer;
2002: begin
2003:
2004: -- copy data to the local IN or IN-OUT args, if any

Line 2057: okl_sty_pvt.delete_row(p_api_version,

2053: ddp_styv_rec.short_description := p5_a43;
2054: ddp_styv_rec.contingency_id := rosetta_g_miss_num_map(p5_a44);
2055:
2056: -- here's the delegated call to the old PL/SQL routine
2057: okl_sty_pvt.delete_row(p_api_version,
2058: p_init_msg_list,
2059: x_return_status,
2060: x_msg_count,
2061: x_msg_data,

Line 2125: ddp_styv_tbl okl_sty_pvt.styv_tbl_type;

2121: , p5_a44 JTF_NUMBER_TABLE
2122: )
2123:
2124: as
2125: ddp_styv_tbl okl_sty_pvt.styv_tbl_type;
2126: ddindx binary_integer; indx binary_integer;
2127: begin
2128:
2129: -- copy data to the local IN or IN-OUT args, if any

Line 2135: okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0

2131:
2132:
2133:
2134:
2135: okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0
2136: , p5_a1
2137: , p5_a2
2138: , p5_a3
2139: , p5_a4

Line 2183: okl_sty_pvt.delete_row(p_api_version,

2179: , p5_a44
2180: );
2181:
2182: -- here's the delegated call to the old PL/SQL routine
2183: okl_sty_pvt.delete_row(p_api_version,
2184: p_init_msg_list,
2185: x_return_status,
2186: x_msg_count,
2187: x_msg_data,

Line 2251: ddp_styv_rec okl_sty_pvt.styv_rec_type;

2247: , p5_a44 NUMBER := 0-1962.0724
2248: )
2249:
2250: as
2251: ddp_styv_rec okl_sty_pvt.styv_rec_type;
2252: ddindx binary_integer; indx binary_integer;
2253: begin
2254:
2255: -- copy data to the local IN or IN-OUT args, if any

Line 2308: okl_sty_pvt.validate_row(p_api_version,

2304: ddp_styv_rec.short_description := p5_a43;
2305: ddp_styv_rec.contingency_id := rosetta_g_miss_num_map(p5_a44);
2306:
2307: -- here's the delegated call to the old PL/SQL routine
2308: okl_sty_pvt.validate_row(p_api_version,
2309: p_init_msg_list,
2310: x_return_status,
2311: x_msg_count,
2312: x_msg_data,

Line 2376: ddp_styv_tbl okl_sty_pvt.styv_tbl_type;

2372: , p5_a44 JTF_NUMBER_TABLE
2373: )
2374:
2375: as
2376: ddp_styv_tbl okl_sty_pvt.styv_tbl_type;
2377: ddindx binary_integer; indx binary_integer;
2378: begin
2379:
2380: -- copy data to the local IN or IN-OUT args, if any

Line 2386: okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0

2382:
2383:
2384:
2385:
2386: okl_sty_pvt_w.rosetta_table_copy_in_p8(ddp_styv_tbl, p5_a0
2387: , p5_a1
2388: , p5_a2
2389: , p5_a3
2390: , p5_a4

Line 2434: okl_sty_pvt.validate_row(p_api_version,

2430: , p5_a44
2431: );
2432:
2433: -- here's the delegated call to the old PL/SQL routine
2434: okl_sty_pvt.validate_row(p_api_version,
2435: p_init_msg_list,
2436: x_return_status,
2437: x_msg_count,
2438: x_msg_data,

Line 2449: end okl_sty_pvt_w;

2445:
2446:
2447: end;
2448:
2449: end okl_sty_pvt_w;