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_TRANSACTIONS

Object Details

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

HR_API_TRANSACTIONS contains a row for each Web Kiosk process that has
been started. It is the parent of HR_API_TRANSACTION_STEPS, which is
the parent of HR_API_TRANSACTION_VALUES.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HR_API_TRANSACTIONS_PK

TRANSACTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_API_TRANSACTIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID
SYS_IL0000044421C00028$$	LOB	UNIQUE	APPS_TS_TX_DATA
HR_API_TRANSACTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_TYPE ITEM_KEY
HR_API_TRANSACTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATOR_PERSON_ID SELECTED_PERSON_ID
HR_API_TRANSACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SELECTED_PERSON_ID STATUS
HR_API_TRANSACTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_TRANSACTION_ID
HR_API_TRANSACTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_REF_ID TRANSACTION_REF_TABLE
HR_API_TRANSACTIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATOR_ROLE

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_API_TRANSACTION_STEPS		HR_API_TRANSACTIONS	HR_API_TRANSACTION_STEPS TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER	(15)	Yes	System-generated primary key column.
CREATOR_PERSON_ID	NUMBER	(15)	Yes	Foreign key to PER_PEOPLE_F.
TRANSACTION_PRIVILEGE	VARCHAR2	(30)	Yes	When this column is 'Private', only the creator of the kiosk process can modify the data values associated with it.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
PRODUCT_CODE	VARCHAR2	(15)		Product code
STATUS	VARCHAR2	(10)		Transaction Status
SECTION_DISPLAY_NAME	VARCHAR2	(500)		Action Display Name
FUNCTION_ID	NUMBER	(10)		Selected Function
TRANSACTION_REF_TABLE	VARCHAR2	(100)		External Table
TRANSACTION_REF_ID	NUMBER	(15)		External Table Primary Key
TRANSACTION_TYPE	VARCHAR2	(10)		WorkFlow or not
ASSIGNMENT_ID	NUMBER	(15)		Selected Assignment
API_ADDTNL_INFO	VARCHAR2	(1000)		Any Additional Info
SELECTED_PERSON_ID	NUMBER	(15)		Selected Person Id for this Transaction
ITEM_TYPE	VARCHAR2	(10)		Item type
ITEM_KEY	VARCHAR2	(240)		Item key
TRANSACTION_EFFECTIVE_DATE	DATE			Transaction effective date
PROCESS_NAME	VARCHAR2	(30)		Process name
URL	LONG	(0)		URL to relaunch the suspended Transaction
TRANSACTION_STATE	VARCHAR2	(10)		State in which transaction is (e.g. Transient, WIP etc)
EFFECTIVE_DATE_OPTION	VARCHAR2	(10)		Effective Date Option ( Approval Date / Effective Date)
RPTG_GRP_ID	NUMBER	(15)		BEN Reporting Group Id, populated of eligibility model
PLAN_ID	NUMBER			BEN Plan Id, populated for eligibility model
TRANSACTION_DOCUMENT	CLOB	(4000)		Transaction Document
RELAUNCH_FUNCTION	VARCHAR2	(30)		Relaunch Function
TRANSACTION_GROUP	VARCHAR2	(60)		Transaction Group
TRANSACTION_IDENTIFIER	VARCHAR2	(60)		Transaction Identifier
PARENT_TRANSACTION_ID	NUMBER	(15)		Parent Transaction ID
CREATOR_ROLE	VARCHAR2	(320)		Creator Role
LAST_UPDATE_ROLE	VARCHAR2	(320)		Last Update Role

Query Text

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


SELECT TRANSACTION_ID
,      CREATOR_PERSON_ID
,      TRANSACTION_PRIVILEGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PRODUCT_CODE
,      STATUS
,      SECTION_DISPLAY_NAME
,      FUNCTION_ID
,      TRANSACTION_REF_TABLE
,      TRANSACTION_REF_ID
,      TRANSACTION_TYPE
,      ASSIGNMENT_ID
,      API_ADDTNL_INFO
,      SELECTED_PERSON_ID
,      ITEM_TYPE
,      ITEM_KEY
,      TRANSACTION_EFFECTIVE_DATE
,      PROCESS_NAME
,      URL
,      TRANSACTION_STATE
,      EFFECTIVE_DATE_OPTION
,      RPTG_GRP_ID
,      PLAN_ID
,      TRANSACTION_DOCUMENT
,      RELAUNCH_FUNCTION
,      TRANSACTION_GROUP
,      TRANSACTION_IDENTIFIER
,      PARENT_TRANSACTION_ID
,      CREATOR_ROLE
,      LAST_UPDATE_ROLE
FROM HR.HR_API_TRANSACTIONS;

Dependencies

[top of page]

HR.HR_API_TRANSACTIONS does not reference any database object

HR.HR_API_TRANSACTIONS is referenced by following:

APPS: HR_API_TRANSACTIONS; HR_API_TRANSACTIONS_WHO
PUBLIC: HR_API_TRANSACTIONS