DBA Data[Home] [Help]

APPS.JTF_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 jtf_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 129: , a2 out JTF_VARCHAR2_TABLE_300

125: end if;
126: end rosetta_table_copy_in_p1;
127: procedure rosetta_table_copy_out_p1(t jtf_attachment_grp.attachment_tbl_type, a0 out JTF_NUMBER_TABLE
128: , a1 out JTF_NUMBER_TABLE
129: , a2 out JTF_VARCHAR2_TABLE_300
130: , a3 out JTF_NUMBER_TABLE
131: , a4 out JTF_VARCHAR2_TABLE_100
132: , a5 out JTF_VARCHAR2_TABLE_100
133: , a6 out JTF_VARCHAR2_TABLE_100

Line 137: , a10 out JTF_VARCHAR2_TABLE_300

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

Line 148: , a21 out JTF_VARCHAR2_TABLE_300

144: , a17 out JTF_VARCHAR2_TABLE_100
145: , a18 out JTF_VARCHAR2_TABLE_100
146: , a19 out JTF_NUMBER_TABLE
147: , a20 out JTF_VARCHAR2_TABLE_2000
148: , a21 out JTF_VARCHAR2_TABLE_300
149: , a22 out JTF_VARCHAR2_TABLE_1100
150: , a23 out JTF_NUMBER_TABLE
151: , a24 out JTF_VARCHAR2_TABLE_300
152: , a25 out JTF_VARCHAR2_TABLE_100

Line 151: , a24 out JTF_VARCHAR2_TABLE_300

147: , a20 out JTF_VARCHAR2_TABLE_2000
148: , a21 out JTF_VARCHAR2_TABLE_300
149: , a22 out JTF_VARCHAR2_TABLE_1100
150: , a23 out JTF_NUMBER_TABLE
151: , a24 out JTF_VARCHAR2_TABLE_300
152: , a25 out JTF_VARCHAR2_TABLE_100
153: , a26 out JTF_VARCHAR2_TABLE_200
154: , a27 out JTF_VARCHAR2_TABLE_200
155: , a28 out JTF_VARCHAR2_TABLE_200

Line 177: a2 := JTF_VARCHAR2_TABLE_300();

173: begin
174: if t is null or t.count = 0 then
175: a0 := JTF_NUMBER_TABLE();
176: a1 := JTF_NUMBER_TABLE();
177: a2 := JTF_VARCHAR2_TABLE_300();
178: a3 := JTF_NUMBER_TABLE();
179: a4 := JTF_VARCHAR2_TABLE_100();
180: a5 := JTF_VARCHAR2_TABLE_100();
181: a6 := JTF_VARCHAR2_TABLE_100();

Line 185: a10 := JTF_VARCHAR2_TABLE_300();

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

Line 196: a21 := JTF_VARCHAR2_TABLE_300();

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

Line 199: a24 := JTF_VARCHAR2_TABLE_300();

195: a20 := JTF_VARCHAR2_TABLE_2000();
196: a21 := JTF_VARCHAR2_TABLE_300();
197: a22 := JTF_VARCHAR2_TABLE_1100();
198: a23 := JTF_NUMBER_TABLE();
199: a24 := JTF_VARCHAR2_TABLE_300();
200: a25 := JTF_VARCHAR2_TABLE_100();
201: a26 := JTF_VARCHAR2_TABLE_200();
202: a27 := JTF_VARCHAR2_TABLE_200();
203: a28 := JTF_VARCHAR2_TABLE_200();

Line 222: a2 := JTF_VARCHAR2_TABLE_300();

218: a43 := JTF_VARCHAR2_TABLE_100();
219: else
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_300();
223: a3 := JTF_NUMBER_TABLE();
224: a4 := JTF_VARCHAR2_TABLE_100();
225: a5 := JTF_VARCHAR2_TABLE_100();
226: a6 := JTF_VARCHAR2_TABLE_100();

Line 230: a10 := JTF_VARCHAR2_TABLE_300();

226: a6 := JTF_VARCHAR2_TABLE_100();
227: a7 := JTF_VARCHAR2_TABLE_100();
228: a8 := JTF_NUMBER_TABLE();
229: a9 := JTF_VARCHAR2_TABLE_100();
230: a10 := JTF_VARCHAR2_TABLE_300();
231: a11 := JTF_NUMBER_TABLE();
232: a12 := JTF_NUMBER_TABLE();
233: a13 := JTF_VARCHAR2_TABLE_2000();
234: a14 := JTF_VARCHAR2_TABLE_2000();

Line 241: a21 := JTF_VARCHAR2_TABLE_300();

237: a17 := JTF_VARCHAR2_TABLE_100();
238: a18 := JTF_VARCHAR2_TABLE_100();
239: a19 := JTF_NUMBER_TABLE();
240: a20 := JTF_VARCHAR2_TABLE_2000();
241: a21 := JTF_VARCHAR2_TABLE_300();
242: a22 := JTF_VARCHAR2_TABLE_1100();
243: a23 := JTF_NUMBER_TABLE();
244: a24 := JTF_VARCHAR2_TABLE_300();
245: a25 := JTF_VARCHAR2_TABLE_100();

Line 244: a24 := JTF_VARCHAR2_TABLE_300();

240: a20 := JTF_VARCHAR2_TABLE_2000();
241: a21 := JTF_VARCHAR2_TABLE_300();
242: a22 := JTF_VARCHAR2_TABLE_1100();
243: a23 := JTF_NUMBER_TABLE();
244: a24 := JTF_VARCHAR2_TABLE_300();
245: a25 := JTF_VARCHAR2_TABLE_100();
246: a26 := JTF_VARCHAR2_TABLE_200();
247: a27 := JTF_VARCHAR2_TABLE_200();
248: a28 := JTF_VARCHAR2_TABLE_200();

Line 367: , a1 JTF_VARCHAR2_TABLE_300

363: end if;
364: end rosetta_table_copy_out_p1;
365:
366: procedure rosetta_table_copy_in_p3(t out jtf_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
367: , a1 JTF_VARCHAR2_TABLE_300
368: , a2 JTF_NUMBER_TABLE
369: , a3 JTF_VARCHAR2_TABLE_100
370: ) as
371: ddindx binary_integer; indx binary_integer;

Line 392: , a1 out JTF_VARCHAR2_TABLE_300

388: end if;
389: end if;
390: end rosetta_table_copy_in_p3;
391: procedure rosetta_table_copy_out_p3(t jtf_attachment_grp.ath_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE
392: , a1 out JTF_VARCHAR2_TABLE_300
393: , a2 out JTF_NUMBER_TABLE
394: , a3 out JTF_VARCHAR2_TABLE_100
395: ) as
396: ddindx binary_integer; indx binary_integer;

Line 400: a1 := JTF_VARCHAR2_TABLE_300();

396: ddindx binary_integer; indx binary_integer;
397: begin
398: if t is null or t.count = 0 then
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_300();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: else
404: a0 := JTF_NUMBER_TABLE();

Line 405: a1 := JTF_VARCHAR2_TABLE_300();

401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: else
404: a0 := JTF_NUMBER_TABLE();
405: a1 := JTF_VARCHAR2_TABLE_300();
406: a2 := JTF_NUMBER_TABLE();
407: a3 := JTF_VARCHAR2_TABLE_100();
408: if t.count > 0 then
409: a0.extend(t.count);

Line 479: procedure rosetta_table_copy_in_p5(t out jtf_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as

475: end if;
476: end if;
477: end rosetta_table_copy_out_p4;
478:
479: procedure rosetta_table_copy_in_p5(t out jtf_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as
480: ddindx binary_integer; indx binary_integer;
481: begin
482: if a0 is null then
483: t := null;

Line 503: procedure rosetta_table_copy_out_p5(t jtf_attachment_grp.varchar2_table_300, a0 out JTF_VARCHAR2_TABLE_300) as

499: end loop;
500: end if;
501: end if;
502: end rosetta_table_copy_in_p5;
503: procedure rosetta_table_copy_out_p5(t jtf_attachment_grp.varchar2_table_300, a0 out JTF_VARCHAR2_TABLE_300) as
504: ddindx binary_integer; indx binary_integer;
505: begin
506: if t is null then
507: a0 := null;

Line 509: a0 := JTF_VARCHAR2_TABLE_300();

505: begin
506: if t is null then
507: a0 := null;
508: elsif t.count = 0 then
509: a0 := JTF_VARCHAR2_TABLE_300();
510: else
511: a0 := JTF_VARCHAR2_TABLE_300();
512: if t.count > 0 then
513: a0.extend(t.count);

Line 511: a0 := JTF_VARCHAR2_TABLE_300();

507: a0 := null;
508: elsif t.count = 0 then
509: a0 := JTF_VARCHAR2_TABLE_300();
510: else
511: a0 := JTF_VARCHAR2_TABLE_300();
512: if t.count > 0 then
513: a0.extend(t.count);
514: ddindx := t.first;
515: indx := 1;

Line 589: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300

585: , p_batch_size NUMBER
586: , x_row_count out NUMBER
587: , x_ath_id_tbl out JTF_NUMBER_TABLE
588: , x_dlv_id_tbl out JTF_NUMBER_TABLE
589: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
590: , x_file_id_tbl out JTF_NUMBER_TABLE
591: , x_file_ext_tbl out JTF_VARCHAR2_TABLE_100
592: , x_dsp_width_tbl out JTF_NUMBER_TABLE
593: , x_dsp_height_tbl out JTF_NUMBER_TABLE

Line 853: , p6_a2 in out JTF_VARCHAR2_TABLE_300

849: , x_msg_count out NUMBER
850: , x_msg_data out VARCHAR2
851: , p6_a0 in out JTF_NUMBER_TABLE
852: , p6_a1 in out JTF_NUMBER_TABLE
853: , p6_a2 in out JTF_VARCHAR2_TABLE_300
854: , p6_a3 in out JTF_NUMBER_TABLE
855: , p6_a4 in out JTF_VARCHAR2_TABLE_100
856: , p6_a5 in out JTF_VARCHAR2_TABLE_100
857: , p6_a6 in out JTF_VARCHAR2_TABLE_100

Line 861: , p6_a10 in out JTF_VARCHAR2_TABLE_300

857: , p6_a6 in out JTF_VARCHAR2_TABLE_100
858: , p6_a7 in out JTF_VARCHAR2_TABLE_100
859: , p6_a8 in out JTF_NUMBER_TABLE
860: , p6_a9 in out JTF_VARCHAR2_TABLE_100
861: , p6_a10 in out JTF_VARCHAR2_TABLE_300
862: , p6_a11 in out JTF_NUMBER_TABLE
863: , p6_a12 in out JTF_NUMBER_TABLE
864: , p6_a13 in out JTF_VARCHAR2_TABLE_2000
865: , p6_a14 in out JTF_VARCHAR2_TABLE_2000

Line 872: , p6_a21 in out JTF_VARCHAR2_TABLE_300

868: , p6_a17 in out JTF_VARCHAR2_TABLE_100
869: , p6_a18 in out JTF_VARCHAR2_TABLE_100
870: , p6_a19 in out JTF_NUMBER_TABLE
871: , p6_a20 in out JTF_VARCHAR2_TABLE_2000
872: , p6_a21 in out JTF_VARCHAR2_TABLE_300
873: , p6_a22 in out JTF_VARCHAR2_TABLE_1100
874: , p6_a23 in out JTF_NUMBER_TABLE
875: , p6_a24 in out JTF_VARCHAR2_TABLE_300
876: , p6_a25 in out JTF_VARCHAR2_TABLE_100

Line 875: , p6_a24 in out JTF_VARCHAR2_TABLE_300

871: , p6_a20 in out JTF_VARCHAR2_TABLE_2000
872: , p6_a21 in out JTF_VARCHAR2_TABLE_300
873: , p6_a22 in out JTF_VARCHAR2_TABLE_1100
874: , p6_a23 in out JTF_NUMBER_TABLE
875: , p6_a24 in out JTF_VARCHAR2_TABLE_300
876: , p6_a25 in out JTF_VARCHAR2_TABLE_100
877: , p6_a26 in out JTF_VARCHAR2_TABLE_200
878: , p6_a27 in out JTF_VARCHAR2_TABLE_200
879: , p6_a28 in out JTF_VARCHAR2_TABLE_200

Line 1024: , p6_a1 in out JTF_VARCHAR2_TABLE_300

1020: , x_return_status out VARCHAR2
1021: , x_msg_count out NUMBER
1022: , x_msg_data out VARCHAR2
1023: , p6_a0 in out JTF_NUMBER_TABLE
1024: , p6_a1 in out JTF_VARCHAR2_TABLE_300
1025: , p6_a2 in out JTF_NUMBER_TABLE
1026: , p6_a3 in out JTF_VARCHAR2_TABLE_100
1027: )
1028: as