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 1951: || ' from fnd_profile_options a'

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

Line 1952: || ' , FND_PROFILE_OPTIONS_TL b'

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

Line 1953: || ' , FND_PROFILE_OPTION_VALUES c'

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

Line 2000: return FND_PROFILE.VALUE(p_profile_option);

1996: -- end;
1997: --
1998: function Get_Profile_Option_html (p_profile_option varchar2) return varchar2 is
1999: begin
2000: return FND_PROFILE.VALUE(p_profile_option);
2001: end;
2002:
2003: -- Procedure Name: Set_Org
2004: --

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

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

Line 3145: l_user_prof_name fnd_profile_options_tl.user_profile_option_name%type;

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

Line 3146: l_prof_value fnd_profile_option_values.profile_option_value%type;

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

Line 3157: from fnd_profile_options_vl

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

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

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

Line 3217: l_dummy_prof_value fnd_profile_option_values.profile_option_value%type;

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

Line 4059: from fnd_profile_option_values v,

4055: 10002, a.application_name,
4056: 10003, r.responsibility_name,
4057: 10004, u.user_name),1,20) lev_value,
4058: v.profile_option_value opt_value
4059: from fnd_profile_option_values v,
4060: fnd_profile_options o,
4061: fnd_profile_options_tl ot,
4062: fnd_application_tl a,
4063: fnd_responsibility_tl r,

Line 4060: fnd_profile_options o,

4056: 10003, r.responsibility_name,
4057: 10004, u.user_name),1,20) lev_value,
4058: v.profile_option_value opt_value
4059: from fnd_profile_option_values v,
4060: fnd_profile_options o,
4061: fnd_profile_options_tl ot,
4062: fnd_application_tl a,
4063: fnd_responsibility_tl r,
4064: fnd_user u

Line 4061: fnd_profile_options_tl ot,

4057: 10004, u.user_name),1,20) lev_value,
4058: v.profile_option_value opt_value
4059: from fnd_profile_option_values v,
4060: fnd_profile_options o,
4061: fnd_profile_options_tl ot,
4062: fnd_application_tl a,
4063: fnd_responsibility_tl r,
4064: fnd_user u
4065: where o.application_id = nvl(p_application_id, o.application_id)

Line 4101: from fnd_profile_option_values v,

4097: 10003, r.responsibility_name,
4098: 10004, u.user_name),1,20))),
4099: max(length(v.profile_option_value))
4100: into max_user_opt, max_opt, max_lev, max_lev_value, max_opt_value
4101: from fnd_profile_option_values v,
4102: fnd_profile_options o,
4103: fnd_profile_options_tl ot,
4104: fnd_application_tl a,
4105: fnd_responsibility_tl r,

Line 4102: fnd_profile_options o,

4098: 10004, u.user_name),1,20))),
4099: max(length(v.profile_option_value))
4100: into max_user_opt, max_opt, max_lev, max_lev_value, max_opt_value
4101: from fnd_profile_option_values v,
4102: fnd_profile_options o,
4103: fnd_profile_options_tl ot,
4104: fnd_application_tl a,
4105: fnd_responsibility_tl r,
4106: fnd_user u

Line 4103: fnd_profile_options_tl ot,

4099: max(length(v.profile_option_value))
4100: into max_user_opt, max_opt, max_lev, max_lev_value, max_opt_value
4101: from fnd_profile_option_values v,
4102: fnd_profile_options o,
4103: fnd_profile_options_tl ot,
4104: fnd_application_tl a,
4105: fnd_responsibility_tl r,
4106: fnd_user u
4107: where o.application_id = nvl(p_application_id, o.application_id)

Line 4168: return FND_PROFILE.VALUE(p_profile_option);

4164: -- end;
4165:
4166: function Get_Profile_Option_text (p_profile_option varchar2) return varchar2 is
4167: begin
4168: return FND_PROFILE.VALUE(p_profile_option);
4169: end;
4170:
4171: -- Procedure Name: Set_Org
4172: -- Usage: