1 package FND_AOLJ_UTIL AUTHID CURRENT_USER as
2 /* $Header: AFAJUTLS.pls 120.5 2006/09/18 09:13:08 stadepal ship $ */
3 /*#
4 * This package is for internal use. It provides api's which are currently used
5 * by AOLJ group for fetching context values to minimize number of roundtrips.
6 * @rep:scope private
7 * @rep:product FND
8 * @rep:displayname Session Api's for AOLJ
9 * @rep:lifecycle active
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY FND_APPS_CTX
12 */
13
14 /*
15 ** MULTI_PROFILE_VALUE_SPECIFIC - Get profile values for a specific user/resp/appl
16 ** in group to minimize # of roundtips
17 ** Default user/resp/appl is current login.
18 */
19 function MULTI_PROFILE_VALUE_SPECIFIC(
20 NUMOFNAMES in number default 1,
21 NAMES in varchar2,
22 USER_ID in number default null,
23 RESPONSIBILITY_ID in number default null,
24 APPLICATION_ID in number default null)
25 return varchar2;
26
27 /*
28 -- SET_NLS_CONTEXT
29 --
30 -- Description: Calls alter session to set the following values in DB.
31 -- NLS_LANGUAGE, NLS_DATE_FORMAT,NLS_DATE_LANGUAGE, NLS_SORT
32 -- NLS_TERRITORY,NLS_NUMERIC_CHARACTERS
33 */
34
35
36 PROCEDURE set_nls_context( p_nls_language IN VARCHAR2 DEFAULT NULL,
37 p_nls_date_format IN VARCHAR2 DEFAULT NULL,
38 p_nls_date_language IN VARCHAR2 DEFAULT NULL,
39 p_nls_numeric_characters IN VARCHAR2 DEFAULT NULL,
40 p_nls_sort IN VARCHAR2 DEFAULT NULL,
41 p_nls_territory IN VARCHAR2 DEFAULT NULL,
42 p_db_nls_language OUT NOCOPY VARCHAR2,
43 p_db_nls_date_format OUT NOCOPY VARCHAR2,
44 p_db_nls_date_language OUT NOCOPY VARCHAR2,
45 p_db_nls_numeric_characters OUT NOCOPY VARCHAR2,
46 p_db_nls_sort OUT NOCOPY VARCHAR2,
47 p_db_nls_territory OUT NOCOPY VARCHAR2,
48 p_db_nls_charset OUT NOCOPY VARCHAR2
49 );
50
51
52 /* -- getClassVersionFromDB
53 --
54 -- Prints out version information for Java classes stored in the database
55 --
56 -- getClassVersionFromDB(p_classname VARCHAR2) -- Print out the version for a single class
57 -- getClassVersionFromDB -- Print out version information for all Java classes
58 --
59 -- Calls a Java stored procedure which writes to System.out, so when used from SQL*Plus,
60 -- SET SERVEROUTPUT ON needs to be used.
61 --
62 -- EX: To display the version of Log.java from SQL*Plus:
63 --
64 -- SQL> set serveroutput on
65 -- SQL> execute fnd_aolj_util.getClassVersionFromDB('oracle.apps.fnd.common.Log');
66 -- >>> Class: oracle.apps.fnd.common.Log
67 -- ... : Log.java 115.8 2002/02/08 19:20:20 mskees ship $
68 --
69 -- PL/SQL procedure successfully completed.
70 */
71 PROCEDURE getClassVersionFromDB;
72 PROCEDURE getClassVersionFromDB(p_classname VARCHAR2);
73
74 /* For AOL INTERNAL USE ONLY!!
75 */
76 /*#
77 * Creates new icx session, validates it and returns session id.
78 * @param p_user_id User Id
79 * @param p_server_id Server Id
80 * @param p_language_code Language Code. If passed in and is one of the
81 * installed languages, the language code and nls language settings for the
82 * session to be created will overwrite what's specified in the nls
83 * profiles. The other nls settings will still get their values from the
84 * profiles.
85 * @param p_function_code Function Code
86 * @param p_validate_only Y/N flag
87 * @param p_commit TRUE/FALSE. If TRUE updates last_connect and counter in ICX_SESSIONS
88 * @param p_update TRUE/FALSE. If TRUE updates last_connect and counter in ICX_SESSIONS
89 * @param p_responsibility_id Responsibility Id
90 * @param p_function_id Function Id
91 * @param p_resp_appl_id Responsibility's Application Id
92 * @param p_security_group_id Security Group Id
93 * @param p_home_url Home URL
94 * @param p_proxy_user User Id of the Proxy User. It's not null for the
95 * proxy sessions and null for the normal sessions.
96 * @param mode_code Mode of the session. Different values for mode are 115P for SSWA, 115J for SSWA with SSO, else 115X.
97 * @param session_id Session Id
98 * @param transaction_id Transaction Id
99 * @param user_id Session's User Id
100 * @param responsibility_id Session's Responsibility Id
101 * @param resp_appl_id Session's Responsibility Application Id
102 * @param security_group_id Session's Security Group Id
103 * @param language_code Session's Language Code
104 * @param nls_language Session's NLS Language
105 * @param date_format_mask Session's Date Format Mask
106 * @param nls_date_language Session's NLS Date Language
107 * @param nls_numeric_characters Session's NLS Numeric Characters
108 * @param nls_sort Session's NLS Sort
109 * @param nls_territory Session's NLS Territory
110 * @param login_id Session's Login Id
111 * @param xsid Session's XSID
112 * @return Y/N flag indicating whether session is created or not
113 * @rep:lifecycle active
114 * @rep:displayname Create new session
115 * @rep:compatibility S
116 */
117 function createSession(
118 p_user_id in number,
119 p_server_id in varchar2,
120 p_language_code in varchar2,
121 p_function_code in varchar2,
122 p_validate_only in varchar2,
123 p_commit in boolean,
124 p_update in boolean,
125 p_responsibility_id in number,
126 p_function_id in number,
127 p_resp_appl_id in number,
128 p_security_group_id in number,
129 p_home_url in varchar2,
130 p_proxy_user in number,
131 mode_code in out nocopy varchar2,
132 session_id out nocopy number,
133 transaction_id out nocopy number,
134 user_id out nocopy number,
135 responsibility_id out nocopy number,
136 resp_appl_id out nocopy number,
137 security_group_id out nocopy number,
138 language_code out nocopy varchar2,
139 nls_language out nocopy varchar2,
140 date_format_mask out nocopy varchar2,
141 nls_date_language out nocopy varchar2,
142 nls_numeric_characters out nocopy varchar2,
143 nls_sort out nocopy varchar2,
144 nls_territory out nocopy varchar2,
145 login_id out nocopy number,
146 xsid out nocopy varchar2
147 ) return VARCHAR2;
148
149 /* -- is_Valid_ICX() -- For AOL INTERNAL USE ONLY!!!!
150 This function is a wrapper to ICX_SEC.validateSessionPrivate and is added for
151 bug 2246010, to synchronise with ICX changes and to provide for a single call
152 interface from all WebAppsContext.validateSession() methods via the method
153 WebAppsContext.doValidateSession().
154 */
155 function is_Valid_ICX(
156 p_session_id in varchar2,
157 p_function_code in varchar2,
158 p_validate_only in varchar2,
159 p_commit in boolean,
160 p_update in boolean,
161 p_responsibility_id in number,
162 p_function_id in number,
163 p_resp_appl_id in number,
164 p_security_group_id in number,
165 p_validate_mode_on in varchar2,
166 p_transaction_id in varchar2,
167 session_id out nocopy number,
168 transaction_id out nocopy number,
169 user_id out nocopy number,
170 responsibility_id out nocopy number,
171 resp_appl_id out nocopy number,
172 security_group_id out nocopy number,
173 language_code out nocopy varchar2,
174 nls_language out nocopy varchar2,
175 date_format_mask out nocopy varchar2,
176 nls_date_language out nocopy varchar2,
177 nls_numeric_characters out nocopy varchar2,
178 nls_sort out nocopy varchar2,
179 nls_territory out nocopy varchar2,
180 login_id out nocopy number,
181 p_isEncrypt in boolean )
182 return varchar2;
183
184 /* for AOL internal use only */
185 function convertGuestSession(
186 p_user_id in number,
187 p_server_id in varchar2,
188 p_session_id in varchar2,
189 p_language_code in varchar2,
190 p_function_code in varchar2,
191 p_validate_only in varchar2,
192 p_commit in boolean,
193 p_update in boolean,
194 p_responsibility_id in number,
195 p_function_id in number,
196 p_resp_appl_id in number,
197 p_security_group_id in number,
198 p_home_url in varchar2,
199 p_mode_code in out nocopy varchar2,
200 session_id out nocopy number,
201 transaction_id out nocopy number,
202 user_id out nocopy number,
203 responsibility_id out nocopy number,
204 resp_appl_id out nocopy number,
205 security_group_id out nocopy number,
206 language_code out nocopy varchar2,
207 nls_language out nocopy varchar2,
208 date_format_mask out nocopy varchar2,
209 nls_date_language out nocopy varchar2,
210 nls_numeric_characters out nocopy varchar2,
211 nls_sort out nocopy varchar2,
212 nls_territory out nocopy varchar2,
213 login_id out nocopy number
214 ) return VARCHAR2;
215
216 PROCEDURE display_AOLJ_RUP;
217
218 end FND_AOLJ_UTIL;
219