/* Formatted on 2014-9-26 16:48:42 (QP5 v5.115.810.9015) */
DECLARE
L_IFACE_REC MTL_ITEM_CATEGORIES_INTERFACE%ROWTYPE;
L_CUR_MFG_ORG_ID NUMBER := 107; --Current Inv Organization--物料类别只需更新主组织,其他组织会自动同步
L_USER_ID NUMBER := FND_GLOBAL.USER_ID; --User ID, Sysadmin here
L_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
L_COUNT NUMBER;
L_REQ_ID NUMBER;
BEGIN
L_IFACE_REC.LAST_UPDATED_BY := L_USER_ID;
L_IFACE_REC.LAST_UPDATE_DATE := SYSDATE;
L_IFACE_REC.CREATED_BY := L_USER_ID;
L_IFACE_REC.CREATION_DATE := SYSDATE;
L_IFACE_REC.SET_PROCESS_ID := 10;
L_IFACE_REC.TRANSACTION_TYPE := 'UPDATE';
L_IFACE_REC.PROCESS_FLAG := 1;
L_IFACE_REC.ORGANIZATION_ID := L_CUR_MFG_ORG_ID;
L_IFACE_REC.INVENTORY_ITEM_ID := 14737558 ;
L_IFACE_REC.CATEGORY_SET_ID := 1;
利用interface更新物料类别
最新推荐文章于 2022-09-22 18:53:32 发布