APPS.FND_GLOBAL dependencies on DBMS_SESSION

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

1256: --
1257: -- SET_NLS
1258: --
1259: -- This is the main NLS routine. All others call into this routine to set
1260: -- NLS values by calling dbms_session.set_nls (i.e. alter session) to set
1261: -- the following values in DB.
1262: --
1263: -- Notes:
1264: -- - Side effects of setting certain values

Line 1311: -- calls dbms_session.set_nls

1307: v_nls_characterset v$nls_parameters.value%type
1308: := get(FND_CONST.NLS_CHARACTERSET);
1309:
1310: --
1311: -- calls dbms_session.set_nls
1312: function set_parameter(p_parameter varchar2, p_value in varchar2)
1313: return boolean is
1314: begin
1315:

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

1318: return false;
1319: end if;
1320:
1321: if has_changed(p_parameter,p_value) then
1322: dbms_session.set_nls(p_parameter, '"'|| p_value ||'"');
1323: put(p_parameter,p_value);
1324: return true;
1325: end if;
1326:

Line 1338: -- calls dbms_session.set_nls

1334: sqlcode, dbms_utility.format_error_stack);
1335: end set_parameter;
1336:
1337: --
1338: -- calls dbms_session.set_nls
1339: procedure set_parameter(p_parameter varchar2, p_value in varchar2)
1340: is
1341: result boolean;
1342: begin

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

1385: z_context(FND_CONST.NLS_DATE_FORMAT) := null;
1386: z_context(FND_CONST.NLS_NUMERIC_CHARACTERS) := null;
1387: end if;
1388:
1389: -- Requery derived values to avoid calling dbms_session.set_nls
1390: -- in case the derived value is the same as the passed parameter value.
1391: -- In other words, it ensures that the following set_parameter calls
1392: -- don't do anything if the value in the database is the same as the
1393: -- passed parameter due to the value passed already being the default

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

1391: -- In other words, it ensures that the following set_parameter calls
1392: -- don't do anything if the value in the database is the same as the
1393: -- passed parameter due to the value passed already being the default
1394: -- for the specified language or territory.
1395: -- This is where bug 5080655 and the improvement to dbms_session.set_nls
1396: -- affects us since we have to retain the nls values in the cache since
1397: -- we have code the depends on knowing when nls context changes.
1398: if (v_nls_language is not null
1399: and (v_nls_date_language is null

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

2100: end;
2101:
2102: --
2103: -- Call routine to load MultiOrg and Multi-Currency info into
2104: -- the RDBMS session-level global variable that we read when we
2105: -- call USERENV('CLIENT_INFO')
2106: --
2107: if security_context_changed then
2108: fnd_client_info.setup_client_info(resp_appl_id,

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

2143: begin
2144: begin
2145: fnd_profile.get('FND_RESOURCE_CONSUMER_GROUP', pro_rcg);
2146: if (pro_rcg is not null) then -- bug 4466432
2147: dbms_session.switch_current_consumer_group(pro_rcg,old_rcg,FALSE);
2148: end if;
2149: end;
2150: exception
2151: when others then