DBA Data[Home] [Help]

APPS.HR_TRANSACTION_SNAPSHOT_SWI SQL Statements

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

Line: 58

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';
Line: 89

end update_transaction_snapshot;
Line: 96

procedure delete_transaction_snapshot
(
   P_SNAPSHOT_ID              IN    NUMBER
  ,P_OBJECT_VERSION_NUMBER    IN    NUMBER
)
--
is
    l_proc varchar2(30) := 'delete_transaction';
Line: 115

end delete_transaction_snapshot;