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.JTF_DIAGNOSTIC_COREAPI dependencies on FND_PROFILE

Line 919: -- profile_val fnd_profile_option_values.profile_option_value%type;

915: -- output.
916: --
917: -- Examples:
918: -- declare
919: -- profile_val fnd_profile_option_values.profile_option_value%type;
920: -- begin
921: -- profile_val := CheckProfile('PA_SELECTIVE_FLEX_SEG',g_user_id,
922: -- g_resp_id, g_appl_id, null, 1);
923: --

Line 937: l_user_prof_name fnd_profile_options_tl.user_profile_option_name%type;

933: , p_appl_id in number
934: , p_default in varchar2 default null
935: , p_indent in integer default 0)
936: return varchar2 is
937: l_user_prof_name fnd_profile_options_tl.user_profile_option_name%type;
938: l_prof_value fnd_profile_option_values.profile_option_value%type;
939: l_start_date date;
940: l_end_date date;
941: l_opt_defined boolean;

Line 938: l_prof_value fnd_profile_option_values.profile_option_value%type;

934: , p_default in varchar2 default null
935: , p_indent in integer default 0)
936: return varchar2 is
937: l_user_prof_name fnd_profile_options_tl.user_profile_option_name%type;
938: l_prof_value fnd_profile_option_values.profile_option_value%type;
939: l_start_date date;
940: l_end_date date;
941: l_opt_defined boolean;
942: l_output_txt varchar2(500);

Line 949: from fnd_profile_options_vl

945: select user_profile_option_name,
946: nvl(start_date_active,sysdate-1),
947: nvl(end_date_active,sysdate+1)
948: into l_user_prof_name, l_start_date, l_end_date
949: from fnd_profile_options_vl
950: where profile_option_name = p_prof_name;
951: exception
952: when no_data_found then
953: l_prof_value := 'DOESNOTEXIST';

Line 966: fnd_profile.get_specific(p_prof_name, p_user_id, p_resp_id, p_appl_id,

962: if ((sysdate < l_start_date) or (sysdate > l_end_date)) then
963: l_prof_value := 'DISABLED';
964: return(l_prof_value);
965: end if;
966: fnd_profile.get_specific(p_prof_name, p_user_id, p_resp_id, p_appl_id,
967: l_prof_value, l_opt_defined);
968: if not l_opt_defined then
969: l_prof_value := null;
970: end if;

Line 1009: l_dummy_prof_value fnd_profile_option_values.profile_option_value%type;

1005: , p_resp_id in number
1006: , p_appl_id in number
1007: , p_default in varchar2 default null
1008: , p_indent in integer default 0) is
1009: l_dummy_prof_value fnd_profile_option_values.profile_option_value%type;
1010: begin
1011: l_dummy_prof_value := CheckProfile(p_prof_name, p_user_id, p_resp_id,
1012: p_appl_id, p_default, p_indent);
1013: end CheckProfile_html;

Line 1947: || ' from fnd_profile_options a'

1943: || ' , c.profile_option_id "Profile
ID"'
1944: || ' , to_char(c.LAST_UPDATE_DATE,''MM-DD-YYYY HH24:MI'') '
1945: || ' "Updated
Date"'
1946: || ' , nvl(d.user_name,to_char(c.last_updated_by)) "Updated
By"'
1947: || ' from fnd_profile_options a'
1948: || ' , FND_PROFILE_OPTIONS_TL b'
1949: || ' , FND_PROFILE_OPTION_VALUES c'
1950: || ' , FND_USER d'
1951: || ' , FND_USER e'

Line 1948: || ' , FND_PROFILE_OPTIONS_TL b'

1944: || ' , to_char(c.LAST_UPDATE_DATE,''MM-DD-YYYY HH24:MI'') '
1945: || ' "Updated
Date"'
1946: || ' , nvl(d.user_name,to_char(c.last_updated_by)) "Updated
By"'
1947: || ' from fnd_profile_options a'
1948: || ' , FND_PROFILE_OPTIONS_TL b'
1949: || ' , FND_PROFILE_OPTION_VALUES c'
1950: || ' , FND_USER d'
1951: || ' , FND_USER e'
1952: || ' , FND_RESPONSIBILITY_TL g'

Line 1949: || ' , FND_PROFILE_OPTION_VALUES c'

1945: || ' "Updated
Date"'
1946: || ' , nvl(d.user_name,to_char(c.last_updated_by)) "Updated
By"'
1947: || ' from fnd_profile_options a'
1948: || ' , FND_PROFILE_OPTIONS_TL b'
1949: || ' , FND_PROFILE_OPTION_VALUES c'
1950: || ' , FND_USER d'
1951: || ' , FND_USER e'
1952: || ' , FND_RESPONSIBILITY_TL g'
1953: || ' , FND_APPLICATION h'

Line 1996: return FND_PROFILE.VALUE(p_profile_option);

1992: -- end;
1993: --
1994: function Get_Profile_Option_html (p_profile_option varchar2) return varchar2 is
1995: begin
1996: return FND_PROFILE.VALUE(p_profile_option);
1997: end;
1998:
1999: -- Procedure Name: Set_Org
2000: --

Line 3125: -- profile_val fnd_profile_option_values.profile_option_value%type;

3121: -- If the profile option does not exist or is disabled there is no
3122: -- output.
3123: -- Examples:
3124: -- declare
3125: -- profile_val fnd_profile_option_values.profile_option_value%type;
3126: -- begin
3127: -- profile_val := CheckProfile('PA_SELECTIVE_FLEX_SEG',g_user_id,
3128: -- g_resp_id, g_appl_id, null, 1);
3129: --

Line 3141: l_user_prof_name fnd_profile_options_tl.user_profile_option_name%type;

3137: , p_appl_id in number
3138: , p_default in varchar2 default null
3139: , p_indent in integer default 0)
3140: return varchar2 is
3141: l_user_prof_name fnd_profile_options_tl.user_profile_option_name%type;
3142: l_prof_value fnd_profile_option_values.profile_option_value%type;
3143: l_start_date date;
3144: l_end_date date;
3145: l_opt_defined boolean;

Line 3142: l_prof_value fnd_profile_option_values.profile_option_value%type;

3138: , p_default in varchar2 default null
3139: , p_indent in integer default 0)
3140: return varchar2 is
3141: l_user_prof_name fnd_profile_options_tl.user_profile_option_name%type;
3142: l_prof_value fnd_profile_option_values.profile_option_value%type;
3143: l_start_date date;
3144: l_end_date date;
3145: l_opt_defined boolean;
3146: l_output_txt varchar2(500);

Line 3153: from fnd_profile_options_vl

3149: select user_profile_option_name,
3150: nvl(start_date_active,sysdate-1),
3151: nvl(end_date_active,sysdate+1)
3152: into l_user_prof_name, l_start_date, l_end_date
3153: from fnd_profile_options_vl
3154: where profile_option_name = p_prof_name;
3155: exception
3156: when no_data_found then
3157: l_prof_value := 'DOESNOTEXIST';

Line 3170: fnd_profile.get_specific(p_prof_name, p_user_id, p_resp_id, p_appl_id,

3166: if ((sysdate < l_start_date) or (sysdate > l_end_date)) then
3167: l_prof_value := 'DISABLED';
3168: return(l_prof_value);
3169: end if;
3170: fnd_profile.get_specific(p_prof_name, p_user_id, p_resp_id, p_appl_id,
3171: l_prof_value, l_opt_defined);
3172: if not l_opt_defined then
3173: l_prof_value := null;
3174: end if;

Line 3213: l_dummy_prof_value fnd_profile_option_values.profile_option_value%type;

3209: , p_resp_id in number
3210: , p_appl_id in number
3211: , p_default in varchar2 default null
3212: , p_indent in integer default 0) is
3213: l_dummy_prof_value fnd_profile_option_values.profile_option_value%type;
3214: begin
3215: l_dummy_prof_value := CheckProfile(p_prof_name, p_user_id, p_resp_id,
3216: p_appl_id, p_default, p_indent);
3217: end CheckProfile_text;

Line 4051: from fnd_profile_option_values v,

4047: 10002, a.application_name,
4048: 10003, r.responsibility_name,
4049: 10004, u.user_name),1,20) lev_value,
4050: v.profile_option_value opt_value
4051: from fnd_profile_option_values v,
4052: fnd_profile_options o,
4053: fnd_profile_options_tl ot,
4054: fnd_application_tl a,
4055: fnd_responsibility_tl r,

Line 4052: fnd_profile_options o,

4048: 10003, r.responsibility_name,
4049: 10004, u.user_name),1,20) lev_value,
4050: v.profile_option_value opt_value
4051: from fnd_profile_option_values v,
4052: fnd_profile_options o,
4053: fnd_profile_options_tl ot,
4054: fnd_application_tl a,
4055: fnd_responsibility_tl r,
4056: fnd_user u

Line 4053: fnd_profile_options_tl ot,

4049: 10004, u.user_name),1,20) lev_value,
4050: v.profile_option_value opt_value
4051: from fnd_profile_option_values v,
4052: fnd_profile_options o,
4053: fnd_profile_options_tl ot,
4054: fnd_application_tl a,
4055: fnd_responsibility_tl r,
4056: fnd_user u
4057: where o.application_id = nvl(p_application_id, o.application_id)

Line 4093: from fnd_profile_option_values v,

4089: 10003, r.responsibility_name,
4090: 10004, u.user_name),1,20))),
4091: max(length(v.profile_option_value))
4092: into max_user_opt, max_opt, max_lev, max_lev_value, max_opt_value
4093: from fnd_profile_option_values v,
4094: fnd_profile_options o,
4095: fnd_profile_options_tl ot,
4096: fnd_application_tl a,
4097: fnd_responsibility_tl r,

Line 4094: fnd_profile_options o,

4090: 10004, u.user_name),1,20))),
4091: max(length(v.profile_option_value))
4092: into max_user_opt, max_opt, max_lev, max_lev_value, max_opt_value
4093: from fnd_profile_option_values v,
4094: fnd_profile_options o,
4095: fnd_profile_options_tl ot,
4096: fnd_application_tl a,
4097: fnd_responsibility_tl r,
4098: fnd_user u

Line 4095: fnd_profile_options_tl ot,

4091: max(length(v.profile_option_value))
4092: into max_user_opt, max_opt, max_lev, max_lev_value, max_opt_value
4093: from fnd_profile_option_values v,
4094: fnd_profile_options o,
4095: fnd_profile_options_tl ot,
4096: fnd_application_tl a,
4097: fnd_responsibility_tl r,
4098: fnd_user u
4099: where o.application_id = nvl(p_application_id, o.application_id)

Line 4160: return FND_PROFILE.VALUE(p_profile_option);

4156: -- end;
4157:
4158: function Get_Profile_Option_text (p_profile_option varchar2) return varchar2 is
4159: begin
4160: return FND_PROFILE.VALUE(p_profile_option);
4161: end;
4162:
4163: -- Procedure Name: Set_Org
4164: -- Usage: