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_SERVICE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_lease_quote_service_pvt_w as
2: /* $Header: OKLEQUSS.pls 120.2 2006/02/13 07:28:25 asawanka noship $ */
3: procedure rosetta_table_copy_in_p17(t out nocopy okl_lease_quote_service_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_p17(t out nocopy okl_lease_quote_service_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_p17(t okl_lease_quote_service_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_p17(t okl_lease_quote_service_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_p17(t okl_lease_quote_service_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_service(p_api_version NUMBER
29: , p_init_msg_list VARCHAR2

Line 59: , p4_a2 JTF_VARCHAR2_TABLE_100

55: , p3_a24 VARCHAR2
56: , p3_a25 VARCHAR2
57: , p4_a0 JTF_NUMBER_TABLE
58: , p4_a1 JTF_NUMBER_TABLE
59: , p4_a2 JTF_VARCHAR2_TABLE_100
60: , p4_a3 JTF_NUMBER_TABLE
61: , p4_a4 JTF_VARCHAR2_TABLE_100
62: , p4_a5 JTF_NUMBER_TABLE
63: , p4_a6 JTF_NUMBER_TABLE

Line 61: , p4_a4 JTF_VARCHAR2_TABLE_100

57: , p4_a0 JTF_NUMBER_TABLE
58: , p4_a1 JTF_NUMBER_TABLE
59: , p4_a2 JTF_VARCHAR2_TABLE_100
60: , p4_a3 JTF_NUMBER_TABLE
61: , p4_a4 JTF_VARCHAR2_TABLE_100
62: , p4_a5 JTF_NUMBER_TABLE
63: , p4_a6 JTF_NUMBER_TABLE
64: , p4_a7 JTF_VARCHAR2_TABLE_300
65: , p4_a8 JTF_VARCHAR2_TABLE_2000

Line 67: , p4_a10 JTF_VARCHAR2_TABLE_100

63: , p4_a6 JTF_NUMBER_TABLE
64: , p4_a7 JTF_VARCHAR2_TABLE_300
65: , p4_a8 JTF_VARCHAR2_TABLE_2000
66: , p4_a9 JTF_VARCHAR2_TABLE_2000
67: , p4_a10 JTF_VARCHAR2_TABLE_100
68: , p5_a0 VARCHAR2
69: , p5_a1 NUMBER
70: , p5_a2 VARCHAR2
71: , p5_a3 VARCHAR2

Line 90: , p6_a8 JTF_VARCHAR2_TABLE_100

86: , p6_a4 JTF_NUMBER_TABLE
87: , p6_a5 JTF_NUMBER_TABLE
88: , p6_a6 JTF_NUMBER_TABLE
89: , p6_a7 JTF_NUMBER_TABLE
90: , p6_a8 JTF_VARCHAR2_TABLE_100
91: , p6_a9 JTF_VARCHAR2_TABLE_100
92: , p7_a0 VARCHAR2
93: , p7_a1 NUMBER
94: , p7_a2 VARCHAR2

Line 91: , p6_a9 JTF_VARCHAR2_TABLE_100

87: , p6_a5 JTF_NUMBER_TABLE
88: , p6_a6 JTF_NUMBER_TABLE
89: , p6_a7 JTF_NUMBER_TABLE
90: , p6_a8 JTF_VARCHAR2_TABLE_100
91: , p6_a9 JTF_VARCHAR2_TABLE_100
92: , p7_a0 VARCHAR2
93: , p7_a1 NUMBER
94: , p7_a2 VARCHAR2
95: , p7_a3 VARCHAR2

Line 114: , p8_a8 JTF_VARCHAR2_TABLE_100

110: , p8_a4 JTF_NUMBER_TABLE
111: , p8_a5 JTF_NUMBER_TABLE
112: , p8_a6 JTF_NUMBER_TABLE
113: , p8_a7 JTF_NUMBER_TABLE
114: , p8_a8 JTF_VARCHAR2_TABLE_100
115: , p8_a9 JTF_VARCHAR2_TABLE_100
116: , x_service_id out nocopy NUMBER
117: , x_return_status out nocopy VARCHAR2
118: , x_msg_count out nocopy NUMBER

Line 115: , p8_a9 JTF_VARCHAR2_TABLE_100

111: , p8_a5 JTF_NUMBER_TABLE
112: , p8_a6 JTF_NUMBER_TABLE
113: , p8_a7 JTF_NUMBER_TABLE
114: , p8_a8 JTF_VARCHAR2_TABLE_100
115: , p8_a9 JTF_VARCHAR2_TABLE_100
116: , x_service_id out nocopy NUMBER
117: , x_return_status out nocopy VARCHAR2
118: , x_msg_count out nocopy NUMBER
119: , x_msg_data out nocopy VARCHAR2

Line 152: , p4_a2 JTF_VARCHAR2_TABLE_100

148: , p3_a24 VARCHAR2
149: , p3_a25 VARCHAR2
150: , p4_a0 JTF_NUMBER_TABLE
151: , p4_a1 JTF_NUMBER_TABLE
152: , p4_a2 JTF_VARCHAR2_TABLE_100
153: , p4_a3 JTF_NUMBER_TABLE
154: , p4_a4 JTF_VARCHAR2_TABLE_100
155: , p4_a5 JTF_NUMBER_TABLE
156: , p4_a6 JTF_NUMBER_TABLE

Line 154: , p4_a4 JTF_VARCHAR2_TABLE_100

150: , p4_a0 JTF_NUMBER_TABLE
151: , p4_a1 JTF_NUMBER_TABLE
152: , p4_a2 JTF_VARCHAR2_TABLE_100
153: , p4_a3 JTF_NUMBER_TABLE
154: , p4_a4 JTF_VARCHAR2_TABLE_100
155: , p4_a5 JTF_NUMBER_TABLE
156: , p4_a6 JTF_NUMBER_TABLE
157: , p4_a7 JTF_VARCHAR2_TABLE_300
158: , p4_a8 JTF_VARCHAR2_TABLE_2000

Line 160: , p4_a10 JTF_VARCHAR2_TABLE_100

156: , p4_a6 JTF_NUMBER_TABLE
157: , p4_a7 JTF_VARCHAR2_TABLE_300
158: , p4_a8 JTF_VARCHAR2_TABLE_2000
159: , p4_a9 JTF_VARCHAR2_TABLE_2000
160: , p4_a10 JTF_VARCHAR2_TABLE_100
161: , p5_a0 VARCHAR2
162: , p5_a1 NUMBER
163: , p5_a2 VARCHAR2
164: , p5_a3 VARCHAR2

Line 183: , p6_a8 JTF_VARCHAR2_TABLE_100

179: , p6_a4 JTF_NUMBER_TABLE
180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_NUMBER_TABLE
182: , p6_a7 JTF_NUMBER_TABLE
183: , p6_a8 JTF_VARCHAR2_TABLE_100
184: , p6_a9 JTF_VARCHAR2_TABLE_100
185: , p7_a0 VARCHAR2
186: , p7_a1 NUMBER
187: , p7_a2 VARCHAR2

Line 184: , p6_a9 JTF_VARCHAR2_TABLE_100

180: , p6_a5 JTF_NUMBER_TABLE
181: , p6_a6 JTF_NUMBER_TABLE
182: , p6_a7 JTF_NUMBER_TABLE
183: , p6_a8 JTF_VARCHAR2_TABLE_100
184: , p6_a9 JTF_VARCHAR2_TABLE_100
185: , p7_a0 VARCHAR2
186: , p7_a1 NUMBER
187: , p7_a2 VARCHAR2
188: , p7_a3 VARCHAR2

Line 207: , p8_a8 JTF_VARCHAR2_TABLE_100

203: , p8_a4 JTF_NUMBER_TABLE
204: , p8_a5 JTF_NUMBER_TABLE
205: , p8_a6 JTF_NUMBER_TABLE
206: , p8_a7 JTF_NUMBER_TABLE
207: , p8_a8 JTF_VARCHAR2_TABLE_100
208: , p8_a9 JTF_VARCHAR2_TABLE_100
209: , x_return_status out nocopy VARCHAR2
210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2

Line 208: , p8_a9 JTF_VARCHAR2_TABLE_100

204: , p8_a5 JTF_NUMBER_TABLE
205: , p8_a6 JTF_NUMBER_TABLE
206: , p8_a7 JTF_NUMBER_TABLE
207: , p8_a8 JTF_VARCHAR2_TABLE_100
208: , p8_a9 JTF_VARCHAR2_TABLE_100
209: , x_return_status out nocopy VARCHAR2
210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: );

Line 245: , p5_a2 JTF_VARCHAR2_TABLE_100

241: , p4_a24 VARCHAR2
242: , p4_a25 VARCHAR2
243: , p5_a0 JTF_NUMBER_TABLE
244: , p5_a1 JTF_NUMBER_TABLE
245: , p5_a2 JTF_VARCHAR2_TABLE_100
246: , p5_a3 JTF_NUMBER_TABLE
247: , p5_a4 JTF_VARCHAR2_TABLE_100
248: , p5_a5 JTF_NUMBER_TABLE
249: , p5_a6 JTF_NUMBER_TABLE

Line 247: , p5_a4 JTF_VARCHAR2_TABLE_100

243: , p5_a0 JTF_NUMBER_TABLE
244: , p5_a1 JTF_NUMBER_TABLE
245: , p5_a2 JTF_VARCHAR2_TABLE_100
246: , p5_a3 JTF_NUMBER_TABLE
247: , p5_a4 JTF_VARCHAR2_TABLE_100
248: , p5_a5 JTF_NUMBER_TABLE
249: , p5_a6 JTF_NUMBER_TABLE
250: , p5_a7 JTF_VARCHAR2_TABLE_300
251: , p5_a8 JTF_VARCHAR2_TABLE_2000

Line 253: , p5_a10 JTF_VARCHAR2_TABLE_100

249: , p5_a6 JTF_NUMBER_TABLE
250: , p5_a7 JTF_VARCHAR2_TABLE_300
251: , p5_a8 JTF_VARCHAR2_TABLE_2000
252: , p5_a9 JTF_VARCHAR2_TABLE_2000
253: , p5_a10 JTF_VARCHAR2_TABLE_100
254: , p6_a0 VARCHAR2
255: , p6_a1 NUMBER
256: , p6_a2 VARCHAR2
257: , p6_a3 VARCHAR2

Line 276: , p7_a8 JTF_VARCHAR2_TABLE_100

272: , p7_a4 JTF_NUMBER_TABLE
273: , p7_a5 JTF_NUMBER_TABLE
274: , p7_a6 JTF_NUMBER_TABLE
275: , p7_a7 JTF_NUMBER_TABLE
276: , p7_a8 JTF_VARCHAR2_TABLE_100
277: , p7_a9 JTF_VARCHAR2_TABLE_100
278: , p8_a0 VARCHAR2
279: , p8_a1 NUMBER
280: , p8_a2 VARCHAR2

Line 277: , p7_a9 JTF_VARCHAR2_TABLE_100

273: , p7_a5 JTF_NUMBER_TABLE
274: , p7_a6 JTF_NUMBER_TABLE
275: , p7_a7 JTF_NUMBER_TABLE
276: , p7_a8 JTF_VARCHAR2_TABLE_100
277: , p7_a9 JTF_VARCHAR2_TABLE_100
278: , p8_a0 VARCHAR2
279: , p8_a1 NUMBER
280: , p8_a2 VARCHAR2
281: , p8_a3 VARCHAR2

Line 300: , p9_a8 JTF_VARCHAR2_TABLE_100

296: , p9_a4 JTF_NUMBER_TABLE
297: , p9_a5 JTF_NUMBER_TABLE
298: , p9_a6 JTF_NUMBER_TABLE
299: , p9_a7 JTF_NUMBER_TABLE
300: , p9_a8 JTF_VARCHAR2_TABLE_100
301: , p9_a9 JTF_VARCHAR2_TABLE_100
302: , x_service_id out nocopy NUMBER
303: , x_return_status out nocopy VARCHAR2
304: , x_msg_count out nocopy NUMBER

Line 301: , p9_a9 JTF_VARCHAR2_TABLE_100

297: , p9_a5 JTF_NUMBER_TABLE
298: , p9_a6 JTF_NUMBER_TABLE
299: , p9_a7 JTF_NUMBER_TABLE
300: , p9_a8 JTF_VARCHAR2_TABLE_100
301: , p9_a9 JTF_VARCHAR2_TABLE_100
302: , x_service_id out nocopy NUMBER
303: , x_return_status out nocopy VARCHAR2
304: , x_msg_count out nocopy NUMBER
305: , x_msg_data out nocopy VARCHAR2