DBA Data[Home] [Help]

APPS.JTF_ASSIGN_PUB_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p8(t out nocopy jtf_assign_pub.avail_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p8(t out nocopy jtf_assign_pub.avail_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 26: , a4 JTF_NUMBER_TABLE

22: procedure rosetta_table_copy_in_p8(t out nocopy jtf_assign_pub.avail_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if a0 is not null and a0.count > 0 then

Line 49: procedure rosetta_table_copy_out_p8(t jtf_assign_pub.avail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

45: end loop;
46: end if;
47: end if;
48: end rosetta_table_copy_in_p8;
49: procedure rosetta_table_copy_out_p8(t jtf_assign_pub.avail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_100
51: , a2 out nocopy JTF_DATE_TABLE
52: , a3 out nocopy JTF_DATE_TABLE
53: , a4 out nocopy JTF_NUMBER_TABLE

Line 53: , a4 out nocopy JTF_NUMBER_TABLE

49: procedure rosetta_table_copy_out_p8(t jtf_assign_pub.avail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_100
51: , a2 out nocopy JTF_DATE_TABLE
52: , a3 out nocopy JTF_DATE_TABLE
53: , a4 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_VARCHAR2_TABLE_100();
60: a2 := JTF_DATE_TABLE();
61: a3 := JTF_DATE_TABLE();
62: a4 := JTF_NUMBER_TABLE();

Line 62: a4 := JTF_NUMBER_TABLE();

58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_VARCHAR2_TABLE_100();
60: a2 := JTF_DATE_TABLE();
61: a3 := JTF_DATE_TABLE();
62: a4 := JTF_NUMBER_TABLE();
63: else
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_DATE_TABLE();

Line 64: a0 := JTF_NUMBER_TABLE();

60: a2 := JTF_DATE_TABLE();
61: a3 := JTF_DATE_TABLE();
62: a4 := JTF_NUMBER_TABLE();
63: else
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_DATE_TABLE();
67: a3 := JTF_DATE_TABLE();
68: a4 := JTF_NUMBER_TABLE();

Line 68: a4 := JTF_NUMBER_TABLE();

64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_100();
66: a2 := JTF_DATE_TABLE();
67: a3 := JTF_DATE_TABLE();
68: a4 := JTF_NUMBER_TABLE();
69: if t.count > 0 then
70: a0.extend(t.count);
71: a1.extend(t.count);
72: a2.extend(t.count);

Line 93: procedure rosetta_table_copy_in_p11(t out nocopy jtf_assign_pub.assignresources_tbl_type, a0 JTF_NUMBER_TABLE

89: end if;
90: end if;
91: end rosetta_table_copy_out_p8;
92:
93: procedure rosetta_table_copy_in_p11(t out nocopy jtf_assign_pub.assignresources_tbl_type, a0 JTF_NUMBER_TABLE
94: , a1 JTF_NUMBER_TABLE
95: , a2 JTF_VARCHAR2_TABLE_100
96: , a3 JTF_VARCHAR2_TABLE_100
97: , a4 JTF_DATE_TABLE

Line 94: , a1 JTF_NUMBER_TABLE

90: end if;
91: end rosetta_table_copy_out_p8;
92:
93: procedure rosetta_table_copy_in_p11(t out nocopy jtf_assign_pub.assignresources_tbl_type, a0 JTF_NUMBER_TABLE
94: , a1 JTF_NUMBER_TABLE
95: , a2 JTF_VARCHAR2_TABLE_100
96: , a3 JTF_VARCHAR2_TABLE_100
97: , a4 JTF_DATE_TABLE
98: , a5 JTF_DATE_TABLE

Line 99: , a6 JTF_NUMBER_TABLE

95: , a2 JTF_VARCHAR2_TABLE_100
96: , a3 JTF_VARCHAR2_TABLE_100
97: , a4 JTF_DATE_TABLE
98: , a5 JTF_DATE_TABLE
99: , a6 JTF_NUMBER_TABLE
100: , a7 JTF_NUMBER_TABLE
101: , a8 JTF_VARCHAR2_TABLE_300
102: , a9 JTF_NUMBER_TABLE
103: , a10 JTF_NUMBER_TABLE

Line 100: , a7 JTF_NUMBER_TABLE

96: , a3 JTF_VARCHAR2_TABLE_100
97: , a4 JTF_DATE_TABLE
98: , a5 JTF_DATE_TABLE
99: , a6 JTF_NUMBER_TABLE
100: , a7 JTF_NUMBER_TABLE
101: , a8 JTF_VARCHAR2_TABLE_300
102: , a9 JTF_NUMBER_TABLE
103: , a10 JTF_NUMBER_TABLE
104: , a11 JTF_VARCHAR2_TABLE_100

Line 102: , a9 JTF_NUMBER_TABLE

98: , a5 JTF_DATE_TABLE
99: , a6 JTF_NUMBER_TABLE
100: , a7 JTF_NUMBER_TABLE
101: , a8 JTF_VARCHAR2_TABLE_300
102: , a9 JTF_NUMBER_TABLE
103: , a10 JTF_NUMBER_TABLE
104: , a11 JTF_VARCHAR2_TABLE_100
105: , a12 JTF_VARCHAR2_TABLE_100
106: , a13 JTF_VARCHAR2_TABLE_100

Line 103: , a10 JTF_NUMBER_TABLE

99: , a6 JTF_NUMBER_TABLE
100: , a7 JTF_NUMBER_TABLE
101: , a8 JTF_VARCHAR2_TABLE_300
102: , a9 JTF_NUMBER_TABLE
103: , a10 JTF_NUMBER_TABLE
104: , a11 JTF_VARCHAR2_TABLE_100
105: , a12 JTF_VARCHAR2_TABLE_100
106: , a13 JTF_VARCHAR2_TABLE_100
107: , a14 JTF_VARCHAR2_TABLE_100

Line 108: , a15 JTF_NUMBER_TABLE

104: , a11 JTF_VARCHAR2_TABLE_100
105: , a12 JTF_VARCHAR2_TABLE_100
106: , a13 JTF_VARCHAR2_TABLE_100
107: , a14 JTF_VARCHAR2_TABLE_100
108: , a15 JTF_NUMBER_TABLE
109: , a16 JTF_VARCHAR2_TABLE_100
110: , a17 JTF_NUMBER_TABLE
111: , a18 JTF_VARCHAR2_TABLE_100
112: , a19 JTF_DATE_TABLE

Line 110: , a17 JTF_NUMBER_TABLE

106: , a13 JTF_VARCHAR2_TABLE_100
107: , a14 JTF_VARCHAR2_TABLE_100
108: , a15 JTF_NUMBER_TABLE
109: , a16 JTF_VARCHAR2_TABLE_100
110: , a17 JTF_NUMBER_TABLE
111: , a18 JTF_VARCHAR2_TABLE_100
112: , a19 JTF_DATE_TABLE
113: , a20 JTF_DATE_TABLE
114: , a21 JTF_NUMBER_TABLE

Line 114: , a21 JTF_NUMBER_TABLE

110: , a17 JTF_NUMBER_TABLE
111: , a18 JTF_VARCHAR2_TABLE_100
112: , a19 JTF_DATE_TABLE
113: , a20 JTF_DATE_TABLE
114: , a21 JTF_NUMBER_TABLE
115: , a22 JTF_VARCHAR2_TABLE_200
116: , a23 JTF_VARCHAR2_TABLE_100
117: , a24 JTF_NUMBER_TABLE
118: , a25 JTF_VARCHAR2_TABLE_100

Line 117: , a24 JTF_NUMBER_TABLE

113: , a20 JTF_DATE_TABLE
114: , a21 JTF_NUMBER_TABLE
115: , a22 JTF_VARCHAR2_TABLE_200
116: , a23 JTF_VARCHAR2_TABLE_100
117: , a24 JTF_NUMBER_TABLE
118: , a25 JTF_VARCHAR2_TABLE_100
119: , a26 JTF_VARCHAR2_TABLE_100
120: ) as
121: ddindx binary_integer; indx binary_integer;

Line 164: procedure rosetta_table_copy_out_p11(t jtf_assign_pub.assignresources_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

160: end loop;
161: end if;
162: end if;
163: end rosetta_table_copy_in_p11;
164: procedure rosetta_table_copy_out_p11(t jtf_assign_pub.assignresources_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_VARCHAR2_TABLE_100
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_DATE_TABLE

Line 165: , a1 out nocopy JTF_NUMBER_TABLE

161: end if;
162: end if;
163: end rosetta_table_copy_in_p11;
164: procedure rosetta_table_copy_out_p11(t jtf_assign_pub.assignresources_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
165: , a1 out nocopy JTF_NUMBER_TABLE
166: , a2 out nocopy JTF_VARCHAR2_TABLE_100
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_DATE_TABLE
169: , a5 out nocopy JTF_DATE_TABLE

Line 170: , a6 out nocopy JTF_NUMBER_TABLE

166: , a2 out nocopy JTF_VARCHAR2_TABLE_100
167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_DATE_TABLE
169: , a5 out nocopy JTF_DATE_TABLE
170: , a6 out nocopy JTF_NUMBER_TABLE
171: , a7 out nocopy JTF_NUMBER_TABLE
172: , a8 out nocopy JTF_VARCHAR2_TABLE_300
173: , a9 out nocopy JTF_NUMBER_TABLE
174: , a10 out nocopy JTF_NUMBER_TABLE

Line 171: , a7 out nocopy JTF_NUMBER_TABLE

167: , a3 out nocopy JTF_VARCHAR2_TABLE_100
168: , a4 out nocopy JTF_DATE_TABLE
169: , a5 out nocopy JTF_DATE_TABLE
170: , a6 out nocopy JTF_NUMBER_TABLE
171: , a7 out nocopy JTF_NUMBER_TABLE
172: , a8 out nocopy JTF_VARCHAR2_TABLE_300
173: , a9 out nocopy JTF_NUMBER_TABLE
174: , a10 out nocopy JTF_NUMBER_TABLE
175: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 173: , a9 out nocopy JTF_NUMBER_TABLE

169: , a5 out nocopy JTF_DATE_TABLE
170: , a6 out nocopy JTF_NUMBER_TABLE
171: , a7 out nocopy JTF_NUMBER_TABLE
172: , a8 out nocopy JTF_VARCHAR2_TABLE_300
173: , a9 out nocopy JTF_NUMBER_TABLE
174: , a10 out nocopy JTF_NUMBER_TABLE
175: , a11 out nocopy JTF_VARCHAR2_TABLE_100
176: , a12 out nocopy JTF_VARCHAR2_TABLE_100
177: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 174: , a10 out nocopy JTF_NUMBER_TABLE

170: , a6 out nocopy JTF_NUMBER_TABLE
171: , a7 out nocopy JTF_NUMBER_TABLE
172: , a8 out nocopy JTF_VARCHAR2_TABLE_300
173: , a9 out nocopy JTF_NUMBER_TABLE
174: , a10 out nocopy JTF_NUMBER_TABLE
175: , a11 out nocopy JTF_VARCHAR2_TABLE_100
176: , a12 out nocopy JTF_VARCHAR2_TABLE_100
177: , a13 out nocopy JTF_VARCHAR2_TABLE_100
178: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 179: , a15 out nocopy JTF_NUMBER_TABLE

175: , a11 out nocopy JTF_VARCHAR2_TABLE_100
176: , a12 out nocopy JTF_VARCHAR2_TABLE_100
177: , a13 out nocopy JTF_VARCHAR2_TABLE_100
178: , a14 out nocopy JTF_VARCHAR2_TABLE_100
179: , a15 out nocopy JTF_NUMBER_TABLE
180: , a16 out nocopy JTF_VARCHAR2_TABLE_100
181: , a17 out nocopy JTF_NUMBER_TABLE
182: , a18 out nocopy JTF_VARCHAR2_TABLE_100
183: , a19 out nocopy JTF_DATE_TABLE

Line 181: , a17 out nocopy JTF_NUMBER_TABLE

177: , a13 out nocopy JTF_VARCHAR2_TABLE_100
178: , a14 out nocopy JTF_VARCHAR2_TABLE_100
179: , a15 out nocopy JTF_NUMBER_TABLE
180: , a16 out nocopy JTF_VARCHAR2_TABLE_100
181: , a17 out nocopy JTF_NUMBER_TABLE
182: , a18 out nocopy JTF_VARCHAR2_TABLE_100
183: , a19 out nocopy JTF_DATE_TABLE
184: , a20 out nocopy JTF_DATE_TABLE
185: , a21 out nocopy JTF_NUMBER_TABLE

Line 185: , a21 out nocopy JTF_NUMBER_TABLE

181: , a17 out nocopy JTF_NUMBER_TABLE
182: , a18 out nocopy JTF_VARCHAR2_TABLE_100
183: , a19 out nocopy JTF_DATE_TABLE
184: , a20 out nocopy JTF_DATE_TABLE
185: , a21 out nocopy JTF_NUMBER_TABLE
186: , a22 out nocopy JTF_VARCHAR2_TABLE_200
187: , a23 out nocopy JTF_VARCHAR2_TABLE_100
188: , a24 out nocopy JTF_NUMBER_TABLE
189: , a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 188: , a24 out nocopy JTF_NUMBER_TABLE

184: , a20 out nocopy JTF_DATE_TABLE
185: , a21 out nocopy JTF_NUMBER_TABLE
186: , a22 out nocopy JTF_VARCHAR2_TABLE_200
187: , a23 out nocopy JTF_VARCHAR2_TABLE_100
188: , a24 out nocopy JTF_NUMBER_TABLE
189: , a25 out nocopy JTF_VARCHAR2_TABLE_100
190: , a26 out nocopy JTF_VARCHAR2_TABLE_100
191: ) as
192: ddindx binary_integer; indx binary_integer;

Line 195: a0 := JTF_NUMBER_TABLE();

191: ) as
192: ddindx binary_integer; indx binary_integer;
193: begin
194: if t is null or t.count = 0 then
195: a0 := JTF_NUMBER_TABLE();
196: a1 := JTF_NUMBER_TABLE();
197: a2 := JTF_VARCHAR2_TABLE_100();
198: a3 := JTF_VARCHAR2_TABLE_100();
199: a4 := JTF_DATE_TABLE();

Line 196: a1 := JTF_NUMBER_TABLE();

192: ddindx binary_integer; indx binary_integer;
193: begin
194: if t is null or t.count = 0 then
195: a0 := JTF_NUMBER_TABLE();
196: a1 := JTF_NUMBER_TABLE();
197: a2 := JTF_VARCHAR2_TABLE_100();
198: a3 := JTF_VARCHAR2_TABLE_100();
199: a4 := JTF_DATE_TABLE();
200: a5 := JTF_DATE_TABLE();

Line 201: a6 := JTF_NUMBER_TABLE();

197: a2 := JTF_VARCHAR2_TABLE_100();
198: a3 := JTF_VARCHAR2_TABLE_100();
199: a4 := JTF_DATE_TABLE();
200: a5 := JTF_DATE_TABLE();
201: a6 := JTF_NUMBER_TABLE();
202: a7 := JTF_NUMBER_TABLE();
203: a8 := JTF_VARCHAR2_TABLE_300();
204: a9 := JTF_NUMBER_TABLE();
205: a10 := JTF_NUMBER_TABLE();

Line 202: a7 := JTF_NUMBER_TABLE();

198: a3 := JTF_VARCHAR2_TABLE_100();
199: a4 := JTF_DATE_TABLE();
200: a5 := JTF_DATE_TABLE();
201: a6 := JTF_NUMBER_TABLE();
202: a7 := JTF_NUMBER_TABLE();
203: a8 := JTF_VARCHAR2_TABLE_300();
204: a9 := JTF_NUMBER_TABLE();
205: a10 := JTF_NUMBER_TABLE();
206: a11 := JTF_VARCHAR2_TABLE_100();

Line 204: a9 := JTF_NUMBER_TABLE();

200: a5 := JTF_DATE_TABLE();
201: a6 := JTF_NUMBER_TABLE();
202: a7 := JTF_NUMBER_TABLE();
203: a8 := JTF_VARCHAR2_TABLE_300();
204: a9 := JTF_NUMBER_TABLE();
205: a10 := JTF_NUMBER_TABLE();
206: a11 := JTF_VARCHAR2_TABLE_100();
207: a12 := JTF_VARCHAR2_TABLE_100();
208: a13 := JTF_VARCHAR2_TABLE_100();

Line 205: a10 := JTF_NUMBER_TABLE();

201: a6 := JTF_NUMBER_TABLE();
202: a7 := JTF_NUMBER_TABLE();
203: a8 := JTF_VARCHAR2_TABLE_300();
204: a9 := JTF_NUMBER_TABLE();
205: a10 := JTF_NUMBER_TABLE();
206: a11 := JTF_VARCHAR2_TABLE_100();
207: a12 := JTF_VARCHAR2_TABLE_100();
208: a13 := JTF_VARCHAR2_TABLE_100();
209: a14 := JTF_VARCHAR2_TABLE_100();

Line 210: a15 := JTF_NUMBER_TABLE();

206: a11 := JTF_VARCHAR2_TABLE_100();
207: a12 := JTF_VARCHAR2_TABLE_100();
208: a13 := JTF_VARCHAR2_TABLE_100();
209: a14 := JTF_VARCHAR2_TABLE_100();
210: a15 := JTF_NUMBER_TABLE();
211: a16 := JTF_VARCHAR2_TABLE_100();
212: a17 := JTF_NUMBER_TABLE();
213: a18 := JTF_VARCHAR2_TABLE_100();
214: a19 := JTF_DATE_TABLE();

Line 212: a17 := JTF_NUMBER_TABLE();

208: a13 := JTF_VARCHAR2_TABLE_100();
209: a14 := JTF_VARCHAR2_TABLE_100();
210: a15 := JTF_NUMBER_TABLE();
211: a16 := JTF_VARCHAR2_TABLE_100();
212: a17 := JTF_NUMBER_TABLE();
213: a18 := JTF_VARCHAR2_TABLE_100();
214: a19 := JTF_DATE_TABLE();
215: a20 := JTF_DATE_TABLE();
216: a21 := JTF_NUMBER_TABLE();

Line 216: a21 := JTF_NUMBER_TABLE();

212: a17 := JTF_NUMBER_TABLE();
213: a18 := JTF_VARCHAR2_TABLE_100();
214: a19 := JTF_DATE_TABLE();
215: a20 := JTF_DATE_TABLE();
216: a21 := JTF_NUMBER_TABLE();
217: a22 := JTF_VARCHAR2_TABLE_200();
218: a23 := JTF_VARCHAR2_TABLE_100();
219: a24 := JTF_NUMBER_TABLE();
220: a25 := JTF_VARCHAR2_TABLE_100();

Line 219: a24 := JTF_NUMBER_TABLE();

215: a20 := JTF_DATE_TABLE();
216: a21 := JTF_NUMBER_TABLE();
217: a22 := JTF_VARCHAR2_TABLE_200();
218: a23 := JTF_VARCHAR2_TABLE_100();
219: a24 := JTF_NUMBER_TABLE();
220: a25 := JTF_VARCHAR2_TABLE_100();
221: a26 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_NUMBER_TABLE();

Line 223: a0 := JTF_NUMBER_TABLE();

219: a24 := JTF_NUMBER_TABLE();
220: a25 := JTF_VARCHAR2_TABLE_100();
221: a26 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_NUMBER_TABLE();
225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_VARCHAR2_TABLE_100();
227: a4 := JTF_DATE_TABLE();

Line 224: a1 := JTF_NUMBER_TABLE();

220: a25 := JTF_VARCHAR2_TABLE_100();
221: a26 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_NUMBER_TABLE();
225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_VARCHAR2_TABLE_100();
227: a4 := JTF_DATE_TABLE();
228: a5 := JTF_DATE_TABLE();

Line 229: a6 := JTF_NUMBER_TABLE();

225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_VARCHAR2_TABLE_100();
227: a4 := JTF_DATE_TABLE();
228: a5 := JTF_DATE_TABLE();
229: a6 := JTF_NUMBER_TABLE();
230: a7 := JTF_NUMBER_TABLE();
231: a8 := JTF_VARCHAR2_TABLE_300();
232: a9 := JTF_NUMBER_TABLE();
233: a10 := JTF_NUMBER_TABLE();

Line 230: a7 := JTF_NUMBER_TABLE();

226: a3 := JTF_VARCHAR2_TABLE_100();
227: a4 := JTF_DATE_TABLE();
228: a5 := JTF_DATE_TABLE();
229: a6 := JTF_NUMBER_TABLE();
230: a7 := JTF_NUMBER_TABLE();
231: a8 := JTF_VARCHAR2_TABLE_300();
232: a9 := JTF_NUMBER_TABLE();
233: a10 := JTF_NUMBER_TABLE();
234: a11 := JTF_VARCHAR2_TABLE_100();

Line 232: a9 := JTF_NUMBER_TABLE();

228: a5 := JTF_DATE_TABLE();
229: a6 := JTF_NUMBER_TABLE();
230: a7 := JTF_NUMBER_TABLE();
231: a8 := JTF_VARCHAR2_TABLE_300();
232: a9 := JTF_NUMBER_TABLE();
233: a10 := JTF_NUMBER_TABLE();
234: a11 := JTF_VARCHAR2_TABLE_100();
235: a12 := JTF_VARCHAR2_TABLE_100();
236: a13 := JTF_VARCHAR2_TABLE_100();

Line 233: a10 := JTF_NUMBER_TABLE();

229: a6 := JTF_NUMBER_TABLE();
230: a7 := JTF_NUMBER_TABLE();
231: a8 := JTF_VARCHAR2_TABLE_300();
232: a9 := JTF_NUMBER_TABLE();
233: a10 := JTF_NUMBER_TABLE();
234: a11 := JTF_VARCHAR2_TABLE_100();
235: a12 := JTF_VARCHAR2_TABLE_100();
236: a13 := JTF_VARCHAR2_TABLE_100();
237: a14 := JTF_VARCHAR2_TABLE_100();

Line 238: a15 := JTF_NUMBER_TABLE();

234: a11 := JTF_VARCHAR2_TABLE_100();
235: a12 := JTF_VARCHAR2_TABLE_100();
236: a13 := JTF_VARCHAR2_TABLE_100();
237: a14 := JTF_VARCHAR2_TABLE_100();
238: a15 := JTF_NUMBER_TABLE();
239: a16 := JTF_VARCHAR2_TABLE_100();
240: a17 := JTF_NUMBER_TABLE();
241: a18 := JTF_VARCHAR2_TABLE_100();
242: a19 := JTF_DATE_TABLE();

Line 240: a17 := JTF_NUMBER_TABLE();

236: a13 := JTF_VARCHAR2_TABLE_100();
237: a14 := JTF_VARCHAR2_TABLE_100();
238: a15 := JTF_NUMBER_TABLE();
239: a16 := JTF_VARCHAR2_TABLE_100();
240: a17 := JTF_NUMBER_TABLE();
241: a18 := JTF_VARCHAR2_TABLE_100();
242: a19 := JTF_DATE_TABLE();
243: a20 := JTF_DATE_TABLE();
244: a21 := JTF_NUMBER_TABLE();

Line 244: a21 := JTF_NUMBER_TABLE();

240: a17 := JTF_NUMBER_TABLE();
241: a18 := JTF_VARCHAR2_TABLE_100();
242: a19 := JTF_DATE_TABLE();
243: a20 := JTF_DATE_TABLE();
244: a21 := JTF_NUMBER_TABLE();
245: a22 := JTF_VARCHAR2_TABLE_200();
246: a23 := JTF_VARCHAR2_TABLE_100();
247: a24 := JTF_NUMBER_TABLE();
248: a25 := JTF_VARCHAR2_TABLE_100();

Line 247: a24 := JTF_NUMBER_TABLE();

243: a20 := JTF_DATE_TABLE();
244: a21 := JTF_NUMBER_TABLE();
245: a22 := JTF_VARCHAR2_TABLE_200();
246: a23 := JTF_VARCHAR2_TABLE_100();
247: a24 := JTF_NUMBER_TABLE();
248: a25 := JTF_VARCHAR2_TABLE_100();
249: a26 := JTF_VARCHAR2_TABLE_100();
250: if t.count > 0 then
251: a0.extend(t.count);

Line 318: procedure rosetta_table_copy_in_p24(t out nocopy jtf_assign_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE

314: end if;
315: end if;
316: end rosetta_table_copy_out_p11;
317:
318: procedure rosetta_table_copy_in_p24(t out nocopy jtf_assign_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
319: , a1 JTF_VARCHAR2_TABLE_100
320: , a2 JTF_VARCHAR2_TABLE_100
321: , a3 JTF_VARCHAR2_TABLE_100
322: , a4 JTF_VARCHAR2_TABLE_100

Line 345: procedure rosetta_table_copy_out_p24(t jtf_assign_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

341: end loop;
342: end if;
343: end if;
344: end rosetta_table_copy_in_p24;
345: procedure rosetta_table_copy_out_p24(t jtf_assign_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
346: , a1 out nocopy JTF_VARCHAR2_TABLE_100
347: , a2 out nocopy JTF_VARCHAR2_TABLE_100
348: , a3 out nocopy JTF_VARCHAR2_TABLE_100
349: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 354: a0 := JTF_NUMBER_TABLE();

350: ) as
351: ddindx binary_integer; indx binary_integer;
352: begin
353: if t is null or t.count = 0 then
354: a0 := JTF_NUMBER_TABLE();
355: a1 := JTF_VARCHAR2_TABLE_100();
356: a2 := JTF_VARCHAR2_TABLE_100();
357: a3 := JTF_VARCHAR2_TABLE_100();
358: a4 := JTF_VARCHAR2_TABLE_100();

Line 360: a0 := JTF_NUMBER_TABLE();

356: a2 := JTF_VARCHAR2_TABLE_100();
357: a3 := JTF_VARCHAR2_TABLE_100();
358: a4 := JTF_VARCHAR2_TABLE_100();
359: else
360: a0 := JTF_NUMBER_TABLE();
361: a1 := JTF_VARCHAR2_TABLE_100();
362: a2 := JTF_VARCHAR2_TABLE_100();
363: a3 := JTF_VARCHAR2_TABLE_100();
364: a4 := JTF_VARCHAR2_TABLE_100();

Line 389: procedure rosetta_table_copy_in_p26(t out nocopy jtf_assign_pub.preferred_engineers_tbl_type, a0 JTF_NUMBER_TABLE

385: end if;
386: end if;
387: end rosetta_table_copy_out_p24;
388:
389: procedure rosetta_table_copy_in_p26(t out nocopy jtf_assign_pub.preferred_engineers_tbl_type, a0 JTF_NUMBER_TABLE
390: , a1 JTF_VARCHAR2_TABLE_100
391: , a2 JTF_VARCHAR2_TABLE_100
392: , a3 JTF_VARCHAR2_TABLE_100
393: ) as

Line 414: procedure rosetta_table_copy_out_p26(t jtf_assign_pub.preferred_engineers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

410: end loop;
411: end if;
412: end if;
413: end rosetta_table_copy_in_p26;
414: procedure rosetta_table_copy_out_p26(t jtf_assign_pub.preferred_engineers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
415: , a1 out nocopy JTF_VARCHAR2_TABLE_100
416: , a2 out nocopy JTF_VARCHAR2_TABLE_100
417: , a3 out nocopy JTF_VARCHAR2_TABLE_100
418: ) as

Line 422: a0 := JTF_NUMBER_TABLE();

418: ) as
419: ddindx binary_integer; indx binary_integer;
420: begin
421: if t is null or t.count = 0 then
422: a0 := JTF_NUMBER_TABLE();
423: a1 := JTF_VARCHAR2_TABLE_100();
424: a2 := JTF_VARCHAR2_TABLE_100();
425: a3 := JTF_VARCHAR2_TABLE_100();
426: else

Line 427: a0 := JTF_NUMBER_TABLE();

423: a1 := JTF_VARCHAR2_TABLE_100();
424: a2 := JTF_VARCHAR2_TABLE_100();
425: a3 := JTF_VARCHAR2_TABLE_100();
426: else
427: a0 := JTF_NUMBER_TABLE();
428: a1 := JTF_VARCHAR2_TABLE_100();
429: a2 := JTF_VARCHAR2_TABLE_100();
430: a3 := JTF_VARCHAR2_TABLE_100();
431: if t.count > 0 then

Line 453: procedure rosetta_table_copy_in_p28(t out nocopy jtf_assign_pub.escalations_tbl_type, a0 JTF_NUMBER_TABLE

449: end if;
450: end if;
451: end rosetta_table_copy_out_p26;
452:
453: procedure rosetta_table_copy_in_p28(t out nocopy jtf_assign_pub.escalations_tbl_type, a0 JTF_NUMBER_TABLE
454: , a1 JTF_VARCHAR2_TABLE_100
455: ) as
456: ddindx binary_integer; indx binary_integer;
457: begin

Line 474: procedure rosetta_table_copy_out_p28(t jtf_assign_pub.escalations_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

470: end loop;
471: end if;
472: end if;
473: end rosetta_table_copy_in_p28;
474: procedure rosetta_table_copy_out_p28(t jtf_assign_pub.escalations_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
475: , a1 out nocopy JTF_VARCHAR2_TABLE_100
476: ) as
477: ddindx binary_integer; indx binary_integer;
478: begin

Line 480: a0 := JTF_NUMBER_TABLE();

476: ) as
477: ddindx binary_integer; indx binary_integer;
478: begin
479: if t is null or t.count = 0 then
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_VARCHAR2_TABLE_100();
482: else
483: a0 := JTF_NUMBER_TABLE();
484: a1 := JTF_VARCHAR2_TABLE_100();

Line 483: a0 := JTF_NUMBER_TABLE();

479: if t is null or t.count = 0 then
480: a0 := JTF_NUMBER_TABLE();
481: a1 := JTF_VARCHAR2_TABLE_100();
482: else
483: a0 := JTF_NUMBER_TABLE();
484: a1 := JTF_VARCHAR2_TABLE_100();
485: if t.count > 0 then
486: a0.extend(t.count);
487: a1.extend(t.count);

Line 503: procedure rosetta_table_copy_in_p30(t out nocopy jtf_assign_pub.excluded_tbl_type, a0 JTF_NUMBER_TABLE

499: end if;
500: end if;
501: end rosetta_table_copy_out_p28;
502:
503: procedure rosetta_table_copy_in_p30(t out nocopy jtf_assign_pub.excluded_tbl_type, a0 JTF_NUMBER_TABLE
504: , a1 JTF_VARCHAR2_TABLE_100
505: ) as
506: ddindx binary_integer; indx binary_integer;
507: begin

Line 524: procedure rosetta_table_copy_out_p30(t jtf_assign_pub.excluded_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

520: end loop;
521: end if;
522: end if;
523: end rosetta_table_copy_in_p30;
524: procedure rosetta_table_copy_out_p30(t jtf_assign_pub.excluded_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
525: , a1 out nocopy JTF_VARCHAR2_TABLE_100
526: ) as
527: ddindx binary_integer; indx binary_integer;
528: begin

Line 530: a0 := JTF_NUMBER_TABLE();

526: ) as
527: ddindx binary_integer; indx binary_integer;
528: begin
529: if t is null or t.count = 0 then
530: a0 := JTF_NUMBER_TABLE();
531: a1 := JTF_VARCHAR2_TABLE_100();
532: else
533: a0 := JTF_NUMBER_TABLE();
534: a1 := JTF_VARCHAR2_TABLE_100();

Line 533: a0 := JTF_NUMBER_TABLE();

529: if t is null or t.count = 0 then
530: a0 := JTF_NUMBER_TABLE();
531: a1 := JTF_VARCHAR2_TABLE_100();
532: else
533: a0 := JTF_NUMBER_TABLE();
534: a1 := JTF_VARCHAR2_TABLE_100();
535: if t.count > 0 then
536: a0.extend(t.count);
537: a1.extend(t.count);

Line 582: , p32_a0 out nocopy JTF_NUMBER_TABLE

578: , p_column_list VARCHAR2
579: , p_business_process_id NUMBER
580: , p_business_process_date date
581: , p_filter_excluded_resource VARCHAR2
582: , p32_a0 out nocopy JTF_NUMBER_TABLE
583: , p32_a1 out nocopy JTF_NUMBER_TABLE
584: , p32_a2 out nocopy JTF_VARCHAR2_TABLE_100
585: , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
586: , p32_a4 out nocopy JTF_DATE_TABLE

Line 583: , p32_a1 out nocopy JTF_NUMBER_TABLE

579: , p_business_process_id NUMBER
580: , p_business_process_date date
581: , p_filter_excluded_resource VARCHAR2
582: , p32_a0 out nocopy JTF_NUMBER_TABLE
583: , p32_a1 out nocopy JTF_NUMBER_TABLE
584: , p32_a2 out nocopy JTF_VARCHAR2_TABLE_100
585: , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
586: , p32_a4 out nocopy JTF_DATE_TABLE
587: , p32_a5 out nocopy JTF_DATE_TABLE

Line 588: , p32_a6 out nocopy JTF_NUMBER_TABLE

584: , p32_a2 out nocopy JTF_VARCHAR2_TABLE_100
585: , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
586: , p32_a4 out nocopy JTF_DATE_TABLE
587: , p32_a5 out nocopy JTF_DATE_TABLE
588: , p32_a6 out nocopy JTF_NUMBER_TABLE
589: , p32_a7 out nocopy JTF_NUMBER_TABLE
590: , p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
591: , p32_a9 out nocopy JTF_NUMBER_TABLE
592: , p32_a10 out nocopy JTF_NUMBER_TABLE

Line 589: , p32_a7 out nocopy JTF_NUMBER_TABLE

585: , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
586: , p32_a4 out nocopy JTF_DATE_TABLE
587: , p32_a5 out nocopy JTF_DATE_TABLE
588: , p32_a6 out nocopy JTF_NUMBER_TABLE
589: , p32_a7 out nocopy JTF_NUMBER_TABLE
590: , p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
591: , p32_a9 out nocopy JTF_NUMBER_TABLE
592: , p32_a10 out nocopy JTF_NUMBER_TABLE
593: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 591: , p32_a9 out nocopy JTF_NUMBER_TABLE

587: , p32_a5 out nocopy JTF_DATE_TABLE
588: , p32_a6 out nocopy JTF_NUMBER_TABLE
589: , p32_a7 out nocopy JTF_NUMBER_TABLE
590: , p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
591: , p32_a9 out nocopy JTF_NUMBER_TABLE
592: , p32_a10 out nocopy JTF_NUMBER_TABLE
593: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
594: , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
595: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 592: , p32_a10 out nocopy JTF_NUMBER_TABLE

588: , p32_a6 out nocopy JTF_NUMBER_TABLE
589: , p32_a7 out nocopy JTF_NUMBER_TABLE
590: , p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
591: , p32_a9 out nocopy JTF_NUMBER_TABLE
592: , p32_a10 out nocopy JTF_NUMBER_TABLE
593: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
594: , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
595: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
596: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 597: , p32_a15 out nocopy JTF_NUMBER_TABLE

593: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
594: , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
595: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
596: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
597: , p32_a15 out nocopy JTF_NUMBER_TABLE
598: , p32_a16 out nocopy JTF_VARCHAR2_TABLE_100
599: , p32_a17 out nocopy JTF_NUMBER_TABLE
600: , p32_a18 out nocopy JTF_VARCHAR2_TABLE_100
601: , p32_a19 out nocopy JTF_DATE_TABLE

Line 599: , p32_a17 out nocopy JTF_NUMBER_TABLE

595: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
596: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
597: , p32_a15 out nocopy JTF_NUMBER_TABLE
598: , p32_a16 out nocopy JTF_VARCHAR2_TABLE_100
599: , p32_a17 out nocopy JTF_NUMBER_TABLE
600: , p32_a18 out nocopy JTF_VARCHAR2_TABLE_100
601: , p32_a19 out nocopy JTF_DATE_TABLE
602: , p32_a20 out nocopy JTF_DATE_TABLE
603: , p32_a21 out nocopy JTF_NUMBER_TABLE

Line 603: , p32_a21 out nocopy JTF_NUMBER_TABLE

599: , p32_a17 out nocopy JTF_NUMBER_TABLE
600: , p32_a18 out nocopy JTF_VARCHAR2_TABLE_100
601: , p32_a19 out nocopy JTF_DATE_TABLE
602: , p32_a20 out nocopy JTF_DATE_TABLE
603: , p32_a21 out nocopy JTF_NUMBER_TABLE
604: , p32_a22 out nocopy JTF_VARCHAR2_TABLE_200
605: , p32_a23 out nocopy JTF_VARCHAR2_TABLE_100
606: , p32_a24 out nocopy JTF_NUMBER_TABLE
607: , p32_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 606: , p32_a24 out nocopy JTF_NUMBER_TABLE

602: , p32_a20 out nocopy JTF_DATE_TABLE
603: , p32_a21 out nocopy JTF_NUMBER_TABLE
604: , p32_a22 out nocopy JTF_VARCHAR2_TABLE_200
605: , p32_a23 out nocopy JTF_VARCHAR2_TABLE_100
606: , p32_a24 out nocopy JTF_NUMBER_TABLE
607: , p32_a25 out nocopy JTF_VARCHAR2_TABLE_100
608: , p32_a26 out nocopy JTF_VARCHAR2_TABLE_100
609: , x_return_status out nocopy VARCHAR2
610: , x_msg_count out nocopy NUMBER

Line 1143: , p20_a0 out nocopy JTF_NUMBER_TABLE

1139: , p_column_list VARCHAR2
1140: , p_business_process_id NUMBER
1141: , p_business_process_date date
1142: , p_filter_excluded_resource VARCHAR2
1143: , p20_a0 out nocopy JTF_NUMBER_TABLE
1144: , p20_a1 out nocopy JTF_NUMBER_TABLE
1145: , p20_a2 out nocopy JTF_VARCHAR2_TABLE_100
1146: , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
1147: , p20_a4 out nocopy JTF_DATE_TABLE

Line 1144: , p20_a1 out nocopy JTF_NUMBER_TABLE

1140: , p_business_process_id NUMBER
1141: , p_business_process_date date
1142: , p_filter_excluded_resource VARCHAR2
1143: , p20_a0 out nocopy JTF_NUMBER_TABLE
1144: , p20_a1 out nocopy JTF_NUMBER_TABLE
1145: , p20_a2 out nocopy JTF_VARCHAR2_TABLE_100
1146: , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
1147: , p20_a4 out nocopy JTF_DATE_TABLE
1148: , p20_a5 out nocopy JTF_DATE_TABLE

Line 1149: , p20_a6 out nocopy JTF_NUMBER_TABLE

1145: , p20_a2 out nocopy JTF_VARCHAR2_TABLE_100
1146: , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
1147: , p20_a4 out nocopy JTF_DATE_TABLE
1148: , p20_a5 out nocopy JTF_DATE_TABLE
1149: , p20_a6 out nocopy JTF_NUMBER_TABLE
1150: , p20_a7 out nocopy JTF_NUMBER_TABLE
1151: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
1152: , p20_a9 out nocopy JTF_NUMBER_TABLE
1153: , p20_a10 out nocopy JTF_NUMBER_TABLE

Line 1150: , p20_a7 out nocopy JTF_NUMBER_TABLE

1146: , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
1147: , p20_a4 out nocopy JTF_DATE_TABLE
1148: , p20_a5 out nocopy JTF_DATE_TABLE
1149: , p20_a6 out nocopy JTF_NUMBER_TABLE
1150: , p20_a7 out nocopy JTF_NUMBER_TABLE
1151: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
1152: , p20_a9 out nocopy JTF_NUMBER_TABLE
1153: , p20_a10 out nocopy JTF_NUMBER_TABLE
1154: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 1152: , p20_a9 out nocopy JTF_NUMBER_TABLE

1148: , p20_a5 out nocopy JTF_DATE_TABLE
1149: , p20_a6 out nocopy JTF_NUMBER_TABLE
1150: , p20_a7 out nocopy JTF_NUMBER_TABLE
1151: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
1152: , p20_a9 out nocopy JTF_NUMBER_TABLE
1153: , p20_a10 out nocopy JTF_NUMBER_TABLE
1154: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
1155: , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
1156: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 1153: , p20_a10 out nocopy JTF_NUMBER_TABLE

1149: , p20_a6 out nocopy JTF_NUMBER_TABLE
1150: , p20_a7 out nocopy JTF_NUMBER_TABLE
1151: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
1152: , p20_a9 out nocopy JTF_NUMBER_TABLE
1153: , p20_a10 out nocopy JTF_NUMBER_TABLE
1154: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
1155: , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
1156: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
1157: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 1158: , p20_a15 out nocopy JTF_NUMBER_TABLE

1154: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
1155: , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
1156: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
1157: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
1158: , p20_a15 out nocopy JTF_NUMBER_TABLE
1159: , p20_a16 out nocopy JTF_VARCHAR2_TABLE_100
1160: , p20_a17 out nocopy JTF_NUMBER_TABLE
1161: , p20_a18 out nocopy JTF_VARCHAR2_TABLE_100
1162: , p20_a19 out nocopy JTF_DATE_TABLE

Line 1160: , p20_a17 out nocopy JTF_NUMBER_TABLE

1156: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
1157: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
1158: , p20_a15 out nocopy JTF_NUMBER_TABLE
1159: , p20_a16 out nocopy JTF_VARCHAR2_TABLE_100
1160: , p20_a17 out nocopy JTF_NUMBER_TABLE
1161: , p20_a18 out nocopy JTF_VARCHAR2_TABLE_100
1162: , p20_a19 out nocopy JTF_DATE_TABLE
1163: , p20_a20 out nocopy JTF_DATE_TABLE
1164: , p20_a21 out nocopy JTF_NUMBER_TABLE

Line 1164: , p20_a21 out nocopy JTF_NUMBER_TABLE

1160: , p20_a17 out nocopy JTF_NUMBER_TABLE
1161: , p20_a18 out nocopy JTF_VARCHAR2_TABLE_100
1162: , p20_a19 out nocopy JTF_DATE_TABLE
1163: , p20_a20 out nocopy JTF_DATE_TABLE
1164: , p20_a21 out nocopy JTF_NUMBER_TABLE
1165: , p20_a22 out nocopy JTF_VARCHAR2_TABLE_200
1166: , p20_a23 out nocopy JTF_VARCHAR2_TABLE_100
1167: , p20_a24 out nocopy JTF_NUMBER_TABLE
1168: , p20_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 1167: , p20_a24 out nocopy JTF_NUMBER_TABLE

1163: , p20_a20 out nocopy JTF_DATE_TABLE
1164: , p20_a21 out nocopy JTF_NUMBER_TABLE
1165: , p20_a22 out nocopy JTF_VARCHAR2_TABLE_200
1166: , p20_a23 out nocopy JTF_VARCHAR2_TABLE_100
1167: , p20_a24 out nocopy JTF_NUMBER_TABLE
1168: , p20_a25 out nocopy JTF_VARCHAR2_TABLE_100
1169: , p20_a26 out nocopy JTF_VARCHAR2_TABLE_100
1170: , x_return_status out nocopy VARCHAR2
1171: , x_msg_count out nocopy NUMBER

Line 1317: , p27_a0 out nocopy JTF_NUMBER_TABLE

1313: , p_column_list VARCHAR2
1314: , p_business_process_id NUMBER
1315: , p_business_process_date date
1316: , p_filter_excluded_resource VARCHAR2
1317: , p27_a0 out nocopy JTF_NUMBER_TABLE
1318: , p27_a1 out nocopy JTF_NUMBER_TABLE
1319: , p27_a2 out nocopy JTF_VARCHAR2_TABLE_100
1320: , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
1321: , p27_a4 out nocopy JTF_DATE_TABLE

Line 1318: , p27_a1 out nocopy JTF_NUMBER_TABLE

1314: , p_business_process_id NUMBER
1315: , p_business_process_date date
1316: , p_filter_excluded_resource VARCHAR2
1317: , p27_a0 out nocopy JTF_NUMBER_TABLE
1318: , p27_a1 out nocopy JTF_NUMBER_TABLE
1319: , p27_a2 out nocopy JTF_VARCHAR2_TABLE_100
1320: , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
1321: , p27_a4 out nocopy JTF_DATE_TABLE
1322: , p27_a5 out nocopy JTF_DATE_TABLE

Line 1323: , p27_a6 out nocopy JTF_NUMBER_TABLE

1319: , p27_a2 out nocopy JTF_VARCHAR2_TABLE_100
1320: , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
1321: , p27_a4 out nocopy JTF_DATE_TABLE
1322: , p27_a5 out nocopy JTF_DATE_TABLE
1323: , p27_a6 out nocopy JTF_NUMBER_TABLE
1324: , p27_a7 out nocopy JTF_NUMBER_TABLE
1325: , p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
1326: , p27_a9 out nocopy JTF_NUMBER_TABLE
1327: , p27_a10 out nocopy JTF_NUMBER_TABLE

Line 1324: , p27_a7 out nocopy JTF_NUMBER_TABLE

1320: , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
1321: , p27_a4 out nocopy JTF_DATE_TABLE
1322: , p27_a5 out nocopy JTF_DATE_TABLE
1323: , p27_a6 out nocopy JTF_NUMBER_TABLE
1324: , p27_a7 out nocopy JTF_NUMBER_TABLE
1325: , p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
1326: , p27_a9 out nocopy JTF_NUMBER_TABLE
1327: , p27_a10 out nocopy JTF_NUMBER_TABLE
1328: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 1326: , p27_a9 out nocopy JTF_NUMBER_TABLE

1322: , p27_a5 out nocopy JTF_DATE_TABLE
1323: , p27_a6 out nocopy JTF_NUMBER_TABLE
1324: , p27_a7 out nocopy JTF_NUMBER_TABLE
1325: , p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
1326: , p27_a9 out nocopy JTF_NUMBER_TABLE
1327: , p27_a10 out nocopy JTF_NUMBER_TABLE
1328: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
1329: , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
1330: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 1327: , p27_a10 out nocopy JTF_NUMBER_TABLE

1323: , p27_a6 out nocopy JTF_NUMBER_TABLE
1324: , p27_a7 out nocopy JTF_NUMBER_TABLE
1325: , p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
1326: , p27_a9 out nocopy JTF_NUMBER_TABLE
1327: , p27_a10 out nocopy JTF_NUMBER_TABLE
1328: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
1329: , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
1330: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
1331: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 1332: , p27_a15 out nocopy JTF_NUMBER_TABLE

1328: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
1329: , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
1330: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
1331: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
1332: , p27_a15 out nocopy JTF_NUMBER_TABLE
1333: , p27_a16 out nocopy JTF_VARCHAR2_TABLE_100
1334: , p27_a17 out nocopy JTF_NUMBER_TABLE
1335: , p27_a18 out nocopy JTF_VARCHAR2_TABLE_100
1336: , p27_a19 out nocopy JTF_DATE_TABLE

Line 1334: , p27_a17 out nocopy JTF_NUMBER_TABLE

1330: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
1331: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
1332: , p27_a15 out nocopy JTF_NUMBER_TABLE
1333: , p27_a16 out nocopy JTF_VARCHAR2_TABLE_100
1334: , p27_a17 out nocopy JTF_NUMBER_TABLE
1335: , p27_a18 out nocopy JTF_VARCHAR2_TABLE_100
1336: , p27_a19 out nocopy JTF_DATE_TABLE
1337: , p27_a20 out nocopy JTF_DATE_TABLE
1338: , p27_a21 out nocopy JTF_NUMBER_TABLE

Line 1338: , p27_a21 out nocopy JTF_NUMBER_TABLE

1334: , p27_a17 out nocopy JTF_NUMBER_TABLE
1335: , p27_a18 out nocopy JTF_VARCHAR2_TABLE_100
1336: , p27_a19 out nocopy JTF_DATE_TABLE
1337: , p27_a20 out nocopy JTF_DATE_TABLE
1338: , p27_a21 out nocopy JTF_NUMBER_TABLE
1339: , p27_a22 out nocopy JTF_VARCHAR2_TABLE_200
1340: , p27_a23 out nocopy JTF_VARCHAR2_TABLE_100
1341: , p27_a24 out nocopy JTF_NUMBER_TABLE
1342: , p27_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 1341: , p27_a24 out nocopy JTF_NUMBER_TABLE

1337: , p27_a20 out nocopy JTF_DATE_TABLE
1338: , p27_a21 out nocopy JTF_NUMBER_TABLE
1339: , p27_a22 out nocopy JTF_VARCHAR2_TABLE_200
1340: , p27_a23 out nocopy JTF_VARCHAR2_TABLE_100
1341: , p27_a24 out nocopy JTF_NUMBER_TABLE
1342: , p27_a25 out nocopy JTF_VARCHAR2_TABLE_100
1343: , p27_a26 out nocopy JTF_VARCHAR2_TABLE_100
1344: , x_return_status out nocopy VARCHAR2
1345: , x_msg_count out nocopy NUMBER

Line 1613: , p15_a0 out nocopy JTF_NUMBER_TABLE

1609: , p_territory_flag VARCHAR2
1610: , p_calendar_flag VARCHAR2
1611: , p_business_process_id NUMBER
1612: , p_business_process_date date
1613: , p15_a0 out nocopy JTF_NUMBER_TABLE
1614: , p15_a1 out nocopy JTF_NUMBER_TABLE
1615: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
1616: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p15_a4 out nocopy JTF_DATE_TABLE

Line 1614: , p15_a1 out nocopy JTF_NUMBER_TABLE

1610: , p_calendar_flag VARCHAR2
1611: , p_business_process_id NUMBER
1612: , p_business_process_date date
1613: , p15_a0 out nocopy JTF_NUMBER_TABLE
1614: , p15_a1 out nocopy JTF_NUMBER_TABLE
1615: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
1616: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p15_a4 out nocopy JTF_DATE_TABLE
1618: , p15_a5 out nocopy JTF_DATE_TABLE

Line 1619: , p15_a6 out nocopy JTF_NUMBER_TABLE

1615: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
1616: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p15_a4 out nocopy JTF_DATE_TABLE
1618: , p15_a5 out nocopy JTF_DATE_TABLE
1619: , p15_a6 out nocopy JTF_NUMBER_TABLE
1620: , p15_a7 out nocopy JTF_NUMBER_TABLE
1621: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
1622: , p15_a9 out nocopy JTF_NUMBER_TABLE
1623: , p15_a10 out nocopy JTF_NUMBER_TABLE

Line 1620: , p15_a7 out nocopy JTF_NUMBER_TABLE

1616: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
1617: , p15_a4 out nocopy JTF_DATE_TABLE
1618: , p15_a5 out nocopy JTF_DATE_TABLE
1619: , p15_a6 out nocopy JTF_NUMBER_TABLE
1620: , p15_a7 out nocopy JTF_NUMBER_TABLE
1621: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
1622: , p15_a9 out nocopy JTF_NUMBER_TABLE
1623: , p15_a10 out nocopy JTF_NUMBER_TABLE
1624: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 1622: , p15_a9 out nocopy JTF_NUMBER_TABLE

1618: , p15_a5 out nocopy JTF_DATE_TABLE
1619: , p15_a6 out nocopy JTF_NUMBER_TABLE
1620: , p15_a7 out nocopy JTF_NUMBER_TABLE
1621: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
1622: , p15_a9 out nocopy JTF_NUMBER_TABLE
1623: , p15_a10 out nocopy JTF_NUMBER_TABLE
1624: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
1625: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
1626: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 1623: , p15_a10 out nocopy JTF_NUMBER_TABLE

1619: , p15_a6 out nocopy JTF_NUMBER_TABLE
1620: , p15_a7 out nocopy JTF_NUMBER_TABLE
1621: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
1622: , p15_a9 out nocopy JTF_NUMBER_TABLE
1623: , p15_a10 out nocopy JTF_NUMBER_TABLE
1624: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
1625: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
1626: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
1627: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 1628: , p15_a15 out nocopy JTF_NUMBER_TABLE

1624: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
1625: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
1626: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
1627: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
1628: , p15_a15 out nocopy JTF_NUMBER_TABLE
1629: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
1630: , p15_a17 out nocopy JTF_NUMBER_TABLE
1631: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
1632: , p15_a19 out nocopy JTF_DATE_TABLE

Line 1630: , p15_a17 out nocopy JTF_NUMBER_TABLE

1626: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
1627: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
1628: , p15_a15 out nocopy JTF_NUMBER_TABLE
1629: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
1630: , p15_a17 out nocopy JTF_NUMBER_TABLE
1631: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
1632: , p15_a19 out nocopy JTF_DATE_TABLE
1633: , p15_a20 out nocopy JTF_DATE_TABLE
1634: , p15_a21 out nocopy JTF_NUMBER_TABLE

Line 1634: , p15_a21 out nocopy JTF_NUMBER_TABLE

1630: , p15_a17 out nocopy JTF_NUMBER_TABLE
1631: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
1632: , p15_a19 out nocopy JTF_DATE_TABLE
1633: , p15_a20 out nocopy JTF_DATE_TABLE
1634: , p15_a21 out nocopy JTF_NUMBER_TABLE
1635: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
1636: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
1637: , p15_a24 out nocopy JTF_NUMBER_TABLE
1638: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 1637: , p15_a24 out nocopy JTF_NUMBER_TABLE

1633: , p15_a20 out nocopy JTF_DATE_TABLE
1634: , p15_a21 out nocopy JTF_NUMBER_TABLE
1635: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
1636: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
1637: , p15_a24 out nocopy JTF_NUMBER_TABLE
1638: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
1639: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
1640: , x_return_status out nocopy VARCHAR2
1641: , x_msg_count out nocopy NUMBER

Line 1863: , p15_a0 out nocopy JTF_NUMBER_TABLE

1859: , p_territory_flag VARCHAR2
1860: , p_calendar_flag VARCHAR2
1861: , p_business_process_id NUMBER
1862: , p_business_process_date date
1863: , p15_a0 out nocopy JTF_NUMBER_TABLE
1864: , p15_a1 out nocopy JTF_NUMBER_TABLE
1865: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
1866: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
1867: , p15_a4 out nocopy JTF_DATE_TABLE

Line 1864: , p15_a1 out nocopy JTF_NUMBER_TABLE

1860: , p_calendar_flag VARCHAR2
1861: , p_business_process_id NUMBER
1862: , p_business_process_date date
1863: , p15_a0 out nocopy JTF_NUMBER_TABLE
1864: , p15_a1 out nocopy JTF_NUMBER_TABLE
1865: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
1866: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
1867: , p15_a4 out nocopy JTF_DATE_TABLE
1868: , p15_a5 out nocopy JTF_DATE_TABLE

Line 1869: , p15_a6 out nocopy JTF_NUMBER_TABLE

1865: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
1866: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
1867: , p15_a4 out nocopy JTF_DATE_TABLE
1868: , p15_a5 out nocopy JTF_DATE_TABLE
1869: , p15_a6 out nocopy JTF_NUMBER_TABLE
1870: , p15_a7 out nocopy JTF_NUMBER_TABLE
1871: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
1872: , p15_a9 out nocopy JTF_NUMBER_TABLE
1873: , p15_a10 out nocopy JTF_NUMBER_TABLE

Line 1870: , p15_a7 out nocopy JTF_NUMBER_TABLE

1866: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
1867: , p15_a4 out nocopy JTF_DATE_TABLE
1868: , p15_a5 out nocopy JTF_DATE_TABLE
1869: , p15_a6 out nocopy JTF_NUMBER_TABLE
1870: , p15_a7 out nocopy JTF_NUMBER_TABLE
1871: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
1872: , p15_a9 out nocopy JTF_NUMBER_TABLE
1873: , p15_a10 out nocopy JTF_NUMBER_TABLE
1874: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 1872: , p15_a9 out nocopy JTF_NUMBER_TABLE

1868: , p15_a5 out nocopy JTF_DATE_TABLE
1869: , p15_a6 out nocopy JTF_NUMBER_TABLE
1870: , p15_a7 out nocopy JTF_NUMBER_TABLE
1871: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
1872: , p15_a9 out nocopy JTF_NUMBER_TABLE
1873: , p15_a10 out nocopy JTF_NUMBER_TABLE
1874: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
1875: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
1876: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 1873: , p15_a10 out nocopy JTF_NUMBER_TABLE

1869: , p15_a6 out nocopy JTF_NUMBER_TABLE
1870: , p15_a7 out nocopy JTF_NUMBER_TABLE
1871: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
1872: , p15_a9 out nocopy JTF_NUMBER_TABLE
1873: , p15_a10 out nocopy JTF_NUMBER_TABLE
1874: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
1875: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
1876: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
1877: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 1878: , p15_a15 out nocopy JTF_NUMBER_TABLE

1874: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
1875: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
1876: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
1877: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
1878: , p15_a15 out nocopy JTF_NUMBER_TABLE
1879: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
1880: , p15_a17 out nocopy JTF_NUMBER_TABLE
1881: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
1882: , p15_a19 out nocopy JTF_DATE_TABLE

Line 1880: , p15_a17 out nocopy JTF_NUMBER_TABLE

1876: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
1877: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
1878: , p15_a15 out nocopy JTF_NUMBER_TABLE
1879: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
1880: , p15_a17 out nocopy JTF_NUMBER_TABLE
1881: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
1882: , p15_a19 out nocopy JTF_DATE_TABLE
1883: , p15_a20 out nocopy JTF_DATE_TABLE
1884: , p15_a21 out nocopy JTF_NUMBER_TABLE

Line 1884: , p15_a21 out nocopy JTF_NUMBER_TABLE

1880: , p15_a17 out nocopy JTF_NUMBER_TABLE
1881: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
1882: , p15_a19 out nocopy JTF_DATE_TABLE
1883: , p15_a20 out nocopy JTF_DATE_TABLE
1884: , p15_a21 out nocopy JTF_NUMBER_TABLE
1885: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
1886: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
1887: , p15_a24 out nocopy JTF_NUMBER_TABLE
1888: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 1887: , p15_a24 out nocopy JTF_NUMBER_TABLE

1883: , p15_a20 out nocopy JTF_DATE_TABLE
1884: , p15_a21 out nocopy JTF_NUMBER_TABLE
1885: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
1886: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
1887: , p15_a24 out nocopy JTF_NUMBER_TABLE
1888: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
1889: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
1890: , x_return_status out nocopy VARCHAR2
1891: , x_msg_count out nocopy NUMBER

Line 2107: , p15_a0 out nocopy JTF_NUMBER_TABLE

2103: , p_territory_flag VARCHAR2
2104: , p_calendar_flag VARCHAR2
2105: , p_business_process_id NUMBER
2106: , p_business_process_date date
2107: , p15_a0 out nocopy JTF_NUMBER_TABLE
2108: , p15_a1 out nocopy JTF_NUMBER_TABLE
2109: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
2110: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
2111: , p15_a4 out nocopy JTF_DATE_TABLE

Line 2108: , p15_a1 out nocopy JTF_NUMBER_TABLE

2104: , p_calendar_flag VARCHAR2
2105: , p_business_process_id NUMBER
2106: , p_business_process_date date
2107: , p15_a0 out nocopy JTF_NUMBER_TABLE
2108: , p15_a1 out nocopy JTF_NUMBER_TABLE
2109: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
2110: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
2111: , p15_a4 out nocopy JTF_DATE_TABLE
2112: , p15_a5 out nocopy JTF_DATE_TABLE

Line 2113: , p15_a6 out nocopy JTF_NUMBER_TABLE

2109: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
2110: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
2111: , p15_a4 out nocopy JTF_DATE_TABLE
2112: , p15_a5 out nocopy JTF_DATE_TABLE
2113: , p15_a6 out nocopy JTF_NUMBER_TABLE
2114: , p15_a7 out nocopy JTF_NUMBER_TABLE
2115: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
2116: , p15_a9 out nocopy JTF_NUMBER_TABLE
2117: , p15_a10 out nocopy JTF_NUMBER_TABLE

Line 2114: , p15_a7 out nocopy JTF_NUMBER_TABLE

2110: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
2111: , p15_a4 out nocopy JTF_DATE_TABLE
2112: , p15_a5 out nocopy JTF_DATE_TABLE
2113: , p15_a6 out nocopy JTF_NUMBER_TABLE
2114: , p15_a7 out nocopy JTF_NUMBER_TABLE
2115: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
2116: , p15_a9 out nocopy JTF_NUMBER_TABLE
2117: , p15_a10 out nocopy JTF_NUMBER_TABLE
2118: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 2116: , p15_a9 out nocopy JTF_NUMBER_TABLE

2112: , p15_a5 out nocopy JTF_DATE_TABLE
2113: , p15_a6 out nocopy JTF_NUMBER_TABLE
2114: , p15_a7 out nocopy JTF_NUMBER_TABLE
2115: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
2116: , p15_a9 out nocopy JTF_NUMBER_TABLE
2117: , p15_a10 out nocopy JTF_NUMBER_TABLE
2118: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
2119: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
2120: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 2117: , p15_a10 out nocopy JTF_NUMBER_TABLE

2113: , p15_a6 out nocopy JTF_NUMBER_TABLE
2114: , p15_a7 out nocopy JTF_NUMBER_TABLE
2115: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
2116: , p15_a9 out nocopy JTF_NUMBER_TABLE
2117: , p15_a10 out nocopy JTF_NUMBER_TABLE
2118: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
2119: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
2120: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
2121: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 2122: , p15_a15 out nocopy JTF_NUMBER_TABLE

2118: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
2119: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
2120: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
2121: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
2122: , p15_a15 out nocopy JTF_NUMBER_TABLE
2123: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
2124: , p15_a17 out nocopy JTF_NUMBER_TABLE
2125: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
2126: , p15_a19 out nocopy JTF_DATE_TABLE

Line 2124: , p15_a17 out nocopy JTF_NUMBER_TABLE

2120: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
2121: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
2122: , p15_a15 out nocopy JTF_NUMBER_TABLE
2123: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
2124: , p15_a17 out nocopy JTF_NUMBER_TABLE
2125: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
2126: , p15_a19 out nocopy JTF_DATE_TABLE
2127: , p15_a20 out nocopy JTF_DATE_TABLE
2128: , p15_a21 out nocopy JTF_NUMBER_TABLE

Line 2128: , p15_a21 out nocopy JTF_NUMBER_TABLE

2124: , p15_a17 out nocopy JTF_NUMBER_TABLE
2125: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
2126: , p15_a19 out nocopy JTF_DATE_TABLE
2127: , p15_a20 out nocopy JTF_DATE_TABLE
2128: , p15_a21 out nocopy JTF_NUMBER_TABLE
2129: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
2130: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
2131: , p15_a24 out nocopy JTF_NUMBER_TABLE
2132: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 2131: , p15_a24 out nocopy JTF_NUMBER_TABLE

2127: , p15_a20 out nocopy JTF_DATE_TABLE
2128: , p15_a21 out nocopy JTF_NUMBER_TABLE
2129: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
2130: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
2131: , p15_a24 out nocopy JTF_NUMBER_TABLE
2132: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
2133: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
2134: , x_return_status out nocopy VARCHAR2
2135: , x_msg_count out nocopy NUMBER

Line 2328: , p13_a0 JTF_NUMBER_TABLE

2324: , p_end_date date
2325: , p_territory_flag VARCHAR2
2326: , p_calendar_flag VARCHAR2
2327: , p_web_availability_flag VARCHAR2
2328: , p13_a0 JTF_NUMBER_TABLE
2329: , p13_a1 JTF_VARCHAR2_TABLE_100
2330: , p_business_process_id NUMBER
2331: , p_business_process_date date
2332: , p16_a0 out nocopy JTF_NUMBER_TABLE

Line 2332: , p16_a0 out nocopy JTF_NUMBER_TABLE

2328: , p13_a0 JTF_NUMBER_TABLE
2329: , p13_a1 JTF_VARCHAR2_TABLE_100
2330: , p_business_process_id NUMBER
2331: , p_business_process_date date
2332: , p16_a0 out nocopy JTF_NUMBER_TABLE
2333: , p16_a1 out nocopy JTF_NUMBER_TABLE
2334: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
2335: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
2336: , p16_a4 out nocopy JTF_DATE_TABLE

Line 2333: , p16_a1 out nocopy JTF_NUMBER_TABLE

2329: , p13_a1 JTF_VARCHAR2_TABLE_100
2330: , p_business_process_id NUMBER
2331: , p_business_process_date date
2332: , p16_a0 out nocopy JTF_NUMBER_TABLE
2333: , p16_a1 out nocopy JTF_NUMBER_TABLE
2334: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
2335: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
2336: , p16_a4 out nocopy JTF_DATE_TABLE
2337: , p16_a5 out nocopy JTF_DATE_TABLE

Line 2338: , p16_a6 out nocopy JTF_NUMBER_TABLE

2334: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
2335: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
2336: , p16_a4 out nocopy JTF_DATE_TABLE
2337: , p16_a5 out nocopy JTF_DATE_TABLE
2338: , p16_a6 out nocopy JTF_NUMBER_TABLE
2339: , p16_a7 out nocopy JTF_NUMBER_TABLE
2340: , p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
2341: , p16_a9 out nocopy JTF_NUMBER_TABLE
2342: , p16_a10 out nocopy JTF_NUMBER_TABLE

Line 2339: , p16_a7 out nocopy JTF_NUMBER_TABLE

2335: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
2336: , p16_a4 out nocopy JTF_DATE_TABLE
2337: , p16_a5 out nocopy JTF_DATE_TABLE
2338: , p16_a6 out nocopy JTF_NUMBER_TABLE
2339: , p16_a7 out nocopy JTF_NUMBER_TABLE
2340: , p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
2341: , p16_a9 out nocopy JTF_NUMBER_TABLE
2342: , p16_a10 out nocopy JTF_NUMBER_TABLE
2343: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 2341: , p16_a9 out nocopy JTF_NUMBER_TABLE

2337: , p16_a5 out nocopy JTF_DATE_TABLE
2338: , p16_a6 out nocopy JTF_NUMBER_TABLE
2339: , p16_a7 out nocopy JTF_NUMBER_TABLE
2340: , p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
2341: , p16_a9 out nocopy JTF_NUMBER_TABLE
2342: , p16_a10 out nocopy JTF_NUMBER_TABLE
2343: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
2344: , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
2345: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 2342: , p16_a10 out nocopy JTF_NUMBER_TABLE

2338: , p16_a6 out nocopy JTF_NUMBER_TABLE
2339: , p16_a7 out nocopy JTF_NUMBER_TABLE
2340: , p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
2341: , p16_a9 out nocopy JTF_NUMBER_TABLE
2342: , p16_a10 out nocopy JTF_NUMBER_TABLE
2343: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
2344: , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
2345: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
2346: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 2347: , p16_a15 out nocopy JTF_NUMBER_TABLE

2343: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
2344: , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
2345: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
2346: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
2347: , p16_a15 out nocopy JTF_NUMBER_TABLE
2348: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_100
2349: , p16_a17 out nocopy JTF_NUMBER_TABLE
2350: , p16_a18 out nocopy JTF_VARCHAR2_TABLE_100
2351: , p16_a19 out nocopy JTF_DATE_TABLE

Line 2349: , p16_a17 out nocopy JTF_NUMBER_TABLE

2345: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
2346: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
2347: , p16_a15 out nocopy JTF_NUMBER_TABLE
2348: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_100
2349: , p16_a17 out nocopy JTF_NUMBER_TABLE
2350: , p16_a18 out nocopy JTF_VARCHAR2_TABLE_100
2351: , p16_a19 out nocopy JTF_DATE_TABLE
2352: , p16_a20 out nocopy JTF_DATE_TABLE
2353: , p16_a21 out nocopy JTF_NUMBER_TABLE

Line 2353: , p16_a21 out nocopy JTF_NUMBER_TABLE

2349: , p16_a17 out nocopy JTF_NUMBER_TABLE
2350: , p16_a18 out nocopy JTF_VARCHAR2_TABLE_100
2351: , p16_a19 out nocopy JTF_DATE_TABLE
2352: , p16_a20 out nocopy JTF_DATE_TABLE
2353: , p16_a21 out nocopy JTF_NUMBER_TABLE
2354: , p16_a22 out nocopy JTF_VARCHAR2_TABLE_200
2355: , p16_a23 out nocopy JTF_VARCHAR2_TABLE_100
2356: , p16_a24 out nocopy JTF_NUMBER_TABLE
2357: , p16_a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 2356: , p16_a24 out nocopy JTF_NUMBER_TABLE

2352: , p16_a20 out nocopy JTF_DATE_TABLE
2353: , p16_a21 out nocopy JTF_NUMBER_TABLE
2354: , p16_a22 out nocopy JTF_VARCHAR2_TABLE_200
2355: , p16_a23 out nocopy JTF_VARCHAR2_TABLE_100
2356: , p16_a24 out nocopy JTF_NUMBER_TABLE
2357: , p16_a25 out nocopy JTF_VARCHAR2_TABLE_100
2358: , p16_a26 out nocopy JTF_VARCHAR2_TABLE_100
2359: , x_return_status out nocopy VARCHAR2
2360: , x_msg_count out nocopy NUMBER

Line 2481: , p12_a0 out nocopy JTF_NUMBER_TABLE

2477: , p_calling_doc_id NUMBER
2478: , p_calling_doc_type VARCHAR2
2479: , p_business_process_id NUMBER
2480: , p_business_process_date date
2481: , p12_a0 out nocopy JTF_NUMBER_TABLE
2482: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
2483: , x_return_status out nocopy VARCHAR2
2484: , x_msg_count out nocopy NUMBER
2485: , x_msg_data out nocopy VARCHAR2

Line 2904: , p14_a0 in out nocopy JTF_NUMBER_TABLE

2900: , p_continuous_task VARCHAR2
2901: , x_return_status in out nocopy VARCHAR2
2902: , x_msg_count in out nocopy NUMBER
2903: , x_msg_data in out nocopy VARCHAR2
2904: , p14_a0 in out nocopy JTF_NUMBER_TABLE
2905: , p14_a1 in out nocopy JTF_NUMBER_TABLE
2906: , p14_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2907: , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2908: , p14_a4 in out nocopy JTF_DATE_TABLE

Line 2905: , p14_a1 in out nocopy JTF_NUMBER_TABLE

2901: , x_return_status in out nocopy VARCHAR2
2902: , x_msg_count in out nocopy NUMBER
2903: , x_msg_data in out nocopy VARCHAR2
2904: , p14_a0 in out nocopy JTF_NUMBER_TABLE
2905: , p14_a1 in out nocopy JTF_NUMBER_TABLE
2906: , p14_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2907: , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2908: , p14_a4 in out nocopy JTF_DATE_TABLE
2909: , p14_a5 in out nocopy JTF_DATE_TABLE

Line 2910: , p14_a6 in out nocopy JTF_NUMBER_TABLE

2906: , p14_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2907: , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2908: , p14_a4 in out nocopy JTF_DATE_TABLE
2909: , p14_a5 in out nocopy JTF_DATE_TABLE
2910: , p14_a6 in out nocopy JTF_NUMBER_TABLE
2911: , p14_a7 in out nocopy JTF_NUMBER_TABLE
2912: , p14_a8 in out nocopy JTF_VARCHAR2_TABLE_300
2913: , p14_a9 in out nocopy JTF_NUMBER_TABLE
2914: , p14_a10 in out nocopy JTF_NUMBER_TABLE

Line 2911: , p14_a7 in out nocopy JTF_NUMBER_TABLE

2907: , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2908: , p14_a4 in out nocopy JTF_DATE_TABLE
2909: , p14_a5 in out nocopy JTF_DATE_TABLE
2910: , p14_a6 in out nocopy JTF_NUMBER_TABLE
2911: , p14_a7 in out nocopy JTF_NUMBER_TABLE
2912: , p14_a8 in out nocopy JTF_VARCHAR2_TABLE_300
2913: , p14_a9 in out nocopy JTF_NUMBER_TABLE
2914: , p14_a10 in out nocopy JTF_NUMBER_TABLE
2915: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100

Line 2913: , p14_a9 in out nocopy JTF_NUMBER_TABLE

2909: , p14_a5 in out nocopy JTF_DATE_TABLE
2910: , p14_a6 in out nocopy JTF_NUMBER_TABLE
2911: , p14_a7 in out nocopy JTF_NUMBER_TABLE
2912: , p14_a8 in out nocopy JTF_VARCHAR2_TABLE_300
2913: , p14_a9 in out nocopy JTF_NUMBER_TABLE
2914: , p14_a10 in out nocopy JTF_NUMBER_TABLE
2915: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
2916: , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
2917: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 2914: , p14_a10 in out nocopy JTF_NUMBER_TABLE

2910: , p14_a6 in out nocopy JTF_NUMBER_TABLE
2911: , p14_a7 in out nocopy JTF_NUMBER_TABLE
2912: , p14_a8 in out nocopy JTF_VARCHAR2_TABLE_300
2913: , p14_a9 in out nocopy JTF_NUMBER_TABLE
2914: , p14_a10 in out nocopy JTF_NUMBER_TABLE
2915: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
2916: , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
2917: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
2918: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100

Line 2919: , p14_a15 in out nocopy JTF_NUMBER_TABLE

2915: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
2916: , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
2917: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
2918: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
2919: , p14_a15 in out nocopy JTF_NUMBER_TABLE
2920: , p14_a16 in out nocopy JTF_VARCHAR2_TABLE_100
2921: , p14_a17 in out nocopy JTF_NUMBER_TABLE
2922: , p14_a18 in out nocopy JTF_VARCHAR2_TABLE_100
2923: , p14_a19 in out nocopy JTF_DATE_TABLE

Line 2921: , p14_a17 in out nocopy JTF_NUMBER_TABLE

2917: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
2918: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
2919: , p14_a15 in out nocopy JTF_NUMBER_TABLE
2920: , p14_a16 in out nocopy JTF_VARCHAR2_TABLE_100
2921: , p14_a17 in out nocopy JTF_NUMBER_TABLE
2922: , p14_a18 in out nocopy JTF_VARCHAR2_TABLE_100
2923: , p14_a19 in out nocopy JTF_DATE_TABLE
2924: , p14_a20 in out nocopy JTF_DATE_TABLE
2925: , p14_a21 in out nocopy JTF_NUMBER_TABLE

Line 2925: , p14_a21 in out nocopy JTF_NUMBER_TABLE

2921: , p14_a17 in out nocopy JTF_NUMBER_TABLE
2922: , p14_a18 in out nocopy JTF_VARCHAR2_TABLE_100
2923: , p14_a19 in out nocopy JTF_DATE_TABLE
2924: , p14_a20 in out nocopy JTF_DATE_TABLE
2925: , p14_a21 in out nocopy JTF_NUMBER_TABLE
2926: , p14_a22 in out nocopy JTF_VARCHAR2_TABLE_200
2927: , p14_a23 in out nocopy JTF_VARCHAR2_TABLE_100
2928: , p14_a24 in out nocopy JTF_NUMBER_TABLE
2929: , p14_a25 in out nocopy JTF_VARCHAR2_TABLE_100

Line 2928: , p14_a24 in out nocopy JTF_NUMBER_TABLE

2924: , p14_a20 in out nocopy JTF_DATE_TABLE
2925: , p14_a21 in out nocopy JTF_NUMBER_TABLE
2926: , p14_a22 in out nocopy JTF_VARCHAR2_TABLE_200
2927: , p14_a23 in out nocopy JTF_VARCHAR2_TABLE_100
2928: , p14_a24 in out nocopy JTF_NUMBER_TABLE
2929: , p14_a25 in out nocopy JTF_VARCHAR2_TABLE_100
2930: , p14_a26 in out nocopy JTF_VARCHAR2_TABLE_100
2931: )
2932: