This page (revision-18) was last changed on 26-Nov-2021 10:22 by RForbes

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
18 26-Nov-2021 10:22 2 KB RForbes to previous
17 26-Nov-2021 10:22 2 KB RForbes to previous | to last
16 26-Nov-2021 10:22 2 KB JMyers to previous | to last
15 26-Nov-2021 10:22 2 KB JMyers to previous | to last
14 26-Nov-2021 10:22 2 KB JEscott to previous | to last
13 26-Nov-2021 10:22 2 KB JEscott to previous | to last
12 26-Nov-2021 10:22 2 KB JEscott to previous | to last
11 26-Nov-2021 10:22 1 KB JEscott to previous | to last
10 26-Nov-2021 10:22 1 KB RForbes to previous | to last
9 26-Nov-2021 10:22 1 KB JMyers to previous | to last
8 26-Nov-2021 10:22 1 KB JMyers to previous | to last
7 26-Nov-2021 10:22 1 KB JMyers to previous | to last
6 26-Nov-2021 10:22 1 KB JMyers to previous | to last
5 26-Nov-2021 10:22 1 KB JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1014 bytes JMyers to previous | to last
2 26-Nov-2021 10:22 1020 bytes JMyers to previous | to last
1 26-Nov-2021 10:22 831 bytes JMyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 1 added 2 lines
[{TableOfContents }]
At line 5 changed 11 lines
Seq #
Parameter Name
This field identifies the parameter by name.
Prompt
This field displays how the parameter will be identified in the columns on forms in the system.
Prompt (FRE)
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 Item Name Data Type
Description
This field provides a quick description of the parameter.
ID
The definition data for the Define Parameters screen is stored in the [P2K_AM_FUNCTIONS] and [P2K_AM_PARAMETERS] tables.
At line 9 added 12 lines
;[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.
\\ \\
----
At line 19 changed 9 lines
Print Format
Parameter Length
Error Code
Hint Text
Mandatory
Singular
Filter
Default Value
;[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.
\\ \\
----
At line 30 changed one line
Validation Clause LOV Query
;[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'}]