1 package FND_PROFILE_OPTIONS_PKG as
2 /* $Header: AFPOMPOS.pls 120.1.12000000.2 2007/04/13 13:23:44 stadepal ship $ */
3 /*#
4 * Table Handler to Insert
5 * and Update data into FND_PROFILE_OPTIONS table.
6 * @rep:scope public
7 * @rep:product FND
8 * @rep:displayname Profile Table Handler
9 * @rep:category BUSINESS_ENTITY FND_PROFILE
10 * @rep:compatibility S
11 * @rep:lifecycle active
12 */
13
14 --
15 -- ### Overloaded version of procedure at package end!
16 --
17 procedure INSERT_ROW (
18 X_ROWID in out NOCOPY VARCHAR2,
19 X_PROFILE_OPTION_NAME in VARCHAR2,
20 X_APPLICATION_ID in NUMBER,
21 X_PROFILE_OPTION_ID in NUMBER,
22 X_WRITE_ALLOWED_FLAG in VARCHAR2,
23 X_READ_ALLOWED_FLAG in VARCHAR2,
24 X_USER_CHANGEABLE_FLAG in VARCHAR2,
25 X_USER_VISIBLE_FLAG in VARCHAR2,
26 X_SITE_ENABLED_FLAG in VARCHAR2,
27 X_SITE_UPDATE_ALLOWED_FLAG in VARCHAR2,
28 X_APP_ENABLED_FLAG in VARCHAR2,
29 X_APP_UPDATE_ALLOWED_FLAG in VARCHAR2,
30 X_RESP_ENABLED_FLAG in VARCHAR2,
31 X_RESP_UPDATE_ALLOWED_FLAG in VARCHAR2,
32 X_USER_ENABLED_FLAG in VARCHAR2,
33 X_USER_UPDATE_ALLOWED_FLAG in VARCHAR2,
34 X_START_DATE_ACTIVE in DATE,
35 X_SQL_VALIDATION in VARCHAR2,
36 X_END_DATE_ACTIVE in DATE,
37 X_USER_PROFILE_OPTION_NAME in VARCHAR2,
38 X_DESCRIPTION in VARCHAR2,
39 X_CREATION_DATE in DATE,
40 X_CREATED_BY in NUMBER,
41 X_LAST_UPDATE_DATE in DATE,
42 X_LAST_UPDATED_BY in NUMBER,
43 X_LAST_UPDATE_LOGIN in NUMBER,
44 X_HIERARCHY_TYPE in VARCHAR2 default 'SECURITY',
45 X_SERVER_ENABLED_FLAG in VARCHAR2 default 'N',
46 X_SERVER_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N',
47 X_ORG_ENABLED_FLAG in VARCHAR2 default 'N',
48 X_ORG_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N');
49
50
51 --
52 -- ### Overloaded version of procedure at package end!
53 --
54 procedure TRANSLATE_ROW (
55 X_PROFILE_NAME in VARCHAR2,
56 X_OWNER in VARCHAR2,
57 X_USER_PROFILE_OPTION_NAME in VARCHAR2,
58 X_DESCRIPTION in VARCHAR2);
59
60 --
61 -- ### Overloaded version of procedure at package end!
62 --
63 procedure LOAD_ROW (
64 X_PROFILE_NAME in VARCHAR2,
65 X_OWNER in VARCHAR2,
66 X_APPLICATION_SHORT_NAME in VARCHAR2,
67 X_USER_PROFILE_OPTION_NAME in VARCHAR2,
68 X_DESCRIPTION in VARCHAR2,
69 X_USER_CHANGEABLE_FLAG in VARCHAR2,
70 X_USER_VISIBLE_FLAG in VARCHAR2,
71 X_READ_ALLOWED_FLAG in VARCHAR2,
72 X_WRITE_ALLOWED_FLAG in VARCHAR2,
73 X_SITE_ENABLED_FLAG in VARCHAR2,
74 X_SITE_UPDATE_ALLOWED_FLAG in VARCHAR2,
75 X_APP_ENABLED_FLAG in VARCHAR2,
76 X_APP_UPDATE_ALLOWED_FLAG in VARCHAR2,
77 X_RESP_ENABLED_FLAG in VARCHAR2,
78 X_RESP_UPDATE_ALLOWED_FLAG in VARCHAR2,
79 X_USER_ENABLED_FLAG in VARCHAR2,
80 X_USER_UPDATE_ALLOWED_FLAG in VARCHAR2,
81 X_START_DATE_ACTIVE in VARCHAR2,
82 X_END_DATE_ACTIVE in VARCHAR2,
83 X_SQL_VALIDATION in VARCHAR2);
84
85 --
86 -- ### Overloaded version of procedure at package end!
87 --
88 procedure LOCK_ROW (
89 X_PROFILE_OPTION_NAME in VARCHAR2,
90 X_APPLICATION_ID in NUMBER,
91 X_PROFILE_OPTION_ID in NUMBER,
92 X_WRITE_ALLOWED_FLAG in VARCHAR2,
93 X_READ_ALLOWED_FLAG in VARCHAR2,
94 X_USER_CHANGEABLE_FLAG in VARCHAR2,
95 X_USER_VISIBLE_FLAG in VARCHAR2,
96 X_SITE_ENABLED_FLAG in VARCHAR2,
97 X_SITE_UPDATE_ALLOWED_FLAG in VARCHAR2,
98 X_APP_ENABLED_FLAG in VARCHAR2,
99 X_APP_UPDATE_ALLOWED_FLAG in VARCHAR2,
100 X_RESP_ENABLED_FLAG in VARCHAR2,
101 X_RESP_UPDATE_ALLOWED_FLAG in VARCHAR2,
102 X_USER_ENABLED_FLAG in VARCHAR2,
103 X_USER_UPDATE_ALLOWED_FLAG in VARCHAR2,
104 X_START_DATE_ACTIVE in DATE,
105 X_SQL_VALIDATION in VARCHAR2,
106 X_END_DATE_ACTIVE in DATE,
107 X_USER_PROFILE_OPTION_NAME in VARCHAR2,
108 X_DESCRIPTION in VARCHAR2,
109 X_HIERARCHY_TYPE in VARCHAR2 default 'SECURITY',
110 X_SERVER_ENABLED_FLAG in VARCHAR2 default 'N',
111 X_SERVER_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N',
112 X_ORG_ENABLED_FLAG in VARCHAR2 default 'N',
113 X_ORG_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N');
114
115 --
116 -- ### Overloaded version of procedure at package end!
117 --
118 procedure UPDATE_ROW (
119 X_PROFILE_OPTION_NAME in VARCHAR2,
120 X_APPLICATION_ID in NUMBER,
121 X_PROFILE_OPTION_ID in NUMBER,
122 X_WRITE_ALLOWED_FLAG in VARCHAR2,
123 X_READ_ALLOWED_FLAG in VARCHAR2,
124 X_USER_CHANGEABLE_FLAG in VARCHAR2,
125 X_USER_VISIBLE_FLAG in VARCHAR2,
126 X_SITE_ENABLED_FLAG in VARCHAR2,
127 X_SITE_UPDATE_ALLOWED_FLAG in VARCHAR2,
128 X_APP_ENABLED_FLAG in VARCHAR2,
129 X_APP_UPDATE_ALLOWED_FLAG in VARCHAR2,
130 X_RESP_ENABLED_FLAG in VARCHAR2,
131 X_RESP_UPDATE_ALLOWED_FLAG in VARCHAR2,
132 X_USER_ENABLED_FLAG in VARCHAR2,
133 X_USER_UPDATE_ALLOWED_FLAG in VARCHAR2,
134 X_START_DATE_ACTIVE in DATE,
135 X_SQL_VALIDATION in VARCHAR2,
136 X_END_DATE_ACTIVE in DATE,
137 X_USER_PROFILE_OPTION_NAME in VARCHAR2,
138 X_DESCRIPTION in VARCHAR2,
139 X_LAST_UPDATE_DATE in DATE,
140 X_LAST_UPDATED_BY in NUMBER,
141 X_LAST_UPDATE_LOGIN in NUMBER,
142 X_HIERARCHY_TYPE in VARCHAR2 default 'SECURITY',
143 X_SERVER_ENABLED_FLAG in VARCHAR2 default 'N',
144 X_SERVER_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N',
145 X_ORG_ENABLED_FLAG in VARCHAR2 default 'N',
146 X_ORG_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N');
147
148
149 procedure DELETE_ROW (
150 X_PROFILE_OPTION_NAME in VARCHAR2);
151
152 procedure ADD_LANGUAGE;
153
154 --
155 -- ### Overloaded version above!
156 --
157 procedure TRANSLATE_ROW (
158 X_PROFILE_NAME in VARCHAR2,
159 X_OWNER in VARCHAR2,
160 X_USER_PROFILE_OPTION_NAME in VARCHAR2,
161 X_DESCRIPTION in VARCHAR2,
162 X_CUSTOM_MODE in VARCHAR2,
163 X_LAST_UPDATE_DATE in VARCHAR2);
164
165 --
166 -- ### Overloaded version above and below!
167 --
168 procedure LOAD_ROW (
169 X_PROFILE_NAME in VARCHAR2,
170 X_OWNER in VARCHAR2,
171 X_APPLICATION_SHORT_NAME in VARCHAR2,
172 X_USER_PROFILE_OPTION_NAME in VARCHAR2,
173 X_DESCRIPTION in VARCHAR2,
174 X_USER_CHANGEABLE_FLAG in VARCHAR2,
175 X_USER_VISIBLE_FLAG in VARCHAR2,
176 X_READ_ALLOWED_FLAG in VARCHAR2,
177 X_WRITE_ALLOWED_FLAG in VARCHAR2,
178 X_SITE_ENABLED_FLAG in VARCHAR2,
179 X_SITE_UPDATE_ALLOWED_FLAG in VARCHAR2,
180 X_APP_ENABLED_FLAG in VARCHAR2,
181 X_APP_UPDATE_ALLOWED_FLAG in VARCHAR2,
182 X_RESP_ENABLED_FLAG in VARCHAR2,
183 X_RESP_UPDATE_ALLOWED_FLAG in VARCHAR2,
184 X_USER_ENABLED_FLAG in VARCHAR2,
185 X_USER_UPDATE_ALLOWED_FLAG in VARCHAR2,
186 X_START_DATE_ACTIVE in VARCHAR2,
187 X_END_DATE_ACTIVE in VARCHAR2,
188 X_SQL_VALIDATION in VARCHAR2,
189 X_HIERARCHY_TYPE in VARCHAR2,
190 X_CUSTOM_MODE in VARCHAR2,
191 X_LAST_UPDATE_DATE in VARCHAR2,
192 X_SERVER_ENABLED_FLAG IN VARCHAR2,
193 X_SERVER_UPDATE_ALLOWED_FLAG IN VARCHAR2,
194 X_ORG_ENABLED_FLAG IN VARCHAR2,
195 X_ORG_UPDATE_ALLOWED_FLAG IN VARCHAR2);
196
197 --
198 -- ### Overloaded version above !
199 --
200 procedure UPDATE_ROW (
201 X_PROFILE_OPTION_NAME in VARCHAR2,
202 X_APPLICATION_ID in NUMBER,
203 X_PROFILE_OPTION_ID in NUMBER,
204 X_WRITE_ALLOWED_FLAG in VARCHAR2,
205 X_READ_ALLOWED_FLAG in VARCHAR2,
206 X_USER_CHANGEABLE_FLAG in VARCHAR2,
207 X_USER_VISIBLE_FLAG in VARCHAR2,
208 X_SITE_ENABLED_FLAG in VARCHAR2,
209 X_SITE_UPDATE_ALLOWED_FLAG in VARCHAR2,
210 X_APP_ENABLED_FLAG in VARCHAR2,
211 X_APP_UPDATE_ALLOWED_FLAG in VARCHAR2,
212 X_RESP_ENABLED_FLAG in VARCHAR2,
213 X_RESP_UPDATE_ALLOWED_FLAG in VARCHAR2,
214 X_USER_ENABLED_FLAG in VARCHAR2,
215 X_USER_UPDATE_ALLOWED_FLAG in VARCHAR2,
216 X_START_DATE_ACTIVE in DATE,
217 X_SQL_VALIDATION in VARCHAR2,
218 X_END_DATE_ACTIVE in DATE,
219 X_USER_PROFILE_OPTION_NAME in VARCHAR2,
220 X_DESCRIPTION in VARCHAR2,
221 X_LAST_UPDATE_DATE in DATE,
222 X_LAST_UPDATED_BY in NUMBER,
223 X_LAST_UPDATE_LOGIN in NUMBER,
224 X_HIERARCHY_TYPE in VARCHAR2 default 'SECURITY',
225 X_SERVER_ENABLED_FLAG in VARCHAR2 default 'N',
226 X_SERVER_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N',
227 X_ORG_ENABLED_FLAG in VARCHAR2 default 'N',
228 X_ORG_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N',
229 X_SERVERRESP_ENABLED_FLAG in VARCHAR2,
230 X_SERVERRESP_UPD_ALLOW_FL in VARCHAR2);
231
232 --
233 -- ### Overloaded version above !
234 --
235 procedure UPDATE_ROW (
236 X_PROFILE_OPTION_NAME in VARCHAR2,
237 X_HIERARCHY_TYPE in VARCHAR2,
238 X_SITE_ENABLED_FLAG in VARCHAR2 default NULL,
239 X_SITE_UPDATE_ALLOWED_FLAG in VARCHAR2 default NULL,
240 X_APP_ENABLED_FLAG in VARCHAR2 default NULL,
241 X_APP_UPDATE_ALLOWED_FLAG in VARCHAR2 default NULL,
242 X_RESP_ENABLED_FLAG in VARCHAR2 default NULL,
243 X_RESP_UPDATE_ALLOWED_FLAG in VARCHAR2 default NULL,
244 X_USER_ENABLED_FLAG in VARCHAR2 default NULL,
245 X_USER_UPDATE_ALLOWED_FLAG in VARCHAR2 default NULL,
246 X_SERVER_ENABLED_FLAG in VARCHAR2 default NULL,
247 X_SERVER_UPDATE_ALLOWED_FLAG in VARCHAR2 default NULL,
248 X_ORG_ENABLED_FLAG in VARCHAR2 default NULL,
249 X_ORG_UPDATE_ALLOWED_FLAG in VARCHAR2 default NULL,
250 X_SERVERRESP_ENABLED_FLAG in VARCHAR2 default NULL,
251 X_SERVERRESP_UPD_ALLOW_FL in VARCHAR2 default NULL);
252
253 --
254 -- ### Overloaded version above !
255 --
256 procedure INSERT_ROW (
257 X_ROWID in out NOCOPY VARCHAR2,
258 X_PROFILE_OPTION_NAME in VARCHAR2,
259 X_APPLICATION_ID in NUMBER,
260 X_PROFILE_OPTION_ID in NUMBER,
261 X_WRITE_ALLOWED_FLAG in VARCHAR2,
262 X_READ_ALLOWED_FLAG in VARCHAR2,
263 X_USER_CHANGEABLE_FLAG in VARCHAR2,
264 X_USER_VISIBLE_FLAG in VARCHAR2,
265 X_SITE_ENABLED_FLAG in VARCHAR2,
266 X_SITE_UPDATE_ALLOWED_FLAG in VARCHAR2,
267 X_APP_ENABLED_FLAG in VARCHAR2,
268 X_APP_UPDATE_ALLOWED_FLAG in VARCHAR2,
269 X_RESP_ENABLED_FLAG in VARCHAR2,
270 X_RESP_UPDATE_ALLOWED_FLAG in VARCHAR2,
271 X_USER_ENABLED_FLAG in VARCHAR2,
272 X_USER_UPDATE_ALLOWED_FLAG in VARCHAR2,
273 X_START_DATE_ACTIVE in DATE,
274 X_SQL_VALIDATION in VARCHAR2,
275 X_END_DATE_ACTIVE in DATE,
276 X_USER_PROFILE_OPTION_NAME in VARCHAR2,
277 X_DESCRIPTION in VARCHAR2,
278 X_CREATION_DATE in DATE,
279 X_CREATED_BY in NUMBER,
280 X_LAST_UPDATE_DATE in DATE,
281 X_LAST_UPDATED_BY in NUMBER,
282 X_LAST_UPDATE_LOGIN in NUMBER,
283 X_HIERARCHY_TYPE in VARCHAR2 default 'SECURITY',
284 X_SERVER_ENABLED_FLAG in VARCHAR2 default 'N',
285 X_SERVER_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N',
286 X_ORG_ENABLED_FLAG in VARCHAR2 default 'N',
287 X_ORG_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N',
288 X_SERVERRESP_ENABLED_FLAG in VARCHAR2,
289 X_SERVERRESP_UPD_ALLOW_FL in VARCHAR2);
290
291 --
292 -- ### Overloaded version above !
293 --
294 /*#
295 * Loads a row of FND_PROFILE_OPTIONS.
296 * There are also overloaded versions of this procedure with fewer parameters.
297 * @param X_PROFILE_NAME Profile name
298 * @param X_OWNER Profile owner
299 * @param X_APPLICATION_SHORT_NAME Application short name
300 * @param X_USER_PROFILE_OPTION_NAME User friendly profile name
301 * @param X_DESCRIPTION Profile description
302 * @param X_USER_CHANGEABLE_FLAG Can user change the profile?
303 * @param X_USER_VISIBLE_FLAG Is profile visible to user?
304 * @param X_READ_ALLOWED_FLAG Is read is allowed?
305 * @param X_WRITE_ALLOWED_FLAG Is write is allowed?
306 * @param X_SITE_ENABLED_FLAG Is enabled in site level?
307 * @param X_SITE_UPDATE_ALLOWED_FLAG Is updatable in site level?
308 * @param X_APP_ENABLED_FLAG Is enabled in application level?
309 * @param X_APP_UPDATE_ALLOWED_FLAG Is updateable in application level?
310 * @param X_RESP_ENABLED_FLAG Is enabled in resposibility level?
311 * @param X_RESP_UPDATE_ALLOWED_FLAG Is updateable in resposibility level?
312 * @param X_USER_ENABLED_FLAG Is enabled in user level?
313 * @param X_USER_UPDATE_ALLOWED_FLAG Is updateable in user level?
314 * @param X_START_DATE_ACTIVE Start date from when the profile is active
315 * @param X_END_DATE_ACTIVE End date to which the profile will be active
316 * @param X_SQL_VALIDATION SQL which retrieves the profile values
317 * @param X_HIERARCHY_TYPE Hierarchy type
318 * @param X_CUSTOM_MODE Custom mode
319 * @param X_LAST_UPDATE_DATE Last date when the profile was updated
320 * @param X_SERVER_ENABLED_FLAG Is enabled at server level?
321 * @param X_SERVER_UPDATE_ALLOWED_FLAG Is updateable in server level?
322 * @param X_ORG_ENABLED_FLAG Is enabled in organisation level?
323 * @param X_ORG_UPDATE_ALLOWED_FLAG Is updateable in organisation level?
324 * @param X_SERVERRESP_ENABLED_FLAG Is enabled in server-resp level?
325 * @param X_SERVERRESP_UPD_ALLOW_FL Is updateable in server-resp level?
326 * @rep:scope public
327 * @rep:displayname Load Row
328 * @rep:compatibility S
329 * @rep:lifecycle active
330 */
331 procedure LOAD_ROW (
332 X_PROFILE_NAME in VARCHAR2,
333 X_OWNER in VARCHAR2,
334 X_APPLICATION_SHORT_NAME in VARCHAR2,
335 X_USER_PROFILE_OPTION_NAME in VARCHAR2,
336 X_DESCRIPTION in VARCHAR2,
337 X_USER_CHANGEABLE_FLAG in VARCHAR2,
338 X_USER_VISIBLE_FLAG in VARCHAR2,
339 X_READ_ALLOWED_FLAG in VARCHAR2,
340 X_WRITE_ALLOWED_FLAG in VARCHAR2,
341 X_SITE_ENABLED_FLAG in VARCHAR2,
342 X_SITE_UPDATE_ALLOWED_FLAG in VARCHAR2,
343 X_APP_ENABLED_FLAG in VARCHAR2,
344 X_APP_UPDATE_ALLOWED_FLAG in VARCHAR2,
345 X_RESP_ENABLED_FLAG in VARCHAR2,
346 X_RESP_UPDATE_ALLOWED_FLAG in VARCHAR2,
347 X_USER_ENABLED_FLAG in VARCHAR2,
348 X_USER_UPDATE_ALLOWED_FLAG in VARCHAR2,
349 X_START_DATE_ACTIVE in VARCHAR2,
350 X_END_DATE_ACTIVE in VARCHAR2,
351 X_SQL_VALIDATION in VARCHAR2,
352 X_HIERARCHY_TYPE in VARCHAR2,
353 X_CUSTOM_MODE in VARCHAR2,
354 X_LAST_UPDATE_DATE in VARCHAR2,
355 X_SERVER_ENABLED_FLAG IN VARCHAR2,
356 X_SERVER_UPDATE_ALLOWED_FLAG IN VARCHAR2,
357 X_ORG_ENABLED_FLAG IN VARCHAR2,
358 X_ORG_UPDATE_ALLOWED_FLAG IN VARCHAR2,
359 X_SERVERRESP_ENABLED_FLAG in VARCHAR2,
360 X_SERVERRESP_UPD_ALLOW_FL in VARCHAR2);
361
362 --
363 -- ### Overloaded version above !
364 --
365 procedure LOCK_ROW (
366 X_PROFILE_OPTION_NAME in VARCHAR2,
367 X_APPLICATION_ID in NUMBER,
368 X_PROFILE_OPTION_ID in NUMBER,
369 X_WRITE_ALLOWED_FLAG in VARCHAR2,
370 X_READ_ALLOWED_FLAG in VARCHAR2,
371 X_USER_CHANGEABLE_FLAG in VARCHAR2,
372 X_USER_VISIBLE_FLAG in VARCHAR2,
373 X_SITE_ENABLED_FLAG in VARCHAR2,
374 X_SITE_UPDATE_ALLOWED_FLAG in VARCHAR2,
375 X_APP_ENABLED_FLAG in VARCHAR2,
376 X_APP_UPDATE_ALLOWED_FLAG in VARCHAR2,
377 X_RESP_ENABLED_FLAG in VARCHAR2,
378 X_RESP_UPDATE_ALLOWED_FLAG in VARCHAR2,
379 X_USER_ENABLED_FLAG in VARCHAR2,
380 X_USER_UPDATE_ALLOWED_FLAG in VARCHAR2,
381 X_START_DATE_ACTIVE in DATE,
382 X_SQL_VALIDATION in VARCHAR2,
383 X_END_DATE_ACTIVE in DATE,
384 X_USER_PROFILE_OPTION_NAME in VARCHAR2,
385 X_DESCRIPTION in VARCHAR2,
386 X_HIERARCHY_TYPE in VARCHAR2 default 'SECURITY',
387 X_SERVER_ENABLED_FLAG in VARCHAR2 default 'N',
388 X_SERVER_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N',
389 X_ORG_ENABLED_FLAG in VARCHAR2 default 'N',
390 X_ORG_UPDATE_ALLOWED_FLAG in VARCHAR2 default 'N',
391 X_SERVERRESP_ENABLED_FLAG in VARCHAR2,
392 X_SERVERRESP_UPD_ALLOW_FL in VARCHAR2);
393
394 end FND_PROFILE_OPTIONS_PKG;