Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | ARGUMENT_ITEM_USAGE |
| Short Name | ARGITE |
| View Name | CI_ARGUMENT_ITEM_USAGES |
| Description | The usage of an ITEM (ie either a DATA_BOUND_ITEM or an UNBOUND_ITEM) |
| within a specific module argument | |
| Sub-type of | INTERSECTION |
| Versioning: | Belongs to: GENERAL_MODULE versionable object ORACLE_OBJECT_TYPE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
MODULE_ARGUMENT_REFERENCE ITEM_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_ARGITE |
| Changes: | Summary of changes to ARGUMENT_ITEM_USAGE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| ITEM_REFERENCE | N |
Prompt: Item
Transferable only if null |
Must be of one and only one ITEM | |
| MODULE_ARGUMENT_REFERENCE | N |
Prompt: Argument
Transferable only if null |
Must be in one and only one MODULE_ARGUMENT | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ARGUMENT_OPERATOR | VARCHAR2(10) | N | The argument operator for the item eg '=', 'LIKE', '>'
Prompt: Operator Uppercase | OPERATOR | = |
| SQL_QUERY_CLAUSE | VARCHAR2(10) | N | Indicates the clause in a SQL query to which the join condition resulting from this argument item usage is to be added
Prompt: SQL Query Clause Uppercase | SQL_CLAUSE | DEFAULT |
| USE_PRIOR_ROW_FLAG | VARCHAR2(1) | N | When binding argument into a CONNECT BY clause, indicates whether PRIOR operator to be appended to column involved (Example: :NO_ORG_CHART_BELOW_JOB != PRIOR JOB. Allows an organization chart down to and including a certain type of job)
Prompt: Use PRIOR when adding to SQL ? Uppercase | YESNO | N |
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Common repository version identifier of owning PAC
Not displayed System maintained Updatable only if null Defined on SE supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs
Not displayed System maintained Not updatable by user Defined on SE supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| Other Properties |
|---|
| ARGUMENT_ITEM_USAGE 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 ARGUMENT_ITEM_USAGE:
Note: