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.IBE_ATTACHMENT_GRP_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p1(t out nocopy ibe_attachment_grp.attachment_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_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

Line 23: , a1 JTF_NUMBER_TABLE

19: return n;
20: end;
21:
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

Line 25: , a3 JTF_NUMBER_TABLE

21:
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

Line 30: , a8 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
34: , a12 JTF_NUMBER_TABLE

Line 33: , a11 JTF_NUMBER_TABLE

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
36: , a14 JTF_VARCHAR2_TABLE_2000
37: , a15 JTF_VARCHAR2_TABLE_2000

Line 34: , a12 JTF_NUMBER_TABLE

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
36: , a14 JTF_VARCHAR2_TABLE_2000
37: , a15 JTF_VARCHAR2_TABLE_2000
38: , a16 JTF_VARCHAR2_TABLE_100

Line 41: , a19 JTF_NUMBER_TABLE

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
45: , a23 JTF_NUMBER_TABLE

Line 45: , a23 JTF_NUMBER_TABLE

41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_2000
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

Line 129: procedure rosetta_table_copy_out_p1(t ibe_attachment_grp.attachment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

125: end loop;
126: end if;
127: end if;
128: end rosetta_table_copy_in_p1;
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

Line 130: , a1 out nocopy JTF_NUMBER_TABLE

126: end if;
127: end if;
128: end rosetta_table_copy_in_p1;
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

Line 132: , a3 out nocopy JTF_NUMBER_TABLE

128: end rosetta_table_copy_in_p1;
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

Line 137: , a8 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
141: , a12 out nocopy JTF_NUMBER_TABLE

Line 140: , a11 out nocopy JTF_NUMBER_TABLE

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
143: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
144: , a15 out nocopy JTF_VARCHAR2_TABLE_2000

Line 141: , a12 out nocopy JTF_NUMBER_TABLE

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
143: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
144: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
145: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 148: , a19 out nocopy JTF_NUMBER_TABLE

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
152: , a23 out nocopy JTF_NUMBER_TABLE

Line 152: , a23 out nocopy JTF_NUMBER_TABLE

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
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

Line 178: a0 := JTF_NUMBER_TABLE();

174: ) as
175: ddindx binary_integer; indx binary_integer;
176: begin
177: if t is null or t.count = 0 then
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();

Line 179: a1 := JTF_NUMBER_TABLE();

175: ddindx binary_integer; indx binary_integer;
176: begin
177: if t is null or t.count = 0 then
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();

Line 181: a3 := JTF_NUMBER_TABLE();

177: if t is null or t.count = 0 then
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();

Line 186: a8 := 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();
190: a12 := JTF_NUMBER_TABLE();

Line 189: a11 := JTF_NUMBER_TABLE();

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();
192: a14 := JTF_VARCHAR2_TABLE_2000();
193: a15 := JTF_VARCHAR2_TABLE_2000();

Line 190: a12 := JTF_NUMBER_TABLE();

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();
192: a14 := JTF_VARCHAR2_TABLE_2000();
193: a15 := JTF_VARCHAR2_TABLE_2000();
194: a16 := JTF_VARCHAR2_TABLE_100();

Line 197: a19 := JTF_NUMBER_TABLE();

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();
201: a23 := JTF_NUMBER_TABLE();

Line 201: a23 := JTF_NUMBER_TABLE();

197: a19 := JTF_NUMBER_TABLE();
198: a20 := JTF_VARCHAR2_TABLE_2000();
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();

Line 224: a0 := JTF_NUMBER_TABLE();

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();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_VARCHAR2_TABLE_100();

Line 225: a1 := JTF_NUMBER_TABLE();

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();
227: a3 := JTF_NUMBER_TABLE();
228: a4 := JTF_VARCHAR2_TABLE_100();
229: a5 := JTF_VARCHAR2_TABLE_100();

Line 227: a3 := JTF_NUMBER_TABLE();

223: else
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();

Line 232: a8 := 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();
236: a12 := JTF_NUMBER_TABLE();

Line 235: a11 := JTF_NUMBER_TABLE();

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();
238: a14 := JTF_VARCHAR2_TABLE_2000();
239: a15 := JTF_VARCHAR2_TABLE_2000();

Line 236: a12 := JTF_NUMBER_TABLE();

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();
238: a14 := JTF_VARCHAR2_TABLE_2000();
239: a15 := JTF_VARCHAR2_TABLE_2000();
240: a16 := JTF_VARCHAR2_TABLE_100();

Line 243: a19 := JTF_NUMBER_TABLE();

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();
247: a23 := JTF_NUMBER_TABLE();

Line 247: a23 := JTF_NUMBER_TABLE();

243: a19 := JTF_NUMBER_TABLE();
244: a20 := JTF_VARCHAR2_TABLE_2000();
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();

Line 373: procedure rosetta_table_copy_in_p3(t out nocopy ibe_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE

369: end if;
370: end if;
371: end rosetta_table_copy_out_p1;
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

Line 375: , a2 JTF_NUMBER_TABLE

371: end rosetta_table_copy_out_p1;
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

Line 398: procedure rosetta_table_copy_out_p3(t ibe_attachment_grp.ath_id_ver_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

394: end loop;
395: end if;
396: end if;
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

Line 400: , a2 out nocopy JTF_NUMBER_TABLE

396: end if;
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

Line 406: a0 := JTF_NUMBER_TABLE();

402: ) as
403: ddindx binary_integer; indx binary_integer;
404: begin
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

Line 408: a2 := JTF_NUMBER_TABLE();

404: begin
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();

Line 411: 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();
414: a3 := JTF_VARCHAR2_TABLE_100();
415: if t.count > 0 then

Line 413: 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();
414: a3 := JTF_VARCHAR2_TABLE_100();
415: if t.count > 0 then
416: a0.extend(t.count);
417: a1.extend(t.count);

Line 437: procedure rosetta_table_copy_in_p4(t out nocopy ibe_attachment_grp.number_table, a0 JTF_NUMBER_TABLE) as

433: end if;
434: end if;
435: end rosetta_table_copy_out_p3;
436:
437: procedure rosetta_table_copy_in_p4(t out nocopy ibe_attachment_grp.number_table, a0 JTF_NUMBER_TABLE) as
438: ddindx binary_integer; indx binary_integer;
439: begin
440: if a0 is null then
441: t := null;

Line 461: procedure rosetta_table_copy_out_p4(t ibe_attachment_grp.number_table, a0 out nocopy JTF_NUMBER_TABLE) as

457: end loop;
458: end if;
459: end if;
460: end rosetta_table_copy_in_p4;
461: procedure rosetta_table_copy_out_p4(t ibe_attachment_grp.number_table, a0 out nocopy JTF_NUMBER_TABLE) as
462: ddindx binary_integer; indx binary_integer;
463: begin
464: if t is null then
465: a0 := null;

Line 467: a0 := JTF_NUMBER_TABLE();

463: begin
464: if t is null then
465: a0 := null;
466: elsif t.count = 0 then
467: a0 := JTF_NUMBER_TABLE();
468: else
469: a0 := JTF_NUMBER_TABLE();
470: if t.count > 0 then
471: a0.extend(t.count);

Line 469: a0 := JTF_NUMBER_TABLE();

465: a0 := null;
466: elsif t.count = 0 then
467: a0 := JTF_NUMBER_TABLE();
468: else
469: a0 := JTF_NUMBER_TABLE();
470: if t.count > 0 then
471: a0.extend(t.count);
472: ddindx := t.first;
473: indx := 1;

Line 594: , x_ath_id_tbl out nocopy JTF_NUMBER_TABLE

590: , p_deliverable_id NUMBER
591: , p_start_id NUMBER
592: , p_batch_size NUMBER
593: , x_row_count out nocopy NUMBER
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

Line 595: , x_dlv_id_tbl out nocopy JTF_NUMBER_TABLE

591: , p_start_id NUMBER
592: , p_batch_size NUMBER
593: , x_row_count out nocopy NUMBER
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

Line 597: , x_file_id_tbl out nocopy JTF_NUMBER_TABLE

593: , x_row_count out nocopy NUMBER
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

Line 599: , x_dsp_width_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: )
603:

Line 600: , x_dsp_height_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: )
603:
604: as

