APPS.JTF_DIAGNOSTIC_COREAPI dependencies on FND_PROFILE_OPTION_VALUES

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 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 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 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 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 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 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 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,