DBA Data[Home] [Help]

APPS.AHL_PRD_MRSHL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 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_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE

Line 13: , a10 JTF_VARCHAR2_TABLE_100

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

Line 17: , a14 JTF_VARCHAR2_TABLE_100

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

Line 18: , a15 JTF_VARCHAR2_TABLE_100

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE

Line 28: , a25 JTF_VARCHAR2_TABLE_100

24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100

Line 31: , a28 JTF_VARCHAR2_TABLE_100

27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100

Line 32: , a29 JTF_VARCHAR2_TABLE_100

28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100

Line 33: , a30 JTF_VARCHAR2_TABLE_100

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE

Line 34: , a31 JTF_VARCHAR2_TABLE_100

30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100

Line 35: , a32 JTF_VARCHAR2_TABLE_100

31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100

Line 36: , a33 JTF_VARCHAR2_TABLE_100

32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE

Line 38: , a35 JTF_VARCHAR2_TABLE_100

34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 39: , a36 JTF_VARCHAR2_TABLE_100

35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE

Line 47: , a5 out nocopy JTF_VARCHAR2_TABLE_100

43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_300
45: , a3 out nocopy JTF_VARCHAR2_TABLE_300
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 51: , a9 out nocopy JTF_VARCHAR2_TABLE_100

47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 52: , a10 out nocopy JTF_VARCHAR2_TABLE_100

48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100

Line 56: , a14 out nocopy JTF_VARCHAR2_TABLE_100

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_VARCHAR2_TABLE_100
57: , a15 out nocopy JTF_VARCHAR2_TABLE_100
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_NUMBER_TABLE
60: , a18 out nocopy JTF_NUMBER_TABLE

Line 57: , a15 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_VARCHAR2_TABLE_100
57: , a15 out nocopy JTF_VARCHAR2_TABLE_100
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_NUMBER_TABLE
60: , a18 out nocopy JTF_NUMBER_TABLE
61: , a19 out nocopy JTF_DATE_TABLE

Line 67: , a25 out nocopy JTF_VARCHAR2_TABLE_100

63: , a21 out nocopy JTF_DATE_TABLE
64: , a22 out nocopy JTF_NUMBER_TABLE
65: , a23 out nocopy JTF_NUMBER_TABLE
66: , a24 out nocopy JTF_NUMBER_TABLE
67: , a25 out nocopy JTF_VARCHAR2_TABLE_100
68: , a26 out nocopy JTF_NUMBER_TABLE
69: , a27 out nocopy JTF_VARCHAR2_TABLE_300
70: , a28 out nocopy JTF_VARCHAR2_TABLE_100
71: , a29 out nocopy JTF_VARCHAR2_TABLE_100

Line 70: , a28 out nocopy JTF_VARCHAR2_TABLE_100

66: , a24 out nocopy JTF_NUMBER_TABLE
67: , a25 out nocopy JTF_VARCHAR2_TABLE_100
68: , a26 out nocopy JTF_NUMBER_TABLE
69: , a27 out nocopy JTF_VARCHAR2_TABLE_300
70: , a28 out nocopy JTF_VARCHAR2_TABLE_100
71: , a29 out nocopy JTF_VARCHAR2_TABLE_100
72: , a30 out nocopy JTF_VARCHAR2_TABLE_100
73: , a31 out nocopy JTF_VARCHAR2_TABLE_100
74: , a32 out nocopy JTF_VARCHAR2_TABLE_100

Line 71: , a29 out nocopy JTF_VARCHAR2_TABLE_100

67: , a25 out nocopy JTF_VARCHAR2_TABLE_100
68: , a26 out nocopy JTF_NUMBER_TABLE
69: , a27 out nocopy JTF_VARCHAR2_TABLE_300
70: , a28 out nocopy JTF_VARCHAR2_TABLE_100
71: , a29 out nocopy JTF_VARCHAR2_TABLE_100
72: , a30 out nocopy JTF_VARCHAR2_TABLE_100
73: , a31 out nocopy JTF_VARCHAR2_TABLE_100
74: , a32 out nocopy JTF_VARCHAR2_TABLE_100
75: , a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 72: , a30 out nocopy JTF_VARCHAR2_TABLE_100

68: , a26 out nocopy JTF_NUMBER_TABLE
69: , a27 out nocopy JTF_VARCHAR2_TABLE_300
70: , a28 out nocopy JTF_VARCHAR2_TABLE_100
71: , a29 out nocopy JTF_VARCHAR2_TABLE_100
72: , a30 out nocopy JTF_VARCHAR2_TABLE_100
73: , a31 out nocopy JTF_VARCHAR2_TABLE_100
74: , a32 out nocopy JTF_VARCHAR2_TABLE_100
75: , a33 out nocopy JTF_VARCHAR2_TABLE_100
76: , a34 out nocopy JTF_NUMBER_TABLE

Line 73: , a31 out nocopy JTF_VARCHAR2_TABLE_100

