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_TIL_PVT_W dependencies on OKL_TIL_PVT

Line 1: package body okl_til_pvt_w as

1: package body okl_til_pvt_w as
2: /* $Header: OKLITILB.pls 120.4 2007/07/20 09:42:01 akrangan 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 25: procedure rosetta_table_copy_in_p2(t out nocopy okl_til_pvt.til_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_til_pvt.til_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE

Line 148: procedure rosetta_table_copy_out_p2(t okl_til_pvt.til_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

144: end loop;
145: end if;
146: end if;
147: end rosetta_table_copy_in_p2;
148: procedure rosetta_table_copy_out_p2(t okl_til_pvt.til_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
149: , a1 out nocopy JTF_VARCHAR2_TABLE_100
150: , a2 out nocopy JTF_NUMBER_TABLE
151: , a3 out nocopy JTF_NUMBER_TABLE
152: , a4 out nocopy JTF_NUMBER_TABLE

Line 432: procedure rosetta_table_copy_in_p5(t out nocopy okl_til_pvt.okl_txl_ar_inv_lns_tl_tbl_type, a0 JTF_NUMBER_TABLE

428: end if;
429: end if;
430: end rosetta_table_copy_out_p2;
431:
432: procedure rosetta_table_copy_in_p5(t out nocopy okl_til_pvt.okl_txl_ar_inv_lns_tl_tbl_type, a0 JTF_NUMBER_TABLE
433: , a1 JTF_VARCHAR2_TABLE_100
434: , a2 JTF_VARCHAR2_TABLE_100
435: , a3 JTF_VARCHAR2_TABLE_3000
436: , a4 JTF_VARCHAR2_TABLE_100

Line 471: procedure rosetta_table_copy_out_p5(t okl_til_pvt.okl_txl_ar_inv_lns_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

467: end loop;
468: end if;
469: end if;
470: end rosetta_table_copy_in_p5;
471: procedure rosetta_table_copy_out_p5(t okl_til_pvt.okl_txl_ar_inv_lns_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
472: , a1 out nocopy JTF_VARCHAR2_TABLE_100
473: , a2 out nocopy JTF_VARCHAR2_TABLE_100
474: , a3 out nocopy JTF_VARCHAR2_TABLE_3000
475: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 545: procedure rosetta_table_copy_in_p8(t out nocopy okl_til_pvt.tilv_tbl_type, a0 JTF_NUMBER_TABLE

541: end if;
542: end if;
543: end rosetta_table_copy_out_p5;
544:
545: procedure rosetta_table_copy_in_p8(t out nocopy okl_til_pvt.tilv_tbl_type, a0 JTF_NUMBER_TABLE
546: , a1 JTF_NUMBER_TABLE
547: , a2 JTF_VARCHAR2_TABLE_3000
548: , a3 JTF_VARCHAR2_TABLE_100
549: , a4 JTF_NUMBER_TABLE

Line 674: procedure rosetta_table_copy_out_p8(t okl_til_pvt.tilv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

670: end loop;
671: end if;
672: end if;
673: end rosetta_table_copy_in_p8;
674: procedure rosetta_table_copy_out_p8(t okl_til_pvt.tilv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
675: , a1 out nocopy JTF_NUMBER_TABLE
676: , a2 out nocopy JTF_VARCHAR2_TABLE_3000
677: , a3 out nocopy JTF_VARCHAR2_TABLE_100
678: , a4 out nocopy JTF_NUMBER_TABLE

Line 1093: ddp_tilv_rec okl_til_pvt.tilv_rec_type;

1089: , p5_a55 NUMBER := 0-1962.0724
1090: )
1091:
1092: as
1093: ddp_tilv_rec okl_til_pvt.tilv_rec_type;
1094: ddx_tilv_rec okl_til_pvt.tilv_rec_type;
1095: ddindx binary_integer; indx binary_integer;
1096: begin
1097:

Line 1094: ddx_tilv_rec okl_til_pvt.tilv_rec_type;

1090: )
1091:
1092: as
1093: ddp_tilv_rec okl_til_pvt.tilv_rec_type;
1094: ddx_tilv_rec okl_til_pvt.tilv_rec_type;
1095: ddindx binary_integer; indx binary_integer;
1096: begin
1097:
1098: -- copy data to the local IN or IN-OUT args, if any

Line 1163: okl_til_pvt.insert_row(p_api_version,

1159: ddp_tilv_rec.txs_trx_line_id := rosetta_g_miss_num_map(p5_a55);
1160:
1161:
1162: -- here's the delegated call to the old PL/SQL routine
1163: okl_til_pvt.insert_row(p_api_version,
1164: p_init_msg_list,
1165: x_return_status,
1166: x_msg_count,
1167: x_msg_data,

Line 1356: ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;

1352: , p6_a55 out nocopy JTF_NUMBER_TABLE
1353: )
1354:
1355: as
1356: ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;
1357: ddx_tilv_tbl okl_til_pvt.tilv_tbl_type;
1358: ddindx binary_integer; indx binary_integer;
1359: begin
1360:

Line 1357: ddx_tilv_tbl okl_til_pvt.tilv_tbl_type;

1353: )
1354:
1355: as
1356: ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;
1357: ddx_tilv_tbl okl_til_pvt.tilv_tbl_type;
1358: ddindx binary_integer; indx binary_integer;
1359: begin
1360:
1361: -- copy data to the local IN or IN-OUT args, if any

Line 1367: okl_til_pvt_w.rosetta_table_copy_in_p8(ddp_tilv_tbl, p5_a0

1363:
1364:
1365:
1366:
1367: okl_til_pvt_w.rosetta_table_copy_in_p8(ddp_tilv_tbl, p5_a0
1368: , p5_a1
1369: , p5_a2
1370: , p5_a3
1371: , p5_a4

Line 1427: okl_til_pvt.insert_row(p_api_version,

1423: );
1424:
1425:
1426: -- here's the delegated call to the old PL/SQL routine
1427: okl_til_pvt.insert_row(p_api_version,
1428: p_init_msg_list,
1429: x_return_status,
1430: x_msg_count,
1431: x_msg_data,

Line 1442: okl_til_pvt_w.rosetta_table_copy_out_p8(ddx_tilv_tbl, p6_a0

1438:
1439:
1440:
1441:
1442: okl_til_pvt_w.rosetta_table_copy_out_p8(ddx_tilv_tbl, p6_a0
1443: , p6_a1
1444: , p6_a2
1445: , p6_a3
1446: , p6_a4

Line 1565: ddp_tilv_rec okl_til_pvt.tilv_rec_type;

1561: , p5_a55 NUMBER := 0-1962.0724
1562: )
1563:
1564: as
1565: ddp_tilv_rec okl_til_pvt.tilv_rec_type;
1566: ddindx binary_integer; indx binary_integer;
1567: begin
1568:
1569: -- copy data to the local IN or IN-OUT args, if any

Line 1633: okl_til_pvt.lock_row(p_api_version,

1629: ddp_tilv_rec.txl_ar_line_number := rosetta_g_miss_num_map(p5_a54);
1630: ddp_tilv_rec.txs_trx_line_id := rosetta_g_miss_num_map(p5_a55);
1631:
1632: -- here's the delegated call to the old PL/SQL routine
1633: okl_til_pvt.lock_row(p_api_version,
1634: p_init_msg_list,
1635: x_return_status,
1636: x_msg_count,
1637: x_msg_data,

Line 1712: ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;

1708: , p5_a55 JTF_NUMBER_TABLE
1709: )
1710:
1711: as
1712: ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;
1713: ddindx binary_integer; indx binary_integer;
1714: begin
1715:
1716: -- copy data to the local IN or IN-OUT args, if any

Line 1722: okl_til_pvt_w.rosetta_table_copy_in_p8(ddp_tilv_tbl, p5_a0

1718:
1719:
1720:
1721:
1722: okl_til_pvt_w.rosetta_table_copy_in_p8(ddp_tilv_tbl, p5_a0
1723: , p5_a1
1724: , p5_a2
1725: , p5_a3
1726: , p5_a4

Line 1781: okl_til_pvt.lock_row(p_api_version,

1777: , p5_a55
1778: );
1779:
1780: -- here's the delegated call to the old PL/SQL routine
1781: okl_til_pvt.lock_row(p_api_version,
1782: p_init_msg_list,
1783: x_return_status,
1784: x_msg_count,
1785: x_msg_data,

Line 1916: ddp_tilv_rec okl_til_pvt.tilv_rec_type;

1912: , p5_a55 NUMBER := 0-1962.0724
1913: )
1914:
1915: as
1916: ddp_tilv_rec okl_til_pvt.tilv_rec_type;
1917: ddx_tilv_rec okl_til_pvt.tilv_rec_type;
1918: ddindx binary_integer; indx binary_integer;
1919: begin
1920:

Line 1917: ddx_tilv_rec okl_til_pvt.tilv_rec_type;

1913: )
1914:
1915: as
1916: ddp_tilv_rec okl_til_pvt.tilv_rec_type;
1917: ddx_tilv_rec okl_til_pvt.tilv_rec_type;
1918: ddindx binary_integer; indx binary_integer;
1919: begin
1920:
1921: -- copy data to the local IN or IN-OUT args, if any

Line 1986: okl_til_pvt.update_row(p_api_version,

1982: ddp_tilv_rec.txs_trx_line_id := rosetta_g_miss_num_map(p5_a55);
1983:
1984:
1985: -- here's the delegated call to the old PL/SQL routine
1986: okl_til_pvt.update_row(p_api_version,
1987: p_init_msg_list,
1988: x_return_status,
1989: x_msg_count,
1990: x_msg_data,

Line 2179: ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;

2175: , p6_a55 out nocopy JTF_NUMBER_TABLE
2176: )
2177:
2178: as
2179: ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;
2180: ddx_tilv_tbl okl_til_pvt.tilv_tbl_type;
2181: ddindx binary_integer; indx binary_integer;
2182: begin
2183:

Line 2180: ddx_tilv_tbl okl_til_pvt.tilv_tbl_type;

2176: )
2177:
2178: as
2179: ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;
2180: ddx_tilv_tbl okl_til_pvt.tilv_tbl_type;
2181: ddindx binary_integer; indx binary_integer;
2182: begin
2183:
2184: -- copy data to the local IN or IN-OUT args, if any

Line 2190: okl_til_pvt_w.rosetta_table_copy_in_p8(ddp_tilv_tbl, p5_a0

2186:
2187:
2188:
2189:
2190: okl_til_pvt_w.rosetta_table_copy_in_p8(ddp_tilv_tbl, p5_a0
2191: , p5_a1
2192: , p5_a2
2193: , p5_a3
2194: , p5_a4

Line 2250: okl_til_pvt.update_row(p_api_version,

2246: );
2247:
2248:
2249: -- here's the delegated call to the old PL/SQL routine
2250: okl_til_pvt.update_row(p_api_version,
2251: p_init_msg_list,
2252: x_return_status,
2253: x_msg_count,
2254: x_msg_data,

Line 2265: okl_til_pvt_w.rosetta_table_copy_out_p8(ddx_tilv_tbl, p6_a0

2261:
2262:
2263:
2264:
2265: okl_til_pvt_w.rosetta_table_copy_out_p8(ddx_tilv_tbl, p6_a0
2266: , p6_a1
2267: , p6_a2
2268: , p6_a3
2269: , p6_a4

Line 2388: ddp_tilv_rec okl_til_pvt.tilv_rec_type;

2384: , p5_a55 NUMBER := 0-1962.0724
2385: )
2386:
2387: as
2388: ddp_tilv_rec okl_til_pvt.tilv_rec_type;
2389: ddindx binary_integer; indx binary_integer;
2390: begin
2391:
2392: -- copy data to the local IN or IN-OUT args, if any

Line 2456: okl_til_pvt.delete_row(p_api_version,

2452: ddp_tilv_rec.txl_ar_line_number := rosetta_g_miss_num_map(p5_a54);
2453: ddp_tilv_rec.txs_trx_line_id := rosetta_g_miss_num_map(p5_a55);
2454:
2455: -- here's the delegated call to the old PL/SQL routine
2456: okl_til_pvt.delete_row(p_api_version,
2457: p_init_msg_list,
2458: x_return_status,
2459: x_msg_count,
2460: x_msg_data,

Line 2535: ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;

2531: , p5_a55 JTF_NUMBER_TABLE
2532: )
2533:
2534: as
2535: ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;
2536: ddindx binary_integer; indx binary_integer;
2537: begin
2538:
2539: -- copy data to the local IN or IN-OUT args, if any

Line 2545: okl_til_pvt_w.rosetta_table_copy_in_p8(ddp_tilv_tbl, p5_a0

2541:
2542:
2543:
2544:
2545: okl_til_pvt_w.rosetta_table_copy_in_p8(ddp_tilv_tbl, p5_a0
2546: , p5_a1
2547: , p5_a2
2548: , p5_a3
2549: , p5_a4

Line 2604: okl_til_pvt.delete_row(p_api_version,

2600: , p5_a55
2601: );
2602:
2603: -- here's the delegated call to the old PL/SQL routine
2604: okl_til_pvt.delete_row(p_api_version,
2605: p_init_msg_list,
2606: x_return_status,
2607: x_msg_count,
2608: x_msg_data,

Line 2683: ddp_tilv_rec okl_til_pvt.tilv_rec_type;

2679: , p5_a55 NUMBER := 0-1962.0724
2680: )
2681:
2682: as
2683: ddp_tilv_rec okl_til_pvt.tilv_rec_type;
2684: ddindx binary_integer; indx binary_integer;
2685: begin
2686:
2687: -- copy data to the local IN or IN-OUT args, if any

Line 2751: okl_til_pvt.validate_row(p_api_version,

2747: ddp_tilv_rec.txl_ar_line_number := rosetta_g_miss_num_map(p5_a54);
2748: ddp_tilv_rec.txs_trx_line_id := rosetta_g_miss_num_map(p5_a55);
2749:
2750: -- here's the delegated call to the old PL/SQL routine
2751: okl_til_pvt.validate_row(p_api_version,
2752: p_init_msg_list,
2753: x_return_status,
2754: x_msg_count,
2755: x_msg_data,

Line 2830: ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;

2826: , p5_a55 JTF_NUMBER_TABLE
2827: )
2828:
2829: as
2830: ddp_tilv_tbl okl_til_pvt.tilv_tbl_type;
2831: ddindx binary_integer; indx binary_integer;
2832: begin
2833:
2834: -- copy data to the local IN or IN-OUT args, if any

Line 2840: okl_til_pvt_w.rosetta_table_copy_in_p8(ddp_tilv_tbl, p5_a0

2836:
2837:
2838:
2839:
2840: okl_til_pvt_w.rosetta_table_copy_in_p8(ddp_tilv_tbl, p5_a0
2841: , p5_a1
2842: , p5_a2
2843: , p5_a3
2844: , p5_a4

Line 2899: okl_til_pvt.validate_row(p_api_version,

2895: , p5_a55
2896: );
2897:
2898: -- here's the delegated call to the old PL/SQL routine
2899: okl_til_pvt.validate_row(p_api_version,
2900: p_init_msg_list,
2901: x_return_status,
2902: x_msg_count,
2903: x_msg_data,

Line 2914: end okl_til_pvt_w;

2910:
2911:
2912: end;
2913:
2914: end okl_til_pvt_w;