1: package ibe_attachment_grp_w AUTHID CURRENT_USER as
2: /* $Header: IBEGRATS.pls 115.2 2002/12/18 07:07:13 schak ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ibe_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
1: package ibe_attachment_grp_w AUTHID CURRENT_USER as
2: /* $Header: IBEGRATS.pls 115.2 2002/12/18 07:07:13 schak ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ibe_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
2: /* $Header: IBEGRATS.pls 115.2 2002/12/18 07:07:13 schak ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ibe_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
10: , a7 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
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
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
18: , a15 JTF_VARCHAR2_TABLE_2000
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
18: , a15 JTF_VARCHAR2_TABLE_2000
19: , a16 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_2000
19: , a16 JTF_VARCHAR2_TABLE_100
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
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
29: , a26 JTF_VARCHAR2_TABLE_200
30: , a27 JTF_VARCHAR2_TABLE_200
45: , a42 JTF_VARCHAR2_TABLE_1000
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p1(t ibe_attachment_grp.attachment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_VARCHAR2_TABLE_300
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p1(t ibe_attachment_grp.attachment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_VARCHAR2_TABLE_300
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_100
54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p1(t ibe_attachment_grp.attachment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_NUMBER_TABLE
51: , a2 out nocopy JTF_VARCHAR2_TABLE_300
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_100
54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
55: , a6 out nocopy JTF_VARCHAR2_TABLE_100
56: , a7 out nocopy JTF_VARCHAR2_TABLE_100
53: , a4 out nocopy JTF_VARCHAR2_TABLE_100
54: , a5 out nocopy JTF_VARCHAR2_TABLE_100
55: , a6 out nocopy JTF_VARCHAR2_TABLE_100
56: , a7 out nocopy JTF_VARCHAR2_TABLE_100
57: , a8 out nocopy JTF_NUMBER_TABLE
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100
59: , a10 out nocopy JTF_VARCHAR2_TABLE_300
60: , a11 out nocopy JTF_NUMBER_TABLE
61: , a12 out nocopy JTF_NUMBER_TABLE
56: , a7 out nocopy JTF_VARCHAR2_TABLE_100
57: , a8 out nocopy JTF_NUMBER_TABLE
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100
59: , a10 out nocopy JTF_VARCHAR2_TABLE_300
60: , a11 out nocopy JTF_NUMBER_TABLE
61: , a12 out nocopy JTF_NUMBER_TABLE
62: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
63: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
57: , a8 out nocopy JTF_NUMBER_TABLE
58: , a9 out nocopy JTF_VARCHAR2_TABLE_100
59: , a10 out nocopy JTF_VARCHAR2_TABLE_300
60: , a11 out nocopy JTF_NUMBER_TABLE
61: , a12 out nocopy JTF_NUMBER_TABLE
62: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
63: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
65: , a16 out nocopy JTF_VARCHAR2_TABLE_100
64: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
65: , a16 out nocopy JTF_VARCHAR2_TABLE_100
66: , a17 out nocopy JTF_VARCHAR2_TABLE_100
67: , a18 out nocopy JTF_VARCHAR2_TABLE_100
68: , a19 out nocopy JTF_NUMBER_TABLE
69: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
70: , a21 out nocopy JTF_VARCHAR2_TABLE_300
71: , a22 out nocopy JTF_VARCHAR2_TABLE_1100
72: , a23 out nocopy JTF_NUMBER_TABLE
68: , a19 out nocopy JTF_NUMBER_TABLE
69: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
70: , a21 out nocopy JTF_VARCHAR2_TABLE_300
71: , a22 out nocopy JTF_VARCHAR2_TABLE_1100
72: , a23 out nocopy JTF_NUMBER_TABLE
73: , a24 out nocopy JTF_VARCHAR2_TABLE_300
74: , a25 out nocopy JTF_VARCHAR2_TABLE_100
75: , a26 out nocopy JTF_VARCHAR2_TABLE_200
76: , a27 out nocopy JTF_VARCHAR2_TABLE_200
92: , a43 out nocopy JTF_VARCHAR2_TABLE_100
93: , a44 out nocopy JTF_VARCHAR2_TABLE_100
94: );
95:
96: procedure rosetta_table_copy_in_p3(t out nocopy ibe_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
97: , a1 JTF_VARCHAR2_TABLE_300
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_100
100: );
94: );
95:
96: procedure rosetta_table_copy_in_p3(t out nocopy ibe_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
97: , a1 JTF_VARCHAR2_TABLE_300
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_100
100: );
101: procedure rosetta_table_copy_out_p3(t ibe_attachment_grp.ath_id_ver_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_300
97: , a1 JTF_VARCHAR2_TABLE_300
98: , a2 JTF_NUMBER_TABLE
99: , a3 JTF_VARCHAR2_TABLE_100
100: );
101: procedure rosetta_table_copy_out_p3(t ibe_attachment_grp.ath_id_ver_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_300
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_VARCHAR2_TABLE_100
105: );
99: , a3 JTF_VARCHAR2_TABLE_100
100: );
101: procedure rosetta_table_copy_out_p3(t ibe_attachment_grp.ath_id_ver_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_VARCHAR2_TABLE_300
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_VARCHAR2_TABLE_100
105: );
106:
107: procedure rosetta_table_copy_in_p4(t out nocopy ibe_attachment_grp.number_table, a0 JTF_NUMBER_TABLE);
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_VARCHAR2_TABLE_100
105: );
106:
107: procedure rosetta_table_copy_in_p4(t out nocopy ibe_attachment_grp.number_table, a0 JTF_NUMBER_TABLE);
108: procedure rosetta_table_copy_out_p4(t ibe_attachment_grp.number_table, a0 out nocopy JTF_NUMBER_TABLE);
109:
110: procedure rosetta_table_copy_in_p5(t out nocopy ibe_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300);
111: procedure rosetta_table_copy_out_p5(t ibe_attachment_grp.varchar2_table_300, a0 out nocopy JTF_VARCHAR2_TABLE_300);
104: , a3 out nocopy JTF_VARCHAR2_TABLE_100
105: );
106:
107: procedure rosetta_table_copy_in_p4(t out nocopy ibe_attachment_grp.number_table, a0 JTF_NUMBER_TABLE);
108: procedure rosetta_table_copy_out_p4(t ibe_attachment_grp.number_table, a0 out nocopy JTF_NUMBER_TABLE);
109:
110: procedure rosetta_table_copy_in_p5(t out nocopy ibe_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300);
111: procedure rosetta_table_copy_out_p5(t ibe_attachment_grp.varchar2_table_300, a0 out nocopy JTF_VARCHAR2_TABLE_300);
112:
122: , p_deliverable_id NUMBER
123: , p_start_id NUMBER
124: , p_batch_size NUMBER
125: , x_row_count out nocopy NUMBER
126: , x_ath_id_tbl out nocopy JTF_NUMBER_TABLE
127: , x_dlv_id_tbl out nocopy JTF_NUMBER_TABLE
128: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
129: , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
130: , x_file_ext_tbl out nocopy JTF_VARCHAR2_TABLE_100
123: , p_start_id NUMBER
124: , p_batch_size NUMBER
125: , x_row_count out nocopy NUMBER
126: , x_ath_id_tbl out nocopy JTF_NUMBER_TABLE
127: , x_dlv_id_tbl out nocopy JTF_NUMBER_TABLE
128: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
129: , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
130: , x_file_ext_tbl out nocopy JTF_VARCHAR2_TABLE_100
131: , x_dsp_width_tbl out nocopy JTF_NUMBER_TABLE
125: , x_row_count out nocopy NUMBER
126: , x_ath_id_tbl out nocopy JTF_NUMBER_TABLE
127: , x_dlv_id_tbl out nocopy JTF_NUMBER_TABLE
128: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
129: , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
130: , x_file_ext_tbl out nocopy JTF_VARCHAR2_TABLE_100
131: , x_dsp_width_tbl out nocopy JTF_NUMBER_TABLE
132: , x_dsp_height_tbl out nocopy JTF_NUMBER_TABLE
133: , x_version_tbl out nocopy JTF_NUMBER_TABLE
127: , x_dlv_id_tbl out nocopy JTF_NUMBER_TABLE
128: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
129: , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
130: , x_file_ext_tbl out nocopy JTF_VARCHAR2_TABLE_100
131: , x_dsp_width_tbl out nocopy JTF_NUMBER_TABLE
132: , x_dsp_height_tbl out nocopy JTF_NUMBER_TABLE
133: , x_version_tbl out nocopy JTF_NUMBER_TABLE
134: );
135: procedure save_attachment(p_api_version NUMBER
128: , x_file_name_tbl out nocopy JTF_VARCHAR2_TABLE_300
129: , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
130: , x_file_ext_tbl out nocopy JTF_VARCHAR2_TABLE_100
131: , x_dsp_width_tbl out nocopy JTF_NUMBER_TABLE
132: , x_dsp_height_tbl out nocopy JTF_NUMBER_TABLE
133: , x_version_tbl out nocopy JTF_NUMBER_TABLE
134: );
135: procedure save_attachment(p_api_version NUMBER
136: , p_init_msg_list VARCHAR2
129: , x_file_id_tbl out nocopy JTF_NUMBER_TABLE
130: , x_file_ext_tbl out nocopy JTF_VARCHAR2_TABLE_100
131: , x_dsp_width_tbl out nocopy JTF_NUMBER_TABLE
132: , x_dsp_height_tbl out nocopy JTF_NUMBER_TABLE
133: , x_version_tbl out nocopy JTF_NUMBER_TABLE
134: );
135: procedure save_attachment(p_api_version NUMBER
136: , p_init_msg_list VARCHAR2
137: , p_commit VARCHAR2
189: , p_commit VARCHAR2
190: , x_return_status out nocopy VARCHAR2
191: , x_msg_count out nocopy NUMBER
192: , x_msg_data out nocopy VARCHAR2
193: , p6_a0 in out nocopy JTF_NUMBER_TABLE
194: , p6_a1 in out nocopy JTF_NUMBER_TABLE
195: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300
196: , p6_a3 in out nocopy JTF_NUMBER_TABLE
197: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
190: , x_return_status out nocopy VARCHAR2
191: , x_msg_count out nocopy NUMBER
192: , x_msg_data out nocopy VARCHAR2
193: , p6_a0 in out nocopy JTF_NUMBER_TABLE
194: , p6_a1 in out nocopy JTF_NUMBER_TABLE
195: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300
196: , p6_a3 in out nocopy JTF_NUMBER_TABLE
197: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
192: , x_msg_data out nocopy VARCHAR2
193: , p6_a0 in out nocopy JTF_NUMBER_TABLE
194: , p6_a1 in out nocopy JTF_NUMBER_TABLE
195: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_300
196: , p6_a3 in out nocopy JTF_NUMBER_TABLE
197: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
199: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
200: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
197: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
199: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
200: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p6_a8 in out nocopy JTF_NUMBER_TABLE
202: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100
203: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300
204: , p6_a11 in out nocopy JTF_NUMBER_TABLE
205: , p6_a12 in out nocopy JTF_NUMBER_TABLE
200: , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p6_a8 in out nocopy JTF_NUMBER_TABLE
202: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100
203: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300
204: , p6_a11 in out nocopy JTF_NUMBER_TABLE
205: , p6_a12 in out nocopy JTF_NUMBER_TABLE
206: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_2000
207: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_2000
208: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_2000
201: , p6_a8 in out nocopy JTF_NUMBER_TABLE
202: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_100
203: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_300
204: , p6_a11 in out nocopy JTF_NUMBER_TABLE
205: , p6_a12 in out nocopy JTF_NUMBER_TABLE
206: , p6_a13 in out nocopy JTF_VARCHAR2_TABLE_2000
207: , p6_a14 in out nocopy JTF_VARCHAR2_TABLE_2000
208: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_2000
209: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
208: , p6_a15 in out nocopy JTF_VARCHAR2_TABLE_2000
209: , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_100
211: , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_100
212: , p6_a19 in out nocopy JTF_NUMBER_TABLE
213: , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_2000
214: , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_300
215: , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_1100
216: , p6_a23 in out nocopy JTF_NUMBER_TABLE
212: , p6_a19 in out nocopy JTF_NUMBER_TABLE
213: , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_2000
214: , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_300
215: , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_1100
216: , p6_a23 in out nocopy JTF_NUMBER_TABLE
217: , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_300
218: , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_100
219: , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_200
220: , p6_a27 in out nocopy JTF_VARCHAR2_TABLE_200
241: , p_commit VARCHAR2
242: , x_return_status out nocopy VARCHAR2
243: , x_msg_count out nocopy NUMBER
244: , x_msg_data out nocopy VARCHAR2
245: , p6_a0 in out nocopy JTF_NUMBER_TABLE
246: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_300
247: , p6_a2 in out nocopy JTF_NUMBER_TABLE
248: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
249: );
243: , x_msg_count out nocopy NUMBER
244: , x_msg_data out nocopy VARCHAR2
245: , p6_a0 in out nocopy JTF_NUMBER_TABLE
246: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_300
247: , p6_a2 in out nocopy JTF_NUMBER_TABLE
248: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
249: );
250: end ibe_attachment_grp_w;