DBA Data[Home] [Help]

APPS.JTF_ATTACHMENT_GRP_W dependencies on JTF_VARCHAR2_TABLE_300

Line 5: , a2 JTF_VARCHAR2_TABLE_300

1: package jtf_attachment_grp_w AUTHID CURRENT_USER as
2: /* $Header: JTFGRATS.pls 115.8 2004/07/09 18:50:24 applrt ship $ */
3: procedure rosetta_table_copy_in_p1(t out jtf_attachment_grp.attachment_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100

Line 13: , a10 JTF_VARCHAR2_TABLE_300

9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_2000
17: , a14 JTF_VARCHAR2_TABLE_2000

Line 24: , a21 JTF_VARCHAR2_TABLE_300

20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_2000
24: , a21 JTF_VARCHAR2_TABLE_300
25: , a22 JTF_VARCHAR2_TABLE_1100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_300
28: , a25 JTF_VARCHAR2_TABLE_100

Line 27: , a24 JTF_VARCHAR2_TABLE_300

23: , a20 JTF_VARCHAR2_TABLE_2000
24: , a21 JTF_VARCHAR2_TABLE_300
25: , a22 JTF_VARCHAR2_TABLE_1100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_300
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_200
30: , a27 JTF_VARCHAR2_TABLE_200
31: , a28 JTF_VARCHAR2_TABLE_200

Line 50: , a2 out JTF_VARCHAR2_TABLE_300

46: , a43 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p1(t jtf_attachment_grp.attachment_tbl_type, a0 out JTF_NUMBER_TABLE
49: , a1 out JTF_NUMBER_TABLE
50: , a2 out JTF_VARCHAR2_TABLE_300
51: , a3 out JTF_NUMBER_TABLE
52: , a4 out JTF_VARCHAR2_TABLE_100
53: , a5 out JTF_VARCHAR2_TABLE_100
54: , a6 out JTF_VARCHAR2_TABLE_100

Line 58: , a10 out JTF_VARCHAR2_TABLE_300

54: , a6 out JTF_VARCHAR2_TABLE_100
55: , a7 out JTF_VARCHAR2_TABLE_100
56: , a8 out JTF_NUMBER_TABLE
57: , a9 out JTF_VARCHAR2_TABLE_100
58: , a10 out JTF_VARCHAR2_TABLE_300
59: , a11 out JTF_NUMBER_TABLE
60: , a12 out JTF_NUMBER_TABLE
61: , a13 out JTF_VARCHAR2_TABLE_2000
62: , a14 out JTF_VARCHAR2_TABLE_2000

Line 69: , a21 out JTF_VARCHAR2_TABLE_300

65: , a17 out JTF_VARCHAR2_TABLE_100
66: , a18 out JTF_VARCHAR2_TABLE_100
67: , a19 out JTF_NUMBER_TABLE
68: , a20 out JTF_VARCHAR2_TABLE_2000
69: , a21 out JTF_VARCHAR2_TABLE_300
70: , a22 out JTF_VARCHAR2_TABLE_1100
71: , a23 out JTF_NUMBER_TABLE
72: , a24 out JTF_VARCHAR2_TABLE_300
73: , a25 out JTF_VARCHAR2_TABLE_100

Line 72: , a24 out JTF_VARCHAR2_TABLE_300

68: , a20 out JTF_VARCHAR2_TABLE_2000
69: , a21 out JTF_VARCHAR2_TABLE_300
70: , a22 out JTF_VARCHAR2_TABLE_1100
71: , a23 out JTF_NUMBER_TABLE
72: , a24 out JTF_VARCHAR2_TABLE_300
73: , a25 out JTF_VARCHAR2_TABLE_100
74: , a26 out JTF_VARCHAR2_TABLE_200
75: , a27 out JTF_VARCHAR2_TABLE_200
76: , a28 out JTF_VARCHAR2_TABLE_200

Line 95: , a1 JTF_VARCHAR2_TABLE_300

91: , a43 out JTF_VARCHAR2_TABLE_100
92: );
93:
94: procedure rosetta_table_copy_in_p3(t out jtf_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
95: , a1 JTF_VARCHAR2_TABLE_300
96: , a2 JTF_NUMBER_TABLE
97: , a3 JTF_VARCHAR2_TABLE_100
98: );
99: procedure rosetta_table_copy_out_p3(t jtf_attachment_grp.ath_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE

Line 100: , a1 out JTF_VARCHAR2_TABLE_300

96: , a2 JTF_NUMBER_TABLE
97: , a3 JTF_VARCHAR2_TABLE_100
98: );
99: procedure rosetta_table_copy_out_p3(t jtf_attachment_grp.ath_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE
100: , a1 out JTF_VARCHAR2_TABLE_300
101: , a2 out JTF_NUMBER_TABLE
102: , a3 out JTF_VARCHAR2_TABLE_100
103: );
104:

Line 108: procedure rosetta_table_copy_in_p5(t out jtf_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300);

104:
105: procedure rosetta_table_copy_in_p4(t out jtf_attachment_grp.number_table, a0 JTF_NUMBER_TABLE);
106: procedure rosetta_table_copy_out_p4(t jtf_attachment_grp.number_table, a0 out JTF_NUMBER_TABLE);
107:
108: procedure rosetta_table_copy_in_p5(t out jtf_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300);
109: procedure rosetta_table_copy_out_p5(t jtf_attachment_grp.varchar2_table_300, a0 out JTF_VARCHAR2_TABLE_300);
110:
111: procedure rosetta_table_copy_in_p6(t out jtf_attachment_grp.varchar2_table_20, a0 JTF_VARCHAR2_TABLE_100);
112: procedure rosetta_table_copy_out_p6(t jtf_attachment_grp.varchar2_table_20, a0 out JTF_VARCHAR2_TABLE_100);

Line 109: procedure rosetta_table_copy_out_p5(t jtf_attachment_grp.varchar2_table_300, a0 out JTF_VARCHAR2_TABLE_300);

105: procedure rosetta_table_copy_in_p4(t out jtf_attachment_grp.number_table, a0 JTF_NUMBER_TABLE);
106: procedure rosetta_table_copy_out_p4(t jtf_attachment_grp.number_table, a0 out JTF_NUMBER_TABLE);
107:
108: procedure rosetta_table_copy_in_p5(t out jtf_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300);
109: procedure rosetta_table_copy_out_p5(t jtf_attachment_grp.varchar2_table_300, a0 out JTF_VARCHAR2_TABLE_300);
110:
111: procedure rosetta_table_copy_in_p6(t out jtf_attachment_grp.varchar2_table_20, a0 JTF_VARCHAR2_TABLE_100);
112: procedure rosetta_table_copy_out_p6(t jtf_attachment_grp.varchar2_table_20, a0 out JTF_VARCHAR2_TABLE_100);
113:

Line 126: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300

122: , p_batch_size NUMBER
123: , x_row_count out NUMBER
124: , x_ath_id_tbl out JTF_NUMBER_TABLE
125: , x_dlv_id_tbl out JTF_NUMBER_TABLE
126: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
127: , x_file_id_tbl out JTF_NUMBER_TABLE
128: , x_file_ext_tbl out JTF_VARCHAR2_TABLE_100
129: , x_dsp_width_tbl out JTF_NUMBER_TABLE
130: , x_dsp_height_tbl out JTF_NUMBER_TABLE

Line 192: , p6_a2 in out JTF_VARCHAR2_TABLE_300

188: , x_msg_count out NUMBER
189: , x_msg_data out VARCHAR2
190: , p6_a0 in out JTF_NUMBER_TABLE
191: , p6_a1 in out JTF_NUMBER_TABLE
192: , p6_a2 in out JTF_VARCHAR2_TABLE_300
193: , p6_a3 in out JTF_NUMBER_TABLE
194: , p6_a4 in out JTF_VARCHAR2_TABLE_100
195: , p6_a5 in out JTF_VARCHAR2_TABLE_100
196: , p6_a6 in out JTF_VARCHAR2_TABLE_100

Line 200: , p6_a10 in out JTF_VARCHAR2_TABLE_300

196: , p6_a6 in out JTF_VARCHAR2_TABLE_100
197: , p6_a7 in out JTF_VARCHAR2_TABLE_100
198: , p6_a8 in out JTF_NUMBER_TABLE
199: , p6_a9 in out JTF_VARCHAR2_TABLE_100
200: , p6_a10 in out JTF_VARCHAR2_TABLE_300
201: , p6_a11 in out JTF_NUMBER_TABLE
202: , p6_a12 in out JTF_NUMBER_TABLE
203: , p6_a13 in out JTF_VARCHAR2_TABLE_2000
204: , p6_a14 in out JTF_VARCHAR2_TABLE_2000

Line 211: , p6_a21 in out JTF_VARCHAR2_TABLE_300

207: , p6_a17 in out JTF_VARCHAR2_TABLE_100
208: , p6_a18 in out JTF_VARCHAR2_TABLE_100
209: , p6_a19 in out JTF_NUMBER_TABLE
210: , p6_a20 in out JTF_VARCHAR2_TABLE_2000
211: , p6_a21 in out JTF_VARCHAR2_TABLE_300
212: , p6_a22 in out JTF_VARCHAR2_TABLE_1100
213: , p6_a23 in out JTF_NUMBER_TABLE
214: , p6_a24 in out JTF_VARCHAR2_TABLE_300
215: , p6_a25 in out JTF_VARCHAR2_TABLE_100

Line 214: , p6_a24 in out JTF_VARCHAR2_TABLE_300

210: , p6_a20 in out JTF_VARCHAR2_TABLE_2000
211: , p6_a21 in out JTF_VARCHAR2_TABLE_300
212: , p6_a22 in out JTF_VARCHAR2_TABLE_1100
213: , p6_a23 in out JTF_NUMBER_TABLE
214: , p6_a24 in out JTF_VARCHAR2_TABLE_300
215: , p6_a25 in out JTF_VARCHAR2_TABLE_100
216: , p6_a26 in out JTF_VARCHAR2_TABLE_200
217: , p6_a27 in out JTF_VARCHAR2_TABLE_200
218: , p6_a28 in out JTF_VARCHAR2_TABLE_200

Line 242: , p6_a1 in out JTF_VARCHAR2_TABLE_300

238: , x_return_status out VARCHAR2
239: , x_msg_count out NUMBER
240: , x_msg_data out VARCHAR2
241: , p6_a0 in out JTF_NUMBER_TABLE
242: , p6_a1 in out JTF_VARCHAR2_TABLE_300
243: , p6_a2 in out JTF_NUMBER_TABLE
244: , p6_a3 in out JTF_VARCHAR2_TABLE_100
245: );
246: end jtf_attachment_grp_w;