Assign a Planned Output

Use this API to assign a Planned Output to a Report Set Entry (RSE). If the Planned Output is already assigned to a different RSE, you must identify that RSE. This API then unassigns the Planned Output from the original RSE and reassigns it to the RSE you specify.

Name

CDR_PUB_DF_PROGRAM.AssignPIandPOtoRSEntry

Signature

PROCEDURE ASSIGNPIANDPOTORSENTRY( 
  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, 
  PI_RSECOMPANYID  IN    CDR_NAMINGS.COMPANY_ID%TYPE, 
  PI_RSEOBJID  IN    CDR_NAMINGS.OBJ_ID%TYPE, 
  PI_RSEOBJVER  IN    CDR_NAMING_VERSIONS.OBJ_VER%TYPE, 
  PI_PIOBJID  IN    CDR_NAMINGS.OBJ_ID%TYPE, 
  PI_POCOMPANYID  IN    CDR_NAMINGS.COMPANY_ID%TYPE, 
  PI_POOBJID  IN    CDR_NAMINGS.OBJ_ID%TYPE, 
  PI_ASGRSEOBJID  IN    CDR_NAMINGS.OBJ_ID%TYPE, 
  PI_ASGRSEOBJVER  IN    CDR_NAMING_VERSIONS.OBJ_VER%TYPE 
);

Parameters

This API has standard parameters (see Standard Parameters) and the following parameters:

• PI_RSECOMPANYID (Mandatory) Enter the Company ID of the Report Set Entry to which you want to assign the Planned Output. To get your company ID, use CDR_DF_PUB_DEF_CONSTANTS.Current_Company_ID.
• PI_RSEOBJID (Mandatory) Enter the object ID of the Report Set Entry to which you want to assign the Planned Output.
• PI_RSEOBJVER (Mandatory) Enter the object version of the Report Set Entry to which you want to assign the Planned Output.
• PI_PIOBJID (Mandatory) Enter the object ID of the Program instance to which the Planned Output belongs.
• PI_POCOMPANYID (Mandatory) Enter the Company ID of the Planned Output.
• PI_POOBJID (Mandatory) Enter the object ID of the Planned Output.
• PI_ASGRSEOBJID (Optional) If the Planned Output is already assigned to another RSE, enter the object ID of the other Report Set Entry.
• PI_ASGRSEOBJVER (Optional) If the Planned Output is already assigned to another RSE, enter the object version of the other Report Set Entry.