PACKAGE: APPS.AD_UPDATE_WORK_PARAMS_PKG

Source

1 PACKAGE AD_UPDATE_WORK_PARAMS_PKG AUTHID CURRENT_USER AS
2 -- $Header: adupwrks.pls 115.3 2004/09/17 07:36:58 msailoz ship $
3 
4 UNDEF_VALUE  CONSTANT VARCHAR2(20) := '#~#UNDEFVALUE#~#';
5 SYSADMIN_VALUE NUMBER := 1;
6 GLOBAL_SESSION_VALUE NUMBER := 0 ;
7 --
8 -- Defines and Sets the value of a parameter at the global level.
9 --
10 PROCEDURE SET_PARAMETER(
11                  p_owner IN VARCHAR2,
12                  p_name  IN VARCHAR2,
13                  p_value IN VARCHAR2);
14 
15 --
16 -- Returns UNDEF_VALUE if parameter is not defined
17 --
18 FUNCTION GET_PARAMETER(
19                  p_owner IN VARCHAR2,
20                  p_name  IN VARCHAR2) RETURN VARCHAR2;
21 
22 
23 --
24 -- Defines and Sets the value of a parameter for a session
25 --
26 
27 PROCEDURE SET_SESSION_PARAMETER(
28                  p_session_id IN number,
29                  p_owner      IN VARCHAR2,
30                  p_name       IN VARCHAR2,
31                  p_value      IN VARCHAR2);
32 
33 --
34 -- Returns UNDEF_VALUE if parameter is not defined
35 --
36 FUNCTION GET_SESSION_PARAMETER(
37                  p_session_id IN number,
38                  p_owner      IN VARCHAR2,
39                  p_name       IN VARCHAR2) RETURN VARCHAR2;
40 
41 
42 END AD_UPDATE_WORK_PARAMS_PKG;