APPS.CN_PSUM_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy cn_psum_pvt.psum_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_400
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_VARCHAR2_TABLE_400
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_VARCHAR2_TABLE_100

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

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100

Line 13: , a10 JTF_VARCHAR2_TABLE_100

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

Line 14: , a11 JTF_VARCHAR2_TABLE_100

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

Line 15: , a12 JTF_VARCHAR2_TABLE_100

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

Line 16: , a13 JTF_VARCHAR2_TABLE_100

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

Line 25: , a4 out nocopy JTF_VARCHAR2_TABLE_100

21: procedure rosetta_table_copy_out_p1(t cn_psum_pvt.psum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
22: , a1 out nocopy JTF_VARCHAR2_TABLE_400
23: , a2 out nocopy JTF_NUMBER_TABLE
24: , a3 out nocopy JTF_NUMBER_TABLE
25: , a4 out nocopy JTF_VARCHAR2_TABLE_100
26: , a5 out nocopy JTF_VARCHAR2_TABLE_100
27: , a6 out nocopy JTF_NUMBER_TABLE
28: , a7 out nocopy JTF_VARCHAR2_TABLE_100
29: , a8 out nocopy JTF_NUMBER_TABLE

Line 26: , a5 out nocopy JTF_VARCHAR2_TABLE_100

22: , a1 out nocopy JTF_VARCHAR2_TABLE_400
23: , a2 out nocopy JTF_NUMBER_TABLE
24: , a3 out nocopy JTF_NUMBER_TABLE
25: , a4 out nocopy JTF_VARCHAR2_TABLE_100
26: , a5 out nocopy JTF_VARCHAR2_TABLE_100
27: , a6 out nocopy JTF_NUMBER_TABLE
28: , a7 out nocopy JTF_VARCHAR2_TABLE_100
29: , a8 out nocopy JTF_NUMBER_TABLE
30: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 28: , a7 out nocopy JTF_VARCHAR2_TABLE_100

24: , a3 out nocopy JTF_NUMBER_TABLE
25: , a4 out nocopy JTF_VARCHAR2_TABLE_100
26: , a5 out nocopy JTF_VARCHAR2_TABLE_100
27: , a6 out nocopy JTF_NUMBER_TABLE
28: , a7 out nocopy JTF_VARCHAR2_TABLE_100
29: , a8 out nocopy JTF_NUMBER_TABLE
30: , a9 out nocopy JTF_VARCHAR2_TABLE_100
31: , a10 out nocopy JTF_VARCHAR2_TABLE_100
32: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 30: , a9 out nocopy JTF_VARCHAR2_TABLE_100

26: , a5 out nocopy JTF_VARCHAR2_TABLE_100
27: , a6 out nocopy JTF_NUMBER_TABLE
28: , a7 out nocopy JTF_VARCHAR2_TABLE_100
29: , a8 out nocopy JTF_NUMBER_TABLE
30: , a9 out nocopy JTF_VARCHAR2_TABLE_100
31: , a10 out nocopy JTF_VARCHAR2_TABLE_100
32: , a11 out nocopy JTF_VARCHAR2_TABLE_100
33: , a12 out nocopy JTF_VARCHAR2_TABLE_100
34: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 31: , a10 out nocopy JTF_VARCHAR2_TABLE_100

27: , a6 out nocopy JTF_NUMBER_TABLE
28: , a7 out nocopy JTF_VARCHAR2_TABLE_100
29: , a8 out nocopy JTF_NUMBER_TABLE
30: , a9 out nocopy JTF_VARCHAR2_TABLE_100
31: , a10 out nocopy JTF_VARCHAR2_TABLE_100
32: , a11 out nocopy JTF_VARCHAR2_TABLE_100
33: , a12 out nocopy JTF_VARCHAR2_TABLE_100
34: , a13 out nocopy JTF_VARCHAR2_TABLE_100
35: , a14 out nocopy JTF_DATE_TABLE

Line 32: , a11 out nocopy JTF_VARCHAR2_TABLE_100

28: , a7 out nocopy JTF_VARCHAR2_TABLE_100
29: , a8 out nocopy JTF_NUMBER_TABLE
30: , a9 out nocopy JTF_VARCHAR2_TABLE_100
31: , a10 out nocopy JTF_VARCHAR2_TABLE_100
32: , a11 out nocopy JTF_VARCHAR2_TABLE_100
33: , a12 out nocopy JTF_VARCHAR2_TABLE_100
34: , a13 out nocopy JTF_VARCHAR2_TABLE_100
35: , a14 out nocopy JTF_DATE_TABLE
36: , a15 out nocopy JTF_DATE_TABLE

Line 33: , a12 out nocopy JTF_VARCHAR2_TABLE_100

29: , a8 out nocopy JTF_NUMBER_TABLE
30: , a9 out nocopy JTF_VARCHAR2_TABLE_100
31: , a10 out nocopy JTF_VARCHAR2_TABLE_100
32: , a11 out nocopy JTF_VARCHAR2_TABLE_100
33: , a12 out nocopy JTF_VARCHAR2_TABLE_100
34: , a13 out nocopy JTF_VARCHAR2_TABLE_100
35: , a14 out nocopy JTF_DATE_TABLE
36: , a15 out nocopy JTF_DATE_TABLE
37: , a16 out nocopy JTF_NUMBER_TABLE

Line 34: , a13 out nocopy JTF_VARCHAR2_TABLE_100

30: , a9 out nocopy JTF_VARCHAR2_TABLE_100
31: , a10 out nocopy JTF_VARCHAR2_TABLE_100
32: , a11 out nocopy JTF_VARCHAR2_TABLE_100
33: , a12 out nocopy JTF_VARCHAR2_TABLE_100
34: , a13 out nocopy JTF_VARCHAR2_TABLE_100
35: , a14 out nocopy JTF_DATE_TABLE
36: , a15 out nocopy JTF_DATE_TABLE
37: , a16 out nocopy JTF_NUMBER_TABLE
38: );

