APPS.PSP_SALARY_CAP_OVERRIDES_SWI SQL Statements

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

Line: 136

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

Line: 151

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

Line: 157

  savepoint delete_salary_cap_override_swi;

Line: 181

  psp_salary_cap_overrides_api.delete_salary_cap_override
    (p_validate                     => l_validate
    ,p_salary_cap_override_id       => p_salary_cap_override_id
    ,p_object_version_number        => p_object_version_number
    ,p_return_status                => l_return_status
    );

Line: 213

    rollback to delete_salary_cap_override_swi;

Line: 229

    rollback to delete_salary_cap_override_swi;

Line: 241

end delete_salary_cap_override;

Line: 245

PROCEDURE update_salary_cap_override
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_salary_cap_override_id       in     number
  ,p_funding_source_code          in     varchar2
  ,p_project_id                   in     number
  ,p_start_date                   in     date
  ,p_end_date                     in     date
  ,p_currency_code                in     varchar2
  ,p_annual_salary_cap            in     number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 266

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

Line: 272

  savepoint update_salary_cap_override_swi;

Line: 296

  psp_salary_cap_overrides_api.update_salary_cap_override
    (p_validate                     => l_validate
    ,p_salary_cap_override_id       => p_salary_cap_override_id
    ,p_funding_source_code          => p_funding_source_code
    ,p_project_id                   => p_project_id
    ,p_start_date                   => p_start_date
    ,p_end_date                     => p_end_date
    ,p_currency_code                => p_currency_code
    ,p_annual_salary_cap            => p_annual_salary_cap
    ,p_object_version_number        => p_object_version_number
    ,p_return_status                => l_return_status
    );

Line: 334

    rollback to update_salary_cap_override_swi;

Line: 350

    rollback to update_salary_cap_override_swi;

Line: 362

end update_salary_cap_override;