1 PACKAGE POR_AUTOSOURCE_UTIL_PKG AUTHID CURRENT_USER AS
2 /* $Header: PORSRCUS.pls 115.6 2003/02/21 22:40:11 jjessup ship $ */
3
4 FUNCTION is_internal_orderable(p_item_id IN NUMBER,
5 p_organization_id IN NUMBER
6 ) RETURN NUMBER;
7
8 FUNCTION is_item_purchasable(p_item_id IN NUMBER,
9 p_organization_id IN NUMBER
10 ) RETURN NUMBER;
11
12
13 FUNCTION is_item_shippable(p_item_id IN NUMBER,
14 p_organization_id IN NUMBER
15 ) RETURN NUMBER;
16
17
18 FUNCTION is_valid_shipping_network(p_from_organization_id IN NUMBER,
19 p_to_organization_id IN NUMBER
20 ) RETURN NUMBER;
21
22 FUNCTION is_item_assigned(p_item_id IN NUMBER,
23 p_source_organization_id IN NUMBER
24 ) RETURN NUMBER;
25
26 FUNCTION autosource(p_item_id IN NUMBER,
27 p_category_id IN NUMBER,
28 p_dest_organization_id IN NUMBER,
29 p_dest_subinventory IN VARCHAR2,
30 p_vendor_id IN NUMBER,
31 p_vendor_site_id IN NUMBER,
32 p_not_purchasable_override IN VARCHAR2,
33 p_unit_of_issue IN OUT NOCOPY VARCHAR2,
34 p_source_organization_id OUT NOCOPY NUMBER,
35 p_source_subinventory OUT NOCOPY VARCHAR2,
36 p_sourcing_type OUT NOCOPY VARCHAR2,
37 p_cost_price OUT NOCOPY NUMBER,
38 p_error_msg_code OUT NOCOPY VARCHAR2
39 ) RETURN BOOLEAN;
40
41 END POR_AUTOSOURCE_UTIL_PKG;