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 okl_lease_quote_fee_pvt_w as
2: /* $Header: OKLEQUFS.pls 120.6 2006/03/16 10:09:34 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: );
15: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 17: , a2 out nocopy JTF_VARCHAR2_TABLE_100

13: , a10 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_NUMBER_TABLE
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE

Line 19: , a4 out nocopy JTF_VARCHAR2_TABLE_100

15: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_NUMBER_TABLE
19: , a4 out nocopy JTF_VARCHAR2_TABLE_100
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_VARCHAR2_TABLE_300
23: , a8 out nocopy JTF_VARCHAR2_TABLE_2000

Line 25: , a10 out nocopy JTF_VARCHAR2_TABLE_100

21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_VARCHAR2_TABLE_300
23: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
24: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
25: , a10 out nocopy JTF_VARCHAR2_TABLE_100
26: );
27:
28: procedure create_fee(p_api_version NUMBER
29: , p_init_msg_list VARCHAR2

Line 72: , p4_a2 JTF_VARCHAR2_TABLE_100

68: , p3_a37 VARCHAR2
69: , p3_a38 NUMBER
70: , p4_a0 JTF_NUMBER_TABLE
71: , p4_a1 JTF_NUMBER_TABLE
72: , p4_a2 JTF_VARCHAR2_TABLE_100
73: , p4_a3 JTF_NUMBER_TABLE
74: , p4_a4 JTF_VARCHAR2_TABLE_100
75: , p4_a5 JTF_NUMBER_TABLE
76: , p4_a6 JTF_NUMBER_TABLE

Line 74: , p4_a4 JTF_VARCHAR2_TABLE_100

70: , p4_a0 JTF_NUMBER_TABLE
71: , p4_a1 JTF_NUMBER_TABLE
72: , p4_a2 JTF_VARCHAR2_TABLE_100
73: , p4_a3 JTF_NUMBER_TABLE
74: , p4_a4 JTF_VARCHAR2_TABLE_100
75: , p4_a5 JTF_NUMBER_TABLE
76: , p4_a6 JTF_NUMBER_TABLE
77: , p4_a7 JTF_VARCHAR2_TABLE_300
78: , p4_a8 JTF_VARCHAR2_TABLE_2000

Line 80: , p4_a10 JTF_VARCHAR2_TABLE_100

76: , p4_a6 JTF_NUMBER_TABLE
77: , p4_a7 JTF_VARCHAR2_TABLE_300
78: , p4_a8 JTF_VARCHAR2_TABLE_2000
79: , p4_a9 JTF_VARCHAR2_TABLE_2000
80: , p4_a10 JTF_VARCHAR2_TABLE_100
81: , p5_a0 VARCHAR2
82: , p5_a1 NUMBER
83: , p5_a2 VARCHAR2
84: , p5_a3 VARCHAR2

Line 103: , p6_a8 JTF_VARCHAR2_TABLE_100

99: , p6_a4 JTF_NUMBER_TABLE
100: , p6_a5 JTF_NUMBER_TABLE
101: , p6_a6 JTF_NUMBER_TABLE
102: , p6_a7 JTF_NUMBER_TABLE
103: , p6_a8 JTF_VARCHAR2_TABLE_100
104: , p6_a9 JTF_VARCHAR2_TABLE_100
105: , p7_a0 VARCHAR2
106: , p7_a1 NUMBER
107: , p7_a2 VARCHAR2

Line 104: , p6_a9 JTF_VARCHAR2_TABLE_100

100: , p6_a5 JTF_NUMBER_TABLE
101: , p6_a6 JTF_NUMBER_TABLE
102: , p6_a7 JTF_NUMBER_TABLE
103: , p6_a8 JTF_VARCHAR2_TABLE_100
104: , p6_a9 JTF_VARCHAR2_TABLE_100
105: , p7_a0 VARCHAR2
106: , p7_a1 NUMBER
107: , p7_a2 VARCHAR2
108: , p7_a3 VARCHAR2

Line 127: , p8_a8 JTF_VARCHAR2_TABLE_100

123: , p8_a4 JTF_NUMBER_TABLE
124: , p8_a5 JTF_NUMBER_TABLE
125: , p8_a6 JTF_NUMBER_TABLE
126: , p8_a7 JTF_NUMBER_TABLE
127: , p8_a8 JTF_VARCHAR2_TABLE_100
128: , p8_a9 JTF_VARCHAR2_TABLE_100
129: , x_fee_id out nocopy NUMBER
130: , x_return_status out nocopy VARCHAR2
131: , x_msg_count out nocopy NUMBER

Line 128: , p8_a9 JTF_VARCHAR2_TABLE_100

124: , p8_a5 JTF_NUMBER_TABLE
125: , p8_a6 JTF_NUMBER_TABLE
126: , p8_a7 JTF_NUMBER_TABLE
127: , p8_a8 JTF_VARCHAR2_TABLE_100
128: , p8_a9 JTF_VARCHAR2_TABLE_100
129: , x_fee_id out nocopy NUMBER
130: , x_return_status out nocopy VARCHAR2
131: , x_msg_count out nocopy NUMBER
132: , x_msg_data out nocopy VARCHAR2

Line 226: , p4_a2 JTF_VARCHAR2_TABLE_100

222: , p3_a37 VARCHAR2
223: , p3_a38 NUMBER
224: , p4_a0 JTF_NUMBER_TABLE
225: , p4_a1 JTF_NUMBER_TABLE
226: , p4_a2 JTF_VARCHAR2_TABLE_100
227: , p4_a3 JTF_NUMBER_TABLE
228: , p4_a4 JTF_VARCHAR2_TABLE_100
229: , p4_a5 JTF_NUMBER_TABLE
230: , p4_a6 JTF_NUMBER_TABLE

Line 228: , p4_a4 JTF_VARCHAR2_TABLE_100

224: , p4_a0 JTF_NUMBER_TABLE
225: , p4_a1 JTF_NUMBER_TABLE
226: , p4_a2 JTF_VARCHAR2_TABLE_100
227: , p4_a3 JTF_NUMBER_TABLE
228: , p4_a4 JTF_VARCHAR2_TABLE_100
229: , p4_a5 JTF_NUMBER_TABLE
230: , p4_a6 JTF_NUMBER_TABLE
231: , p4_a7 JTF_VARCHAR2_TABLE_300
232: , p4_a8 JTF_VARCHAR2_TABLE_2000

Line 234: , p4_a10 JTF_VARCHAR2_TABLE_100

230: , p4_a6 JTF_NUMBER_TABLE
231: , p4_a7 JTF_VARCHAR2_TABLE_300
232: , p4_a8 JTF_VARCHAR2_TABLE_2000
233: , p4_a9 JTF_VARCHAR2_TABLE_2000
234: , p4_a10 JTF_VARCHAR2_TABLE_100
235: , p5_a0 VARCHAR2
236: , p5_a1 NUMBER
237: , p5_a2 VARCHAR2
238: , p5_a3 VARCHAR2

Line 257: , p6_a8 JTF_VARCHAR2_TABLE_100

253: , p6_a4 JTF_NUMBER_TABLE
254: , p6_a5 JTF_NUMBER_TABLE
255: , p6_a6 JTF_NUMBER_TABLE
256: , p6_a7 JTF_NUMBER_TABLE
257: , p6_a8 JTF_VARCHAR2_TABLE_100
258: , p6_a9 JTF_VARCHAR2_TABLE_100
259: , p7_a0 VARCHAR2
260: , p7_a1 NUMBER
261: , p7_a2 VARCHAR2

Line 258: , p6_a9 JTF_VARCHAR2_TABLE_100

254: , p6_a5 JTF_NUMBER_TABLE
255: , p6_a6 JTF_NUMBER_TABLE
256: , p6_a7 JTF_NUMBER_TABLE
257: , p6_a8 JTF_VARCHAR2_TABLE_100
258: , p6_a9 JTF_VARCHAR2_TABLE_100
259: , p7_a0 VARCHAR2
260: , p7_a1 NUMBER
261: , p7_a2 VARCHAR2
262: , p7_a3 VARCHAR2

Line 281: , p8_a8 JTF_VARCHAR2_TABLE_100

277: , p8_a4 JTF_NUMBER_TABLE
278: , p8_a5 JTF_NUMBER_TABLE
279: , p8_a6 JTF_NUMBER_TABLE
280: , p8_a7 JTF_NUMBER_TABLE
281: , p8_a8 JTF_VARCHAR2_TABLE_100
282: , p8_a9 JTF_VARCHAR2_TABLE_100
283: , x_return_status out nocopy VARCHAR2
284: , x_msg_count out nocopy NUMBER
285: , x_msg_data out nocopy VARCHAR2

Line 282: , p8_a9 JTF_VARCHAR2_TABLE_100

278: , p8_a5 JTF_NUMBER_TABLE
279: , p8_a6 JTF_NUMBER_TABLE
280: , p8_a7 JTF_NUMBER_TABLE
281: , p8_a8 JTF_VARCHAR2_TABLE_100
282: , p8_a9 JTF_VARCHAR2_TABLE_100
283: , x_return_status out nocopy VARCHAR2
284: , x_msg_count out nocopy NUMBER
285: , x_msg_data out nocopy VARCHAR2
286: );

Line 332: , p5_a2 JTF_VARCHAR2_TABLE_100

328: , p4_a37 VARCHAR2
329: , p4_a38 NUMBER
330: , p5_a0 JTF_NUMBER_TABLE
331: , p5_a1 JTF_NUMBER_TABLE
332: , p5_a2 JTF_VARCHAR2_TABLE_100
333: , p5_a3 JTF_NUMBER_TABLE
334: , p5_a4 JTF_VARCHAR2_TABLE_100
335: , p5_a5 JTF_NUMBER_TABLE
336: , p5_a6 JTF_NUMBER_TABLE

Line 334: , p5_a4 JTF_VARCHAR2_TABLE_100

330: , p5_a0 JTF_NUMBER_TABLE
331: , p5_a1 JTF_NUMBER_TABLE
332: , p5_a2 JTF_VARCHAR2_TABLE_100
333: , p5_a3 JTF_NUMBER_TABLE
334: , p5_a4 JTF_VARCHAR2_TABLE_100
335: , p5_a5 JTF_NUMBER_TABLE
336: , p5_a6 JTF_NUMBER_TABLE
337: , p5_a7 JTF_VARCHAR2_TABLE_300
338: , p5_a8 JTF_VARCHAR2_TABLE_2000

Line 340: , p5_a10 JTF_VARCHAR2_TABLE_100

336: , p5_a6 JTF_NUMBER_TABLE
337: , p5_a7 JTF_VARCHAR2_TABLE_300
338: , p5_a8 JTF_VARCHAR2_TABLE_2000
339: , p5_a9 JTF_VARCHAR2_TABLE_2000
340: , p5_a10 JTF_VARCHAR2_TABLE_100
341: , p6_a0 VARCHAR2
342: , p6_a1 NUMBER
343: , p6_a2 VARCHAR2
344: , p6_a3 VARCHAR2

Line 363: , p7_a8 JTF_VARCHAR2_TABLE_100

359: , p7_a4 JTF_NUMBER_TABLE
360: , p7_a5 JTF_NUMBER_TABLE
361: , p7_a6 JTF_NUMBER_TABLE
362: , p7_a7 JTF_NUMBER_TABLE
363: , p7_a8 JTF_VARCHAR2_TABLE_100
364: , p7_a9 JTF_VARCHAR2_TABLE_100
365: , p8_a0 VARCHAR2
366: , p8_a1 NUMBER
367: , p8_a2 VARCHAR2

Line 364: , p7_a9 JTF_VARCHAR2_TABLE_100

360: , p7_a5 JTF_NUMBER_TABLE
361: , p7_a6 JTF_NUMBER_TABLE
362: , p7_a7 JTF_NUMBER_TABLE
363: , p7_a8 JTF_VARCHAR2_TABLE_100
364: , p7_a9 JTF_VARCHAR2_TABLE_100
365: , p8_a0 VARCHAR2
366: , p8_a1 NUMBER
367: , p8_a2 VARCHAR2
368: , p8_a3 VARCHAR2

Line 387: , p9_a8 JTF_VARCHAR2_TABLE_100

383: , p9_a4 JTF_NUMBER_TABLE
384: , p9_a5 JTF_NUMBER_TABLE
385: , p9_a6 JTF_NUMBER_TABLE
386: , p9_a7 JTF_NUMBER_TABLE
387: , p9_a8 JTF_VARCHAR2_TABLE_100
388: , p9_a9 JTF_VARCHAR2_TABLE_100
389: , x_fee_id out nocopy NUMBER
390: , x_return_status out nocopy VARCHAR2
391: , x_msg_count out nocopy NUMBER

Line 388: , p9_a9 JTF_VARCHAR2_TABLE_100

384: , p9_a5 JTF_NUMBER_TABLE
385: , p9_a6 JTF_NUMBER_TABLE
386: , p9_a7 JTF_NUMBER_TABLE
387: , p9_a8 JTF_VARCHAR2_TABLE_100
388: , p9_a9 JTF_VARCHAR2_TABLE_100
389: , x_fee_id out nocopy NUMBER
390: , x_return_status out nocopy VARCHAR2
391: , x_msg_count out nocopy NUMBER
392: , x_msg_data out nocopy VARCHAR2