Reorder a Hierarchy Column
Use this API to reorder the Columns of a Business Area Hierarchy.
Note:
The API enforces validation rules for Column sequence.Name
CDR_PUB_DF_BUSINESSAREA_HIER.ReorderHierCols
Signature
PROCEDURE REORDERHIERCOLS( 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 parameters:
PIO_BUS_HIERCOLUMNS_COLL (Mandatory) This is a collection of CDR_BUSAREA_HIER_COLS_OBJ_TYPEs. For each Column, initialize a CDR_BUSAREA_HIER_COLS_OBJ_TYPE, providing the new value for POSITION NUMBER relative to the other Columns, and then extend the collection. You must initialize all existing Columns.
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.
Parent topic: Create and Modify Business Area Hierarchies