PACKAGE: APPS.EDW_LOOKUP_PKG

Source

1 PACKAGE EDW_LOOKUP_PKG AS
2 /* $Header: poafklks.pls 120.1 2005/06/13 12:44:11 sriswami noship $  */
3 
4 -- ------------------------
5 -- Public Functions
6 -- ------------------------
7 Function Lookup_code_fk(
8 	p_lookup_table			in VARCHAR2,
9 	p_lookup_type			in VARCHAR2,
10 	p_lookup_code			in VARCHAR2) return VARCHAR2;
11 
12 PRAGMA RESTRICT_REFERENCES (Lookup_code_fk,WNDS, WNPS, RNPS);
13 --PRAGMA RESTRICT_REFERENCES (Lookup_code_fk,WNDS);
14 
15 Function Lookup_code_fk(
16 	p_lookup_table			in VARCHAR2,
17 	p_lookup_type			in VARCHAR2,
18 	p_lookup_code			in NUMBER) return VARCHAR2;
19 
20 PRAGMA RESTRICT_REFERENCES (Lookup_code_fk,WNDS, WNPS, RNPS);
21 
22 end EDW_LOOKUP_PKG;