DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 26: , a1 JTF_VARCHAR2_TABLE_200

22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p13(t out nocopy okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_200
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_DATE_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_DATE_TABLE

Line 27: , a2 JTF_VARCHAR2_TABLE_200

23: end;
24:
25: procedure rosetta_table_copy_in_p13(t out nocopy okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_200
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_DATE_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_VARCHAR2_TABLE_200

Line 29: , a4 JTF_VARCHAR2_TABLE_200

25: procedure rosetta_table_copy_in_p13(t out nocopy okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_200
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_DATE_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_VARCHAR2_TABLE_200
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_2000

Line 31: , a6 JTF_VARCHAR2_TABLE_200

27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_DATE_TABLE
29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_VARCHAR2_TABLE_200
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_2000
34: , a9 JTF_VARCHAR2_TABLE_2000
35: , a10 JTF_VARCHAR2_TABLE_100

Line 33: , a8 JTF_VARCHAR2_TABLE_2000

29: , a4 JTF_VARCHAR2_TABLE_200
30: , a5 JTF_DATE_TABLE
31: , a6 JTF_VARCHAR2_TABLE_200
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_2000
34: , a9 JTF_VARCHAR2_TABLE_2000
35: , a10 JTF_VARCHAR2_TABLE_100
36: , a11 JTF_VARCHAR2_TABLE_200
37: , a12 JTF_VARCHAR2_TABLE_100

Line 34: , a9 JTF_VARCHAR2_TABLE_2000

30: , a5 JTF_DATE_TABLE
31: , a6 JTF_VARCHAR2_TABLE_200
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_2000
34: , a9 JTF_VARCHAR2_TABLE_2000
35: , a10 JTF_VARCHAR2_TABLE_100
36: , a11 JTF_VARCHAR2_TABLE_200
37: , a12 JTF_VARCHAR2_TABLE_100
38: ) as

Line 36: , a11 JTF_VARCHAR2_TABLE_200

32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_2000
34: , a9 JTF_VARCHAR2_TABLE_2000
35: , a10 JTF_VARCHAR2_TABLE_100
36: , a11 JTF_VARCHAR2_TABLE_200
37: , a12 JTF_VARCHAR2_TABLE_100
38: ) as
39: ddindx binary_integer; indx binary_integer;
40: begin

Line 69: , a1 out nocopy JTF_VARCHAR2_TABLE_200

65: end if;
66: end if;
67: end rosetta_table_copy_in_p13;
68: procedure rosetta_table_copy_out_p13(t okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_VARCHAR2_TABLE_200
70: , a2 out nocopy JTF_VARCHAR2_TABLE_200
71: , a3 out nocopy JTF_DATE_TABLE
72: , a4 out nocopy JTF_VARCHAR2_TABLE_200
73: , a5 out nocopy JTF_DATE_TABLE

Line 70: , a2 out nocopy JTF_VARCHAR2_TABLE_200

66: end if;
67: end rosetta_table_copy_in_p13;
68: procedure rosetta_table_copy_out_p13(t okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_VARCHAR2_TABLE_200
70: , a2 out nocopy JTF_VARCHAR2_TABLE_200
71: , a3 out nocopy JTF_DATE_TABLE
72: , a4 out nocopy JTF_VARCHAR2_TABLE_200
73: , a5 out nocopy JTF_DATE_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 72: , a4 out nocopy JTF_VARCHAR2_TABLE_200

68: procedure rosetta_table_copy_out_p13(t okl_am_lease_loan_trmnt_pvt.term_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_VARCHAR2_TABLE_200
70: , a2 out nocopy JTF_VARCHAR2_TABLE_200
71: , a3 out nocopy JTF_DATE_TABLE
72: , a4 out nocopy JTF_VARCHAR2_TABLE_200
73: , a5 out nocopy JTF_DATE_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_200
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 74: , a6 out nocopy JTF_VARCHAR2_TABLE_200

70: , a2 out nocopy JTF_VARCHAR2_TABLE_200
71: , a3 out nocopy JTF_DATE_TABLE
72: , a4 out nocopy JTF_VARCHAR2_TABLE_200
73: , a5 out nocopy JTF_DATE_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_200
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
77: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
78: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 76: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

72: , a4 out nocopy JTF_VARCHAR2_TABLE_200
73: , a5 out nocopy JTF_DATE_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_200
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
77: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
78: , a10 out nocopy JTF_VARCHAR2_TABLE_100
79: , a11 out nocopy JTF_VARCHAR2_TABLE_200
80: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 77: , a9 out nocopy JTF_VARCHAR2_TABLE_2000

73: , a5 out nocopy JTF_DATE_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_200
75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
77: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
78: , a10 out nocopy JTF_VARCHAR2_TABLE_100
79: , a11 out nocopy JTF_VARCHAR2_TABLE_200
80: , a12 out nocopy JTF_VARCHAR2_TABLE_100
81: ) as

Line 79: , a11 out nocopy JTF_VARCHAR2_TABLE_200

75: , a7 out nocopy JTF_NUMBER_TABLE
76: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
77: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
78: , a10 out nocopy JTF_VARCHAR2_TABLE_100
79: , a11 out nocopy JTF_VARCHAR2_TABLE_200
80: , a12 out nocopy JTF_VARCHAR2_TABLE_100
81: ) as
82: ddindx binary_integer; indx binary_integer;
83: begin

Line 86: a1 := JTF_VARCHAR2_TABLE_200();

82: ddindx binary_integer; indx binary_integer;
83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_200();
87: a2 := JTF_VARCHAR2_TABLE_200();
88: a3 := JTF_DATE_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_200();
90: a5 := JTF_DATE_TABLE();

Line 87: a2 := JTF_VARCHAR2_TABLE_200();

83: begin
84: if t is null or t.count = 0 then
85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_200();
87: a2 := JTF_VARCHAR2_TABLE_200();
88: a3 := JTF_DATE_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_200();
90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_VARCHAR2_TABLE_200();

Line 89: a4 := JTF_VARCHAR2_TABLE_200();

85: a0 := JTF_NUMBER_TABLE();
86: a1 := JTF_VARCHAR2_TABLE_200();
87: a2 := JTF_VARCHAR2_TABLE_200();
88: a3 := JTF_DATE_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_200();
90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_VARCHAR2_TABLE_200();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_2000();

Line 91: a6 := JTF_VARCHAR2_TABLE_200();

87: a2 := JTF_VARCHAR2_TABLE_200();
88: a3 := JTF_DATE_TABLE();
89: a4 := JTF_VARCHAR2_TABLE_200();
90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_VARCHAR2_TABLE_200();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_2000();
94: a9 := JTF_VARCHAR2_TABLE_2000();
95: a10 := JTF_VARCHAR2_TABLE_100();

Line 93: a8 := JTF_VARCHAR2_TABLE_2000();

89: a4 := JTF_VARCHAR2_TABLE_200();
90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_VARCHAR2_TABLE_200();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_2000();
94: a9 := JTF_VARCHAR2_TABLE_2000();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_200();
97: a12 := JTF_VARCHAR2_TABLE_100();

Line 94: a9 := JTF_VARCHAR2_TABLE_2000();

90: a5 := JTF_DATE_TABLE();
91: a6 := JTF_VARCHAR2_TABLE_200();
92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_2000();
94: a9 := JTF_VARCHAR2_TABLE_2000();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_200();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: else

Line 96: a11 := JTF_VARCHAR2_TABLE_200();

92: a7 := JTF_NUMBER_TABLE();
93: a8 := JTF_VARCHAR2_TABLE_2000();
94: a9 := JTF_VARCHAR2_TABLE_2000();
95: a10 := JTF_VARCHAR2_TABLE_100();
96: a11 := JTF_VARCHAR2_TABLE_200();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: else
99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_VARCHAR2_TABLE_200();

Line 100: a1 := JTF_VARCHAR2_TABLE_200();

96: a11 := JTF_VARCHAR2_TABLE_200();
97: a12 := JTF_VARCHAR2_TABLE_100();
98: else
99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_VARCHAR2_TABLE_200();
101: a2 := JTF_VARCHAR2_TABLE_200();
102: a3 := JTF_DATE_TABLE();
103: a4 := JTF_VARCHAR2_TABLE_200();
104: a5 := JTF_DATE_TABLE();

Line 101: a2 := JTF_VARCHAR2_TABLE_200();

97: a12 := JTF_VARCHAR2_TABLE_100();
98: else
99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_VARCHAR2_TABLE_200();
101: a2 := JTF_VARCHAR2_TABLE_200();
102: a3 := JTF_DATE_TABLE();
103: a4 := JTF_VARCHAR2_TABLE_200();
104: a5 := JTF_DATE_TABLE();
105: a6 := JTF_VARCHAR2_TABLE_200();

Line 103: a4 := JTF_VARCHAR2_TABLE_200();

99: a0 := JTF_NUMBER_TABLE();
100: a1 := JTF_VARCHAR2_TABLE_200();
101: a2 := JTF_VARCHAR2_TABLE_200();
102: a3 := JTF_DATE_TABLE();
103: a4 := JTF_VARCHAR2_TABLE_200();
104: a5 := JTF_DATE_TABLE();
105: a6 := JTF_VARCHAR2_TABLE_200();
106: a7 := JTF_NUMBER_TABLE();
107: a8 := JTF_VARCHAR2_TABLE_2000();

Line 105: a6 := JTF_VARCHAR2_TABLE_200();

101: a2 := JTF_VARCHAR2_TABLE_200();
102: a3 := JTF_DATE_TABLE();
103: a4 := JTF_VARCHAR2_TABLE_200();
104: a5 := JTF_DATE_TABLE();
105: a6 := JTF_VARCHAR2_TABLE_200();
106: a7 := JTF_NUMBER_TABLE();
107: a8 := JTF_VARCHAR2_TABLE_2000();
108: a9 := JTF_VARCHAR2_TABLE_2000();
109: a10 := JTF_VARCHAR2_TABLE_100();

Line 107: a8 := JTF_VARCHAR2_TABLE_2000();

103: a4 := JTF_VARCHAR2_TABLE_200();
104: a5 := JTF_DATE_TABLE();
105: a6 := JTF_VARCHAR2_TABLE_200();
106: a7 := JTF_NUMBER_TABLE();
107: a8 := JTF_VARCHAR2_TABLE_2000();
108: a9 := JTF_VARCHAR2_TABLE_2000();
109: a10 := JTF_VARCHAR2_TABLE_100();
110: a11 := JTF_VARCHAR2_TABLE_200();
111: a12 := JTF_VARCHAR2_TABLE_100();

Line 108: a9 := JTF_VARCHAR2_TABLE_2000();

104: a5 := JTF_DATE_TABLE();
105: a6 := JTF_VARCHAR2_TABLE_200();
106: a7 := JTF_NUMBER_TABLE();
107: a8 := JTF_VARCHAR2_TABLE_2000();
108: a9 := JTF_VARCHAR2_TABLE_2000();
109: a10 := JTF_VARCHAR2_TABLE_100();
110: a11 := JTF_VARCHAR2_TABLE_200();
111: a12 := JTF_VARCHAR2_TABLE_100();
112: if t.count > 0 then

Line 110: a11 := JTF_VARCHAR2_TABLE_200();

106: a7 := JTF_NUMBER_TABLE();
107: a8 := JTF_VARCHAR2_TABLE_2000();
108: a9 := JTF_VARCHAR2_TABLE_2000();
109: a10 := JTF_VARCHAR2_TABLE_100();
110: a11 := JTF_VARCHAR2_TABLE_200();
111: a12 := JTF_VARCHAR2_TABLE_100();
112: if t.count > 0 then
113: a0.extend(t.count);
114: a1.extend(t.count);

Line 411: , p5_a1 JTF_VARCHAR2_TABLE_200

407: , x_return_status out nocopy VARCHAR2
408: , x_msg_count out nocopy NUMBER
409: , x_msg_data out nocopy VARCHAR2
410: , p5_a0 JTF_NUMBER_TABLE
411: , p5_a1 JTF_VARCHAR2_TABLE_200
412: , p5_a2 JTF_VARCHAR2_TABLE_200
413: , p5_a3 JTF_DATE_TABLE
414: , p5_a4 JTF_VARCHAR2_TABLE_200
415: , p5_a5 JTF_DATE_TABLE

Line 412: , p5_a2 JTF_VARCHAR2_TABLE_200

408: , x_msg_count out nocopy NUMBER
409: , x_msg_data out nocopy VARCHAR2
410: , p5_a0 JTF_NUMBER_TABLE
411: , p5_a1 JTF_VARCHAR2_TABLE_200
412: , p5_a2 JTF_VARCHAR2_TABLE_200
413: , p5_a3 JTF_DATE_TABLE
414: , p5_a4 JTF_VARCHAR2_TABLE_200
415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_200

Line 414: , p5_a4 JTF_VARCHAR2_TABLE_200

410: , p5_a0 JTF_NUMBER_TABLE
411: , p5_a1 JTF_VARCHAR2_TABLE_200
412: , p5_a2 JTF_VARCHAR2_TABLE_200
413: , p5_a3 JTF_DATE_TABLE
414: , p5_a4 JTF_VARCHAR2_TABLE_200
415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_200
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_VARCHAR2_TABLE_2000

Line 416: , p5_a6 JTF_VARCHAR2_TABLE_200

412: , p5_a2 JTF_VARCHAR2_TABLE_200
413: , p5_a3 JTF_DATE_TABLE
414: , p5_a4 JTF_VARCHAR2_TABLE_200
415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_200
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_VARCHAR2_TABLE_2000
419: , p5_a9 JTF_VARCHAR2_TABLE_2000
420: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 418: , p5_a8 JTF_VARCHAR2_TABLE_2000

414: , p5_a4 JTF_VARCHAR2_TABLE_200
415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_200
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_VARCHAR2_TABLE_2000
419: , p5_a9 JTF_VARCHAR2_TABLE_2000
420: , p5_a10 JTF_VARCHAR2_TABLE_100
421: , p5_a11 JTF_VARCHAR2_TABLE_200
422: , p5_a12 JTF_VARCHAR2_TABLE_100

Line 419: , p5_a9 JTF_VARCHAR2_TABLE_2000

415: , p5_a5 JTF_DATE_TABLE
416: , p5_a6 JTF_VARCHAR2_TABLE_200
417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_VARCHAR2_TABLE_2000
419: , p5_a9 JTF_VARCHAR2_TABLE_2000
420: , p5_a10 JTF_VARCHAR2_TABLE_100
421: , p5_a11 JTF_VARCHAR2_TABLE_200
422: , p5_a12 JTF_VARCHAR2_TABLE_100
423: , p6_a0 JTF_NUMBER_TABLE

Line 421: , p5_a11 JTF_VARCHAR2_TABLE_200

417: , p5_a7 JTF_NUMBER_TABLE
418: , p5_a8 JTF_VARCHAR2_TABLE_2000
419: , p5_a9 JTF_VARCHAR2_TABLE_2000
420: , p5_a10 JTF_VARCHAR2_TABLE_100
421: , p5_a11 JTF_VARCHAR2_TABLE_200
422: , p5_a12 JTF_VARCHAR2_TABLE_100
423: , p6_a0 JTF_NUMBER_TABLE
424: , p6_a1 JTF_NUMBER_TABLE
425: , p6_a2 JTF_VARCHAR2_TABLE_100

Line 441: , p6_a18 JTF_VARCHAR2_TABLE_200

437: , p6_a14 JTF_DATE_TABLE
438: , p6_a15 JTF_VARCHAR2_TABLE_100
439: , p6_a16 JTF_VARCHAR2_TABLE_100
440: , p6_a17 JTF_NUMBER_TABLE
441: , p6_a18 JTF_VARCHAR2_TABLE_200
442: , p6_a19 JTF_VARCHAR2_TABLE_100
443: , p6_a20 JTF_VARCHAR2_TABLE_500
444: , p6_a21 JTF_VARCHAR2_TABLE_500
445: , p6_a22 JTF_VARCHAR2_TABLE_500

Line 480: , p6_a57 JTF_VARCHAR2_TABLE_2000

476: , p6_a53 JTF_NUMBER_TABLE
477: , p6_a54 JTF_NUMBER_TABLE
478: , p6_a55 JTF_VARCHAR2_TABLE_100
479: , p6_a56 JTF_NUMBER_TABLE
480: , p6_a57 JTF_VARCHAR2_TABLE_2000
481: , p6_a58 JTF_DATE_TABLE
482: , p6_a59 JTF_VARCHAR2_TABLE_100
483: , p6_a60 JTF_VARCHAR2_TABLE_100
484: , p6_a61 JTF_VARCHAR2_TABLE_100

Line 509: , p6_a86 JTF_VARCHAR2_TABLE_200

505: , p6_a82 JTF_DATE_TABLE
506: , p6_a83 JTF_NUMBER_TABLE
507: , p6_a84 JTF_DATE_TABLE
508: , p6_a85 JTF_VARCHAR2_TABLE_100
509: , p6_a86 JTF_VARCHAR2_TABLE_200
510: , p6_a87 JTF_VARCHAR2_TABLE_100
511: , p6_a88 JTF_VARCHAR2_TABLE_200
512: , p6_a89 JTF_VARCHAR2_TABLE_100
513: , p6_a90 JTF_VARCHAR2_TABLE_100

Line 511: , p6_a88 JTF_VARCHAR2_TABLE_200

507: , p6_a84 JTF_DATE_TABLE
508: , p6_a85 JTF_VARCHAR2_TABLE_100
509: , p6_a86 JTF_VARCHAR2_TABLE_200
510: , p6_a87 JTF_VARCHAR2_TABLE_100
511: , p6_a88 JTF_VARCHAR2_TABLE_200
512: , p6_a89 JTF_VARCHAR2_TABLE_100
513: , p6_a90 JTF_VARCHAR2_TABLE_100
514: , p6_a91 JTF_VARCHAR2_TABLE_100
515: , p6_a92 JTF_VARCHAR2_TABLE_100