Get a New Position Number

Use this API to get a unique position number for a Planned Output within a parent object. This API is used from within the CREATEPLANNEDOUTPUT API, which is used to create a new Planned Output. You can also reorder Planned Outputs using this API.

Name

CDR_PUB_DF_PLANNED_OUTPUT.GetNewPositionNumber

Signature

FUNCTION GETNEWPOSITIONNUMBER( 
  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, 
  PI_NCOMPANYID  IN    CDR_NAMINGS.COMPANY_ID%TYPE, 
  PI_NOBJID  IN    CDR_NAMINGS.OBJ_ID%TYPE, 
  PI_NOBJVER  IN    CDR_NAMING_VERSIONS.OBJ_VER%TYPE 
) RETURN NUMBER; 

Parameters

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

• PI_NCOMPANYID (Mandatory) Enter the COMPANY_ID of the parent object.
• PI_NOBJID (Mandatory) Enter the OBJ_ID of the parent object.
• PI_NOBJVER (Mandatory) Enter the OBJ_VER of the parent object.