eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
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;