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.LNS_FINANCIALS_W dependencies on LNS_FINANCIALS

Line 1: package body lns_financials_w as

1: package body lns_financials_w as
2: /* $Header: LNS_FINANCIALJ_B.pls 120.7.12010000.3 2009/01/07 13:35:38 gparuchu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_financials.rate_schedule_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy lns_financials.rate_schedule_tbl, a0 JTF_NUMBER_TABLE

1: package body lns_financials_w as
2: /* $Header: LNS_FINANCIALJ_B.pls 120.7.12010000.3 2009/01/07 13:35:38 gparuchu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_financials.rate_schedule_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 40: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t lns_financials.rate_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_DATE_TABLE
42: , a2 out nocopy JTF_DATE_TABLE
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_NUMBER_TABLE

Line 109: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE

105: end if;
106: end if;
107: end rosetta_table_copy_out_p1;
108:
109: procedure rosetta_table_copy_in_p3(t out nocopy lns_financials.amortization_tbl, a0 JTF_NUMBER_TABLE
110: , a1 JTF_DATE_TABLE
111: , a2 JTF_DATE_TABLE
112: , a3 JTF_DATE_TABLE
113: , a4 JTF_NUMBER_TABLE

Line 180: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE

176: end loop;
177: end if;
178: end if;
179: end rosetta_table_copy_in_p3;
180: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
181: , a1 out nocopy JTF_DATE_TABLE
182: , a2 out nocopy JTF_DATE_TABLE
183: , a3 out nocopy JTF_DATE_TABLE
184: , a4 out nocopy JTF_NUMBER_TABLE

Line 334: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE

330: end if;
331: end if;
332: end rosetta_table_copy_out_p3;
333:
334: procedure rosetta_table_copy_in_p6(t out nocopy lns_financials.payoff_tbl, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_NUMBER_TABLE
338: , a4 JTF_NUMBER_TABLE

Line 371: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE

367: end loop;
368: end if;
369: end if;
370: end rosetta_table_copy_in_p6;
371: procedure rosetta_table_copy_out_p6(t lns_financials.payoff_tbl, a0 out nocopy JTF_NUMBER_TABLE
372: , a1 out nocopy JTF_NUMBER_TABLE
373: , a2 out nocopy JTF_NUMBER_TABLE
374: , a3 out nocopy JTF_NUMBER_TABLE
375: , a4 out nocopy JTF_NUMBER_TABLE

Line 440: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100

436: end if;
437: end if;
438: end rosetta_table_copy_out_p6;
439:
440: procedure rosetta_table_copy_in_p8(t out nocopy lns_financials.payoff_tbl2, a0 JTF_VARCHAR2_TABLE_100
441: , a1 JTF_NUMBER_TABLE
442: , a2 JTF_NUMBER_TABLE
443: , a3 JTF_NUMBER_TABLE
444: ) as

Line 465: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100

461: end loop;
462: end if;
463: end if;
464: end rosetta_table_copy_in_p8;
465: procedure rosetta_table_copy_out_p8(t lns_financials.payoff_tbl2, a0 out nocopy JTF_VARCHAR2_TABLE_100
466: , a1 out nocopy JTF_NUMBER_TABLE
467: , a2 out nocopy JTF_NUMBER_TABLE
468: , a3 out nocopy JTF_NUMBER_TABLE
469: ) as

Line 504: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE

500: end if;
501: end if;
502: end rosetta_table_copy_out_p8;
503:
504: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
505: , a1 JTF_NUMBER_TABLE
506: , a2 JTF_NUMBER_TABLE
507: , a3 JTF_NUMBER_TABLE
508: ) as

Line 529: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE

525: end loop;
526: end if;
527: end if;
528: end rosetta_table_copy_in_p10;
529: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
530: , a1 out nocopy JTF_NUMBER_TABLE
531: , a2 out nocopy JTF_NUMBER_TABLE
532: , a3 out nocopy JTF_NUMBER_TABLE
533: ) as

Line 568: procedure rosetta_table_copy_in_p12(t out nocopy lns_financials.payment_schedule_tbl, a0 JTF_DATE_TABLE

564: end if;
565: end if;
566: end rosetta_table_copy_out_p10;
567:
568: procedure rosetta_table_copy_in_p12(t out nocopy lns_financials.payment_schedule_tbl, a0 JTF_DATE_TABLE
569: , a1 JTF_DATE_TABLE
570: ) as
571: ddindx binary_integer; indx binary_integer;
572: begin

Line 589: procedure rosetta_table_copy_out_p12(t lns_financials.payment_schedule_tbl, a0 out nocopy JTF_DATE_TABLE

585: end loop;
586: end if;
587: end if;
588: end rosetta_table_copy_in_p12;
589: procedure rosetta_table_copy_out_p12(t lns_financials.payment_schedule_tbl, a0 out nocopy JTF_DATE_TABLE
590: , a1 out nocopy JTF_DATE_TABLE
591: ) as
592: ddindx binary_integer; indx binary_integer;
593: begin

Line 618: procedure rosetta_table_copy_in_p13(t out nocopy lns_financials.date_tbl, a0 JTF_DATE_TABLE) as

614: end if;
615: end if;
616: end rosetta_table_copy_out_p12;
617:
618: procedure rosetta_table_copy_in_p13(t out nocopy lns_financials.date_tbl, a0 JTF_DATE_TABLE) as
619: ddindx binary_integer; indx binary_integer;
620: begin
621: if a0 is not null and a0.count > 0 then
622: if a0.count > 0 then

Line 636: procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE) as

632: end loop;
633: end if;
634: end if;
635: end rosetta_table_copy_in_p13;
636: procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE) as
637: ddindx binary_integer; indx binary_integer;
638: begin
639: if t is null or t.count = 0 then
640: a0 := JTF_DATE_TABLE();

Line 659: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE) as

655: end if;
656: end if;
657: end rosetta_table_copy_out_p13;
658:
659: procedure rosetta_table_copy_in_p14(t out nocopy lns_financials.amount_tbl, a0 JTF_NUMBER_TABLE) as
660: ddindx binary_integer; indx binary_integer;
661: begin
662: if a0 is not null and a0.count > 0 then
663: if a0.count > 0 then

Line 677: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE) as

673: end loop;
674: end if;
675: end if;
676: end rosetta_table_copy_in_p14;
677: procedure rosetta_table_copy_out_p14(t lns_financials.amount_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
678: ddindx binary_integer; indx binary_integer;
679: begin
680: if t is null or t.count = 0 then
681: a0 := JTF_NUMBER_TABLE();

Line 700: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100) as

696: end if;
697: end if;
698: end rosetta_table_copy_out_p14;
699:
700: procedure rosetta_table_copy_in_p15(t out nocopy lns_financials.vchar_tbl, a0 JTF_VARCHAR2_TABLE_100) as
701: ddindx binary_integer; indx binary_integer;
702: begin
703: if a0 is not null and a0.count > 0 then
704: if a0.count > 0 then

Line 718: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

714: end loop;
715: end if;
716: end if;
717: end rosetta_table_copy_in_p15;
718: procedure rosetta_table_copy_out_p15(t lns_financials.vchar_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
719: ddindx binary_integer; indx binary_integer;
720: begin
721: if t is null or t.count = 0 then
722: a0 := JTF_VARCHAR2_TABLE_100();

Line 741: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE

737: end if;
738: end if;
739: end rosetta_table_copy_out_p15;
740:
741: procedure rosetta_table_copy_in_p17(t out nocopy lns_financials.fees_tbl, a0 JTF_NUMBER_TABLE
742: , a1 JTF_VARCHAR2_TABLE_100
743: , a2 JTF_NUMBER_TABLE
744: , a3 JTF_NUMBER_TABLE
745: , a4 JTF_VARCHAR2_TABLE_300

Line 778: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE

774: end loop;
775: end if;
776: end if;
777: end rosetta_table_copy_in_p17;
778: procedure rosetta_table_copy_out_p17(t lns_financials.fees_tbl, a0 out nocopy JTF_NUMBER_TABLE
779: , a1 out nocopy JTF_VARCHAR2_TABLE_100
780: , a2 out nocopy JTF_NUMBER_TABLE
781: , a3 out nocopy JTF_NUMBER_TABLE
782: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 946: ddx_loan_details lns_financials.loan_details_rec;

942: , x_msg_data out nocopy VARCHAR2
943: )
944:
945: as
946: ddx_loan_details lns_financials.loan_details_rec;
947: ddindx binary_integer; indx binary_integer;
948: begin
949:
950: -- copy data to the local IN or IN-OUT args, if any

Line 960: lns_financials.shiftloandates(p_loan_id,

956:
957:
958:
959: -- here's the delegated call to the old PL/SQL routine
960: lns_financials.shiftloandates(p_loan_id,
961: p_new_start_date,
962: p_phase,
963: ddx_loan_details,
964: x_dates_shifted_flag,

Line 1174: ddp_loan_details lns_financials.loan_details_rec;

1170: , x_msg_data out nocopy VARCHAR2
1171: )
1172:
1173: as
1174: ddp_loan_details lns_financials.loan_details_rec;
1175: ddindx binary_integer; indx binary_integer;
1176: begin
1177:
1178: -- copy data to the local IN or IN-OUT args, if any

Line 1284: lns_financials.validatepayoff(ddp_loan_details,

1280:
1281:
1282:
1283: -- here's the delegated call to the old PL/SQL routine
1284: lns_financials.validatepayoff(ddp_loan_details,
1285: p_payoff_date,
1286: x_return_status,
1287: x_msg_count,
1288: x_msg_data);

Line 1311: ddx_payoff_tbl lns_financials.payoff_tbl2;

1307: , x_msg_data out nocopy VARCHAR2
1308: )
1309:
1310: as
1311: ddx_payoff_tbl lns_financials.payoff_tbl2;
1312: ddindx binary_integer; indx binary_integer;
1313: begin
1314:
1315: -- copy data to the local IN or IN-OUT args, if any

Line 1325: lns_financials.calculatepayoff(p_api_version,

1321:
1322:
1323:
1324: -- here's the delegated call to the old PL/SQL routine
1325: lns_financials.calculatepayoff(p_api_version,
1326: p_init_msg_list,
1327: p_loan_id,
1328: p_payoff_date,
1329: ddx_payoff_tbl,

Line 1339: lns_financials_w.rosetta_table_copy_out_p8(ddx_payoff_tbl, p4_a0

1335:
1336:
1337:
1338:
1339: lns_financials_w.rosetta_table_copy_out_p8(ddx_payoff_tbl, p4_a0
1340: , p4_a1
1341: , p4_a2
1342: , p4_a3
1343: );

Line 1453: ddp_loan_details lns_financials.loan_details_rec;

1449: , p3_a9 JTF_VARCHAR2_TABLE_100
1450: ) return number
1451:
1452: as
1453: ddp_loan_details lns_financials.loan_details_rec;
1454: ddp_rate_tbl lns_financials.rate_schedule_tbl;
1455: ddindx binary_integer; indx binary_integer;
1456: ddrosetta_retval number;
1457: begin

Line 1454: ddp_rate_tbl lns_financials.rate_schedule_tbl;

1450: ) return number
1451:
1452: as
1453: ddp_loan_details lns_financials.loan_details_rec;
1454: ddp_rate_tbl lns_financials.rate_schedule_tbl;
1455: ddindx binary_integer; indx binary_integer;
1456: ddrosetta_retval number;
1457: begin
1458:

Line 1562: lns_financials_w.rosetta_table_copy_in_p1(ddp_rate_tbl, p3_a0

1558: ddp_loan_details.penal_int_grace_days := p0_a88;
1559:
1560:
1561:
1562: lns_financials_w.rosetta_table_copy_in_p1(ddp_rate_tbl, p3_a0
1563: , p3_a1
1564: , p3_a2
1565: , p3_a3
1566: , p3_a4

Line 1575: ddrosetta_retval := lns_financials.getweightedrate(ddp_loan_details,

1571: , p3_a9
1572: );
1573:
1574: -- here's the delegated call to the old PL/SQL routine
1575: ddrosetta_retval := lns_financials.getweightedrate(ddp_loan_details,
1576: p_start_date,
1577: p_end_date,
1578: ddp_rate_tbl);
1579:

Line 1719: ddp_loan_details lns_financials.loan_details_rec;

1715: , p4_a26 out nocopy JTF_NUMBER_TABLE
1716: )
1717:
1718: as
1719: ddp_loan_details lns_financials.loan_details_rec;
1720: ddp_rate_schedule lns_financials.rate_schedule_tbl;
1721: ddx_loan_amort_tbl lns_financials.amortization_tbl;
1722: ddindx binary_integer; indx binary_integer;
1723: begin

Line 1720: ddp_rate_schedule lns_financials.rate_schedule_tbl;

1716: )
1717:
1718: as
1719: ddp_loan_details lns_financials.loan_details_rec;
1720: ddp_rate_schedule lns_financials.rate_schedule_tbl;
1721: ddx_loan_amort_tbl lns_financials.amortization_tbl;
1722: ddindx binary_integer; indx binary_integer;
1723: begin
1724:

Line 1721: ddx_loan_amort_tbl lns_financials.amortization_tbl;

1717:
1718: as
1719: ddp_loan_details lns_financials.loan_details_rec;
1720: ddp_rate_schedule lns_financials.rate_schedule_tbl;
1721: ddx_loan_amort_tbl lns_financials.amortization_tbl;
1722: ddindx binary_integer; indx binary_integer;
1723: begin
1724:
1725: -- copy data to the local IN or IN-OUT args, if any

Line 1826: lns_financials_w.rosetta_table_copy_in_p1(ddp_rate_schedule, p1_a0

1822: ddp_loan_details.orig_number_installments := p0_a86;
1823: ddp_loan_details.penal_int_rate := p0_a87;
1824: ddp_loan_details.penal_int_grace_days := p0_a88;
1825:
1826: lns_financials_w.rosetta_table_copy_in_p1(ddp_rate_schedule, p1_a0
1827: , p1_a1
1828: , p1_a2
1829: , p1_a3
1830: , p1_a4

Line 1842: lns_financials.amortizeeploan(ddp_loan_details,

1838:
1839:
1840:
1841: -- here's the delegated call to the old PL/SQL routine
1842: lns_financials.amortizeeploan(ddp_loan_details,
1843: ddp_rate_schedule,
1844: p_based_on_terms,
1845: p_installment_number,
1846: ddx_loan_amort_tbl);

Line 1853: lns_financials_w.rosetta_table_copy_out_p3(ddx_loan_amort_tbl, p4_a0

1849:
1850:
1851:
1852:
1853: lns_financials_w.rosetta_table_copy_out_p3(ddx_loan_amort_tbl, p4_a0
1854: , p4_a1
1855: , p4_a2
1856: , p4_a3
1857: , p4_a4

Line 2014: ddp_loan_details lns_financials.loan_details_rec;

2010: , p4_a26 out nocopy JTF_NUMBER_TABLE
2011: )
2012:
2013: as
2014: ddp_loan_details lns_financials.loan_details_rec;
2015: ddp_rate_schedule lns_financials.rate_schedule_tbl;
2016: ddx_loan_amort_tbl lns_financials.amortization_tbl;
2017: ddindx binary_integer; indx binary_integer;
2018: begin

Line 2015: ddp_rate_schedule lns_financials.rate_schedule_tbl;

2011: )
2012:
2013: as
2014: ddp_loan_details lns_financials.loan_details_rec;
2015: ddp_rate_schedule lns_financials.rate_schedule_tbl;
2016: ddx_loan_amort_tbl lns_financials.amortization_tbl;
2017: ddindx binary_integer; indx binary_integer;
2018: begin
2019:

Line 2016: ddx_loan_amort_tbl lns_financials.amortization_tbl;

2012:
2013: as
2014: ddp_loan_details lns_financials.loan_details_rec;
2015: ddp_rate_schedule lns_financials.rate_schedule_tbl;
2016: ddx_loan_amort_tbl lns_financials.amortization_tbl;
2017: ddindx binary_integer; indx binary_integer;
2018: begin
2019:
2020: -- copy data to the local IN or IN-OUT args, if any

Line 2121: lns_financials_w.rosetta_table_copy_in_p1(ddp_rate_schedule, p1_a0

2117: ddp_loan_details.orig_number_installments := p0_a86;
2118: ddp_loan_details.penal_int_rate := p0_a87;
2119: ddp_loan_details.penal_int_grace_days := p0_a88;
2120:
2121: lns_financials_w.rosetta_table_copy_in_p1(ddp_rate_schedule, p1_a0
2122: , p1_a1
2123: , p1_a2
2124: , p1_a3
2125: , p1_a4

Line 2137: lns_financials.amortizeloan(ddp_loan_details,

2133:
2134:
2135:
2136: -- here's the delegated call to the old PL/SQL routine
2137: lns_financials.amortizeloan(ddp_loan_details,
2138: ddp_rate_schedule,
2139: p_based_on_terms,
2140: p_installment_number,
2141: ddx_loan_amort_tbl);

Line 2148: lns_financials_w.rosetta_table_copy_out_p3(ddx_loan_amort_tbl, p4_a0

2144:
2145:
2146:
2147:
2148: lns_financials_w.rosetta_table_copy_out_p3(ddx_loan_amort_tbl, p4_a0
2149: , p4_a1
2150: , p4_a2
2151: , p4_a3
2152: , p4_a4

Line 2211: ddx_loan_amort_tbl lns_financials.amortization_tbl;

2207: , p3_a26 out nocopy JTF_NUMBER_TABLE
2208: )
2209:
2210: as
2211: ddx_loan_amort_tbl lns_financials.amortization_tbl;
2212: ddindx binary_integer; indx binary_integer;
2213: begin
2214:
2215: -- copy data to the local IN or IN-OUT args, if any

Line 2221: lns_financials.amortizeloan(p_loan_id,

2217:
2218:
2219:
2220: -- here's the delegated call to the old PL/SQL routine
2221: lns_financials.amortizeloan(p_loan_id,
2222: p_based_on_terms,
2223: p_installment_number,
2224: ddx_loan_amort_tbl);
2225:

Line 2230: lns_financials_w.rosetta_table_copy_out_p3(ddx_loan_amort_tbl, p3_a0

2226: -- copy data back from the local variables to OUT or IN-OUT args, if any
2227:
2228:
2229:
2230: lns_financials_w.rosetta_table_copy_out_p3(ddx_loan_amort_tbl, p3_a0
2231: , p3_a1
2232: , p3_a2
2233: , p3_a3
2234: , p3_a4

Line 2389: ddp_loan_details lns_financials.loan_details_rec;

2385: , p2_a26 out nocopy JTF_NUMBER_TABLE
2386: )
2387:
2388: as
2389: ddp_loan_details lns_financials.loan_details_rec;
2390: ddp_rate_schedule lns_financials.rate_schedule_tbl;
2391: ddx_loan_amort_tbl lns_financials.amortization_tbl;
2392: ddindx binary_integer; indx binary_integer;
2393: begin

Line 2390: ddp_rate_schedule lns_financials.rate_schedule_tbl;

2386: )
2387:
2388: as
2389: ddp_loan_details lns_financials.loan_details_rec;
2390: ddp_rate_schedule lns_financials.rate_schedule_tbl;
2391: ddx_loan_amort_tbl lns_financials.amortization_tbl;
2392: ddindx binary_integer; indx binary_integer;
2393: begin
2394:

Line 2391: ddx_loan_amort_tbl lns_financials.amortization_tbl;

2387:
2388: as
2389: ddp_loan_details lns_financials.loan_details_rec;
2390: ddp_rate_schedule lns_financials.rate_schedule_tbl;
2391: ddx_loan_amort_tbl lns_financials.amortization_tbl;
2392: ddindx binary_integer; indx binary_integer;
2393: begin
2394:
2395: -- copy data to the local IN or IN-OUT args, if any

Line 2496: lns_financials_w.rosetta_table_copy_in_p1(ddp_rate_schedule, p1_a0

2492: ddp_loan_details.orig_number_installments := p0_a86;
2493: ddp_loan_details.penal_int_rate := p0_a87;
2494: ddp_loan_details.penal_int_grace_days := p0_a88;
2495:
2496: lns_financials_w.rosetta_table_copy_in_p1(ddp_rate_schedule, p1_a0
2497: , p1_a1
2498: , p1_a2
2499: , p1_a3
2500: , p1_a4

Line 2510: lns_financials.loanprojection(ddp_loan_details,

2506: );
2507:
2508:
2509: -- here's the delegated call to the old PL/SQL routine
2510: lns_financials.loanprojection(ddp_loan_details,
2511: ddp_rate_schedule,
2512: ddx_loan_amort_tbl);
2513:
2514: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 2517: lns_financials_w.rosetta_table_copy_out_p3(ddx_loan_amort_tbl, p2_a0

2513:
2514: -- copy data back from the local variables to OUT or IN-OUT args, if any
2515:
2516:
2517: lns_financials_w.rosetta_table_copy_out_p3(ddx_loan_amort_tbl, p2_a0
2518: , p2_a1
2519: , p2_a2
2520: , p2_a3
2521: , p2_a4

Line 2583: ddx_amort_tbl lns_financials.amortization_tbl;

2579: , x_msg_data out nocopy VARCHAR2
2580: )
2581:
2582: as
2583: ddx_amort_tbl lns_financials.amortization_tbl;
2584: ddindx binary_integer; indx binary_integer;
2585: begin
2586:
2587: -- copy data to the local IN or IN-OUT args, if any

Line 2596: lns_financials.runopenprojection(p_init_msg_list,

2592:
2593:
2594:
2595: -- here's the delegated call to the old PL/SQL routine
2596: lns_financials.runopenprojection(p_init_msg_list,
2597: p_loan_id,
2598: p_based_on_terms,
2599: ddx_amort_tbl,
2600: x_return_status,

Line 2608: lns_financials_w.rosetta_table_copy_out_p3(ddx_amort_tbl, p3_a0

2604: -- copy data back from the local variables to OUT or IN-OUT args, if any
2605:
2606:
2607:
2608: lns_financials_w.rosetta_table_copy_out_p3(ddx_amort_tbl, p3_a0
2609: , p3_a1
2610: , p3_a2
2611: , p3_a3
2612: , p3_a4

Line 2679: ddx_amort_tbl lns_financials.amortization_tbl;

2675: , x_msg_data out nocopy VARCHAR2
2676: )
2677:
2678: as
2679: ddx_amort_tbl lns_financials.amortization_tbl;
2680: ddindx binary_integer; indx binary_integer;
2681: begin
2682:
2683: -- copy data to the local IN or IN-OUT args, if any

Line 2694: lns_financials.runamortization(p_api_version,

2690:
2691:
2692:
2693: -- here's the delegated call to the old PL/SQL routine
2694: lns_financials.runamortization(p_api_version,
2695: p_init_msg_list,
2696: p_commit,
2697: p_loan_id,
2698: p_based_on_terms,

Line 2710: lns_financials_w.rosetta_table_copy_out_p3(ddx_amort_tbl, p5_a0

2706:
2707:
2708:
2709:
2710: lns_financials_w.rosetta_table_copy_out_p3(ddx_amort_tbl, p5_a0
2711: , p5_a1
2712: , p5_a2
2713: , p5_a3
2714: , p5_a4

Line 2791: ddx_amortization_rec lns_financials.amortization_rec;

2787: , x_msg_data out nocopy VARCHAR2
2788: )
2789:
2790: as
2791: ddx_amortization_rec lns_financials.amortization_rec;
2792: ddx_fees_tbl lns_financials.fees_tbl;
2793: ddindx binary_integer; indx binary_integer;
2794: begin
2795:

Line 2792: ddx_fees_tbl lns_financials.fees_tbl;

2788: )
2789:
2790: as
2791: ddx_amortization_rec lns_financials.amortization_rec;
2792: ddx_fees_tbl lns_financials.fees_tbl;
2793: ddindx binary_integer; indx binary_integer;
2794: begin
2795:
2796: -- copy data to the local IN or IN-OUT args, if any

Line 2808: lns_financials.getinstallment(p_api_version,

2804:
2805:
2806:
2807: -- here's the delegated call to the old PL/SQL routine
2808: lns_financials.getinstallment(p_api_version,
2809: p_init_msg_list,
2810: p_commit,
2811: p_loan_id,
2812: p_installment_number,

Line 2853: lns_financials_w.rosetta_table_copy_out_p17(ddx_fees_tbl, p6_a0

2849: p5_a24 := ddx_amortization_rec.unpaid_prin;
2850: p5_a25 := ddx_amortization_rec.unpaid_int;
2851: p5_a26 := ddx_amortization_rec.interest_rate;
2852:
2853: lns_financials_w.rosetta_table_copy_out_p17(ddx_fees_tbl, p6_a0
2854: , p6_a1
2855: , p6_a2
2856: , p6_a3
2857: , p6_a4

Line 2915: ddx_amortization_rec lns_financials.amortization_rec;

2911: , x_msg_data out nocopy VARCHAR2
2912: )
2913:
2914: as
2915: ddx_amortization_rec lns_financials.amortization_rec;
2916: ddx_fees_tbl lns_financials.fees_tbl;
2917: ddindx binary_integer; indx binary_integer;
2918: begin
2919:

Line 2916: ddx_fees_tbl lns_financials.fees_tbl;

2912: )
2913:
2914: as
2915: ddx_amortization_rec lns_financials.amortization_rec;
2916: ddx_fees_tbl lns_financials.fees_tbl;
2917: ddindx binary_integer; indx binary_integer;
2918: begin
2919:
2920: -- copy data to the local IN or IN-OUT args, if any

Line 2930: lns_financials.getopeninstallment(p_init_msg_list,

2926:
2927:
2928:
2929: -- here's the delegated call to the old PL/SQL routine
2930: lns_financials.getopeninstallment(p_init_msg_list,
2931: p_loan_id,
2932: p_installment_number,
2933: ddx_amortization_rec,
2934: ddx_fees_tbl,

Line 2971: lns_financials_w.rosetta_table_copy_out_p17(ddx_fees_tbl, p4_a0

2967: p3_a24 := ddx_amortization_rec.unpaid_prin;
2968: p3_a25 := ddx_amortization_rec.unpaid_int;
2969: p3_a26 := ddx_amortization_rec.interest_rate;
2970:
2971: lns_financials_w.rosetta_table_copy_out_p17(ddx_fees_tbl, p4_a0
2972: , p4_a1
2973: , p4_a2
2974: , p4_a3
2975: , p4_a4

Line 3025: ddx_amortization_rec lns_financials.amortization_rec;

3021: , x_msg_data out nocopy VARCHAR2
3022: )
3023:
3024: as
3025: ddx_amortization_rec lns_financials.amortization_rec;
3026: ddindx binary_integer; indx binary_integer;
3027: begin
3028:
3029: -- copy data to the local IN or IN-OUT args, if any

Line 3040: lns_financials.preprocessinstallment(p_api_version,

3036:
3037:
3038:
3039: -- here's the delegated call to the old PL/SQL routine
3040: lns_financials.preprocessinstallment(p_api_version,
3041: p_init_msg_list,
3042: p_commit,
3043: p_loan_id,
3044: p_installment_number,

Line 3125: ddx_amortization_rec lns_financials.amortization_rec;

3121: , x_msg_data out nocopy VARCHAR2
3122: )
3123:
3124: as
3125: ddx_amortization_rec lns_financials.amortization_rec;
3126: ddindx binary_integer; indx binary_integer;
3127: begin
3128:
3129: -- copy data to the local IN or IN-OUT args, if any

Line 3139: lns_financials.preprocessopeninstallment(p_init_msg_list,

3135:
3136:
3137:
3138: -- here's the delegated call to the old PL/SQL routine
3139: lns_financials.preprocessopeninstallment(p_init_msg_list,
3140: p_commit,
3141: p_loan_id,
3142: p_installment_number,
3143: ddx_amortization_rec,

Line 3209: ddrosetta_retval := lns_financials.calculateeppayment(p_loan_amount,

3205: else ddp_pay_in_arrears := true;
3206: end if;
3207:
3208: -- here's the delegated call to the old PL/SQL routine
3209: ddrosetta_retval := lns_financials.calculateeppayment(p_loan_amount,
3210: p_num_intervals,
3211: p_ending_balance,
3212: ddp_pay_in_arrears);
3213:

Line 3248: ddrosetta_retval := lns_financials.calculatepayment(p_loan_amount,

3244: else ddp_pay_in_arrears := true;
3245: end if;
3246:
3247: -- here's the delegated call to the old PL/SQL routine
3248: ddrosetta_retval := lns_financials.calculatepayment(p_loan_amount,
3249: p_periodic_rate,
3250: p_num_intervals,
3251: p_ending_balance,
3252: ddp_pay_in_arrears);

Line 3263: end lns_financials_w;

3259:
3260: return ddrosetta_retval;
3261: end;
3262:
3263: end lns_financials_w;