1 PACKAGE AD_UPDATE_PREFS_PKG AUTHID CURRENT_USER AS
2 -- $Header: adupprfs.pls 115.3 2004/09/17 07:37:27 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 DEFINE_PREFERENCE(
11 p_owner IN VARCHAR2,
12 p_name IN VARCHAR2,
13 p_description IN VARCHAR2 DEFAULT NULL,
14 p_default_value IN VARCHAR2 DEFAULT NULL
15 );
16
17 --
18 -- Updates the definition of a existing parameter.
19 --
20
21 PROCEDURE UPDATE_DEF_PREFERENCE(
22 p_owner IN VARCHAR2,
23 p_name IN VARCHAR2,
24 p_description IN VARCHAR2,
25 p_default_value IN VARCHAR2,
26 p_pref_id OUT NOCOPY NUMBER
27 );
28
29
30
31 --
32 -- returns NULL if preference is not found
33 --
34 FUNCTION GET_PREFERENCE_ID(
35 p_owner IN VARCHAR2,
36 p_name IN VARCHAR2)
37 RETURN number;
38
39 --
40 -- Gets the preference value for global if session preference is not found
41 -- Returns UNDEF_VALUE if parameter is not defined
42 --
43 FUNCTION GET_PREFERENCE_VALUE(
44 p_owner IN VARCHAR2,
45 p_name IN VARCHAR2,
46 p_session_id IN NUMBER DEFAULT NULL )
47 RETURN VARCHAR2;
48
49 --
50 -- Gets Session preference value
51 --
52
53 FUNCTION GET_SESSION_PREFERENCE_VALUE(
54 p_owner IN VARCHAR2,
55 p_name IN VARCHAR2,
56 p_session_id IN NUMBER) RETURN VARCHAR2;
57
58
59 --
60 -- Creates an new global value for a preference
61 --
62
63 PROCEDURE CREATE_PREFERENCE_VALUE(
64 p_owner IN VARCHAR2,
65 p_name IN VARCHAR2,
66 p_value IN VARCHAR2);
67
68 --
69 -- Updates the global value for a preference
70 --
71
72 PROCEDURE UPDATE_PREFERENCE_VALUE(
73 p_owner IN VARCHAR2,
74 p_name IN VARCHAR2,
75 p_value IN VARCHAR2);
76
77 --
78 -- Sets value for a preference (Global)
79 --
80
81 PROCEDURE SET_SESSION_PREFERENCE_VALUE(
82 p_owner IN VARCHAR2,
83 p_name IN VARCHAR2,
84 p_session_id IN NUMBER,
85 p_value IN VARCHAR2);
86
87
88 END AD_UPDATE_PREFS_PKG;