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.
Parent topic: Create and Modify Business Area Hierarchies