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_MODULES

Object Details

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

This table contains details of the business processes and row handlers
which contain user hooks.
This table will contain data sourced from HR core development. If
legislation group/partners and legislation vertical market groups
implement additional APIs they will also own rows in this table.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: HR_API_MODULES_PK

API_MODULE_ID

Unique Key: HR_API_MODULES_UK1

API_MODULE_TYPE
MODULE_NAME

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_API_MODULES_PK	NORMAL	UNIQUE	APPS_TS_SEED	API_MODULE_ID
HR_API_MODULES_UK1	NORMAL	UNIQUE	APPS_TS_SEED	API_MODULE_TYPE MODULE_NAME

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_API_HOOKS		HR_API_MODULES	HR_API_HOOKS API_MODULE_ID
HR_PUMP_BATCH_LINES		HR_API_MODULES	HR_PUMP_BATCH_LINES API_MODULE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
API_MODULE_ID	NUMBER	(15)	Yes	Unique ID for the module.
API_MODULE_TYPE	VARCHAR2	(30)	Yes	Module type of the API.
MODULE_NAME	VARCHAR2	(30)	Yes	Module name of the API.
DATA_WITHIN_BUSINESS_GROUP	VARCHAR2	(30)	Yes	Indicates if the data assoicated with this module is within the context of a business_group_id.
LEGISLATION_CODE	VARCHAR2	(30)		NULL for APIs implemented and maintained by HR core evelopment. Not null for extra legislation or legislation vertical market business processes which will contain customer hooks.
MODULE_PACKAGE	VARCHAR2	(30)		When API_MODULE_TYPE is 'BP' holds the name of the database package containing the business process procedure otherwise NULL.
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_MODULE_ID
,      API_MODULE_TYPE
,      MODULE_NAME
,      DATA_WITHIN_BUSINESS_GROUP
,      LEGISLATION_CODE
,      MODULE_PACKAGE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.HR_API_MODULES;

Dependencies

[top of page]

HR.HR_API_MODULES does not reference any database object

HR.HR_API_MODULES is referenced by following:

APPS: HR_API_MODULES; HR_API_MODULES_WHO
PUBLIC: HR_API_MODULES