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.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
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.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
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 181: , a1 out nocopy JTF_DATE_TABLE

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

Line 182: , a2 out nocopy JTF_DATE_TABLE

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
185: , a5 out nocopy JTF_NUMBER_TABLE
186: , a6 out nocopy JTF_NUMBER_TABLE

Line 183: , a3 out nocopy JTF_DATE_TABLE

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
185: , a5 out nocopy JTF_NUMBER_TABLE
186: , a6 out nocopy JTF_NUMBER_TABLE
187: , a7 out nocopy JTF_NUMBER_TABLE

Line 212: a1 := JTF_DATE_TABLE();

208: ddindx binary_integer; indx binary_integer;
209: begin
210: if t is null or t.count = 0 then
211: a0 := JTF_NUMBER_TABLE();
212: a1 := JTF_DATE_TABLE();
213: a2 := JTF_DATE_TABLE();
214: a3 := JTF_DATE_TABLE();
215: a4 := JTF_NUMBER_TABLE();
216: a5 := JTF_NUMBER_TABLE();

Line 213: a2 := JTF_DATE_TABLE();

209: begin
210: if t is null or t.count = 0 then
211: a0 := JTF_NUMBER_TABLE();
212: a1 := JTF_DATE_TABLE();
213: a2 := JTF_DATE_TABLE();
214: a3 := JTF_DATE_TABLE();
215: a4 := JTF_NUMBER_TABLE();
216: a5 := JTF_NUMBER_TABLE();
217: a6 := JTF_NUMBER_TABLE();

Line 214: a3 := JTF_DATE_TABLE();

210: if t is null or t.count = 0 then
211: a0 := JTF_NUMBER_TABLE();
212: a1 := JTF_DATE_TABLE();
213: a2 := JTF_DATE_TABLE();
214: a3 := JTF_DATE_TABLE();
215: a4 := JTF_NUMBER_TABLE();
216: a5 := JTF_NUMBER_TABLE();
217: a6 := JTF_NUMBER_TABLE();
218: a7 := JTF_NUMBER_TABLE();

Line 240: a1 := JTF_DATE_TABLE();

236: a25 := JTF_NUMBER_TABLE();
237: a26 := JTF_NUMBER_TABLE();
238: else
239: a0 := JTF_NUMBER_TABLE();
240: a1 := JTF_DATE_TABLE();
241: a2 := JTF_DATE_TABLE();
242: a3 := JTF_DATE_TABLE();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_NUMBER_TABLE();

Line 241: a2 := JTF_DATE_TABLE();

237: a26 := JTF_NUMBER_TABLE();
238: else
239: a0 := JTF_NUMBER_TABLE();
240: a1 := JTF_DATE_TABLE();
241: a2 := JTF_DATE_TABLE();
242: a3 := JTF_DATE_TABLE();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_NUMBER_TABLE();
245: a6 := JTF_NUMBER_TABLE();

Line 242: a3 := JTF_DATE_TABLE();

238: else
239: a0 := JTF_NUMBER_TABLE();
240: a1 := JTF_DATE_TABLE();
241: a2 := JTF_DATE_TABLE();
242: a3 := JTF_DATE_TABLE();
243: a4 := JTF_NUMBER_TABLE();
244: a5 := JTF_NUMBER_TABLE();
245: a6 := JTF_NUMBER_TABLE();
246: a7 := JTF_NUMBER_TABLE();

Line 343: , a9 JTF_DATE_TABLE

339: , a5 JTF_NUMBER_TABLE
340: , a6 JTF_NUMBER_TABLE
341: , a7 JTF_NUMBER_TABLE
342: , a8 JTF_NUMBER_TABLE
343: , a9 JTF_DATE_TABLE
344: ) as
345: ddindx binary_integer; indx binary_integer;
346: begin
347: if a0 is not null and a0.count > 0 then

Line 380: , a9 out nocopy JTF_DATE_TABLE

