APPS.FND_GLOBAL dependencies on DBMS_SESSION

Line 1418: -- NLS values by calling dbms_session.set_nls (i.e. alter session) to set

1414: --
1415: -- SET_NLS
1416: --
1417: -- This is the main NLS routine. All others call into this routine to set
1418: -- NLS values by calling dbms_session.set_nls (i.e. alter session) to set
1419: -- the following values in DB.
1420: --
1421: -- Notes:
1422: -- - Side effects of setting certain values

Line 1469: -- calls dbms_session.set_nls

1465: v_nls_characterset v$nls_parameters.value%type
1466: := get(FND_CONST.NLS_CHARACTERSET);
1467:
1468: --
1469: -- calls dbms_session.set_nls
1470: function set_parameter(p_parameter varchar2, p_value in varchar2)
1471: return boolean is
1472: begin
1473:

Line 1480: dbms_session.set_nls(p_parameter, '"'|| p_value ||'"');

1476: return false;
1477: end if;
1478:
1479: if has_changed(p_parameter,p_value) then
1480: dbms_session.set_nls(p_parameter, '"'|| p_value ||'"');
1481: put(p_parameter,p_value);
1482: return true;
1483: end if;
1484:

Line 1496: -- calls dbms_session.set_nls

1492: sqlcode, dbms_utility.format_error_stack);
1493: end set_parameter;
1494:
1495: --
1496: -- calls dbms_session.set_nls
1497: procedure set_parameter(p_parameter varchar2, p_value in varchar2)
1498: is
1499: result boolean;
1500: begin

Line 1547: -- Requery derived values to avoid calling dbms_session.set_nls

1543: z_context(FND_CONST.NLS_DATE_FORMAT) := null;
1544: z_context(FND_CONST.NLS_NUMERIC_CHARACTERS) := null;
1545: end if;
1546:
1547: -- Requery derived values to avoid calling dbms_session.set_nls
1548: -- in case the derived value is the same as the passed parameter value.
1549: -- In other words, it ensures that the following set_parameter calls
1550: -- don't do anything if the value in the database is the same as the
1551: -- passed parameter due to the value passed already being the default

Line 1553: -- This is where bug 5080655 and the improvement to dbms_session.set_nls

1549: -- In other words, it ensures that the following set_parameter calls
1550: -- don't do anything if the value in the database is the same as the
1551: -- passed parameter due to the value passed already being the default
1552: -- for the specified language or territory.
1553: -- This is where bug 5080655 and the improvement to dbms_session.set_nls
1554: -- affects us since we have to retain the nls values in the cache since
1555: -- we have code the depends on knowing when nls context changes.
1556: if (v_nls_language is not null
1557: and (v_nls_date_language is null

Line 2325: -- the RDBMS session-level global variable that we read when we

2321: end;
2322:
2323: --
2324: -- Call routine to load MultiOrg and Multi-Currency info into
2325: -- the RDBMS session-level global variable that we read when we
2326: -- call USERENV('CLIENT_INFO')
2327: --
2328: if security_context_changed then
2329: fnd_client_info.setup_client_info(resp_appl_id,

Line 2381: dbms_session.switch_current_consumer_group(pro_rcg,old_rcg,FALSE);

2377: begin
2378: begin
2379: fnd_profile.get('FND_RESOURCE_CONSUMER_GROUP', pro_rcg);
2380: if (pro_rcg is not null) then -- bug 4466432
2381: dbms_session.switch_current_consumer_group(pro_rcg,old_rcg,FALSE);
2382: end if;
2383: end;
2384: exception
2385: when others then

Line 3117: dbms_session.set_identifier(username);

3113: action := p_resp_appl || '/' || p_resp_key;
3114: end if;
3115: end if;
3116:
3117: dbms_session.set_identifier(username);
3118: -- Set the module and action field of v$session
3119: dbms_application_info.set_module(module,action);
3120: exception
3121: when others then