APPS.CSI_ASSET_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 25: procedure rosetta_table_copy_in_p1(t out nocopy csi_asset_pvt.lookup_tbl, a0 JTF_VARCHAR2_TABLE_100

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p1(t out nocopy csi_asset_pvt.lookup_tbl, a0 JTF_VARCHAR2_TABLE_100
26: , a1 JTF_VARCHAR2_TABLE_100
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin

Line 26: , a1 JTF_VARCHAR2_TABLE_100

22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p1(t out nocopy csi_asset_pvt.lookup_tbl, a0 JTF_VARCHAR2_TABLE_100
26: , a1 JTF_VARCHAR2_TABLE_100
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if a0 is not null and a0.count > 0 then

Line 46: procedure rosetta_table_copy_out_p1(t csi_asset_pvt.lookup_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

42: end loop;
43: end if;
44: end if;
45: end rosetta_table_copy_in_p1;
46: procedure rosetta_table_copy_out_p1(t csi_asset_pvt.lookup_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin

Line 47: , a1 out nocopy JTF_VARCHAR2_TABLE_100

43: end if;
44: end if;
45: end rosetta_table_copy_in_p1;
46: procedure rosetta_table_copy_out_p1(t csi_asset_pvt.lookup_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then

Line 52: a0 := JTF_VARCHAR2_TABLE_100();

48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: else
55: a0 := JTF_VARCHAR2_TABLE_100();
56: a1 := JTF_VARCHAR2_TABLE_100();

Line 53: a1 := JTF_VARCHAR2_TABLE_100();

49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: else
55: a0 := JTF_VARCHAR2_TABLE_100();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: if t.count > 0 then

Line 55: a0 := JTF_VARCHAR2_TABLE_100();

51: if t is null or t.count = 0 then
52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: else
55: a0 := JTF_VARCHAR2_TABLE_100();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: if t.count > 0 then
58: a0.extend(t.count);
59: a1.extend(t.count);

Line 56: a1 := JTF_VARCHAR2_TABLE_100();

52: a0 := JTF_VARCHAR2_TABLE_100();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: else
55: a0 := JTF_VARCHAR2_TABLE_100();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: if t.count > 0 then
58: a0.extend(t.count);
59: a1.extend(t.count);
60: ddindx := t.first;

Line 76: , a1 JTF_VARCHAR2_TABLE_100

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;
80: begin

Line 77: , a2 JTF_VARCHAR2_TABLE_100

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;
80: begin
81: if a0 is not null and a0.count > 0 then

Line 99: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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;
103: begin

Line 100: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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;
103: begin
104: if t is null or t.count = 0 then

Line 106: a1 := JTF_VARCHAR2_TABLE_100();

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();
110: a1 := JTF_VARCHAR2_TABLE_100();

Line 107: a2 := JTF_VARCHAR2_TABLE_100();

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();
110: a1 := JTF_VARCHAR2_TABLE_100();
111: a2 := JTF_VARCHAR2_TABLE_100();

Line 110: a1 := JTF_VARCHAR2_TABLE_100();

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);
114: a1.extend(t.count);

Line 111: a2 := 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);
114: a1.extend(t.count);
115: a2.extend(t.count);

Line 133: , a1 JTF_VARCHAR2_TABLE_100

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
137: if a0 is not null and a0.count > 0 then

Line 154: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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
158: if t is null or t.count = 0 then

Line 160: a1 := JTF_VARCHAR2_TABLE_100();

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();
164: if t.count > 0 then

Line 163: a1 := JTF_VARCHAR2_TABLE_100();

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);
167: ddindx := t.first;

Line 321: , a4 JTF_VARCHAR2_TABLE_100

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
325: ) as

Line 324: , a7 JTF_VARCHAR2_TABLE_100

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
328: if a0 is not null and a0.count > 0 then

Line 354: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
358: ) as

Line 357: , a7 out nocopy JTF_VARCHAR2_TABLE_100

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
361: if t is null or t.count = 0 then

Line 366: a4 := JTF_VARCHAR2_TABLE_100();

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();
370: else

Line 369: a7 := JTF_VARCHAR2_TABLE_100();

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();
373: a2 := JTF_NUMBER_TABLE();

Line 375: a4 := JTF_VARCHAR2_TABLE_100();

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();
379: if t.count > 0 then

Line 378: a7 := JTF_VARCHAR2_TABLE_100();

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);
382: a2.extend(t.count);

Line 519: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100

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
523: , p0_a7 in out nocopy JTF_DATE_TABLE

Line 522: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100

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
526: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 526: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100

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
530: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100

