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_TLD_PVT_W dependencies on OKL_TLD_PVT

Line 1: package body okl_tld_pvt_w as

1: package body okl_tld_pvt_w as
2: /* $Header: OKLITLDB.pls 120.0 2007/07/17 06:15:56 gkhuntet 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: 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_tld_pvt.tld_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_tld_pvt.tld_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_NUMBER_TABLE

Line 168: procedure rosetta_table_copy_out_p2(t okl_tld_pvt.tld_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

164: end loop;
165: end if;
166: end if;
167: end rosetta_table_copy_in_p2;
168: procedure rosetta_table_copy_out_p2(t okl_tld_pvt.tld_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
169: , a1 out nocopy JTF_NUMBER_TABLE
170: , a2 out nocopy JTF_NUMBER_TABLE
171: , a3 out nocopy JTF_NUMBER_TABLE
172: , a4 out nocopy JTF_NUMBER_TABLE

Line 502: procedure rosetta_table_copy_in_p5(t out nocopy okl_tld_pvt.okl_txd_ar_ln_dtls_tl_tbl_type, a0 JTF_NUMBER_TABLE

498: end if;
499: end if;
500: end rosetta_table_copy_out_p2;
501:
502: procedure rosetta_table_copy_in_p5(t out nocopy okl_tld_pvt.okl_txd_ar_ln_dtls_tl_tbl_type, a0 JTF_NUMBER_TABLE
503: , a1 JTF_VARCHAR2_TABLE_100
504: , a2 JTF_VARCHAR2_TABLE_100
505: , a3 JTF_VARCHAR2_TABLE_3000
506: , a4 JTF_VARCHAR2_TABLE_100

Line 541: procedure rosetta_table_copy_out_p5(t okl_tld_pvt.okl_txd_ar_ln_dtls_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

537: end loop;
538: end if;
539: end if;
540: end rosetta_table_copy_in_p5;
541: procedure rosetta_table_copy_out_p5(t okl_tld_pvt.okl_txd_ar_ln_dtls_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
542: , a1 out nocopy JTF_VARCHAR2_TABLE_100
543: , a2 out nocopy JTF_VARCHAR2_TABLE_100
544: , a3 out nocopy JTF_VARCHAR2_TABLE_3000
545: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 615: procedure rosetta_table_copy_in_p8(t out nocopy okl_tld_pvt.tldv_tbl_type, a0 JTF_NUMBER_TABLE

611: end if;
612: end if;
613: end rosetta_table_copy_out_p5;
614:
615: procedure rosetta_table_copy_in_p8(t out nocopy okl_tld_pvt.tldv_tbl_type, a0 JTF_NUMBER_TABLE
616: , a1 JTF_NUMBER_TABLE
617: , a2 JTF_VARCHAR2_TABLE_3000
618: , a3 JTF_VARCHAR2_TABLE_100
619: , a4 JTF_NUMBER_TABLE

Line 764: procedure rosetta_table_copy_out_p8(t okl_tld_pvt.tldv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

760: end loop;
761: end if;
762: end if;
763: end rosetta_table_copy_in_p8;
764: procedure rosetta_table_copy_out_p8(t okl_tld_pvt.tldv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
765: , a1 out nocopy JTF_NUMBER_TABLE
766: , a2 out nocopy JTF_VARCHAR2_TABLE_3000
767: , a3 out nocopy JTF_VARCHAR2_TABLE_100
768: , a4 out nocopy JTF_NUMBER_TABLE

Line 1253: ddp_tldv_rec okl_tld_pvt.tldv_rec_type;

1249: , p5_a65 NUMBER := 0-1962.0724
1250: )
1251:
1252: as
1253: ddp_tldv_rec okl_tld_pvt.tldv_rec_type;
1254: ddx_tldv_rec okl_tld_pvt.tldv_rec_type;
1255: ddindx binary_integer; indx binary_integer;
1256: begin
1257:

Line 1254: ddx_tldv_rec okl_tld_pvt.tldv_rec_type;

1250: )
1251:
1252: as
1253: ddp_tldv_rec okl_tld_pvt.tldv_rec_type;
1254: ddx_tldv_rec okl_tld_pvt.tldv_rec_type;
1255: ddindx binary_integer; indx binary_integer;
1256: begin
1257:
1258: -- copy data to the local IN or IN-OUT args, if any

Line 1333: okl_tld_pvt.insert_row(p_api_version,

1329: ddp_tldv_rec.tax_amount := rosetta_g_miss_num_map(p5_a65);
1330:
1331:
1332: -- here's the delegated call to the old PL/SQL routine
1333: okl_tld_pvt.insert_row(p_api_version,
1334: p_init_msg_list,
1335: x_return_status,
1336: x_msg_count,
1337: x_msg_data,

Line 1556: ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;

1552: , p6_a65 out nocopy JTF_NUMBER_TABLE
1553: )
1554:
1555: as
1556: ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1557: ddx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1558: ddindx binary_integer; indx binary_integer;
1559: begin
1560:

Line 1557: ddx_tldv_tbl okl_tld_pvt.tldv_tbl_type;

1553: )
1554:
1555: as
1556: ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1557: ddx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1558: ddindx binary_integer; indx binary_integer;
1559: begin
1560:
1561: -- copy data to the local IN or IN-OUT args, if any

Line 1567: okl_tld_pvt_w.rosetta_table_copy_in_p8(ddp_tldv_tbl, p5_a0

1563:
1564:
1565:
1566:
1567: okl_tld_pvt_w.rosetta_table_copy_in_p8(ddp_tldv_tbl, p5_a0
1568: , p5_a1
1569: , p5_a2
1570: , p5_a3
1571: , p5_a4

Line 1637: okl_tld_pvt.insert_row(p_api_version,

1633: );
1634:
1635:
1636: -- here's the delegated call to the old PL/SQL routine
1637: okl_tld_pvt.insert_row(p_api_version,
1638: p_init_msg_list,
1639: x_return_status,
1640: x_msg_count,
1641: x_msg_data,

Line 1652: okl_tld_pvt_w.rosetta_table_copy_out_p8(ddx_tldv_tbl, p6_a0

1648:
1649:
1650:
1651:
1652: okl_tld_pvt_w.rosetta_table_copy_out_p8(ddx_tldv_tbl, p6_a0
1653: , p6_a1
1654: , p6_a2
1655: , p6_a3
1656: , p6_a4

Line 1795: ddp_tldv_rec okl_tld_pvt.tldv_rec_type;

1791: , p5_a65 NUMBER := 0-1962.0724
1792: )
1793:
1794: as
1795: ddp_tldv_rec okl_tld_pvt.tldv_rec_type;
1796: ddindx binary_integer; indx binary_integer;
1797: begin
1798:
1799: -- copy data to the local IN or IN-OUT args, if any

Line 1873: okl_tld_pvt.lock_row(p_api_version,

1869: ddp_tldv_rec.kle_id := rosetta_g_miss_num_map(p5_a64);
1870: ddp_tldv_rec.tax_amount := rosetta_g_miss_num_map(p5_a65);
1871:
1872: -- here's the delegated call to the old PL/SQL routine
1873: okl_tld_pvt.lock_row(p_api_version,
1874: p_init_msg_list,
1875: x_return_status,
1876: x_msg_count,
1877: x_msg_data,

Line 1962: ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;

1958: , p5_a65 JTF_NUMBER_TABLE
1959: )
1960:
1961: as
1962: ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
1963: ddindx binary_integer; indx binary_integer;
1964: begin
1965:
1966: -- copy data to the local IN or IN-OUT args, if any

Line 1972: okl_tld_pvt_w.rosetta_table_copy_in_p8(ddp_tldv_tbl, p5_a0

1968:
1969:
1970:
1971:
1972: okl_tld_pvt_w.rosetta_table_copy_in_p8(ddp_tldv_tbl, p5_a0
1973: , p5_a1
1974: , p5_a2
1975: , p5_a3
1976: , p5_a4

Line 2041: okl_tld_pvt.lock_row(p_api_version,

2037: , p5_a65
2038: );
2039:
2040: -- here's the delegated call to the old PL/SQL routine
2041: okl_tld_pvt.lock_row(p_api_version,
2042: p_init_msg_list,
2043: x_return_status,
2044: x_msg_count,
2045: x_msg_data,

Line 2196: ddp_tldv_rec okl_tld_pvt.tldv_rec_type;

2192: , p5_a65 NUMBER := 0-1962.0724
2193: )
2194:
2195: as
2196: ddp_tldv_rec okl_tld_pvt.tldv_rec_type;
2197: ddx_tldv_rec okl_tld_pvt.tldv_rec_type;
2198: ddindx binary_integer; indx binary_integer;
2199: begin
2200:

Line 2197: ddx_tldv_rec okl_tld_pvt.tldv_rec_type;

2193: )
2194:
2195: as
2196: ddp_tldv_rec okl_tld_pvt.tldv_rec_type;
2197: ddx_tldv_rec okl_tld_pvt.tldv_rec_type;
2198: ddindx binary_integer; indx binary_integer;
2199: begin
2200:
2201: -- copy data to the local IN or IN-OUT args, if any

Line 2276: okl_tld_pvt.update_row(p_api_version,

2272: ddp_tldv_rec.tax_amount := rosetta_g_miss_num_map(p5_a65);
2273:
2274:
2275: -- here's the delegated call to the old PL/SQL routine
2276: okl_tld_pvt.update_row(p_api_version,
2277: p_init_msg_list,
2278: x_return_status,
2279: x_msg_count,
2280: x_msg_data,

Line 2499: ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;

2495: , p6_a65 out nocopy JTF_NUMBER_TABLE
2496: )
2497:
2498: as
2499: ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2500: ddx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2501: ddindx binary_integer; indx binary_integer;
2502: begin
2503:

Line 2500: ddx_tldv_tbl okl_tld_pvt.tldv_tbl_type;

2496: )
2497:
2498: as
2499: ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2500: ddx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2501: ddindx binary_integer; indx binary_integer;
2502: begin
2503:
2504: -- copy data to the local IN or IN-OUT args, if any

Line 2510: okl_tld_pvt_w.rosetta_table_copy_in_p8(ddp_tldv_tbl, p5_a0

2506:
2507:
2508:
2509:
2510: okl_tld_pvt_w.rosetta_table_copy_in_p8(ddp_tldv_tbl, p5_a0
2511: , p5_a1
2512: , p5_a2
2513: , p5_a3
2514: , p5_a4

Line 2580: okl_tld_pvt.update_row(p_api_version,

2576: );
2577:
2578:
2579: -- here's the delegated call to the old PL/SQL routine
2580: okl_tld_pvt.update_row(p_api_version,
2581: p_init_msg_list,
2582: x_return_status,
2583: x_msg_count,
2584: x_msg_data,

Line 2595: okl_tld_pvt_w.rosetta_table_copy_out_p8(ddx_tldv_tbl, p6_a0

2591:
2592:
2593:
2594:
2595: okl_tld_pvt_w.rosetta_table_copy_out_p8(ddx_tldv_tbl, p6_a0
2596: , p6_a1
2597: , p6_a2
2598: , p6_a3
2599: , p6_a4

Line 2738: ddp_tldv_rec okl_tld_pvt.tldv_rec_type;

2734: , p5_a65 NUMBER := 0-1962.0724
2735: )
2736:
2737: as
2738: ddp_tldv_rec okl_tld_pvt.tldv_rec_type;
2739: ddindx binary_integer; indx binary_integer;
2740: begin
2741:
2742: -- copy data to the local IN or IN-OUT args, if any

Line 2816: okl_tld_pvt.delete_row(p_api_version,

2812: ddp_tldv_rec.kle_id := rosetta_g_miss_num_map(p5_a64);
2813: ddp_tldv_rec.tax_amount := rosetta_g_miss_num_map(p5_a65);
2814:
2815: -- here's the delegated call to the old PL/SQL routine
2816: okl_tld_pvt.delete_row(p_api_version,
2817: p_init_msg_list,
2818: x_return_status,
2819: x_msg_count,
2820: x_msg_data,

Line 2905: ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;

2901: , p5_a65 JTF_NUMBER_TABLE
2902: )
2903:
2904: as
2905: ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
2906: ddindx binary_integer; indx binary_integer;
2907: begin
2908:
2909: -- copy data to the local IN or IN-OUT args, if any

Line 2915: okl_tld_pvt_w.rosetta_table_copy_in_p8(ddp_tldv_tbl, p5_a0

2911:
2912:
2913:
2914:
2915: okl_tld_pvt_w.rosetta_table_copy_in_p8(ddp_tldv_tbl, p5_a0
2916: , p5_a1
2917: , p5_a2
2918: , p5_a3
2919: , p5_a4

Line 2984: okl_tld_pvt.delete_row(p_api_version,

2980: , p5_a65
2981: );
2982:
2983: -- here's the delegated call to the old PL/SQL routine
2984: okl_tld_pvt.delete_row(p_api_version,
2985: p_init_msg_list,
2986: x_return_status,
2987: x_msg_count,
2988: x_msg_data,

Line 3073: ddp_tldv_rec okl_tld_pvt.tldv_rec_type;

3069: , p5_a65 NUMBER := 0-1962.0724
3070: )
3071:
3072: as
3073: ddp_tldv_rec okl_tld_pvt.tldv_rec_type;
3074: ddindx binary_integer; indx binary_integer;
3075: begin
3076:
3077: -- copy data to the local IN or IN-OUT args, if any

Line 3151: okl_tld_pvt.validate_row(p_api_version,

3147: ddp_tldv_rec.kle_id := rosetta_g_miss_num_map(p5_a64);
3148: ddp_tldv_rec.tax_amount := rosetta_g_miss_num_map(p5_a65);
3149:
3150: -- here's the delegated call to the old PL/SQL routine
3151: okl_tld_pvt.validate_row(p_api_version,
3152: p_init_msg_list,
3153: x_return_status,
3154: x_msg_count,
3155: x_msg_data,

Line 3240: ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;

3236: , p5_a65 JTF_NUMBER_TABLE
3237: )
3238:
3239: as
3240: ddp_tldv_tbl okl_tld_pvt.tldv_tbl_type;
3241: ddindx binary_integer; indx binary_integer;
3242: begin
3243:
3244: -- copy data to the local IN or IN-OUT args, if any

Line 3250: okl_tld_pvt_w.rosetta_table_copy_in_p8(ddp_tldv_tbl, p5_a0

3246:
3247:
3248:
3249:
3250: okl_tld_pvt_w.rosetta_table_copy_in_p8(ddp_tldv_tbl, p5_a0
3251: , p5_a1
3252: , p5_a2
3253: , p5_a3
3254: , p5_a4

Line 3319: okl_tld_pvt.validate_row(p_api_version,

3315: , p5_a65
3316: );
3317:
3318: -- here's the delegated call to the old PL/SQL routine
3319: okl_tld_pvt.validate_row(p_api_version,
3320: p_init_msg_list,
3321: x_return_status,
3322: x_msg_count,
3323: x_msg_data,

Line 3334: end okl_tld_pvt_w;

3330:
3331:
3332: end;
3333:
3334: end okl_tld_pvt_w;