PACKAGE: APPS.OE_SYS_PARAMETERS

Source

1 PACKAGE OE_Sys_Parameters AUTHID CURRENT_USER AS
2 /* $Header: OESYSPAS.pls 115.9 2003/10/20 06:48:01 appldev ship $ */
3 
4 
5 -- FUNCTION VALUE
6 -- Use this function to get the value of a system parameter.
7 
8 FUNCTION VALUE
9 	(param_name 		IN VARCHAR2,
10 	p_org_id 		IN NUMBER DEFAULT NULL)
11 RETURN VARCHAR2;
12 
13 -- FUNCTION VALUE_WNPS                                                          -- Use this function to get the value of a system parameter.
14 -- Since this function has pragma WNPS associated with it,
15 -- it can be used in where clauses of SQL statements.
16 
17 FUNCTION VALUE_WNPS
18 	(param_name 		IN VARCHAR2,
19 	p_org_id 		IN NUMBER DEFAULT NULL)
20 RETURN VARCHAR2;
21 
22 -- aksingh removed this retriction for the fix of bug1632598/1715969
23 --PRAGMA RESTRICT_REFERENCES(VALUE_WNPS, WNPS, RNPS);
24 
25 END OE_Sys_Parameters;