DBA Data[Home] [Help]

APPS.LNS_FINANCIALS_W dependencies on JTF_DATE_TABLE

Line 4: , a1 JTF_DATE_TABLE

1: package body lns_financials_w as
2: /* $Header: LNS_FINANCIALJ_B.pls 120.13.12020000.2 2012/07/19 20:56:08 scherkas 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
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_DATE_TABLE

1: package body lns_financials_w as
2: /* $Header: LNS_FINANCIALJ_B.pls 120.13.12020000.2 2012/07/19 20:56:08 scherkas 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
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 41: , a1 out nocopy JTF_DATE_TABLE

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
45: , a5 out nocopy JTF_NUMBER_TABLE

Line 42: , a2 out nocopy JTF_DATE_TABLE

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
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE

Line 55: a1 := JTF_DATE_TABLE();

51: ddindx binary_integer; indx binary_integer;
52: begin
53: if t is null or t.count = 0 then
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_DATE_TABLE();
56: a2 := JTF_DATE_TABLE();
57: a3 := JTF_NUMBER_TABLE();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();

Line 56: a2 := JTF_DATE_TABLE();

52: begin
53: if t is null or t.count = 0 then
54: a0 := JTF_NUMBER_TABLE();
55: a1 := JTF_DATE_TABLE();
56: a2 := JTF_DATE_TABLE();
57: a3 := JTF_NUMBER_TABLE();
58: a4 := JTF_NUMBER_TABLE();
59: a5 := JTF_NUMBER_TABLE();
60: a6 := JTF_NUMBER_TABLE();

Line 66: a1 := JTF_DATE_TABLE();

62: a8 := JTF_VARCHAR2_TABLE_100();
63: a9 := JTF_VARCHAR2_TABLE_100();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_DATE_TABLE();
67: a2 := JTF_DATE_TABLE();
68: a3 := JTF_NUMBER_TABLE();
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();

Line 67: a2 := JTF_DATE_TABLE();

63: a9 := JTF_VARCHAR2_TABLE_100();
64: else
65: a0 := JTF_NUMBER_TABLE();
66: a1 := JTF_DATE_TABLE();
67: a2 := JTF_DATE_TABLE();
68: a3 := JTF_NUMBER_TABLE();
69: a4 := JTF_NUMBER_TABLE();
70: a5 := JTF_NUMBER_TABLE();
71: a6 := JTF_NUMBER_TABLE();

Line 110: , a1 JTF_DATE_TABLE

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
114: , a5 JTF_NUMBER_TABLE

Line 111: , a2 JTF_DATE_TABLE

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
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_NUMBER_TABLE

Line 112: , a3 JTF_DATE_TABLE

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
114: , a5 JTF_NUMBER_TABLE
115: , a6 JTF_NUMBER_TABLE
116: , a7 JTF_NUMBER_TABLE

Line 213: , a1 out nocopy JTF_DATE_TABLE

209: end if;
210: end if;
211: end rosetta_table_copy_in_p3;
212: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
213: , a1 out nocopy JTF_DATE_TABLE
214: , a2 out nocopy JTF_DATE_TABLE
215: , a3 out nocopy JTF_DATE_TABLE
216: , a4 out nocopy JTF_NUMBER_TABLE
217: , a5 out nocopy JTF_NUMBER_TABLE

Line 214: , a2 out nocopy JTF_DATE_TABLE

210: end if;
211: end rosetta_table_copy_in_p3;
212: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
213: , a1 out nocopy JTF_DATE_TABLE
214: , a2 out nocopy JTF_DATE_TABLE
215: , a3 out nocopy JTF_DATE_TABLE
216: , a4 out nocopy JTF_NUMBER_TABLE
217: , a5 out nocopy JTF_NUMBER_TABLE
218: , a6 out nocopy JTF_NUMBER_TABLE

Line 215: , a3 out nocopy JTF_DATE_TABLE

211: end rosetta_table_copy_in_p3;
212: procedure rosetta_table_copy_out_p3(t lns_financials.amortization_tbl, a0 out nocopy JTF_NUMBER_TABLE
213: , a1 out nocopy JTF_DATE_TABLE
214: , a2 out nocopy JTF_DATE_TABLE
215: , a3 out nocopy JTF_DATE_TABLE
216: , a4 out nocopy JTF_NUMBER_TABLE
217: , a5 out nocopy JTF_NUMBER_TABLE
218: , a6 out nocopy JTF_NUMBER_TABLE
219: , a7 out nocopy JTF_NUMBER_TABLE

Line 260: a1 := JTF_DATE_TABLE();

256: ddindx binary_integer; indx binary_integer;
257: begin
258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_DATE_TABLE();
261: a2 := JTF_DATE_TABLE();
262: a3 := JTF_DATE_TABLE();
263: a4 := JTF_NUMBER_TABLE();
264: a5 := JTF_NUMBER_TABLE();

Line 261: a2 := JTF_DATE_TABLE();

257: begin
258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_DATE_TABLE();
261: a2 := JTF_DATE_TABLE();
262: a3 := JTF_DATE_TABLE();
263: a4 := JTF_NUMBER_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_NUMBER_TABLE();

Line 262: a3 := JTF_DATE_TABLE();

258: if t is null or t.count = 0 then
259: a0 := JTF_NUMBER_TABLE();
260: a1 := JTF_DATE_TABLE();
261: a2 := JTF_DATE_TABLE();
262: a3 := JTF_DATE_TABLE();
263: a4 := JTF_NUMBER_TABLE();
264: a5 := JTF_NUMBER_TABLE();
265: a6 := JTF_NUMBER_TABLE();
266: a7 := JTF_NUMBER_TABLE();

Line 304: a1 := JTF_DATE_TABLE();

300: a41 := JTF_NUMBER_TABLE();
301: a42 := JTF_VARCHAR2_TABLE_2000();
302: else
303: a0 := JTF_NUMBER_TABLE();
304: a1 := JTF_DATE_TABLE();
305: a2 := JTF_DATE_TABLE();
306: a3 := JTF_DATE_TABLE();
307: a4 := JTF_NUMBER_TABLE();
308: a5 := JTF_NUMBER_TABLE();

Line 305: a2 := JTF_DATE_TABLE();

301: a42 := JTF_VARCHAR2_TABLE_2000();
302: else
303: a0 := JTF_NUMBER_TABLE();
304: a1 := JTF_DATE_TABLE();
305: a2 := JTF_DATE_TABLE();
306: a3 := JTF_DATE_TABLE();
307: a4 := JTF_NUMBER_TABLE();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();

Line 306: a3 := JTF_DATE_TABLE();

302: else
303: a0 := JTF_NUMBER_TABLE();
304: a1 := JTF_DATE_TABLE();
305: a2 := JTF_DATE_TABLE();
306: a3 := JTF_DATE_TABLE();
307: a4 := JTF_NUMBER_TABLE();
308: a5 := JTF_NUMBER_TABLE();
309: a6 := JTF_NUMBER_TABLE();
310: a7 := JTF_NUMBER_TABLE();

Line 455: , a9 JTF_DATE_TABLE

451: , a5 JTF_NUMBER_TABLE
452: , a6 JTF_NUMBER_TABLE
453: , a7 JTF_NUMBER_TABLE
454: , a8 JTF_NUMBER_TABLE
455: , a9 JTF_DATE_TABLE
456: ) as
457: ddindx binary_integer; indx binary_integer;
458: begin
459: if a0 is not null and a0.count > 0 then

Line 492: , a9 out nocopy JTF_DATE_TABLE

488: , a5 out nocopy JTF_NUMBER_TABLE
489: , a6 out nocopy JTF_NUMBER_TABLE
490: , a7 out nocopy JTF_NUMBER_TABLE
491: , a8 out nocopy JTF_NUMBER_TABLE
492: , a9 out nocopy JTF_DATE_TABLE
493: ) as
494: ddindx binary_integer; indx binary_integer;
495: begin
496: if t is null or t.count = 0 then

Line 506: a9 := JTF_DATE_TABLE();

502: a5 := JTF_NUMBER_TABLE();
503: a6 := JTF_NUMBER_TABLE();
504: a7 := JTF_NUMBER_TABLE();
505: a8 := JTF_NUMBER_TABLE();
506: a9 := JTF_DATE_TABLE();
507: else
508: a0 := JTF_NUMBER_TABLE();
509: a1 := JTF_NUMBER_TABLE();
510: a2 := JTF_NUMBER_TABLE();

Line 517: a9 := JTF_DATE_TABLE();

513: a5 := JTF_NUMBER_TABLE();
514: a6 := JTF_NUMBER_TABLE();
515: a7 := JTF_NUMBER_TABLE();
516: a8 := JTF_NUMBER_TABLE();
517: a9 := JTF_DATE_TABLE();
518: if t.count > 0 then
519: a0.extend(t.count);
520: a1.extend(t.count);
521: a2.extend(t.count);

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

612: end if;
613: end if;
614: end rosetta_table_copy_out_p8;
615:
616: procedure rosetta_table_copy_in_p10(t out nocopy lns_financials.loan_activity_tbl, a0 JTF_DATE_TABLE
617: , a1 JTF_NUMBER_TABLE
618: , a2 JTF_NUMBER_TABLE
619: , a3 JTF_NUMBER_TABLE
620: ) as

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

637: end loop;
638: end if;
639: end if;
640: end rosetta_table_copy_in_p10;
641: procedure rosetta_table_copy_out_p10(t lns_financials.loan_activity_tbl, a0 out nocopy JTF_DATE_TABLE
642: , a1 out nocopy JTF_NUMBER_TABLE
643: , a2 out nocopy JTF_NUMBER_TABLE
644: , a3 out nocopy JTF_NUMBER_TABLE
645: ) as

Line 649: a0 := JTF_DATE_TABLE();

645: ) as
646: ddindx binary_integer; indx binary_integer;
647: begin
648: if t is null or t.count = 0 then
649: a0 := JTF_DATE_TABLE();
650: a1 := JTF_NUMBER_TABLE();
651: a2 := JTF_NUMBER_TABLE();
652: a3 := JTF_NUMBER_TABLE();
653: else

Line 654: a0 := JTF_DATE_TABLE();

650: a1 := JTF_NUMBER_TABLE();
651: a2 := JTF_NUMBER_TABLE();
652: a3 := JTF_NUMBER_TABLE();
653: else
654: a0 := JTF_DATE_TABLE();
655: a1 := JTF_NUMBER_TABLE();
656: a2 := JTF_NUMBER_TABLE();
657: a3 := JTF_NUMBER_TABLE();
658: if t.count > 0 then

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

676: end if;
677: end if;
678: end rosetta_table_copy_out_p10;
679:
680: procedure rosetta_table_copy_in_p12(t out nocopy lns_financials.payment_schedule_tbl, a0 JTF_DATE_TABLE
681: , a1 JTF_DATE_TABLE
682: ) as
683: ddindx binary_integer; indx binary_integer;
684: begin

Line 681: , a1 JTF_DATE_TABLE

677: end if;
678: end rosetta_table_copy_out_p10;
679:
680: procedure rosetta_table_copy_in_p12(t out nocopy lns_financials.payment_schedule_tbl, a0 JTF_DATE_TABLE
681: , a1 JTF_DATE_TABLE
682: ) as
683: ddindx binary_integer; indx binary_integer;
684: begin
685: if a0 is not null and a0.count > 0 then

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

697: end loop;
698: end if;
699: end if;
700: end rosetta_table_copy_in_p12;
701: procedure rosetta_table_copy_out_p12(t lns_financials.payment_schedule_tbl, a0 out nocopy JTF_DATE_TABLE
702: , a1 out nocopy JTF_DATE_TABLE
703: ) as
704: ddindx binary_integer; indx binary_integer;
705: begin

Line 702: , a1 out nocopy JTF_DATE_TABLE

698: end if;
699: end if;
700: end rosetta_table_copy_in_p12;
701: procedure rosetta_table_copy_out_p12(t lns_financials.payment_schedule_tbl, a0 out nocopy JTF_DATE_TABLE
702: , a1 out nocopy JTF_DATE_TABLE
703: ) as
704: ddindx binary_integer; indx binary_integer;
705: begin
706: if t is null or t.count = 0 then

Line 707: a0 := JTF_DATE_TABLE();

703: ) as
704: ddindx binary_integer; indx binary_integer;
705: begin
706: if t is null or t.count = 0 then
707: a0 := JTF_DATE_TABLE();
708: a1 := JTF_DATE_TABLE();
709: else
710: a0 := JTF_DATE_TABLE();
711: a1 := JTF_DATE_TABLE();

Line 708: a1 := JTF_DATE_TABLE();

704: ddindx binary_integer; indx binary_integer;
705: begin
706: if t is null or t.count = 0 then
707: a0 := JTF_DATE_TABLE();
708: a1 := JTF_DATE_TABLE();
709: else
710: a0 := JTF_DATE_TABLE();
711: a1 := JTF_DATE_TABLE();
712: if t.count > 0 then

Line 710: a0 := JTF_DATE_TABLE();

706: if t is null or t.count = 0 then
707: a0 := JTF_DATE_TABLE();
708: a1 := JTF_DATE_TABLE();
709: else
710: a0 := JTF_DATE_TABLE();
711: a1 := JTF_DATE_TABLE();
712: if t.count > 0 then
713: a0.extend(t.count);
714: a1.extend(t.count);

Line 711: a1 := JTF_DATE_TABLE();

707: a0 := JTF_DATE_TABLE();
708: a1 := JTF_DATE_TABLE();
709: else
710: a0 := JTF_DATE_TABLE();
711: a1 := JTF_DATE_TABLE();
712: if t.count > 0 then
713: a0.extend(t.count);
714: a1.extend(t.count);
715: ddindx := t.first;

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

726: end if;
727: end if;
728: end rosetta_table_copy_out_p12;
729:
730: procedure rosetta_table_copy_in_p13(t out nocopy lns_financials.date_tbl, a0 JTF_DATE_TABLE) as
731: ddindx binary_integer; indx binary_integer;
732: begin
733: if a0 is not null and a0.count > 0 then
734: if a0.count > 0 then

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

744: end loop;
745: end if;
746: end if;
747: end rosetta_table_copy_in_p13;
748: procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE) as
749: ddindx binary_integer; indx binary_integer;
750: begin
751: if t is null or t.count = 0 then
752: a0 := JTF_DATE_TABLE();

Line 752: a0 := JTF_DATE_TABLE();

748: procedure rosetta_table_copy_out_p13(t lns_financials.date_tbl, a0 out nocopy JTF_DATE_TABLE) as
749: ddindx binary_integer; indx binary_integer;
750: begin
751: if t is null or t.count = 0 then
752: a0 := JTF_DATE_TABLE();
753: else
754: a0 := JTF_DATE_TABLE();
755: if t.count > 0 then
756: a0.extend(t.count);

Line 754: a0 := JTF_DATE_TABLE();

750: begin
751: if t is null or t.count = 0 then
752: a0 := JTF_DATE_TABLE();
753: else
754: a0 := JTF_DATE_TABLE();
755: if t.count > 0 then
756: a0.extend(t.count);
757: ddindx := t.first;
758: indx := 1;

Line 1588: , p3_a1 JTF_DATE_TABLE

1584: , p0_a95 VARCHAR2
1585: , p_start_date DATE
1586: , p_end_date DATE
1587: , p3_a0 JTF_NUMBER_TABLE
1588: , p3_a1 JTF_DATE_TABLE
1589: , p3_a2 JTF_DATE_TABLE
1590: , p3_a3 JTF_NUMBER_TABLE
1591: , p3_a4 JTF_NUMBER_TABLE
1592: , p3_a5 JTF_NUMBER_TABLE

Line 1589: , p3_a2 JTF_DATE_TABLE

1585: , p_start_date DATE
1586: , p_end_date DATE
1587: , p3_a0 JTF_NUMBER_TABLE
1588: , p3_a1 JTF_DATE_TABLE
1589: , p3_a2 JTF_DATE_TABLE
1590: , p3_a3 JTF_NUMBER_TABLE
1591: , p3_a4 JTF_NUMBER_TABLE
1592: , p3_a5 JTF_NUMBER_TABLE
1593: , p3_a6 JTF_NUMBER_TABLE

Line 1839: , p1_a1 JTF_DATE_TABLE

1835: , p0_a93 VARCHAR2
1836: , p0_a94 VARCHAR2
1837: , p0_a95 VARCHAR2
1838: , p1_a0 JTF_NUMBER_TABLE
1839: , p1_a1 JTF_DATE_TABLE
1840: , p1_a2 JTF_DATE_TABLE
1841: , p1_a3 JTF_NUMBER_TABLE
1842: , p1_a4 JTF_NUMBER_TABLE
1843: , p1_a5 JTF_NUMBER_TABLE

Line 1840: , p1_a2 JTF_DATE_TABLE

1836: , p0_a94 VARCHAR2
1837: , p0_a95 VARCHAR2
1838: , p1_a0 JTF_NUMBER_TABLE
1839: , p1_a1 JTF_DATE_TABLE
1840: , p1_a2 JTF_DATE_TABLE
1841: , p1_a3 JTF_NUMBER_TABLE
1842: , p1_a4 JTF_NUMBER_TABLE
1843: , p1_a5 JTF_NUMBER_TABLE
1844: , p1_a6 JTF_NUMBER_TABLE

Line 1851: , p4_a1 out nocopy JTF_DATE_TABLE

1847: , p1_a9 JTF_VARCHAR2_TABLE_100
1848: , p_based_on_terms VARCHAR2
1849: , p_installment_number NUMBER
1850: , p4_a0 out nocopy JTF_NUMBER_TABLE
1851: , p4_a1 out nocopy JTF_DATE_TABLE
1852: , p4_a2 out nocopy JTF_DATE_TABLE
1853: , p4_a3 out nocopy JTF_DATE_TABLE
1854: , p4_a4 out nocopy JTF_NUMBER_TABLE
1855: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 1852: , p4_a2 out nocopy JTF_DATE_TABLE

1848: , p_based_on_terms VARCHAR2
1849: , p_installment_number NUMBER
1850: , p4_a0 out nocopy JTF_NUMBER_TABLE
1851: , p4_a1 out nocopy JTF_DATE_TABLE
1852: , p4_a2 out nocopy JTF_DATE_TABLE
1853: , p4_a3 out nocopy JTF_DATE_TABLE
1854: , p4_a4 out nocopy JTF_NUMBER_TABLE
1855: , p4_a5 out nocopy JTF_NUMBER_TABLE
1856: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 1853: , p4_a3 out nocopy JTF_DATE_TABLE

1849: , p_installment_number NUMBER
1850: , p4_a0 out nocopy JTF_NUMBER_TABLE
1851: , p4_a1 out nocopy JTF_DATE_TABLE
1852: , p4_a2 out nocopy JTF_DATE_TABLE
1853: , p4_a3 out nocopy JTF_DATE_TABLE
1854: , p4_a4 out nocopy JTF_NUMBER_TABLE
1855: , p4_a5 out nocopy JTF_NUMBER_TABLE
1856: , p4_a6 out nocopy JTF_NUMBER_TABLE
1857: , p4_a7 out nocopy JTF_NUMBER_TABLE

Line 2180: , p1_a1 JTF_DATE_TABLE

2176: , p0_a93 VARCHAR2
2177: , p0_a94 VARCHAR2
2178: , p0_a95 VARCHAR2
2179: , p1_a0 JTF_NUMBER_TABLE
2180: , p1_a1 JTF_DATE_TABLE
2181: , p1_a2 JTF_DATE_TABLE
2182: , p1_a3 JTF_NUMBER_TABLE
2183: , p1_a4 JTF_NUMBER_TABLE
2184: , p1_a5 JTF_NUMBER_TABLE

Line 2181: , p1_a2 JTF_DATE_TABLE

2177: , p0_a94 VARCHAR2
2178: , p0_a95 VARCHAR2
2179: , p1_a0 JTF_NUMBER_TABLE
2180: , p1_a1 JTF_DATE_TABLE
2181: , p1_a2 JTF_DATE_TABLE
2182: , p1_a3 JTF_NUMBER_TABLE
2183: , p1_a4 JTF_NUMBER_TABLE
2184: , p1_a5 JTF_NUMBER_TABLE
2185: , p1_a6 JTF_NUMBER_TABLE

Line 2192: , p4_a1 out nocopy JTF_DATE_TABLE

2188: , p1_a9 JTF_VARCHAR2_TABLE_100
2189: , p_based_on_terms VARCHAR2
2190: , p_installment_number NUMBER
2191: , p4_a0 out nocopy JTF_NUMBER_TABLE
2192: , p4_a1 out nocopy JTF_DATE_TABLE
2193: , p4_a2 out nocopy JTF_DATE_TABLE
2194: , p4_a3 out nocopy JTF_DATE_TABLE
2195: , p4_a4 out nocopy JTF_NUMBER_TABLE
2196: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 2193: , p4_a2 out nocopy JTF_DATE_TABLE

2189: , p_based_on_terms VARCHAR2
2190: , p_installment_number NUMBER
2191: , p4_a0 out nocopy JTF_NUMBER_TABLE
2192: , p4_a1 out nocopy JTF_DATE_TABLE
2193: , p4_a2 out nocopy JTF_DATE_TABLE
2194: , p4_a3 out nocopy JTF_DATE_TABLE
2195: , p4_a4 out nocopy JTF_NUMBER_TABLE
2196: , p4_a5 out nocopy JTF_NUMBER_TABLE
2197: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 2194: , p4_a3 out nocopy JTF_DATE_TABLE

2190: , p_installment_number NUMBER
2191: , p4_a0 out nocopy JTF_NUMBER_TABLE
2192: , p4_a1 out nocopy JTF_DATE_TABLE
2193: , p4_a2 out nocopy JTF_DATE_TABLE
2194: , p4_a3 out nocopy JTF_DATE_TABLE
2195: , p4_a4 out nocopy JTF_NUMBER_TABLE
2196: , p4_a5 out nocopy JTF_NUMBER_TABLE
2197: , p4_a6 out nocopy JTF_NUMBER_TABLE
2198: , p4_a7 out nocopy JTF_NUMBER_TABLE

Line 2428: , p3_a1 out nocopy JTF_DATE_TABLE

2424: procedure amortizeloan(p_loan_id NUMBER
2425: , p_based_on_terms VARCHAR2
2426: , p_installment_number NUMBER
2427: , p3_a0 out nocopy JTF_NUMBER_TABLE
2428: , p3_a1 out nocopy JTF_DATE_TABLE
2429: , p3_a2 out nocopy JTF_DATE_TABLE
2430: , p3_a3 out nocopy JTF_DATE_TABLE
2431: , p3_a4 out nocopy JTF_NUMBER_TABLE
2432: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 2429: , p3_a2 out nocopy JTF_DATE_TABLE

2425: , p_based_on_terms VARCHAR2
2426: , p_installment_number NUMBER
2427: , p3_a0 out nocopy JTF_NUMBER_TABLE
2428: , p3_a1 out nocopy JTF_DATE_TABLE
2429: , p3_a2 out nocopy JTF_DATE_TABLE
2430: , p3_a3 out nocopy JTF_DATE_TABLE
2431: , p3_a4 out nocopy JTF_NUMBER_TABLE
2432: , p3_a5 out nocopy JTF_NUMBER_TABLE
2433: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 2430: , p3_a3 out nocopy JTF_DATE_TABLE

2426: , p_installment_number NUMBER
2427: , p3_a0 out nocopy JTF_NUMBER_TABLE
2428: , p3_a1 out nocopy JTF_DATE_TABLE
2429: , p3_a2 out nocopy JTF_DATE_TABLE
2430: , p3_a3 out nocopy JTF_DATE_TABLE
2431: , p3_a4 out nocopy JTF_NUMBER_TABLE
2432: , p3_a5 out nocopy JTF_NUMBER_TABLE
2433: , p3_a6 out nocopy JTF_NUMBER_TABLE
2434: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 2636: , p2_a1 JTF_DATE_TABLE

2632: , p0_a94 VARCHAR2
2633: , p0_a95 VARCHAR2
2634: , p_based_on_terms VARCHAR2
2635: , p2_a0 JTF_NUMBER_TABLE
2636: , p2_a1 JTF_DATE_TABLE
2637: , p2_a2 JTF_DATE_TABLE
2638: , p2_a3 JTF_NUMBER_TABLE
2639: , p2_a4 JTF_NUMBER_TABLE
2640: , p2_a5 JTF_NUMBER_TABLE

Line 2637: , p2_a2 JTF_DATE_TABLE

2633: , p0_a95 VARCHAR2
2634: , p_based_on_terms VARCHAR2
2635: , p2_a0 JTF_NUMBER_TABLE
2636: , p2_a1 JTF_DATE_TABLE
2637: , p2_a2 JTF_DATE_TABLE
2638: , p2_a3 JTF_NUMBER_TABLE
2639: , p2_a4 JTF_NUMBER_TABLE
2640: , p2_a5 JTF_NUMBER_TABLE
2641: , p2_a6 JTF_NUMBER_TABLE

Line 2646: , p3_a1 out nocopy JTF_DATE_TABLE

2642: , p2_a7 JTF_VARCHAR2_TABLE_100
2643: , p2_a8 JTF_VARCHAR2_TABLE_100
2644: , p2_a9 JTF_VARCHAR2_TABLE_100
2645: , p3_a0 out nocopy JTF_NUMBER_TABLE
2646: , p3_a1 out nocopy JTF_DATE_TABLE
2647: , p3_a2 out nocopy JTF_DATE_TABLE
2648: , p3_a3 out nocopy JTF_DATE_TABLE
2649: , p3_a4 out nocopy JTF_NUMBER_TABLE
2650: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 2647: , p3_a2 out nocopy JTF_DATE_TABLE

2643: , p2_a8 JTF_VARCHAR2_TABLE_100
2644: , p2_a9 JTF_VARCHAR2_TABLE_100
2645: , p3_a0 out nocopy JTF_NUMBER_TABLE
2646: , p3_a1 out nocopy JTF_DATE_TABLE
2647: , p3_a2 out nocopy JTF_DATE_TABLE
2648: , p3_a3 out nocopy JTF_DATE_TABLE
2649: , p3_a4 out nocopy JTF_NUMBER_TABLE
2650: , p3_a5 out nocopy JTF_NUMBER_TABLE
2651: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 2648: , p3_a3 out nocopy JTF_DATE_TABLE

2644: , p2_a9 JTF_VARCHAR2_TABLE_100
2645: , p3_a0 out nocopy JTF_NUMBER_TABLE
2646: , p3_a1 out nocopy JTF_DATE_TABLE
2647: , p3_a2 out nocopy JTF_DATE_TABLE
2648: , p3_a3 out nocopy JTF_DATE_TABLE
2649: , p3_a4 out nocopy JTF_NUMBER_TABLE
2650: , p3_a5 out nocopy JTF_NUMBER_TABLE
2651: , p3_a6 out nocopy JTF_NUMBER_TABLE
2652: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 2879: , p3_a1 out nocopy JTF_DATE_TABLE

2875: procedure runopenprojection(p_init_msg_list VARCHAR2
2876: , p_loan_id NUMBER
2877: , p_based_on_terms VARCHAR2
2878: , p3_a0 out nocopy JTF_NUMBER_TABLE
2879: , p3_a1 out nocopy JTF_DATE_TABLE
2880: , p3_a2 out nocopy JTF_DATE_TABLE
2881: , p3_a3 out nocopy JTF_DATE_TABLE
2882: , p3_a4 out nocopy JTF_NUMBER_TABLE
2883: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 2880: , p3_a2 out nocopy JTF_DATE_TABLE

2876: , p_loan_id NUMBER
2877: , p_based_on_terms VARCHAR2
2878: , p3_a0 out nocopy JTF_NUMBER_TABLE
2879: , p3_a1 out nocopy JTF_DATE_TABLE
2880: , p3_a2 out nocopy JTF_DATE_TABLE
2881: , p3_a3 out nocopy JTF_DATE_TABLE
2882: , p3_a4 out nocopy JTF_NUMBER_TABLE
2883: , p3_a5 out nocopy JTF_NUMBER_TABLE
2884: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 2881: , p3_a3 out nocopy JTF_DATE_TABLE

2877: , p_based_on_terms VARCHAR2
2878: , p3_a0 out nocopy JTF_NUMBER_TABLE
2879: , p3_a1 out nocopy JTF_DATE_TABLE
2880: , p3_a2 out nocopy JTF_DATE_TABLE
2881: , p3_a3 out nocopy JTF_DATE_TABLE
2882: , p3_a4 out nocopy JTF_NUMBER_TABLE
2883: , p3_a5 out nocopy JTF_NUMBER_TABLE
2884: , p3_a6 out nocopy JTF_NUMBER_TABLE
2885: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 3007: , p5_a1 out nocopy JTF_DATE_TABLE

3003: , p_commit VARCHAR2
3004: , p_loan_id NUMBER
3005: , p_based_on_terms VARCHAR2
3006: , p5_a0 out nocopy JTF_NUMBER_TABLE
3007: , p5_a1 out nocopy JTF_DATE_TABLE
3008: , p5_a2 out nocopy JTF_DATE_TABLE
3009: , p5_a3 out nocopy JTF_DATE_TABLE
3010: , p5_a4 out nocopy JTF_NUMBER_TABLE
3011: , p5_a5 out nocopy JTF_NUMBER_TABLE

Line 3008: , p5_a2 out nocopy JTF_DATE_TABLE

3004: , p_loan_id NUMBER
3005: , p_based_on_terms VARCHAR2
3006: , p5_a0 out nocopy JTF_NUMBER_TABLE
3007: , p5_a1 out nocopy JTF_DATE_TABLE
3008: , p5_a2 out nocopy JTF_DATE_TABLE
3009: , p5_a3 out nocopy JTF_DATE_TABLE
3010: , p5_a4 out nocopy JTF_NUMBER_TABLE
3011: , p5_a5 out nocopy JTF_NUMBER_TABLE
3012: , p5_a6 out nocopy JTF_NUMBER_TABLE

Line 3009: , p5_a3 out nocopy JTF_DATE_TABLE

3005: , p_based_on_terms VARCHAR2
3006: , p5_a0 out nocopy JTF_NUMBER_TABLE
3007: , p5_a1 out nocopy JTF_DATE_TABLE
3008: , p5_a2 out nocopy JTF_DATE_TABLE
3009: , p5_a3 out nocopy JTF_DATE_TABLE
3010: , p5_a4 out nocopy JTF_NUMBER_TABLE
3011: , p5_a5 out nocopy JTF_NUMBER_TABLE
3012: , p5_a6 out nocopy JTF_NUMBER_TABLE
3013: , p5_a7 out nocopy JTF_NUMBER_TABLE