Get Categories for Model

Use this API to get all categories that are valid for a model type and subtype.

Name

DME_PUB_MODEL_FLAGCAT.GetCategoriesForModel

Signature

PROCEDURE GETCATEGORIESFORMODEL,  
P_API_VERSION IN VARCHAR2,   
P_INIT_MSG_LIST IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE,
P_COMMIT IN VARCHAR2 DEFAULT CDR_PUB_DEF_CONSTANTS.G_FALSE,
P_VALIDATION_LEVEL IN NUMBER DEFAULT CDR_PUB_DEF_CONSTANTS.G_VALID_LEVEL_FULL,
X_RETURN_STATUS OUT NOCOPY VARCHAR2,
X_MSG_COUNT OUT NOCOPY NUMBER,
X_MSG_DATA OUT NOCOPY VARCHAR2,
PI_COMPANY_ID IN NUMBER,
PI_MODEL_TYPE_RC IN VARCHAR2,
PI_MODEL_SUBTYPE_RC IN VARCHAR2,
PO_CATEGORIES OUT NOCOPY DME_NUMBER_COLL,
);

Parameters

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

• PI_COMPANY_ID (Mandatory). Enter the company ID.
• PI_MODEL_TYPE_RC (Mandatory). Enter a model type such as $MODELTYPE$INPUT, from the lookup CDR_MODELTYPES.
• PI_MODEL_SUBTYPE_RC (Mandatory). Enter a model subtype; for example, $INPUTMODTYPE$FILE.
• PO_CATEGORIES Output parameter returns an array of category IDs.