458: l_item_number MTL_SYSTEM_ITEMS_INTERFACE.ITEM_NUMBER%TYPE;
459: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
460: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;
461: l_concat_value VARCHAR2(32000);
462: l_user_id NUMBER := FND_GLOBAL.USER_ID;
463: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
464: l_delimeter EGO_DEFAULT_OPTIONS.OPTION_VALUE%TYPE;
465: l_attr_missing BOOLEAN;
466: l_attr_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
459: l_category_id MTL_SYSTEM_ITEMS_INTERFACE.ITEM_CATALOG_GROUP_ID%TYPE;
460: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;
461: l_concat_value VARCHAR2(32000);
462: l_user_id NUMBER := FND_GLOBAL.USER_ID;
463: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
464: l_delimeter EGO_DEFAULT_OPTIONS.OPTION_VALUE%TYPE;
465: l_attr_missing BOOLEAN;
466: l_attr_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
467: l_old_attr_id NUMBER;
565: x_err_text OUT NOCOPY VARCHAR2)
566: RETURN INTEGER
567: IS
568:
569: l_user_id NUMBER := FND_GLOBAL.USER_ID;
570: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
571: l_sysdate DATE := sysdate;
572:
573: BEGIN
566: RETURN INTEGER
567: IS
568:
569: l_user_id NUMBER := FND_GLOBAL.USER_ID;
570: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
571: l_sysdate DATE := sysdate;
572:
573: BEGIN
574: INSERT INTO ego_style_variant_attr_vs