Writing a Procedure to Change the Dictionary Display

By default, the Dictionary Term field in the Classify VT Omissions and Reclassify Verbatim Terms windows displays the dictionary term to which the selected verbatim term is mapped. In some cases, however, you may require different information about a verbatim term's mapping within a particular dictionary to make a decision about classification—instead of the classification level term, you might want to see its parent term or another term in the hierarchy.

By defining a Dictionary Term Display Procedure for a TMS dictionary, you can dictate the level of dictionary term shown in the derivation path for a dictionary. You specify which procedure to use in the Base Dictionary tab window in the Define Dictionaries window.

If you leave the Dictionary Term Display Procedure field blank when defining the dictionary, TMS exhibits the default behavior: displaying the classification level term to which the selected verbatim term is mapped.

For more information, see:

• Writing a Dictionary Term Display Procedure
  

Writing a Dictionary Term Display Procedure

Any Dictionary Term Display Procedure must be written with the input and output parameters shown below. Oracle recommends that you create the procedure from the TMS role.

PROCEDURE procedure_name (
   pDictContentId IN NUMBER
   , pDefLevelId IN NUMBER
   , pTermType IN VARCHAR2
   , pCutOffDate IN DATE
   , pReturnLevel IN OUT VARCHAR2
   , pReturnTerm IN OUT VARCHAR2

After you write a procedure, grant the proper execute privilege to the tms_classify_priv role by issuing the following statement from TMS (or the role you used to write the procedure):

grant execute on procedure_name to tms_classify_priv