Create a Join
Use this API to create a Business Area Join.
Name
CDR_PUB_DF_BUSINESSAREA_JOIN.CreateBusinessAreaJoin
Signature
PROCEDURE CREATEBUSINESSAREAJOIN( 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_SOURCECDRNAMING IN OUT CDR_NAMING_VERSION_OBJ_TYPE, PI_BUSAREAJOINSOBJTYPE IN CDR_BUSAREA_JOINS_OBJ_TYPE );
Parameters
This API has standard parameters (see Standard Parameters) and the following parameters:
- PIO_SOURCECDRNAMING (Mandatory) This is a parameter of table type
CDR_NAMING_VERSION_OBJ_TYPE. Enter values for the Join that you want to create. Use the
NAMESPACE attributes to identify the Business Area in which you want to create the Join.
The following attributes are required: OBJECT_TYPE_RC,NAME,NAMESPACE_OBJ_ID,NAMESPACE_OBJ_VER,OBJECT_SUBTYPE_ID. For OBJECT_TYPE_RC enter $OBJTYPES$JOIN.
- PI_BUSAREAJOINSOBJTYPE (Mandatory) This is a parameter of table type
CDR_BUSAREA_JOINS_OBJ_TYPE specific to Joins. Enter values for the Join that you want to
create.
The following attributes are required: TD_COMPANY_ID,TD_OBJ_ID,FK_TD_COMPANY_ID,FK_TD_OBJ_ID,TD_OUTERJOIN_RC,FK_TD_OUTERJOIN_RC.
For TD_OUTERJOIN_RC and FK_TD_OUTERJOIN_RC, enter $YESNO$NO to define an inner join on the side of the corresponding Table Descriptor, or $YESNO$YES to define an outer join. Be sure to define an outer join on only one side, if any.
Parent topic: Create and Modify Business Area Joins