UserHook For Element entry Screen

declare
l_api_hook_call_id      number;
l_object_version_number number;
L_API_HOOK_ID NUMBER;
begin

select ahk.api_hook_id INTO L_API_HOOK_ID
 FROM hr_api_hooks ahk, hr_api_modules ahm
 WHERE ahm.module_name like 'CREATE_PROCESS_EVENT'
   AND ahm.api_module_type = 'BP'
   AND ahk.api_hook_type = 'BP'
   AND ahk.api_module_id = ahm.api_module_id;

hr_api_hook_call_api.create_api_hook_call (p_validate  => false,
p_effective_date        => to_date('01-JUL-1999','DD-MON-YYYY'),
p_api_hook_id           => L_API_HOOK_ID ,
p_api_hook_call_type    => 'PP',
p_sequence              => 100,
p_enabled_flag          => 'Y',
p_call_package          => 'XX_HR_ELEMENT_VALID_PKG_DP',
p_call_procedure        => 'ELEMENT_VALIDATION',
p_api_hook_call_id      => l_api_hook_call_id,
p_object_version_number => l_object_version_number);

DBMS_OUTPUT.PUT_LINE('The hook call id :'||l_api_hook_call_id);


end;


Declare
Begin
hr_api_hook_call_api.delete_api_hook_call
  (p_validate                       => false,
   p_api_hook_call_id               => 1218,
   p_object_version_number          =>2  
  );

  end;


select * from hr_api_hook_calls where CALL_PACKAGE  LIKE 'XX_HR_ELEMENT_VALID_PKG%'

select * from hr_api_hook_calls
where sequence = '100'


PAY_PPE_BK1


select * from hr_api_hook_calls -- where api_hook_call_id=1141
where sequence = '3030'

select * from hr_api_hook_calls
where trunc(creation_date) = trunc(sysdate);

select * from  hr_api_modules ahm
where trunc(creation_date) = trunc(sysdate);


SELECT * FROM  XX_TEST WHERE X=10032013

select ahk.*,ahk.api_hook_id,ahm.*-- INTO L_API_HOOK_ID
 FROM hr_api_hooks ahk, hr_api_modules ahm
 WHERE ahm.module_name like 'CREATE_PROCESS_EVENT'
   AND ahm.api_module_type = 'BP'
   AND ahk.api_hook_type = 'AP'
   AND ahk.api_module_id = ahm.api_module_id;
 
   select * from  hr_api_modules where module_name like 'CREATE_PROCESS_EVENT'
 
   SELECT * FROM HR_API_HOOK_CALLS WHERE CALL_PACKAGE LIKE ''
 
   select c.encoded_error
   from hr_api_hook_calls c
  where c.api_hook_call_id = 1102;


Run Preprocessor From Toad use Below Command

DECLARE
BEGIN
    hr_api_user_hooks_utility.create_hooks_one_module(1915); -- (Pass Application Module ID )
   dbms_output.put_line('Pre-Processor Run Successfully');
    exception
    when others then
   dbms_output.put_line(sqlerrm);
END;