Line 55: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100

51: , p11_a0 out nocopy JTF_NUMBER_TABLE
52: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_400
53: , p11_a2 out nocopy JTF_NUMBER_TABLE
54: , p11_a3 out nocopy JTF_NUMBER_TABLE
55: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , p11_a6 out nocopy JTF_NUMBER_TABLE
58: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , p11_a8 out nocopy JTF_NUMBER_TABLE

Line 56: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

52: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_400
53: , p11_a2 out nocopy JTF_NUMBER_TABLE
54: , p11_a3 out nocopy JTF_NUMBER_TABLE
55: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , p11_a6 out nocopy JTF_NUMBER_TABLE
58: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , p11_a8 out nocopy JTF_NUMBER_TABLE
60: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 58: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100

54: , p11_a3 out nocopy JTF_NUMBER_TABLE
55: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , p11_a6 out nocopy JTF_NUMBER_TABLE
58: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , p11_a8 out nocopy JTF_NUMBER_TABLE
60: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100

56: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , p11_a6 out nocopy JTF_NUMBER_TABLE
58: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , p11_a8 out nocopy JTF_NUMBER_TABLE
60: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
63: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 61: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100

57: , p11_a6 out nocopy JTF_NUMBER_TABLE
58: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , p11_a8 out nocopy JTF_NUMBER_TABLE
60: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
63: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
65: , p11_a14 out nocopy JTF_DATE_TABLE

Line 62: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100

58: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
59: , p11_a8 out nocopy JTF_NUMBER_TABLE
60: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
63: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
65: , p11_a14 out nocopy JTF_DATE_TABLE
66: , p11_a15 out nocopy JTF_DATE_TABLE

Line 63: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100

