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_CREDIT_PUB_W dependencies on OKL_CREDIT_PUB

Line 1: package body okl_credit_pub_w as

1: package body okl_credit_pub_w as
2: /* $Header: OKLUCRDB.pls 115.7 2003/08/29 22:46:01 cklee 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_p5(t out nocopy okl_credit_pub.clev_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_p5(t out nocopy okl_credit_pub.clev_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_100

Line 59: procedure rosetta_table_copy_out_p5(t okl_credit_pub.clev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

55: end loop;
56: end if;
57: end if;
58: end rosetta_table_copy_in_p5;
59: procedure rosetta_table_copy_out_p5(t okl_credit_pub.clev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_VARCHAR2_TABLE_200
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 201: okl_credit_pub.create_credit(p_api_version,

197:
198:
199:
200: -- here's the delegated call to the old PL/SQL routine
201: okl_credit_pub.create_credit(p_api_version,
202: p_init_msg_list,
203: x_return_status,
204: x_msg_count,
205: x_msg_data,

Line 611: ddp_khrv_rec okl_credit_pub.khrv_rec_type;

607: )
608:
609: as
610: ddp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
611: ddp_khrv_rec okl_credit_pub.khrv_rec_type;
612: ddx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
613: ddx_khrv_rec okl_credit_pub.khrv_rec_type;
614: ddindx binary_integer; indx binary_integer;
615: begin

Line 613: ddx_khrv_rec okl_credit_pub.khrv_rec_type;

609: as
610: ddp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
611: ddp_khrv_rec okl_credit_pub.khrv_rec_type;
612: ddx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
613: ddx_khrv_rec okl_credit_pub.khrv_rec_type;
614: ddindx binary_integer; indx binary_integer;
615: begin
616:
617: -- copy data to the local IN or IN-OUT args, if any

Line 802: okl_credit_pub.create_credit_header(p_api_version,

798:
799:
800:
801: -- here's the delegated call to the old PL/SQL routine
802: okl_credit_pub.create_credit_header(p_api_version,
803: p_init_msg_list,
804: x_return_status,
805: x_msg_count,
806: x_msg_data,

Line 1354: ddp_khrv_rec okl_credit_pub.khrv_rec_type;

1350: )
1351:
1352: as
1353: ddp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1354: ddp_khrv_rec okl_credit_pub.khrv_rec_type;
1355: ddx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1356: ddx_khrv_rec okl_credit_pub.khrv_rec_type;
1357: ddindx binary_integer; indx binary_integer;
1358: begin

Line 1356: ddx_khrv_rec okl_credit_pub.khrv_rec_type;

1352: as
1353: ddp_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1354: ddp_khrv_rec okl_credit_pub.khrv_rec_type;
1355: ddx_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1356: ddx_khrv_rec okl_credit_pub.khrv_rec_type;
1357: ddindx binary_integer; indx binary_integer;
1358: begin
1359:
1360: -- copy data to the local IN or IN-OUT args, if any

Line 1548: okl_credit_pub.update_credit_header(p_api_version,

1544:
1545:
1546:
1547: -- here's the delegated call to the old PL/SQL routine
1548: okl_credit_pub.update_credit_header(p_api_version,
1549: p_init_msg_list,
1550: x_return_status,
1551: x_msg_count,
1552: x_msg_data,

Line 1811: okl_credit_pub.validate_credit(p_api_version,

1807:
1808:
1809:
1810: -- here's the delegated call to the old PL/SQL routine
1811: okl_credit_pub.validate_credit(p_api_version,
1812: p_init_msg_list,
1813: x_return_status,
1814: x_msg_count,
1815: x_msg_data,

Line 1894: okl_credit_pub.validate_credit_limit(p_api_version,

1890:
1891:
1892:
1893: -- here's the delegated call to the old PL/SQL routine
1894: okl_credit_pub.validate_credit_limit(p_api_version,
1895: p_init_msg_list,
1896: x_return_status,
1897: x_msg_count,
1898: x_msg_data,

Line 2121: ddp_klev_rec okl_credit_pub.klev_rec_type;

2117: )
2118:
2119: as
2120: ddp_clev_rec okl_okc_migration_pvt.clev_rec_type;
2121: ddp_klev_rec okl_credit_pub.klev_rec_type;
2122: ddindx binary_integer; indx binary_integer;
2123: begin
2124:
2125: -- copy data to the local IN or IN-OUT args, if any

Line 2324: okl_credit_pub.validate_credit_limit(p_api_version,

2320: ddp_klev_rec.pay_investor_event := p7_a97;
2321: ddp_klev_rec.pay_investor_remittance_days := rosetta_g_miss_num_map(p7_a98);
2322:
2323: -- here's the delegated call to the old PL/SQL routine
2324: okl_credit_pub.validate_credit_limit(p_api_version,
2325: p_init_msg_list,
2326: x_return_status,
2327: x_msg_count,
2328: x_msg_data,

Line 2542: ddp_klev_tbl okl_credit_pub.klev_tbl_type;

2538: )
2539:
2540: as
2541: ddp_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
2542: ddp_klev_tbl okl_credit_pub.klev_tbl_type;
2543: ddindx binary_integer; indx binary_integer;
2544: begin
2545:
2546: -- copy data to the local IN or IN-OUT args, if any

Line 2747: okl_credit_pub.validate_credit_limit(p_api_version,

2743: , p7_a98
2744: );
2745:
2746: -- here's the delegated call to the old PL/SQL routine
2747: okl_credit_pub.validate_credit_limit(p_api_version,
2748: p_init_msg_list,
2749: x_return_status,
2750: x_msg_count,
2751: x_msg_data,

Line 2993: ddp_clev_tbl okl_credit_pub.clev_tbl_type;

2989: , p8_a98 out nocopy JTF_NUMBER_TABLE
2990: )
2991:
2992: as
2993: ddp_clev_tbl okl_credit_pub.clev_tbl_type;
2994: ddp_klev_tbl okl_credit_pub.klev_tbl_type;
2995: ddx_clev_tbl okl_credit_pub.clev_tbl_type;
2996: ddx_klev_tbl okl_credit_pub.klev_tbl_type;
2997: ddindx binary_integer; indx binary_integer;

Line 2994: ddp_klev_tbl okl_credit_pub.klev_tbl_type;

2990: )
2991:
2992: as
2993: ddp_clev_tbl okl_credit_pub.clev_tbl_type;
2994: ddp_klev_tbl okl_credit_pub.klev_tbl_type;
2995: ddx_clev_tbl okl_credit_pub.clev_tbl_type;
2996: ddx_klev_tbl okl_credit_pub.klev_tbl_type;
2997: ddindx binary_integer; indx binary_integer;
2998: begin

Line 2995: ddx_clev_tbl okl_credit_pub.clev_tbl_type;

2991:
2992: as
2993: ddp_clev_tbl okl_credit_pub.clev_tbl_type;
2994: ddp_klev_tbl okl_credit_pub.klev_tbl_type;
2995: ddx_clev_tbl okl_credit_pub.clev_tbl_type;
2996: ddx_klev_tbl okl_credit_pub.klev_tbl_type;
2997: ddindx binary_integer; indx binary_integer;
2998: begin
2999:

Line 2996: ddx_klev_tbl okl_credit_pub.klev_tbl_type;

2992: as
2993: ddp_clev_tbl okl_credit_pub.clev_tbl_type;
2994: ddp_klev_tbl okl_credit_pub.klev_tbl_type;
2995: ddx_clev_tbl okl_credit_pub.clev_tbl_type;
2996: ddx_klev_tbl okl_credit_pub.klev_tbl_type;
2997: ddindx binary_integer; indx binary_integer;
2998: begin
2999:
3000: -- copy data to the local IN or IN-OUT args, if any

Line 3006: okl_credit_pub_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p5_a0

3002:
3003:
3004:
3005:
3006: okl_credit_pub_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p5_a0
3007: , p5_a1
3008: , p5_a2
3009: , p5_a3
3010: , p5_a4

Line 3122: okl_credit_pub.create_credit_limit(p_api_version,

3118:
3119:
3120:
3121: -- here's the delegated call to the old PL/SQL routine
3122: okl_credit_pub.create_credit_limit(p_api_version,
3123: p_init_msg_list,
3124: x_return_status,
3125: x_msg_count,
3126: x_msg_data,

Line 3140: okl_credit_pub_w.rosetta_table_copy_out_p5(ddx_clev_tbl, p7_a0

3136:
3137:
3138:
3139:
3140: okl_credit_pub_w.rosetta_table_copy_out_p5(ddx_clev_tbl, p7_a0
3141: , p7_a1
3142: , p7_a2
3143: , p7_a3
3144: , p7_a4

Line 3480: ddp_clev_tbl okl_credit_pub.clev_tbl_type;

3476: , p8_a98 out nocopy JTF_NUMBER_TABLE
3477: )
3478:
3479: as
3480: ddp_clev_tbl okl_credit_pub.clev_tbl_type;
3481: ddp_klev_tbl okl_credit_pub.klev_tbl_type;
3482: ddx_clev_tbl okl_credit_pub.clev_tbl_type;
3483: ddx_klev_tbl okl_credit_pub.klev_tbl_type;
3484: ddindx binary_integer; indx binary_integer;

Line 3481: ddp_klev_tbl okl_credit_pub.klev_tbl_type;

3477: )
3478:
3479: as
3480: ddp_clev_tbl okl_credit_pub.clev_tbl_type;
3481: ddp_klev_tbl okl_credit_pub.klev_tbl_type;
3482: ddx_clev_tbl okl_credit_pub.clev_tbl_type;
3483: ddx_klev_tbl okl_credit_pub.klev_tbl_type;
3484: ddindx binary_integer; indx binary_integer;
3485: begin

Line 3482: ddx_clev_tbl okl_credit_pub.clev_tbl_type;

3478:
3479: as
3480: ddp_clev_tbl okl_credit_pub.clev_tbl_type;
3481: ddp_klev_tbl okl_credit_pub.klev_tbl_type;
3482: ddx_clev_tbl okl_credit_pub.clev_tbl_type;
3483: ddx_klev_tbl okl_credit_pub.klev_tbl_type;
3484: ddindx binary_integer; indx binary_integer;
3485: begin
3486:

Line 3483: ddx_klev_tbl okl_credit_pub.klev_tbl_type;

3479: as
3480: ddp_clev_tbl okl_credit_pub.clev_tbl_type;
3481: ddp_klev_tbl okl_credit_pub.klev_tbl_type;
3482: ddx_clev_tbl okl_credit_pub.clev_tbl_type;
3483: ddx_klev_tbl okl_credit_pub.klev_tbl_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 3493: okl_credit_pub_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p5_a0

3489:
3490:
3491:
3492:
3493: okl_credit_pub_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p5_a0
3494: , p5_a1
3495: , p5_a2
3496: , p5_a3
3497: , p5_a4

Line 3610: okl_credit_pub.update_credit_limit(p_api_version,

3606:
3607:
3608:
3609: -- here's the delegated call to the old PL/SQL routine
3610: okl_credit_pub.update_credit_limit(p_api_version,
3611: p_init_msg_list,
3612: x_return_status,
3613: x_msg_count,
3614: x_msg_data,

Line 3628: okl_credit_pub_w.rosetta_table_copy_out_p5(ddx_clev_tbl, p7_a0

3624:
3625:
3626:
3627:
3628: okl_credit_pub_w.rosetta_table_copy_out_p5(ddx_clev_tbl, p7_a0
3629: , p7_a1
3630: , p7_a2
3631: , p7_a3
3632: , p7_a4

Line 3859: ddp_clev_tbl okl_credit_pub.clev_tbl_type;

3855: , p6_a98 JTF_NUMBER_TABLE
3856: )
3857:
3858: as
3859: ddp_clev_tbl okl_credit_pub.clev_tbl_type;
3860: ddp_klev_tbl okl_credit_pub.klev_tbl_type;
3861: ddindx binary_integer; indx binary_integer;
3862: begin
3863:

Line 3860: ddp_klev_tbl okl_credit_pub.klev_tbl_type;

3856: )
3857:
3858: as
3859: ddp_clev_tbl okl_credit_pub.clev_tbl_type;
3860: ddp_klev_tbl okl_credit_pub.klev_tbl_type;
3861: ddindx binary_integer; indx binary_integer;
3862: begin
3863:
3864: -- copy data to the local IN or IN-OUT args, if any

Line 3870: okl_credit_pub_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p5_a0

3866:
3867:
3868:
3869:
3870: okl_credit_pub_w.rosetta_table_copy_in_p5(ddp_clev_tbl, p5_a0
3871: , p5_a1
3872: , p5_a2
3873: , p5_a3
3874: , p5_a4

Line 3986: okl_credit_pub.delete_credit_limit(p_api_version,

3982: , p6_a98
3983: );
3984:
3985: -- here's the delegated call to the old PL/SQL routine
3986: okl_credit_pub.delete_credit_limit(p_api_version,
3987: p_init_msg_list,
3988: x_return_status,
3989: x_msg_count,
3990: x_msg_data,

Line 4003: end okl_credit_pub_w;

3999:
4000:
4001: end;
4002:
4003: end okl_credit_pub_w;