DBA Data[Home] [Help]

APPS.IBE_ATTACHMENT_GRP_W dependencies on JTF_VARCHAR2_TABLE_300

Line 24: , a2 JTF_VARCHAR2_TABLE_300

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
28: , a6 JTF_VARCHAR2_TABLE_100

Line 32: , a10 JTF_VARCHAR2_TABLE_300

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

Line 43: , a21 JTF_VARCHAR2_TABLE_300

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
46: , a24 JTF_VARCHAR2_TABLE_300
47: , a25 JTF_VARCHAR2_TABLE_100

Line 46: , a24 JTF_VARCHAR2_TABLE_300

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
50: , a28 JTF_VARCHAR2_TABLE_200

Line 131: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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
135: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 139: , a10 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 150: , a21 out nocopy JTF_VARCHAR2_TABLE_300

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
153: , a24 out nocopy JTF_VARCHAR2_TABLE_300
154: , a25 out nocopy JTF_VARCHAR2_TABLE_100

Line 153: , a24 out nocopy JTF_VARCHAR2_TABLE_300

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
157: , a28 out nocopy JTF_VARCHAR2_TABLE_200

Line 180: a2 := JTF_VARCHAR2_TABLE_300();

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();
184: a6 := JTF_VARCHAR2_TABLE_100();

Line 188: a10 := JTF_VARCHAR2_TABLE_300();

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

Line 199: a21 := JTF_VARCHAR2_TABLE_300();

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();
202: a24 := JTF_VARCHAR2_TABLE_300();
203: a25 := JTF_VARCHAR2_TABLE_100();

Line 202: a24 := JTF_VARCHAR2_TABLE_300();

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();
206: a28 := JTF_VARCHAR2_TABLE_200();

Line 226: a2 := JTF_VARCHAR2_TABLE_300();

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();
230: a6 := JTF_VARCHAR2_TABLE_100();

Line 234: a10 := JTF_VARCHAR2_TABLE_300();

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

Line 245: a21 := JTF_VARCHAR2_TABLE_300();

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();
248: a24 := JTF_VARCHAR2_TABLE_300();
249: a25 := JTF_VARCHAR2_TABLE_100();

Line 248: a24 := JTF_VARCHAR2_TABLE_300();

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();
252: a28 := JTF_VARCHAR2_TABLE_200();

Line 374: , a1 JTF_VARCHAR2_TABLE_300

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
378: ddindx binary_integer; indx binary_integer;

Line 399: , a1 out nocopy JTF_VARCHAR2_TABLE_300

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
403: ddindx binary_integer; indx binary_integer;

Line 407: a1 := JTF_VARCHAR2_TABLE_300();

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
411: a0 := JTF_NUMBER_TABLE();

Line 412: 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
416: a0.extend(t.count);

Line 486: procedure rosetta_table_copy_in_p5(t out nocopy ibe_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as

482: end if;
483: end if;
484: end rosetta_table_copy_out_p4;
485:
486: procedure rosetta_table_copy_in_p5(t out nocopy ibe_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as
487: ddindx binary_integer; indx binary_integer;
488: begin
489: if a0 is null then
490: t := null;

Line 510: procedure rosetta_table_copy_out_p5(t ibe_attachment_grp.varchar2_table_300, a0 out nocopy JTF_VARCHAR2_TABLE_300) as

506: end loop;
507: end if;
508: end if;
509: end rosetta_table_copy_in_p5;
510: procedure rosetta_table_copy_out_p5(t ibe_attachment_grp.varchar2_table_300, a0 out nocopy JTF_VARCHAR2_TABLE_300) as
511: ddindx binary_integer; indx binary_integer;
512: begin
513: if t is null then
514: a0 := null;

Line 516: a0 := JTF_VARCHAR2_TABLE_300();

512: begin
513: if t is null then
514: a0 := null;
515: elsif t.count = 0 then
516: a0 := JTF_VARCHAR2_TABLE_300();
517: else
518: a0 := JTF_VARCHAR2_TABLE_300();
519: if t.count > 0 then
520: a0.extend(t.count);

Line 518: a0 := JTF_VARCHAR2_TABLE_300();

514: a0 := null;
515: elsif t.count = 0 then
516: a0 := JTF_VARCHAR2_TABLE_300();
517: else
518: a0 := JTF_VARCHAR2_TABLE_300();
519: if t.count > 0 then
520: a0.extend(t.count);
521: ddindx := t.first;
522: indx := 1;

Line 596: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300

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
600: , x_dsp_height_tbl out nocopy JTF_NUMBER_TABLE

Line 865: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300

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
869: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 873: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300

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

Line 884: , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_300

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
887: , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_300
888: , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_100

Line 887: , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_300

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
891: , p6_a28 in out nocopy JTF_VARCHAR2_TABLE_200

Line 1040: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_300

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: )
1044: