DBA Data[Home] [Help]

APPS.OKL_INR_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okl_inr_pvt_w as
2: /* $Header: OKLIINRS.pls 120.1 2005/07/13 09:28:18 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_inr_pvt.inr_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: OKLIINRS.pls 120.1 2005/07/13 09:28:18 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_inr_pvt.inr_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_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 16: , a13 JTF_VARCHAR2_TABLE_100

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500

Line 39: , a1 out nocopy JTF_VARCHAR2_TABLE_100

35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p2(t okl_inr_pvt.inr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_VARCHAR2_TABLE_100
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_NUMBER_TABLE

Line 41: , a3 out nocopy JTF_VARCHAR2_TABLE_100

37: );
38: procedure rosetta_table_copy_out_p2(t okl_inr_pvt.inr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_VARCHAR2_TABLE_100
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_NUMBER_TABLE
45: , a7 out nocopy JTF_NUMBER_TABLE

Line 51: , a13 out nocopy JTF_VARCHAR2_TABLE_100

47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_DATE_TABLE
49: , a11 out nocopy JTF_DATE_TABLE
50: , a12 out nocopy JTF_NUMBER_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
52: , a14 out nocopy JTF_VARCHAR2_TABLE_500
53: , a15 out nocopy JTF_VARCHAR2_TABLE_500
54: , a16 out nocopy JTF_VARCHAR2_TABLE_500
55: , a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 76: , a2 JTF_VARCHAR2_TABLE_100

72: );
73:
74: procedure rosetta_table_copy_in_p5(t out nocopy okl_inr_pvt.inrv_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_100
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE
80: , a6 JTF_NUMBER_TABLE

Line 78: , a4 JTF_VARCHAR2_TABLE_100

74: procedure rosetta_table_copy_in_p5(t out nocopy okl_inr_pvt.inrv_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_100
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_NUMBER_TABLE
80: , a6 JTF_NUMBER_TABLE
81: , a7 JTF_NUMBER_TABLE
82: , a8 JTF_NUMBER_TABLE

Line 87: , a13 JTF_VARCHAR2_TABLE_100

83: , a9 JTF_NUMBER_TABLE
84: , a10 JTF_DATE_TABLE
85: , a11 JTF_DATE_TABLE
86: , a12 JTF_NUMBER_TABLE
87: , a13 JTF_VARCHAR2_TABLE_100
88: , a14 JTF_VARCHAR2_TABLE_500
89: , a15 JTF_VARCHAR2_TABLE_500
90: , a16 JTF_VARCHAR2_TABLE_500
91: , a17 JTF_VARCHAR2_TABLE_500

Line 111: , a2 out nocopy JTF_VARCHAR2_TABLE_100

107: , a33 JTF_NUMBER_TABLE
108: );
109: procedure rosetta_table_copy_out_p5(t okl_inr_pvt.inrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , a3 out nocopy JTF_NUMBER_TABLE
113: , a4 out nocopy JTF_VARCHAR2_TABLE_100
114: , a5 out nocopy JTF_NUMBER_TABLE
115: , a6 out nocopy JTF_NUMBER_TABLE

Line 113: , a4 out nocopy JTF_VARCHAR2_TABLE_100

109: procedure rosetta_table_copy_out_p5(t okl_inr_pvt.inrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , a3 out nocopy JTF_NUMBER_TABLE
113: , a4 out nocopy JTF_VARCHAR2_TABLE_100
114: , a5 out nocopy JTF_NUMBER_TABLE
115: , a6 out nocopy JTF_NUMBER_TABLE
116: , a7 out nocopy JTF_NUMBER_TABLE
117: , a8 out nocopy JTF_NUMBER_TABLE

Line 122: , a13 out nocopy JTF_VARCHAR2_TABLE_100

118: , a9 out nocopy JTF_NUMBER_TABLE
119: , a10 out nocopy JTF_DATE_TABLE
120: , a11 out nocopy JTF_DATE_TABLE
121: , a12 out nocopy JTF_NUMBER_TABLE
122: , a13 out nocopy JTF_VARCHAR2_TABLE_100
123: , a14 out nocopy JTF_VARCHAR2_TABLE_500
124: , a15 out nocopy JTF_VARCHAR2_TABLE_500
125: , a16 out nocopy JTF_VARCHAR2_TABLE_500
126: , a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 226: , p5_a2 JTF_VARCHAR2_TABLE_100

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

Line 228: , p5_a4 JTF_VARCHAR2_TABLE_100

224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_NUMBER_TABLE
230: , p5_a6 JTF_NUMBER_TABLE
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE

Line 237: , p5_a13 JTF_VARCHAR2_TABLE_100

233: , p5_a9 JTF_NUMBER_TABLE
234: , p5_a10 JTF_DATE_TABLE
235: , p5_a11 JTF_DATE_TABLE
236: , p5_a12 JTF_NUMBER_TABLE
237: , p5_a13 JTF_VARCHAR2_TABLE_100
238: , p5_a14 JTF_VARCHAR2_TABLE_500
239: , p5_a15 JTF_VARCHAR2_TABLE_500
240: , p5_a16 JTF_VARCHAR2_TABLE_500
241: , p5_a17 JTF_VARCHAR2_TABLE_500

Line 260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

256: , p5_a32 JTF_DATE_TABLE
257: , p5_a33 JTF_NUMBER_TABLE
258: , p6_a0 out nocopy JTF_NUMBER_TABLE
259: , p6_a1 out nocopy JTF_NUMBER_TABLE
260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a3 out nocopy JTF_NUMBER_TABLE
262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a5 out nocopy JTF_NUMBER_TABLE
264: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

258: , p6_a0 out nocopy JTF_NUMBER_TABLE
259: , p6_a1 out nocopy JTF_NUMBER_TABLE
260: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a3 out nocopy JTF_NUMBER_TABLE
262: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a5 out nocopy JTF_NUMBER_TABLE
264: , p6_a6 out nocopy JTF_NUMBER_TABLE
265: , p6_a7 out nocopy JTF_NUMBER_TABLE
266: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 271: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

267: , p6_a9 out nocopy JTF_NUMBER_TABLE
268: , p6_a10 out nocopy JTF_DATE_TABLE
269: , p6_a11 out nocopy JTF_DATE_TABLE
270: , p6_a12 out nocopy JTF_NUMBER_TABLE
271: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
272: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
273: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
274: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
275: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 340: , p5_a2 JTF_VARCHAR2_TABLE_100

336: , x_msg_count out nocopy NUMBER
337: , x_msg_data out nocopy 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_NUMBER_TABLE
346: , p5_a8 JTF_NUMBER_TABLE

Line 351: , p5_a13 JTF_VARCHAR2_TABLE_100

347: , p5_a9 JTF_NUMBER_TABLE
348: , p5_a10 JTF_DATE_TABLE
349: , p5_a11 JTF_DATE_TABLE
350: , p5_a12 JTF_NUMBER_TABLE
351: , p5_a13 JTF_VARCHAR2_TABLE_100
352: , p5_a14 JTF_VARCHAR2_TABLE_500
353: , p5_a15 JTF_VARCHAR2_TABLE_500
354: , p5_a16 JTF_VARCHAR2_TABLE_500
355: , p5_a17 JTF_VARCHAR2_TABLE_500

Line 454: , p5_a2 JTF_VARCHAR2_TABLE_100

450: , x_msg_count out nocopy NUMBER
451: , x_msg_data out nocopy VARCHAR2
452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_VARCHAR2_TABLE_100
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_NUMBER_TABLE
458: , p5_a6 JTF_NUMBER_TABLE

Line 456: , p5_a4 JTF_VARCHAR2_TABLE_100

452: , p5_a0 JTF_NUMBER_TABLE
453: , p5_a1 JTF_NUMBER_TABLE
454: , p5_a2 JTF_VARCHAR2_TABLE_100
455: , p5_a3 JTF_NUMBER_TABLE
456: , p5_a4 JTF_VARCHAR2_TABLE_100
457: , p5_a5 JTF_NUMBER_TABLE
458: , p5_a6 JTF_NUMBER_TABLE
459: , p5_a7 JTF_NUMBER_TABLE
460: , p5_a8 JTF_NUMBER_TABLE

Line 465: , p5_a13 JTF_VARCHAR2_TABLE_100

461: , p5_a9 JTF_NUMBER_TABLE
462: , p5_a10 JTF_DATE_TABLE
463: , p5_a11 JTF_DATE_TABLE
464: , p5_a12 JTF_NUMBER_TABLE
465: , p5_a13 JTF_VARCHAR2_TABLE_100
466: , p5_a14 JTF_VARCHAR2_TABLE_500
467: , p5_a15 JTF_VARCHAR2_TABLE_500
468: , p5_a16 JTF_VARCHAR2_TABLE_500
469: , p5_a17 JTF_VARCHAR2_TABLE_500

Line 488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

484: , p5_a32 JTF_DATE_TABLE
485: , p5_a33 JTF_NUMBER_TABLE
486: , p6_a0 out nocopy JTF_NUMBER_TABLE
487: , p6_a1 out nocopy JTF_NUMBER_TABLE
488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a3 out nocopy JTF_NUMBER_TABLE
490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a5 out nocopy JTF_NUMBER_TABLE
492: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

486: , p6_a0 out nocopy JTF_NUMBER_TABLE
487: , p6_a1 out nocopy JTF_NUMBER_TABLE
488: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
489: , p6_a3 out nocopy JTF_NUMBER_TABLE
490: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a5 out nocopy JTF_NUMBER_TABLE
492: , p6_a6 out nocopy JTF_NUMBER_TABLE
493: , p6_a7 out nocopy JTF_NUMBER_TABLE
494: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 499: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

495: , p6_a9 out nocopy JTF_NUMBER_TABLE
496: , p6_a10 out nocopy JTF_DATE_TABLE
497: , p6_a11 out nocopy JTF_DATE_TABLE
498: , p6_a12 out nocopy JTF_NUMBER_TABLE
499: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
500: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
501: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
502: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
503: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 568: , p5_a2 JTF_VARCHAR2_TABLE_100

564: , x_msg_count out nocopy NUMBER
565: , x_msg_data out nocopy VARCHAR2
566: , p5_a0 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_VARCHAR2_TABLE_100
569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_100
571: , p5_a5 JTF_NUMBER_TABLE
572: , p5_a6 JTF_NUMBER_TABLE

Line 570: , p5_a4 JTF_VARCHAR2_TABLE_100

566: , p5_a0 JTF_NUMBER_TABLE
567: , p5_a1 JTF_NUMBER_TABLE
568: , p5_a2 JTF_VARCHAR2_TABLE_100
569: , p5_a3 JTF_NUMBER_TABLE
570: , p5_a4 JTF_VARCHAR2_TABLE_100
571: , p5_a5 JTF_NUMBER_TABLE
572: , p5_a6 JTF_NUMBER_TABLE
573: , p5_a7 JTF_NUMBER_TABLE
574: , p5_a8 JTF_NUMBER_TABLE

Line 579: , p5_a13 JTF_VARCHAR2_TABLE_100

575: , p5_a9 JTF_NUMBER_TABLE
576: , p5_a10 JTF_DATE_TABLE
577: , p5_a11 JTF_DATE_TABLE
578: , p5_a12 JTF_NUMBER_TABLE
579: , p5_a13 JTF_VARCHAR2_TABLE_100
580: , p5_a14 JTF_VARCHAR2_TABLE_500
581: , p5_a15 JTF_VARCHAR2_TABLE_500
582: , p5_a16 JTF_VARCHAR2_TABLE_500
583: , p5_a17 JTF_VARCHAR2_TABLE_500

Line 648: , p5_a2 JTF_VARCHAR2_TABLE_100

644: , x_msg_count out nocopy NUMBER
645: , x_msg_data out nocopy VARCHAR2
646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_VARCHAR2_TABLE_100
649: , p5_a3 JTF_NUMBER_TABLE
650: , p5_a4 JTF_VARCHAR2_TABLE_100
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_NUMBER_TABLE

Line 650: , p5_a4 JTF_VARCHAR2_TABLE_100

646: , p5_a0 JTF_NUMBER_TABLE
647: , p5_a1 JTF_NUMBER_TABLE
648: , p5_a2 JTF_VARCHAR2_TABLE_100
649: , p5_a3 JTF_NUMBER_TABLE
650: , p5_a4 JTF_VARCHAR2_TABLE_100
651: , p5_a5 JTF_NUMBER_TABLE
652: , p5_a6 JTF_NUMBER_TABLE
653: , p5_a7 JTF_NUMBER_TABLE
654: , p5_a8 JTF_NUMBER_TABLE

Line 659: , p5_a13 JTF_VARCHAR2_TABLE_100

655: , p5_a9 JTF_NUMBER_TABLE
656: , p5_a10 JTF_DATE_TABLE
657: , p5_a11 JTF_DATE_TABLE
658: , p5_a12 JTF_NUMBER_TABLE
659: , p5_a13 JTF_VARCHAR2_TABLE_100
660: , p5_a14 JTF_VARCHAR2_TABLE_500
661: , p5_a15 JTF_VARCHAR2_TABLE_500
662: , p5_a16 JTF_VARCHAR2_TABLE_500
663: , p5_a17 JTF_VARCHAR2_TABLE_500