Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | MODULE_ARGUMENT |
| Short Name | ARG |
| View Name | CI_MODULE_ARGUMENTS |
| Description | An argument passed to, from or modified by a module |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: GENERAL_MODULE versionable object ORACLE_OBJECT_TYPE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
GENERAL_MODULE_REFERENCE PLSQL_MODULE_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_ARG |
| Changes: | Summary of changes to MODULE_ARGUMENT in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| GENERAL_MODULE_REFERENCE | N |
Prompt: Module
Transferable only if null |
Must be within one and only one GENERAL_MODULE | 90 |
| PLSQL_MODULE_REFERENCE | N |
Prompt: PL/SQL Definition
Transferable only if null |
Must be within one and only one PLSQL_MODULE | 90 |
| COLUMN_REFERENCE | Y | Prompt: Column | May be defined by one and only one COLUMN | 25 |
| DATASTRUCTURE_REFERENCE | Y | Prompt: Datastructure | May be defined by one and only one DATASTRUCTURE | 25 |
| DOMAIN_REFERENCE | Y | Prompt: Domain | May be defined by one and only one DOMAIN | 25 |
| ORACLE_TYPE_REFERENCE | Y | Prompt: Oracle Type | May be defined by one and only one ORACLE_TYPE | 25 |
| TABLE_DEFINITION_REFERENCE | Y | Prompt: Table Definition | May be defined by one and only one TABLE_DEFINITION | 25 |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ATTRIBUTE_OR_DATAITEM | NUMBER(38, 0) | Y | A foreign key to either 'Attributes' or 'Data Items' to record the link back to analysis info that the argument was derived from.
Not displayed System maintained Not updatable by user | ||
| DATATYPE | VARCHAR2(70) | Y | The datatype for this argument.
Prompt: Datatype | DATATYPE_LARGE Non-enforced Language specific values | |
| DEFAULT_VALUE | VARCHAR2(60) | Y | The default value for the argument.
Prompt: Default | ||
| DEFAULT_VALUE_TYPE | VARCHAR2(15) | N | Indicates the nature of the default value
Prompt: Default Value Type Uppercase | DEFAULT_VALUE_TYPE | LITERAL |
| DISPLAY_FLAG | VARCHAR2(1) | N | Indicates whether argument to be displayed, allowing argument to be explicity hidden from the user. Hidden arguments may have their value supplied via an ARGUMENT_PASSED_VALUE
Prompt: Display ? Uppercase | YESNO | Y |
| INPUT_MASK | VARCHAR2(20) | Y | Display datatype used as input mask for argument
Prompt: Input Mask Uppercase | ||
| INPUT_OUTPUT_IDENTIFIER | VARCHAR2(13) | Y | An indicator to show whether the argument is to be used for input, output or to modify the module.
Prompt: Input Output Uppercase | ARG_INPUT_OUTPUT_IDENTIFIER | |
| LENGTH | NUMBER(6, 0) | Y | The maximum number of characters used to express the value of the argument.
Prompt: Length | ||
| MODULE_ARGUMENT_FOR | VARCHAR2(8) | N | Arc 25 discriminator. Discriminator for "logical arc" comprised of the foreign keys DATASTRUCTURE_REFERENCE, DOMAIN_REFERENCE, etc and the property DATATYPE
Not displayed Uppercase System maintained Not updatable by user | MODULE_ARGUMENT_FOR | |
| MODULE_TYPE_FOR | VARCHAR2(3) | N | Arc 90 discriminator. Indicates whether the argument is for a PL/SQL module or a general module
Not displayed Uppercase System maintained Not updatable by user | GEM_OR_PLM | |
| NAME | VARCHAR2(30) | N | Alias by which the argument is identified
Prompt: Name | ||
| OPTIONAL_FLAG | VARCHAR2(1) | N | Indicates whether null is a valid value for the argument
Prompt: Optional ? Uppercase | YESNO | N |
| POSITION | NUMBER(6, 0) | Y | The position of this argument among other arguments for the module
Prompt: Position | ||
| PROMPT | VARCHAR2(130) | Y | The text to be used as a prompt for this argument.
Prompt: Prompt | ||
| REMARK | VARCHAR2(240) | Y | A comment for the argument.
Prompt: Comment | ||
| SCALE | NUMBER(3, 0) | Y | The number of decimal places in the argument.
Prompt: Decimal Places | ||
| SOFT_LOV | VARCHAR2(1) | N | Applicable when module argument has valid values defined directly against it, as opposed to being in a domain. Value of Y indicates that value of module argument is to be checked against a table (ie soft-coded). Used by the Generators.
Prompt: Dynamic List ? Uppercase | YESNO | N |
| SUBSTITUTION_VARIABLE | VARCHAR2(40) | Y | The name for a substitution variable for this argument.
Prompt: Substitution String | ||
| SUGGESTION_LIST_FLAG | VARCHAR2(1) | N | Indicates whether the domain of the argument is a suggestion list only, ie not enforced
Prompt: Suggestion List ? 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 SAC 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 SAC supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| FULL_DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
| MODULE_ARGUMENT has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference MODULE_ARGUMENT:
Note: