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_TAL_PVT_W dependencies on OKL_TAL_PVT

Line 1: package body okl_tal_pvt_w as

1: package body okl_tal_pvt_w as
2: /* $Header: OKLITALB.pls 120.3.12010000.2 2010/04/29 15:05:41 rpillay 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_tal_pvt.tal_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_tal_pvt.tal_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 202: procedure rosetta_table_copy_out_p2(t okl_tal_pvt.tal_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

198: end loop;
199: end if;
200: end if;
201: end rosetta_table_copy_in_p2;
202: procedure rosetta_table_copy_out_p2(t okl_tal_pvt.tal_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
203: , a1 out nocopy JTF_NUMBER_TABLE
204: , a2 out nocopy JTF_NUMBER_TABLE
205: , a3 out nocopy JTF_NUMBER_TABLE
206: , a4 out nocopy JTF_NUMBER_TABLE

Line 621: procedure rosetta_table_copy_in_p5(t out nocopy okl_tal_pvt.okl_txl_assets_tl_tbl_type, a0 JTF_NUMBER_TABLE

617: end if;
618: end if;
619: end rosetta_table_copy_out_p2;
620:
621: procedure rosetta_table_copy_in_p5(t out nocopy okl_tal_pvt.okl_txl_assets_tl_tbl_type, a0 JTF_NUMBER_TABLE
622: , a1 JTF_VARCHAR2_TABLE_100
623: , a2 JTF_VARCHAR2_TABLE_100
624: , a3 JTF_VARCHAR2_TABLE_100
625: , a4 JTF_VARCHAR2_TABLE_2000

Line 658: procedure rosetta_table_copy_out_p5(t okl_tal_pvt.okl_txl_assets_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

654: end loop;
655: end if;
656: end if;
657: end rosetta_table_copy_in_p5;
658: procedure rosetta_table_copy_out_p5(t okl_tal_pvt.okl_txl_assets_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
659: , a1 out nocopy JTF_VARCHAR2_TABLE_100
660: , a2 out nocopy JTF_VARCHAR2_TABLE_100
661: , a3 out nocopy JTF_VARCHAR2_TABLE_100
662: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 727: procedure rosetta_table_copy_in_p8(t out nocopy okl_tal_pvt.talv_tbl_type, a0 JTF_NUMBER_TABLE

723: end if;
724: end if;
725: end rosetta_table_copy_out_p5;
726:
727: procedure rosetta_table_copy_in_p8(t out nocopy okl_tal_pvt.talv_tbl_type, a0 JTF_NUMBER_TABLE
728: , a1 JTF_NUMBER_TABLE
729: , a2 JTF_VARCHAR2_TABLE_100
730: , a3 JTF_NUMBER_TABLE
731: , a4 JTF_NUMBER_TABLE

Line 908: procedure rosetta_table_copy_out_p8(t okl_tal_pvt.talv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

904: end loop;
905: end if;
906: end if;
907: end rosetta_table_copy_in_p8;
908: procedure rosetta_table_copy_out_p8(t okl_tal_pvt.talv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
909: , a1 out nocopy JTF_NUMBER_TABLE
910: , a2 out nocopy JTF_VARCHAR2_TABLE_100
911: , a3 out nocopy JTF_NUMBER_TABLE
912: , a4 out nocopy JTF_NUMBER_TABLE

Line 1509: ddp_talv_rec okl_tal_pvt.talv_rec_type;

1505: , p5_a81 NUMBER := 0-1962.0724
1506: )
1507:
1508: as
1509: ddp_talv_rec okl_tal_pvt.talv_rec_type;
1510: ddx_talv_rec okl_tal_pvt.talv_rec_type;
1511: ddindx binary_integer; indx binary_integer;
1512: begin
1513:

Line 1510: ddx_talv_rec okl_tal_pvt.talv_rec_type;

1506: )
1507:
1508: as
1509: ddp_talv_rec okl_tal_pvt.talv_rec_type;
1510: ddx_talv_rec okl_tal_pvt.talv_rec_type;
1511: ddindx binary_integer; indx binary_integer;
1512: begin
1513:
1514: -- copy data to the local IN or IN-OUT args, if any

Line 1605: okl_tal_pvt.insert_row(p_api_version,

1601: ddp_talv_rec.retirement_id := rosetta_g_miss_num_map(p5_a81);
1602:
1603:
1604: -- here's the delegated call to the old PL/SQL routine
1605: okl_tal_pvt.insert_row(p_api_version,
1606: p_init_msg_list,
1607: x_return_status,
1608: x_msg_count,
1609: x_msg_data,

Line 1876: ddp_talv_tbl okl_tal_pvt.talv_tbl_type;

1872: , p6_a81 out nocopy JTF_NUMBER_TABLE
1873: )
1874:
1875: as
1876: ddp_talv_tbl okl_tal_pvt.talv_tbl_type;
1877: ddx_talv_tbl okl_tal_pvt.talv_tbl_type;
1878: ddindx binary_integer; indx binary_integer;
1879: begin
1880:

Line 1877: ddx_talv_tbl okl_tal_pvt.talv_tbl_type;

1873: )
1874:
1875: as
1876: ddp_talv_tbl okl_tal_pvt.talv_tbl_type;
1877: ddx_talv_tbl okl_tal_pvt.talv_tbl_type;
1878: ddindx binary_integer; indx binary_integer;
1879: begin
1880:
1881: -- copy data to the local IN or IN-OUT args, if any

Line 1887: okl_tal_pvt_w.rosetta_table_copy_in_p8(ddp_talv_tbl, p5_a0

1883:
1884:
1885:
1886:
1887: okl_tal_pvt_w.rosetta_table_copy_in_p8(ddp_talv_tbl, p5_a0
1888: , p5_a1
1889: , p5_a2
1890: , p5_a3
1891: , p5_a4

Line 1973: okl_tal_pvt.insert_row(p_api_version,

1969: );
1970:
1971:
1972: -- here's the delegated call to the old PL/SQL routine
1973: okl_tal_pvt.insert_row(p_api_version,
1974: p_init_msg_list,
1975: x_return_status,
1976: x_msg_count,
1977: x_msg_data,

Line 1988: okl_tal_pvt_w.rosetta_table_copy_out_p8(ddx_talv_tbl, p6_a0

1984:
1985:
1986:
1987:
1988: okl_tal_pvt_w.rosetta_table_copy_out_p8(ddx_talv_tbl, p6_a0
1989: , p6_a1
1990: , p6_a2
1991: , p6_a3
1992: , p6_a4

Line 2163: ddp_talv_rec okl_tal_pvt.talv_rec_type;

2159: , p5_a81 NUMBER := 0-1962.0724
2160: )
2161:
2162: as
2163: ddp_talv_rec okl_tal_pvt.talv_rec_type;
2164: ddindx binary_integer; indx binary_integer;
2165: begin
2166:
2167: -- copy data to the local IN or IN-OUT args, if any

Line 2257: okl_tal_pvt.lock_row(p_api_version,

2253: ddp_talv_rec.residual_shr_amount := rosetta_g_miss_num_map(p5_a80);
2254: ddp_talv_rec.retirement_id := rosetta_g_miss_num_map(p5_a81);
2255:
2256: -- here's the delegated call to the old PL/SQL routine
2257: okl_tal_pvt.lock_row(p_api_version,
2258: p_init_msg_list,
2259: x_return_status,
2260: x_msg_count,
2261: x_msg_data,

Line 2362: ddp_talv_tbl okl_tal_pvt.talv_tbl_type;

2358: , p5_a81 JTF_NUMBER_TABLE
2359: )
2360:
2361: as
2362: ddp_talv_tbl okl_tal_pvt.talv_tbl_type;
2363: ddindx binary_integer; indx binary_integer;
2364: begin
2365:
2366: -- copy data to the local IN or IN-OUT args, if any

Line 2372: okl_tal_pvt_w.rosetta_table_copy_in_p8(ddp_talv_tbl, p5_a0

2368:
2369:
2370:
2371:
2372: okl_tal_pvt_w.rosetta_table_copy_in_p8(ddp_talv_tbl, p5_a0
2373: , p5_a1
2374: , p5_a2
2375: , p5_a3
2376: , p5_a4

Line 2457: okl_tal_pvt.lock_row(p_api_version,

2453: , p5_a81
2454: );
2455:
2456: -- here's the delegated call to the old PL/SQL routine
2457: okl_tal_pvt.lock_row(p_api_version,
2458: p_init_msg_list,
2459: x_return_status,
2460: x_msg_count,
2461: x_msg_data,

Line 2644: ddp_talv_rec okl_tal_pvt.talv_rec_type;

2640: , p5_a81 NUMBER := 0-1962.0724
2641: )
2642:
2643: as
2644: ddp_talv_rec okl_tal_pvt.talv_rec_type;
2645: ddx_talv_rec okl_tal_pvt.talv_rec_type;
2646: ddindx binary_integer; indx binary_integer;
2647: begin
2648:

Line 2645: ddx_talv_rec okl_tal_pvt.talv_rec_type;

2641: )
2642:
2643: as
2644: ddp_talv_rec okl_tal_pvt.talv_rec_type;
2645: ddx_talv_rec okl_tal_pvt.talv_rec_type;
2646: ddindx binary_integer; indx binary_integer;
2647: begin
2648:
2649: -- copy data to the local IN or IN-OUT args, if any

Line 2740: okl_tal_pvt.update_row(p_api_version,

2736: ddp_talv_rec.retirement_id := rosetta_g_miss_num_map(p5_a81);
2737:
2738:
2739: -- here's the delegated call to the old PL/SQL routine
2740: okl_tal_pvt.update_row(p_api_version,
2741: p_init_msg_list,
2742: x_return_status,
2743: x_msg_count,
2744: x_msg_data,

Line 3011: ddp_talv_tbl okl_tal_pvt.talv_tbl_type;

3007: , p6_a81 out nocopy JTF_NUMBER_TABLE
3008: )
3009:
3010: as
3011: ddp_talv_tbl okl_tal_pvt.talv_tbl_type;
3012: ddx_talv_tbl okl_tal_pvt.talv_tbl_type;
3013: ddindx binary_integer; indx binary_integer;
3014: begin
3015:

Line 3012: ddx_talv_tbl okl_tal_pvt.talv_tbl_type;

3008: )
3009:
3010: as
3011: ddp_talv_tbl okl_tal_pvt.talv_tbl_type;
3012: ddx_talv_tbl okl_tal_pvt.talv_tbl_type;
3013: ddindx binary_integer; indx binary_integer;
3014: begin
3015:
3016: -- copy data to the local IN or IN-OUT args, if any

Line 3022: okl_tal_pvt_w.rosetta_table_copy_in_p8(ddp_talv_tbl, p5_a0

3018:
3019:
3020:
3021:
3022: okl_tal_pvt_w.rosetta_table_copy_in_p8(ddp_talv_tbl, p5_a0
3023: , p5_a1
3024: , p5_a2
3025: , p5_a3
3026: , p5_a4

Line 3108: okl_tal_pvt.update_row(p_api_version,

3104: );
3105:
3106:
3107: -- here's the delegated call to the old PL/SQL routine
3108: okl_tal_pvt.update_row(p_api_version,
3109: p_init_msg_list,
3110: x_return_status,
3111: x_msg_count,
3112: x_msg_data,

Line 3123: okl_tal_pvt_w.rosetta_table_copy_out_p8(ddx_talv_tbl, p6_a0

3119:
3120:
3121:
3122:
3123: okl_tal_pvt_w.rosetta_table_copy_out_p8(ddx_talv_tbl, p6_a0
3124: , p6_a1
3125: , p6_a2
3126: , p6_a3
3127: , p6_a4

Line 3298: ddp_talv_rec okl_tal_pvt.talv_rec_type;

3294: , p5_a81 NUMBER := 0-1962.0724
3295: )
3296:
3297: as
3298: ddp_talv_rec okl_tal_pvt.talv_rec_type;
3299: ddindx binary_integer; indx binary_integer;
3300: begin
3301:
3302: -- copy data to the local IN or IN-OUT args, if any

Line 3392: okl_tal_pvt.delete_row(p_api_version,

3388: ddp_talv_rec.residual_shr_amount := rosetta_g_miss_num_map(p5_a80);
3389: ddp_talv_rec.retirement_id := rosetta_g_miss_num_map(p5_a81);
3390:
3391: -- here's the delegated call to the old PL/SQL routine
3392: okl_tal_pvt.delete_row(p_api_version,
3393: p_init_msg_list,
3394: x_return_status,
3395: x_msg_count,
3396: x_msg_data,

Line 3497: ddp_talv_tbl okl_tal_pvt.talv_tbl_type;

3493: , p5_a81 JTF_NUMBER_TABLE
3494: )
3495:
3496: as
3497: ddp_talv_tbl okl_tal_pvt.talv_tbl_type;
3498: ddindx binary_integer; indx binary_integer;
3499: begin
3500:
3501: -- copy data to the local IN or IN-OUT args, if any

Line 3507: okl_tal_pvt_w.rosetta_table_copy_in_p8(ddp_talv_tbl, p5_a0

3503:
3504:
3505:
3506:
3507: okl_tal_pvt_w.rosetta_table_copy_in_p8(ddp_talv_tbl, p5_a0
3508: , p5_a1
3509: , p5_a2
3510: , p5_a3
3511: , p5_a4

Line 3592: okl_tal_pvt.delete_row(p_api_version,

3588: , p5_a81
3589: );
3590:
3591: -- here's the delegated call to the old PL/SQL routine
3592: okl_tal_pvt.delete_row(p_api_version,
3593: p_init_msg_list,
3594: x_return_status,
3595: x_msg_count,
3596: x_msg_data,

Line 3697: ddp_talv_rec okl_tal_pvt.talv_rec_type;

3693: , p5_a81 NUMBER := 0-1962.0724
3694: )
3695:
3696: as
3697: ddp_talv_rec okl_tal_pvt.talv_rec_type;
3698: ddindx binary_integer; indx binary_integer;
3699: begin
3700:
3701: -- copy data to the local IN or IN-OUT args, if any

Line 3791: okl_tal_pvt.validate_row(p_api_version,

3787: ddp_talv_rec.residual_shr_amount := rosetta_g_miss_num_map(p5_a80);
3788: ddp_talv_rec.retirement_id := rosetta_g_miss_num_map(p5_a81);
3789:
3790: -- here's the delegated call to the old PL/SQL routine
3791: okl_tal_pvt.validate_row(p_api_version,
3792: p_init_msg_list,
3793: x_return_status,
3794: x_msg_count,
3795: x_msg_data,

Line 3896: ddp_talv_tbl okl_tal_pvt.talv_tbl_type;

3892: , p5_a81 JTF_NUMBER_TABLE
3893: )
3894:
3895: as
3896: ddp_talv_tbl okl_tal_pvt.talv_tbl_type;
3897: ddindx binary_integer; indx binary_integer;
3898: begin
3899:
3900: -- copy data to the local IN or IN-OUT args, if any

Line 3906: okl_tal_pvt_w.rosetta_table_copy_in_p8(ddp_talv_tbl, p5_a0

3902:
3903:
3904:
3905:
3906: okl_tal_pvt_w.rosetta_table_copy_in_p8(ddp_talv_tbl, p5_a0
3907: , p5_a1
3908: , p5_a2
3909: , p5_a3
3910: , p5_a4

Line 3991: okl_tal_pvt.validate_row(p_api_version,

3987: , p5_a81
3988: );
3989:
3990: -- here's the delegated call to the old PL/SQL routine
3991: okl_tal_pvt.validate_row(p_api_version,
3992: p_init_msg_list,
3993: x_return_status,
3994: x_msg_count,
3995: x_msg_data,

Line 4006: end okl_tal_pvt_w;

4002:
4003:
4004: end;
4005:
4006: end okl_tal_pvt_w;