DBA Data[Home] [Help]

APPS.OKL_CURE_REPORTS_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_cure_reports_pub_w AUTHID CURRENT_USER as
2: /* $Header: OKLUCRTS.pls 115.2 2003/10/07 18:00:15 pdevaraj noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cure_reports_pub.crtv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 10: , a7 JTF_VARCHAR2_TABLE_100

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

Line 13: , a10 JTF_VARCHAR2_TABLE_100

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

Line 44: , a2 out nocopy JTF_VARCHAR2_TABLE_100

40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_cure_reports_pub.crtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_200
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE

Line 49: , a7 out nocopy JTF_VARCHAR2_TABLE_100

45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_DATE_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE

Line 52: , a10 out nocopy JTF_VARCHAR2_TABLE_100

48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_VARCHAR2_TABLE_100
50: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
51: , a9 out nocopy JTF_DATE_TABLE
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE

Line 89: , p5_a2 JTF_VARCHAR2_TABLE_100

85: , x_msg_count out nocopy NUMBER
86: , x_msg_data out nocopy VARCHAR2
87: , p5_a0 JTF_NUMBER_TABLE
88: , p5_a1 JTF_VARCHAR2_TABLE_200
89: , p5_a2 JTF_VARCHAR2_TABLE_100
90: , p5_a3 JTF_DATE_TABLE
91: , p5_a4 JTF_NUMBER_TABLE
92: , p5_a5 JTF_NUMBER_TABLE
93: , p5_a6 JTF_NUMBER_TABLE

Line 94: , p5_a7 JTF_VARCHAR2_TABLE_100

90: , p5_a3 JTF_DATE_TABLE
91: , p5_a4 JTF_NUMBER_TABLE
92: , p5_a5 JTF_NUMBER_TABLE
93: , p5_a6 JTF_NUMBER_TABLE
94: , p5_a7 JTF_VARCHAR2_TABLE_100
95: , p5_a8 JTF_VARCHAR2_TABLE_2000
96: , p5_a9 JTF_DATE_TABLE
97: , p5_a10 JTF_VARCHAR2_TABLE_100
98: , p5_a11 JTF_NUMBER_TABLE

Line 97: , p5_a10 JTF_VARCHAR2_TABLE_100

93: , p5_a6 JTF_NUMBER_TABLE
94: , p5_a7 JTF_VARCHAR2_TABLE_100
95: , p5_a8 JTF_VARCHAR2_TABLE_2000
96: , p5_a9 JTF_DATE_TABLE
97: , p5_a10 JTF_VARCHAR2_TABLE_100
98: , p5_a11 JTF_NUMBER_TABLE
99: , p5_a12 JTF_NUMBER_TABLE
100: , p5_a13 JTF_NUMBER_TABLE
101: , p5_a14 JTF_NUMBER_TABLE

Line 127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

123: , p5_a36 JTF_DATE_TABLE
124: , p5_a37 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
127: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
128: , p6_a3 out nocopy JTF_DATE_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
131: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 132: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

128: , p6_a3 out nocopy JTF_DATE_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_NUMBER_TABLE
131: , p6_a6 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
133: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
134: , p6_a9 out nocopy JTF_DATE_TABLE
135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

131: , p6_a6 out nocopy JTF_NUMBER_TABLE
132: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
133: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
134: , p6_a9 out nocopy JTF_DATE_TABLE
135: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a11 out nocopy JTF_NUMBER_TABLE
137: , p6_a12 out nocopy JTF_NUMBER_TABLE
138: , p6_a13 out nocopy JTF_NUMBER_TABLE
139: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 253: , p5_a2 JTF_VARCHAR2_TABLE_100

249: , x_msg_count out nocopy NUMBER
250: , x_msg_data out nocopy VARCHAR2
251: , p5_a0 JTF_NUMBER_TABLE
252: , p5_a1 JTF_VARCHAR2_TABLE_200
253: , p5_a2 JTF_VARCHAR2_TABLE_100
254: , p5_a3 JTF_DATE_TABLE
255: , p5_a4 JTF_NUMBER_TABLE
256: , p5_a5 JTF_NUMBER_TABLE
257: , p5_a6 JTF_NUMBER_TABLE

Line 258: , p5_a7 JTF_VARCHAR2_TABLE_100

254: , p5_a3 JTF_DATE_TABLE
255: , p5_a4 JTF_NUMBER_TABLE
256: , p5_a5 JTF_NUMBER_TABLE
257: , p5_a6 JTF_NUMBER_TABLE
258: , p5_a7 JTF_VARCHAR2_TABLE_100
259: , p5_a8 JTF_VARCHAR2_TABLE_2000
260: , p5_a9 JTF_DATE_TABLE
261: , p5_a10 JTF_VARCHAR2_TABLE_100
262: , p5_a11 JTF_NUMBER_TABLE

Line 261: , p5_a10 JTF_VARCHAR2_TABLE_100

257: , p5_a6 JTF_NUMBER_TABLE
258: , p5_a7 JTF_VARCHAR2_TABLE_100
259: , p5_a8 JTF_VARCHAR2_TABLE_2000
260: , p5_a9 JTF_DATE_TABLE
261: , p5_a10 JTF_VARCHAR2_TABLE_100
262: , p5_a11 JTF_NUMBER_TABLE
263: , p5_a12 JTF_NUMBER_TABLE
264: , p5_a13 JTF_NUMBER_TABLE
265: , p5_a14 JTF_NUMBER_TABLE

Line 341: , p5_a2 JTF_VARCHAR2_TABLE_100

337: , x_msg_count out nocopy NUMBER
338: , x_msg_data out nocopy VARCHAR2
339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_VARCHAR2_TABLE_200
341: , p5_a2 JTF_VARCHAR2_TABLE_100
342: , p5_a3 JTF_DATE_TABLE
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE

Line 346: , p5_a7 JTF_VARCHAR2_TABLE_100

342: , p5_a3 JTF_DATE_TABLE
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_VARCHAR2_TABLE_100
347: , p5_a8 JTF_VARCHAR2_TABLE_2000
348: , p5_a9 JTF_DATE_TABLE
349: , p5_a10 JTF_VARCHAR2_TABLE_100
350: , p5_a11 JTF_NUMBER_TABLE

Line 349: , p5_a10 JTF_VARCHAR2_TABLE_100

345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_VARCHAR2_TABLE_100
347: , p5_a8 JTF_VARCHAR2_TABLE_2000
348: , p5_a9 JTF_DATE_TABLE
349: , p5_a10 JTF_VARCHAR2_TABLE_100
350: , p5_a11 JTF_NUMBER_TABLE
351: , p5_a12 JTF_NUMBER_TABLE
352: , p5_a13 JTF_NUMBER_TABLE
353: , p5_a14 JTF_NUMBER_TABLE

Line 379: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

375: , p5_a36 JTF_DATE_TABLE
376: , p5_a37 JTF_NUMBER_TABLE
377: , p6_a0 out nocopy JTF_NUMBER_TABLE
378: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
379: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
380: , p6_a3 out nocopy JTF_DATE_TABLE
381: , p6_a4 out nocopy JTF_NUMBER_TABLE
382: , p6_a5 out nocopy JTF_NUMBER_TABLE
383: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 384: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

380: , p6_a3 out nocopy JTF_DATE_TABLE
381: , p6_a4 out nocopy JTF_NUMBER_TABLE
382: , p6_a5 out nocopy JTF_NUMBER_TABLE
383: , p6_a6 out nocopy JTF_NUMBER_TABLE
384: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
385: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
386: , p6_a9 out nocopy JTF_DATE_TABLE
387: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
388: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 387: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

383: , p6_a6 out nocopy JTF_NUMBER_TABLE
384: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
385: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
386: , p6_a9 out nocopy JTF_DATE_TABLE
387: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
388: , p6_a11 out nocopy JTF_NUMBER_TABLE
389: , p6_a12 out nocopy JTF_NUMBER_TABLE
390: , p6_a13 out nocopy JTF_NUMBER_TABLE
391: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 505: , p5_a2 JTF_VARCHAR2_TABLE_100

501: , x_msg_count out nocopy NUMBER
502: , x_msg_data out nocopy VARCHAR2
503: , p5_a0 JTF_NUMBER_TABLE
504: , p5_a1 JTF_VARCHAR2_TABLE_200
505: , p5_a2 JTF_VARCHAR2_TABLE_100
506: , p5_a3 JTF_DATE_TABLE
507: , p5_a4 JTF_NUMBER_TABLE
508: , p5_a5 JTF_NUMBER_TABLE
509: , p5_a6 JTF_NUMBER_TABLE

Line 510: , p5_a7 JTF_VARCHAR2_TABLE_100

506: , p5_a3 JTF_DATE_TABLE
507: , p5_a4 JTF_NUMBER_TABLE
508: , p5_a5 JTF_NUMBER_TABLE
509: , p5_a6 JTF_NUMBER_TABLE
510: , p5_a7 JTF_VARCHAR2_TABLE_100
511: , p5_a8 JTF_VARCHAR2_TABLE_2000
512: , p5_a9 JTF_DATE_TABLE
513: , p5_a10 JTF_VARCHAR2_TABLE_100
514: , p5_a11 JTF_NUMBER_TABLE

Line 513: , p5_a10 JTF_VARCHAR2_TABLE_100

509: , p5_a6 JTF_NUMBER_TABLE
510: , p5_a7 JTF_VARCHAR2_TABLE_100
511: , p5_a8 JTF_VARCHAR2_TABLE_2000
512: , p5_a9 JTF_DATE_TABLE
513: , p5_a10 JTF_VARCHAR2_TABLE_100
514: , p5_a11 JTF_NUMBER_TABLE
515: , p5_a12 JTF_NUMBER_TABLE
516: , p5_a13 JTF_NUMBER_TABLE
517: , p5_a14 JTF_NUMBER_TABLE

Line 593: , p5_a2 JTF_VARCHAR2_TABLE_100

589: , x_msg_count out nocopy NUMBER
590: , x_msg_data out nocopy VARCHAR2
591: , p5_a0 JTF_NUMBER_TABLE
592: , p5_a1 JTF_VARCHAR2_TABLE_200
593: , p5_a2 JTF_VARCHAR2_TABLE_100
594: , p5_a3 JTF_DATE_TABLE
595: , p5_a4 JTF_NUMBER_TABLE
596: , p5_a5 JTF_NUMBER_TABLE
597: , p5_a6 JTF_NUMBER_TABLE

Line 598: , p5_a7 JTF_VARCHAR2_TABLE_100

594: , p5_a3 JTF_DATE_TABLE
595: , p5_a4 JTF_NUMBER_TABLE
596: , p5_a5 JTF_NUMBER_TABLE
597: , p5_a6 JTF_NUMBER_TABLE
598: , p5_a7 JTF_VARCHAR2_TABLE_100
599: , p5_a8 JTF_VARCHAR2_TABLE_2000
600: , p5_a9 JTF_DATE_TABLE
601: , p5_a10 JTF_VARCHAR2_TABLE_100
602: , p5_a11 JTF_NUMBER_TABLE

Line 601: , p5_a10 JTF_VARCHAR2_TABLE_100

597: , p5_a6 JTF_NUMBER_TABLE
598: , p5_a7 JTF_VARCHAR2_TABLE_100
599: , p5_a8 JTF_VARCHAR2_TABLE_2000
600: , p5_a9 JTF_DATE_TABLE
601: , p5_a10 JTF_VARCHAR2_TABLE_100
602: , p5_a11 JTF_NUMBER_TABLE
603: , p5_a12 JTF_NUMBER_TABLE
604: , p5_a13 JTF_NUMBER_TABLE
605: , p5_a14 JTF_NUMBER_TABLE