APPS.IRC_TEMPLATE_ASSOCIATION_SWI SQL Statements

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

Line: 128

PROCEDURE update_template_association
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date      default hr_api.g_date
  ,p_template_association_id      in     number
  ,p_template_id                  in     number
  ,p_default_association          in     varchar2  default hr_api.g_varchar2
  ,p_job_id                       in     number    default hr_api.g_number
  ,p_position_id                  in     number    default hr_api.g_number
  ,p_organization_id              in     number    default hr_api.g_number
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_end_date                     in     date      default hr_api.g_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: 150

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

Line: 156

  savepoint update_template_assoc_swi;

Line: 177

  irc_template_association_api.update_template_association
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_template_association_id      => p_template_association_id
    ,p_template_id                  => p_template_id
    ,p_default_association          => p_default_association
    ,p_job_id                       => p_job_id
    ,p_position_id                  => p_position_id
    ,p_organization_id              => p_organization_id
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_object_version_number        => p_object_version_number
    );

Line: 212

    rollback to update_template_assoc_swi;

Line: 227

    rollback to update_template_assoc_swi;

Line: 238

end update_template_association;

Line: 242

PROCEDURE delete_template_association
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_template_association_id      in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 255

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

Line: 261

  savepoint delete_template_assoc_swi;

Line: 281

  irc_template_association_api.delete_template_association
    (p_validate                     => l_validate
    ,p_template_association_id      => p_template_association_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 308

    rollback to delete_template_assoc_swi;

Line: 322

    rollback to delete_template_assoc_swi;

Line: 332

end delete_template_association;