[Home] [Help]
PACKAGE: APPS.ICX_SEC
Source
1 package icx_sec as
2 /* $Header: ICXSESES.pls 120.0 2005/10/07 12:19:58 gjimenez noship $ */
3
4 PV_CUST_CONTACT_ID CONSTANT NUMBER := 7;
5 PV_VEND_CONTACT_ID CONSTANT NUMBER := 8;
6 PV_INT_CONTACT_ID CONSTANT NUMBER := 9;
7 PV_WEB_USER_ID CONSTANT NUMBER := 10;
8 PV_USER_ID CONSTANT NUMBER := 10;
9 PV_LANGUAGE_CODE CONSTANT NUMBER := 21;
10 PV_DATE_FORMAT CONSTANT NUMBER := 22;
11 PV_SESSION_ID CONSTANT NUMBER := 23;
12 PV_RESPONSIBILITY_ID CONSTANT NUMBER := 24;
13 PV_USER_REQ_TEMPLATE CONSTANT NUMBER := 25;
14 PV_USER_REQ_OVERRIDE_REQUESTOR CONSTANT NUMBER := 26;
15 PV_USER_REQ_OVERRIDE_LOC_FLAG CONSTANT NUMBER := 27;
16 PV_USER_REQ_DAYS_NEEDED_BY CONSTANT NUMBER := 28;
17 PV_ORG_ID CONSTANT NUMBER := 29;
18 PV_SESSION_MODE CONSTANT NUMBER := 30;
19 PV_FUNCTION_ID CONSTANT NUMBER := 31;
20 PV_FUNCTION_TYPE CONSTANT NUMBER := 32;
21 PV_USERNAME CONSTANT NUMBER := 99;
22 PV_USER_NAME CONSTANT NUMBER := 99;
23
24
25 TYPE g_char_tbl_type is table of varchar2(240) index by BINARY_INTEGER;
26 TYPE g_date_tbl_type is table of date index by BINARY_INTEGER;
27 TYPE g_num_tbl_type is table of number index by BINARY_INTEGER;
28
29 -- For passing more meaningful error messages to JAVA
30
31 g_validation_error varchar2(240);
32
33 -- ICX_SESSIONS
34
35 g_session_id number := -1;
36 g_transaction_id number := -1;
37 g_resp_appl_id number := -1;
38 g_responsibility_id number := -1;
39 g_security_group_id number := -1;
40 g_org_id number := -1;
41 g_function_id number := -1;
42 g_function_type varchar2(30) := '';
43 g_menu_id number := -1;
44 g_page_id number := -1;
45
46 g_user_id number := -1;
47 g_language varchar2(30) := 'AMERICAN';
48 g_language_code varchar2(30) := 'US';
49 g_date_format varchar2(80) := 'DD-MON-RRRR';
50 g_date_language varchar2(30) := 'AMERICAN';
51 g_numeric_characters varchar2(30) := '.,';
52 g_nls_sort varchar2(30) := 'BINARY';
53 g_nls_territory varchar2(30) := 'AMERICA';
54 g_login_id NUMBER := -1; -- mputman added 2020952
55 g_prog_appl_id number := -1;
56 --Bug 3238722
57 g_p_loginID NUMBER;
58 g_p_expired varchar2(10);
59
60 --added connection level globals for
61 --1574527 mputman
62 g_language_c varchar2(30) := null;
63 g_language_code_c varchar2(30) := null;
64 g_date_format_c varchar2(80) := null;
65 g_date_language_c varchar2(30) := null;
66 g_numeric_characters_c varchar2(30) := null;
67 g_nls_sort_c varchar2(30) := null;
68 g_nls_territory_c varchar2(30) := null;
69
70 g_OA_HTML varchar2(30) := 'OA_HTML';
71 g_OA_MEDIA varchar2(30) := 'OA_MEDIA';
72 g_style_sheet varchar2(30) := 'oracle.css';
73
74 g_mode_code varchar2(30) := null;
75
76 -- ICX_PARAMETERS
77
78 g_home_url varchar2(240) := '';
79 g_webmaster_email varchar2(80) := '';
80 g_query_set number := -1;
81 g_max_rows number := -1;
82 g_session_cookie_name varchar2(81) := '';
83 g_session_cookie_domain varchar2(30) := '';
84 g_window_cookie_name varchar2(30) := '';
85
86 -- nlbarlow 1574527
87
88 g_validateSession_flag boolean := true;
89
90 -- for returning a list of responsibilities for a user
91 type g_responsibility_list is table of varchar2(100)
92 index by binary_integer;
93
94 function validatePassword(c_user_name in varchar2,
95 c_user_password in varchar2,
96 n_session_id out NOCOPY number,
97 c_validate_only in varchar2 default 'N',
98 c_mode_code in varchar2 default '115P',
99 c_url in varchar2 default null)
100 return varchar2;
101
102 function createSession(p_user_id in number,
103 c_mode_code in varchar2 default 'SLAVE',
104 c_sec_grp_id in NUMBER DEFAULT NULL,
105 p_server_id in varchar2 DEFAULT NULL)
106 return number;
107
108 function createTransaction(p_session_id in number,
109 p_resp_appl_id in number default null,
110 p_responsibility_id in number default null,
111 p_security_group_id in number default null,
112 p_menu_id in number default null,
113 p_function_id in number default null,
114 p_function_type in varchar2 default null,
115 p_page_id in number default null)
116 return number;
117
118 procedure removeTransaction(p_transaction_id in number);
119
120 procedure createSessionCookie(p_session_id in number);
121
122 function NewSession( user_info in fnd_user%rowtype,
123 c_user_name in varchar2,
124 c_password in varchar2,
125 n_session_id out NOCOPY number,
126 c_validate_only in varchar2 default 'N',
127 c_mode_code in varchar2 default '115P')
128 return varchar2;
129
130 procedure ServerLevel(p_server_id in varchar2 default NULL);
131
132 function PseudoSession (n_session_id out NOCOPY number,
133 IncludeHeader in boolean default TRUE)
134 return varchar2;
135
136 function setSessionPublic(p_ticket in varchar2) return BOOLEAN;
137
138
139
140 procedure setSessionPrivate( p_session_id in number,
141 p_success out NOCOPY boolean);
142
143 procedure setSessionPrivate( p_user_id in number,
144 p_responsibility_id in number,
145 p_resp_appl_id in number,
146 p_security_group_id in number,
147 p_date_format in varchar2,
148 p_language in varchar2,
149 p_date_language in varchar2,
150 p_numeric_characters in varchar2,
151 p_nls_sort in varchar2,
152 p_nls_territory in varchar2);
153
154 function validatePlugSession(p_plug_id in number,
155 p_session_id in number default NULL,
156 p_update_context in varchar2 default 'N')
157 return BOOLEAN;
158
159 function validateSessionPrivate( c_session_id in number,
160 c_function_code in varchar2 default NULL,
161 c_validate_only in varchar2 default 'N',
162 c_commit in boolean default TRUE,
163 c_update in boolean default TRUE,
164 c_responsibility_id in number default NULL,
165 c_function_id in number default NULL,
166 c_resp_appl_id in number default NULL,
167 c_security_group_id in number default NULL,
168 c_validate_mode_on in varchar2 default 'Y',
169 c_transaction_id in number default NULL)
170 return BOOLEAN;
171
172 function validateSessionPrivate( c_encrypted_session_id in varchar2,
173 c_function_code in varchar2 default NULL,
174 c_validate_only in varchar2 default 'N',
175 c_commit in boolean default TRUE,
176 c_update in boolean default TRUE,
177 c_responsibility_id in number default NULL,
178 c_function_id in number default NULL,
179 c_resp_appl_id in number default NULL,
180 c_security_group_id in number default NULL,
181 c_validate_mode_on in varchar2 default 'Y',
182 c_encrypted_transaction_id in varchar2 default NULL,
183 session_id out NOCOPY number,
184 transaction_id out NOCOPY number,
185 user_id out NOCOPY number,
186 responsibility_id out NOCOPY number,
187 resp_appl_id out NOCOPY number,
188 security_group_id out NOCOPY number,
189 language_code out NOCOPY varchar2,
190 nls_language out NOCOPY varchar2,
191 date_format_mask out NOCOPY varchar2,
192 nls_date_language out NOCOPY varchar2,
193 nls_numeric_characters out NOCOPY varchar2,
194 nls_sort out NOCOPY varchar2,
195 nls_territory out NOCOPY varchar2)
196 return BOOLEAN;
197
198 function validateSession( c_function_code in varchar2 default NULL,
199 c_validate_only in varchar2 default 'N',
200 c_commit in boolean default TRUE,
201 c_update in boolean default TRUE,
202 c_validate_mode_on in varchar2 default 'Y')
203 return BOOLEAN;
204
205 function disableUserSession(c_session_id in number default null,
206 c_user_id in number default null) return BOOLEAN;
207
208 procedure RemoveCookie;
209
210 procedure writeAudit;
211
212 procedure set_org_context(
213 n_session_id in number,
214 n_org_id in number);
215
216 function getID( n_param in number,
217 c_logo in varchar2 default 'Y',
218 p_session_id in number default NULL)
219 return varchar2;
220
221 procedure getResponsibilityList(c_user_id in number,
222 c_application_id in number default null,
223 c_responsibility_list out NOCOPY g_responsibility_list);
224
225 procedure putSessionAttributeValue(p_name in varchar2,
226 p_value in varchar2,
227 p_session_id in number default null);
228
229 function getSessionAttributeValue(p_name in varchar2,
230 p_session_id in number default null)
231 return varchar2;
232
233 procedure clearSessionAttributeValue(p_name in varchar2,
234 p_session_id in number default null);
235
236 procedure sendsessioncookie(p_session_id in number);
237
238 function getsessioncookie(p_ticket in varchar2 default null) return number;
239
240 function getsessioncookiename return varchar2;
241
242 function getsessioncookiedomain return varchar2;
243
244 procedure getSecureAttributeValues(p_return_status out NOCOPY varchar2,
245 p_attri_code in varchar2,
246 p_char_tbl out NOCOPY g_char_tbl_type,
247 p_session_id in number default -1);
248
249 procedure getSecureAttributeValues(p_return_status out NOCOPY varchar2,
250 p_attri_code in varchar2,
251 p_date_tbl out NOCOPY g_date_tbl_type,
252 p_session_id in number default -1);
253
254 procedure getSecureAttributeValues(p_return_status out NOCOPY varchar2,
255 p_attri_code in varchar2,
256 p_num_tbl out NOCOPY g_num_tbl_type,
257 p_session_id in number default -1);
258
259 function createRFURL( p_function_name varchar2 default null,
260 p_function_id number default null,
261 p_application_id number,
262 p_responsibility_id number,
263 p_security_group_id number,
264 p_session_id number default null,
265 p_parameters varchar2 default null )
266 return varchar2;
267
268 function createRFLink( p_text varchar2,
269 p_application_id number,
270 p_responsibility_id number,
271 p_security_group_id number,
272 p_function_id number,
273 p_target varchar2 default '_top',
274 p_session_id number default null)
275 return varchar2;
276
277 procedure updateSessionContext( p_function_name varchar2 default null,
278 p_function_id number default null,
279 p_application_id number,
280 p_responsibility_id number,
281 p_security_group_id number,
282 p_session_id number default null,
283 p_transaction_id number default null);
284
285 function jumpIntoFlow( c_person_id in number default null,
286 c_application_id in number,
287 c_flow_code in varchar2,
288 c_sequence in number default null,
289 c_key1 in varchar2 default null,
290 c_key2 in varchar2 default null,
291 c_key3 in varchar2 default null,
292 c_key4 in varchar2 default null,
293 c_key5 in varchar2 default null,
294 c_key6 in varchar2 default null,
295 c_key7 in varchar2 default null,
296 c_key8 in varchar2 default null,
297 c_key9 in varchar2 default null,
298 c_key10 in varchar2 default null)
299 return varchar2;
300
301 function jumpIntoFunction(p_application_id in number,
302 p_function_code in varchar2,
303 p_parameter1 in varchar2 default null,
304 p_parameter2 in varchar2 default null,
305 p_parameter3 in varchar2 default null,
306 p_parameter4 in varchar2 default null,
307 p_parameter5 in varchar2 default null,
308 p_parameter6 in varchar2 default null,
309 p_parameter7 in varchar2 default null,
310 p_parameter8 in varchar2 default null,
311 p_parameter9 in varchar2 default null,
312 p_parameter10 in varchar2 default null,
313 p_parameter11 in varchar2 default null)
314 return varchar2;
315
316 function getNLS_PARAMETER(p_param in VARCHAR2)
317 return varchar2; -- mputman added
318
319
320
321 function NewSessionId(dummy in number)
322 return number; -- bug 1388903
323
324 PROCEDURE set_session_nls (p_session_id IN NUMBER,
325 p_language IN VARCHAR2,
326 p_date_format_mask IN VARCHAR2,
327 p_language_code IN VARCHAR2,
328 p_date_language IN VARCHAR2,
329 p_numeric_characters IN VARCHAR2,
330 p_sort IN VARCHAR2,
331 p_territory IN VARCHAR2); --mputman added for AOLJ/CRM
332
333 FUNCTION CHECK_SESSION(p_session_id IN NUMBER,
334 p_resp_id IN NUMBER DEFAULT NULL,
335 p_app_resp_id IN NUMBER DEFAULT NULL)
336 RETURN VARCHAR2;
337
338 FUNCTION recreate_session(i_1 IN VARCHAR2,
339 i_2 IN VARCHAR2,
340 p_enc_session IN VARCHAR2,
341 p_mode IN VARCHAR2 DEFAULT '115p')
342 RETURN VARCHAR2;
343
344 function recreateURL(p_session_id IN NUMBER,
345 p_user_name in varchar2)
346 return VARCHAR2;
347
348 procedure newSessionRaiseEvent (p_user_id in varchar2 DEFAULT '-7777',
349 p_session_id in varchar2 DEFAULT '-7777');
350
351
352 function doNewSessionEvent (p_guid in raw,
353 p_evtMsg in out NOCOPY wf_event_t)
354 return VARCHAR2;
355
356 /* no longer needed after fix for bug 3238722
357 function newLoginId
358 return number;
359 */
360
361 PROCEDURE disableSessions (threshold IN NUMBER);
362
363 FUNCTION anonFunctionTest(p_func_id IN VARCHAR2,
364 p_user_id IN NUMBER DEFAULT NULL)
365
366 RETURN BOOLEAN;
367 PROCEDURE setUserNLS (p_user_id IN NUMBER,
368 l_language OUT NOCOPY varchar2,
369 l_language_code OUT NOCOPY varchar2,
370 l_date_format OUT NOCOPY varchar2,
371 l_date_language OUT NOCOPY varchar2,
372 l_numeric_characters OUT NOCOPY varchar2,
373 l_nls_sort OUT NOCOPY varchar2,
374 l_nls_territory OUT NOCOPY varchar2,
375 l_limit_time OUT NOCOPY NUMBER,
376 l_limit_connects OUT NOCOPY NUMBER,
377 l_org_id OUT NOCOPY varchar2);
378
379
380 PROCEDURE setUserNLS (p_user_id IN NUMBER,
381 l_language OUT NOCOPY varchar2,
382 l_language_code OUT NOCOPY varchar2,
383 l_date_format OUT NOCOPY varchar2,
384 l_date_language OUT NOCOPY varchar2,
385 l_numeric_characters OUT NOCOPY varchar2,
386 l_nls_sort OUT NOCOPY varchar2,
387 l_nls_territory OUT NOCOPY varchar2,
388 l_limit_time OUT NOCOPY NUMBER,
389 l_limit_connects OUT NOCOPY NUMBER,
390 l_org_id OUT NOCOPY varchar2,
391 l_timeout OUT NOCOPY NUMBER);
392
393
394 end icx_sec;