376: , a5 out nocopy JTF_NUMBER_TABLE
377: , a6 out nocopy JTF_NUMBER_TABLE
378: , a7 out nocopy JTF_NUMBER_TABLE
379: , a8 out nocopy JTF_NUMBER_TABLE
380: , a9 out nocopy JTF_DATE_TABLE
381: ) as
382: ddindx binary_integer; indx binary_integer;
383: begin
384: if t is null or t.count = 0 then

Line 394: a9 := JTF_DATE_TABLE();

390: a5 := JTF_NUMBER_TABLE();
391: a6 := JTF_NUMBER_TABLE();
392: a7 := JTF_NUMBER_TABLE();
393: a8 := JTF_NUMBER_TABLE();
394: a9 := JTF_DATE_TABLE();
395: else
396: a0 := JTF_NUMBER_TABLE();
397: a1 := JTF_NUMBER_TABLE();
398: a2 := JTF_NUMBER_TABLE();

Line 405: a9 := JTF_DATE_TABLE();

401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_NUMBER_TABLE();
403: a7 := JTF_NUMBER_TABLE();
404: a8 := JTF_NUMBER_TABLE();
405: a9 := JTF_DATE_TABLE();
406: if t.count > 0 then
407: a0.extend(t.count);
408: a1.extend(t.count);
409: a2.extend(t.count);

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 537: a0 := JTF_DATE_TABLE();

533: ) as
534: ddindx binary_integer; indx binary_integer;
535: begin
536: if t is null or t.count = 0 then
537: a0 := JTF_DATE_TABLE();
538: a1 := JTF_NUMBER_TABLE();
539: a2 := JTF_NUMBER_TABLE();
540: a3 := JTF_NUMBER_TABLE();
541: else

Line 542: a0 := JTF_DATE_TABLE();

538: a1 := JTF_NUMBER_TABLE();
539: a2 := JTF_NUMBER_TABLE();
540: a3 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_DATE_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
545: a3 := JTF_NUMBER_TABLE();
546: if t.count > 0 then

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 569: , a1 JTF_DATE_TABLE

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
573: if a0 is not null and a0.count > 0 then

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 590: , a1 out nocopy JTF_DATE_TABLE

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
594: if t is null or t.count = 0 then

Line 595: a0 := JTF_DATE_TABLE();

591: ) as
592: ddindx binary_integer; indx binary_integer;
593: begin
594: if t is null or t.count = 0 then
595: a0 := JTF_DATE_TABLE();
596: a1 := JTF_DATE_TABLE();
597: else
598: a0 := JTF_DATE_TABLE();
599: a1 := JTF_DATE_TABLE();

Line 596: a1 := JTF_DATE_TABLE();

592: ddindx binary_integer; indx binary_integer;
593: begin
594: if t is null or t.count = 0 then
595: a0 := JTF_DATE_TABLE();
596: a1 := JTF_DATE_TABLE();
597: else
598: a0 := JTF_DATE_TABLE();
599: a1 := JTF_DATE_TABLE();
600: if t.count > 0 then

Line 598: a0 := JTF_DATE_TABLE();

594: if t is null or t.count = 0 then
595: a0 := JTF_DATE_TABLE();
596: a1 := JTF_DATE_TABLE();
597: else
598: a0 := JTF_DATE_TABLE();
599: a1 := JTF_DATE_TABLE();
600: if t.count > 0 then
601: a0.extend(t.count);
602: a1.extend(t.count);

Line 599: a1 := JTF_DATE_TABLE();

595: a0 := JTF_DATE_TABLE();
596: a1 := JTF_DATE_TABLE();
597: else
598: a0 := JTF_DATE_TABLE();
599: a1 := JTF_DATE_TABLE();
600: if t.count > 0 then
601: a0.extend(t.count);
602: a1.extend(t.count);
603: ddindx := t.first;

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 640: a0 := JTF_DATE_TABLE();

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();
641: else
642: a0 := JTF_DATE_TABLE();
643: if t.count > 0 then
644: a0.extend(t.count);

Line 642: a0 := JTF_DATE_TABLE();

638: begin
639: if t is null or t.count = 0 then
640: a0 := JTF_DATE_TABLE();
641: else
642: a0 := JTF_DATE_TABLE();
643: if t.count > 0 then
644: a0.extend(t.count);
645: ddindx := t.first;
646: indx := 1;

