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_KLE_PVT_W dependencies on OKL_KLE_PVT

Line 1: package body okl_kle_pvt_w as

1: package body okl_kle_pvt_w as
2: /* $Header: OKLIKLEB.pls 115.6 2002/12/20 19:18:13 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_kle_pvt.kle_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_kle_pvt.kle_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 237: procedure rosetta_table_copy_out_p2(t okl_kle_pvt.kle_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

233: end loop;
234: end if;
235: end if;
236: end rosetta_table_copy_in_p2;
237: procedure rosetta_table_copy_out_p2(t okl_kle_pvt.kle_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_NUMBER_TABLE
239: , a2 out nocopy JTF_NUMBER_TABLE
240: , a3 out nocopy JTF_NUMBER_TABLE
241: , a4 out nocopy JTF_NUMBER_TABLE

Line 751: procedure rosetta_table_copy_in_p5(t out nocopy okl_kle_pvt.okl_k_lines_h_tbl_type, a0 JTF_NUMBER_TABLE

747: end if;
748: end if;
749: end rosetta_table_copy_out_p2;
750:
751: procedure rosetta_table_copy_in_p5(t out nocopy okl_kle_pvt.okl_k_lines_h_tbl_type, a0 JTF_NUMBER_TABLE
752: , a1 JTF_NUMBER_TABLE
753: , a2 JTF_NUMBER_TABLE
754: , a3 JTF_NUMBER_TABLE
755: , a4 JTF_NUMBER_TABLE

Line 968: procedure rosetta_table_copy_out_p5(t okl_kle_pvt.okl_k_lines_h_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

964: end loop;
965: end if;
966: end if;
967: end rosetta_table_copy_in_p5;
968: procedure rosetta_table_copy_out_p5(t okl_kle_pvt.okl_k_lines_h_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
969: , a1 out nocopy JTF_NUMBER_TABLE
970: , a2 out nocopy JTF_NUMBER_TABLE
971: , a3 out nocopy JTF_NUMBER_TABLE
972: , a4 out nocopy JTF_NUMBER_TABLE

Line 1487: procedure rosetta_table_copy_in_p8(t out nocopy okl_kle_pvt.klev_tbl_type, a0 JTF_NUMBER_TABLE

1483: end if;
1484: end if;
1485: end rosetta_table_copy_out_p5;
1486:
1487: procedure rosetta_table_copy_in_p8(t out nocopy okl_kle_pvt.klev_tbl_type, a0 JTF_NUMBER_TABLE
1488: , a1 JTF_NUMBER_TABLE
1489: , a2 JTF_NUMBER_TABLE
1490: , a3 JTF_NUMBER_TABLE
1491: , a4 JTF_VARCHAR2_TABLE_100

Line 1702: procedure rosetta_table_copy_out_p8(t okl_kle_pvt.klev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1698: end loop;
1699: end if;
1700: end if;
1701: end rosetta_table_copy_in_p8;
1702: procedure rosetta_table_copy_out_p8(t okl_kle_pvt.klev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1703: , a1 out nocopy JTF_NUMBER_TABLE
1704: , a2 out nocopy JTF_NUMBER_TABLE
1705: , a3 out nocopy JTF_NUMBER_TABLE
1706: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 2422: ddp_klev_rec okl_kle_pvt.klev_rec_type;

2418: , p5_a98 NUMBER := 0-1962.0724
2419: )
2420:
2421: as
2422: ddp_klev_rec okl_kle_pvt.klev_rec_type;
2423: ddx_klev_rec okl_kle_pvt.klev_rec_type;
2424: ddindx binary_integer; indx binary_integer;
2425: begin
2426:

Line 2423: ddx_klev_rec okl_kle_pvt.klev_rec_type;

2419: )
2420:
2421: as
2422: ddp_klev_rec okl_kle_pvt.klev_rec_type;
2423: ddx_klev_rec okl_kle_pvt.klev_rec_type;
2424: ddindx binary_integer; indx binary_integer;
2425: begin
2426:
2427: -- copy data to the local IN or IN-OUT args, if any

Line 2535: okl_kle_pvt.insert_row(p_api_version,

2531: ddp_klev_rec.pay_investor_remittance_days := rosetta_g_miss_num_map(p5_a98);
2532:
2533:
2534: -- here's the delegated call to the old PL/SQL routine
2535: okl_kle_pvt.insert_row(p_api_version,
2536: p_init_msg_list,
2537: x_return_status,
2538: x_msg_count,
2539: x_msg_data,

Line 2857: ddp_klev_tbl okl_kle_pvt.klev_tbl_type;

2853: , p6_a98 out nocopy JTF_NUMBER_TABLE
2854: )
2855:
2856: as
2857: ddp_klev_tbl okl_kle_pvt.klev_tbl_type;
2858: ddx_klev_tbl okl_kle_pvt.klev_tbl_type;
2859: ddindx binary_integer; indx binary_integer;
2860: begin
2861:

Line 2858: ddx_klev_tbl okl_kle_pvt.klev_tbl_type;

2854: )
2855:
2856: as
2857: ddp_klev_tbl okl_kle_pvt.klev_tbl_type;
2858: ddx_klev_tbl okl_kle_pvt.klev_tbl_type;
2859: ddindx binary_integer; indx binary_integer;
2860: begin
2861:
2862: -- copy data to the local IN or IN-OUT args, if any

Line 2868: okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p5_a0

2864:
2865:
2866:
2867:
2868: okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p5_a0
2869: , p5_a1
2870: , p5_a2
2871: , p5_a3
2872: , p5_a4

Line 2971: okl_kle_pvt.insert_row(p_api_version,

2967: );
2968:
2969:
2970: -- here's the delegated call to the old PL/SQL routine
2971: okl_kle_pvt.insert_row(p_api_version,
2972: p_init_msg_list,
2973: x_return_status,
2974: x_msg_count,
2975: x_msg_data,

Line 2986: okl_kle_pvt_w.rosetta_table_copy_out_p8(ddx_klev_tbl, p6_a0

2982:
2983:
2984:
2985:
2986: okl_kle_pvt_w.rosetta_table_copy_out_p8(ddx_klev_tbl, p6_a0
2987: , p6_a1
2988: , p6_a2
2989: , p6_a3
2990: , p6_a4

Line 3294: ddp_klev_rec okl_kle_pvt.klev_rec_type;

3290: , p5_a98 NUMBER := 0-1962.0724
3291: )
3292:
3293: as
3294: ddp_klev_rec okl_kle_pvt.klev_rec_type;
3295: ddx_klev_rec okl_kle_pvt.klev_rec_type;
3296: ddindx binary_integer; indx binary_integer;
3297: begin
3298:

Line 3295: ddx_klev_rec okl_kle_pvt.klev_rec_type;

3291: )
3292:
3293: as
3294: ddp_klev_rec okl_kle_pvt.klev_rec_type;
3295: ddx_klev_rec okl_kle_pvt.klev_rec_type;
3296: ddindx binary_integer; indx binary_integer;
3297: begin
3298:
3299: -- copy data to the local IN or IN-OUT args, if any

Line 3407: okl_kle_pvt.update_row(p_api_version,

3403: ddp_klev_rec.pay_investor_remittance_days := rosetta_g_miss_num_map(p5_a98);
3404:
3405:
3406: -- here's the delegated call to the old PL/SQL routine
3407: okl_kle_pvt.update_row(p_api_version,
3408: p_init_msg_list,
3409: x_return_status,
3410: x_msg_count,
3411: x_msg_data,

Line 3729: ddp_klev_tbl okl_kle_pvt.klev_tbl_type;

3725: , p6_a98 out nocopy JTF_NUMBER_TABLE
3726: )
3727:
3728: as
3729: ddp_klev_tbl okl_kle_pvt.klev_tbl_type;
3730: ddx_klev_tbl okl_kle_pvt.klev_tbl_type;
3731: ddindx binary_integer; indx binary_integer;
3732: begin
3733:

Line 3730: ddx_klev_tbl okl_kle_pvt.klev_tbl_type;

3726: )
3727:
3728: as
3729: ddp_klev_tbl okl_kle_pvt.klev_tbl_type;
3730: ddx_klev_tbl okl_kle_pvt.klev_tbl_type;
3731: ddindx binary_integer; indx binary_integer;
3732: begin
3733:
3734: -- copy data to the local IN or IN-OUT args, if any

Line 3740: okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p5_a0

3736:
3737:
3738:
3739:
3740: okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p5_a0
3741: , p5_a1
3742: , p5_a2
3743: , p5_a3
3744: , p5_a4

Line 3843: okl_kle_pvt.update_row(p_api_version,

3839: );
3840:
3841:
3842: -- here's the delegated call to the old PL/SQL routine
3843: okl_kle_pvt.update_row(p_api_version,
3844: p_init_msg_list,
3845: x_return_status,
3846: x_msg_count,
3847: x_msg_data,

Line 3858: okl_kle_pvt_w.rosetta_table_copy_out_p8(ddx_klev_tbl, p6_a0

3854:
3855:
3856:
3857:
3858: okl_kle_pvt_w.rosetta_table_copy_out_p8(ddx_klev_tbl, p6_a0
3859: , p6_a1
3860: , p6_a2
3861: , p6_a3
3862: , p6_a4

Line 4067: ddp_klev_rec okl_kle_pvt.klev_rec_type;

4063: , p5_a98 NUMBER := 0-1962.0724
4064: )
4065:
4066: as
4067: ddp_klev_rec okl_kle_pvt.klev_rec_type;
4068: ddindx binary_integer; indx binary_integer;
4069: begin
4070:
4071: -- copy data to the local IN or IN-OUT args, if any

Line 4178: okl_kle_pvt.delete_row(p_api_version,

4174: ddp_klev_rec.pay_investor_event := p5_a97;
4175: ddp_klev_rec.pay_investor_remittance_days := rosetta_g_miss_num_map(p5_a98);
4176:
4177: -- here's the delegated call to the old PL/SQL routine
4178: okl_kle_pvt.delete_row(p_api_version,
4179: p_init_msg_list,
4180: x_return_status,
4181: x_msg_count,
4182: x_msg_data,

Line 4300: ddp_klev_tbl okl_kle_pvt.klev_tbl_type;

4296: , p5_a98 JTF_NUMBER_TABLE
4297: )
4298:
4299: as
4300: ddp_klev_tbl okl_kle_pvt.klev_tbl_type;
4301: ddindx binary_integer; indx binary_integer;
4302: begin
4303:
4304: -- copy data to the local IN or IN-OUT args, if any

Line 4310: okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p5_a0

4306:
4307:
4308:
4309:
4310: okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p5_a0
4311: , p5_a1
4312: , p5_a2
4313: , p5_a3
4314: , p5_a4

Line 4412: okl_kle_pvt.delete_row(p_api_version,

4408: , p5_a98
4409: );
4410:
4411: -- here's the delegated call to the old PL/SQL routine
4412: okl_kle_pvt.delete_row(p_api_version,
4413: p_init_msg_list,
4414: x_return_status,
4415: x_msg_count,
4416: x_msg_data,

Line 4534: ddp_klev_rec okl_kle_pvt.klev_rec_type;

4530: , p5_a98 NUMBER := 0-1962.0724
4531: )
4532:
4533: as
4534: ddp_klev_rec okl_kle_pvt.klev_rec_type;
4535: ddindx binary_integer; indx binary_integer;
4536: begin
4537:
4538: -- copy data to the local IN or IN-OUT args, if any

Line 4645: okl_kle_pvt.validate_row(p_api_version,

4641: ddp_klev_rec.pay_investor_event := p5_a97;
4642: ddp_klev_rec.pay_investor_remittance_days := rosetta_g_miss_num_map(p5_a98);
4643:
4644: -- here's the delegated call to the old PL/SQL routine
4645: okl_kle_pvt.validate_row(p_api_version,
4646: p_init_msg_list,
4647: x_return_status,
4648: x_msg_count,
4649: x_msg_data,

Line 4767: ddp_klev_tbl okl_kle_pvt.klev_tbl_type;

4763: , p5_a98 JTF_NUMBER_TABLE
4764: )
4765:
4766: as
4767: ddp_klev_tbl okl_kle_pvt.klev_tbl_type;
4768: ddindx binary_integer; indx binary_integer;
4769: begin
4770:
4771: -- copy data to the local IN or IN-OUT args, if any

Line 4777: okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p5_a0

4773:
4774:
4775:
4776:
4777: okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p5_a0
4778: , p5_a1
4779: , p5_a2
4780: , p5_a3
4781: , p5_a4

Line 4879: okl_kle_pvt.validate_row(p_api_version,

4875: , p5_a98
4876: );
4877:
4878: -- here's the delegated call to the old PL/SQL routine
4879: okl_kle_pvt.validate_row(p_api_version,
4880: p_init_msg_list,
4881: x_return_status,
4882: x_msg_count,
4883: x_msg_data,

Line 5001: ddp_klev_rec okl_kle_pvt.klev_rec_type;

4997: , p5_a98 NUMBER := 0-1962.0724
4998: )
4999:
5000: as
5001: ddp_klev_rec okl_kle_pvt.klev_rec_type;
5002: ddindx binary_integer; indx binary_integer;
5003: begin
5004:
5005: -- copy data to the local IN or IN-OUT args, if any

Line 5112: okl_kle_pvt.lock_row(p_api_version,

5108: ddp_klev_rec.pay_investor_event := p5_a97;
5109: ddp_klev_rec.pay_investor_remittance_days := rosetta_g_miss_num_map(p5_a98);
5110:
5111: -- here's the delegated call to the old PL/SQL routine
5112: okl_kle_pvt.lock_row(p_api_version,
5113: p_init_msg_list,
5114: x_return_status,
5115: x_msg_count,
5116: x_msg_data,

Line 5234: ddp_klev_tbl okl_kle_pvt.klev_tbl_type;

5230: , p5_a98 JTF_NUMBER_TABLE
5231: )
5232:
5233: as
5234: ddp_klev_tbl okl_kle_pvt.klev_tbl_type;
5235: ddindx binary_integer; indx binary_integer;
5236: begin
5237:
5238: -- copy data to the local IN or IN-OUT args, if any

Line 5244: okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p5_a0

5240:
5241:
5242:
5243:
5244: okl_kle_pvt_w.rosetta_table_copy_in_p8(ddp_klev_tbl, p5_a0
5245: , p5_a1
5246: , p5_a2
5247: , p5_a3
5248: , p5_a4

Line 5346: okl_kle_pvt.lock_row(p_api_version,

5342: , p5_a98
5343: );
5344:
5345: -- here's the delegated call to the old PL/SQL routine
5346: okl_kle_pvt.lock_row(p_api_version,
5347: p_init_msg_list,
5348: x_return_status,
5349: x_msg_count,
5350: x_msg_data,

Line 5361: end okl_kle_pvt_w;

5357:
5358:
5359: end;
5360:
5361: end okl_kle_pvt_w;