PACKAGE: APPS.EDW_MTL_INVENTORY_LOC_PKG

Source

1 PACKAGE edw_mtl_inventory_loc_pkg AS
2 /* $Header: OPIILFKS.pls 120.1 2005/06/07 01:48:12 appldev  $  */
3 -- ------------------------
4 -- Public Functions
5 -- ------------------------
6 	FUNCTION get_locator_fk (p_inventory_location_id IN NUMBER,
7                                p_organization_id IN NUMBER,
8                                p_subinventory_code IN VARCHAR2) RETURN VARCHAR2;
9 	FUNCTION get_stock_room_fk (p_secondary_inventory_name IN VARCHAR2,
10                                   p_organization_id IN NUMBER) RETURN VARCHAR2;
11 	FUNCTION get_locator_fk (p_inventory_location_id IN NUMBER,
12                                p_organization_id IN NUMBER,
13                                p_subinventory_code IN VARCHAR2,
14                                p_whse_loct_ctl IN NUMBER,
15                                P_item_loct_ctl IN NUMBER,
16                                p_location_code IN VARCHAR2,
17                                p_organization_code IN VARCHAR2,
18                                p_instance_code  IN VARCHAR2) RETURN VARCHAR2;
19 
20 	PRAGMA RESTRICT_REFERENCES (get_locator_fk, WNDS, WNPS, RNPS);
21 	PRAGMA RESTRICT_REFERENCES (get_stock_room_fk, WNDS, WNPS, RNPS);
22 
23 end;