eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_PVT_W dependencies on JTF_NUMBER_TABLE

Line 25: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE

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 ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: ) as

Line 26: , a1 JTF_NUMBER_TABLE

22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: ) as
30: ddindx binary_integer; indx binary_integer;

Line 27: , a2 JTF_NUMBER_TABLE

23: end;
24:
25: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin

Line 28: , a3 JTF_NUMBER_TABLE

24:
25: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin
32: if a0 is not null and a0.count > 0 then

Line 50: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

46: end loop;
47: end if;
48: end if;
49: end rosetta_table_copy_in_p1;
50: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_NUMBER_TABLE
52: , a2 out nocopy JTF_NUMBER_TABLE
53: , a3 out nocopy JTF_NUMBER_TABLE
54: ) as

Line 51: , a1 out nocopy JTF_NUMBER_TABLE

47: end if;
48: end if;
49: end rosetta_table_copy_in_p1;
50: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_NUMBER_TABLE
52: , a2 out nocopy JTF_NUMBER_TABLE
53: , a3 out nocopy JTF_NUMBER_TABLE
54: ) as
55: ddindx binary_integer; indx binary_integer;

Line 52: , a2 out nocopy JTF_NUMBER_TABLE

48: end if;
49: end rosetta_table_copy_in_p1;
50: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_NUMBER_TABLE
52: , a2 out nocopy JTF_NUMBER_TABLE
53: , a3 out nocopy JTF_NUMBER_TABLE
54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin

Line 53: , a3 out nocopy JTF_NUMBER_TABLE

49: end rosetta_table_copy_in_p1;
50: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_NUMBER_TABLE
52: , a2 out nocopy JTF_NUMBER_TABLE
53: , a3 out nocopy JTF_NUMBER_TABLE
54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin
57: if t is null or t.count = 0 then

Line 58: a0 := JTF_NUMBER_TABLE();

54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin
57: if t is null or t.count = 0 then
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_NUMBER_TABLE();
60: a2 := JTF_NUMBER_TABLE();
61: a3 := JTF_NUMBER_TABLE();
62: else

Line 59: a1 := JTF_NUMBER_TABLE();

55: ddindx binary_integer; indx binary_integer;
56: begin
57: if t is null or t.count = 0 then
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_NUMBER_TABLE();
60: a2 := JTF_NUMBER_TABLE();
61: a3 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();

Line 60: a2 := JTF_NUMBER_TABLE();

56: begin
57: if t is null or t.count = 0 then
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_NUMBER_TABLE();
60: a2 := JTF_NUMBER_TABLE();
61: a3 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();

Line 61: a3 := JTF_NUMBER_TABLE();

57: if t is null or t.count = 0 then
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_NUMBER_TABLE();
60: a2 := JTF_NUMBER_TABLE();
61: a3 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();

Line 63: a0 := JTF_NUMBER_TABLE();

59: a1 := JTF_NUMBER_TABLE();
60: a2 := JTF_NUMBER_TABLE();
61: a3 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: if t.count > 0 then

Line 64: a1 := JTF_NUMBER_TABLE();

60: a2 := JTF_NUMBER_TABLE();
61: a3 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: if t.count > 0 then
68: a0.extend(t.count);

Line 65: a2 := JTF_NUMBER_TABLE();

61: a3 := JTF_NUMBER_TABLE();
62: else
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: if t.count > 0 then
68: a0.extend(t.count);
69: a1.extend(t.count);

Line 66: a3 := JTF_NUMBER_TABLE();

62: else
63: a0 := JTF_NUMBER_TABLE();
64: a1 := JTF_NUMBER_TABLE();
65: a2 := JTF_NUMBER_TABLE();
66: a3 := JTF_NUMBER_TABLE();
67: if t.count > 0 then
68: a0.extend(t.count);
69: a1.extend(t.count);
70: a2.extend(t.count);

Line 91: , a2 JTF_NUMBER_TABLE

87: end rosetta_table_copy_out_p1;
88:
89: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pvt.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
90: , a1 JTF_VARCHAR2_TABLE_100
91: , a2 JTF_NUMBER_TABLE
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_NUMBER_TABLE
94: , a5 JTF_VARCHAR2_TABLE_100
95: , a6 JTF_NUMBER_TABLE

Line 93: , a4 JTF_NUMBER_TABLE

89: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pvt.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
90: , a1 JTF_VARCHAR2_TABLE_100
91: , a2 JTF_NUMBER_TABLE
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_NUMBER_TABLE
94: , a5 JTF_VARCHAR2_TABLE_100
95: , a6 JTF_NUMBER_TABLE
96: , a7 JTF_DATE_TABLE
97: , a8 JTF_DATE_TABLE

Line 95: , a6 JTF_NUMBER_TABLE

91: , a2 JTF_NUMBER_TABLE
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_NUMBER_TABLE
94: , a5 JTF_VARCHAR2_TABLE_100
95: , a6 JTF_NUMBER_TABLE
96: , a7 JTF_DATE_TABLE
97: , a8 JTF_DATE_TABLE
98: , a9 JTF_VARCHAR2_TABLE_100
99: , a10 JTF_VARCHAR2_TABLE_100

Line 100: , a11 JTF_NUMBER_TABLE

96: , a7 JTF_DATE_TABLE
97: , a8 JTF_DATE_TABLE
98: , a9 JTF_VARCHAR2_TABLE_100
99: , a10 JTF_VARCHAR2_TABLE_100
100: , a11 JTF_NUMBER_TABLE
101: , a12 JTF_VARCHAR2_TABLE_100
102: , a13 JTF_NUMBER_TABLE
103: , a14 JTF_NUMBER_TABLE
104: , a15 JTF_VARCHAR2_TABLE_100

Line 102: , a13 JTF_NUMBER_TABLE

98: , a9 JTF_VARCHAR2_TABLE_100
99: , a10 JTF_VARCHAR2_TABLE_100
100: , a11 JTF_NUMBER_TABLE
101: , a12 JTF_VARCHAR2_TABLE_100
102: , a13 JTF_NUMBER_TABLE
103: , a14 JTF_NUMBER_TABLE
104: , a15 JTF_VARCHAR2_TABLE_100
105: , a16 JTF_NUMBER_TABLE
106: , a17 JTF_VARCHAR2_TABLE_100

Line 103: , a14 JTF_NUMBER_TABLE

99: , a10 JTF_VARCHAR2_TABLE_100
100: , a11 JTF_NUMBER_TABLE
101: , a12 JTF_VARCHAR2_TABLE_100
102: , a13 JTF_NUMBER_TABLE
103: , a14 JTF_NUMBER_TABLE
104: , a15 JTF_VARCHAR2_TABLE_100
105: , a16 JTF_NUMBER_TABLE
106: , a17 JTF_VARCHAR2_TABLE_100
107: , a18 JTF_NUMBER_TABLE

Line 105: , a16 JTF_NUMBER_TABLE

101: , a12 JTF_VARCHAR2_TABLE_100
102: , a13 JTF_NUMBER_TABLE
103: , a14 JTF_NUMBER_TABLE
104: , a15 JTF_VARCHAR2_TABLE_100
105: , a16 JTF_NUMBER_TABLE
106: , a17 JTF_VARCHAR2_TABLE_100
107: , a18 JTF_NUMBER_TABLE
108: , a19 JTF_NUMBER_TABLE
109: , a20 JTF_NUMBER_TABLE

Line 107: , a18 JTF_NUMBER_TABLE

103: , a14 JTF_NUMBER_TABLE
104: , a15 JTF_VARCHAR2_TABLE_100
105: , a16 JTF_NUMBER_TABLE
106: , a17 JTF_VARCHAR2_TABLE_100
107: , a18 JTF_NUMBER_TABLE
108: , a19 JTF_NUMBER_TABLE
109: , a20 JTF_NUMBER_TABLE
110: , a21 JTF_NUMBER_TABLE
111: , a22 JTF_VARCHAR2_TABLE_100

Line 108: , a19 JTF_NUMBER_TABLE

104: , a15 JTF_VARCHAR2_TABLE_100
105: , a16 JTF_NUMBER_TABLE
106: , a17 JTF_VARCHAR2_TABLE_100
107: , a18 JTF_NUMBER_TABLE
108: , a19 JTF_NUMBER_TABLE
109: , a20 JTF_NUMBER_TABLE
110: , a21 JTF_NUMBER_TABLE
111: , a22 JTF_VARCHAR2_TABLE_100
112: , a23 JTF_VARCHAR2_TABLE_100

Line 109: , a20 JTF_NUMBER_TABLE

105: , a16 JTF_NUMBER_TABLE
106: , a17 JTF_VARCHAR2_TABLE_100
107: , a18 JTF_NUMBER_TABLE
108: , a19 JTF_NUMBER_TABLE
109: , a20 JTF_NUMBER_TABLE
110: , a21 JTF_NUMBER_TABLE
111: , a22 JTF_VARCHAR2_TABLE_100
112: , a23 JTF_VARCHAR2_TABLE_100
113: , a24 JTF_VARCHAR2_TABLE_100

Line 110: , a21 JTF_NUMBER_TABLE

106: , a17 JTF_VARCHAR2_TABLE_100
107: , a18 JTF_NUMBER_TABLE
108: , a19 JTF_NUMBER_TABLE
109: , a20 JTF_NUMBER_TABLE
110: , a21 JTF_NUMBER_TABLE
111: , a22 JTF_VARCHAR2_TABLE_100
112: , a23 JTF_VARCHAR2_TABLE_100
113: , a24 JTF_VARCHAR2_TABLE_100
114: , a25 JTF_VARCHAR2_TABLE_300

Line 116: , a27 JTF_NUMBER_TABLE

112: , a23 JTF_VARCHAR2_TABLE_100
113: , a24 JTF_VARCHAR2_TABLE_100
114: , a25 JTF_VARCHAR2_TABLE_300
115: , a26 JTF_VARCHAR2_TABLE_100
116: , a27 JTF_NUMBER_TABLE
117: , a28 JTF_VARCHAR2_TABLE_100
118: , a29 JTF_VARCHAR2_TABLE_100
119: , a30 JTF_VARCHAR2_TABLE_300
120: , a31 JTF_VARCHAR2_TABLE_100

Line 128: , a39 JTF_NUMBER_TABLE

124: , a35 JTF_VARCHAR2_TABLE_300
125: , a36 JTF_VARCHAR2_TABLE_100
126: , a37 JTF_VARCHAR2_TABLE_300
127: , a38 JTF_VARCHAR2_TABLE_300
128: , a39 JTF_NUMBER_TABLE
129: , a40 JTF_VARCHAR2_TABLE_2000
130: , a41 JTF_VARCHAR2_TABLE_100
131: , a42 JTF_VARCHAR2_TABLE_300
132: , a43 JTF_VARCHAR2_TABLE_300

Line 146: , a57 JTF_NUMBER_TABLE

142: , a53 JTF_VARCHAR2_TABLE_300
143: , a54 JTF_VARCHAR2_TABLE_300
144: , a55 JTF_VARCHAR2_TABLE_300
145: , a56 JTF_VARCHAR2_TABLE_300
146: , a57 JTF_NUMBER_TABLE
147: , a58 JTF_NUMBER_TABLE
148: , a59 JTF_NUMBER_TABLE
149: , a60 JTF_NUMBER_TABLE
150: , a61 JTF_NUMBER_TABLE

Line 147: , a58 JTF_NUMBER_TABLE

143: , a54 JTF_VARCHAR2_TABLE_300
144: , a55 JTF_VARCHAR2_TABLE_300
145: , a56 JTF_VARCHAR2_TABLE_300
146: , a57 JTF_NUMBER_TABLE
147: , a58 JTF_NUMBER_TABLE
148: , a59 JTF_NUMBER_TABLE
149: , a60 JTF_NUMBER_TABLE
150: , a61 JTF_NUMBER_TABLE
151: , a62 JTF_NUMBER_TABLE

Line 148: , a59 JTF_NUMBER_TABLE

144: , a55 JTF_VARCHAR2_TABLE_300
145: , a56 JTF_VARCHAR2_TABLE_300
146: , a57 JTF_NUMBER_TABLE
147: , a58 JTF_NUMBER_TABLE
148: , a59 JTF_NUMBER_TABLE
149: , a60 JTF_NUMBER_TABLE
150: , a61 JTF_NUMBER_TABLE
151: , a62 JTF_NUMBER_TABLE
152: , a63 JTF_NUMBER_TABLE

Line 149: , a60 JTF_NUMBER_TABLE

145: , a56 JTF_VARCHAR2_TABLE_300
146: , a57 JTF_NUMBER_TABLE
147: , a58 JTF_NUMBER_TABLE
148: , a59 JTF_NUMBER_TABLE
149: , a60 JTF_NUMBER_TABLE
150: , a61 JTF_NUMBER_TABLE
151: , a62 JTF_NUMBER_TABLE
152: , a63 JTF_NUMBER_TABLE
153: , a64 JTF_NUMBER_TABLE

Line 150: , a61 JTF_NUMBER_TABLE

146: , a57 JTF_NUMBER_TABLE
147: , a58 JTF_NUMBER_TABLE
148: , a59 JTF_NUMBER_TABLE
149: , a60 JTF_NUMBER_TABLE
150: , a61 JTF_NUMBER_TABLE
151: , a62 JTF_NUMBER_TABLE
152: , a63 JTF_NUMBER_TABLE
153: , a64 JTF_NUMBER_TABLE
154: , a65 JTF_NUMBER_TABLE

Line 151: , a62 JTF_NUMBER_TABLE

147: , a58 JTF_NUMBER_TABLE
148: , a59 JTF_NUMBER_TABLE
149: , a60 JTF_NUMBER_TABLE
150: , a61 JTF_NUMBER_TABLE
151: , a62 JTF_NUMBER_TABLE
152: , a63 JTF_NUMBER_TABLE
153: , a64 JTF_NUMBER_TABLE
154: , a65 JTF_NUMBER_TABLE
155: , a66 JTF_NUMBER_TABLE

Line 152: , a63 JTF_NUMBER_TABLE

148: , a59 JTF_NUMBER_TABLE
149: , a60 JTF_NUMBER_TABLE
150: , a61 JTF_NUMBER_TABLE
151: , a62 JTF_NUMBER_TABLE
152: , a63 JTF_NUMBER_TABLE
153: , a64 JTF_NUMBER_TABLE
154: , a65 JTF_NUMBER_TABLE
155: , a66 JTF_NUMBER_TABLE
156: , a67 JTF_VARCHAR2_TABLE_100

Line 153: , a64 JTF_NUMBER_TABLE

149: , a60 JTF_NUMBER_TABLE
150: , a61 JTF_NUMBER_TABLE
151: , a62 JTF_NUMBER_TABLE
152: , a63 JTF_NUMBER_TABLE
153: , a64 JTF_NUMBER_TABLE
154: , a65 JTF_NUMBER_TABLE
155: , a66 JTF_NUMBER_TABLE
156: , a67 JTF_VARCHAR2_TABLE_100
157: , a68 JTF_NUMBER_TABLE

Line 154: , a65 JTF_NUMBER_TABLE

150: , a61 JTF_NUMBER_TABLE
151: , a62 JTF_NUMBER_TABLE
152: , a63 JTF_NUMBER_TABLE
153: , a64 JTF_NUMBER_TABLE
154: , a65 JTF_NUMBER_TABLE
155: , a66 JTF_NUMBER_TABLE
156: , a67 JTF_VARCHAR2_TABLE_100
157: , a68 JTF_NUMBER_TABLE
158: , a69 JTF_NUMBER_TABLE

Line 155: , a66 JTF_NUMBER_TABLE

151: , a62 JTF_NUMBER_TABLE
152: , a63 JTF_NUMBER_TABLE
153: , a64 JTF_NUMBER_TABLE
154: , a65 JTF_NUMBER_TABLE
155: , a66 JTF_NUMBER_TABLE
156: , a67 JTF_VARCHAR2_TABLE_100
157: , a68 JTF_NUMBER_TABLE
158: , a69 JTF_NUMBER_TABLE
159: , a70 JTF_VARCHAR2_TABLE_300

Line 157: , a68 JTF_NUMBER_TABLE

153: , a64 JTF_NUMBER_TABLE
154: , a65 JTF_NUMBER_TABLE
155: , a66 JTF_NUMBER_TABLE
156: , a67 JTF_VARCHAR2_TABLE_100
157: , a68 JTF_NUMBER_TABLE
158: , a69 JTF_NUMBER_TABLE
159: , a70 JTF_VARCHAR2_TABLE_300
160: , a71 JTF_VARCHAR2_TABLE_300
161: , a72 JTF_VARCHAR2_TABLE_300

Line 158: , a69 JTF_NUMBER_TABLE

154: , a65 JTF_NUMBER_TABLE
155: , a66 JTF_NUMBER_TABLE
156: , a67 JTF_VARCHAR2_TABLE_100
157: , a68 JTF_NUMBER_TABLE
158: , a69 JTF_NUMBER_TABLE
159: , a70 JTF_VARCHAR2_TABLE_300
160: , a71 JTF_VARCHAR2_TABLE_300
161: , a72 JTF_VARCHAR2_TABLE_300
162: ) as

Line 254: , a2 out nocopy JTF_NUMBER_TABLE

250: end if;
251: end rosetta_table_copy_in_p4;
252: procedure rosetta_table_copy_out_p4(t ozf_offer_pvt.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
253: , a1 out nocopy JTF_VARCHAR2_TABLE_100
254: , a2 out nocopy JTF_NUMBER_TABLE
255: , a3 out nocopy JTF_VARCHAR2_TABLE_100
256: , a4 out nocopy JTF_NUMBER_TABLE
257: , a5 out nocopy JTF_VARCHAR2_TABLE_100
258: , a6 out nocopy JTF_NUMBER_TABLE

Line 256: , a4 out nocopy JTF_NUMBER_TABLE

252: procedure rosetta_table_copy_out_p4(t ozf_offer_pvt.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
253: , a1 out nocopy JTF_VARCHAR2_TABLE_100
254: , a2 out nocopy JTF_NUMBER_TABLE
255: , a3 out nocopy JTF_VARCHAR2_TABLE_100
256: , a4 out nocopy JTF_NUMBER_TABLE
257: , a5 out nocopy JTF_VARCHAR2_TABLE_100
258: , a6 out nocopy JTF_NUMBER_TABLE
259: , a7 out nocopy JTF_DATE_TABLE
260: , a8 out nocopy JTF_DATE_TABLE

Line 258: , a6 out nocopy JTF_NUMBER_TABLE

254: , a2 out nocopy JTF_NUMBER_TABLE
255: , a3 out nocopy JTF_VARCHAR2_TABLE_100
256: , a4 out nocopy JTF_NUMBER_TABLE
257: , a5 out nocopy JTF_VARCHAR2_TABLE_100
258: , a6 out nocopy JTF_NUMBER_TABLE
259: , a7 out nocopy JTF_DATE_TABLE
260: , a8 out nocopy JTF_DATE_TABLE
261: , a9 out nocopy JTF_VARCHAR2_TABLE_100
262: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 263: , a11 out nocopy JTF_NUMBER_TABLE

259: , a7 out nocopy JTF_DATE_TABLE
260: , a8 out nocopy JTF_DATE_TABLE
261: , a9 out nocopy JTF_VARCHAR2_TABLE_100
262: , a10 out nocopy JTF_VARCHAR2_TABLE_100
263: , a11 out nocopy JTF_NUMBER_TABLE
264: , a12 out nocopy JTF_VARCHAR2_TABLE_100
265: , a13 out nocopy JTF_NUMBER_TABLE
266: , a14 out nocopy JTF_NUMBER_TABLE
267: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 265: , a13 out nocopy JTF_NUMBER_TABLE

261: , a9 out nocopy JTF_VARCHAR2_TABLE_100
262: , a10 out nocopy JTF_VARCHAR2_TABLE_100
263: , a11 out nocopy JTF_NUMBER_TABLE
264: , a12 out nocopy JTF_VARCHAR2_TABLE_100
265: , a13 out nocopy JTF_NUMBER_TABLE
266: , a14 out nocopy JTF_NUMBER_TABLE
267: , a15 out nocopy JTF_VARCHAR2_TABLE_100
268: , a16 out nocopy JTF_NUMBER_TABLE
269: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 266: , a14 out nocopy JTF_NUMBER_TABLE

262: , a10 out nocopy JTF_VARCHAR2_TABLE_100
263: , a11 out nocopy JTF_NUMBER_TABLE
264: , a12 out nocopy JTF_VARCHAR2_TABLE_100
265: , a13 out nocopy JTF_NUMBER_TABLE
266: , a14 out nocopy JTF_NUMBER_TABLE
267: , a15 out nocopy JTF_VARCHAR2_TABLE_100
268: , a16 out nocopy JTF_NUMBER_TABLE
269: , a17 out nocopy JTF_VARCHAR2_TABLE_100
270: , a18 out nocopy JTF_NUMBER_TABLE

Line 268: , a16 out nocopy JTF_NUMBER_TABLE

264: , a12 out nocopy JTF_VARCHAR2_TABLE_100
265: , a13 out nocopy JTF_NUMBER_TABLE
266: , a14 out nocopy JTF_NUMBER_TABLE
267: , a15 out nocopy JTF_VARCHAR2_TABLE_100
268: , a16 out nocopy JTF_NUMBER_TABLE
269: , a17 out nocopy JTF_VARCHAR2_TABLE_100
270: , a18 out nocopy JTF_NUMBER_TABLE
271: , a19 out nocopy JTF_NUMBER_TABLE
272: , a20 out nocopy JTF_NUMBER_TABLE

Line 270: , a18 out nocopy JTF_NUMBER_TABLE

266: , a14 out nocopy JTF_NUMBER_TABLE
267: , a15 out nocopy JTF_VARCHAR2_TABLE_100
268: , a16 out nocopy JTF_NUMBER_TABLE
269: , a17 out nocopy JTF_VARCHAR2_TABLE_100
270: , a18 out nocopy JTF_NUMBER_TABLE
271: , a19 out nocopy JTF_NUMBER_TABLE
272: , a20 out nocopy JTF_NUMBER_TABLE
273: , a21 out nocopy JTF_NUMBER_TABLE
274: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 271: , a19 out nocopy JTF_NUMBER_TABLE

267: , a15 out nocopy JTF_VARCHAR2_TABLE_100
268: , a16 out nocopy JTF_NUMBER_TABLE
269: , a17 out nocopy JTF_VARCHAR2_TABLE_100
270: , a18 out nocopy JTF_NUMBER_TABLE
271: , a19 out nocopy JTF_NUMBER_TABLE
272: , a20 out nocopy JTF_NUMBER_TABLE
273: , a21 out nocopy JTF_NUMBER_TABLE
274: , a22 out nocopy JTF_VARCHAR2_TABLE_100
275: , a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 272: , a20 out nocopy JTF_NUMBER_TABLE

268: , a16 out nocopy JTF_NUMBER_TABLE
269: , a17 out nocopy JTF_VARCHAR2_TABLE_100
270: , a18 out nocopy JTF_NUMBER_TABLE
271: , a19 out nocopy JTF_NUMBER_TABLE
272: , a20 out nocopy JTF_NUMBER_TABLE
273: , a21 out nocopy JTF_NUMBER_TABLE
274: , a22 out nocopy JTF_VARCHAR2_TABLE_100
275: , a23 out nocopy JTF_VARCHAR2_TABLE_100
276: , a24 out nocopy JTF_VARCHAR2_TABLE_100

Line 273: , a21 out nocopy JTF_NUMBER_TABLE

269: , a17 out nocopy JTF_VARCHAR2_TABLE_100
270: , a18 out nocopy JTF_NUMBER_TABLE
271: , a19 out nocopy JTF_NUMBER_TABLE
272: , a20 out nocopy JTF_NUMBER_TABLE
273: , a21 out nocopy JTF_NUMBER_TABLE
274: , a22 out nocopy JTF_VARCHAR2_TABLE_100
275: , a23 out nocopy JTF_VARCHAR2_TABLE_100
276: , a24 out nocopy JTF_VARCHAR2_TABLE_100
277: , a25 out nocopy JTF_VARCHAR2_TABLE_300

Line 279: , a27 out nocopy JTF_NUMBER_TABLE

275: , a23 out nocopy JTF_VARCHAR2_TABLE_100
276: , a24 out nocopy JTF_VARCHAR2_TABLE_100
277: , a25 out nocopy JTF_VARCHAR2_TABLE_300
278: , a26 out nocopy JTF_VARCHAR2_TABLE_100
279: , a27 out nocopy JTF_NUMBER_TABLE
280: , a28 out nocopy JTF_VARCHAR2_TABLE_100
281: , a29 out nocopy JTF_VARCHAR2_TABLE_100
282: , a30 out nocopy JTF_VARCHAR2_TABLE_300
283: , a31 out nocopy JTF_VARCHAR2_TABLE_100

Line 291: , a39 out nocopy JTF_NUMBER_TABLE

287: , a35 out nocopy JTF_VARCHAR2_TABLE_300
288: , a36 out nocopy JTF_VARCHAR2_TABLE_100
289: , a37 out nocopy JTF_VARCHAR2_TABLE_300
290: , a38 out nocopy JTF_VARCHAR2_TABLE_300
291: , a39 out nocopy JTF_NUMBER_TABLE
292: , a40 out nocopy JTF_VARCHAR2_TABLE_2000
293: , a41 out nocopy JTF_VARCHAR2_TABLE_100
294: , a42 out nocopy JTF_VARCHAR2_TABLE_300
295: , a43 out nocopy JTF_VARCHAR2_TABLE_300

Line 309: , a57 out nocopy JTF_NUMBER_TABLE

305: , a53 out nocopy JTF_VARCHAR2_TABLE_300
306: , a54 out nocopy JTF_VARCHAR2_TABLE_300
307: , a55 out nocopy JTF_VARCHAR2_TABLE_300
308: , a56 out nocopy JTF_VARCHAR2_TABLE_300
309: , a57 out nocopy JTF_NUMBER_TABLE
310: , a58 out nocopy JTF_NUMBER_TABLE
311: , a59 out nocopy JTF_NUMBER_TABLE
312: , a60 out nocopy JTF_NUMBER_TABLE
313: , a61 out nocopy JTF_NUMBER_TABLE

Line 310: , a58 out nocopy JTF_NUMBER_TABLE

306: , a54 out nocopy JTF_VARCHAR2_TABLE_300
307: , a55 out nocopy JTF_VARCHAR2_TABLE_300
308: , a56 out nocopy JTF_VARCHAR2_TABLE_300
309: , a57 out nocopy JTF_NUMBER_TABLE
310: , a58 out nocopy JTF_NUMBER_TABLE
311: , a59 out nocopy JTF_NUMBER_TABLE
312: , a60 out nocopy JTF_NUMBER_TABLE
313: , a61 out nocopy JTF_NUMBER_TABLE
314: , a62 out nocopy JTF_NUMBER_TABLE

Line 311: , a59 out nocopy JTF_NUMBER_TABLE

307: , a55 out nocopy JTF_VARCHAR2_TABLE_300
308: , a56 out nocopy JTF_VARCHAR2_TABLE_300
309: , a57 out nocopy JTF_NUMBER_TABLE
310: , a58 out nocopy JTF_NUMBER_TABLE
311: , a59 out nocopy JTF_NUMBER_TABLE
312: , a60 out nocopy JTF_NUMBER_TABLE
313: , a61 out nocopy JTF_NUMBER_TABLE
314: , a62 out nocopy JTF_NUMBER_TABLE
315: , a63 out nocopy JTF_NUMBER_TABLE

Line 312: , a60 out nocopy JTF_NUMBER_TABLE

308: , a56 out nocopy JTF_VARCHAR2_TABLE_300
309: , a57 out nocopy JTF_NUMBER_TABLE
310: , a58 out nocopy JTF_NUMBER_TABLE
311: , a59 out nocopy JTF_NUMBER_TABLE
312: , a60 out nocopy JTF_NUMBER_TABLE
313: , a61 out nocopy JTF_NUMBER_TABLE
314: , a62 out nocopy JTF_NUMBER_TABLE
315: , a63 out nocopy JTF_NUMBER_TABLE
316: , a64 out nocopy JTF_NUMBER_TABLE

Line 313: , a61 out nocopy JTF_NUMBER_TABLE

309: , a57 out nocopy JTF_NUMBER_TABLE
310: , a58 out nocopy JTF_NUMBER_TABLE
311: , a59 out nocopy JTF_NUMBER_TABLE
312: , a60 out nocopy JTF_NUMBER_TABLE
313: , a61 out nocopy JTF_NUMBER_TABLE
314: , a62 out nocopy JTF_NUMBER_TABLE
315: , a63 out nocopy JTF_NUMBER_TABLE
316: , a64 out nocopy JTF_NUMBER_TABLE
317: , a65 out nocopy JTF_NUMBER_TABLE

Line 314: , a62 out nocopy JTF_NUMBER_TABLE

310: , a58 out nocopy JTF_NUMBER_TABLE
311: , a59 out nocopy JTF_NUMBER_TABLE
312: , a60 out nocopy JTF_NUMBER_TABLE
313: , a61 out nocopy JTF_NUMBER_TABLE
314: , a62 out nocopy JTF_NUMBER_TABLE
315: , a63 out nocopy JTF_NUMBER_TABLE
316: , a64 out nocopy JTF_NUMBER_TABLE
317: , a65 out nocopy JTF_NUMBER_TABLE
318: , a66 out nocopy JTF_NUMBER_TABLE

Line 315: , a63 out nocopy JTF_NUMBER_TABLE

311: , a59 out nocopy JTF_NUMBER_TABLE
312: , a60 out nocopy JTF_NUMBER_TABLE
313: , a61 out nocopy JTF_NUMBER_TABLE
314: , a62 out nocopy JTF_NUMBER_TABLE
315: , a63 out nocopy JTF_NUMBER_TABLE
316: , a64 out nocopy JTF_NUMBER_TABLE
317: , a65 out nocopy JTF_NUMBER_TABLE
318: , a66 out nocopy JTF_NUMBER_TABLE
319: , a67 out nocopy JTF_VARCHAR2_TABLE_100

Line 316: , a64 out nocopy JTF_NUMBER_TABLE

312: , a60 out nocopy JTF_NUMBER_TABLE
313: , a61 out nocopy JTF_NUMBER_TABLE
314: , a62 out nocopy JTF_NUMBER_TABLE
315: , a63 out nocopy JTF_NUMBER_TABLE
316: , a64 out nocopy JTF_NUMBER_TABLE
317: , a65 out nocopy JTF_NUMBER_TABLE
318: , a66 out nocopy JTF_NUMBER_TABLE
319: , a67 out nocopy JTF_VARCHAR2_TABLE_100
320: , a68 out nocopy JTF_NUMBER_TABLE

Line 317: , a65 out nocopy JTF_NUMBER_TABLE

313: , a61 out nocopy JTF_NUMBER_TABLE
314: , a62 out nocopy JTF_NUMBER_TABLE
315: , a63 out nocopy JTF_NUMBER_TABLE
316: , a64 out nocopy JTF_NUMBER_TABLE
317: , a65 out nocopy JTF_NUMBER_TABLE
318: , a66 out nocopy JTF_NUMBER_TABLE
319: , a67 out nocopy JTF_VARCHAR2_TABLE_100
320: , a68 out nocopy JTF_NUMBER_TABLE
321: , a69 out nocopy JTF_NUMBER_TABLE

Line 318: , a66 out nocopy JTF_NUMBER_TABLE

314: , a62 out nocopy JTF_NUMBER_TABLE
315: , a63 out nocopy JTF_NUMBER_TABLE
316: , a64 out nocopy JTF_NUMBER_TABLE
317: , a65 out nocopy JTF_NUMBER_TABLE
318: , a66 out nocopy JTF_NUMBER_TABLE
319: , a67 out nocopy JTF_VARCHAR2_TABLE_100
320: , a68 out nocopy JTF_NUMBER_TABLE
321: , a69 out nocopy JTF_NUMBER_TABLE
322: , a70 out nocopy JTF_VARCHAR2_TABLE_300

Line 320: , a68 out nocopy JTF_NUMBER_TABLE

316: , a64 out nocopy JTF_NUMBER_TABLE
317: , a65 out nocopy JTF_NUMBER_TABLE
318: , a66 out nocopy JTF_NUMBER_TABLE
319: , a67 out nocopy JTF_VARCHAR2_TABLE_100
320: , a68 out nocopy JTF_NUMBER_TABLE
321: , a69 out nocopy JTF_NUMBER_TABLE
322: , a70 out nocopy JTF_VARCHAR2_TABLE_300
323: , a71 out nocopy JTF_VARCHAR2_TABLE_300
324: , a72 out nocopy JTF_VARCHAR2_TABLE_300

Line 321: , a69 out nocopy JTF_NUMBER_TABLE

317: , a65 out nocopy JTF_NUMBER_TABLE
318: , a66 out nocopy JTF_NUMBER_TABLE
319: , a67 out nocopy JTF_VARCHAR2_TABLE_100
320: , a68 out nocopy JTF_NUMBER_TABLE
321: , a69 out nocopy JTF_NUMBER_TABLE
322: , a70 out nocopy JTF_VARCHAR2_TABLE_300
323: , a71 out nocopy JTF_VARCHAR2_TABLE_300
324: , a72 out nocopy JTF_VARCHAR2_TABLE_300
325: ) as

Line 331: a2 := JTF_NUMBER_TABLE();

327: begin
328: if t is null or t.count = 0 then
329: a0 := JTF_VARCHAR2_TABLE_100();
330: a1 := JTF_VARCHAR2_TABLE_100();
331: a2 := JTF_NUMBER_TABLE();
332: a3 := JTF_VARCHAR2_TABLE_100();
333: a4 := JTF_NUMBER_TABLE();
334: a5 := JTF_VARCHAR2_TABLE_100();
335: a6 := JTF_NUMBER_TABLE();

Line 333: a4 := JTF_NUMBER_TABLE();

329: a0 := JTF_VARCHAR2_TABLE_100();
330: a1 := JTF_VARCHAR2_TABLE_100();
331: a2 := JTF_NUMBER_TABLE();
332: a3 := JTF_VARCHAR2_TABLE_100();
333: a4 := JTF_NUMBER_TABLE();
334: a5 := JTF_VARCHAR2_TABLE_100();
335: a6 := JTF_NUMBER_TABLE();
336: a7 := JTF_DATE_TABLE();
337: a8 := JTF_DATE_TABLE();

Line 335: a6 := JTF_NUMBER_TABLE();

331: a2 := JTF_NUMBER_TABLE();
332: a3 := JTF_VARCHAR2_TABLE_100();
333: a4 := JTF_NUMBER_TABLE();
334: a5 := JTF_VARCHAR2_TABLE_100();
335: a6 := JTF_NUMBER_TABLE();
336: a7 := JTF_DATE_TABLE();
337: a8 := JTF_DATE_TABLE();
338: a9 := JTF_VARCHAR2_TABLE_100();
339: a10 := JTF_VARCHAR2_TABLE_100();

Line 340: a11 := JTF_NUMBER_TABLE();

336: a7 := JTF_DATE_TABLE();
337: a8 := JTF_DATE_TABLE();
338: a9 := JTF_VARCHAR2_TABLE_100();
339: a10 := JTF_VARCHAR2_TABLE_100();
340: a11 := JTF_NUMBER_TABLE();
341: a12 := JTF_VARCHAR2_TABLE_100();
342: a13 := JTF_NUMBER_TABLE();
343: a14 := JTF_NUMBER_TABLE();
344: a15 := JTF_VARCHAR2_TABLE_100();

Line 342: a13 := JTF_NUMBER_TABLE();

338: a9 := JTF_VARCHAR2_TABLE_100();
339: a10 := JTF_VARCHAR2_TABLE_100();
340: a11 := JTF_NUMBER_TABLE();
341: a12 := JTF_VARCHAR2_TABLE_100();
342: a13 := JTF_NUMBER_TABLE();
343: a14 := JTF_NUMBER_TABLE();
344: a15 := JTF_VARCHAR2_TABLE_100();
345: a16 := JTF_NUMBER_TABLE();
346: a17 := JTF_VARCHAR2_TABLE_100();

Line 343: a14 := JTF_NUMBER_TABLE();

339: a10 := JTF_VARCHAR2_TABLE_100();
340: a11 := JTF_NUMBER_TABLE();
341: a12 := JTF_VARCHAR2_TABLE_100();
342: a13 := JTF_NUMBER_TABLE();
343: a14 := JTF_NUMBER_TABLE();
344: a15 := JTF_VARCHAR2_TABLE_100();
345: a16 := JTF_NUMBER_TABLE();
346: a17 := JTF_VARCHAR2_TABLE_100();
347: a18 := JTF_NUMBER_TABLE();

Line 345: a16 := JTF_NUMBER_TABLE();

341: a12 := JTF_VARCHAR2_TABLE_100();
342: a13 := JTF_NUMBER_TABLE();
343: a14 := JTF_NUMBER_TABLE();
344: a15 := JTF_VARCHAR2_TABLE_100();
345: a16 := JTF_NUMBER_TABLE();
346: a17 := JTF_VARCHAR2_TABLE_100();
347: a18 := JTF_NUMBER_TABLE();
348: a19 := JTF_NUMBER_TABLE();
349: a20 := JTF_NUMBER_TABLE();

Line 347: a18 := JTF_NUMBER_TABLE();

343: a14 := JTF_NUMBER_TABLE();
344: a15 := JTF_VARCHAR2_TABLE_100();
345: a16 := JTF_NUMBER_TABLE();
346: a17 := JTF_VARCHAR2_TABLE_100();
347: a18 := JTF_NUMBER_TABLE();
348: a19 := JTF_NUMBER_TABLE();
349: a20 := JTF_NUMBER_TABLE();
350: a21 := JTF_NUMBER_TABLE();
351: a22 := JTF_VARCHAR2_TABLE_100();

Line 348: a19 := JTF_NUMBER_TABLE();

344: a15 := JTF_VARCHAR2_TABLE_100();
345: a16 := JTF_NUMBER_TABLE();
346: a17 := JTF_VARCHAR2_TABLE_100();
347: a18 := JTF_NUMBER_TABLE();
348: a19 := JTF_NUMBER_TABLE();
349: a20 := JTF_NUMBER_TABLE();
350: a21 := JTF_NUMBER_TABLE();
351: a22 := JTF_VARCHAR2_TABLE_100();
352: a23 := JTF_VARCHAR2_TABLE_100();

Line 349: a20 := JTF_NUMBER_TABLE();

345: a16 := JTF_NUMBER_TABLE();
346: a17 := JTF_VARCHAR2_TABLE_100();
347: a18 := JTF_NUMBER_TABLE();
348: a19 := JTF_NUMBER_TABLE();
349: a20 := JTF_NUMBER_TABLE();
350: a21 := JTF_NUMBER_TABLE();
351: a22 := JTF_VARCHAR2_TABLE_100();
352: a23 := JTF_VARCHAR2_TABLE_100();
353: a24 := JTF_VARCHAR2_TABLE_100();

Line 350: a21 := JTF_NUMBER_TABLE();

346: a17 := JTF_VARCHAR2_TABLE_100();
347: a18 := JTF_NUMBER_TABLE();
348: a19 := JTF_NUMBER_TABLE();
349: a20 := JTF_NUMBER_TABLE();
350: a21 := JTF_NUMBER_TABLE();
351: a22 := JTF_VARCHAR2_TABLE_100();
352: a23 := JTF_VARCHAR2_TABLE_100();
353: a24 := JTF_VARCHAR2_TABLE_100();
354: a25 := JTF_VARCHAR2_TABLE_300();

Line 356: a27 := JTF_NUMBER_TABLE();

352: a23 := JTF_VARCHAR2_TABLE_100();
353: a24 := JTF_VARCHAR2_TABLE_100();
354: a25 := JTF_VARCHAR2_TABLE_300();
355: a26 := JTF_VARCHAR2_TABLE_100();
356: a27 := JTF_NUMBER_TABLE();
357: a28 := JTF_VARCHAR2_TABLE_100();
358: a29 := JTF_VARCHAR2_TABLE_100();
359: a30 := JTF_VARCHAR2_TABLE_300();
360: a31 := JTF_VARCHAR2_TABLE_100();

Line 368: a39 := JTF_NUMBER_TABLE();

364: a35 := JTF_VARCHAR2_TABLE_300();
365: a36 := JTF_VARCHAR2_TABLE_100();
366: a37 := JTF_VARCHAR2_TABLE_300();
367: a38 := JTF_VARCHAR2_TABLE_300();
368: a39 := JTF_NUMBER_TABLE();
369: a40 := JTF_VARCHAR2_TABLE_2000();
370: a41 := JTF_VARCHAR2_TABLE_100();
371: a42 := JTF_VARCHAR2_TABLE_300();
372: a43 := JTF_VARCHAR2_TABLE_300();

Line 386: a57 := JTF_NUMBER_TABLE();

382: a53 := JTF_VARCHAR2_TABLE_300();
383: a54 := JTF_VARCHAR2_TABLE_300();
384: a55 := JTF_VARCHAR2_TABLE_300();
385: a56 := JTF_VARCHAR2_TABLE_300();
386: a57 := JTF_NUMBER_TABLE();
387: a58 := JTF_NUMBER_TABLE();
388: a59 := JTF_NUMBER_TABLE();
389: a60 := JTF_NUMBER_TABLE();
390: a61 := JTF_NUMBER_TABLE();

Line 387: a58 := JTF_NUMBER_TABLE();

383: a54 := JTF_VARCHAR2_TABLE_300();
384: a55 := JTF_VARCHAR2_TABLE_300();
385: a56 := JTF_VARCHAR2_TABLE_300();
386: a57 := JTF_NUMBER_TABLE();
387: a58 := JTF_NUMBER_TABLE();
388: a59 := JTF_NUMBER_TABLE();
389: a60 := JTF_NUMBER_TABLE();
390: a61 := JTF_NUMBER_TABLE();
391: a62 := JTF_NUMBER_TABLE();

Line 388: a59 := JTF_NUMBER_TABLE();

384: a55 := JTF_VARCHAR2_TABLE_300();
385: a56 := JTF_VARCHAR2_TABLE_300();
386: a57 := JTF_NUMBER_TABLE();
387: a58 := JTF_NUMBER_TABLE();
388: a59 := JTF_NUMBER_TABLE();
389: a60 := JTF_NUMBER_TABLE();
390: a61 := JTF_NUMBER_TABLE();
391: a62 := JTF_NUMBER_TABLE();
392: a63 := JTF_NUMBER_TABLE();

Line 389: a60 := JTF_NUMBER_TABLE();

385: a56 := JTF_VARCHAR2_TABLE_300();
386: a57 := JTF_NUMBER_TABLE();
387: a58 := JTF_NUMBER_TABLE();
388: a59 := JTF_NUMBER_TABLE();
389: a60 := JTF_NUMBER_TABLE();
390: a61 := JTF_NUMBER_TABLE();
391: a62 := JTF_NUMBER_TABLE();
392: a63 := JTF_NUMBER_TABLE();
393: a64 := JTF_NUMBER_TABLE();

Line 390: a61 := JTF_NUMBER_TABLE();

386: a57 := JTF_NUMBER_TABLE();
387: a58 := JTF_NUMBER_TABLE();
388: a59 := JTF_NUMBER_TABLE();
389: a60 := JTF_NUMBER_TABLE();
390: a61 := JTF_NUMBER_TABLE();
391: a62 := JTF_NUMBER_TABLE();
392: a63 := JTF_NUMBER_TABLE();
393: a64 := JTF_NUMBER_TABLE();
394: a65 := JTF_NUMBER_TABLE();

Line 391: a62 := JTF_NUMBER_TABLE();

387: a58 := JTF_NUMBER_TABLE();
388: a59 := JTF_NUMBER_TABLE();
389: a60 := JTF_NUMBER_TABLE();
390: a61 := JTF_NUMBER_TABLE();
391: a62 := JTF_NUMBER_TABLE();
392: a63 := JTF_NUMBER_TABLE();
393: a64 := JTF_NUMBER_TABLE();
394: a65 := JTF_NUMBER_TABLE();
395: a66 := JTF_NUMBER_TABLE();

Line 392: a63 := JTF_NUMBER_TABLE();

388: a59 := JTF_NUMBER_TABLE();
389: a60 := JTF_NUMBER_TABLE();
390: a61 := JTF_NUMBER_TABLE();
391: a62 := JTF_NUMBER_TABLE();
392: a63 := JTF_NUMBER_TABLE();
393: a64 := JTF_NUMBER_TABLE();
394: a65 := JTF_NUMBER_TABLE();
395: a66 := JTF_NUMBER_TABLE();
396: a67 := JTF_VARCHAR2_TABLE_100();

Line 393: a64 := JTF_NUMBER_TABLE();

389: a60 := JTF_NUMBER_TABLE();
390: a61 := JTF_NUMBER_TABLE();
391: a62 := JTF_NUMBER_TABLE();
392: a63 := JTF_NUMBER_TABLE();
393: a64 := JTF_NUMBER_TABLE();
394: a65 := JTF_NUMBER_TABLE();
395: a66 := JTF_NUMBER_TABLE();
396: a67 := JTF_VARCHAR2_TABLE_100();
397: a68 := JTF_NUMBER_TABLE();

Line 394: a65 := JTF_NUMBER_TABLE();

390: a61 := JTF_NUMBER_TABLE();
391: a62 := JTF_NUMBER_TABLE();
392: a63 := JTF_NUMBER_TABLE();
393: a64 := JTF_NUMBER_TABLE();
394: a65 := JTF_NUMBER_TABLE();
395: a66 := JTF_NUMBER_TABLE();
396: a67 := JTF_VARCHAR2_TABLE_100();
397: a68 := JTF_NUMBER_TABLE();
398: a69 := JTF_NUMBER_TABLE();

Line 395: a66 := JTF_NUMBER_TABLE();

391: a62 := JTF_NUMBER_TABLE();
392: a63 := JTF_NUMBER_TABLE();
393: a64 := JTF_NUMBER_TABLE();
394: a65 := JTF_NUMBER_TABLE();
395: a66 := JTF_NUMBER_TABLE();
396: a67 := JTF_VARCHAR2_TABLE_100();
397: a68 := JTF_NUMBER_TABLE();
398: a69 := JTF_NUMBER_TABLE();
399: a70 := JTF_VARCHAR2_TABLE_300();

Line 397: a68 := JTF_NUMBER_TABLE();

393: a64 := JTF_NUMBER_TABLE();
394: a65 := JTF_NUMBER_TABLE();
395: a66 := JTF_NUMBER_TABLE();
396: a67 := JTF_VARCHAR2_TABLE_100();
397: a68 := JTF_NUMBER_TABLE();
398: a69 := JTF_NUMBER_TABLE();
399: a70 := JTF_VARCHAR2_TABLE_300();
400: a71 := JTF_VARCHAR2_TABLE_300();
401: a72 := JTF_VARCHAR2_TABLE_300();

Line 398: a69 := JTF_NUMBER_TABLE();

394: a65 := JTF_NUMBER_TABLE();
395: a66 := JTF_NUMBER_TABLE();
396: a67 := JTF_VARCHAR2_TABLE_100();
397: a68 := JTF_NUMBER_TABLE();
398: a69 := JTF_NUMBER_TABLE();
399: a70 := JTF_VARCHAR2_TABLE_300();
400: a71 := JTF_VARCHAR2_TABLE_300();
401: a72 := JTF_VARCHAR2_TABLE_300();
402: else

Line 405: a2 := JTF_NUMBER_TABLE();

401: a72 := JTF_VARCHAR2_TABLE_300();
402: else
403: a0 := JTF_VARCHAR2_TABLE_100();
404: a1 := JTF_VARCHAR2_TABLE_100();
405: a2 := JTF_NUMBER_TABLE();
406: a3 := JTF_VARCHAR2_TABLE_100();
407: a4 := JTF_NUMBER_TABLE();
408: a5 := JTF_VARCHAR2_TABLE_100();
409: a6 := JTF_NUMBER_TABLE();

Line 407: a4 := JTF_NUMBER_TABLE();

403: a0 := JTF_VARCHAR2_TABLE_100();
404: a1 := JTF_VARCHAR2_TABLE_100();
405: a2 := JTF_NUMBER_TABLE();
406: a3 := JTF_VARCHAR2_TABLE_100();
407: a4 := JTF_NUMBER_TABLE();
408: a5 := JTF_VARCHAR2_TABLE_100();
409: a6 := JTF_NUMBER_TABLE();
410: a7 := JTF_DATE_TABLE();
411: a8 := JTF_DATE_TABLE();

Line 409: a6 := JTF_NUMBER_TABLE();

405: a2 := JTF_NUMBER_TABLE();
406: a3 := JTF_VARCHAR2_TABLE_100();
407: a4 := JTF_NUMBER_TABLE();
408: a5 := JTF_VARCHAR2_TABLE_100();
409: a6 := JTF_NUMBER_TABLE();
410: a7 := JTF_DATE_TABLE();
411: a8 := JTF_DATE_TABLE();
412: a9 := JTF_VARCHAR2_TABLE_100();
413: a10 := JTF_VARCHAR2_TABLE_100();

Line 414: a11 := JTF_NUMBER_TABLE();

410: a7 := JTF_DATE_TABLE();
411: a8 := JTF_DATE_TABLE();
412: a9 := JTF_VARCHAR2_TABLE_100();
413: a10 := JTF_VARCHAR2_TABLE_100();
414: a11 := JTF_NUMBER_TABLE();
415: a12 := JTF_VARCHAR2_TABLE_100();
416: a13 := JTF_NUMBER_TABLE();
417: a14 := JTF_NUMBER_TABLE();
418: a15 := JTF_VARCHAR2_TABLE_100();

Line 416: a13 := JTF_NUMBER_TABLE();

412: a9 := JTF_VARCHAR2_TABLE_100();
413: a10 := JTF_VARCHAR2_TABLE_100();
414: a11 := JTF_NUMBER_TABLE();
415: a12 := JTF_VARCHAR2_TABLE_100();
416: a13 := JTF_NUMBER_TABLE();
417: a14 := JTF_NUMBER_TABLE();
418: a15 := JTF_VARCHAR2_TABLE_100();
419: a16 := JTF_NUMBER_TABLE();
420: a17 := JTF_VARCHAR2_TABLE_100();

Line 417: a14 := JTF_NUMBER_TABLE();

413: a10 := JTF_VARCHAR2_TABLE_100();
414: a11 := JTF_NUMBER_TABLE();
415: a12 := JTF_VARCHAR2_TABLE_100();
416: a13 := JTF_NUMBER_TABLE();
417: a14 := JTF_NUMBER_TABLE();
418: a15 := JTF_VARCHAR2_TABLE_100();
419: a16 := JTF_NUMBER_TABLE();
420: a17 := JTF_VARCHAR2_TABLE_100();
421: a18 := JTF_NUMBER_TABLE();

Line 419: a16 := JTF_NUMBER_TABLE();

415: a12 := JTF_VARCHAR2_TABLE_100();
416: a13 := JTF_NUMBER_TABLE();
417: a14 := JTF_NUMBER_TABLE();
418: a15 := JTF_VARCHAR2_TABLE_100();
419: a16 := JTF_NUMBER_TABLE();
420: a17 := JTF_VARCHAR2_TABLE_100();
421: a18 := JTF_NUMBER_TABLE();
422: a19 := JTF_NUMBER_TABLE();
423: a20 := JTF_NUMBER_TABLE();

Line 421: a18 := JTF_NUMBER_TABLE();

417: a14 := JTF_NUMBER_TABLE();
418: a15 := JTF_VARCHAR2_TABLE_100();
419: a16 := JTF_NUMBER_TABLE();
420: a17 := JTF_VARCHAR2_TABLE_100();
421: a18 := JTF_NUMBER_TABLE();
422: a19 := JTF_NUMBER_TABLE();
423: a20 := JTF_NUMBER_TABLE();
424: a21 := JTF_NUMBER_TABLE();
425: a22 := JTF_VARCHAR2_TABLE_100();

Line 422: a19 := JTF_NUMBER_TABLE();

418: a15 := JTF_VARCHAR2_TABLE_100();
419: a16 := JTF_NUMBER_TABLE();
420: a17 := JTF_VARCHAR2_TABLE_100();
421: a18 := JTF_NUMBER_TABLE();
422: a19 := JTF_NUMBER_TABLE();
423: a20 := JTF_NUMBER_TABLE();
424: a21 := JTF_NUMBER_TABLE();
425: a22 := JTF_VARCHAR2_TABLE_100();
426: a23 := JTF_VARCHAR2_TABLE_100();

Line 423: a20 := JTF_NUMBER_TABLE();

419: a16 := JTF_NUMBER_TABLE();
420: a17 := JTF_VARCHAR2_TABLE_100();
421: a18 := JTF_NUMBER_TABLE();
422: a19 := JTF_NUMBER_TABLE();
423: a20 := JTF_NUMBER_TABLE();
424: a21 := JTF_NUMBER_TABLE();
425: a22 := JTF_VARCHAR2_TABLE_100();
426: a23 := JTF_VARCHAR2_TABLE_100();
427: a24 := JTF_VARCHAR2_TABLE_100();

Line 424: a21 := JTF_NUMBER_TABLE();

420: a17 := JTF_VARCHAR2_TABLE_100();
421: a18 := JTF_NUMBER_TABLE();
422: a19 := JTF_NUMBER_TABLE();
423: a20 := JTF_NUMBER_TABLE();
424: a21 := JTF_NUMBER_TABLE();
425: a22 := JTF_VARCHAR2_TABLE_100();
426: a23 := JTF_VARCHAR2_TABLE_100();
427: a24 := JTF_VARCHAR2_TABLE_100();
428: a25 := JTF_VARCHAR2_TABLE_300();

Line 430: a27 := JTF_NUMBER_TABLE();

426: a23 := JTF_VARCHAR2_TABLE_100();
427: a24 := JTF_VARCHAR2_TABLE_100();
428: a25 := JTF_VARCHAR2_TABLE_300();
429: a26 := JTF_VARCHAR2_TABLE_100();
430: a27 := JTF_NUMBER_TABLE();
431: a28 := JTF_VARCHAR2_TABLE_100();
432: a29 := JTF_VARCHAR2_TABLE_100();
433: a30 := JTF_VARCHAR2_TABLE_300();
434: a31 := JTF_VARCHAR2_TABLE_100();

Line 442: a39 := JTF_NUMBER_TABLE();

438: a35 := JTF_VARCHAR2_TABLE_300();
439: a36 := JTF_VARCHAR2_TABLE_100();
440: a37 := JTF_VARCHAR2_TABLE_300();
441: a38 := JTF_VARCHAR2_TABLE_300();
442: a39 := JTF_NUMBER_TABLE();
443: a40 := JTF_VARCHAR2_TABLE_2000();
444: a41 := JTF_VARCHAR2_TABLE_100();
445: a42 := JTF_VARCHAR2_TABLE_300();
446: a43 := JTF_VARCHAR2_TABLE_300();

Line 460: a57 := JTF_NUMBER_TABLE();

456: a53 := JTF_VARCHAR2_TABLE_300();
457: a54 := JTF_VARCHAR2_TABLE_300();
458: a55 := JTF_VARCHAR2_TABLE_300();
459: a56 := JTF_VARCHAR2_TABLE_300();
460: a57 := JTF_NUMBER_TABLE();
461: a58 := JTF_NUMBER_TABLE();
462: a59 := JTF_NUMBER_TABLE();
463: a60 := JTF_NUMBER_TABLE();
464: a61 := JTF_NUMBER_TABLE();

Line 461: a58 := JTF_NUMBER_TABLE();

457: a54 := JTF_VARCHAR2_TABLE_300();
458: a55 := JTF_VARCHAR2_TABLE_300();
459: a56 := JTF_VARCHAR2_TABLE_300();
460: a57 := JTF_NUMBER_TABLE();
461: a58 := JTF_NUMBER_TABLE();
462: a59 := JTF_NUMBER_TABLE();
463: a60 := JTF_NUMBER_TABLE();
464: a61 := JTF_NUMBER_TABLE();
465: a62 := JTF_NUMBER_TABLE();

Line 462: a59 := JTF_NUMBER_TABLE();

458: a55 := JTF_VARCHAR2_TABLE_300();
459: a56 := JTF_VARCHAR2_TABLE_300();
460: a57 := JTF_NUMBER_TABLE();
461: a58 := JTF_NUMBER_TABLE();
462: a59 := JTF_NUMBER_TABLE();
463: a60 := JTF_NUMBER_TABLE();
464: a61 := JTF_NUMBER_TABLE();
465: a62 := JTF_NUMBER_TABLE();
466: a63 := JTF_NUMBER_TABLE();

Line 463: a60 := JTF_NUMBER_TABLE();

459: a56 := JTF_VARCHAR2_TABLE_300();
460: a57 := JTF_NUMBER_TABLE();
461: a58 := JTF_NUMBER_TABLE();
462: a59 := JTF_NUMBER_TABLE();
463: a60 := JTF_NUMBER_TABLE();
464: a61 := JTF_NUMBER_TABLE();
465: a62 := JTF_NUMBER_TABLE();
466: a63 := JTF_NUMBER_TABLE();
467: a64 := JTF_NUMBER_TABLE();

Line 464: a61 := JTF_NUMBER_TABLE();

460: a57 := JTF_NUMBER_TABLE();
461: a58 := JTF_NUMBER_TABLE();
462: a59 := JTF_NUMBER_TABLE();
463: a60 := JTF_NUMBER_TABLE();
464: a61 := JTF_NUMBER_TABLE();
465: a62 := JTF_NUMBER_TABLE();
466: a63 := JTF_NUMBER_TABLE();
467: a64 := JTF_NUMBER_TABLE();
468: a65 := JTF_NUMBER_TABLE();

Line 465: a62 := JTF_NUMBER_TABLE();

461: a58 := JTF_NUMBER_TABLE();
462: a59 := JTF_NUMBER_TABLE();
463: a60 := JTF_NUMBER_TABLE();
464: a61 := JTF_NUMBER_TABLE();
465: a62 := JTF_NUMBER_TABLE();
466: a63 := JTF_NUMBER_TABLE();
467: a64 := JTF_NUMBER_TABLE();
468: a65 := JTF_NUMBER_TABLE();
469: a66 := JTF_NUMBER_TABLE();

Line 466: a63 := JTF_NUMBER_TABLE();

462: a59 := JTF_NUMBER_TABLE();
463: a60 := JTF_NUMBER_TABLE();
464: a61 := JTF_NUMBER_TABLE();
465: a62 := JTF_NUMBER_TABLE();
466: a63 := JTF_NUMBER_TABLE();
467: a64 := JTF_NUMBER_TABLE();
468: a65 := JTF_NUMBER_TABLE();
469: a66 := JTF_NUMBER_TABLE();
470: a67 := JTF_VARCHAR2_TABLE_100();

Line 467: a64 := JTF_NUMBER_TABLE();

463: a60 := JTF_NUMBER_TABLE();
464: a61 := JTF_NUMBER_TABLE();
465: a62 := JTF_NUMBER_TABLE();
466: a63 := JTF_NUMBER_TABLE();
467: a64 := JTF_NUMBER_TABLE();
468: a65 := JTF_NUMBER_TABLE();
469: a66 := JTF_NUMBER_TABLE();
470: a67 := JTF_VARCHAR2_TABLE_100();
471: a68 := JTF_NUMBER_TABLE();

Line 468: a65 := JTF_NUMBER_TABLE();

464: a61 := JTF_NUMBER_TABLE();
465: a62 := JTF_NUMBER_TABLE();
466: a63 := JTF_NUMBER_TABLE();
467: a64 := JTF_NUMBER_TABLE();
468: a65 := JTF_NUMBER_TABLE();
469: a66 := JTF_NUMBER_TABLE();
470: a67 := JTF_VARCHAR2_TABLE_100();
471: a68 := JTF_NUMBER_TABLE();
472: a69 := JTF_NUMBER_TABLE();

Line 469: a66 := JTF_NUMBER_TABLE();

465: a62 := JTF_NUMBER_TABLE();
466: a63 := JTF_NUMBER_TABLE();
467: a64 := JTF_NUMBER_TABLE();
468: a65 := JTF_NUMBER_TABLE();
469: a66 := JTF_NUMBER_TABLE();
470: a67 := JTF_VARCHAR2_TABLE_100();
471: a68 := JTF_NUMBER_TABLE();
472: a69 := JTF_NUMBER_TABLE();
473: a70 := JTF_VARCHAR2_TABLE_300();

Line 471: a68 := JTF_NUMBER_TABLE();

467: a64 := JTF_NUMBER_TABLE();
468: a65 := JTF_NUMBER_TABLE();
469: a66 := JTF_NUMBER_TABLE();
470: a67 := JTF_VARCHAR2_TABLE_100();
471: a68 := JTF_NUMBER_TABLE();
472: a69 := JTF_NUMBER_TABLE();
473: a70 := JTF_VARCHAR2_TABLE_300();
474: a71 := JTF_VARCHAR2_TABLE_300();
475: a72 := JTF_VARCHAR2_TABLE_300();

Line 472: a69 := JTF_NUMBER_TABLE();

468: a65 := JTF_NUMBER_TABLE();
469: a66 := JTF_NUMBER_TABLE();
470: a67 := JTF_VARCHAR2_TABLE_100();
471: a68 := JTF_NUMBER_TABLE();
472: a69 := JTF_NUMBER_TABLE();
473: a70 := JTF_VARCHAR2_TABLE_300();
474: a71 := JTF_VARCHAR2_TABLE_300();
475: a72 := JTF_VARCHAR2_TABLE_300();
476: if t.count > 0 then

Line 636: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE

632: end if;
633: end if;
634: end rosetta_table_copy_out_p4;
635:
636: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
637: , a1 JTF_VARCHAR2_TABLE_100
638: , a2 JTF_NUMBER_TABLE
639: , a3 JTF_VARCHAR2_TABLE_100
640: , a4 JTF_VARCHAR2_TABLE_100

Line 638: , a2 JTF_NUMBER_TABLE

634: end rosetta_table_copy_out_p4;
635:
636: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
637: , a1 JTF_VARCHAR2_TABLE_100
638: , a2 JTF_NUMBER_TABLE
639: , a3 JTF_VARCHAR2_TABLE_100
640: , a4 JTF_VARCHAR2_TABLE_100
641: , a5 JTF_VARCHAR2_TABLE_300
642: , a6 JTF_VARCHAR2_TABLE_100

Line 647: , a11 JTF_NUMBER_TABLE

643: , a7 JTF_VARCHAR2_TABLE_100
644: , a8 JTF_VARCHAR2_TABLE_100
645: , a9 JTF_VARCHAR2_TABLE_300
646: , a10 JTF_VARCHAR2_TABLE_300
647: , a11 JTF_NUMBER_TABLE
648: , a12 JTF_VARCHAR2_TABLE_100
649: ) as
650: ddindx binary_integer; indx binary_integer;
651: begin

Line 679: procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

675: end loop;
676: end if;
677: end if;
678: end rosetta_table_copy_in_p6;
679: procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
680: , a1 out nocopy JTF_VARCHAR2_TABLE_100
681: , a2 out nocopy JTF_NUMBER_TABLE
682: , a3 out nocopy JTF_VARCHAR2_TABLE_100
683: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 681: , a2 out nocopy JTF_NUMBER_TABLE

677: end if;
678: end rosetta_table_copy_in_p6;
679: procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
680: , a1 out nocopy JTF_VARCHAR2_TABLE_100
681: , a2 out nocopy JTF_NUMBER_TABLE
682: , a3 out nocopy JTF_VARCHAR2_TABLE_100
683: , a4 out nocopy JTF_VARCHAR2_TABLE_100
684: , a5 out nocopy JTF_VARCHAR2_TABLE_300
685: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 690: , a11 out nocopy JTF_NUMBER_TABLE

686: , a7 out nocopy JTF_VARCHAR2_TABLE_100
687: , a8 out nocopy JTF_VARCHAR2_TABLE_100
688: , a9 out nocopy JTF_VARCHAR2_TABLE_300
689: , a10 out nocopy JTF_VARCHAR2_TABLE_300
690: , a11 out nocopy JTF_NUMBER_TABLE
691: , a12 out nocopy JTF_VARCHAR2_TABLE_100
692: ) as
693: ddindx binary_integer; indx binary_integer;
694: begin

Line 696: a0 := JTF_NUMBER_TABLE();

692: ) as
693: ddindx binary_integer; indx binary_integer;
694: begin
695: if t is null or t.count = 0 then
696: a0 := JTF_NUMBER_TABLE();
697: a1 := JTF_VARCHAR2_TABLE_100();
698: a2 := JTF_NUMBER_TABLE();
699: a3 := JTF_VARCHAR2_TABLE_100();
700: a4 := JTF_VARCHAR2_TABLE_100();

Line 698: a2 := JTF_NUMBER_TABLE();

694: begin
695: if t is null or t.count = 0 then
696: a0 := JTF_NUMBER_TABLE();
697: a1 := JTF_VARCHAR2_TABLE_100();
698: a2 := JTF_NUMBER_TABLE();
699: a3 := JTF_VARCHAR2_TABLE_100();
700: a4 := JTF_VARCHAR2_TABLE_100();
701: a5 := JTF_VARCHAR2_TABLE_300();
702: a6 := JTF_VARCHAR2_TABLE_100();

Line 707: a11 := JTF_NUMBER_TABLE();

703: a7 := JTF_VARCHAR2_TABLE_100();
704: a8 := JTF_VARCHAR2_TABLE_100();
705: a9 := JTF_VARCHAR2_TABLE_300();
706: a10 := JTF_VARCHAR2_TABLE_300();
707: a11 := JTF_NUMBER_TABLE();
708: a12 := JTF_VARCHAR2_TABLE_100();
709: else
710: a0 := JTF_NUMBER_TABLE();
711: a1 := JTF_VARCHAR2_TABLE_100();

Line 710: a0 := JTF_NUMBER_TABLE();

706: a10 := JTF_VARCHAR2_TABLE_300();
707: a11 := JTF_NUMBER_TABLE();
708: a12 := JTF_VARCHAR2_TABLE_100();
709: else
710: a0 := JTF_NUMBER_TABLE();
711: a1 := JTF_VARCHAR2_TABLE_100();
712: a2 := JTF_NUMBER_TABLE();
713: a3 := JTF_VARCHAR2_TABLE_100();
714: a4 := JTF_VARCHAR2_TABLE_100();

Line 712: a2 := JTF_NUMBER_TABLE();

708: a12 := JTF_VARCHAR2_TABLE_100();
709: else
710: a0 := JTF_NUMBER_TABLE();
711: a1 := JTF_VARCHAR2_TABLE_100();
712: a2 := JTF_NUMBER_TABLE();
713: a3 := JTF_VARCHAR2_TABLE_100();
714: a4 := JTF_VARCHAR2_TABLE_100();
715: a5 := JTF_VARCHAR2_TABLE_300();
716: a6 := JTF_VARCHAR2_TABLE_100();

Line 721: a11 := JTF_NUMBER_TABLE();

717: a7 := JTF_VARCHAR2_TABLE_100();
718: a8 := JTF_VARCHAR2_TABLE_100();
719: a9 := JTF_VARCHAR2_TABLE_300();
720: a10 := JTF_VARCHAR2_TABLE_300();
721: a11 := JTF_NUMBER_TABLE();
722: a12 := JTF_VARCHAR2_TABLE_100();
723: if t.count > 0 then
724: a0.extend(t.count);
725: a1.extend(t.count);

Line 768: , a5 JTF_NUMBER_TABLE

764: , a1 JTF_VARCHAR2_TABLE_100
765: , a2 JTF_VARCHAR2_TABLE_300
766: , a3 JTF_VARCHAR2_TABLE_300
767: , a4 JTF_VARCHAR2_TABLE_100
768: , a5 JTF_NUMBER_TABLE
769: , a6 JTF_NUMBER_TABLE
770: , a7 JTF_NUMBER_TABLE
771: , a8 JTF_NUMBER_TABLE
772: , a9 JTF_DATE_TABLE

Line 769: , a6 JTF_NUMBER_TABLE

765: , a2 JTF_VARCHAR2_TABLE_300
766: , a3 JTF_VARCHAR2_TABLE_300
767: , a4 JTF_VARCHAR2_TABLE_100
768: , a5 JTF_NUMBER_TABLE
769: , a6 JTF_NUMBER_TABLE
770: , a7 JTF_NUMBER_TABLE
771: , a8 JTF_NUMBER_TABLE
772: , a9 JTF_DATE_TABLE
773: , a10 JTF_DATE_TABLE

Line 770: , a7 JTF_NUMBER_TABLE

766: , a3 JTF_VARCHAR2_TABLE_300
767: , a4 JTF_VARCHAR2_TABLE_100
768: , a5 JTF_NUMBER_TABLE
769: , a6 JTF_NUMBER_TABLE
770: , a7 JTF_NUMBER_TABLE
771: , a8 JTF_NUMBER_TABLE
772: , a9 JTF_DATE_TABLE
773: , a10 JTF_DATE_TABLE
774: , a11 JTF_NUMBER_TABLE

Line 771: , a8 JTF_NUMBER_TABLE

767: , a4 JTF_VARCHAR2_TABLE_100
768: , a5 JTF_NUMBER_TABLE
769: , a6 JTF_NUMBER_TABLE
770: , a7 JTF_NUMBER_TABLE
771: , a8 JTF_NUMBER_TABLE
772: , a9 JTF_DATE_TABLE
773: , a10 JTF_DATE_TABLE
774: , a11 JTF_NUMBER_TABLE
775: , a12 JTF_VARCHAR2_TABLE_100

Line 774: , a11 JTF_NUMBER_TABLE

770: , a7 JTF_NUMBER_TABLE
771: , a8 JTF_NUMBER_TABLE
772: , a9 JTF_DATE_TABLE
773: , a10 JTF_DATE_TABLE
774: , a11 JTF_NUMBER_TABLE
775: , a12 JTF_VARCHAR2_TABLE_100
776: , a13 JTF_VARCHAR2_TABLE_100
777: , a14 JTF_VARCHAR2_TABLE_300
778: , a15 JTF_VARCHAR2_TABLE_300

Line 843: , a5 out nocopy JTF_NUMBER_TABLE

839: , a1 out nocopy JTF_VARCHAR2_TABLE_100
840: , a2 out nocopy JTF_VARCHAR2_TABLE_300
841: , a3 out nocopy JTF_VARCHAR2_TABLE_300
842: , a4 out nocopy JTF_VARCHAR2_TABLE_100
843: , a5 out nocopy JTF_NUMBER_TABLE
844: , a6 out nocopy JTF_NUMBER_TABLE
845: , a7 out nocopy JTF_NUMBER_TABLE
846: , a8 out nocopy JTF_NUMBER_TABLE
847: , a9 out nocopy JTF_DATE_TABLE

Line 844: , a6 out nocopy JTF_NUMBER_TABLE

840: , a2 out nocopy JTF_VARCHAR2_TABLE_300
841: , a3 out nocopy JTF_VARCHAR2_TABLE_300
842: , a4 out nocopy JTF_VARCHAR2_TABLE_100
843: , a5 out nocopy JTF_NUMBER_TABLE
844: , a6 out nocopy JTF_NUMBER_TABLE
845: , a7 out nocopy JTF_NUMBER_TABLE
846: , a8 out nocopy JTF_NUMBER_TABLE
847: , a9 out nocopy JTF_DATE_TABLE
848: , a10 out nocopy JTF_DATE_TABLE

Line 845: , a7 out nocopy JTF_NUMBER_TABLE

841: , a3 out nocopy JTF_VARCHAR2_TABLE_300
842: , a4 out nocopy JTF_VARCHAR2_TABLE_100
843: , a5 out nocopy JTF_NUMBER_TABLE
844: , a6 out nocopy JTF_NUMBER_TABLE
845: , a7 out nocopy JTF_NUMBER_TABLE
846: , a8 out nocopy JTF_NUMBER_TABLE
847: , a9 out nocopy JTF_DATE_TABLE
848: , a10 out nocopy JTF_DATE_TABLE
849: , a11 out nocopy JTF_NUMBER_TABLE

Line 846: , a8 out nocopy JTF_NUMBER_TABLE

842: , a4 out nocopy JTF_VARCHAR2_TABLE_100
843: , a5 out nocopy JTF_NUMBER_TABLE
844: , a6 out nocopy JTF_NUMBER_TABLE
845: , a7 out nocopy JTF_NUMBER_TABLE
846: , a8 out nocopy JTF_NUMBER_TABLE
847: , a9 out nocopy JTF_DATE_TABLE
848: , a10 out nocopy JTF_DATE_TABLE
849: , a11 out nocopy JTF_NUMBER_TABLE
850: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 849: , a11 out nocopy JTF_NUMBER_TABLE

845: , a7 out nocopy JTF_NUMBER_TABLE
846: , a8 out nocopy JTF_NUMBER_TABLE
847: , a9 out nocopy JTF_DATE_TABLE
848: , a10 out nocopy JTF_DATE_TABLE
849: , a11 out nocopy JTF_NUMBER_TABLE
850: , a12 out nocopy JTF_VARCHAR2_TABLE_100
851: , a13 out nocopy JTF_VARCHAR2_TABLE_100
852: , a14 out nocopy JTF_VARCHAR2_TABLE_300
853: , a15 out nocopy JTF_VARCHAR2_TABLE_300

Line 876: a5 := JTF_NUMBER_TABLE();

872: a1 := JTF_VARCHAR2_TABLE_100();
873: a2 := JTF_VARCHAR2_TABLE_300();
874: a3 := JTF_VARCHAR2_TABLE_300();
875: a4 := JTF_VARCHAR2_TABLE_100();
876: a5 := JTF_NUMBER_TABLE();
877: a6 := JTF_NUMBER_TABLE();
878: a7 := JTF_NUMBER_TABLE();
879: a8 := JTF_NUMBER_TABLE();
880: a9 := JTF_DATE_TABLE();

Line 877: a6 := JTF_NUMBER_TABLE();

873: a2 := JTF_VARCHAR2_TABLE_300();
874: a3 := JTF_VARCHAR2_TABLE_300();
875: a4 := JTF_VARCHAR2_TABLE_100();
876: a5 := JTF_NUMBER_TABLE();
877: a6 := JTF_NUMBER_TABLE();
878: a7 := JTF_NUMBER_TABLE();
879: a8 := JTF_NUMBER_TABLE();
880: a9 := JTF_DATE_TABLE();
881: a10 := JTF_DATE_TABLE();

Line 878: a7 := JTF_NUMBER_TABLE();

874: a3 := JTF_VARCHAR2_TABLE_300();
875: a4 := JTF_VARCHAR2_TABLE_100();
876: a5 := JTF_NUMBER_TABLE();
877: a6 := JTF_NUMBER_TABLE();
878: a7 := JTF_NUMBER_TABLE();
879: a8 := JTF_NUMBER_TABLE();
880: a9 := JTF_DATE_TABLE();
881: a10 := JTF_DATE_TABLE();
882: a11 := JTF_NUMBER_TABLE();

Line 879: a8 := JTF_NUMBER_TABLE();

875: a4 := JTF_VARCHAR2_TABLE_100();
876: a5 := JTF_NUMBER_TABLE();
877: a6 := JTF_NUMBER_TABLE();
878: a7 := JTF_NUMBER_TABLE();
879: a8 := JTF_NUMBER_TABLE();
880: a9 := JTF_DATE_TABLE();
881: a10 := JTF_DATE_TABLE();
882: a11 := JTF_NUMBER_TABLE();
883: a12 := JTF_VARCHAR2_TABLE_100();

Line 882: a11 := JTF_NUMBER_TABLE();

878: a7 := JTF_NUMBER_TABLE();
879: a8 := JTF_NUMBER_TABLE();
880: a9 := JTF_DATE_TABLE();
881: a10 := JTF_DATE_TABLE();
882: a11 := JTF_NUMBER_TABLE();
883: a12 := JTF_VARCHAR2_TABLE_100();
884: a13 := JTF_VARCHAR2_TABLE_100();
885: a14 := JTF_VARCHAR2_TABLE_300();
886: a15 := JTF_VARCHAR2_TABLE_300();

Line 906: a5 := JTF_NUMBER_TABLE();

902: a1 := JTF_VARCHAR2_TABLE_100();
903: a2 := JTF_VARCHAR2_TABLE_300();
904: a3 := JTF_VARCHAR2_TABLE_300();
905: a4 := JTF_VARCHAR2_TABLE_100();
906: a5 := JTF_NUMBER_TABLE();
907: a6 := JTF_NUMBER_TABLE();
908: a7 := JTF_NUMBER_TABLE();
909: a8 := JTF_NUMBER_TABLE();
910: a9 := JTF_DATE_TABLE();

Line 907: a6 := JTF_NUMBER_TABLE();

903: a2 := JTF_VARCHAR2_TABLE_300();
904: a3 := JTF_VARCHAR2_TABLE_300();
905: a4 := JTF_VARCHAR2_TABLE_100();
906: a5 := JTF_NUMBER_TABLE();
907: a6 := JTF_NUMBER_TABLE();
908: a7 := JTF_NUMBER_TABLE();
909: a8 := JTF_NUMBER_TABLE();
910: a9 := JTF_DATE_TABLE();
911: a10 := JTF_DATE_TABLE();

Line 908: a7 := JTF_NUMBER_TABLE();

904: a3 := JTF_VARCHAR2_TABLE_300();
905: a4 := JTF_VARCHAR2_TABLE_100();
906: a5 := JTF_NUMBER_TABLE();
907: a6 := JTF_NUMBER_TABLE();
908: a7 := JTF_NUMBER_TABLE();
909: a8 := JTF_NUMBER_TABLE();
910: a9 := JTF_DATE_TABLE();
911: a10 := JTF_DATE_TABLE();
912: a11 := JTF_NUMBER_TABLE();

Line 909: a8 := JTF_NUMBER_TABLE();

905: a4 := JTF_VARCHAR2_TABLE_100();
906: a5 := JTF_NUMBER_TABLE();
907: a6 := JTF_NUMBER_TABLE();
908: a7 := JTF_NUMBER_TABLE();
909: a8 := JTF_NUMBER_TABLE();
910: a9 := JTF_DATE_TABLE();
911: a10 := JTF_DATE_TABLE();
912: a11 := JTF_NUMBER_TABLE();
913: a12 := JTF_VARCHAR2_TABLE_100();

Line 912: a11 := JTF_NUMBER_TABLE();

908: a7 := JTF_NUMBER_TABLE();
909: a8 := JTF_NUMBER_TABLE();
910: a9 := JTF_DATE_TABLE();
911: a10 := JTF_DATE_TABLE();
912: a11 := JTF_NUMBER_TABLE();
913: a12 := JTF_VARCHAR2_TABLE_100();
914: a13 := JTF_VARCHAR2_TABLE_100();
915: a14 := JTF_VARCHAR2_TABLE_300();
916: a15 := JTF_VARCHAR2_TABLE_300();

Line 1011: , p8_a2 JTF_NUMBER_TABLE

1007: , x_msg_data out nocopy VARCHAR2
1008: , p_offer_type VARCHAR2
1009: , p8_a0 JTF_VARCHAR2_TABLE_100
1010: , p8_a1 JTF_VARCHAR2_TABLE_100
1011: , p8_a2 JTF_NUMBER_TABLE
1012: , p8_a3 JTF_VARCHAR2_TABLE_100
1013: , p8_a4 JTF_NUMBER_TABLE
1014: , p8_a5 JTF_VARCHAR2_TABLE_100
1015: , p8_a6 JTF_NUMBER_TABLE

Line 1013: , p8_a4 JTF_NUMBER_TABLE

1009: , p8_a0 JTF_VARCHAR2_TABLE_100
1010: , p8_a1 JTF_VARCHAR2_TABLE_100
1011: , p8_a2 JTF_NUMBER_TABLE
1012: , p8_a3 JTF_VARCHAR2_TABLE_100
1013: , p8_a4 JTF_NUMBER_TABLE
1014: , p8_a5 JTF_VARCHAR2_TABLE_100
1015: , p8_a6 JTF_NUMBER_TABLE
1016: , p8_a7 JTF_DATE_TABLE
1017: , p8_a8 JTF_DATE_TABLE

Line 1015: , p8_a6 JTF_NUMBER_TABLE

1011: , p8_a2 JTF_NUMBER_TABLE
1012: , p8_a3 JTF_VARCHAR2_TABLE_100
1013: , p8_a4 JTF_NUMBER_TABLE
1014: , p8_a5 JTF_VARCHAR2_TABLE_100
1015: , p8_a6 JTF_NUMBER_TABLE
1016: , p8_a7 JTF_DATE_TABLE
1017: , p8_a8 JTF_DATE_TABLE
1018: , p8_a9 JTF_VARCHAR2_TABLE_100
1019: , p8_a10 JTF_VARCHAR2_TABLE_100

Line 1020: , p8_a11 JTF_NUMBER_TABLE

1016: , p8_a7 JTF_DATE_TABLE
1017: , p8_a8 JTF_DATE_TABLE
1018: , p8_a9 JTF_VARCHAR2_TABLE_100
1019: , p8_a10 JTF_VARCHAR2_TABLE_100
1020: , p8_a11 JTF_NUMBER_TABLE
1021: , p8_a12 JTF_VARCHAR2_TABLE_100
1022: , p8_a13 JTF_NUMBER_TABLE
1023: , p8_a14 JTF_NUMBER_TABLE
1024: , p8_a15 JTF_VARCHAR2_TABLE_100

Line 1022: , p8_a13 JTF_NUMBER_TABLE

1018: , p8_a9 JTF_VARCHAR2_TABLE_100
1019: , p8_a10 JTF_VARCHAR2_TABLE_100
1020: , p8_a11 JTF_NUMBER_TABLE
1021: , p8_a12 JTF_VARCHAR2_TABLE_100
1022: , p8_a13 JTF_NUMBER_TABLE
1023: , p8_a14 JTF_NUMBER_TABLE
1024: , p8_a15 JTF_VARCHAR2_TABLE_100
1025: , p8_a16 JTF_NUMBER_TABLE
1026: , p8_a17 JTF_VARCHAR2_TABLE_100

Line 1023: , p8_a14 JTF_NUMBER_TABLE

1019: , p8_a10 JTF_VARCHAR2_TABLE_100
1020: , p8_a11 JTF_NUMBER_TABLE
1021: , p8_a12 JTF_VARCHAR2_TABLE_100
1022: , p8_a13 JTF_NUMBER_TABLE
1023: , p8_a14 JTF_NUMBER_TABLE
1024: , p8_a15 JTF_VARCHAR2_TABLE_100
1025: , p8_a16 JTF_NUMBER_TABLE
1026: , p8_a17 JTF_VARCHAR2_TABLE_100
1027: , p8_a18 JTF_NUMBER_TABLE

Line 1025: , p8_a16 JTF_NUMBER_TABLE

1021: , p8_a12 JTF_VARCHAR2_TABLE_100
1022: , p8_a13 JTF_NUMBER_TABLE
1023: , p8_a14 JTF_NUMBER_TABLE
1024: , p8_a15 JTF_VARCHAR2_TABLE_100
1025: , p8_a16 JTF_NUMBER_TABLE
1026: , p8_a17 JTF_VARCHAR2_TABLE_100
1027: , p8_a18 JTF_NUMBER_TABLE
1028: , p8_a19 JTF_NUMBER_TABLE
1029: , p8_a20 JTF_NUMBER_TABLE

Line 1027: , p8_a18 JTF_NUMBER_TABLE

1023: , p8_a14 JTF_NUMBER_TABLE
1024: , p8_a15 JTF_VARCHAR2_TABLE_100
1025: , p8_a16 JTF_NUMBER_TABLE
1026: , p8_a17 JTF_VARCHAR2_TABLE_100
1027: , p8_a18 JTF_NUMBER_TABLE
1028: , p8_a19 JTF_NUMBER_TABLE
1029: , p8_a20 JTF_NUMBER_TABLE
1030: , p8_a21 JTF_NUMBER_TABLE
1031: , p8_a22 JTF_VARCHAR2_TABLE_100

Line 1028: , p8_a19 JTF_NUMBER_TABLE

1024: , p8_a15 JTF_VARCHAR2_TABLE_100
1025: , p8_a16 JTF_NUMBER_TABLE
1026: , p8_a17 JTF_VARCHAR2_TABLE_100
1027: , p8_a18 JTF_NUMBER_TABLE
1028: , p8_a19 JTF_NUMBER_TABLE
1029: , p8_a20 JTF_NUMBER_TABLE
1030: , p8_a21 JTF_NUMBER_TABLE
1031: , p8_a22 JTF_VARCHAR2_TABLE_100
1032: , p8_a23 JTF_VARCHAR2_TABLE_100

Line 1029: , p8_a20 JTF_NUMBER_TABLE

1025: , p8_a16 JTF_NUMBER_TABLE
1026: , p8_a17 JTF_VARCHAR2_TABLE_100
1027: , p8_a18 JTF_NUMBER_TABLE
1028: , p8_a19 JTF_NUMBER_TABLE
1029: , p8_a20 JTF_NUMBER_TABLE
1030: , p8_a21 JTF_NUMBER_TABLE
1031: , p8_a22 JTF_VARCHAR2_TABLE_100
1032: , p8_a23 JTF_VARCHAR2_TABLE_100
1033: , p8_a24 JTF_VARCHAR2_TABLE_100

Line 1030: , p8_a21 JTF_NUMBER_TABLE

1026: , p8_a17 JTF_VARCHAR2_TABLE_100
1027: , p8_a18 JTF_NUMBER_TABLE
1028: , p8_a19 JTF_NUMBER_TABLE
1029: , p8_a20 JTF_NUMBER_TABLE
1030: , p8_a21 JTF_NUMBER_TABLE
1031: , p8_a22 JTF_VARCHAR2_TABLE_100
1032: , p8_a23 JTF_VARCHAR2_TABLE_100
1033: , p8_a24 JTF_VARCHAR2_TABLE_100
1034: , p8_a25 JTF_VARCHAR2_TABLE_300

Line 1036: , p8_a27 JTF_NUMBER_TABLE

1032: , p8_a23 JTF_VARCHAR2_TABLE_100
1033: , p8_a24 JTF_VARCHAR2_TABLE_100
1034: , p8_a25 JTF_VARCHAR2_TABLE_300
1035: , p8_a26 JTF_VARCHAR2_TABLE_100
1036: , p8_a27 JTF_NUMBER_TABLE
1037: , p8_a28 JTF_VARCHAR2_TABLE_100
1038: , p8_a29 JTF_VARCHAR2_TABLE_100
1039: , p8_a30 JTF_VARCHAR2_TABLE_300
1040: , p8_a31 JTF_VARCHAR2_TABLE_100

Line 1048: , p8_a39 JTF_NUMBER_TABLE

1044: , p8_a35 JTF_VARCHAR2_TABLE_300
1045: , p8_a36 JTF_VARCHAR2_TABLE_100
1046: , p8_a37 JTF_VARCHAR2_TABLE_300
1047: , p8_a38 JTF_VARCHAR2_TABLE_300
1048: , p8_a39 JTF_NUMBER_TABLE
1049: , p8_a40 JTF_VARCHAR2_TABLE_2000
1050: , p8_a41 JTF_VARCHAR2_TABLE_100
1051: , p8_a42 JTF_VARCHAR2_TABLE_300
1052: , p8_a43 JTF_VARCHAR2_TABLE_300

Line 1066: , p8_a57 JTF_NUMBER_TABLE

1062: , p8_a53 JTF_VARCHAR2_TABLE_300
1063: , p8_a54 JTF_VARCHAR2_TABLE_300
1064: , p8_a55 JTF_VARCHAR2_TABLE_300
1065: , p8_a56 JTF_VARCHAR2_TABLE_300
1066: , p8_a57 JTF_NUMBER_TABLE
1067: , p8_a58 JTF_NUMBER_TABLE
1068: , p8_a59 JTF_NUMBER_TABLE
1069: , p8_a60 JTF_NUMBER_TABLE
1070: , p8_a61 JTF_NUMBER_TABLE

Line 1067: , p8_a58 JTF_NUMBER_TABLE

1063: , p8_a54 JTF_VARCHAR2_TABLE_300
1064: , p8_a55 JTF_VARCHAR2_TABLE_300
1065: , p8_a56 JTF_VARCHAR2_TABLE_300
1066: , p8_a57 JTF_NUMBER_TABLE
1067: , p8_a58 JTF_NUMBER_TABLE
1068: , p8_a59 JTF_NUMBER_TABLE
1069: , p8_a60 JTF_NUMBER_TABLE
1070: , p8_a61 JTF_NUMBER_TABLE
1071: , p8_a62 JTF_NUMBER_TABLE

Line 1068: , p8_a59 JTF_NUMBER_TABLE

1064: , p8_a55 JTF_VARCHAR2_TABLE_300
1065: , p8_a56 JTF_VARCHAR2_TABLE_300
1066: , p8_a57 JTF_NUMBER_TABLE
1067: , p8_a58 JTF_NUMBER_TABLE
1068: , p8_a59 JTF_NUMBER_TABLE
1069: , p8_a60 JTF_NUMBER_TABLE
1070: , p8_a61 JTF_NUMBER_TABLE
1071: , p8_a62 JTF_NUMBER_TABLE
1072: , p8_a63 JTF_NUMBER_TABLE

Line 1069: , p8_a60 JTF_NUMBER_TABLE

1065: , p8_a56 JTF_VARCHAR2_TABLE_300
1066: , p8_a57 JTF_NUMBER_TABLE
1067: , p8_a58 JTF_NUMBER_TABLE
1068: , p8_a59 JTF_NUMBER_TABLE
1069: , p8_a60 JTF_NUMBER_TABLE
1070: , p8_a61 JTF_NUMBER_TABLE
1071: , p8_a62 JTF_NUMBER_TABLE
1072: , p8_a63 JTF_NUMBER_TABLE
1073: , p8_a64 JTF_NUMBER_TABLE

Line 1070: , p8_a61 JTF_NUMBER_TABLE

1066: , p8_a57 JTF_NUMBER_TABLE
1067: , p8_a58 JTF_NUMBER_TABLE
1068: , p8_a59 JTF_NUMBER_TABLE
1069: , p8_a60 JTF_NUMBER_TABLE
1070: , p8_a61 JTF_NUMBER_TABLE
1071: , p8_a62 JTF_NUMBER_TABLE
1072: , p8_a63 JTF_NUMBER_TABLE
1073: , p8_a64 JTF_NUMBER_TABLE
1074: , p8_a65 JTF_NUMBER_TABLE

Line 1071: , p8_a62 JTF_NUMBER_TABLE

1067: , p8_a58 JTF_NUMBER_TABLE
1068: , p8_a59 JTF_NUMBER_TABLE
1069: , p8_a60 JTF_NUMBER_TABLE
1070: , p8_a61 JTF_NUMBER_TABLE
1071: , p8_a62 JTF_NUMBER_TABLE
1072: , p8_a63 JTF_NUMBER_TABLE
1073: , p8_a64 JTF_NUMBER_TABLE
1074: , p8_a65 JTF_NUMBER_TABLE
1075: , p8_a66 JTF_NUMBER_TABLE

Line 1072: , p8_a63 JTF_NUMBER_TABLE

1068: , p8_a59 JTF_NUMBER_TABLE
1069: , p8_a60 JTF_NUMBER_TABLE
1070: , p8_a61 JTF_NUMBER_TABLE
1071: , p8_a62 JTF_NUMBER_TABLE
1072: , p8_a63 JTF_NUMBER_TABLE
1073: , p8_a64 JTF_NUMBER_TABLE
1074: , p8_a65 JTF_NUMBER_TABLE
1075: , p8_a66 JTF_NUMBER_TABLE
1076: , p8_a67 JTF_VARCHAR2_TABLE_100

Line 1073: , p8_a64 JTF_NUMBER_TABLE

1069: , p8_a60 JTF_NUMBER_TABLE
1070: , p8_a61 JTF_NUMBER_TABLE
1071: , p8_a62 JTF_NUMBER_TABLE
1072: , p8_a63 JTF_NUMBER_TABLE
1073: , p8_a64 JTF_NUMBER_TABLE
1074: , p8_a65 JTF_NUMBER_TABLE
1075: , p8_a66 JTF_NUMBER_TABLE
1076: , p8_a67 JTF_VARCHAR2_TABLE_100
1077: , p8_a68 JTF_NUMBER_TABLE

Line 1074: , p8_a65 JTF_NUMBER_TABLE

1070: , p8_a61 JTF_NUMBER_TABLE
1071: , p8_a62 JTF_NUMBER_TABLE
1072: , p8_a63 JTF_NUMBER_TABLE
1073: , p8_a64 JTF_NUMBER_TABLE
1074: , p8_a65 JTF_NUMBER_TABLE
1075: , p8_a66 JTF_NUMBER_TABLE
1076: , p8_a67 JTF_VARCHAR2_TABLE_100
1077: , p8_a68 JTF_NUMBER_TABLE
1078: , p8_a69 JTF_NUMBER_TABLE

Line 1075: , p8_a66 JTF_NUMBER_TABLE

1071: , p8_a62 JTF_NUMBER_TABLE
1072: , p8_a63 JTF_NUMBER_TABLE
1073: , p8_a64 JTF_NUMBER_TABLE
1074: , p8_a65 JTF_NUMBER_TABLE
1075: , p8_a66 JTF_NUMBER_TABLE
1076: , p8_a67 JTF_VARCHAR2_TABLE_100
1077: , p8_a68 JTF_NUMBER_TABLE
1078: , p8_a69 JTF_NUMBER_TABLE
1079: , p8_a70 JTF_VARCHAR2_TABLE_300

Line 1077: , p8_a68 JTF_NUMBER_TABLE

1073: , p8_a64 JTF_NUMBER_TABLE
1074: , p8_a65 JTF_NUMBER_TABLE
1075: , p8_a66 JTF_NUMBER_TABLE
1076: , p8_a67 JTF_VARCHAR2_TABLE_100
1077: , p8_a68 JTF_NUMBER_TABLE
1078: , p8_a69 JTF_NUMBER_TABLE
1079: , p8_a70 JTF_VARCHAR2_TABLE_300
1080: , p8_a71 JTF_VARCHAR2_TABLE_300
1081: , p8_a72 JTF_VARCHAR2_TABLE_300

Line 1078: , p8_a69 JTF_NUMBER_TABLE

1074: , p8_a65 JTF_NUMBER_TABLE
1075: , p8_a66 JTF_NUMBER_TABLE
1076: , p8_a67 JTF_VARCHAR2_TABLE_100
1077: , p8_a68 JTF_NUMBER_TABLE
1078: , p8_a69 JTF_NUMBER_TABLE
1079: , p8_a70 JTF_VARCHAR2_TABLE_300
1080: , p8_a71 JTF_VARCHAR2_TABLE_300
1081: , p8_a72 JTF_VARCHAR2_TABLE_300
1082: , x_qp_list_header_id out nocopy NUMBER

Line 1384: , p6_a2 JTF_NUMBER_TABLE

1380: , x_msg_count out nocopy NUMBER
1381: , x_msg_data out nocopy VARCHAR2
1382: , p6_a0 JTF_VARCHAR2_TABLE_100
1383: , p6_a1 JTF_VARCHAR2_TABLE_100
1384: , p6_a2 JTF_NUMBER_TABLE
1385: , p6_a3 JTF_VARCHAR2_TABLE_100
1386: , p6_a4 JTF_NUMBER_TABLE
1387: , p6_a5 JTF_VARCHAR2_TABLE_100
1388: , p6_a6 JTF_NUMBER_TABLE

Line 1386: , p6_a4 JTF_NUMBER_TABLE

1382: , p6_a0 JTF_VARCHAR2_TABLE_100
1383: , p6_a1 JTF_VARCHAR2_TABLE_100
1384: , p6_a2 JTF_NUMBER_TABLE
1385: , p6_a3 JTF_VARCHAR2_TABLE_100
1386: , p6_a4 JTF_NUMBER_TABLE
1387: , p6_a5 JTF_VARCHAR2_TABLE_100
1388: , p6_a6 JTF_NUMBER_TABLE
1389: , p6_a7 JTF_DATE_TABLE
1390: , p6_a8 JTF_DATE_TABLE

Line 1388: , p6_a6 JTF_NUMBER_TABLE

1384: , p6_a2 JTF_NUMBER_TABLE
1385: , p6_a3 JTF_VARCHAR2_TABLE_100
1386: , p6_a4 JTF_NUMBER_TABLE
1387: , p6_a5 JTF_VARCHAR2_TABLE_100
1388: , p6_a6 JTF_NUMBER_TABLE
1389: , p6_a7 JTF_DATE_TABLE
1390: , p6_a8 JTF_DATE_TABLE
1391: , p6_a9 JTF_VARCHAR2_TABLE_100
1392: , p6_a10 JTF_VARCHAR2_TABLE_100

Line 1393: , p6_a11 JTF_NUMBER_TABLE

1389: , p6_a7 JTF_DATE_TABLE
1390: , p6_a8 JTF_DATE_TABLE
1391: , p6_a9 JTF_VARCHAR2_TABLE_100
1392: , p6_a10 JTF_VARCHAR2_TABLE_100
1393: , p6_a11 JTF_NUMBER_TABLE
1394: , p6_a12 JTF_VARCHAR2_TABLE_100
1395: , p6_a13 JTF_NUMBER_TABLE
1396: , p6_a14 JTF_NUMBER_TABLE
1397: , p6_a15 JTF_VARCHAR2_TABLE_100

Line 1395: , p6_a13 JTF_NUMBER_TABLE

1391: , p6_a9 JTF_VARCHAR2_TABLE_100
1392: , p6_a10 JTF_VARCHAR2_TABLE_100
1393: , p6_a11 JTF_NUMBER_TABLE
1394: , p6_a12 JTF_VARCHAR2_TABLE_100
1395: , p6_a13 JTF_NUMBER_TABLE
1396: , p6_a14 JTF_NUMBER_TABLE
1397: , p6_a15 JTF_VARCHAR2_TABLE_100
1398: , p6_a16 JTF_NUMBER_TABLE
1399: , p6_a17 JTF_VARCHAR2_TABLE_100

Line 1396: , p6_a14 JTF_NUMBER_TABLE

1392: , p6_a10 JTF_VARCHAR2_TABLE_100
1393: , p6_a11 JTF_NUMBER_TABLE
1394: , p6_a12 JTF_VARCHAR2_TABLE_100
1395: , p6_a13 JTF_NUMBER_TABLE
1396: , p6_a14 JTF_NUMBER_TABLE
1397: , p6_a15 JTF_VARCHAR2_TABLE_100
1398: , p6_a16 JTF_NUMBER_TABLE
1399: , p6_a17 JTF_VARCHAR2_TABLE_100
1400: , p6_a18 JTF_NUMBER_TABLE

Line 1398: , p6_a16 JTF_NUMBER_TABLE

1394: , p6_a12 JTF_VARCHAR2_TABLE_100
1395: , p6_a13 JTF_NUMBER_TABLE
1396: , p6_a14 JTF_NUMBER_TABLE
1397: , p6_a15 JTF_VARCHAR2_TABLE_100
1398: , p6_a16 JTF_NUMBER_TABLE
1399: , p6_a17 JTF_VARCHAR2_TABLE_100
1400: , p6_a18 JTF_NUMBER_TABLE
1401: , p6_a19 JTF_NUMBER_TABLE
1402: , p6_a20 JTF_NUMBER_TABLE

Line 1400: , p6_a18 JTF_NUMBER_TABLE

1396: , p6_a14 JTF_NUMBER_TABLE
1397: , p6_a15 JTF_VARCHAR2_TABLE_100
1398: , p6_a16 JTF_NUMBER_TABLE
1399: , p6_a17 JTF_VARCHAR2_TABLE_100
1400: , p6_a18 JTF_NUMBER_TABLE
1401: , p6_a19 JTF_NUMBER_TABLE
1402: , p6_a20 JTF_NUMBER_TABLE
1403: , p6_a21 JTF_NUMBER_TABLE
1404: , p6_a22 JTF_VARCHAR2_TABLE_100

Line 1401: , p6_a19 JTF_NUMBER_TABLE

1397: , p6_a15 JTF_VARCHAR2_TABLE_100
1398: , p6_a16 JTF_NUMBER_TABLE
1399: , p6_a17 JTF_VARCHAR2_TABLE_100
1400: , p6_a18 JTF_NUMBER_TABLE
1401: , p6_a19 JTF_NUMBER_TABLE
1402: , p6_a20 JTF_NUMBER_TABLE
1403: , p6_a21 JTF_NUMBER_TABLE
1404: , p6_a22 JTF_VARCHAR2_TABLE_100
1405: , p6_a23 JTF_VARCHAR2_TABLE_100

Line 1402: , p6_a20 JTF_NUMBER_TABLE

1398: , p6_a16 JTF_NUMBER_TABLE
1399: , p6_a17 JTF_VARCHAR2_TABLE_100
1400: , p6_a18 JTF_NUMBER_TABLE
1401: , p6_a19 JTF_NUMBER_TABLE
1402: , p6_a20 JTF_NUMBER_TABLE
1403: , p6_a21 JTF_NUMBER_TABLE
1404: , p6_a22 JTF_VARCHAR2_TABLE_100
1405: , p6_a23 JTF_VARCHAR2_TABLE_100
1406: , p6_a24 JTF_VARCHAR2_TABLE_100

Line 1403: , p6_a21 JTF_NUMBER_TABLE

