DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE

Line 17: , a1 JTF_NUMBER_TABLE

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE

Line 20: , a4 JTF_NUMBER_TABLE

16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_DATE_TABLE

Line 21: , a5 JTF_NUMBER_TABLE

17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_DATE_TABLE

Line 22: , a6 JTF_NUMBER_TABLE

18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_DATE_TABLE

Line 23: , a7 JTF_NUMBER_TABLE

19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_NUMBER_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_DATE_TABLE
25: , a9 JTF_DATE_TABLE
26: , a10 JTF_DATE_TABLE
27: , a11 JTF_DATE_TABLE

Line 30: , a14 JTF_NUMBER_TABLE

26: , a10 JTF_DATE_TABLE
27: , a11 JTF_DATE_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_NUMBER_TABLE

Line 31: , a15 JTF_NUMBER_TABLE

27: , a11 JTF_DATE_TABLE
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100

Line 32: , a16 JTF_NUMBER_TABLE

28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100

Line 34: , a18 JTF_NUMBER_TABLE

30: , a14 JTF_NUMBER_TABLE
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_VARCHAR2_TABLE_100
34: , a18 JTF_NUMBER_TABLE
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_VARCHAR2_TABLE_100

Line 39: , a23 JTF_NUMBER_TABLE

35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_VARCHAR2_TABLE_100
39: , a23 JTF_NUMBER_TABLE
40: ) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if a0 is not null and a0.count > 0 then

Line 81: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

77: end loop;
78: end if;
79: end if;
80: end rosetta_table_copy_in_p1;
81: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_NUMBER_TABLE
83: , a2 out nocopy JTF_VARCHAR2_TABLE_100
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_NUMBER_TABLE

Line 82: , a1 out nocopy JTF_NUMBER_TABLE

78: end if;
79: end if;
80: end rosetta_table_copy_in_p1;
81: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_NUMBER_TABLE
83: , a2 out nocopy JTF_VARCHAR2_TABLE_100
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_NUMBER_TABLE
86: , a5 out nocopy JTF_NUMBER_TABLE

Line 85: , a4 out nocopy JTF_NUMBER_TABLE

81: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_NUMBER_TABLE
83: , a2 out nocopy JTF_VARCHAR2_TABLE_100
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_NUMBER_TABLE
86: , a5 out nocopy JTF_NUMBER_TABLE
87: , a6 out nocopy JTF_NUMBER_TABLE
88: , a7 out nocopy JTF_NUMBER_TABLE
89: , a8 out nocopy JTF_DATE_TABLE

Line 86: , a5 out nocopy JTF_NUMBER_TABLE

82: , a1 out nocopy JTF_NUMBER_TABLE
83: , a2 out nocopy JTF_VARCHAR2_TABLE_100
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_NUMBER_TABLE
86: , a5 out nocopy JTF_NUMBER_TABLE
87: , a6 out nocopy JTF_NUMBER_TABLE
88: , a7 out nocopy JTF_NUMBER_TABLE
89: , a8 out nocopy JTF_DATE_TABLE
90: , a9 out nocopy JTF_DATE_TABLE

Line 87: , a6 out nocopy JTF_NUMBER_TABLE

83: , a2 out nocopy JTF_VARCHAR2_TABLE_100
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_NUMBER_TABLE
86: , a5 out nocopy JTF_NUMBER_TABLE
87: , a6 out nocopy JTF_NUMBER_TABLE
88: , a7 out nocopy JTF_NUMBER_TABLE
89: , a8 out nocopy JTF_DATE_TABLE
90: , a9 out nocopy JTF_DATE_TABLE
91: , a10 out nocopy JTF_DATE_TABLE

Line 88: , a7 out nocopy JTF_NUMBER_TABLE

84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_NUMBER_TABLE
86: , a5 out nocopy JTF_NUMBER_TABLE
87: , a6 out nocopy JTF_NUMBER_TABLE
88: , a7 out nocopy JTF_NUMBER_TABLE
89: , a8 out nocopy JTF_DATE_TABLE
90: , a9 out nocopy JTF_DATE_TABLE
91: , a10 out nocopy JTF_DATE_TABLE
92: , a11 out nocopy JTF_DATE_TABLE

Line 95: , a14 out nocopy JTF_NUMBER_TABLE

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

Line 96: , a15 out nocopy JTF_NUMBER_TABLE

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

Line 97: , a16 out nocopy JTF_NUMBER_TABLE

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

Line 99: , a18 out nocopy JTF_NUMBER_TABLE

95: , a14 out nocopy JTF_NUMBER_TABLE
96: , a15 out nocopy JTF_NUMBER_TABLE
97: , a16 out nocopy JTF_NUMBER_TABLE
98: , a17 out nocopy JTF_VARCHAR2_TABLE_100
99: , a18 out nocopy JTF_NUMBER_TABLE
100: , a19 out nocopy JTF_VARCHAR2_TABLE_100
101: , a20 out nocopy JTF_VARCHAR2_TABLE_100
102: , a21 out nocopy JTF_VARCHAR2_TABLE_100
103: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 104: , a23 out nocopy JTF_NUMBER_TABLE

100: , a19 out nocopy JTF_VARCHAR2_TABLE_100
101: , a20 out nocopy JTF_VARCHAR2_TABLE_100
102: , a21 out nocopy JTF_VARCHAR2_TABLE_100
103: , a22 out nocopy JTF_VARCHAR2_TABLE_100
104: , a23 out nocopy JTF_NUMBER_TABLE
105: ) as
106: ddindx binary_integer; indx binary_integer;
107: begin
108: if t is null or t.count = 0 then

Line 109: a0 := JTF_NUMBER_TABLE();

105: ) as
106: ddindx binary_integer; indx binary_integer;
107: begin
108: if t is null or t.count = 0 then
109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_NUMBER_TABLE();
111: a2 := JTF_VARCHAR2_TABLE_100();
112: a3 := JTF_VARCHAR2_TABLE_100();
113: a4 := JTF_NUMBER_TABLE();

Line 110: a1 := JTF_NUMBER_TABLE();

106: ddindx binary_integer; indx binary_integer;
107: begin
108: if t is null or t.count = 0 then
109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_NUMBER_TABLE();
111: a2 := JTF_VARCHAR2_TABLE_100();
112: a3 := JTF_VARCHAR2_TABLE_100();
113: a4 := JTF_NUMBER_TABLE();
114: a5 := JTF_NUMBER_TABLE();

Line 113: a4 := JTF_NUMBER_TABLE();

109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_NUMBER_TABLE();
111: a2 := JTF_VARCHAR2_TABLE_100();
112: a3 := JTF_VARCHAR2_TABLE_100();
113: a4 := JTF_NUMBER_TABLE();
114: a5 := JTF_NUMBER_TABLE();
115: a6 := JTF_NUMBER_TABLE();
116: a7 := JTF_NUMBER_TABLE();
117: a8 := JTF_DATE_TABLE();

Line 114: a5 := JTF_NUMBER_TABLE();

110: a1 := JTF_NUMBER_TABLE();
111: a2 := JTF_VARCHAR2_TABLE_100();
112: a3 := JTF_VARCHAR2_TABLE_100();
113: a4 := JTF_NUMBER_TABLE();
114: a5 := JTF_NUMBER_TABLE();
115: a6 := JTF_NUMBER_TABLE();
116: a7 := JTF_NUMBER_TABLE();
117: a8 := JTF_DATE_TABLE();
118: a9 := JTF_DATE_TABLE();

Line 115: a6 := JTF_NUMBER_TABLE();

111: a2 := JTF_VARCHAR2_TABLE_100();
112: a3 := JTF_VARCHAR2_TABLE_100();
113: a4 := JTF_NUMBER_TABLE();
114: a5 := JTF_NUMBER_TABLE();
115: a6 := JTF_NUMBER_TABLE();
116: a7 := JTF_NUMBER_TABLE();
117: a8 := JTF_DATE_TABLE();
118: a9 := JTF_DATE_TABLE();
119: a10 := JTF_DATE_TABLE();

Line 116: a7 := JTF_NUMBER_TABLE();

112: a3 := JTF_VARCHAR2_TABLE_100();
113: a4 := JTF_NUMBER_TABLE();
114: a5 := JTF_NUMBER_TABLE();
115: a6 := JTF_NUMBER_TABLE();
116: a7 := JTF_NUMBER_TABLE();
117: a8 := JTF_DATE_TABLE();
118: a9 := JTF_DATE_TABLE();
119: a10 := JTF_DATE_TABLE();
120: a11 := JTF_DATE_TABLE();

Line 123: a14 := JTF_NUMBER_TABLE();

119: a10 := JTF_DATE_TABLE();
120: a11 := JTF_DATE_TABLE();
121: a12 := JTF_VARCHAR2_TABLE_100();
122: a13 := JTF_VARCHAR2_TABLE_100();
123: a14 := JTF_NUMBER_TABLE();
124: a15 := JTF_NUMBER_TABLE();
125: a16 := JTF_NUMBER_TABLE();
126: a17 := JTF_VARCHAR2_TABLE_100();
127: a18 := JTF_NUMBER_TABLE();

Line 124: a15 := JTF_NUMBER_TABLE();

120: a11 := JTF_DATE_TABLE();
121: a12 := JTF_VARCHAR2_TABLE_100();
122: a13 := JTF_VARCHAR2_TABLE_100();
123: a14 := JTF_NUMBER_TABLE();
124: a15 := JTF_NUMBER_TABLE();
125: a16 := JTF_NUMBER_TABLE();
126: a17 := JTF_VARCHAR2_TABLE_100();
127: a18 := JTF_NUMBER_TABLE();
128: a19 := JTF_VARCHAR2_TABLE_100();

Line 125: a16 := JTF_NUMBER_TABLE();

121: a12 := JTF_VARCHAR2_TABLE_100();
122: a13 := JTF_VARCHAR2_TABLE_100();
123: a14 := JTF_NUMBER_TABLE();
124: a15 := JTF_NUMBER_TABLE();
125: a16 := JTF_NUMBER_TABLE();
126: a17 := JTF_VARCHAR2_TABLE_100();
127: a18 := JTF_NUMBER_TABLE();
128: a19 := JTF_VARCHAR2_TABLE_100();
129: a20 := JTF_VARCHAR2_TABLE_100();

Line 127: a18 := JTF_NUMBER_TABLE();

123: a14 := JTF_NUMBER_TABLE();
124: a15 := JTF_NUMBER_TABLE();
125: a16 := JTF_NUMBER_TABLE();
126: a17 := JTF_VARCHAR2_TABLE_100();
127: a18 := JTF_NUMBER_TABLE();
128: a19 := JTF_VARCHAR2_TABLE_100();
129: a20 := JTF_VARCHAR2_TABLE_100();
130: a21 := JTF_VARCHAR2_TABLE_100();
131: a22 := JTF_VARCHAR2_TABLE_100();

Line 132: a23 := JTF_NUMBER_TABLE();

128: a19 := JTF_VARCHAR2_TABLE_100();
129: a20 := JTF_VARCHAR2_TABLE_100();
130: a21 := JTF_VARCHAR2_TABLE_100();
131: a22 := JTF_VARCHAR2_TABLE_100();
132: a23 := JTF_NUMBER_TABLE();
133: else
134: a0 := JTF_NUMBER_TABLE();
135: a1 := JTF_NUMBER_TABLE();
136: a2 := JTF_VARCHAR2_TABLE_100();

Line 134: a0 := JTF_NUMBER_TABLE();

130: a21 := JTF_VARCHAR2_TABLE_100();
131: a22 := JTF_VARCHAR2_TABLE_100();
132: a23 := JTF_NUMBER_TABLE();
133: else
134: a0 := JTF_NUMBER_TABLE();
135: a1 := JTF_NUMBER_TABLE();
136: a2 := JTF_VARCHAR2_TABLE_100();
137: a3 := JTF_VARCHAR2_TABLE_100();
138: a4 := JTF_NUMBER_TABLE();

Line 135: a1 := JTF_NUMBER_TABLE();

131: a22 := JTF_VARCHAR2_TABLE_100();
132: a23 := JTF_NUMBER_TABLE();
133: else
134: a0 := JTF_NUMBER_TABLE();
135: a1 := JTF_NUMBER_TABLE();
136: a2 := JTF_VARCHAR2_TABLE_100();
137: a3 := JTF_VARCHAR2_TABLE_100();
138: a4 := JTF_NUMBER_TABLE();
139: a5 := JTF_NUMBER_TABLE();

Line 138: a4 := JTF_NUMBER_TABLE();

134: a0 := JTF_NUMBER_TABLE();
135: a1 := JTF_NUMBER_TABLE();
136: a2 := JTF_VARCHAR2_TABLE_100();
137: a3 := JTF_VARCHAR2_TABLE_100();
138: a4 := JTF_NUMBER_TABLE();
139: a5 := JTF_NUMBER_TABLE();
140: a6 := JTF_NUMBER_TABLE();
141: a7 := JTF_NUMBER_TABLE();
142: a8 := JTF_DATE_TABLE();

Line 139: a5 := JTF_NUMBER_TABLE();

135: a1 := JTF_NUMBER_TABLE();
136: a2 := JTF_VARCHAR2_TABLE_100();
137: a3 := JTF_VARCHAR2_TABLE_100();
138: a4 := JTF_NUMBER_TABLE();
139: a5 := JTF_NUMBER_TABLE();
140: a6 := JTF_NUMBER_TABLE();
141: a7 := JTF_NUMBER_TABLE();
142: a8 := JTF_DATE_TABLE();
143: a9 := JTF_DATE_TABLE();

Line 140: a6 := JTF_NUMBER_TABLE();

136: a2 := JTF_VARCHAR2_TABLE_100();
137: a3 := JTF_VARCHAR2_TABLE_100();
138: a4 := JTF_NUMBER_TABLE();
139: a5 := JTF_NUMBER_TABLE();
140: a6 := JTF_NUMBER_TABLE();
141: a7 := JTF_NUMBER_TABLE();
142: a8 := JTF_DATE_TABLE();
143: a9 := JTF_DATE_TABLE();
144: a10 := JTF_DATE_TABLE();

Line 141: a7 := JTF_NUMBER_TABLE();

137: a3 := JTF_VARCHAR2_TABLE_100();
138: a4 := JTF_NUMBER_TABLE();
139: a5 := JTF_NUMBER_TABLE();
140: a6 := JTF_NUMBER_TABLE();
141: a7 := JTF_NUMBER_TABLE();
142: a8 := JTF_DATE_TABLE();
143: a9 := JTF_DATE_TABLE();
144: a10 := JTF_DATE_TABLE();
145: a11 := JTF_DATE_TABLE();

Line 148: a14 := JTF_NUMBER_TABLE();

144: a10 := JTF_DATE_TABLE();
145: a11 := JTF_DATE_TABLE();
146: a12 := JTF_VARCHAR2_TABLE_100();
147: a13 := JTF_VARCHAR2_TABLE_100();
148: a14 := JTF_NUMBER_TABLE();
149: a15 := JTF_NUMBER_TABLE();
150: a16 := JTF_NUMBER_TABLE();
151: a17 := JTF_VARCHAR2_TABLE_100();
152: a18 := JTF_NUMBER_TABLE();

Line 149: a15 := JTF_NUMBER_TABLE();

145: a11 := JTF_DATE_TABLE();
146: a12 := JTF_VARCHAR2_TABLE_100();
147: a13 := JTF_VARCHAR2_TABLE_100();
148: a14 := JTF_NUMBER_TABLE();
149: a15 := JTF_NUMBER_TABLE();
150: a16 := JTF_NUMBER_TABLE();
151: a17 := JTF_VARCHAR2_TABLE_100();
152: a18 := JTF_NUMBER_TABLE();
153: a19 := JTF_VARCHAR2_TABLE_100();

Line 150: a16 := JTF_NUMBER_TABLE();

146: a12 := JTF_VARCHAR2_TABLE_100();
147: a13 := JTF_VARCHAR2_TABLE_100();
148: a14 := JTF_NUMBER_TABLE();
149: a15 := JTF_NUMBER_TABLE();
150: a16 := JTF_NUMBER_TABLE();
151: a17 := JTF_VARCHAR2_TABLE_100();
152: a18 := JTF_NUMBER_TABLE();
153: a19 := JTF_VARCHAR2_TABLE_100();
154: a20 := JTF_VARCHAR2_TABLE_100();

Line 152: a18 := JTF_NUMBER_TABLE();

148: a14 := JTF_NUMBER_TABLE();
149: a15 := JTF_NUMBER_TABLE();
150: a16 := JTF_NUMBER_TABLE();
151: a17 := JTF_VARCHAR2_TABLE_100();
152: a18 := JTF_NUMBER_TABLE();
153: a19 := JTF_VARCHAR2_TABLE_100();
154: a20 := JTF_VARCHAR2_TABLE_100();
155: a21 := JTF_VARCHAR2_TABLE_100();
156: a22 := JTF_VARCHAR2_TABLE_100();

Line 157: a23 := JTF_NUMBER_TABLE();

153: a19 := JTF_VARCHAR2_TABLE_100();
154: a20 := JTF_VARCHAR2_TABLE_100();
155: a21 := JTF_VARCHAR2_TABLE_100();
156: a22 := JTF_VARCHAR2_TABLE_100();
157: a23 := JTF_NUMBER_TABLE();
158: if t.count > 0 then
159: a0.extend(t.count);
160: a1.extend(t.count);
161: a2.extend(t.count);

Line 220: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE

216: end if;
217: end if;
218: end rosetta_table_copy_out_p1;
219:
220: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
221: , a1 JTF_NUMBER_TABLE
222: , a2 JTF_NUMBER_TABLE
223: , a3 JTF_VARCHAR2_TABLE_100
224: , a4 JTF_NUMBER_TABLE

Line 221: , a1 JTF_NUMBER_TABLE

217: end if;
218: end rosetta_table_copy_out_p1;
219:
220: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
221: , a1 JTF_NUMBER_TABLE
222: , a2 JTF_NUMBER_TABLE
223: , a3 JTF_VARCHAR2_TABLE_100
224: , a4 JTF_NUMBER_TABLE
225: , a5 JTF_NUMBER_TABLE

Line 222: , a2 JTF_NUMBER_TABLE

218: end rosetta_table_copy_out_p1;
219:
220: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
221: , a1 JTF_NUMBER_TABLE
222: , a2 JTF_NUMBER_TABLE
223: , a3 JTF_VARCHAR2_TABLE_100
224: , a4 JTF_NUMBER_TABLE
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_NUMBER_TABLE

Line 224: , a4 JTF_NUMBER_TABLE

220: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
221: , a1 JTF_NUMBER_TABLE
222: , a2 JTF_NUMBER_TABLE
223: , a3 JTF_VARCHAR2_TABLE_100
224: , a4 JTF_NUMBER_TABLE
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_NUMBER_TABLE
227: , a7 JTF_VARCHAR2_TABLE_2000
228: , a8 JTF_NUMBER_TABLE

Line 225: , a5 JTF_NUMBER_TABLE

221: , a1 JTF_NUMBER_TABLE
222: , a2 JTF_NUMBER_TABLE
223: , a3 JTF_VARCHAR2_TABLE_100
224: , a4 JTF_NUMBER_TABLE
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_NUMBER_TABLE
227: , a7 JTF_VARCHAR2_TABLE_2000
228: , a8 JTF_NUMBER_TABLE
229: , a9 JTF_NUMBER_TABLE

Line 226: , a6 JTF_NUMBER_TABLE

222: , a2 JTF_NUMBER_TABLE
223: , a3 JTF_VARCHAR2_TABLE_100
224: , a4 JTF_NUMBER_TABLE
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_NUMBER_TABLE
227: , a7 JTF_VARCHAR2_TABLE_2000
228: , a8 JTF_NUMBER_TABLE
229: , a9 JTF_NUMBER_TABLE
230: , a10 JTF_DATE_TABLE

Line 228: , a8 JTF_NUMBER_TABLE

224: , a4 JTF_NUMBER_TABLE
225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_NUMBER_TABLE
227: , a7 JTF_VARCHAR2_TABLE_2000
228: , a8 JTF_NUMBER_TABLE
229: , a9 JTF_NUMBER_TABLE
230: , a10 JTF_DATE_TABLE
231: , a11 JTF_DATE_TABLE
232: , a12 JTF_DATE_TABLE

Line 229: , a9 JTF_NUMBER_TABLE

225: , a5 JTF_NUMBER_TABLE
226: , a6 JTF_NUMBER_TABLE
227: , a7 JTF_VARCHAR2_TABLE_2000
228: , a8 JTF_NUMBER_TABLE
229: , a9 JTF_NUMBER_TABLE
230: , a10 JTF_DATE_TABLE
231: , a11 JTF_DATE_TABLE
232: , a12 JTF_DATE_TABLE
233: , a13 JTF_DATE_TABLE

Line 269: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

265: end loop;
266: end if;
267: end if;
268: end rosetta_table_copy_in_p3;
269: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
270: , a1 out nocopy JTF_NUMBER_TABLE
271: , a2 out nocopy JTF_NUMBER_TABLE
272: , a3 out nocopy JTF_VARCHAR2_TABLE_100
273: , a4 out nocopy JTF_NUMBER_TABLE

Line 270: , a1 out nocopy JTF_NUMBER_TABLE

266: end if;
267: end if;
268: end rosetta_table_copy_in_p3;
269: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
270: , a1 out nocopy JTF_NUMBER_TABLE
271: , a2 out nocopy JTF_NUMBER_TABLE
272: , a3 out nocopy JTF_VARCHAR2_TABLE_100
273: , a4 out nocopy JTF_NUMBER_TABLE
274: , a5 out nocopy JTF_NUMBER_TABLE

Line 271: , a2 out nocopy JTF_NUMBER_TABLE

267: end if;
268: end rosetta_table_copy_in_p3;
269: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
270: , a1 out nocopy JTF_NUMBER_TABLE
271: , a2 out nocopy JTF_NUMBER_TABLE
272: , a3 out nocopy JTF_VARCHAR2_TABLE_100
273: , a4 out nocopy JTF_NUMBER_TABLE
274: , a5 out nocopy JTF_NUMBER_TABLE
275: , a6 out nocopy JTF_NUMBER_TABLE

Line 273: , a4 out nocopy JTF_NUMBER_TABLE

269: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
270: , a1 out nocopy JTF_NUMBER_TABLE
271: , a2 out nocopy JTF_NUMBER_TABLE
272: , a3 out nocopy JTF_VARCHAR2_TABLE_100
273: , a4 out nocopy JTF_NUMBER_TABLE
274: , a5 out nocopy JTF_NUMBER_TABLE
275: , a6 out nocopy JTF_NUMBER_TABLE
276: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
277: , a8 out nocopy JTF_NUMBER_TABLE

Line 274: , a5 out nocopy JTF_NUMBER_TABLE

270: , a1 out nocopy JTF_NUMBER_TABLE
271: , a2 out nocopy JTF_NUMBER_TABLE
272: , a3 out nocopy JTF_VARCHAR2_TABLE_100
273: , a4 out nocopy JTF_NUMBER_TABLE
274: , a5 out nocopy JTF_NUMBER_TABLE
275: , a6 out nocopy JTF_NUMBER_TABLE
276: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
277: , a8 out nocopy JTF_NUMBER_TABLE
278: , a9 out nocopy JTF_NUMBER_TABLE

Line 275: , a6 out nocopy JTF_NUMBER_TABLE

271: , a2 out nocopy JTF_NUMBER_TABLE
272: , a3 out nocopy JTF_VARCHAR2_TABLE_100
273: , a4 out nocopy JTF_NUMBER_TABLE
274: , a5 out nocopy JTF_NUMBER_TABLE
275: , a6 out nocopy JTF_NUMBER_TABLE
276: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
277: , a8 out nocopy JTF_NUMBER_TABLE
278: , a9 out nocopy JTF_NUMBER_TABLE
279: , a10 out nocopy JTF_DATE_TABLE

Line 277: , a8 out nocopy JTF_NUMBER_TABLE

273: , a4 out nocopy JTF_NUMBER_TABLE
274: , a5 out nocopy JTF_NUMBER_TABLE
275: , a6 out nocopy JTF_NUMBER_TABLE
276: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
277: , a8 out nocopy JTF_NUMBER_TABLE
278: , a9 out nocopy JTF_NUMBER_TABLE
279: , a10 out nocopy JTF_DATE_TABLE
280: , a11 out nocopy JTF_DATE_TABLE
281: , a12 out nocopy JTF_DATE_TABLE

Line 278: , a9 out nocopy JTF_NUMBER_TABLE

274: , a5 out nocopy JTF_NUMBER_TABLE
275: , a6 out nocopy JTF_NUMBER_TABLE
276: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
277: , a8 out nocopy JTF_NUMBER_TABLE
278: , a9 out nocopy JTF_NUMBER_TABLE
279: , a10 out nocopy JTF_DATE_TABLE
280: , a11 out nocopy JTF_DATE_TABLE
281: , a12 out nocopy JTF_DATE_TABLE
282: , a13 out nocopy JTF_DATE_TABLE

Line 289: a0 := JTF_NUMBER_TABLE();

285: ) as
286: ddindx binary_integer; indx binary_integer;
287: begin
288: if t is null or t.count = 0 then
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_NUMBER_TABLE();
292: a3 := JTF_VARCHAR2_TABLE_100();
293: a4 := JTF_NUMBER_TABLE();

Line 290: a1 := JTF_NUMBER_TABLE();

286: ddindx binary_integer; indx binary_integer;
287: begin
288: if t is null or t.count = 0 then
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_NUMBER_TABLE();
292: a3 := JTF_VARCHAR2_TABLE_100();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();

Line 291: a2 := JTF_NUMBER_TABLE();

287: begin
288: if t is null or t.count = 0 then
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_NUMBER_TABLE();
292: a3 := JTF_VARCHAR2_TABLE_100();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_NUMBER_TABLE();

Line 293: a4 := JTF_NUMBER_TABLE();

289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_NUMBER_TABLE();
292: a3 := JTF_VARCHAR2_TABLE_100();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_NUMBER_TABLE();
296: a7 := JTF_VARCHAR2_TABLE_2000();
297: a8 := JTF_NUMBER_TABLE();

Line 294: a5 := JTF_NUMBER_TABLE();

290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_NUMBER_TABLE();
292: a3 := JTF_VARCHAR2_TABLE_100();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_NUMBER_TABLE();
296: a7 := JTF_VARCHAR2_TABLE_2000();
297: a8 := JTF_NUMBER_TABLE();
298: a9 := JTF_NUMBER_TABLE();

Line 295: a6 := JTF_NUMBER_TABLE();

291: a2 := JTF_NUMBER_TABLE();
292: a3 := JTF_VARCHAR2_TABLE_100();
293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_NUMBER_TABLE();
296: a7 := JTF_VARCHAR2_TABLE_2000();
297: a8 := JTF_NUMBER_TABLE();
298: a9 := JTF_NUMBER_TABLE();
299: a10 := JTF_DATE_TABLE();

Line 297: a8 := JTF_NUMBER_TABLE();

293: a4 := JTF_NUMBER_TABLE();
294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_NUMBER_TABLE();
296: a7 := JTF_VARCHAR2_TABLE_2000();
297: a8 := JTF_NUMBER_TABLE();
298: a9 := JTF_NUMBER_TABLE();
299: a10 := JTF_DATE_TABLE();
300: a11 := JTF_DATE_TABLE();
301: a12 := JTF_DATE_TABLE();

Line 298: a9 := JTF_NUMBER_TABLE();

294: a5 := JTF_NUMBER_TABLE();
295: a6 := JTF_NUMBER_TABLE();
296: a7 := JTF_VARCHAR2_TABLE_2000();
297: a8 := JTF_NUMBER_TABLE();
298: a9 := JTF_NUMBER_TABLE();
299: a10 := JTF_DATE_TABLE();
300: a11 := JTF_DATE_TABLE();
301: a12 := JTF_DATE_TABLE();
302: a13 := JTF_DATE_TABLE();

Line 306: a0 := JTF_NUMBER_TABLE();

302: a13 := JTF_DATE_TABLE();
303: a14 := JTF_VARCHAR2_TABLE_100();
304: a15 := JTF_VARCHAR2_TABLE_100();
305: else
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_NUMBER_TABLE();
308: a2 := JTF_NUMBER_TABLE();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_NUMBER_TABLE();

Line 307: a1 := JTF_NUMBER_TABLE();

303: a14 := JTF_VARCHAR2_TABLE_100();
304: a15 := JTF_VARCHAR2_TABLE_100();
305: else
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_NUMBER_TABLE();
308: a2 := JTF_NUMBER_TABLE();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_NUMBER_TABLE();
311: a5 := JTF_NUMBER_TABLE();

Line 308: a2 := JTF_NUMBER_TABLE();

304: a15 := JTF_VARCHAR2_TABLE_100();
305: else
306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_NUMBER_TABLE();
308: a2 := JTF_NUMBER_TABLE();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_NUMBER_TABLE();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();

Line 310: a4 := JTF_NUMBER_TABLE();

306: a0 := JTF_NUMBER_TABLE();
307: a1 := JTF_NUMBER_TABLE();
308: a2 := JTF_NUMBER_TABLE();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_NUMBER_TABLE();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_VARCHAR2_TABLE_2000();
314: a8 := JTF_NUMBER_TABLE();

Line 311: a5 := JTF_NUMBER_TABLE();

307: a1 := JTF_NUMBER_TABLE();
308: a2 := JTF_NUMBER_TABLE();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_NUMBER_TABLE();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_VARCHAR2_TABLE_2000();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := JTF_NUMBER_TABLE();

Line 312: a6 := JTF_NUMBER_TABLE();

308: a2 := JTF_NUMBER_TABLE();
309: a3 := JTF_VARCHAR2_TABLE_100();
310: a4 := JTF_NUMBER_TABLE();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_VARCHAR2_TABLE_2000();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := JTF_NUMBER_TABLE();
316: a10 := JTF_DATE_TABLE();

Line 314: a8 := JTF_NUMBER_TABLE();

310: a4 := JTF_NUMBER_TABLE();
311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_VARCHAR2_TABLE_2000();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := JTF_NUMBER_TABLE();
316: a10 := JTF_DATE_TABLE();
317: a11 := JTF_DATE_TABLE();
318: a12 := JTF_DATE_TABLE();

Line 315: a9 := JTF_NUMBER_TABLE();

311: a5 := JTF_NUMBER_TABLE();
312: a6 := JTF_NUMBER_TABLE();
313: a7 := JTF_VARCHAR2_TABLE_2000();
314: a8 := JTF_NUMBER_TABLE();
315: a9 := JTF_NUMBER_TABLE();
316: a10 := JTF_DATE_TABLE();
317: a11 := JTF_DATE_TABLE();
318: a12 := JTF_DATE_TABLE();
319: a13 := JTF_DATE_TABLE();

Line 368: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE

364: end if;
365: end if;
366: end rosetta_table_copy_out_p3;
367:
368: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
369: , a1 JTF_NUMBER_TABLE
370: , a2 JTF_VARCHAR2_TABLE_100
371: , a3 JTF_VARCHAR2_TABLE_100
372: , a4 JTF_NUMBER_TABLE

Line 369: , a1 JTF_NUMBER_TABLE

365: end if;
366: end rosetta_table_copy_out_p3;
367:
368: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
369: , a1 JTF_NUMBER_TABLE
370: , a2 JTF_VARCHAR2_TABLE_100
371: , a3 JTF_VARCHAR2_TABLE_100
372: , a4 JTF_NUMBER_TABLE
373: , a5 JTF_NUMBER_TABLE

Line 372: , a4 JTF_NUMBER_TABLE

368: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
369: , a1 JTF_NUMBER_TABLE
370: , a2 JTF_VARCHAR2_TABLE_100
371: , a3 JTF_VARCHAR2_TABLE_100
372: , a4 JTF_NUMBER_TABLE
373: , a5 JTF_NUMBER_TABLE
374: , a6 JTF_VARCHAR2_TABLE_100
375: , a7 JTF_VARCHAR2_TABLE_200
376: , a8 JTF_NUMBER_TABLE

Line 373: , a5 JTF_NUMBER_TABLE

369: , a1 JTF_NUMBER_TABLE
370: , a2 JTF_VARCHAR2_TABLE_100
371: , a3 JTF_VARCHAR2_TABLE_100
372: , a4 JTF_NUMBER_TABLE
373: , a5 JTF_NUMBER_TABLE
374: , a6 JTF_VARCHAR2_TABLE_100
375: , a7 JTF_VARCHAR2_TABLE_200
376: , a8 JTF_NUMBER_TABLE
377: , a9 JTF_NUMBER_TABLE

Line 376: , a8 JTF_NUMBER_TABLE

372: , a4 JTF_NUMBER_TABLE
373: , a5 JTF_NUMBER_TABLE
374: , a6 JTF_VARCHAR2_TABLE_100
375: , a7 JTF_VARCHAR2_TABLE_200
376: , a8 JTF_NUMBER_TABLE
377: , a9 JTF_NUMBER_TABLE
378: , a10 JTF_NUMBER_TABLE
379: , a11 JTF_DATE_TABLE
380: ) as

Line 377: , a9 JTF_NUMBER_TABLE

373: , a5 JTF_NUMBER_TABLE
374: , a6 JTF_VARCHAR2_TABLE_100
375: , a7 JTF_VARCHAR2_TABLE_200
376: , a8 JTF_NUMBER_TABLE
377: , a9 JTF_NUMBER_TABLE
378: , a10 JTF_NUMBER_TABLE
379: , a11 JTF_DATE_TABLE
380: ) as
381: ddindx binary_integer; indx binary_integer;

Line 378: , a10 JTF_NUMBER_TABLE

374: , a6 JTF_VARCHAR2_TABLE_100
375: , a7 JTF_VARCHAR2_TABLE_200
376: , a8 JTF_NUMBER_TABLE
377: , a9 JTF_NUMBER_TABLE
378: , a10 JTF_NUMBER_TABLE
379: , a11 JTF_DATE_TABLE
380: ) as
381: ddindx binary_integer; indx binary_integer;
382: begin

Line 409: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

405: end loop;
406: end if;
407: end if;
408: end rosetta_table_copy_in_p7;
409: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
410: , a1 out nocopy JTF_NUMBER_TABLE
411: , a2 out nocopy JTF_VARCHAR2_TABLE_100
412: , a3 out nocopy JTF_VARCHAR2_TABLE_100
413: , a4 out nocopy JTF_NUMBER_TABLE

Line 410: , a1 out nocopy JTF_NUMBER_TABLE

406: end if;
407: end if;
408: end rosetta_table_copy_in_p7;
409: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
410: , a1 out nocopy JTF_NUMBER_TABLE
411: , a2 out nocopy JTF_VARCHAR2_TABLE_100
412: , a3 out nocopy JTF_VARCHAR2_TABLE_100
413: , a4 out nocopy JTF_NUMBER_TABLE
414: , a5 out nocopy JTF_NUMBER_TABLE

Line 413: , a4 out nocopy JTF_NUMBER_TABLE

409: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
410: , a1 out nocopy JTF_NUMBER_TABLE
411: , a2 out nocopy JTF_VARCHAR2_TABLE_100
412: , a3 out nocopy JTF_VARCHAR2_TABLE_100
413: , a4 out nocopy JTF_NUMBER_TABLE
414: , a5 out nocopy JTF_NUMBER_TABLE
415: , a6 out nocopy JTF_VARCHAR2_TABLE_100
416: , a7 out nocopy JTF_VARCHAR2_TABLE_200
417: , a8 out nocopy JTF_NUMBER_TABLE

Line 414: , a5 out nocopy JTF_NUMBER_TABLE

410: , a1 out nocopy JTF_NUMBER_TABLE
411: , a2 out nocopy JTF_VARCHAR2_TABLE_100
412: , a3 out nocopy JTF_VARCHAR2_TABLE_100
413: , a4 out nocopy JTF_NUMBER_TABLE
414: , a5 out nocopy JTF_NUMBER_TABLE
415: , a6 out nocopy JTF_VARCHAR2_TABLE_100
416: , a7 out nocopy JTF_VARCHAR2_TABLE_200
417: , a8 out nocopy JTF_NUMBER_TABLE
418: , a9 out nocopy JTF_NUMBER_TABLE

Line 417: , a8 out nocopy JTF_NUMBER_TABLE

413: , a4 out nocopy JTF_NUMBER_TABLE
414: , a5 out nocopy JTF_NUMBER_TABLE
415: , a6 out nocopy JTF_VARCHAR2_TABLE_100
416: , a7 out nocopy JTF_VARCHAR2_TABLE_200
417: , a8 out nocopy JTF_NUMBER_TABLE
418: , a9 out nocopy JTF_NUMBER_TABLE
419: , a10 out nocopy JTF_NUMBER_TABLE
420: , a11 out nocopy JTF_DATE_TABLE
421: ) as

Line 418: , a9 out nocopy JTF_NUMBER_TABLE

414: , a5 out nocopy JTF_NUMBER_TABLE
415: , a6 out nocopy JTF_VARCHAR2_TABLE_100
416: , a7 out nocopy JTF_VARCHAR2_TABLE_200
417: , a8 out nocopy JTF_NUMBER_TABLE
418: , a9 out nocopy JTF_NUMBER_TABLE
419: , a10 out nocopy JTF_NUMBER_TABLE
420: , a11 out nocopy JTF_DATE_TABLE
421: ) as
422: ddindx binary_integer; indx binary_integer;

Line 419: , a10 out nocopy JTF_NUMBER_TABLE

415: , a6 out nocopy JTF_VARCHAR2_TABLE_100
416: , a7 out nocopy JTF_VARCHAR2_TABLE_200
417: , a8 out nocopy JTF_NUMBER_TABLE
418: , a9 out nocopy JTF_NUMBER_TABLE
419: , a10 out nocopy JTF_NUMBER_TABLE
420: , a11 out nocopy JTF_DATE_TABLE
421: ) as
422: ddindx binary_integer; indx binary_integer;
423: begin

Line 425: a0 := JTF_NUMBER_TABLE();

421: ) as
422: ddindx binary_integer; indx binary_integer;
423: begin
424: if t is null or t.count = 0 then
425: a0 := JTF_NUMBER_TABLE();
426: a1 := JTF_NUMBER_TABLE();
427: a2 := JTF_VARCHAR2_TABLE_100();
428: a3 := JTF_VARCHAR2_TABLE_100();
429: a4 := JTF_NUMBER_TABLE();

Line 426: a1 := JTF_NUMBER_TABLE();

422: ddindx binary_integer; indx binary_integer;
423: begin
424: if t is null or t.count = 0 then
425: a0 := JTF_NUMBER_TABLE();
426: a1 := JTF_NUMBER_TABLE();
427: a2 := JTF_VARCHAR2_TABLE_100();
428: a3 := JTF_VARCHAR2_TABLE_100();
429: a4 := JTF_NUMBER_TABLE();
430: a5 := JTF_NUMBER_TABLE();

Line 429: a4 := JTF_NUMBER_TABLE();

425: a0 := JTF_NUMBER_TABLE();
426: a1 := JTF_NUMBER_TABLE();
427: a2 := JTF_VARCHAR2_TABLE_100();
428: a3 := JTF_VARCHAR2_TABLE_100();
429: a4 := JTF_NUMBER_TABLE();
430: a5 := JTF_NUMBER_TABLE();
431: a6 := JTF_VARCHAR2_TABLE_100();
432: a7 := JTF_VARCHAR2_TABLE_200();
433: a8 := JTF_NUMBER_TABLE();

Line 430: a5 := JTF_NUMBER_TABLE();

426: a1 := JTF_NUMBER_TABLE();
427: a2 := JTF_VARCHAR2_TABLE_100();
428: a3 := JTF_VARCHAR2_TABLE_100();
429: a4 := JTF_NUMBER_TABLE();
430: a5 := JTF_NUMBER_TABLE();
431: a6 := JTF_VARCHAR2_TABLE_100();
432: a7 := JTF_VARCHAR2_TABLE_200();
433: a8 := JTF_NUMBER_TABLE();
434: a9 := JTF_NUMBER_TABLE();

Line 433: a8 := JTF_NUMBER_TABLE();

429: a4 := JTF_NUMBER_TABLE();
430: a5 := JTF_NUMBER_TABLE();
431: a6 := JTF_VARCHAR2_TABLE_100();
432: a7 := JTF_VARCHAR2_TABLE_200();
433: a8 := JTF_NUMBER_TABLE();
434: a9 := JTF_NUMBER_TABLE();
435: a10 := JTF_NUMBER_TABLE();
436: a11 := JTF_DATE_TABLE();
437: else

Line 434: a9 := JTF_NUMBER_TABLE();

430: a5 := JTF_NUMBER_TABLE();
431: a6 := JTF_VARCHAR2_TABLE_100();
432: a7 := JTF_VARCHAR2_TABLE_200();
433: a8 := JTF_NUMBER_TABLE();
434: a9 := JTF_NUMBER_TABLE();
435: a10 := JTF_NUMBER_TABLE();
436: a11 := JTF_DATE_TABLE();
437: else
438: a0 := JTF_NUMBER_TABLE();

Line 435: a10 := JTF_NUMBER_TABLE();

431: a6 := JTF_VARCHAR2_TABLE_100();
432: a7 := JTF_VARCHAR2_TABLE_200();
433: a8 := JTF_NUMBER_TABLE();
434: a9 := JTF_NUMBER_TABLE();
435: a10 := JTF_NUMBER_TABLE();
436: a11 := JTF_DATE_TABLE();
437: else
438: a0 := JTF_NUMBER_TABLE();
439: a1 := JTF_NUMBER_TABLE();

Line 438: a0 := JTF_NUMBER_TABLE();

434: a9 := JTF_NUMBER_TABLE();
435: a10 := JTF_NUMBER_TABLE();
436: a11 := JTF_DATE_TABLE();
437: else
438: a0 := JTF_NUMBER_TABLE();
439: a1 := JTF_NUMBER_TABLE();
440: a2 := JTF_VARCHAR2_TABLE_100();
441: a3 := JTF_VARCHAR2_TABLE_100();
442: a4 := JTF_NUMBER_TABLE();

Line 439: a1 := JTF_NUMBER_TABLE();

435: a10 := JTF_NUMBER_TABLE();
436: a11 := JTF_DATE_TABLE();
437: else
438: a0 := JTF_NUMBER_TABLE();
439: a1 := JTF_NUMBER_TABLE();
440: a2 := JTF_VARCHAR2_TABLE_100();
441: a3 := JTF_VARCHAR2_TABLE_100();
442: a4 := JTF_NUMBER_TABLE();
443: a5 := JTF_NUMBER_TABLE();

Line 442: a4 := JTF_NUMBER_TABLE();

438: a0 := JTF_NUMBER_TABLE();
439: a1 := JTF_NUMBER_TABLE();
440: a2 := JTF_VARCHAR2_TABLE_100();
441: a3 := JTF_VARCHAR2_TABLE_100();
442: a4 := JTF_NUMBER_TABLE();
443: a5 := JTF_NUMBER_TABLE();
444: a6 := JTF_VARCHAR2_TABLE_100();
445: a7 := JTF_VARCHAR2_TABLE_200();
446: a8 := JTF_NUMBER_TABLE();

Line 443: a5 := JTF_NUMBER_TABLE();

439: a1 := JTF_NUMBER_TABLE();
440: a2 := JTF_VARCHAR2_TABLE_100();
441: a3 := JTF_VARCHAR2_TABLE_100();
442: a4 := JTF_NUMBER_TABLE();
443: a5 := JTF_NUMBER_TABLE();
444: a6 := JTF_VARCHAR2_TABLE_100();
445: a7 := JTF_VARCHAR2_TABLE_200();
446: a8 := JTF_NUMBER_TABLE();
447: a9 := JTF_NUMBER_TABLE();

Line 446: a8 := JTF_NUMBER_TABLE();

442: a4 := JTF_NUMBER_TABLE();
443: a5 := JTF_NUMBER_TABLE();
444: a6 := JTF_VARCHAR2_TABLE_100();
445: a7 := JTF_VARCHAR2_TABLE_200();
446: a8 := JTF_NUMBER_TABLE();
447: a9 := JTF_NUMBER_TABLE();
448: a10 := JTF_NUMBER_TABLE();
449: a11 := JTF_DATE_TABLE();
450: if t.count > 0 then

Line 447: a9 := JTF_NUMBER_TABLE();

443: a5 := JTF_NUMBER_TABLE();
444: a6 := JTF_VARCHAR2_TABLE_100();
445: a7 := JTF_VARCHAR2_TABLE_200();
446: a8 := JTF_NUMBER_TABLE();
447: a9 := JTF_NUMBER_TABLE();
448: a10 := JTF_NUMBER_TABLE();
449: a11 := JTF_DATE_TABLE();
450: if t.count > 0 then
451: a0.extend(t.count);

Line 448: a10 := JTF_NUMBER_TABLE();

444: a6 := JTF_VARCHAR2_TABLE_100();
445: a7 := JTF_VARCHAR2_TABLE_200();
446: a8 := JTF_NUMBER_TABLE();
447: a9 := JTF_NUMBER_TABLE();
448: a10 := JTF_NUMBER_TABLE();
449: a11 := JTF_DATE_TABLE();
450: if t.count > 0 then
451: a0.extend(t.count);
452: a1.extend(t.count);

Line 488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE

484: end if;
485: end if;
486: end rosetta_table_copy_out_p7;
487:
488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_NUMBER_TABLE
491: , a3 JTF_NUMBER_TABLE
492: , a4 JTF_NUMBER_TABLE

Line 489: , a1 JTF_NUMBER_TABLE

485: end if;
486: end rosetta_table_copy_out_p7;
487:
488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_NUMBER_TABLE
491: , a3 JTF_NUMBER_TABLE
492: , a4 JTF_NUMBER_TABLE
493: , a5 JTF_NUMBER_TABLE

Line 490: , a2 JTF_NUMBER_TABLE

486: end rosetta_table_copy_out_p7;
487:
488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_NUMBER_TABLE
491: , a3 JTF_NUMBER_TABLE
492: , a4 JTF_NUMBER_TABLE
493: , a5 JTF_NUMBER_TABLE
494: , a6 JTF_VARCHAR2_TABLE_100

Line 491: , a3 JTF_NUMBER_TABLE

487:
488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_NUMBER_TABLE
491: , a3 JTF_NUMBER_TABLE
492: , a4 JTF_NUMBER_TABLE
493: , a5 JTF_NUMBER_TABLE
494: , a6 JTF_VARCHAR2_TABLE_100
495: , a7 JTF_NUMBER_TABLE

Line 492: , a4 JTF_NUMBER_TABLE

488: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_NUMBER_TABLE
491: , a3 JTF_NUMBER_TABLE
492: , a4 JTF_NUMBER_TABLE
493: , a5 JTF_NUMBER_TABLE
494: , a6 JTF_VARCHAR2_TABLE_100
495: , a7 JTF_NUMBER_TABLE
496: ) as

Line 493: , a5 JTF_NUMBER_TABLE

489: , a1 JTF_NUMBER_TABLE
490: , a2 JTF_NUMBER_TABLE
491: , a3 JTF_NUMBER_TABLE
492: , a4 JTF_NUMBER_TABLE
493: , a5 JTF_NUMBER_TABLE
494: , a6 JTF_VARCHAR2_TABLE_100
495: , a7 JTF_NUMBER_TABLE
496: ) as
497: ddindx binary_integer; indx binary_integer;

Line 495: , a7 JTF_NUMBER_TABLE

491: , a3 JTF_NUMBER_TABLE
492: , a4 JTF_NUMBER_TABLE
493: , a5 JTF_NUMBER_TABLE
494: , a6 JTF_VARCHAR2_TABLE_100
495: , a7 JTF_NUMBER_TABLE
496: ) as
497: ddindx binary_integer; indx binary_integer;
498: begin
499: if a0 is not null and a0.count > 0 then

Line 521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

517: end loop;
518: end if;
519: end if;
520: end rosetta_table_copy_in_p9;
521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
522: , a1 out nocopy JTF_NUMBER_TABLE
523: , a2 out nocopy JTF_NUMBER_TABLE
524: , a3 out nocopy JTF_NUMBER_TABLE
525: , a4 out nocopy JTF_NUMBER_TABLE

Line 522: , a1 out nocopy JTF_NUMBER_TABLE

518: end if;
519: end if;
520: end rosetta_table_copy_in_p9;
521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
522: , a1 out nocopy JTF_NUMBER_TABLE
523: , a2 out nocopy JTF_NUMBER_TABLE
524: , a3 out nocopy JTF_NUMBER_TABLE
525: , a4 out nocopy JTF_NUMBER_TABLE
526: , a5 out nocopy JTF_NUMBER_TABLE

Line 523: , a2 out nocopy JTF_NUMBER_TABLE

519: end if;
520: end rosetta_table_copy_in_p9;
521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
522: , a1 out nocopy JTF_NUMBER_TABLE
523: , a2 out nocopy JTF_NUMBER_TABLE
524: , a3 out nocopy JTF_NUMBER_TABLE
525: , a4 out nocopy JTF_NUMBER_TABLE
526: , a5 out nocopy JTF_NUMBER_TABLE
527: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 524: , a3 out nocopy JTF_NUMBER_TABLE

520: end rosetta_table_copy_in_p9;
521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
522: , a1 out nocopy JTF_NUMBER_TABLE
523: , a2 out nocopy JTF_NUMBER_TABLE
524: , a3 out nocopy JTF_NUMBER_TABLE
525: , a4 out nocopy JTF_NUMBER_TABLE
526: , a5 out nocopy JTF_NUMBER_TABLE
527: , a6 out nocopy JTF_VARCHAR2_TABLE_100
528: , a7 out nocopy JTF_NUMBER_TABLE

Line 525: , a4 out nocopy JTF_NUMBER_TABLE

521: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
522: , a1 out nocopy JTF_NUMBER_TABLE
523: , a2 out nocopy JTF_NUMBER_TABLE
524: , a3 out nocopy JTF_NUMBER_TABLE
525: , a4 out nocopy JTF_NUMBER_TABLE
526: , a5 out nocopy JTF_NUMBER_TABLE
527: , a6 out nocopy JTF_VARCHAR2_TABLE_100
528: , a7 out nocopy JTF_NUMBER_TABLE
529: ) as

Line 526: , a5 out nocopy JTF_NUMBER_TABLE

522: , a1 out nocopy JTF_NUMBER_TABLE
523: , a2 out nocopy JTF_NUMBER_TABLE
524: , a3 out nocopy JTF_NUMBER_TABLE
525: , a4 out nocopy JTF_NUMBER_TABLE
526: , a5 out nocopy JTF_NUMBER_TABLE
527: , a6 out nocopy JTF_VARCHAR2_TABLE_100
528: , a7 out nocopy JTF_NUMBER_TABLE
529: ) as
530: ddindx binary_integer; indx binary_integer;

Line 528: , a7 out nocopy JTF_NUMBER_TABLE

