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_TCN_PVT_W dependencies on OKL_TCN_PVT

Line 1: package body okl_tcn_pvt_w as

1: package body okl_tcn_pvt_w as
2: /* $Header: OKLITCNB.pls 120.10.12010000.6 2008/11/12 23:56:03 apaul 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_tcn_pvt.tcn_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_tcn_pvt.tcn_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_100

Line 230: procedure rosetta_table_copy_out_p2(t okl_tcn_pvt.tcn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

226: end loop;
227: end if;
228: end if;
229: end rosetta_table_copy_in_p2;
230: procedure rosetta_table_copy_out_p2(t okl_tcn_pvt.tcn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
231: , a1 out nocopy JTF_NUMBER_TABLE
232: , a2 out nocopy JTF_NUMBER_TABLE
233: , a3 out nocopy JTF_NUMBER_TABLE
234: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 719: procedure rosetta_table_copy_in_p5(t out nocopy okl_tcn_pvt.tcnv_tbl_type, a0 JTF_NUMBER_TABLE

715: end if;
716: end if;
717: end rosetta_table_copy_out_p2;
718:
719: procedure rosetta_table_copy_in_p5(t out nocopy okl_tcn_pvt.tcnv_tbl_type, a0 JTF_NUMBER_TABLE
720: , a1 JTF_NUMBER_TABLE
721: , a2 JTF_VARCHAR2_TABLE_100
722: , a3 JTF_VARCHAR2_TABLE_100
723: , a4 JTF_VARCHAR2_TABLE_100

Line 924: procedure rosetta_table_copy_out_p5(t okl_tcn_pvt.tcnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

920: end loop;
921: end if;
922: end if;
923: end rosetta_table_copy_in_p5;
924: procedure rosetta_table_copy_out_p5(t okl_tcn_pvt.tcnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
925: , a1 out nocopy JTF_NUMBER_TABLE
926: , a2 out nocopy JTF_VARCHAR2_TABLE_100
927: , a3 out nocopy JTF_VARCHAR2_TABLE_100
928: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1609: ddp_tcnv_rec okl_tcn_pvt.tcnv_rec_type;

1605: , p5_a93 DATE := fnd_api.g_miss_date
1606: )
1607:
1608: as
1609: ddp_tcnv_rec okl_tcn_pvt.tcnv_rec_type;
1610: ddx_tcnv_rec okl_tcn_pvt.tcnv_rec_type;
1611: ddindx binary_integer; indx binary_integer;
1612: begin
1613:

Line 1610: ddx_tcnv_rec okl_tcn_pvt.tcnv_rec_type;

1606: )
1607:
1608: as
1609: ddp_tcnv_rec okl_tcn_pvt.tcnv_rec_type;
1610: ddx_tcnv_rec okl_tcn_pvt.tcnv_rec_type;
1611: ddindx binary_integer; indx binary_integer;
1612: begin
1613:
1614: -- copy data to the local IN or IN-OUT args, if any

Line 1717: okl_tcn_pvt.insert_row(p_api_version,

1713: ddp_tcnv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a93);
1714:
1715:
1716: -- here's the delegated call to the old PL/SQL routine
1717: okl_tcn_pvt.insert_row(p_api_version,
1718: p_init_msg_list,
1719: x_return_status,
1720: x_msg_count,
1721: x_msg_data,

Line 2024: ddp_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;

2020: , p6_a93 out nocopy JTF_DATE_TABLE
2021: )
2022:
2023: as
2024: ddp_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;
2025: ddx_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;
2026: ddindx binary_integer; indx binary_integer;
2027: begin
2028:

Line 2025: ddx_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;

2021: )
2022:
2023: as
2024: ddp_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;
2025: ddx_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;
2026: ddindx binary_integer; indx binary_integer;
2027: begin
2028:
2029: -- copy data to the local IN or IN-OUT args, if any

Line 2035: okl_tcn_pvt_w.rosetta_table_copy_in_p5(ddp_tcnv_tbl, p5_a0

2031:
2032:
2033:
2034:
2035: okl_tcn_pvt_w.rosetta_table_copy_in_p5(ddp_tcnv_tbl, p5_a0
2036: , p5_a1
2037: , p5_a2
2038: , p5_a3
2039: , p5_a4

Line 2133: okl_tcn_pvt.insert_row(p_api_version,

2129: );
2130:
2131:
2132: -- here's the delegated call to the old PL/SQL routine
2133: okl_tcn_pvt.insert_row(p_api_version,
2134: p_init_msg_list,
2135: x_return_status,
2136: x_msg_count,
2137: x_msg_data,

Line 2148: okl_tcn_pvt_w.rosetta_table_copy_out_p5(ddx_tcnv_tbl, p6_a0

2144:
2145:
2146:
2147:
2148: okl_tcn_pvt_w.rosetta_table_copy_out_p5(ddx_tcnv_tbl, p6_a0
2149: , p6_a1
2150: , p6_a2
2151: , p6_a3
2152: , p6_a4

Line 2347: ddp_tcnv_rec okl_tcn_pvt.tcnv_rec_type;

2343: , p5_a93 DATE := fnd_api.g_miss_date
2344: )
2345:
2346: as
2347: ddp_tcnv_rec okl_tcn_pvt.tcnv_rec_type;
2348: ddindx binary_integer; indx binary_integer;
2349: begin
2350:
2351: -- copy data to the local IN or IN-OUT args, if any

Line 2453: okl_tcn_pvt.lock_row(p_api_version,

2449: ddp_tcnv_rec.upgrade_status_flag := p5_a92;
2450: ddp_tcnv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a93);
2451:
2452: -- here's the delegated call to the old PL/SQL routine
2453: okl_tcn_pvt.lock_row(p_api_version,
2454: p_init_msg_list,
2455: x_return_status,
2456: x_msg_count,
2457: x_msg_data,

Line 2570: ddp_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;

2566: , p5_a93 JTF_DATE_TABLE
2567: )
2568:
2569: as
2570: ddp_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;
2571: ddindx binary_integer; indx binary_integer;
2572: begin
2573:
2574: -- copy data to the local IN or IN-OUT args, if any

Line 2580: okl_tcn_pvt_w.rosetta_table_copy_in_p5(ddp_tcnv_tbl, p5_a0

2576:
2577:
2578:
2579:
2580: okl_tcn_pvt_w.rosetta_table_copy_in_p5(ddp_tcnv_tbl, p5_a0
2581: , p5_a1
2582: , p5_a2
2583: , p5_a3
2584: , p5_a4

Line 2677: okl_tcn_pvt.lock_row(p_api_version,

2673: , p5_a93
2674: );
2675:
2676: -- here's the delegated call to the old PL/SQL routine
2677: okl_tcn_pvt.lock_row(p_api_version,
2678: p_init_msg_list,
2679: x_return_status,
2680: x_msg_count,
2681: x_msg_data,

Line 2888: ddp_tcnv_rec okl_tcn_pvt.tcnv_rec_type;

2884: , p5_a93 DATE := fnd_api.g_miss_date
2885: )
2886:
2887: as
2888: ddp_tcnv_rec okl_tcn_pvt.tcnv_rec_type;
2889: ddx_tcnv_rec okl_tcn_pvt.tcnv_rec_type;
2890: ddindx binary_integer; indx binary_integer;
2891: begin
2892:

Line 2889: ddx_tcnv_rec okl_tcn_pvt.tcnv_rec_type;

2885: )
2886:
2887: as
2888: ddp_tcnv_rec okl_tcn_pvt.tcnv_rec_type;
2889: ddx_tcnv_rec okl_tcn_pvt.tcnv_rec_type;
2890: ddindx binary_integer; indx binary_integer;
2891: begin
2892:
2893: -- copy data to the local IN or IN-OUT args, if any

Line 2996: okl_tcn_pvt.update_row(p_api_version,

2992: ddp_tcnv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a93);
2993:
2994:
2995: -- here's the delegated call to the old PL/SQL routine
2996: okl_tcn_pvt.update_row(p_api_version,
2997: p_init_msg_list,
2998: x_return_status,
2999: x_msg_count,
3000: x_msg_data,

Line 3303: ddp_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;

3299: , p6_a93 out nocopy JTF_DATE_TABLE
3300: )
3301:
3302: as
3303: ddp_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;
3304: ddx_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;
3305: ddindx binary_integer; indx binary_integer;
3306: begin
3307:

Line 3304: ddx_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;

3300: )
3301:
3302: as
3303: ddp_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;
3304: ddx_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;
3305: ddindx binary_integer; indx binary_integer;
3306: begin
3307:
3308: -- copy data to the local IN or IN-OUT args, if any

Line 3314: okl_tcn_pvt_w.rosetta_table_copy_in_p5(ddp_tcnv_tbl, p5_a0

3310:
3311:
3312:
3313:
3314: okl_tcn_pvt_w.rosetta_table_copy_in_p5(ddp_tcnv_tbl, p5_a0
3315: , p5_a1
3316: , p5_a2
3317: , p5_a3
3318: , p5_a4

Line 3412: okl_tcn_pvt.update_row(p_api_version,

3408: );
3409:
3410:
3411: -- here's the delegated call to the old PL/SQL routine
3412: okl_tcn_pvt.update_row(p_api_version,
3413: p_init_msg_list,
3414: x_return_status,
3415: x_msg_count,
3416: x_msg_data,

Line 3427: okl_tcn_pvt_w.rosetta_table_copy_out_p5(ddx_tcnv_tbl, p6_a0

3423:
3424:
3425:
3426:
3427: okl_tcn_pvt_w.rosetta_table_copy_out_p5(ddx_tcnv_tbl, p6_a0
3428: , p6_a1
3429: , p6_a2
3430: , p6_a3
3431: , p6_a4

Line 3626: ddp_tcnv_rec okl_tcn_pvt.tcnv_rec_type;

3622: , p5_a93 DATE := fnd_api.g_miss_date
3623: )
3624:
3625: as
3626: ddp_tcnv_rec okl_tcn_pvt.tcnv_rec_type;
3627: ddindx binary_integer; indx binary_integer;
3628: begin
3629:
3630: -- copy data to the local IN or IN-OUT args, if any

Line 3732: okl_tcn_pvt.delete_row(p_api_version,

3728: ddp_tcnv_rec.upgrade_status_flag := p5_a92;
3729: ddp_tcnv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a93);
3730:
3731: -- here's the delegated call to the old PL/SQL routine
3732: okl_tcn_pvt.delete_row(p_api_version,
3733: p_init_msg_list,
3734: x_return_status,
3735: x_msg_count,
3736: x_msg_data,

Line 3849: ddp_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;

3845: , p5_a93 JTF_DATE_TABLE
3846: )
3847:
3848: as
3849: ddp_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;
3850: ddindx binary_integer; indx binary_integer;
3851: begin
3852:
3853: -- copy data to the local IN or IN-OUT args, if any

Line 3859: okl_tcn_pvt_w.rosetta_table_copy_in_p5(ddp_tcnv_tbl, p5_a0

3855:
3856:
3857:
3858:
3859: okl_tcn_pvt_w.rosetta_table_copy_in_p5(ddp_tcnv_tbl, p5_a0
3860: , p5_a1
3861: , p5_a2
3862: , p5_a3
3863: , p5_a4

Line 3956: okl_tcn_pvt.delete_row(p_api_version,

3952: , p5_a93
3953: );
3954:
3955: -- here's the delegated call to the old PL/SQL routine
3956: okl_tcn_pvt.delete_row(p_api_version,
3957: p_init_msg_list,
3958: x_return_status,
3959: x_msg_count,
3960: x_msg_data,

Line 4073: ddp_tcnv_rec okl_tcn_pvt.tcnv_rec_type;

4069: , p5_a93 DATE := fnd_api.g_miss_date
4070: )
4071:
4072: as
4073: ddp_tcnv_rec okl_tcn_pvt.tcnv_rec_type;
4074: ddindx binary_integer; indx binary_integer;
4075: begin
4076:
4077: -- copy data to the local IN or IN-OUT args, if any

Line 4179: okl_tcn_pvt.validate_row(p_api_version,

4175: ddp_tcnv_rec.upgrade_status_flag := p5_a92;
4176: ddp_tcnv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a93);
4177:
4178: -- here's the delegated call to the old PL/SQL routine
4179: okl_tcn_pvt.validate_row(p_api_version,
4180: p_init_msg_list,
4181: x_return_status,
4182: x_msg_count,
4183: x_msg_data,

Line 4296: ddp_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;

4292: , p5_a93 JTF_DATE_TABLE
4293: )
4294:
4295: as
4296: ddp_tcnv_tbl okl_tcn_pvt.tcnv_tbl_type;
4297: ddindx binary_integer; indx binary_integer;
4298: begin
4299:
4300: -- copy data to the local IN or IN-OUT args, if any

Line 4306: okl_tcn_pvt_w.rosetta_table_copy_in_p5(ddp_tcnv_tbl, p5_a0

4302:
4303:
4304:
4305:
4306: okl_tcn_pvt_w.rosetta_table_copy_in_p5(ddp_tcnv_tbl, p5_a0
4307: , p5_a1
4308: , p5_a2
4309: , p5_a3
4310: , p5_a4

Line 4403: okl_tcn_pvt.validate_row(p_api_version,

4399: , p5_a93
4400: );
4401:
4402: -- here's the delegated call to the old PL/SQL routine
4403: okl_tcn_pvt.validate_row(p_api_version,
4404: p_init_msg_list,
4405: x_return_status,
4406: x_msg_count,
4407: x_msg_data,

Line 4418: end okl_tcn_pvt_w;

4414:
4415:
4416: end;
4417:
4418: end okl_tcn_pvt_w;