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 AUTHID CURRENT_USER as
2: /* $Header: OKLEQUFS.pls 120.6.12020000.2 2012/08/07 12:50:29 racheruv ship $ */
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: , a11 JTF_NUMBER_TABLE
15: );
16: procedure rosetta_table_copy_out_p24(t okl_lease_quote_fee_pvt.line_relation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE

Line 18: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 20: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 26: , a10 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 75: , p4_a2 JTF_VARCHAR2_TABLE_100

71: , p3_a38 NUMBER
72: , p3_a39 VARCHAR2
73: , p4_a0 JTF_NUMBER_TABLE
74: , p4_a1 JTF_NUMBER_TABLE
75: , p4_a2 JTF_VARCHAR2_TABLE_100
76: , p4_a3 JTF_NUMBER_TABLE
77: , p4_a4 JTF_VARCHAR2_TABLE_100
78: , p4_a5 JTF_NUMBER_TABLE
79: , p4_a6 JTF_NUMBER_TABLE

Line 77: , p4_a4 JTF_VARCHAR2_TABLE_100

73: , p4_a0 JTF_NUMBER_TABLE
74: , p4_a1 JTF_NUMBER_TABLE
75: , p4_a2 JTF_VARCHAR2_TABLE_100
76: , p4_a3 JTF_NUMBER_TABLE
77: , p4_a4 JTF_VARCHAR2_TABLE_100
78: , p4_a5 JTF_NUMBER_TABLE
79: , p4_a6 JTF_NUMBER_TABLE
80: , p4_a7 JTF_VARCHAR2_TABLE_300
81: , p4_a8 JTF_VARCHAR2_TABLE_2000

Line 83: , p4_a10 JTF_VARCHAR2_TABLE_100

79: , p4_a6 JTF_NUMBER_TABLE
80: , p4_a7 JTF_VARCHAR2_TABLE_300
81: , p4_a8 JTF_VARCHAR2_TABLE_2000
82: , p4_a9 JTF_VARCHAR2_TABLE_2000
83: , p4_a10 JTF_VARCHAR2_TABLE_100
84: , p4_a11 JTF_NUMBER_TABLE
85: , p5_a0 VARCHAR2
86: , p5_a1 NUMBER
87: , p5_a2 VARCHAR2

Line 107: , p6_a8 JTF_VARCHAR2_TABLE_100

103: , p6_a4 JTF_NUMBER_TABLE
104: , p6_a5 JTF_NUMBER_TABLE
105: , p6_a6 JTF_NUMBER_TABLE
106: , p6_a7 JTF_NUMBER_TABLE
107: , p6_a8 JTF_VARCHAR2_TABLE_100
108: , p6_a9 JTF_VARCHAR2_TABLE_100
109: , p7_a0 VARCHAR2
110: , p7_a1 NUMBER
111: , p7_a2 VARCHAR2

Line 108: , p6_a9 JTF_VARCHAR2_TABLE_100

104: , p6_a5 JTF_NUMBER_TABLE
105: , p6_a6 JTF_NUMBER_TABLE
106: , p6_a7 JTF_NUMBER_TABLE
107: , p6_a8 JTF_VARCHAR2_TABLE_100
108: , p6_a9 JTF_VARCHAR2_TABLE_100
109: , p7_a0 VARCHAR2
110: , p7_a1 NUMBER
111: , p7_a2 VARCHAR2
112: , p7_a3 VARCHAR2

Line 131: , p8_a8 JTF_VARCHAR2_TABLE_100

127: , p8_a4 JTF_NUMBER_TABLE
128: , p8_a5 JTF_NUMBER_TABLE
129: , p8_a6 JTF_NUMBER_TABLE
130: , p8_a7 JTF_NUMBER_TABLE
131: , p8_a8 JTF_VARCHAR2_TABLE_100
132: , p8_a9 JTF_VARCHAR2_TABLE_100
133: , x_fee_id out nocopy NUMBER
134: , x_return_status out nocopy VARCHAR2
135: , x_msg_count out nocopy NUMBER

Line 132: , p8_a9 JTF_VARCHAR2_TABLE_100

128: , p8_a5 JTF_NUMBER_TABLE
129: , p8_a6 JTF_NUMBER_TABLE
130: , p8_a7 JTF_NUMBER_TABLE
131: , p8_a8 JTF_VARCHAR2_TABLE_100
132: , p8_a9 JTF_VARCHAR2_TABLE_100
133: , x_fee_id out nocopy NUMBER
134: , x_return_status out nocopy VARCHAR2
135: , x_msg_count out nocopy NUMBER
136: , x_msg_data out nocopy VARCHAR2

Line 232: , p4_a2 JTF_VARCHAR2_TABLE_100

228: , p3_a38 NUMBER
229: , p3_a39 VARCHAR2
230: , p4_a0 JTF_NUMBER_TABLE
231: , p4_a1 JTF_NUMBER_TABLE
232: , p4_a2 JTF_VARCHAR2_TABLE_100
233: , p4_a3 JTF_NUMBER_TABLE
234: , p4_a4 JTF_VARCHAR2_TABLE_100
235: , p4_a5 JTF_NUMBER_TABLE
236: , p4_a6 JTF_NUMBER_TABLE

Line 234: , p4_a4 JTF_VARCHAR2_TABLE_100

230: , p4_a0 JTF_NUMBER_TABLE
231: , p4_a1 JTF_NUMBER_TABLE
232: , p4_a2 JTF_VARCHAR2_TABLE_100
233: , p4_a3 JTF_NUMBER_TABLE
234: , p4_a4 JTF_VARCHAR2_TABLE_100
235: , p4_a5 JTF_NUMBER_TABLE
236: , p4_a6 JTF_NUMBER_TABLE
237: , p4_a7 JTF_VARCHAR2_TABLE_300
238: , p4_a8 JTF_VARCHAR2_TABLE_2000

Line 240: , p4_a10 JTF_VARCHAR2_TABLE_100

236: , p4_a6 JTF_NUMBER_TABLE
237: , p4_a7 JTF_VARCHAR2_TABLE_300
238: , p4_a8 JTF_VARCHAR2_TABLE_2000
239: , p4_a9 JTF_VARCHAR2_TABLE_2000
240: , p4_a10 JTF_VARCHAR2_TABLE_100
241: , p4_a11 JTF_NUMBER_TABLE
242: , p5_a0 VARCHAR2
243: , p5_a1 NUMBER
244: , p5_a2 VARCHAR2

Line 264: , p6_a8 JTF_VARCHAR2_TABLE_100

260: , p6_a4 JTF_NUMBER_TABLE
261: , p6_a5 JTF_NUMBER_TABLE
262: , p6_a6 JTF_NUMBER_TABLE
263: , p6_a7 JTF_NUMBER_TABLE
264: , p6_a8 JTF_VARCHAR2_TABLE_100
265: , p6_a9 JTF_VARCHAR2_TABLE_100
266: , p7_a0 VARCHAR2
267: , p7_a1 NUMBER
268: , p7_a2 VARCHAR2

Line 265: , p6_a9 JTF_VARCHAR2_TABLE_100

261: , p6_a5 JTF_NUMBER_TABLE
262: , p6_a6 JTF_NUMBER_TABLE
263: , p6_a7 JTF_NUMBER_TABLE
264: , p6_a8 JTF_VARCHAR2_TABLE_100
265: , p6_a9 JTF_VARCHAR2_TABLE_100
266: , p7_a0 VARCHAR2
267: , p7_a1 NUMBER
268: , p7_a2 VARCHAR2
269: , p7_a3 VARCHAR2

Line 288: , p8_a8 JTF_VARCHAR2_TABLE_100

284: , p8_a4 JTF_NUMBER_TABLE
285: , p8_a5 JTF_NUMBER_TABLE
286: , p8_a6 JTF_NUMBER_TABLE
287: , p8_a7 JTF_NUMBER_TABLE
288: , p8_a8 JTF_VARCHAR2_TABLE_100
289: , p8_a9 JTF_VARCHAR2_TABLE_100
290: , x_return_status out nocopy VARCHAR2
291: , x_msg_count out nocopy NUMBER
292: , x_msg_data out nocopy VARCHAR2

Line 289: , p8_a9 JTF_VARCHAR2_TABLE_100

285: , p8_a5 JTF_NUMBER_TABLE
286: , p8_a6 JTF_NUMBER_TABLE
287: , p8_a7 JTF_NUMBER_TABLE
288: , p8_a8 JTF_VARCHAR2_TABLE_100
289: , p8_a9 JTF_VARCHAR2_TABLE_100
290: , x_return_status out nocopy VARCHAR2
291: , x_msg_count out nocopy NUMBER
292: , x_msg_data out nocopy VARCHAR2
293: );

