APPS.OKL_SPP_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 5: , a2 JTF_VARCHAR2_TABLE_200

1: package okl_spp_pvt_w as
2: /* $Header: OKLISPPS.pls 120.1 2005/07/15 07:38:49 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_spp_pvt.spp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_2000

Line 9: , a6 JTF_VARCHAR2_TABLE_2000

5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_200

Line 13: , a10 JTF_VARCHAR2_TABLE_200

9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_200
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_500
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_500

Line 38: , a2 out nocopy JTF_VARCHAR2_TABLE_200

34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_spp_pvt.spp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_200
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_DATE_TABLE
41: , a5 out nocopy JTF_DATE_TABLE
42: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 42: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

38: , a2 out nocopy JTF_VARCHAR2_TABLE_200
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_DATE_TABLE
41: , a5 out nocopy JTF_DATE_TABLE
42: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
43: , a7 out nocopy JTF_VARCHAR2_TABLE_100
44: , a8 out nocopy JTF_VARCHAR2_TABLE_100
45: , a9 out nocopy JTF_VARCHAR2_TABLE_100
46: , a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 46: , a10 out nocopy JTF_VARCHAR2_TABLE_200

42: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
43: , a7 out nocopy JTF_VARCHAR2_TABLE_100
44: , a8 out nocopy JTF_VARCHAR2_TABLE_100
45: , a9 out nocopy JTF_VARCHAR2_TABLE_100
46: , a10 out nocopy JTF_VARCHAR2_TABLE_200
47: , a11 out nocopy JTF_VARCHAR2_TABLE_100
48: , a12 out nocopy JTF_VARCHAR2_TABLE_500
49: , a13 out nocopy JTF_VARCHAR2_TABLE_500
50: , a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 72: , a2 JTF_VARCHAR2_TABLE_200

68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_spp_pvt.sppv_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: , a2 JTF_VARCHAR2_TABLE_200
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_DATE_TABLE
75: , a5 JTF_DATE_TABLE
76: , a6 JTF_VARCHAR2_TABLE_2000

Line 76: , a6 JTF_VARCHAR2_TABLE_2000

72: , a2 JTF_VARCHAR2_TABLE_200
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_DATE_TABLE
75: , a5 JTF_DATE_TABLE
76: , a6 JTF_VARCHAR2_TABLE_2000
77: , a7 JTF_VARCHAR2_TABLE_100
78: , a8 JTF_VARCHAR2_TABLE_100
79: , a9 JTF_VARCHAR2_TABLE_100
80: , a10 JTF_VARCHAR2_TABLE_200

Line 80: , a10 JTF_VARCHAR2_TABLE_200

76: , a6 JTF_VARCHAR2_TABLE_2000
77: , a7 JTF_VARCHAR2_TABLE_100
78: , a8 JTF_VARCHAR2_TABLE_100
79: , a9 JTF_VARCHAR2_TABLE_100
80: , a10 JTF_VARCHAR2_TABLE_200
81: , a11 JTF_VARCHAR2_TABLE_100
82: , a12 JTF_VARCHAR2_TABLE_500
83: , a13 JTF_VARCHAR2_TABLE_500
84: , a14 JTF_VARCHAR2_TABLE_500

Line 105: , a2 out nocopy JTF_VARCHAR2_TABLE_200

101: , a31 JTF_NUMBER_TABLE
102: );
103: procedure rosetta_table_copy_out_p5(t okl_spp_pvt.sppv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_200
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_DATE_TABLE
108: , a5 out nocopy JTF_DATE_TABLE
109: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 109: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

105: , a2 out nocopy JTF_VARCHAR2_TABLE_200
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_DATE_TABLE
108: , a5 out nocopy JTF_DATE_TABLE
109: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
110: , a7 out nocopy JTF_VARCHAR2_TABLE_100
111: , a8 out nocopy JTF_VARCHAR2_TABLE_100
112: , a9 out nocopy JTF_VARCHAR2_TABLE_100
113: , a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 113: , a10 out nocopy JTF_VARCHAR2_TABLE_200

109: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
110: , a7 out nocopy JTF_VARCHAR2_TABLE_100
111: , a8 out nocopy JTF_VARCHAR2_TABLE_100
112: , a9 out nocopy JTF_VARCHAR2_TABLE_100
113: , a10 out nocopy JTF_VARCHAR2_TABLE_200
114: , a11 out nocopy JTF_VARCHAR2_TABLE_100
115: , a12 out nocopy JTF_VARCHAR2_TABLE_500
116: , a13 out nocopy JTF_VARCHAR2_TABLE_500
117: , a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 214: , p5_a2 JTF_VARCHAR2_TABLE_200

210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_VARCHAR2_TABLE_200
215: , p5_a3 JTF_VARCHAR2_TABLE_100
216: , p5_a4 JTF_DATE_TABLE
217: , p5_a5 JTF_DATE_TABLE
218: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 218: , p5_a6 JTF_VARCHAR2_TABLE_2000

214: , p5_a2 JTF_VARCHAR2_TABLE_200
215: , p5_a3 JTF_VARCHAR2_TABLE_100
216: , p5_a4 JTF_DATE_TABLE
217: , p5_a5 JTF_DATE_TABLE
218: , p5_a6 JTF_VARCHAR2_TABLE_2000
219: , p5_a7 JTF_VARCHAR2_TABLE_100
220: , p5_a8 JTF_VARCHAR2_TABLE_100
221: , p5_a9 JTF_VARCHAR2_TABLE_100
222: , p5_a10 JTF_VARCHAR2_TABLE_200

Line 222: , p5_a10 JTF_VARCHAR2_TABLE_200

218: , p5_a6 JTF_VARCHAR2_TABLE_2000
219: , p5_a7 JTF_VARCHAR2_TABLE_100
220: , p5_a8 JTF_VARCHAR2_TABLE_100
221: , p5_a9 JTF_VARCHAR2_TABLE_100
222: , p5_a10 JTF_VARCHAR2_TABLE_200
223: , p5_a11 JTF_VARCHAR2_TABLE_100
224: , p5_a12 JTF_VARCHAR2_TABLE_500
225: , p5_a13 JTF_VARCHAR2_TABLE_500
226: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

242: , p5_a30 JTF_DATE_TABLE
243: , p5_a31 JTF_NUMBER_TABLE
244: , p6_a0 out nocopy JTF_NUMBER_TABLE
245: , p6_a1 out nocopy JTF_NUMBER_TABLE
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
247: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a4 out nocopy JTF_DATE_TABLE
249: , p6_a5 out nocopy JTF_DATE_TABLE
250: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 250: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
247: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a4 out nocopy JTF_DATE_TABLE
249: , p6_a5 out nocopy JTF_DATE_TABLE
250: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
251: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
252: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
254: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 254: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200

250: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
251: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
252: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
254: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
255: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
256: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
258: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 322: , p5_a2 JTF_VARCHAR2_TABLE_200

318: , x_msg_count out nocopy NUMBER
319: , x_msg_data out nocopy VARCHAR2
320: , p5_a0 JTF_NUMBER_TABLE
321: , p5_a1 JTF_NUMBER_TABLE
322: , p5_a2 JTF_VARCHAR2_TABLE_200
323: , p5_a3 JTF_VARCHAR2_TABLE_100
324: , p5_a4 JTF_DATE_TABLE
325: , p5_a5 JTF_DATE_TABLE
326: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 326: , p5_a6 JTF_VARCHAR2_TABLE_2000

322: , p5_a2 JTF_VARCHAR2_TABLE_200
323: , p5_a3 JTF_VARCHAR2_TABLE_100
324: , p5_a4 JTF_DATE_TABLE
325: , p5_a5 JTF_DATE_TABLE
326: , p5_a6 JTF_VARCHAR2_TABLE_2000
327: , p5_a7 JTF_VARCHAR2_TABLE_100
328: , p5_a8 JTF_VARCHAR2_TABLE_100
329: , p5_a9 JTF_VARCHAR2_TABLE_100
330: , p5_a10 JTF_VARCHAR2_TABLE_200

Line 330: , p5_a10 JTF_VARCHAR2_TABLE_200

326: , p5_a6 JTF_VARCHAR2_TABLE_2000
327: , p5_a7 JTF_VARCHAR2_TABLE_100
328: , p5_a8 JTF_VARCHAR2_TABLE_100
329: , p5_a9 JTF_VARCHAR2_TABLE_100
330: , p5_a10 JTF_VARCHAR2_TABLE_200
331: , p5_a11 JTF_VARCHAR2_TABLE_100
332: , p5_a12 JTF_VARCHAR2_TABLE_500
333: , p5_a13 JTF_VARCHAR2_TABLE_500
334: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 430: , p5_a2 JTF_VARCHAR2_TABLE_200

426: , x_msg_count out nocopy NUMBER
427: , x_msg_data out nocopy VARCHAR2
428: , p5_a0 JTF_NUMBER_TABLE
429: , p5_a1 JTF_NUMBER_TABLE
430: , p5_a2 JTF_VARCHAR2_TABLE_200
431: , p5_a3 JTF_VARCHAR2_TABLE_100
432: , p5_a4 JTF_DATE_TABLE
433: , p5_a5 JTF_DATE_TABLE
434: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 434: , p5_a6 JTF_VARCHAR2_TABLE_2000

430: , p5_a2 JTF_VARCHAR2_TABLE_200
431: , p5_a3 JTF_VARCHAR2_TABLE_100
432: , p5_a4 JTF_DATE_TABLE
433: , p5_a5 JTF_DATE_TABLE
434: , p5_a6 JTF_VARCHAR2_TABLE_2000
435: , p5_a7 JTF_VARCHAR2_TABLE_100
436: , p5_a8 JTF_VARCHAR2_TABLE_100
437: , p5_a9 JTF_VARCHAR2_TABLE_100
438: , p5_a10 JTF_VARCHAR2_TABLE_200

Line 438: , p5_a10 JTF_VARCHAR2_TABLE_200

434: , p5_a6 JTF_VARCHAR2_TABLE_2000
435: , p5_a7 JTF_VARCHAR2_TABLE_100
436: , p5_a8 JTF_VARCHAR2_TABLE_100
437: , p5_a9 JTF_VARCHAR2_TABLE_100
438: , p5_a10 JTF_VARCHAR2_TABLE_200
439: , p5_a11 JTF_VARCHAR2_TABLE_100
440: , p5_a12 JTF_VARCHAR2_TABLE_500
441: , p5_a13 JTF_VARCHAR2_TABLE_500
442: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 462: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

458: , p5_a30 JTF_DATE_TABLE
459: , p5_a31 JTF_NUMBER_TABLE
460: , p6_a0 out nocopy JTF_NUMBER_TABLE
461: , p6_a1 out nocopy JTF_NUMBER_TABLE
462: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_DATE_TABLE
465: , p6_a5 out nocopy JTF_DATE_TABLE
466: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 466: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

462: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_DATE_TABLE
465: , p6_a5 out nocopy JTF_DATE_TABLE
466: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
467: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
470: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 470: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200

466: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
467: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
470: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_200
471: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
472: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
473: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
474: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 538: , p5_a2 JTF_VARCHAR2_TABLE_200

534: , x_msg_count out nocopy NUMBER
535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 JTF_NUMBER_TABLE
537: , p5_a1 JTF_NUMBER_TABLE
538: , p5_a2 JTF_VARCHAR2_TABLE_200
539: , p5_a3 JTF_VARCHAR2_TABLE_100
540: , p5_a4 JTF_DATE_TABLE
541: , p5_a5 JTF_DATE_TABLE
542: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 542: , p5_a6 JTF_VARCHAR2_TABLE_2000

538: , p5_a2 JTF_VARCHAR2_TABLE_200
539: , p5_a3 JTF_VARCHAR2_TABLE_100
540: , p5_a4 JTF_DATE_TABLE
541: , p5_a5 JTF_DATE_TABLE
542: , p5_a6 JTF_VARCHAR2_TABLE_2000
543: , p5_a7 JTF_VARCHAR2_TABLE_100
544: , p5_a8 JTF_VARCHAR2_TABLE_100
545: , p5_a9 JTF_VARCHAR2_TABLE_100
546: , p5_a10 JTF_VARCHAR2_TABLE_200

Line 546: , p5_a10 JTF_VARCHAR2_TABLE_200

542: , p5_a6 JTF_VARCHAR2_TABLE_2000
543: , p5_a7 JTF_VARCHAR2_TABLE_100
544: , p5_a8 JTF_VARCHAR2_TABLE_100
545: , p5_a9 JTF_VARCHAR2_TABLE_100
546: , p5_a10 JTF_VARCHAR2_TABLE_200
547: , p5_a11 JTF_VARCHAR2_TABLE_100
548: , p5_a12 JTF_VARCHAR2_TABLE_500
549: , p5_a13 JTF_VARCHAR2_TABLE_500
550: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 614: , p5_a2 JTF_VARCHAR2_TABLE_200

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

Line 618: , p5_a6 JTF_VARCHAR2_TABLE_2000

614: , p5_a2 JTF_VARCHAR2_TABLE_200
615: , p5_a3 JTF_VARCHAR2_TABLE_100
616: , p5_a4 JTF_DATE_TABLE
617: , p5_a5 JTF_DATE_TABLE
618: , p5_a6 JTF_VARCHAR2_TABLE_2000
619: , p5_a7 JTF_VARCHAR2_TABLE_100
620: , p5_a8 JTF_VARCHAR2_TABLE_100
621: , p5_a9 JTF_VARCHAR2_TABLE_100
622: , p5_a10 JTF_VARCHAR2_TABLE_200

Line 622: , p5_a10 JTF_VARCHAR2_TABLE_200

618: , p5_a6 JTF_VARCHAR2_TABLE_2000
619: , p5_a7 JTF_VARCHAR2_TABLE_100
620: , p5_a8 JTF_VARCHAR2_TABLE_100
621: , p5_a9 JTF_VARCHAR2_TABLE_100
622: , p5_a10 JTF_VARCHAR2_TABLE_200
623: , p5_a11 JTF_VARCHAR2_TABLE_100
624: , p5_a12 JTF_VARCHAR2_TABLE_500
625: , p5_a13 JTF_VARCHAR2_TABLE_500
626: , p5_a14 JTF_VARCHAR2_TABLE_500