31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_300
36: , a14 JTF_VARCHAR2_TABLE_300
37: ) as
38: ddindx binary_integer; indx binary_integer;
39: begin
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_300
36: , a14 JTF_VARCHAR2_TABLE_300
37: ) as
38: ddindx binary_integer; indx binary_integer;
39: begin
40: if a0 is not null and a0.count > 0 then
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_NUMBER_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_VARCHAR2_TABLE_100
82: , a13 out nocopy JTF_VARCHAR2_TABLE_300
83: , a14 out nocopy JTF_VARCHAR2_TABLE_300
84: ) as
85: ddindx binary_integer; indx binary_integer;
86: begin
79: , a10 out nocopy JTF_NUMBER_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_VARCHAR2_TABLE_100
82: , a13 out nocopy JTF_VARCHAR2_TABLE_300
83: , a14 out nocopy JTF_VARCHAR2_TABLE_300
84: ) as
85: ddindx binary_integer; indx binary_integer;
86: begin
87: if t is null or t.count = 0 then
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_VARCHAR2_TABLE_100();
101: a13 := JTF_VARCHAR2_TABLE_300();
102: a14 := JTF_VARCHAR2_TABLE_300();
103: else
104: a0 := JTF_VARCHAR2_TABLE_1000();
105: a1 := JTF_VARCHAR2_TABLE_100();
98: a10 := JTF_NUMBER_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_VARCHAR2_TABLE_100();
101: a13 := JTF_VARCHAR2_TABLE_300();
102: a14 := JTF_VARCHAR2_TABLE_300();
103: else
104: a0 := JTF_VARCHAR2_TABLE_1000();
105: a1 := JTF_VARCHAR2_TABLE_100();
106: a2 := JTF_VARCHAR2_TABLE_2000();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_VARCHAR2_TABLE_100();
117: a13 := JTF_VARCHAR2_TABLE_300();
118: a14 := JTF_VARCHAR2_TABLE_300();
119: if t.count > 0 then
120: a0.extend(t.count);
121: a1.extend(t.count);
114: a10 := JTF_NUMBER_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_VARCHAR2_TABLE_100();
117: a13 := JTF_VARCHAR2_TABLE_300();
118: a14 := JTF_VARCHAR2_TABLE_300();
119: if t.count > 0 then
120: a0.extend(t.count);
121: a1.extend(t.count);
122: a2.extend(t.count);
218: , p3_a9 out nocopy JTF_NUMBER_TABLE
219: , p3_a10 out nocopy JTF_NUMBER_TABLE
220: , p3_a11 out nocopy JTF_NUMBER_TABLE
221: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_300
223: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_300
224: )
225:
226: as
219: , p3_a10 out nocopy JTF_NUMBER_TABLE
220: , p3_a11 out nocopy JTF_NUMBER_TABLE
221: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_300
223: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_300
224: )
225:
226: as
227: ddx_result jtf_um_subscription_info.subscription_info_table;
278: , p5_a9 out nocopy JTF_NUMBER_TABLE
279: , p5_a10 out nocopy JTF_NUMBER_TABLE
280: , p5_a11 out nocopy JTF_NUMBER_TABLE
281: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
282: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
283: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
284: )
285:
286: as
279: , p5_a10 out nocopy JTF_NUMBER_TABLE
280: , p5_a11 out nocopy JTF_NUMBER_TABLE
281: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
282: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
283: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
284: )
285:
286: as
287: ddx_result jtf_um_subscription_info.subscription_info_table;
345: , p6_a9 out nocopy JTF_NUMBER_TABLE
346: , p6_a10 out nocopy JTF_NUMBER_TABLE
347: , p6_a11 out nocopy JTF_NUMBER_TABLE
348: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
350: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
351: )
352:
353: as
346: , p6_a10 out nocopy JTF_NUMBER_TABLE
347: , p6_a11 out nocopy JTF_NUMBER_TABLE
348: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
350: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
351: )
352:
353: as
354: ddp_sub_list jtf_um_subscription_info.subscription_list;
417: , p5_a9 out nocopy JTF_NUMBER_TABLE
418: , p5_a10 out nocopy JTF_NUMBER_TABLE
419: , p5_a11 out nocopy JTF_NUMBER_TABLE
420: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
422: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
423: )
424:
425: as
418: , p5_a10 out nocopy JTF_NUMBER_TABLE
419: , p5_a11 out nocopy JTF_NUMBER_TABLE
420: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
422: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
423: )
424:
425: as
426: ddp_sub_list jtf_um_subscription_info.subscription_list;