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.OKL_LEASE_QUOTE_FEE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body okl_lease_quote_fee_pvt_w as
2: /* $Header: OKLEQUFB.pls 120.6 2006/03/16 10:09:26 asawanka noship $ */
3: procedure rosetta_table_copy_in_p24(t out nocopy okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_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_NUMBER_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p24(t out nocopy okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_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_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_2000

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_100
14: ) as
15: ddindx binary_integer; indx binary_integer;
16: begin
17: if a0 is not null and a0.count > 0 then

Line 44: , a2 out nocopy JTF_VARCHAR2_TABLE_100

40: end if;
41: end rosetta_table_copy_in_p24;
42: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_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_NUMBER_TABLE

Line 46: , a4 out nocopy JTF_VARCHAR2_TABLE_100

42: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_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_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_300
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 52: , a10 out nocopy JTF_VARCHAR2_TABLE_100

48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_300
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: ) as
54: ddindx binary_integer; indx binary_integer;
55: begin
56: if t is null or t.count = 0 then

Line 59: a2 := JTF_VARCHAR2_TABLE_100();

55: begin
56: if t is null or t.count = 0 then
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_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_NUMBER_TABLE();

Line 61: a4 := JTF_VARCHAR2_TABLE_100();

57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_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_NUMBER_TABLE();
64: a7 := JTF_VARCHAR2_TABLE_300();
65: a8 := JTF_VARCHAR2_TABLE_2000();

Line 67: a10 := JTF_VARCHAR2_TABLE_100();

63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_VARCHAR2_TABLE_300();
65: a8 := JTF_VARCHAR2_TABLE_2000();
66: a9 := JTF_VARCHAR2_TABLE_2000();
67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_TABLE();
71: a2 := JTF_VARCHAR2_TABLE_100();

Line 71: a2 := JTF_VARCHAR2_TABLE_100();

67: a10 := JTF_VARCHAR2_TABLE_100();
68: else
69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_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_NUMBER_TABLE();

Line 73: a4 := JTF_VARCHAR2_TABLE_100();

69: a0 := JTF_NUMBER_TABLE();
70: a1 := JTF_NUMBER_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_NUMBER_TABLE();
76: a7 := JTF_VARCHAR2_TABLE_300();
77: a8 := JTF_VARCHAR2_TABLE_2000();

Line 79: a10 := JTF_VARCHAR2_TABLE_100();

75: a6 := JTF_NUMBER_TABLE();
76: a7 := JTF_VARCHAR2_TABLE_300();
77: a8 := JTF_VARCHAR2_TABLE_2000();
78: a9 := JTF_VARCHAR2_TABLE_2000();
79: a10 := JTF_VARCHAR2_TABLE_100();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);
83: a2.extend(t.count);

Line 160: , p4_a2 JTF_VARCHAR2_TABLE_100

156: , p3_a37 VARCHAR2
157: , p3_a38 NUMBER
158: , p4_a0 JTF_NUMBER_TABLE
159: , p4_a1 JTF_NUMBER_TABLE
160: , p4_a2 JTF_VARCHAR2_TABLE_100
161: , p4_a3 JTF_NUMBER_TABLE
162: , p4_a4 JTF_VARCHAR2_TABLE_100
163: , p4_a5 JTF_NUMBER_TABLE
164: , p4_a6 JTF_NUMBER_TABLE

Line 162: , p4_a4 JTF_VARCHAR2_TABLE_100

158: , p4_a0 JTF_NUMBER_TABLE
159: , p4_a1 JTF_NUMBER_TABLE
160: , p4_a2 JTF_VARCHAR2_TABLE_100
161: , p4_a3 JTF_NUMBER_TABLE
162: , p4_a4 JTF_VARCHAR2_TABLE_100
163: , p4_a5 JTF_NUMBER_TABLE
164: , p4_a6 JTF_NUMBER_TABLE
165: , p4_a7 JTF_VARCHAR2_TABLE_300
166: , p4_a8 JTF_VARCHAR2_TABLE_2000

Line 168: , p4_a10 JTF_VARCHAR2_TABLE_100

164: , p4_a6 JTF_NUMBER_TABLE
165: , p4_a7 JTF_VARCHAR2_TABLE_300
166: , p4_a8 JTF_VARCHAR2_TABLE_2000
167: , p4_a9 JTF_VARCHAR2_TABLE_2000
168: , p4_a10 JTF_VARCHAR2_TABLE_100
169: , p5_a0 VARCHAR2
170: , p5_a1 NUMBER
171: , p5_a2 VARCHAR2
172: , p5_a3 VARCHAR2

Line 191: , p6_a8 JTF_VARCHAR2_TABLE_100

187: , p6_a4 JTF_NUMBER_TABLE
188: , p6_a5 JTF_NUMBER_TABLE
189: , p6_a6 JTF_NUMBER_TABLE
190: , p6_a7 JTF_NUMBER_TABLE
191: , p6_a8 JTF_VARCHAR2_TABLE_100
192: , p6_a9 JTF_VARCHAR2_TABLE_100
193: , p7_a0 VARCHAR2
194: , p7_a1 NUMBER
195: , p7_a2 VARCHAR2

