Element Type Definition: REUSABLE

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	REUSABLE_MCO
Short Name	RMC
View Name	CI_REUSABLE_MCOS
Description
Sub-type of	MODULE_COMPONENT
Versioning:	Structure of REUSABLE_MCO versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	Oracle Designer
Underlying table:	SDD_MUN

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
LANGUAGE_REFERENCE	N	Prompt: Language Defined on MCO supertype	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 Defined on MCO supertype	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 Defined on MCO supertype	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 Defined on MCO supertype	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 Defined on MCO supertype	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 Defined on MCO supertype
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 Defined on MCO supertype
IMPLEMENTATION_ITEM	VARCHAR2(30)	Y	Name of template/library object on which the generated module component will be based. Prompt: Template/Library Object Defined on MCO supertype
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 Defined on MCO supertype	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 Defined on MCO supertype	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 Defined on MCO supertype
REQ_VIEW_WIDTH	NUMBER(6, 0)	Y	Required view width. In units specified in the template form. Prompt: View Width Defined on MCO supertype
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 Defined on MCO supertype
SELECT_FLAG	VARCHAR2(1)	N	Indicates whether this module component will allow the user to select rows from its base table Prompt: Query ? Uppercase Defined on MCO supertype	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 Defined on MCO supertype	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 Defined on MCO supertype	User/Help Text
NOTES	CDINOT Defined on MUN supertype	Notes

Other Properties
REUSABLE_MCO 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: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference REUSABLE_MCO:

Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each ITEM_GROUP must be within one and only one MODULE_COMPONENT (in arc)
Each ITEM must be within one and only one MODULE_UNIT (in arc)
Each MODULE_COMPONENT_INCLUSION must be the usage of one and only one MODULE_COMPONENT (in arc)
Each MODULE_DETAIL_TABLE_USAGE must be within one and only one MODULE_UNIT (in arc)
Each PREFERENCE_SET_USAGE must be for one and only one CIELEMENT (in arc)
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each SERVER_OBJECT_USAGE must be for generation of one and only one CIELEMENT (in arc)
Each SQL_QUERY_SET must be in set operation with one and only one MODULE_COMPONENT (in arc)
Each SUBCOMPONENT must be a subcomponent in one and only one MODULE_COMPONENT
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT
Each USER_PREFERENCE must be for one and only one CIELEMENT (in arc)

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype