1 PACKAGE arp_clas_pkg AS
2 /* $Header: AROCLASS.pls 120.3.12010000.2 2008/11/19 11:38:55 ankuagar ship $ */
3
4 PROCEDURE check_unique_inv_location ( p_inventory_location_id in number,
5 x_return_status out nocopy varchar2,
6 x_msg_count out nocopy number,
7 x_msg_data out nocopy varchar2,
8 l_org_id in number
9 );
10
11 procedure insert_po_loc_associations ( p_inventory_location_id in number,
12 p_inventory_organization_id in number,
13 p_customer_id in number,
14 p_address_id in number,
15 p_site_use_id in number,
16 x_return_status out nocopy varchar2,
17 x_msg_count out nocopy number,
18 x_msg_data out nocopy varchar2
19 );
20
21
22 procedure update_po_loc_associations ( p_site_use_id in number,
23 p_address_id in number,
24 p_customer_id in number,
25 p_inventory_organization_id in number,
26 p_inventory_location_id in number,
27 x_return_status out nocopy varchar2,
28 x_msg_count out nocopy number,
29 x_msg_data out nocopy varchar2
30 );
31
32 PROCEDURE check_unique_inv_location ( p_inventory_location_id in number );
33
34 procedure insert_po_loc_associations ( p_inventory_location_id in number,
35 p_inventory_organization_id in number,
36 p_customer_id in number,
37 p_address_id in number,
38 p_site_use_id in number
39 );
40
41 procedure update_po_loc_associations ( p_site_use_id in number,
42 p_address_id in number,
43 p_customer_id in number,
44 p_inventory_organization_id in number,
45 p_inventory_location_id in number );
46 END arp_clas_pkg;