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_TAI_PVT_W dependencies on OKL_TAI_PVT

Line 1: package body okl_tai_pvt_w as

1: package body okl_tai_pvt_w as
2: /* $Header: OKLITAIB.pls 120.8 2007/11/06 14:13:41 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_tai_pvt.tai_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_tai_pvt.tai_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_DATE_TABLE

Line 186: procedure rosetta_table_copy_out_p2(t okl_tai_pvt.tai_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

182: end loop;
183: end if;
184: end if;
185: end rosetta_table_copy_in_p2;
186: procedure rosetta_table_copy_out_p2(t okl_tai_pvt.tai_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
187: , a1 out nocopy JTF_VARCHAR2_TABLE_100
188: , a2 out nocopy JTF_VARCHAR2_TABLE_100
189: , a3 out nocopy JTF_NUMBER_TABLE
190: , a4 out nocopy JTF_DATE_TABLE

Line 565: procedure rosetta_table_copy_in_p5(t out nocopy okl_tai_pvt.okltrxarinvoicestltbltype, a0 JTF_NUMBER_TABLE

561: end if;
562: end if;
563: end rosetta_table_copy_out_p2;
564:
565: procedure rosetta_table_copy_in_p5(t out nocopy okl_tai_pvt.okltrxarinvoicestltbltype, a0 JTF_NUMBER_TABLE
566: , a1 JTF_VARCHAR2_TABLE_100
567: , a2 JTF_VARCHAR2_TABLE_100
568: , a3 JTF_VARCHAR2_TABLE_100
569: , a4 JTF_VARCHAR2_TABLE_2000

Line 602: procedure rosetta_table_copy_out_p5(t okl_tai_pvt.okltrxarinvoicestltbltype, a0 out nocopy JTF_NUMBER_TABLE

598: end loop;
599: end if;
600: end if;
601: end rosetta_table_copy_in_p5;
602: procedure rosetta_table_copy_out_p5(t okl_tai_pvt.okltrxarinvoicestltbltype, a0 out nocopy JTF_NUMBER_TABLE
603: , a1 out nocopy JTF_VARCHAR2_TABLE_100
604: , a2 out nocopy JTF_VARCHAR2_TABLE_100
605: , a3 out nocopy JTF_VARCHAR2_TABLE_100
606: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 671: procedure rosetta_table_copy_in_p8(t out nocopy okl_tai_pvt.taiv_tbl_type, a0 JTF_NUMBER_TABLE

667: end if;
668: end if;
669: end rosetta_table_copy_out_p5;
670:
671: procedure rosetta_table_copy_in_p8(t out nocopy okl_tai_pvt.taiv_tbl_type, a0 JTF_NUMBER_TABLE
672: , a1 JTF_NUMBER_TABLE
673: , a2 JTF_VARCHAR2_TABLE_100
674: , a3 JTF_VARCHAR2_TABLE_100
675: , a4 JTF_VARCHAR2_TABLE_100

Line 836: procedure rosetta_table_copy_out_p8(t okl_tai_pvt.taiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

832: end loop;
833: end if;
834: end if;
835: end rosetta_table_copy_in_p8;
836: procedure rosetta_table_copy_out_p8(t okl_tai_pvt.taiv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
837: , a1 out nocopy JTF_NUMBER_TABLE
838: , a2 out nocopy JTF_VARCHAR2_TABLE_100
839: , a3 out nocopy JTF_VARCHAR2_TABLE_100
840: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1381: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;

1377: , p5_a73 DATE := fnd_api.g_miss_date
1378: )
1379:
1380: as
1381: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
1382: ddx_taiv_rec okl_tai_pvt.taiv_rec_type;
1383: ddindx binary_integer; indx binary_integer;
1384: begin
1385:

Line 1382: ddx_taiv_rec okl_tai_pvt.taiv_rec_type;

1378: )
1379:
1380: as
1381: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
1382: ddx_taiv_rec okl_tai_pvt.taiv_rec_type;
1383: ddindx binary_integer; indx binary_integer;
1384: begin
1385:
1386: -- copy data to the local IN or IN-OUT args, if any

Line 1469: okl_tai_pvt.insert_row(p_api_version,

1465: ddp_taiv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a73);
1466:
1467:
1468: -- here's the delegated call to the old PL/SQL routine
1469: okl_tai_pvt.insert_row(p_api_version,
1470: p_init_msg_list,
1471: x_return_status,
1472: x_msg_count,
1473: x_msg_data,

Line 1716: ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;

1712: , p6_a73 out nocopy JTF_DATE_TABLE
1713: )
1714:
1715: as
1716: ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;
1717: ddx_taiv_tbl okl_tai_pvt.taiv_tbl_type;
1718: ddindx binary_integer; indx binary_integer;
1719: begin
1720:

Line 1717: ddx_taiv_tbl okl_tai_pvt.taiv_tbl_type;

1713: )
1714:
1715: as
1716: ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;
1717: ddx_taiv_tbl okl_tai_pvt.taiv_tbl_type;
1718: ddindx binary_integer; indx binary_integer;
1719: begin
1720:
1721: -- copy data to the local IN or IN-OUT args, if any

Line 1727: okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0

1723:
1724:
1725:
1726:
1727: okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0
1728: , p5_a1
1729: , p5_a2
1730: , p5_a3
1731: , p5_a4

Line 1805: okl_tai_pvt.insert_row(p_api_version,

1801: );
1802:
1803:
1804: -- here's the delegated call to the old PL/SQL routine
1805: okl_tai_pvt.insert_row(p_api_version,
1806: p_init_msg_list,
1807: x_return_status,
1808: x_msg_count,
1809: x_msg_data,

Line 1820: okl_tai_pvt_w.rosetta_table_copy_out_p8(ddx_taiv_tbl, p6_a0

1816:
1817:
1818:
1819:
1820: okl_tai_pvt_w.rosetta_table_copy_out_p8(ddx_taiv_tbl, p6_a0
1821: , p6_a1
1822: , p6_a2
1823: , p6_a3
1824: , p6_a4

Line 1979: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;

1975: , p5_a73 DATE := fnd_api.g_miss_date
1976: )
1977:
1978: as
1979: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
1980: ddindx binary_integer; indx binary_integer;
1981: begin
1982:
1983: -- copy data to the local IN or IN-OUT args, if any

Line 2065: okl_tai_pvt.lock_row(p_api_version,

2061: ddp_taiv_rec.private_label := p5_a72;
2062: ddp_taiv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a73);
2063:
2064: -- here's the delegated call to the old PL/SQL routine
2065: okl_tai_pvt.lock_row(p_api_version,
2066: p_init_msg_list,
2067: x_return_status,
2068: x_msg_count,
2069: x_msg_data,

Line 2162: ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;

2158: , p5_a73 JTF_DATE_TABLE
2159: )
2160:
2161: as
2162: ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;
2163: ddindx binary_integer; indx binary_integer;
2164: begin
2165:
2166: -- copy data to the local IN or IN-OUT args, if any

Line 2172: okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0

2168:
2169:
2170:
2171:
2172: okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0
2173: , p5_a1
2174: , p5_a2
2175: , p5_a3
2176: , p5_a4

Line 2249: okl_tai_pvt.lock_row(p_api_version,

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

Line 2420: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;

2416: , p5_a73 DATE := fnd_api.g_miss_date
2417: )
2418:
2419: as
2420: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
2421: ddx_taiv_rec okl_tai_pvt.taiv_rec_type;
2422: ddindx binary_integer; indx binary_integer;
2423: begin
2424:

Line 2421: ddx_taiv_rec okl_tai_pvt.taiv_rec_type;

2417: )
2418:
2419: as
2420: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
2421: ddx_taiv_rec okl_tai_pvt.taiv_rec_type;
2422: ddindx binary_integer; indx binary_integer;
2423: begin
2424:
2425: -- copy data to the local IN or IN-OUT args, if any

Line 2508: okl_tai_pvt.update_row(p_api_version,

2504: ddp_taiv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a73);
2505:
2506:
2507: -- here's the delegated call to the old PL/SQL routine
2508: okl_tai_pvt.update_row(p_api_version,
2509: p_init_msg_list,
2510: x_return_status,
2511: x_msg_count,
2512: x_msg_data,

Line 2755: ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;

2751: , p6_a73 out nocopy JTF_DATE_TABLE
2752: )
2753:
2754: as
2755: ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;
2756: ddx_taiv_tbl okl_tai_pvt.taiv_tbl_type;
2757: ddindx binary_integer; indx binary_integer;
2758: begin
2759:

Line 2756: ddx_taiv_tbl okl_tai_pvt.taiv_tbl_type;

2752: )
2753:
2754: as
2755: ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;
2756: ddx_taiv_tbl okl_tai_pvt.taiv_tbl_type;
2757: ddindx binary_integer; indx binary_integer;
2758: begin
2759:
2760: -- copy data to the local IN or IN-OUT args, if any

Line 2766: okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0

2762:
2763:
2764:
2765:
2766: okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0
2767: , p5_a1
2768: , p5_a2
2769: , p5_a3
2770: , p5_a4

Line 2844: okl_tai_pvt.update_row(p_api_version,

2840: );
2841:
2842:
2843: -- here's the delegated call to the old PL/SQL routine
2844: okl_tai_pvt.update_row(p_api_version,
2845: p_init_msg_list,
2846: x_return_status,
2847: x_msg_count,
2848: x_msg_data,

Line 2859: okl_tai_pvt_w.rosetta_table_copy_out_p8(ddx_taiv_tbl, p6_a0

2855:
2856:
2857:
2858:
2859: okl_tai_pvt_w.rosetta_table_copy_out_p8(ddx_taiv_tbl, p6_a0
2860: , p6_a1
2861: , p6_a2
2862: , p6_a3
2863: , p6_a4

Line 3018: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;

3014: , p5_a73 DATE := fnd_api.g_miss_date
3015: )
3016:
3017: as
3018: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
3019: ddindx binary_integer; indx binary_integer;
3020: begin
3021:
3022: -- copy data to the local IN or IN-OUT args, if any

Line 3104: okl_tai_pvt.delete_row(p_api_version,

3100: ddp_taiv_rec.private_label := p5_a72;
3101: ddp_taiv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a73);
3102:
3103: -- here's the delegated call to the old PL/SQL routine
3104: okl_tai_pvt.delete_row(p_api_version,
3105: p_init_msg_list,
3106: x_return_status,
3107: x_msg_count,
3108: x_msg_data,

Line 3201: ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;

3197: , p5_a73 JTF_DATE_TABLE
3198: )
3199:
3200: as
3201: ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;
3202: ddindx binary_integer; indx binary_integer;
3203: begin
3204:
3205: -- copy data to the local IN or IN-OUT args, if any

Line 3211: okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0

3207:
3208:
3209:
3210:
3211: okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0
3212: , p5_a1
3213: , p5_a2
3214: , p5_a3
3215: , p5_a4

Line 3288: okl_tai_pvt.delete_row(p_api_version,

3284: , p5_a73
3285: );
3286:
3287: -- here's the delegated call to the old PL/SQL routine
3288: okl_tai_pvt.delete_row(p_api_version,
3289: p_init_msg_list,
3290: x_return_status,
3291: x_msg_count,
3292: x_msg_data,

Line 3385: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;

3381: , p5_a73 DATE := fnd_api.g_miss_date
3382: )
3383:
3384: as
3385: ddp_taiv_rec okl_tai_pvt.taiv_rec_type;
3386: ddindx binary_integer; indx binary_integer;
3387: begin
3388:
3389: -- copy data to the local IN or IN-OUT args, if any

Line 3471: okl_tai_pvt.validate_row(p_api_version,

3467: ddp_taiv_rec.private_label := p5_a72;
3468: ddp_taiv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a73);
3469:
3470: -- here's the delegated call to the old PL/SQL routine
3471: okl_tai_pvt.validate_row(p_api_version,
3472: p_init_msg_list,
3473: x_return_status,
3474: x_msg_count,
3475: x_msg_data,

Line 3568: ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;

3564: , p5_a73 JTF_DATE_TABLE
3565: )
3566:
3567: as
3568: ddp_taiv_tbl okl_tai_pvt.taiv_tbl_type;
3569: ddindx binary_integer; indx binary_integer;
3570: begin
3571:
3572: -- copy data to the local IN or IN-OUT args, if any

Line 3578: okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0

3574:
3575:
3576:
3577:
3578: okl_tai_pvt_w.rosetta_table_copy_in_p8(ddp_taiv_tbl, p5_a0
3579: , p5_a1
3580: , p5_a2
3581: , p5_a3
3582: , p5_a4

Line 3655: okl_tai_pvt.validate_row(p_api_version,

3651: , p5_a73
3652: );
3653:
3654: -- here's the delegated call to the old PL/SQL routine
3655: okl_tai_pvt.validate_row(p_api_version,
3656: p_init_msg_list,
3657: x_return_status,
3658: x_msg_count,
3659: x_msg_data,

Line 3670: end okl_tai_pvt_w;

3666:
3667:
3668: end;
3669:
3670: end okl_tai_pvt_w;