APPS.IRC_OFFER_STATUS_HISTORY_SWI SQL Statements

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

Line: 125

PROCEDURE update_offer_status_history
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date      default hr_api.g_date
  ,p_offer_status_history_id      in     number
  ,p_offer_id                     in     number
  ,p_status_change_date           in     date      default hr_api.g_date
  ,p_offer_status                 in     varchar2
  ,p_change_reason                in     varchar2  default hr_api.g_varchar2
  ,p_decline_reason               in     varchar2  default hr_api.g_varchar2
  ,p_note_text                    in     varchar2  default hr_api.g_varchar2
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 145

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

Line: 151

  savepoint update_offer_status_hist_swi;

Line: 171

  irc_offer_status_history_api.update_offer_status_history
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_offer_status_history_id      => p_offer_status_history_id
    ,p_offer_id                     => p_offer_id
    ,p_status_change_date           => p_status_change_date
    ,p_offer_status                 => p_offer_status
    ,p_change_reason                => p_change_reason
    ,p_decline_reason               => p_decline_reason
    ,p_note_text                    => p_note_text
    ,p_object_version_number        => p_object_version_number
    );

Line: 205

    rollback to update_offer_status_hist_swi;

Line: 220

    rollback to update_offer_status_hist_swi;

Line: 231

end update_offer_status_history;

Line: 235

PROCEDURE delete_offer_status_history
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_offer_id                     in     number
  ,p_effective_date               in     date
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 248

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

Line: 254

  savepoint delete_offer_status_hist_swi;

Line: 274

  irc_offer_status_history_api.delete_offer_status_history
    (p_validate                     => l_validate
    ,p_offer_id                     => p_offer_id
    ,p_effective_date               => p_effective_date
    );

Line: 301

    rollback to delete_offer_status_hist_swi;

Line: 315

    rollback to delete_offer_status_hist_swi;

Line: 325

end delete_offer_status_history;