Insert a Classification Value

Use this API to insert values, or terms, into a classification hierarchy level, related to a term in the next higher level. The function returns 0 if the transaction failed and 1 if it succeeded.

Name

CDR_PUB_CLA_HIERARCHY_VALS.InsertValues

Signature

FUNCTION INSERTVALUES( 
  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, 
  PPARENTCONTENTID  IN    TMS.TMS_DICT_CONTENTS.DICT_CONTENT_ID%TYPE, 
  PLEVELID  IN    TMS.TMS_DEF_LEVELS.DEF_LEVEL_ID%TYPE, 
  PVALUES  IN OUT    CDR_HIER_VAL_COLL 
) RETURN PLS_INTEGER; 

Return

Type PLS_INTEGER

• 0 is returned if the transaction fails.
• 1 is returned if the transaction succeeds.

Parameters

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

• PPARENTCONTENTID Enter the ID of a term that serves as a parent to the terms you are inserting.
• PLEVELID Enter the ID of the classification hierarchy level into which you want to insert the terms.
• PVALUES (Mandatory) This is a collection of CDR_HIER_VAL_TYPEs. For each classification value (term) that you want to add as a child to the term you specified, initialize a CDR_HIER_VAL_TYPE and then extend the collection.

  The following attributes are required: CONTENT_ID,TERM,ERROR_MSG,APPROVED_FLAG.