DBA Data[Home] [Help]

APPS.IBE_ATTACHMENT_GRP_W dependencies on JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p1(t out nocopy ibe_attachment_grp.attachment_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE

Line 27: , a5 JTF_VARCHAR2_TABLE_100

23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100

Line 28: , a6 JTF_VARCHAR2_TABLE_100

24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_300

Line 29: , a7 JTF_VARCHAR2_TABLE_100

25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_300
33: , a11 JTF_NUMBER_TABLE

Line 31: , a9 JTF_VARCHAR2_TABLE_100

27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_300
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_2000

Line 38: , a16 JTF_VARCHAR2_TABLE_100

34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_2000
36: , a14 JTF_VARCHAR2_TABLE_2000
37: , a15 JTF_VARCHAR2_TABLE_2000
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_2000

Line 39: , a17 JTF_VARCHAR2_TABLE_100

35: , a13 JTF_VARCHAR2_TABLE_2000
36: , a14 JTF_VARCHAR2_TABLE_2000
37: , a15 JTF_VARCHAR2_TABLE_2000
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_2000
43: , a21 JTF_VARCHAR2_TABLE_300

Line 40: , a18 JTF_VARCHAR2_TABLE_100

36: , a14 JTF_VARCHAR2_TABLE_2000
37: , a15 JTF_VARCHAR2_TABLE_2000
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_2000
43: , a21 JTF_VARCHAR2_TABLE_300
44: , a22 JTF_VARCHAR2_TABLE_1100

Line 47: , a25 JTF_VARCHAR2_TABLE_100

43: , a21 JTF_VARCHAR2_TABLE_300
44: , a22 JTF_VARCHAR2_TABLE_1100
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_VARCHAR2_TABLE_300
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_200
49: , a27 JTF_VARCHAR2_TABLE_200
50: , a28 JTF_VARCHAR2_TABLE_200
51: , a29 JTF_VARCHAR2_TABLE_200

Line 64: , a42 JTF_VARCHAR2_TABLE_1000

60: , a38 JTF_VARCHAR2_TABLE_200
61: , a39 JTF_VARCHAR2_TABLE_200
62: , a40 JTF_VARCHAR2_TABLE_200
63: , a41 JTF_VARCHAR2_TABLE_2000
64: , a42 JTF_VARCHAR2_TABLE_1000
65: , a43 JTF_VARCHAR2_TABLE_100
66: , a44 JTF_VARCHAR2_TABLE_100
67: ) as
68: ddindx binary_integer; indx binary_integer;

Line 65: , a43 JTF_VARCHAR2_TABLE_100

61: , a39 JTF_VARCHAR2_TABLE_200
62: , a40 JTF_VARCHAR2_TABLE_200
63: , a41 JTF_VARCHAR2_TABLE_2000
64: , a42 JTF_VARCHAR2_TABLE_1000
65: , a43 JTF_VARCHAR2_TABLE_100
66: , a44 JTF_VARCHAR2_TABLE_100
67: ) as
68: ddindx binary_integer; indx binary_integer;
69: begin

Line 66: , a44 JTF_VARCHAR2_TABLE_100

62: , a40 JTF_VARCHAR2_TABLE_200
63: , a41 JTF_VARCHAR2_TABLE_2000
64: , a42 JTF_VARCHAR2_TABLE_1000
65: , a43 JTF_VARCHAR2_TABLE_100
66: , a44 JTF_VARCHAR2_TABLE_100
67: ) as
68: ddindx binary_integer; indx binary_integer;
69: begin
70: if a0 is not null and a0.count > 0 then

Line 133: , a4 out nocopy JTF_VARCHAR2_TABLE_100

129: procedure rosetta_table_copy_out_p1(t ibe_attachment_grp.attachment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
130: , a1 out nocopy JTF_NUMBER_TABLE
131: , a2 out nocopy JTF_VARCHAR2_TABLE_300
132: , a3 out nocopy JTF_NUMBER_TABLE
133: , a4 out nocopy JTF_VARCHAR2_TABLE_100
134: , a5 out nocopy JTF_VARCHAR2_TABLE_100
135: , a6 out nocopy JTF_VARCHAR2_TABLE_100
136: , a7 out nocopy JTF_VARCHAR2_TABLE_100
137: , a8 out nocopy JTF_NUMBER_TABLE

Line 134: , a5 out nocopy JTF_VARCHAR2_TABLE_100

130: , a1 out nocopy JTF_NUMBER_TABLE
131: , a2 out nocopy JTF_VARCHAR2_TABLE_300
132: , a3 out nocopy JTF_NUMBER_TABLE
133: , a4 out nocopy JTF_VARCHAR2_TABLE_100
134: , a5 out nocopy JTF_VARCHAR2_TABLE_100
135: , a6 out nocopy JTF_VARCHAR2_TABLE_100
136: , a7 out nocopy JTF_VARCHAR2_TABLE_100
137: , a8 out nocopy JTF_NUMBER_TABLE
138: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 135: , a6 out nocopy JTF_VARCHAR2_TABLE_100

131: , a2 out nocopy JTF_VARCHAR2_TABLE_300
132: , a3 out nocopy JTF_NUMBER_TABLE
133: , a4 out nocopy JTF_VARCHAR2_TABLE_100
134: , a5 out nocopy JTF_VARCHAR2_TABLE_100
135: , a6 out nocopy JTF_VARCHAR2_TABLE_100
136: , a7 out nocopy JTF_VARCHAR2_TABLE_100
137: , a8 out nocopy JTF_NUMBER_TABLE
138: , a9 out nocopy JTF_VARCHAR2_TABLE_100
139: , a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 136: , a7 out nocopy JTF_VARCHAR2_TABLE_100

132: , a3 out nocopy JTF_NUMBER_TABLE
133: , a4 out nocopy JTF_VARCHAR2_TABLE_100
134: , a5 out nocopy JTF_VARCHAR2_TABLE_100
135: , a6 out nocopy JTF_VARCHAR2_TABLE_100
136: , a7 out nocopy JTF_VARCHAR2_TABLE_100
137: , a8 out nocopy JTF_NUMBER_TABLE
138: , a9 out nocopy JTF_VARCHAR2_TABLE_100
139: , a10 out nocopy JTF_VARCHAR2_TABLE_300
140: , a11 out nocopy JTF_NUMBER_TABLE

Line 138: , a9 out nocopy JTF_VARCHAR2_TABLE_100

134: , a5 out nocopy JTF_VARCHAR2_TABLE_100
135: , a6 out nocopy JTF_VARCHAR2_TABLE_100
136: , a7 out nocopy JTF_VARCHAR2_TABLE_100
137: , a8 out nocopy JTF_NUMBER_TABLE
138: , a9 out nocopy JTF_VARCHAR2_TABLE_100
139: , a10 out nocopy JTF_VARCHAR2_TABLE_300
140: , a11 out nocopy JTF_NUMBER_TABLE
141: , a12 out nocopy JTF_NUMBER_TABLE
142: , a13 out nocopy JTF_VARCHAR2_TABLE_2000

Line 145: , a16 out nocopy JTF_VARCHAR2_TABLE_100

141: , a12 out nocopy JTF_NUMBER_TABLE
142: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
143: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
144: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
145: , a16 out nocopy JTF_VARCHAR2_TABLE_100
146: , a17 out nocopy JTF_VARCHAR2_TABLE_100
147: , a18 out nocopy JTF_VARCHAR2_TABLE_100
148: , a19 out nocopy JTF_NUMBER_TABLE
149: , a20 out nocopy JTF_VARCHAR2_TABLE_2000

Line 146: , a17 out nocopy JTF_VARCHAR2_TABLE_100

142: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
143: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
144: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
145: , a16 out nocopy JTF_VARCHAR2_TABLE_100
146: , a17 out nocopy JTF_VARCHAR2_TABLE_100
147: , a18 out nocopy JTF_VARCHAR2_TABLE_100
148: , a19 out nocopy JTF_NUMBER_TABLE
149: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
150: , a21 out nocopy JTF_VARCHAR2_TABLE_300

Line 147: , a18 out nocopy JTF_VARCHAR2_TABLE_100

143: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
144: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
145: , a16 out nocopy JTF_VARCHAR2_TABLE_100
146: , a17 out nocopy JTF_VARCHAR2_TABLE_100
147: , a18 out nocopy JTF_VARCHAR2_TABLE_100
148: , a19 out nocopy JTF_NUMBER_TABLE
149: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
150: , a21 out nocopy JTF_VARCHAR2_TABLE_300
151: , a22 out nocopy JTF_VARCHAR2_TABLE_1100

Line 154: , a25 out nocopy JTF_VARCHAR2_TABLE_100

150: , a21 out nocopy JTF_VARCHAR2_TABLE_300
151: , a22 out nocopy JTF_VARCHAR2_TABLE_1100
152: , a23 out nocopy JTF_NUMBER_TABLE
153: , a24 out nocopy JTF_VARCHAR2_TABLE_300
154: , a25 out nocopy JTF_VARCHAR2_TABLE_100
155: , a26 out nocopy JTF_VARCHAR2_TABLE_200
156: , a27 out nocopy JTF_VARCHAR2_TABLE_200
157: , a28 out nocopy JTF_VARCHAR2_TABLE_200
158: , a29 out nocopy JTF_VARCHAR2_TABLE_200

Line 171: , a42 out nocopy JTF_VARCHAR2_TABLE_1000

167: , a38 out nocopy JTF_VARCHAR2_TABLE_200
168: , a39 out nocopy JTF_VARCHAR2_TABLE_200
169: , a40 out nocopy JTF_VARCHAR2_TABLE_200
170: , a41 out nocopy JTF_VARCHAR2_TABLE_2000
171: , a42 out nocopy JTF_VARCHAR2_TABLE_1000
172: , a43 out nocopy JTF_VARCHAR2_TABLE_100
173: , a44 out nocopy JTF_VARCHAR2_TABLE_100
174: ) as
175: ddindx binary_integer; indx binary_integer;

Line 172: , a43 out nocopy JTF_VARCHAR2_TABLE_100

168: , a39 out nocopy JTF_VARCHAR2_TABLE_200
169: , a40 out nocopy JTF_VARCHAR2_TABLE_200
170: , a41 out nocopy JTF_VARCHAR2_TABLE_2000
171: , a42 out nocopy JTF_VARCHAR2_TABLE_1000
172: , a43 out nocopy JTF_VARCHAR2_TABLE_100
173: , a44 out nocopy JTF_VARCHAR2_TABLE_100
174: ) as
175: ddindx binary_integer; indx binary_integer;
176: begin

Line 173: , a44 out nocopy JTF_VARCHAR2_TABLE_100

169: , a40 out nocopy JTF_VARCHAR2_TABLE_200
170: , a41 out nocopy JTF_VARCHAR2_TABLE_2000
171: , a42 out nocopy JTF_VARCHAR2_TABLE_1000
172: , a43 out nocopy JTF_VARCHAR2_TABLE_100
173: , a44 out nocopy JTF_VARCHAR2_TABLE_100
174: ) as
175: ddindx binary_integer; indx binary_integer;
176: begin
177: if t is null or t.count = 0 then

Line 182: a4 := JTF_VARCHAR2_TABLE_100();

178: a0 := JTF_NUMBER_TABLE();
179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_VARCHAR2_TABLE_300();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_VARCHAR2_TABLE_100();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
185: a7 := JTF_VARCHAR2_TABLE_100();
186: a8 := JTF_NUMBER_TABLE();

Line 183: a5 := JTF_VARCHAR2_TABLE_100();

179: a1 := JTF_NUMBER_TABLE();
180: a2 := JTF_VARCHAR2_TABLE_300();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_VARCHAR2_TABLE_100();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
185: a7 := JTF_VARCHAR2_TABLE_100();
186: a8 := JTF_NUMBER_TABLE();
187: a9 := JTF_VARCHAR2_TABLE_100();

Line 184: a6 := JTF_VARCHAR2_TABLE_100();

180: a2 := JTF_VARCHAR2_TABLE_300();
181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_VARCHAR2_TABLE_100();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
185: a7 := JTF_VARCHAR2_TABLE_100();
186: a8 := JTF_NUMBER_TABLE();
187: a9 := JTF_VARCHAR2_TABLE_100();
188: a10 := JTF_VARCHAR2_TABLE_300();

Line 185: a7 := JTF_VARCHAR2_TABLE_100();

181: a3 := JTF_NUMBER_TABLE();
182: a4 := JTF_VARCHAR2_TABLE_100();
183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
185: a7 := JTF_VARCHAR2_TABLE_100();
186: a8 := JTF_NUMBER_TABLE();
187: a9 := JTF_VARCHAR2_TABLE_100();
188: a10 := JTF_VARCHAR2_TABLE_300();
189: a11 := JTF_NUMBER_TABLE();

Line 187: a9 := JTF_VARCHAR2_TABLE_100();

183: a5 := JTF_VARCHAR2_TABLE_100();
184: a6 := JTF_VARCHAR2_TABLE_100();
185: a7 := JTF_VARCHAR2_TABLE_100();
186: a8 := JTF_NUMBER_TABLE();
187: a9 := JTF_VARCHAR2_TABLE_100();
188: a10 := JTF_VARCHAR2_TABLE_300();
189: a11 := JTF_NUMBER_TABLE();
190: a12 := JTF_NUMBER_TABLE();
191: a13 := JTF_VARCHAR2_TABLE_2000();

Line 194: a16 := JTF_VARCHAR2_TABLE_100();

190: a12 := JTF_NUMBER_TABLE();
191: a13 := JTF_VARCHAR2_TABLE_2000();
192: a14 := JTF_VARCHAR2_TABLE_2000();
193: a15 := JTF_VARCHAR2_TABLE_2000();
194: a16 := JTF_VARCHAR2_TABLE_100();
195: a17 := JTF_VARCHAR2_TABLE_100();
196: a18 := JTF_VARCHAR2_TABLE_100();
197: a19 := JTF_NUMBER_TABLE();
198: a20 := JTF_VARCHAR2_TABLE_2000();

Line 195: a17 := JTF_VARCHAR2_TABLE_100();

191: a13 := JTF_VARCHAR2_TABLE_2000();
192: a14 := JTF_VARCHAR2_TABLE_2000();
193: a15 := JTF_VARCHAR2_TABLE_2000();
194: a16 := JTF_VARCHAR2_TABLE_100();
195: a17 := JTF_VARCHAR2_TABLE_100();
196: a18 := JTF_VARCHAR2_TABLE_100();
197: a19 := JTF_NUMBER_TABLE();
198: a20 := JTF_VARCHAR2_TABLE_2000();
199: a21 := JTF_VARCHAR2_TABLE_300();

Line 196: a18 := JTF_VARCHAR2_TABLE_100();

192: a14 := JTF_VARCHAR2_TABLE_2000();
193: a15 := JTF_VARCHAR2_TABLE_2000();
194: a16 := JTF_VARCHAR2_TABLE_100();
195: a17 := JTF_VARCHAR2_TABLE_100();
196: a18 := JTF_VARCHAR2_TABLE_100();
197: a19 := JTF_NUMBER_TABLE();
198: a20 := JTF_VARCHAR2_TABLE_2000();
199: a21 := JTF_VARCHAR2_TABLE_300();
200: a22 := JTF_VARCHAR2_TABLE_1100();

Line 203: a25 := JTF_VARCHAR2_TABLE_100();

199: a21 := JTF_VARCHAR2_TABLE_300();
200: a22 := JTF_VARCHAR2_TABLE_1100();
201: a23 := JTF_NUMBER_TABLE();
202: a24 := JTF_VARCHAR2_TABLE_300();
203: a25 := JTF_VARCHAR2_TABLE_100();
204: a26 := JTF_VARCHAR2_TABLE_200();
205: a27 := JTF_VARCHAR2_TABLE_200();
206: a28 := JTF_VARCHAR2_TABLE_200();
207: a29 := JTF_VARCHAR2_TABLE_200();

Line 220: a42 := JTF_VARCHAR2_TABLE_1000();

216: a38 := JTF_VARCHAR2_TABLE_200();
217: a39 := JTF_VARCHAR2_TABLE_200();
218: a40 := JTF_VARCHAR2_TABLE_200();
219: a41 := JTF_VARCHAR2_TABLE_2000();
220: a42 := JTF_VARCHAR2_TABLE_1000();
221: a43 := JTF_VARCHAR2_TABLE_100();
222: a44 := JTF_VARCHAR2_TABLE_100();
223: else
224: a0 := JTF_NUMBER_TABLE();

Line 221: a43 := JTF_VARCHAR2_TABLE_100();

217: a39 := JTF_VARCHAR2_TABLE_200();
218: a40 := JTF_VARCHAR2_TABLE_200();
219: a41 := JTF_VARCHAR2_TABLE_2000();
220: a42 := JTF_VARCHAR2_TABLE_1000();
221: a43 := JTF_VARCHAR2_TABLE_100();
222: a44 := JTF_VARCHAR2_TABLE_100();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();

Line 222: a44 := JTF_VARCHAR2_TABLE_100();

218: a40 := JTF_VARCHAR2_TABLE_200();
219: a41 := JTF_VARCHAR2_TABLE_2000();
220: a42 := JTF_VARCHAR2_TABLE_1000();
221: a43 := JTF_VARCHAR2_TABLE_100();
222: a44 := JTF_VARCHAR2_TABLE_100();
223: else
224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_VARCHAR2_TABLE_300();

Line 228: a4 := JTF_VARCHAR2_TABLE_100();

224: a0 := JTF_NUMBER_TABLE();
225: a1 := JTF_NUMBER_TABLE();
226: a2 := JTF_VARCHAR2_TABLE_300();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_VARCHAR2_TABLE_100();
229: a5 := JTF_VARCHAR2_TABLE_100();
230: a6 := JTF_VARCHAR2_TABLE_100();
231: a7 := JTF_VARCHAR2_TABLE_100();
232: a8 := JTF_NUMBER_TABLE();

Line 229: a5 := JTF_VARCHAR2_TABLE_100();

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

Line 230: a6 := JTF_VARCHAR2_TABLE_100();

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

Line 231: a7 := JTF_VARCHAR2_TABLE_100();

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

Line 233: a9 := JTF_VARCHAR2_TABLE_100();

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

Line 240: a16 := JTF_VARCHAR2_TABLE_100();

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

Line 241: a17 := JTF_VARCHAR2_TABLE_100();

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

Line 242: a18 := JTF_VARCHAR2_TABLE_100();

238: a14 := JTF_VARCHAR2_TABLE_2000();
239: a15 := JTF_VARCHAR2_TABLE_2000();
240: a16 := JTF_VARCHAR2_TABLE_100();
241: a17 := JTF_VARCHAR2_TABLE_100();
242: a18 := JTF_VARCHAR2_TABLE_100();
243: a19 := JTF_NUMBER_TABLE();
244: a20 := JTF_VARCHAR2_TABLE_2000();
245: a21 := JTF_VARCHAR2_TABLE_300();
246: a22 := JTF_VARCHAR2_TABLE_1100();

Line 249: a25 := JTF_VARCHAR2_TABLE_100();

245: a21 := JTF_VARCHAR2_TABLE_300();
246: a22 := JTF_VARCHAR2_TABLE_1100();
247: a23 := JTF_NUMBER_TABLE();
248: a24 := JTF_VARCHAR2_TABLE_300();
249: a25 := JTF_VARCHAR2_TABLE_100();
250: a26 := JTF_VARCHAR2_TABLE_200();
251: a27 := JTF_VARCHAR2_TABLE_200();
252: a28 := JTF_VARCHAR2_TABLE_200();
253: a29 := JTF_VARCHAR2_TABLE_200();

Line 266: a42 := JTF_VARCHAR2_TABLE_1000();

262: a38 := JTF_VARCHAR2_TABLE_200();
263: a39 := JTF_VARCHAR2_TABLE_200();
264: a40 := JTF_VARCHAR2_TABLE_200();
265: a41 := JTF_VARCHAR2_TABLE_2000();
266: a42 := JTF_VARCHAR2_TABLE_1000();
267: a43 := JTF_VARCHAR2_TABLE_100();
268: a44 := JTF_VARCHAR2_TABLE_100();
269: if t.count > 0 then
270: a0.extend(t.count);

Line 267: a43 := JTF_VARCHAR2_TABLE_100();

263: a39 := JTF_VARCHAR2_TABLE_200();
264: a40 := JTF_VARCHAR2_TABLE_200();
265: a41 := JTF_VARCHAR2_TABLE_2000();
266: a42 := JTF_VARCHAR2_TABLE_1000();
267: a43 := JTF_VARCHAR2_TABLE_100();
268: a44 := JTF_VARCHAR2_TABLE_100();
269: if t.count > 0 then
270: a0.extend(t.count);
271: a1.extend(t.count);

Line 268: a44 := JTF_VARCHAR2_TABLE_100();

264: a40 := JTF_VARCHAR2_TABLE_200();
265: a41 := JTF_VARCHAR2_TABLE_2000();
266: a42 := JTF_VARCHAR2_TABLE_1000();
267: a43 := JTF_VARCHAR2_TABLE_100();
268: a44 := JTF_VARCHAR2_TABLE_100();
269: if t.count > 0 then
270: a0.extend(t.count);
271: a1.extend(t.count);
272: a2.extend(t.count);

Line 376: , a3 JTF_VARCHAR2_TABLE_100

372:
373: procedure rosetta_table_copy_in_p3(t out nocopy ibe_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
374: , a1 JTF_VARCHAR2_TABLE_300
375: , a2 JTF_NUMBER_TABLE
376: , a3 JTF_VARCHAR2_TABLE_100
377: ) as
378: ddindx binary_integer; indx binary_integer;
379: begin
380: if a0 is not null and a0.count > 0 then

Line 401: , a3 out nocopy JTF_VARCHAR2_TABLE_100

397: end rosetta_table_copy_in_p3;
398: procedure rosetta_table_copy_out_p3(t ibe_attachment_grp.ath_id_ver_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
399: , a1 out nocopy JTF_VARCHAR2_TABLE_300
400: , a2 out nocopy JTF_NUMBER_TABLE
401: , a3 out nocopy JTF_VARCHAR2_TABLE_100
402: ) as
403: ddindx binary_integer; indx binary_integer;
404: begin
405: if t is null or t.count = 0 then

Line 409: a3 := JTF_VARCHAR2_TABLE_100();

405: if t is null or t.count = 0 then
406: a0 := JTF_NUMBER_TABLE();
407: a1 := JTF_VARCHAR2_TABLE_300();
408: a2 := JTF_NUMBER_TABLE();
409: a3 := JTF_VARCHAR2_TABLE_100();
410: else
411: a0 := JTF_NUMBER_TABLE();
412: a1 := JTF_VARCHAR2_TABLE_300();
413: a2 := JTF_NUMBER_TABLE();

Line 414: a3 := JTF_VARCHAR2_TABLE_100();

