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;