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.CSP_TRANSACTIONS_PUB_W

Source


1 package csp_transactions_pub_w AUTHID CURRENT_USER as
2   /* $Header: csptppws.pls 120.5.12020000.2 2012/07/20 10:08:00 rrajain ship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy csp_transactions_pub.trans_items_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_VARCHAR2_TABLE_100
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_VARCHAR2_TABLE_100
14     , a11 JTF_NUMBER_TABLE
15     , a12 JTF_VARCHAR2_TABLE_100
16     , a13 JTF_VARCHAR2_TABLE_100
17     , a14 JTF_VARCHAR2_TABLE_100
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_NUMBER_TABLE
20     , a17 JTF_NUMBER_TABLE
21     , a18 JTF_VARCHAR2_TABLE_2000
22     , a19 JTF_NUMBER_TABLE
23     , a20 JTF_NUMBER_TABLE
24     );
25   procedure rosetta_table_copy_out_p2(t csp_transactions_pub.trans_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
26     , a1 out nocopy JTF_VARCHAR2_TABLE_100
27     , a2 out nocopy JTF_NUMBER_TABLE
28     , a3 out nocopy JTF_VARCHAR2_TABLE_100
29     , a4 out nocopy JTF_VARCHAR2_TABLE_100
30     , a5 out nocopy JTF_VARCHAR2_TABLE_100
31     , a6 out nocopy JTF_NUMBER_TABLE
32     , a7 out nocopy JTF_VARCHAR2_TABLE_100
33     , a8 out nocopy JTF_NUMBER_TABLE
34     , a9 out nocopy JTF_NUMBER_TABLE
35     , a10 out nocopy JTF_VARCHAR2_TABLE_100
36     , a11 out nocopy JTF_NUMBER_TABLE
37     , a12 out nocopy JTF_VARCHAR2_TABLE_100
38     , a13 out nocopy JTF_VARCHAR2_TABLE_100
39     , a14 out nocopy JTF_VARCHAR2_TABLE_100
40     , a15 out nocopy JTF_VARCHAR2_TABLE_100
41     , a16 out nocopy JTF_NUMBER_TABLE
42     , a17 out nocopy JTF_NUMBER_TABLE
43     , a18 out nocopy JTF_VARCHAR2_TABLE_2000
44     , a19 out nocopy JTF_NUMBER_TABLE
45     , a20 out nocopy JTF_NUMBER_TABLE
46     );
47 
48   procedure rosetta_table_copy_in_p17(t out nocopy csp_transactions_pub.csparray, a0 JTF_NUMBER_TABLE);
49   procedure rosetta_table_copy_out_p17(t csp_transactions_pub.csparray, a0 out nocopy JTF_NUMBER_TABLE);
50 
51   procedure create_move_order_header(px_header_id in out nocopy  NUMBER
52     , p_request_number  VARCHAR2
53     , p_api_version  NUMBER
54     , p_init_msg_list  VARCHAR2
55     , p_commit  VARCHAR2
56     , p_date_required  date
57     , p_organization_id  NUMBER
58     , p_from_subinventory_code  VARCHAR2
59     , p_to_subinventory_code  VARCHAR2
60     , p_address1  VARCHAR2
61     , p_address2  VARCHAR2
62     , p_address3  VARCHAR2
63     , p_address4  VARCHAR2
64     , p_city  VARCHAR2
65     , p_postal_code  VARCHAR2
66     , p_state  VARCHAR2
67     , p_province  VARCHAR2
68     , p_country  VARCHAR2
69     , p_freight_carrier  VARCHAR2
70     , p_shipment_method  VARCHAR2
71     , p_autoreceipt_flag  VARCHAR2
72     , x_return_status out nocopy  VARCHAR2
73     , x_msg_count out nocopy  NUMBER
74     , x_msg_data out nocopy  VARCHAR2
75   );
76   procedure create_move_order_line(p_api_version  NUMBER
77     , p_init_msg_list  VARCHAR2
78     , p_commit  VARCHAR2
79     , px_line_id in out nocopy  NUMBER
80     , p_header_id  NUMBER
81     , p_organization_id  NUMBER
82     , p_from_subinventory_code  VARCHAR2
83     , p_from_locator_id  NUMBER
84     , p_inventory_item_id  NUMBER
85     , p_revision  VARCHAR2
86     , p_lot_number  VARCHAR2
87     , p_serial_number_start  VARCHAR2
88     , p_serial_number_end  VARCHAR2
89     , p_quantity  NUMBER
90     , p_uom_code  VARCHAR2
91     , p_quantity_delivered  NUMBER
92     , p_to_subinventory_code  VARCHAR2
93     , p_to_locator_id  VARCHAR2
94     , p_to_organization_id  NUMBER
95     , p_service_request  VARCHAR2
96     , p_task_id  NUMBER
97     , p_task_assignment_id  NUMBER
98     , p_customer_po  VARCHAR2
99     , p_date_required  date
100     , p_comments  VARCHAR2
101     , x_return_status out nocopy  VARCHAR2
102     , x_msg_count out nocopy  NUMBER
103     , x_msg_data out nocopy  VARCHAR2
104   );
105   procedure transact_material(p_api_version  NUMBER
106     , p_init_msg_list  VARCHAR2
107     , p_commit  VARCHAR2
108     , px_transaction_id in out nocopy  NUMBER
109     , px_transaction_header_id in out nocopy  NUMBER
110     , p_inventory_item_id  NUMBER
111     , p_organization_id  NUMBER
112     , p_subinventory_code  VARCHAR2
113     , p_locator_id  NUMBER
114     , p_lot_number  VARCHAR2
115     , p_lot_expiration_date  date
116     , p_revision  VARCHAR2
117     , p_serial_number  VARCHAR2
118     , p_to_serial_number  VARCHAR2
119     , p_quantity  NUMBER
120     , p_uom  VARCHAR2
121     , p_source_id  VARCHAR2
122     , p_source_line_id  NUMBER
123     , p_transaction_type_id  NUMBER
124     , p_account_id  NUMBER
125     , p_transfer_to_subinventory  VARCHAR2
126     , p_transfer_to_locator  NUMBER
127     , p_transfer_to_organization  NUMBER
128     , p_online_process_flag  number
129     , p_transaction_source_id  NUMBER
130     , p_trx_source_line_id  NUMBER
131     , p_transaction_source_name  VARCHAR2
132     , p_waybill_airbill  VARCHAR2
133     , p_shipment_number  VARCHAR2
134     , p_freight_code  VARCHAR2
135     , p_reason_id  NUMBER
136     , p_transaction_reference  VARCHAR2
137     , p_transaction_date  date
138     , p_expected_delivery_date  date
139     , p_final_completion_flag  VARCHAR2
140     , x_return_status out nocopy  VARCHAR2
141     , x_msg_count out nocopy  NUMBER
142     , x_msg_data out nocopy  VARCHAR2
143   );
144   procedure transact_temp_record(p_api_version_number  NUMBER
145     , p_init_msg_list  VARCHAR2
146     , p_commit  VARCHAR2
147     , p_validation_level  NUMBER
148     , p_transaction_temp_id  NUMBER
149     , px_transaction_header_id in out nocopy  NUMBER
150     , p_online_process_flag  number
151     , x_return_status out nocopy  VARCHAR2
152     , x_msg_count out nocopy  NUMBER
153     , x_msg_data out nocopy  VARCHAR2
154   );
155   procedure transact_items_transfer(p_api_version_number  NUMBER
156     , p_init_msg_list  VARCHAR2
157     , p_commit  VARCHAR2
158     , p3_a0 in out nocopy JTF_NUMBER_TABLE
159     , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
160     , p3_a2 in out nocopy JTF_NUMBER_TABLE
161     , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
162     , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_100
163     , p3_a5 in out nocopy JTF_VARCHAR2_TABLE_100
164     , p3_a6 in out nocopy JTF_NUMBER_TABLE
165     , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_100
166     , p3_a8 in out nocopy JTF_NUMBER_TABLE
167     , p3_a9 in out nocopy JTF_NUMBER_TABLE
168     , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
169     , p3_a11 in out nocopy JTF_NUMBER_TABLE
170     , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
171     , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
172     , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
173     , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
174     , p3_a16 in out nocopy JTF_NUMBER_TABLE
175     , p3_a17 in out nocopy JTF_NUMBER_TABLE
176     , p3_a18 in out nocopy JTF_VARCHAR2_TABLE_2000
177     , p3_a19 in out nocopy JTF_NUMBER_TABLE
178     , p3_a20 in out nocopy JTF_NUMBER_TABLE
179     , p_trans_type_id  NUMBER
180     , x_return_status out nocopy  VARCHAR2
181     , x_msg_count out nocopy  NUMBER
182     , x_msg_data out nocopy  VARCHAR2
183   );
184   procedure transact_subinv_transfer(p_api_version_number  NUMBER
185     , p_init_msg_list  VARCHAR2
186     , p_commit  VARCHAR2
187     , p3_a0 in out nocopy JTF_NUMBER_TABLE
188     , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
189     , p3_a2 in out nocopy JTF_NUMBER_TABLE
190     , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
191     , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_100
192     , p3_a5 in out nocopy JTF_VARCHAR2_TABLE_100
193     , p3_a6 in out nocopy JTF_NUMBER_TABLE
194     , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_100
195     , p3_a8 in out nocopy JTF_NUMBER_TABLE
196     , p3_a9 in out nocopy JTF_NUMBER_TABLE
197     , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
198     , p3_a11 in out nocopy JTF_NUMBER_TABLE
199     , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
200     , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
201     , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
202     , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
203     , p3_a16 in out nocopy JTF_NUMBER_TABLE
204     , p3_a17 in out nocopy JTF_NUMBER_TABLE
205     , p3_a18 in out nocopy JTF_VARCHAR2_TABLE_2000
206     , p3_a19 in out nocopy JTF_NUMBER_TABLE
207     , p3_a20 in out nocopy JTF_NUMBER_TABLE
208     , x_return_status out nocopy  VARCHAR2
209     , x_msg_count out nocopy  NUMBER
210     , x_msg_data out nocopy  VARCHAR2
211   );
212   procedure transact_intorg_transfer(p_api_version_number  NUMBER
213     , p_init_msg_list  VARCHAR2
214     , p_commit  VARCHAR2
215     , p3_a0 in out nocopy JTF_NUMBER_TABLE
216     , p3_a1 in out nocopy JTF_VARCHAR2_TABLE_100
217     , p3_a2 in out nocopy JTF_NUMBER_TABLE
218     , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
219     , p3_a4 in out nocopy JTF_VARCHAR2_TABLE_100
220     , p3_a5 in out nocopy JTF_VARCHAR2_TABLE_100
221     , p3_a6 in out nocopy JTF_NUMBER_TABLE
222     , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_100
223     , p3_a8 in out nocopy JTF_NUMBER_TABLE
224     , p3_a9 in out nocopy JTF_NUMBER_TABLE
225     , p3_a10 in out nocopy JTF_VARCHAR2_TABLE_100
226     , p3_a11 in out nocopy JTF_NUMBER_TABLE
227     , p3_a12 in out nocopy JTF_VARCHAR2_TABLE_100
228     , p3_a13 in out nocopy JTF_VARCHAR2_TABLE_100
229     , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
230     , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
231     , p3_a16 in out nocopy JTF_NUMBER_TABLE
232     , p3_a17 in out nocopy JTF_NUMBER_TABLE
233     , p3_a18 in out nocopy JTF_VARCHAR2_TABLE_2000
234     , p3_a19 in out nocopy JTF_NUMBER_TABLE
235     , p3_a20 in out nocopy JTF_NUMBER_TABLE
236     , p_if_intransit  number
237     , x_return_status out nocopy  VARCHAR2
238     , x_msg_count out nocopy  NUMBER
239     , x_msg_data out nocopy  VARCHAR2
240   );
241   procedure create_move_order(p0_a0 in out nocopy JTF_NUMBER_TABLE
242     , p0_a1 in out nocopy JTF_VARCHAR2_TABLE_100
243     , p0_a2 in out nocopy JTF_NUMBER_TABLE
244     , p0_a3 in out nocopy JTF_VARCHAR2_TABLE_100
245     , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
246     , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
247     , p0_a6 in out nocopy JTF_NUMBER_TABLE
248     , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
249     , p0_a8 in out nocopy JTF_NUMBER_TABLE
250     , p0_a9 in out nocopy JTF_NUMBER_TABLE
251     , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
252     , p0_a11 in out nocopy JTF_NUMBER_TABLE
253     , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
254     , p0_a13 in out nocopy JTF_VARCHAR2_TABLE_100
255     , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
256     , p0_a15 in out nocopy JTF_VARCHAR2_TABLE_100
257     , p0_a16 in out nocopy JTF_NUMBER_TABLE
258     , p0_a17 in out nocopy JTF_NUMBER_TABLE
259     , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_2000
260     , p0_a19 in out nocopy JTF_NUMBER_TABLE
261     , p0_a20 in out nocopy JTF_NUMBER_TABLE
262     , p_date_required  date
263     , p_comments  VARCHAR2
264     , x_move_order_number out nocopy  VARCHAR2
265     , x_return_status out nocopy  VARCHAR2
266     , x_msg_count out nocopy  NUMBER
267     , x_msg_data out nocopy  VARCHAR2
268   );
269   procedure receive_requirement_trans(p_trans_header_id  NUMBER
270     , p_trans_line_id  NUMBER
271     , p2_a0  NUMBER
272     , p2_a1  VARCHAR2
273     , p2_a2  NUMBER
274     , p2_a3  VARCHAR2
275     , p2_a4  VARCHAR2
276     , p2_a5  VARCHAR2
277     , p2_a6  NUMBER
278     , p2_a7  VARCHAR2
279     , p2_a8  NUMBER
280     , p2_a9  NUMBER
281     , p2_a10  VARCHAR2
282     , p2_a11  NUMBER
283     , p2_a12  VARCHAR2
284     , p2_a13  VARCHAR2
285     , p2_a14  VARCHAR2
286     , p2_a15  VARCHAR2
287     , p2_a16  NUMBER
288     , p2_a17  NUMBER
289     , p2_a18  VARCHAR2
290     , p2_a19  NUMBER
291     , p2_a20  NUMBER
292     , p_trans_type  VARCHAR2
293     , p_req_line_detail_id  NUMBER
294     , p_close_short  VARCHAR2
295     , x_return_status out nocopy  VARCHAR2
296     , x_msg_count out nocopy  NUMBER
297     , x_msg_data out nocopy  VARCHAR2
298   );
299 end csp_transactions_pub_w;