PACKAGE: APPS.EDW_SUPPLIER_ITEM_PKG

Source

1 PACKAGE EDW_SUPPLIER_ITEM_PKG AS
2 /*$Header: poafksis.pls 120.0 2005/06/01 23:59:15 appldev noship $*/
3 
4 -- ---------------------------------------------------------
5 -- Supplier Item API for SUPPLIER_ITEM DIMENSION
6 --
7 -- Function returns Supplier_Item level foreign key
8 --
9 -- Underlining View: EDW_POA_SPIM_SPLRITEM_FKV
10 -- ---------------------------------------------------------
11 
12 -- Use Supplier Site ID as a parameter
13 --
14   Function Supplier_Item_FK (
15   	            p_supplier_name        in VARCHAR2,
16   	            p_supplier_site_id     in NUMBER,
17   	            p_supplier_product_num in VARCHAR2)
18                                        return VARCHAR2;
19 
20 -- Use Supplier Site Code as a parameter
21 --
22   Function Supplier_Item_SC_FK (
23   	            p_supplier_name        in VARCHAR2,
24   	            p_supplier_site_code   in VARCHAR2,
25   	            p_supplier_product_num in VARCHAR2)
26                                        return VARCHAR2;
27 
28   PRAGMA RESTRICT_REFERENCES (Supplier_Item_FK, WNDS, WNPS, RNPS);
29   PRAGMA RESTRICT_REFERENCES (Supplier_Item_SC_FK, WNDS, WNPS, RNPS);
30 
31 END EDW_SUPPLIER_ITEM_PKG;