[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select end_date,
description,
password_lifespan_accesses,
password_lifespan_days,
employee_id,
email_address,
fax,
customer_id,
supplier_id
from fnd_user
where user_name = upper(p_template_user);
select user_id into new_userid
from fnd_user
where user_name = upper(p_new_user);
fnd_user_pkg.UpdateUser(
x_user_name => upper(p_new_user),
x_owner => 'CUST',
x_end_date => tu.end_date,
x_description => nvl(description, tu.description),
x_password_date => sysdate,
x_password_accesses_left => tu.password_lifespan_accesses,
x_password_lifespan_accesses => tu.password_lifespan_accesses,
x_password_lifespan_days => tu.password_lifespan_days,
x_employee_id => tu.employee_id,
x_email_address => nvl(email, tu.email_address),
x_fax => tu.fax,
x_customer_id => tu.customer_id,
x_supplier_id => tu.supplier_id);
select a.application_short_name app,
r.responsibility_key resp,
s.security_group_key sg,
decode(u.last_updated_by, 1, 'SEED', 'CUSTOM') owner,
to_char(ur.start_date, 'YYYY/MM/DD') start_date,
to_char(ur.end_date, 'YYYY/MM/DD') end_date,
ur.description
from fnd_user u,
fnd_user_resp_groups ur,
fnd_application_vl a,
fnd_responsibility_vl r,
fnd_security_groups_vl s
where u.user_name = upper(p_template_user)
and ur.user_id = u.user_id
and ur.responsibility_id = r.responsibility_id
and ur.responsibility_application_id = r.application_id
and ur.responsibility_application_id = a.application_id
and ur.security_group_id = s.security_group_id;
select user_id into new_userid
from fnd_user
where user_name = upper(p_new_user);
select pov.application_id appid,
p.profile_option_name proname,
pov.profile_option_value val
from fnd_profile_option_values pov,
fnd_profile_options p,
fnd_user u
where pov.level_id = 10004
and pov.level_value = u.user_id
and pov.profile_option_id = p.profile_option_id
and pov.application_id = p.application_id
and u.user_name = upper(p_template_user);
select user_id into new_userid
from fnd_user
where user_name = upper(p_new_user);
select application_id into appid
from fnd_application
where application_short_name = x_resp_application;
select responsibility_id into respid
from fnd_responsibility
where application_id = appid
and responsibility_key = x_responsibility;
select security_group_id into secid
from fnd_security_groups
where security_group_key = x_security_group;
select application_id into appid
from fnd_application
where application_id = x_resp_application_id;
select responsibility_id into respid
from fnd_responsibility
where application_id = appid
and responsibility_id = x_responsibility_id;
select security_group_id into secid
from fnd_security_groups
where security_group_key = x_security_group;
select application_id into appid
from fnd_application
where application_short_name = x_resp_application;
select security_group_id into secid
from fnd_security_groups
where security_group_key = x_security_group;
select responsibility_id into respid
from fnd_responsibility
where application_id = appid
and responsibility_key = x_responsibility;
'select r.user_id, r.security_group_id ' ||
'from fnd_user_resp_groups r '||
'where r.responsibility_id = '||respid||
' and r.security_group_id = '||secid||
' and r.responsibility_application_id = '||appid;
select application_id into appid
from fnd_application
where application_id = x_resp_application_id;
select security_group_id into secid
from fnd_security_groups
where security_group_key = x_security_group;
select responsibility_id into respid
from fnd_responsibility
where application_id = appid
and responsibility_id = x_responsibility_id;
'select r.user_id, r.security_group_id '||
'from fnd_user_resp_groups r '||
'where r.responsibility_id = '||respid||
' and r.security_group_id = '||secid||
' and r.responsibility_application_id = '||appid;
procedure UpdateUserGroup(
x_user_group_clause in varchar2,
x_start_date in date default null,
x_end_date in date default null,
x_description in varchar2 default null,
x_password_lifespan_accesses in number default null,
x_password_lifespan_days in number default null,
x_email_address in varchar2 default null,
x_fax in varchar2 default null) is
uid number;
-- Update a group of user with the input user attriutes
open c for x_user_group_clause;
update fnd_user
set last_update_date = sysdate,
start_date = nvl(x_start_date, start_date),
end_date = nvl(x_end_date, end_date),
description = nvl(x_description, description),
password_lifespan_accesses = nvl(x_password_lifespan_accesses,
password_lifespan_accesses),
password_lifespan_days = nvl(x_password_lifespan_days,
password_lifespan_days),
email_address = nvl(x_email_address, email_address),
fax = nvl(x_fax, fax)
where user_id = uid;
fnd_function_security_cache.update_user(uid);
end UpdateUserGroup;
procedure UpdateUserGroupTemplate(
x_user_group_clause in varchar2,
x_template_user in varchar2,
x_attribute_flag in boolean default TRUE,
x_responsibility_flag in boolean default TRUE,
x_profile_flag in boolean default TRUE) is
uname varchar2(100);
select user_name into uname
from fnd_user where user_id = uid;
end UpdateUserGroupTemplate;
sql_string := 'update fnd_user set end_date = sysdate where userid in ('||
x_user_group_clause||')';