59: , p11_a8 out nocopy JTF_NUMBER_TABLE
60: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
63: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
65: , p11_a14 out nocopy JTF_DATE_TABLE
66: , p11_a15 out nocopy JTF_DATE_TABLE
67: , p11_a16 out nocopy JTF_NUMBER_TABLE

Line 64: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100

60: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
61: , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
62: , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
63: , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
65: , p11_a14 out nocopy JTF_DATE_TABLE
66: , p11_a15 out nocopy JTF_DATE_TABLE
67: , p11_a16 out nocopy JTF_NUMBER_TABLE
68: , x_total_rows out nocopy NUMBER

Line 86: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100

82: , p12_a0 out nocopy JTF_NUMBER_TABLE
83: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_400
84: , p12_a2 out nocopy JTF_NUMBER_TABLE
85: , p12_a3 out nocopy JTF_NUMBER_TABLE
86: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
87: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
88: , p12_a6 out nocopy JTF_NUMBER_TABLE
89: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
90: , p12_a8 out nocopy JTF_NUMBER_TABLE

Line 87: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100

83: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_400
84: , p12_a2 out nocopy JTF_NUMBER_TABLE
85: , p12_a3 out nocopy JTF_NUMBER_TABLE
86: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
87: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
88: , p12_a6 out nocopy JTF_NUMBER_TABLE
89: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
90: , p12_a8 out nocopy JTF_NUMBER_TABLE
91: , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 89: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100

85: , p12_a3 out nocopy JTF_NUMBER_TABLE
86: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
87: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
88: , p12_a6 out nocopy JTF_NUMBER_TABLE
89: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
90: , p12_a8 out nocopy JTF_NUMBER_TABLE
91: , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
92: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
93: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 91: , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100

87: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
88: , p12_a6 out nocopy JTF_NUMBER_TABLE
89: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
90: , p12_a8 out nocopy JTF_NUMBER_TABLE
91: , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
92: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
93: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
94: , p12_a12 out nocopy JTF_VARCHAR2_TABLE_100
95: , p12_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 92: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100

88: , p12_a6 out nocopy JTF_NUMBER_TABLE
89: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
90: , p12_a8 out nocopy JTF_NUMBER_TABLE
91: , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
92: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
93: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
94: , p12_a12 out nocopy JTF_VARCHAR2_TABLE_100
95: , p12_a13 out nocopy JTF_VARCHAR2_TABLE_100
96: , p12_a14 out nocopy JTF_DATE_TABLE

Line 93: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100

89: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
90: , p12_a8 out nocopy JTF_NUMBER_TABLE
91: , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
92: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
93: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
94: , p12_a12 out nocopy JTF_VARCHAR2_TABLE_100
95: , p12_a13 out nocopy JTF_VARCHAR2_TABLE_100
96: , p12_a14 out nocopy JTF_DATE_TABLE
97: , p12_a15 out nocopy JTF_DATE_TABLE

Line 94: , p12_a12 out nocopy JTF_VARCHAR2_TABLE_100

90: , p12_a8 out nocopy JTF_NUMBER_TABLE
91: , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
92: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
93: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
94: , p12_a12 out nocopy JTF_VARCHAR2_TABLE_100
95: , p12_a13 out nocopy JTF_VARCHAR2_TABLE_100
96: , p12_a14 out nocopy JTF_DATE_TABLE
97: , p12_a15 out nocopy JTF_DATE_TABLE
98: , p12_a16 out nocopy JTF_NUMBER_TABLE

Line 95: , p12_a13 out nocopy JTF_VARCHAR2_TABLE_100

91: , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
92: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
93: , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
94: , p12_a12 out nocopy JTF_VARCHAR2_TABLE_100
95: , p12_a13 out nocopy JTF_VARCHAR2_TABLE_100
96: , p12_a14 out nocopy JTF_DATE_TABLE
97: , p12_a15 out nocopy JTF_DATE_TABLE
98: , p12_a16 out nocopy JTF_NUMBER_TABLE
99: , x_total_rows out nocopy NUMBER