[{TableOfContents }]

!!!DEFINE PARAMETERS

The Define Parameters (IMPM) is used to maintain the supplied parameters for the reports within the system. 
 
The definition data for the Define Parameters screen is stored in the [P2K_AM_FUNCTIONS] and [P2K_AM_PARAMETERS] tables.

;[Description|DESCRIPTION]:This field provides a short description of the parameter.
;[Table|TABLE_NAME]:This field identifies the table associated with the parameter.
;[Seq #|PARAMETER_SEQUENCE]:This field defines the sequential order of the parameters. 
;[Parameter Name|PARAMETER_NAME]:This field identifies the parameter by name. 
;[Prompt|PARAMETER_PROMPT]:This field displays how the parameter will be identified in the columns on forms in the system. 
;[Prompt (FRE) |PARAMETER_PROMPT_TRANSLATE]:If the form is to be displayed in a second language, this field allows you to provide an alternate language name for the parameter. (On the example screen, the second language is identified as French, ‘Prompt (FRE)’.) 
;[Reference|REFERENCE_CODE]:This field allows you to provide reference information for the parameter.
;[Item Name|ITEM_NAME]: This is a mandatory field that the user can fill from the LOV (F9). This field indicates the database item that is associated with the parameter.
;[Data Type|DATA_TYPE]:This field defines the data type of parameter, for example, numeric, alphanumeric, etc.
 
\\  \\
----
!!Format tab 
 
;[Parameter Length|VALUE_LENGTH]:The length of the parameter value is defined in this field.
;[Hint Text|HINT_TEXT]:This field provides a hint as to the parameter's usage within the report.   This field is now deprecated.
;[Mandatory|MANDATORY]:If this toggle is checked, the parameter is mandatory and must be completed.
;[Singular|SINGLE_VALUE]: If this toggle is checked, only one value may be selected for the parameter
;[Filter|REPORT_FILTER]: If this toggle is checked, the parameter is used to further qualify the list of records that will be processed.
;[Default Value|DEFAULT_VALUE]:If there is a default value for the parameter, it will defined in this field.
\\  \\
----
!!Clause tab 
 
;[Validation Clause|VALIDATION_CLAUSE]:This field displays the clause that is added to the “Report List Query” in IMLQ to refine the report list.

;[LOV Query|LOV_QUERY]: This field displays the sql query used to define the List Of Values (LOV). This field is being deprecated and was only used with Oracle Forms-launched reports.



----
![Notes|Edit:Internal.IMPM] 	
[{InsertPage page='Internal.IMPM' default='Click to create a new notes page'}]