Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | MODULE_COMPONENT |
| Short Name | MCO |
| View Name | CI_MODULE_COMPONENTS |
| Description | A potentially re-usable component of a module, analagous to a |
| block in a form or a query in a report. Each module component | |
| consists of one base table and all its look-ups, sub-queries and/or | |
| single row SQL aggregates. | |
| A module component may either be "SPECIFIC" to a single module (ie | |
| not re-usable) or "REUSABLE" (ie available for re-use), as indicated | |
| by the property MODULE_COMPONENT_TYPE | |
| A "SPECIFIC" module component is further distinguished by the | |
| fact that its foreign key MODULE_REFERENCE is populated, linking it | |
| to a single module. This is denormalised information for performance | |
| reasons as a single module component inclusion will also exist between | |
| the "SPECIFIC" module component and the module. MODULE_REFERENCE | |
| CANNOT be used where it is required to retrieve all module components | |
| for a given module (as it would not include any REUSABLE ones) and | |
| this can only be done via module component inclusions for the module. | |
| "REUSABLE" module components have more stringent uniqueness criteria | |
| than "SPECIFIC" ones, and also can be shared between application | |
| systems. | |
| Sub-type of | MODULE_UNIT |
| Non-instantiable super-type of | REUSABLE_MCO |
| SPECIFIC_MCO | |
| As this is a non-instantiable supertype, follow links (above) to its instantiable subtypes to find versioning information for each subtype, uniqueness criteria, API rules etc | |
| Underlying table: | SDD_MUN |
| Changes: | Summary of changes to MODULE_COMPONENT in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| LANGUAGE_REFERENCE | N | Prompt: Language | Must be written in one and only one LANGUAGE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| AUTOQUERY_FLAG | VARCHAR2(1) | N | Indicates whether block/zone should be automatically queried on startup (for masterless blocks) and on change of master (for detail blocks). A value of 'Default Behaviour' indicates the generator will decide
Prompt: Autoquery ? Uppercase | YESNODEF | D |
| DATASOURCE_TYPE | VARCHAR2(16) | N | Type of data source through which generated module component will retrieve data. If other than 'TABLE', Forms Generator will generate a datasource of the required type based on the DTU information defined for the module component
Prompt: Datasource Type Uppercase | DATASOURCE_TYPE | TABLE |
| DATATARGET_TYPE | VARCHAR2(16) | N | Type of data target through which generated module component will write data. If other than 'TABLE', Forms Generator will generate a datatarget of the required type from the DTU information defined for the module component
Prompt: Datatarget Type Uppercase | DATATARGET_TYPE | TABLE |
| DELETE_FLAG | VARCHAR2(1) | N | Indicates whether this module component will allow the user to delete rows in its base table
Prompt: Delete ? Uppercase | YESNO | N |
| DISPLAY_TITLE | VARCHAR2(70) | Y | The title to be displayed in screens and reports for this module unit
Prompt: Title Defined on MUN supertype | ||
| HELP_CONTEXT_ID_PREFIX | NUMBER(3, 0) | Y | If specified, Help Generator will use it to allocate unique help context ids for all help items derived from the component
Prompt: Help Context Id Prefix | ||
| HELP_CONTEXT_ID_SUFFIX | NUMBER(5, 0) | Y | Allocated by the help generator. Combined with the help prefix on module, forms a unique number within the scope set for the help
Not displayed | ||
| IMPLEMENTATION_ITEM | VARCHAR2(30) | Y | Name of template/library object on which the generated module component will be based.
Prompt: Template/Library Object | ||
| INSERT_FLAG | VARCHAR2(1) | N | Indicates whether this module component will allow in the user to update rows of its base table
Prompt: Insert ? Uppercase | YESNO | N |
| LAYOUT_STYLE | VARCHAR2(20) | Y | Layout style to be applied to this module unit
Prompt: Layout Style Uppercase Defined on MUN supertype | MTI_REPORT_FORMAT
Language specific values | |
| MODULE_UNIT_SUBTYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal property indicating the type of MODULE_UNIT
Not displayed Uppercase System maintained Not updatable by user Defined on MUN supertype | MUN_SUBTYPE | |
| NAME | VARCHAR2(30) | N | Name by which this module unit is identified
Prompt: Name Uppercase Defined on MUN supertype | ||
| REQ_OVERFLOW | VARCHAR2(30) | Y | Required overflow option for the base table usage, used to determine the overflow layout style, enabling the user to control hoizontal expansion of resulting generated block
Prompt: Overflow Uppercase | DTU_LAYOUT_OPTIONS | |
| REQ_PAGE_HEIGHT | NUMBER(6, 0) | Y | Required page/popup height. In units specified in the template form
Prompt: Height Defined on MUN supertype | ||
| REQ_PAGE_WIDTH | NUMBER(6, 0) | Y | Required page/popup width. In units specified in the template form
Prompt: Width Defined on MUN supertype | ||
| REQ_VIEW_HEIGHT | NUMBER(6, 0) | Y | Required view height. In units specified in template form.
Prompt: View Height | ||
| REQ_VIEW_WIDTH | NUMBER(6, 0) | Y | Required view width. In units specified in the template form.
Prompt: View Width | ||
| ROWS_DISPLAYED | NUMBER(10, 0) | Y | The number of rows of the base table to be displayed in this module unit
Prompt: Rows Displayed Defined on MUN supertype | ||
| RUNTIME_PATHNAME | VARCHAR2(240) | Y | Used and maintained by the Forms Generator to record the name of the file, including pathname, into which the reusable module component has been generated. Applicable to REUSABLE module components only.
Not displayed | ||
| SELECT_FLAG | VARCHAR2(1) | N | Indicates whether this module component will allow the user to select rows from its base table
Prompt: Query ? Uppercase | YESNO | Y |
| SHORT_DESCRIPTION | VARCHAR2(60) | Y | Short textual description of the module unit
Prompt: Short Description Defined on MUN supertype | ||
| UPDATE_FLAG | VARCHAR2(1) | N | Indicates whether this module component will allow the user to update rows in its base table
Prompt: Update ? Uppercase | YESNO | N |
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs.
Not displayed System maintained Updatable only if null Defined on MUN supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs.
Not displayed System maintained Not updatable by user Defined on MUN supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC Defined on MUN supertype |
Description |
| HELP | CDHELP | User/Help Text |
| NOTES | CDINOT Defined on MUN supertype |
Notes |
| Other Properties |
|---|
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference MODULE_COMPONENT:
Note: