APPS.JTF_DIAGNOSTIC_COREAPI dependencies on FND_PROFILE_OPTIONS

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