69: , a27 out nocopy JTF_VARCHAR2_TABLE_300
70: , a28 out nocopy JTF_VARCHAR2_TABLE_100
71: , a29 out nocopy JTF_VARCHAR2_TABLE_100
72: , a30 out nocopy JTF_VARCHAR2_TABLE_100
73: , a31 out nocopy JTF_VARCHAR2_TABLE_100
74: , a32 out nocopy JTF_VARCHAR2_TABLE_100
75: , a33 out nocopy JTF_VARCHAR2_TABLE_100
76: , a34 out nocopy JTF_NUMBER_TABLE
77: , a35 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: , a32 out nocopy JTF_VARCHAR2_TABLE_100

70: , a28 out nocopy JTF_VARCHAR2_TABLE_100
71: , a29 out nocopy JTF_VARCHAR2_TABLE_100
72: , a30 out nocopy JTF_VARCHAR2_TABLE_100
73: , a31 out nocopy JTF_VARCHAR2_TABLE_100
74: , a32 out nocopy JTF_VARCHAR2_TABLE_100
75: , a33 out nocopy JTF_VARCHAR2_TABLE_100
76: , a34 out nocopy JTF_NUMBER_TABLE
77: , a35 out nocopy JTF_VARCHAR2_TABLE_100
78: , a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 75: , a33 out nocopy JTF_VARCHAR2_TABLE_100

71: , a29 out nocopy JTF_VARCHAR2_TABLE_100
72: , a30 out nocopy JTF_VARCHAR2_TABLE_100
73: , a31 out nocopy JTF_VARCHAR2_TABLE_100
74: , a32 out nocopy JTF_VARCHAR2_TABLE_100
75: , a33 out nocopy JTF_VARCHAR2_TABLE_100
76: , a34 out nocopy JTF_NUMBER_TABLE
77: , a35 out nocopy JTF_VARCHAR2_TABLE_100
78: , a36 out nocopy JTF_VARCHAR2_TABLE_100
79: , a37 out nocopy JTF_NUMBER_TABLE

Line 77: , a35 out nocopy JTF_VARCHAR2_TABLE_100

73: , a31 out nocopy JTF_VARCHAR2_TABLE_100
74: , a32 out nocopy JTF_VARCHAR2_TABLE_100
75: , a33 out nocopy JTF_VARCHAR2_TABLE_100
76: , a34 out nocopy JTF_NUMBER_TABLE
77: , a35 out nocopy JTF_VARCHAR2_TABLE_100
78: , a36 out nocopy JTF_VARCHAR2_TABLE_100
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:

Line 78: , a36 out nocopy JTF_VARCHAR2_TABLE_100

74: , a32 out nocopy JTF_VARCHAR2_TABLE_100
75: , a33 out nocopy JTF_VARCHAR2_TABLE_100
76: , a34 out nocopy JTF_NUMBER_TABLE
77: , a35 out nocopy JTF_VARCHAR2_TABLE_100
78: , a36 out nocopy JTF_VARCHAR2_TABLE_100
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
82: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE

Line 87: , a5 JTF_VARCHAR2_TABLE_100

83: , a1 JTF_NUMBER_TABLE
84: , a2 JTF_VARCHAR2_TABLE_300
85: , a3 JTF_VARCHAR2_TABLE_300
86: , a4 JTF_NUMBER_TABLE
87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_VARCHAR2_TABLE_100

Line 91: , a9 JTF_VARCHAR2_TABLE_100

87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_VARCHAR2_TABLE_100
92: , a10 JTF_VARCHAR2_TABLE_100
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE

Line 92: , a10 JTF_VARCHAR2_TABLE_100

88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_VARCHAR2_TABLE_100
92: , a10 JTF_VARCHAR2_TABLE_100
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_VARCHAR2_TABLE_100

Line 96: , a14 JTF_VARCHAR2_TABLE_100

92: , a10 JTF_VARCHAR2_TABLE_100
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_VARCHAR2_TABLE_100
97: , a15 JTF_VARCHAR2_TABLE_100
98: , a16 JTF_DATE_TABLE
99: , a17 JTF_NUMBER_TABLE
100: , a18 JTF_DATE_TABLE

Line 97: , a15 JTF_VARCHAR2_TABLE_100

93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_VARCHAR2_TABLE_100
97: , a15 JTF_VARCHAR2_TABLE_100
98: , a16 JTF_DATE_TABLE
99: , a17 JTF_NUMBER_TABLE
100: , a18 JTF_DATE_TABLE
101: , a19 JTF_NUMBER_TABLE

Line 107: , a25 JTF_VARCHAR2_TABLE_100

103: , a21 JTF_DATE_TABLE
104: , a22 JTF_NUMBER_TABLE
105: , a23 JTF_NUMBER_TABLE
106: , a24 JTF_NUMBER_TABLE
107: , a25 JTF_VARCHAR2_TABLE_100
108: , a26 JTF_NUMBER_TABLE
109: , a27 JTF_VARCHAR2_TABLE_300
110: , a28 JTF_VARCHAR2_TABLE_100
111: , a29 JTF_VARCHAR2_TABLE_100

Line 110: , a28 JTF_VARCHAR2_TABLE_100

106: , a24 JTF_NUMBER_TABLE
107: , a25 JTF_VARCHAR2_TABLE_100
108: , a26 JTF_NUMBER_TABLE
109: , a27 JTF_VARCHAR2_TABLE_300
110: , a28 JTF_VARCHAR2_TABLE_100
111: , a29 JTF_VARCHAR2_TABLE_100
112: , a30 JTF_VARCHAR2_TABLE_100
113: , a31 JTF_NUMBER_TABLE
114: , a32 JTF_VARCHAR2_TABLE_100

Line 111: , a29 JTF_VARCHAR2_TABLE_100

107: , a25 JTF_VARCHAR2_TABLE_100
108: , a26 JTF_NUMBER_TABLE
109: , a27 JTF_VARCHAR2_TABLE_300
110: , a28 JTF_VARCHAR2_TABLE_100
111: , a29 JTF_VARCHAR2_TABLE_100
112: , a30 JTF_VARCHAR2_TABLE_100
113: , a31 JTF_NUMBER_TABLE
114: , a32 JTF_VARCHAR2_TABLE_100
115: , a33 JTF_NUMBER_TABLE

Line 112: , a30 JTF_VARCHAR2_TABLE_100

108: , a26 JTF_NUMBER_TABLE
109: , a27 JTF_VARCHAR2_TABLE_300
110: , a28 JTF_VARCHAR2_TABLE_100
111: , a29 JTF_VARCHAR2_TABLE_100
112: , a30 JTF_VARCHAR2_TABLE_100
113: , a31 JTF_NUMBER_TABLE
114: , a32 JTF_VARCHAR2_TABLE_100
115: , a33 JTF_NUMBER_TABLE
116: , a34 JTF_NUMBER_TABLE

Line 114: , a32 JTF_VARCHAR2_TABLE_100

110: , a28 JTF_VARCHAR2_TABLE_100
111: , a29 JTF_VARCHAR2_TABLE_100
112: , a30 JTF_VARCHAR2_TABLE_100
113: , a31 JTF_NUMBER_TABLE
114: , a32 JTF_VARCHAR2_TABLE_100
115: , a33 JTF_NUMBER_TABLE
116: , a34 JTF_NUMBER_TABLE
117: , a35 JTF_VARCHAR2_TABLE_100
118: , a36 JTF_VARCHAR2_TABLE_100

Line 117: , a35 JTF_VARCHAR2_TABLE_100

113: , a31 JTF_NUMBER_TABLE
114: , a32 JTF_VARCHAR2_TABLE_100
115: , a33 JTF_NUMBER_TABLE
116: , a34 JTF_NUMBER_TABLE
117: , a35 JTF_VARCHAR2_TABLE_100
118: , a36 JTF_VARCHAR2_TABLE_100
119: , a37 JTF_VARCHAR2_TABLE_100
120: , a38 JTF_NUMBER_TABLE
121: , a39 JTF_VARCHAR2_TABLE_100

Line 118: , a36 JTF_VARCHAR2_TABLE_100

114: , a32 JTF_VARCHAR2_TABLE_100
115: , a33 JTF_NUMBER_TABLE
116: , a34 JTF_NUMBER_TABLE
117: , a35 JTF_VARCHAR2_TABLE_100
118: , a36 JTF_VARCHAR2_TABLE_100
119: , a37 JTF_VARCHAR2_TABLE_100
120: , a38 JTF_NUMBER_TABLE
121: , a39 JTF_VARCHAR2_TABLE_100
122: , a40 JTF_VARCHAR2_TABLE_100

Line 119: , a37 JTF_VARCHAR2_TABLE_100

115: , a33 JTF_NUMBER_TABLE
116: , a34 JTF_NUMBER_TABLE
117: , a35 JTF_VARCHAR2_TABLE_100
118: , a36 JTF_VARCHAR2_TABLE_100
119: , a37 JTF_VARCHAR2_TABLE_100
120: , a38 JTF_NUMBER_TABLE
121: , a39 JTF_VARCHAR2_TABLE_100
122: , a40 JTF_VARCHAR2_TABLE_100
123: , a41 JTF_NUMBER_TABLE

Line 121: , a39 JTF_VARCHAR2_TABLE_100

117: , a35 JTF_VARCHAR2_TABLE_100
118: , a36 JTF_VARCHAR2_TABLE_100
119: , a37 JTF_VARCHAR2_TABLE_100
120: , a38 JTF_NUMBER_TABLE
121: , a39 JTF_VARCHAR2_TABLE_100
122: , a40 JTF_VARCHAR2_TABLE_100
123: , a41 JTF_NUMBER_TABLE
124: );
125: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 122: , a40 JTF_VARCHAR2_TABLE_100

118: , a36 JTF_VARCHAR2_TABLE_100
119: , a37 JTF_VARCHAR2_TABLE_100
120: , a38 JTF_NUMBER_TABLE
121: , a39 JTF_VARCHAR2_TABLE_100
122: , a40 JTF_VARCHAR2_TABLE_100
123: , a41 JTF_NUMBER_TABLE
124: );
125: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE

Line 130: , a5 out nocopy JTF_VARCHAR2_TABLE_100

126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_VARCHAR2_TABLE_300
128: , a3 out nocopy JTF_VARCHAR2_TABLE_300
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_VARCHAR2_TABLE_100
131: , a6 out nocopy JTF_NUMBER_TABLE
132: , a7 out nocopy JTF_NUMBER_TABLE
133: , a8 out nocopy JTF_NUMBER_TABLE
134: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 134: , a9 out nocopy JTF_VARCHAR2_TABLE_100

130: , a5 out nocopy JTF_VARCHAR2_TABLE_100
131: , a6 out nocopy JTF_NUMBER_TABLE
132: , a7 out nocopy JTF_NUMBER_TABLE
133: , a8 out nocopy JTF_NUMBER_TABLE
134: , a9 out nocopy JTF_VARCHAR2_TABLE_100
135: , a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , a11 out nocopy JTF_NUMBER_TABLE
137: , a12 out nocopy JTF_NUMBER_TABLE
138: , a13 out nocopy JTF_NUMBER_TABLE

Line 135: , a10 out nocopy JTF_VARCHAR2_TABLE_100

131: , a6 out nocopy JTF_NUMBER_TABLE
132: , a7 out nocopy JTF_NUMBER_TABLE
133: , a8 out nocopy JTF_NUMBER_TABLE
134: , a9 out nocopy JTF_VARCHAR2_TABLE_100
135: , a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , a11 out nocopy JTF_NUMBER_TABLE
137: , a12 out nocopy JTF_NUMBER_TABLE
138: , a13 out nocopy JTF_NUMBER_TABLE
139: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 139: , a14 out nocopy JTF_VARCHAR2_TABLE_100

135: , a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , a11 out nocopy JTF_NUMBER_TABLE
137: , a12 out nocopy JTF_NUMBER_TABLE
138: , a13 out nocopy JTF_NUMBER_TABLE
139: , a14 out nocopy JTF_VARCHAR2_TABLE_100
140: , a15 out nocopy JTF_VARCHAR2_TABLE_100
141: , a16 out nocopy JTF_DATE_TABLE
142: , a17 out nocopy JTF_NUMBER_TABLE
143: , a18 out nocopy JTF_DATE_TABLE

Line 140: , a15 out nocopy JTF_VARCHAR2_TABLE_100

136: , a11 out nocopy JTF_NUMBER_TABLE
137: , a12 out nocopy JTF_NUMBER_TABLE
138: , a13 out nocopy JTF_NUMBER_TABLE
139: , a14 out nocopy JTF_VARCHAR2_TABLE_100
140: , a15 out nocopy JTF_VARCHAR2_TABLE_100
141: , a16 out nocopy JTF_DATE_TABLE
142: , a17 out nocopy JTF_NUMBER_TABLE
143: , a18 out nocopy JTF_DATE_TABLE
144: , a19 out nocopy JTF_NUMBER_TABLE

Line 150: , a25 out nocopy JTF_VARCHAR2_TABLE_100

146: , a21 out nocopy JTF_DATE_TABLE
147: , a22 out nocopy JTF_NUMBER_TABLE
148: , a23 out nocopy JTF_NUMBER_TABLE
149: , a24 out nocopy JTF_NUMBER_TABLE
150: , a25 out nocopy JTF_VARCHAR2_TABLE_100
151: , a26 out nocopy JTF_NUMBER_TABLE
152: , a27 out nocopy JTF_VARCHAR2_TABLE_300
153: , a28 out nocopy JTF_VARCHAR2_TABLE_100
154: , a29 out nocopy JTF_VARCHAR2_TABLE_100

Line 153: , a28 out nocopy JTF_VARCHAR2_TABLE_100

149: , a24 out nocopy JTF_NUMBER_TABLE
150: , a25 out nocopy JTF_VARCHAR2_TABLE_100
151: , a26 out nocopy JTF_NUMBER_TABLE
152: , a27 out nocopy JTF_VARCHAR2_TABLE_300
153: , a28 out nocopy JTF_VARCHAR2_TABLE_100
154: , a29 out nocopy JTF_VARCHAR2_TABLE_100
155: , a30 out nocopy JTF_VARCHAR2_TABLE_100
156: , a31 out nocopy JTF_NUMBER_TABLE
157: , a32 out nocopy JTF_VARCHAR2_TABLE_100

Line 154: , a29 out nocopy JTF_VARCHAR2_TABLE_100

150: , a25 out nocopy JTF_VARCHAR2_TABLE_100
151: , a26 out nocopy JTF_NUMBER_TABLE
152: , a27 out nocopy JTF_VARCHAR2_TABLE_300
153: , a28 out nocopy JTF_VARCHAR2_TABLE_100
154: , a29 out nocopy JTF_VARCHAR2_TABLE_100
155: , a30 out nocopy JTF_VARCHAR2_TABLE_100
156: , a31 out nocopy JTF_NUMBER_TABLE
157: , a32 out nocopy JTF_VARCHAR2_TABLE_100
158: , a33 out nocopy JTF_NUMBER_TABLE

Line 155: , a30 out nocopy JTF_VARCHAR2_TABLE_100

151: , a26 out nocopy JTF_NUMBER_TABLE
152: , a27 out nocopy JTF_VARCHAR2_TABLE_300
153: , a28 out nocopy JTF_VARCHAR2_TABLE_100
154: , a29 out nocopy JTF_VARCHAR2_TABLE_100
155: , a30 out nocopy JTF_VARCHAR2_TABLE_100
156: , a31 out nocopy JTF_NUMBER_TABLE
157: , a32 out nocopy JTF_VARCHAR2_TABLE_100
158: , a33 out nocopy JTF_NUMBER_TABLE
159: , a34 out nocopy JTF_NUMBER_TABLE

Line 157: , a32 out nocopy JTF_VARCHAR2_TABLE_100

153: , a28 out nocopy JTF_VARCHAR2_TABLE_100
154: , a29 out nocopy JTF_VARCHAR2_TABLE_100
155: , a30 out nocopy JTF_VARCHAR2_TABLE_100
156: , a31 out nocopy JTF_NUMBER_TABLE
157: , a32 out nocopy JTF_VARCHAR2_TABLE_100
158: , a33 out nocopy JTF_NUMBER_TABLE
159: , a34 out nocopy JTF_NUMBER_TABLE
160: , a35 out nocopy JTF_VARCHAR2_TABLE_100
161: , a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 160: , a35 out nocopy JTF_VARCHAR2_TABLE_100

156: , a31 out nocopy JTF_NUMBER_TABLE
157: , a32 out nocopy JTF_VARCHAR2_TABLE_100
158: , a33 out nocopy JTF_NUMBER_TABLE
159: , a34 out nocopy JTF_NUMBER_TABLE
160: , a35 out nocopy JTF_VARCHAR2_TABLE_100
161: , a36 out nocopy JTF_VARCHAR2_TABLE_100
162: , a37 out nocopy JTF_VARCHAR2_TABLE_100
163: , a38 out nocopy JTF_NUMBER_TABLE
164: , a39 out nocopy JTF_VARCHAR2_TABLE_100

Line 161: , a36 out nocopy JTF_VARCHAR2_TABLE_100

157: , a32 out nocopy JTF_VARCHAR2_TABLE_100
158: , a33 out nocopy JTF_NUMBER_TABLE
159: , a34 out nocopy JTF_NUMBER_TABLE
160: , a35 out nocopy JTF_VARCHAR2_TABLE_100
161: , a36 out nocopy JTF_VARCHAR2_TABLE_100
162: , a37 out nocopy JTF_VARCHAR2_TABLE_100
163: , a38 out nocopy JTF_NUMBER_TABLE
164: , a39 out nocopy JTF_VARCHAR2_TABLE_100
165: , a40 out nocopy JTF_VARCHAR2_TABLE_100

Line 162: , a37 out nocopy JTF_VARCHAR2_TABLE_100

158: , a33 out nocopy JTF_NUMBER_TABLE
159: , a34 out nocopy JTF_NUMBER_TABLE
160: , a35 out nocopy JTF_VARCHAR2_TABLE_100
161: , a36 out nocopy JTF_VARCHAR2_TABLE_100
162: , a37 out nocopy JTF_VARCHAR2_TABLE_100
163: , a38 out nocopy JTF_NUMBER_TABLE
164: , a39 out nocopy JTF_VARCHAR2_TABLE_100
165: , a40 out nocopy JTF_VARCHAR2_TABLE_100
166: , a41 out nocopy JTF_NUMBER_TABLE

Line 164: , a39 out nocopy JTF_VARCHAR2_TABLE_100

160: , a35 out nocopy JTF_VARCHAR2_TABLE_100
161: , a36 out nocopy JTF_VARCHAR2_TABLE_100
162: , a37 out nocopy JTF_VARCHAR2_TABLE_100
163: , a38 out nocopy JTF_NUMBER_TABLE
164: , a39 out nocopy JTF_VARCHAR2_TABLE_100
165: , a40 out nocopy JTF_VARCHAR2_TABLE_100
166: , a41 out nocopy JTF_NUMBER_TABLE
167: );
168:

Line 165: , a40 out nocopy JTF_VARCHAR2_TABLE_100

161: , a36 out nocopy JTF_VARCHAR2_TABLE_100
162: , a37 out nocopy JTF_VARCHAR2_TABLE_100
163: , a38 out nocopy JTF_NUMBER_TABLE
164: , a39 out nocopy JTF_VARCHAR2_TABLE_100
165: , a40 out nocopy JTF_VARCHAR2_TABLE_100
166: , a41 out nocopy JTF_NUMBER_TABLE
167: );
168:
169: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE

Line 170: , a1 JTF_VARCHAR2_TABLE_100

166: , a41 out nocopy JTF_NUMBER_TABLE
167: );
168:
169: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
170: , a1 JTF_VARCHAR2_TABLE_100
171: , a2 JTF_NUMBER_TABLE
172: , a3 JTF_NUMBER_TABLE
173: , a4 JTF_NUMBER_TABLE
174: , a5 JTF_VARCHAR2_TABLE_300

Line 175: , a6 JTF_VARCHAR2_TABLE_100

171: , a2 JTF_NUMBER_TABLE
172: , a3 JTF_NUMBER_TABLE
173: , a4 JTF_NUMBER_TABLE
174: , a5 JTF_VARCHAR2_TABLE_300
175: , a6 JTF_VARCHAR2_TABLE_100
176: , a7 JTF_NUMBER_TABLE
177: , a8 JTF_NUMBER_TABLE
178: , a9 JTF_NUMBER_TABLE
179: , a10 JTF_NUMBER_TABLE

Line 181: , a12 JTF_VARCHAR2_TABLE_100

177: , a8 JTF_NUMBER_TABLE
178: , a9 JTF_NUMBER_TABLE
179: , a10 JTF_NUMBER_TABLE
180: , a11 JTF_VARCHAR2_TABLE_300
181: , a12 JTF_VARCHAR2_TABLE_100
182: , a13 JTF_NUMBER_TABLE
183: , a14 JTF_NUMBER_TABLE
184: , a15 JTF_NUMBER_TABLE
185: , a16 JTF_NUMBER_TABLE

Line 197: , a1 out nocopy JTF_VARCHAR2_TABLE_100

193: , a24 JTF_NUMBER_TABLE
194: , a25 JTF_NUMBER_TABLE
195: );
196: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_NUMBER_TABLE
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 202: , a6 out nocopy JTF_VARCHAR2_TABLE_100

198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_NUMBER_TABLE
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_VARCHAR2_TABLE_300
202: , a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_NUMBER_TABLE

Line 208: , a12 out nocopy JTF_VARCHAR2_TABLE_100

204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_NUMBER_TABLE
207: , a11 out nocopy JTF_VARCHAR2_TABLE_300
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
209: , a13 out nocopy JTF_NUMBER_TABLE
210: , a14 out nocopy JTF_NUMBER_TABLE
211: , a15 out nocopy JTF_NUMBER_TABLE
212: , a16 out nocopy JTF_NUMBER_TABLE

Line 242: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

238: , p7_a1 out nocopy JTF_NUMBER_TABLE
239: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
240: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
241: , p7_a4 out nocopy JTF_NUMBER_TABLE
242: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
243: , p7_a6 out nocopy JTF_NUMBER_TABLE
244: , p7_a7 out nocopy JTF_NUMBER_TABLE
245: , p7_a8 out nocopy JTF_NUMBER_TABLE
246: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 246: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

242: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
243: , p7_a6 out nocopy JTF_NUMBER_TABLE
244: , p7_a7 out nocopy JTF_NUMBER_TABLE
245: , p7_a8 out nocopy JTF_NUMBER_TABLE
246: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a11 out nocopy JTF_NUMBER_TABLE
249: , p7_a12 out nocopy JTF_NUMBER_TABLE
250: , p7_a13 out nocopy JTF_NUMBER_TABLE

Line 247: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

243: , p7_a6 out nocopy JTF_NUMBER_TABLE
244: , p7_a7 out nocopy JTF_NUMBER_TABLE
245: , p7_a8 out nocopy JTF_NUMBER_TABLE
246: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a11 out nocopy JTF_NUMBER_TABLE
249: , p7_a12 out nocopy JTF_NUMBER_TABLE
250: , p7_a13 out nocopy JTF_NUMBER_TABLE
251: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 251: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100

247: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a11 out nocopy JTF_NUMBER_TABLE
249: , p7_a12 out nocopy JTF_NUMBER_TABLE
250: , p7_a13 out nocopy JTF_NUMBER_TABLE
251: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
252: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
253: , p7_a16 out nocopy JTF_DATE_TABLE
254: , p7_a17 out nocopy JTF_NUMBER_TABLE
255: , p7_a18 out nocopy JTF_NUMBER_TABLE

Line 252: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100

248: , p7_a11 out nocopy JTF_NUMBER_TABLE
249: , p7_a12 out nocopy JTF_NUMBER_TABLE
250: , p7_a13 out nocopy JTF_NUMBER_TABLE
251: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
252: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
253: , p7_a16 out nocopy JTF_DATE_TABLE
254: , p7_a17 out nocopy JTF_NUMBER_TABLE
255: , p7_a18 out nocopy JTF_NUMBER_TABLE
256: , p7_a19 out nocopy JTF_DATE_TABLE

Line 262: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100

258: , p7_a21 out nocopy JTF_DATE_TABLE
259: , p7_a22 out nocopy JTF_NUMBER_TABLE
260: , p7_a23 out nocopy JTF_NUMBER_TABLE
261: , p7_a24 out nocopy JTF_NUMBER_TABLE
262: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
263: , p7_a26 out nocopy JTF_NUMBER_TABLE
264: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
265: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
266: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100

Line 265: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100

261: , p7_a24 out nocopy JTF_NUMBER_TABLE
262: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
263: , p7_a26 out nocopy JTF_NUMBER_TABLE
264: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
265: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
266: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
267: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
268: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
269: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100

Line 266: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100

262: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
263: , p7_a26 out nocopy JTF_NUMBER_TABLE
264: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
265: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
266: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
267: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
268: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
269: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 267: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100

263: , p7_a26 out nocopy JTF_NUMBER_TABLE
264: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
265: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
266: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
267: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
268: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
269: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
271: , p7_a34 out nocopy JTF_NUMBER_TABLE

Line 268: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100

264: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
265: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
266: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
267: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
268: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
269: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
271: , p7_a34 out nocopy JTF_NUMBER_TABLE
272: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100

Line 269: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100

265: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
266: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
267: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
268: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
269: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
271: , p7_a34 out nocopy JTF_NUMBER_TABLE
272: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
273: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 270: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100

266: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
267: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
268: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
269: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
271: , p7_a34 out nocopy JTF_NUMBER_TABLE
272: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
273: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
274: , p7_a37 out nocopy JTF_NUMBER_TABLE

Line 272: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100

268: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
269: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
271: , p7_a34 out nocopy JTF_NUMBER_TABLE
272: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
273: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
274: , p7_a37 out nocopy JTF_NUMBER_TABLE
275: , x_return_status out nocopy VARCHAR2
276: , x_msg_count out nocopy NUMBER

Line 273: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100

269: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
271: , p7_a34 out nocopy JTF_NUMBER_TABLE
272: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
273: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
274: , p7_a37 out nocopy JTF_NUMBER_TABLE
275: , x_return_status out nocopy VARCHAR2
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2

Line 297: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

293: , p7_a1 out nocopy JTF_NUMBER_TABLE
294: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
295: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
296: , p7_a4 out nocopy JTF_NUMBER_TABLE
297: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
298: , p7_a6 out nocopy JTF_NUMBER_TABLE
299: , p7_a7 out nocopy JTF_NUMBER_TABLE
300: , p7_a8 out nocopy JTF_NUMBER_TABLE
301: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 301: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100

297: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
298: , p7_a6 out nocopy JTF_NUMBER_TABLE
299: , p7_a7 out nocopy JTF_NUMBER_TABLE
300: , p7_a8 out nocopy JTF_NUMBER_TABLE
301: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
302: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
303: , p7_a11 out nocopy JTF_NUMBER_TABLE
304: , p7_a12 out nocopy JTF_NUMBER_TABLE
305: , p7_a13 out nocopy JTF_NUMBER_TABLE

Line 302: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

298: , p7_a6 out nocopy JTF_NUMBER_TABLE
299: , p7_a7 out nocopy JTF_NUMBER_TABLE
300: , p7_a8 out nocopy JTF_NUMBER_TABLE
301: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
302: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
303: , p7_a11 out nocopy JTF_NUMBER_TABLE
304: , p7_a12 out nocopy JTF_NUMBER_TABLE
305: , p7_a13 out nocopy JTF_NUMBER_TABLE
306: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 306: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100

302: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
303: , p7_a11 out nocopy JTF_NUMBER_TABLE
304: , p7_a12 out nocopy JTF_NUMBER_TABLE
305: , p7_a13 out nocopy JTF_NUMBER_TABLE
306: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a16 out nocopy JTF_DATE_TABLE
309: , p7_a17 out nocopy JTF_NUMBER_TABLE
310: , p7_a18 out nocopy JTF_DATE_TABLE

Line 307: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100

303: , p7_a11 out nocopy JTF_NUMBER_TABLE
304: , p7_a12 out nocopy JTF_NUMBER_TABLE
305: , p7_a13 out nocopy JTF_NUMBER_TABLE
306: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a16 out nocopy JTF_DATE_TABLE
309: , p7_a17 out nocopy JTF_NUMBER_TABLE
310: , p7_a18 out nocopy JTF_DATE_TABLE
311: , p7_a19 out nocopy JTF_NUMBER_TABLE

Line 317: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100

313: , p7_a21 out nocopy JTF_DATE_TABLE
314: , p7_a22 out nocopy JTF_NUMBER_TABLE
315: , p7_a23 out nocopy JTF_NUMBER_TABLE
316: , p7_a24 out nocopy JTF_NUMBER_TABLE
317: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a26 out nocopy JTF_NUMBER_TABLE
319: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
320: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
321: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100

Line 320: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100

316: , p7_a24 out nocopy JTF_NUMBER_TABLE
317: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a26 out nocopy JTF_NUMBER_TABLE
319: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
320: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
321: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
322: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
323: , p7_a31 out nocopy JTF_NUMBER_TABLE
324: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100

Line 321: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100

317: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a26 out nocopy JTF_NUMBER_TABLE
319: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
320: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
321: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
322: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
323: , p7_a31 out nocopy JTF_NUMBER_TABLE
324: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
325: , p7_a33 out nocopy JTF_NUMBER_TABLE

Line 322: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100

318: , p7_a26 out nocopy JTF_NUMBER_TABLE
319: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
320: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
321: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
322: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
323: , p7_a31 out nocopy JTF_NUMBER_TABLE
324: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
325: , p7_a33 out nocopy JTF_NUMBER_TABLE
326: , p7_a34 out nocopy JTF_NUMBER_TABLE

Line 324: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100

320: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
321: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
322: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
323: , p7_a31 out nocopy JTF_NUMBER_TABLE
324: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
325: , p7_a33 out nocopy JTF_NUMBER_TABLE
326: , p7_a34 out nocopy JTF_NUMBER_TABLE
327: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
328: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 327: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100

323: , p7_a31 out nocopy JTF_NUMBER_TABLE
324: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
325: , p7_a33 out nocopy JTF_NUMBER_TABLE
326: , p7_a34 out nocopy JTF_NUMBER_TABLE
327: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
328: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
329: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
330: , p7_a38 out nocopy JTF_NUMBER_TABLE
331: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100

Line 328: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100

324: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
325: , p7_a33 out nocopy JTF_NUMBER_TABLE
326: , p7_a34 out nocopy JTF_NUMBER_TABLE
327: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
328: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
329: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
330: , p7_a38 out nocopy JTF_NUMBER_TABLE
331: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
332: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100

Line 329: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100

325: , p7_a33 out nocopy JTF_NUMBER_TABLE
326: , p7_a34 out nocopy JTF_NUMBER_TABLE
327: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
328: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
329: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
330: , p7_a38 out nocopy JTF_NUMBER_TABLE
331: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
332: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
333: , p7_a41 out nocopy JTF_NUMBER_TABLE

Line 331: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100

327: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
328: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
329: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
330: , p7_a38 out nocopy JTF_NUMBER_TABLE
331: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
332: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
333: , p7_a41 out nocopy JTF_NUMBER_TABLE
334: , x_return_status out nocopy VARCHAR2
335: , x_msg_count out nocopy NUMBER

Line 332: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100

328: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
329: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
330: , p7_a38 out nocopy JTF_NUMBER_TABLE
331: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
332: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
333: , p7_a41 out nocopy JTF_NUMBER_TABLE
334: , x_return_status out nocopy VARCHAR2
335: , x_msg_count out nocopy NUMBER
336: , x_msg_data out nocopy VARCHAR2

Line 348: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

344: , p_unit_header_id NUMBER
345: , p_item_instance_id NUMBER
346: , p_visit_id NUMBER
347: , p9_a0 out nocopy JTF_NUMBER_TABLE
348: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p9_a2 out nocopy JTF_NUMBER_TABLE
350: , p9_a3 out nocopy JTF_NUMBER_TABLE
351: , p9_a4 out nocopy JTF_NUMBER_TABLE
352: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 353: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100

349: , p9_a2 out nocopy JTF_NUMBER_TABLE
350: , p9_a3 out nocopy JTF_NUMBER_TABLE
351: , p9_a4 out nocopy JTF_NUMBER_TABLE
352: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
353: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
354: , p9_a7 out nocopy JTF_NUMBER_TABLE
355: , p9_a8 out nocopy JTF_NUMBER_TABLE
356: , p9_a9 out nocopy JTF_NUMBER_TABLE
357: , p9_a10 out nocopy JTF_NUMBER_TABLE

Line 359: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100

355: , p9_a8 out nocopy JTF_NUMBER_TABLE
356: , p9_a9 out nocopy JTF_NUMBER_TABLE
357: , p9_a10 out nocopy JTF_NUMBER_TABLE
358: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
359: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
360: , p9_a13 out nocopy JTF_NUMBER_TABLE
361: , p9_a14 out nocopy JTF_NUMBER_TABLE
362: , p9_a15 out nocopy JTF_NUMBER_TABLE
363: , p9_a16 out nocopy JTF_NUMBER_TABLE