1 PACKAGE MRP_Sourcing_GRP AUTHID CURRENT_USER AS
2 /* $Header: MRPGSRCS.pls 115.0 2003/07/17 23:24:15 ichoudhu noship $ */
3
4 PROCEDURE Get_Source(
5 p_api_version IN NUMBER,
6 x_return_status OUT NOCOPY VARCHAR2,
7 p_mode IN VARCHAR2,
8 p_item_id IN NUMBER,
9 p_commodity_id IN NUMBER,
10 p_dest_organization_id IN NUMBER,
11 p_dest_subinventory IN VARCHAR2,
12 p_autosource_date IN DATE,
13 x_vendor_id OUT NOCOPY NUMBER,
14 x_vendor_site_code OUT NOCOPY VARCHAR2,
15 x_source_organization_id IN OUT NOCOPY NUMBER,
16 x_source_subinventory IN OUT NOCOPY VARCHAR2,
17 x_sourcing_rule_id OUT NOCOPY NUMBER,
18 x_error_message OUT NOCOPY VARCHAR2);
19
20 END MRP_Sourcing_GRP;