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_KHR_PVT_W dependencies on OKL_KHR_PVT

Line 1: package body okl_khr_pvt_w as

1: package body okl_khr_pvt_w as
2: /* $Header: OKLIKHRB.pls 115.7 2002/12/20 19:17:39 avsingh 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:

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_khr_pvt.khr_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_khr_pvt.khr_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 171: procedure rosetta_table_copy_out_p2(t okl_khr_pvt.khr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

167: end loop;
168: end if;
169: end if;
170: end rosetta_table_copy_in_p2;
171: procedure rosetta_table_copy_out_p2(t okl_khr_pvt.khr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
172: , a1 out nocopy JTF_NUMBER_TABLE
173: , a2 out nocopy JTF_NUMBER_TABLE
174: , a3 out nocopy JTF_NUMBER_TABLE
175: , a4 out nocopy JTF_NUMBER_TABLE

Line 520: procedure rosetta_table_copy_in_p5(t out nocopy okl_khr_pvt.okl_k_headers_h_tbl_type, a0 JTF_NUMBER_TABLE

516: end if;
517: end if;
518: end rosetta_table_copy_out_p2;
519:
520: procedure rosetta_table_copy_in_p5(t out nocopy okl_khr_pvt.okl_k_headers_h_tbl_type, a0 JTF_NUMBER_TABLE
521: , a1 JTF_NUMBER_TABLE
522: , a2 JTF_NUMBER_TABLE
523: , a3 JTF_NUMBER_TABLE
524: , a4 JTF_NUMBER_TABLE

Line 671: procedure rosetta_table_copy_out_p5(t okl_khr_pvt.okl_k_headers_h_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

667: end loop;
668: end if;
669: end if;
670: end rosetta_table_copy_in_p5;
671: procedure rosetta_table_copy_out_p5(t okl_khr_pvt.okl_k_headers_h_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
672: , a1 out nocopy JTF_NUMBER_TABLE
673: , a2 out nocopy JTF_NUMBER_TABLE
674: , a3 out nocopy JTF_NUMBER_TABLE
675: , a4 out nocopy JTF_NUMBER_TABLE

Line 1025: procedure rosetta_table_copy_in_p8(t out nocopy okl_khr_pvt.khrv_tbl_type, a0 JTF_NUMBER_TABLE

1021: end if;
1022: end if;
1023: end rosetta_table_copy_out_p5;
1024:
1025: procedure rosetta_table_copy_in_p8(t out nocopy okl_khr_pvt.khrv_tbl_type, a0 JTF_NUMBER_TABLE
1026: , a1 JTF_NUMBER_TABLE
1027: , a2 JTF_NUMBER_TABLE
1028: , a3 JTF_NUMBER_TABLE
1029: , a4 JTF_NUMBER_TABLE

Line 1174: procedure rosetta_table_copy_out_p8(t okl_khr_pvt.khrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1170: end loop;
1171: end if;
1172: end if;
1173: end rosetta_table_copy_in_p8;
1174: procedure rosetta_table_copy_out_p8(t okl_khr_pvt.khrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1175: , a1 out nocopy JTF_NUMBER_TABLE
1176: , a2 out nocopy JTF_NUMBER_TABLE
1177: , a3 out nocopy JTF_NUMBER_TABLE
1178: , a4 out nocopy JTF_NUMBER_TABLE

Line 1663: ddp_khrv_rec okl_khr_pvt.khrv_rec_type;

1659: , p5_a65 VARCHAR2 := fnd_api.g_miss_char
1660: )
1661:
1662: as
1663: ddp_khrv_rec okl_khr_pvt.khrv_rec_type;
1664: ddx_khrv_rec okl_khr_pvt.khrv_rec_type;
1665: ddindx binary_integer; indx binary_integer;
1666: begin
1667:

Line 1664: ddx_khrv_rec okl_khr_pvt.khrv_rec_type;

1660: )
1661:
1662: as
1663: ddp_khrv_rec okl_khr_pvt.khrv_rec_type;
1664: ddx_khrv_rec okl_khr_pvt.khrv_rec_type;
1665: ddindx binary_integer; indx binary_integer;
1666: begin
1667:
1668: -- copy data to the local IN or IN-OUT args, if any

Line 1743: okl_khr_pvt.insert_row(p_api_version,

1739: ddp_khrv_rec.securitization_type := p5_a65;
1740:
1741:
1742: -- here's the delegated call to the old PL/SQL routine
1743: okl_khr_pvt.insert_row(p_api_version,
1744: p_init_msg_list,
1745: x_return_status,
1746: x_msg_count,
1747: x_msg_data,

Line 1966: ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;

1962: , p6_a65 out nocopy JTF_VARCHAR2_TABLE_100
1963: )
1964:
1965: as
1966: ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;
1967: ddx_khrv_tbl okl_khr_pvt.khrv_tbl_type;
1968: ddindx binary_integer; indx binary_integer;
1969: begin
1970:

Line 1967: ddx_khrv_tbl okl_khr_pvt.khrv_tbl_type;

1963: )
1964:
1965: as
1966: ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;
1967: ddx_khrv_tbl okl_khr_pvt.khrv_tbl_type;
1968: ddindx binary_integer; indx binary_integer;
1969: begin
1970:
1971: -- copy data to the local IN or IN-OUT args, if any

Line 1977: okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0

1973:
1974:
1975:
1976:
1977: okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0
1978: , p5_a1
1979: , p5_a2
1980: , p5_a3
1981: , p5_a4

Line 2047: okl_khr_pvt.insert_row(p_api_version,

2043: );
2044:
2045:
2046: -- here's the delegated call to the old PL/SQL routine
2047: okl_khr_pvt.insert_row(p_api_version,
2048: p_init_msg_list,
2049: x_return_status,
2050: x_msg_count,
2051: x_msg_data,

Line 2062: okl_khr_pvt_w.rosetta_table_copy_out_p8(ddx_khrv_tbl, p6_a0

2058:
2059:
2060:
2061:
2062: okl_khr_pvt_w.rosetta_table_copy_out_p8(ddx_khrv_tbl, p6_a0
2063: , p6_a1
2064: , p6_a2
2065: , p6_a3
2066: , p6_a4

Line 2271: ddp_khrv_rec okl_khr_pvt.khrv_rec_type;

2267: , p5_a65 VARCHAR2 := fnd_api.g_miss_char
2268: )
2269:
2270: as
2271: ddp_khrv_rec okl_khr_pvt.khrv_rec_type;
2272: ddx_khrv_rec okl_khr_pvt.khrv_rec_type;
2273: ddindx binary_integer; indx binary_integer;
2274: begin
2275:

Line 2272: ddx_khrv_rec okl_khr_pvt.khrv_rec_type;

2268: )
2269:
2270: as
2271: ddp_khrv_rec okl_khr_pvt.khrv_rec_type;
2272: ddx_khrv_rec okl_khr_pvt.khrv_rec_type;
2273: ddindx binary_integer; indx binary_integer;
2274: begin
2275:
2276: -- copy data to the local IN or IN-OUT args, if any

Line 2351: okl_khr_pvt.update_row(p_api_version,

2347: ddp_khrv_rec.securitization_type := p5_a65;
2348:
2349:
2350: -- here's the delegated call to the old PL/SQL routine
2351: okl_khr_pvt.update_row(p_api_version,
2352: p_init_msg_list,
2353: x_return_status,
2354: x_msg_count,
2355: x_msg_data,

Line 2574: ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;

2570: , p6_a65 out nocopy JTF_VARCHAR2_TABLE_100
2571: )
2572:
2573: as
2574: ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;
2575: ddx_khrv_tbl okl_khr_pvt.khrv_tbl_type;
2576: ddindx binary_integer; indx binary_integer;
2577: begin
2578:

Line 2575: ddx_khrv_tbl okl_khr_pvt.khrv_tbl_type;

2571: )
2572:
2573: as
2574: ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;
2575: ddx_khrv_tbl okl_khr_pvt.khrv_tbl_type;
2576: ddindx binary_integer; indx binary_integer;
2577: begin
2578:
2579: -- copy data to the local IN or IN-OUT args, if any

Line 2585: okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0

2581:
2582:
2583:
2584:
2585: okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0
2586: , p5_a1
2587: , p5_a2
2588: , p5_a3
2589: , p5_a4

Line 2655: okl_khr_pvt.update_row(p_api_version,

2651: );
2652:
2653:
2654: -- here's the delegated call to the old PL/SQL routine
2655: okl_khr_pvt.update_row(p_api_version,
2656: p_init_msg_list,
2657: x_return_status,
2658: x_msg_count,
2659: x_msg_data,

Line 2670: okl_khr_pvt_w.rosetta_table_copy_out_p8(ddx_khrv_tbl, p6_a0

2666:
2667:
2668:
2669:
2670: okl_khr_pvt_w.rosetta_table_copy_out_p8(ddx_khrv_tbl, p6_a0
2671: , p6_a1
2672: , p6_a2
2673: , p6_a3
2674: , p6_a4

Line 2813: ddp_khrv_rec okl_khr_pvt.khrv_rec_type;

2809: , p5_a65 VARCHAR2 := fnd_api.g_miss_char
2810: )
2811:
2812: as
2813: ddp_khrv_rec okl_khr_pvt.khrv_rec_type;
2814: ddindx binary_integer; indx binary_integer;
2815: begin
2816:
2817: -- copy data to the local IN or IN-OUT args, if any

Line 2891: okl_khr_pvt.delete_row(p_api_version,

2887: ddp_khrv_rec.securitized_code := p5_a64;
2888: ddp_khrv_rec.securitization_type := p5_a65;
2889:
2890: -- here's the delegated call to the old PL/SQL routine
2891: okl_khr_pvt.delete_row(p_api_version,
2892: p_init_msg_list,
2893: x_return_status,
2894: x_msg_count,
2895: x_msg_data,

Line 2980: ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;

2976: , p5_a65 JTF_VARCHAR2_TABLE_100
2977: )
2978:
2979: as
2980: ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;
2981: ddindx binary_integer; indx binary_integer;
2982: begin
2983:
2984: -- copy data to the local IN or IN-OUT args, if any

Line 2990: okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0

2986:
2987:
2988:
2989:
2990: okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0
2991: , p5_a1
2992: , p5_a2
2993: , p5_a3
2994: , p5_a4

Line 3059: okl_khr_pvt.delete_row(p_api_version,

3055: , p5_a65
3056: );
3057:
3058: -- here's the delegated call to the old PL/SQL routine
3059: okl_khr_pvt.delete_row(p_api_version,
3060: p_init_msg_list,
3061: x_return_status,
3062: x_msg_count,
3063: x_msg_data,

Line 3148: ddp_khrv_rec okl_khr_pvt.khrv_rec_type;

3144: , p5_a65 VARCHAR2 := fnd_api.g_miss_char
3145: )
3146:
3147: as
3148: ddp_khrv_rec okl_khr_pvt.khrv_rec_type;
3149: ddindx binary_integer; indx binary_integer;
3150: begin
3151:
3152: -- copy data to the local IN or IN-OUT args, if any

Line 3226: okl_khr_pvt.validate_row(p_api_version,

3222: ddp_khrv_rec.securitized_code := p5_a64;
3223: ddp_khrv_rec.securitization_type := p5_a65;
3224:
3225: -- here's the delegated call to the old PL/SQL routine
3226: okl_khr_pvt.validate_row(p_api_version,
3227: p_init_msg_list,
3228: x_return_status,
3229: x_msg_count,
3230: x_msg_data,

Line 3315: ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;

3311: , p5_a65 JTF_VARCHAR2_TABLE_100
3312: )
3313:
3314: as
3315: ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;
3316: ddindx binary_integer; indx binary_integer;
3317: begin
3318:
3319: -- copy data to the local IN or IN-OUT args, if any

Line 3325: okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0

3321:
3322:
3323:
3324:
3325: okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0
3326: , p5_a1
3327: , p5_a2
3328: , p5_a3
3329: , p5_a4

Line 3394: okl_khr_pvt.validate_row(p_api_version,

3390: , p5_a65
3391: );
3392:
3393: -- here's the delegated call to the old PL/SQL routine
3394: okl_khr_pvt.validate_row(p_api_version,
3395: p_init_msg_list,
3396: x_return_status,
3397: x_msg_count,
3398: x_msg_data,

Line 3483: ddp_khrv_rec okl_khr_pvt.khrv_rec_type;

3479: , p5_a65 VARCHAR2 := fnd_api.g_miss_char
3480: )
3481:
3482: as
3483: ddp_khrv_rec okl_khr_pvt.khrv_rec_type;
3484: ddindx binary_integer; indx binary_integer;
3485: begin
3486:
3487: -- copy data to the local IN or IN-OUT args, if any

Line 3561: okl_khr_pvt.lock_row(p_api_version,

3557: ddp_khrv_rec.securitized_code := p5_a64;
3558: ddp_khrv_rec.securitization_type := p5_a65;
3559:
3560: -- here's the delegated call to the old PL/SQL routine
3561: okl_khr_pvt.lock_row(p_api_version,
3562: p_init_msg_list,
3563: x_return_status,
3564: x_msg_count,
3565: x_msg_data,

Line 3650: ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;

3646: , p5_a65 JTF_VARCHAR2_TABLE_100
3647: )
3648:
3649: as
3650: ddp_khrv_tbl okl_khr_pvt.khrv_tbl_type;
3651: ddindx binary_integer; indx binary_integer;
3652: begin
3653:
3654: -- copy data to the local IN or IN-OUT args, if any

Line 3660: okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0

3656:
3657:
3658:
3659:
3660: okl_khr_pvt_w.rosetta_table_copy_in_p8(ddp_khrv_tbl, p5_a0
3661: , p5_a1
3662: , p5_a2
3663: , p5_a3
3664: , p5_a4

Line 3729: okl_khr_pvt.lock_row(p_api_version,

3725: , p5_a65
3726: );
3727:
3728: -- here's the delegated call to the old PL/SQL routine
3729: okl_khr_pvt.lock_row(p_api_version,
3730: p_init_msg_list,
3731: x_return_status,
3732: x_msg_count,
3733: x_msg_data,

Line 3744: end okl_khr_pvt_w;

3740:
3741:
3742: end;
3743:
3744: end okl_khr_pvt_w;