PACKAGE: APPS.EDW_GEOGRAPHY_PKG

Source

1 PACKAGE EDW_GEOGRAPHY_PKG AS
2 /* $Header: poafkge.pkh 120.1 2005/06/13 12:39:15 sriswami noship $  */
3 
4   Function HR_Location_fk
5                (p_location_id   in NUMBER,
6                 p_instance_code in VARCHAR2 :=NULL) return VARCHAR2;
7 
8   Function HZ_Postcode_City_fk
9                (p_location_id   in NUMBER) return VARCHAR2;
10 
11   Function Customer_Site_Location_fk
12                (p_site_use_id   in NUMBER,
13                 p_instance_code in VARCHAR2 :=NULL) return VARCHAR2;
14 
15   Function Supplier_Site_Location_fk
16                (p_vendor_site_id in NUMBER,
17                 p_org_id         in NUMBER,
18                 p_instance_code  in VARCHAR2 :=NULL) return VARCHAR2;
19 
20   PRAGMA RESTRICT_REFERENCES (HR_Location_fk,
21                                              WNDS, WNPS, RNPS);
22 
23   PRAGMA RESTRICT_REFERENCES (HZ_Postcode_City_fk,
24                                             WNDS, WNPS, RNPS);
25 
26   PRAGMA RESTRICT_REFERENCES (Customer_Site_Location_fk,
27                                              WNDS, WNPS, RNPS);
28   PRAGMA RESTRICT_REFERENCES (Supplier_Site_Location_fk,
29                                              WNDS, WNPS, RNPS);
30 
31 /* For 11.5, new customer model, used by CRM */
32   Function Party_Site_Location_fk
33                (p_party_site_id in NUMBER,
34                 p_instance_code in VARCHAR2 :=NULL) return VARCHAR2;
35 
36   PRAGMA RESTRICT_REFERENCES (Party_Site_Location_fk,
37                                              WNDS, WNPS, RNPS);
38 
39 end;