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_SIF_PVT_W dependencies on OKL_SIF_PVT

Line 1: package body okl_sif_pvt_w as

1: package body okl_sif_pvt_w as
2: /* $Header: OKLISIFB.pls 115.9 2002/12/23 06:41:51 smahapat 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_sif_pvt.sif_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_sif_pvt.sif_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_VARCHAR2_TABLE_200

Line 155: procedure rosetta_table_copy_out_p2(t okl_sif_pvt.sif_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

151: end loop;
152: end if;
153: end if;
154: end rosetta_table_copy_in_p2;
155: procedure rosetta_table_copy_out_p2(t okl_sif_pvt.sif_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
156: , a1 out nocopy JTF_NUMBER_TABLE
157: , a2 out nocopy JTF_VARCHAR2_TABLE_100
158: , a3 out nocopy JTF_DATE_TABLE
159: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 464: procedure rosetta_table_copy_in_p5(t out nocopy okl_sif_pvt.sifv_tbl_type, a0 JTF_NUMBER_TABLE

460: end if;
461: end if;
462: end rosetta_table_copy_out_p2;
463:
464: procedure rosetta_table_copy_in_p5(t out nocopy okl_sif_pvt.sifv_tbl_type, a0 JTF_NUMBER_TABLE
465: , a1 JTF_NUMBER_TABLE
466: , a2 JTF_VARCHAR2_TABLE_100
467: , a3 JTF_DATE_TABLE
468: , a4 JTF_VARCHAR2_TABLE_200

Line 597: procedure rosetta_table_copy_out_p5(t okl_sif_pvt.sifv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

593: end loop;
594: end if;
595: end if;
596: end rosetta_table_copy_in_p5;
597: procedure rosetta_table_copy_out_p5(t okl_sif_pvt.sifv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
598: , a1 out nocopy JTF_NUMBER_TABLE
599: , a2 out nocopy JTF_VARCHAR2_TABLE_100
600: , a3 out nocopy JTF_DATE_TABLE
601: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 1030: ddp_sifv_rec okl_sif_pvt.sifv_rec_type;

1026: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1027: )
1028:
1029: as
1030: ddp_sifv_rec okl_sif_pvt.sifv_rec_type;
1031: ddx_sifv_rec okl_sif_pvt.sifv_rec_type;
1032: ddindx binary_integer; indx binary_integer;
1033: begin
1034:

Line 1031: ddx_sifv_rec okl_sif_pvt.sifv_rec_type;

1027: )
1028:
1029: as
1030: ddp_sifv_rec okl_sif_pvt.sifv_rec_type;
1031: ddx_sifv_rec okl_sif_pvt.sifv_rec_type;
1032: ddindx binary_integer; indx binary_integer;
1033: begin
1034:
1035: -- copy data to the local IN or IN-OUT args, if any

Line 1102: okl_sif_pvt.insert_row(p_api_version,

1098: ddp_sifv_rec.purpose_code := p5_a57;
1099:
1100:
1101: -- here's the delegated call to the old PL/SQL routine
1102: okl_sif_pvt.insert_row(p_api_version,
1103: p_init_msg_list,
1104: x_return_status,
1105: x_msg_count,
1106: x_msg_data,

Line 1301: ddp_sifv_tbl okl_sif_pvt.sifv_tbl_type;

1297: , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
1298: )
1299:
1300: as
1301: ddp_sifv_tbl okl_sif_pvt.sifv_tbl_type;
1302: ddx_sifv_tbl okl_sif_pvt.sifv_tbl_type;
1303: ddindx binary_integer; indx binary_integer;
1304: begin
1305:

Line 1302: ddx_sifv_tbl okl_sif_pvt.sifv_tbl_type;

1298: )
1299:
1300: as
1301: ddp_sifv_tbl okl_sif_pvt.sifv_tbl_type;
1302: ddx_sifv_tbl okl_sif_pvt.sifv_tbl_type;
1303: ddindx binary_integer; indx binary_integer;
1304: begin
1305:
1306: -- copy data to the local IN or IN-OUT args, if any

Line 1312: okl_sif_pvt_w.rosetta_table_copy_in_p5(ddp_sifv_tbl, p5_a0

1308:
1309:
1310:
1311:
1312: okl_sif_pvt_w.rosetta_table_copy_in_p5(ddp_sifv_tbl, p5_a0
1313: , p5_a1
1314: , p5_a2
1315: , p5_a3
1316: , p5_a4

Line 1374: okl_sif_pvt.insert_row(p_api_version,

1370: );
1371:
1372:
1373: -- here's the delegated call to the old PL/SQL routine
1374: okl_sif_pvt.insert_row(p_api_version,
1375: p_init_msg_list,
1376: x_return_status,
1377: x_msg_count,
1378: x_msg_data,

Line 1389: okl_sif_pvt_w.rosetta_table_copy_out_p5(ddx_sifv_tbl, p6_a0

1385:
1386:
1387:
1388:
1389: okl_sif_pvt_w.rosetta_table_copy_out_p5(ddx_sifv_tbl, p6_a0
1390: , p6_a1
1391: , p6_a2
1392: , p6_a3
1393: , p6_a4

Line 1516: ddp_sifv_rec okl_sif_pvt.sifv_rec_type;

1512: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1513: )
1514:
1515: as
1516: ddp_sifv_rec okl_sif_pvt.sifv_rec_type;
1517: ddindx binary_integer; indx binary_integer;
1518: begin
1519:
1520: -- copy data to the local IN or IN-OUT args, if any

Line 1586: okl_sif_pvt.lock_row(p_api_version,

1582: ddp_sifv_rec.sif_id := rosetta_g_miss_num_map(p5_a56);
1583: ddp_sifv_rec.purpose_code := p5_a57;
1584:
1585: -- here's the delegated call to the old PL/SQL routine
1586: okl_sif_pvt.lock_row(p_api_version,
1587: p_init_msg_list,
1588: x_return_status,
1589: x_msg_count,
1590: x_msg_data,

Line 1667: ddp_sifv_tbl okl_sif_pvt.sifv_tbl_type;

1663: , p5_a57 JTF_VARCHAR2_TABLE_100
1664: )
1665:
1666: as
1667: ddp_sifv_tbl okl_sif_pvt.sifv_tbl_type;
1668: ddindx binary_integer; indx binary_integer;
1669: begin
1670:
1671: -- copy data to the local IN or IN-OUT args, if any

Line 1677: okl_sif_pvt_w.rosetta_table_copy_in_p5(ddp_sifv_tbl, p5_a0

1673:
1674:
1675:
1676:
1677: okl_sif_pvt_w.rosetta_table_copy_in_p5(ddp_sifv_tbl, p5_a0
1678: , p5_a1
1679: , p5_a2
1680: , p5_a3
1681: , p5_a4

Line 1738: okl_sif_pvt.lock_row(p_api_version,

1734: , p5_a57
1735: );
1736:
1737: -- here's the delegated call to the old PL/SQL routine
1738: okl_sif_pvt.lock_row(p_api_version,
1739: p_init_msg_list,
1740: x_return_status,
1741: x_msg_count,
1742: x_msg_data,

Line 1877: ddp_sifv_rec okl_sif_pvt.sifv_rec_type;

1873: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
1874: )
1875:
1876: as
1877: ddp_sifv_rec okl_sif_pvt.sifv_rec_type;
1878: ddx_sifv_rec okl_sif_pvt.sifv_rec_type;
1879: ddindx binary_integer; indx binary_integer;
1880: begin
1881:

Line 1878: ddx_sifv_rec okl_sif_pvt.sifv_rec_type;

1874: )
1875:
1876: as
1877: ddp_sifv_rec okl_sif_pvt.sifv_rec_type;
1878: ddx_sifv_rec okl_sif_pvt.sifv_rec_type;
1879: ddindx binary_integer; indx binary_integer;
1880: begin
1881:
1882: -- copy data to the local IN or IN-OUT args, if any

Line 1949: okl_sif_pvt.update_row(p_api_version,

1945: ddp_sifv_rec.purpose_code := p5_a57;
1946:
1947:
1948: -- here's the delegated call to the old PL/SQL routine
1949: okl_sif_pvt.update_row(p_api_version,
1950: p_init_msg_list,
1951: x_return_status,
1952: x_msg_count,
1953: x_msg_data,

Line 2148: ddp_sifv_tbl okl_sif_pvt.sifv_tbl_type;

2144: , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
2145: )
2146:
2147: as
2148: ddp_sifv_tbl okl_sif_pvt.sifv_tbl_type;
2149: ddx_sifv_tbl okl_sif_pvt.sifv_tbl_type;
2150: ddindx binary_integer; indx binary_integer;
2151: begin
2152:

Line 2149: ddx_sifv_tbl okl_sif_pvt.sifv_tbl_type;

2145: )
2146:
2147: as
2148: ddp_sifv_tbl okl_sif_pvt.sifv_tbl_type;
2149: ddx_sifv_tbl okl_sif_pvt.sifv_tbl_type;
2150: ddindx binary_integer; indx binary_integer;
2151: begin
2152:
2153: -- copy data to the local IN or IN-OUT args, if any

Line 2159: okl_sif_pvt_w.rosetta_table_copy_in_p5(ddp_sifv_tbl, p5_a0

2155:
2156:
2157:
2158:
2159: okl_sif_pvt_w.rosetta_table_copy_in_p5(ddp_sifv_tbl, p5_a0
2160: , p5_a1
2161: , p5_a2
2162: , p5_a3
2163: , p5_a4

Line 2221: okl_sif_pvt.update_row(p_api_version,

2217: );
2218:
2219:
2220: -- here's the delegated call to the old PL/SQL routine
2221: okl_sif_pvt.update_row(p_api_version,
2222: p_init_msg_list,
2223: x_return_status,
2224: x_msg_count,
2225: x_msg_data,

Line 2236: okl_sif_pvt_w.rosetta_table_copy_out_p5(ddx_sifv_tbl, p6_a0

2232:
2233:
2234:
2235:
2236: okl_sif_pvt_w.rosetta_table_copy_out_p5(ddx_sifv_tbl, p6_a0
2237: , p6_a1
2238: , p6_a2
2239: , p6_a3
2240: , p6_a4

Line 2363: ddp_sifv_rec okl_sif_pvt.sifv_rec_type;

2359: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
2360: )
2361:
2362: as
2363: ddp_sifv_rec okl_sif_pvt.sifv_rec_type;
2364: ddindx binary_integer; indx binary_integer;
2365: begin
2366:
2367: -- copy data to the local IN or IN-OUT args, if any

Line 2433: okl_sif_pvt.delete_row(p_api_version,

2429: ddp_sifv_rec.sif_id := rosetta_g_miss_num_map(p5_a56);
2430: ddp_sifv_rec.purpose_code := p5_a57;
2431:
2432: -- here's the delegated call to the old PL/SQL routine
2433: okl_sif_pvt.delete_row(p_api_version,
2434: p_init_msg_list,
2435: x_return_status,
2436: x_msg_count,
2437: x_msg_data,

Line 2514: ddp_sifv_tbl okl_sif_pvt.sifv_tbl_type;

2510: , p5_a57 JTF_VARCHAR2_TABLE_100
2511: )
2512:
2513: as
2514: ddp_sifv_tbl okl_sif_pvt.sifv_tbl_type;
2515: ddindx binary_integer; indx binary_integer;
2516: begin
2517:
2518: -- copy data to the local IN or IN-OUT args, if any

Line 2524: okl_sif_pvt_w.rosetta_table_copy_in_p5(ddp_sifv_tbl, p5_a0

2520:
2521:
2522:
2523:
2524: okl_sif_pvt_w.rosetta_table_copy_in_p5(ddp_sifv_tbl, p5_a0
2525: , p5_a1
2526: , p5_a2
2527: , p5_a3
2528: , p5_a4

Line 2585: okl_sif_pvt.delete_row(p_api_version,

2581: , p5_a57
2582: );
2583:
2584: -- here's the delegated call to the old PL/SQL routine
2585: okl_sif_pvt.delete_row(p_api_version,
2586: p_init_msg_list,
2587: x_return_status,
2588: x_msg_count,
2589: x_msg_data,

Line 2666: ddp_sifv_rec okl_sif_pvt.sifv_rec_type;

2662: , p5_a57 VARCHAR2 := fnd_api.g_miss_char
2663: )
2664:
2665: as
2666: ddp_sifv_rec okl_sif_pvt.sifv_rec_type;
2667: ddindx binary_integer; indx binary_integer;
2668: begin
2669:
2670: -- copy data to the local IN or IN-OUT args, if any

Line 2736: okl_sif_pvt.validate_row(p_api_version,

2732: ddp_sifv_rec.sif_id := rosetta_g_miss_num_map(p5_a56);
2733: ddp_sifv_rec.purpose_code := p5_a57;
2734:
2735: -- here's the delegated call to the old PL/SQL routine
2736: okl_sif_pvt.validate_row(p_api_version,
2737: p_init_msg_list,
2738: x_return_status,
2739: x_msg_count,
2740: x_msg_data,

Line 2817: ddp_sifv_tbl okl_sif_pvt.sifv_tbl_type;

2813: , p5_a57 JTF_VARCHAR2_TABLE_100
2814: )
2815:
2816: as
2817: ddp_sifv_tbl okl_sif_pvt.sifv_tbl_type;
2818: ddindx binary_integer; indx binary_integer;
2819: begin
2820:
2821: -- copy data to the local IN or IN-OUT args, if any

Line 2827: okl_sif_pvt_w.rosetta_table_copy_in_p5(ddp_sifv_tbl, p5_a0

2823:
2824:
2825:
2826:
2827: okl_sif_pvt_w.rosetta_table_copy_in_p5(ddp_sifv_tbl, p5_a0
2828: , p5_a1
2829: , p5_a2
2830: , p5_a3
2831: , p5_a4

Line 2888: okl_sif_pvt.validate_row(p_api_version,

2884: , p5_a57
2885: );
2886:
2887: -- here's the delegated call to the old PL/SQL routine
2888: okl_sif_pvt.validate_row(p_api_version,
2889: p_init_msg_list,
2890: x_return_status,
2891: x_msg_count,
2892: x_msg_data,

Line 2903: end okl_sif_pvt_w;

2899:
2900:
2901: end;
2902:
2903: end okl_sif_pvt_w;