Line 1441: , p3_a1 JTF_DATE_TABLE

1437: , p0_a88 NUMBER
1438: , p_start_date DATE
1439: , p_end_date DATE
1440: , p3_a0 JTF_NUMBER_TABLE
1441: , p3_a1 JTF_DATE_TABLE
1442: , p3_a2 JTF_DATE_TABLE
1443: , p3_a3 JTF_NUMBER_TABLE
1444: , p3_a4 JTF_NUMBER_TABLE
1445: , p3_a5 JTF_NUMBER_TABLE

Line 1442: , p3_a2 JTF_DATE_TABLE

1438: , p_start_date DATE
1439: , p_end_date DATE
1440: , p3_a0 JTF_NUMBER_TABLE
1441: , p3_a1 JTF_DATE_TABLE
1442: , p3_a2 JTF_DATE_TABLE
1443: , p3_a3 JTF_NUMBER_TABLE
1444: , p3_a4 JTF_NUMBER_TABLE
1445: , p3_a5 JTF_NUMBER_TABLE
1446: , p3_a6 JTF_NUMBER_TABLE

Line 1678: , p1_a1 JTF_DATE_TABLE

1674: , p0_a86 NUMBER
1675: , p0_a87 NUMBER
1676: , p0_a88 NUMBER
1677: , p1_a0 JTF_NUMBER_TABLE
1678: , p1_a1 JTF_DATE_TABLE
1679: , p1_a2 JTF_DATE_TABLE
1680: , p1_a3 JTF_NUMBER_TABLE
1681: , p1_a4 JTF_NUMBER_TABLE
1682: , p1_a5 JTF_NUMBER_TABLE

Line 1679: , p1_a2 JTF_DATE_TABLE

1675: , p0_a87 NUMBER
1676: , p0_a88 NUMBER
1677: , p1_a0 JTF_NUMBER_TABLE
1678: , p1_a1 JTF_DATE_TABLE
1679: , p1_a2 JTF_DATE_TABLE
1680: , p1_a3 JTF_NUMBER_TABLE
1681: , p1_a4 JTF_NUMBER_TABLE
1682: , p1_a5 JTF_NUMBER_TABLE
1683: , p1_a6 JTF_NUMBER_TABLE

Line 1690: , p4_a1 out nocopy JTF_DATE_TABLE

1686: , p1_a9 JTF_VARCHAR2_TABLE_100
1687: , p_based_on_terms VARCHAR2
1688: , p_installment_number NUMBER
1689: , p4_a0 out nocopy JTF_NUMBER_TABLE
1690: , p4_a1 out nocopy JTF_DATE_TABLE
1691: , p4_a2 out nocopy JTF_DATE_TABLE
1692: , p4_a3 out nocopy JTF_DATE_TABLE
1693: , p4_a4 out nocopy JTF_NUMBER_TABLE
1694: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 1691: , p4_a2 out nocopy JTF_DATE_TABLE

1687: , p_based_on_terms VARCHAR2
1688: , p_installment_number NUMBER
1689: , p4_a0 out nocopy JTF_NUMBER_TABLE
1690: , p4_a1 out nocopy JTF_DATE_TABLE
1691: , p4_a2 out nocopy JTF_DATE_TABLE
1692: , p4_a3 out nocopy JTF_DATE_TABLE
1693: , p4_a4 out nocopy JTF_NUMBER_TABLE
1694: , p4_a5 out nocopy JTF_NUMBER_TABLE
1695: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 1692: , p4_a3 out nocopy JTF_DATE_TABLE

1688: , p_installment_number NUMBER
1689: , p4_a0 out nocopy JTF_NUMBER_TABLE
1690: , p4_a1 out nocopy JTF_DATE_TABLE
1691: , p4_a2 out nocopy JTF_DATE_TABLE
1692: , p4_a3 out nocopy JTF_DATE_TABLE
1693: , p4_a4 out nocopy JTF_NUMBER_TABLE
1694: , p4_a5 out nocopy JTF_NUMBER_TABLE
1695: , p4_a6 out nocopy JTF_NUMBER_TABLE
1696: , p4_a7 out nocopy JTF_NUMBER_TABLE

Line 1973: , p1_a1 JTF_DATE_TABLE

1969: , p0_a86 NUMBER
1970: , p0_a87 NUMBER
1971: , p0_a88 NUMBER
1972: , p1_a0 JTF_NUMBER_TABLE
1973: , p1_a1 JTF_DATE_TABLE
1974: , p1_a2 JTF_DATE_TABLE
1975: , p1_a3 JTF_NUMBER_TABLE
1976: , p1_a4 JTF_NUMBER_TABLE
1977: , p1_a5 JTF_NUMBER_TABLE

Line 1974: , p1_a2 JTF_DATE_TABLE

1970: , p0_a87 NUMBER
1971: , p0_a88 NUMBER
1972: , p1_a0 JTF_NUMBER_TABLE
1973: , p1_a1 JTF_DATE_TABLE
1974: , p1_a2 JTF_DATE_TABLE
1975: , p1_a3 JTF_NUMBER_TABLE
1976: , p1_a4 JTF_NUMBER_TABLE
1977: , p1_a5 JTF_NUMBER_TABLE
1978: , p1_a6 JTF_NUMBER_TABLE

Line 1985: , p4_a1 out nocopy JTF_DATE_TABLE

1981: , p1_a9 JTF_VARCHAR2_TABLE_100
1982: , p_based_on_terms VARCHAR2
1983: , p_installment_number NUMBER
1984: , p4_a0 out nocopy JTF_NUMBER_TABLE
1985: , p4_a1 out nocopy JTF_DATE_TABLE
1986: , p4_a2 out nocopy JTF_DATE_TABLE
1987: , p4_a3 out nocopy JTF_DATE_TABLE
1988: , p4_a4 out nocopy JTF_NUMBER_TABLE
1989: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 1986: , p4_a2 out nocopy JTF_DATE_TABLE

1982: , p_based_on_terms VARCHAR2
1983: , p_installment_number NUMBER
1984: , p4_a0 out nocopy JTF_NUMBER_TABLE
1985: , p4_a1 out nocopy JTF_DATE_TABLE
1986: , p4_a2 out nocopy JTF_DATE_TABLE
1987: , p4_a3 out nocopy JTF_DATE_TABLE
1988: , p4_a4 out nocopy JTF_NUMBER_TABLE
1989: , p4_a5 out nocopy JTF_NUMBER_TABLE
1990: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 1987: , p4_a3 out nocopy JTF_DATE_TABLE

1983: , p_installment_number NUMBER
1984: , p4_a0 out nocopy JTF_NUMBER_TABLE
1985: , p4_a1 out nocopy JTF_DATE_TABLE
1986: , p4_a2 out nocopy JTF_DATE_TABLE
1987: , p4_a3 out nocopy JTF_DATE_TABLE
1988: , p4_a4 out nocopy JTF_NUMBER_TABLE
1989: , p4_a5 out nocopy JTF_NUMBER_TABLE
1990: , p4_a6 out nocopy JTF_NUMBER_TABLE
1991: , p4_a7 out nocopy JTF_NUMBER_TABLE

Line 2182: , p3_a1 out nocopy JTF_DATE_TABLE

2178: procedure amortizeloan(p_loan_id NUMBER
2179: , p_based_on_terms VARCHAR2
2180: , p_installment_number NUMBER
2181: , p3_a0 out nocopy JTF_NUMBER_TABLE
2182: , p3_a1 out nocopy JTF_DATE_TABLE
2183: , p3_a2 out nocopy JTF_DATE_TABLE
2184: , p3_a3 out nocopy JTF_DATE_TABLE
2185: , p3_a4 out nocopy JTF_NUMBER_TABLE
2186: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 2183: , p3_a2 out nocopy JTF_DATE_TABLE

2179: , p_based_on_terms VARCHAR2
2180: , p_installment_number NUMBER
2181: , p3_a0 out nocopy JTF_NUMBER_TABLE
2182: , p3_a1 out nocopy JTF_DATE_TABLE
2183: , p3_a2 out nocopy JTF_DATE_TABLE
2184: , p3_a3 out nocopy JTF_DATE_TABLE
2185: , p3_a4 out nocopy JTF_NUMBER_TABLE
2186: , p3_a5 out nocopy JTF_NUMBER_TABLE
2187: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 2184: , p3_a3 out nocopy JTF_DATE_TABLE

2180: , p_installment_number NUMBER
2181: , p3_a0 out nocopy JTF_NUMBER_TABLE
2182: , p3_a1 out nocopy JTF_DATE_TABLE
2183: , p3_a2 out nocopy JTF_DATE_TABLE
2184: , p3_a3 out nocopy JTF_DATE_TABLE
2185: , p3_a4 out nocopy JTF_NUMBER_TABLE
2186: , p3_a5 out nocopy JTF_NUMBER_TABLE
2187: , p3_a6 out nocopy JTF_NUMBER_TABLE
2188: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 2350: , p1_a1 JTF_DATE_TABLE

2346: , p0_a86 NUMBER
2347: , p0_a87 NUMBER
2348: , p0_a88 NUMBER
2349: , p1_a0 JTF_NUMBER_TABLE
2350: , p1_a1 JTF_DATE_TABLE
2351: , p1_a2 JTF_DATE_TABLE
2352: , p1_a3 JTF_NUMBER_TABLE
2353: , p1_a4 JTF_NUMBER_TABLE
2354: , p1_a5 JTF_NUMBER_TABLE

Line 2351: , p1_a2 JTF_DATE_TABLE

2347: , p0_a87 NUMBER
2348: , p0_a88 NUMBER
2349: , p1_a0 JTF_NUMBER_TABLE
2350: , p1_a1 JTF_DATE_TABLE
2351: , p1_a2 JTF_DATE_TABLE
2352: , p1_a3 JTF_NUMBER_TABLE
2353: , p1_a4 JTF_NUMBER_TABLE
2354: , p1_a5 JTF_NUMBER_TABLE
2355: , p1_a6 JTF_NUMBER_TABLE

Line 2360: , p2_a1 out nocopy JTF_DATE_TABLE

2356: , p1_a7 JTF_VARCHAR2_TABLE_100
2357: , p1_a8 JTF_VARCHAR2_TABLE_100
2358: , p1_a9 JTF_VARCHAR2_TABLE_100
2359: , p2_a0 out nocopy JTF_NUMBER_TABLE
2360: , p2_a1 out nocopy JTF_DATE_TABLE
2361: , p2_a2 out nocopy JTF_DATE_TABLE
2362: , p2_a3 out nocopy JTF_DATE_TABLE
2363: , p2_a4 out nocopy JTF_NUMBER_TABLE
2364: , p2_a5 out nocopy JTF_NUMBER_TABLE

Line 2361: , p2_a2 out nocopy JTF_DATE_TABLE

2357: , p1_a8 JTF_VARCHAR2_TABLE_100
2358: , p1_a9 JTF_VARCHAR2_TABLE_100
2359: , p2_a0 out nocopy JTF_NUMBER_TABLE
2360: , p2_a1 out nocopy JTF_DATE_TABLE
2361: , p2_a2 out nocopy JTF_DATE_TABLE
2362: , p2_a3 out nocopy JTF_DATE_TABLE
2363: , p2_a4 out nocopy JTF_NUMBER_TABLE
2364: , p2_a5 out nocopy JTF_NUMBER_TABLE
2365: , p2_a6 out nocopy JTF_NUMBER_TABLE

Line 2362: , p2_a3 out nocopy JTF_DATE_TABLE

2358: , p1_a9 JTF_VARCHAR2_TABLE_100
2359: , p2_a0 out nocopy JTF_NUMBER_TABLE
2360: , p2_a1 out nocopy JTF_DATE_TABLE
2361: , p2_a2 out nocopy JTF_DATE_TABLE
2362: , p2_a3 out nocopy JTF_DATE_TABLE
2363: , p2_a4 out nocopy JTF_NUMBER_TABLE
2364: , p2_a5 out nocopy JTF_NUMBER_TABLE
2365: , p2_a6 out nocopy JTF_NUMBER_TABLE
2366: , p2_a7 out nocopy JTF_NUMBER_TABLE

Line 2551: , p3_a1 out nocopy JTF_DATE_TABLE

2547: procedure runopenprojection(p_init_msg_list VARCHAR2
2548: , p_loan_id NUMBER
2549: , p_based_on_terms VARCHAR2
2550: , p3_a0 out nocopy JTF_NUMBER_TABLE
2551: , p3_a1 out nocopy JTF_DATE_TABLE
2552: , p3_a2 out nocopy JTF_DATE_TABLE
2553: , p3_a3 out nocopy JTF_DATE_TABLE
2554: , p3_a4 out nocopy JTF_NUMBER_TABLE
2555: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 2552: , p3_a2 out nocopy JTF_DATE_TABLE

2548: , p_loan_id NUMBER
2549: , p_based_on_terms VARCHAR2
2550: , p3_a0 out nocopy JTF_NUMBER_TABLE
2551: , p3_a1 out nocopy JTF_DATE_TABLE
2552: , p3_a2 out nocopy JTF_DATE_TABLE
2553: , p3_a3 out nocopy JTF_DATE_TABLE
2554: , p3_a4 out nocopy JTF_NUMBER_TABLE
2555: , p3_a5 out nocopy JTF_NUMBER_TABLE
2556: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 2553: , p3_a3 out nocopy JTF_DATE_TABLE

2549: , p_based_on_terms VARCHAR2
2550: , p3_a0 out nocopy JTF_NUMBER_TABLE
2551: , p3_a1 out nocopy JTF_DATE_TABLE
2552: , p3_a2 out nocopy JTF_DATE_TABLE
2553: , p3_a3 out nocopy JTF_DATE_TABLE
2554: , p3_a4 out nocopy JTF_NUMBER_TABLE
2555: , p3_a5 out nocopy JTF_NUMBER_TABLE
2556: , p3_a6 out nocopy JTF_NUMBER_TABLE
2557: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 2647: , p5_a1 out nocopy JTF_DATE_TABLE

2643: , p_commit VARCHAR2
2644: , p_loan_id NUMBER
2645: , p_based_on_terms VARCHAR2
2646: , p5_a0 out nocopy JTF_NUMBER_TABLE
2647: , p5_a1 out nocopy JTF_DATE_TABLE
2648: , p5_a2 out nocopy JTF_DATE_TABLE
2649: , p5_a3 out nocopy JTF_DATE_TABLE
2650: , p5_a4 out nocopy JTF_NUMBER_TABLE
2651: , p5_a5 out nocopy JTF_NUMBER_TABLE

Line 2648: , p5_a2 out nocopy JTF_DATE_TABLE

2644: , p_loan_id NUMBER
2645: , p_based_on_terms VARCHAR2
2646: , p5_a0 out nocopy JTF_NUMBER_TABLE
2647: , p5_a1 out nocopy JTF_DATE_TABLE
2648: , p5_a2 out nocopy JTF_DATE_TABLE
2649: , p5_a3 out nocopy JTF_DATE_TABLE
2650: , p5_a4 out nocopy JTF_NUMBER_TABLE
2651: , p5_a5 out nocopy JTF_NUMBER_TABLE
2652: , p5_a6 out nocopy JTF_NUMBER_TABLE

Line 2649: , p5_a3 out nocopy JTF_DATE_TABLE

2645: , p_based_on_terms VARCHAR2
2646: , p5_a0 out nocopy JTF_NUMBER_TABLE
2647: , p5_a1 out nocopy JTF_DATE_TABLE
2648: , p5_a2 out nocopy JTF_DATE_TABLE
2649: , p5_a3 out nocopy JTF_DATE_TABLE
2650: , p5_a4 out nocopy JTF_NUMBER_TABLE
2651: , p5_a5 out nocopy JTF_NUMBER_TABLE
2652: , p5_a6 out nocopy JTF_NUMBER_TABLE
2653: , p5_a7 out nocopy JTF_NUMBER_TABLE