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 278: c_date_format := ''''||NVL(fnd_profile.value_specific(

274: c_territory := ''''||role_info_tbl(1).territory||'''';
275:
276: if (l_user_id is not null) then
277: -- get the date format preference
278: c_date_format := ''''||NVL(fnd_profile.value_specific(
279: 'ICX_DATE_FORMAT_MASK',l_user_id, null, null),'DD-MON-RRRR')||'''';
280: else
281: c_date_format := ''''||NVL(wf_pref.get_pref2(user_name,'DATEFORMAT','WFDS'),
282: 'DD-MON-RRRR')||'''';

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

606: end if;
607:
608:
609: -- <7578908> "-1" instead of NULL for ctx parameters other than USER_ID, so that
610: -- NOT to use current login ctx when calling fnd_profile.value_specific.
611: -- Also, in case of null profile value (user and site), getting the session
612: -- values
613: language := nvl(fnd_profile.value_specific('ICX_LANGUAGE',fndUserID /*user_id*/
614: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)

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

609: -- <7578908> "-1" instead of NULL for ctx parameters other than USER_ID, so that
610: -- NOT to use current login ctx when calling fnd_profile.value_specific.
611: -- Also, in case of null profile value (user and site), getting the session
612: -- values
613: language := nvl(fnd_profile.value_specific('ICX_LANGUAGE',fndUserID /*user_id*/
614: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)
615: , wf_core.nls_language);
616: territory := nvl(fnd_profile.value_specific('ICX_TERRITORY',fndUserID, -1, -1, -1, -1)
617: , wf_core.nls_territory);

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

612: -- values
613: language := nvl(fnd_profile.value_specific('ICX_LANGUAGE',fndUserID /*user_id*/
614: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)
615: , wf_core.nls_language);
616: territory := nvl(fnd_profile.value_specific('ICX_TERRITORY',fndUserID, -1, -1, -1, -1)
617: , wf_core.nls_territory);
618:
619: end if;
620: end if;

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

721: else
722: l_fndUserID := p_orig_system_id;
723: end if;
724:
725: p_nlsCurrency := nvl(fnd_profile.value_specific('ICX_PREFERRED_CURRENCY', l_fndUserID /*user_id*/
726: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)
727: , wf_core.nls_currency);
728: p_nlsNumericCharacters := nvl(fnd_profile.value_specific('ICX_NUMERIC_CHARACTERS', l_fndUserID, -1, -1, -1, -1),
729: wf_core.nls_numeric_characters);

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

724:
725: p_nlsCurrency := nvl(fnd_profile.value_specific('ICX_PREFERRED_CURRENCY', l_fndUserID /*user_id*/
726: , -1 /*resp_id*/, -1 /*app_id*/, -1 /*org_id*/, -1 /*server_id*/)
727: , wf_core.nls_currency);
728: p_nlsNumericCharacters := nvl(fnd_profile.value_specific('ICX_NUMERIC_CHARACTERS', l_fndUserID, -1, -1, -1, -1),
729: wf_core.nls_numeric_characters);
730:
731: p_nlsCalendar := nvl(fnd_profile.value_specific('FND_FORMS_USER_CALENDAR', l_fndUserID, -1, -1, -1, -1)
732: , wf_core.nls_calendar);

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

727: , wf_core.nls_currency);
728: p_nlsNumericCharacters := nvl(fnd_profile.value_specific('ICX_NUMERIC_CHARACTERS', l_fndUserID, -1, -1, -1, -1),
729: wf_core.nls_numeric_characters);
730:
731: p_nlsCalendar := nvl(fnd_profile.value_specific('FND_FORMS_USER_CALENDAR', l_fndUserID, -1, -1, -1, -1)
732: , wf_core.nls_calendar);
733:
734: p_nlsDateFormat := nvl(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK', l_fndUserID, -1, -1, -1, -1),
735: wf_core.nls_date_format);

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

730:
731: p_nlsCalendar := nvl(fnd_profile.value_specific('FND_FORMS_USER_CALENDAR', l_fndUserID, -1, -1, -1, -1)
732: , wf_core.nls_calendar);
733:
734: p_nlsDateFormat := nvl(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK', l_fndUserID, -1, -1, -1, -1),
735: wf_core.nls_date_format);
736:
737: p_nlsDateLanguage := nvl(
738: nvl(fnd_profile.value_specific('ICX_DATE_LANGUAGE', l_fndUserID, -1, -1, -1, -1) , p_nlsLanguage),

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

734: p_nlsDateFormat := nvl(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK', l_fndUserID, -1, -1, -1, -1),
735: wf_core.nls_date_format);
736:
737: p_nlsDateLanguage := nvl(
738: nvl(fnd_profile.value_specific('ICX_DATE_LANGUAGE', l_fndUserID, -1, -1, -1, -1) , p_nlsLanguage),
739: wf_core.nls_date_language);
740:
741: p_nlsSort := nvl(fnd_profile.value_specific('ICX_NLS_SORT', l_fndUserID, -1, -1, -1, -1),
742: wf_core.nls_sort);

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

737: p_nlsDateLanguage := nvl(
738: nvl(fnd_profile.value_specific('ICX_DATE_LANGUAGE', l_fndUserID, -1, -1, -1, -1) , p_nlsLanguage),
739: wf_core.nls_date_language);
740:
741: p_nlsSort := nvl(fnd_profile.value_specific('ICX_NLS_SORT', l_fndUserID, -1, -1, -1, -1),
742: wf_core.nls_sort);
743:
744: else -- not an EBS user role, therefore, return PHASE 1 default values
745:

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

798: begin
799: Wf_Directory.GetRoleOrigSysInfo(user_name, l_orig_system, l_orig_system_id);
800:
801: if (instr(l_orig_system, 'FND_USR') > 0) then
802: result := fnd_profile.value_specific(name=>Get_Profile_Value.name,
803: user_id=>l_orig_system_id);
804: elsif ((SUBSTRB(l_orig_system, 1, 8) = 'FND_RESP') and
805: (length(l_orig_system) > 8) and --Make sure we don't just get
806: --'FND_RESP'

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

806: --'FND_RESP'
807: (substr(l_orig_system, 9, 9) between '0' and '9')) then
808: l_application_id := substr(l_orig_system,
809: instr(l_orig_system,'FND_RESP')+8);
810: result := fnd_profile.value_specific(name=>Get_Profile_Value.name,
811: responsibility_id=>l_orig_system_id,
812: application_id=>l_application_id);
813: elsif (instr(l_orig_system, 'PER') > 0) then
814: begin

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

822: when NO_DATA_FOUND then
823: l_user_id := to_number(null);
824: end;
825: if (l_user_id is not null) then
826: result := fnd_profile.value_specific(name=>Get_Profile_Value.name,
827: user_id=>l_user_id);
828: else
829: result := null;
830: end if;

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

888: function DirectLogin (nid in NUMBER) return VARCHAR2
889: IS
890: x_mode varchar2(30);
891: BEGIN
892: fnd_profile.get('WF_ICX_MODE',x_mode);
893:
894: return ('OracleApps.DF?i_direct=' || WFA_SEC.DetailURL(nid) || '&i_mode=' ||
895: nvl(x_mode,'2'));
896: