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.PAY_TRIGGER_PARAMETERS

Object Details

Object Name:	PAY_TRIGGER_PARAMETERS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_TRIGGER_PARAMETERS
Subobject Name:
Status:	VALID

PAY_TRIGGER_PARAMETERS defines the mapping between input and
output parameter values, placeholders and local or bind variables.
When a component or initialisation is created mappings will be
automatically created for any required parameters or placeholders.
Where possible the value name will be populated automatically
according to the following rules;
p_l_ maps to l_
p_old_ maps to :old.
p_new_ maps to :new.
$L_$ maps to l_
$OLD_$ maps to :old.
$NEW_$ maps to :new.
Any other mappings will have to be manually created. Automatic as
well as manual mappings will be checked for validity, e.g. that the
parameter has been declared, that the bind variable is valid for
this type of trigger, that a bind variable is not being mapped to an
out or in out parameter. There will be a facility provided for re-trying
the automatic mapping procedure at the user's request
(e.g. a procedure definition changes) but where possible it will happen
automatically.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_TRIGGER_PARAMETERS_PK

PARAMETER_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_TRIGGER_PARAMETERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARAMETER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PARAMETER_ID	NUMBER	(15)	Yes	System-generated primary key column.
USAGE_TYPE	VARCHAR2	(30)	Yes	Defines the way in which the mapping will be interpreted;I - The mapping is used by a row in the initialisations entity.C - The mapping is used by a row in the components entity.
USAGE_ID	NUMBER	(15)	Yes	A soft foreign key to either component_id or initialisation_id depending on the value of usage_type.
PARAMETER_TYPE	VARCHAR2	(1)	Yes	How this parameter mapping will be used;R - Return. Only valid for I-type usages where the initialisation is if type F, S, A. The mapping defines the local variable into which the function, assignment or select list item will return it's value. The parameter_name is only specified for S-type initialisations. It is not permitted to return values into :old or :new bind variables.I - Input. Valid for I and C type usages. The mapping defines the local or bind variable which will be passed to a function or procedure as an input parameter, or which will be used in place of a $_$ placeholder in an S or A type initialisation. Both parameter_name (either parameter or placeholder name) and value_name must be supplied.O - Output. Valid only for I-type usages for initialisations of type P. Defines the mapping between the out parameters of the procedure and local variables. It is not permitted to return values into :old or :new bind variables. The parameter and value_names must both be supllied.
PARAMETER_NAME	VARCHAR2	(60)		The name of the function or procedure parameter to map, or the name of a placeholder in an SQL or PL/SQL statement. This value will be automatically populated based on the usage of the mapping and the user will not be permitted to change it. It is not required for return type usages.
VALUE_NAME	VARCHAR2	(2000)		The full name of the local or bind variable to map to the parameter, placeholder or return value. This should include the l_, :old, :new prefix. Where possible these values will be automatically generated based on name matching but they may be modified manually. If no name is specified here then a value will not be passed for this parameter (only allowed for procedure and function type usages).
AUTOMATIC	VARCHAR2	(1)	Yes	A Y or N flag indicating that this mapping was automatically generated, this allows the mapping to be changed if the automatic mapper is called again for this usage. If the user changes the mapping in any way then this flag is changed to N and the row will subsequently not be changed by the automatic mapper. The user is not permitted to switch this flag on.

Query Text

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


SELECT PARAMETER_ID
,      USAGE_TYPE
,      USAGE_ID
,      PARAMETER_TYPE
,      PARAMETER_NAME
,      VALUE_NAME
,      AUTOMATIC
FROM HR.PAY_TRIGGER_PARAMETERS;

Dependencies

[top of page]

HR.PAY_TRIGGER_PARAMETERS does not reference any database object

HR.PAY_TRIGGER_PARAMETERS is referenced by following:

APPS: PAY_TRIGGER_PARAMETERS
PUBLIC: PAY_TRIGGER_PARAMETERS