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.
Parent topic: Classify Subtypes