DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_FNCTN_PRMTRS_V

Object Details
Object Name: OKL_FNCTN_PRMTRS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_FNCTN_PRMTRS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


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


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier in the database
ID NUMBER
Yes Primary key column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
SFWT_FLAG VARCHAR2 (3) Yes Column used by the translation batch program
DSF_ID NUMBER
Yes Foreign key to table OKL_DATA_SRC_FNCTNS_B
PMR_ID NUMBER

Foreign key to table OKL_PARAMETERS_B
SEQUENCE_NUMBER NUMBER (5) Yes Sequence number
VALUE VARCHAR2 (240)
Actual Value like 10, 'Joe'...
INSTRUCTIONS VARCHAR2 (720)
Instructions for this function parameter value.
FPR_TYPE VARCHAR2 (10) Yes This column represents function parameter type. It can have two values STATIC and CONTEXT.
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
Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      DSF_ID
,      PMR_ID
,      SEQUENCE_NUMBER
,      VALUE
,      INSTRUCTIONS
,      FPR_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKL_FNCTN_PRMTRS_V;

Dependencies

[top of page]

APPS.OKL_FNCTN_PRMTRS_V references the following:

SchemaAPPS
SynonymOKL_FNCTN_PRMTRS_B
SynonymOKL_FNCTN_PRMTRS_TL
APPS.OKL_FNCTN_PRMTRS_V is referenced by following:

SchemaAPPS
Package BodyOKL_EXECUTE_FORMULA_PVT - show dependent code
PL/SQL PackageOKL_EXECUTE_FORMULA_PVT - show dependent code
Package BodyOKL_FORMULAEVALUATE_PVT - show dependent code
Package BodyOKL_FORMULAVALIDATE_PVT - show dependent code
PL/SQL PackageOKL_FPR_PVT - show dependent code
Package BodyOKL_FPR_PVT - show dependent code
Package BodyOKL_SETUPDSFPARAMETERS_PVT - show dependent code