230: v_user_id NUMBER;
231: v_resp_id NUMBER;
232: v_resp_appl_id NUMBER;
233: v_lang VARCHAR2(100);
234: v_session_lang VARCHAR2(100):=fnd_global.current_language;
235: v_return VARCHAR2(10):='T';
236: V_NLS_LANG VARCHAR2(100);
237: v_org_id NUMBER;
238: /* Cursor to get the user id information based on the input user name */
279: CLOSE cur_resp;
280:
281:
282: /* Setting the oracle applications context for the particular session */
283: fnd_global.apps_initialize ( user_id => v_user_id
284: ,resp_id => v_resp_id
285: ,RESP_APPL_ID => V_RESP_APPL_ID
286: ,SECURITY_GROUP_ID => P_SECURITY_GROUP_ID);
287: --,server_id => p_server_id);
286: ,SECURITY_GROUP_ID => P_SECURITY_GROUP_ID);
287: --,server_id => p_server_id);
288: /* setting the nls context for the particular session */
289: /*
290: FND_GLOBAL.SET_NLS_CONTEXT( P_NLS_LANGUAGE => P_NLS_LANGUAGE
291: ,P_NLS_DATE_FORMAT => P_NLS_DATE_FORMAT
292: ,P_NLS_DATE_LANGUAGE => P_NLS_DATE_LANGUAGE
293: ,P_NLS_NUMERIC_CHARACTERS => P_NLS_NUMERIC_CHARACTERS
294: ,P_NLS_SORT => P_NLS_SORT
299: THEN
300: OPEN cur_lang(v_lang);
301: FETCH cur_lang INTO v_nls_lang;
302: CLOSE cur_lang;
303: fnd_global.set_nls_context(v_nls_lang);
304: END IF; --IF v_session_lang != v_lang
305: */
306: RETURN v_return;
307: EXCEPTION