DBA Data[Home] [Help]

APPS.LNS_PAYOFF_PUB_W dependencies on JTF_DATE_TABLE

Line 9: , a6 JTF_DATE_TABLE

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_DATE_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as

Line 11: , a8 JTF_DATE_TABLE

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;

Line 48: , a6 out nocopy JTF_DATE_TABLE

44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_DATE_TABLE
49: , a7 out nocopy JTF_DATE_TABLE
50: , a8 out nocopy JTF_DATE_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , a7 out nocopy JTF_DATE_TABLE

45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_DATE_TABLE
49: , a7 out nocopy JTF_DATE_TABLE
50: , a8 out nocopy JTF_DATE_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as

Line 50: , a8 out nocopy JTF_DATE_TABLE

46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_DATE_TABLE
49: , a7 out nocopy JTF_DATE_TABLE
50: , a8 out nocopy JTF_DATE_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;

Line 63: a6 := JTF_DATE_TABLE();

59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_DATE_TABLE();
64: a7 := JTF_DATE_TABLE();
65: a8 := JTF_DATE_TABLE();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();

Line 64: a7 := JTF_DATE_TABLE();

60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_DATE_TABLE();
64: a7 := JTF_DATE_TABLE();
65: a8 := JTF_DATE_TABLE();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else

Line 65: a8 := JTF_DATE_TABLE();

61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_DATE_TABLE();
64: a7 := JTF_DATE_TABLE();
65: a8 := JTF_DATE_TABLE();
66: a9 := JTF_VARCHAR2_TABLE_100();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();

Line 75: a6 := JTF_DATE_TABLE();

71: a2 := JTF_VARCHAR2_TABLE_100();
72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_DATE_TABLE();
76: a7 := JTF_DATE_TABLE();
77: a8 := JTF_DATE_TABLE();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := JTF_VARCHAR2_TABLE_100();

Line 76: a7 := JTF_DATE_TABLE();

72: a3 := JTF_NUMBER_TABLE();
73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_DATE_TABLE();
76: a7 := JTF_DATE_TABLE();
77: a8 := JTF_DATE_TABLE();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then

Line 77: a8 := JTF_DATE_TABLE();

73: a4 := JTF_VARCHAR2_TABLE_100();
74: a5 := JTF_NUMBER_TABLE();
75: a6 := JTF_DATE_TABLE();
76: a7 := JTF_DATE_TABLE();
77: a8 := JTF_DATE_TABLE();
78: a9 := JTF_VARCHAR2_TABLE_100();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);

Line 120: , a4 JTF_DATE_TABLE

116: procedure rosetta_table_copy_in_p3(t out nocopy lns_payoff_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_VARCHAR2_TABLE_100
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_DATE_TABLE
121: , a5 JTF_VARCHAR2_TABLE_100
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_VARCHAR2_TABLE_100
124: ) as

Line 153: , a4 out nocopy JTF_DATE_TABLE

149: procedure rosetta_table_copy_out_p3(t lns_payoff_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
150: , a1 out nocopy JTF_NUMBER_TABLE
151: , a2 out nocopy JTF_VARCHAR2_TABLE_100
152: , a3 out nocopy JTF_NUMBER_TABLE
153: , a4 out nocopy JTF_DATE_TABLE
154: , a5 out nocopy JTF_VARCHAR2_TABLE_100
155: , a6 out nocopy JTF_VARCHAR2_TABLE_100
156: , a7 out nocopy JTF_VARCHAR2_TABLE_100
157: ) as

Line 165: a4 := JTF_DATE_TABLE();

161: a0 := JTF_NUMBER_TABLE();
162: a1 := JTF_NUMBER_TABLE();
163: a2 := JTF_VARCHAR2_TABLE_100();
164: a3 := JTF_NUMBER_TABLE();
165: a4 := JTF_DATE_TABLE();
166: a5 := JTF_VARCHAR2_TABLE_100();
167: a6 := JTF_VARCHAR2_TABLE_100();
168: a7 := JTF_VARCHAR2_TABLE_100();
169: else

Line 174: a4 := JTF_DATE_TABLE();

