[Home] [Help]
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;
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';
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'
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'
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;
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';
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
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)
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
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)