Line 527: , p0_a11 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
530: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100

Line 528: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100

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
530: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
532: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 529: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100

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
530: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
532: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
533: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100

Line 530: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100

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
530: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
532: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
533: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100

Line 531: , p0_a15 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
530: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
532: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
533: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
535: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100

Line 532: , p0_a16 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
530: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
532: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
533: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
535: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
536: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100

Line 533: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100

529: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
530: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
532: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
533: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
535: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
536: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
537: , p0_a21 in out nocopy JTF_DATE_TABLE

Line 534: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100

530: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
531: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
532: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
533: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
535: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
536: , p0_a20 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

Line 535: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100

531: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
532: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
533: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
535: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
536: , p0_a20 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

Line 536: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100

532: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
533: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
534: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
535: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
536: , p0_a20 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

Line 538: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100

534: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
535: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
536: , p0_a20 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

Line 540: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100

536: , p0_a20 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: )

Line 542: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100

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:
546: as

Line 729: , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100

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
733: , p0_a7 in out nocopy JTF_DATE_TABLE

Line 732: , p0_a6 in out nocopy JTF_VARCHAR2_TABLE_100

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
736: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 736: , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100

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
740: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100

Line 737: , p0_a11 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
740: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100

Line 738: , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100

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
740: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
742: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 739: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100

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
740: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
742: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
743: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100

Line 740: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100

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
740: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
742: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
743: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
744: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100

Line 741: , p0_a15 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
740: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
742: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
743: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
744: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100

Line 742: , p0_a16 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
740: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
742: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
743: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
744: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100

Line 743: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100

739: , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
740: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
742: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
743: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
744: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100
747: , p0_a21 in out nocopy JTF_DATE_TABLE

Line 744: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100

740: , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
742: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
743: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
744: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p0_a20 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

Line 745: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100

741: , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
742: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
743: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
744: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p0_a20 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

Line 746: , p0_a20 in out nocopy JTF_VARCHAR2_TABLE_100

742: , p0_a16 in out nocopy JTF_VARCHAR2_TABLE_100
743: , p0_a17 in out nocopy JTF_VARCHAR2_TABLE_100
744: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p0_a20 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

Line 748: , p0_a22 in out nocopy JTF_VARCHAR2_TABLE_100

744: , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_100
745: , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p0_a20 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

Line 750: , p0_a24 in out nocopy JTF_VARCHAR2_TABLE_100

746: , p0_a20 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:

Line 752: , p0_a26 in out nocopy JTF_VARCHAR2_TABLE_100

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
756: ddp_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 866: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
870: , p7_a7 out nocopy JTF_DATE_TABLE

Line 869: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
873: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 873: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

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
877: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 874: , p7_a11 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
877: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
878: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 875: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
877: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
878: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
879: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 876: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100

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
877: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
878: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
879: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
880: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 877: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100

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
877: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
878: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
879: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
880: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
881: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 878: , p7_a15 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
877: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
878: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
879: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
880: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
881: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
882: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 879: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100

875: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
876: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
877: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
878: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
879: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
880: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
881: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
882: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
883: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 880: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100

876: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
877: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
878: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
879: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
880: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
881: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
882: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
883: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
884: , p7_a21 out nocopy JTF_DATE_TABLE

Line 881: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100

877: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
878: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
879: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
880: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
881: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
882: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
883: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
884: , p7_a21 out nocopy JTF_DATE_TABLE
885: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 882: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

878: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
879: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
880: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
881: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
882: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
883: , p7_a20 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

Line 883: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100

879: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
880: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
881: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
882: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
883: , p7_a20 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

Line 885: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100

881: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
882: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100
883: , p7_a20 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

Line 887: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100

883: , p7_a20 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

Line 889: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100

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
893: , p4_a0 NUMBER := 0-1962.0724

Line 1046: , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100

1042: , p5_a39 in out nocopy NUMBER
1043: , x_return_status out nocopy VARCHAR2
1044: , x_msg_count out nocopy NUMBER
1045: , x_msg_data out nocopy VARCHAR2
1046: , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100
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

Line 1047: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1043: , x_return_status out nocopy VARCHAR2
1044: , x_msg_count out nocopy NUMBER
1045: , x_msg_data out nocopy VARCHAR2
1046: , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100
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

Line 1052: , p11_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
1056: , p_called_from_grp VARCHAR2

Line 1053: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100

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
1056: , p_called_from_grp VARCHAR2
1057: )

Line 1055: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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:
1059: as

Line 1317: , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100

