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_HOOKS

Object Details

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

This table contains data sourced from HR core development, legislation
development teams and legislation vertical market groups. It
contains the list of hook points which are available in each API
module. The data in this table must not be updated by customer code.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: HR_API_HOOKS_PK

API_HOOK_ID

Unique Key: HR_API_HOOKS_UK1

API_MODULE_ID
API_HOOK_TYPE

Unique Key: HR_API_HOOKS_UK2

HOOK_PACKAGE
HOOK_PROCEDURE

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_API_HOOKS_PK	NORMAL	UNIQUE	APPS_TS_SEED	API_HOOK_ID
HR_API_HOOKS_UK1	NORMAL	UNIQUE	APPS_TS_SEED	API_MODULE_ID API_HOOK_TYPE
HR_API_HOOKS_UK2	NORMAL	UNIQUE	APPS_TS_SEED	HOOK_PACKAGE HOOK_PROCEDURE

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_API_HOOKS		HR_API_MODULES	HR_API_HOOKS API_MODULE_ID
HR_API_HOOK_CALLS		HR_API_HOOKS	HR_API_HOOK_CALLS API_HOOK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
API_HOOK_ID	NUMBER	(15)	Yes	System generated primary key column.
API_MODULE_ID	NUMBER	(15)	Yes	Foreign key to HR_API_MODULES
API_HOOK_TYPE	VARCHAR2	(30)	Yes	Type of hook
HOOK_PACKAGE	VARCHAR2	(30)	Yes	Name of the database package which the business process or row handler calls when the hook point is reached.
HOOK_PROCEDURE	VARCHAR2	(30)	Yes	Name of the procedure with HOOK_PACKAGE which the business process or row handler calls when the hook point is reached.
LEGISLATION_CODE	VARCHAR2	(30)		Identifies rows created by legislation group/partners or legislation vertical markets. Will be null for all hooks provided by HR development core products.
LEGISLATION_PACKAGE	VARCHAR2	(30)		Holds the name of the database package to be called, to derive the legislation code, when legislation specific logicexists and p_business_group_id is not a known parameter to the hook package.
LEGISLATION_FUNCTION	VARCHAR2	(30)		Name of the function, within the database package LEGISLATION_PACKAGE, to call when the legislation code needs to be known.
ENCODED_ERROR	VARCHAR2	(2000)		Holds the error text in AOL encoded format if the code to call the legislation_procedure or hook_procedure could not be created by the preprocessor..
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.

Query Text

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


SELECT API_HOOK_ID
,      API_MODULE_ID
,      API_HOOK_TYPE
,      HOOK_PACKAGE
,      HOOK_PROCEDURE
,      LEGISLATION_CODE
,      LEGISLATION_PACKAGE
,      LEGISLATION_FUNCTION
,      ENCODED_ERROR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.HR_API_HOOKS;

Dependencies

[top of page]

HR.HR_API_HOOKS does not reference any database object

HR.HR_API_HOOKS is referenced by following:

APPS: HR_API_HOOKS; HR_API_HOOKS_WHO
PUBLIC: HR_API_HOOKS