Friday, November 9, 2018

Delete User Hook in Oracle HRMS

Delete User Hook in Oracle HRMS

select * from hr_api_hook_calls where call_package like 'XX%'

declare
ln_ovn number := 2;
begin
hr_api_hook_call_api.delete_api_hook_call
  (p_validate                          =>  false,
   p_api_hook_call_id                  => 1140,
   p_object_version_number             => ln_ovn
  );
end;

No comments:

Post a Comment

SQL Important Queries

  How to delete rows with no where clause The following example deletes  all rows  from the  Person.Person  the table in the AdventureWork...