The following lines contain the word 'select', 'insert', 'update' or 'delete':
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);
l_proc varchar2(72) := g_package||'UPDATE_OFFER_STATUS_HISTORY';
savepoint UPDATE_OFFER_STATUS_HISTORY;
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
);
(p_module_name => 'UPDATE_OFFER_STATUS_HISTORY'
,p_hook_type => 'BP'
);
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
);
(p_module_name => 'UPDATE_OFFER_STATUS_HISTORY'
,p_hook_type => 'AP'
);
rollback to UPDATE_OFFER_STATUS_HISTORY;
rollback to UPDATE_OFFER_STATUS_HISTORY;
end UPDATE_OFFER_STATUS_HISTORY;
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';
select offer_status_history_id,
object_version_number
from irc_offer_status_history
where offer_id = p_offer_id;
savepoint DELETE_OFFER_STATUS_HISTORY;
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
);
(p_module_name => 'DELETE_OFFER_STATUS_HISTORY'
,p_hook_type => 'BP'
);
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
);
(p_module_name => 'DELETE_OFFER_STATUS_HISTORY'
,p_hook_type => 'AP'
);
rollback to DELETE_OFFER_STATUS_HISTORY;
rollback to DELETE_OFFER_STATUS_HISTORY;
end DELETE_OFFER_STATUS_HISTORY;