Managing Ident Attribute Functions - Intergraph Smart Reference Data - Help - Hexagon

Intergraph Smart Reference Data Help (10.2)

Language
English
Product
Intergraph Smart Reference Data
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

The following work process diagram explains how an ident attribute function is defined to display the ident attribute values.

Ident Attribute Functions

Define Ident Attribute Function

  1. Go to Administration > XA90 Ident Attribute Function.

  2. Click Add Add to make the fields editable.

  3. In the Order Seq box, enter a numerical value. This number controls the display sequence of functions and their return values.

    You may also edit numbers of existing functions in order to make the display sequence to suit your requirement.

  4. In the Function Code box, enter the name of the custom function. This name must match exactly with the associated PL/SQL function. Otherwise, the validation of the declaration will fail.

  5. Type Short Description and Description.

  6. Click Savesave. The custom function gets added in the Ident Attribute Functions tree view.

  7. Right-click the ident attribute function you want to validate.

  8. Click Validate.

    If validation is successful, the Valid check box is selected automatically.

  9. Double-click the ident attribute function. The Function Source Code box gets populated with the code.

Create Parameter

Each function must have a 'bound' parameter, which the system understands. It can be either Ident ID (p_ident) or the language identifier (p_nls_id). Apart from using the bound parameters, you may additionally specify one unbound parameter, which defines an iteration scheme. When a function is called, the system gets the actual values for the formal parameter from the calling environment.

  1. In the Ident Attribute Function Parameters section, enter a numerical value in the Order Seq cell.

  2. In the Parameter cell, double-click to see a list of parameters.

  3. Select a parameter and set the data type, iteration type, low and high value.

    • For bound parameters, it must be set to NONE; for iteration parameters it must be either SET or RANGE.

    • In case of Iteration Type RANGE, enter a lower bound and higher bound value in Low Value and High Value respectively.

    • In case of Iteration Type SET, enter the order sequence for the value and one value of the iteration set.

  4. Click Save gridsave.

Validate Ident Attribute Functions

  1. In the Ident Attribute Functions section, right-click the ident attribute you want to validate.

  2. Click Validate.

    If validation is successful, the Valid check box is selected automatically. You may now choose to select the Include check box in the Ident Attribute Function Definition to display this function in the SRD > XS10 Component Manager > XS1010 Commodity/ Ident Management screen.

Display Ident Attribute Values

  1. Go to SRD > XS10 Component Manager > XS1010 Commodity/ Ident Management.

  2. In Data: Explorer list, select All Commodity Groups/Commodity Group/Part/Commodity Code/Ident.

  3. Expand a commodity group node to view the ident list.

  4. Right-click an ident and click Execute Ident Attribute Function. The functions along with their attribute values are displayed.