410: else
411: a0 := JTF_NUMBER_TABLE();
412: a1 := JTF_VARCHAR2_TABLE_300();
413: a2 := JTF_NUMBER_TABLE();
414: a3 := JTF_VARCHAR2_TABLE_100();
415: if t.count > 0 then
416: a0.extend(t.count);
417: a1.extend(t.count);
418: a2.extend(t.count);

Line 535: procedure rosetta_table_copy_in_p6(t out nocopy ibe_attachment_grp.varchar2_table_20, a0 JTF_VARCHAR2_TABLE_100) as

531: end if;
532: end if;
533: end rosetta_table_copy_out_p5;
534:
535: procedure rosetta_table_copy_in_p6(t out nocopy ibe_attachment_grp.varchar2_table_20, a0 JTF_VARCHAR2_TABLE_100) as
536: ddindx binary_integer; indx binary_integer;
537: begin
538: if a0 is null then
539: t := null;

Line 559: procedure rosetta_table_copy_out_p6(t ibe_attachment_grp.varchar2_table_20, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

555: end loop;
556: end if;
557: end if;
558: end rosetta_table_copy_in_p6;
559: procedure rosetta_table_copy_out_p6(t ibe_attachment_grp.varchar2_table_20, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
560: ddindx binary_integer; indx binary_integer;
561: begin
562: if t is null then
563: a0 := null;

Line 565: a0 := JTF_VARCHAR2_TABLE_100();

561: begin
562: if t is null then
563: a0 := null;
564: elsif t.count = 0 then
565: a0 := JTF_VARCHAR2_TABLE_100();
566: else
567: a0 := JTF_VARCHAR2_TABLE_100();
568: if t.count > 0 then
569: a0.extend(t.count);

Line 567: a0 := JTF_VARCHAR2_TABLE_100();

563: a0 := null;
564: elsif t.count = 0 then
565: a0 := JTF_VARCHAR2_TABLE_100();
566: else
567: a0 := JTF_VARCHAR2_TABLE_100();
568: if t.count > 0 then
569: a0.extend(t.count);
570: ddindx := t.first;
571: indx := 1;

Line 598: , x_file_ext_tbl out nocopy JTF_VARCHAR2_TABLE_100

594: , x_ath_id_tbl out nocopy JTF_NUMBER_TABLE
595: , x_dlv_id_tbl out nocopy JTF_NUMBER_TABLE
596: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
597: , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
598: , x_file_ext_tbl out nocopy JTF_VARCHAR2_TABLE_100
599: , x_dsp_width_tbl out nocopy JTF_NUMBER_TABLE
600: , x_dsp_height_tbl out nocopy JTF_NUMBER_TABLE
601: , x_version_tbl out nocopy JTF_NUMBER_TABLE
602: )

Line 867: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100

863: , p6_a0 in out nocopy JTF_NUMBER_TABLE
864: , p6_a1 in out nocopy JTF_NUMBER_TABLE
865: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300
866: , p6_a3 in out nocopy JTF_NUMBER_TABLE
867: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
868: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
869: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a8 in out nocopy JTF_NUMBER_TABLE

Line 868: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

864: , p6_a1 in out nocopy JTF_NUMBER_TABLE
865: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300
866: , p6_a3 in out nocopy JTF_NUMBER_TABLE
867: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
868: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
869: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a8 in out nocopy JTF_NUMBER_TABLE
872: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 869: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

865: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300
866: , p6_a3 in out nocopy JTF_NUMBER_TABLE
867: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
868: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
869: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a8 in out nocopy JTF_NUMBER_TABLE
872: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100
873: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300

Line 870: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100

866: , p6_a3 in out nocopy JTF_NUMBER_TABLE
867: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
868: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
869: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a8 in out nocopy JTF_NUMBER_TABLE
872: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100
873: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300
874: , p6_a11 in out nocopy JTF_NUMBER_TABLE

Line 872: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100

868: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
869: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
871: , p6_a8 in out nocopy JTF_NUMBER_TABLE
872: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100
873: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300
874: , p6_a11 in out nocopy JTF_NUMBER_TABLE
875: , p6_a12 in out nocopy JTF_NUMBER_TABLE
876: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 879: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100

875: , p6_a12 in out nocopy JTF_NUMBER_TABLE
876: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_2000
877: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_2000
878: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_2000
879: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
880: , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_100
881: , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_100
882: , p6_a19 in out nocopy JTF_NUMBER_TABLE
883: , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 880: , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_100

876: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_2000
877: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_2000
878: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_2000
879: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
880: , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_100
881: , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_100
882: , p6_a19 in out nocopy JTF_NUMBER_TABLE
883: , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_2000
884: , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_300

Line 881: , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_100

877: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_2000
878: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_2000
879: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
880: , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_100
881: , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_100
882: , p6_a19 in out nocopy JTF_NUMBER_TABLE
883: , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_2000
884: , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_300
885: , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_1100

Line 888: , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_100

884: , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_300
885: , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_1100
886: , p6_a23 in out nocopy JTF_NUMBER_TABLE
887: , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_300
888: , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_100
889: , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_200
890: , p6_a27 in out nocopy JTF_VARCHAR2_TABLE_200
891: , p6_a28 in out nocopy JTF_VARCHAR2_TABLE_200
892: , p6_a29 in out nocopy JTF_VARCHAR2_TABLE_200

Line 905: , p6_a42 in out nocopy JTF_VARCHAR2_TABLE_1000

901: , p6_a38 in out nocopy JTF_VARCHAR2_TABLE_200
902: , p6_a39 in out nocopy JTF_VARCHAR2_TABLE_200
903: , p6_a40 in out nocopy JTF_VARCHAR2_TABLE_200
904: , p6_a41 in out nocopy JTF_VARCHAR2_TABLE_2000
905: , p6_a42 in out nocopy JTF_VARCHAR2_TABLE_1000
906: , p6_a43 in out nocopy JTF_VARCHAR2_TABLE_100
907: , p6_a44 in out nocopy JTF_VARCHAR2_TABLE_100
908: )
909:

Line 906: , p6_a43 in out nocopy JTF_VARCHAR2_TABLE_100

902: , p6_a39 in out nocopy JTF_VARCHAR2_TABLE_200
903: , p6_a40 in out nocopy JTF_VARCHAR2_TABLE_200
904: , p6_a41 in out nocopy JTF_VARCHAR2_TABLE_2000
905: , p6_a42 in out nocopy JTF_VARCHAR2_TABLE_1000
906: , p6_a43 in out nocopy JTF_VARCHAR2_TABLE_100
907: , p6_a44 in out nocopy JTF_VARCHAR2_TABLE_100
908: )
909:
910: as

Line 907: , p6_a44 in out nocopy JTF_VARCHAR2_TABLE_100

903: , p6_a40 in out nocopy JTF_VARCHAR2_TABLE_200
904: , p6_a41 in out nocopy JTF_VARCHAR2_TABLE_2000
905: , p6_a42 in out nocopy JTF_VARCHAR2_TABLE_1000
906: , p6_a43 in out nocopy JTF_VARCHAR2_TABLE_100
907: , p6_a44 in out nocopy JTF_VARCHAR2_TABLE_100
908: )
909:
910: as
911: ddp_attachment_tbl ibe_attachment_grp.attachment_tbl_type;

Line 1042: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100

1038: , x_msg_data out nocopy VARCHAR2
1039: , p6_a0 in out nocopy JTF_NUMBER_TABLE
1040: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_300
1041: , p6_a2 in out nocopy JTF_NUMBER_TABLE
1042: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1043: )
1044:
1045: as
1046: ddp_ath_id_ver_tbl ibe_attachment_grp.ath_id_ver_tbl_type;