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

APPS.OZF_VOLUME_OFFER_DISC_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_volume_offer_disc_pvt.ozf_vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
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_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100

Line 27: , a5 JTF_VARCHAR2_TABLE_100

23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
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_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100

Line 28: , a6 JTF_VARCHAR2_TABLE_100

24: , a2 JTF_NUMBER_TABLE
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_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100

Line 30: , a8 JTF_VARCHAR2_TABLE_100

26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 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_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100

Line 32: , a10 JTF_VARCHAR2_TABLE_100

28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE

Line 33: , a11 JTF_VARCHAR2_TABLE_100

29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE

Line 35: , a13 JTF_VARCHAR2_TABLE_100

31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_VARCHAR2_TABLE_100
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_100
36: , a14 JTF_NUMBER_TABLE
37: , a15 JTF_NUMBER_TABLE
38: , a16 JTF_NUMBER_TABLE
39: , a17 JTF_NUMBER_TABLE

Line 40: , a18 JTF_VARCHAR2_TABLE_100

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

Line 43: , a21 JTF_VARCHAR2_TABLE_100

39: , a17 JTF_NUMBER_TABLE
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_DATE_TABLE
42: , a20 JTF_DATE_TABLE
43: , a21 JTF_VARCHAR2_TABLE_100
44: , a22 JTF_DATE_TABLE
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_DATE_TABLE
47: , a25 JTF_NUMBER_TABLE

Line 51: , a29 JTF_VARCHAR2_TABLE_100

47: , a25 JTF_NUMBER_TABLE
48: , a26 JTF_NUMBER_TABLE
49: , a27 JTF_NUMBER_TABLE
50: , a28 JTF_NUMBER_TABLE
51: , a29 JTF_VARCHAR2_TABLE_100
52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_NUMBER_TABLE
54: , a32 JTF_VARCHAR2_TABLE_300
55: , a33 JTF_VARCHAR2_TABLE_2000

Line 56: , a34 JTF_VARCHAR2_TABLE_100

52: , a30 JTF_NUMBER_TABLE
53: , a31 JTF_NUMBER_TABLE
54: , a32 JTF_VARCHAR2_TABLE_300
55: , a33 JTF_VARCHAR2_TABLE_2000
56: , a34 JTF_VARCHAR2_TABLE_100
57: , a35 JTF_VARCHAR2_TABLE_300
58: , a36 JTF_VARCHAR2_TABLE_300
59: , a37 JTF_VARCHAR2_TABLE_300
60: , a38 JTF_VARCHAR2_TABLE_300

Line 143: , a4 out nocopy JTF_VARCHAR2_TABLE_100