1313: , p5_a39 in out nocopy NUMBER
1314: , x_return_status out nocopy VARCHAR2
1315: , x_msg_count out nocopy NUMBER
1316: , x_msg_data out nocopy VARCHAR2
1317: , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100
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

Line 1318: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

1314: , x_return_status out nocopy VARCHAR2
1315: , x_msg_count out nocopy NUMBER
1316: , x_msg_data out nocopy VARCHAR2
1317: , p9_a0 in out nocopy JTF_VARCHAR2_TABLE_100
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

Line 1323: , p11_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
1327: )

Line 1324: , p11_a2 in out nocopy JTF_VARCHAR2_TABLE_100

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
1327: )
1328:

Line 1326: , p12_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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
1330: ddp_instance_asset_rec csi_datastructures_pub.instance_asset_rec;

Line 1531: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
1535: , p5_a9 out nocopy JTF_NUMBER_TABLE

Line 1532: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
1535: , p5_a9 out nocopy JTF_NUMBER_TABLE
1536: , p5_a10 out nocopy JTF_NUMBER_TABLE

Line 1537: , p5_a11 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
1541: , p5_a15 out nocopy JTF_DATE_TABLE

Line 1538: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100

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
1541: , p5_a15 out nocopy JTF_DATE_TABLE
1542: , p5_a16 out nocopy JTF_DATE_TABLE

Line 1543: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100

1539: , p5_a13 out nocopy JTF_DATE_TABLE
1540: , p5_a14 out nocopy JTF_DATE_TABLE
1541: , p5_a15 out nocopy JTF_DATE_TABLE
1542: , p5_a16 out nocopy JTF_DATE_TABLE
1543: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
1544: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
1545: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
1546: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
1547: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 1544: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100

1540: , p5_a14 out nocopy JTF_DATE_TABLE
1541: , p5_a15 out nocopy JTF_DATE_TABLE
1542: , p5_a16 out nocopy JTF_DATE_TABLE
1543: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
1544: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
1545: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
1546: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
1547: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1548: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 1545: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100

1541: , p5_a15 out nocopy JTF_DATE_TABLE
1542: , p5_a16 out nocopy JTF_DATE_TABLE
1543: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
1544: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
1545: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
1546: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
1547: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1548: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1549: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 1546: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100

1542: , p5_a16 out nocopy JTF_DATE_TABLE
1543: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
1544: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
1545: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
1546: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
1547: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1548: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1549: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1550: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100

Line 1547: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100

1543: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_100
1544: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
1545: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
1546: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
1547: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1548: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1549: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1550: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
1551: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 1548: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100

1544: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_100
1545: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
1546: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
1547: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1548: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1549: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1550: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
1551: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100

Line 1549: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100

1545: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
1546: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
1547: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1548: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1549: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1550: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
1551: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
1553: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 1550: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100

1546: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
1547: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1548: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1549: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1550: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
1551: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
1553: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
1554: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 1551: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100

1547: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_100
1548: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1549: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1550: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
1551: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
1553: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
1554: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100

Line 1552: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100

1548: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_100
1549: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1550: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
1551: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
1553: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
1554: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
1556: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 1553: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100

1549: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
1550: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
1551: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
1553: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
1554: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
1556: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
1557: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100

Line 1554: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100

1550: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_100
1551: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
1553: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
1554: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
1556: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
1557: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
1558: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100

Line 1555: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100

1551: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_100
1552: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
1553: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
1554: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
1556: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
1557: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
1558: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 1556: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100

1552: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_100
1553: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
1554: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
1556: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
1557: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
1558: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
1560: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100

Line 1557: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100

1553: , p5_a27 out nocopy JTF_VARCHAR2_TABLE_100
1554: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
1556: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
1557: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
1558: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
1560: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
1561: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100

Line 1558: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100

1554: , p5_a28 out nocopy JTF_VARCHAR2_TABLE_100
1555: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
1556: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
1557: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
1558: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
1560: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
1561: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100

Line 1559: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100

1555: , p5_a29 out nocopy JTF_VARCHAR2_TABLE_100
1556: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
1557: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
1558: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
1560: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
1561: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100

Line 1560: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100

1556: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
1557: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
1558: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
1560: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
1561: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 1561: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100

1557: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_100
1558: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
1560: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
1561: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
1565: , p5_a39 out nocopy JTF_DATE_TABLE

Line 1562: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100

1558: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_100
1559: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
1560: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
1561: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
1565: , p5_a39 out nocopy JTF_DATE_TABLE
1566: , p5_a40 out nocopy JTF_DATE_TABLE

Line 1563: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100

