eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WFA_SEC dependencies on FND_PROFILE

Line 267: c_date_format := ''''||NVL(fnd_profile.value_specific(

263: c_territory := ''''||role_info_tbl(1).territory||'''';
264:
265: if (l_user_id is not null) then
266: -- get the date format preference
267: c_date_format := ''''||NVL(fnd_profile.value_specific(
268: 'ICX_DATE_FORMAT_MASK',l_user_id, null, null),'DD-MON-RRRR')||'''';
269: else
270: c_date_format := ''''||NVL(wf_pref.get_pref(user_name,'DATEFORMAT'),
271: 'DD-MON-RRRR')||'''';

Line 598: -- NOT to use current login ctx when calling fnd_profile.value_specific.

594: notification_preference := nvl(WF_PREF.get_pref(name,'MAILTYPE'),
595: 'MAILHTML');
596:
597: -- <7578908> "-1" instead of NULL for ctx parameters other than USER_ID, so that
598: -- NOT to use current login ctx when calling fnd_profile.value_specific.
599: -- Also, in case of null profile value (user and site), getting the session
600: -- values
601: language := nvl(fnd_profile.value_specific('ICX_LANGUAGE',fndUserID /*user_id*/
602: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)

Line 601: language := nvl(fnd_profile.value_specific('ICX_LANGUAGE',fndUserID /user_id/

597: -- <7578908> "-1" instead of NULL for ctx parameters other than USER_ID, so that
598: -- NOT to use current login ctx when calling fnd_profile.value_specific.
599: -- Also, in case of null profile value (user and site), getting the session
600: -- values
601: language := nvl(fnd_profile.value_specific('ICX_LANGUAGE',fndUserID /*user_id*/
602: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)
603: , wf_core.nls_language);
604: territory := nvl(fnd_profile.value_specific('ICX_TERRITORY',fndUserID, -1, -1, -1, -1)
605: , wf_core.nls_territory);

Line 604: territory := nvl(fnd_profile.value_specific('ICX_TERRITORY',fndUserID, -1, -1, -1, -1)

600: -- values
601: language := nvl(fnd_profile.value_specific('ICX_LANGUAGE',fndUserID /*user_id*/
602: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)
603: , wf_core.nls_language);
604: territory := nvl(fnd_profile.value_specific('ICX_TERRITORY',fndUserID, -1, -1, -1, -1)
605: , wf_core.nls_territory);
606:
607: end if;
608: end if;

Line 713: p_nlsCurrency := nvl(fnd_profile.value_specific('ICX_PREFERRED_CURRENCY', l_fndUserID /user_id/

709: else
710: l_fndUserID := p_orig_system_id;
711: end if;
712:
713: p_nlsCurrency := nvl(fnd_profile.value_specific('ICX_PREFERRED_CURRENCY', l_fndUserID /*user_id*/
714: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)
715: , wf_core.nls_currency);
716: p_nlsNumericCharacters := nvl(fnd_profile.value_specific('ICX_NUMERIC_CHARACTERS', l_fndUserID, -1, -1, -1, -1),
717: wf_core.nls_numeric_characters);

Line 716: p_nlsNumericCharacters := nvl(fnd_profile.value_specific('ICX_NUMERIC_CHARACTERS', l_fndUserID, -1, -1, -1, -1),

712:
713: p_nlsCurrency := nvl(fnd_profile.value_specific('ICX_PREFERRED_CURRENCY', l_fndUserID /*user_id*/
714: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)
715: , wf_core.nls_currency);
716: p_nlsNumericCharacters := nvl(fnd_profile.value_specific('ICX_NUMERIC_CHARACTERS', l_fndUserID, -1, -1, -1, -1),
717: wf_core.nls_numeric_characters);
718:
719: -- <8220816> returns default value if profile nls_calendar is null
720: if (fnd_release.major_version = 12 and fnd_release.minor_version >= 1 and fnd_release.point_version>=1)

Line 722: p_nlsCalendar := nvl(fnd_profile.value_specific('FND_FORMS_USER_CALENDAR', l_fndUserID, -1, -1, -1, -1)

718:
719: -- <8220816> returns default value if profile nls_calendar is null
720: if (fnd_release.major_version = 12 and fnd_release.minor_version >= 1 and fnd_release.point_version>=1)
721: or (fnd_release.major_version > 12) then
722: p_nlsCalendar := nvl(fnd_profile.value_specific('FND_FORMS_USER_CALENDAR', l_fndUserID, -1, -1, -1, -1)
723: , wf_core.nls_calendar);
724: end if;
725:
726: p_nlsDateFormat := nvl(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK', l_fndUserID, -1, -1, -1, -1),

Line 726: p_nlsDateFormat := nvl(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK', l_fndUserID, -1, -1, -1, -1),

722: p_nlsCalendar := nvl(fnd_profile.value_specific('FND_FORMS_USER_CALENDAR', l_fndUserID, -1, -1, -1, -1)
723: , wf_core.nls_calendar);
724: end if;
725:
726: p_nlsDateFormat := nvl(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK', l_fndUserID, -1, -1, -1, -1),
727: wf_core.nls_date_format);
728:
729: p_nlsDateLanguage := nvl(
730: nvl(fnd_profile.value_specific('ICX_DATE_LANGUAGE', l_fndUserID, -1, -1, -1, -1) , p_nlsLanguage),

Line 730: nvl(fnd_profile.value_specific('ICX_DATE_LANGUAGE', l_fndUserID, -1, -1, -1, -1) , p_nlsLanguage),

726: p_nlsDateFormat := nvl(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK', l_fndUserID, -1, -1, -1, -1),
727: wf_core.nls_date_format);
728:
729: p_nlsDateLanguage := nvl(
730: nvl(fnd_profile.value_specific('ICX_DATE_LANGUAGE', l_fndUserID, -1, -1, -1, -1) , p_nlsLanguage),
731: wf_core.nls_date_language);
732:
733: p_nlsSort := nvl(fnd_profile.value_specific('ICX_NLS_SORT', l_fndUserID, -1, -1, -1, -1),
734: wf_core.nls_sort);

Line 733: p_nlsSort := nvl(fnd_profile.value_specific('ICX_NLS_SORT', l_fndUserID, -1, -1, -1, -1),

729: p_nlsDateLanguage := nvl(
730: nvl(fnd_profile.value_specific('ICX_DATE_LANGUAGE', l_fndUserID, -1, -1, -1, -1) , p_nlsLanguage),
731: wf_core.nls_date_language);
732:
733: p_nlsSort := nvl(fnd_profile.value_specific('ICX_NLS_SORT', l_fndUserID, -1, -1, -1, -1),
734: wf_core.nls_sort);
735:
736: else -- not an EBS user role, therefore, return PHASE 1 default values
737:

Line 794: result := fnd_profile.value_specific(name=>Get_Profile_Value.name,

790: begin
791: Wf_Directory.GetRoleOrigSysInfo(user_name, l_orig_system, l_orig_system_id);
792:
793: if (instr(l_orig_system, 'FND_USR') > 0) then
794: result := fnd_profile.value_specific(name=>Get_Profile_Value.name,
795: user_id=>l_orig_system_id);
796: elsif ((SUBSTRB(l_orig_system, 1, 8) = 'FND_RESP') and
797: (length(l_orig_system) > 8) and --Make sure we don't just get
798: --'FND_RESP'

Line 802: result := fnd_profile.value_specific(name=>Get_Profile_Value.name,

798: --'FND_RESP'
799: (substr(l_orig_system, 9, 9) between '0' and '9')) then
800: l_application_id := substr(l_orig_system,
801: instr(l_orig_system,'FND_RESP')+8);
802: result := fnd_profile.value_specific(name=>Get_Profile_Value.name,
803: responsibility_id=>l_orig_system_id,
804: application_id=>l_application_id);
805: elsif (instr(l_orig_system, 'PER') > 0) then
806: begin

Line 818: result := fnd_profile.value_specific(name=>Get_Profile_Value.name,

814: when NO_DATA_FOUND then
815: l_user_id := to_number(null);
816: end;
817: if (l_user_id is not null) then
818: result := fnd_profile.value_specific(name=>Get_Profile_Value.name,
819: user_id=>l_user_id);
820: else
821: result := null;
822: end if;

Line 884: fnd_profile.get('WF_ICX_MODE',x_mode);

880: function DirectLogin (nid in NUMBER) return VARCHAR2
881: IS
882: x_mode varchar2(30);
883: BEGIN
884: fnd_profile.get('WF_ICX_MODE',x_mode);
885:
886: return ('OracleApps.DF?i_direct=' || WFA_SEC.DetailURL(nid) || '&i_mode=' ||
887: nvl(x_mode,'2'));
888: