DBA Data[Home] [Help]

APPS.WF_NOTIFICATION dependencies on WF_LANGUAGES

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

1275:
1276: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
1277: l_language := role_info_tbl(1).language;
1278:
1279: select code into l_language from wf_languages where nls_language = l_language;
1280:
1281: -- AppSearch
1282: wf_event.AddParameterToList('OBJECT_NAME',
1283: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

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

3992:
3993: Wf_Directory.GetRoleInfo2(sendsingle.role, role_info_tbl);
3994: l_language := role_info_tbl(1).language;
3995:
3996: select code into l_language from wf_languages where nls_language = l_language;
3997:
3998: -- AppSearch
3999: wf_event.AddParameterToList('OBJECT_NAME',
4000: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

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

4569:
4570: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
4571: l_language := role_info_tbl(1).language;
4572:
4573: select code into l_language from wf_languages where nls_language = l_language;
4574:
4575: -- AppSearch
4576: wf_event.AddParameterToList('OBJECT_NAME',
4577: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

Line 6184: from WF_LANGUAGES

6180: return;
6181: end if;
6182: select NLS_LANGUAGE
6183: into l_language
6184: from WF_LANGUAGES
6185: where CODE = langcode;
6186: -- ### and INSTALLED_FLAG = 'Y';
6187: -- ### Maybe we do not need to restrict installed flag to be Y
6188: end if;

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

6874:
6875: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);
6876: l_language := role_info_tbl(1).language;
6877:
6878: select code into l_language from wf_languages where nls_language = l_language;
6879:
6880: -- AppSearch
6881: wf_event.AddParameterToList('OBJECT_NAME',
6882: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

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

7132:
7133: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);
7134: l_language := role_info_tbl(1).language;
7135:
7136: select code into l_language from wf_languages where nls_language = l_language;
7137:
7138: -- AppSearch
7139: wf_event.AddParameterToList('OBJECT_NAME',
7140: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

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

7779:
7780: Wf_Directory.GetRoleInfo2(l_recip_role, role_info_tbl);
7781: l_language := role_info_tbl(1).language;
7782:
7783: select code into l_language from wf_languages where nls_language = l_language;
7784:
7785:
7786: -- AppSearch
7787: wf_event.AddParameterToList('OBJECT_NAME',

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

7938:
7939: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
7940: l_language := role_info_tbl(1).language;
7941:
7942: select code into l_language from wf_languages where nls_language = l_language;
7943:
7944: -- AppSearch
7945: wf_event.AddParameterToList('OBJECT_NAME',
7946: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_parameterlist);

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

9139: -- Append the language_code to the fwk URL to set session p_language
9140: if (p_language is not null) then
9141: begin
9142:
9143: select code into lang_code from wf_languages where nls_language=p_language;
9144: url_value := url_value || '&language_code='|| lang_code;
9145:
9146: exception
9147: when others then

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

9529:
9530: Wf_Directory.GetRoleInfo2(l_recipient_role, role_info_tbl);
9531: l_language := role_info_tbl(1).language;
9532:
9533: select code into l_language from wf_languages where nls_language = l_language;
9534:
9535: -- AppSearch
9536: wf_event.AddParameterToList('OBJECT_NAME',
9537: 'oracle.apps.fnd.wf.worklist.server.AllNotificationsVO', l_paramlist);