1559: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_100
1560: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
1561: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
1565: , p5_a39 out nocopy JTF_DATE_TABLE
1566: , p5_a40 out nocopy JTF_DATE_TABLE
1567: , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 1564: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100

1560: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_100
1561: , p5_a35 out nocopy JTF_VARCHAR2_TABLE_100
1562: , p5_a36 out nocopy JTF_VARCHAR2_TABLE_100
1563: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
1565: , p5_a39 out nocopy JTF_DATE_TABLE
1566: , p5_a40 out nocopy JTF_DATE_TABLE
1567: , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100
1568: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100

Line 1567: , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100

1563: , p5_a37 out nocopy JTF_VARCHAR2_TABLE_100
1564: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
1565: , p5_a39 out nocopy JTF_DATE_TABLE
1566: , p5_a40 out nocopy JTF_DATE_TABLE
1567: , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100
1568: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 1568: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100

1564: , p5_a38 out nocopy JTF_VARCHAR2_TABLE_100
1565: , p5_a39 out nocopy JTF_DATE_TABLE
1566: , p5_a40 out nocopy JTF_DATE_TABLE
1567: , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100
1568: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 1571: , p5_a45 out nocopy JTF_VARCHAR2_TABLE_100

1567: , p5_a41 out nocopy JTF_VARCHAR2_TABLE_100
1568: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 1572: , p5_a46 out nocopy JTF_VARCHAR2_TABLE_100

1568: , p5_a42 out nocopy JTF_VARCHAR2_TABLE_100
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

Line 1576: , p5_a50 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
1580: , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100

Line 1577: , p5_a51 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
1580: , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100
1581: , p5_a55 out nocopy JTF_VARCHAR2_TABLE_100

Line 1580: , p5_a54 out nocopy JTF_VARCHAR2_TABLE_100

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
1584: , x_msg_data out nocopy VARCHAR2

Line 1581: , p5_a55 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
1584: , x_msg_data out nocopy VARCHAR2
1585: )

Line 1685: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100

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
1689: , p1_a0 in out nocopy JTF_NUMBER_TABLE

Line 1688: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100

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
1692: , p1_a3 in out nocopy JTF_NUMBER_TABLE

Line 1780: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
1784: , x_return_status out nocopy VARCHAR2

Line 1783: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

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
1787: , p_source_system_name VARCHAR2

Line 1850: , p2_a4 JTF_VARCHAR2_TABLE_100

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
1854: , p3_a0 out nocopy JTF_NUMBER_TABLE

Line 1853: , p2_a7 JTF_VARCHAR2_TABLE_100

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
1857: , p3_a3 out nocopy JTF_NUMBER_TABLE

Line 1990: , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100

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
1994: , p1_a0 in out nocopy JTF_NUMBER_TABLE

Line 1993: , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100

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
1997: , p1_a3 in out nocopy JTF_NUMBER_TABLE

Line 2089: , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100

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
2093: , p4_a7 in out nocopy JTF_DATE_TABLE

Line 2092: , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_100

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
2096: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 2096: , p4_a10 in out nocopy JTF_VARCHAR2_TABLE_100

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
2100: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100

Line 2098: , p4_a12 in out nocopy JTF_VARCHAR2_TABLE_100

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
2102: , p5_a0 in out nocopy NUMBER

Line 2100: , p4_a14 in out nocopy JTF_VARCHAR2_TABLE_100

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
2104: , p5_a2 in out nocopy DATE

Line 2101: , p4_a15 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
2104: , p5_a2 in out nocopy DATE
2105: , p5_a3 in out nocopy NUMBER

Line 2142: , p6_a0 in out nocopy JTF_VARCHAR2_TABLE_100

2138: , p5_a36 in out nocopy NUMBER
2139: , p5_a37 in out nocopy VARCHAR2
2140: , p5_a38 in out nocopy DATE
2141: , p5_a39 in out nocopy NUMBER
2142: , p6_a0 in out nocopy JTF_VARCHAR2_TABLE_100
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

Line 2143: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

2139: , p5_a37 in out nocopy VARCHAR2
2140: , p5_a38 in out nocopy DATE
2141: , p5_a39 in out nocopy NUMBER
2142: , p6_a0 in out nocopy JTF_VARCHAR2_TABLE_100
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

Line 2148: , p8_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
2152: , x_return_status out nocopy VARCHAR2

Line 2149: , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_100

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
2152: , x_return_status out nocopy VARCHAR2
2153: , x_msg_count out nocopy NUMBER

Line 2151: , p9_a1 in out nocopy JTF_VARCHAR2_TABLE_100

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
2155: )