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: OKL.OKL_FNCTN_PRMTRS_B

Object Details

Object Name:	OKL_FNCTN_PRMTRS_B
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_FNCTN_PRMTRS_B
Subobject Name:
Status:	VALID

DEFINITION
Association of Parameter and Functions.
This indicates the list of parameters required by the function to return a scalar numeric value.
This should not include khr_id and kle_id.

a) A function parameter with a constant is termed as static function parameter.
b) A parameter that does not have a constant value is a dynamic function parameter.

EXAMPLE
- This is just an example.
Name of the function : FN_CONTRACT_TRANSACTION
Source DB function : OKL_SEEDED_FUNCTIONS_PVT.FUNCTION_PARAMETER_EXAMPLE(KHR_ID,KLE_ID, TRX_DATE)
In this example the TRX_DATE is a function parameter for the Function FN_CONTRACT_TRANSACTION
The functions defined in OKL_FORMULAFUNCTION_PVT.GET_TRX_DATE_VALUE should have the logic
to retrieve the value for TRX_DATE.

Any formula that needs this function should have the appropriate context group that contains TRX_DATE as context parameter.
MISCELLANEOUS

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_FPR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID ZD_EDITION_NAME
OKL_FPR_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	DSF_ID SEQUENCE_NUMBER ZD_EDITION_NAME
OKL_FPR_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	DSF_ID PMR_ID ZD_EDITION_NAME
OKL_PMR_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PMR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
DSF_ID	NUMBER		Yes	Foreign key to table OKL_DATA_SRC_FNCTNS_B
PMR_ID	NUMBER			Foreign key to table OKL_PARAMETERS_B
FPR_TYPE	VARCHAR2	(10)	Yes	This column represents function parameter type. It can have two values STATIC and CONTEXT.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
SEQUENCE_NUMBER	NUMBER	(5)	Yes	Sequence number
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT ID
,      DSF_ID
,      PMR_ID
,      FPR_TYPE
,      OBJECT_VERSION_NUMBER
,      SEQUENCE_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM OKL.OKL_FNCTN_PRMTRS_B;

Dependencies

[top of page]

OKL.OKL_FNCTN_PRMTRS_B does not reference any database object

OKL.OKL_FNCTN_PRMTRS_B is referenced by following:

OKL: OKL_FNCTN_PRMTRS_B#