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_K_RATE_PARAMS_PVT_W dependencies on OKL_K_RATE_PARAMS_PVT

Line 1: package body okl_k_rate_params_pvt_w as

1: package body okl_k_rate_params_pvt_w as
2: /* $Header: OKLUKRPB.pls 120.2 2005/11/22 23:41:07 ramurt 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_p1(t out nocopy okl_k_rate_params_pvt.krpdel_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_p1(t out nocopy okl_k_rate_params_pvt.krpdel_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: ) as
26: ddindx binary_integer; indx binary_integer;

Line 45: procedure rosetta_table_copy_out_p1(t okl_k_rate_params_pvt.krpdel_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

41: end loop;
42: end if;
43: end if;
44: end rosetta_table_copy_in_p1;
45: procedure rosetta_table_copy_out_p1(t okl_k_rate_params_pvt.krpdel_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
46: , a1 out nocopy JTF_VARCHAR2_TABLE_100
47: , a2 out nocopy JTF_DATE_TABLE
48: ) as
49: ddindx binary_integer; indx binary_integer;

Line 79: procedure rosetta_table_copy_in_p6(t out nocopy okl_k_rate_params_pvt.var_prm_tbl_type, a0 JTF_VARCHAR2_TABLE_100

75: end if;
76: end if;
77: end rosetta_table_copy_out_p1;
78:
79: procedure rosetta_table_copy_in_p6(t out nocopy okl_k_rate_params_pvt.var_prm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_NUMBER_TABLE
83: , a4 JTF_DATE_TABLE

Line 108: procedure rosetta_table_copy_out_p6(t okl_k_rate_params_pvt.var_prm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

104: end loop;
105: end if;
106: end if;
107: end rosetta_table_copy_in_p6;
108: procedure rosetta_table_copy_out_p6(t okl_k_rate_params_pvt.var_prm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
109: , a1 out nocopy JTF_VARCHAR2_TABLE_100
110: , a2 out nocopy JTF_VARCHAR2_TABLE_100
111: , a3 out nocopy JTF_NUMBER_TABLE
112: , a4 out nocopy JTF_DATE_TABLE

Line 211: okl_k_rate_params_pvt.get_product(p_api_version,

207:
208:
209:
210: -- here's the delegated call to the old PL/SQL routine
211: okl_k_rate_params_pvt.get_product(p_api_version,
212: p_init_msg_list,
213: x_return_status,
214: x_msg_count,
215: x_msg_data,

Line 367: ddp_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;

363: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
364: )
365:
366: as
367: ddp_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;
368: ddx_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;
369: ddindx binary_integer; indx binary_integer;
370: begin
371:

Line 368: ddx_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;

364: )
365:
366: as
367: ddp_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;
368: ddx_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;
369: ddindx binary_integer; indx binary_integer;
370: begin
371:
372: -- copy data to the local IN or IN-OUT args, if any

Line 431: okl_k_rate_params_pvt.create_k_rate_params(p_api_version,

427:
428:
429:
430: -- here's the delegated call to the old PL/SQL routine
431: okl_k_rate_params_pvt.create_k_rate_params(p_api_version,
432: p_init_msg_list,
433: x_return_status,
434: x_msg_count,
435: x_msg_data,

Line 535: ddp_krpr_rec okl_k_rate_params_pvt.krpr_rec_type;

531: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
532: )
533:
534: as
535: ddp_krpr_rec okl_k_rate_params_pvt.krpr_rec_type;
536: ddx_krpr_rec okl_k_rate_params_pvt.krpr_rec_type;
537: ddindx binary_integer; indx binary_integer;
538: begin
539:

Line 536: ddx_krpr_rec okl_k_rate_params_pvt.krpr_rec_type;

532: )
533:
534: as
535: ddp_krpr_rec okl_k_rate_params_pvt.krpr_rec_type;
536: ddx_krpr_rec okl_k_rate_params_pvt.krpr_rec_type;
537: ddindx binary_integer; indx binary_integer;
538: begin
539:
540: -- copy data to the local IN or IN-OUT args, if any

Line 563: okl_k_rate_params_pvt.create_k_rate_params(p_api_version,

559: ddp_krpr_rec.interest_basis_code := p5_a13;
560:
561:
562: -- here's the delegated call to the old PL/SQL routine
563: okl_k_rate_params_pvt.create_k_rate_params(p_api_version,
564: p_init_msg_list,
565: x_return_status,
566: x_msg_count,
567: x_msg_data,

Line 630: ddp_krpar_rec okl_k_rate_params_pvt.krpar_rec_type;

626: , p5_a13 NUMBER := 0-1962.0724
627: )
628:
629: as
630: ddp_krpar_rec okl_k_rate_params_pvt.krpar_rec_type;
631: ddx_krpar_rec okl_k_rate_params_pvt.krpar_rec_type;
632: ddindx binary_integer; indx binary_integer;
633: begin
634:

Line 631: ddx_krpar_rec okl_k_rate_params_pvt.krpar_rec_type;

627: )
628:
629: as
630: ddp_krpar_rec okl_k_rate_params_pvt.krpar_rec_type;
631: ddx_krpar_rec okl_k_rate_params_pvt.krpar_rec_type;
632: ddindx binary_integer; indx binary_integer;
633: begin
634:
635: -- copy data to the local IN or IN-OUT args, if any

Line 658: okl_k_rate_params_pvt.create_k_rate_params(p_api_version,

654: ddp_krpar_rec.rate_change_value := rosetta_g_miss_num_map(p5_a13);
655:
656:
657: -- here's the delegated call to the old PL/SQL routine
658: okl_k_rate_params_pvt.create_k_rate_params(p_api_version,
659: p_init_msg_list,
660: x_return_status,
661: x_msg_count,
662: x_msg_data,

Line 711: ddp_krpc_rec okl_k_rate_params_pvt.krpc_rec_type;

707: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
708: )
709:
710: as
711: ddp_krpc_rec okl_k_rate_params_pvt.krpc_rec_type;
712: ddx_krpc_rec okl_k_rate_params_pvt.krpc_rec_type;
713: ddindx binary_integer; indx binary_integer;
714: begin
715:

Line 712: ddx_krpc_rec okl_k_rate_params_pvt.krpc_rec_type;

708: )
709:
710: as
711: ddp_krpc_rec okl_k_rate_params_pvt.krpc_rec_type;
712: ddx_krpc_rec okl_k_rate_params_pvt.krpc_rec_type;
713: ddindx binary_integer; indx binary_integer;
714: begin
715:
716: -- copy data to the local IN or IN-OUT args, if any

Line 732: okl_k_rate_params_pvt.create_k_rate_params(p_api_version,

728: ddp_krpc_rec.conversion_type_code := p5_a6;
729:
730:
731: -- here's the delegated call to the old PL/SQL routine
732: okl_k_rate_params_pvt.create_k_rate_params(p_api_version,
733: p_init_msg_list,
734: x_return_status,
735: x_msg_count,
736: x_msg_data,

Line 862: ddp_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;

858: , p5_a48 VARCHAR2 := fnd_api.g_miss_char
859: )
860:
861: as
862: ddp_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;
863: ddx_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;
864: ddindx binary_integer; indx binary_integer;
865: begin
866:

Line 863: ddx_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;

859: )
860:
861: as
862: ddp_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;
863: ddx_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;
864: ddindx binary_integer; indx binary_integer;
865: begin
866:
867: -- copy data to the local IN or IN-OUT args, if any

Line 925: okl_k_rate_params_pvt.update_k_rate_params(p_api_version,

921: ddp_krpv_rec.catchup_frequency_code := p5_a48;
922:
923:
924: -- here's the delegated call to the old PL/SQL routine
925: okl_k_rate_params_pvt.update_k_rate_params(p_api_version,
926: p_init_msg_list,
927: x_return_status,
928: x_msg_count,
929: x_msg_data,

Line 1027: ddp_krpr_rec okl_k_rate_params_pvt.krpr_rec_type;

1023: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1024: )
1025:
1026: as
1027: ddp_krpr_rec okl_k_rate_params_pvt.krpr_rec_type;
1028: ddx_krpr_rec okl_k_rate_params_pvt.krpr_rec_type;
1029: ddindx binary_integer; indx binary_integer;
1030: begin
1031:

Line 1028: ddx_krpr_rec okl_k_rate_params_pvt.krpr_rec_type;

1024: )
1025:
1026: as
1027: ddp_krpr_rec okl_k_rate_params_pvt.krpr_rec_type;
1028: ddx_krpr_rec okl_k_rate_params_pvt.krpr_rec_type;
1029: ddindx binary_integer; indx binary_integer;
1030: begin
1031:
1032: -- copy data to the local IN or IN-OUT args, if any

Line 1055: okl_k_rate_params_pvt.update_k_rate_params(p_api_version,

1051: ddp_krpr_rec.interest_basis_code := p5_a13;
1052:
1053:
1054: -- here's the delegated call to the old PL/SQL routine
1055: okl_k_rate_params_pvt.update_k_rate_params(p_api_version,
1056: p_init_msg_list,
1057: x_return_status,
1058: x_msg_count,
1059: x_msg_data,

Line 1122: ddp_krpar_rec okl_k_rate_params_pvt.krpar_rec_type;

1118: , p5_a13 NUMBER := 0-1962.0724
1119: )
1120:
1121: as
1122: ddp_krpar_rec okl_k_rate_params_pvt.krpar_rec_type;
1123: ddx_krpar_rec okl_k_rate_params_pvt.krpar_rec_type;
1124: ddindx binary_integer; indx binary_integer;
1125: begin
1126:

Line 1123: ddx_krpar_rec okl_k_rate_params_pvt.krpar_rec_type;

1119: )
1120:
1121: as
1122: ddp_krpar_rec okl_k_rate_params_pvt.krpar_rec_type;
1123: ddx_krpar_rec okl_k_rate_params_pvt.krpar_rec_type;
1124: ddindx binary_integer; indx binary_integer;
1125: begin
1126:
1127: -- copy data to the local IN or IN-OUT args, if any

Line 1150: okl_k_rate_params_pvt.update_k_rate_params(p_api_version,

1146: ddp_krpar_rec.rate_change_value := rosetta_g_miss_num_map(p5_a13);
1147:
1148:
1149: -- here's the delegated call to the old PL/SQL routine
1150: okl_k_rate_params_pvt.update_k_rate_params(p_api_version,
1151: p_init_msg_list,
1152: x_return_status,
1153: x_msg_count,
1154: x_msg_data,

Line 1203: ddp_krpc_rec okl_k_rate_params_pvt.krpc_rec_type;

1199: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1200: )
1201:
1202: as
1203: ddp_krpc_rec okl_k_rate_params_pvt.krpc_rec_type;
1204: ddx_krpc_rec okl_k_rate_params_pvt.krpc_rec_type;
1205: ddindx binary_integer; indx binary_integer;
1206: begin
1207:

Line 1204: ddx_krpc_rec okl_k_rate_params_pvt.krpc_rec_type;

1200: )
1201:
1202: as
1203: ddp_krpc_rec okl_k_rate_params_pvt.krpc_rec_type;
1204: ddx_krpc_rec okl_k_rate_params_pvt.krpc_rec_type;
1205: ddindx binary_integer; indx binary_integer;
1206: begin
1207:
1208: -- copy data to the local IN or IN-OUT args, if any

Line 1224: okl_k_rate_params_pvt.update_k_rate_params(p_api_version,

1220: ddp_krpc_rec.conversion_type_code := p5_a6;
1221:
1222:
1223: -- here's the delegated call to the old PL/SQL routine
1224: okl_k_rate_params_pvt.update_k_rate_params(p_api_version,
1225: p_init_msg_list,
1226: x_return_status,
1227: x_msg_count,
1228: x_msg_data,

Line 1259: ddp_krpdel_tbl okl_k_rate_params_pvt.krpdel_tbl_type;

1255: , p5_a2 JTF_DATE_TABLE
1256: )
1257:
1258: as
1259: ddp_krpdel_tbl okl_k_rate_params_pvt.krpdel_tbl_type;
1260: ddindx binary_integer; indx binary_integer;
1261: begin
1262:
1263: -- copy data to the local IN or IN-OUT args, if any

Line 1269: okl_k_rate_params_pvt_w.rosetta_table_copy_in_p1(ddp_krpdel_tbl, p5_a0

1265:
1266:
1267:
1268:
1269: okl_k_rate_params_pvt_w.rosetta_table_copy_in_p1(ddp_krpdel_tbl, p5_a0
1270: , p5_a1
1271: , p5_a2
1272: );
1273:

Line 1275: okl_k_rate_params_pvt.delete_k_rate_params(p_api_version,

1271: , p5_a2
1272: );
1273:
1274: -- here's the delegated call to the old PL/SQL routine
1275: okl_k_rate_params_pvt.delete_k_rate_params(p_api_version,
1276: p_init_msg_list,
1277: x_return_status,
1278: x_msg_count,
1279: x_msg_data,

Line 1348: ddp_k_rate_tbl okl_k_rate_params_pvt.krpv_tbl_type;

1344: , p6_a48 JTF_VARCHAR2_TABLE_100
1345: )
1346:
1347: as
1348: ddp_k_rate_tbl okl_k_rate_params_pvt.krpv_tbl_type;
1349: ddindx binary_integer; indx binary_integer;
1350: begin
1351:
1352: -- copy data to the local IN or IN-OUT args, if any

Line 1411: okl_k_rate_params_pvt.validate_k_rate_params(p_api_version,

1407: , p6_a48
1408: );
1409:
1410: -- here's the delegated call to the old PL/SQL routine
1411: okl_k_rate_params_pvt.validate_k_rate_params(p_api_version,
1412: p_init_msg_list,
1413: x_return_status,
1414: x_msg_count,
1415: x_msg_data,

Line 1443: ddx_var_par_tbl okl_k_rate_params_pvt.var_prm_tbl_type;

1439: , p6_a5 out nocopy JTF_DATE_TABLE
1440: )
1441:
1442: as
1443: ddx_var_par_tbl okl_k_rate_params_pvt.var_prm_tbl_type;
1444: ddindx binary_integer; indx binary_integer;
1445: begin
1446:
1447: -- copy data to the local IN or IN-OUT args, if any

Line 1456: okl_k_rate_params_pvt.generate_rate_summary(p_api_version,

1452:
1453:
1454:
1455: -- here's the delegated call to the old PL/SQL routine
1456: okl_k_rate_params_pvt.generate_rate_summary(p_api_version,
1457: p_init_msg_list,
1458: x_return_status,
1459: x_msg_count,
1460: x_msg_data,

Line 1471: okl_k_rate_params_pvt_w.rosetta_table_copy_out_p6(ddx_var_par_tbl, p6_a0

1467:
1468:
1469:
1470:
1471: okl_k_rate_params_pvt_w.rosetta_table_copy_out_p6(ddx_var_par_tbl, p6_a0
1472: , p6_a1
1473: , p6_a2
1474: , p6_a3
1475: , p6_a4

Line 1541: ddp_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;

1537: , p9_a48 in out nocopy VARCHAR2
1538: )
1539:
1540: as
1541: ddp_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;
1542: ddindx binary_integer; indx binary_integer;
1543: begin
1544:
1545: -- copy data to the local IN or IN-OUT args, if any

Line 1606: okl_k_rate_params_pvt.default_k_rate_params(p_api_version,

1602: ddp_krpv_rec.last_update_login := rosetta_g_miss_num_map(p9_a47);
1603: ddp_krpv_rec.catchup_frequency_code := p9_a48;
1604:
1605: -- here's the delegated call to the old PL/SQL routine
1606: okl_k_rate_params_pvt.default_k_rate_params(p_api_version,
1607: p_init_msg_list,
1608: x_return_status,
1609: x_msg_count,
1610: x_msg_data,

Line 1702: okl_k_rate_params_pvt.cascade_contract_start_date(p_api_version,

1698:
1699: ddp_new_start_date := rosetta_g_miss_date_in_map(p_new_start_date);
1700:
1701: -- here's the delegated call to the old PL/SQL routine
1702: okl_k_rate_params_pvt.cascade_contract_start_date(p_api_version,
1703: p_init_msg_list,
1704: x_return_status,
1705: x_msg_count,
1706: x_msg_data,

Line 1776: ddx_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;

1772: )
1773:
1774: as
1775: ddp_effective_from_date date;
1776: ddx_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;
1777: ddx_no_data_found boolean;
1778: ddindx binary_integer; indx binary_integer;
1779: begin
1780:

Line 1789: okl_k_rate_params_pvt.get_rate_rec(p_chr_id,

1785:
1786:
1787:
1788: -- here's the delegated call to the old PL/SQL routine
1789: okl_k_rate_params_pvt.get_rate_rec(p_chr_id,
1790: p_parameter_type_code,
1791: ddp_effective_from_date,
1792: ddx_krpv_rec,
1793: ddx_no_data_found);

Line 1881: okl_k_rate_params_pvt.check_rebook_allowed(p_api_version,

1877:
1878: ddp_rebook_date := rosetta_g_miss_date_in_map(p_rebook_date);
1879:
1880: -- here's the delegated call to the old PL/SQL routine
1881: okl_k_rate_params_pvt.check_rebook_allowed(p_api_version,
1882: p_init_msg_list,
1883: x_return_status,
1884: x_msg_count,
1885: x_msg_data,

Line 1913: okl_k_rate_params_pvt.check_base_rate(p_khr_id,

1909:
1910:
1911:
1912: -- here's the delegated call to the old PL/SQL routine
1913: okl_k_rate_params_pvt.check_base_rate(p_khr_id,
1914: ddx_base_rate_defined,
1915: x_return_status);
1916:
1917: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1951: okl_k_rate_params_pvt.check_principal_payment(p_api_version,

1947:
1948:
1949:
1950: -- here's the delegated call to the old PL/SQL routine
1951: okl_k_rate_params_pvt.check_principal_payment(p_api_version,
1952: p_init_msg_list,
1953: x_return_status,
1954: x_msg_count,
1955: x_msg_data,

Line 2035: ddx_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;

2031: )
2032:
2033: as
2034: ddp_effective_from_date date;
2035: ddx_krpv_rec okl_k_rate_params_pvt.krpv_rec_type;
2036: ddindx binary_integer; indx binary_integer;
2037: begin
2038:
2039: -- copy data to the local IN or IN-OUT args, if any

Line 2051: okl_k_rate_params_pvt.copy_k_rate_params(p_api_version,

2047:
2048:
2049:
2050: -- here's the delegated call to the old PL/SQL routine
2051: okl_k_rate_params_pvt.copy_k_rate_params(p_api_version,
2052: p_init_msg_list,
2053: x_return_status,
2054: x_msg_count,
2055: x_msg_data,

Line 2121: end okl_k_rate_params_pvt_w;

2117: p8_a47 := rosetta_g_miss_num_map(ddx_krpv_rec.last_update_login);
2118: p8_a48 := ddx_krpv_rec.catchup_frequency_code;
2119: end;
2120:
2121: end okl_k_rate_params_pvt_w;