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]

VIEW: APPS.EGO_FUNC_PARAMS_V

Object Details

Object Name:	EGO_FUNC_PARAMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EGO.EGO_FUNC_PARAMS_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

View EGO_FUNC_PARAMS_V provides the metadata for User-Defined functions and their parameters. Each row of this table provides information such as display name, description, type, and names of procedures and/or packages to be executed for a given function as well as its parameter type (input,return value,etc) and meaning of the parameter type.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
FUNC_PARAM_ID	NUMBER		Yes	Function Id
FUNCTION_ID	NUMBER		Yes	Function Parameter identifier
SEQUENCE	NUMBER		Yes	Sequence
INTERNAL_NAME	VARCHAR2	(60)	Yes	Function parameter internal name
DISPLAY_NAME	VARCHAR2	(150)	Yes	User-friendly name for the Parameter
DESCRIPTION	VARCHAR2	(240)		A brief explanation of the Parameter purpose, function, etc.
DATA_TYPE_CODE	VARCHAR2	(2)	Yes	Data type of the parameter ( N,V,..)
DATA_TYPE_MEANING	VARCHAR2	(80)	Yes	Data type meaning (Number, Varchar, ..)
FUNC_TYPE_CODE	VARCHAR2	(30)	Yes	Type of the Function (Ex: P )
FUNC_TYPE_MEANING	VARCHAR2	(80)	Yes	Meaning of the Function (Ex: PL/SQL )
PARAM_TYPE_CODE	VARCHAR2	(1)	Yes	Parameter type (input,return value,etc)
PARAM_TYPE_MEANING	VARCHAR2	(80)	Yes	Meaning of Parameter type

Query Text

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


SELECT FUNC_PARAM_ID
,      FUNCTION_ID
,      SEQUENCE
,      INTERNAL_NAME
,      DISPLAY_NAME
,      DESCRIPTION
,      DATA_TYPE_CODE
,      DATA_TYPE_MEANING
,      FUNC_TYPE_CODE
,      FUNC_TYPE_MEANING
,      PARAM_TYPE_CODE
,      PARAM_TYPE_MEANING
FROM APPS.EGO_FUNC_PARAMS_V;

Dependencies

[top of page]

APPS.EGO_FUNC_PARAMS_V references the following:

APPS: EGO_FUNCTIONS_B; EGO_FUNC_PARAMS_B; EGO_FUNC_PARAMS_TL; FND_LOOKUP_VALUES

APPS.EGO_FUNC_PARAMS_V is not referenced by any database object