170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_VARCHAR2_TABLE_100();
173: a3 := JTF_NUMBER_TABLE();
174: a4 := JTF_DATE_TABLE();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_VARCHAR2_TABLE_100();
178: if t.count > 0 then

Line 210: , a2 JTF_DATE_TABLE

206: end rosetta_table_copy_out_p3;
207:
208: procedure rosetta_table_copy_in_p5(t out nocopy lns_payoff_pub.loan_cancel_details_tbl, a0 JTF_NUMBER_TABLE
209: , a1 JTF_NUMBER_TABLE
210: , a2 JTF_DATE_TABLE
211: , a3 JTF_DATE_TABLE
212: , a4 JTF_DATE_TABLE
213: , a5 JTF_VARCHAR2_TABLE_100
214: , a6 JTF_VARCHAR2_TABLE_100

Line 211: , a3 JTF_DATE_TABLE

207:
208: procedure rosetta_table_copy_in_p5(t out nocopy lns_payoff_pub.loan_cancel_details_tbl, a0 JTF_NUMBER_TABLE
209: , a1 JTF_NUMBER_TABLE
210: , a2 JTF_DATE_TABLE
211: , a3 JTF_DATE_TABLE
212: , a4 JTF_DATE_TABLE
213: , a5 JTF_VARCHAR2_TABLE_100
214: , a6 JTF_VARCHAR2_TABLE_100
215: , a7 JTF_VARCHAR2_TABLE_100

Line 212: , a4 JTF_DATE_TABLE

208: procedure rosetta_table_copy_in_p5(t out nocopy lns_payoff_pub.loan_cancel_details_tbl, a0 JTF_NUMBER_TABLE
209: , a1 JTF_NUMBER_TABLE
210: , a2 JTF_DATE_TABLE
211: , a3 JTF_DATE_TABLE
212: , a4 JTF_DATE_TABLE
213: , a5 JTF_VARCHAR2_TABLE_100
214: , a6 JTF_VARCHAR2_TABLE_100
215: , a7 JTF_VARCHAR2_TABLE_100
216: , a8 JTF_NUMBER_TABLE

Line 261: , a2 out nocopy JTF_DATE_TABLE

257: end if;
258: end rosetta_table_copy_in_p5;
259: procedure rosetta_table_copy_out_p5(t lns_payoff_pub.loan_cancel_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
260: , a1 out nocopy JTF_NUMBER_TABLE
261: , a2 out nocopy JTF_DATE_TABLE
262: , a3 out nocopy JTF_DATE_TABLE
263: , a4 out nocopy JTF_DATE_TABLE
264: , a5 out nocopy JTF_VARCHAR2_TABLE_100
265: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 262: , a3 out nocopy JTF_DATE_TABLE

258: end rosetta_table_copy_in_p5;
259: procedure rosetta_table_copy_out_p5(t lns_payoff_pub.loan_cancel_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
260: , a1 out nocopy JTF_NUMBER_TABLE
261: , a2 out nocopy JTF_DATE_TABLE
262: , a3 out nocopy JTF_DATE_TABLE
263: , a4 out nocopy JTF_DATE_TABLE
264: , a5 out nocopy JTF_VARCHAR2_TABLE_100
265: , a6 out nocopy JTF_VARCHAR2_TABLE_100
266: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 263: , a4 out nocopy JTF_DATE_TABLE

259: procedure rosetta_table_copy_out_p5(t lns_payoff_pub.loan_cancel_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
260: , a1 out nocopy JTF_NUMBER_TABLE
261: , a2 out nocopy JTF_DATE_TABLE
262: , a3 out nocopy JTF_DATE_TABLE
263: , a4 out nocopy JTF_DATE_TABLE
264: , a5 out nocopy JTF_VARCHAR2_TABLE_100
265: , a6 out nocopy JTF_VARCHAR2_TABLE_100
266: , a7 out nocopy JTF_VARCHAR2_TABLE_100
267: , a8 out nocopy JTF_NUMBER_TABLE

Line 282: a2 := JTF_DATE_TABLE();

278: begin
279: if t is null or t.count = 0 then
280: a0 := JTF_NUMBER_TABLE();
281: a1 := JTF_NUMBER_TABLE();
282: a2 := JTF_DATE_TABLE();
283: a3 := JTF_DATE_TABLE();
284: a4 := JTF_DATE_TABLE();
285: a5 := JTF_VARCHAR2_TABLE_100();
286: a6 := JTF_VARCHAR2_TABLE_100();

Line 283: a3 := JTF_DATE_TABLE();

279: if t is null or t.count = 0 then
280: a0 := JTF_NUMBER_TABLE();
281: a1 := JTF_NUMBER_TABLE();
282: a2 := JTF_DATE_TABLE();
283: a3 := JTF_DATE_TABLE();
284: a4 := JTF_DATE_TABLE();
285: a5 := JTF_VARCHAR2_TABLE_100();
286: a6 := JTF_VARCHAR2_TABLE_100();
287: a7 := JTF_VARCHAR2_TABLE_100();

Line 284: a4 := JTF_DATE_TABLE();

280: a0 := JTF_NUMBER_TABLE();
281: a1 := JTF_NUMBER_TABLE();
282: a2 := JTF_DATE_TABLE();
283: a3 := JTF_DATE_TABLE();
284: a4 := JTF_DATE_TABLE();
285: a5 := JTF_VARCHAR2_TABLE_100();
286: a6 := JTF_VARCHAR2_TABLE_100();
287: a7 := JTF_VARCHAR2_TABLE_100();
288: a8 := JTF_NUMBER_TABLE();

Line 300: a2 := JTF_DATE_TABLE();

296: a16 := JTF_NUMBER_TABLE();
297: else
298: a0 := JTF_NUMBER_TABLE();
299: a1 := JTF_NUMBER_TABLE();
300: a2 := JTF_DATE_TABLE();
301: a3 := JTF_DATE_TABLE();
302: a4 := JTF_DATE_TABLE();
303: a5 := JTF_VARCHAR2_TABLE_100();
304: a6 := JTF_VARCHAR2_TABLE_100();

Line 301: a3 := JTF_DATE_TABLE();

297: else
298: a0 := JTF_NUMBER_TABLE();
299: a1 := JTF_NUMBER_TABLE();
300: a2 := JTF_DATE_TABLE();
301: a3 := JTF_DATE_TABLE();
302: a4 := JTF_DATE_TABLE();
303: a5 := JTF_VARCHAR2_TABLE_100();
304: a6 := JTF_VARCHAR2_TABLE_100();
305: a7 := JTF_VARCHAR2_TABLE_100();

Line 302: a4 := JTF_DATE_TABLE();

298: a0 := JTF_NUMBER_TABLE();
299: a1 := JTF_NUMBER_TABLE();
300: a2 := JTF_DATE_TABLE();
301: a3 := JTF_DATE_TABLE();
302: a4 := JTF_DATE_TABLE();
303: a5 := JTF_VARCHAR2_TABLE_100();
304: a6 := JTF_VARCHAR2_TABLE_100();
305: a7 := JTF_VARCHAR2_TABLE_100();
306: a8 := JTF_NUMBER_TABLE();

Line 371: , p4_a4 JTF_DATE_TABLE

367: , p4_a0 JTF_NUMBER_TABLE
368: , p4_a1 JTF_NUMBER_TABLE
369: , p4_a2 JTF_VARCHAR2_TABLE_100
370: , p4_a3 JTF_NUMBER_TABLE
371: , p4_a4 JTF_DATE_TABLE
372: , p4_a5 JTF_VARCHAR2_TABLE_100
373: , p4_a6 JTF_VARCHAR2_TABLE_100
374: , p4_a7 JTF_VARCHAR2_TABLE_100
375: , x_return_status out nocopy VARCHAR2

Line 433: , p4_a6 out nocopy JTF_DATE_TABLE

429: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
430: , p4_a3 out nocopy JTF_NUMBER_TABLE
431: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a5 out nocopy JTF_NUMBER_TABLE
433: , p4_a6 out nocopy JTF_DATE_TABLE
434: , p4_a7 out nocopy JTF_DATE_TABLE
435: , p4_a8 out nocopy JTF_DATE_TABLE
436: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
437: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 434: , p4_a7 out nocopy JTF_DATE_TABLE

430: , p4_a3 out nocopy JTF_NUMBER_TABLE
431: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a5 out nocopy JTF_NUMBER_TABLE
433: , p4_a6 out nocopy JTF_DATE_TABLE
434: , p4_a7 out nocopy JTF_DATE_TABLE
435: , p4_a8 out nocopy JTF_DATE_TABLE
436: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
437: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
438: , x_return_status out nocopy VARCHAR2

Line 435: , p4_a8 out nocopy JTF_DATE_TABLE

431: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
432: , p4_a5 out nocopy JTF_NUMBER_TABLE
433: , p4_a6 out nocopy JTF_DATE_TABLE
434: , p4_a7 out nocopy JTF_DATE_TABLE
435: , p4_a8 out nocopy JTF_DATE_TABLE
436: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
437: , p4_a10 out nocopy JTF_VARCHAR2_TABLE_100
438: , x_return_status out nocopy VARCHAR2
439: , x_msg_count out nocopy NUMBER

Line 495: , p4_a2 out nocopy JTF_DATE_TABLE

491: , p_loan_id NUMBER
492: , p_cancellation_date DATE
493: , p4_a0 out nocopy JTF_NUMBER_TABLE
494: , p4_a1 out nocopy JTF_NUMBER_TABLE
495: , p4_a2 out nocopy JTF_DATE_TABLE
496: , p4_a3 out nocopy JTF_DATE_TABLE
497: , p4_a4 out nocopy JTF_DATE_TABLE
498: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
499: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 496: , p4_a3 out nocopy JTF_DATE_TABLE

492: , p_cancellation_date DATE
493: , p4_a0 out nocopy JTF_NUMBER_TABLE
494: , p4_a1 out nocopy JTF_NUMBER_TABLE
495: , p4_a2 out nocopy JTF_DATE_TABLE
496: , p4_a3 out nocopy JTF_DATE_TABLE
497: , p4_a4 out nocopy JTF_DATE_TABLE
498: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
499: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
500: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 497: , p4_a4 out nocopy JTF_DATE_TABLE

493: , p4_a0 out nocopy JTF_NUMBER_TABLE
494: , p4_a1 out nocopy JTF_NUMBER_TABLE
495: , p4_a2 out nocopy JTF_DATE_TABLE
496: , p4_a3 out nocopy JTF_DATE_TABLE
497: , p4_a4 out nocopy JTF_DATE_TABLE
498: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
499: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
500: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
501: , p4_a8 out nocopy JTF_NUMBER_TABLE

Line 579: , p10_a2 in out nocopy JTF_DATE_TABLE

575: , p_action VARCHAR2
576: , p_loan_cancellation_id in out nocopy NUMBER
577: , p10_a0 in out nocopy JTF_NUMBER_TABLE
578: , p10_a1 in out nocopy JTF_NUMBER_TABLE
579: , p10_a2 in out nocopy JTF_DATE_TABLE
580: , p10_a3 in out nocopy JTF_DATE_TABLE
581: , p10_a4 in out nocopy JTF_DATE_TABLE
582: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 580: , p10_a3 in out nocopy JTF_DATE_TABLE

576: , p_loan_cancellation_id in out nocopy NUMBER
577: , p10_a0 in out nocopy JTF_NUMBER_TABLE
578: , p10_a1 in out nocopy JTF_NUMBER_TABLE
579: , p10_a2 in out nocopy JTF_DATE_TABLE
580: , p10_a3 in out nocopy JTF_DATE_TABLE
581: , p10_a4 in out nocopy JTF_DATE_TABLE
582: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
584: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 581: , p10_a4 in out nocopy JTF_DATE_TABLE

577: , p10_a0 in out nocopy JTF_NUMBER_TABLE
578: , p10_a1 in out nocopy JTF_NUMBER_TABLE
579: , p10_a2 in out nocopy JTF_DATE_TABLE
580: , p10_a3 in out nocopy JTF_DATE_TABLE
581: , p10_a4 in out nocopy JTF_DATE_TABLE
582: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
584: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
585: , p10_a8 in out nocopy JTF_NUMBER_TABLE