Line 601: , x_version_tbl out nocopy JTF_NUMBER_TABLE

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: )
603:
604: as
605: ddx_ath_id_tbl ibe_attachment_grp.number_table;

Line 863: , p6_a0 in out nocopy JTF_NUMBER_TABLE

859: , p_commit VARCHAR2
860: , x_return_status out nocopy VARCHAR2
861: , x_msg_count out nocopy NUMBER
862: , x_msg_data out nocopy VARCHAR2
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

Line 864: , p6_a1 in out nocopy JTF_NUMBER_TABLE

860: , x_return_status out nocopy VARCHAR2
861: , x_msg_count out nocopy NUMBER
862: , x_msg_data out nocopy VARCHAR2
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

Line 866: , p6_a3 in out nocopy JTF_NUMBER_TABLE

862: , x_msg_data out nocopy VARCHAR2
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

Line 871: , p6_a8 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
875: , p6_a12 in out nocopy JTF_NUMBER_TABLE

Line 874: , p6_a11 in out nocopy JTF_NUMBER_TABLE

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
877: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_2000
878: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 875: , p6_a12 in out nocopy JTF_NUMBER_TABLE

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
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

Line 882: , p6_a19 in out nocopy JTF_NUMBER_TABLE

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
886: , p6_a23 in out nocopy JTF_NUMBER_TABLE

Line 886: , p6_a23 in out nocopy JTF_NUMBER_TABLE

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
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

Line 1039: , p6_a0 in out nocopy JTF_NUMBER_TABLE

1035: , p_commit VARCHAR2
1036: , x_return_status out nocopy VARCHAR2
1037: , x_msg_count out nocopy NUMBER
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: )

Line 1041: , p6_a2 in out nocopy JTF_NUMBER_TABLE

1037: , x_msg_count out nocopy NUMBER
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