The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure update_transaction_snapshot
(
P_DOCUMENT IN CLOB
,P_SNAPSHOT_ID IN NUMBER
,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
,P_OBJECT_NAME IN VARCHAR2
,P_OBJECT_IDENTIFIER IN VARCHAR2
,P_VALIDATE IN NUMBER default hr_api.g_false_num
)
--
is
l_proc varchar2(30) := 'update_transaction';
end update_transaction_snapshot;
procedure delete_transaction_snapshot
(
P_SNAPSHOT_ID IN NUMBER
,P_OBJECT_VERSION_NUMBER IN NUMBER
)
--
is
l_proc varchar2(30) := 'delete_transaction';
end delete_transaction_snapshot;