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_TPL_PVT_W dependencies on OKL_TPL_PVT

Line 1: package body okl_tpl_pvt_w as

1: package body okl_tpl_pvt_w as
2: /* $Header: OKLITPLB.pls 120.2 2007/11/06 07:36:52 veramach 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_tpl_pvt.tpl_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_tpl_pvt.tpl_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_NUMBER_TABLE

Line 146: procedure rosetta_table_copy_out_p2(t okl_tpl_pvt.tpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

142: end loop;
143: end if;
144: end if;
145: end rosetta_table_copy_in_p2;
146: procedure rosetta_table_copy_out_p2(t okl_tpl_pvt.tpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
147: , a1 out nocopy JTF_VARCHAR2_TABLE_100
148: , a2 out nocopy JTF_NUMBER_TABLE
149: , a3 out nocopy JTF_VARCHAR2_TABLE_100
150: , a4 out nocopy JTF_NUMBER_TABLE

Line 425: procedure rosetta_table_copy_in_p5(t out nocopy okl_tpl_pvt.okl_txl_ap_inv_lns_tl_tbl_type, a0 JTF_NUMBER_TABLE

421: end if;
422: end if;
423: end rosetta_table_copy_out_p2;
424:
425: procedure rosetta_table_copy_in_p5(t out nocopy okl_tpl_pvt.okl_txl_ap_inv_lns_tl_tbl_type, a0 JTF_NUMBER_TABLE
426: , a1 JTF_VARCHAR2_TABLE_100
427: , a2 JTF_VARCHAR2_TABLE_100
428: , a3 JTF_VARCHAR2_TABLE_100
429: , a4 JTF_VARCHAR2_TABLE_2000

Line 462: procedure rosetta_table_copy_out_p5(t okl_tpl_pvt.okl_txl_ap_inv_lns_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

458: end loop;
459: end if;
460: end if;
461: end rosetta_table_copy_in_p5;
462: procedure rosetta_table_copy_out_p5(t okl_tpl_pvt.okl_txl_ap_inv_lns_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
463: , a1 out nocopy JTF_VARCHAR2_TABLE_100
464: , a2 out nocopy JTF_VARCHAR2_TABLE_100
465: , a3 out nocopy JTF_VARCHAR2_TABLE_100
466: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 531: procedure rosetta_table_copy_in_p8(t out nocopy okl_tpl_pvt.tplv_tbl_type, a0 JTF_NUMBER_TABLE

527: end if;
528: end if;
529: end rosetta_table_copy_out_p5;
530:
531: procedure rosetta_table_copy_in_p8(t out nocopy okl_tpl_pvt.tplv_tbl_type, a0 JTF_NUMBER_TABLE
532: , a1 JTF_NUMBER_TABLE
533: , a2 JTF_VARCHAR2_TABLE_100
534: , a3 JTF_NUMBER_TABLE
535: , a4 JTF_NUMBER_TABLE

Line 656: procedure rosetta_table_copy_out_p8(t okl_tpl_pvt.tplv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

652: end loop;
653: end if;
654: end if;
655: end rosetta_table_copy_in_p8;
656: procedure rosetta_table_copy_out_p8(t okl_tpl_pvt.tplv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
657: , a1 out nocopy JTF_NUMBER_TABLE
658: , a2 out nocopy JTF_VARCHAR2_TABLE_100
659: , a3 out nocopy JTF_NUMBER_TABLE
660: , a4 out nocopy JTF_NUMBER_TABLE

Line 1061: ddp_tplv_rec okl_tpl_pvt.tplv_rec_type;

1057: , p5_a53 NUMBER := 0-1962.0724
1058: )
1059:
1060: as
1061: ddp_tplv_rec okl_tpl_pvt.tplv_rec_type;
1062: ddx_tplv_rec okl_tpl_pvt.tplv_rec_type;
1063: ddindx binary_integer; indx binary_integer;
1064: begin
1065:

Line 1062: ddx_tplv_rec okl_tpl_pvt.tplv_rec_type;

1058: )
1059:
1060: as
1061: ddp_tplv_rec okl_tpl_pvt.tplv_rec_type;
1062: ddx_tplv_rec okl_tpl_pvt.tplv_rec_type;
1063: ddindx binary_integer; indx binary_integer;
1064: begin
1065:
1066: -- copy data to the local IN or IN-OUT args, if any

Line 1129: okl_tpl_pvt.insert_row(p_api_version,

1125: ddp_tplv_rec.tld_id := rosetta_g_miss_num_map(p5_a53);
1126:
1127:
1128: -- here's the delegated call to the old PL/SQL routine
1129: okl_tpl_pvt.insert_row(p_api_version,
1130: p_init_msg_list,
1131: x_return_status,
1132: x_msg_count,
1133: x_msg_data,

Line 1316: ddp_tplv_tbl okl_tpl_pvt.tplv_tbl_type;

1312: , p6_a53 out nocopy JTF_NUMBER_TABLE
1313: )
1314:
1315: as
1316: ddp_tplv_tbl okl_tpl_pvt.tplv_tbl_type;
1317: ddx_tplv_tbl okl_tpl_pvt.tplv_tbl_type;
1318: ddindx binary_integer; indx binary_integer;
1319: begin
1320:

Line 1317: ddx_tplv_tbl okl_tpl_pvt.tplv_tbl_type;

1313: )
1314:
1315: as
1316: ddp_tplv_tbl okl_tpl_pvt.tplv_tbl_type;
1317: ddx_tplv_tbl okl_tpl_pvt.tplv_tbl_type;
1318: ddindx binary_integer; indx binary_integer;
1319: begin
1320:
1321: -- copy data to the local IN or IN-OUT args, if any

Line 1327: okl_tpl_pvt_w.rosetta_table_copy_in_p8(ddp_tplv_tbl, p5_a0

1323:
1324:
1325:
1326:
1327: okl_tpl_pvt_w.rosetta_table_copy_in_p8(ddp_tplv_tbl, p5_a0
1328: , p5_a1
1329: , p5_a2
1330: , p5_a3
1331: , p5_a4

Line 1385: okl_tpl_pvt.insert_row(p_api_version,

1381: );
1382:
1383:
1384: -- here's the delegated call to the old PL/SQL routine
1385: okl_tpl_pvt.insert_row(p_api_version,
1386: p_init_msg_list,
1387: x_return_status,
1388: x_msg_count,
1389: x_msg_data,

Line 1400: okl_tpl_pvt_w.rosetta_table_copy_out_p8(ddx_tplv_tbl, p6_a0

1396:
1397:
1398:
1399:
1400: okl_tpl_pvt_w.rosetta_table_copy_out_p8(ddx_tplv_tbl, p6_a0
1401: , p6_a1
1402: , p6_a2
1403: , p6_a3
1404: , p6_a4

Line 1519: ddp_tplv_rec okl_tpl_pvt.tplv_rec_type;

1515: , p5_a53 NUMBER := 0-1962.0724
1516: )
1517:
1518: as
1519: ddp_tplv_rec okl_tpl_pvt.tplv_rec_type;
1520: ddindx binary_integer; indx binary_integer;
1521: begin
1522:
1523: -- copy data to the local IN or IN-OUT args, if any

Line 1585: okl_tpl_pvt.lock_row(p_api_version,

1581: ddp_tplv_rec.taxable_yn := p5_a52;
1582: ddp_tplv_rec.tld_id := rosetta_g_miss_num_map(p5_a53);
1583:
1584: -- here's the delegated call to the old PL/SQL routine
1585: okl_tpl_pvt.lock_row(p_api_version,
1586: p_init_msg_list,
1587: x_return_status,
1588: x_msg_count,
1589: x_msg_data,

Line 1662: ddp_tplv_tbl okl_tpl_pvt.tplv_tbl_type;

1658: , p5_a53 JTF_NUMBER_TABLE
1659: )
1660:
1661: as
1662: ddp_tplv_tbl okl_tpl_pvt.tplv_tbl_type;
1663: ddindx binary_integer; indx binary_integer;
1664: begin
1665:
1666: -- copy data to the local IN or IN-OUT args, if any

Line 1672: okl_tpl_pvt_w.rosetta_table_copy_in_p8(ddp_tplv_tbl, p5_a0

1668:
1669:
1670:
1671:
1672: okl_tpl_pvt_w.rosetta_table_copy_in_p8(ddp_tplv_tbl, p5_a0
1673: , p5_a1
1674: , p5_a2
1675: , p5_a3
1676: , p5_a4

Line 1729: okl_tpl_pvt.lock_row(p_api_version,

1725: , p5_a53
1726: );
1727:
1728: -- here's the delegated call to the old PL/SQL routine
1729: okl_tpl_pvt.lock_row(p_api_version,
1730: p_init_msg_list,
1731: x_return_status,
1732: x_msg_count,
1733: x_msg_data,

Line 1860: ddp_tplv_rec okl_tpl_pvt.tplv_rec_type;

1856: , p5_a53 NUMBER := 0-1962.0724
1857: )
1858:
1859: as
1860: ddp_tplv_rec okl_tpl_pvt.tplv_rec_type;
1861: ddx_tplv_rec okl_tpl_pvt.tplv_rec_type;
1862: ddindx binary_integer; indx binary_integer;
1863: begin
1864:

Line 1861: ddx_tplv_rec okl_tpl_pvt.tplv_rec_type;

1857: )
1858:
1859: as
1860: ddp_tplv_rec okl_tpl_pvt.tplv_rec_type;
1861: ddx_tplv_rec okl_tpl_pvt.tplv_rec_type;
1862: ddindx binary_integer; indx binary_integer;
1863: begin
1864:
1865: -- copy data to the local IN or IN-OUT args, if any

Line 1928: okl_tpl_pvt.update_row(p_api_version,

1924: ddp_tplv_rec.tld_id := rosetta_g_miss_num_map(p5_a53);
1925:
1926:
1927: -- here's the delegated call to the old PL/SQL routine
1928: okl_tpl_pvt.update_row(p_api_version,
1929: p_init_msg_list,
1930: x_return_status,
1931: x_msg_count,
1932: x_msg_data,

Line 2115: ddp_tplv_tbl okl_tpl_pvt.tplv_tbl_type;

2111: , p6_a53 out nocopy JTF_NUMBER_TABLE
2112: )
2113:
2114: as
2115: ddp_tplv_tbl okl_tpl_pvt.tplv_tbl_type;
2116: ddx_tplv_tbl okl_tpl_pvt.tplv_tbl_type;
2117: ddindx binary_integer; indx binary_integer;
2118: begin
2119:

Line 2116: ddx_tplv_tbl okl_tpl_pvt.tplv_tbl_type;

2112: )
2113:
2114: as
2115: ddp_tplv_tbl okl_tpl_pvt.tplv_tbl_type;
2116: ddx_tplv_tbl okl_tpl_pvt.tplv_tbl_type;
2117: ddindx binary_integer; indx binary_integer;
2118: begin
2119:
2120: -- copy data to the local IN or IN-OUT args, if any

Line 2126: okl_tpl_pvt_w.rosetta_table_copy_in_p8(ddp_tplv_tbl, p5_a0

2122:
2123:
2124:
2125:
2126: okl_tpl_pvt_w.rosetta_table_copy_in_p8(ddp_tplv_tbl, p5_a0
2127: , p5_a1
2128: , p5_a2
2129: , p5_a3
2130: , p5_a4

Line 2184: okl_tpl_pvt.update_row(p_api_version,

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

Line 2199: okl_tpl_pvt_w.rosetta_table_copy_out_p8(ddx_tplv_tbl, p6_a0

2195:
2196:
2197:
2198:
2199: okl_tpl_pvt_w.rosetta_table_copy_out_p8(ddx_tplv_tbl, p6_a0
2200: , p6_a1
2201: , p6_a2
2202: , p6_a3
2203: , p6_a4

Line 2318: ddp_tplv_rec okl_tpl_pvt.tplv_rec_type;

2314: , p5_a53 NUMBER := 0-1962.0724
2315: )
2316:
2317: as
2318: ddp_tplv_rec okl_tpl_pvt.tplv_rec_type;
2319: ddindx binary_integer; indx binary_integer;
2320: begin
2321:
2322: -- copy data to the local IN or IN-OUT args, if any

Line 2384: okl_tpl_pvt.delete_row(p_api_version,

2380: ddp_tplv_rec.taxable_yn := p5_a52;
2381: ddp_tplv_rec.tld_id := rosetta_g_miss_num_map(p5_a53);
2382:
2383: -- here's the delegated call to the old PL/SQL routine
2384: okl_tpl_pvt.delete_row(p_api_version,
2385: p_init_msg_list,
2386: x_return_status,
2387: x_msg_count,
2388: x_msg_data,

Line 2461: ddp_tplv_tbl okl_tpl_pvt.tplv_tbl_type;

2457: , p5_a53 JTF_NUMBER_TABLE
2458: )
2459:
2460: as
2461: ddp_tplv_tbl okl_tpl_pvt.tplv_tbl_type;
2462: ddindx binary_integer; indx binary_integer;
2463: begin
2464:
2465: -- copy data to the local IN or IN-OUT args, if any

Line 2471: okl_tpl_pvt_w.rosetta_table_copy_in_p8(ddp_tplv_tbl, p5_a0

2467:
2468:
2469:
2470:
2471: okl_tpl_pvt_w.rosetta_table_copy_in_p8(ddp_tplv_tbl, p5_a0
2472: , p5_a1
2473: , p5_a2
2474: , p5_a3
2475: , p5_a4

Line 2528: okl_tpl_pvt.delete_row(p_api_version,

2524: , p5_a53
2525: );
2526:
2527: -- here's the delegated call to the old PL/SQL routine
2528: okl_tpl_pvt.delete_row(p_api_version,
2529: p_init_msg_list,
2530: x_return_status,
2531: x_msg_count,
2532: x_msg_data,

Line 2605: ddp_tplv_rec okl_tpl_pvt.tplv_rec_type;

2601: , p5_a53 NUMBER := 0-1962.0724
2602: )
2603:
2604: as
2605: ddp_tplv_rec okl_tpl_pvt.tplv_rec_type;
2606: ddindx binary_integer; indx binary_integer;
2607: begin
2608:
2609: -- copy data to the local IN or IN-OUT args, if any

Line 2671: okl_tpl_pvt.validate_row(p_api_version,

2667: ddp_tplv_rec.taxable_yn := p5_a52;
2668: ddp_tplv_rec.tld_id := rosetta_g_miss_num_map(p5_a53);
2669:
2670: -- here's the delegated call to the old PL/SQL routine
2671: okl_tpl_pvt.validate_row(p_api_version,
2672: p_init_msg_list,
2673: x_return_status,
2674: x_msg_count,
2675: x_msg_data,

Line 2748: ddp_tplv_tbl okl_tpl_pvt.tplv_tbl_type;

2744: , p5_a53 JTF_NUMBER_TABLE
2745: )
2746:
2747: as
2748: ddp_tplv_tbl okl_tpl_pvt.tplv_tbl_type;
2749: ddindx binary_integer; indx binary_integer;
2750: begin
2751:
2752: -- copy data to the local IN or IN-OUT args, if any

Line 2758: okl_tpl_pvt_w.rosetta_table_copy_in_p8(ddp_tplv_tbl, p5_a0

2754:
2755:
2756:
2757:
2758: okl_tpl_pvt_w.rosetta_table_copy_in_p8(ddp_tplv_tbl, p5_a0
2759: , p5_a1
2760: , p5_a2
2761: , p5_a3
2762: , p5_a4

Line 2815: okl_tpl_pvt.validate_row(p_api_version,

2811: , p5_a53
2812: );
2813:
2814: -- here's the delegated call to the old PL/SQL routine
2815: okl_tpl_pvt.validate_row(p_api_version,
2816: p_init_msg_list,
2817: x_return_status,
2818: x_msg_count,
2819: x_msg_data,

Line 2830: end okl_tpl_pvt_w;

2826:
2827:
2828: end;
2829:
2830: end okl_tpl_pvt_w;