1 package WF_PREF AUTHID CURRENT_USER as
2 /* $Header: wfprfs.pls 120.4 2011/03/30 17:09:32 ppalanic ship $ */
3 /*#
4 * Provides an API to retrieve user preference information.
5 * @rep:scope public
6 * @rep:product OWF
7 * @rep:displayname Workflow Preference
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY WF_USER
11 * @rep:ihelp FND/@a_pref See the related online help
12 */
13 --
14 -- EDIT
15 -- Generate edit preferences page that shows the current values.
16 -- IN
17 --
18 -- NOTE
19 --
20 procedure edit (edit_defaults IN VARCHAR2 DEFAULT 'N');
21
22 --
23 -- EDIT
24 -- Generate edit preferences page that allows you to edit the values
25 -- IN
26 --
27 -- NOTE
28 --
29 procedure edit_form (edit_defaults IN VARCHAR2 DEFAULT 'N');
30
31 --
32 -- Lang_LOV
33 -- Create the data for the Language List of Values
34 --
35 procedure Lang_LOV (p_titles_only IN VARCHAR2 DEFAULT NULL,
36 p_find_criteria IN VARCHAR2 DEFAULT NULL);
37 --
38 -- terr_LOV
39 -- Create the data for the territory List of Values
40 --
41 procedure terr_LOV (p_titles_only IN VARCHAR2 DEFAULT NULL,
42 p_find_criteria IN VARCHAR2 DEFAULT NULL);
43 --
44 -- dm_LOV
45 -- Create the data for the document management home List of Values
46 --
47 procedure dm_LOV (p_titles_only IN VARCHAR2 DEFAULT NULL,
48 p_find_criteria IN VARCHAR2 DEFAULT NULL);
49
50 procedure update_pref (
51 p_admin_role IN VARCHAR2 DEFAULT NULL,
52 p_display_admin_role IN VARCHAR2 DEFAULT NULL,
53 p_web_agent IN VARCHAR2 DEFAULT NULL,
54 p_edit_defaults IN VARCHAR2 DEFAULT NULL,
55 p_language IN VARCHAR2 DEFAULT NULL,
56 p_territory IN VARCHAR2 DEFAULT NULL,
57 p_date_format IN VARCHAR2 DEFAULT NULL,
58 p_dm_node_id IN VARCHAR2 DEFAULT NULL,
59 p_dm_home IN VARCHAR2 DEFAULT NULL,
60 p_mailtype IN VARCHAR2 DEFAULT NULL,
61 p_classid IN VARCHAR2 DEFAULT NULL,
62 p_plugin_loc IN VARCHAR2 DEFAULT NULL,
63 p_plugin_ver IN VARCHAR2 DEFAULT NULL,
64 p_system_guid IN VARCHAR2 DEFAULT NULL,
65 p_system_name IN VARCHAR2 DEFAULT NULL,
66 p_system_status IN VARCHAR2 DEFAULT NULL,
67 p_ldap_host IN VARCHAR2 DEFAULT NULL,
68 p_ldap_port IN VARCHAR2 DEFAULT NULL,
69 p_ldap_user IN VARCHAR2 DEFAULT NULL,
70 p_ldap_opwd IN VARCHAR2 DEFAULT NULL,
71 p_ldap_npwd IN VARCHAR2 DEFAULT NULL,
72 p_ldap_rpwd IN VARCHAR2 DEFAULT NULL,
73 p_ldap_log_base IN VARCHAR2 DEFAULT NULL,
74 p_ldap_user_base IN VARCHAR2 DEFAULT NULL,
75 p_text_signon IN VARCHAR2 DEFAULT NULL
76 );
77
78 --update preferences for OAF
79 procedure update_pref_fwk (
80 p_admin_role IN VARCHAR2 DEFAULT NULL,
81 p_display_admin_role IN VARCHAR2 DEFAULT NULL,
82 p_web_agent IN VARCHAR2 DEFAULT NULL,
83 p_edit_defaults IN VARCHAR2 DEFAULT NULL,
84 p_language IN VARCHAR2 DEFAULT NULL,
85 p_territory IN VARCHAR2 DEFAULT NULL,
86 p_date_format IN VARCHAR2 DEFAULT NULL,
87 p_dm_node_id IN VARCHAR2 DEFAULT NULL,
88 p_dm_home IN VARCHAR2 DEFAULT NULL,
89 p_mailtype IN VARCHAR2 DEFAULT NULL,
90 p_classid IN VARCHAR2 DEFAULT NULL,
91 p_plugin_loc IN VARCHAR2 DEFAULT NULL,
92 p_plugin_ver IN VARCHAR2 DEFAULT NULL,
93 p_system_guid IN VARCHAR2 DEFAULT NULL,
94 p_system_name IN VARCHAR2 DEFAULT NULL,
95 p_system_status IN VARCHAR2 DEFAULT NULL,
96 p_ldap_host IN VARCHAR2 DEFAULT NULL,
97 p_ldap_port IN VARCHAR2 DEFAULT NULL,
98 p_ldap_user IN VARCHAR2 DEFAULT NULL,
99 p_ldap_opwd IN VARCHAR2 DEFAULT NULL,
100 p_ldap_npwd IN VARCHAR2 DEFAULT NULL,
101 p_ldap_rpwd IN VARCHAR2 DEFAULT NULL,
102 p_ldap_log_base IN VARCHAR2 DEFAULT NULL,
103 p_ldap_user_base IN VARCHAR2 DEFAULT NULL,
104 p_text_signon IN VARCHAR2 DEFAULT NULL,
105 p_num_format IN VARCHAR2 DEFAULT NULL,
106 p_browser_dll_loc IN VARCHAR2 DEFAULT NULL,
107 p_err_msg OUT NOCOPY VARCHAR2
108 );
109
110
111
112 --update preferences for OAF
113 procedure update_pref_fwk2 (
114 p_admin_role IN VARCHAR2 DEFAULT NULL,
115 p_display_admin_role IN VARCHAR2 DEFAULT NULL,
116 p_web_agent IN VARCHAR2 DEFAULT NULL,
117 p_edit_defaults IN VARCHAR2 DEFAULT NULL,
118 p_language IN VARCHAR2 DEFAULT NULL,
119 p_territory IN VARCHAR2 DEFAULT NULL,
120 p_date_format IN VARCHAR2 DEFAULT NULL,
121 p_dm_node_id IN VARCHAR2 DEFAULT NULL,
122 p_dm_home IN VARCHAR2 DEFAULT NULL,
123 p_mailtype IN VARCHAR2 DEFAULT NULL,
124 p_classid IN VARCHAR2 DEFAULT NULL,
125 p_plugin_loc IN VARCHAR2 DEFAULT NULL,
126 p_plugin_ver IN VARCHAR2 DEFAULT NULL,
127 p_system_guid IN VARCHAR2 DEFAULT NULL,
128 p_system_name IN VARCHAR2 DEFAULT NULL,
129 p_system_status IN VARCHAR2 DEFAULT NULL,
130 p_ldap_host IN VARCHAR2 DEFAULT NULL,
131 p_ldap_port IN VARCHAR2 DEFAULT NULL,
132 p_ldap_user IN VARCHAR2 DEFAULT NULL,
133 p_ldap_opwd IN VARCHAR2 DEFAULT NULL,
134 p_ldap_npwd IN VARCHAR2 DEFAULT NULL,
135 p_ldap_rpwd IN VARCHAR2 DEFAULT NULL,
136 p_ldap_log_base IN VARCHAR2 DEFAULT NULL,
137 p_ldap_user_base IN VARCHAR2 DEFAULT NULL,
138 p_text_signon IN VARCHAR2 DEFAULT NULL,
139 p_num_format IN VARCHAR2 DEFAULT NULL,
140 p_browser_dll_loc IN VARCHAR2 DEFAULT NULL,
141 p_status_monitor_size IN VARCHAR2,
142 p_err_msg OUT NOCOPY VARCHAR2
143 );
144
145 procedure create_reg_button (
146 when_pressed_url IN VARCHAR2,
147 onmouseover IN VARCHAR2,
148 icon_top IN VARCHAR2,
149 icon_name IN VARCHAR2,
150 show_text IN VARCHAR2);
151
152 procedure get_open_lov_window_html;
153
154 /*#
155 * Retrieves the value of the specified preference for the specified user.
156 * Specify -WF_DEFAULT- as the user name to retrieve a global preference value.
157 * @param p_user_name Internal Name of the user
158 * @param p_preference_name Preference Name
159 * @return Preference Value
160 * @rep:scope public
161 * @rep:lifecycle active
162 * @rep:displayname Get Preference Value
163 * @rep:compatibility S
164 * @rep:ihelp FND/@a_pref#get_pref See the related online help
165 */
166 FUNCTION get_pref
167 (
168 p_user_name IN VARCHAR2,
169 p_preference_name IN VARCHAR2
170 ) RETURN VARCHAR2;
171
172
173
174 -- Bug 8823516 - overriden function of get_pref().
175 -- Returns the default preference 'MAILHTML' when called by the
176 -- product team and null for WFDS, if both the user and global
177 -- preference values are null in FND_USER_PREFERENCES table.
178 FUNCTION get_pref2
179 (
180 p_user_name IN VARCHAR2,
181 p_preference_name IN VARCHAR2,
182 p_caller IN VARCHAR2
183 ) RETURN VARCHAR2;
184
185 PRAGMA RESTRICT_REFERENCES(get_pref2, WNDS, WNPS);
186
187 end WF_PREF;