eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.HR_API_HOOK_CALLS

Object Details

Object Name:	HR_API_HOOK_CALLS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_API_HOOK_CALLS
Subobject Name:
Status:	VALID

Lists which extra logic, package procedures or formula, should be
called from the API hook points.
This table will contain rows created by legislation groups,
legislation vertical market groups and customers.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: HR_API_HOOK_CALLS_PK

API_HOOK_CALL_ID

Unique Key: HR_API_HOOK_CALLS_UK1

APPLICATION_ID
API_HOOK_ID
LEGISLATION_CODE
CALL_PACKAGE
CALL_PROCEDURE

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_API_HOOK_CALLS_PK	NORMAL	UNIQUE	APPS_TS_SEED	API_HOOK_CALL_ID
HR_API_HOOK_CALLS_UK1	NORMAL	UNIQUE	APPS_TS_SEED	API_HOOK_ID LEGISLATION_CODE APPLICATION_ID CALL_PACKAGE CALL_PROCEDURE

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_API_HOOK_CALLS		HR_API_HOOKS	HR_API_HOOK_CALLS API_HOOK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
API_HOOK_CALL_ID	NUMBER	(15)	Yes	System generated primary key column.
API_HOOK_ID	NUMBER	(15)	Yes	Foreign key to HR_API_HOOKS.
API_HOOK_CALL_TYPE	VARCHAR2	(30)	Yes	Type of hook call.
LEGISLATION_CODE	VARCHAR2	(30)		Indicates if the extra logic should be called every time the hook point is reached or when the data corresponds to a particular legislation.
SEQUENCE	NUMBER	(15)	Yes	When more than one row exists for the same API_HOOK_ID, SEQUENCE affects the order of the hook calls.
ENABLED_FLAG	VARCHAR2	(30)	Yes	Indicates if the hook call should be generated.
CALL_PACKAGE	VARCHAR2	(30)		Name of the database package which the hook package should call to carry out the legislation, legislation vertical market or customer specific logic.
CALL_PROCEDURE	VARCHAR2	(30)		Name of the procedure, within CALL_PACKAGE, which the hook package should call to carry out the legislation, legislation vertical market or customer specific logic.
PRE_PROCESSOR_DATE	DATE			The last time the API hook pre-processor program attempted (successfully or unsuccessfully) to create the package body code for this hook call.
ENCODED_ERROR	VARCHAR2	(2000)		If the last time the API hook pre-processor program failed to make the source code for this hook call, the error details will be held in this column.
STATUS	VARCHAR2	(30)	Yes	Status of hook call code at pre-processor time (as of PRE_PROCESSOR_DATE).
OBJECT_VERSION_NUMBER	NUMBER	(15)		System-generated version of row. Increments by one with each update.
LAST_UPDATE_DATE	DATE			Standard Who Column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column.
CREATED_BY	NUMBER	(15)		Standard Who Column.
CREATION_DATE	DATE			Standard Who Column.
APPLICATION_ID	NUMBER			The APPLICATION_ID of Application as defined in the FND_APPLCATION table.
APP_INSTALL_STATUS	VARCHAR2	(30)		Indicates for which installation statuses the hook call should be included in the user hook package body.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT API_HOOK_CALL_ID
,      API_HOOK_ID
,      API_HOOK_CALL_TYPE
,      LEGISLATION_CODE
,      SEQUENCE
,      ENABLED_FLAG
,      CALL_PACKAGE
,      CALL_PROCEDURE
,      PRE_PROCESSOR_DATE
,      ENCODED_ERROR
,      STATUS
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      APPLICATION_ID
,      APP_INSTALL_STATUS
FROM HR.HR_API_HOOK_CALLS;

Dependencies

[top of page]

HR.HR_API_HOOK_CALLS does not reference any database object

HR.HR_API_HOOK_CALLS is referenced by following:

APPS: HR_API_HOOK_CALLS; HR_API_HOOK_CALLS_WHO