Line 192: , p6_a9 JTF_VARCHAR2_TABLE_100

188: , p6_a5 JTF_NUMBER_TABLE
189: , p6_a6 JTF_NUMBER_TABLE
190: , p6_a7 JTF_NUMBER_TABLE
191: , p6_a8 JTF_VARCHAR2_TABLE_100
192: , p6_a9 JTF_VARCHAR2_TABLE_100
193: , p7_a0 VARCHAR2
194: , p7_a1 NUMBER
195: , p7_a2 VARCHAR2
196: , p7_a3 VARCHAR2

Line 215: , p8_a8 JTF_VARCHAR2_TABLE_100

211: , p8_a4 JTF_NUMBER_TABLE
212: , p8_a5 JTF_NUMBER_TABLE
213: , p8_a6 JTF_NUMBER_TABLE
214: , p8_a7 JTF_NUMBER_TABLE
215: , p8_a8 JTF_VARCHAR2_TABLE_100
216: , p8_a9 JTF_VARCHAR2_TABLE_100
217: , x_fee_id out nocopy NUMBER
218: , x_return_status out nocopy VARCHAR2
219: , x_msg_count out nocopy NUMBER

Line 216: , p8_a9 JTF_VARCHAR2_TABLE_100

212: , p8_a5 JTF_NUMBER_TABLE
213: , p8_a6 JTF_NUMBER_TABLE
214: , p8_a7 JTF_NUMBER_TABLE
215: , p8_a8 JTF_VARCHAR2_TABLE_100
216: , p8_a9 JTF_VARCHAR2_TABLE_100
217: , x_fee_id out nocopy NUMBER
218: , x_return_status out nocopy VARCHAR2
219: , x_msg_count out nocopy NUMBER
220: , x_msg_data out nocopy VARCHAR2

Line 547: , p4_a2 JTF_VARCHAR2_TABLE_100

543: , p3_a37 VARCHAR2
544: , p3_a38 NUMBER
545: , p4_a0 JTF_NUMBER_TABLE
546: , p4_a1 JTF_NUMBER_TABLE
547: , p4_a2 JTF_VARCHAR2_TABLE_100
548: , p4_a3 JTF_NUMBER_TABLE
549: , p4_a4 JTF_VARCHAR2_TABLE_100
550: , p4_a5 JTF_NUMBER_TABLE
551: , p4_a6 JTF_NUMBER_TABLE

Line 549: , p4_a4 JTF_VARCHAR2_TABLE_100

545: , p4_a0 JTF_NUMBER_TABLE
546: , p4_a1 JTF_NUMBER_TABLE
547: , p4_a2 JTF_VARCHAR2_TABLE_100
548: , p4_a3 JTF_NUMBER_TABLE
549: , p4_a4 JTF_VARCHAR2_TABLE_100
550: , p4_a5 JTF_NUMBER_TABLE
551: , p4_a6 JTF_NUMBER_TABLE
552: , p4_a7 JTF_VARCHAR2_TABLE_300
553: , p4_a8 JTF_VARCHAR2_TABLE_2000

Line 555: , p4_a10 JTF_VARCHAR2_TABLE_100

551: , p4_a6 JTF_NUMBER_TABLE
552: , p4_a7 JTF_VARCHAR2_TABLE_300
553: , p4_a8 JTF_VARCHAR2_TABLE_2000
554: , p4_a9 JTF_VARCHAR2_TABLE_2000
555: , p4_a10 JTF_VARCHAR2_TABLE_100
556: , p5_a0 VARCHAR2
557: , p5_a1 NUMBER
558: , p5_a2 VARCHAR2
559: , p5_a3 VARCHAR2

Line 578: , p6_a8 JTF_VARCHAR2_TABLE_100

574: , p6_a4 JTF_NUMBER_TABLE
575: , p6_a5 JTF_NUMBER_TABLE
576: , p6_a6 JTF_NUMBER_TABLE
577: , p6_a7 JTF_NUMBER_TABLE
578: , p6_a8 JTF_VARCHAR2_TABLE_100
579: , p6_a9 JTF_VARCHAR2_TABLE_100
580: , p7_a0 VARCHAR2
581: , p7_a1 NUMBER
582: , p7_a2 VARCHAR2

Line 579: , p6_a9 JTF_VARCHAR2_TABLE_100

575: , p6_a5 JTF_NUMBER_TABLE
576: , p6_a6 JTF_NUMBER_TABLE
577: , p6_a7 JTF_NUMBER_TABLE
578: , p6_a8 JTF_VARCHAR2_TABLE_100
579: , p6_a9 JTF_VARCHAR2_TABLE_100
580: , p7_a0 VARCHAR2
581: , p7_a1 NUMBER
582: , p7_a2 VARCHAR2
583: , p7_a3 VARCHAR2

Line 602: , p8_a8 JTF_VARCHAR2_TABLE_100

