APPS.OKL_SVF_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okl_svf_pvt_w as
2: /* $Header: OKLISVFS.pls 120.1 2005/07/15 07:39:38 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_svf_pvt.svf_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500
14: , a11 JTF_VARCHAR2_TABLE_500

Line 33: , a1 out nocopy JTF_VARCHAR2_TABLE_100

29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_svf_pvt.svf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_DATE_TABLE
37: , a5 out nocopy JTF_DATE_TABLE

Line 39: , a7 out nocopy JTF_VARCHAR2_TABLE_100

35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_DATE_TABLE
37: , a5 out nocopy JTF_DATE_TABLE
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , a8 out nocopy JTF_VARCHAR2_TABLE_500
41: , a9 out nocopy JTF_VARCHAR2_TABLE_500
42: , a10 out nocopy JTF_VARCHAR2_TABLE_500
43: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 63: , a1 JTF_VARCHAR2_TABLE_100

59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_svf_pvt.okl_service_fees_tl_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_VARCHAR2_TABLE_100
64: , a2 JTF_VARCHAR2_TABLE_100
65: , a3 JTF_VARCHAR2_TABLE_100
66: , a4 JTF_VARCHAR2_TABLE_200
67: , a5 JTF_VARCHAR2_TABLE_2000

Line 64: , a2 JTF_VARCHAR2_TABLE_100

60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_svf_pvt.okl_service_fees_tl_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_VARCHAR2_TABLE_100
64: , a2 JTF_VARCHAR2_TABLE_100
65: , a3 JTF_VARCHAR2_TABLE_100
66: , a4 JTF_VARCHAR2_TABLE_200
67: , a5 JTF_VARCHAR2_TABLE_2000
68: , a6 JTF_NUMBER_TABLE

Line 65: , a3 JTF_VARCHAR2_TABLE_100

61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_svf_pvt.okl_service_fees_tl_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_VARCHAR2_TABLE_100
64: , a2 JTF_VARCHAR2_TABLE_100
65: , a3 JTF_VARCHAR2_TABLE_100
66: , a4 JTF_VARCHAR2_TABLE_200
67: , a5 JTF_VARCHAR2_TABLE_2000
68: , a6 JTF_NUMBER_TABLE
69: , a7 JTF_DATE_TABLE

Line 75: , a1 out nocopy JTF_VARCHAR2_TABLE_100

71: , a9 JTF_DATE_TABLE
72: , a10 JTF_NUMBER_TABLE
73: );
74: procedure rosetta_table_copy_out_p5(t okl_svf_pvt.okl_service_fees_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_VARCHAR2_TABLE_100
76: , a2 out nocopy JTF_VARCHAR2_TABLE_100
77: , a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , a4 out nocopy JTF_VARCHAR2_TABLE_200
79: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 76: , a2 out nocopy JTF_VARCHAR2_TABLE_100

72: , a10 JTF_NUMBER_TABLE
73: );
74: procedure rosetta_table_copy_out_p5(t okl_svf_pvt.okl_service_fees_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_VARCHAR2_TABLE_100
76: , a2 out nocopy JTF_VARCHAR2_TABLE_100
77: , a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , a4 out nocopy JTF_VARCHAR2_TABLE_200
79: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
80: , a6 out nocopy JTF_NUMBER_TABLE

Line 77: , a3 out nocopy JTF_VARCHAR2_TABLE_100

73: );
74: procedure rosetta_table_copy_out_p5(t okl_svf_pvt.okl_service_fees_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_VARCHAR2_TABLE_100
76: , a2 out nocopy JTF_VARCHAR2_TABLE_100
77: , a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , a4 out nocopy JTF_VARCHAR2_TABLE_200
79: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
80: , a6 out nocopy JTF_NUMBER_TABLE
81: , a7 out nocopy JTF_DATE_TABLE

Line 89: , a2 JTF_VARCHAR2_TABLE_100

85: );
86:
87: procedure rosetta_table_copy_in_p8(t out nocopy okl_svf_pvt.svfv_tbl_type, a0 JTF_NUMBER_TABLE
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_VARCHAR2_TABLE_100
90: , a3 JTF_VARCHAR2_TABLE_100
91: , a4 JTF_VARCHAR2_TABLE_200
92: , a5 JTF_VARCHAR2_TABLE_2000
93: , a6 JTF_NUMBER_TABLE

Line 90: , a3 JTF_VARCHAR2_TABLE_100

86:
87: procedure rosetta_table_copy_in_p8(t out nocopy okl_svf_pvt.svfv_tbl_type, a0 JTF_NUMBER_TABLE
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_VARCHAR2_TABLE_100
90: , a3 JTF_VARCHAR2_TABLE_100
91: , a4 JTF_VARCHAR2_TABLE_200
92: , a5 JTF_VARCHAR2_TABLE_2000
93: , a6 JTF_NUMBER_TABLE
94: , a7 JTF_DATE_TABLE

Line 97: , a10 JTF_VARCHAR2_TABLE_100

93: , a6 JTF_NUMBER_TABLE
94: , a7 JTF_DATE_TABLE
95: , a8 JTF_DATE_TABLE
96: , a9 JTF_NUMBER_TABLE
97: , a10 JTF_VARCHAR2_TABLE_100
98: , a11 JTF_VARCHAR2_TABLE_500
99: , a12 JTF_VARCHAR2_TABLE_500
100: , a13 JTF_VARCHAR2_TABLE_500
101: , a14 JTF_VARCHAR2_TABLE_500

Line 121: , a2 out nocopy JTF_VARCHAR2_TABLE_100

117: , a30 JTF_NUMBER_TABLE
118: );
119: procedure rosetta_table_copy_out_p8(t okl_svf_pvt.svfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_VARCHAR2_TABLE_100
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_200
124: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
125: , a6 out nocopy JTF_NUMBER_TABLE

Line 122: , a3 out nocopy JTF_VARCHAR2_TABLE_100

118: );
119: procedure rosetta_table_copy_out_p8(t okl_svf_pvt.svfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_VARCHAR2_TABLE_100
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_200
124: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_DATE_TABLE

Line 129: , a10 out nocopy JTF_VARCHAR2_TABLE_100

125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_DATE_TABLE
127: , a8 out nocopy JTF_DATE_TABLE
128: , a9 out nocopy JTF_NUMBER_TABLE
129: , a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , a11 out nocopy JTF_VARCHAR2_TABLE_500
131: , a12 out nocopy JTF_VARCHAR2_TABLE_500
132: , a13 out nocopy JTF_VARCHAR2_TABLE_500
133: , a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 227: , p5_a2 JTF_VARCHAR2_TABLE_100

223: , x_msg_count out nocopy NUMBER
224: , x_msg_data out nocopy VARCHAR2
225: , p5_a0 JTF_NUMBER_TABLE
226: , p5_a1 JTF_NUMBER_TABLE
227: , p5_a2 JTF_VARCHAR2_TABLE_100
228: , p5_a3 JTF_VARCHAR2_TABLE_100
229: , p5_a4 JTF_VARCHAR2_TABLE_200
230: , p5_a5 JTF_VARCHAR2_TABLE_2000
231: , p5_a6 JTF_NUMBER_TABLE

Line 228: , p5_a3 JTF_VARCHAR2_TABLE_100

224: , x_msg_data out nocopy VARCHAR2
225: , p5_a0 JTF_NUMBER_TABLE
226: , p5_a1 JTF_NUMBER_TABLE
227: , p5_a2 JTF_VARCHAR2_TABLE_100
228: , p5_a3 JTF_VARCHAR2_TABLE_100
229: , p5_a4 JTF_VARCHAR2_TABLE_200
230: , p5_a5 JTF_VARCHAR2_TABLE_2000
231: , p5_a6 JTF_NUMBER_TABLE
232: , p5_a7 JTF_DATE_TABLE

Line 235: , p5_a10 JTF_VARCHAR2_TABLE_100

231: , p5_a6 JTF_NUMBER_TABLE
232: , p5_a7 JTF_DATE_TABLE
233: , p5_a8 JTF_DATE_TABLE
234: , p5_a9 JTF_NUMBER_TABLE
235: , p5_a10 JTF_VARCHAR2_TABLE_100
236: , p5_a11 JTF_VARCHAR2_TABLE_500
237: , p5_a12 JTF_VARCHAR2_TABLE_500
238: , p5_a13 JTF_VARCHAR2_TABLE_500
239: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

254: , p5_a29 JTF_DATE_TABLE
255: , p5_a30 JTF_NUMBER_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
262: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 259: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

255: , p5_a30 JTF_NUMBER_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
262: , p6_a6 out nocopy JTF_NUMBER_TABLE
263: , p6_a7 out nocopy JTF_DATE_TABLE

Line 266: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

262: , p6_a6 out nocopy JTF_NUMBER_TABLE
263: , p6_a7 out nocopy JTF_DATE_TABLE
264: , p6_a8 out nocopy JTF_DATE_TABLE
265: , p6_a9 out nocopy JTF_NUMBER_TABLE
266: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
267: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
268: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
269: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 332: , p5_a2 JTF_VARCHAR2_TABLE_100

328: , x_msg_count out nocopy NUMBER
329: , x_msg_data out nocopy VARCHAR2
330: , p5_a0 JTF_NUMBER_TABLE
331: , p5_a1 JTF_NUMBER_TABLE
332: , p5_a2 JTF_VARCHAR2_TABLE_100
333: , p5_a3 JTF_VARCHAR2_TABLE_100
334: , p5_a4 JTF_VARCHAR2_TABLE_200
335: , p5_a5 JTF_VARCHAR2_TABLE_2000
336: , p5_a6 JTF_NUMBER_TABLE

Line 333: , p5_a3 JTF_VARCHAR2_TABLE_100

329: , x_msg_data out nocopy VARCHAR2
330: , p5_a0 JTF_NUMBER_TABLE
331: , p5_a1 JTF_NUMBER_TABLE
332: , p5_a2 JTF_VARCHAR2_TABLE_100
333: , p5_a3 JTF_VARCHAR2_TABLE_100
334: , p5_a4 JTF_VARCHAR2_TABLE_200
335: , p5_a5 JTF_VARCHAR2_TABLE_2000
336: , p5_a6 JTF_NUMBER_TABLE
337: , p5_a7 JTF_DATE_TABLE

Line 340: , p5_a10 JTF_VARCHAR2_TABLE_100

336: , p5_a6 JTF_NUMBER_TABLE
337: , p5_a7 JTF_DATE_TABLE
338: , p5_a8 JTF_DATE_TABLE
339: , p5_a9 JTF_NUMBER_TABLE
340: , p5_a10 JTF_VARCHAR2_TABLE_100
341: , p5_a11 JTF_VARCHAR2_TABLE_500
342: , p5_a12 JTF_VARCHAR2_TABLE_500
343: , p5_a13 JTF_VARCHAR2_TABLE_500
344: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 437: , p5_a2 JTF_VARCHAR2_TABLE_100

433: , x_msg_count out nocopy NUMBER
434: , x_msg_data out nocopy VARCHAR2
435: , p5_a0 JTF_NUMBER_TABLE
436: , p5_a1 JTF_NUMBER_TABLE
437: , p5_a2 JTF_VARCHAR2_TABLE_100
438: , p5_a3 JTF_VARCHAR2_TABLE_100
439: , p5_a4 JTF_VARCHAR2_TABLE_200
440: , p5_a5 JTF_VARCHAR2_TABLE_2000
441: , p5_a6 JTF_NUMBER_TABLE

Line 438: , p5_a3 JTF_VARCHAR2_TABLE_100

434: , x_msg_data out nocopy VARCHAR2
435: , p5_a0 JTF_NUMBER_TABLE
436: , p5_a1 JTF_NUMBER_TABLE
437: , p5_a2 JTF_VARCHAR2_TABLE_100
438: , p5_a3 JTF_VARCHAR2_TABLE_100
439: , p5_a4 JTF_VARCHAR2_TABLE_200
440: , p5_a5 JTF_VARCHAR2_TABLE_2000
441: , p5_a6 JTF_NUMBER_TABLE
442: , p5_a7 JTF_DATE_TABLE

Line 445: , p5_a10 JTF_VARCHAR2_TABLE_100

441: , p5_a6 JTF_NUMBER_TABLE
442: , p5_a7 JTF_DATE_TABLE
443: , p5_a8 JTF_DATE_TABLE
444: , p5_a9 JTF_NUMBER_TABLE
445: , p5_a10 JTF_VARCHAR2_TABLE_100
446: , p5_a11 JTF_VARCHAR2_TABLE_500
447: , p5_a12 JTF_VARCHAR2_TABLE_500
448: , p5_a13 JTF_VARCHAR2_TABLE_500
449: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 468: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p6_a0 out nocopy JTF_NUMBER_TABLE
467: , p6_a1 out nocopy JTF_NUMBER_TABLE
468: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
470: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
471: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
472: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 469: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

465: , p5_a30 JTF_NUMBER_TABLE
466: , p6_a0 out nocopy JTF_NUMBER_TABLE
467: , p6_a1 out nocopy JTF_NUMBER_TABLE
468: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
470: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
471: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
472: , p6_a6 out nocopy JTF_NUMBER_TABLE
473: , p6_a7 out nocopy JTF_DATE_TABLE

Line 476: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

472: , p6_a6 out nocopy JTF_NUMBER_TABLE
473: , p6_a7 out nocopy JTF_DATE_TABLE
474: , p6_a8 out nocopy JTF_DATE_TABLE
475: , p6_a9 out nocopy JTF_NUMBER_TABLE
476: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
477: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
478: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
479: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
480: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 542: , p5_a2 JTF_VARCHAR2_TABLE_100

538: , x_msg_count out nocopy NUMBER
539: , x_msg_data out nocopy VARCHAR2
540: , p5_a0 JTF_NUMBER_TABLE
541: , p5_a1 JTF_NUMBER_TABLE
542: , p5_a2 JTF_VARCHAR2_TABLE_100
543: , p5_a3 JTF_VARCHAR2_TABLE_100
544: , p5_a4 JTF_VARCHAR2_TABLE_200
545: , p5_a5 JTF_VARCHAR2_TABLE_2000
546: , p5_a6 JTF_NUMBER_TABLE

Line 543: , p5_a3 JTF_VARCHAR2_TABLE_100

539: , x_msg_data out nocopy VARCHAR2
540: , p5_a0 JTF_NUMBER_TABLE
541: , p5_a1 JTF_NUMBER_TABLE
542: , p5_a2 JTF_VARCHAR2_TABLE_100
543: , p5_a3 JTF_VARCHAR2_TABLE_100
544: , p5_a4 JTF_VARCHAR2_TABLE_200
545: , p5_a5 JTF_VARCHAR2_TABLE_2000
546: , p5_a6 JTF_NUMBER_TABLE
547: , p5_a7 JTF_DATE_TABLE

Line 550: , p5_a10 JTF_VARCHAR2_TABLE_100

546: , p5_a6 JTF_NUMBER_TABLE
547: , p5_a7 JTF_DATE_TABLE
548: , p5_a8 JTF_DATE_TABLE
549: , p5_a9 JTF_NUMBER_TABLE
550: , p5_a10 JTF_VARCHAR2_TABLE_100
551: , p5_a11 JTF_VARCHAR2_TABLE_500
552: , p5_a12 JTF_VARCHAR2_TABLE_500
553: , p5_a13 JTF_VARCHAR2_TABLE_500
554: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 616: , p5_a2 JTF_VARCHAR2_TABLE_100

612: , x_msg_count out nocopy NUMBER
613: , x_msg_data out nocopy VARCHAR2
614: , p5_a0 JTF_NUMBER_TABLE
615: , p5_a1 JTF_NUMBER_TABLE
616: , p5_a2 JTF_VARCHAR2_TABLE_100
617: , p5_a3 JTF_VARCHAR2_TABLE_100
618: , p5_a4 JTF_VARCHAR2_TABLE_200
619: , p5_a5 JTF_VARCHAR2_TABLE_2000
620: , p5_a6 JTF_NUMBER_TABLE

Line 617: , p5_a3 JTF_VARCHAR2_TABLE_100

613: , x_msg_data out nocopy VARCHAR2
614: , p5_a0 JTF_NUMBER_TABLE
615: , p5_a1 JTF_NUMBER_TABLE
616: , p5_a2 JTF_VARCHAR2_TABLE_100
617: , p5_a3 JTF_VARCHAR2_TABLE_100
618: , p5_a4 JTF_VARCHAR2_TABLE_200
619: , p5_a5 JTF_VARCHAR2_TABLE_2000
620: , p5_a6 JTF_NUMBER_TABLE
621: , p5_a7 JTF_DATE_TABLE

Line 624: , p5_a10 JTF_VARCHAR2_TABLE_100

620: , p5_a6 JTF_NUMBER_TABLE
621: , p5_a7 JTF_DATE_TABLE
622: , p5_a8 JTF_DATE_TABLE
623: , p5_a9 JTF_NUMBER_TABLE
624: , p5_a10 JTF_VARCHAR2_TABLE_100
625: , p5_a11 JTF_VARCHAR2_TABLE_500
626: , p5_a12 JTF_VARCHAR2_TABLE_500
627: , p5_a13 JTF_VARCHAR2_TABLE_500
628: , p5_a14 JTF_VARCHAR2_TABLE_500