[Home] [Help]
PACKAGE: APPS.INV_TRANSACTION_FLOW_PUB_W
Source
1 package inv_transaction_flow_pub_w AUTHID CURRENT_USER as
2 /* $Header: INVWICTS.pls 115.1 2003/12/18 16:12:23 sthamman noship $ */
3 procedure rosetta_table_copy_in_p9(t out nocopy inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_DATE_TABLE
15 , a12 JTF_DATE_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_NUMBER_TABLE
18 , a15 JTF_NUMBER_TABLE
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_NUMBER_TABLE
21 , a18 JTF_NUMBER_TABLE
22 , a19 JTF_NUMBER_TABLE
23 , a20 JTF_NUMBER_TABLE
24 , a21 JTF_NUMBER_TABLE
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_VARCHAR2_TABLE_100
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_NUMBER_TABLE
29 );
30 procedure rosetta_table_copy_out_p9(t inv_transaction_flow_pub.g_transaction_flow_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31 , a1 out nocopy JTF_NUMBER_TABLE
32 , a2 out nocopy JTF_NUMBER_TABLE
33 , a3 out nocopy JTF_NUMBER_TABLE
34 , a4 out nocopy JTF_NUMBER_TABLE
35 , a5 out nocopy JTF_NUMBER_TABLE
36 , a6 out nocopy JTF_NUMBER_TABLE
37 , a7 out nocopy JTF_NUMBER_TABLE
38 , a8 out nocopy JTF_NUMBER_TABLE
39 , a9 out nocopy JTF_NUMBER_TABLE
40 , a10 out nocopy JTF_NUMBER_TABLE
41 , a11 out nocopy JTF_DATE_TABLE
42 , a12 out nocopy JTF_DATE_TABLE
43 , a13 out nocopy JTF_NUMBER_TABLE
44 , a14 out nocopy JTF_NUMBER_TABLE
45 , a15 out nocopy JTF_NUMBER_TABLE
46 , a16 out nocopy JTF_NUMBER_TABLE
47 , a17 out nocopy JTF_NUMBER_TABLE
48 , a18 out nocopy JTF_NUMBER_TABLE
49 , a19 out nocopy JTF_NUMBER_TABLE
50 , a20 out nocopy JTF_NUMBER_TABLE
51 , a21 out nocopy JTF_NUMBER_TABLE
52 , a22 out nocopy JTF_NUMBER_TABLE
53 , a23 out nocopy JTF_VARCHAR2_TABLE_100
54 , a24 out nocopy JTF_NUMBER_TABLE
55 , a25 out nocopy JTF_NUMBER_TABLE
56 );
57
58 procedure rosetta_table_copy_in_p10(t out nocopy inv_transaction_flow_pub.number_tbl, a0 JTF_NUMBER_TABLE);
59 procedure rosetta_table_copy_out_p10(t inv_transaction_flow_pub.number_tbl, a0 out nocopy JTF_NUMBER_TABLE);
60
61 procedure rosetta_table_copy_in_p11(t out nocopy inv_transaction_flow_pub.varchar2_tbl, a0 JTF_VARCHAR2_TABLE_200);
62 procedure rosetta_table_copy_out_p11(t inv_transaction_flow_pub.varchar2_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_200);
63
64 procedure get_transaction_flow(x_return_status out nocopy VARCHAR2
65 , x_msg_data out nocopy VARCHAR2
66 , x_msg_count out nocopy NUMBER
67 , p3_a0 out nocopy JTF_NUMBER_TABLE
68 , p3_a1 out nocopy JTF_NUMBER_TABLE
69 , p3_a2 out nocopy JTF_NUMBER_TABLE
70 , p3_a3 out nocopy JTF_NUMBER_TABLE
71 , p3_a4 out nocopy JTF_NUMBER_TABLE
72 , p3_a5 out nocopy JTF_NUMBER_TABLE
73 , p3_a6 out nocopy JTF_NUMBER_TABLE
74 , p3_a7 out nocopy JTF_NUMBER_TABLE
75 , p3_a8 out nocopy JTF_NUMBER_TABLE
76 , p3_a9 out nocopy JTF_NUMBER_TABLE
77 , p3_a10 out nocopy JTF_NUMBER_TABLE
78 , p3_a11 out nocopy JTF_DATE_TABLE
79 , p3_a12 out nocopy JTF_DATE_TABLE
80 , p3_a13 out nocopy JTF_NUMBER_TABLE
81 , p3_a14 out nocopy JTF_NUMBER_TABLE
82 , p3_a15 out nocopy JTF_NUMBER_TABLE
83 , p3_a16 out nocopy JTF_NUMBER_TABLE
84 , p3_a17 out nocopy JTF_NUMBER_TABLE
85 , p3_a18 out nocopy JTF_NUMBER_TABLE
86 , p3_a19 out nocopy JTF_NUMBER_TABLE
87 , p3_a20 out nocopy JTF_NUMBER_TABLE
88 , p3_a21 out nocopy JTF_NUMBER_TABLE
89 , p3_a22 out nocopy JTF_NUMBER_TABLE
90 , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
91 , p3_a24 out nocopy JTF_NUMBER_TABLE
92 , p3_a25 out nocopy JTF_NUMBER_TABLE
93 , p_api_version NUMBER
94 , p_init_msg_list VARCHAR2
95 , p_start_operating_unit NUMBER
96 , p_end_operating_unit NUMBER
97 , p_flow_type NUMBER
98 , p_organization_id NUMBER
99 , p_qualifier_code_tbl JTF_NUMBER_TABLE
100 , p_qualifier_value_tbl JTF_NUMBER_TABLE
101 , p_transaction_date DATE
102 , p_get_default_cost_group VARCHAR2
103 );
104 procedure get_transaction_flow(x_return_status out nocopy VARCHAR2
105 , x_msg_data out nocopy VARCHAR2
106 , x_msg_count out nocopy NUMBER
107 , p3_a0 out nocopy JTF_NUMBER_TABLE
108 , p3_a1 out nocopy JTF_NUMBER_TABLE
109 , p3_a2 out nocopy JTF_NUMBER_TABLE
110 , p3_a3 out nocopy JTF_NUMBER_TABLE
111 , p3_a4 out nocopy JTF_NUMBER_TABLE
112 , p3_a5 out nocopy JTF_NUMBER_TABLE
113 , p3_a6 out nocopy JTF_NUMBER_TABLE
114 , p3_a7 out nocopy JTF_NUMBER_TABLE
115 , p3_a8 out nocopy JTF_NUMBER_TABLE
116 , p3_a9 out nocopy JTF_NUMBER_TABLE
117 , p3_a10 out nocopy JTF_NUMBER_TABLE
118 , p3_a11 out nocopy JTF_DATE_TABLE
119 , p3_a12 out nocopy JTF_DATE_TABLE
120 , p3_a13 out nocopy JTF_NUMBER_TABLE
121 , p3_a14 out nocopy JTF_NUMBER_TABLE
122 , p3_a15 out nocopy JTF_NUMBER_TABLE
123 , p3_a16 out nocopy JTF_NUMBER_TABLE
124 , p3_a17 out nocopy JTF_NUMBER_TABLE
125 , p3_a18 out nocopy JTF_NUMBER_TABLE
126 , p3_a19 out nocopy JTF_NUMBER_TABLE
127 , p3_a20 out nocopy JTF_NUMBER_TABLE
128 , p3_a21 out nocopy JTF_NUMBER_TABLE
129 , p3_a22 out nocopy JTF_NUMBER_TABLE
130 , p3_a23 out nocopy JTF_VARCHAR2_TABLE_100
131 , p3_a24 out nocopy JTF_NUMBER_TABLE
132 , p3_a25 out nocopy JTF_NUMBER_TABLE
133 , p_api_version NUMBER
134 , p_init_msg_list VARCHAR2
135 , p_header_id NUMBER
136 , p_get_default_cost_group VARCHAR2
137 );
138 procedure check_transaction_flow(p_api_version NUMBER
139 , p_init_msg_list VARCHAR2
140 , p_start_operating_unit NUMBER
141 , p_end_operating_unit NUMBER
142 , p_flow_type NUMBER
143 , p_organization_id NUMBER
144 , p_qualifier_code_tbl JTF_NUMBER_TABLE
145 , p_qualifier_value_tbl JTF_NUMBER_TABLE
146 , p_transaction_date DATE
147 , x_return_status out nocopy VARCHAR2
148 , x_msg_count out nocopy NUMBER
149 , x_msg_data out nocopy VARCHAR2
150 , x_header_id out nocopy NUMBER
151 , x_new_accounting_flag out nocopy VARCHAR2
152 , x_transaction_flow_exists out nocopy VARCHAR2
153 );
154 procedure create_transaction_flow(x_return_status out nocopy VARCHAR2
155 , x_msg_data out nocopy VARCHAR2
156 , x_msg_count out nocopy NUMBER
157 , x_header_id out nocopy NUMBER
158 , x_line_number_tbl out nocopy JTF_NUMBER_TABLE
159 , p_api_version NUMBER
160 , p_init_msg_list VARCHAR2
161 , p_validation_level NUMBER
162 , p_start_org_id NUMBER
163 , p_end_org_id NUMBER
164 , p_flow_type NUMBER
165 , p_organization_id NUMBER
166 , p_qualifier_code NUMBER
167 , p_qualifier_value_id NUMBER
168 , p_asset_item_pricing_option NUMBER
169 , p_expense_item_pricing_option NUMBER
170 , p_new_accounting_flag VARCHAR2
171 , p_start_date DATE
172 , p_end_date DATE
173 , p_attribute_category VARCHAR2
174 , p_attribute1 VARCHAR2
175 , p_attribute2 VARCHAR2
176 , p_attribute3 VARCHAR2
177 , p_attribute4 VARCHAR2
178 , p_attribute5 VARCHAR2
179 , p_attribute6 VARCHAR2
180 , p_attribute7 VARCHAR2
181 , p_attribute8 VARCHAR2
182 , p_attribute9 VARCHAR2
183 , p_attribute10 VARCHAR2
184 , p_attribute11 VARCHAR2
185 , p_attribute12 VARCHAR2
186 , p_attribute13 VARCHAR2
187 , p_attribute14 VARCHAR2
188 , p_attribute15 VARCHAR2
189 , p_line_number_tbl JTF_NUMBER_TABLE
190 , p_from_org_id_tbl JTF_NUMBER_TABLE
191 , p_from_organization_id_tbl JTF_NUMBER_TABLE
192 , p_to_org_id_tbl JTF_NUMBER_TABLE
193 , p_to_organization_id_tbl JTF_NUMBER_TABLE
194 , p_line_attribute_category_tbl JTF_VARCHAR2_TABLE_200
195 , p_line_attribute1_tbl JTF_VARCHAR2_TABLE_200
196 , p_line_attribute2_tbl JTF_VARCHAR2_TABLE_200
197 , p_line_attribute3_tbl JTF_VARCHAR2_TABLE_200
198 , p_line_attribute4_tbl JTF_VARCHAR2_TABLE_200
199 , p_line_attribute5_tbl JTF_VARCHAR2_TABLE_200
200 , p_line_attribute6_tbl JTF_VARCHAR2_TABLE_200
201 , p_line_attribute7_tbl JTF_VARCHAR2_TABLE_200
202 , p_line_attribute8_tbl JTF_VARCHAR2_TABLE_200
203 , p_line_attribute9_tbl JTF_VARCHAR2_TABLE_200
204 , p_line_attribute10_tbl JTF_VARCHAR2_TABLE_200
205 , p_line_attribute11_tbl JTF_VARCHAR2_TABLE_200
206 , p_line_attribute12_tbl JTF_VARCHAR2_TABLE_200
207 , p_line_attribute13_tbl JTF_VARCHAR2_TABLE_200
208 , p_line_attribute14_tbl JTF_VARCHAR2_TABLE_200
209 , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
210 , p_ship_organization_id_tbl JTF_NUMBER_TABLE
211 , p_sell_organization_id_tbl JTF_NUMBER_TABLE
212 , p_vendor_id_tbl JTF_NUMBER_TABLE
213 , p_vendor_site_id_tbl JTF_NUMBER_TABLE
214 , p_customer_id_tbl JTF_NUMBER_TABLE
215 , p_address_id_tbl JTF_NUMBER_TABLE
216 , p_customer_site_id_tbl JTF_NUMBER_TABLE
217 , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
218 , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
219 , p_ic_attribute1_tbl JTF_VARCHAR2_TABLE_200
220 , p_ic_attribute2_tbl JTF_VARCHAR2_TABLE_200
221 , p_ic_attribute3_tbl JTF_VARCHAR2_TABLE_200
222 , p_ic_attribute4_tbl JTF_VARCHAR2_TABLE_200
223 , p_ic_attribute5_tbl JTF_VARCHAR2_TABLE_200
224 , p_ic_attribute6_tbl JTF_VARCHAR2_TABLE_200
225 , p_ic_attribute7_tbl JTF_VARCHAR2_TABLE_200
226 , p_ic_attribute8_tbl JTF_VARCHAR2_TABLE_200
227 , p_ic_attribute9_tbl JTF_VARCHAR2_TABLE_200
228 , p_ic_attribute10_tbl JTF_VARCHAR2_TABLE_200
229 , p_ic_attribute11_tbl JTF_VARCHAR2_TABLE_200
230 , p_ic_attribute12_tbl JTF_VARCHAR2_TABLE_200
231 , p_ic_attribute13_tbl JTF_VARCHAR2_TABLE_200
232 , p_ic_attribute14_tbl JTF_VARCHAR2_TABLE_200
233 , p_ic_attribute15_tbl JTF_VARCHAR2_TABLE_200
234 , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
235 , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
236 , p_inv_currency_code_tbl JTF_NUMBER_TABLE
237 , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
238 , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
239 , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
240 );
241 procedure update_transaction_flow(x_return_status out nocopy VARCHAR2
242 , x_msg_data out nocopy VARCHAR2
243 , x_msg_count out nocopy NUMBER
244 , p_api_version NUMBER
245 , p_init_msg_list VARCHAR2
246 , p_validation_level NUMBER
247 , p_header_id NUMBER
248 , p_flow_type NUMBER
249 , p_start_date DATE
250 , p_end_date DATE
251 , p_attribute_category VARCHAR2
252 , p_attribute1 VARCHAR2
253 , p_attribute2 VARCHAR2
254 , p_attribute3 VARCHAR2
255 , p_attribute4 VARCHAR2
256 , p_attribute5 VARCHAR2
257 , p_attribute6 VARCHAR2
258 , p_attribute7 VARCHAR2
259 , p_attribute8 VARCHAR2
260 , p_attribute9 VARCHAR2
261 , p_attribute10 VARCHAR2
262 , p_attribute11 VARCHAR2
263 , p_attribute12 VARCHAR2
264 , p_attribute13 VARCHAR2
265 , p_attribute14 VARCHAR2
266 , p_attribute15 VARCHAR2
267 , p_line_number_tbl JTF_NUMBER_TABLE
268 , p_line_attribute_category_tbl JTF_VARCHAR2_TABLE_200
269 , p_line_attribute1_tbl JTF_VARCHAR2_TABLE_200
270 , p_line_attribute2_tbl JTF_VARCHAR2_TABLE_200
271 , p_line_attribute3_tbl JTF_VARCHAR2_TABLE_200
272 , p_line_attribute4_tbl JTF_VARCHAR2_TABLE_200
273 , p_line_attribute5_tbl JTF_VARCHAR2_TABLE_200
274 , p_line_attribute6_tbl JTF_VARCHAR2_TABLE_200
275 , p_line_attribute7_tbl JTF_VARCHAR2_TABLE_200
276 , p_line_attribute8_tbl JTF_VARCHAR2_TABLE_200
277 , p_line_attribute9_tbl JTF_VARCHAR2_TABLE_200
278 , p_line_attribute10_tbl JTF_VARCHAR2_TABLE_200
279 , p_line_attribute11_tbl JTF_VARCHAR2_TABLE_200
280 , p_line_attribute12_tbl JTF_VARCHAR2_TABLE_200
281 , p_line_attribute13_tbl JTF_VARCHAR2_TABLE_200
282 , p_line_attribute14_tbl JTF_VARCHAR2_TABLE_200
283 , p_line_attribute15_tbl JTF_VARCHAR2_TABLE_200
284 , p_ship_organization_id_tbl JTF_NUMBER_TABLE
285 , p_sell_organization_id_tbl JTF_NUMBER_TABLE
286 , p_vendor_id_tbl JTF_NUMBER_TABLE
287 , p_vendor_site_id_tbl JTF_NUMBER_TABLE
288 , p_customer_id_tbl JTF_NUMBER_TABLE
289 , p_address_id_tbl JTF_NUMBER_TABLE
290 , p_customer_site_id_tbl JTF_NUMBER_TABLE
291 , p_cust_trx_type_id_tbl JTF_NUMBER_TABLE
292 , p_ic_attribute_category_tbl JTF_VARCHAR2_TABLE_200
293 , p_ic_attribute1_tbl JTF_VARCHAR2_TABLE_200
294 , p_ic_attribute2_tbl JTF_VARCHAR2_TABLE_200
295 , p_ic_attribute3_tbl JTF_VARCHAR2_TABLE_200
296 , p_ic_attribute4_tbl JTF_VARCHAR2_TABLE_200
297 , p_ic_attribute5_tbl JTF_VARCHAR2_TABLE_200
298 , p_ic_attribute6_tbl JTF_VARCHAR2_TABLE_200
299 , p_ic_attribute7_tbl JTF_VARCHAR2_TABLE_200
300 , p_ic_attribute8_tbl JTF_VARCHAR2_TABLE_200
301 , p_ic_attribute9_tbl JTF_VARCHAR2_TABLE_200
302 , p_ic_attribute10_tbl JTF_VARCHAR2_TABLE_200
303 , p_ic_attribute11_tbl JTF_VARCHAR2_TABLE_200
304 , p_ic_attribute12_tbl JTF_VARCHAR2_TABLE_200
305 , p_ic_attribute13_tbl JTF_VARCHAR2_TABLE_200
306 , p_ic_attribute14_tbl JTF_VARCHAR2_TABLE_200
307 , p_ic_attribute15_tbl JTF_VARCHAR2_TABLE_200
308 , p_revalue_average_flag_tbl JTF_VARCHAR2_TABLE_200
309 , p_freight_code_comb_id_tbl JTF_NUMBER_TABLE
310 , p_inv_currency_code_tbl JTF_NUMBER_TABLE
311 , p_ic_cogs_acct_id_tbl JTF_NUMBER_TABLE
312 , p_inv_accrual_acct_id_tbl JTF_NUMBER_TABLE
313 , p_exp_accrual_acct_id_tbl JTF_NUMBER_TABLE
314 );
315 end inv_transaction_flow_pub_w;