DBA Data[Home] [Help]

APPS.OKL_AUL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okl_aul_pvt_w as
2: /* $Header: OKLIAULS.pls 120.1 2005/07/07 12:47:20 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_aul_pvt.aul_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLIAULS.pls 120.1 2005/07/07 12:47:20 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_aul_pvt.aul_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_500

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 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_aul_pvt.aul_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_VARCHAR2_TABLE_100
36: , a4 out nocopy JTF_NUMBER_TABLE
37: , a5 out nocopy JTF_NUMBER_TABLE

Line 35: , a3 out nocopy JTF_VARCHAR2_TABLE_100

31: );
32: procedure rosetta_table_copy_out_p2(t okl_aul_pvt.aul_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_VARCHAR2_TABLE_100
36: , a4 out nocopy JTF_NUMBER_TABLE
37: , a5 out nocopy JTF_NUMBER_TABLE
38: , a6 out nocopy JTF_VARCHAR2_TABLE_100
39: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 38: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 64: , a2 JTF_VARCHAR2_TABLE_100

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

Line 65: , a3 JTF_VARCHAR2_TABLE_100

61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_aul_pvt.aulv_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE
64: , a2 JTF_VARCHAR2_TABLE_100
65: , a3 JTF_VARCHAR2_TABLE_100
66: , a4 JTF_NUMBER_TABLE
67: , a5 JTF_VARCHAR2_TABLE_100
68: , a6 JTF_VARCHAR2_TABLE_500
69: , a7 JTF_VARCHAR2_TABLE_500

Line 67: , a5 JTF_VARCHAR2_TABLE_100

63: , a1 JTF_NUMBER_TABLE
64: , a2 JTF_VARCHAR2_TABLE_100
65: , a3 JTF_VARCHAR2_TABLE_100
66: , a4 JTF_NUMBER_TABLE
67: , a5 JTF_VARCHAR2_TABLE_100
68: , a6 JTF_VARCHAR2_TABLE_500
69: , a7 JTF_VARCHAR2_TABLE_500
70: , a8 JTF_VARCHAR2_TABLE_500
71: , a9 JTF_VARCHAR2_TABLE_500

Line 93: , a2 out nocopy JTF_VARCHAR2_TABLE_100

89: , a27 JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_aul_pvt.aulv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 94: , a3 out nocopy JTF_VARCHAR2_TABLE_100

90: );
91: procedure rosetta_table_copy_out_p5(t okl_aul_pvt.aulv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_VARCHAR2_TABLE_500
98: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 96: , a5 out nocopy JTF_VARCHAR2_TABLE_100

92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: , a4 out nocopy JTF_NUMBER_TABLE
96: , a5 out nocopy JTF_VARCHAR2_TABLE_100
97: , a6 out nocopy JTF_VARCHAR2_TABLE_500
98: , a7 out nocopy JTF_VARCHAR2_TABLE_500
99: , a8 out nocopy JTF_VARCHAR2_TABLE_500
100: , a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 190: , p5_a2 JTF_VARCHAR2_TABLE_100

186: , x_msg_count out nocopy NUMBER
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_VARCHAR2_TABLE_100
191: , p5_a3 JTF_VARCHAR2_TABLE_100
192: , p5_a4 JTF_NUMBER_TABLE
193: , p5_a5 JTF_VARCHAR2_TABLE_100
194: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 191: , p5_a3 JTF_VARCHAR2_TABLE_100

187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_VARCHAR2_TABLE_100
191: , p5_a3 JTF_VARCHAR2_TABLE_100
192: , p5_a4 JTF_NUMBER_TABLE
193: , p5_a5 JTF_VARCHAR2_TABLE_100
194: , p5_a6 JTF_VARCHAR2_TABLE_500
195: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 193: , p5_a5 JTF_VARCHAR2_TABLE_100

189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_VARCHAR2_TABLE_100
191: , p5_a3 JTF_VARCHAR2_TABLE_100
192: , p5_a4 JTF_NUMBER_TABLE
193: , p5_a5 JTF_VARCHAR2_TABLE_100
194: , p5_a6 JTF_VARCHAR2_TABLE_500
195: , p5_a7 JTF_VARCHAR2_TABLE_500
196: , p5_a8 JTF_VARCHAR2_TABLE_500
197: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

214: , p5_a26 JTF_DATE_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
220: , p6_a4 out nocopy JTF_NUMBER_TABLE
221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
220: , p6_a4 out nocopy JTF_NUMBER_TABLE
221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
223: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
219: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
220: , p6_a4 out nocopy JTF_NUMBER_TABLE
221: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
223: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
224: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
225: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 286: , p5_a2 JTF_VARCHAR2_TABLE_100

282: , x_msg_count out nocopy NUMBER
283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_VARCHAR2_TABLE_100
287: , p5_a3 JTF_VARCHAR2_TABLE_100
288: , p5_a4 JTF_NUMBER_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 287: , p5_a3 JTF_VARCHAR2_TABLE_100

283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_VARCHAR2_TABLE_100
287: , p5_a3 JTF_VARCHAR2_TABLE_100
288: , p5_a4 JTF_NUMBER_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_VARCHAR2_TABLE_500
291: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 289: , p5_a5 JTF_VARCHAR2_TABLE_100

285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_VARCHAR2_TABLE_100
287: , p5_a3 JTF_VARCHAR2_TABLE_100
288: , p5_a4 JTF_NUMBER_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_VARCHAR2_TABLE_500
291: , p5_a7 JTF_VARCHAR2_TABLE_500
292: , p5_a8 JTF_VARCHAR2_TABLE_500
293: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 382: , p5_a2 JTF_VARCHAR2_TABLE_100

378: , x_msg_count out nocopy NUMBER
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_VARCHAR2_TABLE_100
383: , p5_a3 JTF_VARCHAR2_TABLE_100
384: , p5_a4 JTF_NUMBER_TABLE
385: , p5_a5 JTF_VARCHAR2_TABLE_100
386: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 383: , p5_a3 JTF_VARCHAR2_TABLE_100

379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_VARCHAR2_TABLE_100
383: , p5_a3 JTF_VARCHAR2_TABLE_100
384: , p5_a4 JTF_NUMBER_TABLE
385: , p5_a5 JTF_VARCHAR2_TABLE_100
386: , p5_a6 JTF_VARCHAR2_TABLE_500
387: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 385: , p5_a5 JTF_VARCHAR2_TABLE_100

381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_VARCHAR2_TABLE_100
383: , p5_a3 JTF_VARCHAR2_TABLE_100
384: , p5_a4 JTF_NUMBER_TABLE
385: , p5_a5 JTF_VARCHAR2_TABLE_100
386: , p5_a6 JTF_VARCHAR2_TABLE_500
387: , p5_a7 JTF_VARCHAR2_TABLE_500
388: , p5_a8 JTF_VARCHAR2_TABLE_500
389: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 410: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

406: , p5_a26 JTF_DATE_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a4 out nocopy JTF_NUMBER_TABLE
413: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 411: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a4 out nocopy JTF_NUMBER_TABLE
413: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
415: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 413: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a4 out nocopy JTF_NUMBER_TABLE
413: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
414: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
415: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
416: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
417: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 478: , p5_a2 JTF_VARCHAR2_TABLE_100

474: , x_msg_count out nocopy NUMBER
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_VARCHAR2_TABLE_100
479: , p5_a3 JTF_VARCHAR2_TABLE_100
480: , p5_a4 JTF_NUMBER_TABLE
481: , p5_a5 JTF_VARCHAR2_TABLE_100
482: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 479: , p5_a3 JTF_VARCHAR2_TABLE_100

475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_VARCHAR2_TABLE_100
479: , p5_a3 JTF_VARCHAR2_TABLE_100
480: , p5_a4 JTF_NUMBER_TABLE
481: , p5_a5 JTF_VARCHAR2_TABLE_100
482: , p5_a6 JTF_VARCHAR2_TABLE_500
483: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 481: , p5_a5 JTF_VARCHAR2_TABLE_100

477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_VARCHAR2_TABLE_100
479: , p5_a3 JTF_VARCHAR2_TABLE_100
480: , p5_a4 JTF_NUMBER_TABLE
481: , p5_a5 JTF_VARCHAR2_TABLE_100
482: , p5_a6 JTF_VARCHAR2_TABLE_500
483: , p5_a7 JTF_VARCHAR2_TABLE_500
484: , p5_a8 JTF_VARCHAR2_TABLE_500
485: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 546: , p5_a2 JTF_VARCHAR2_TABLE_100

542: , x_msg_count out nocopy NUMBER
543: , x_msg_data out nocopy VARCHAR2
544: , p5_a0 JTF_NUMBER_TABLE
545: , p5_a1 JTF_NUMBER_TABLE
546: , p5_a2 JTF_VARCHAR2_TABLE_100
547: , p5_a3 JTF_VARCHAR2_TABLE_100
548: , p5_a4 JTF_NUMBER_TABLE
549: , p5_a5 JTF_VARCHAR2_TABLE_100
550: , p5_a6 JTF_VARCHAR2_TABLE_500

Line 547: , p5_a3 JTF_VARCHAR2_TABLE_100

543: , x_msg_data out nocopy VARCHAR2
544: , p5_a0 JTF_NUMBER_TABLE
545: , p5_a1 JTF_NUMBER_TABLE
546: , p5_a2 JTF_VARCHAR2_TABLE_100
547: , p5_a3 JTF_VARCHAR2_TABLE_100
548: , p5_a4 JTF_NUMBER_TABLE
549: , p5_a5 JTF_VARCHAR2_TABLE_100
550: , p5_a6 JTF_VARCHAR2_TABLE_500
551: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 549: , p5_a5 JTF_VARCHAR2_TABLE_100

545: , p5_a1 JTF_NUMBER_TABLE
546: , p5_a2 JTF_VARCHAR2_TABLE_100
547: , p5_a3 JTF_VARCHAR2_TABLE_100
548: , p5_a4 JTF_NUMBER_TABLE
549: , p5_a5 JTF_VARCHAR2_TABLE_100
550: , p5_a6 JTF_VARCHAR2_TABLE_500
551: , p5_a7 JTF_VARCHAR2_TABLE_500
552: , p5_a8 JTF_VARCHAR2_TABLE_500
553: , p5_a9 JTF_VARCHAR2_TABLE_500