524: , a3 out nocopy JTF_NUMBER_TABLE
525: , a4 out nocopy JTF_NUMBER_TABLE
526: , a5 out nocopy JTF_NUMBER_TABLE
527: , a6 out nocopy JTF_VARCHAR2_TABLE_100
528: , a7 out nocopy JTF_NUMBER_TABLE
529: ) as
530: ddindx binary_integer; indx binary_integer;
531: begin
532: if t is null or t.count = 0 then

Line 533: a0 := JTF_NUMBER_TABLE();

529: ) as
530: ddindx binary_integer; indx binary_integer;
531: begin
532: if t is null or t.count = 0 then
533: a0 := JTF_NUMBER_TABLE();
534: a1 := JTF_NUMBER_TABLE();
535: a2 := JTF_NUMBER_TABLE();
536: a3 := JTF_NUMBER_TABLE();
537: a4 := JTF_NUMBER_TABLE();

Line 534: a1 := JTF_NUMBER_TABLE();

530: ddindx binary_integer; indx binary_integer;
531: begin
532: if t is null or t.count = 0 then
533: a0 := JTF_NUMBER_TABLE();
534: a1 := JTF_NUMBER_TABLE();
535: a2 := JTF_NUMBER_TABLE();
536: a3 := JTF_NUMBER_TABLE();
537: a4 := JTF_NUMBER_TABLE();
538: a5 := JTF_NUMBER_TABLE();

Line 535: a2 := JTF_NUMBER_TABLE();

531: begin
532: if t is null or t.count = 0 then
533: a0 := JTF_NUMBER_TABLE();
534: a1 := JTF_NUMBER_TABLE();
535: a2 := JTF_NUMBER_TABLE();
536: a3 := JTF_NUMBER_TABLE();
537: a4 := JTF_NUMBER_TABLE();
538: a5 := JTF_NUMBER_TABLE();
539: a6 := JTF_VARCHAR2_TABLE_100();

Line 536: a3 := JTF_NUMBER_TABLE();

532: if t is null or t.count = 0 then
533: a0 := JTF_NUMBER_TABLE();
534: a1 := JTF_NUMBER_TABLE();
535: a2 := JTF_NUMBER_TABLE();
536: a3 := JTF_NUMBER_TABLE();
537: a4 := JTF_NUMBER_TABLE();
538: a5 := JTF_NUMBER_TABLE();
539: a6 := JTF_VARCHAR2_TABLE_100();
540: a7 := JTF_NUMBER_TABLE();

Line 537: a4 := JTF_NUMBER_TABLE();

533: a0 := JTF_NUMBER_TABLE();
534: a1 := JTF_NUMBER_TABLE();
535: a2 := JTF_NUMBER_TABLE();
536: a3 := JTF_NUMBER_TABLE();
537: a4 := JTF_NUMBER_TABLE();
538: a5 := JTF_NUMBER_TABLE();
539: a6 := JTF_VARCHAR2_TABLE_100();
540: a7 := JTF_NUMBER_TABLE();
541: else

Line 538: a5 := JTF_NUMBER_TABLE();

534: a1 := JTF_NUMBER_TABLE();
535: a2 := JTF_NUMBER_TABLE();
536: a3 := JTF_NUMBER_TABLE();
537: a4 := JTF_NUMBER_TABLE();
538: a5 := JTF_NUMBER_TABLE();
539: a6 := JTF_VARCHAR2_TABLE_100();
540: a7 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_NUMBER_TABLE();

Line 540: a7 := JTF_NUMBER_TABLE();

536: a3 := JTF_NUMBER_TABLE();
537: a4 := JTF_NUMBER_TABLE();
538: a5 := JTF_NUMBER_TABLE();
539: a6 := JTF_VARCHAR2_TABLE_100();
540: a7 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_NUMBER_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();

Line 542: a0 := JTF_NUMBER_TABLE();

538: a5 := JTF_NUMBER_TABLE();
539: a6 := JTF_VARCHAR2_TABLE_100();
540: a7 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_NUMBER_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
545: a3 := JTF_NUMBER_TABLE();
546: a4 := JTF_NUMBER_TABLE();

Line 543: a1 := JTF_NUMBER_TABLE();

539: a6 := JTF_VARCHAR2_TABLE_100();
540: a7 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_NUMBER_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
545: a3 := JTF_NUMBER_TABLE();
546: a4 := JTF_NUMBER_TABLE();
547: a5 := JTF_NUMBER_TABLE();

Line 544: a2 := JTF_NUMBER_TABLE();

540: a7 := JTF_NUMBER_TABLE();
541: else
542: a0 := JTF_NUMBER_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
545: a3 := JTF_NUMBER_TABLE();
546: a4 := JTF_NUMBER_TABLE();
547: a5 := JTF_NUMBER_TABLE();
548: a6 := JTF_VARCHAR2_TABLE_100();

Line 545: a3 := JTF_NUMBER_TABLE();

541: else
542: a0 := JTF_NUMBER_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
545: a3 := JTF_NUMBER_TABLE();
546: a4 := JTF_NUMBER_TABLE();
547: a5 := JTF_NUMBER_TABLE();
548: a6 := JTF_VARCHAR2_TABLE_100();
549: a7 := JTF_NUMBER_TABLE();

Line 546: a4 := JTF_NUMBER_TABLE();

542: a0 := JTF_NUMBER_TABLE();
543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
545: a3 := JTF_NUMBER_TABLE();
546: a4 := JTF_NUMBER_TABLE();
547: a5 := JTF_NUMBER_TABLE();
548: a6 := JTF_VARCHAR2_TABLE_100();
549: a7 := JTF_NUMBER_TABLE();
550: if t.count > 0 then

Line 547: a5 := JTF_NUMBER_TABLE();

543: a1 := JTF_NUMBER_TABLE();
544: a2 := JTF_NUMBER_TABLE();
545: a3 := JTF_NUMBER_TABLE();
546: a4 := JTF_NUMBER_TABLE();
547: a5 := JTF_NUMBER_TABLE();
548: a6 := JTF_VARCHAR2_TABLE_100();
549: a7 := JTF_NUMBER_TABLE();
550: if t.count > 0 then
551: a0.extend(t.count);

Line 549: a7 := JTF_NUMBER_TABLE();

545: a3 := JTF_NUMBER_TABLE();
546: a4 := JTF_NUMBER_TABLE();
547: a5 := JTF_NUMBER_TABLE();
548: a6 := JTF_VARCHAR2_TABLE_100();
549: a7 := JTF_NUMBER_TABLE();
550: if t.count > 0 then
551: a0.extend(t.count);
552: a1.extend(t.count);
553: a2.extend(t.count);

Line 580: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE) as

576: end if;
577: end if;
578: end rosetta_table_copy_out_p9;
579:
580: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE) as
581: ddindx binary_integer; indx binary_integer;
582: begin
583: if a0 is not null and a0.count > 0 then
584: if a0.count > 0 then

Line 598: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

594: end loop;
595: end if;
596: end if;
597: end rosetta_table_copy_in_p10;
598: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
599: ddindx binary_integer; indx binary_integer;
600: begin
601: if t is null or t.count = 0 then
602: a0 := JTF_NUMBER_TABLE();

Line 602: a0 := JTF_NUMBER_TABLE();

598: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
599: ddindx binary_integer; indx binary_integer;
600: begin
601: if t is null or t.count = 0 then
602: a0 := JTF_NUMBER_TABLE();
603: else
604: a0 := JTF_NUMBER_TABLE();
605: if t.count > 0 then
606: a0.extend(t.count);

Line 604: a0 := JTF_NUMBER_TABLE();

600: begin
601: if t is null or t.count = 0 then
602: a0 := JTF_NUMBER_TABLE();
603: else
604: a0 := JTF_NUMBER_TABLE();
605: if t.count > 0 then
606: a0.extend(t.count);
607: ddindx := t.first;
608: indx := 1;

Line 621: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE

617: end if;
618: end if;
619: end rosetta_table_copy_out_p10;
620:
621: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
622: , a1 JTF_VARCHAR2_TABLE_100
623: , a2 JTF_NUMBER_TABLE
624: , a3 JTF_NUMBER_TABLE
625: , a4 JTF_NUMBER_TABLE

Line 623: , a2 JTF_NUMBER_TABLE

619: end rosetta_table_copy_out_p10;
620:
621: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
622: , a1 JTF_VARCHAR2_TABLE_100
623: , a2 JTF_NUMBER_TABLE
624: , a3 JTF_NUMBER_TABLE
625: , a4 JTF_NUMBER_TABLE
626: , a5 JTF_NUMBER_TABLE
627: , a6 JTF_VARCHAR2_TABLE_100

Line 624: , a3 JTF_NUMBER_TABLE

620:
621: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
622: , a1 JTF_VARCHAR2_TABLE_100
623: , a2 JTF_NUMBER_TABLE
624: , a3 JTF_NUMBER_TABLE
625: , a4 JTF_NUMBER_TABLE
626: , a5 JTF_NUMBER_TABLE
627: , a6 JTF_VARCHAR2_TABLE_100
628: , a7 JTF_NUMBER_TABLE

Line 625: , a4 JTF_NUMBER_TABLE

621: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
622: , a1 JTF_VARCHAR2_TABLE_100
623: , a2 JTF_NUMBER_TABLE
624: , a3 JTF_NUMBER_TABLE
625: , a4 JTF_NUMBER_TABLE
626: , a5 JTF_NUMBER_TABLE
627: , a6 JTF_VARCHAR2_TABLE_100
628: , a7 JTF_NUMBER_TABLE
629: , a8 JTF_NUMBER_TABLE

Line 626: , a5 JTF_NUMBER_TABLE

622: , a1 JTF_VARCHAR2_TABLE_100
623: , a2 JTF_NUMBER_TABLE
624: , a3 JTF_NUMBER_TABLE
625: , a4 JTF_NUMBER_TABLE
626: , a5 JTF_NUMBER_TABLE
627: , a6 JTF_VARCHAR2_TABLE_100
628: , a7 JTF_NUMBER_TABLE
629: , a8 JTF_NUMBER_TABLE
630: , a9 JTF_NUMBER_TABLE

Line 628: , a7 JTF_NUMBER_TABLE

624: , a3 JTF_NUMBER_TABLE
625: , a4 JTF_NUMBER_TABLE
626: , a5 JTF_NUMBER_TABLE
627: , a6 JTF_VARCHAR2_TABLE_100
628: , a7 JTF_NUMBER_TABLE
629: , a8 JTF_NUMBER_TABLE
630: , a9 JTF_NUMBER_TABLE
631: , a10 JTF_NUMBER_TABLE
632: , a11 JTF_VARCHAR2_TABLE_100

Line 629: , a8 JTF_NUMBER_TABLE

625: , a4 JTF_NUMBER_TABLE
626: , a5 JTF_NUMBER_TABLE
627: , a6 JTF_VARCHAR2_TABLE_100
628: , a7 JTF_NUMBER_TABLE
629: , a8 JTF_NUMBER_TABLE
630: , a9 JTF_NUMBER_TABLE
631: , a10 JTF_NUMBER_TABLE
632: , a11 JTF_VARCHAR2_TABLE_100
633: , a12 JTF_NUMBER_TABLE

Line 630: , a9 JTF_NUMBER_TABLE

626: , a5 JTF_NUMBER_TABLE
627: , a6 JTF_VARCHAR2_TABLE_100
628: , a7 JTF_NUMBER_TABLE
629: , a8 JTF_NUMBER_TABLE
630: , a9 JTF_NUMBER_TABLE
631: , a10 JTF_NUMBER_TABLE
632: , a11 JTF_VARCHAR2_TABLE_100
633: , a12 JTF_NUMBER_TABLE
634: , a13 JTF_NUMBER_TABLE

Line 631: , a10 JTF_NUMBER_TABLE

627: , a6 JTF_VARCHAR2_TABLE_100
628: , a7 JTF_NUMBER_TABLE
629: , a8 JTF_NUMBER_TABLE
630: , a9 JTF_NUMBER_TABLE
631: , a10 JTF_NUMBER_TABLE
632: , a11 JTF_VARCHAR2_TABLE_100
633: , a12 JTF_NUMBER_TABLE
634: , a13 JTF_NUMBER_TABLE
635: ) as

Line 633: , a12 JTF_NUMBER_TABLE

629: , a8 JTF_NUMBER_TABLE
630: , a9 JTF_NUMBER_TABLE
631: , a10 JTF_NUMBER_TABLE
632: , a11 JTF_VARCHAR2_TABLE_100
633: , a12 JTF_NUMBER_TABLE
634: , a13 JTF_NUMBER_TABLE
635: ) as
636: ddindx binary_integer; indx binary_integer;
637: begin

Line 634: , a13 JTF_NUMBER_TABLE

630: , a9 JTF_NUMBER_TABLE
631: , a10 JTF_NUMBER_TABLE
632: , a11 JTF_VARCHAR2_TABLE_100
633: , a12 JTF_NUMBER_TABLE
634: , a13 JTF_NUMBER_TABLE
635: ) as
636: ddindx binary_integer; indx binary_integer;
637: begin
638: if a0 is not null and a0.count > 0 then

Line 666: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

662: end loop;
663: end if;
664: end if;
665: end rosetta_table_copy_in_p18;
666: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
667: , a1 out nocopy JTF_VARCHAR2_TABLE_100
668: , a2 out nocopy JTF_NUMBER_TABLE
669: , a3 out nocopy JTF_NUMBER_TABLE
670: , a4 out nocopy JTF_NUMBER_TABLE

Line 668: , a2 out nocopy JTF_NUMBER_TABLE

664: end if;
665: end rosetta_table_copy_in_p18;
666: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
667: , a1 out nocopy JTF_VARCHAR2_TABLE_100
668: , a2 out nocopy JTF_NUMBER_TABLE
669: , a3 out nocopy JTF_NUMBER_TABLE
670: , a4 out nocopy JTF_NUMBER_TABLE
671: , a5 out nocopy JTF_NUMBER_TABLE
672: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 669: , a3 out nocopy JTF_NUMBER_TABLE

665: end rosetta_table_copy_in_p18;
666: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
667: , a1 out nocopy JTF_VARCHAR2_TABLE_100
668: , a2 out nocopy JTF_NUMBER_TABLE
669: , a3 out nocopy JTF_NUMBER_TABLE
670: , a4 out nocopy JTF_NUMBER_TABLE
671: , a5 out nocopy JTF_NUMBER_TABLE
672: , a6 out nocopy JTF_VARCHAR2_TABLE_100
673: , a7 out nocopy JTF_NUMBER_TABLE

Line 670: , a4 out nocopy JTF_NUMBER_TABLE

666: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
667: , a1 out nocopy JTF_VARCHAR2_TABLE_100
668: , a2 out nocopy JTF_NUMBER_TABLE
669: , a3 out nocopy JTF_NUMBER_TABLE
670: , a4 out nocopy JTF_NUMBER_TABLE
671: , a5 out nocopy JTF_NUMBER_TABLE
672: , a6 out nocopy JTF_VARCHAR2_TABLE_100
673: , a7 out nocopy JTF_NUMBER_TABLE
674: , a8 out nocopy JTF_NUMBER_TABLE

Line 671: , a5 out nocopy JTF_NUMBER_TABLE

667: , a1 out nocopy JTF_VARCHAR2_TABLE_100
668: , a2 out nocopy JTF_NUMBER_TABLE
669: , a3 out nocopy JTF_NUMBER_TABLE
670: , a4 out nocopy JTF_NUMBER_TABLE
671: , a5 out nocopy JTF_NUMBER_TABLE
672: , a6 out nocopy JTF_VARCHAR2_TABLE_100
673: , a7 out nocopy JTF_NUMBER_TABLE
674: , a8 out nocopy JTF_NUMBER_TABLE
675: , a9 out nocopy JTF_NUMBER_TABLE

Line 673: , a7 out nocopy JTF_NUMBER_TABLE

669: , a3 out nocopy JTF_NUMBER_TABLE
670: , a4 out nocopy JTF_NUMBER_TABLE
671: , a5 out nocopy JTF_NUMBER_TABLE
672: , a6 out nocopy JTF_VARCHAR2_TABLE_100
673: , a7 out nocopy JTF_NUMBER_TABLE
674: , a8 out nocopy JTF_NUMBER_TABLE
675: , a9 out nocopy JTF_NUMBER_TABLE
676: , a10 out nocopy JTF_NUMBER_TABLE
677: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 674: , a8 out nocopy JTF_NUMBER_TABLE

670: , a4 out nocopy JTF_NUMBER_TABLE
671: , a5 out nocopy JTF_NUMBER_TABLE
672: , a6 out nocopy JTF_VARCHAR2_TABLE_100
673: , a7 out nocopy JTF_NUMBER_TABLE
674: , a8 out nocopy JTF_NUMBER_TABLE
675: , a9 out nocopy JTF_NUMBER_TABLE
676: , a10 out nocopy JTF_NUMBER_TABLE
677: , a11 out nocopy JTF_VARCHAR2_TABLE_100
678: , a12 out nocopy JTF_NUMBER_TABLE

Line 675: , a9 out nocopy JTF_NUMBER_TABLE

671: , a5 out nocopy JTF_NUMBER_TABLE
672: , a6 out nocopy JTF_VARCHAR2_TABLE_100
673: , a7 out nocopy JTF_NUMBER_TABLE
674: , a8 out nocopy JTF_NUMBER_TABLE
675: , a9 out nocopy JTF_NUMBER_TABLE
676: , a10 out nocopy JTF_NUMBER_TABLE
677: , a11 out nocopy JTF_VARCHAR2_TABLE_100
678: , a12 out nocopy JTF_NUMBER_TABLE
679: , a13 out nocopy JTF_NUMBER_TABLE

Line 676: , a10 out nocopy JTF_NUMBER_TABLE

672: , a6 out nocopy JTF_VARCHAR2_TABLE_100
673: , a7 out nocopy JTF_NUMBER_TABLE
674: , a8 out nocopy JTF_NUMBER_TABLE
675: , a9 out nocopy JTF_NUMBER_TABLE
676: , a10 out nocopy JTF_NUMBER_TABLE
677: , a11 out nocopy JTF_VARCHAR2_TABLE_100
678: , a12 out nocopy JTF_NUMBER_TABLE
679: , a13 out nocopy JTF_NUMBER_TABLE
680: ) as

Line 678: , a12 out nocopy JTF_NUMBER_TABLE

674: , a8 out nocopy JTF_NUMBER_TABLE
675: , a9 out nocopy JTF_NUMBER_TABLE
676: , a10 out nocopy JTF_NUMBER_TABLE
677: , a11 out nocopy JTF_VARCHAR2_TABLE_100
678: , a12 out nocopy JTF_NUMBER_TABLE
679: , a13 out nocopy JTF_NUMBER_TABLE
680: ) as
681: ddindx binary_integer; indx binary_integer;
682: begin

Line 679: , a13 out nocopy JTF_NUMBER_TABLE

675: , a9 out nocopy JTF_NUMBER_TABLE
676: , a10 out nocopy JTF_NUMBER_TABLE
677: , a11 out nocopy JTF_VARCHAR2_TABLE_100
678: , a12 out nocopy JTF_NUMBER_TABLE
679: , a13 out nocopy JTF_NUMBER_TABLE
680: ) as
681: ddindx binary_integer; indx binary_integer;
682: begin
683: if t is null or t.count = 0 then

Line 684: a0 := JTF_NUMBER_TABLE();

680: ) as
681: ddindx binary_integer; indx binary_integer;
682: begin
683: if t is null or t.count = 0 then
684: a0 := JTF_NUMBER_TABLE();
685: a1 := JTF_VARCHAR2_TABLE_100();
686: a2 := JTF_NUMBER_TABLE();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_NUMBER_TABLE();

Line 686: a2 := JTF_NUMBER_TABLE();

682: begin
683: if t is null or t.count = 0 then
684: a0 := JTF_NUMBER_TABLE();
685: a1 := JTF_VARCHAR2_TABLE_100();
686: a2 := JTF_NUMBER_TABLE();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_NUMBER_TABLE();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_VARCHAR2_TABLE_100();

Line 687: a3 := JTF_NUMBER_TABLE();

683: if t is null or t.count = 0 then
684: a0 := JTF_NUMBER_TABLE();
685: a1 := JTF_VARCHAR2_TABLE_100();
686: a2 := JTF_NUMBER_TABLE();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_NUMBER_TABLE();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_VARCHAR2_TABLE_100();
691: a7 := JTF_NUMBER_TABLE();

Line 688: a4 := JTF_NUMBER_TABLE();

684: a0 := JTF_NUMBER_TABLE();
685: a1 := JTF_VARCHAR2_TABLE_100();
686: a2 := JTF_NUMBER_TABLE();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_NUMBER_TABLE();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_VARCHAR2_TABLE_100();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_NUMBER_TABLE();

Line 689: a5 := JTF_NUMBER_TABLE();

685: a1 := JTF_VARCHAR2_TABLE_100();
686: a2 := JTF_NUMBER_TABLE();
687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_NUMBER_TABLE();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_VARCHAR2_TABLE_100();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_NUMBER_TABLE();
693: a9 := JTF_NUMBER_TABLE();

Line 691: a7 := JTF_NUMBER_TABLE();

687: a3 := JTF_NUMBER_TABLE();
688: a4 := JTF_NUMBER_TABLE();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_VARCHAR2_TABLE_100();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_NUMBER_TABLE();
693: a9 := JTF_NUMBER_TABLE();
694: a10 := JTF_NUMBER_TABLE();
695: a11 := JTF_VARCHAR2_TABLE_100();

Line 692: a8 := JTF_NUMBER_TABLE();

688: a4 := JTF_NUMBER_TABLE();
689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_VARCHAR2_TABLE_100();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_NUMBER_TABLE();
693: a9 := JTF_NUMBER_TABLE();
694: a10 := JTF_NUMBER_TABLE();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_NUMBER_TABLE();

Line 693: a9 := JTF_NUMBER_TABLE();

689: a5 := JTF_NUMBER_TABLE();
690: a6 := JTF_VARCHAR2_TABLE_100();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_NUMBER_TABLE();
693: a9 := JTF_NUMBER_TABLE();
694: a10 := JTF_NUMBER_TABLE();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_NUMBER_TABLE();
697: a13 := JTF_NUMBER_TABLE();

Line 694: a10 := JTF_NUMBER_TABLE();

690: a6 := JTF_VARCHAR2_TABLE_100();
691: a7 := JTF_NUMBER_TABLE();
692: a8 := JTF_NUMBER_TABLE();
693: a9 := JTF_NUMBER_TABLE();
694: a10 := JTF_NUMBER_TABLE();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_NUMBER_TABLE();
697: a13 := JTF_NUMBER_TABLE();
698: else

Line 696: a12 := JTF_NUMBER_TABLE();

692: a8 := JTF_NUMBER_TABLE();
693: a9 := JTF_NUMBER_TABLE();
694: a10 := JTF_NUMBER_TABLE();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_NUMBER_TABLE();
697: a13 := JTF_NUMBER_TABLE();
698: else
699: a0 := JTF_NUMBER_TABLE();
700: a1 := JTF_VARCHAR2_TABLE_100();

Line 697: a13 := JTF_NUMBER_TABLE();

693: a9 := JTF_NUMBER_TABLE();
694: a10 := JTF_NUMBER_TABLE();
695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_NUMBER_TABLE();
697: a13 := JTF_NUMBER_TABLE();
698: else
699: a0 := JTF_NUMBER_TABLE();
700: a1 := JTF_VARCHAR2_TABLE_100();
701: a2 := JTF_NUMBER_TABLE();

Line 699: a0 := JTF_NUMBER_TABLE();

695: a11 := JTF_VARCHAR2_TABLE_100();
696: a12 := JTF_NUMBER_TABLE();
697: a13 := JTF_NUMBER_TABLE();
698: else
699: a0 := JTF_NUMBER_TABLE();
700: a1 := JTF_VARCHAR2_TABLE_100();
701: a2 := JTF_NUMBER_TABLE();
702: a3 := JTF_NUMBER_TABLE();
703: a4 := JTF_NUMBER_TABLE();

Line 701: a2 := JTF_NUMBER_TABLE();

697: a13 := JTF_NUMBER_TABLE();
698: else
699: a0 := JTF_NUMBER_TABLE();
700: a1 := JTF_VARCHAR2_TABLE_100();
701: a2 := JTF_NUMBER_TABLE();
702: a3 := JTF_NUMBER_TABLE();
703: a4 := JTF_NUMBER_TABLE();
704: a5 := JTF_NUMBER_TABLE();
705: a6 := JTF_VARCHAR2_TABLE_100();

Line 702: a3 := JTF_NUMBER_TABLE();

698: else
699: a0 := JTF_NUMBER_TABLE();
700: a1 := JTF_VARCHAR2_TABLE_100();
701: a2 := JTF_NUMBER_TABLE();
702: a3 := JTF_NUMBER_TABLE();
703: a4 := JTF_NUMBER_TABLE();
704: a5 := JTF_NUMBER_TABLE();
705: a6 := JTF_VARCHAR2_TABLE_100();
706: a7 := JTF_NUMBER_TABLE();

Line 703: a4 := JTF_NUMBER_TABLE();

699: a0 := JTF_NUMBER_TABLE();
700: a1 := JTF_VARCHAR2_TABLE_100();
701: a2 := JTF_NUMBER_TABLE();
702: a3 := JTF_NUMBER_TABLE();
703: a4 := JTF_NUMBER_TABLE();
704: a5 := JTF_NUMBER_TABLE();
705: a6 := JTF_VARCHAR2_TABLE_100();
706: a7 := JTF_NUMBER_TABLE();
707: a8 := JTF_NUMBER_TABLE();

