DBA Data[Home] [Help]

PACKAGE: APPS.EDW_TRD_PARTNER_PKG

Source


1 Package EDW_TRD_PARTNER_PKG AS
2 /* $Header: poafktps.pls 120.0 2005/06/02 02:00:24 appldev noship $ */
3 
4  Function supplier_site_fk(p_vendor_site_id in NUMBER,
5                            p_org_id         in NUMBER,
6                            p_instance_code  in VARCHAR2 := NULL) return VARCHAR2;
7 
8  Function supplier_fk(p_vendor_id      in NUMBER,
9                       p_instance_code  in VARCHAR2 := NULL) return VARCHAR2;
10 
11  Function customer_fk (p_cust_account_id in NUMBER,
12                        p_instance_code   in VARCHAR2 := NULL) return VARCHAR2;
13 
14  Function customer_site_fk (p_site_use_id     in NUMBER,
15                             p_instance_code   in VARCHAR2 := NULL) return VARCHAR2;
16 
17  Function party_fk (p_party_id	in NUMBER,
18                     p_instance_code   in VARCHAR2 := NULL) return VARCHAR2;
19 
20  PRAGMA RESTRICT_REFERENCES (supplier_site_fk, WNDS, WNPS, RNPS);
21  PRAGMA RESTRICT_REFERENCES (supplier_fk, WNDS, WNPS, RNPS);
22  PRAGMA RESTRICT_REFERENCES (customer_fk, WNDS, WNPS, RNPS);
23  PRAGMA RESTRICT_REFERENCES (customer_site_fk, WNDS, WNPS, RNPS);
24  PRAGMA RESTRICT_REFERENCES (party_fk, WNDS, WNPS, RNPS);
25 
26 End EDW_TRD_PARTNER_PKG;