To run the pre-processor run one of the following commands:
cd $PER_TOP/admin/sql
Log into SQLPLUS as the APPS user
SQL> @hrahkall.sql
or
SQL> @hrahkone.sql
The first script will create all hook package bodies, whilst the second will
create hook package bodies for one API module only, and prompt for that
api_module_id.
==========================================================
Sometimes if you don't have server credentials then you can use below alternative to run the pre-processor through sqlplus
Log in to database through apps
SQL> @hrahkall.sql
instead of running above script you can execute below statement
exec hr_api_user_hooks_utility.create_hooks_all_modules;
SQL> @hrahkone.sql
instead of running above script you can execute below statement
exec hr_api_user_hooks_utility.create_hooks_one_module(p_module_id);
No comments:
Post a Comment