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: PA.PA_ACTION_SET_TYPES

Object Details

Object Name:	PA_ACTION_SET_TYPES
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_ACTION_SET_TYPES
Subobject Name:
Status:	VALID

PA_ACTION_SET_TYPES stores attributes of action set types

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_ACTION_SET_TYPES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTION_SET_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ACTION_SET_TYPE_CODE	VARCHAR2	(30)	Yes	Identifier of the Action Set Type.
ACTION_SET_TYPE_NAME	VARCHAR2	(80)	Yes	Name of the Action Set Type. This name will be used to generate the page headings / button labels / tips on generic pages. It should NOT contain the word rule or action set. For example, for action_set_type_code ADVERTISEMENT, the action_set_type_name is 'Adevertisement'.
OBJECT_TYPE	VARCHAR2	(30)	Yes	Object Type to which this action set type belongs.
CONC_PROGRAM_VIEW_NAME	VARCHAR2	(30)	Yes	Name of the view that will be used to find the action sets to be performed when the Perfrom Action Sets concurrent program is run. Only module specific business logic can be put in this view. Action Set statuses will be checked by the generic model.This view must have the following columns: project_number, object_type, object_id, and object_name. Object name is the object to which this action set belongs. For example, an Advertisement action set belongs to an assignment - so the object_name will be the assignment name. This will be used in the concurrent program report.When the concurrent program is run for this action set type, the generic model will select from this view WHERE project_number between project_number_from and project_number_to that are concurrent program parameters.Business logic such as - don not perform any action sets if the project start date is in the future can be put in the view.
EDIT_TEMPLATE_SEC_FUNC_CODE	VARCHAR2	(30)		Name of security function used to secure create and edit access to Define Action Set page. If this column is NULL then no security check will be performed.
EDIT_OBJECT_SEC_FUNC_CODE	VARCHAR2	(30)		Name of security function used to secure edit access to action lines belonging to an object. Object is hard-coded as Project in the initial release.
VALIDATE_ACTION_SET_LINE_CALL	VARCHAR2	(61)		Name of API (PackageName.ProcedureName) to call in order to validate an action set line. Almost all validation within a single line should be handled by value set validation, but if not possible then this API should be implemented. If not required, leave the column blank.
ACTION_SET_STARTED_CALL	VARCHAR2	(61)		Name of function (PackageName.FunctionName) to call to determine if the action set should be started by default when an action set is applied to an object. Module-specific business logic should be put in this API. If you always want the action set to be started, then there is no need to implement this API - leave the column blank.
PERFORM_ACTION_SET_LINE_CALL	VARCHAR2	(61)	Yes	Name of API (PackageName.ProcedureName) to call in order to perform an action set line.
PROCESS_ACTION_SET_CALL	VARCHAR2	(61)	Yes	Name of API (PackageName.ProcedureName) to call in order to process an action set. Cross-line validation, as well as updating the line number and condition date should be in this API.
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column

Query Text

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


SELECT ACTION_SET_TYPE_CODE
,      ACTION_SET_TYPE_NAME
,      OBJECT_TYPE
,      CONC_PROGRAM_VIEW_NAME
,      EDIT_TEMPLATE_SEC_FUNC_CODE
,      EDIT_OBJECT_SEC_FUNC_CODE
,      VALIDATE_ACTION_SET_LINE_CALL
,      ACTION_SET_STARTED_CALL
,      PERFORM_ACTION_SET_LINE_CALL
,      PROCESS_ACTION_SET_CALL
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_ACTION_SET_TYPES;

Dependencies

[top of page]

PA.PA_ACTION_SET_TYPES does not reference any database object

PA.PA_ACTION_SET_TYPES is referenced by following:

APPS: PA_ACTION_SET_TYPES