APPS.IRC_OFFER_STATUS_HISTORY_API SQL Statements

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

Line: 173

  procedure update_offer_status_history
  ( P_VALIDATE                 IN   boolean   default false
   ,P_EFFECTIVE_DATE           IN   DATE      default null
   ,P_OFFER_STATUS_HISTORY_ID  IN   NUMBER
   ,P_OFFER_ID                 IN   NUMBER
   ,P_STATUS_CHANGE_DATE       IN   DATE
   ,P_OFFER_STATUS             IN   VARCHAR2
   ,P_CHANGE_REASON            IN   VARCHAR2  default null
   ,P_DECLINE_REASON           IN   VARCHAR2  default null
   ,P_NOTE_TEXT                IN   VARCHAR2  default null
   ,P_OBJECT_VERSION_NUMBER    IN OUT  nocopy    NUMBER
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number number(9);

Line: 189

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

Line: 202

  savepoint UPDATE_OFFER_STATUS_HISTORY;

Line: 225

    IRC_OFFER_STATUS_HISTORY_BK2.update_offer_status_history_b
    (P_EFFECTIVE_DATE          =>   l_effective_date
    ,P_OFFER_STATUS_HISTORY_ID =>   P_OFFER_STATUS_HISTORY_ID
    ,P_STATUS_CHANGE_DATE      =>   l_status_change_date
    ,P_CHANGE_REASON           =>   P_CHANGE_REASON
    ,P_DECLINE_REASON          =>   P_DECLINE_REASON
    ,P_NOTE_TEXT               =>   P_NOTE_TEXT
    );

Line: 236

        (p_module_name  => 'UPDATE_OFFER_STATUS_HISTORY'
	,p_hook_type    => 'BP'
	);

Line: 261

    IRC_OFFER_STATUS_HISTORY_BK2.update_offer_status_history_a
      (P_EFFECTIVE_DATE           => l_effective_date
      ,P_OFFER_STATUS_HISTORY_ID  => P_OFFER_STATUS_HISTORY_ID
      ,P_STATUS_CHANGE_DATE       => l_status_change_date
      ,P_CHANGE_REASON            => P_CHANGE_REASON
      ,P_DECLINE_REASON           => P_DECLINE_REASON
      ,P_NOTE_TEXT                => P_NOTE_TEXT
      ,P_OBJECT_VERSION_NUMBER    => l_object_version_number
      );

Line: 273

        (p_module_name => 'UPDATE_OFFER_STATUS_HISTORY'
        ,p_hook_type   => 'AP'
        );

Line: 295

    rollback to UPDATE_OFFER_STATUS_HISTORY;

Line: 307

    rollback to UPDATE_OFFER_STATUS_HISTORY;

Line: 315

end UPDATE_OFFER_STATUS_HISTORY;

Line: 322

procedure delete_offer_status_history
  ( P_VALIDATE                   IN   boolean   default false
   ,P_OFFER_ID                   IN   NUMBER
   ,P_EFFECTIVE_DATE             IN   DATE
  ) is
  --
  --
  -- Declare cursors and local variables
  --
  l_proc           varchar2(72) := g_package||'DELETE_OFFER_STATUS_HISTORY';

Line: 334

     select offer_status_history_id,
            object_version_number
     from   irc_offer_status_history
     where  offer_id = p_offer_id;

Line: 345

  savepoint DELETE_OFFER_STATUS_HISTORY;

Line: 356

    IRC_OFFER_STATUS_HISTORY_BK3.delete_offer_status_history_b
      (  P_OBJECT_VERSION_NUMBER    => c_rec.object_version_number
        ,P_OFFER_STATUS_HISTORY_ID  => c_rec.offer_status_history_id
      );

Line: 363

        (p_module_name => 'DELETE_OFFER_STATUS_HISTORY'
        ,p_hook_type   => 'BP'
        );

Line: 378

    IRC_OFFER_STATUS_HISTORY_BK3.delete_offer_status_history_a
      (  P_OBJECT_VERSION_NUMBER    => c_rec.object_version_number
        ,P_OFFER_STATUS_HISTORY_ID  => c_rec.offer_status_history_id
      );

Line: 385

        (p_module_name => 'DELETE_OFFER_STATUS_HISTORY'
        ,p_hook_type   => 'AP'
        );

Line: 404

    rollback to DELETE_OFFER_STATUS_HISTORY;

Line: 411

    rollback to DELETE_OFFER_STATUS_HISTORY;

Line: 415

end DELETE_OFFER_STATUS_HISTORY;