INV Item Category API

Following APIs can be used to Create/Update/Delete Category Combinations

INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY

(P_API_VERSION IN NUMBER,

P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

X_RETURN_STATUS OUT VARCHAR2,

X_ERRORCODE OUT NUMBER,

X_MSG_COUNT OUT NUMBER,

X_MSG_DATA OUT VARCHAR2,

P_CATEGORY_REC IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE, X_CATEGORY_ID OUT NUMBER)

INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY

(P_API_VERSION IN NUMBER,

P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

X_RETURN_STATUS OUT VARCHAR2,

X_ERRORCODE OUT NUMBER,

X_MSG_COUNT OUT NUMBER,

X_MSG_DATA OUT VARCHAR2,

P_CATEGORY_REC IN INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE)

INV_ITEM_CATEGORY_PUB.DELETE_CATEGORY

(P_API_VERSION IN NUMBER,

P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

X_RETURN_STATUS OUT VARCHAR2,

X_ERRORCODE OUT NUMBER,

X_MSG_COUNT OUT NUMBER,

X_MSG_DATA OUT VARCHAR2,

P_CATEGORY_ID IN NUMBER)

Following API is used for assigning a Category to a Category Set. A Category will be available in the list of valid categories for a category set only if it

is assigned to the category set. This is a required step for categories if enforce list is checked on

INV_ITEM_CATEGORY_PUB.CREATE_VALID_CATEGORY

(P_API_VERSION IN NUMBER,

P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

P_CATEGORY_SET_ID IN NUMBER,

P_CATEGORY_ID IN NUMBER,

P_PARENT_CATEGORY_ID IN NUMBER,

X_RETURN_STATUS OUT VARCHAR2,

X_ERRORCODE OUT NUMBER,

X_MSG_COUNT OUT NUMBER,

X_MSG_DATA OUT VARCHAR2)

Following APIs can be used to Create/Update/Delete Item Category Assignments

INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY_ASSIGNMENT

(P_API_VERSION IN NUMBER,

P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

X_RETURN_STATUS OUT VARCHAR2,

X_ERRORCODE OUT NUMBER,

X_MSG_COUNT OUT NUMBER,

X_MSG_DATA OUT VARCHAR2,

P_CATEGORY_ID IN NUMBER,

P_CATEGORY_SET_ID IN NUMBER,

P_INVENTORY_ITEM_ID IN NUMBER,

P_ORGANIZATION_ID IN NUMBER)

INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY_DESCRIPTION

(P_API_VERSION IN NUMBER,

P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

X_RETURN_STATUS OUT VARCHAR2,

X_ERRORCODE OUT NUMBER,

X_MSG_COUNT OUT NUMBER,

X_MSG_DATA OUT VARCHAR2,

P_CATEGORY_ID IN NUMBER,

P_DESCRIPTION IN VARCHAR2)

INV_ITEM_CATEGORY_PUB.DELETE_CATEGORY_ASSIGNMENT

(P_API_VERSION IN NUMBER,

P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

X_RETURN_STATUS OUT VARCHAR2,

X_ERRORCODE OUT NUMBER,

X_MSG_COUNT OUT NUMBER,

X_MSG_DATA OUT VARCHAR2,

P_CATEGORY_ID IN NUMBER,

P_CATEGORY_SET_ID IN NUMBER,

P_INVENTORY_ITEM_ID IN NUMBER,

P_ORGANIZATION_ID IN NUMBER)

/