Get Child Terms

Use this API to retrieve some or all of the terms on a particular level that are children of a particular parent term. The function returns a collection of CDR_HIER_LEVEL_VAL_OBJ_TYPEs.

Name

CDR_PUB_CLA_SUBTYPES.GetClaHierValues

Signature

FUNCTION GETCLAHIERVALUES( 
  P_API_VERSION  IN    NUMBER, 
  P_INIT_MSG_LIST  IN    VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, 
  P_COMMIT  IN    VARCHAR2 := CDR_PUB_DEF_CONSTANTS.G_FALSE, 
  P_VALIDATION_LEVEL  IN    NUMBER := CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL, 
  PLEVELIDS  IN    CDR_OPA_ID_COLL, 
  PTERMS  IN    CDR_OPA_STRING_COLL, 
  PDOMAINID  IN    PLS_INTEGER, 
  PCLALEVELID  IN    CDR_SUBTYPE_CLA_LEVELS.CLA_LEVEL_ID%TYPE 
) RETURN CDR_HIER_LEVEL_VALUES_COLL; 

Return

Type CDR_HIER_LEVEL_VALUES_COLL

Description Classification hierarchy values

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• PLEVELIDS (Mandatory) This is a collection of CDR_OPA_ID_OBJ_TYPEs. For each hierarchy level from the top level to the level from which you want to retrieve terms (but not lower), initialize a CDR_OPA_ID_OBJ_TYPE and then extend the collection.

  The following attribute is required: CDR_OPA_ID.

• PTERMS (Mandatory) This is a collection of CDR_OPA_STRING_OBJ_TYPEs. For each hierarchy level from the top level to the one from which you want to retrieve terms (but not lower), initialize a CDR_OPA_ID_OBJ_TYPE and then extend the collection. For the required attribute, CDR_OPA_STRING, enter the term whose related terms you want to retrieve, in order starting with the top level.
• PDOMAINID Enter the ID of the LSH Instance Domain. Use the following query to get this ID: select * from TMS.TMS_DEF_DOMAINS where name = 'CDR_USER_HIER'
• PCLALEVELID Enter the ID of the classification hierarchy level that contains the terms you are searching for.