The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fr.responsibility_id
,frtl.responsibility_name
,fr.responsibility_key
,fr.application_id resp_app_id
,frtl.description
,fr.start_date
,fr.end_date
,fdg.data_group_name
,fr.data_group_application_id data_group_app_id
,fm.menu_name
,frg.request_group_name
,fr.request_group_id
,fr.group_application_id req_group_app_id
,fr.version
,fr.web_host_name
,fr.web_agent_name
FROM fnd_responsibility fr
,fnd_responsibility_tl frtl
,fnd_menus fm
,fnd_data_groups fdg
,fnd_request_groups frg
WHERE fr.responsibility_id = l_exist_resp_id
AND fr.application_id = l_exist_resp_app_id
AND fr.responsibility_id = frtl.responsibility_id
AND fr.data_group_id = fdg.data_group_id
AND fr.menu_id = fm.menu_id
AND fr.request_group_id = frg.request_group_id(+)
--BUG 3648732
AND fr.application_id = frtl.application_id
AND fr.application_id = frg.application_id(+);
SELECT responsibility_id, application_id
FROM fnd_responsibility
WHERE responsibility_key = p_resp_key;
SELECT security_group_id
FROM fnd_security_groups
WHERE security_group_key = to_char(p_business_group_id);
-- NOTE: Only insert a row into fnd_user_resp_groups
-- when the profile option 'ENABLE_SECURITY_GROUPS'
-- is 'N'.
--
hr_user_acct_internal.create_fnd_user_resp_groups
(p_user_id => l_user_id
,p_responsibility_id => l_responsibility_id
,p_application_id => l_user_resp_app_id
,p_sec_group_id => 0
,p_start_date => l_fnd_resp_rec.user_resp_start_date
,p_end_date => l_fnd_resp_rec.user_resp_end_date
,p_description => l_fnd_resp_rec.user_resp_description
);
,p_delete_flag => 'N');
END LOOP; -- end loop for inserting each profile opt value rec
END LOOP; -- end loop for inserting each profile opt value rec
PROCEDURE update_user_acct
(p_validate in boolean default false
,p_person_id in number
,p_per_effective_start_date in date default null
,p_per_effective_end_date in date default null
,p_assignment_id in number default null
,p_asg_effective_start_date in date default null
,p_asg_effective_end_date in date default null
,p_business_group_id in number
,p_date_from in date default null
,p_date_to in date default null
,p_org_structure_id in number default null
,p_org_structure_vers_id in number default null
,p_parent_org_id in number default null
,p_single_org_id in number default null
,p_run_type in varchar2 default null
,p_inactivate_date in date
)
is
--
l_date date default null;
SELECT user_id
FROM fnd_user
WHERE employee_id = p_person_id
AND nvl(end_date, hr_api.g_eot) > l_date;
SELECT sec_profile_assignment_id
,security_group_id
,security_profile_id
,responsibility_id
,responsibility_application_id
,object_version_number
,start_date
FROM per_sec_profile_assignments
WHERE user_id = c_user_id
AND nvl(end_date, l_date + 1) > l_date;
SELECT responsibility_application_id
,responsibility_id
,security_group_id
,start_date
,end_date
-- ,description
FROM fnd_user_resp_groups_direct
WHERE user_id = c_user_id
AND nvl(end_date, l_date + 1) > l_date
AND trunc(sysdate) between start_date and nvl(end_date,sysdate); --5090502
SELECT furgd.responsibility_application_id
,furgd.responsibility_id
,furgd.security_group_id
,furgd.start_date
,furgd.end_date
-- ,description
FROM fnd_user_resp_groups_direct furgd, FND_RESPONSIBILITY fr
WHERE furgd.user_id = c_user_id
AND fr.responsibility_id = furgd.responsibility_id
AND trunc(sysdate) between fr.start_date and nvl(fr.end_date,sysdate)
AND nvl(furgd.end_date, l_date + 1) > l_date
AND trunc(sysdate) between furgd.start_date and nvl(furgd.end_date,sysdate);
l_proc varchar2(72) := g_package||'update_user_acct';
savepoint update_user_acct;
hr_user_acct_bk2.update_user_acct_b
(p_person_id => p_person_id
,p_per_effective_start_date => p_per_effective_start_date
,p_per_effective_end_date => p_per_effective_end_date
,p_assignment_id => p_assignment_id
,p_asg_effective_start_date => p_asg_effective_start_date
,p_asg_effective_end_date => p_asg_effective_end_date
,p_business_group_id => p_business_group_id
,p_date_from => p_date_from
,p_date_to => p_date_to
,p_org_structure_id => p_org_structure_id
,p_org_structure_vers_id => p_org_structure_vers_id
,p_parent_org_id => p_parent_org_id
,p_single_org_id => p_single_org_id
,p_run_type => p_run_type
,p_inactivate_date => l_date
);
(p_module_name => 'UPDATE_USER_ACCOUNT'
,p_hook_type => 'BP'
);
hr_user_acct_internal.update_fnd_user
(p_user_id => get_user_ids.user_id
,p_end_date => l_date
);
hr_utility.trace('Calling update_sec_profile_asg with ' || get_sec_prf_asg.sec_profile_assignment_id);
hr_user_acct_internal.update_sec_profile_asg
(p_sec_profile_asg_id => get_sec_prf_asg.sec_profile_assignment_id
,p_object_version_number => get_sec_prf_asg.object_version_number
,p_start_date => get_sec_prf_asg.start_date
,p_end_date => l_date -- Fix 2978610
);
hr_utility.trace('Calling update_fnd_user_resp_groups with ');
hr_user_acct_internal.update_fnd_user_resp_groups
(p_user_id => get_user_ids.user_id
,p_responsibility_id => get_user_resp.responsibility_id
,p_resp_application_id
=> get_user_resp.responsibility_application_id
,p_security_group_id => get_user_resp.security_group_id
,p_start_date => get_user_resp.start_date
,p_end_date => l_date
--,p_description => get_user_resp.description -- Bug 4147802
);
hr_user_acct_bk2.update_user_acct_a
(p_person_id => p_person_id
,p_per_effective_start_date => p_per_effective_start_date
,p_per_effective_end_date => p_per_effective_end_date
,p_assignment_id => p_assignment_id
,p_asg_effective_start_date => p_asg_effective_start_date
,p_asg_effective_end_date => p_asg_effective_end_date
,p_business_group_id => p_business_group_id
,p_date_from => p_date_from
,p_date_to => p_date_to
,p_org_structure_id => p_org_structure_id
,p_org_structure_vers_id => p_org_structure_vers_id
,p_parent_org_id => p_parent_org_id
,p_single_org_id => p_single_org_id
,p_run_type => p_run_type
,p_inactivate_date => l_date
);
(p_module_name => 'UPDATE_USER_ACCOUNT'
,p_hook_type => 'AP'
);
ROLLBACK TO update_user_acct;
ROLLBACK TO update_user_acct;
END update_user_acct;