1399: , p6_a17 JTF_VARCHAR2_TABLE_100
1400: , p6_a18 JTF_NUMBER_TABLE
1401: , p6_a19 JTF_NUMBER_TABLE
1402: , p6_a20 JTF_NUMBER_TABLE
1403: , p6_a21 JTF_NUMBER_TABLE
1404: , p6_a22 JTF_VARCHAR2_TABLE_100
1405: , p6_a23 JTF_VARCHAR2_TABLE_100
1406: , p6_a24 JTF_VARCHAR2_TABLE_100
1407: , p6_a25 JTF_VARCHAR2_TABLE_300

Line 1409: , p6_a27 JTF_NUMBER_TABLE

1405: , p6_a23 JTF_VARCHAR2_TABLE_100
1406: , p6_a24 JTF_VARCHAR2_TABLE_100
1407: , p6_a25 JTF_VARCHAR2_TABLE_300
1408: , p6_a26 JTF_VARCHAR2_TABLE_100
1409: , p6_a27 JTF_NUMBER_TABLE
1410: , p6_a28 JTF_VARCHAR2_TABLE_100
1411: , p6_a29 JTF_VARCHAR2_TABLE_100
1412: , p6_a30 JTF_VARCHAR2_TABLE_300
1413: , p6_a31 JTF_VARCHAR2_TABLE_100

Line 1421: , p6_a39 JTF_NUMBER_TABLE

1417: , p6_a35 JTF_VARCHAR2_TABLE_300
1418: , p6_a36 JTF_VARCHAR2_TABLE_100
1419: , p6_a37 JTF_VARCHAR2_TABLE_300
1420: , p6_a38 JTF_VARCHAR2_TABLE_300
1421: , p6_a39 JTF_NUMBER_TABLE
1422: , p6_a40 JTF_VARCHAR2_TABLE_2000
1423: , p6_a41 JTF_VARCHAR2_TABLE_100
1424: , p6_a42 JTF_VARCHAR2_TABLE_300
1425: , p6_a43 JTF_VARCHAR2_TABLE_300

Line 1439: , p6_a57 JTF_NUMBER_TABLE

1435: , p6_a53 JTF_VARCHAR2_TABLE_300
1436: , p6_a54 JTF_VARCHAR2_TABLE_300
1437: , p6_a55 JTF_VARCHAR2_TABLE_300
1438: , p6_a56 JTF_VARCHAR2_TABLE_300
1439: , p6_a57 JTF_NUMBER_TABLE
1440: , p6_a58 JTF_NUMBER_TABLE
1441: , p6_a59 JTF_NUMBER_TABLE
1442: , p6_a60 JTF_NUMBER_TABLE
1443: , p6_a61 JTF_NUMBER_TABLE

Line 1440: , p6_a58 JTF_NUMBER_TABLE

1436: , p6_a54 JTF_VARCHAR2_TABLE_300
1437: , p6_a55 JTF_VARCHAR2_TABLE_300
1438: , p6_a56 JTF_VARCHAR2_TABLE_300
1439: , p6_a57 JTF_NUMBER_TABLE
1440: , p6_a58 JTF_NUMBER_TABLE
1441: , p6_a59 JTF_NUMBER_TABLE
1442: , p6_a60 JTF_NUMBER_TABLE
1443: , p6_a61 JTF_NUMBER_TABLE
1444: , p6_a62 JTF_NUMBER_TABLE

Line 1441: , p6_a59 JTF_NUMBER_TABLE

1437: , p6_a55 JTF_VARCHAR2_TABLE_300
1438: , p6_a56 JTF_VARCHAR2_TABLE_300
1439: , p6_a57 JTF_NUMBER_TABLE
1440: , p6_a58 JTF_NUMBER_TABLE
1441: , p6_a59 JTF_NUMBER_TABLE
1442: , p6_a60 JTF_NUMBER_TABLE
1443: , p6_a61 JTF_NUMBER_TABLE
1444: , p6_a62 JTF_NUMBER_TABLE
1445: , p6_a63 JTF_NUMBER_TABLE

Line 1442: , p6_a60 JTF_NUMBER_TABLE

1438: , p6_a56 JTF_VARCHAR2_TABLE_300
1439: , p6_a57 JTF_NUMBER_TABLE
1440: , p6_a58 JTF_NUMBER_TABLE
1441: , p6_a59 JTF_NUMBER_TABLE
1442: , p6_a60 JTF_NUMBER_TABLE
1443: , p6_a61 JTF_NUMBER_TABLE
1444: , p6_a62 JTF_NUMBER_TABLE
1445: , p6_a63 JTF_NUMBER_TABLE
1446: , p6_a64 JTF_NUMBER_TABLE

Line 1443: , p6_a61 JTF_NUMBER_TABLE

1439: , p6_a57 JTF_NUMBER_TABLE
1440: , p6_a58 JTF_NUMBER_TABLE
1441: , p6_a59 JTF_NUMBER_TABLE
1442: , p6_a60 JTF_NUMBER_TABLE
1443: , p6_a61 JTF_NUMBER_TABLE
1444: , p6_a62 JTF_NUMBER_TABLE
1445: , p6_a63 JTF_NUMBER_TABLE
1446: , p6_a64 JTF_NUMBER_TABLE
1447: , p6_a65 JTF_NUMBER_TABLE

Line 1444: , p6_a62 JTF_NUMBER_TABLE

1440: , p6_a58 JTF_NUMBER_TABLE
1441: , p6_a59 JTF_NUMBER_TABLE
1442: , p6_a60 JTF_NUMBER_TABLE
1443: , p6_a61 JTF_NUMBER_TABLE
1444: , p6_a62 JTF_NUMBER_TABLE
1445: , p6_a63 JTF_NUMBER_TABLE
1446: , p6_a64 JTF_NUMBER_TABLE
1447: , p6_a65 JTF_NUMBER_TABLE
1448: , p6_a66 JTF_NUMBER_TABLE

Line 1445: , p6_a63 JTF_NUMBER_TABLE

1441: , p6_a59 JTF_NUMBER_TABLE
1442: , p6_a60 JTF_NUMBER_TABLE
1443: , p6_a61 JTF_NUMBER_TABLE
1444: , p6_a62 JTF_NUMBER_TABLE
1445: , p6_a63 JTF_NUMBER_TABLE
1446: , p6_a64 JTF_NUMBER_TABLE
1447: , p6_a65 JTF_NUMBER_TABLE
1448: , p6_a66 JTF_NUMBER_TABLE
1449: , p6_a67 JTF_VARCHAR2_TABLE_100

Line 1446: , p6_a64 JTF_NUMBER_TABLE

1442: , p6_a60 JTF_NUMBER_TABLE
1443: , p6_a61 JTF_NUMBER_TABLE
1444: , p6_a62 JTF_NUMBER_TABLE
1445: , p6_a63 JTF_NUMBER_TABLE
1446: , p6_a64 JTF_NUMBER_TABLE
1447: , p6_a65 JTF_NUMBER_TABLE
1448: , p6_a66 JTF_NUMBER_TABLE
1449: , p6_a67 JTF_VARCHAR2_TABLE_100
1450: , p6_a68 JTF_NUMBER_TABLE

Line 1447: , p6_a65 JTF_NUMBER_TABLE

1443: , p6_a61 JTF_NUMBER_TABLE
1444: , p6_a62 JTF_NUMBER_TABLE
1445: , p6_a63 JTF_NUMBER_TABLE
1446: , p6_a64 JTF_NUMBER_TABLE
1447: , p6_a65 JTF_NUMBER_TABLE
1448: , p6_a66 JTF_NUMBER_TABLE
1449: , p6_a67 JTF_VARCHAR2_TABLE_100
1450: , p6_a68 JTF_NUMBER_TABLE
1451: , p6_a69 JTF_NUMBER_TABLE

Line 1448: , p6_a66 JTF_NUMBER_TABLE

1444: , p6_a62 JTF_NUMBER_TABLE
1445: , p6_a63 JTF_NUMBER_TABLE
1446: , p6_a64 JTF_NUMBER_TABLE
1447: , p6_a65 JTF_NUMBER_TABLE
1448: , p6_a66 JTF_NUMBER_TABLE
1449: , p6_a67 JTF_VARCHAR2_TABLE_100
1450: , p6_a68 JTF_NUMBER_TABLE
1451: , p6_a69 JTF_NUMBER_TABLE
1452: , p6_a70 JTF_VARCHAR2_TABLE_300

Line 1450: , p6_a68 JTF_NUMBER_TABLE

1446: , p6_a64 JTF_NUMBER_TABLE
1447: , p6_a65 JTF_NUMBER_TABLE
1448: , p6_a66 JTF_NUMBER_TABLE
1449: , p6_a67 JTF_VARCHAR2_TABLE_100
1450: , p6_a68 JTF_NUMBER_TABLE
1451: , p6_a69 JTF_NUMBER_TABLE
1452: , p6_a70 JTF_VARCHAR2_TABLE_300
1453: , p6_a71 JTF_VARCHAR2_TABLE_300
1454: , p6_a72 JTF_VARCHAR2_TABLE_300

Line 1451: , p6_a69 JTF_NUMBER_TABLE

1447: , p6_a65 JTF_NUMBER_TABLE
1448: , p6_a66 JTF_NUMBER_TABLE
1449: , p6_a67 JTF_VARCHAR2_TABLE_100
1450: , p6_a68 JTF_NUMBER_TABLE
1451: , p6_a69 JTF_NUMBER_TABLE
1452: , p6_a70 JTF_VARCHAR2_TABLE_300
1453: , p6_a71 JTF_VARCHAR2_TABLE_300
1454: , p6_a72 JTF_VARCHAR2_TABLE_300
1455: , x_error_location out nocopy NUMBER

Line 1577: , p6_a5 JTF_NUMBER_TABLE

1573: , p6_a1 JTF_VARCHAR2_TABLE_100
1574: , p6_a2 JTF_VARCHAR2_TABLE_300
1575: , p6_a3 JTF_VARCHAR2_TABLE_300
1576: , p6_a4 JTF_VARCHAR2_TABLE_100
1577: , p6_a5 JTF_NUMBER_TABLE
1578: , p6_a6 JTF_NUMBER_TABLE
1579: , p6_a7 JTF_NUMBER_TABLE
1580: , p6_a8 JTF_NUMBER_TABLE
1581: , p6_a9 JTF_DATE_TABLE

Line 1578: , p6_a6 JTF_NUMBER_TABLE

1574: , p6_a2 JTF_VARCHAR2_TABLE_300
1575: , p6_a3 JTF_VARCHAR2_TABLE_300
1576: , p6_a4 JTF_VARCHAR2_TABLE_100
1577: , p6_a5 JTF_NUMBER_TABLE
1578: , p6_a6 JTF_NUMBER_TABLE
1579: , p6_a7 JTF_NUMBER_TABLE
1580: , p6_a8 JTF_NUMBER_TABLE
1581: , p6_a9 JTF_DATE_TABLE
1582: , p6_a10 JTF_DATE_TABLE

Line 1579: , p6_a7 JTF_NUMBER_TABLE

1575: , p6_a3 JTF_VARCHAR2_TABLE_300
1576: , p6_a4 JTF_VARCHAR2_TABLE_100
1577: , p6_a5 JTF_NUMBER_TABLE
1578: , p6_a6 JTF_NUMBER_TABLE
1579: , p6_a7 JTF_NUMBER_TABLE
1580: , p6_a8 JTF_NUMBER_TABLE
1581: , p6_a9 JTF_DATE_TABLE
1582: , p6_a10 JTF_DATE_TABLE
1583: , p6_a11 JTF_NUMBER_TABLE

Line 1580: , p6_a8 JTF_NUMBER_TABLE

1576: , p6_a4 JTF_VARCHAR2_TABLE_100
1577: , p6_a5 JTF_NUMBER_TABLE
1578: , p6_a6 JTF_NUMBER_TABLE
1579: , p6_a7 JTF_NUMBER_TABLE
1580: , p6_a8 JTF_NUMBER_TABLE
1581: , p6_a9 JTF_DATE_TABLE
1582: , p6_a10 JTF_DATE_TABLE
1583: , p6_a11 JTF_NUMBER_TABLE
1584: , p6_a12 JTF_VARCHAR2_TABLE_100

Line 1583: , p6_a11 JTF_NUMBER_TABLE

1579: , p6_a7 JTF_NUMBER_TABLE
1580: , p6_a8 JTF_NUMBER_TABLE
1581: , p6_a9 JTF_DATE_TABLE
1582: , p6_a10 JTF_DATE_TABLE
1583: , p6_a11 JTF_NUMBER_TABLE
1584: , p6_a12 JTF_VARCHAR2_TABLE_100
1585: , p6_a13 JTF_VARCHAR2_TABLE_100
1586: , p6_a14 JTF_VARCHAR2_TABLE_300
1587: , p6_a15 JTF_VARCHAR2_TABLE_300

Line 1674: , p6_a0 JTF_NUMBER_TABLE

1670: , p_commit VARCHAR2
1671: , x_return_status out nocopy VARCHAR2
1672: , x_msg_count out nocopy NUMBER
1673: , x_msg_data out nocopy VARCHAR2
1674: , p6_a0 JTF_NUMBER_TABLE
1675: , p6_a1 JTF_VARCHAR2_TABLE_100
1676: , p6_a2 JTF_NUMBER_TABLE
1677: , p6_a3 JTF_VARCHAR2_TABLE_100
1678: , p6_a4 JTF_VARCHAR2_TABLE_100

Line 1676: , p6_a2 JTF_NUMBER_TABLE

1672: , x_msg_count out nocopy NUMBER
1673: , x_msg_data out nocopy VARCHAR2
1674: , p6_a0 JTF_NUMBER_TABLE
1675: , p6_a1 JTF_VARCHAR2_TABLE_100
1676: , p6_a2 JTF_NUMBER_TABLE
1677: , p6_a3 JTF_VARCHAR2_TABLE_100
1678: , p6_a4 JTF_VARCHAR2_TABLE_100
1679: , p6_a5 JTF_VARCHAR2_TABLE_300
1680: , p6_a6 JTF_VARCHAR2_TABLE_100

Line 1685: , p6_a11 JTF_NUMBER_TABLE

1681: , p6_a7 JTF_VARCHAR2_TABLE_100
1682: , p6_a8 JTF_VARCHAR2_TABLE_100
1683: , p6_a9 JTF_VARCHAR2_TABLE_300
1684: , p6_a10 JTF_VARCHAR2_TABLE_300
1685: , p6_a11 JTF_NUMBER_TABLE
1686: , p6_a12 JTF_VARCHAR2_TABLE_100
1687: , x_error_location out nocopy NUMBER
1688: )
1689: