APPS.PER_SEC_PROFILE_ASG_SWI SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 156

PROCEDURE update_security_profile_asg
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_sec_profile_assignment_id    in     number
  ,p_user_id                      in     number
  ,p_security_group_id            in     number
  ,p_business_group_id            in     number
  ,p_security_profile_id          in     number
  ,p_responsibility_id            in     number
  ,p_responsibility_application_i in     number
  ,p_start_date                   in     date
  ,p_end_date                     in     date
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 179

  l_proc    varchar2(72) := g_package ||'update_security_profile_asg';

Line: 185

  savepoint update_sec_prf_asg_swi;

Line: 217

  per_sec_profile_asg_api.update_security_profile_asg
    (p_validate                     => l_validate
    ,p_sec_profile_assignment_id    => p_sec_profile_assignment_id
    ,p_user_id                      => p_user_id
    ,p_security_group_id            => p_security_group_id
    ,p_business_group_id            => p_business_group_id
    ,p_security_profile_id          => p_security_profile_id
    ,p_responsibility_id            => p_responsibility_id
    ,p_responsibility_application_i => p_responsibility_application_i
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_object_version_number        => p_object_version_number
    );

Line: 255

    rollback to update_sec_prf_asg_swi;

Line: 273

    rollback to update_sec_prf_asg_swi;

Line: 288

end update_security_profile_asg;