APPS.JTA_SYNC_TASK_W dependencies on JTF_NUMBER_TABLE

Line 16: procedure rosetta_table_copy_in_p3(t out nocopy jta_sync_task.task_tbl, 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_p3(t out nocopy jta_sync_task.task_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_NUMBER_TABLE

Line 17: , a1 JTF_NUMBER_TABLE

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

Line 18: , a2 JTF_NUMBER_TABLE

14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy jta_sync_task.task_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100

Line 20: , a4 JTF_NUMBER_TABLE

16: procedure rosetta_table_copy_in_p3(t out nocopy jta_sync_task.task_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_2000
24: , a8 JTF_VARCHAR2_TABLE_4000

Line 32: , a16 JTF_NUMBER_TABLE

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

Line 33: , a17 JTF_NUMBER_TABLE

29: , a13 JTF_DATE_TABLE
30: , a14 JTF_DATE_TABLE
31: , a15 JTF_DATE_TABLE
32: , a16 JTF_NUMBER_TABLE
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_DATE_TABLE
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_300

Line 38: , a22 JTF_NUMBER_TABLE

34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_DATE_TABLE
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_300
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_VARCHAR2_TABLE_2000
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_VARCHAR2_TABLE_300

Line 40: , a24 JTF_NUMBER_TABLE

36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_300
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_VARCHAR2_TABLE_2000
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_VARCHAR2_TABLE_300
43: , a27 JTF_VARCHAR2_TABLE_2000
44: , a28 JTF_VARCHAR2_TABLE_100

Line 41: , a25 JTF_NUMBER_TABLE

37: , a21 JTF_VARCHAR2_TABLE_300
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_VARCHAR2_TABLE_2000
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_VARCHAR2_TABLE_300
43: , a27 JTF_VARCHAR2_TABLE_2000
44: , a28 JTF_VARCHAR2_TABLE_100
45: , a29 JTF_NUMBER_TABLE

Line 45: , a29 JTF_NUMBER_TABLE

41: , a25 JTF_NUMBER_TABLE
42: , a26 JTF_VARCHAR2_TABLE_300
43: , a27 JTF_VARCHAR2_TABLE_2000
44: , a28 JTF_VARCHAR2_TABLE_100
45: , a29 JTF_NUMBER_TABLE
46: , a30 JTF_DATE_TABLE
47: , a31 JTF_DATE_TABLE
48: , a32 JTF_VARCHAR2_TABLE_100
49: , a33 JTF_VARCHAR2_TABLE_100

Line 55: , a39 JTF_NUMBER_TABLE

51: , a35 JTF_VARCHAR2_TABLE_100
52: , a36 JTF_VARCHAR2_TABLE_100
53: , a37 JTF_VARCHAR2_TABLE_100
54: , a38 JTF_VARCHAR2_TABLE_100
55: , a39 JTF_NUMBER_TABLE
56: , a40 JTF_NUMBER_TABLE
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin

Line 56: , a40 JTF_NUMBER_TABLE

52: , a36 JTF_VARCHAR2_TABLE_100
53: , a37 JTF_VARCHAR2_TABLE_100
54: , a38 JTF_VARCHAR2_TABLE_100
55: , a39 JTF_NUMBER_TABLE
56: , a40 JTF_NUMBER_TABLE
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin
60: if a0 is not null and a0.count > 0 then

Line 115: procedure rosetta_table_copy_out_p3(t jta_sync_task.task_tbl, a0 out nocopy JTF_NUMBER_TABLE

111: end loop;
112: end if;
113: end if;
114: end rosetta_table_copy_in_p3;
115: procedure rosetta_table_copy_out_p3(t jta_sync_task.task_tbl, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_DATE_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE

Line 116: , a1 out nocopy JTF_NUMBER_TABLE

112: end if;
113: end if;
114: end rosetta_table_copy_in_p3;
115: procedure rosetta_table_copy_out_p3(t jta_sync_task.task_tbl, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_DATE_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE
120: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 117: , a2 out nocopy JTF_NUMBER_TABLE

113: end if;
114: end rosetta_table_copy_in_p3;
115: procedure rosetta_table_copy_out_p3(t jta_sync_task.task_tbl, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_DATE_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE
120: , a5 out nocopy JTF_VARCHAR2_TABLE_100
121: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 119: , a4 out nocopy JTF_NUMBER_TABLE

115: procedure rosetta_table_copy_out_p3(t jta_sync_task.task_tbl, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_DATE_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE
120: , a5 out nocopy JTF_VARCHAR2_TABLE_100
121: , a6 out nocopy JTF_VARCHAR2_TABLE_100
122: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
123: , a8 out nocopy JTF_VARCHAR2_TABLE_4000

Line 131: , a16 out nocopy JTF_NUMBER_TABLE

127: , a12 out nocopy JTF_DATE_TABLE
128: , a13 out nocopy JTF_DATE_TABLE
129: , a14 out nocopy JTF_DATE_TABLE
130: , a15 out nocopy JTF_DATE_TABLE
131: , a16 out nocopy JTF_NUMBER_TABLE
132: , a17 out nocopy JTF_NUMBER_TABLE
133: , a18 out nocopy JTF_VARCHAR2_TABLE_100
134: , a19 out nocopy JTF_DATE_TABLE
135: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 132: , a17 out nocopy JTF_NUMBER_TABLE

128: , a13 out nocopy JTF_DATE_TABLE
129: , a14 out nocopy JTF_DATE_TABLE
130: , a15 out nocopy JTF_DATE_TABLE
131: , a16 out nocopy JTF_NUMBER_TABLE
132: , a17 out nocopy JTF_NUMBER_TABLE
133: , a18 out nocopy JTF_VARCHAR2_TABLE_100
134: , a19 out nocopy JTF_DATE_TABLE
135: , a20 out nocopy JTF_VARCHAR2_TABLE_100
136: , a21 out nocopy JTF_VARCHAR2_TABLE_300

Line 137: , a22 out nocopy JTF_NUMBER_TABLE

133: , a18 out nocopy JTF_VARCHAR2_TABLE_100
134: , a19 out nocopy JTF_DATE_TABLE
135: , a20 out nocopy JTF_VARCHAR2_TABLE_100
136: , a21 out nocopy JTF_VARCHAR2_TABLE_300
137: , a22 out nocopy JTF_NUMBER_TABLE
138: , a23 out nocopy JTF_VARCHAR2_TABLE_2000
139: , a24 out nocopy JTF_NUMBER_TABLE
140: , a25 out nocopy JTF_NUMBER_TABLE
141: , a26 out nocopy JTF_VARCHAR2_TABLE_300

Line 139: , a24 out nocopy JTF_NUMBER_TABLE

135: , a20 out nocopy JTF_VARCHAR2_TABLE_100
136: , a21 out nocopy JTF_VARCHAR2_TABLE_300
137: , a22 out nocopy JTF_NUMBER_TABLE
138: , a23 out nocopy JTF_VARCHAR2_TABLE_2000
139: , a24 out nocopy JTF_NUMBER_TABLE
140: , a25 out nocopy JTF_NUMBER_TABLE
141: , a26 out nocopy JTF_VARCHAR2_TABLE_300
142: , a27 out nocopy JTF_VARCHAR2_TABLE_2000
143: , a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 140: , a25 out nocopy JTF_NUMBER_TABLE

136: , a21 out nocopy JTF_VARCHAR2_TABLE_300
137: , a22 out nocopy JTF_NUMBER_TABLE
138: , a23 out nocopy JTF_VARCHAR2_TABLE_2000
139: , a24 out nocopy JTF_NUMBER_TABLE
140: , a25 out nocopy JTF_NUMBER_TABLE
141: , a26 out nocopy JTF_VARCHAR2_TABLE_300
142: , a27 out nocopy JTF_VARCHAR2_TABLE_2000
143: , a28 out nocopy JTF_VARCHAR2_TABLE_100
144: , a29 out nocopy JTF_NUMBER_TABLE

Line 144: , a29 out nocopy JTF_NUMBER_TABLE

140: , a25 out nocopy JTF_NUMBER_TABLE
141: , a26 out nocopy JTF_VARCHAR2_TABLE_300
142: , a27 out nocopy JTF_VARCHAR2_TABLE_2000
143: , a28 out nocopy JTF_VARCHAR2_TABLE_100
144: , a29 out nocopy JTF_NUMBER_TABLE
145: , a30 out nocopy JTF_DATE_TABLE
146: , a31 out nocopy JTF_DATE_TABLE
147: , a32 out nocopy JTF_VARCHAR2_TABLE_100
148: , a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 154: , a39 out nocopy JTF_NUMBER_TABLE

150: , a35 out nocopy JTF_VARCHAR2_TABLE_100
151: , a36 out nocopy JTF_VARCHAR2_TABLE_100
152: , a37 out nocopy JTF_VARCHAR2_TABLE_100
153: , a38 out nocopy JTF_VARCHAR2_TABLE_100
154: , a39 out nocopy JTF_NUMBER_TABLE
155: , a40 out nocopy JTF_NUMBER_TABLE
156: ) as
157: ddindx binary_integer; indx binary_integer;
158: begin

Line 155: , a40 out nocopy JTF_NUMBER_TABLE

151: , a36 out nocopy JTF_VARCHAR2_TABLE_100
152: , a37 out nocopy JTF_VARCHAR2_TABLE_100
153: , a38 out nocopy JTF_VARCHAR2_TABLE_100
154: , a39 out nocopy JTF_NUMBER_TABLE
155: , a40 out nocopy JTF_NUMBER_TABLE
156: ) as
157: ddindx binary_integer; indx binary_integer;
158: begin
159: if t is null or t.count = 0 then

Line 160: a0 := JTF_NUMBER_TABLE();

156: ) as
157: ddindx binary_integer; indx binary_integer;
158: begin
159: if t is null or t.count = 0 then
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_DATE_TABLE();
164: a4 := JTF_NUMBER_TABLE();

Line 161: a1 := JTF_NUMBER_TABLE();

157: ddindx binary_integer; indx binary_integer;
158: begin
159: if t is null or t.count = 0 then
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_DATE_TABLE();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_VARCHAR2_TABLE_100();

Line 162: a2 := JTF_NUMBER_TABLE();

158: begin
159: if t is null or t.count = 0 then
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_DATE_TABLE();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_VARCHAR2_TABLE_100();

Line 164: a4 := JTF_NUMBER_TABLE();

160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_DATE_TABLE();
164: a4 := JTF_NUMBER_TABLE();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_VARCHAR2_TABLE_2000();
168: a8 := JTF_VARCHAR2_TABLE_4000();

Line 176: a16 := JTF_NUMBER_TABLE();

172: a12 := JTF_DATE_TABLE();
173: a13 := JTF_DATE_TABLE();
174: a14 := JTF_DATE_TABLE();
175: a15 := JTF_DATE_TABLE();
176: a16 := JTF_NUMBER_TABLE();
177: a17 := JTF_NUMBER_TABLE();
178: a18 := JTF_VARCHAR2_TABLE_100();
179: a19 := JTF_DATE_TABLE();
180: a20 := JTF_VARCHAR2_TABLE_100();

Line 177: a17 := JTF_NUMBER_TABLE();

173: a13 := JTF_DATE_TABLE();
174: a14 := JTF_DATE_TABLE();
175: a15 := JTF_DATE_TABLE();
176: a16 := JTF_NUMBER_TABLE();
177: a17 := JTF_NUMBER_TABLE();
178: a18 := JTF_VARCHAR2_TABLE_100();
179: a19 := JTF_DATE_TABLE();
180: a20 := JTF_VARCHAR2_TABLE_100();
181: a21 := JTF_VARCHAR2_TABLE_300();

Line 182: a22 := JTF_NUMBER_TABLE();

178: a18 := JTF_VARCHAR2_TABLE_100();
179: a19 := JTF_DATE_TABLE();
180: a20 := JTF_VARCHAR2_TABLE_100();
181: a21 := JTF_VARCHAR2_TABLE_300();
182: a22 := JTF_NUMBER_TABLE();
183: a23 := JTF_VARCHAR2_TABLE_2000();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_NUMBER_TABLE();
186: a26 := JTF_VARCHAR2_TABLE_300();

Line 184: a24 := JTF_NUMBER_TABLE();

180: a20 := JTF_VARCHAR2_TABLE_100();
181: a21 := JTF_VARCHAR2_TABLE_300();
182: a22 := JTF_NUMBER_TABLE();
183: a23 := JTF_VARCHAR2_TABLE_2000();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_NUMBER_TABLE();
186: a26 := JTF_VARCHAR2_TABLE_300();
187: a27 := JTF_VARCHAR2_TABLE_2000();
188: a28 := JTF_VARCHAR2_TABLE_100();

Line 185: a25 := JTF_NUMBER_TABLE();

181: a21 := JTF_VARCHAR2_TABLE_300();
182: a22 := JTF_NUMBER_TABLE();
183: a23 := JTF_VARCHAR2_TABLE_2000();
184: a24 := JTF_NUMBER_TABLE();
185: a25 := JTF_NUMBER_TABLE();
186: a26 := JTF_VARCHAR2_TABLE_300();
187: a27 := JTF_VARCHAR2_TABLE_2000();
188: a28 := JTF_VARCHAR2_TABLE_100();
189: a29 := JTF_NUMBER_TABLE();

Line 189: a29 := JTF_NUMBER_TABLE();

185: a25 := JTF_NUMBER_TABLE();
186: a26 := JTF_VARCHAR2_TABLE_300();
187: a27 := JTF_VARCHAR2_TABLE_2000();
188: a28 := JTF_VARCHAR2_TABLE_100();
189: a29 := JTF_NUMBER_TABLE();
190: a30 := JTF_DATE_TABLE();
191: a31 := JTF_DATE_TABLE();
192: a32 := JTF_VARCHAR2_TABLE_100();
193: a33 := JTF_VARCHAR2_TABLE_100();

Line 199: a39 := JTF_NUMBER_TABLE();

195: a35 := JTF_VARCHAR2_TABLE_100();
196: a36 := JTF_VARCHAR2_TABLE_100();
197: a37 := JTF_VARCHAR2_TABLE_100();
198: a38 := JTF_VARCHAR2_TABLE_100();
199: a39 := JTF_NUMBER_TABLE();
200: a40 := JTF_NUMBER_TABLE();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_NUMBER_TABLE();

Line 200: a40 := JTF_NUMBER_TABLE();

196: a36 := JTF_VARCHAR2_TABLE_100();
197: a37 := JTF_VARCHAR2_TABLE_100();
198: a38 := JTF_VARCHAR2_TABLE_100();
199: a39 := JTF_NUMBER_TABLE();
200: a40 := JTF_NUMBER_TABLE();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_NUMBER_TABLE();
204: a2 := JTF_NUMBER_TABLE();

Line 202: a0 := JTF_NUMBER_TABLE();

198: a38 := JTF_VARCHAR2_TABLE_100();
199: a39 := JTF_NUMBER_TABLE();
200: a40 := JTF_NUMBER_TABLE();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_NUMBER_TABLE();
204: a2 := JTF_NUMBER_TABLE();
205: a3 := JTF_DATE_TABLE();
206: a4 := JTF_NUMBER_TABLE();

Line 203: a1 := JTF_NUMBER_TABLE();

199: a39 := JTF_NUMBER_TABLE();
200: a40 := JTF_NUMBER_TABLE();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_NUMBER_TABLE();
204: a2 := JTF_NUMBER_TABLE();
205: a3 := JTF_DATE_TABLE();
206: a4 := JTF_NUMBER_TABLE();
207: a5 := JTF_VARCHAR2_TABLE_100();

Line 204: a2 := JTF_NUMBER_TABLE();

200: a40 := JTF_NUMBER_TABLE();
201: else
202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_NUMBER_TABLE();
204: a2 := JTF_NUMBER_TABLE();
205: a3 := JTF_DATE_TABLE();
206: a4 := JTF_NUMBER_TABLE();
207: a5 := JTF_VARCHAR2_TABLE_100();
208: a6 := JTF_VARCHAR2_TABLE_100();

Line 206: a4 := JTF_NUMBER_TABLE();

202: a0 := JTF_NUMBER_TABLE();
203: a1 := JTF_NUMBER_TABLE();
204: a2 := JTF_NUMBER_TABLE();
205: a3 := JTF_DATE_TABLE();
206: a4 := JTF_NUMBER_TABLE();
207: a5 := JTF_VARCHAR2_TABLE_100();
208: a6 := JTF_VARCHAR2_TABLE_100();
209: a7 := JTF_VARCHAR2_TABLE_2000();
210: a8 := JTF_VARCHAR2_TABLE_4000();

Line 218: a16 := JTF_NUMBER_TABLE();

214: a12 := JTF_DATE_TABLE();
215: a13 := JTF_DATE_TABLE();
216: a14 := JTF_DATE_TABLE();
217: a15 := JTF_DATE_TABLE();
218: a16 := JTF_NUMBER_TABLE();
219: a17 := JTF_NUMBER_TABLE();
220: a18 := JTF_VARCHAR2_TABLE_100();
221: a19 := JTF_DATE_TABLE();
222: a20 := JTF_VARCHAR2_TABLE_100();

Line 219: a17 := JTF_NUMBER_TABLE();

215: a13 := JTF_DATE_TABLE();
216: a14 := JTF_DATE_TABLE();
217: a15 := JTF_DATE_TABLE();
218: a16 := JTF_NUMBER_TABLE();
219: a17 := JTF_NUMBER_TABLE();
220: a18 := JTF_VARCHAR2_TABLE_100();
221: a19 := JTF_DATE_TABLE();
222: a20 := JTF_VARCHAR2_TABLE_100();
223: a21 := JTF_VARCHAR2_TABLE_300();

Line 224: a22 := JTF_NUMBER_TABLE();

220: a18 := JTF_VARCHAR2_TABLE_100();
221: a19 := JTF_DATE_TABLE();
222: a20 := JTF_VARCHAR2_TABLE_100();
223: a21 := JTF_VARCHAR2_TABLE_300();
224: a22 := JTF_NUMBER_TABLE();
225: a23 := JTF_VARCHAR2_TABLE_2000();
226: a24 := JTF_NUMBER_TABLE();
227: a25 := JTF_NUMBER_TABLE();
228: a26 := JTF_VARCHAR2_TABLE_300();

Line 226: a24 := JTF_NUMBER_TABLE();

222: a20 := JTF_VARCHAR2_TABLE_100();
223: a21 := JTF_VARCHAR2_TABLE_300();
224: a22 := JTF_NUMBER_TABLE();
225: a23 := JTF_VARCHAR2_TABLE_2000();
226: a24 := JTF_NUMBER_TABLE();
227: a25 := JTF_NUMBER_TABLE();
228: a26 := JTF_VARCHAR2_TABLE_300();
229: a27 := JTF_VARCHAR2_TABLE_2000();
230: a28 := JTF_VARCHAR2_TABLE_100();

Line 227: a25 := JTF_NUMBER_TABLE();

223: a21 := JTF_VARCHAR2_TABLE_300();
224: a22 := JTF_NUMBER_TABLE();
225: a23 := JTF_VARCHAR2_TABLE_2000();
226: a24 := JTF_NUMBER_TABLE();
227: a25 := JTF_NUMBER_TABLE();
228: a26 := JTF_VARCHAR2_TABLE_300();
229: a27 := JTF_VARCHAR2_TABLE_2000();
230: a28 := JTF_VARCHAR2_TABLE_100();
231: a29 := JTF_NUMBER_TABLE();

Line 231: a29 := JTF_NUMBER_TABLE();

227: a25 := JTF_NUMBER_TABLE();
228: a26 := JTF_VARCHAR2_TABLE_300();
229: a27 := JTF_VARCHAR2_TABLE_2000();
230: a28 := JTF_VARCHAR2_TABLE_100();
231: a29 := JTF_NUMBER_TABLE();
232: a30 := JTF_DATE_TABLE();
233: a31 := JTF_DATE_TABLE();
234: a32 := JTF_VARCHAR2_TABLE_100();
235: a33 := JTF_VARCHAR2_TABLE_100();

Line 241: a39 := JTF_NUMBER_TABLE();

237: a35 := JTF_VARCHAR2_TABLE_100();
238: a36 := JTF_VARCHAR2_TABLE_100();
239: a37 := JTF_VARCHAR2_TABLE_100();
240: a38 := JTF_VARCHAR2_TABLE_100();
241: a39 := JTF_NUMBER_TABLE();
242: a40 := JTF_NUMBER_TABLE();
243: if t.count > 0 then
244: a0.extend(t.count);
245: a1.extend(t.count);

Line 242: a40 := JTF_NUMBER_TABLE();

238: a36 := JTF_VARCHAR2_TABLE_100();
239: a37 := JTF_VARCHAR2_TABLE_100();
240: a38 := JTF_VARCHAR2_TABLE_100();
241: a39 := JTF_NUMBER_TABLE();
242: a40 := JTF_NUMBER_TABLE();
243: if t.count > 0 then
244: a0.extend(t.count);
245: a1.extend(t.count);
246: a2.extend(t.count);

Line 339: procedure rosetta_table_copy_in_p4(t out nocopy jta_sync_task.exclusion_tbl, a0 JTF_NUMBER_TABLE

335: end if;
336: end if;
337: end rosetta_table_copy_out_p3;
338:
339: procedure rosetta_table_copy_in_p4(t out nocopy jta_sync_task.exclusion_tbl, a0 JTF_NUMBER_TABLE
340: , a1 JTF_DATE_TABLE
341: ) as
342: ddindx binary_integer; indx binary_integer;
343: begin

Line 360: procedure rosetta_table_copy_out_p4(t jta_sync_task.exclusion_tbl, a0 out nocopy JTF_NUMBER_TABLE

356: end loop;
357: end if;
358: end if;
359: end rosetta_table_copy_in_p4;
360: procedure rosetta_table_copy_out_p4(t jta_sync_task.exclusion_tbl, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_DATE_TABLE
362: ) as
363: ddindx binary_integer; indx binary_integer;
364: begin

Line 366: a0 := JTF_NUMBER_TABLE();

362: ) as
363: ddindx binary_integer; indx binary_integer;
364: begin
365: if t is null or t.count = 0 then
366: a0 := JTF_NUMBER_TABLE();
367: a1 := JTF_DATE_TABLE();
368: else
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_DATE_TABLE();

Line 369: a0 := JTF_NUMBER_TABLE();

365: if t is null or t.count = 0 then
366: a0 := JTF_NUMBER_TABLE();
367: a1 := JTF_DATE_TABLE();
368: else
369: a0 := JTF_NUMBER_TABLE();
370: a1 := JTF_DATE_TABLE();
371: if t.count > 0 then
372: a0.extend(t.count);
373: a1.extend(t.count);

Line 428: , p2_a0 out nocopy JTF_NUMBER_TABLE

424: end;
425:
426: procedure get_list(p_request_type VARCHAR2
427: , p_syncanchor date
428: , p2_a0 out nocopy JTF_NUMBER_TABLE
429: , p2_a1 out nocopy JTF_NUMBER_TABLE
430: , p2_a2 out nocopy JTF_NUMBER_TABLE
431: , p2_a3 out nocopy JTF_DATE_TABLE
432: , p2_a4 out nocopy JTF_NUMBER_TABLE

Line 429: , p2_a1 out nocopy JTF_NUMBER_TABLE

425:
426: procedure get_list(p_request_type VARCHAR2
427: , p_syncanchor date
428: , p2_a0 out nocopy JTF_NUMBER_TABLE
429: , p2_a1 out nocopy JTF_NUMBER_TABLE
430: , p2_a2 out nocopy JTF_NUMBER_TABLE
431: , p2_a3 out nocopy JTF_DATE_TABLE
432: , p2_a4 out nocopy JTF_NUMBER_TABLE
433: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 430: , p2_a2 out nocopy JTF_NUMBER_TABLE

426: procedure get_list(p_request_type VARCHAR2
427: , p_syncanchor date
428: , p2_a0 out nocopy JTF_NUMBER_TABLE
429: , p2_a1 out nocopy JTF_NUMBER_TABLE
430: , p2_a2 out nocopy JTF_NUMBER_TABLE
431: , p2_a3 out nocopy JTF_DATE_TABLE
432: , p2_a4 out nocopy JTF_NUMBER_TABLE
433: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
434: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 432: , p2_a4 out nocopy JTF_NUMBER_TABLE

428: , p2_a0 out nocopy JTF_NUMBER_TABLE
429: , p2_a1 out nocopy JTF_NUMBER_TABLE
430: , p2_a2 out nocopy JTF_NUMBER_TABLE
431: , p2_a3 out nocopy JTF_DATE_TABLE
432: , p2_a4 out nocopy JTF_NUMBER_TABLE
433: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
434: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
435: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_2000
436: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_4000

Line 444: , p2_a16 out nocopy JTF_NUMBER_TABLE

440: , p2_a12 out nocopy JTF_DATE_TABLE
441: , p2_a13 out nocopy JTF_DATE_TABLE
442: , p2_a14 out nocopy JTF_DATE_TABLE
443: , p2_a15 out nocopy JTF_DATE_TABLE
444: , p2_a16 out nocopy JTF_NUMBER_TABLE
445: , p2_a17 out nocopy JTF_NUMBER_TABLE
446: , p2_a18 out nocopy JTF_VARCHAR2_TABLE_100
447: , p2_a19 out nocopy JTF_DATE_TABLE
448: , p2_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 445: , p2_a17 out nocopy JTF_NUMBER_TABLE

441: , p2_a13 out nocopy JTF_DATE_TABLE
442: , p2_a14 out nocopy JTF_DATE_TABLE
443: , p2_a15 out nocopy JTF_DATE_TABLE
444: , p2_a16 out nocopy JTF_NUMBER_TABLE
445: , p2_a17 out nocopy JTF_NUMBER_TABLE
446: , p2_a18 out nocopy JTF_VARCHAR2_TABLE_100
447: , p2_a19 out nocopy JTF_DATE_TABLE
448: , p2_a20 out nocopy JTF_VARCHAR2_TABLE_100
449: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_300

Line 450: , p2_a22 out nocopy JTF_NUMBER_TABLE

446: , p2_a18 out nocopy JTF_VARCHAR2_TABLE_100
447: , p2_a19 out nocopy JTF_DATE_TABLE
448: , p2_a20 out nocopy JTF_VARCHAR2_TABLE_100
449: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_300
450: , p2_a22 out nocopy JTF_NUMBER_TABLE
451: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_2000
452: , p2_a24 out nocopy JTF_NUMBER_TABLE
453: , p2_a25 out nocopy JTF_NUMBER_TABLE
454: , p2_a26 out nocopy JTF_VARCHAR2_TABLE_300

Line 452: , p2_a24 out nocopy JTF_NUMBER_TABLE

448: , p2_a20 out nocopy JTF_VARCHAR2_TABLE_100
449: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_300
450: , p2_a22 out nocopy JTF_NUMBER_TABLE
451: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_2000
452: , p2_a24 out nocopy JTF_NUMBER_TABLE
453: , p2_a25 out nocopy JTF_NUMBER_TABLE
454: , p2_a26 out nocopy JTF_VARCHAR2_TABLE_300
455: , p2_a27 out nocopy JTF_VARCHAR2_TABLE_2000
456: , p2_a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 453: , p2_a25 out nocopy JTF_NUMBER_TABLE

449: , p2_a21 out nocopy JTF_VARCHAR2_TABLE_300
450: , p2_a22 out nocopy JTF_NUMBER_TABLE
451: , p2_a23 out nocopy JTF_VARCHAR2_TABLE_2000
452: , p2_a24 out nocopy JTF_NUMBER_TABLE
453: , p2_a25 out nocopy JTF_NUMBER_TABLE
454: , p2_a26 out nocopy JTF_VARCHAR2_TABLE_300
455: , p2_a27 out nocopy JTF_VARCHAR2_TABLE_2000
456: , p2_a28 out nocopy JTF_VARCHAR2_TABLE_100
457: , p2_a29 out nocopy JTF_NUMBER_TABLE

Line 457: , p2_a29 out nocopy JTF_NUMBER_TABLE

453: , p2_a25 out nocopy JTF_NUMBER_TABLE
454: , p2_a26 out nocopy JTF_VARCHAR2_TABLE_300
455: , p2_a27 out nocopy JTF_VARCHAR2_TABLE_2000
456: , p2_a28 out nocopy JTF_VARCHAR2_TABLE_100
457: , p2_a29 out nocopy JTF_NUMBER_TABLE
458: , p2_a30 out nocopy JTF_DATE_TABLE
459: , p2_a31 out nocopy JTF_DATE_TABLE
460: , p2_a32 out nocopy JTF_VARCHAR2_TABLE_100
461: , p2_a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 467: , p2_a39 out nocopy JTF_NUMBER_TABLE

463: , p2_a35 out nocopy JTF_VARCHAR2_TABLE_100
464: , p2_a36 out nocopy JTF_VARCHAR2_TABLE_100
465: , p2_a37 out nocopy JTF_VARCHAR2_TABLE_100
466: , p2_a38 out nocopy JTF_VARCHAR2_TABLE_100
467: , p2_a39 out nocopy JTF_NUMBER_TABLE
468: , p2_a40 out nocopy JTF_NUMBER_TABLE
469: , p3_a0 out nocopy JTF_NUMBER_TABLE
470: , p3_a1 out nocopy JTF_DATE_TABLE
471: )

Line 468: , p2_a40 out nocopy JTF_NUMBER_TABLE

464: , p2_a36 out nocopy JTF_VARCHAR2_TABLE_100
465: , p2_a37 out nocopy JTF_VARCHAR2_TABLE_100
466: , p2_a38 out nocopy JTF_VARCHAR2_TABLE_100
467: , p2_a39 out nocopy JTF_NUMBER_TABLE
468: , p2_a40 out nocopy JTF_NUMBER_TABLE
469: , p3_a0 out nocopy JTF_NUMBER_TABLE
470: , p3_a1 out nocopy JTF_DATE_TABLE
471: )
472:

Line 469: , p3_a0 out nocopy JTF_NUMBER_TABLE

465: , p2_a37 out nocopy JTF_VARCHAR2_TABLE_100
466: , p2_a38 out nocopy JTF_VARCHAR2_TABLE_100
467: , p2_a39 out nocopy JTF_NUMBER_TABLE
468: , p2_a40 out nocopy JTF_NUMBER_TABLE
469: , p3_a0 out nocopy JTF_NUMBER_TABLE
470: , p3_a1 out nocopy JTF_DATE_TABLE
471: )
472:
473: as

Line 544: , p1_a0 in out nocopy JTF_NUMBER_TABLE

540: );
541: end;
542:
543: procedure create_ids(p_num_req NUMBER
544: , p1_a0 in out nocopy JTF_NUMBER_TABLE
545: , p1_a1 in out nocopy JTF_NUMBER_TABLE
546: , p1_a2 in out nocopy JTF_NUMBER_TABLE
547: , p1_a3 in out nocopy JTF_DATE_TABLE
548: , p1_a4 in out nocopy JTF_NUMBER_TABLE

Line 545: , p1_a1 in out nocopy JTF_NUMBER_TABLE

541: end;
542:
543: procedure create_ids(p_num_req NUMBER
544: , p1_a0 in out nocopy JTF_NUMBER_TABLE
545: , p1_a1 in out nocopy JTF_NUMBER_TABLE
546: , p1_a2 in out nocopy JTF_NUMBER_TABLE
547: , p1_a3 in out nocopy JTF_DATE_TABLE
548: , p1_a4 in out nocopy JTF_NUMBER_TABLE
549: , p1_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 546: , p1_a2 in out nocopy JTF_NUMBER_TABLE

542:
543: procedure create_ids(p_num_req NUMBER
544: , p1_a0 in out nocopy JTF_NUMBER_TABLE
545: , p1_a1 in out nocopy JTF_NUMBER_TABLE
546: , p1_a2 in out nocopy JTF_NUMBER_TABLE
547: , p1_a3 in out nocopy JTF_DATE_TABLE
548: , p1_a4 in out nocopy JTF_NUMBER_TABLE
549: , p1_a5 in out nocopy JTF_VARCHAR2_TABLE_100
550: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 548: , p1_a4 in out nocopy JTF_NUMBER_TABLE

544: , p1_a0 in out nocopy JTF_NUMBER_TABLE
545: , p1_a1 in out nocopy JTF_NUMBER_TABLE
546: , p1_a2 in out nocopy JTF_NUMBER_TABLE
547: , p1_a3 in out nocopy JTF_DATE_TABLE
548: , p1_a4 in out nocopy JTF_NUMBER_TABLE
549: , p1_a5 in out nocopy JTF_VARCHAR2_TABLE_100
550: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
551: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
552: , p1_a8 in out nocopy JTF_VARCHAR2_TABLE_4000

Line 560: , p1_a16 in out nocopy JTF_NUMBER_TABLE

556: , p1_a12 in out nocopy JTF_DATE_TABLE
557: , p1_a13 in out nocopy JTF_DATE_TABLE
558: , p1_a14 in out nocopy JTF_DATE_TABLE
559: , p1_a15 in out nocopy JTF_DATE_TABLE
560: , p1_a16 in out nocopy JTF_NUMBER_TABLE
561: , p1_a17 in out nocopy JTF_NUMBER_TABLE
562: , p1_a18 in out nocopy JTF_VARCHAR2_TABLE_100
563: , p1_a19 in out nocopy JTF_DATE_TABLE
564: , p1_a20 in out nocopy JTF_VARCHAR2_TABLE_100

Line 561: , p1_a17 in out nocopy JTF_NUMBER_TABLE

557: , p1_a13 in out nocopy JTF_DATE_TABLE
558: , p1_a14 in out nocopy JTF_DATE_TABLE
559: , p1_a15 in out nocopy JTF_DATE_TABLE
560: , p1_a16 in out nocopy JTF_NUMBER_TABLE
561: , p1_a17 in out nocopy JTF_NUMBER_TABLE
562: , p1_a18 in out nocopy JTF_VARCHAR2_TABLE_100
563: , p1_a19 in out nocopy JTF_DATE_TABLE
564: , p1_a20 in out nocopy JTF_VARCHAR2_TABLE_100
565: , p1_a21 in out nocopy JTF_VARCHAR2_TABLE_300

Line 566: , p1_a22 in out nocopy JTF_NUMBER_TABLE

562: , p1_a18 in out nocopy JTF_VARCHAR2_TABLE_100
563: , p1_a19 in out nocopy JTF_DATE_TABLE
564: , p1_a20 in out nocopy JTF_VARCHAR2_TABLE_100
565: , p1_a21 in out nocopy JTF_VARCHAR2_TABLE_300
566: , p1_a22 in out nocopy JTF_NUMBER_TABLE
567: , p1_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
568: , p1_a24 in out nocopy JTF_NUMBER_TABLE
569: , p1_a25 in out nocopy JTF_NUMBER_TABLE
570: , p1_a26 in out nocopy JTF_VARCHAR2_TABLE_300

Line 568: , p1_a24 in out nocopy JTF_NUMBER_TABLE

564: , p1_a20 in out nocopy JTF_VARCHAR2_TABLE_100
565: , p1_a21 in out nocopy JTF_VARCHAR2_TABLE_300
566: , p1_a22 in out nocopy JTF_NUMBER_TABLE
567: , p1_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
568: , p1_a24 in out nocopy JTF_NUMBER_TABLE
569: , p1_a25 in out nocopy JTF_NUMBER_TABLE
570: , p1_a26 in out nocopy JTF_VARCHAR2_TABLE_300
571: , p1_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
572: , p1_a28 in out nocopy JTF_VARCHAR2_TABLE_100

Line 569: , p1_a25 in out nocopy JTF_NUMBER_TABLE

565: , p1_a21 in out nocopy JTF_VARCHAR2_TABLE_300
566: , p1_a22 in out nocopy JTF_NUMBER_TABLE
567: , p1_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
568: , p1_a24 in out nocopy JTF_NUMBER_TABLE
569: , p1_a25 in out nocopy JTF_NUMBER_TABLE
570: , p1_a26 in out nocopy JTF_VARCHAR2_TABLE_300
571: , p1_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
572: , p1_a28 in out nocopy JTF_VARCHAR2_TABLE_100
573: , p1_a29 in out nocopy JTF_NUMBER_TABLE

Line 573: , p1_a29 in out nocopy JTF_NUMBER_TABLE

569: , p1_a25 in out nocopy JTF_NUMBER_TABLE
570: , p1_a26 in out nocopy JTF_VARCHAR2_TABLE_300
571: , p1_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
572: , p1_a28 in out nocopy JTF_VARCHAR2_TABLE_100
573: , p1_a29 in out nocopy JTF_NUMBER_TABLE
574: , p1_a30 in out nocopy JTF_DATE_TABLE
575: , p1_a31 in out nocopy JTF_DATE_TABLE
576: , p1_a32 in out nocopy JTF_VARCHAR2_TABLE_100
577: , p1_a33 in out nocopy JTF_VARCHAR2_TABLE_100

Line 583: , p1_a39 in out nocopy JTF_NUMBER_TABLE

579: , p1_a35 in out nocopy JTF_VARCHAR2_TABLE_100
580: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p1_a39 in out nocopy JTF_NUMBER_TABLE
584: , p1_a40 in out nocopy JTF_NUMBER_TABLE
585: )
586:
587: as

Line 584: , p1_a40 in out nocopy JTF_NUMBER_TABLE

580: , p1_a36 in out nocopy JTF_VARCHAR2_TABLE_100
581: , p1_a37 in out nocopy JTF_VARCHAR2_TABLE_100
582: , p1_a38 in out nocopy JTF_VARCHAR2_TABLE_100
583: , p1_a39 in out nocopy JTF_NUMBER_TABLE
584: , p1_a40 in out nocopy JTF_NUMBER_TABLE
585: )
586:
587: as
588: ddx_results jta_sync_task.task_tbl;

Line 687: procedure update_data(p0_a0 in out nocopy JTF_NUMBER_TABLE

683: , p1_a40
684: );
685: end;
686:
687: procedure update_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
688: , p0_a1 in out nocopy JTF_NUMBER_TABLE
689: , p0_a2 in out nocopy JTF_NUMBER_TABLE
690: , p0_a3 in out nocopy JTF_DATE_TABLE
691: , p0_a4 in out nocopy JTF_NUMBER_TABLE

Line 688: , p0_a1 in out nocopy JTF_NUMBER_TABLE

684: );
685: end;
686:
687: procedure update_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
688: , p0_a1 in out nocopy JTF_NUMBER_TABLE
689: , p0_a2 in out nocopy JTF_NUMBER_TABLE
690: , p0_a3 in out nocopy JTF_DATE_TABLE
691: , p0_a4 in out nocopy JTF_NUMBER_TABLE
692: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 689: , p0_a2 in out nocopy JTF_NUMBER_TABLE

685: end;
686:
687: procedure update_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
688: , p0_a1 in out nocopy JTF_NUMBER_TABLE
689: , p0_a2 in out nocopy JTF_NUMBER_TABLE
690: , p0_a3 in out nocopy JTF_DATE_TABLE
691: , p0_a4 in out nocopy JTF_NUMBER_TABLE
692: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
693: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 691: , p0_a4 in out nocopy JTF_NUMBER_TABLE

687: procedure update_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
688: , p0_a1 in out nocopy JTF_NUMBER_TABLE
689: , p0_a2 in out nocopy JTF_NUMBER_TABLE
690: , p0_a3 in out nocopy JTF_DATE_TABLE
691: , p0_a4 in out nocopy JTF_NUMBER_TABLE
692: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
693: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
694: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
695: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000

Line 703: , p0_a16 in out nocopy JTF_NUMBER_TABLE

699: , p0_a12 in out nocopy JTF_DATE_TABLE
700: , p0_a13 in out nocopy JTF_DATE_TABLE
701: , p0_a14 in out nocopy JTF_DATE_TABLE
702: , p0_a15 in out nocopy JTF_DATE_TABLE
703: , p0_a16 in out nocopy JTF_NUMBER_TABLE
704: , p0_a17 in out nocopy JTF_NUMBER_TABLE
705: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p0_a19 in out nocopy JTF_DATE_TABLE
707: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100

Line 704: , p0_a17 in out nocopy JTF_NUMBER_TABLE

700: , p0_a13 in out nocopy JTF_DATE_TABLE
701: , p0_a14 in out nocopy JTF_DATE_TABLE
702: , p0_a15 in out nocopy JTF_DATE_TABLE
703: , p0_a16 in out nocopy JTF_NUMBER_TABLE
704: , p0_a17 in out nocopy JTF_NUMBER_TABLE
705: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p0_a19 in out nocopy JTF_DATE_TABLE
707: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300

Line 709: , p0_a22 in out nocopy JTF_NUMBER_TABLE

705: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
706: , p0_a19 in out nocopy JTF_DATE_TABLE
707: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
709: , p0_a22 in out nocopy JTF_NUMBER_TABLE
710: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
711: , p0_a24 in out nocopy JTF_NUMBER_TABLE
712: , p0_a25 in out nocopy JTF_NUMBER_TABLE
713: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300

Line 711: , p0_a24 in out nocopy JTF_NUMBER_TABLE

707: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
708: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
709: , p0_a22 in out nocopy JTF_NUMBER_TABLE
710: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
711: , p0_a24 in out nocopy JTF_NUMBER_TABLE
712: , p0_a25 in out nocopy JTF_NUMBER_TABLE
713: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300
714: , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
715: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100

Line 712: , p0_a25 in out nocopy JTF_NUMBER_TABLE

708: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
709: , p0_a22 in out nocopy JTF_NUMBER_TABLE
710: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
711: , p0_a24 in out nocopy JTF_NUMBER_TABLE
712: , p0_a25 in out nocopy JTF_NUMBER_TABLE
713: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300
714: , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
715: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p0_a29 in out nocopy JTF_NUMBER_TABLE

Line 716: , p0_a29 in out nocopy JTF_NUMBER_TABLE

712: , p0_a25 in out nocopy JTF_NUMBER_TABLE
713: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300
714: , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
715: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
716: , p0_a29 in out nocopy JTF_NUMBER_TABLE
717: , p0_a30 in out nocopy JTF_DATE_TABLE
718: , p0_a31 in out nocopy JTF_DATE_TABLE
719: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
720: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100

Line 726: , p0_a39 in out nocopy JTF_NUMBER_TABLE

722: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
723: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
724: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
725: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
726: , p0_a39 in out nocopy JTF_NUMBER_TABLE
727: , p0_a40 in out nocopy JTF_NUMBER_TABLE
728: , p1_a0 JTF_NUMBER_TABLE
729: , p1_a1 JTF_DATE_TABLE
730: )

Line 727: , p0_a40 in out nocopy JTF_NUMBER_TABLE

723: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
724: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
725: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
726: , p0_a39 in out nocopy JTF_NUMBER_TABLE
727: , p0_a40 in out nocopy JTF_NUMBER_TABLE
728: , p1_a0 JTF_NUMBER_TABLE
729: , p1_a1 JTF_DATE_TABLE
730: )
731:

Line 728: , p1_a0 JTF_NUMBER_TABLE

724: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
725: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
726: , p0_a39 in out nocopy JTF_NUMBER_TABLE
727: , p0_a40 in out nocopy JTF_NUMBER_TABLE
728: , p1_a0 JTF_NUMBER_TABLE
729: , p1_a1 JTF_DATE_TABLE
730: )
731:
732: as

Line 836: procedure delete_data(p0_a0 in out nocopy JTF_NUMBER_TABLE

832: );
833:
834: end;
835:
836: procedure delete_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
837: , p0_a1 in out nocopy JTF_NUMBER_TABLE
838: , p0_a2 in out nocopy JTF_NUMBER_TABLE
839: , p0_a3 in out nocopy JTF_DATE_TABLE
840: , p0_a4 in out nocopy JTF_NUMBER_TABLE

Line 837: , p0_a1 in out nocopy JTF_NUMBER_TABLE

833:
834: end;
835:
836: procedure delete_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
837: , p0_a1 in out nocopy JTF_NUMBER_TABLE
838: , p0_a2 in out nocopy JTF_NUMBER_TABLE
839: , p0_a3 in out nocopy JTF_DATE_TABLE
840: , p0_a4 in out nocopy JTF_NUMBER_TABLE
841: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 838: , p0_a2 in out nocopy JTF_NUMBER_TABLE

834: end;
835:
836: procedure delete_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
837: , p0_a1 in out nocopy JTF_NUMBER_TABLE
838: , p0_a2 in out nocopy JTF_NUMBER_TABLE
839: , p0_a3 in out nocopy JTF_DATE_TABLE
840: , p0_a4 in out nocopy JTF_NUMBER_TABLE
841: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
842: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 840: , p0_a4 in out nocopy JTF_NUMBER_TABLE

836: procedure delete_data(p0_a0 in out nocopy JTF_NUMBER_TABLE
837: , p0_a1 in out nocopy JTF_NUMBER_TABLE
838: , p0_a2 in out nocopy JTF_NUMBER_TABLE
839: , p0_a3 in out nocopy JTF_DATE_TABLE
840: , p0_a4 in out nocopy JTF_NUMBER_TABLE
841: , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
842: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
843: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
844: , p0_a8 in out nocopy JTF_VARCHAR2_TABLE_4000

Line 852: , p0_a16 in out nocopy JTF_NUMBER_TABLE

848: , p0_a12 in out nocopy JTF_DATE_TABLE
849: , p0_a13 in out nocopy JTF_DATE_TABLE
850: , p0_a14 in out nocopy JTF_DATE_TABLE
851: , p0_a15 in out nocopy JTF_DATE_TABLE
852: , p0_a16 in out nocopy JTF_NUMBER_TABLE
853: , p0_a17 in out nocopy JTF_NUMBER_TABLE
854: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
855: , p0_a19 in out nocopy JTF_DATE_TABLE
856: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100

Line 853: , p0_a17 in out nocopy JTF_NUMBER_TABLE

849: , p0_a13 in out nocopy JTF_DATE_TABLE
850: , p0_a14 in out nocopy JTF_DATE_TABLE
851: , p0_a15 in out nocopy JTF_DATE_TABLE
852: , p0_a16 in out nocopy JTF_NUMBER_TABLE
853: , p0_a17 in out nocopy JTF_NUMBER_TABLE
854: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
855: , p0_a19 in out nocopy JTF_DATE_TABLE
856: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
857: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300

Line 858: , p0_a22 in out nocopy JTF_NUMBER_TABLE

854: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
855: , p0_a19 in out nocopy JTF_DATE_TABLE
856: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
857: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
858: , p0_a22 in out nocopy JTF_NUMBER_TABLE
859: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
860: , p0_a24 in out nocopy JTF_NUMBER_TABLE
861: , p0_a25 in out nocopy JTF_NUMBER_TABLE
862: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300

Line 860: , p0_a24 in out nocopy JTF_NUMBER_TABLE

856: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
857: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
858: , p0_a22 in out nocopy JTF_NUMBER_TABLE
859: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
860: , p0_a24 in out nocopy JTF_NUMBER_TABLE
861: , p0_a25 in out nocopy JTF_NUMBER_TABLE
862: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300
863: , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
864: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100

Line 861: , p0_a25 in out nocopy JTF_NUMBER_TABLE

857: , p0_a21 in out nocopy JTF_VARCHAR2_TABLE_300
858: , p0_a22 in out nocopy JTF_NUMBER_TABLE
859: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_2000
860: , p0_a24 in out nocopy JTF_NUMBER_TABLE
861: , p0_a25 in out nocopy JTF_NUMBER_TABLE
862: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300
863: , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
864: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
865: , p0_a29 in out nocopy JTF_NUMBER_TABLE

Line 865: , p0_a29 in out nocopy JTF_NUMBER_TABLE

861: , p0_a25 in out nocopy JTF_NUMBER_TABLE
862: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_300
863: , p0_a27 in out nocopy JTF_VARCHAR2_TABLE_2000
864: , p0_a28 in out nocopy JTF_VARCHAR2_TABLE_100
865: , p0_a29 in out nocopy JTF_NUMBER_TABLE
866: , p0_a30 in out nocopy JTF_DATE_TABLE
867: , p0_a31 in out nocopy JTF_DATE_TABLE
868: , p0_a32 in out nocopy JTF_VARCHAR2_TABLE_100
869: , p0_a33 in out nocopy JTF_VARCHAR2_TABLE_100

Line 875: , p0_a39 in out nocopy JTF_NUMBER_TABLE

871: , p0_a35 in out nocopy JTF_VARCHAR2_TABLE_100
872: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
873: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
874: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
875: , p0_a39 in out nocopy JTF_NUMBER_TABLE
876: , p0_a40 in out nocopy JTF_NUMBER_TABLE
877: )
878:
879: as

Line 876: , p0_a40 in out nocopy JTF_NUMBER_TABLE

872: , p0_a36 in out nocopy JTF_VARCHAR2_TABLE_100
873: , p0_a37 in out nocopy JTF_VARCHAR2_TABLE_100
874: , p0_a38 in out nocopy JTF_VARCHAR2_TABLE_100
875: , p0_a39 in out nocopy JTF_NUMBER_TABLE
876: , p0_a40 in out nocopy JTF_NUMBER_TABLE
877: )
878:
879: as
880: ddp_tasks jta_sync_task.task_tbl;