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.CS_SERVICEREQUEST_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 16: , a3 JTF_VARCHAR2_TABLE_100

12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cs_servicerequest_pub.notes_table, a0 JTF_VARCHAR2_TABLE_2000
14: , a1 JTF_VARCHAR2_TABLE_32767
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100

Line 18: , a5 JTF_VARCHAR2_TABLE_100

14: , a1 JTF_VARCHAR2_TABLE_32767
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: ) as

Line 20: , a7 JTF_VARCHAR2_TABLE_100

16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_VARCHAR2_TABLE_100
21: , a8 JTF_NUMBER_TABLE
22: ) as
23: ddindx binary_integer; indx binary_integer;
24: begin

Line 51: , a3 out nocopy JTF_VARCHAR2_TABLE_100

47: end rosetta_table_copy_in_p1;
48: procedure rosetta_table_copy_out_p1(t cs_servicerequest_pub.notes_table, a0 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a1 out nocopy JTF_VARCHAR2_TABLE_32767
50: , a2 out nocopy JTF_VARCHAR2_TABLE_300
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 53: , a5 out nocopy JTF_VARCHAR2_TABLE_100

49: , a1 out nocopy JTF_VARCHAR2_TABLE_32767
50: , a2 out nocopy JTF_VARCHAR2_TABLE_300
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100
56: , a8 out nocopy JTF_NUMBER_TABLE
57: ) as

Line 55: , a7 out nocopy JTF_VARCHAR2_TABLE_100

51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_NUMBER_TABLE
53: , a5 out nocopy JTF_VARCHAR2_TABLE_100
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_VARCHAR2_TABLE_100
56: , a8 out nocopy JTF_NUMBER_TABLE
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin

Line 64: a3 := JTF_VARCHAR2_TABLE_100();

60: if t is null or t.count = 0 then
61: a0 := JTF_VARCHAR2_TABLE_2000();
62: a1 := JTF_VARCHAR2_TABLE_32767();
63: a2 := JTF_VARCHAR2_TABLE_300();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_NUMBER_TABLE();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_VARCHAR2_TABLE_100();

Line 66: a5 := JTF_VARCHAR2_TABLE_100();

62: a1 := JTF_VARCHAR2_TABLE_32767();
63: a2 := JTF_VARCHAR2_TABLE_300();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_NUMBER_TABLE();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_VARCHAR2_TABLE_100();
69: a8 := JTF_NUMBER_TABLE();
70: else

Line 68: a7 := JTF_VARCHAR2_TABLE_100();

64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_NUMBER_TABLE();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_VARCHAR2_TABLE_100();
69: a8 := JTF_NUMBER_TABLE();
70: else
71: a0 := JTF_VARCHAR2_TABLE_2000();
72: a1 := JTF_VARCHAR2_TABLE_32767();

Line 74: a3 := JTF_VARCHAR2_TABLE_100();

70: else
71: a0 := JTF_VARCHAR2_TABLE_2000();
72: a1 := JTF_VARCHAR2_TABLE_32767();
73: a2 := JTF_VARCHAR2_TABLE_300();
74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_NUMBER_TABLE();
76: a5 := JTF_VARCHAR2_TABLE_100();
77: a6 := JTF_NUMBER_TABLE();
78: a7 := JTF_VARCHAR2_TABLE_100();

Line 76: a5 := JTF_VARCHAR2_TABLE_100();

72: a1 := JTF_VARCHAR2_TABLE_32767();
73: a2 := JTF_VARCHAR2_TABLE_300();
74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_NUMBER_TABLE();
76: a5 := JTF_VARCHAR2_TABLE_100();
77: a6 := JTF_NUMBER_TABLE();
78: a7 := JTF_VARCHAR2_TABLE_100();
79: a8 := JTF_NUMBER_TABLE();
80: if t.count > 0 then

Line 78: a7 := JTF_VARCHAR2_TABLE_100();

74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_NUMBER_TABLE();
76: a5 := JTF_VARCHAR2_TABLE_100();
77: a6 := JTF_NUMBER_TABLE();
78: a7 := JTF_VARCHAR2_TABLE_100();
79: a8 := JTF_NUMBER_TABLE();
80: if t.count > 0 then
81: a0.extend(t.count);
82: a1.extend(t.count);

Line 115: , a3 JTF_VARCHAR2_TABLE_100

111:
112: procedure rosetta_table_copy_in_p3(t out nocopy cs_servicerequest_pub.contacts_table, a0 JTF_NUMBER_TABLE
113: , a1 JTF_NUMBER_TABLE
114: , a2 JTF_NUMBER_TABLE
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_100
117: , a5 JTF_VARCHAR2_TABLE_100
118: , a6 JTF_VARCHAR2_TABLE_100
119: , a7 JTF_DATE_TABLE

Line 116: , a4 JTF_VARCHAR2_TABLE_100

112: procedure rosetta_table_copy_in_p3(t out nocopy cs_servicerequest_pub.contacts_table, a0 JTF_NUMBER_TABLE
113: , a1 JTF_NUMBER_TABLE
114: , a2 JTF_NUMBER_TABLE
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_100
117: , a5 JTF_VARCHAR2_TABLE_100
118: , a6 JTF_VARCHAR2_TABLE_100
119: , a7 JTF_DATE_TABLE
120: , a8 JTF_DATE_TABLE

Line 117: , a5 JTF_VARCHAR2_TABLE_100

113: , a1 JTF_NUMBER_TABLE
114: , a2 JTF_NUMBER_TABLE
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_100
117: , a5 JTF_VARCHAR2_TABLE_100
118: , a6 JTF_VARCHAR2_TABLE_100
119: , a7 JTF_DATE_TABLE
120: , a8 JTF_DATE_TABLE
121: ) as

Line 118: , a6 JTF_VARCHAR2_TABLE_100

114: , a2 JTF_NUMBER_TABLE
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_100
117: , a5 JTF_VARCHAR2_TABLE_100
118: , a6 JTF_VARCHAR2_TABLE_100
119: , a7 JTF_DATE_TABLE
120: , a8 JTF_DATE_TABLE
121: ) as
122: ddindx binary_integer; indx binary_integer;

Line 150: , a3 out nocopy JTF_VARCHAR2_TABLE_100

146: end rosetta_table_copy_in_p3;
147: procedure rosetta_table_copy_out_p3(t cs_servicerequest_pub.contacts_table, a0 out nocopy JTF_NUMBER_TABLE
148: , a1 out nocopy JTF_NUMBER_TABLE
149: , a2 out nocopy JTF_NUMBER_TABLE
150: , a3 out nocopy JTF_VARCHAR2_TABLE_100
151: , a4 out nocopy JTF_VARCHAR2_TABLE_100
152: , a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , a7 out nocopy JTF_DATE_TABLE

Line 151: , a4 out nocopy JTF_VARCHAR2_TABLE_100

147: procedure rosetta_table_copy_out_p3(t cs_servicerequest_pub.contacts_table, a0 out nocopy JTF_NUMBER_TABLE
148: , a1 out nocopy JTF_NUMBER_TABLE
149: , a2 out nocopy JTF_NUMBER_TABLE
150: , a3 out nocopy JTF_VARCHAR2_TABLE_100
151: , a4 out nocopy JTF_VARCHAR2_TABLE_100
152: , a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , a7 out nocopy JTF_DATE_TABLE
155: , a8 out nocopy JTF_DATE_TABLE

Line 152: , a5 out nocopy JTF_VARCHAR2_TABLE_100

148: , a1 out nocopy JTF_NUMBER_TABLE
149: , a2 out nocopy JTF_NUMBER_TABLE
150: , a3 out nocopy JTF_VARCHAR2_TABLE_100
151: , a4 out nocopy JTF_VARCHAR2_TABLE_100
152: , a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , a7 out nocopy JTF_DATE_TABLE
155: , a8 out nocopy JTF_DATE_TABLE
156: ) as

Line 153: , a6 out nocopy JTF_VARCHAR2_TABLE_100

149: , a2 out nocopy JTF_NUMBER_TABLE
150: , a3 out nocopy JTF_VARCHAR2_TABLE_100
151: , a4 out nocopy JTF_VARCHAR2_TABLE_100
152: , a5 out nocopy JTF_VARCHAR2_TABLE_100
153: , a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , a7 out nocopy JTF_DATE_TABLE
155: , a8 out nocopy JTF_DATE_TABLE
156: ) as
157: ddindx binary_integer; indx binary_integer;

Line 163: a3 := JTF_VARCHAR2_TABLE_100();

159: if t is null or t.count = 0 then
160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_VARCHAR2_TABLE_100();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_DATE_TABLE();

Line 164: a4 := JTF_VARCHAR2_TABLE_100();

160: a0 := JTF_NUMBER_TABLE();
161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_VARCHAR2_TABLE_100();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_DATE_TABLE();
168: a8 := JTF_DATE_TABLE();

Line 165: a5 := JTF_VARCHAR2_TABLE_100();

161: a1 := JTF_NUMBER_TABLE();
162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_VARCHAR2_TABLE_100();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_DATE_TABLE();
168: a8 := JTF_DATE_TABLE();
169: else

Line 166: a6 := JTF_VARCHAR2_TABLE_100();

162: a2 := JTF_NUMBER_TABLE();
163: a3 := JTF_VARCHAR2_TABLE_100();
164: a4 := JTF_VARCHAR2_TABLE_100();
165: a5 := JTF_VARCHAR2_TABLE_100();
166: a6 := JTF_VARCHAR2_TABLE_100();
167: a7 := JTF_DATE_TABLE();
168: a8 := JTF_DATE_TABLE();
169: else
170: a0 := JTF_NUMBER_TABLE();

Line 173: a3 := JTF_VARCHAR2_TABLE_100();

169: else
170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_NUMBER_TABLE();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_DATE_TABLE();

Line 174: a4 := JTF_VARCHAR2_TABLE_100();

170: a0 := JTF_NUMBER_TABLE();
171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_NUMBER_TABLE();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_DATE_TABLE();
178: a8 := JTF_DATE_TABLE();

Line 175: a5 := JTF_VARCHAR2_TABLE_100();

171: a1 := JTF_NUMBER_TABLE();
172: a2 := JTF_NUMBER_TABLE();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_DATE_TABLE();
178: a8 := JTF_DATE_TABLE();
179: if t.count > 0 then

Line 176: a6 := JTF_VARCHAR2_TABLE_100();

172: a2 := JTF_NUMBER_TABLE();
173: a3 := JTF_VARCHAR2_TABLE_100();
174: a4 := JTF_VARCHAR2_TABLE_100();
175: a5 := JTF_VARCHAR2_TABLE_100();
176: a6 := JTF_VARCHAR2_TABLE_100();
177: a7 := JTF_DATE_TABLE();
178: a8 := JTF_DATE_TABLE();
179: if t.count > 0 then
180: a0.extend(t.count);

Line 218: , a7 JTF_VARCHAR2_TABLE_100

214: , a3 JTF_VARCHAR2_TABLE_200
215: , a4 JTF_VARCHAR2_TABLE_200
216: , a5 JTF_VARCHAR2_TABLE_200
217: , a6 JTF_VARCHAR2_TABLE_200
218: , a7 JTF_VARCHAR2_TABLE_100
219: , a8 JTF_NUMBER_TABLE
220: , a9 JTF_NUMBER_TABLE
221: , a10 JTF_VARCHAR2_TABLE_100
222: , a11 JTF_VARCHAR2_TABLE_100

Line 221: , a10 JTF_VARCHAR2_TABLE_100

217: , a6 JTF_VARCHAR2_TABLE_200
218: , a7 JTF_VARCHAR2_TABLE_100
219: , a8 JTF_NUMBER_TABLE
220: , a9 JTF_NUMBER_TABLE
221: , a10 JTF_VARCHAR2_TABLE_100
222: , a11 JTF_VARCHAR2_TABLE_100
223: , a12 JTF_VARCHAR2_TABLE_200
224: , a13 JTF_VARCHAR2_TABLE_100
225: , a14 JTF_VARCHAR2_TABLE_100

Line 222: , a11 JTF_VARCHAR2_TABLE_100

218: , a7 JTF_VARCHAR2_TABLE_100
219: , a8 JTF_NUMBER_TABLE
220: , a9 JTF_NUMBER_TABLE
221: , a10 JTF_VARCHAR2_TABLE_100
222: , a11 JTF_VARCHAR2_TABLE_100
223: , a12 JTF_VARCHAR2_TABLE_200
224: , a13 JTF_VARCHAR2_TABLE_100
225: , a14 JTF_VARCHAR2_TABLE_100
226: ) as

Line 224: , a13 JTF_VARCHAR2_TABLE_100

220: , a9 JTF_NUMBER_TABLE
221: , a10 JTF_VARCHAR2_TABLE_100
222: , a11 JTF_VARCHAR2_TABLE_100
223: , a12 JTF_VARCHAR2_TABLE_200
224: , a13 JTF_VARCHAR2_TABLE_100
225: , a14 JTF_VARCHAR2_TABLE_100
226: ) as
227: ddindx binary_integer; indx binary_integer;
228: begin

Line 225: , a14 JTF_VARCHAR2_TABLE_100

221: , a10 JTF_VARCHAR2_TABLE_100
222: , a11 JTF_VARCHAR2_TABLE_100
223: , a12 JTF_VARCHAR2_TABLE_200
224: , a13 JTF_VARCHAR2_TABLE_100
225: , a14 JTF_VARCHAR2_TABLE_100
226: ) as
227: ddindx binary_integer; indx binary_integer;
228: begin
229: if a0 is not null and a0.count > 0 then

Line 265: , a7 out nocopy JTF_VARCHAR2_TABLE_100

261: , a3 out nocopy JTF_VARCHAR2_TABLE_200
262: , a4 out nocopy JTF_VARCHAR2_TABLE_200
263: , a5 out nocopy JTF_VARCHAR2_TABLE_200
264: , a6 out nocopy JTF_VARCHAR2_TABLE_200
265: , a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , a8 out nocopy JTF_NUMBER_TABLE
267: , a9 out nocopy JTF_NUMBER_TABLE
268: , a10 out nocopy JTF_VARCHAR2_TABLE_100
269: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 268: , a10 out nocopy JTF_VARCHAR2_TABLE_100

264: , a6 out nocopy JTF_VARCHAR2_TABLE_200
265: , a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , a8 out nocopy JTF_NUMBER_TABLE
267: , a9 out nocopy JTF_NUMBER_TABLE
268: , a10 out nocopy JTF_VARCHAR2_TABLE_100
269: , a11 out nocopy JTF_VARCHAR2_TABLE_100
270: , a12 out nocopy JTF_VARCHAR2_TABLE_200
271: , a13 out nocopy JTF_VARCHAR2_TABLE_100
272: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 269: , a11 out nocopy JTF_VARCHAR2_TABLE_100

265: , a7 out nocopy JTF_VARCHAR2_TABLE_100
266: , a8 out nocopy JTF_NUMBER_TABLE
267: , a9 out nocopy JTF_NUMBER_TABLE
268: , a10 out nocopy JTF_VARCHAR2_TABLE_100
269: , a11 out nocopy JTF_VARCHAR2_TABLE_100
270: , a12 out nocopy JTF_VARCHAR2_TABLE_200
271: , a13 out nocopy JTF_VARCHAR2_TABLE_100
272: , a14 out nocopy JTF_VARCHAR2_TABLE_100
273: ) as

Line 271: , a13 out nocopy JTF_VARCHAR2_TABLE_100

267: , a9 out nocopy JTF_NUMBER_TABLE
268: , a10 out nocopy JTF_VARCHAR2_TABLE_100
269: , a11 out nocopy JTF_VARCHAR2_TABLE_100
270: , a12 out nocopy JTF_VARCHAR2_TABLE_200
271: , a13 out nocopy JTF_VARCHAR2_TABLE_100
272: , a14 out nocopy JTF_VARCHAR2_TABLE_100
273: ) as
274: ddindx binary_integer; indx binary_integer;
275: begin

Line 272: , a14 out nocopy JTF_VARCHAR2_TABLE_100

268: , a10 out nocopy JTF_VARCHAR2_TABLE_100
269: , a11 out nocopy JTF_VARCHAR2_TABLE_100
270: , a12 out nocopy JTF_VARCHAR2_TABLE_200
271: , a13 out nocopy JTF_VARCHAR2_TABLE_100
272: , a14 out nocopy JTF_VARCHAR2_TABLE_100
273: ) as
274: ddindx binary_integer; indx binary_integer;
275: begin
276: if t is null or t.count = 0 then

Line 284: a7 := JTF_VARCHAR2_TABLE_100();

280: a3 := JTF_VARCHAR2_TABLE_200();
281: a4 := JTF_VARCHAR2_TABLE_200();
282: a5 := JTF_VARCHAR2_TABLE_200();
283: a6 := JTF_VARCHAR2_TABLE_200();
284: a7 := JTF_VARCHAR2_TABLE_100();
285: a8 := JTF_NUMBER_TABLE();
286: a9 := JTF_NUMBER_TABLE();
287: a10 := JTF_VARCHAR2_TABLE_100();
288: a11 := JTF_VARCHAR2_TABLE_100();

Line 287: a10 := JTF_VARCHAR2_TABLE_100();

283: a6 := JTF_VARCHAR2_TABLE_200();
284: a7 := JTF_VARCHAR2_TABLE_100();
285: a8 := JTF_NUMBER_TABLE();
286: a9 := JTF_NUMBER_TABLE();
287: a10 := JTF_VARCHAR2_TABLE_100();
288: a11 := JTF_VARCHAR2_TABLE_100();
289: a12 := JTF_VARCHAR2_TABLE_200();
290: a13 := JTF_VARCHAR2_TABLE_100();
291: a14 := JTF_VARCHAR2_TABLE_100();

Line 288: a11 := JTF_VARCHAR2_TABLE_100();

284: a7 := JTF_VARCHAR2_TABLE_100();
285: a8 := JTF_NUMBER_TABLE();
286: a9 := JTF_NUMBER_TABLE();
287: a10 := JTF_VARCHAR2_TABLE_100();
288: a11 := JTF_VARCHAR2_TABLE_100();
289: a12 := JTF_VARCHAR2_TABLE_200();
290: a13 := JTF_VARCHAR2_TABLE_100();
291: a14 := JTF_VARCHAR2_TABLE_100();
292: else

Line 290: a13 := JTF_VARCHAR2_TABLE_100();

286: a9 := JTF_NUMBER_TABLE();
287: a10 := JTF_VARCHAR2_TABLE_100();
288: a11 := JTF_VARCHAR2_TABLE_100();
289: a12 := JTF_VARCHAR2_TABLE_200();
290: a13 := JTF_VARCHAR2_TABLE_100();
291: a14 := JTF_VARCHAR2_TABLE_100();
292: else
293: a0 := JTF_NUMBER_TABLE();
294: a1 := JTF_VARCHAR2_TABLE_200();

Line 291: a14 := JTF_VARCHAR2_TABLE_100();

287: a10 := JTF_VARCHAR2_TABLE_100();
288: a11 := JTF_VARCHAR2_TABLE_100();
289: a12 := JTF_VARCHAR2_TABLE_200();
290: a13 := JTF_VARCHAR2_TABLE_100();
291: a14 := JTF_VARCHAR2_TABLE_100();
292: else
293: a0 := JTF_NUMBER_TABLE();
294: a1 := JTF_VARCHAR2_TABLE_200();
295: a2 := JTF_VARCHAR2_TABLE_200();

Line 300: a7 := JTF_VARCHAR2_TABLE_100();

296: a3 := JTF_VARCHAR2_TABLE_200();
297: a4 := JTF_VARCHAR2_TABLE_200();
298: a5 := JTF_VARCHAR2_TABLE_200();
299: a6 := JTF_VARCHAR2_TABLE_200();
300: a7 := JTF_VARCHAR2_TABLE_100();
301: a8 := JTF_NUMBER_TABLE();
302: a9 := JTF_NUMBER_TABLE();
303: a10 := JTF_VARCHAR2_TABLE_100();
304: a11 := JTF_VARCHAR2_TABLE_100();

Line 303: a10 := JTF_VARCHAR2_TABLE_100();

299: a6 := JTF_VARCHAR2_TABLE_200();
300: a7 := JTF_VARCHAR2_TABLE_100();
301: a8 := JTF_NUMBER_TABLE();
302: a9 := JTF_NUMBER_TABLE();
303: a10 := JTF_VARCHAR2_TABLE_100();
304: a11 := JTF_VARCHAR2_TABLE_100();
305: a12 := JTF_VARCHAR2_TABLE_200();
306: a13 := JTF_VARCHAR2_TABLE_100();
307: a14 := JTF_VARCHAR2_TABLE_100();

Line 304: a11 := JTF_VARCHAR2_TABLE_100();

300: a7 := JTF_VARCHAR2_TABLE_100();
301: a8 := JTF_NUMBER_TABLE();
302: a9 := JTF_NUMBER_TABLE();
303: a10 := JTF_VARCHAR2_TABLE_100();
304: a11 := JTF_VARCHAR2_TABLE_100();
305: a12 := JTF_VARCHAR2_TABLE_200();
306: a13 := JTF_VARCHAR2_TABLE_100();
307: a14 := JTF_VARCHAR2_TABLE_100();
308: if t.count > 0 then

Line 306: a13 := JTF_VARCHAR2_TABLE_100();

302: a9 := JTF_NUMBER_TABLE();
303: a10 := JTF_VARCHAR2_TABLE_100();
304: a11 := JTF_VARCHAR2_TABLE_100();
305: a12 := JTF_VARCHAR2_TABLE_200();
306: a13 := JTF_VARCHAR2_TABLE_100();
307: a14 := JTF_VARCHAR2_TABLE_100();
308: if t.count > 0 then
309: a0.extend(t.count);
310: a1.extend(t.count);

Line 307: a14 := JTF_VARCHAR2_TABLE_100();

303: a10 := JTF_VARCHAR2_TABLE_100();
304: a11 := JTF_VARCHAR2_TABLE_100();
305: a12 := JTF_VARCHAR2_TABLE_200();
306: a13 := JTF_VARCHAR2_TABLE_100();
307: a14 := JTF_VARCHAR2_TABLE_100();
308: if t.count > 0 then
309: a0.extend(t.count);
310: a1.extend(t.count);
311: a2.extend(t.count);

Line 353: , a1 JTF_VARCHAR2_TABLE_100

349: end if;
350: end rosetta_table_copy_out_p8;
351:
352: procedure rosetta_table_copy_in_p10(t out nocopy cs_servicerequest_pub.ext_attr_tbl_type, a0 JTF_NUMBER_TABLE
353: , a1 JTF_VARCHAR2_TABLE_100
354: , a2 JTF_VARCHAR2_TABLE_200
355: , a3 JTF_VARCHAR2_TABLE_200
356: , a4 JTF_VARCHAR2_TABLE_200
357: , a5 JTF_NUMBER_TABLE

Line 359: , a7 JTF_VARCHAR2_TABLE_1000

355: , a3 JTF_VARCHAR2_TABLE_200
356: , a4 JTF_VARCHAR2_TABLE_200
357: , a5 JTF_NUMBER_TABLE
358: , a6 JTF_DATE_TABLE
359: , a7 JTF_VARCHAR2_TABLE_1000
360: , a8 JTF_VARCHAR2_TABLE_100
361: ) as
362: ddindx binary_integer; indx binary_integer;
363: begin

Line 360: , a8 JTF_VARCHAR2_TABLE_100

356: , a4 JTF_VARCHAR2_TABLE_200
357: , a5 JTF_NUMBER_TABLE
358: , a6 JTF_DATE_TABLE
359: , a7 JTF_VARCHAR2_TABLE_1000
360: , a8 JTF_VARCHAR2_TABLE_100
361: ) as
362: ddindx binary_integer; indx binary_integer;
363: begin
364: if a0 is not null and a0.count > 0 then

Line 388: , a1 out nocopy JTF_VARCHAR2_TABLE_100

384: end if;
385: end if;
386: end rosetta_table_copy_in_p10;
387: procedure rosetta_table_copy_out_p10(t cs_servicerequest_pub.ext_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
388: , a1 out nocopy JTF_VARCHAR2_TABLE_100
389: , a2 out nocopy JTF_VARCHAR2_TABLE_200
390: , a3 out nocopy JTF_VARCHAR2_TABLE_200
391: , a4 out nocopy JTF_VARCHAR2_TABLE_200
392: , a5 out nocopy JTF_NUMBER_TABLE

Line 394: , a7 out nocopy JTF_VARCHAR2_TABLE_1000

390: , a3 out nocopy JTF_VARCHAR2_TABLE_200
391: , a4 out nocopy JTF_VARCHAR2_TABLE_200
392: , a5 out nocopy JTF_NUMBER_TABLE
393: , a6 out nocopy JTF_DATE_TABLE
394: , a7 out nocopy JTF_VARCHAR2_TABLE_1000
395: , a8 out nocopy JTF_VARCHAR2_TABLE_100
396: ) as
397: ddindx binary_integer; indx binary_integer;
398: begin

Line 395: , a8 out nocopy JTF_VARCHAR2_TABLE_100

391: , a4 out nocopy JTF_VARCHAR2_TABLE_200
392: , a5 out nocopy JTF_NUMBER_TABLE
393: , a6 out nocopy JTF_DATE_TABLE
394: , a7 out nocopy JTF_VARCHAR2_TABLE_1000
395: , a8 out nocopy JTF_VARCHAR2_TABLE_100
396: ) as
397: ddindx binary_integer; indx binary_integer;
398: begin
399: if t is null or t.count = 0 then

Line 401: a1 := JTF_VARCHAR2_TABLE_100();

397: ddindx binary_integer; indx binary_integer;
398: begin
399: if t is null or t.count = 0 then
400: a0 := JTF_NUMBER_TABLE();
401: a1 := JTF_VARCHAR2_TABLE_100();
402: a2 := JTF_VARCHAR2_TABLE_200();
403: a3 := JTF_VARCHAR2_TABLE_200();
404: a4 := JTF_VARCHAR2_TABLE_200();
405: a5 := JTF_NUMBER_TABLE();

Line 407: a7 := JTF_VARCHAR2_TABLE_1000();

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

Line 408: a8 := JTF_VARCHAR2_TABLE_100();

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

Line 411: a1 := JTF_VARCHAR2_TABLE_100();

407: a7 := JTF_VARCHAR2_TABLE_1000();
408: a8 := JTF_VARCHAR2_TABLE_100();
409: else
410: a0 := JTF_NUMBER_TABLE();
411: a1 := JTF_VARCHAR2_TABLE_100();
412: a2 := JTF_VARCHAR2_TABLE_200();
413: a3 := JTF_VARCHAR2_TABLE_200();
414: a4 := JTF_VARCHAR2_TABLE_200();
415: a5 := JTF_NUMBER_TABLE();

Line 417: a7 := JTF_VARCHAR2_TABLE_1000();

413: a3 := JTF_VARCHAR2_TABLE_200();
414: a4 := JTF_VARCHAR2_TABLE_200();
415: a5 := JTF_NUMBER_TABLE();
416: a6 := JTF_DATE_TABLE();
417: a7 := JTF_VARCHAR2_TABLE_1000();
418: a8 := JTF_VARCHAR2_TABLE_100();
419: if t.count > 0 then
420: a0.extend(t.count);
421: a1.extend(t.count);

Line 418: a8 := JTF_VARCHAR2_TABLE_100();

414: a4 := JTF_VARCHAR2_TABLE_200();
415: a5 := JTF_NUMBER_TABLE();
416: a6 := JTF_DATE_TABLE();
417: a7 := JTF_VARCHAR2_TABLE_1000();
418: a8 := JTF_VARCHAR2_TABLE_100();
419: if t.count > 0 then
420: a0.extend(t.count);
421: a1.extend(t.count);
422: a2.extend(t.count);

Line 492: procedure rosetta_table_copy_in_p13(t out nocopy cs_servicerequest_pub.vc2_table, a0 JTF_VARCHAR2_TABLE_100) as

488: end if;
489: end if;
490: end rosetta_table_copy_out_p11;
491:
492: procedure rosetta_table_copy_in_p13(t out nocopy cs_servicerequest_pub.vc2_table, a0 JTF_VARCHAR2_TABLE_100) as
493: ddindx binary_integer; indx binary_integer;
494: begin
495: if a0 is not null and a0.count > 0 then
496: if a0.count > 0 then

Line 510: procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

506: end loop;
507: end if;
508: end if;
509: end rosetta_table_copy_in_p13;
510: procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
511: ddindx binary_integer; indx binary_integer;
512: begin
513: if t is null or t.count = 0 then
514: a0 := JTF_VARCHAR2_TABLE_100();

Line 514: a0 := JTF_VARCHAR2_TABLE_100();

510: procedure rosetta_table_copy_out_p13(t cs_servicerequest_pub.vc2_table, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
511: ddindx binary_integer; indx binary_integer;
512: begin
513: if t is null or t.count = 0 then
514: a0 := JTF_VARCHAR2_TABLE_100();
515: else
516: a0 := JTF_VARCHAR2_TABLE_100();
517: if t.count > 0 then
518: a0.extend(t.count);

Line 516: a0 := JTF_VARCHAR2_TABLE_100();

512: begin
513: if t is null or t.count = 0 then
514: a0 := JTF_VARCHAR2_TABLE_100();
515: else
516: a0 := JTF_VARCHAR2_TABLE_100();
517: if t.count > 0 then
518: a0.extend(t.count);
519: ddindx := t.first;
520: indx := 1;

Line 1396: , p14_a3 JTF_VARCHAR2_TABLE_100

1392: , p13_a207 NUMBER
1393: , p14_a0 JTF_VARCHAR2_TABLE_2000
1394: , p14_a1 JTF_VARCHAR2_TABLE_32767
1395: , p14_a2 JTF_VARCHAR2_TABLE_300
1396: , p14_a3 JTF_VARCHAR2_TABLE_100
1397: , p14_a4 JTF_NUMBER_TABLE
1398: , p14_a5 JTF_VARCHAR2_TABLE_100
1399: , p14_a6 JTF_NUMBER_TABLE
1400: , p14_a7 JTF_VARCHAR2_TABLE_100

Line 1398: , p14_a5 JTF_VARCHAR2_TABLE_100

1394: , p14_a1 JTF_VARCHAR2_TABLE_32767
1395: , p14_a2 JTF_VARCHAR2_TABLE_300
1396: , p14_a3 JTF_VARCHAR2_TABLE_100
1397: , p14_a4 JTF_NUMBER_TABLE
1398: , p14_a5 JTF_VARCHAR2_TABLE_100
1399: , p14_a6 JTF_NUMBER_TABLE
1400: , p14_a7 JTF_VARCHAR2_TABLE_100
1401: , p14_a8 JTF_NUMBER_TABLE
1402: , p15_a0 JTF_NUMBER_TABLE

Line 1400: , p14_a7 JTF_VARCHAR2_TABLE_100

1396: , p14_a3 JTF_VARCHAR2_TABLE_100
1397: , p14_a4 JTF_NUMBER_TABLE
1398: , p14_a5 JTF_VARCHAR2_TABLE_100
1399: , p14_a6 JTF_NUMBER_TABLE
1400: , p14_a7 JTF_VARCHAR2_TABLE_100
1401: , p14_a8 JTF_NUMBER_TABLE
1402: , p15_a0 JTF_NUMBER_TABLE
1403: , p15_a1 JTF_NUMBER_TABLE
1404: , p15_a2 JTF_NUMBER_TABLE

Line 1405: , p15_a3 JTF_VARCHAR2_TABLE_100

1401: , p14_a8 JTF_NUMBER_TABLE
1402: , p15_a0 JTF_NUMBER_TABLE
1403: , p15_a1 JTF_NUMBER_TABLE
1404: , p15_a2 JTF_NUMBER_TABLE
1405: , p15_a3 JTF_VARCHAR2_TABLE_100
1406: , p15_a4 JTF_VARCHAR2_TABLE_100
1407: , p15_a5 JTF_VARCHAR2_TABLE_100
1408: , p15_a6 JTF_VARCHAR2_TABLE_100
1409: , p15_a7 JTF_DATE_TABLE

Line 1406: , p15_a4 JTF_VARCHAR2_TABLE_100

1402: , p15_a0 JTF_NUMBER_TABLE
1403: , p15_a1 JTF_NUMBER_TABLE
1404: , p15_a2 JTF_NUMBER_TABLE
1405: , p15_a3 JTF_VARCHAR2_TABLE_100
1406: , p15_a4 JTF_VARCHAR2_TABLE_100
1407: , p15_a5 JTF_VARCHAR2_TABLE_100
1408: , p15_a6 JTF_VARCHAR2_TABLE_100
1409: , p15_a7 JTF_DATE_TABLE
1410: , p15_a8 JTF_DATE_TABLE

Line 1407: , p15_a5 JTF_VARCHAR2_TABLE_100

1403: , p15_a1 JTF_NUMBER_TABLE
1404: , p15_a2 JTF_NUMBER_TABLE
1405: , p15_a3 JTF_VARCHAR2_TABLE_100
1406: , p15_a4 JTF_VARCHAR2_TABLE_100
1407: , p15_a5 JTF_VARCHAR2_TABLE_100
1408: , p15_a6 JTF_VARCHAR2_TABLE_100
1409: , p15_a7 JTF_DATE_TABLE
1410: , p15_a8 JTF_DATE_TABLE
1411: , p_auto_assign VARCHAR2

Line 1408: , p15_a6 JTF_VARCHAR2_TABLE_100

1404: , p15_a2 JTF_NUMBER_TABLE
1405: , p15_a3 JTF_VARCHAR2_TABLE_100
1406: , p15_a4 JTF_VARCHAR2_TABLE_100
1407: , p15_a5 JTF_VARCHAR2_TABLE_100
1408: , p15_a6 JTF_VARCHAR2_TABLE_100
1409: , p15_a7 JTF_DATE_TABLE
1410: , p15_a8 JTF_DATE_TABLE
1411: , p_auto_assign VARCHAR2
1412: , p_auto_generate_tasks VARCHAR2

Line 1985: , p14_a3 JTF_VARCHAR2_TABLE_100

1981: , p13_a207 NUMBER
1982: , p14_a0 JTF_VARCHAR2_TABLE_2000
1983: , p14_a1 JTF_VARCHAR2_TABLE_32767
1984: , p14_a2 JTF_VARCHAR2_TABLE_300
1985: , p14_a3 JTF_VARCHAR2_TABLE_100
1986: , p14_a4 JTF_NUMBER_TABLE
1987: , p14_a5 JTF_VARCHAR2_TABLE_100
1988: , p14_a6 JTF_NUMBER_TABLE
1989: , p14_a7 JTF_VARCHAR2_TABLE_100

Line 1987: , p14_a5 JTF_VARCHAR2_TABLE_100

1983: , p14_a1 JTF_VARCHAR2_TABLE_32767
1984: , p14_a2 JTF_VARCHAR2_TABLE_300
1985: , p14_a3 JTF_VARCHAR2_TABLE_100
1986: , p14_a4 JTF_NUMBER_TABLE
1987: , p14_a5 JTF_VARCHAR2_TABLE_100
1988: , p14_a6 JTF_NUMBER_TABLE
1989: , p14_a7 JTF_VARCHAR2_TABLE_100
1990: , p14_a8 JTF_NUMBER_TABLE
1991: , p15_a0 JTF_NUMBER_TABLE

Line 1989: , p14_a7 JTF_VARCHAR2_TABLE_100

1985: , p14_a3 JTF_VARCHAR2_TABLE_100
1986: , p14_a4 JTF_NUMBER_TABLE
1987: , p14_a5 JTF_VARCHAR2_TABLE_100
1988: , p14_a6 JTF_NUMBER_TABLE
1989: , p14_a7 JTF_VARCHAR2_TABLE_100
1990: , p14_a8 JTF_NUMBER_TABLE
1991: , p15_a0 JTF_NUMBER_TABLE
1992: , p15_a1 JTF_NUMBER_TABLE
1993: , p15_a2 JTF_NUMBER_TABLE

Line 1994: , p15_a3 JTF_VARCHAR2_TABLE_100

1990: , p14_a8 JTF_NUMBER_TABLE
1991: , p15_a0 JTF_NUMBER_TABLE
1992: , p15_a1 JTF_NUMBER_TABLE
1993: , p15_a2 JTF_NUMBER_TABLE
1994: , p15_a3 JTF_VARCHAR2_TABLE_100
1995: , p15_a4 JTF_VARCHAR2_TABLE_100
1996: , p15_a5 JTF_VARCHAR2_TABLE_100
1997: , p15_a6 JTF_VARCHAR2_TABLE_100
1998: , p15_a7 JTF_DATE_TABLE

Line 1995: , p15_a4 JTF_VARCHAR2_TABLE_100

1991: , p15_a0 JTF_NUMBER_TABLE
1992: , p15_a1 JTF_NUMBER_TABLE
1993: , p15_a2 JTF_NUMBER_TABLE
1994: , p15_a3 JTF_VARCHAR2_TABLE_100
1995: , p15_a4 JTF_VARCHAR2_TABLE_100
1996: , p15_a5 JTF_VARCHAR2_TABLE_100
1997: , p15_a6 JTF_VARCHAR2_TABLE_100
1998: , p15_a7 JTF_DATE_TABLE
1999: , p15_a8 JTF_DATE_TABLE

Line 1996: , p15_a5 JTF_VARCHAR2_TABLE_100

1992: , p15_a1 JTF_NUMBER_TABLE
1993: , p15_a2 JTF_NUMBER_TABLE
1994: , p15_a3 JTF_VARCHAR2_TABLE_100
1995: , p15_a4 JTF_VARCHAR2_TABLE_100
1996: , p15_a5 JTF_VARCHAR2_TABLE_100
1997: , p15_a6 JTF_VARCHAR2_TABLE_100
1998: , p15_a7 JTF_DATE_TABLE
1999: , p15_a8 JTF_DATE_TABLE
2000: , p_auto_assign VARCHAR2

Line 1997: , p15_a6 JTF_VARCHAR2_TABLE_100

1993: , p15_a2 JTF_NUMBER_TABLE
1994: , p15_a3 JTF_VARCHAR2_TABLE_100
1995: , p15_a4 JTF_VARCHAR2_TABLE_100
1996: , p15_a5 JTF_VARCHAR2_TABLE_100
1997: , p15_a6 JTF_VARCHAR2_TABLE_100
1998: , p15_a7 JTF_DATE_TABLE
1999: , p15_a8 JTF_DATE_TABLE
2000: , p_auto_assign VARCHAR2
2001: , p_default_contract_sla_ind VARCHAR2

Line 2552: , p16_a3 JTF_VARCHAR2_TABLE_100

2548: , p15_a207 NUMBER
2549: , p16_a0 JTF_VARCHAR2_TABLE_2000
2550: , p16_a1 JTF_VARCHAR2_TABLE_32767
2551: , p16_a2 JTF_VARCHAR2_TABLE_300
2552: , p16_a3 JTF_VARCHAR2_TABLE_100
2553: , p16_a4 JTF_NUMBER_TABLE
2554: , p16_a5 JTF_VARCHAR2_TABLE_100
2555: , p16_a6 JTF_NUMBER_TABLE
2556: , p16_a7 JTF_VARCHAR2_TABLE_100

Line 2554: , p16_a5 JTF_VARCHAR2_TABLE_100

2550: , p16_a1 JTF_VARCHAR2_TABLE_32767
2551: , p16_a2 JTF_VARCHAR2_TABLE_300
2552: , p16_a3 JTF_VARCHAR2_TABLE_100
2553: , p16_a4 JTF_NUMBER_TABLE
2554: , p16_a5 JTF_VARCHAR2_TABLE_100
2555: , p16_a6 JTF_NUMBER_TABLE
2556: , p16_a7 JTF_VARCHAR2_TABLE_100
2557: , p16_a8 JTF_NUMBER_TABLE
2558: , p17_a0 JTF_NUMBER_TABLE

Line 2556: , p16_a7 JTF_VARCHAR2_TABLE_100

2552: , p16_a3 JTF_VARCHAR2_TABLE_100
2553: , p16_a4 JTF_NUMBER_TABLE
2554: , p16_a5 JTF_VARCHAR2_TABLE_100
2555: , p16_a6 JTF_NUMBER_TABLE
2556: , p16_a7 JTF_VARCHAR2_TABLE_100
2557: , p16_a8 JTF_NUMBER_TABLE
2558: , p17_a0 JTF_NUMBER_TABLE
2559: , p17_a1 JTF_NUMBER_TABLE
2560: , p17_a2 JTF_NUMBER_TABLE

Line 2561: , p17_a3 JTF_VARCHAR2_TABLE_100

2557: , p16_a8 JTF_NUMBER_TABLE
2558: , p17_a0 JTF_NUMBER_TABLE
2559: , p17_a1 JTF_NUMBER_TABLE
2560: , p17_a2 JTF_NUMBER_TABLE
2561: , p17_a3 JTF_VARCHAR2_TABLE_100
2562: , p17_a4 JTF_VARCHAR2_TABLE_100
2563: , p17_a5 JTF_VARCHAR2_TABLE_100
2564: , p17_a6 JTF_VARCHAR2_TABLE_100
2565: , p17_a7 JTF_DATE_TABLE

Line 2562: , p17_a4 JTF_VARCHAR2_TABLE_100

2558: , p17_a0 JTF_NUMBER_TABLE
2559: , p17_a1 JTF_NUMBER_TABLE
2560: , p17_a2 JTF_NUMBER_TABLE
2561: , p17_a3 JTF_VARCHAR2_TABLE_100
2562: , p17_a4 JTF_VARCHAR2_TABLE_100
2563: , p17_a5 JTF_VARCHAR2_TABLE_100
2564: , p17_a6 JTF_VARCHAR2_TABLE_100
2565: , p17_a7 JTF_DATE_TABLE
2566: , p17_a8 JTF_DATE_TABLE

Line 2563: , p17_a5 JTF_VARCHAR2_TABLE_100

2559: , p17_a1 JTF_NUMBER_TABLE
2560: , p17_a2 JTF_NUMBER_TABLE
2561: , p17_a3 JTF_VARCHAR2_TABLE_100
2562: , p17_a4 JTF_VARCHAR2_TABLE_100
2563: , p17_a5 JTF_VARCHAR2_TABLE_100
2564: , p17_a6 JTF_VARCHAR2_TABLE_100
2565: , p17_a7 JTF_DATE_TABLE
2566: , p17_a8 JTF_DATE_TABLE
2567: , p_called_by_workflow VARCHAR2

Line 2564: , p17_a6 JTF_VARCHAR2_TABLE_100

2560: , p17_a2 JTF_NUMBER_TABLE
2561: , p17_a3 JTF_VARCHAR2_TABLE_100
2562: , p17_a4 JTF_VARCHAR2_TABLE_100
2563: , p17_a5 JTF_VARCHAR2_TABLE_100
2564: , p17_a6 JTF_VARCHAR2_TABLE_100
2565: , p17_a7 JTF_DATE_TABLE
2566: , p17_a8 JTF_DATE_TABLE
2567: , p_called_by_workflow VARCHAR2
2568: , p_workflow_process_id NUMBER

Line 3137: , p16_a3 JTF_VARCHAR2_TABLE_100

3133: , p15_a207 NUMBER
3134: , p16_a0 JTF_VARCHAR2_TABLE_2000
3135: , p16_a1 JTF_VARCHAR2_TABLE_32767
3136: , p16_a2 JTF_VARCHAR2_TABLE_300
3137: , p16_a3 JTF_VARCHAR2_TABLE_100
3138: , p16_a4 JTF_NUMBER_TABLE
3139: , p16_a5 JTF_VARCHAR2_TABLE_100
3140: , p16_a6 JTF_NUMBER_TABLE
3141: , p16_a7 JTF_VARCHAR2_TABLE_100

Line 3139: , p16_a5 JTF_VARCHAR2_TABLE_100

3135: , p16_a1 JTF_VARCHAR2_TABLE_32767
3136: , p16_a2 JTF_VARCHAR2_TABLE_300
3137: , p16_a3 JTF_VARCHAR2_TABLE_100
3138: , p16_a4 JTF_NUMBER_TABLE
3139: , p16_a5 JTF_VARCHAR2_TABLE_100
3140: , p16_a6 JTF_NUMBER_TABLE
3141: , p16_a7 JTF_VARCHAR2_TABLE_100
3142: , p16_a8 JTF_NUMBER_TABLE
3143: , p17_a0 JTF_NUMBER_TABLE

Line 3141: , p16_a7 JTF_VARCHAR2_TABLE_100

3137: , p16_a3 JTF_VARCHAR2_TABLE_100
3138: , p16_a4 JTF_NUMBER_TABLE
3139: , p16_a5 JTF_VARCHAR2_TABLE_100
3140: , p16_a6 JTF_NUMBER_TABLE
3141: , p16_a7 JTF_VARCHAR2_TABLE_100
3142: , p16_a8 JTF_NUMBER_TABLE
3143: , p17_a0 JTF_NUMBER_TABLE
3144: , p17_a1 JTF_NUMBER_TABLE
3145: , p17_a2 JTF_NUMBER_TABLE

Line 3146: , p17_a3 JTF_VARCHAR2_TABLE_100

3142: , p16_a8 JTF_NUMBER_TABLE
3143: , p17_a0 JTF_NUMBER_TABLE
3144: , p17_a1 JTF_NUMBER_TABLE
3145: , p17_a2 JTF_NUMBER_TABLE
3146: , p17_a3 JTF_VARCHAR2_TABLE_100
3147: , p17_a4 JTF_VARCHAR2_TABLE_100
3148: , p17_a5 JTF_VARCHAR2_TABLE_100
3149: , p17_a6 JTF_VARCHAR2_TABLE_100
3150: , p17_a7 JTF_DATE_TABLE

Line 3147: , p17_a4 JTF_VARCHAR2_TABLE_100

3143: , p17_a0 JTF_NUMBER_TABLE
3144: , p17_a1 JTF_NUMBER_TABLE
3145: , p17_a2 JTF_NUMBER_TABLE
3146: , p17_a3 JTF_VARCHAR2_TABLE_100
3147: , p17_a4 JTF_VARCHAR2_TABLE_100
3148: , p17_a5 JTF_VARCHAR2_TABLE_100
3149: , p17_a6 JTF_VARCHAR2_TABLE_100
3150: , p17_a7 JTF_DATE_TABLE
3151: , p17_a8 JTF_DATE_TABLE

Line 3148: , p17_a5 JTF_VARCHAR2_TABLE_100

3144: , p17_a1 JTF_NUMBER_TABLE
3145: , p17_a2 JTF_NUMBER_TABLE
3146: , p17_a3 JTF_VARCHAR2_TABLE_100
3147: , p17_a4 JTF_VARCHAR2_TABLE_100
3148: , p17_a5 JTF_VARCHAR2_TABLE_100
3149: , p17_a6 JTF_VARCHAR2_TABLE_100
3150: , p17_a7 JTF_DATE_TABLE
3151: , p17_a8 JTF_DATE_TABLE
3152: , p_called_by_workflow VARCHAR2

Line 3149: , p17_a6 JTF_VARCHAR2_TABLE_100

3145: , p17_a2 JTF_NUMBER_TABLE
3146: , p17_a3 JTF_VARCHAR2_TABLE_100
3147: , p17_a4 JTF_VARCHAR2_TABLE_100
3148: , p17_a5 JTF_VARCHAR2_TABLE_100
3149: , p17_a6 JTF_VARCHAR2_TABLE_100
3150: , p17_a7 JTF_DATE_TABLE
3151: , p17_a8 JTF_DATE_TABLE
3152: , p_called_by_workflow VARCHAR2
3153: , p_workflow_process_id NUMBER

Line 3803: , p14_a3 JTF_VARCHAR2_TABLE_100

3799: , p13_a207 NUMBER
3800: , p14_a0 JTF_VARCHAR2_TABLE_2000
3801: , p14_a1 JTF_VARCHAR2_TABLE_32767
3802: , p14_a2 JTF_VARCHAR2_TABLE_300
3803: , p14_a3 JTF_VARCHAR2_TABLE_100
3804: , p14_a4 JTF_NUMBER_TABLE
3805: , p14_a5 JTF_VARCHAR2_TABLE_100
3806: , p14_a6 JTF_NUMBER_TABLE
3807: , p14_a7 JTF_VARCHAR2_TABLE_100

Line 3805: , p14_a5 JTF_VARCHAR2_TABLE_100

3801: , p14_a1 JTF_VARCHAR2_TABLE_32767
3802: , p14_a2 JTF_VARCHAR2_TABLE_300
3803: , p14_a3 JTF_VARCHAR2_TABLE_100
3804: , p14_a4 JTF_NUMBER_TABLE
3805: , p14_a5 JTF_VARCHAR2_TABLE_100
3806: , p14_a6 JTF_NUMBER_TABLE
3807: , p14_a7 JTF_VARCHAR2_TABLE_100
3808: , p14_a8 JTF_NUMBER_TABLE
3809: , p15_a0 JTF_NUMBER_TABLE

Line 3807: , p14_a7 JTF_VARCHAR2_TABLE_100

3803: , p14_a3 JTF_VARCHAR2_TABLE_100
3804: , p14_a4 JTF_NUMBER_TABLE
3805: , p14_a5 JTF_VARCHAR2_TABLE_100
3806: , p14_a6 JTF_NUMBER_TABLE
3807: , p14_a7 JTF_VARCHAR2_TABLE_100
3808: , p14_a8 JTF_NUMBER_TABLE
3809: , p15_a0 JTF_NUMBER_TABLE
3810: , p15_a1 JTF_NUMBER_TABLE
3811: , p15_a2 JTF_NUMBER_TABLE

Line 3812: , p15_a3 JTF_VARCHAR2_TABLE_100

3808: , p14_a8 JTF_NUMBER_TABLE
3809: , p15_a0 JTF_NUMBER_TABLE
3810: , p15_a1 JTF_NUMBER_TABLE
3811: , p15_a2 JTF_NUMBER_TABLE
3812: , p15_a3 JTF_VARCHAR2_TABLE_100
3813: , p15_a4 JTF_VARCHAR2_TABLE_100
3814: , p15_a5 JTF_VARCHAR2_TABLE_100
3815: , p15_a6 JTF_VARCHAR2_TABLE_100
3816: , p15_a7 JTF_DATE_TABLE

Line 3813: , p15_a4 JTF_VARCHAR2_TABLE_100

3809: , p15_a0 JTF_NUMBER_TABLE
3810: , p15_a1 JTF_NUMBER_TABLE
3811: , p15_a2 JTF_NUMBER_TABLE
3812: , p15_a3 JTF_VARCHAR2_TABLE_100
3813: , p15_a4 JTF_VARCHAR2_TABLE_100
3814: , p15_a5 JTF_VARCHAR2_TABLE_100
3815: , p15_a6 JTF_VARCHAR2_TABLE_100
3816: , p15_a7 JTF_DATE_TABLE
3817: , p15_a8 JTF_DATE_TABLE

Line 3814: , p15_a5 JTF_VARCHAR2_TABLE_100

3810: , p15_a1 JTF_NUMBER_TABLE
3811: , p15_a2 JTF_NUMBER_TABLE
3812: , p15_a3 JTF_VARCHAR2_TABLE_100
3813: , p15_a4 JTF_VARCHAR2_TABLE_100
3814: , p15_a5 JTF_VARCHAR2_TABLE_100
3815: , p15_a6 JTF_VARCHAR2_TABLE_100
3816: , p15_a7 JTF_DATE_TABLE
3817: , p15_a8 JTF_DATE_TABLE
3818: , p_default_contract_sla_ind VARCHAR2

Line 3815: , p15_a6 JTF_VARCHAR2_TABLE_100

3811: , p15_a2 JTF_NUMBER_TABLE
3812: , p15_a3 JTF_VARCHAR2_TABLE_100
3813: , p15_a4 JTF_VARCHAR2_TABLE_100
3814: , p15_a5 JTF_VARCHAR2_TABLE_100
3815: , p15_a6 JTF_VARCHAR2_TABLE_100
3816: , p15_a7 JTF_DATE_TABLE
3817: , p15_a8 JTF_DATE_TABLE
3818: , p_default_contract_sla_ind VARCHAR2
3819: , x_request_id out nocopy NUMBER

Line 4139: , p4_a7 JTF_VARCHAR2_TABLE_100

4135: , p4_a3 JTF_VARCHAR2_TABLE_200
4136: , p4_a4 JTF_VARCHAR2_TABLE_200
4137: , p4_a5 JTF_VARCHAR2_TABLE_200
4138: , p4_a6 JTF_VARCHAR2_TABLE_200
4139: , p4_a7 JTF_VARCHAR2_TABLE_100
4140: , p4_a8 JTF_NUMBER_TABLE
4141: , p4_a9 JTF_NUMBER_TABLE
4142: , p4_a10 JTF_VARCHAR2_TABLE_100
4143: , p4_a11 JTF_VARCHAR2_TABLE_100

Line 4142: , p4_a10 JTF_VARCHAR2_TABLE_100

4138: , p4_a6 JTF_VARCHAR2_TABLE_200
4139: , p4_a7 JTF_VARCHAR2_TABLE_100
4140: , p4_a8 JTF_NUMBER_TABLE
4141: , p4_a9 JTF_NUMBER_TABLE
4142: , p4_a10 JTF_VARCHAR2_TABLE_100
4143: , p4_a11 JTF_VARCHAR2_TABLE_100
4144: , p4_a12 JTF_VARCHAR2_TABLE_200
4145: , p4_a13 JTF_VARCHAR2_TABLE_100
4146: , p4_a14 JTF_VARCHAR2_TABLE_100

Line 4143: , p4_a11 JTF_VARCHAR2_TABLE_100

4139: , p4_a7 JTF_VARCHAR2_TABLE_100
4140: , p4_a8 JTF_NUMBER_TABLE
4141: , p4_a9 JTF_NUMBER_TABLE
4142: , p4_a10 JTF_VARCHAR2_TABLE_100
4143: , p4_a11 JTF_VARCHAR2_TABLE_100
4144: , p4_a12 JTF_VARCHAR2_TABLE_200
4145: , p4_a13 JTF_VARCHAR2_TABLE_100
4146: , p4_a14 JTF_VARCHAR2_TABLE_100
4147: , p5_a0 JTF_NUMBER_TABLE

Line 4145: , p4_a13 JTF_VARCHAR2_TABLE_100

4141: , p4_a9 JTF_NUMBER_TABLE
4142: , p4_a10 JTF_VARCHAR2_TABLE_100
4143: , p4_a11 JTF_VARCHAR2_TABLE_100
4144: , p4_a12 JTF_VARCHAR2_TABLE_200
4145: , p4_a13 JTF_VARCHAR2_TABLE_100
4146: , p4_a14 JTF_VARCHAR2_TABLE_100
4147: , p5_a0 JTF_NUMBER_TABLE
4148: , p5_a1 JTF_VARCHAR2_TABLE_100
4149: , p5_a2 JTF_VARCHAR2_TABLE_200

Line 4146: , p4_a14 JTF_VARCHAR2_TABLE_100

4142: , p4_a10 JTF_VARCHAR2_TABLE_100
4143: , p4_a11 JTF_VARCHAR2_TABLE_100
4144: , p4_a12 JTF_VARCHAR2_TABLE_200
4145: , p4_a13 JTF_VARCHAR2_TABLE_100
4146: , p4_a14 JTF_VARCHAR2_TABLE_100
4147: , p5_a0 JTF_NUMBER_TABLE
4148: , p5_a1 JTF_VARCHAR2_TABLE_100
4149: , p5_a2 JTF_VARCHAR2_TABLE_200
4150: , p5_a3 JTF_VARCHAR2_TABLE_200

Line 4148: , p5_a1 JTF_VARCHAR2_TABLE_100

4144: , p4_a12 JTF_VARCHAR2_TABLE_200
4145: , p4_a13 JTF_VARCHAR2_TABLE_100
4146: , p4_a14 JTF_VARCHAR2_TABLE_100
4147: , p5_a0 JTF_NUMBER_TABLE
4148: , p5_a1 JTF_VARCHAR2_TABLE_100
4149: , p5_a2 JTF_VARCHAR2_TABLE_200
4150: , p5_a3 JTF_VARCHAR2_TABLE_200
4151: , p5_a4 JTF_VARCHAR2_TABLE_200
4152: , p5_a5 JTF_NUMBER_TABLE

Line 4154: , p5_a7 JTF_VARCHAR2_TABLE_1000

4150: , p5_a3 JTF_VARCHAR2_TABLE_200
4151: , p5_a4 JTF_VARCHAR2_TABLE_200
4152: , p5_a5 JTF_NUMBER_TABLE
4153: , p5_a6 JTF_DATE_TABLE
4154: , p5_a7 JTF_VARCHAR2_TABLE_1000
4155: , p5_a8 JTF_VARCHAR2_TABLE_100
4156: , p_modified_by NUMBER
4157: , p_modified_on date
4158: , x_failed_row_id_list out nocopy VARCHAR2

Line 4155: , p5_a8 JTF_VARCHAR2_TABLE_100

4151: , p5_a4 JTF_VARCHAR2_TABLE_200
4152: , p5_a5 JTF_NUMBER_TABLE
4153: , p5_a6 JTF_DATE_TABLE
4154: , p5_a7 JTF_VARCHAR2_TABLE_1000
4155: , p5_a8 JTF_VARCHAR2_TABLE_100
4156: , p_modified_by NUMBER
4157: , p_modified_on date
4158: , x_failed_row_id_list out nocopy VARCHAR2
4159: , x_return_status out nocopy VARCHAR2