APPS.WF_NOTIFICATION dependencies on WF_LANGUAGES

Line 1240: select code into l_language from wf_languages where nls_language = l_language;

1236:
1237: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
1238: l_language := role_info_tbl(1).language;
1239:
1240: select code into l_language from wf_languages where nls_language = l_language;
1241:
1242: -- AppSearch
1243: wf_event.AddParameterToList('OBJECT_NAME',
1244: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

Line 3866: select code into l_language from wf_languages where nls_language = l_language;

3862:
3863: Wf_Directory.GetRoleInfo2(sendsingle.role, role_info_tbl);
3864: l_language := role_info_tbl(1).language;
3865:
3866: select code into l_language from wf_languages where nls_language = l_language;
3867:
3868: -- AppSearch
3869: wf_event.AddParameterToList('OBJECT_NAME',
3870: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

Line 4408: select code into l_language from wf_languages where nls_language = l_language;

4404:
4405: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
4406: l_language := role_info_tbl(1).language;
4407:
4408: select code into l_language from wf_languages where nls_language = l_language;
4409:
4410: -- AppSearch
4411: wf_event.AddParameterToList('OBJECT_NAME',
4412: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

Line 6354: from WF_LANGUAGES

6350: return;
6351: end if;
6352: select NLS_LANGUAGE
6353: into l_language
6354: from WF_LANGUAGES
6355: where CODE = langcode;
6356: -- ### and INSTALLED_FLAG = 'Y';
6357: -- ### Maybe we do not need to restrict installed flag to be Y
6358: end if;

Line 7078: select code into l_language from wf_languages where nls_language = l_language;

7074:
7075: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);
7076: l_language := role_info_tbl(1).language;
7077:
7078: select code into l_language from wf_languages where nls_language = l_language;
7079:
7080: -- AppSearch
7081: wf_event.AddParameterToList('OBJECT_NAME',
7082: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

Line 7557: select code into l_language from wf_languages where nls_language = l_language;

7553:
7554: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);
7555: l_language := role_info_tbl(1).language;
7556:
7557: select code into l_language from wf_languages where nls_language = l_language;
7558:
7559:
7560: -- AppSearch
7561: wf_event.AddParameterToList('OBJECT_NAME',

Line 7716: select code into l_language from wf_languages where nls_language = l_language;

7712:
7713: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
7714: l_language := role_info_tbl(1).language;
7715:
7716: select code into l_language from wf_languages where nls_language = l_language;
7717:
7718: -- AppSearch
7719: wf_event.AddParameterToList('OBJECT_NAME',
7720: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

Line 8892: select code into lang_code from wf_languages where nls_language=p_language;

8888: -- Append the language_code to the fwk URL to set session p_language
8889: if (p_language is not null) then
8890: begin
8891:
8892: select code into lang_code from wf_languages where nls_language=p_language;
8893: url_value := url_value || '&language_code='|| lang_code;
8894:
8895: exception
8896: when others then

Line 9285: select code into l_language from wf_languages where nls_language = l_language;

9281:
9282: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
9283: l_language := role_info_tbl(1).language;
9284:
9285: select code into l_language from wf_languages where nls_language = l_language;
9286:
9287: -- AppSearch
9288: wf_event.AddParameterToList('OBJECT_NAME',
9289: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_paramlist);