598: , p8_a4 JTF_NUMBER_TABLE
599: , p8_a5 JTF_NUMBER_TABLE
600: , p8_a6 JTF_NUMBER_TABLE
601: , p8_a7 JTF_NUMBER_TABLE
602: , p8_a8 JTF_VARCHAR2_TABLE_100
603: , p8_a9 JTF_VARCHAR2_TABLE_100
604: , x_return_status out nocopy VARCHAR2
605: , x_msg_count out nocopy NUMBER
606: , x_msg_data out nocopy VARCHAR2

Line 603: , p8_a9 JTF_VARCHAR2_TABLE_100

599: , p8_a5 JTF_NUMBER_TABLE
600: , p8_a6 JTF_NUMBER_TABLE
601: , p8_a7 JTF_NUMBER_TABLE
602: , p8_a8 JTF_VARCHAR2_TABLE_100
603: , p8_a9 JTF_VARCHAR2_TABLE_100
604: , x_return_status out nocopy VARCHAR2
605: , x_msg_count out nocopy NUMBER
606: , x_msg_data out nocopy VARCHAR2
607: )

Line 806: , p5_a2 JTF_VARCHAR2_TABLE_100

802: , p4_a37 VARCHAR2
803: , p4_a38 NUMBER
804: , p5_a0 JTF_NUMBER_TABLE
805: , p5_a1 JTF_NUMBER_TABLE
806: , p5_a2 JTF_VARCHAR2_TABLE_100
807: , p5_a3 JTF_NUMBER_TABLE
808: , p5_a4 JTF_VARCHAR2_TABLE_100
809: , p5_a5 JTF_NUMBER_TABLE
810: , p5_a6 JTF_NUMBER_TABLE

Line 808: , p5_a4 JTF_VARCHAR2_TABLE_100

804: , p5_a0 JTF_NUMBER_TABLE
805: , p5_a1 JTF_NUMBER_TABLE
806: , p5_a2 JTF_VARCHAR2_TABLE_100
807: , p5_a3 JTF_NUMBER_TABLE
808: , p5_a4 JTF_VARCHAR2_TABLE_100
809: , p5_a5 JTF_NUMBER_TABLE
810: , p5_a6 JTF_NUMBER_TABLE
811: , p5_a7 JTF_VARCHAR2_TABLE_300
812: , p5_a8 JTF_VARCHAR2_TABLE_2000

Line 814: , p5_a10 JTF_VARCHAR2_TABLE_100

810: , p5_a6 JTF_NUMBER_TABLE
811: , p5_a7 JTF_VARCHAR2_TABLE_300
812: , p5_a8 JTF_VARCHAR2_TABLE_2000
813: , p5_a9 JTF_VARCHAR2_TABLE_2000
814: , p5_a10 JTF_VARCHAR2_TABLE_100
815: , p6_a0 VARCHAR2
816: , p6_a1 NUMBER
817: , p6_a2 VARCHAR2
818: , p6_a3 VARCHAR2

Line 837: , p7_a8 JTF_VARCHAR2_TABLE_100

833: , p7_a4 JTF_NUMBER_TABLE
834: , p7_a5 JTF_NUMBER_TABLE
835: , p7_a6 JTF_NUMBER_TABLE
836: , p7_a7 JTF_NUMBER_TABLE
837: , p7_a8 JTF_VARCHAR2_TABLE_100
838: , p7_a9 JTF_VARCHAR2_TABLE_100
839: , p8_a0 VARCHAR2
840: , p8_a1 NUMBER
841: , p8_a2 VARCHAR2

Line 838: , p7_a9 JTF_VARCHAR2_TABLE_100

834: , p7_a5 JTF_NUMBER_TABLE
835: , p7_a6 JTF_NUMBER_TABLE
836: , p7_a7 JTF_NUMBER_TABLE
837: , p7_a8 JTF_VARCHAR2_TABLE_100
838: , p7_a9 JTF_VARCHAR2_TABLE_100
839: , p8_a0 VARCHAR2
840: , p8_a1 NUMBER
841: , p8_a2 VARCHAR2
842: , p8_a3 VARCHAR2

Line 861: , p9_a8 JTF_VARCHAR2_TABLE_100

857: , p9_a4 JTF_NUMBER_TABLE
858: , p9_a5 JTF_NUMBER_TABLE
859: , p9_a6 JTF_NUMBER_TABLE
860: , p9_a7 JTF_NUMBER_TABLE
861: , p9_a8 JTF_VARCHAR2_TABLE_100
862: , p9_a9 JTF_VARCHAR2_TABLE_100
863: , x_fee_id out nocopy NUMBER
864: , x_return_status out nocopy VARCHAR2
865: , x_msg_count out nocopy NUMBER

Line 862: , p9_a9 JTF_VARCHAR2_TABLE_100

858: , p9_a5 JTF_NUMBER_TABLE
859: , p9_a6 JTF_NUMBER_TABLE
860: , p9_a7 JTF_NUMBER_TABLE
861: , p9_a8 JTF_VARCHAR2_TABLE_100
862: , p9_a9 JTF_VARCHAR2_TABLE_100
863: , x_fee_id out nocopy NUMBER
864: , x_return_status out nocopy VARCHAR2
865: , x_msg_count out nocopy NUMBER
866: , x_msg_data out nocopy VARCHAR2