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.