Line 340: , p5_a2 JTF_VARCHAR2_TABLE_100

336: , p4_a38 NUMBER
337: , p4_a39 VARCHAR2
338: , p5_a0 JTF_NUMBER_TABLE
339: , p5_a1 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
343: , p5_a5 JTF_NUMBER_TABLE
344: , p5_a6 JTF_NUMBER_TABLE

Line 342: , p5_a4 JTF_VARCHAR2_TABLE_100

338: , p5_a0 JTF_NUMBER_TABLE
339: , p5_a1 JTF_NUMBER_TABLE
340: , p5_a2 JTF_VARCHAR2_TABLE_100
341: , p5_a3 JTF_NUMBER_TABLE
342: , p5_a4 JTF_VARCHAR2_TABLE_100
343: , p5_a5 JTF_NUMBER_TABLE
344: , p5_a6 JTF_NUMBER_TABLE
345: , p5_a7 JTF_VARCHAR2_TABLE_300
346: , p5_a8 JTF_VARCHAR2_TABLE_2000

Line 348: , p5_a10 JTF_VARCHAR2_TABLE_100

344: , p5_a6 JTF_NUMBER_TABLE
345: , p5_a7 JTF_VARCHAR2_TABLE_300
346: , p5_a8 JTF_VARCHAR2_TABLE_2000
347: , p5_a9 JTF_VARCHAR2_TABLE_2000
348: , p5_a10 JTF_VARCHAR2_TABLE_100
349: , p5_a11 JTF_NUMBER_TABLE
350: , p6_a0 VARCHAR2
351: , p6_a1 NUMBER
352: , p6_a2 VARCHAR2

Line 372: , p7_a8 JTF_VARCHAR2_TABLE_100

368: , p7_a4 JTF_NUMBER_TABLE
369: , p7_a5 JTF_NUMBER_TABLE
370: , p7_a6 JTF_NUMBER_TABLE
371: , p7_a7 JTF_NUMBER_TABLE
372: , p7_a8 JTF_VARCHAR2_TABLE_100
373: , p7_a9 JTF_VARCHAR2_TABLE_100
374: , p8_a0 VARCHAR2
375: , p8_a1 NUMBER
376: , p8_a2 VARCHAR2

Line 373: , p7_a9 JTF_VARCHAR2_TABLE_100

369: , p7_a5 JTF_NUMBER_TABLE
370: , p7_a6 JTF_NUMBER_TABLE
371: , p7_a7 JTF_NUMBER_TABLE
372: , p7_a8 JTF_VARCHAR2_TABLE_100
373: , p7_a9 JTF_VARCHAR2_TABLE_100
374: , p8_a0 VARCHAR2
375: , p8_a1 NUMBER
376: , p8_a2 VARCHAR2
377: , p8_a3 VARCHAR2

Line 396: , p9_a8 JTF_VARCHAR2_TABLE_100

392: , p9_a4 JTF_NUMBER_TABLE
393: , p9_a5 JTF_NUMBER_TABLE
394: , p9_a6 JTF_NUMBER_TABLE
395: , p9_a7 JTF_NUMBER_TABLE
396: , p9_a8 JTF_VARCHAR2_TABLE_100
397: , p9_a9 JTF_VARCHAR2_TABLE_100
398: , x_fee_id out nocopy NUMBER
399: , x_return_status out nocopy VARCHAR2
400: , x_msg_count out nocopy NUMBER

Line 397: , p9_a9 JTF_VARCHAR2_TABLE_100

393: , p9_a5 JTF_NUMBER_TABLE
394: , p9_a6 JTF_NUMBER_TABLE
395: , p9_a7 JTF_NUMBER_TABLE
396: , p9_a8 JTF_VARCHAR2_TABLE_100
397: , p9_a9 JTF_VARCHAR2_TABLE_100
398: , x_fee_id out nocopy NUMBER
399: , x_return_status out nocopy VARCHAR2
400: , x_msg_count out nocopy NUMBER
401: , x_msg_data out nocopy VARCHAR2