Remove a Hierarchy Column

Use this API to remove Business Area Hierarchy Columns.

Note:

You cannot remove a Column that is currently part of a Join. If you remove a Column, and if the next Column's Group By Previous setting is Yes, then that setting is changed to No.

Name

CDR_PUB_DF_BUSINESSAREA_HIER.RemoveHierColumns

Signature

PROCEDURE REMOVEHIERCOLUMNS( 
  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_BUS_HIERCOLUMNS_COLL  IN OUT    CDR_BUSAREA_HIER_COLS_COLL 
); 

Parameters

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

PIO_BUS_HIERCOLUMNS_COLL (Mandatory) This is a collection of CDR_BUSAREA_HIER_COLS_OBJ_TYPEs. For each Column that you want to remove, initialize a CDR_BUSAREA_HIER_COLS_OBJ_TYPE and then extend the collection.

The following attributes are required: COMPANY_ID,HIER_OBJ_ID,HIER_OBJ_VER,TD_COMPANY_ID,TD_OBJ_ID,TD_COL_COMPANY_ID,TD_COL_OBJ_ID,POSITION,GROUP_WITH_PREVIOUS_RC.