Modify a Join and a Join Column
Use this API to modify Business Area Joins and Join Columns. You can change the name and description of the Join and change either side to an inner or outer join (but be careful not to make both sides into outer joins). You can add Join Columns and pair them with a different Column from the other Table Descriptor.
Note:
Do not change the operator. EQUAL TO is the only operator currently supported.Name
CDR_PUB_DF_BUSINESSAREA_JOIN.ModifyBusAreaJoinAndJoinCol
Signature
PROCEDURE MODIFYBUSAREAJOINANDJOINCOL( 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_BUSINESS_JOIN IN OUT CDR_BUSAREA_JOINS_OBJ_TYPE, PI_BUS_JOINCOLUMNS_COLL IN OUT CDR_BUSAREA_JOIN_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 Join that you want to modify and
for the attributes you want to change.
The following attributes are required: COMPANY_ID,OBJ_ID,OBJ_VER,OBJECT_VERSION_NUMBER,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER.
- PI_BUSINESS_JOIN (Mandatory) This is a parameter of table type CDR_BUSAREA_JOINS_OBJ_TYPE specific to Joins. Enter values to identify the Join that you want to modify and the values you want to modify. All attributes are required.
- PI_BUS_JOINCOLUMNS_COLL (Mandatory) This is a collection of
CDR_BUSAREA_JOIN_COLS_TYPEs. For each Join Column that you want to modify, initialize a
CDR_BUSAREA_JOIN_COLS_TYPE and then extend the collection.
The following attributes are required: COMPANY_ID,JOIN_OBJ_ID,JOIN_OBJ_VER,TD_COL_COMPANY_ID,TD_COL_OBJ_ID,FK_TD_COL_COMPANY_ID,FK_TD_COL_OBJ_ID,POSITION. You can change the joined columns but you cannot modify the operator, which is always Equal To.
Parent topic: Create and Modify Business Area Joins