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_PRICELIST_PVT_W dependencies on JTF_NUMBER_TABLE

Line 23: , a1 JTF_NUMBER_TABLE

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ozf_pricelist_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_NUMBER_TABLE

Line 26: , a4 JTF_NUMBER_TABLE

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

Line 27: , a5 JTF_NUMBER_TABLE

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

Line 33: , a11 JTF_NUMBER_TABLE

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

Line 34: , a12 JTF_NUMBER_TABLE

30: , a8 JTF_VARCHAR2_TABLE_300
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_100
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_NUMBER_TABLE
36: , a14 JTF_DATE_TABLE
37: , a15 JTF_VARCHAR2_TABLE_100
38: , a16 JTF_VARCHAR2_TABLE_100

Line 35: , a13 JTF_NUMBER_TABLE

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

Line 104: , a1 out nocopy JTF_NUMBER_TABLE

100: end if;
101: end if;
102: end rosetta_table_copy_in_p3;
103: procedure rosetta_table_copy_out_p3(t ozf_pricelist_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE

Line 107: , a4 out nocopy JTF_NUMBER_TABLE

103: procedure rosetta_table_copy_out_p3(t ozf_pricelist_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_VARCHAR2_TABLE_300
111: , a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 108: , a5 out nocopy JTF_NUMBER_TABLE

104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE
108: , a5 out nocopy JTF_NUMBER_TABLE
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: , a7 out nocopy JTF_VARCHAR2_TABLE_300
111: , a8 out nocopy JTF_VARCHAR2_TABLE_300
112: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 114: , a11 out nocopy JTF_NUMBER_TABLE

110: , a7 out nocopy JTF_VARCHAR2_TABLE_300
111: , a8 out nocopy JTF_VARCHAR2_TABLE_300
112: , a9 out nocopy JTF_VARCHAR2_TABLE_100
113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_NUMBER_TABLE
116: , a13 out nocopy JTF_NUMBER_TABLE
117: , a14 out nocopy JTF_DATE_TABLE
118: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 115: , a12 out nocopy JTF_NUMBER_TABLE

111: , a8 out nocopy JTF_VARCHAR2_TABLE_300
112: , a9 out nocopy JTF_VARCHAR2_TABLE_100
113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_NUMBER_TABLE
116: , a13 out nocopy JTF_NUMBER_TABLE
117: , a14 out nocopy JTF_DATE_TABLE
118: , a15 out nocopy JTF_VARCHAR2_TABLE_100
119: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 116: , a13 out nocopy JTF_NUMBER_TABLE

112: , a9 out nocopy JTF_VARCHAR2_TABLE_100
113: , a10 out nocopy JTF_VARCHAR2_TABLE_100
114: , a11 out nocopy JTF_NUMBER_TABLE
115: , a12 out nocopy JTF_NUMBER_TABLE
116: , a13 out nocopy JTF_NUMBER_TABLE
117: , a14 out nocopy JTF_DATE_TABLE
118: , a15 out nocopy JTF_VARCHAR2_TABLE_100
119: , a16 out nocopy JTF_VARCHAR2_TABLE_100
120: , a17 out nocopy JTF_VARCHAR2_TABLE_300

Line 140: a1 := JTF_NUMBER_TABLE();

136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_VARCHAR2_TABLE_100();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_DATE_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();

Line 143: a4 := JTF_NUMBER_TABLE();

139: a0 := JTF_VARCHAR2_TABLE_100();
140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_DATE_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_VARCHAR2_TABLE_300();
147: a8 := JTF_VARCHAR2_TABLE_300();

Line 144: a5 := JTF_NUMBER_TABLE();

140: a1 := JTF_NUMBER_TABLE();
141: a2 := JTF_DATE_TABLE();
142: a3 := JTF_VARCHAR2_TABLE_100();
143: a4 := JTF_NUMBER_TABLE();
144: a5 := JTF_NUMBER_TABLE();
145: a6 := JTF_VARCHAR2_TABLE_100();
146: a7 := JTF_VARCHAR2_TABLE_300();
147: a8 := JTF_VARCHAR2_TABLE_300();
148: a9 := JTF_VARCHAR2_TABLE_100();

Line 150: a11 := JTF_NUMBER_TABLE();

146: a7 := JTF_VARCHAR2_TABLE_300();
147: a8 := JTF_VARCHAR2_TABLE_300();
148: a9 := JTF_VARCHAR2_TABLE_100();
149: a10 := JTF_VARCHAR2_TABLE_100();
150: a11 := JTF_NUMBER_TABLE();
151: a12 := JTF_NUMBER_TABLE();
152: a13 := JTF_NUMBER_TABLE();
153: a14 := JTF_DATE_TABLE();
154: a15 := JTF_VARCHAR2_TABLE_100();

Line 151: a12 := JTF_NUMBER_TABLE();

147: a8 := JTF_VARCHAR2_TABLE_300();
148: a9 := JTF_VARCHAR2_TABLE_100();
149: a10 := JTF_VARCHAR2_TABLE_100();
150: a11 := JTF_NUMBER_TABLE();
151: a12 := JTF_NUMBER_TABLE();
152: a13 := JTF_NUMBER_TABLE();
153: a14 := JTF_DATE_TABLE();
154: a15 := JTF_VARCHAR2_TABLE_100();
155: a16 := JTF_VARCHAR2_TABLE_100();

Line 152: a13 := JTF_NUMBER_TABLE();

148: a9 := JTF_VARCHAR2_TABLE_100();
149: a10 := JTF_VARCHAR2_TABLE_100();
150: a11 := JTF_NUMBER_TABLE();
151: a12 := JTF_NUMBER_TABLE();
152: a13 := JTF_NUMBER_TABLE();
153: a14 := JTF_DATE_TABLE();
154: a15 := JTF_VARCHAR2_TABLE_100();
155: a16 := JTF_VARCHAR2_TABLE_100();
156: a17 := JTF_VARCHAR2_TABLE_300();

Line 173: a1 := JTF_NUMBER_TABLE();

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

Line 176: a4 := JTF_NUMBER_TABLE();

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

Line 177: a5 := JTF_NUMBER_TABLE();

173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_DATE_TABLE();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_NUMBER_TABLE();
177: a5 := JTF_NUMBER_TABLE();
178: a6 := JTF_VARCHAR2_TABLE_100();
179: a7 := JTF_VARCHAR2_TABLE_300();
180: a8 := JTF_VARCHAR2_TABLE_300();
181: a9 := JTF_VARCHAR2_TABLE_100();

Line 183: a11 := JTF_NUMBER_TABLE();

179: a7 := JTF_VARCHAR2_TABLE_300();
180: a8 := JTF_VARCHAR2_TABLE_300();
181: a9 := JTF_VARCHAR2_TABLE_100();
182: a10 := JTF_VARCHAR2_TABLE_100();
183: a11 := JTF_NUMBER_TABLE();
184: a12 := JTF_NUMBER_TABLE();
185: a13 := JTF_NUMBER_TABLE();
186: a14 := JTF_DATE_TABLE();
187: a15 := JTF_VARCHAR2_TABLE_100();

Line 184: a12 := JTF_NUMBER_TABLE();

180: a8 := JTF_VARCHAR2_TABLE_300();
181: a9 := JTF_VARCHAR2_TABLE_100();
182: a10 := JTF_VARCHAR2_TABLE_100();
183: a11 := JTF_NUMBER_TABLE();
184: a12 := JTF_NUMBER_TABLE();
185: a13 := JTF_NUMBER_TABLE();
186: a14 := JTF_DATE_TABLE();
187: a15 := JTF_VARCHAR2_TABLE_100();
188: a16 := JTF_VARCHAR2_TABLE_100();

Line 185: a13 := JTF_NUMBER_TABLE();

181: a9 := JTF_VARCHAR2_TABLE_100();
182: a10 := JTF_VARCHAR2_TABLE_100();
183: a11 := JTF_NUMBER_TABLE();
184: a12 := JTF_NUMBER_TABLE();
185: a13 := JTF_NUMBER_TABLE();
186: a14 := JTF_DATE_TABLE();
187: a15 := JTF_VARCHAR2_TABLE_100();
188: a16 := JTF_VARCHAR2_TABLE_100();
189: a17 := JTF_VARCHAR2_TABLE_300();

Line 284: , a2 JTF_NUMBER_TABLE

280: end rosetta_table_copy_out_p3;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy ozf_pricelist_pvt.price_list_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
283: , a1 JTF_DATE_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_NUMBER_TABLE
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE

Line 285: , a3 JTF_NUMBER_TABLE

281:
282: procedure rosetta_table_copy_in_p5(t out nocopy ozf_pricelist_pvt.price_list_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
283: , a1 JTF_DATE_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_NUMBER_TABLE
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_VARCHAR2_TABLE_100

Line 286: , a4 JTF_NUMBER_TABLE

282: procedure rosetta_table_copy_in_p5(t out nocopy ozf_pricelist_pvt.price_list_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
283: , a1 JTF_DATE_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_NUMBER_TABLE
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_VARCHAR2_TABLE_100
290: , a8 JTF_VARCHAR2_TABLE_100

Line 287: , a5 JTF_NUMBER_TABLE

283: , a1 JTF_DATE_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_NUMBER_TABLE
286: , a4 JTF_NUMBER_TABLE
287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_VARCHAR2_TABLE_100
290: , a8 JTF_VARCHAR2_TABLE_100
291: , a9 JTF_NUMBER_TABLE

Line 291: , a9 JTF_NUMBER_TABLE

287: , a5 JTF_NUMBER_TABLE
288: , a6 JTF_DATE_TABLE
289: , a7 JTF_VARCHAR2_TABLE_100
290: , a8 JTF_VARCHAR2_TABLE_100
291: , a9 JTF_NUMBER_TABLE
292: , a10 JTF_NUMBER_TABLE
293: , a11 JTF_NUMBER_TABLE
294: , a12 JTF_NUMBER_TABLE
295: , a13 JTF_VARCHAR2_TABLE_2000

Line 292: , a10 JTF_NUMBER_TABLE

288: , a6 JTF_DATE_TABLE
289: , a7 JTF_VARCHAR2_TABLE_100
290: , a8 JTF_VARCHAR2_TABLE_100
291: , a9 JTF_NUMBER_TABLE
292: , a10 JTF_NUMBER_TABLE
293: , a11 JTF_NUMBER_TABLE
294: , a12 JTF_NUMBER_TABLE
295: , a13 JTF_VARCHAR2_TABLE_2000
296: , a14 JTF_NUMBER_TABLE

Line 293: , a11 JTF_NUMBER_TABLE

289: , a7 JTF_VARCHAR2_TABLE_100
290: , a8 JTF_VARCHAR2_TABLE_100
291: , a9 JTF_NUMBER_TABLE
292: , a10 JTF_NUMBER_TABLE
293: , a11 JTF_NUMBER_TABLE
294: , a12 JTF_NUMBER_TABLE
295: , a13 JTF_VARCHAR2_TABLE_2000
296: , a14 JTF_NUMBER_TABLE
297: , a15 JTF_VARCHAR2_TABLE_100

Line 294: , a12 JTF_NUMBER_TABLE

290: , a8 JTF_VARCHAR2_TABLE_100
291: , a9 JTF_NUMBER_TABLE
292: , a10 JTF_NUMBER_TABLE
293: , a11 JTF_NUMBER_TABLE
294: , a12 JTF_NUMBER_TABLE
295: , a13 JTF_VARCHAR2_TABLE_2000
296: , a14 JTF_NUMBER_TABLE
297: , a15 JTF_VARCHAR2_TABLE_100
298: , a16 JTF_VARCHAR2_TABLE_300

Line 296: , a14 JTF_NUMBER_TABLE

292: , a10 JTF_NUMBER_TABLE
293: , a11 JTF_NUMBER_TABLE
294: , a12 JTF_NUMBER_TABLE
295: , a13 JTF_VARCHAR2_TABLE_2000
296: , a14 JTF_NUMBER_TABLE
297: , a15 JTF_VARCHAR2_TABLE_100
298: , a16 JTF_VARCHAR2_TABLE_300
299: , a17 JTF_VARCHAR2_TABLE_300
300: , a18 JTF_VARCHAR2_TABLE_300

Line 363: , a2 out nocopy JTF_NUMBER_TABLE

359: end if;
360: end rosetta_table_copy_in_p5;
361: procedure rosetta_table_copy_out_p5(t ozf_pricelist_pvt.price_list_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
362: , a1 out nocopy JTF_DATE_TABLE
363: , a2 out nocopy JTF_NUMBER_TABLE
364: , a3 out nocopy JTF_NUMBER_TABLE
365: , a4 out nocopy JTF_NUMBER_TABLE
366: , a5 out nocopy JTF_NUMBER_TABLE
367: , a6 out nocopy JTF_DATE_TABLE

Line 364: , a3 out nocopy JTF_NUMBER_TABLE

360: end rosetta_table_copy_in_p5;
361: procedure rosetta_table_copy_out_p5(t ozf_pricelist_pvt.price_list_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
362: , a1 out nocopy JTF_DATE_TABLE
363: , a2 out nocopy JTF_NUMBER_TABLE
364: , a3 out nocopy JTF_NUMBER_TABLE
365: , a4 out nocopy JTF_NUMBER_TABLE
366: , a5 out nocopy JTF_NUMBER_TABLE
367: , a6 out nocopy JTF_DATE_TABLE
368: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 365: , a4 out nocopy JTF_NUMBER_TABLE

361: procedure rosetta_table_copy_out_p5(t ozf_pricelist_pvt.price_list_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
362: , a1 out nocopy JTF_DATE_TABLE
363: , a2 out nocopy JTF_NUMBER_TABLE
364: , a3 out nocopy JTF_NUMBER_TABLE
365: , a4 out nocopy JTF_NUMBER_TABLE
366: , a5 out nocopy JTF_NUMBER_TABLE
367: , a6 out nocopy JTF_DATE_TABLE
368: , a7 out nocopy JTF_VARCHAR2_TABLE_100
369: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 366: , a5 out nocopy JTF_NUMBER_TABLE

362: , a1 out nocopy JTF_DATE_TABLE
363: , a2 out nocopy JTF_NUMBER_TABLE
364: , a3 out nocopy JTF_NUMBER_TABLE
365: , a4 out nocopy JTF_NUMBER_TABLE
366: , a5 out nocopy JTF_NUMBER_TABLE
367: , a6 out nocopy JTF_DATE_TABLE
368: , a7 out nocopy JTF_VARCHAR2_TABLE_100
369: , a8 out nocopy JTF_VARCHAR2_TABLE_100
370: , a9 out nocopy JTF_NUMBER_TABLE

Line 370: , a9 out nocopy JTF_NUMBER_TABLE

366: , a5 out nocopy JTF_NUMBER_TABLE
367: , a6 out nocopy JTF_DATE_TABLE
368: , a7 out nocopy JTF_VARCHAR2_TABLE_100
369: , a8 out nocopy JTF_VARCHAR2_TABLE_100
370: , a9 out nocopy JTF_NUMBER_TABLE
371: , a10 out nocopy JTF_NUMBER_TABLE
372: , a11 out nocopy JTF_NUMBER_TABLE
373: , a12 out nocopy JTF_NUMBER_TABLE
374: , a13 out nocopy JTF_VARCHAR2_TABLE_2000

Line 371: , a10 out nocopy JTF_NUMBER_TABLE

367: , a6 out nocopy JTF_DATE_TABLE
368: , a7 out nocopy JTF_VARCHAR2_TABLE_100
369: , a8 out nocopy JTF_VARCHAR2_TABLE_100
370: , a9 out nocopy JTF_NUMBER_TABLE
371: , a10 out nocopy JTF_NUMBER_TABLE
372: , a11 out nocopy JTF_NUMBER_TABLE
373: , a12 out nocopy JTF_NUMBER_TABLE
374: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
375: , a14 out nocopy JTF_NUMBER_TABLE

Line 372: , a11 out nocopy JTF_NUMBER_TABLE

368: , a7 out nocopy JTF_VARCHAR2_TABLE_100
369: , a8 out nocopy JTF_VARCHAR2_TABLE_100
370: , a9 out nocopy JTF_NUMBER_TABLE
371: , a10 out nocopy JTF_NUMBER_TABLE
372: , a11 out nocopy JTF_NUMBER_TABLE
373: , a12 out nocopy JTF_NUMBER_TABLE
374: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
375: , a14 out nocopy JTF_NUMBER_TABLE
376: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 373: , a12 out nocopy JTF_NUMBER_TABLE

369: , a8 out nocopy JTF_VARCHAR2_TABLE_100
370: , a9 out nocopy JTF_NUMBER_TABLE
371: , a10 out nocopy JTF_NUMBER_TABLE
372: , a11 out nocopy JTF_NUMBER_TABLE
373: , a12 out nocopy JTF_NUMBER_TABLE
374: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
375: , a14 out nocopy JTF_NUMBER_TABLE
376: , a15 out nocopy JTF_VARCHAR2_TABLE_100
377: , a16 out nocopy JTF_VARCHAR2_TABLE_300

Line 375: , a14 out nocopy JTF_NUMBER_TABLE

371: , a10 out nocopy JTF_NUMBER_TABLE
372: , a11 out nocopy JTF_NUMBER_TABLE
373: , a12 out nocopy JTF_NUMBER_TABLE
374: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
375: , a14 out nocopy JTF_NUMBER_TABLE
376: , a15 out nocopy JTF_VARCHAR2_TABLE_100
377: , a16 out nocopy JTF_VARCHAR2_TABLE_300
378: , a17 out nocopy JTF_VARCHAR2_TABLE_300
379: , a18 out nocopy JTF_VARCHAR2_TABLE_300

Line 398: a2 := JTF_NUMBER_TABLE();

394: begin
395: if t is null or t.count = 0 then
396: a0 := JTF_VARCHAR2_TABLE_100();
397: a1 := JTF_DATE_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_DATE_TABLE();

Line 399: a3 := JTF_NUMBER_TABLE();

395: if t is null or t.count = 0 then
396: a0 := JTF_VARCHAR2_TABLE_100();
397: a1 := JTF_DATE_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_DATE_TABLE();
403: a7 := JTF_VARCHAR2_TABLE_100();

Line 400: a4 := JTF_NUMBER_TABLE();

396: a0 := JTF_VARCHAR2_TABLE_100();
397: a1 := JTF_DATE_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_DATE_TABLE();
403: a7 := JTF_VARCHAR2_TABLE_100();
404: a8 := JTF_VARCHAR2_TABLE_100();

Line 401: a5 := JTF_NUMBER_TABLE();

397: a1 := JTF_DATE_TABLE();
398: a2 := JTF_NUMBER_TABLE();
399: a3 := JTF_NUMBER_TABLE();
400: a4 := JTF_NUMBER_TABLE();
401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_DATE_TABLE();
403: a7 := JTF_VARCHAR2_TABLE_100();
404: a8 := JTF_VARCHAR2_TABLE_100();
405: a9 := JTF_NUMBER_TABLE();

Line 405: a9 := JTF_NUMBER_TABLE();

401: a5 := JTF_NUMBER_TABLE();
402: a6 := JTF_DATE_TABLE();
403: a7 := JTF_VARCHAR2_TABLE_100();
404: a8 := JTF_VARCHAR2_TABLE_100();
405: a9 := JTF_NUMBER_TABLE();
406: a10 := JTF_NUMBER_TABLE();
407: a11 := JTF_NUMBER_TABLE();
408: a12 := JTF_NUMBER_TABLE();
409: a13 := JTF_VARCHAR2_TABLE_2000();

Line 406: a10 := JTF_NUMBER_TABLE();

402: a6 := JTF_DATE_TABLE();
403: a7 := JTF_VARCHAR2_TABLE_100();
404: a8 := JTF_VARCHAR2_TABLE_100();
405: a9 := JTF_NUMBER_TABLE();
406: a10 := JTF_NUMBER_TABLE();
407: a11 := JTF_NUMBER_TABLE();
408: a12 := JTF_NUMBER_TABLE();
409: a13 := JTF_VARCHAR2_TABLE_2000();
410: a14 := JTF_NUMBER_TABLE();

Line 407: a11 := JTF_NUMBER_TABLE();

403: a7 := JTF_VARCHAR2_TABLE_100();
404: a8 := JTF_VARCHAR2_TABLE_100();
405: a9 := JTF_NUMBER_TABLE();
406: a10 := JTF_NUMBER_TABLE();
407: a11 := JTF_NUMBER_TABLE();
408: a12 := JTF_NUMBER_TABLE();
409: a13 := JTF_VARCHAR2_TABLE_2000();
410: a14 := JTF_NUMBER_TABLE();
411: a15 := JTF_VARCHAR2_TABLE_100();

Line 408: a12 := JTF_NUMBER_TABLE();

404: a8 := JTF_VARCHAR2_TABLE_100();
405: a9 := JTF_NUMBER_TABLE();
406: a10 := JTF_NUMBER_TABLE();
407: a11 := JTF_NUMBER_TABLE();
408: a12 := JTF_NUMBER_TABLE();
409: a13 := JTF_VARCHAR2_TABLE_2000();
410: a14 := JTF_NUMBER_TABLE();
411: a15 := JTF_VARCHAR2_TABLE_100();
412: a16 := JTF_VARCHAR2_TABLE_300();

Line 410: a14 := JTF_NUMBER_TABLE();

406: a10 := JTF_NUMBER_TABLE();
407: a11 := JTF_NUMBER_TABLE();
408: a12 := JTF_NUMBER_TABLE();
409: a13 := JTF_VARCHAR2_TABLE_2000();
410: a14 := JTF_NUMBER_TABLE();
411: a15 := JTF_VARCHAR2_TABLE_100();
412: a16 := JTF_VARCHAR2_TABLE_300();
413: a17 := JTF_VARCHAR2_TABLE_300();
414: a18 := JTF_VARCHAR2_TABLE_300();

Line 430: a2 := JTF_NUMBER_TABLE();

426: a30 := JTF_VARCHAR2_TABLE_300();
427: else
428: a0 := JTF_VARCHAR2_TABLE_100();
429: a1 := JTF_DATE_TABLE();
430: a2 := JTF_NUMBER_TABLE();
431: a3 := JTF_NUMBER_TABLE();
432: a4 := JTF_NUMBER_TABLE();
433: a5 := JTF_NUMBER_TABLE();
434: a6 := JTF_DATE_TABLE();

Line 431: a3 := JTF_NUMBER_TABLE();

427: else
428: a0 := JTF_VARCHAR2_TABLE_100();
429: a1 := JTF_DATE_TABLE();
430: a2 := JTF_NUMBER_TABLE();
431: a3 := JTF_NUMBER_TABLE();
432: a4 := JTF_NUMBER_TABLE();
433: a5 := JTF_NUMBER_TABLE();
434: a6 := JTF_DATE_TABLE();
435: a7 := JTF_VARCHAR2_TABLE_100();

Line 432: a4 := JTF_NUMBER_TABLE();

428: a0 := JTF_VARCHAR2_TABLE_100();
429: a1 := JTF_DATE_TABLE();
430: a2 := JTF_NUMBER_TABLE();
431: a3 := JTF_NUMBER_TABLE();
432: a4 := JTF_NUMBER_TABLE();
433: a5 := JTF_NUMBER_TABLE();
434: a6 := JTF_DATE_TABLE();
435: a7 := JTF_VARCHAR2_TABLE_100();
436: a8 := JTF_VARCHAR2_TABLE_100();

Line 433: a5 := JTF_NUMBER_TABLE();

429: a1 := JTF_DATE_TABLE();
430: a2 := JTF_NUMBER_TABLE();
431: a3 := JTF_NUMBER_TABLE();
432: a4 := JTF_NUMBER_TABLE();
433: a5 := JTF_NUMBER_TABLE();
434: a6 := JTF_DATE_TABLE();
435: a7 := JTF_VARCHAR2_TABLE_100();
436: a8 := JTF_VARCHAR2_TABLE_100();
437: a9 := JTF_NUMBER_TABLE();

Line 437: a9 := JTF_NUMBER_TABLE();

433: a5 := JTF_NUMBER_TABLE();
434: a6 := JTF_DATE_TABLE();
435: a7 := JTF_VARCHAR2_TABLE_100();
436: a8 := JTF_VARCHAR2_TABLE_100();
437: a9 := JTF_NUMBER_TABLE();
438: a10 := JTF_NUMBER_TABLE();
439: a11 := JTF_NUMBER_TABLE();
440: a12 := JTF_NUMBER_TABLE();
441: a13 := JTF_VARCHAR2_TABLE_2000();

Line 438: a10 := JTF_NUMBER_TABLE();

434: a6 := JTF_DATE_TABLE();
435: a7 := JTF_VARCHAR2_TABLE_100();
436: a8 := JTF_VARCHAR2_TABLE_100();
437: a9 := JTF_NUMBER_TABLE();
438: a10 := JTF_NUMBER_TABLE();
439: a11 := JTF_NUMBER_TABLE();
440: a12 := JTF_NUMBER_TABLE();
441: a13 := JTF_VARCHAR2_TABLE_2000();
442: a14 := JTF_NUMBER_TABLE();

Line 439: a11 := JTF_NUMBER_TABLE();

435: a7 := JTF_VARCHAR2_TABLE_100();
436: a8 := JTF_VARCHAR2_TABLE_100();
437: a9 := JTF_NUMBER_TABLE();
438: a10 := JTF_NUMBER_TABLE();
439: a11 := JTF_NUMBER_TABLE();
440: a12 := JTF_NUMBER_TABLE();
441: a13 := JTF_VARCHAR2_TABLE_2000();
442: a14 := JTF_NUMBER_TABLE();
443: a15 := JTF_VARCHAR2_TABLE_100();

Line 440: a12 := JTF_NUMBER_TABLE();

436: a8 := JTF_VARCHAR2_TABLE_100();
437: a9 := JTF_NUMBER_TABLE();
438: a10 := JTF_NUMBER_TABLE();
439: a11 := JTF_NUMBER_TABLE();
440: a12 := JTF_NUMBER_TABLE();
441: a13 := JTF_VARCHAR2_TABLE_2000();
442: a14 := JTF_NUMBER_TABLE();
443: a15 := JTF_VARCHAR2_TABLE_100();
444: a16 := JTF_VARCHAR2_TABLE_300();

Line 442: a14 := JTF_NUMBER_TABLE();

438: a10 := JTF_NUMBER_TABLE();
439: a11 := JTF_NUMBER_TABLE();
440: a12 := JTF_NUMBER_TABLE();
441: a13 := JTF_VARCHAR2_TABLE_2000();
442: a14 := JTF_NUMBER_TABLE();
443: a15 := JTF_VARCHAR2_TABLE_100();
444: a16 := JTF_VARCHAR2_TABLE_300();
445: a17 := JTF_VARCHAR2_TABLE_300();
446: a18 := JTF_VARCHAR2_TABLE_300();

Line 535: procedure rosetta_table_copy_in_p7(t out nocopy ozf_pricelist_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE

531: end if;
532: end if;
533: end rosetta_table_copy_out_p5;
534:
535: procedure rosetta_table_copy_in_p7(t out nocopy ozf_pricelist_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
536: , a1 JTF_VARCHAR2_TABLE_100
537: , a2 JTF_VARCHAR2_TABLE_100
538: , a3 JTF_NUMBER_TABLE
539: , a4 JTF_VARCHAR2_TABLE_300

Line 538: , a3 JTF_NUMBER_TABLE

534:
535: procedure rosetta_table_copy_in_p7(t out nocopy ozf_pricelist_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
536: , a1 JTF_VARCHAR2_TABLE_100
537: , a2 JTF_VARCHAR2_TABLE_100
538: , a3 JTF_NUMBER_TABLE
539: , a4 JTF_VARCHAR2_TABLE_300
540: , a5 JTF_VARCHAR2_TABLE_300
541: , a6 JTF_VARCHAR2_TABLE_100
542: , a7 JTF_VARCHAR2_TABLE_100

Line 546: , a11 JTF_NUMBER_TABLE

542: , a7 JTF_VARCHAR2_TABLE_100
543: , a8 JTF_VARCHAR2_TABLE_300
544: , a9 JTF_VARCHAR2_TABLE_100
545: , a10 JTF_VARCHAR2_TABLE_100
546: , a11 JTF_NUMBER_TABLE
547: , a12 JTF_VARCHAR2_TABLE_100
548: , a13 JTF_NUMBER_TABLE
549: ) as
550: ddindx binary_integer; indx binary_integer;

Line 548: , a13 JTF_NUMBER_TABLE

544: , a9 JTF_VARCHAR2_TABLE_100
545: , a10 JTF_VARCHAR2_TABLE_100
546: , a11 JTF_NUMBER_TABLE
547: , a12 JTF_VARCHAR2_TABLE_100
548: , a13 JTF_NUMBER_TABLE
549: ) as
550: ddindx binary_integer; indx binary_integer;
551: begin
552: if a0 is not null and a0.count > 0 then

Line 580: procedure rosetta_table_copy_out_p7(t ozf_pricelist_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

576: end loop;
577: end if;
578: end if;
579: end rosetta_table_copy_in_p7;
580: procedure rosetta_table_copy_out_p7(t ozf_pricelist_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
581: , a1 out nocopy JTF_VARCHAR2_TABLE_100
582: , a2 out nocopy JTF_VARCHAR2_TABLE_100
583: , a3 out nocopy JTF_NUMBER_TABLE
584: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 583: , a3 out nocopy JTF_NUMBER_TABLE

579: end rosetta_table_copy_in_p7;
580: procedure rosetta_table_copy_out_p7(t ozf_pricelist_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
581: , a1 out nocopy JTF_VARCHAR2_TABLE_100
582: , a2 out nocopy JTF_VARCHAR2_TABLE_100
583: , a3 out nocopy JTF_NUMBER_TABLE
584: , a4 out nocopy JTF_VARCHAR2_TABLE_300
585: , a5 out nocopy JTF_VARCHAR2_TABLE_300
586: , a6 out nocopy JTF_VARCHAR2_TABLE_100
587: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 591: , a11 out nocopy JTF_NUMBER_TABLE

587: , a7 out nocopy JTF_VARCHAR2_TABLE_100
588: , a8 out nocopy JTF_VARCHAR2_TABLE_300
589: , a9 out nocopy JTF_VARCHAR2_TABLE_100
590: , a10 out nocopy JTF_VARCHAR2_TABLE_100
591: , a11 out nocopy JTF_NUMBER_TABLE
592: , a12 out nocopy JTF_VARCHAR2_TABLE_100
593: , a13 out nocopy JTF_NUMBER_TABLE
594: ) as
595: ddindx binary_integer; indx binary_integer;

Line 593: , a13 out nocopy JTF_NUMBER_TABLE

589: , a9 out nocopy JTF_VARCHAR2_TABLE_100
590: , a10 out nocopy JTF_VARCHAR2_TABLE_100
591: , a11 out nocopy JTF_NUMBER_TABLE
592: , a12 out nocopy JTF_VARCHAR2_TABLE_100
593: , a13 out nocopy JTF_NUMBER_TABLE
594: ) as
595: ddindx binary_integer; indx binary_integer;
596: begin
597: if t is null or t.count = 0 then

Line 598: a0 := JTF_NUMBER_TABLE();

594: ) as
595: ddindx binary_integer; indx binary_integer;
596: begin
597: if t is null or t.count = 0 then
598: a0 := JTF_NUMBER_TABLE();
599: a1 := JTF_VARCHAR2_TABLE_100();
600: a2 := JTF_VARCHAR2_TABLE_100();
601: a3 := JTF_NUMBER_TABLE();
602: a4 := JTF_VARCHAR2_TABLE_300();

Line 601: a3 := JTF_NUMBER_TABLE();

597: if t is null or t.count = 0 then
598: a0 := JTF_NUMBER_TABLE();
599: a1 := JTF_VARCHAR2_TABLE_100();
600: a2 := JTF_VARCHAR2_TABLE_100();
601: a3 := JTF_NUMBER_TABLE();
602: a4 := JTF_VARCHAR2_TABLE_300();
603: a5 := JTF_VARCHAR2_TABLE_300();
604: a6 := JTF_VARCHAR2_TABLE_100();
605: a7 := JTF_VARCHAR2_TABLE_100();

Line 609: a11 := JTF_NUMBER_TABLE();

605: a7 := JTF_VARCHAR2_TABLE_100();
606: a8 := JTF_VARCHAR2_TABLE_300();
607: a9 := JTF_VARCHAR2_TABLE_100();
608: a10 := JTF_VARCHAR2_TABLE_100();
609: a11 := JTF_NUMBER_TABLE();
610: a12 := JTF_VARCHAR2_TABLE_100();
611: a13 := JTF_NUMBER_TABLE();
612: else
613: a0 := JTF_NUMBER_TABLE();

Line 611: a13 := JTF_NUMBER_TABLE();

607: a9 := JTF_VARCHAR2_TABLE_100();
608: a10 := JTF_VARCHAR2_TABLE_100();
609: a11 := JTF_NUMBER_TABLE();
610: a12 := JTF_VARCHAR2_TABLE_100();
611: a13 := JTF_NUMBER_TABLE();
612: else
613: a0 := JTF_NUMBER_TABLE();
614: a1 := JTF_VARCHAR2_TABLE_100();
615: a2 := JTF_VARCHAR2_TABLE_100();

Line 613: a0 := JTF_NUMBER_TABLE();

609: a11 := JTF_NUMBER_TABLE();
610: a12 := JTF_VARCHAR2_TABLE_100();
611: a13 := JTF_NUMBER_TABLE();
612: else
613: a0 := JTF_NUMBER_TABLE();
614: a1 := JTF_VARCHAR2_TABLE_100();
615: a2 := JTF_VARCHAR2_TABLE_100();
616: a3 := JTF_NUMBER_TABLE();
617: a4 := JTF_VARCHAR2_TABLE_300();

Line 616: a3 := JTF_NUMBER_TABLE();

612: else
613: a0 := JTF_NUMBER_TABLE();
614: a1 := JTF_VARCHAR2_TABLE_100();
615: a2 := JTF_VARCHAR2_TABLE_100();
616: a3 := JTF_NUMBER_TABLE();
617: a4 := JTF_VARCHAR2_TABLE_300();
618: a5 := JTF_VARCHAR2_TABLE_300();
619: a6 := JTF_VARCHAR2_TABLE_100();
620: a7 := JTF_VARCHAR2_TABLE_100();

Line 624: a11 := JTF_NUMBER_TABLE();

620: a7 := JTF_VARCHAR2_TABLE_100();
621: a8 := JTF_VARCHAR2_TABLE_300();
622: a9 := JTF_VARCHAR2_TABLE_100();
623: a10 := JTF_VARCHAR2_TABLE_100();
624: a11 := JTF_NUMBER_TABLE();
625: a12 := JTF_VARCHAR2_TABLE_100();
626: a13 := JTF_NUMBER_TABLE();
627: if t.count > 0 then
628: a0.extend(t.count);

Line 626: a13 := JTF_NUMBER_TABLE();

622: a9 := JTF_VARCHAR2_TABLE_100();
623: a10 := JTF_VARCHAR2_TABLE_100();
624: a11 := JTF_NUMBER_TABLE();
625: a12 := JTF_VARCHAR2_TABLE_100();
626: a13 := JTF_NUMBER_TABLE();
627: if t.count > 0 then
628: a0.extend(t.count);
629: a1.extend(t.count);
630: a2.extend(t.count);

Line 669: procedure rosetta_table_copy_in_p12(t out nocopy ozf_pricelist_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE) as

665: end if;
666: end if;
667: end rosetta_table_copy_out_p7;
668:
669: procedure rosetta_table_copy_in_p12(t out nocopy ozf_pricelist_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE) as
670: ddindx binary_integer; indx binary_integer;
671: begin
672: if a0 is not null and a0.count > 0 then
673: if a0.count > 0 then

Line 687: procedure rosetta_table_copy_out_p12(t ozf_pricelist_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

683: end loop;
684: end if;
685: end if;
686: end rosetta_table_copy_in_p12;
687: procedure rosetta_table_copy_out_p12(t ozf_pricelist_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
688: ddindx binary_integer; indx binary_integer;
689: begin
690: if t is null or t.count = 0 then
691: a0 := JTF_NUMBER_TABLE();

Line 691: a0 := JTF_NUMBER_TABLE();

687: procedure rosetta_table_copy_out_p12(t ozf_pricelist_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
688: ddindx binary_integer; indx binary_integer;
689: begin
690: if t is null or t.count = 0 then
691: a0 := JTF_NUMBER_TABLE();
692: else
693: a0 := JTF_NUMBER_TABLE();
694: if t.count > 0 then
695: a0.extend(t.count);

Line 693: a0 := JTF_NUMBER_TABLE();

689: begin
690: if t is null or t.count = 0 then
691: a0 := JTF_NUMBER_TABLE();
692: else
693: a0 := JTF_NUMBER_TABLE();
694: if t.count > 0 then
695: a0.extend(t.count);
696: ddindx := t.first;
697: indx := 1;

Line 719: , p8_a2 JTF_NUMBER_TABLE

715: , x_msg_count out nocopy NUMBER
716: , x_msg_data out nocopy VARCHAR2
717: , p8_a0 JTF_VARCHAR2_TABLE_100
718: , p8_a1 JTF_DATE_TABLE
719: , p8_a2 JTF_NUMBER_TABLE
720: , p8_a3 JTF_NUMBER_TABLE
721: , p8_a4 JTF_NUMBER_TABLE
722: , p8_a5 JTF_NUMBER_TABLE
723: , p8_a6 JTF_DATE_TABLE

Line 720: , p8_a3 JTF_NUMBER_TABLE

716: , x_msg_data out nocopy VARCHAR2
717: , p8_a0 JTF_VARCHAR2_TABLE_100
718: , p8_a1 JTF_DATE_TABLE
719: , p8_a2 JTF_NUMBER_TABLE
720: , p8_a3 JTF_NUMBER_TABLE
721: , p8_a4 JTF_NUMBER_TABLE
722: , p8_a5 JTF_NUMBER_TABLE
723: , p8_a6 JTF_DATE_TABLE
724: , p8_a7 JTF_VARCHAR2_TABLE_100

Line 721: , p8_a4 JTF_NUMBER_TABLE

717: , p8_a0 JTF_VARCHAR2_TABLE_100
718: , p8_a1 JTF_DATE_TABLE
719: , p8_a2 JTF_NUMBER_TABLE
720: , p8_a3 JTF_NUMBER_TABLE
721: , p8_a4 JTF_NUMBER_TABLE
722: , p8_a5 JTF_NUMBER_TABLE
723: , p8_a6 JTF_DATE_TABLE
724: , p8_a7 JTF_VARCHAR2_TABLE_100
725: , p8_a8 JTF_VARCHAR2_TABLE_100

Line 722: , p8_a5 JTF_NUMBER_TABLE

718: , p8_a1 JTF_DATE_TABLE
719: , p8_a2 JTF_NUMBER_TABLE
720: , p8_a3 JTF_NUMBER_TABLE
721: , p8_a4 JTF_NUMBER_TABLE
722: , p8_a5 JTF_NUMBER_TABLE
723: , p8_a6 JTF_DATE_TABLE
724: , p8_a7 JTF_VARCHAR2_TABLE_100
725: , p8_a8 JTF_VARCHAR2_TABLE_100
726: , p8_a9 JTF_NUMBER_TABLE

Line 726: , p8_a9 JTF_NUMBER_TABLE

722: , p8_a5 JTF_NUMBER_TABLE
723: , p8_a6 JTF_DATE_TABLE
724: , p8_a7 JTF_VARCHAR2_TABLE_100
725: , p8_a8 JTF_VARCHAR2_TABLE_100
726: , p8_a9 JTF_NUMBER_TABLE
727: , p8_a10 JTF_NUMBER_TABLE
728: , p8_a11 JTF_NUMBER_TABLE
729: , p8_a12 JTF_NUMBER_TABLE
730: , p8_a13 JTF_VARCHAR2_TABLE_2000

Line 727: , p8_a10 JTF_NUMBER_TABLE

723: , p8_a6 JTF_DATE_TABLE
724: , p8_a7 JTF_VARCHAR2_TABLE_100
725: , p8_a8 JTF_VARCHAR2_TABLE_100
726: , p8_a9 JTF_NUMBER_TABLE
727: , p8_a10 JTF_NUMBER_TABLE
728: , p8_a11 JTF_NUMBER_TABLE
729: , p8_a12 JTF_NUMBER_TABLE
730: , p8_a13 JTF_VARCHAR2_TABLE_2000
731: , p8_a14 JTF_NUMBER_TABLE

Line 728: , p8_a11 JTF_NUMBER_TABLE

724: , p8_a7 JTF_VARCHAR2_TABLE_100
725: , p8_a8 JTF_VARCHAR2_TABLE_100
726: , p8_a9 JTF_NUMBER_TABLE
727: , p8_a10 JTF_NUMBER_TABLE
728: , p8_a11 JTF_NUMBER_TABLE
729: , p8_a12 JTF_NUMBER_TABLE
730: , p8_a13 JTF_VARCHAR2_TABLE_2000
731: , p8_a14 JTF_NUMBER_TABLE
732: , p8_a15 JTF_VARCHAR2_TABLE_100

Line 729: , p8_a12 JTF_NUMBER_TABLE

725: , p8_a8 JTF_VARCHAR2_TABLE_100
726: , p8_a9 JTF_NUMBER_TABLE
727: , p8_a10 JTF_NUMBER_TABLE
728: , p8_a11 JTF_NUMBER_TABLE
729: , p8_a12 JTF_NUMBER_TABLE
730: , p8_a13 JTF_VARCHAR2_TABLE_2000
731: , p8_a14 JTF_NUMBER_TABLE
732: , p8_a15 JTF_VARCHAR2_TABLE_100
733: , p8_a16 JTF_VARCHAR2_TABLE_300

Line 731: , p8_a14 JTF_NUMBER_TABLE

727: , p8_a10 JTF_NUMBER_TABLE
728: , p8_a11 JTF_NUMBER_TABLE
729: , p8_a12 JTF_NUMBER_TABLE
730: , p8_a13 JTF_VARCHAR2_TABLE_2000
731: , p8_a14 JTF_NUMBER_TABLE
732: , p8_a15 JTF_VARCHAR2_TABLE_100
733: , p8_a16 JTF_VARCHAR2_TABLE_300
734: , p8_a17 JTF_VARCHAR2_TABLE_300
735: , p8_a18 JTF_VARCHAR2_TABLE_300

Line 748: , p9_a0 JTF_NUMBER_TABLE

744: , p8_a27 JTF_VARCHAR2_TABLE_300
745: , p8_a28 JTF_VARCHAR2_TABLE_300
746: , p8_a29 JTF_VARCHAR2_TABLE_300
747: , p8_a30 JTF_VARCHAR2_TABLE_300
748: , p9_a0 JTF_NUMBER_TABLE
749: , p9_a1 JTF_VARCHAR2_TABLE_100
750: , p9_a2 JTF_VARCHAR2_TABLE_100
751: , p9_a3 JTF_NUMBER_TABLE
752: , p9_a4 JTF_VARCHAR2_TABLE_300

Line 751: , p9_a3 JTF_NUMBER_TABLE

747: , p8_a30 JTF_VARCHAR2_TABLE_300
748: , p9_a0 JTF_NUMBER_TABLE
749: , p9_a1 JTF_VARCHAR2_TABLE_100
750: , p9_a2 JTF_VARCHAR2_TABLE_100
751: , p9_a3 JTF_NUMBER_TABLE
752: , p9_a4 JTF_VARCHAR2_TABLE_300
753: , p9_a5 JTF_VARCHAR2_TABLE_300
754: , p9_a6 JTF_VARCHAR2_TABLE_100
755: , p9_a7 JTF_VARCHAR2_TABLE_100

Line 759: , p9_a11 JTF_NUMBER_TABLE

755: , p9_a7 JTF_VARCHAR2_TABLE_100
756: , p9_a8 JTF_VARCHAR2_TABLE_300
757: , p9_a9 JTF_VARCHAR2_TABLE_100
758: , p9_a10 JTF_VARCHAR2_TABLE_100
759: , p9_a11 JTF_NUMBER_TABLE
760: , p9_a12 JTF_VARCHAR2_TABLE_100
761: , p9_a13 JTF_NUMBER_TABLE
762: , p10_a0 JTF_VARCHAR2_TABLE_100
763: , p10_a1 JTF_NUMBER_TABLE

Line 761: , p9_a13 JTF_NUMBER_TABLE

757: , p9_a9 JTF_VARCHAR2_TABLE_100
758: , p9_a10 JTF_VARCHAR2_TABLE_100
759: , p9_a11 JTF_NUMBER_TABLE
760: , p9_a12 JTF_VARCHAR2_TABLE_100
761: , p9_a13 JTF_NUMBER_TABLE
762: , p10_a0 JTF_VARCHAR2_TABLE_100
763: , p10_a1 JTF_NUMBER_TABLE
764: , p10_a2 JTF_DATE_TABLE
765: , p10_a3 JTF_VARCHAR2_TABLE_100

Line 763: , p10_a1 JTF_NUMBER_TABLE

759: , p9_a11 JTF_NUMBER_TABLE
760: , p9_a12 JTF_VARCHAR2_TABLE_100
761: , p9_a13 JTF_NUMBER_TABLE
762: , p10_a0 JTF_VARCHAR2_TABLE_100
763: , p10_a1 JTF_NUMBER_TABLE
764: , p10_a2 JTF_DATE_TABLE
765: , p10_a3 JTF_VARCHAR2_TABLE_100
766: , p10_a4 JTF_NUMBER_TABLE
767: , p10_a5 JTF_NUMBER_TABLE

Line 766: , p10_a4 JTF_NUMBER_TABLE

762: , p10_a0 JTF_VARCHAR2_TABLE_100
763: , p10_a1 JTF_NUMBER_TABLE
764: , p10_a2 JTF_DATE_TABLE
765: , p10_a3 JTF_VARCHAR2_TABLE_100
766: , p10_a4 JTF_NUMBER_TABLE
767: , p10_a5 JTF_NUMBER_TABLE
768: , p10_a6 JTF_VARCHAR2_TABLE_100
769: , p10_a7 JTF_VARCHAR2_TABLE_300
770: , p10_a8 JTF_VARCHAR2_TABLE_300

Line 767: , p10_a5 JTF_NUMBER_TABLE

763: , p10_a1 JTF_NUMBER_TABLE
764: , p10_a2 JTF_DATE_TABLE
765: , p10_a3 JTF_VARCHAR2_TABLE_100
766: , p10_a4 JTF_NUMBER_TABLE
767: , p10_a5 JTF_NUMBER_TABLE
768: , p10_a6 JTF_VARCHAR2_TABLE_100
769: , p10_a7 JTF_VARCHAR2_TABLE_300
770: , p10_a8 JTF_VARCHAR2_TABLE_300
771: , p10_a9 JTF_VARCHAR2_TABLE_100

Line 773: , p10_a11 JTF_NUMBER_TABLE

769: , p10_a7 JTF_VARCHAR2_TABLE_300
770: , p10_a8 JTF_VARCHAR2_TABLE_300
771: , p10_a9 JTF_VARCHAR2_TABLE_100
772: , p10_a10 JTF_VARCHAR2_TABLE_100
773: , p10_a11 JTF_NUMBER_TABLE
774: , p10_a12 JTF_NUMBER_TABLE
775: , p10_a13 JTF_NUMBER_TABLE
776: , p10_a14 JTF_DATE_TABLE
777: , p10_a15 JTF_VARCHAR2_TABLE_100

Line 774: , p10_a12 JTF_NUMBER_TABLE

770: , p10_a8 JTF_VARCHAR2_TABLE_300
771: , p10_a9 JTF_VARCHAR2_TABLE_100
772: , p10_a10 JTF_VARCHAR2_TABLE_100
773: , p10_a11 JTF_NUMBER_TABLE
774: , p10_a12 JTF_NUMBER_TABLE
775: , p10_a13 JTF_NUMBER_TABLE
776: , p10_a14 JTF_DATE_TABLE
777: , p10_a15 JTF_VARCHAR2_TABLE_100
778: , p10_a16 JTF_VARCHAR2_TABLE_100

Line 775: , p10_a13 JTF_NUMBER_TABLE

771: , p10_a9 JTF_VARCHAR2_TABLE_100
772: , p10_a10 JTF_VARCHAR2_TABLE_100
773: , p10_a11 JTF_NUMBER_TABLE
774: , p10_a12 JTF_NUMBER_TABLE
775: , p10_a13 JTF_NUMBER_TABLE
776: , p10_a14 JTF_DATE_TABLE
777: , p10_a15 JTF_VARCHAR2_TABLE_100
778: , p10_a16 JTF_VARCHAR2_TABLE_100
779: , p10_a17 JTF_VARCHAR2_TABLE_300

Line 1013: , p_new_inv_item_id JTF_NUMBER_TABLE

1009: , x_return_status out nocopy VARCHAR2
1010: , x_msg_count out nocopy NUMBER
1011: , x_msg_data out nocopy VARCHAR2
1012: , p_org_inv_item_id NUMBER
1013: , p_new_inv_item_id JTF_NUMBER_TABLE
1014: )
1015:
1016: as
1017: ddp_new_inv_item_id ozf_pricelist_pvt.num_tbl_type;