71: end if;
72: end if;
73: end rosetta_table_copy_out_p1;
74:
75: procedure rosetta_table_copy_in_p4(t out nocopy csi_asset_pvt.asset_id_tbl, a0 JTF_NUMBER_TABLE
76: , a1 JTF_VARCHAR2_TABLE_100
77: , a2 JTF_VARCHAR2_TABLE_100
78: ) as
79: ddindx binary_integer; indx binary_integer;
94: end loop;
95: end if;
96: end if;
97: end rosetta_table_copy_in_p4;
98: procedure rosetta_table_copy_out_p4(t csi_asset_pvt.asset_id_tbl, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: ) as
102: ddindx binary_integer; indx binary_integer;
101: ) as
102: ddindx binary_integer; indx binary_integer;
103: begin
104: if t is null or t.count = 0 then
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_VARCHAR2_TABLE_100();
107: a2 := JTF_VARCHAR2_TABLE_100();
108: else
109: a0 := JTF_NUMBER_TABLE();
105: a0 := JTF_NUMBER_TABLE();
106: a1 := JTF_VARCHAR2_TABLE_100();
107: a2 := JTF_VARCHAR2_TABLE_100();
108: else
109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_VARCHAR2_TABLE_100();
111: a2 := JTF_VARCHAR2_TABLE_100();
112: if t.count > 0 then
113: a0.extend(t.count);
128: end if;
129: end if;
130: end rosetta_table_copy_out_p4;
131:
132: procedure rosetta_table_copy_in_p6(t out nocopy csi_asset_pvt.asset_loc_tbl, a0 JTF_NUMBER_TABLE
133: , a1 JTF_VARCHAR2_TABLE_100
134: ) as
135: ddindx binary_integer; indx binary_integer;
136: begin
149: end loop;
150: end if;
151: end if;
152: end rosetta_table_copy_in_p6;
153: procedure rosetta_table_copy_out_p6(t csi_asset_pvt.asset_loc_tbl, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_VARCHAR2_TABLE_100
155: ) as
156: ddindx binary_integer; indx binary_integer;
157: begin
155: ) as
156: ddindx binary_integer; indx binary_integer;
157: begin
158: if t is null or t.count = 0 then
159: a0 := JTF_NUMBER_TABLE();
160: a1 := JTF_VARCHAR2_TABLE_100();
161: else
162: a0 := JTF_NUMBER_TABLE();
163: a1 := JTF_VARCHAR2_TABLE_100();
158: if t is null or t.count = 0 then
159: a0 := JTF_NUMBER_TABLE();
160: a1 := JTF_VARCHAR2_TABLE_100();
161: else
162: a0 := JTF_NUMBER_TABLE();
163: a1 := JTF_VARCHAR2_TABLE_100();
164: if t.count > 0 then
165: a0.extend(t.count);
166: a1.extend(t.count);
178: end if;
179: end if;
180: end rosetta_table_copy_out_p6;
181:
182: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
183: , a1 JTF_NUMBER_TABLE
184: , a2 JTF_NUMBER_TABLE
185: , a3 JTF_NUMBER_TABLE
186: , a4 JTF_NUMBER_TABLE
179: end if;
180: end rosetta_table_copy_out_p6;
181:
182: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
183: , a1 JTF_NUMBER_TABLE
184: , a2 JTF_NUMBER_TABLE
185: , a3 JTF_NUMBER_TABLE
186: , a4 JTF_NUMBER_TABLE
187: ) as
180: end rosetta_table_copy_out_p6;
181:
182: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
183: , a1 JTF_NUMBER_TABLE
184: , a2 JTF_NUMBER_TABLE
185: , a3 JTF_NUMBER_TABLE
186: , a4 JTF_NUMBER_TABLE
187: ) as
188: ddindx binary_integer; indx binary_integer;
181:
182: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
183: , a1 JTF_NUMBER_TABLE
184: , a2 JTF_NUMBER_TABLE
185: , a3 JTF_NUMBER_TABLE
186: , a4 JTF_NUMBER_TABLE
187: ) as
188: ddindx binary_integer; indx binary_integer;
189: begin
182: procedure rosetta_table_copy_in_p8(t out nocopy csi_asset_pvt.instance_asset_sync_tbl, a0 JTF_NUMBER_TABLE
183: , a1 JTF_NUMBER_TABLE
184: , a2 JTF_NUMBER_TABLE
185: , a3 JTF_NUMBER_TABLE
186: , a4 JTF_NUMBER_TABLE
187: ) as
188: ddindx binary_integer; indx binary_integer;
189: begin
190: if a0 is not null and a0.count > 0 then
205: end loop;
206: end if;
207: end if;
208: end rosetta_table_copy_in_p8;
209: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
210: , a1 out nocopy JTF_NUMBER_TABLE
211: , a2 out nocopy JTF_NUMBER_TABLE
212: , a3 out nocopy JTF_NUMBER_TABLE
213: , a4 out nocopy JTF_NUMBER_TABLE
206: end if;
207: end if;
208: end rosetta_table_copy_in_p8;
209: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
210: , a1 out nocopy JTF_NUMBER_TABLE
211: , a2 out nocopy JTF_NUMBER_TABLE
212: , a3 out nocopy JTF_NUMBER_TABLE
213: , a4 out nocopy JTF_NUMBER_TABLE
214: ) as
207: end if;
208: end rosetta_table_copy_in_p8;
209: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
210: , a1 out nocopy JTF_NUMBER_TABLE
211: , a2 out nocopy JTF_NUMBER_TABLE
212: , a3 out nocopy JTF_NUMBER_TABLE
213: , a4 out nocopy JTF_NUMBER_TABLE
214: ) as
215: ddindx binary_integer; indx binary_integer;
208: end rosetta_table_copy_in_p8;
209: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
210: , a1 out nocopy JTF_NUMBER_TABLE
211: , a2 out nocopy JTF_NUMBER_TABLE
212: , a3 out nocopy JTF_NUMBER_TABLE
213: , a4 out nocopy JTF_NUMBER_TABLE
214: ) as
215: ddindx binary_integer; indx binary_integer;
216: begin
209: procedure rosetta_table_copy_out_p8(t csi_asset_pvt.instance_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
210: , a1 out nocopy JTF_NUMBER_TABLE
211: , a2 out nocopy JTF_NUMBER_TABLE
212: , a3 out nocopy JTF_NUMBER_TABLE
213: , a4 out nocopy JTF_NUMBER_TABLE
214: ) as
215: ddindx binary_integer; indx binary_integer;
216: begin
217: if t is null or t.count = 0 then
214: ) as
215: ddindx binary_integer; indx binary_integer;
216: begin
217: if t is null or t.count = 0 then
218: a0 := JTF_NUMBER_TABLE();
219: a1 := JTF_NUMBER_TABLE();
220: a2 := JTF_NUMBER_TABLE();
221: a3 := JTF_NUMBER_TABLE();
222: a4 := JTF_NUMBER_TABLE();
215: ddindx binary_integer; indx binary_integer;
216: begin
217: if t is null or t.count = 0 then
218: a0 := JTF_NUMBER_TABLE();
219: a1 := JTF_NUMBER_TABLE();
220: a2 := JTF_NUMBER_TABLE();
221: a3 := JTF_NUMBER_TABLE();
222: a4 := JTF_NUMBER_TABLE();
223: else
216: begin
217: if t is null or t.count = 0 then
218: a0 := JTF_NUMBER_TABLE();
219: a1 := JTF_NUMBER_TABLE();
220: a2 := JTF_NUMBER_TABLE();
221: a3 := JTF_NUMBER_TABLE();
222: a4 := JTF_NUMBER_TABLE();
223: else
224: a0 := JTF_NUMBER_TABLE();
217: if t is null or t.count = 0 then
218: a0 := JTF_NUMBER_TABLE();
219: a1 := JTF_NUMBER_TABLE();
220: a2 := JTF_NUMBER_TABLE();
221: a3 := JTF_NUMBER_TABLE();
222: a4 := JTF_NUMBER_TABLE();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
218: a0 := JTF_NUMBER_TABLE();
219: a1 := JTF_NUMBER_TABLE();
220: a2 := JTF_NUMBER_TABLE();
221: a3 := JTF_NUMBER_TABLE();
222: a4 := JTF_NUMBER_TABLE();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_NUMBER_TABLE();
220: a2 := JTF_NUMBER_TABLE();
221: a3 := JTF_NUMBER_TABLE();
222: a4 := JTF_NUMBER_TABLE();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_NUMBER_TABLE();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_NUMBER_TABLE();
221: a3 := JTF_NUMBER_TABLE();
222: a4 := JTF_NUMBER_TABLE();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_NUMBER_TABLE();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_NUMBER_TABLE();
229: if t.count > 0 then
222: a4 := JTF_NUMBER_TABLE();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_NUMBER_TABLE();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_NUMBER_TABLE();
229: if t.count > 0 then
230: a0.extend(t.count);
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_NUMBER_TABLE();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_NUMBER_TABLE();
229: if t.count > 0 then
230: a0.extend(t.count);
231: a1.extend(t.count);
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_NUMBER_TABLE();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_NUMBER_TABLE();
229: if t.count > 0 then
230: a0.extend(t.count);
231: a1.extend(t.count);
232: a2.extend(t.count);
249: end if;
250: end if;
251: end rosetta_table_copy_out_p8;
252:
253: procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE
254: , a1 JTF_NUMBER_TABLE
255: , a2 JTF_NUMBER_TABLE
256: , a3 JTF_NUMBER_TABLE
257: ) as
250: end if;
251: end rosetta_table_copy_out_p8;
252:
253: procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE
254: , a1 JTF_NUMBER_TABLE
255: , a2 JTF_NUMBER_TABLE
256: , a3 JTF_NUMBER_TABLE
257: ) as
258: ddindx binary_integer; indx binary_integer;
251: end rosetta_table_copy_out_p8;
252:
253: procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE
254: , a1 JTF_NUMBER_TABLE
255: , a2 JTF_NUMBER_TABLE
256: , a3 JTF_NUMBER_TABLE
257: ) as
258: ddindx binary_integer; indx binary_integer;
259: begin
252:
253: procedure rosetta_table_copy_in_p10(t out nocopy csi_asset_pvt.fa_asset_sync_tbl, a0 JTF_NUMBER_TABLE
254: , a1 JTF_NUMBER_TABLE
255: , a2 JTF_NUMBER_TABLE
256: , a3 JTF_NUMBER_TABLE
257: ) as
258: ddindx binary_integer; indx binary_integer;
259: begin
260: if a0 is not null and a0.count > 0 then
274: end loop;
275: end if;
276: end if;
277: end rosetta_table_copy_in_p10;
278: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
279: , a1 out nocopy JTF_NUMBER_TABLE
280: , a2 out nocopy JTF_NUMBER_TABLE
281: , a3 out nocopy JTF_NUMBER_TABLE
282: ) as
275: end if;
276: end if;
277: end rosetta_table_copy_in_p10;
278: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
279: , a1 out nocopy JTF_NUMBER_TABLE
280: , a2 out nocopy JTF_NUMBER_TABLE
281: , a3 out nocopy JTF_NUMBER_TABLE
282: ) as
283: ddindx binary_integer; indx binary_integer;
276: end if;
277: end rosetta_table_copy_in_p10;
278: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
279: , a1 out nocopy JTF_NUMBER_TABLE
280: , a2 out nocopy JTF_NUMBER_TABLE
281: , a3 out nocopy JTF_NUMBER_TABLE
282: ) as
283: ddindx binary_integer; indx binary_integer;
284: begin
277: end rosetta_table_copy_in_p10;
278: procedure rosetta_table_copy_out_p10(t csi_asset_pvt.fa_asset_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
279: , a1 out nocopy JTF_NUMBER_TABLE
280: , a2 out nocopy JTF_NUMBER_TABLE
281: , a3 out nocopy JTF_NUMBER_TABLE
282: ) as
283: ddindx binary_integer; indx binary_integer;
284: begin
285: if t is null or t.count = 0 then
282: ) as
283: ddindx binary_integer; indx binary_integer;
284: begin
285: if t is null or t.count = 0 then
286: a0 := JTF_NUMBER_TABLE();
287: a1 := JTF_NUMBER_TABLE();
288: a2 := JTF_NUMBER_TABLE();
289: a3 := JTF_NUMBER_TABLE();
290: else
283: ddindx binary_integer; indx binary_integer;
284: begin
285: if t is null or t.count = 0 then
286: a0 := JTF_NUMBER_TABLE();
287: a1 := JTF_NUMBER_TABLE();
288: a2 := JTF_NUMBER_TABLE();
289: a3 := JTF_NUMBER_TABLE();
290: else
291: a0 := JTF_NUMBER_TABLE();
284: begin
285: if t is null or t.count = 0 then
286: a0 := JTF_NUMBER_TABLE();
287: a1 := JTF_NUMBER_TABLE();
288: a2 := JTF_NUMBER_TABLE();
289: a3 := JTF_NUMBER_TABLE();
290: else
291: a0 := JTF_NUMBER_TABLE();
292: a1 := JTF_NUMBER_TABLE();
285: if t is null or t.count = 0 then
286: a0 := JTF_NUMBER_TABLE();
287: a1 := JTF_NUMBER_TABLE();
288: a2 := JTF_NUMBER_TABLE();
289: a3 := JTF_NUMBER_TABLE();
290: else
291: a0 := JTF_NUMBER_TABLE();
292: a1 := JTF_NUMBER_TABLE();
293: a2 := JTF_NUMBER_TABLE();
287: a1 := JTF_NUMBER_TABLE();
288: a2 := JTF_NUMBER_TABLE();
289: a3 := JTF_NUMBER_TABLE();
290: else
291: a0 := JTF_NUMBER_TABLE();
292: a1 := JTF_NUMBER_TABLE();
293: a2 := JTF_NUMBER_TABLE();
294: a3 := JTF_NUMBER_TABLE();
295: if t.count > 0 then
288: a2 := JTF_NUMBER_TABLE();
289: a3 := JTF_NUMBER_TABLE();
290: else
291: a0 := JTF_NUMBER_TABLE();
292: a1 := JTF_NUMBER_TABLE();
293: a2 := JTF_NUMBER_TABLE();
294: a3 := JTF_NUMBER_TABLE();
295: if t.count > 0 then
296: a0.extend(t.count);
289: a3 := JTF_NUMBER_TABLE();
290: else
291: a0 := JTF_NUMBER_TABLE();
292: a1 := JTF_NUMBER_TABLE();
293: a2 := JTF_NUMBER_TABLE();
294: a3 := JTF_NUMBER_TABLE();
295: if t.count > 0 then
296: a0.extend(t.count);
297: a1.extend(t.count);
290: else
291: a0 := JTF_NUMBER_TABLE();
292: a1 := JTF_NUMBER_TABLE();
293: a2 := JTF_NUMBER_TABLE();
294: a3 := JTF_NUMBER_TABLE();
295: if t.count > 0 then
296: a0.extend(t.count);
297: a1.extend(t.count);
298: a2.extend(t.count);
313: end if;
314: end if;
315: end rosetta_table_copy_out_p10;
316:
317: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE
318: , a1 JTF_NUMBER_TABLE
319: , a2 JTF_NUMBER_TABLE
320: , a3 JTF_NUMBER_TABLE
321: , a4 JTF_VARCHAR2_TABLE_100
314: end if;
315: end rosetta_table_copy_out_p10;
316:
317: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE
318: , a1 JTF_NUMBER_TABLE
319: , a2 JTF_NUMBER_TABLE
320: , a3 JTF_NUMBER_TABLE
321: , a4 JTF_VARCHAR2_TABLE_100
322: , a5 JTF_NUMBER_TABLE
315: end rosetta_table_copy_out_p10;
316:
317: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE
318: , a1 JTF_NUMBER_TABLE
319: , a2 JTF_NUMBER_TABLE
320: , a3 JTF_NUMBER_TABLE
321: , a4 JTF_VARCHAR2_TABLE_100
322: , a5 JTF_NUMBER_TABLE
323: , a6 JTF_NUMBER_TABLE
316:
317: procedure rosetta_table_copy_in_p12(t out nocopy csi_asset_pvt.instance_sync_tbl, a0 JTF_NUMBER_TABLE
318: , a1 JTF_NUMBER_TABLE
319: , a2 JTF_NUMBER_TABLE
320: , a3 JTF_NUMBER_TABLE
321: , a4 JTF_VARCHAR2_TABLE_100
322: , a5 JTF_NUMBER_TABLE
323: , a6 JTF_NUMBER_TABLE
324: , a7 JTF_VARCHAR2_TABLE_100
318: , a1 JTF_NUMBER_TABLE
319: , a2 JTF_NUMBER_TABLE
320: , a3 JTF_NUMBER_TABLE
321: , a4 JTF_VARCHAR2_TABLE_100
322: , a5 JTF_NUMBER_TABLE
323: , a6 JTF_NUMBER_TABLE
324: , a7 JTF_VARCHAR2_TABLE_100
325: ) as
326: ddindx binary_integer; indx binary_integer;
319: , a2 JTF_NUMBER_TABLE
320: , a3 JTF_NUMBER_TABLE
321: , a4 JTF_VARCHAR2_TABLE_100
322: , a5 JTF_NUMBER_TABLE
323: , a6 JTF_NUMBER_TABLE
324: , a7 JTF_VARCHAR2_TABLE_100
325: ) as
326: ddindx binary_integer; indx binary_integer;
327: begin
346: end loop;
347: end if;
348: end if;
349: end rosetta_table_copy_in_p12;
350: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
351: , a1 out nocopy JTF_NUMBER_TABLE
352: , a2 out nocopy JTF_NUMBER_TABLE
353: , a3 out nocopy JTF_NUMBER_TABLE
354: , a4 out nocopy JTF_VARCHAR2_TABLE_100
347: end if;
348: end if;
349: end rosetta_table_copy_in_p12;
350: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
351: , a1 out nocopy JTF_NUMBER_TABLE
352: , a2 out nocopy JTF_NUMBER_TABLE
353: , a3 out nocopy JTF_NUMBER_TABLE
354: , a4 out nocopy JTF_VARCHAR2_TABLE_100
355: , a5 out nocopy JTF_NUMBER_TABLE
348: end if;
349: end rosetta_table_copy_in_p12;
350: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
351: , a1 out nocopy JTF_NUMBER_TABLE
352: , a2 out nocopy JTF_NUMBER_TABLE
353: , a3 out nocopy JTF_NUMBER_TABLE
354: , a4 out nocopy JTF_VARCHAR2_TABLE_100
355: , a5 out nocopy JTF_NUMBER_TABLE
356: , a6 out nocopy JTF_NUMBER_TABLE
349: end rosetta_table_copy_in_p12;
350: procedure rosetta_table_copy_out_p12(t csi_asset_pvt.instance_sync_tbl, a0 out nocopy JTF_NUMBER_TABLE
351: , a1 out nocopy JTF_NUMBER_TABLE
352: , a2 out nocopy JTF_NUMBER_TABLE
353: , a3 out nocopy JTF_NUMBER_TABLE
354: , a4 out nocopy JTF_VARCHAR2_TABLE_100
355: , a5 out nocopy JTF_NUMBER_TABLE
356: , a6 out nocopy JTF_NUMBER_TABLE
357: , a7 out nocopy JTF_VARCHAR2_TABLE_100
351: , a1 out nocopy JTF_NUMBER_TABLE
352: , a2 out nocopy JTF_NUMBER_TABLE
353: , a3 out nocopy JTF_NUMBER_TABLE
354: , a4 out nocopy JTF_VARCHAR2_TABLE_100
355: , a5 out nocopy JTF_NUMBER_TABLE
356: , a6 out nocopy JTF_NUMBER_TABLE
357: , a7 out nocopy JTF_VARCHAR2_TABLE_100
358: ) as
359: ddindx binary_integer; indx binary_integer;
352: , a2 out nocopy JTF_NUMBER_TABLE
353: , a3 out nocopy JTF_NUMBER_TABLE
354: , a4 out nocopy JTF_VARCHAR2_TABLE_100
355: , a5 out nocopy JTF_NUMBER_TABLE
356: , a6 out nocopy JTF_NUMBER_TABLE
357: , a7 out nocopy JTF_VARCHAR2_TABLE_100
358: ) as
359: ddindx binary_integer; indx binary_integer;
360: begin
358: ) as
359: ddindx binary_integer; indx binary_integer;
360: begin
361: if t is null or t.count = 0 then
362: a0 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_NUMBER_TABLE();
366: a4 := JTF_VARCHAR2_TABLE_100();
359: ddindx binary_integer; indx binary_integer;
360: begin
361: if t is null or t.count = 0 then
362: a0 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_NUMBER_TABLE();
366: a4 := JTF_VARCHAR2_TABLE_100();
367: a5 := JTF_NUMBER_TABLE();
360: begin
361: if t is null or t.count = 0 then
362: a0 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_NUMBER_TABLE();
366: a4 := JTF_VARCHAR2_TABLE_100();
367: a5 := JTF_NUMBER_TABLE();
368: a6 := JTF_NUMBER_TABLE();
361: if t is null or t.count = 0 then
362: a0 := JTF_NUMBER_TABLE();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_NUMBER_TABLE();
366: a4 := JTF_VARCHAR2_TABLE_100();
367: a5 := JTF_NUMBER_TABLE();
368: a6 := JTF_NUMBER_TABLE();
369: a7 := JTF_VARCHAR2_TABLE_100();
363: a1 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_NUMBER_TABLE();
366: a4 := JTF_VARCHAR2_TABLE_100();
367: a5 := JTF_NUMBER_TABLE();
368: a6 := JTF_NUMBER_TABLE();
369: a7 := JTF_VARCHAR2_TABLE_100();
370: else
371: a0 := JTF_NUMBER_TABLE();
364: a2 := JTF_NUMBER_TABLE();
365: a3 := JTF_NUMBER_TABLE();
366: a4 := JTF_VARCHAR2_TABLE_100();
367: a5 := JTF_NUMBER_TABLE();
368: a6 := JTF_NUMBER_TABLE();
369: a7 := JTF_VARCHAR2_TABLE_100();
370: else
371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_NUMBER_TABLE();
367: a5 := JTF_NUMBER_TABLE();
368: a6 := JTF_NUMBER_TABLE();
369: a7 := JTF_VARCHAR2_TABLE_100();
370: else
371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_NUMBER_TABLE();
373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_NUMBER_TABLE();
375: a4 := JTF_VARCHAR2_TABLE_100();
368: a6 := JTF_NUMBER_TABLE();
369: a7 := JTF_VARCHAR2_TABLE_100();
370: else
371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_NUMBER_TABLE();
373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_NUMBER_TABLE();
375: a4 := JTF_VARCHAR2_TABLE_100();
376: a5 := JTF_NUMBER_TABLE();
369: a7 := JTF_VARCHAR2_TABLE_100();
370: else
371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_NUMBER_TABLE();
373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_NUMBER_TABLE();
375: a4 := JTF_VARCHAR2_TABLE_100();
376: a5 := JTF_NUMBER_TABLE();
377: a6 := JTF_NUMBER_TABLE();
370: else
371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_NUMBER_TABLE();
373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_NUMBER_TABLE();
375: a4 := JTF_VARCHAR2_TABLE_100();
376: a5 := JTF_NUMBER_TABLE();
377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_VARCHAR2_TABLE_100();
372: a1 := JTF_NUMBER_TABLE();
373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_NUMBER_TABLE();
375: a4 := JTF_VARCHAR2_TABLE_100();
376: a5 := JTF_NUMBER_TABLE();
377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_VARCHAR2_TABLE_100();
379: if t.count > 0 then
380: a0.extend(t.count);
373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_NUMBER_TABLE();
375: a4 := JTF_VARCHAR2_TABLE_100();
376: a5 := JTF_NUMBER_TABLE();
377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_VARCHAR2_TABLE_100();
379: if t.count > 0 then
380: a0.extend(t.count);
381: a1.extend(t.count);
512:
513: x_nearest_full_dump := ddx_nearest_full_dump;
514: end;
515:
516: procedure construct_asset_from_hist(p0_a0 in out nocopy JTF_NUMBER_TABLE
517: , p0_a1 in out nocopy JTF_NUMBER_TABLE
518: , p0_a2 in out nocopy JTF_NUMBER_TABLE
519: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p0_a4 in out nocopy JTF_NUMBER_TABLE
513: x_nearest_full_dump := ddx_nearest_full_dump;
514: end;
515:
516: procedure construct_asset_from_hist(p0_a0 in out nocopy JTF_NUMBER_TABLE
517: , p0_a1 in out nocopy JTF_NUMBER_TABLE
518: , p0_a2 in out nocopy JTF_NUMBER_TABLE
519: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p0_a4 in out nocopy JTF_NUMBER_TABLE
521: , p0_a5 in out nocopy JTF_NUMBER_TABLE
514: end;
515:
516: procedure construct_asset_from_hist(p0_a0 in out nocopy JTF_NUMBER_TABLE
517: , p0_a1 in out nocopy JTF_NUMBER_TABLE
518: , p0_a2 in out nocopy JTF_NUMBER_TABLE
519: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p0_a4 in out nocopy JTF_NUMBER_TABLE
521: , p0_a5 in out nocopy JTF_NUMBER_TABLE
522: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
516: procedure construct_asset_from_hist(p0_a0 in out nocopy JTF_NUMBER_TABLE
517: , p0_a1 in out nocopy JTF_NUMBER_TABLE
518: , p0_a2 in out nocopy JTF_NUMBER_TABLE
519: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p0_a4 in out nocopy JTF_NUMBER_TABLE
521: , p0_a5 in out nocopy JTF_NUMBER_TABLE
522: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p0_a7 in out nocopy JTF_DATE_TABLE
524: , p0_a8 in out nocopy JTF_DATE_TABLE
517: , p0_a1 in out nocopy JTF_NUMBER_TABLE
518: , p0_a2 in out nocopy JTF_NUMBER_TABLE
519: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
520: , p0_a4 in out nocopy JTF_NUMBER_TABLE
521: , p0_a5 in out nocopy JTF_NUMBER_TABLE
522: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p0_a7 in out nocopy JTF_DATE_TABLE
524: , p0_a8 in out nocopy JTF_DATE_TABLE
525: , p0_a9 in out nocopy JTF_NUMBER_TABLE
521: , p0_a5 in out nocopy JTF_NUMBER_TABLE
522: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
523: , p0_a7 in out nocopy JTF_DATE_TABLE
524: , p0_a8 in out nocopy JTF_DATE_TABLE
525: , p0_a9 in out nocopy JTF_NUMBER_TABLE
526: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
527: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
528: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
529: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
537: , p0_a21 in out nocopy JTF_DATE_TABLE
538: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
539: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
540: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100
541: , p0_a25 in out nocopy JTF_NUMBER_TABLE
542: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100
543: , p_time_stamp date
544: )
545:
722: -- copy data back from the local variables to OUT or IN-OUT args, if any
723:
724: end;
725:
726: procedure resolve_id_columns(p0_a0 in out nocopy JTF_NUMBER_TABLE
727: , p0_a1 in out nocopy JTF_NUMBER_TABLE
728: , p0_a2 in out nocopy JTF_NUMBER_TABLE
729: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p0_a4 in out nocopy JTF_NUMBER_TABLE
723:
724: end;
725:
726: procedure resolve_id_columns(p0_a0 in out nocopy JTF_NUMBER_TABLE
727: , p0_a1 in out nocopy JTF_NUMBER_TABLE
728: , p0_a2 in out nocopy JTF_NUMBER_TABLE
729: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p0_a4 in out nocopy JTF_NUMBER_TABLE
731: , p0_a5 in out nocopy JTF_NUMBER_TABLE
724: end;
725:
726: procedure resolve_id_columns(p0_a0 in out nocopy JTF_NUMBER_TABLE
727: , p0_a1 in out nocopy JTF_NUMBER_TABLE
728: , p0_a2 in out nocopy JTF_NUMBER_TABLE
729: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p0_a4 in out nocopy JTF_NUMBER_TABLE
731: , p0_a5 in out nocopy JTF_NUMBER_TABLE
732: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
726: procedure resolve_id_columns(p0_a0 in out nocopy JTF_NUMBER_TABLE
727: , p0_a1 in out nocopy JTF_NUMBER_TABLE
728: , p0_a2 in out nocopy JTF_NUMBER_TABLE
729: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p0_a4 in out nocopy JTF_NUMBER_TABLE
731: , p0_a5 in out nocopy JTF_NUMBER_TABLE
732: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
733: , p0_a7 in out nocopy JTF_DATE_TABLE
734: , p0_a8 in out nocopy JTF_DATE_TABLE
727: , p0_a1 in out nocopy JTF_NUMBER_TABLE
728: , p0_a2 in out nocopy JTF_NUMBER_TABLE
729: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
730: , p0_a4 in out nocopy JTF_NUMBER_TABLE
731: , p0_a5 in out nocopy JTF_NUMBER_TABLE
732: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
733: , p0_a7 in out nocopy JTF_DATE_TABLE
734: , p0_a8 in out nocopy JTF_DATE_TABLE
735: , p0_a9 in out nocopy JTF_NUMBER_TABLE
731: , p0_a5 in out nocopy JTF_NUMBER_TABLE
732: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100
733: , p0_a7 in out nocopy JTF_DATE_TABLE
734: , p0_a8 in out nocopy JTF_DATE_TABLE
735: , p0_a9 in out nocopy JTF_NUMBER_TABLE
736: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
737: , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
738: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
739: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
747: , p0_a21 in out nocopy JTF_DATE_TABLE
748: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100
749: , p0_a23 in out nocopy JTF_VARCHAR2_TABLE_300
750: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100
751: , p0_a25 in out nocopy JTF_NUMBER_TABLE
752: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100
753: )
754:
755: as
859: , p_init_msg_list VARCHAR2
860: , p_validation_level NUMBER
861: , p_resolve_id_columns VARCHAR2
862: , p_time_stamp date
863: , p7_a0 out nocopy JTF_NUMBER_TABLE
864: , p7_a1 out nocopy JTF_NUMBER_TABLE
865: , p7_a2 out nocopy JTF_NUMBER_TABLE
866: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , p7_a4 out nocopy JTF_NUMBER_TABLE
860: , p_validation_level NUMBER
861: , p_resolve_id_columns VARCHAR2
862: , p_time_stamp date
863: , p7_a0 out nocopy JTF_NUMBER_TABLE
864: , p7_a1 out nocopy JTF_NUMBER_TABLE
865: , p7_a2 out nocopy JTF_NUMBER_TABLE
866: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , p7_a4 out nocopy JTF_NUMBER_TABLE
868: , p7_a5 out nocopy JTF_NUMBER_TABLE
861: , p_resolve_id_columns VARCHAR2
862: , p_time_stamp date
863: , p7_a0 out nocopy JTF_NUMBER_TABLE
864: , p7_a1 out nocopy JTF_NUMBER_TABLE
865: , p7_a2 out nocopy JTF_NUMBER_TABLE
866: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , p7_a4 out nocopy JTF_NUMBER_TABLE
868: , p7_a5 out nocopy JTF_NUMBER_TABLE
869: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
863: , p7_a0 out nocopy JTF_NUMBER_TABLE
864: , p7_a1 out nocopy JTF_NUMBER_TABLE
865: , p7_a2 out nocopy JTF_NUMBER_TABLE
866: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , p7_a4 out nocopy JTF_NUMBER_TABLE
868: , p7_a5 out nocopy JTF_NUMBER_TABLE
869: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
870: , p7_a7 out nocopy JTF_DATE_TABLE
871: , p7_a8 out nocopy JTF_DATE_TABLE
864: , p7_a1 out nocopy JTF_NUMBER_TABLE
865: , p7_a2 out nocopy JTF_NUMBER_TABLE
866: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
867: , p7_a4 out nocopy JTF_NUMBER_TABLE
868: , p7_a5 out nocopy JTF_NUMBER_TABLE
869: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
870: , p7_a7 out nocopy JTF_DATE_TABLE
871: , p7_a8 out nocopy JTF_DATE_TABLE
872: , p7_a9 out nocopy JTF_NUMBER_TABLE
868: , p7_a5 out nocopy JTF_NUMBER_TABLE
869: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
870: , p7_a7 out nocopy JTF_DATE_TABLE
871: , p7_a8 out nocopy JTF_DATE_TABLE
872: , p7_a9 out nocopy JTF_NUMBER_TABLE
873: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
874: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
875: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
876: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
884: , p7_a21 out nocopy JTF_DATE_TABLE
885: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
886: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_300
887: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
888: , p7_a25 out nocopy JTF_NUMBER_TABLE
889: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
890: , x_return_status out nocopy VARCHAR2
891: , x_msg_count out nocopy NUMBER
892: , x_msg_data out nocopy VARCHAR2
1047: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1048: , p10_a0 in out nocopy NUMBER
1049: , p10_a1 in out nocopy NUMBER
1050: , p10_a2 in out nocopy NUMBER
1051: , p11_a0 in out nocopy JTF_NUMBER_TABLE
1052: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1053: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1054: , p12_a0 in out nocopy JTF_NUMBER_TABLE
1055: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1050: , p10_a2 in out nocopy NUMBER
1051: , p11_a0 in out nocopy JTF_NUMBER_TABLE
1052: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1053: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1054: , p12_a0 in out nocopy JTF_NUMBER_TABLE
1055: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1056: , p_called_from_grp VARCHAR2
1057: )
1058:
1318: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1319: , p10_a0 in out nocopy NUMBER
1320: , p10_a1 in out nocopy NUMBER
1321: , p10_a2 in out nocopy NUMBER
1322: , p11_a0 in out nocopy JTF_NUMBER_TABLE
1323: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1324: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1325: , p12_a0 in out nocopy JTF_NUMBER_TABLE
1326: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1321: , p10_a2 in out nocopy NUMBER
1322: , p11_a0 in out nocopy JTF_NUMBER_TABLE
1323: , p11_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1324: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1325: , p12_a0 in out nocopy JTF_NUMBER_TABLE
1326: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100
1327: )
1328:
1329: as
1522: , p_commit VARCHAR2
1523: , p_init_msg_list VARCHAR2
1524: , p_validation_level NUMBER
1525: , p_transaction_id NUMBER
1526: , p5_a0 out nocopy JTF_NUMBER_TABLE
1527: , p5_a1 out nocopy JTF_NUMBER_TABLE
1528: , p5_a2 out nocopy JTF_NUMBER_TABLE
1529: , p5_a3 out nocopy JTF_NUMBER_TABLE
1530: , p5_a4 out nocopy JTF_NUMBER_TABLE
1523: , p_init_msg_list VARCHAR2
1524: , p_validation_level NUMBER
1525: , p_transaction_id NUMBER
1526: , p5_a0 out nocopy JTF_NUMBER_TABLE
1527: , p5_a1 out nocopy JTF_NUMBER_TABLE
1528: , p5_a2 out nocopy JTF_NUMBER_TABLE
1529: , p5_a3 out nocopy JTF_NUMBER_TABLE
1530: , p5_a4 out nocopy JTF_NUMBER_TABLE
1531: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1524: , p_validation_level NUMBER
1525: , p_transaction_id NUMBER
1526: , p5_a0 out nocopy JTF_NUMBER_TABLE
1527: , p5_a1 out nocopy JTF_NUMBER_TABLE
1528: , p5_a2 out nocopy JTF_NUMBER_TABLE
1529: , p5_a3 out nocopy JTF_NUMBER_TABLE
1530: , p5_a4 out nocopy JTF_NUMBER_TABLE
1531: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1532: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
1525: , p_transaction_id NUMBER
1526: , p5_a0 out nocopy JTF_NUMBER_TABLE
1527: , p5_a1 out nocopy JTF_NUMBER_TABLE
1528: , p5_a2 out nocopy JTF_NUMBER_TABLE
1529: , p5_a3 out nocopy JTF_NUMBER_TABLE
1530: , p5_a4 out nocopy JTF_NUMBER_TABLE
1531: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1532: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
1533: , p5_a7 out nocopy JTF_NUMBER_TABLE
1526: , p5_a0 out nocopy JTF_NUMBER_TABLE
1527: , p5_a1 out nocopy JTF_NUMBER_TABLE
1528: , p5_a2 out nocopy JTF_NUMBER_TABLE
1529: , p5_a3 out nocopy JTF_NUMBER_TABLE
1530: , p5_a4 out nocopy JTF_NUMBER_TABLE
1531: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1532: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
1533: , p5_a7 out nocopy JTF_NUMBER_TABLE
1534: , p5_a8 out nocopy JTF_NUMBER_TABLE
1529: , p5_a3 out nocopy JTF_NUMBER_TABLE
1530: , p5_a4 out nocopy JTF_NUMBER_TABLE
1531: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1532: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
1533: , p5_a7 out nocopy JTF_NUMBER_TABLE
1534: , p5_a8 out nocopy JTF_NUMBER_TABLE
1535: , p5_a9 out nocopy JTF_NUMBER_TABLE
1536: , p5_a10 out nocopy JTF_NUMBER_TABLE
1537: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
1530: , p5_a4 out nocopy JTF_NUMBER_TABLE
1531: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1532: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
1533: , p5_a7 out nocopy JTF_NUMBER_TABLE
1534: , p5_a8 out nocopy JTF_NUMBER_TABLE
1535: , p5_a9 out nocopy JTF_NUMBER_TABLE
1536: , p5_a10 out nocopy JTF_NUMBER_TABLE
1537: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
1538: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
1531: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
1532: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
1533: , p5_a7 out nocopy JTF_NUMBER_TABLE
1534: , p5_a8 out nocopy JTF_NUMBER_TABLE
1535: , p5_a9 out nocopy JTF_NUMBER_TABLE
1536: , p5_a10 out nocopy JTF_NUMBER_TABLE
1537: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
1538: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
1539: , p5_a13 out nocopy JTF_DATE_TABLE
1532: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
1533: , p5_a7 out nocopy JTF_NUMBER_TABLE
1534: , p5_a8 out nocopy JTF_NUMBER_TABLE
1535: , p5_a9 out nocopy JTF_NUMBER_TABLE
1536: , p5_a10 out nocopy JTF_NUMBER_TABLE
1537: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_100
1538: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
1539: , p5_a13 out nocopy JTF_DATE_TABLE
1540: , p5_a14 out nocopy JTF_DATE_TABLE
1569: , p5_a43 out nocopy JTF_VARCHAR2_TABLE_300
1570: , p5_a44 out nocopy JTF_VARCHAR2_TABLE_300
1571: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
1572: , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100
1573: , p5_a47 out nocopy JTF_NUMBER_TABLE
1574: , p5_a48 out nocopy JTF_NUMBER_TABLE
1575: , p5_a49 out nocopy JTF_NUMBER_TABLE
1576: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
1577: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
1570: , p5_a44 out nocopy JTF_VARCHAR2_TABLE_300
1571: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
1572: , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100
1573: , p5_a47 out nocopy JTF_NUMBER_TABLE
1574: , p5_a48 out nocopy JTF_NUMBER_TABLE
1575: , p5_a49 out nocopy JTF_NUMBER_TABLE
1576: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
1577: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
1578: , p5_a52 out nocopy JTF_NUMBER_TABLE
1571: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100
1572: , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100
1573: , p5_a47 out nocopy JTF_NUMBER_TABLE
1574: , p5_a48 out nocopy JTF_NUMBER_TABLE
1575: , p5_a49 out nocopy JTF_NUMBER_TABLE
1576: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
1577: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
1578: , p5_a52 out nocopy JTF_NUMBER_TABLE
1579: , p5_a53 out nocopy JTF_NUMBER_TABLE
1574: , p5_a48 out nocopy JTF_NUMBER_TABLE
1575: , p5_a49 out nocopy JTF_NUMBER_TABLE
1576: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
1577: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
1578: , p5_a52 out nocopy JTF_NUMBER_TABLE
1579: , p5_a53 out nocopy JTF_NUMBER_TABLE
1580: , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100
1581: , p5_a55 out nocopy JTF_VARCHAR2_TABLE_100
1582: , x_return_status out nocopy VARCHAR2
1575: , p5_a49 out nocopy JTF_NUMBER_TABLE
1576: , p5_a50 out nocopy JTF_VARCHAR2_TABLE_100
1577: , p5_a51 out nocopy JTF_VARCHAR2_TABLE_100
1578: , p5_a52 out nocopy JTF_NUMBER_TABLE
1579: , p5_a53 out nocopy JTF_NUMBER_TABLE
1580: , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100
1581: , p5_a55 out nocopy JTF_VARCHAR2_TABLE_100
1582: , x_return_status out nocopy VARCHAR2
1583: , x_msg_count out nocopy NUMBER
1677:
1678:
1679: end;
1680:
1681: procedure asset_syncup_validation(p0_a0 in out nocopy JTF_NUMBER_TABLE
1682: , p0_a1 in out nocopy JTF_NUMBER_TABLE
1683: , p0_a2 in out nocopy JTF_NUMBER_TABLE
1684: , p0_a3 in out nocopy JTF_NUMBER_TABLE
1685: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1678:
1679: end;
1680:
1681: procedure asset_syncup_validation(p0_a0 in out nocopy JTF_NUMBER_TABLE
1682: , p0_a1 in out nocopy JTF_NUMBER_TABLE
1683: , p0_a2 in out nocopy JTF_NUMBER_TABLE
1684: , p0_a3 in out nocopy JTF_NUMBER_TABLE
1685: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1686: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1679: end;
1680:
1681: procedure asset_syncup_validation(p0_a0 in out nocopy JTF_NUMBER_TABLE
1682: , p0_a1 in out nocopy JTF_NUMBER_TABLE
1683: , p0_a2 in out nocopy JTF_NUMBER_TABLE
1684: , p0_a3 in out nocopy JTF_NUMBER_TABLE
1685: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1686: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1687: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1680:
1681: procedure asset_syncup_validation(p0_a0 in out nocopy JTF_NUMBER_TABLE
1682: , p0_a1 in out nocopy JTF_NUMBER_TABLE
1683: , p0_a2 in out nocopy JTF_NUMBER_TABLE
1684: , p0_a3 in out nocopy JTF_NUMBER_TABLE
1685: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1686: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1687: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1688: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1682: , p0_a1 in out nocopy JTF_NUMBER_TABLE
1683: , p0_a2 in out nocopy JTF_NUMBER_TABLE
1684: , p0_a3 in out nocopy JTF_NUMBER_TABLE
1685: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1686: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1687: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1688: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1689: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1690: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1683: , p0_a2 in out nocopy JTF_NUMBER_TABLE
1684: , p0_a3 in out nocopy JTF_NUMBER_TABLE
1685: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1686: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1687: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1688: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1689: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1690: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1691: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1685: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1686: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1687: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1688: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1689: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1690: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1691: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1692: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1693: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1686: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1687: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1688: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1689: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1690: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1691: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1692: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1693: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1694: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1687: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1688: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1689: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1690: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1691: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1692: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1693: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1694: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1695: , p2_a1 in out nocopy JTF_NUMBER_TABLE
1688: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1689: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1690: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1691: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1692: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1693: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1694: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1695: , p2_a1 in out nocopy JTF_NUMBER_TABLE
1696: , p2_a2 in out nocopy JTF_NUMBER_TABLE
1689: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1690: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1691: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1692: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1693: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1694: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1695: , p2_a1 in out nocopy JTF_NUMBER_TABLE
1696: , p2_a2 in out nocopy JTF_NUMBER_TABLE
1697: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1690: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1691: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1692: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1693: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1694: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1695: , p2_a1 in out nocopy JTF_NUMBER_TABLE
1696: , p2_a2 in out nocopy JTF_NUMBER_TABLE
1697: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1698: , x_error_msg out nocopy VARCHAR2
1691: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1692: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1693: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1694: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1695: , p2_a1 in out nocopy JTF_NUMBER_TABLE
1696: , p2_a2 in out nocopy JTF_NUMBER_TABLE
1697: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1698: , x_error_msg out nocopy VARCHAR2
1699: , x_return_status out nocopy VARCHAR2
1692: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1693: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1694: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1695: , p2_a1 in out nocopy JTF_NUMBER_TABLE
1696: , p2_a2 in out nocopy JTF_NUMBER_TABLE
1697: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1698: , x_error_msg out nocopy VARCHAR2
1699: , x_return_status out nocopy VARCHAR2
1700: )
1693: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1694: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1695: , p2_a1 in out nocopy JTF_NUMBER_TABLE
1696: , p2_a2 in out nocopy JTF_NUMBER_TABLE
1697: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1698: , x_error_msg out nocopy VARCHAR2
1699: , x_return_status out nocopy VARCHAR2
1700: )
1701:
1767: end;
1768:
1769: procedure get_attached_item_instances(p_api_version NUMBER
1770: , p_init_msg_list VARCHAR2
1771: , p2_a0 JTF_NUMBER_TABLE
1772: , p2_a1 JTF_NUMBER_TABLE
1773: , p2_a2 JTF_NUMBER_TABLE
1774: , p2_a3 JTF_NUMBER_TABLE
1775: , p2_a4 JTF_NUMBER_TABLE
1768:
1769: procedure get_attached_item_instances(p_api_version NUMBER
1770: , p_init_msg_list VARCHAR2
1771: , p2_a0 JTF_NUMBER_TABLE
1772: , p2_a1 JTF_NUMBER_TABLE
1773: , p2_a2 JTF_NUMBER_TABLE
1774: , p2_a3 JTF_NUMBER_TABLE
1775: , p2_a4 JTF_NUMBER_TABLE
1776: , p3_a0 out nocopy JTF_NUMBER_TABLE
1769: procedure get_attached_item_instances(p_api_version NUMBER
1770: , p_init_msg_list VARCHAR2
1771: , p2_a0 JTF_NUMBER_TABLE
1772: , p2_a1 JTF_NUMBER_TABLE
1773: , p2_a2 JTF_NUMBER_TABLE
1774: , p2_a3 JTF_NUMBER_TABLE
1775: , p2_a4 JTF_NUMBER_TABLE
1776: , p3_a0 out nocopy JTF_NUMBER_TABLE
1777: , p3_a1 out nocopy JTF_NUMBER_TABLE
1770: , p_init_msg_list VARCHAR2
1771: , p2_a0 JTF_NUMBER_TABLE
1772: , p2_a1 JTF_NUMBER_TABLE
1773: , p2_a2 JTF_NUMBER_TABLE
1774: , p2_a3 JTF_NUMBER_TABLE
1775: , p2_a4 JTF_NUMBER_TABLE
1776: , p3_a0 out nocopy JTF_NUMBER_TABLE
1777: , p3_a1 out nocopy JTF_NUMBER_TABLE
1778: , p3_a2 out nocopy JTF_NUMBER_TABLE
1771: , p2_a0 JTF_NUMBER_TABLE
1772: , p2_a1 JTF_NUMBER_TABLE
1773: , p2_a2 JTF_NUMBER_TABLE
1774: , p2_a3 JTF_NUMBER_TABLE
1775: , p2_a4 JTF_NUMBER_TABLE
1776: , p3_a0 out nocopy JTF_NUMBER_TABLE
1777: , p3_a1 out nocopy JTF_NUMBER_TABLE
1778: , p3_a2 out nocopy JTF_NUMBER_TABLE
1779: , p3_a3 out nocopy JTF_NUMBER_TABLE
1772: , p2_a1 JTF_NUMBER_TABLE
1773: , p2_a2 JTF_NUMBER_TABLE
1774: , p2_a3 JTF_NUMBER_TABLE
1775: , p2_a4 JTF_NUMBER_TABLE
1776: , p3_a0 out nocopy JTF_NUMBER_TABLE
1777: , p3_a1 out nocopy JTF_NUMBER_TABLE
1778: , p3_a2 out nocopy JTF_NUMBER_TABLE
1779: , p3_a3 out nocopy JTF_NUMBER_TABLE
1780: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1773: , p2_a2 JTF_NUMBER_TABLE
1774: , p2_a3 JTF_NUMBER_TABLE
1775: , p2_a4 JTF_NUMBER_TABLE
1776: , p3_a0 out nocopy JTF_NUMBER_TABLE
1777: , p3_a1 out nocopy JTF_NUMBER_TABLE
1778: , p3_a2 out nocopy JTF_NUMBER_TABLE
1779: , p3_a3 out nocopy JTF_NUMBER_TABLE
1780: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1781: , p3_a5 out nocopy JTF_NUMBER_TABLE
1774: , p2_a3 JTF_NUMBER_TABLE
1775: , p2_a4 JTF_NUMBER_TABLE
1776: , p3_a0 out nocopy JTF_NUMBER_TABLE
1777: , p3_a1 out nocopy JTF_NUMBER_TABLE
1778: , p3_a2 out nocopy JTF_NUMBER_TABLE
1779: , p3_a3 out nocopy JTF_NUMBER_TABLE
1780: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1781: , p3_a5 out nocopy JTF_NUMBER_TABLE
1782: , p3_a6 out nocopy JTF_NUMBER_TABLE
1775: , p2_a4 JTF_NUMBER_TABLE
1776: , p3_a0 out nocopy JTF_NUMBER_TABLE
1777: , p3_a1 out nocopy JTF_NUMBER_TABLE
1778: , p3_a2 out nocopy JTF_NUMBER_TABLE
1779: , p3_a3 out nocopy JTF_NUMBER_TABLE
1780: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1781: , p3_a5 out nocopy JTF_NUMBER_TABLE
1782: , p3_a6 out nocopy JTF_NUMBER_TABLE
1783: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
1777: , p3_a1 out nocopy JTF_NUMBER_TABLE
1778: , p3_a2 out nocopy JTF_NUMBER_TABLE
1779: , p3_a3 out nocopy JTF_NUMBER_TABLE
1780: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1781: , p3_a5 out nocopy JTF_NUMBER_TABLE
1782: , p3_a6 out nocopy JTF_NUMBER_TABLE
1783: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
1784: , x_return_status out nocopy VARCHAR2
1785: , x_msg_count out nocopy NUMBER
1778: , p3_a2 out nocopy JTF_NUMBER_TABLE
1779: , p3_a3 out nocopy JTF_NUMBER_TABLE
1780: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
1781: , p3_a5 out nocopy JTF_NUMBER_TABLE
1782: , p3_a6 out nocopy JTF_NUMBER_TABLE
1783: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
1784: , x_return_status out nocopy VARCHAR2
1785: , x_msg_count out nocopy NUMBER
1786: , x_msg_data out nocopy VARCHAR2
1842: end;
1843:
1844: procedure get_attached_asset_links(p_api_version NUMBER
1845: , p_init_msg_list VARCHAR2
1846: , p2_a0 JTF_NUMBER_TABLE
1847: , p2_a1 JTF_NUMBER_TABLE
1848: , p2_a2 JTF_NUMBER_TABLE
1849: , p2_a3 JTF_NUMBER_TABLE
1850: , p2_a4 JTF_VARCHAR2_TABLE_100
1843:
1844: procedure get_attached_asset_links(p_api_version NUMBER
1845: , p_init_msg_list VARCHAR2
1846: , p2_a0 JTF_NUMBER_TABLE
1847: , p2_a1 JTF_NUMBER_TABLE
1848: , p2_a2 JTF_NUMBER_TABLE
1849: , p2_a3 JTF_NUMBER_TABLE
1850: , p2_a4 JTF_VARCHAR2_TABLE_100
1851: , p2_a5 JTF_NUMBER_TABLE
1844: procedure get_attached_asset_links(p_api_version NUMBER
1845: , p_init_msg_list VARCHAR2
1846: , p2_a0 JTF_NUMBER_TABLE
1847: , p2_a1 JTF_NUMBER_TABLE
1848: , p2_a2 JTF_NUMBER_TABLE
1849: , p2_a3 JTF_NUMBER_TABLE
1850: , p2_a4 JTF_VARCHAR2_TABLE_100
1851: , p2_a5 JTF_NUMBER_TABLE
1852: , p2_a6 JTF_NUMBER_TABLE
1845: , p_init_msg_list VARCHAR2
1846: , p2_a0 JTF_NUMBER_TABLE
1847: , p2_a1 JTF_NUMBER_TABLE
1848: , p2_a2 JTF_NUMBER_TABLE
1849: , p2_a3 JTF_NUMBER_TABLE
1850: , p2_a4 JTF_VARCHAR2_TABLE_100
1851: , p2_a5 JTF_NUMBER_TABLE
1852: , p2_a6 JTF_NUMBER_TABLE
1853: , p2_a7 JTF_VARCHAR2_TABLE_100
1847: , p2_a1 JTF_NUMBER_TABLE
1848: , p2_a2 JTF_NUMBER_TABLE
1849: , p2_a3 JTF_NUMBER_TABLE
1850: , p2_a4 JTF_VARCHAR2_TABLE_100
1851: , p2_a5 JTF_NUMBER_TABLE
1852: , p2_a6 JTF_NUMBER_TABLE
1853: , p2_a7 JTF_VARCHAR2_TABLE_100
1854: , p3_a0 out nocopy JTF_NUMBER_TABLE
1855: , p3_a1 out nocopy JTF_NUMBER_TABLE
1848: , p2_a2 JTF_NUMBER_TABLE
1849: , p2_a3 JTF_NUMBER_TABLE
1850: , p2_a4 JTF_VARCHAR2_TABLE_100
1851: , p2_a5 JTF_NUMBER_TABLE
1852: , p2_a6 JTF_NUMBER_TABLE
1853: , p2_a7 JTF_VARCHAR2_TABLE_100
1854: , p3_a0 out nocopy JTF_NUMBER_TABLE
1855: , p3_a1 out nocopy JTF_NUMBER_TABLE
1856: , p3_a2 out nocopy JTF_NUMBER_TABLE
1850: , p2_a4 JTF_VARCHAR2_TABLE_100
1851: , p2_a5 JTF_NUMBER_TABLE
1852: , p2_a6 JTF_NUMBER_TABLE
1853: , p2_a7 JTF_VARCHAR2_TABLE_100
1854: , p3_a0 out nocopy JTF_NUMBER_TABLE
1855: , p3_a1 out nocopy JTF_NUMBER_TABLE
1856: , p3_a2 out nocopy JTF_NUMBER_TABLE
1857: , p3_a3 out nocopy JTF_NUMBER_TABLE
1858: , p3_a4 out nocopy JTF_NUMBER_TABLE
1851: , p2_a5 JTF_NUMBER_TABLE
1852: , p2_a6 JTF_NUMBER_TABLE
1853: , p2_a7 JTF_VARCHAR2_TABLE_100
1854: , p3_a0 out nocopy JTF_NUMBER_TABLE
1855: , p3_a1 out nocopy JTF_NUMBER_TABLE
1856: , p3_a2 out nocopy JTF_NUMBER_TABLE
1857: , p3_a3 out nocopy JTF_NUMBER_TABLE
1858: , p3_a4 out nocopy JTF_NUMBER_TABLE
1859: , x_return_status out nocopy VARCHAR2
1852: , p2_a6 JTF_NUMBER_TABLE
1853: , p2_a7 JTF_VARCHAR2_TABLE_100
1854: , p3_a0 out nocopy JTF_NUMBER_TABLE
1855: , p3_a1 out nocopy JTF_NUMBER_TABLE
1856: , p3_a2 out nocopy JTF_NUMBER_TABLE
1857: , p3_a3 out nocopy JTF_NUMBER_TABLE
1858: , p3_a4 out nocopy JTF_NUMBER_TABLE
1859: , x_return_status out nocopy VARCHAR2
1860: , x_msg_count out nocopy NUMBER
1853: , p2_a7 JTF_VARCHAR2_TABLE_100
1854: , p3_a0 out nocopy JTF_NUMBER_TABLE
1855: , p3_a1 out nocopy JTF_NUMBER_TABLE
1856: , p3_a2 out nocopy JTF_NUMBER_TABLE
1857: , p3_a3 out nocopy JTF_NUMBER_TABLE
1858: , p3_a4 out nocopy JTF_NUMBER_TABLE
1859: , x_return_status out nocopy VARCHAR2
1860: , x_msg_count out nocopy NUMBER
1861: , x_msg_data out nocopy VARCHAR2
1854: , p3_a0 out nocopy JTF_NUMBER_TABLE
1855: , p3_a1 out nocopy JTF_NUMBER_TABLE
1856: , p3_a2 out nocopy JTF_NUMBER_TABLE
1857: , p3_a3 out nocopy JTF_NUMBER_TABLE
1858: , p3_a4 out nocopy JTF_NUMBER_TABLE
1859: , x_return_status out nocopy VARCHAR2
1860: , x_msg_count out nocopy NUMBER
1861: , x_msg_data out nocopy VARCHAR2
1862: , p_source_system_name VARCHAR2
1917: end;
1918:
1919: procedure get_fa_asset_details(p_api_version NUMBER
1920: , p_init_msg_list VARCHAR2
1921: , p2_a0 JTF_NUMBER_TABLE
1922: , p2_a1 JTF_NUMBER_TABLE
1923: , p2_a2 JTF_NUMBER_TABLE
1924: , p2_a3 JTF_NUMBER_TABLE
1925: , p2_a4 JTF_NUMBER_TABLE
1918:
1919: procedure get_fa_asset_details(p_api_version NUMBER
1920: , p_init_msg_list VARCHAR2
1921: , p2_a0 JTF_NUMBER_TABLE
1922: , p2_a1 JTF_NUMBER_TABLE
1923: , p2_a2 JTF_NUMBER_TABLE
1924: , p2_a3 JTF_NUMBER_TABLE
1925: , p2_a4 JTF_NUMBER_TABLE
1926: , p3_a0 out nocopy JTF_NUMBER_TABLE
1919: procedure get_fa_asset_details(p_api_version NUMBER
1920: , p_init_msg_list VARCHAR2
1921: , p2_a0 JTF_NUMBER_TABLE
1922: , p2_a1 JTF_NUMBER_TABLE
1923: , p2_a2 JTF_NUMBER_TABLE
1924: , p2_a3 JTF_NUMBER_TABLE
1925: , p2_a4 JTF_NUMBER_TABLE
1926: , p3_a0 out nocopy JTF_NUMBER_TABLE
1927: , p3_a1 out nocopy JTF_NUMBER_TABLE
1920: , p_init_msg_list VARCHAR2
1921: , p2_a0 JTF_NUMBER_TABLE
1922: , p2_a1 JTF_NUMBER_TABLE
1923: , p2_a2 JTF_NUMBER_TABLE
1924: , p2_a3 JTF_NUMBER_TABLE
1925: , p2_a4 JTF_NUMBER_TABLE
1926: , p3_a0 out nocopy JTF_NUMBER_TABLE
1927: , p3_a1 out nocopy JTF_NUMBER_TABLE
1928: , p3_a2 out nocopy JTF_NUMBER_TABLE
1921: , p2_a0 JTF_NUMBER_TABLE
1922: , p2_a1 JTF_NUMBER_TABLE
1923: , p2_a2 JTF_NUMBER_TABLE
1924: , p2_a3 JTF_NUMBER_TABLE
1925: , p2_a4 JTF_NUMBER_TABLE
1926: , p3_a0 out nocopy JTF_NUMBER_TABLE
1927: , p3_a1 out nocopy JTF_NUMBER_TABLE
1928: , p3_a2 out nocopy JTF_NUMBER_TABLE
1929: , p3_a3 out nocopy JTF_NUMBER_TABLE
1922: , p2_a1 JTF_NUMBER_TABLE
1923: , p2_a2 JTF_NUMBER_TABLE
1924: , p2_a3 JTF_NUMBER_TABLE
1925: , p2_a4 JTF_NUMBER_TABLE
1926: , p3_a0 out nocopy JTF_NUMBER_TABLE
1927: , p3_a1 out nocopy JTF_NUMBER_TABLE
1928: , p3_a2 out nocopy JTF_NUMBER_TABLE
1929: , p3_a3 out nocopy JTF_NUMBER_TABLE
1930: , x_return_status out nocopy VARCHAR2
1923: , p2_a2 JTF_NUMBER_TABLE
1924: , p2_a3 JTF_NUMBER_TABLE
1925: , p2_a4 JTF_NUMBER_TABLE
1926: , p3_a0 out nocopy JTF_NUMBER_TABLE
1927: , p3_a1 out nocopy JTF_NUMBER_TABLE
1928: , p3_a2 out nocopy JTF_NUMBER_TABLE
1929: , p3_a3 out nocopy JTF_NUMBER_TABLE
1930: , x_return_status out nocopy VARCHAR2
1931: , x_msg_count out nocopy NUMBER
1924: , p2_a3 JTF_NUMBER_TABLE
1925: , p2_a4 JTF_NUMBER_TABLE
1926: , p3_a0 out nocopy JTF_NUMBER_TABLE
1927: , p3_a1 out nocopy JTF_NUMBER_TABLE
1928: , p3_a2 out nocopy JTF_NUMBER_TABLE
1929: , p3_a3 out nocopy JTF_NUMBER_TABLE
1930: , x_return_status out nocopy VARCHAR2
1931: , x_msg_count out nocopy NUMBER
1932: , x_msg_data out nocopy VARCHAR2
1925: , p2_a4 JTF_NUMBER_TABLE
1926: , p3_a0 out nocopy JTF_NUMBER_TABLE
1927: , p3_a1 out nocopy JTF_NUMBER_TABLE
1928: , p3_a2 out nocopy JTF_NUMBER_TABLE
1929: , p3_a3 out nocopy JTF_NUMBER_TABLE
1930: , x_return_status out nocopy VARCHAR2
1931: , x_msg_count out nocopy NUMBER
1932: , x_msg_data out nocopy VARCHAR2
1933: , p_source_system_name VARCHAR2
1982:
1983:
1984: end;
1985:
1986: procedure get_syncup_tree(p0_a0 in out nocopy JTF_NUMBER_TABLE
1987: , p0_a1 in out nocopy JTF_NUMBER_TABLE
1988: , p0_a2 in out nocopy JTF_NUMBER_TABLE
1989: , p0_a3 in out nocopy JTF_NUMBER_TABLE
1990: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1983:
1984: end;
1985:
1986: procedure get_syncup_tree(p0_a0 in out nocopy JTF_NUMBER_TABLE
1987: , p0_a1 in out nocopy JTF_NUMBER_TABLE
1988: , p0_a2 in out nocopy JTF_NUMBER_TABLE
1989: , p0_a3 in out nocopy JTF_NUMBER_TABLE
1990: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1991: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1984: end;
1985:
1986: procedure get_syncup_tree(p0_a0 in out nocopy JTF_NUMBER_TABLE
1987: , p0_a1 in out nocopy JTF_NUMBER_TABLE
1988: , p0_a2 in out nocopy JTF_NUMBER_TABLE
1989: , p0_a3 in out nocopy JTF_NUMBER_TABLE
1990: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1991: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1992: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1985:
1986: procedure get_syncup_tree(p0_a0 in out nocopy JTF_NUMBER_TABLE
1987: , p0_a1 in out nocopy JTF_NUMBER_TABLE
1988: , p0_a2 in out nocopy JTF_NUMBER_TABLE
1989: , p0_a3 in out nocopy JTF_NUMBER_TABLE
1990: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1991: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1992: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1993: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1987: , p0_a1 in out nocopy JTF_NUMBER_TABLE
1988: , p0_a2 in out nocopy JTF_NUMBER_TABLE
1989: , p0_a3 in out nocopy JTF_NUMBER_TABLE
1990: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1991: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1992: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1993: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1994: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1995: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1988: , p0_a2 in out nocopy JTF_NUMBER_TABLE
1989: , p0_a3 in out nocopy JTF_NUMBER_TABLE
1990: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1991: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1992: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1993: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1994: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1995: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1996: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1990: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
1991: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1992: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1993: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1994: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1995: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1996: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1997: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1998: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1991: , p0_a5 in out nocopy JTF_NUMBER_TABLE
1992: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1993: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1994: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1995: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1996: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1997: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1998: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1999: , p2_a0 in out nocopy JTF_NUMBER_TABLE
1992: , p0_a6 in out nocopy JTF_NUMBER_TABLE
1993: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1994: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1995: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1996: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1997: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1998: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1999: , p2_a0 in out nocopy JTF_NUMBER_TABLE
2000: , p2_a1 in out nocopy JTF_NUMBER_TABLE
1993: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1994: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1995: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1996: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1997: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1998: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1999: , p2_a0 in out nocopy JTF_NUMBER_TABLE
2000: , p2_a1 in out nocopy JTF_NUMBER_TABLE
2001: , p2_a2 in out nocopy JTF_NUMBER_TABLE
1994: , p1_a0 in out nocopy JTF_NUMBER_TABLE
1995: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1996: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1997: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1998: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1999: , p2_a0 in out nocopy JTF_NUMBER_TABLE
2000: , p2_a1 in out nocopy JTF_NUMBER_TABLE
2001: , p2_a2 in out nocopy JTF_NUMBER_TABLE
2002: , p2_a3 in out nocopy JTF_NUMBER_TABLE
1995: , p1_a1 in out nocopy JTF_NUMBER_TABLE
1996: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1997: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1998: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1999: , p2_a0 in out nocopy JTF_NUMBER_TABLE
2000: , p2_a1 in out nocopy JTF_NUMBER_TABLE
2001: , p2_a2 in out nocopy JTF_NUMBER_TABLE
2002: , p2_a3 in out nocopy JTF_NUMBER_TABLE
2003: , x_return_status out nocopy VARCHAR2
1996: , p1_a2 in out nocopy JTF_NUMBER_TABLE
1997: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1998: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1999: , p2_a0 in out nocopy JTF_NUMBER_TABLE
2000: , p2_a1 in out nocopy JTF_NUMBER_TABLE
2001: , p2_a2 in out nocopy JTF_NUMBER_TABLE
2002: , p2_a3 in out nocopy JTF_NUMBER_TABLE
2003: , x_return_status out nocopy VARCHAR2
2004: , x_error_msg out nocopy VARCHAR2
1997: , p1_a3 in out nocopy JTF_NUMBER_TABLE
1998: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1999: , p2_a0 in out nocopy JTF_NUMBER_TABLE
2000: , p2_a1 in out nocopy JTF_NUMBER_TABLE
2001: , p2_a2 in out nocopy JTF_NUMBER_TABLE
2002: , p2_a3 in out nocopy JTF_NUMBER_TABLE
2003: , x_return_status out nocopy VARCHAR2
2004: , x_error_msg out nocopy VARCHAR2
2005: , p_source_system_name VARCHAR2
1998: , p1_a4 in out nocopy JTF_NUMBER_TABLE
1999: , p2_a0 in out nocopy JTF_NUMBER_TABLE
2000: , p2_a1 in out nocopy JTF_NUMBER_TABLE
2001: , p2_a2 in out nocopy JTF_NUMBER_TABLE
2002: , p2_a3 in out nocopy JTF_NUMBER_TABLE
2003: , x_return_status out nocopy VARCHAR2
2004: , x_error_msg out nocopy VARCHAR2
2005: , p_source_system_name VARCHAR2
2006: , p_called_from_grp VARCHAR2
2082: procedure create_instance_assets(p_api_version NUMBER
2083: , p_commit VARCHAR2
2084: , p_init_msg_list VARCHAR2
2085: , p_validation_level NUMBER
2086: , p4_a0 in out nocopy JTF_NUMBER_TABLE
2087: , p4_a1 in out nocopy JTF_NUMBER_TABLE
2088: , p4_a2 in out nocopy JTF_NUMBER_TABLE
2089: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2090: , p4_a4 in out nocopy JTF_NUMBER_TABLE
2083: , p_commit VARCHAR2
2084: , p_init_msg_list VARCHAR2
2085: , p_validation_level NUMBER
2086: , p4_a0 in out nocopy JTF_NUMBER_TABLE
2087: , p4_a1 in out nocopy JTF_NUMBER_TABLE
2088: , p4_a2 in out nocopy JTF_NUMBER_TABLE
2089: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2090: , p4_a4 in out nocopy JTF_NUMBER_TABLE
2091: , p4_a5 in out nocopy JTF_NUMBER_TABLE
2084: , p_init_msg_list VARCHAR2
2085: , p_validation_level NUMBER
2086: , p4_a0 in out nocopy JTF_NUMBER_TABLE
2087: , p4_a1 in out nocopy JTF_NUMBER_TABLE
2088: , p4_a2 in out nocopy JTF_NUMBER_TABLE
2089: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2090: , p4_a4 in out nocopy JTF_NUMBER_TABLE
2091: , p4_a5 in out nocopy JTF_NUMBER_TABLE
2092: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2086: , p4_a0 in out nocopy JTF_NUMBER_TABLE
2087: , p4_a1 in out nocopy JTF_NUMBER_TABLE
2088: , p4_a2 in out nocopy JTF_NUMBER_TABLE
2089: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2090: , p4_a4 in out nocopy JTF_NUMBER_TABLE
2091: , p4_a5 in out nocopy JTF_NUMBER_TABLE
2092: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2093: , p4_a7 in out nocopy JTF_DATE_TABLE
2094: , p4_a8 in out nocopy JTF_DATE_TABLE
2087: , p4_a1 in out nocopy JTF_NUMBER_TABLE
2088: , p4_a2 in out nocopy JTF_NUMBER_TABLE
2089: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2090: , p4_a4 in out nocopy JTF_NUMBER_TABLE
2091: , p4_a5 in out nocopy JTF_NUMBER_TABLE
2092: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2093: , p4_a7 in out nocopy JTF_DATE_TABLE
2094: , p4_a8 in out nocopy JTF_DATE_TABLE
2095: , p4_a9 in out nocopy JTF_NUMBER_TABLE
2091: , p4_a5 in out nocopy JTF_NUMBER_TABLE
2092: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100
2093: , p4_a7 in out nocopy JTF_DATE_TABLE
2094: , p4_a8 in out nocopy JTF_DATE_TABLE
2095: , p4_a9 in out nocopy JTF_NUMBER_TABLE
2096: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
2097: , p4_a11 in out nocopy JTF_NUMBER_TABLE
2098: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
2099: , p4_a13 in out nocopy JTF_NUMBER_TABLE
2093: , p4_a7 in out nocopy JTF_DATE_TABLE
2094: , p4_a8 in out nocopy JTF_DATE_TABLE
2095: , p4_a9 in out nocopy JTF_NUMBER_TABLE
2096: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
2097: , p4_a11 in out nocopy JTF_NUMBER_TABLE
2098: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
2099: , p4_a13 in out nocopy JTF_NUMBER_TABLE
2100: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
2101: , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_100
2095: , p4_a9 in out nocopy JTF_NUMBER_TABLE
2096: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100
2097: , p4_a11 in out nocopy JTF_NUMBER_TABLE
2098: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100
2099: , p4_a13 in out nocopy JTF_NUMBER_TABLE
2100: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100
2101: , p4_a15 in out nocopy JTF_VARCHAR2_TABLE_100
2102: , p5_a0 in out nocopy NUMBER
2103: , p5_a1 in out nocopy DATE
2143: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2144: , p7_a0 in out nocopy NUMBER
2145: , p7_a1 in out nocopy NUMBER
2146: , p7_a2 in out nocopy NUMBER
2147: , p8_a0 in out nocopy JTF_NUMBER_TABLE
2148: , p8_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2149: , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2150: , p9_a0 in out nocopy JTF_NUMBER_TABLE
2151: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2146: , p7_a2 in out nocopy NUMBER
2147: , p8_a0 in out nocopy JTF_NUMBER_TABLE
2148: , p8_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2149: , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2150: , p9_a0 in out nocopy JTF_NUMBER_TABLE
2151: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100
2152: , x_return_status out nocopy VARCHAR2
2153: , x_msg_count out nocopy NUMBER
2154: , x_msg_data out nocopy VARCHAR2