DBA Data[Home] [Help]

APPS.ORACLEAPPS dependencies on FND_GLOBAL

Line 346: FND_GLOBAL.set_nls_context(

342:
343:
344: end if;
345:
346: FND_GLOBAL.set_nls_context(
347: p_nls_language => l_language,
348: p_nls_territory =>'AMERICA');
349: --next 4 lines removed in favor of above call -- mputman
350: -- l_date_format := ''''||l_date_format||'''';

Line 470: FND_GLOBAL.set_nls_context(

466: l_date_format:=icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT'); -- replaces above select mputman 1574527
467:
468:
469: end if;
470: FND_GLOBAL.set_nls_context(
471: p_nls_language => l_language,
472: p_nls_territory =>'AMERICA');
473:
474: --next 4 lines removed in favor of above call. -- mputman

Line 800: --dbms_session.set_nls('NLS_LANGUAGE' , c_nls_language); --replaced with call to fnd_global

796: and nvl(icx_sec.g_language_c,'XXXXX') <> l_nls_lang
797: then
798: c_nls_language := l_nls_lang;
799: --c_nls_language := ''''||l_nls_lang||'''';
800: --dbms_session.set_nls('NLS_LANGUAGE' , c_nls_language); --replaced with call to fnd_global
801: icx_sec.g_language_c:=l_nls_lang;
802: FND_GLOBAL.set_nls_context(p_nls_language =>c_nls_language);
803: end if;
804:

Line 802: FND_GLOBAL.set_nls_context(p_nls_language =>c_nls_language);

798: c_nls_language := l_nls_lang;
799: --c_nls_language := ''''||l_nls_lang||'''';
800: --dbms_session.set_nls('NLS_LANGUAGE' , c_nls_language); --replaced with call to fnd_global
801: icx_sec.g_language_c:=l_nls_lang;
802: FND_GLOBAL.set_nls_context(p_nls_language =>c_nls_language);
803: end if;
804:
805:
806:

Line 1505: FND_GLOBAL.set_nls_context(

1501: from icx_sessions
1502: where session_id = n_session_id;
1503:
1504: l_session_id := n_session_id;
1505: FND_GLOBAL.set_nls_context(
1506: p_nls_language => l_language,
1507: p_nls_territory =>'AMERICA');
1508: --next 4 lines removed in favor of above call -- mputman
1509: -- l_date_format := ''''||l_date_format||'''';

Line 4006: -- call fnd_global.set_nls to get return vals for date_lang and sort.

4002: from fnd_languages
4003: where nls_language = c_LANGUAGE;
4004: -- bug 2656698
4005: -- get prof option vals for date_lang and sort.
4006: -- call fnd_global.set_nls to get return vals for date_lang and sort.
4007: -- when the prof vals are null, use the returns from fnd_global in the update to icx_sessions.
4008:
4009: fnd_profile.get(name => 'ICX_NLS_SORT',
4010: val => prof_sort);

Line 4007: -- when the prof vals are null, use the returns from fnd_global in the update to icx_sessions.

4003: where nls_language = c_LANGUAGE;
4004: -- bug 2656698
4005: -- get prof option vals for date_lang and sort.
4006: -- call fnd_global.set_nls to get return vals for date_lang and sort.
4007: -- when the prof vals are null, use the returns from fnd_global in the update to icx_sessions.
4008:
4009: fnd_profile.get(name => 'ICX_NLS_SORT',
4010: val => prof_sort);
4011: fnd_profile.get(name => 'ICX_DATE_LANGUAGE',

Line 4014: fnd_global.set_nls(

4010: val => prof_sort);
4011: fnd_profile.get(name => 'ICX_DATE_LANGUAGE',
4012: val => prof_date_lang);
4013:
4014: fnd_global.set_nls(
4015: p_nls_language => c_LANGUAGE,
4016: p_nls_date_format => l_date_format,
4017: p_nls_date_language => NULL,
4018: p_nls_numeric_characters => c_NUMERIC_CHARACTERS,

Line 4032: z_sort :=prof_sort; --profile is null.. use value returned from fnd_global

4028:
4029: IF (prof_sort IS NULL) THEN
4030: z_sort :=p_db_nls_sort; --profile is not null.. use profile value
4031: ELSE
4032: z_sort :=prof_sort; --profile is null.. use value returned from fnd_global
4033: END IF;
4034:
4035: IF (prof_date_lang IS NULL) THEN
4036: z_date_lang :=p_db_nls_date_language; --profile is not null.. use profile value

Line 4038: z_date_lang :=prof_date_lang; --profile is null.. use value returned from fnd_global

4034:
4035: IF (prof_date_lang IS NULL) THEN
4036: z_date_lang :=p_db_nls_date_language; --profile is not null.. use profile value
4037: ELSE
4038: z_date_lang :=prof_date_lang; --profile is null.. use value returned from fnd_global
4039: END IF;
4040: --added date_lang and sort to the update for 2656698
4041: update icx_sessions
4042: set nls_language = c_LANGUAGE,

Line 4529: FND_GLOBAL.set_nls_context(p_nls_language =>c_nls_language);

4525: into c_language_code, c_nls_language
4526: from FND_LANGUAGES
4527: where INSTALLED_FLAG = 'B';
4528: end;
4529: FND_GLOBAL.set_nls_context(p_nls_language =>c_nls_language);
4530: --c_nls_language := ''''||c_nls_language||'''';
4531: --dbms_session.set_nls('NLS_LANGUAGE' , c_nls_language);--removed in favor of above call to fnd_global -- mputman
4532: end if;
4533: fnd_profile.get(name => 'ENABLE_SECURITY_GROUPS',

Line 4531: --dbms_session.set_nls('NLS_LANGUAGE' , c_nls_language);--removed in favor of above call to fnd_global -- mputman

4527: where INSTALLED_FLAG = 'B';
4528: end;
4529: FND_GLOBAL.set_nls_context(p_nls_language =>c_nls_language);
4530: --c_nls_language := ''''||c_nls_language||'''';
4531: --dbms_session.set_nls('NLS_LANGUAGE' , c_nls_language);--removed in favor of above call to fnd_global -- mputman
4532: end if;
4533: fnd_profile.get(name => 'ENABLE_SECURITY_GROUPS',
4534: val => l_hosted_profile);
4535:

Line 4739: FND_GLOBAL.set_nls_context(p_nls_language => l_language);

4735: select nls_language
4736: into l_language
4737: from fnd_languages_vl
4738: where LANGUAGE_CODE = l_language_code;
4739: FND_GLOBAL.set_nls_context(p_nls_language => l_language);
4740:
4741: EXCEPTION
4742: WHEN OTHERS THEN
4743: l_language_code :=''; -- bogus value, set to null

Line 4753: fnd_global.SET_SECURITY_GROUP_ID_CONTEXT(i_S);

4749: IF ((i_1 IS NOT NULL) AND (i_2 IS NOT NULL)) THEN
4750:
4751: IF ((b_hosted) AND (i_S IS NOT NULL)) THEN
4752:
4753: fnd_global.SET_SECURITY_GROUP_ID_CONTEXT(i_S);
4754: --fnd_global.apps_initialize(user_id => -1,
4755: -- resp_id => -1,
4756: -- resp_appl_id => -1,
4757: -- security_group_id => i_S);--mputman hosted update

Line 4754: --fnd_global.apps_initialize(user_id => -1,

4750:
4751: IF ((b_hosted) AND (i_S IS NOT NULL)) THEN
4752:
4753: fnd_global.SET_SECURITY_GROUP_ID_CONTEXT(i_S);
4754: --fnd_global.apps_initialize(user_id => -1,
4755: -- resp_id => -1,
4756: -- resp_appl_id => -1,
4757: -- security_group_id => i_S);--mputman hosted update
4758: END IF;