Modify a Hierarchy and a Hierarchy Column

Use this API to modify Business Area hierarchies and hierarchy columns. You can change name and description, add columns, and change their Group With Previous setting. Use the remove columns API to remove columns.

Name

CDR_PUB_DF_BUSINESSAREA_HIER.ModifyBusAreaHierAndHierCol

Signature

PROCEDURE MODIFYBUSAREAHIERANDHIERCOL( 
  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, 
  X_RETURN_STATUS  OUT    VARCHAR2, 
  X_MSG_COUNT  OUT    NUMBER, 
  X_MSG_DATA  OUT    VARCHAR2, 
  PIO_NAMING  IN OUT    CDR_NAMING_VERSION_OBJ_TYPE, 
  PI_BUS_HIERCOLUMNS_COLL  IN OUT    CDR_BUSAREA_HIER_COLS_COLL 
); 

Parameters

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

• PIO_NAMING (Mandatory) This is a parameter of table type CDR_NAMING_VERSION_OBJ_TYPE.

  Enter values to identify the Business Area Hierarchy that you want to modify and enter new values for the attributes you want to modify. You can modify only the Name and Description. All attributes are required.

• PI_BUS_HIERCOLUMNS_COLL (Mandatory) This is a collection of CDR_BUSAREA_HIER_COLS_OBJ_TYPE.

  Initialize a CDR_BUSAREA_HIER_COLS_OBJ_TYPE for each Column in their position order with the values you want to change, and then extend the collection. All attributes are required.