139: procedure rosetta_table_copy_out_p2(t ozf_volume_offer_disc_pvt.ozf_vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
140: , a1 out nocopy JTF_NUMBER_TABLE
141: , a2 out nocopy JTF_NUMBER_TABLE
142: , a3 out nocopy JTF_NUMBER_TABLE
143: , a4 out nocopy JTF_VARCHAR2_TABLE_100
144: , a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , a6 out nocopy JTF_VARCHAR2_TABLE_100
146: , a7 out nocopy JTF_NUMBER_TABLE
147: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 144: , a5 out nocopy JTF_VARCHAR2_TABLE_100

140: , a1 out nocopy JTF_NUMBER_TABLE
141: , a2 out nocopy JTF_NUMBER_TABLE
142: , a3 out nocopy JTF_NUMBER_TABLE
143: , a4 out nocopy JTF_VARCHAR2_TABLE_100
144: , a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , a6 out nocopy JTF_VARCHAR2_TABLE_100
146: , a7 out nocopy JTF_NUMBER_TABLE
147: , a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 145: , a6 out nocopy JTF_VARCHAR2_TABLE_100

141: , a2 out nocopy JTF_NUMBER_TABLE
142: , a3 out nocopy JTF_NUMBER_TABLE
143: , a4 out nocopy JTF_VARCHAR2_TABLE_100
144: , a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , a6 out nocopy JTF_VARCHAR2_TABLE_100
146: , a7 out nocopy JTF_NUMBER_TABLE
147: , a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , a9 out nocopy JTF_VARCHAR2_TABLE_100
149: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 147: , a8 out nocopy JTF_VARCHAR2_TABLE_100

143: , a4 out nocopy JTF_VARCHAR2_TABLE_100
144: , a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , a6 out nocopy JTF_VARCHAR2_TABLE_100
146: , a7 out nocopy JTF_NUMBER_TABLE
147: , a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , a9 out nocopy JTF_VARCHAR2_TABLE_100
149: , a10 out nocopy JTF_VARCHAR2_TABLE_100
150: , a11 out nocopy JTF_VARCHAR2_TABLE_100
151: , a12 out nocopy JTF_NUMBER_TABLE

Line 148: , a9 out nocopy JTF_VARCHAR2_TABLE_100

144: , a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , a6 out nocopy JTF_VARCHAR2_TABLE_100
146: , a7 out nocopy JTF_NUMBER_TABLE
147: , a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , a9 out nocopy JTF_VARCHAR2_TABLE_100
149: , a10 out nocopy JTF_VARCHAR2_TABLE_100
150: , a11 out nocopy JTF_VARCHAR2_TABLE_100
151: , a12 out nocopy JTF_NUMBER_TABLE
152: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 149: , a10 out nocopy JTF_VARCHAR2_TABLE_100

145: , a6 out nocopy JTF_VARCHAR2_TABLE_100
146: , a7 out nocopy JTF_NUMBER_TABLE
147: , a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , a9 out nocopy JTF_VARCHAR2_TABLE_100
149: , a10 out nocopy JTF_VARCHAR2_TABLE_100
150: , a11 out nocopy JTF_VARCHAR2_TABLE_100
151: , a12 out nocopy JTF_NUMBER_TABLE
152: , a13 out nocopy JTF_VARCHAR2_TABLE_100
153: , a14 out nocopy JTF_NUMBER_TABLE

Line 150: , a11 out nocopy JTF_VARCHAR2_TABLE_100

146: , a7 out nocopy JTF_NUMBER_TABLE
147: , a8 out nocopy JTF_VARCHAR2_TABLE_100
148: , a9 out nocopy JTF_VARCHAR2_TABLE_100
149: , a10 out nocopy JTF_VARCHAR2_TABLE_100
150: , a11 out nocopy JTF_VARCHAR2_TABLE_100
151: , a12 out nocopy JTF_NUMBER_TABLE
152: , a13 out nocopy JTF_VARCHAR2_TABLE_100
153: , a14 out nocopy JTF_NUMBER_TABLE
154: , a15 out nocopy JTF_NUMBER_TABLE

Line 152: , a13 out nocopy JTF_VARCHAR2_TABLE_100

148: , a9 out nocopy JTF_VARCHAR2_TABLE_100
149: , a10 out nocopy JTF_VARCHAR2_TABLE_100
150: , a11 out nocopy JTF_VARCHAR2_TABLE_100
151: , a12 out nocopy JTF_NUMBER_TABLE
152: , a13 out nocopy JTF_VARCHAR2_TABLE_100
153: , a14 out nocopy JTF_NUMBER_TABLE
154: , a15 out nocopy JTF_NUMBER_TABLE
155: , a16 out nocopy JTF_NUMBER_TABLE
156: , a17 out nocopy JTF_NUMBER_TABLE

Line 157: , a18 out nocopy JTF_VARCHAR2_TABLE_100

153: , a14 out nocopy JTF_NUMBER_TABLE
154: , a15 out nocopy JTF_NUMBER_TABLE
155: , a16 out nocopy JTF_NUMBER_TABLE
156: , a17 out nocopy JTF_NUMBER_TABLE
157: , a18 out nocopy JTF_VARCHAR2_TABLE_100
158: , a19 out nocopy JTF_DATE_TABLE
159: , a20 out nocopy JTF_DATE_TABLE
160: , a21 out nocopy JTF_VARCHAR2_TABLE_100
161: , a22 out nocopy JTF_DATE_TABLE

Line 160: , a21 out nocopy JTF_VARCHAR2_TABLE_100

156: , a17 out nocopy JTF_NUMBER_TABLE
157: , a18 out nocopy JTF_VARCHAR2_TABLE_100
158: , a19 out nocopy JTF_DATE_TABLE
159: , a20 out nocopy JTF_DATE_TABLE
160: , a21 out nocopy JTF_VARCHAR2_TABLE_100
161: , a22 out nocopy JTF_DATE_TABLE
162: , a23 out nocopy JTF_NUMBER_TABLE
163: , a24 out nocopy JTF_DATE_TABLE
164: , a25 out nocopy JTF_NUMBER_TABLE

Line 168: , a29 out nocopy JTF_VARCHAR2_TABLE_100

164: , a25 out nocopy JTF_NUMBER_TABLE
165: , a26 out nocopy JTF_NUMBER_TABLE
166: , a27 out nocopy JTF_NUMBER_TABLE
167: , a28 out nocopy JTF_NUMBER_TABLE
168: , a29 out nocopy JTF_VARCHAR2_TABLE_100
169: , a30 out nocopy JTF_NUMBER_TABLE
170: , a31 out nocopy JTF_NUMBER_TABLE
171: , a32 out nocopy JTF_VARCHAR2_TABLE_300
172: , a33 out nocopy JTF_VARCHAR2_TABLE_2000

Line 173: , a34 out nocopy JTF_VARCHAR2_TABLE_100

169: , a30 out nocopy JTF_NUMBER_TABLE
170: , a31 out nocopy JTF_NUMBER_TABLE
171: , a32 out nocopy JTF_VARCHAR2_TABLE_300
172: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
173: , a34 out nocopy JTF_VARCHAR2_TABLE_100
174: , a35 out nocopy JTF_VARCHAR2_TABLE_300
175: , a36 out nocopy JTF_VARCHAR2_TABLE_300
176: , a37 out nocopy JTF_VARCHAR2_TABLE_300
177: , a38 out nocopy JTF_VARCHAR2_TABLE_300

Line 197: a4 := JTF_VARCHAR2_TABLE_100();

193: a0 := JTF_NUMBER_TABLE();
194: a1 := JTF_NUMBER_TABLE();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_NUMBER_TABLE();
197: a4 := JTF_VARCHAR2_TABLE_100();
198: a5 := JTF_VARCHAR2_TABLE_100();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_NUMBER_TABLE();
201: a8 := JTF_VARCHAR2_TABLE_100();

Line 198: a5 := JTF_VARCHAR2_TABLE_100();

194: a1 := JTF_NUMBER_TABLE();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_NUMBER_TABLE();
197: a4 := JTF_VARCHAR2_TABLE_100();
198: a5 := JTF_VARCHAR2_TABLE_100();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_NUMBER_TABLE();
201: a8 := JTF_VARCHAR2_TABLE_100();
202: a9 := JTF_VARCHAR2_TABLE_100();

Line 199: a6 := JTF_VARCHAR2_TABLE_100();

195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_NUMBER_TABLE();
197: a4 := JTF_VARCHAR2_TABLE_100();
198: a5 := JTF_VARCHAR2_TABLE_100();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_NUMBER_TABLE();
201: a8 := JTF_VARCHAR2_TABLE_100();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_VARCHAR2_TABLE_100();

Line 201: a8 := JTF_VARCHAR2_TABLE_100();

197: a4 := JTF_VARCHAR2_TABLE_100();
198: a5 := JTF_VARCHAR2_TABLE_100();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_NUMBER_TABLE();
201: a8 := JTF_VARCHAR2_TABLE_100();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_VARCHAR2_TABLE_100();
204: a11 := JTF_VARCHAR2_TABLE_100();
205: a12 := JTF_NUMBER_TABLE();

Line 202: a9 := JTF_VARCHAR2_TABLE_100();

198: a5 := JTF_VARCHAR2_TABLE_100();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_NUMBER_TABLE();
201: a8 := JTF_VARCHAR2_TABLE_100();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_VARCHAR2_TABLE_100();
204: a11 := JTF_VARCHAR2_TABLE_100();
205: a12 := JTF_NUMBER_TABLE();
206: a13 := JTF_VARCHAR2_TABLE_100();

Line 203: a10 := JTF_VARCHAR2_TABLE_100();

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

Line 204: a11 := JTF_VARCHAR2_TABLE_100();

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

Line 206: a13 := JTF_VARCHAR2_TABLE_100();

202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_VARCHAR2_TABLE_100();
204: a11 := JTF_VARCHAR2_TABLE_100();
205: a12 := JTF_NUMBER_TABLE();
206: a13 := JTF_VARCHAR2_TABLE_100();
207: a14 := JTF_NUMBER_TABLE();
208: a15 := JTF_NUMBER_TABLE();
209: a16 := JTF_NUMBER_TABLE();
210: a17 := JTF_NUMBER_TABLE();

Line 211: a18 := JTF_VARCHAR2_TABLE_100();

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

Line 214: a21 := JTF_VARCHAR2_TABLE_100();

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

Line 222: a29 := JTF_VARCHAR2_TABLE_100();

218: a25 := JTF_NUMBER_TABLE();
219: a26 := JTF_NUMBER_TABLE();
220: a27 := JTF_NUMBER_TABLE();
221: a28 := JTF_NUMBER_TABLE();
222: a29 := JTF_VARCHAR2_TABLE_100();
223: a30 := JTF_NUMBER_TABLE();
224: a31 := JTF_NUMBER_TABLE();
225: a32 := JTF_VARCHAR2_TABLE_300();
226: a33 := JTF_VARCHAR2_TABLE_2000();

Line 227: a34 := JTF_VARCHAR2_TABLE_100();

223: a30 := JTF_NUMBER_TABLE();
224: a31 := JTF_NUMBER_TABLE();
225: a32 := JTF_VARCHAR2_TABLE_300();
226: a33 := JTF_VARCHAR2_TABLE_2000();
227: a34 := JTF_VARCHAR2_TABLE_100();
228: a35 := JTF_VARCHAR2_TABLE_300();
229: a36 := JTF_VARCHAR2_TABLE_300();
230: a37 := JTF_VARCHAR2_TABLE_300();
231: a38 := JTF_VARCHAR2_TABLE_300();

Line 248: a4 := JTF_VARCHAR2_TABLE_100();

244: a0 := JTF_NUMBER_TABLE();
245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_NUMBER_TABLE();
247: a3 := JTF_NUMBER_TABLE();
248: a4 := JTF_VARCHAR2_TABLE_100();
249: a5 := JTF_VARCHAR2_TABLE_100();
250: a6 := JTF_VARCHAR2_TABLE_100();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();

Line 249: a5 := JTF_VARCHAR2_TABLE_100();

245: a1 := JTF_NUMBER_TABLE();
246: a2 := JTF_NUMBER_TABLE();
247: a3 := JTF_NUMBER_TABLE();
248: a4 := JTF_VARCHAR2_TABLE_100();
249: a5 := JTF_VARCHAR2_TABLE_100();
250: a6 := JTF_VARCHAR2_TABLE_100();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_VARCHAR2_TABLE_100();

Line 250: a6 := JTF_VARCHAR2_TABLE_100();

246: a2 := JTF_NUMBER_TABLE();
247: a3 := JTF_NUMBER_TABLE();
248: a4 := JTF_VARCHAR2_TABLE_100();
249: a5 := JTF_VARCHAR2_TABLE_100();
250: a6 := JTF_VARCHAR2_TABLE_100();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_VARCHAR2_TABLE_100();
254: a10 := JTF_VARCHAR2_TABLE_100();

Line 252: a8 := JTF_VARCHAR2_TABLE_100();

248: a4 := JTF_VARCHAR2_TABLE_100();
249: a5 := JTF_VARCHAR2_TABLE_100();
250: a6 := JTF_VARCHAR2_TABLE_100();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_VARCHAR2_TABLE_100();
254: a10 := JTF_VARCHAR2_TABLE_100();
255: a11 := JTF_VARCHAR2_TABLE_100();
256: a12 := JTF_NUMBER_TABLE();

Line 253: a9 := JTF_VARCHAR2_TABLE_100();

249: a5 := JTF_VARCHAR2_TABLE_100();
250: a6 := JTF_VARCHAR2_TABLE_100();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_VARCHAR2_TABLE_100();
254: a10 := JTF_VARCHAR2_TABLE_100();
255: a11 := JTF_VARCHAR2_TABLE_100();
256: a12 := JTF_NUMBER_TABLE();
257: a13 := JTF_VARCHAR2_TABLE_100();

Line 254: a10 := JTF_VARCHAR2_TABLE_100();

250: a6 := JTF_VARCHAR2_TABLE_100();
251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_VARCHAR2_TABLE_100();
254: a10 := JTF_VARCHAR2_TABLE_100();
255: a11 := JTF_VARCHAR2_TABLE_100();
256: a12 := JTF_NUMBER_TABLE();
257: a13 := JTF_VARCHAR2_TABLE_100();
258: a14 := JTF_NUMBER_TABLE();

Line 255: a11 := JTF_VARCHAR2_TABLE_100();

251: a7 := JTF_NUMBER_TABLE();
252: a8 := JTF_VARCHAR2_TABLE_100();
253: a9 := JTF_VARCHAR2_TABLE_100();
254: a10 := JTF_VARCHAR2_TABLE_100();
255: a11 := JTF_VARCHAR2_TABLE_100();
256: a12 := JTF_NUMBER_TABLE();
257: a13 := JTF_VARCHAR2_TABLE_100();
258: a14 := JTF_NUMBER_TABLE();
259: a15 := JTF_NUMBER_TABLE();

Line 257: a13 := JTF_VARCHAR2_TABLE_100();

253: a9 := JTF_VARCHAR2_TABLE_100();
254: a10 := JTF_VARCHAR2_TABLE_100();
255: a11 := JTF_VARCHAR2_TABLE_100();
256: a12 := JTF_NUMBER_TABLE();
257: a13 := JTF_VARCHAR2_TABLE_100();
258: a14 := JTF_NUMBER_TABLE();
259: a15 := JTF_NUMBER_TABLE();
260: a16 := JTF_NUMBER_TABLE();
261: a17 := JTF_NUMBER_TABLE();

Line 262: a18 := JTF_VARCHAR2_TABLE_100();

258: a14 := JTF_NUMBER_TABLE();
259: a15 := JTF_NUMBER_TABLE();
260: a16 := JTF_NUMBER_TABLE();
261: a17 := JTF_NUMBER_TABLE();
262: a18 := JTF_VARCHAR2_TABLE_100();
263: a19 := JTF_DATE_TABLE();
264: a20 := JTF_DATE_TABLE();
265: a21 := JTF_VARCHAR2_TABLE_100();
266: a22 := JTF_DATE_TABLE();

Line 265: a21 := JTF_VARCHAR2_TABLE_100();

261: a17 := JTF_NUMBER_TABLE();
262: a18 := JTF_VARCHAR2_TABLE_100();
263: a19 := JTF_DATE_TABLE();
264: a20 := JTF_DATE_TABLE();
265: a21 := JTF_VARCHAR2_TABLE_100();
266: a22 := JTF_DATE_TABLE();
267: a23 := JTF_NUMBER_TABLE();
268: a24 := JTF_DATE_TABLE();
269: a25 := JTF_NUMBER_TABLE();

Line 273: a29 := JTF_VARCHAR2_TABLE_100();

269: a25 := JTF_NUMBER_TABLE();
270: a26 := JTF_NUMBER_TABLE();
271: a27 := JTF_NUMBER_TABLE();
272: a28 := JTF_NUMBER_TABLE();
273: a29 := JTF_VARCHAR2_TABLE_100();
274: a30 := JTF_NUMBER_TABLE();
275: a31 := JTF_NUMBER_TABLE();
276: a32 := JTF_VARCHAR2_TABLE_300();
277: a33 := JTF_VARCHAR2_TABLE_2000();

Line 278: a34 := JTF_VARCHAR2_TABLE_100();

274: a30 := JTF_NUMBER_TABLE();
275: a31 := JTF_NUMBER_TABLE();
276: a32 := JTF_VARCHAR2_TABLE_300();
277: a33 := JTF_VARCHAR2_TABLE_2000();
278: a34 := JTF_VARCHAR2_TABLE_100();
279: a35 := JTF_VARCHAR2_TABLE_300();
280: a36 := JTF_VARCHAR2_TABLE_300();
281: a37 := JTF_VARCHAR2_TABLE_300();
282: a38 := JTF_VARCHAR2_TABLE_300();

Line 409: , a1 JTF_VARCHAR2_TABLE_100

405: end if;
406: end rosetta_table_copy_out_p2;
407:
408: procedure rosetta_table_copy_in_p6(t out nocopy ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
409: , a1 JTF_VARCHAR2_TABLE_100
410: , a2 JTF_NUMBER_TABLE
411: , a3 JTF_VARCHAR2_TABLE_100
412: , a4 JTF_VARCHAR2_TABLE_100
413: , a5 JTF_DATE_TABLE

Line 411: , a3 JTF_VARCHAR2_TABLE_100

407:
408: procedure rosetta_table_copy_in_p6(t out nocopy ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
409: , a1 JTF_VARCHAR2_TABLE_100
410: , a2 JTF_NUMBER_TABLE
411: , a3 JTF_VARCHAR2_TABLE_100
412: , a4 JTF_VARCHAR2_TABLE_100
413: , a5 JTF_DATE_TABLE
414: , a6 JTF_DATE_TABLE
415: , a7 JTF_NUMBER_TABLE

Line 412: , a4 JTF_VARCHAR2_TABLE_100

408: procedure rosetta_table_copy_in_p6(t out nocopy ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
409: , a1 JTF_VARCHAR2_TABLE_100
410: , a2 JTF_NUMBER_TABLE
411: , a3 JTF_VARCHAR2_TABLE_100
412: , a4 JTF_VARCHAR2_TABLE_100
413: , a5 JTF_DATE_TABLE
414: , a6 JTF_DATE_TABLE
415: , a7 JTF_NUMBER_TABLE
416: , a8 JTF_NUMBER_TABLE

Line 424: , a16 JTF_VARCHAR2_TABLE_100

420: , a12 JTF_NUMBER_TABLE
421: , a13 JTF_NUMBER_TABLE
422: , a14 JTF_NUMBER_TABLE
423: , a15 JTF_NUMBER_TABLE
424: , a16 JTF_VARCHAR2_TABLE_100
425: , a17 JTF_VARCHAR2_TABLE_100
426: , a18 JTF_VARCHAR2_TABLE_300
427: , a19 JTF_VARCHAR2_TABLE_100
428: , a20 JTF_VARCHAR2_TABLE_100

Line 425: , a17 JTF_VARCHAR2_TABLE_100

421: , a13 JTF_NUMBER_TABLE
422: , a14 JTF_NUMBER_TABLE
423: , a15 JTF_NUMBER_TABLE
424: , a16 JTF_VARCHAR2_TABLE_100
425: , a17 JTF_VARCHAR2_TABLE_100
426: , a18 JTF_VARCHAR2_TABLE_300
427: , a19 JTF_VARCHAR2_TABLE_100
428: , a20 JTF_VARCHAR2_TABLE_100
429: ) as

Line 427: , a19 JTF_VARCHAR2_TABLE_100

423: , a15 JTF_NUMBER_TABLE
424: , a16 JTF_VARCHAR2_TABLE_100
425: , a17 JTF_VARCHAR2_TABLE_100
426: , a18 JTF_VARCHAR2_TABLE_300
427: , a19 JTF_VARCHAR2_TABLE_100
428: , a20 JTF_VARCHAR2_TABLE_100
429: ) as
430: ddindx binary_integer; indx binary_integer;
431: begin

Line 428: , a20 JTF_VARCHAR2_TABLE_100

424: , a16 JTF_VARCHAR2_TABLE_100
425: , a17 JTF_VARCHAR2_TABLE_100
426: , a18 JTF_VARCHAR2_TABLE_300
427: , a19 JTF_VARCHAR2_TABLE_100
428: , a20 JTF_VARCHAR2_TABLE_100
429: ) as
430: ddindx binary_integer; indx binary_integer;
431: begin
432: if a0 is not null and a0.count > 0 then

Line 468: , a1 out nocopy JTF_VARCHAR2_TABLE_100

464: end if;
465: end if;
466: end rosetta_table_copy_in_p6;
467: procedure rosetta_table_copy_out_p6(t ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
468: , a1 out nocopy JTF_VARCHAR2_TABLE_100
469: , a2 out nocopy JTF_NUMBER_TABLE
470: , a3 out nocopy JTF_VARCHAR2_TABLE_100
471: , a4 out nocopy JTF_VARCHAR2_TABLE_100
472: , a5 out nocopy JTF_DATE_TABLE

Line 470: , a3 out nocopy JTF_VARCHAR2_TABLE_100

466: end rosetta_table_copy_in_p6;
467: procedure rosetta_table_copy_out_p6(t ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
468: , a1 out nocopy JTF_VARCHAR2_TABLE_100
469: , a2 out nocopy JTF_NUMBER_TABLE
470: , a3 out nocopy JTF_VARCHAR2_TABLE_100
471: , a4 out nocopy JTF_VARCHAR2_TABLE_100
472: , a5 out nocopy JTF_DATE_TABLE
473: , a6 out nocopy JTF_DATE_TABLE
474: , a7 out nocopy JTF_NUMBER_TABLE

Line 471: , a4 out nocopy JTF_VARCHAR2_TABLE_100

467: procedure rosetta_table_copy_out_p6(t ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
468: , a1 out nocopy JTF_VARCHAR2_TABLE_100
469: , a2 out nocopy JTF_NUMBER_TABLE
470: , a3 out nocopy JTF_VARCHAR2_TABLE_100
471: , a4 out nocopy JTF_VARCHAR2_TABLE_100
472: , a5 out nocopy JTF_DATE_TABLE
473: , a6 out nocopy JTF_DATE_TABLE
474: , a7 out nocopy JTF_NUMBER_TABLE
475: , a8 out nocopy JTF_NUMBER_TABLE

Line 483: , a16 out nocopy JTF_VARCHAR2_TABLE_100

479: , a12 out nocopy JTF_NUMBER_TABLE
480: , a13 out nocopy JTF_NUMBER_TABLE
481: , a14 out nocopy JTF_NUMBER_TABLE
482: , a15 out nocopy JTF_NUMBER_TABLE
483: , a16 out nocopy JTF_VARCHAR2_TABLE_100
484: , a17 out nocopy JTF_VARCHAR2_TABLE_100
485: , a18 out nocopy JTF_VARCHAR2_TABLE_300
486: , a19 out nocopy JTF_VARCHAR2_TABLE_100
487: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 484: , a17 out nocopy JTF_VARCHAR2_TABLE_100

480: , a13 out nocopy JTF_NUMBER_TABLE
481: , a14 out nocopy JTF_NUMBER_TABLE
482: , a15 out nocopy JTF_NUMBER_TABLE
483: , a16 out nocopy JTF_VARCHAR2_TABLE_100
484: , a17 out nocopy JTF_VARCHAR2_TABLE_100
485: , a18 out nocopy JTF_VARCHAR2_TABLE_300
486: , a19 out nocopy JTF_VARCHAR2_TABLE_100
487: , a20 out nocopy JTF_VARCHAR2_TABLE_100
488: ) as

Line 486: , a19 out nocopy JTF_VARCHAR2_TABLE_100

482: , a15 out nocopy JTF_NUMBER_TABLE
483: , a16 out nocopy JTF_VARCHAR2_TABLE_100
484: , a17 out nocopy JTF_VARCHAR2_TABLE_100
485: , a18 out nocopy JTF_VARCHAR2_TABLE_300
486: , a19 out nocopy JTF_VARCHAR2_TABLE_100
487: , a20 out nocopy JTF_VARCHAR2_TABLE_100
488: ) as
489: ddindx binary_integer; indx binary_integer;
490: begin

Line 487: , a20 out nocopy JTF_VARCHAR2_TABLE_100

483: , a16 out nocopy JTF_VARCHAR2_TABLE_100
484: , a17 out nocopy JTF_VARCHAR2_TABLE_100
485: , a18 out nocopy JTF_VARCHAR2_TABLE_300
486: , a19 out nocopy JTF_VARCHAR2_TABLE_100
487: , a20 out nocopy JTF_VARCHAR2_TABLE_100
488: ) as
489: ddindx binary_integer; indx binary_integer;
490: begin
491: if t is null or t.count = 0 then

Line 493: a1 := JTF_VARCHAR2_TABLE_100();

489: ddindx binary_integer; indx binary_integer;
490: begin
491: if t is null or t.count = 0 then
492: a0 := JTF_NUMBER_TABLE();
493: a1 := JTF_VARCHAR2_TABLE_100();
494: a2 := JTF_NUMBER_TABLE();
495: a3 := JTF_VARCHAR2_TABLE_100();
496: a4 := JTF_VARCHAR2_TABLE_100();
497: a5 := JTF_DATE_TABLE();

Line 495: a3 := JTF_VARCHAR2_TABLE_100();

491: if t is null or t.count = 0 then
492: a0 := JTF_NUMBER_TABLE();
493: a1 := JTF_VARCHAR2_TABLE_100();
494: a2 := JTF_NUMBER_TABLE();
495: a3 := JTF_VARCHAR2_TABLE_100();
496: a4 := JTF_VARCHAR2_TABLE_100();
497: a5 := JTF_DATE_TABLE();
498: a6 := JTF_DATE_TABLE();
499: a7 := JTF_NUMBER_TABLE();

Line 496: a4 := JTF_VARCHAR2_TABLE_100();

492: a0 := JTF_NUMBER_TABLE();
493: a1 := JTF_VARCHAR2_TABLE_100();
494: a2 := JTF_NUMBER_TABLE();
495: a3 := JTF_VARCHAR2_TABLE_100();
496: a4 := JTF_VARCHAR2_TABLE_100();
497: a5 := JTF_DATE_TABLE();
498: a6 := JTF_DATE_TABLE();
499: a7 := JTF_NUMBER_TABLE();
500: a8 := JTF_NUMBER_TABLE();

Line 508: a16 := JTF_VARCHAR2_TABLE_100();

504: a12 := JTF_NUMBER_TABLE();
505: a13 := JTF_NUMBER_TABLE();
506: a14 := JTF_NUMBER_TABLE();
507: a15 := JTF_NUMBER_TABLE();
508: a16 := JTF_VARCHAR2_TABLE_100();
509: a17 := JTF_VARCHAR2_TABLE_100();
510: a18 := JTF_VARCHAR2_TABLE_300();
511: a19 := JTF_VARCHAR2_TABLE_100();
512: a20 := JTF_VARCHAR2_TABLE_100();

Line 509: a17 := JTF_VARCHAR2_TABLE_100();

505: a13 := JTF_NUMBER_TABLE();
506: a14 := JTF_NUMBER_TABLE();
507: a15 := JTF_NUMBER_TABLE();
508: a16 := JTF_VARCHAR2_TABLE_100();
509: a17 := JTF_VARCHAR2_TABLE_100();
510: a18 := JTF_VARCHAR2_TABLE_300();
511: a19 := JTF_VARCHAR2_TABLE_100();
512: a20 := JTF_VARCHAR2_TABLE_100();
513: else

Line 511: a19 := JTF_VARCHAR2_TABLE_100();

507: a15 := JTF_NUMBER_TABLE();
508: a16 := JTF_VARCHAR2_TABLE_100();
509: a17 := JTF_VARCHAR2_TABLE_100();
510: a18 := JTF_VARCHAR2_TABLE_300();
511: a19 := JTF_VARCHAR2_TABLE_100();
512: a20 := JTF_VARCHAR2_TABLE_100();
513: else
514: a0 := JTF_NUMBER_TABLE();
515: a1 := JTF_VARCHAR2_TABLE_100();

Line 512: a20 := JTF_VARCHAR2_TABLE_100();

508: a16 := JTF_VARCHAR2_TABLE_100();
509: a17 := JTF_VARCHAR2_TABLE_100();
510: a18 := JTF_VARCHAR2_TABLE_300();
511: a19 := JTF_VARCHAR2_TABLE_100();
512: a20 := JTF_VARCHAR2_TABLE_100();
513: else
514: a0 := JTF_NUMBER_TABLE();
515: a1 := JTF_VARCHAR2_TABLE_100();
516: a2 := JTF_NUMBER_TABLE();

Line 515: a1 := JTF_VARCHAR2_TABLE_100();

511: a19 := JTF_VARCHAR2_TABLE_100();
512: a20 := JTF_VARCHAR2_TABLE_100();
513: else
514: a0 := JTF_NUMBER_TABLE();
515: a1 := JTF_VARCHAR2_TABLE_100();
516: a2 := JTF_NUMBER_TABLE();
517: a3 := JTF_VARCHAR2_TABLE_100();
518: a4 := JTF_VARCHAR2_TABLE_100();
519: a5 := JTF_DATE_TABLE();

Line 517: a3 := JTF_VARCHAR2_TABLE_100();

513: else
514: a0 := JTF_NUMBER_TABLE();
515: a1 := JTF_VARCHAR2_TABLE_100();
516: a2 := JTF_NUMBER_TABLE();
517: a3 := JTF_VARCHAR2_TABLE_100();
518: a4 := JTF_VARCHAR2_TABLE_100();
519: a5 := JTF_DATE_TABLE();
520: a6 := JTF_DATE_TABLE();
521: a7 := JTF_NUMBER_TABLE();

Line 518: a4 := JTF_VARCHAR2_TABLE_100();

514: a0 := JTF_NUMBER_TABLE();
515: a1 := JTF_VARCHAR2_TABLE_100();
516: a2 := JTF_NUMBER_TABLE();
517: a3 := JTF_VARCHAR2_TABLE_100();
518: a4 := JTF_VARCHAR2_TABLE_100();
519: a5 := JTF_DATE_TABLE();
520: a6 := JTF_DATE_TABLE();
521: a7 := JTF_NUMBER_TABLE();
522: a8 := JTF_NUMBER_TABLE();

Line 530: a16 := JTF_VARCHAR2_TABLE_100();

526: a12 := JTF_NUMBER_TABLE();
527: a13 := JTF_NUMBER_TABLE();
528: a14 := JTF_NUMBER_TABLE();
529: a15 := JTF_NUMBER_TABLE();
530: a16 := JTF_VARCHAR2_TABLE_100();
531: a17 := JTF_VARCHAR2_TABLE_100();
532: a18 := JTF_VARCHAR2_TABLE_300();
533: a19 := JTF_VARCHAR2_TABLE_100();
534: a20 := JTF_VARCHAR2_TABLE_100();

Line 531: a17 := JTF_VARCHAR2_TABLE_100();

527: a13 := JTF_NUMBER_TABLE();
528: a14 := JTF_NUMBER_TABLE();
529: a15 := JTF_NUMBER_TABLE();
530: a16 := JTF_VARCHAR2_TABLE_100();
531: a17 := JTF_VARCHAR2_TABLE_100();
532: a18 := JTF_VARCHAR2_TABLE_300();
533: a19 := JTF_VARCHAR2_TABLE_100();
534: a20 := JTF_VARCHAR2_TABLE_100();
535: if t.count > 0 then

Line 533: a19 := JTF_VARCHAR2_TABLE_100();

529: a15 := JTF_NUMBER_TABLE();
530: a16 := JTF_VARCHAR2_TABLE_100();
531: a17 := JTF_VARCHAR2_TABLE_100();
532: a18 := JTF_VARCHAR2_TABLE_300();
533: a19 := JTF_VARCHAR2_TABLE_100();
534: a20 := JTF_VARCHAR2_TABLE_100();
535: if t.count > 0 then
536: a0.extend(t.count);
537: a1.extend(t.count);

Line 534: a20 := JTF_VARCHAR2_TABLE_100();

530: a16 := JTF_VARCHAR2_TABLE_100();
531: a17 := JTF_VARCHAR2_TABLE_100();
532: a18 := JTF_VARCHAR2_TABLE_300();
533: a19 := JTF_VARCHAR2_TABLE_100();
534: a20 := JTF_VARCHAR2_TABLE_100();
535: if t.count > 0 then
536: a0.extend(t.count);
537: a1.extend(t.count);
538: a2.extend(t.count);