Line 704: a5 := JTF_NUMBER_TABLE();

700: a1 := JTF_VARCHAR2_TABLE_100();
701: a2 := JTF_NUMBER_TABLE();
702: a3 := JTF_NUMBER_TABLE();
703: a4 := JTF_NUMBER_TABLE();
704: a5 := JTF_NUMBER_TABLE();
705: a6 := JTF_VARCHAR2_TABLE_100();
706: a7 := JTF_NUMBER_TABLE();
707: a8 := JTF_NUMBER_TABLE();
708: a9 := JTF_NUMBER_TABLE();

Line 706: a7 := JTF_NUMBER_TABLE();

702: a3 := JTF_NUMBER_TABLE();
703: a4 := JTF_NUMBER_TABLE();
704: a5 := JTF_NUMBER_TABLE();
705: a6 := JTF_VARCHAR2_TABLE_100();
706: a7 := JTF_NUMBER_TABLE();
707: a8 := JTF_NUMBER_TABLE();
708: a9 := JTF_NUMBER_TABLE();
709: a10 := JTF_NUMBER_TABLE();
710: a11 := JTF_VARCHAR2_TABLE_100();

Line 707: a8 := JTF_NUMBER_TABLE();

703: a4 := JTF_NUMBER_TABLE();
704: a5 := JTF_NUMBER_TABLE();
705: a6 := JTF_VARCHAR2_TABLE_100();
706: a7 := JTF_NUMBER_TABLE();
707: a8 := JTF_NUMBER_TABLE();
708: a9 := JTF_NUMBER_TABLE();
709: a10 := JTF_NUMBER_TABLE();
710: a11 := JTF_VARCHAR2_TABLE_100();
711: a12 := JTF_NUMBER_TABLE();

Line 708: a9 := JTF_NUMBER_TABLE();

704: a5 := JTF_NUMBER_TABLE();
705: a6 := JTF_VARCHAR2_TABLE_100();
706: a7 := JTF_NUMBER_TABLE();
707: a8 := JTF_NUMBER_TABLE();
708: a9 := JTF_NUMBER_TABLE();
709: a10 := JTF_NUMBER_TABLE();
710: a11 := JTF_VARCHAR2_TABLE_100();
711: a12 := JTF_NUMBER_TABLE();
712: a13 := JTF_NUMBER_TABLE();

Line 709: a10 := JTF_NUMBER_TABLE();

705: a6 := JTF_VARCHAR2_TABLE_100();
706: a7 := JTF_NUMBER_TABLE();
707: a8 := JTF_NUMBER_TABLE();
708: a9 := JTF_NUMBER_TABLE();
709: a10 := JTF_NUMBER_TABLE();
710: a11 := JTF_VARCHAR2_TABLE_100();
711: a12 := JTF_NUMBER_TABLE();
712: a13 := JTF_NUMBER_TABLE();
713: if t.count > 0 then

Line 711: a12 := JTF_NUMBER_TABLE();

707: a8 := JTF_NUMBER_TABLE();
708: a9 := JTF_NUMBER_TABLE();
709: a10 := JTF_NUMBER_TABLE();
710: a11 := JTF_VARCHAR2_TABLE_100();
711: a12 := JTF_NUMBER_TABLE();
712: a13 := JTF_NUMBER_TABLE();
713: if t.count > 0 then
714: a0.extend(t.count);
715: a1.extend(t.count);

Line 712: a13 := JTF_NUMBER_TABLE();

708: a9 := JTF_NUMBER_TABLE();
709: a10 := JTF_NUMBER_TABLE();
710: a11 := JTF_VARCHAR2_TABLE_100();
711: a12 := JTF_NUMBER_TABLE();
712: a13 := JTF_NUMBER_TABLE();
713: if t.count > 0 then
714: a0.extend(t.count);
715: a1.extend(t.count);
716: a2.extend(t.count);

Line 997: , p3_a0 in out nocopy JTF_NUMBER_TABLE

993:
994: procedure get_default_op_actual_dates(x_return_status out nocopy VARCHAR2
995: , x_msg_count out nocopy NUMBER
996: , x_msg_data out nocopy VARCHAR2
997: , p3_a0 in out nocopy JTF_NUMBER_TABLE
998: , p3_a1 in out nocopy JTF_NUMBER_TABLE
999: , p3_a2 in out nocopy JTF_NUMBER_TABLE
1000: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1001: , p3_a4 in out nocopy JTF_NUMBER_TABLE

Line 998: , p3_a1 in out nocopy JTF_NUMBER_TABLE

994: procedure get_default_op_actual_dates(x_return_status out nocopy VARCHAR2
995: , x_msg_count out nocopy NUMBER
996: , x_msg_data out nocopy VARCHAR2
997: , p3_a0 in out nocopy JTF_NUMBER_TABLE
998: , p3_a1 in out nocopy JTF_NUMBER_TABLE
999: , p3_a2 in out nocopy JTF_NUMBER_TABLE
1000: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1001: , p3_a4 in out nocopy JTF_NUMBER_TABLE
1002: , p3_a5 in out nocopy JTF_NUMBER_TABLE

Line 999: , p3_a2 in out nocopy JTF_NUMBER_TABLE

995: , x_msg_count out nocopy NUMBER
996: , x_msg_data out nocopy VARCHAR2
997: , p3_a0 in out nocopy JTF_NUMBER_TABLE
998: , p3_a1 in out nocopy JTF_NUMBER_TABLE
999: , p3_a2 in out nocopy JTF_NUMBER_TABLE
1000: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1001: , p3_a4 in out nocopy JTF_NUMBER_TABLE
1002: , p3_a5 in out nocopy JTF_NUMBER_TABLE
1003: , p3_a6 in out nocopy JTF_NUMBER_TABLE

Line 1001: , p3_a4 in out nocopy JTF_NUMBER_TABLE

997: , p3_a0 in out nocopy JTF_NUMBER_TABLE
998: , p3_a1 in out nocopy JTF_NUMBER_TABLE
999: , p3_a2 in out nocopy JTF_NUMBER_TABLE
1000: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1001: , p3_a4 in out nocopy JTF_NUMBER_TABLE
1002: , p3_a5 in out nocopy JTF_NUMBER_TABLE
1003: , p3_a6 in out nocopy JTF_NUMBER_TABLE
1004: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1005: , p3_a8 in out nocopy JTF_NUMBER_TABLE

Line 1002: , p3_a5 in out nocopy JTF_NUMBER_TABLE

998: , p3_a1 in out nocopy JTF_NUMBER_TABLE
999: , p3_a2 in out nocopy JTF_NUMBER_TABLE
1000: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1001: , p3_a4 in out nocopy JTF_NUMBER_TABLE
1002: , p3_a5 in out nocopy JTF_NUMBER_TABLE
1003: , p3_a6 in out nocopy JTF_NUMBER_TABLE
1004: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1005: , p3_a8 in out nocopy JTF_NUMBER_TABLE
1006: , p3_a9 in out nocopy JTF_NUMBER_TABLE

Line 1003: , p3_a6 in out nocopy JTF_NUMBER_TABLE

999: , p3_a2 in out nocopy JTF_NUMBER_TABLE
1000: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1001: , p3_a4 in out nocopy JTF_NUMBER_TABLE
1002: , p3_a5 in out nocopy JTF_NUMBER_TABLE
1003: , p3_a6 in out nocopy JTF_NUMBER_TABLE
1004: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1005: , p3_a8 in out nocopy JTF_NUMBER_TABLE
1006: , p3_a9 in out nocopy JTF_NUMBER_TABLE
1007: , p3_a10 in out nocopy JTF_DATE_TABLE

Line 1005: , p3_a8 in out nocopy JTF_NUMBER_TABLE

1001: , p3_a4 in out nocopy JTF_NUMBER_TABLE
1002: , p3_a5 in out nocopy JTF_NUMBER_TABLE
1003: , p3_a6 in out nocopy JTF_NUMBER_TABLE
1004: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1005: , p3_a8 in out nocopy JTF_NUMBER_TABLE
1006: , p3_a9 in out nocopy JTF_NUMBER_TABLE
1007: , p3_a10 in out nocopy JTF_DATE_TABLE
1008: , p3_a11 in out nocopy JTF_DATE_TABLE
1009: , p3_a12 in out nocopy JTF_DATE_TABLE

Line 1006: , p3_a9 in out nocopy JTF_NUMBER_TABLE

1002: , p3_a5 in out nocopy JTF_NUMBER_TABLE
1003: , p3_a6 in out nocopy JTF_NUMBER_TABLE
1004: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1005: , p3_a8 in out nocopy JTF_NUMBER_TABLE
1006: , p3_a9 in out nocopy JTF_NUMBER_TABLE
1007: , p3_a10 in out nocopy JTF_DATE_TABLE
1008: , p3_a11 in out nocopy JTF_DATE_TABLE
1009: , p3_a12 in out nocopy JTF_DATE_TABLE
1010: , p3_a13 in out nocopy JTF_DATE_TABLE

Line 1072: , p1_a0 in out nocopy JTF_NUMBER_TABLE

1068: );
1069: end;
1070:
1071: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
1072: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1073: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1074: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1075: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1076: , p1_a4 in out nocopy JTF_NUMBER_TABLE

Line 1073: , p1_a1 in out nocopy JTF_NUMBER_TABLE

1069: end;
1070:
1071: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
1072: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1073: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1074: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1075: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1076: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1077: , p1_a5 in out nocopy JTF_NUMBER_TABLE

Line 1074: , p1_a2 in out nocopy JTF_NUMBER_TABLE

1070:
1071: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
1072: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1073: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1074: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1075: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1076: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1077: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1078: , p1_a6 in out nocopy JTF_NUMBER_TABLE

Line 1076: , p1_a4 in out nocopy JTF_NUMBER_TABLE

1072: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1073: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1074: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1075: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1076: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1077: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1078: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1079: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1080: , p1_a8 in out nocopy JTF_NUMBER_TABLE

Line 1077: , p1_a5 in out nocopy JTF_NUMBER_TABLE

1073: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1074: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1075: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1076: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1077: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1078: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1079: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1080: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1081: , p1_a9 in out nocopy JTF_NUMBER_TABLE

Line 1078: , p1_a6 in out nocopy JTF_NUMBER_TABLE

1074: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1075: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1076: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1077: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1078: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1079: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1080: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1081: , p1_a9 in out nocopy JTF_NUMBER_TABLE
1082: , p1_a10 in out nocopy JTF_DATE_TABLE

Line 1080: , p1_a8 in out nocopy JTF_NUMBER_TABLE

1076: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1077: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1078: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1079: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1080: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1081: , p1_a9 in out nocopy JTF_NUMBER_TABLE
1082: , p1_a10 in out nocopy JTF_DATE_TABLE
1083: , p1_a11 in out nocopy JTF_DATE_TABLE
1084: , p1_a12 in out nocopy JTF_DATE_TABLE

Line 1081: , p1_a9 in out nocopy JTF_NUMBER_TABLE

1077: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1078: , p1_a6 in out nocopy JTF_NUMBER_TABLE
1079: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
1080: , p1_a8 in out nocopy JTF_NUMBER_TABLE
1081: , p1_a9 in out nocopy JTF_NUMBER_TABLE
1082: , p1_a10 in out nocopy JTF_DATE_TABLE
1083: , p1_a11 in out nocopy JTF_DATE_TABLE
1084: , p1_a12 in out nocopy JTF_DATE_TABLE
1085: , p1_a13 in out nocopy JTF_DATE_TABLE

Line 1177: , p3_a0 out nocopy JTF_NUMBER_TABLE

1173:
1174: function get_reset_counters(p_mr_header_id NUMBER
1175: , p_item_instance_id NUMBER
1176: , p_actual_date date
1177: , p3_a0 out nocopy JTF_NUMBER_TABLE
1178: , p3_a1 out nocopy JTF_NUMBER_TABLE
1179: , p3_a2 out nocopy JTF_NUMBER_TABLE
1180: , p3_a3 out nocopy JTF_NUMBER_TABLE
1181: , p3_a4 out nocopy JTF_NUMBER_TABLE

Line 1178: , p3_a1 out nocopy JTF_NUMBER_TABLE

1174: function get_reset_counters(p_mr_header_id NUMBER
1175: , p_item_instance_id NUMBER
1176: , p_actual_date date
1177: , p3_a0 out nocopy JTF_NUMBER_TABLE
1178: , p3_a1 out nocopy JTF_NUMBER_TABLE
1179: , p3_a2 out nocopy JTF_NUMBER_TABLE
1180: , p3_a3 out nocopy JTF_NUMBER_TABLE
1181: , p3_a4 out nocopy JTF_NUMBER_TABLE
1182: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 1179: , p3_a2 out nocopy JTF_NUMBER_TABLE

1175: , p_item_instance_id NUMBER
1176: , p_actual_date date
1177: , p3_a0 out nocopy JTF_NUMBER_TABLE
1178: , p3_a1 out nocopy JTF_NUMBER_TABLE
1179: , p3_a2 out nocopy JTF_NUMBER_TABLE
1180: , p3_a3 out nocopy JTF_NUMBER_TABLE
1181: , p3_a4 out nocopy JTF_NUMBER_TABLE
1182: , p3_a5 out nocopy JTF_NUMBER_TABLE
1183: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1180: , p3_a3 out nocopy JTF_NUMBER_TABLE

1176: , p_actual_date date
1177: , p3_a0 out nocopy JTF_NUMBER_TABLE
1178: , p3_a1 out nocopy JTF_NUMBER_TABLE
1179: , p3_a2 out nocopy JTF_NUMBER_TABLE
1180: , p3_a3 out nocopy JTF_NUMBER_TABLE
1181: , p3_a4 out nocopy JTF_NUMBER_TABLE
1182: , p3_a5 out nocopy JTF_NUMBER_TABLE
1183: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 1181: , p3_a4 out nocopy JTF_NUMBER_TABLE

1177: , p3_a0 out nocopy JTF_NUMBER_TABLE
1178: , p3_a1 out nocopy JTF_NUMBER_TABLE
1179: , p3_a2 out nocopy JTF_NUMBER_TABLE
1180: , p3_a3 out nocopy JTF_NUMBER_TABLE
1181: , p3_a4 out nocopy JTF_NUMBER_TABLE
1182: , p3_a5 out nocopy JTF_NUMBER_TABLE
1183: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p3_a7 out nocopy JTF_NUMBER_TABLE
1185: ) return varchar2

Line 1182: , p3_a5 out nocopy JTF_NUMBER_TABLE

1178: , p3_a1 out nocopy JTF_NUMBER_TABLE
1179: , p3_a2 out nocopy JTF_NUMBER_TABLE
1180: , p3_a3 out nocopy JTF_NUMBER_TABLE
1181: , p3_a4 out nocopy JTF_NUMBER_TABLE
1182: , p3_a5 out nocopy JTF_NUMBER_TABLE
1183: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p3_a7 out nocopy JTF_NUMBER_TABLE
1185: ) return varchar2
1186:

Line 1184: , p3_a7 out nocopy JTF_NUMBER_TABLE

1180: , p3_a3 out nocopy JTF_NUMBER_TABLE
1181: , p3_a4 out nocopy JTF_NUMBER_TABLE
1182: , p3_a5 out nocopy JTF_NUMBER_TABLE
1183: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
1184: , p3_a7 out nocopy JTF_NUMBER_TABLE
1185: ) return varchar2
1186:
1187: as
1188: ddp_actual_date date;

Line 1235: , p1_a0 in out nocopy JTF_NUMBER_TABLE

1231: , p0_a8 NUMBER
1232: , p0_a9 NUMBER
1233: , p0_a10 NUMBER
1234: , p0_a11 DATE
1235: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1237: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1238: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1239: , p1_a4 in out nocopy JTF_NUMBER_TABLE

Line 1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE

1232: , p0_a9 NUMBER
1233: , p0_a10 NUMBER
1234: , p0_a11 DATE
1235: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1237: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1238: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1239: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1240: , p1_a5 in out nocopy JTF_NUMBER_TABLE

Line 1237: , p1_a2 in out nocopy JTF_NUMBER_TABLE

1233: , p0_a10 NUMBER
1234: , p0_a11 DATE
1235: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1237: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1238: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1239: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1240: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1241: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1238: , p1_a3 in out nocopy JTF_NUMBER_TABLE

1234: , p0_a11 DATE
1235: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1237: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1238: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1239: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1240: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1241: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1242: , p1_a7 in out nocopy JTF_NUMBER_TABLE

Line 1239: , p1_a4 in out nocopy JTF_NUMBER_TABLE

1235: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1237: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1238: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1239: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1240: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1241: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1242: , p1_a7 in out nocopy JTF_NUMBER_TABLE
1243: , p_actual_end_date date

Line 1240: , p1_a5 in out nocopy JTF_NUMBER_TABLE

1236: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1237: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1238: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1239: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1240: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1241: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1242: , p1_a7 in out nocopy JTF_NUMBER_TABLE
1243: , p_actual_end_date date
1244: , x_msg_count out nocopy VARCHAR2

Line 1242: , p1_a7 in out nocopy JTF_NUMBER_TABLE

1238: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1239: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1240: , p1_a5 in out nocopy JTF_NUMBER_TABLE
1241: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
1242: , p1_a7 in out nocopy JTF_NUMBER_TABLE
1243: , p_actual_end_date date
1244: , x_msg_count out nocopy VARCHAR2
1245: , x_msg_data out nocopy VARCHAR2
1246: ) return varchar2

Line 1312: , p3_a0 out nocopy JTF_NUMBER_TABLE

1308:
1309: function get_cp_counters(p_item_instance_id NUMBER
1310: , p_wip_entity_id NUMBER
1311: , p_actual_date date
1312: , p3_a0 out nocopy JTF_NUMBER_TABLE
1313: , p3_a1 out nocopy JTF_NUMBER_TABLE
1314: , p3_a2 out nocopy JTF_NUMBER_TABLE
1315: , p3_a3 out nocopy JTF_NUMBER_TABLE
1316: , p3_a4 out nocopy JTF_NUMBER_TABLE

Line 1313: , p3_a1 out nocopy JTF_NUMBER_TABLE

1309: function get_cp_counters(p_item_instance_id NUMBER
1310: , p_wip_entity_id NUMBER
1311: , p_actual_date date
1312: , p3_a0 out nocopy JTF_NUMBER_TABLE
1313: , p3_a1 out nocopy JTF_NUMBER_TABLE
1314: , p3_a2 out nocopy JTF_NUMBER_TABLE
1315: , p3_a3 out nocopy JTF_NUMBER_TABLE
1316: , p3_a4 out nocopy JTF_NUMBER_TABLE
1317: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 1314: , p3_a2 out nocopy JTF_NUMBER_TABLE

1310: , p_wip_entity_id NUMBER
1311: , p_actual_date date
1312: , p3_a0 out nocopy JTF_NUMBER_TABLE
1313: , p3_a1 out nocopy JTF_NUMBER_TABLE
1314: , p3_a2 out nocopy JTF_NUMBER_TABLE
1315: , p3_a3 out nocopy JTF_NUMBER_TABLE
1316: , p3_a4 out nocopy JTF_NUMBER_TABLE
1317: , p3_a5 out nocopy JTF_NUMBER_TABLE
1318: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 1315: , p3_a3 out nocopy JTF_NUMBER_TABLE

1311: , p_actual_date date
1312: , p3_a0 out nocopy JTF_NUMBER_TABLE
1313: , p3_a1 out nocopy JTF_NUMBER_TABLE
1314: , p3_a2 out nocopy JTF_NUMBER_TABLE
1315: , p3_a3 out nocopy JTF_NUMBER_TABLE
1316: , p3_a4 out nocopy JTF_NUMBER_TABLE
1317: , p3_a5 out nocopy JTF_NUMBER_TABLE
1318: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
1319: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 1316: , p3_a4 out nocopy JTF_NUMBER_TABLE

1312: , p3_a0 out nocopy JTF_NUMBER_TABLE
1313: , p3_a1 out nocopy JTF_NUMBER_TABLE
1314: , p3_a2 out nocopy JTF_NUMBER_TABLE
1315: , p3_a3 out nocopy JTF_NUMBER_TABLE
1316: , p3_a4 out nocopy JTF_NUMBER_TABLE
1317: , p3_a5 out nocopy JTF_NUMBER_TABLE
1318: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
1319: , p3_a7 out nocopy JTF_NUMBER_TABLE
1320: ) return varchar2

Line 1317: , p3_a5 out nocopy JTF_NUMBER_TABLE

1313: , p3_a1 out nocopy JTF_NUMBER_TABLE
1314: , p3_a2 out nocopy JTF_NUMBER_TABLE
1315: , p3_a3 out nocopy JTF_NUMBER_TABLE
1316: , p3_a4 out nocopy JTF_NUMBER_TABLE
1317: , p3_a5 out nocopy JTF_NUMBER_TABLE
1318: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
1319: , p3_a7 out nocopy JTF_NUMBER_TABLE
1320: ) return varchar2
1321:

Line 1319: , p3_a7 out nocopy JTF_NUMBER_TABLE

1315: , p3_a3 out nocopy JTF_NUMBER_TABLE
1316: , p3_a4 out nocopy JTF_NUMBER_TABLE
1317: , p3_a5 out nocopy JTF_NUMBER_TABLE
1318: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
1319: , p3_a7 out nocopy JTF_NUMBER_TABLE
1320: ) return varchar2
1321:
1322: as
1323: ddp_actual_date date;

Line 1361: , p3_a0 JTF_NUMBER_TABLE

1357:
1358: function update_ump(p_unit_effectivity_id NUMBER
1359: , p_ue_object_version NUMBER
1360: , p_actual_end_date date
1361: , p3_a0 JTF_NUMBER_TABLE
1362: , p3_a1 JTF_NUMBER_TABLE
1363: , p3_a2 JTF_NUMBER_TABLE
1364: , p3_a3 JTF_NUMBER_TABLE
1365: , p3_a4 JTF_NUMBER_TABLE

Line 1362: , p3_a1 JTF_NUMBER_TABLE

1358: function update_ump(p_unit_effectivity_id NUMBER
1359: , p_ue_object_version NUMBER
1360: , p_actual_end_date date
1361: , p3_a0 JTF_NUMBER_TABLE
1362: , p3_a1 JTF_NUMBER_TABLE
1363: , p3_a2 JTF_NUMBER_TABLE
1364: , p3_a3 JTF_NUMBER_TABLE
1365: , p3_a4 JTF_NUMBER_TABLE
1366: , p3_a5 JTF_NUMBER_TABLE

Line 1363: , p3_a2 JTF_NUMBER_TABLE

1359: , p_ue_object_version NUMBER
1360: , p_actual_end_date date
1361: , p3_a0 JTF_NUMBER_TABLE
1362: , p3_a1 JTF_NUMBER_TABLE
1363: , p3_a2 JTF_NUMBER_TABLE
1364: , p3_a3 JTF_NUMBER_TABLE
1365: , p3_a4 JTF_NUMBER_TABLE
1366: , p3_a5 JTF_NUMBER_TABLE
1367: , p3_a6 JTF_VARCHAR2_TABLE_100

Line 1364: , p3_a3 JTF_NUMBER_TABLE

1360: , p_actual_end_date date
1361: , p3_a0 JTF_NUMBER_TABLE
1362: , p3_a1 JTF_NUMBER_TABLE
1363: , p3_a2 JTF_NUMBER_TABLE
1364: , p3_a3 JTF_NUMBER_TABLE
1365: , p3_a4 JTF_NUMBER_TABLE
1366: , p3_a5 JTF_NUMBER_TABLE
1367: , p3_a6 JTF_VARCHAR2_TABLE_100
1368: , p3_a7 JTF_NUMBER_TABLE

Line 1365: , p3_a4 JTF_NUMBER_TABLE

1361: , p3_a0 JTF_NUMBER_TABLE
1362: , p3_a1 JTF_NUMBER_TABLE
1363: , p3_a2 JTF_NUMBER_TABLE
1364: , p3_a3 JTF_NUMBER_TABLE
1365: , p3_a4 JTF_NUMBER_TABLE
1366: , p3_a5 JTF_NUMBER_TABLE
1367: , p3_a6 JTF_VARCHAR2_TABLE_100
1368: , p3_a7 JTF_NUMBER_TABLE
1369: , p_dml_flag VARCHAR2

Line 1366: , p3_a5 JTF_NUMBER_TABLE

1362: , p3_a1 JTF_NUMBER_TABLE
1363: , p3_a2 JTF_NUMBER_TABLE
1364: , p3_a3 JTF_NUMBER_TABLE
1365: , p3_a4 JTF_NUMBER_TABLE
1366: , p3_a5 JTF_NUMBER_TABLE
1367: , p3_a6 JTF_VARCHAR2_TABLE_100
1368: , p3_a7 JTF_NUMBER_TABLE
1369: , p_dml_flag VARCHAR2
1370: , x_msg_count out nocopy VARCHAR2

Line 1368: , p3_a7 JTF_NUMBER_TABLE

1364: , p3_a3 JTF_NUMBER_TABLE
1365: , p3_a4 JTF_NUMBER_TABLE
1366: , p3_a5 JTF_NUMBER_TABLE
1367: , p3_a6 JTF_VARCHAR2_TABLE_100
1368: , p3_a7 JTF_NUMBER_TABLE
1369: , p_dml_flag VARCHAR2
1370: , x_msg_count out nocopy VARCHAR2
1371: , x_msg_data out nocopy VARCHAR2
1372: ) return varchar2