APPS.EGO_STYLE_SKU_ITEM_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 456: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;

452: )
453: ORDER BY ATTR_EXT.ATTR_ID;
454:
455: l_sku_item_id MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE;
456: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
457: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
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;

Line 460: l_batch_id MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE;

456: l_style_item_id MTL_SYSTEM_ITEMS_INTERFACE.STYLE_ITEM_ID%TYPE;
457: l_org_id MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE;
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;

Line 764: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,

760: p_organization_id,
761: p_item_number,
762: p_style_item_flag,
763: p_style_item_id,
764: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,
765: EGO_IMPORT_PVT.G_PDH_SOURCE_SYSTEM_ID,
766: 'FK'
767: );
768: